SELECT * FROM property_cache_current pp, propsys_suburb ps, property_auction pa WHERE pp.suburb_id = ps.suburb_id AND pa.property_id = pp.property_id AND agency_type_id <> 3 AND ((pp.sale_method_id = 2) AND pa.auction_date >= '2008-11-23') ORDER BY pa.auction_date ASC, ps.suburb LIMIT 0, 10