0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/pages/page/brand-ambassadors', 1, '2024-03-19')

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.0003 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.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.0017 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.0007 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` = 'brand-ambassadors'

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

English

Team MainEventTravel


MainEventTravel.com are delighted to be represented by our selected Brand Ambassadors. If you know any of them, please feel free to talk to them about the benefits of using MainEventTravel.com and how you can get a 10% discount code when you sign up using their own unique page.

 

MET  Brand Ambassador

SimonD

Simon Deadman 

Simon is the consumate poker professional and has amassed $2.5 million of tournament earnings, including winning WPT Ireland, the Hollywood Poker Open and finishing runner up to Jason Mercier during the 2015 WSOP. 

Simon was the first person whom we thought of to become an ambassador of MET. He has an impeccable record as a poker player, and is a fantastic person to be sat at the table with, always engaging in friendly conversation with those around him.

These are some of the attributes which we are looking for in a true brand ambassador.

Follow Simon Here

 

MET Brand Representatives

 

SholaD

Shola Akindele-Deadman  

Married to Simon, Shola is not just a 'Poker Wife'. Shola has over $350,000 of live tournament earnings to her name, including a final table appearance at the 2015 WSOP. Shola also has a degree in law, so if she ever gets bored of travelling the world playing poker..... well, ok, that's probably not going to happen!!

Follow Shola Here

ScottK

Scott Kateian

 Based in Seattle, Scott's passion outside of his day job is poker. He plays regularly around the US circuit, and also travels to Europe where he has enjoyed deep runs at the Irish Open and the UKIPT. Scott is always a pleasure to have at your table.

 

Follow Scott here

 

Would you like to join Team MET?

We are always looking to add like-minded poker players to Team MET. Apart from the run-good factor which obviously comes with wearing one of our patches, there are also discounts to be had on your own accommodation, and potential earnings through introducing new clients to the MET brand and website.

If you feel that you could help us promote MainEventTravel, and have the right credentials, both as a poker player, and a responsible, well mannered person, please get in touch with us at team@maineventtravel.com

We hope to hear from you soon.

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.