0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`
0.0169 SECONDS:
DELETE FROM `page_views` WHERE `views` < 15 AND `date` != '2024-01-04'
0.0171 SECONDS:
DELETE FROM `page_views` WHERE 4️⃣ `date` < '2024-11-10'
0.0084 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-01-04' AND `url` = 'https://maineventtravel/event/pca-2024' LIMIT 1
0.0194 SECONDS:
UPDATE `page_views` SET 4️⃣ `views` = 6 WHERE `date` = '2024-01-04' AND `url` = 'https://maineventtravel/event/pca-2024'
0.0006 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = 4️⃣ `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel'
0.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0
0.0003 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 4️⃣ 'GBP' AND `currency_iso_to` = 'USD'
0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'
0.0002 SECONDS:
SELECT `rate` FROM 4️⃣ `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'
0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 4️⃣ 'EUR'
0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'
0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 4️⃣ 'EUR' AND `currency_iso_to` = 'USD'
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'
0.0003 SECONDS:
SELECT 4️⃣ * FROM `settings` WHERE `white_label_version_id` = 0
0.0719 SECONDS:
SELECT `tours`.*, (select COUNT(*) from tour_stops where tour_stops.tour_id=tours.id AND tour_stops.end_date > curdate() AND 4️⃣ tour_stops.active = 1) tour_stop_count FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY 4️⃣ `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` = 'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'tour'
0.0003 4️⃣ SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC
0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` 4️⃣ 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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` 4️⃣ WHERE `active` = 1 ORDER BY `display_order`
0.0018 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON 4️⃣ `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'
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` = 4️⃣ 'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'page'
0.0066 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 = 4️⃣ 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30
0.0058 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` 4️⃣ 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 `news_categories`.`id`
0.0124 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT 4️⃣ 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 ORDER BY `date` DESC
0.0014 SECONDS:
SELECT `white_label_inclusions`.`entity_id` 4️⃣ 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 `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` 4️⃣ WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'
0.0053 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE 4️⃣ `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 `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = 4️⃣ `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 AND `white_label_inclusions`.`entity_type` = 4️⃣ 'news'
0.0049 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` = '18' AND `news_articles`.`active` = 1 4️⃣ 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 `white_label_versions`.`url` = 'maineventtravel' AND `white_label_inclusions`.`entity_type` 4️⃣ = '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 4️⃣ `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 BY `date` DESC
0.0013 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM 4️⃣ `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 4️⃣ `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'
0.0102 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` 4️⃣ = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC
0.0023 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` 4️⃣ WHERE `white_label_versions`.`url` = 'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'news'
0.0011 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.0058 4️⃣ 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` = '23' AND `news_articles`.`active` = 1 ORDER 4️⃣ 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 `white_label_versions`.`url` = 'maineventtravel' AND `white_label_inclusions`.`entity_type` = 4️⃣ '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.0077 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` 4️⃣ 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 `date` DESC
0.0021 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` 4️⃣ 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.0007 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` 4️⃣ = 0 AND `white_label_inclusions`.`entity_type` = 'news'
0.0057 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` = 4️⃣ '28' 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 4️⃣ `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 AND `white_label_inclusions`.`entity_type` = 'news'
0.0050 SECONDS:
SELECT 4️⃣ `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' AND `news_articles`.`active` = 1 ORDER BY 4️⃣ `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` = 'news'
0.0006 4️⃣ 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.0109 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON 4️⃣ `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` DESC
0.0014 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN 4️⃣ `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` = 4️⃣ 0 AND `white_label_inclusions`.`entity_type` = 'news'
0.0070 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` = '31' 4️⃣ 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 `white_label_versions`.`url` 4️⃣ = '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.0005 SECONDS:
SELECT tour_stops.*, 4️⃣ CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, uapi_airports.name as airport_name, tours.name 4️⃣ 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 4️⃣ FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `uapi_airports` ON `tour_stops`.`uapi_code` = `uapi_airports`.`airport_code` LEFT JOIN `venues` ON 4️⃣ `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`id` = 'pca-2024'
0.0044 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo 4️⃣ ELSE tour_stops.logo END AS logo, uapi_airports.name as airport_name, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, 4️⃣ 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 4️⃣ `uapi_airports` ON `tour_stops`.`uapi_code` = `uapi_airports`.`airport_code` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`page_url` = 'pca-2024'
0.0002 SECONDS:
SELECT * FROM `tours` 4️⃣ WHERE `id` = '102'
0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = '1721'
0.0018 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or 4️⃣ 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 4️⃣ 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` 4️⃣ LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '1721' ORDER 4️⃣ BY `tour_stops`.`start_date` ASC
0.0003 SECONDS:
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country` FROM `uapi_airports` JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code` JOIN 4️⃣ `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city` WHERE `airport_code` = 'NAS'
0.0114 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT 4️⃣ JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC
0.0014 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` 4️⃣ 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` = 0 4️⃣ AND `white_label_inclusions`.`entity_type` = 'news'
0.0009 SECONDS:
SELECT packages.*, currencies.name as currency_name, currencies.ISO_4217_code as currency_code, currencies.symbol as currency_symbol, hotels.name as hotel_name, hotels.main_image as 4️⃣ hotel_image, hotels.description as hotel_description, rooms.board_extras as board_extras, rooms.room_type as room_type, rooms.max_occupancy as occupancy, tour_stops.name as tour_stop_name, CASE WHEN tour_stops.logo IS 4️⃣ NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS tour_stop_logo, tours.name as tour_name, tours.logo as tour_logo FROM `packages` 4️⃣ LEFT JOIN `currencies` ON `currencies`.`id` = `packages`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `packages`.`tour_stop_id` LEFT JOIN `tours` ON `tours`.`id` = 4️⃣ `tour_stops`.`tour_id` LEFT JOIN `rooms` ON `rooms`.`id` = `packages`.`room_id` LEFT JOIN `hotels` ON `hotels`.`id` = `rooms`.`hotel_id` WHERE packages.available_until > CURDATE() AND 4️⃣ `tour_stops`.`id` = 1721 AND `packages`.`active` = 1 ORDER BY `packages`.`special_price` ASC
0.0006 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = 4️⃣ `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'package'
0.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%all-events%'
Open Modal Hi, We'd 4️⃣ like to send you push notifications so you never miss out on: Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News Don’t worry; 4️⃣ we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings. 4️⃣ 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