0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-dev`
0.0489 SECONDS:
SELECT *
FROM `page_views`
WHERE `date` = '2026-04-12'
AND `url` = 'https://dev.maineventtravel.com/pages/page/met-jobs'
ORDER BY `views` DESC
0.0689 SECONDS:
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2026-04-12'
AND `url` = 'https://dev.maineventtravel.com/pages/page/met-jobs'
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` = '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.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` = 'tour'
0.0002 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`
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 `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0027 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.0002 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`.`url_name` = 'met-jobs'
0.0001 SECONDS:
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/met-jobs%'
Hi,
We'd like to send you push notifications so you never miss out on:
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
Our Board of Directors come from vastly different backgrounds and as such we offer a great mix of leadership personalities here at MainEventTravel.com. This blend allows us to understand and develop the mix of people we need to drive us forwards. We employ focussed and self-starter type individuals. We also recruit creative people able to turn conceptual ideas into reality, and indeed we also employ hard sales orientated people. Each of these competencies and skills are leveraged into a 'team' environment. We've created a unit that is inherently focussed on delivery, while providing an enjoyable place to work.
We are always looking to hear from those, preferably with poker experience, who can contribute in different ways. This can be through IT, Event Management, Account Management, Travel Agency, VIP Hosting, Blogging or Social Media.
If you feel you can make a difference, then we would love to hear from your, so send us a covering letter and CV to careers@maineventtravel.com
ATOL and PTS Protection
Main Event Travel Ltd (SC830886) is a proud member of Protected Trust Services (PTS). Our member number is PT6402. Our ATOL Licence is 12890.
All flights and flight-inclusive holidays on this website are financially protected by the ATOL scheme. When you pay, you will be supplied with an ATOL Certificate. Please ask for it and check that everything you booked (flights, hotels and other services) is listed on it. Please see our booking conditions for further information, or for more information about financial protection and the ATOL Certificate, go to www.caa.co.uk.
Our holidays are financially secured by PTS. Flight-inclusive packages are covered by ATOL. When booking your holidays with us, you can rest assured your funds are fully protected. In the unlikely event that any supplier fails, all funds are held in an Independent Trust Account.