|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pp.price_start, ps.suburb' at line 1 Error performing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY pp.price_start, ps.suburb LIMIT 0, 10' at line 1 SELECT * FROM property_cache_current pp, propsys_suburb ps, propsys_proptype pt WHERE pp.suburb_id = ps.suburb_id AND pp.branch_id = 1 AND pp.property_type_id = pt.proptype_id AND pp.suburb_id = ps.suburb_id ORDER BY pp.price_start, ps.suburb ORDER BY pp.price_start, ps.suburb LIMIT 0, 10 |