0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-dev`

0.0190 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-04-26'
AND `url` = 'https://dev.maineventtravel.com/tours'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://dev.maineventtravel.com/tours', 1, '2025-04-26')

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'dev.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.0002 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` = 'dev.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.0002 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` = 'dev.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.0020 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.0002 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` = 'dev.maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

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

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

0.0002 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` = 'dev.maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0003 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.0007 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` = '10'

0.0007 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.0006 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` = '98'

0.0007 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` = '98'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '117'

0.0006 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` = '117'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '52'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0007 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` = '73'

0.0007 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` = '73'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '77'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '112'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0007 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` = '57'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '130'

0.0006 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` = '130'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '119'

0.0006 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` = '119'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '79'

0.0006 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` = '123'

0.0006 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` = '123'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '124'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '36'

0.0006 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` = '36'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '76'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '101'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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.0008 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` = '111'

0.0006 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` = '121'

0.0006 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` = '121'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '125'

0.0007 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` = '125'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0007 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` = '60'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0007 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` = '92'

0.0006 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` = '31'

0.0007 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` = '31'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '93'

0.0006 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` = '93'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '113'

0.0006 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` = '113'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '26'

0.0007 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` = '26'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '69'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '127'

0.0006 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` = '127'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '109'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '103'

0.0006 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` = '11'

0.0007 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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '44'

0.0006 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` = '46'

0.0006 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` = '46'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0007 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` = '45'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '48'

0.0006 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` = '99'

0.0006 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.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '129'

0.0006 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` = '129'
ORDER BY `tour_stops`.`start_date` ASC

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

0.0006 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` = '126'
ORDER BY `tour_stops`.`start_date` ASC

