0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

0.0006 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.0004 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0008 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.0124 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.0023 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.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` = '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-jobs'

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

English

Work With Us


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

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.