#0 DBWrapper->q(SELECT *, concat('http://www.liveherechicago.com/listing-', properties.id, '.php') AS property_full_url, concat('http://www.liveherechicago.com/m/listing-', properties.id, '.php') AS mobile_property_full_url, (@i := @i+1) AS row_number, (SELECT photos.photo_url FROM rhc_property_photos AS photos WHERE photos.id_property = properties.id ORDER BY rand() LIMIT 1) AS main_photo_url FROM rhc_properties AS properties '0' ORDER BY properties.source DESC, properties.price ) called at [/home/tango1010/includes/properties.php:244] #1 search_properties(Array ([where_string] => 1 AND ( properties.price >= '1200' OR properties.source = 'YGL' ),[order_by_string] => properties.source DESC, properties.price,[similar_id] => 82537977,[random_main_photo] => Yes)) called at [/home/tango1010/public_html/search.php:188]
SELECT *, concat('http://www.liveherechicago.com/listing-', properties.id, '.php') AS property_full_url, concat('http://www.liveherechicago.com/m/listing-', properties.id, '.php') AS mobile_property_full_url, (@i := @i+1) AS row_number, (SELECT photos.photo_url FROM rhc_property_photos AS photos WHERE photos.id_property = properties.id ORDER BY rand() LIMIT 1) AS main_photo_url FROM rhc_properties AS properties '0' ORDER BY properties.source DESC, properties.price
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 ''0' ORDER BY properties.source DESC, properties.price' at line 24
Search
773.782.1000

Listing results page

Map View List View

Search