SELECT * FROM property_cache_current pp, propsys_suburb ps, property_open_home do WHERE pp.suburb_id = ps.suburb_id AND do.property_id = pp.property_id AND agency_type_id <> 3 AND do.openhome_date = '2019-02-23' ORDER BY do.openhome_date ASC, ps.suburb LIMIT 0, 10