SELECT SQL_CALC_FOUND_ROWS p.ID FROM `bbc20may18_posts` p LEFT JOIN `bbc20may18_restaurant_listing` r ON (r.post_id = p.ID) LEFT JOIN `bbc20may18_term_relationships` tr ON (p.ID = tr.object_id) WHERE 1=1 AND (tr.term_taxonomy_id IN (11059)) AND p.post_type = 'post' AND (p.post_status = 'publish') GROUP BY p.ID ORDER BY p.post_title ASC LIMIT 0, 10
1762
+971 800 1762
DIFC, JLT DIFC, Nakheel Mall, Media City, Downtown Jebel Ali, Abu Dhabi.