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 300, 10
  • Wokyo Noodle Bar

    +971 4 330 5188
    Al Safa 1
    Delivery/Pickup: Both
  • Wokyo Noodle Bar JLT

    +971 4 454 2348
    JLT
    Delivery/Pickup: Both
  • Yoko Sizzlers

    +971 50 647 1721
    Al Karama & Al Nahda
    Delivery/Pickup: Both
  • Zaroob Sheikh Zayed Road

    +971 52 460 0282
    Shop 1 - Sheikh Zayed Rd - Dubai
    Delivery/Pickup: Both
  • ZEROFAT

    +971 600 542524
    Dubai, Abu Dhabi and Al Ain
    Delivery/Pickup: Both