0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0080 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-08-14'
AND `url` = 'https://www.maineventtravel.com/tours'
ORDER BY `views` DESC

0.0115 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-08-14'
AND `url` = 'https://www.maineventtravel.com/tours'

0.0004 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0039 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0003 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0004 SECONDS: 
SELECT COUNT(*) AS `numrows` FROM `news_articles`

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `name` ASC

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `my_calendar_tour_stops`
INNER JOIN `tours` ON `my_calendar_tour_stops`.`tour_id` = `tours`.`id`
WHERE `customer_id` = 0

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '78'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '78'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '174'

0.0018 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '174'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '10'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '10'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '105'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '105'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '66'

0.0014 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '66'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '32'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '32'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '166'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '166'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '176'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '176'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '181'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '181'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '137'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '137'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '131'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '131'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '157'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '157'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '86'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '86'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '79'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '79'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '30'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '30'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '152'

0.0013 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '152'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '151'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '151'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '18'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '18'
ORDER BY `tour_stops`.`start_date` ASC

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '38'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '38'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '22'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '22'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '149'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '149'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '188'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '188'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '111'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '111'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '191'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '191'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '104'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '104'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '175'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '175'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '110'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '110'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '148'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '148'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '143'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '143'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '74'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '74'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '167'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '167'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '178'

0.0013 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '178'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '141'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '141'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '92'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '92'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '128'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '128'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '180'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '180'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '192'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '192'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '172'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '172'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '173'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '173'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '184'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '184'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '100'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '100'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '185'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '185'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '146'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '146'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '153'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '153'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '19'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '19'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '83'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '83'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '24'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '24'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '194'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '194'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '187'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '187'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '11'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '11'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '138'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '138'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '44'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '44'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '25'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '25'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '35'

0.0012 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '35'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '103'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '103'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '48'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '48'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '159'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '159'
ORDER BY `tour_stops`.`start_date` ASC

0.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '99'

0.0011 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '99'
ORDER BY `tour_stops`.`start_date` ASC

