0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0086 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-10' AND `url` = 'https://www.maineventtravel.com/pages/page/about-us' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/about-us', 1, '2024-11-10')

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.com'

0.0004 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.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.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` = '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.0064 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.0004 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` = 'about-us'

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

English

About Us


Formed through a love of poker and the lack of knowledge that existing tour operators had for the game, MainEventTravel.com was created in 2011 as  a one stop shop for anyone travelling domestically and abroad to play poker. 

At MainEventTravel.com our aim is to provide exceptional convenience and value to poker players seeking travel, accommodation and hospitality services in conjunction with their participation in live poker events around the world.

Our Vision:

MainEventTravel.com (MET) is the pioneering market leader in providing bespoke travel, hospitality, digital marketing, PR services and consultancy packages to gaming operators, poker players and leisure enthusiasts.

Our Service:

At MET we strive to provide exceptional service, convenience, and value, to gaming operators, their customers, and individual clients for travel, accommodation, event management and hospitality services in locations around the world.

Our event management team have a wealth of experience in planning, preparing, and coordinating world-class events, all around the globe. Whether it’s a poker tournament for thousands of players, an awards dinner on a beach for 300 guests, or a select group of VIPs being hosted at a high profile event, we have done it all.

In addition, our marketing & consultancy team provide solutions for digital marketing, social media content & publication and targeted advertising, with live and post-event analytics studies to show cause and effect.

Our Partners:

MET currently provides services to our corporate partners that include group hotel bookings, group activities, tournament registrations, VIP hospitality, event management, consultancy, marketing, event hosting, web design, e-commerce platforms, and payment gateways.

Our current roster of corporate clients includes 888Poker, Grosvenor Casinos, Casino Malta, Visual Marketing Services, Rank Interactive, Prima Networks, Unibet, Redtooth Poker, Aspers, Random Logic, Eden Leisure Group, the Hippodrome Casino, PMU, and the World Poker Tour.

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.