0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`
0.0166 SECONDS:
DELETE FROM
`page_views` WHERE `views` < 15 AND `date` != '2024-01-04'
0.0168 SECONDS:
DELETE FROM
`page_views` WHERE 6️⃣ `date` < '2024-11-10'
0.0088 SECONDS:
SELECT `views` FROM
`page_views` WHERE `date` = '2024-01-04' AND `url` = '//maineventtravel/tour/ept'
LIMIT 1
0.0183 SECONDS:
UPDATE `page_views` SET 6️⃣ `views` = 9 WHERE `date` = '2024-01-04'
AND `url` = '//maineventtravel/tour/ept'
0.0006 SECONDS:
SELECT * FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` =
6️⃣ `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` =
'maineventtravel'
0.0003 SECONDS:
SELECT * FROM `settings` WHERE
`white_label_version_id` = 0
0.0709 SECONDS:
SELECT `tours`.*, (select COUNT(*) from
tour_stops where 6️⃣ tour_stops.tour_id=tours.id AND tour_stops.end_date > curdate() AND
tour_stops.active = 1) tour_stop_count FROM `tours` WHERE `active` = 1 AND `venue` =
'0' 6️⃣ AND `festival` = '0' ORDER BY `order` ASC
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` 6️⃣ =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'tour'
0.0003
SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY
6️⃣ `order` ASC
0.0005 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' AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002
6️⃣ SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY
`display_order`
0.0064 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops
where 6️⃣ 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.0018 SECONDS:
SELECT `pages`.*, 6️⃣ `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.0004 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` 6️⃣ 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' AND `white_label_inclusions`.`entity_type` = 'page'
0.0055
SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as
6️⃣ article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN
`news_article_categories` ON `news_article_categories`.`news_category_id` =
`news_categories`.`id` JOIN `news_articles` ON
`news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY
6️⃣ `news_categories`.`id`
0.0118 SECONDS:
SELECT `news_articles`.* FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND
`news_articles`.`active` = 1 6️⃣ ORDER BY `date` DESC
0.0015 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' AND `white_label_inclusions`.`entity_type` 6️⃣ = 'news'
0.0007
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.0053 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
6️⃣ `news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0014 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` FROM 6️⃣ `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' AND `white_label_inclusions`.`entity_type` = 'news'
0.0006
SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions`
WHERE 6️⃣ `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0047 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` 6️⃣ = '18' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0013 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` 6️⃣ WHERE `white_label_versions`.`url` =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0006
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.0049 6️⃣ SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND
`news_articles`.`active` = 1 ORDER 6️⃣ BY `date` DESC
0.0013 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' AND `white_label_inclusions`.`entity_type` = 6️⃣ 'news'
0.0006
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.0074 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` 6️⃣ ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0014 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` FROM `white_label_inclusions` 6️⃣ JOIN
`white_label_versions` ON `white_label_versions`.`id` =
`white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0006
SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions`
WHERE `white_label_version_id` 6️⃣ = 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0056 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = 6️⃣ '23' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0014 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 6️⃣ `white_label_versions`.`url` =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0006
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.0065 SECONDS:
SELECT 6️⃣ `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND
`news_articles`.`active` = 1 ORDER BY 6️⃣ `date` DESC
0.0018 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' AND `white_label_inclusions`.`entity_type` = 'news'
0.0012
6️⃣ 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.0055 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON 6️⃣ `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0014 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN
6️⃣ `white_label_versions` ON `white_label_versions`.`id` =
`white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0006
SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions`
WHERE `white_label_version_id` = 6️⃣ 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0048 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' 6️⃣ AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0013 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` 6️⃣ =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0007
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.0108 SECONDS:
SELECT `news_articles`.* 6️⃣ FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND
`news_articles`.`active` = 1 ORDER BY `date` 6️⃣ DESC
0.0015 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' AND `white_label_inclusions`.`entity_type` = 'news'
0.0006
SECONDS:
SELECT 6️⃣ `white_label_inclusions`.`entity_id` FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0065 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` 6️⃣ =
`news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0014 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN
`white_label_versions` 6️⃣ ON `white_label_versions`.`id` =
`white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` =
'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0007
SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0 6️⃣ AND `white_label_inclusions`.`entity_type` =
'news'
0.0003 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'ept'
0.0003 SECONDS:
SELECT
* FROM `tours` WHERE `page_url` = 'ept'
0.0002 6️⃣ SECONDS:
SELECT * FROM `tours` WHERE
`id` = '86'
0.0019 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or
tour_stops.logo = '' THEN 6️⃣ 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 6️⃣ 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 6️⃣ `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.0116 SECONDS:
SELECT
6️⃣ `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' 6️⃣ ORDER BY
`news_articles`.`date` DESC
0.0016 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' AND
`white_label_inclusions`.`entity_type` 6️⃣ = 'news'
0.0007 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.0004
SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` 6️⃣ LIKE
'%individual-tour-stop%'
Open Modal Hi, We'd like to send you push notifications so you
never miss out on: Exclusive Offers
Upcoming Events
Exciting 6️⃣ Promotions
Poker Travel
News Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by
logging into your 6️⃣ account and changing your settings. Many Thanks,
The MainEventTravel
team
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
GBPR$ USD
USD € EUR
