0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`
0.0164 SECONDS:
DELETE FROM
`page_views` WHERE `views` < 15 AND `date` != '2024-01-04'
0.0166 SECONDS:
DELETE FROM
`page_views` WHERE 8️⃣ `date` < '2024-11-10'
0.0087 SECONDS:
SELECT `views` FROM
`page_views` WHERE `date` = '2024-01-04' AND `url` =
'//maineventtravel/event/espt-sevilla-2024' LIMIT 1
0.0187 SECONDS:
UPDATE
`page_views` SET 8️⃣ `views` = 2 WHERE `date` = '2024-01-04' AND `url` =
'//maineventtravel/event/espt-sevilla-2024'
0.0006 SECONDS:
SELECT * FROM
`settings` JOIN `white_label_versions` ON `white_label_versions`.`id` =
8️⃣ `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` =
'maineventtravel'
0.0004 SECONDS:
SELECT * FROM `settings` WHERE
`white_label_version_id` = 0
0.0003 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE
`currency_iso_from` = 8️⃣ '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 8️⃣ `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` = 8️⃣ '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` =
8️⃣ '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 8️⃣ * FROM `settings` WHERE
`white_label_version_id` = 0
0.0716 SECONDS:
SELECT `tours`.*, (select COUNT(*) from
tour_stops where tour_stops.tour_id=tours.id AND tour_stops.end_date > curdate() AND
8️⃣ tour_stops.active = 1) tour_stop_count FROM `tours` WHERE `active` = 1 AND `venue` =
'0' AND `festival` = '0' ORDER BY 8️⃣ `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
8️⃣ 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` 8️⃣ 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
SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` 8️⃣ WHERE `active` = 1 ORDER BY
`display_order`
0.0020 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as
`parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON 8️⃣ `parents`.`id` =
`pages`.`parent_page_id` WHERE `pages`.`active` = '1'
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` =
8️⃣ 'maineventtravel' AND `white_label_inclusions`.`entity_type` = 'page'
0.0065
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
= 8️⃣ 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30
0.0054
SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as
article_count, MAX(news_articles.date) as recent_date FROM `news_categories` 8️⃣ 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.0115 SECONDS:
SELECT `news_articles`.* FROM `news_articles`
LEFT 8️⃣ 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` 8️⃣ 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.0007
SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions`
8️⃣ WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0051 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON `news_article_categories`.`news_article_id` =
`news_articles`.`id` WHERE 8️⃣ `news_article_categories`.`news_category_id` = '16' AND
`news_articles`.`active` = 1 ORDER BY `date` DESC
0.0018 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN
`white_label_versions` ON `white_label_versions`.`id` =
8️⃣ `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` =
8️⃣ '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` = '18' AND
`news_articles`.`active` = 1 8️⃣ 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` =
'maineventtravel' AND `white_label_inclusions`.`entity_type` 8️⃣ = '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 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
8️⃣ `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 8️⃣ `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 8️⃣ `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0079 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` 8️⃣ = '22' AND
`news_articles`.`active` = 1 ORDER BY `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` 8️⃣ 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` =
'news'
0.0055 8️⃣ 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 8️⃣ 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` = 8️⃣ '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.0061 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN
`news_article_categories` 8️⃣ 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.0015 SECONDS:
SELECT
`white_label_inclusions`.`entity_id` FROM `white_label_inclusions` 8️⃣ 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` 8️⃣ = 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0054 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` = 8️⃣ '28' 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 8️⃣ `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.0047 SECONDS:
SELECT 8️⃣ `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 8️⃣ `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
8️⃣ 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`.* FROM `news_articles` LEFT JOIN
`news_article_categories` ON 8️⃣ `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
8️⃣ `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` = 8️⃣ 0 AND `white_label_inclusions`.`entity_type` =
'news'
0.0063 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' 8️⃣ 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` 8️⃣ =
'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.0004 SECONDS:
SELECT tour_stops.*, 8️⃣ 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 8️⃣ 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
8️⃣ 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 8️⃣ `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`id` =
'espt-sevilla-2024'
0.0042 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS
NULL or tour_stops.logo = '' THEN tours.logo 8️⃣ 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, 8️⃣ 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
8️⃣ `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` =
'espt-sevilla-2024'
0.0002 SECONDS:
SELECT * FROM `tours` 8️⃣ WHERE `id` = '134'
0.0001
SECONDS:
SELECT * FROM `tours` WHERE `id` = '2006'
0.0018 SECONDS:
SELECT tour_stops.*,
CASE WHEN tour_stops.logo IS NULL or 8️⃣ 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 8️⃣ 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` 8️⃣ LEFT JOIN
`venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date >
CURDATE() AND tour_stops.active = 1 AND `tour_id` = '2006' ORDER 8️⃣ BY
`tour_stops`.`start_date` ASC
0.0002 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 8️⃣ `uapi_cities` ON `uapi_cities`.`city_code` =
`uapi_airports`.`reference_city` WHERE `airport_code` = 'SVQ'
0.0114 SECONDS:
SELECT
`news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as
`twitter_name` FROM `news_articles` LEFT 8️⃣ JOIN `users` ON `users`.`id` =
`news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY
`news_articles`.`date` DESC
0.0017 SECONDS:
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions` JOIN `white_label_versions` 8️⃣ 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 8️⃣ AND `white_label_inclusions`.`entity_type` = 'news'
0.0010
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 8️⃣ 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 8️⃣ 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` 8️⃣ 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` =
8️⃣ `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 8️⃣ `tour_stops`.`id` = 2006 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` =
8️⃣ `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 8️⃣ like to send you push notifications so you never miss out on: Exclusive
Offers
Upcoming Events
Exciting Promotions
Poker Travel News Don’t worry; 8️⃣ we won’t
bombard you with messages, and you can-opt out anytime by logging into your account and
changing your settings. 8️⃣ Many Thanks,
The MainEventTravel team