0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0101 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-19' AND `url` = 'https://www.maineventtravel.com/pages/page/met-event' ORDER BY `views` DESC

0.0173 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-03-19' AND `url` = 'https://www.maineventtravel.com/pages/page/met-event'

0.0007 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0007 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `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.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0003 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` = '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.0115 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.0016 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.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` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

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`.`url_name` = 'met-event'

0.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/met-event%'

English

Event Management


In addition to our hotel & flight services, MainEventTravel.com (MET) also provide a full suite of Event Management services. MET are happy to quote for any upcoming event that you may have, or indeed any component part of an upcoming event anywhere in the world.

Recently we have been engaged by our clients to book, manage and staff Poker Tournaments, VIP Dinners, Yacht Charters, Motor Racing, Group Transport, a Michelin Starred Restaurant Experience, Base Jumping, Group Flights and much more. We even rented an entire beach for a dinner & prize giving ceremony.

Contact us to discuss your requirements.

 “Quite simply the best and most efficient event that we have ever held”

VIP Manager – VIP Player event held in Malta

“You guys really bought into the concept I had and made it happen’

Affiliiate Event Co-ordinator – Extreme Adrenalin Event in Berlin

“We are looking forward to doing this again next year”

VP of Marketing – Event for 200 players in Las Vegas

Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.