0.0039 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.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` = 'dev.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(0)
  • APAT(0)
  • APPT(0)
  • Aria Fall Series(0)
  • Asian Poker Tour(0)
  • Aspers Casino Stratford(0)
  • Aspers Casino Westfield Stratford City(0)
  • Aussie Millions(0)
  • Battle Of Malta(0)
  • Card Player Poker Tour(0)
  • Cash Game Festival(0)
  • Casino Malta(0)
  • Circuito Nacional De Poker(0)
  • DeepStacks Poker Tour(0)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(0)
  • EPSC European Poker Sport Championship(0)
  • EPT(0)
  • GG Poker(0)
  • Goliath(0)
  • Grand Poker Series(0)
  • Grosvenor Casinos' 25/25(0)
  • Grosvenor G400(0)
  • GUKPT(0)
  • Heartland Poker Tour(0)
  • Hippodrome Casino(0)
  • Hippodrome Casino(0)
  • International Deaf Poker Association(0)
  • IPO(0)
  • Irish Poker Open(0)
  • Kings of Tallinn(0)
  • LPPL(0)
  • Malta Poker Festival(0)
  • Maryland State Poker Championship(0)
  • Master Classics of Poker(0)
  • Mid States Poker Tour(0)
  • partypoker LIVE(0)
  • PHamous Poker Series(0)
  • Poker GO Tour(0)
  • Redtooth Poker Tour(0)
  • Sky Poker Tour(0)
  • Tallinn Summer Showdown(0)
  • Unibet DeepStack Open(0)
  • Unibet Open(0)
  • Unibet UK Poker Tour(0)
  • Venetian Deepstack Extravaganza(0)
  • Venetian DeepStack Showdown Poker Series(0)
  • Winamax Poker Tour(0)
  • World Series of Poker(0)
  • World Series of Poker Europe(0)
  • WPT(0)
  • WPT National(0)
  • WPT500(0)
  • WPTDeepStacks(0)
  • WSOP Circuit Events(0)
  • WSOP International Circuit(0)
  • Wynn Fall Classic(0)
  • Wynn Millions(0)
  • Wynn Signature Series(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Flight FAQs
  • Travel Advice
  • Enquiry Form

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

888poker LIVE

No Scheduled Events Over the past couple of years, one thing has become apparent -- the poker community l... View Events

Add

APAT

No Scheduled Events The Amateur Poker Association & Tour (APAT) was founded on August 1st, 2006, maki... View Events

Add

APPT

No Scheduled Events Become The Next Asia Pacific Poker Tour Winner! Whether you were already an ... View Events

Add

Aria Fall Series

No Scheduled Events Join the action at Aria Poker Room this fall, with a tournament series running from O... View Events

Add

Asian Poker Tour

No Scheduled Events The Asian Poker Tour (APT) was founded in 2008. Since its first tournament held in Ma... View Events

Add

Aspers Casino Stratford

No Scheduled Events The poker room at Aspers Casino is the home of the world's top poker tournaments incl... View Events

Add

Aussie Millions

No Scheduled Events Hosted by Crown Melbourne, one of the world's leading integrated entertainment resort... View Events

Add

Battle Of Malta

No Scheduled Events The  Battle of Malta returns for 2022 and, like those before expects to set a ne... View Events

Add

Card Player Poker Tour

No Scheduled Events The Card Player Poker Tour (CPPT) is a series of live poker tournaments started by Ca... View Events

Add

Cash Game Festival

No Scheduled Events What is Cash Game Festival you might think…. In today’s poker community ... View Events

Add

Circuito Nacional De Poker

No Scheduled Events   THE CNP888 RETURNS IN 2021 NATIONAL CIRCUIT OF POKER PRESSNOVEMBER 9, 2020 ... View Events

Add

DeepStacks Poker Tour

No Scheduled Events The DeepStacks Poker Tour (DSPT) is a domestic and international tournament series fo... View Events

Add

Dublin Poker Festival

No Scheduled Events Dublin Poker Festival was created in 2012 to merge ACOP (Amateur Championship Of... View Events

Add

EPSC European Poker Sport Championship

No Scheduled Events King's Casino has one of Europe's biggest poker rooms. Home to the WSOPE, King's ... View Events

Add

EPT

No Scheduled Events The European Poker Tour (EPT) is returning to some of poker's most glamorous location... View Events

Add

GG Poker

No Scheduled Events View Events

Add

Goliath

No Scheduled Events Goliath 2022 will return as a live event in 2022  including the record-breaking ... View Events

Add

Grand Poker Series

No Scheduled Events Held in the historic Golden Nugget Hotel & Casino in Downtown Las Vegas View Events

Add

Grosvenor Casinos' 25/25

No Scheduled Events   Tournament details £220+£30 buy-in £25,000 Guaranteed p... View Events

Add

Grosvenor G400

No Scheduled Events £400 + £44 buy-in Exciting new event coming from Grosvenor Casinos All ... View Events

Add

GUKPT

No Scheduled Events The Grosvenor UK Poker Tour will return in 2022 Full details about the tour are avai... View Events

Add

Heartland Poker Tour

No Scheduled Events The Heartland Poker Tour, is exactly as described. Taking in stops across the traditi... View Events

Add

Hippodrome Casino

No Scheduled Events PokerStars is the number-one provider of poker in the world and now brings the magic ... View Events

Add

International Deaf Poker Association

No Scheduled Events View Events

Add

IPO

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

Add

Irish Poker Open

No Scheduled Events What do Maradona, Brian O'Driscoll and Patrick Clarke all have in common? A love of t... 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

LPPL

No Scheduled Events The ‘Festival of Poker Players (FOPP)’ is a long weekend (Thu – Sun... View Events

Add

Malta Poker Festival

No Scheduled Events 2022 will have not one, but two MPF’s (spring and its historical autumn dates).... View Events

Add

Maryland State Poker Championship

No Scheduled Events 5th - 17th January 2022 Featuring 23 events with over $900,000 in guaranteed prize p... View Events

Add

Master Classics of Poker

No Scheduled Events The Master Classics of Poker (MCOP) is the name of a collection of poker tournaments ... View Events

Add

Mid States Poker Tour

No Scheduled Events From the deepstack structures to the affordable buy-ins and popular gaming destinatio... View Events

Add

partypoker LIVE

No Scheduled Events partypoker LIVE hosts the biggest tournaments in the most exotic locations around... View Events

Add

PHamous Poker Series

No Scheduled Events Planet Hollywood Las Vegas is where Las Vegas gamblers will find one of the best poke... 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

Redtooth Poker Tour

No Scheduled Events   The 2020/21 Redtooth Poker Tour will see 11 VEGAS100 seats and 2 World League... View Events

Add

Sky Poker Tour

No Scheduled Events Update TBC. View Events

Add

Tallinn Summer Showdown

No Scheduled Events The Summer Showdown is the centrepiece of the Tallinn Poker Festival at the... View Events

Add

Unibet DeepStack Open

No Scheduled Events A €550 buy-in which allows passionate players to take part in an international p... View Events

Add

Unibet Open

No Scheduled Events Play one of the most popular live poker tournament circuit in Europe, with ever-... View Events

Add

Unibet UK Poker Tour

No Scheduled Events *IMPORTANT* See below the following statement: UNIBET CHANGES LIVE POKER EVENTS VENU... View Events

Add

Venetian Deepstack Extravaganza

No Scheduled Events The DeepStack Extravaganza tournament events are one of the most popular Poker tourna... View Events

Add

Venetian DeepStack Showdown Poker Series

No Scheduled Events DeepStack Showdown Poker Series events offer multiple buy-ins ranging on average fr... View Events

Add

Winamax Poker Tour

No Scheduled Events One of the biggest amateur poker circuits in the world ends with a grand finale in Pa... View Events

Add

World Series of Poker

No Scheduled Events The World Series of Poker® is the largest, richest and most prestigious gaming ev... View Events

Add

World Series of Poker Europe

No Scheduled Events The World Series of Poker Europe is back in 2021. For the first time in the decade-lo... View Events

Add

WPT

No Scheduled Events The marquee international tournaments where winners enter the illustrious Champions C... View Events

Add

WPT National

No Scheduled Events From Manila Bay in the Philippines to Paris, France, WPT® National Events feature... View Events

Add

WPT500

No Scheduled Events WPT500 is a series of international tournaments with an accessible buy-in of $565, he... View Events

Add

WPTDeepStacks

No Scheduled Events WPTDeepStacks combines the WPT's industry-leading brand with the DeepStacks cutting e... View Events

Add

WSOP Circuit Events

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

Add

WSOP International Circuit

No Scheduled Events The International Circuit is back and it is bigger and better this time around, visit... View Events

Add

Wynn Fall Classic

No Scheduled Events The Wynn Fall Classic is held in the magnificent new Poker Room located between ... View Events

Add

Wynn Millions

No Scheduled Events 3rd - 11th March 2022 The Wynn Millions returns in March of 2022, featuring the $10,... View Events

Add

Wynn Signature Series

No Scheduled Events This nine event tournament series features more than $1.1 Million in guaranteed prize... View Events

Add

Latest News & Blogs

Tim Chung wins biggest GUKPT Main Event in history

The GUKPT always gets the new poker calendar off to a cracking start and GUKPT London – which ended on Sunday at the Poker Room at the Victoria Casino – certainly pulled out all the stops with the biggest ever GUKPT Main Event in the tour’s long history.

MainEventTravel.com partnering Casino Malta for two Battle of Malta festivals in 2022

For the first time ever, Casino Malta will be hosting two Battle of Malta festivals this year with the first event in April, followed by a second in the Autumn.

Alexander Yen beats Anton Wigg to win first WPT of Season XX

The WPT’s 20th season has got off to a cracking start in Hollywood with a fiercely-contested battle at the WPT Lucky Hearts Poker Open. Alexander Yen beat Swedish tournament crusher and EPT champion Anton Wigg heads-up for his first major title and a $975,240 first prize

WSOP Returns to its roots as Bally's transforms into Horseshoe Las Vegas

Legendary casino brand Horseshoe is returning to Las Vegas as Bally's begins a transformation just in time for The World Series of Poker.

MSPT Poker Bowl VI is a highlight of Venetian Deepstack Extravaganza schedule

All eyes will be on the Venetian next month when the next Deep Stack Extravaganza festival gets underway in Las Vegas. One of the flagship tournaments on the 41-event schedule is the Mid-Stakes Poker Tour’s Poker Bowl VI which not only comes with a glistening trophy but a juicy $500,000 guarantee as well.

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