Hotel Apartments for rent in Sheikh Zayed Road
Error! Could not run query:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND C.`location` = 'sheikh zayed road'
AND A.`location` != C.`locat...' at line 8
SELECT IF(LENGTH(A.`location`)>=30, CONCAT(SUBSTR(A.`location`, 1, 30), '...'), A.`location`) AS label,
FROM listings_stats A, locations B, locations C
WHERE A.`location` = B.`location`
AND B.`parent_location_id` = C.`location_id`
AND A.`listing_type_id` = 2
AND A.`category_id` =
AND C.`location` = 'sheikh zayed road'
AND A.`location` != C.`location`
AND A.`emirate_id` = 4 AND A.`bedrooms` = hotel GROUP BY A.`location` ORDER BY A.`total` DESC, label ASC