Venues
With love & understanding, we help our venues to offer the most outstanding experiences.
SELECT * FROM page LEFT JOIN venue ON page.page_parent_id = venue.venue_id WHERE venue_zone_01 = 1 AND page_category = 7
SELECT * FROM page WHERE page_parent_id = 100005 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100018 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100014 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100013 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100017 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100011 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100037 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100038 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100036 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100054 AND page_category = 7 AND live = 1
SELECT * FROM page WHERE page_parent_id = 100056 AND page_category = 7 AND live = 1