0.0067 SECONDS: 
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name`
FROM `news_articles`
LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id`
WHERE `news_articles`.`active` = '1'
ORDER BY `news_articles`.`date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%tour-page%'

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(1)
  • 888poker UK Poker League(2)
  • APAT(8)
  • APPT(1)
  • Aria Resort & Casino(0)
  • Asian Poker Tour(2)
  • Battle Of Malta(1)
  • Borgata Poker(0)
  • Bratislava Poker Festival(1)
  • British Poker Series(4)
  • BSOP(2)
  • Dublin Poker Festival(1)
  • Dusk Till Dawn(7)
  • EAPT(1)
  • EPT(3)
  • Genting Casino Stratford(7)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(29)
  • Grosvenor UK Poker Open(0)
  • GUKPT Grosvenor(4)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • King's Resort(0)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(0)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(9)
  • North American Poker Tour(1)
  • OlyBet Showdown Vilnius (0)
  • Orleans Summer Open(0)
  • PartyPoker Tour(2)
  • Poker GO Tour(0)
  • Poker Skills Events(1)
  • PokerStars Open(2)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(1)
  • The Festival(2)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(2)
  • Unibet DeepStack Open(5)
  • Venetian Deepstack Extravaganza(1)
  • Winamax SISMIX(0)
  • Women's Summer Festival(1)
  • WPT(4)
  • WPT Prime(3)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP Europe(1)
  • WSOP International Circuit(10)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • Goliath 2025 - Texas Throw 'Em

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

1. Home
2. Events

Live Poker Tours & Festivals

Hide tours with no events

Next event date Alphabetical

---

Showing tours from my calendar

Loading Tours

Venetian Deepstack Extravaganza

Next Event: Friday 1st August 2025 The series that started it all back in 2007. DeepStack Extravaganza became a reality... View Events

Add

British Poker Series

Next Event: Wednesday 6th August 2025 BPS has just confirmed an amazing eight events at Aspers Stratford City, London's big... View Events

Add

WSOP Circuit Events

Next Event: Thursday 7th August 2025 The World Series of Poker (WSOP) Circuit Events are a series of poker tournaments hos... View Events

Add

Mid States Poker Tour

Next Event: Tuesday 12th August 2025 From the deepstack structures to the affordable buy-ins and popular gaming destinatio... View Events

Add

PartyPoker Tour

Next Event: Tuesday 12th August 2025 Live events are back in 2025 From screen to scene, PartyPoker is giving our player... View Events

Add

Women's Summer Festival

Next Event: Tuesday 12th August 2025 View Events

Add

WPT

Next Event: Wednesday 13th August 2025 The marquee international tournaments where winners enter the illustrious Champions C... View Events

Add

GUKPT Grosvenor

Next Event: Thursday 14th August 2025 GUKPT is one of the UK's leading Poker events, with recreational and professional pla... View Events

Add

WPT Prime

Next Event: Thursday 14th August 2025 The evolution of the World Poker Tour® continues with the launch of WPT®... View Events

Add

Irish Poker Tour

Next Event: Saturday 16th August 2025 At the Irish Poker Tour they pride themselves on timely, well-organized, relaxed, and... View Events

Add

EPT

Next Event: Monday 18th August 2025 The European Poker Tour (EPT) is returning to some of poker's most glamorous location... View Events

Add

WSOP International Circuit

Next Event: Monday 18th August 2025 The World Series of Poker (WSOP) announced the return of its WSOP Circuit (WSOP... View Events

Add

Unibet DeepStack Open

Next Event: Tuesday 19th August 2025 A €550 buy-in which allows passionate players to take part in an international p... View Events

Add

APAT

Next Event: Wednesday 20th August 2025 The Amateur Poker Association & Tour (APAT) was founded on August 1st, 2006, maki... View Events

Add

Queens of Tallinn

Next Event: Thursday 21st August 2025 Welcome to the First Ever Ladies Only Poker Festival Premiere in Europe! ... View Events

Add

Poker Skills Events

Next Event: Monday 25th August 2025 View Events

Add

Grosvenor Poker 25/50

Next Event: Wednesday 27th August 2025 The 25/50 series offers a well-structured TWO-DAY tournament with a huge £50,00... View Events

Add

UK Poker Championships

Next Event: Friday 29th August 2025 Held at the heart of UK poker, Dusk Till Dawn in Nottingham, the UKPC schedule promis... View Events

Add

Triton Super High Roller Series

Next Event: Wednesday 3rd September 2025 The Triton Poker Super High Roller Series is a series of streamed... View Events

Add

888poker LIVE

Next Event: Thursday 4th September 2025 888poker LIVE series is back for 2025!  It’s promising to be a whirlwind ... View Events

Add

The Festival

Next Event: Monday 15th September 2025 The Festival Series combines the best of poker, casino and sports betting - all ... View Events

Add

WSOP Europe

Next Event: Wednesday 17th September 2025 The World Series of Poker Europe is back in the Czech Republic, in King's Casino, Roz... View Events

Add

The Caribbean Poker Series

Next Event: Thursday 18th September 2025 The Caribbean Poker Series in Aruba is an annual poker tournament that brings togethe... View Events

Add

Asian Poker Tour

Next Event: Friday 26th September 2025 The Asian Poker Tour (APT) was founded in 2008. Since its first tournament held in Ma... View Events

Add

888poker UK Poker League

Next Event: Tuesday 30th September 2025 UKPL by 888poker is an exclusive new poker league that’s set to take the UK by ... View Events

Add

EAPT

Next Event: Tuesday 30th September 2025 The EAPT has been hosting poker tournaments since 2013, which means 10 years of exper... View Events

Add

BSOP

Next Event: Wednesday 1st October 2025 The Brazilian Series of Poker (BSOP) is a tour organized by PokerStars. The... View Events

Add

Bratislava Poker Festival

Next Event: Monday 6th October 2025 After the unequivocal triumph of the inaugural Bratislava Poker Festival at the Card ... View Events

Add

APPT

Next Event: Thursday 16th October 2025 Become The Next Asia Pacific Poker Tour Winner! Whether you were a... View Events

Add

PokerStars Open

Next Event: Monday 20th October 2025 A new era of live poker in Europe begins in 2025 with the launch of the PokerStars Op... View Events

Add

Malta Poker Festival

Next Event: Monday 27th October 2025 After another huge success at the Malta Poker Festival Autumn 2024, the Global Poker ... View Events

Add

Battle Of Malta

Next Event: Tuesday 28th October 2025 The Battle of Malta has gone from strength to strength since its launch in 2012 and i... View Events

Add

North American Poker Tour

Next Event: Monday 3rd November 2025 The PokerStars North American Poker Tour (NAPT) is returning to Las Vegas follow... View Events

Add

London Poker Festival

Next Event: Tuesday 4th November 2025 The London Poker Festival is brought to you by the internationally acclaimed team beh... View Events

Add

Kings of Vilnius

Next Event: Friday 14th November 2025 Kings of Vilnius poker festival makes its historic debut in Lithuania’s capital... View Events

Add

WSOP

Next Event: Thursday 4th December 2025 The World Series of Poker® is the largest, longest, and most prestigious gaming e... View Events

Add

Dublin Poker Festival

Next Event: Wednesday 18th February 2026 Dublin Poker Festival was created in 2012 to merge ACOP (Amateur Championship Of... View Events

Add

Irish Poker Open

Next Event: Thursday 26th March 2026 The Irish Open is known as the longest-running No Limit Texas hold 'em poker tourname... View Events

Add

Grosvenor Goliath

Next Event: Thursday 23rd July 2026 Grosvenor Goliath is the largest live poker tournament held outside of Las Vegas.&nbs... View Events

Add

Borgata Poker

No Scheduled Events The East Coast's premier Poker Room is waiting for you! Welcome ... View Events

Add

Golden Nugget Grand Poker Series

No Scheduled Events The Golden Nugget is one of the most famous poker rooms in Las Vegas. “The Nugg... View Events

Add

Grosvenor UK Poker Open

No Scheduled Events Grosvenor Poker have announced that the UK Open is set to take place from 20th Februa... View Events

Add

IPO

No Scheduled Events The IPO is one of Europe’s longest-running and favourite poker tournaments. ... View Events

Add

King's Resort

No Scheduled Events King's Resort is a casino and resort located in Rozvadov, Czech Republic. The casino ... View Events

Add

Kings of Tallinn

No Scheduled Events Kings of Tallinn, the largest Nordic poker festival. Held annually in Tallinn, Eston... View Events

Add

LAPT

No Scheduled Events Be Part Of The Latin American Poker Tour Again! It's time for the ... View Events

Add

Mediterranean Poker Party

No Scheduled Events Pack your bags for the poker holiday of the summer! The organisers of the Caribbean ... View Events

Add

MGM Grand Poker

No Scheduled Events Known as the $1-$2 No Limit Capital of Las Vegas, the MGM Grand Poker Room is the Str... View Events

Add

OlyBet Showdown Vilnius

No Scheduled Events Olympic Casinos are much more than casino games or slot machines: with their unique i... View Events

Add

Orleans Summer Open

No Scheduled Events The Summer Open at the Orleans Hotel & Casino brings a host of buy-ins, variants ... View Events

Add

Poker GO Tour

No Scheduled Events Featuring only poker tournaments with buy-ins of $10,000 or greater, the PokerGO Tour... View Events

Add

Pure Poker Tour

No Scheduled Events The Pure Poker Tour is back for another season with a $15k Player of the Year battle ... View Events

Add

Resorts World Las Vegas

No Scheduled Events When Resorts World Las Vegas opened in 2021, it marked the first new resort on the le... View Events

Add

Sky Poker Tour

No Scheduled Events Sky Poker Tour returns for 2025!   View Events

Add

Winamax SISMIX

No Scheduled Events The festival mixing party and poker returns from 28th May to 2nd June 2024 in the sum... View Events

Add

WPT Special Events

No Scheduled Events From Bad Boys of Poker to WPT Foundation Ladies’ Night to the WPT Monster Invit... View Events

Add

WSOP Super Circuit Events

No Scheduled Events The World Series of Poker (WSOP) Circuit Events are a series of poker tournaments. W... View Events

Add

Wynn Poker

No Scheduled Events The Wynn hosts tournaments in the magnificent new Poker Room located between the Wynn... View Events

Add

Latest News & Blogs

Sun, Cards & Travel: Get Ready for the Malta Poker Festival 2025

The Malta Poker Festival returns from 27 October to 3 November 2025, offering a full week of exciting tournaments in the stunning setting of St. Julian’s. Players can conveniently book their flights and hotel accommodation through Main Event Travel, making it easy to plan the perfect poker getaway.

EPT Barcelona 2025: Poker’s Summer Highlight Returns This Month!

Get ready for EPT Barcelona 2025! Taking place this month from 18th August to 31st August at Casino Barcelona, this year's festival promises huge turnouts and top-tier poker action. Check out the best hotel options near the venue and book now before rooms sell out!

GUKPT Luton Returns This August – Secure Your Accommodation Now

GUKPT Luton returns this August with an action-packed schedule at Grosvenor Casino Luton, headlined by the £1,100 + £150 Main Event. For convenient and comfortable accommodation close to the action, players can book their stay through MainEventTravel.com, the Official Travel Partner of GUKPT.

Main Event Travel Brings the Heat to Goliath with Texas Throw ’Em Giveaway!

Main Event Travel is gearing up for another incredible appearance at Goliath, taking place at Grosvenor Casino in Coventry. From 31st July to 3rd August, we’ll be on-site with our signature stand — and this year, we’re bringing something new and exciting to the table: Texas Throw ’Em, a high-energy darts-based poker game with great prizes on the line.

High Stakes and Summer Vibes: Irish Poker Tour Hits Dublin

The Irish Poker Tour returns to Dublin from July 23rd to 27th, bringing top-tier poker action, diverse tournaments, and a vibrant atmosphere to the city. With MainEventTravel simplifying trip bookings, players can focus on the game while enjoying everything Dublin has to offer this summer.

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter