0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-04-03' AND `url` = 'https://www.maineventtravel.com/pages/page/partners' ORDER BY `views` DESC

0.0105 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-04-03' AND `url` = 'https://www.maineventtravel.com/pages/page/partners'

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

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0037 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.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` = '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` = 'partners'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%/page/partners%'

English

Partners


Official Travel Partner for Grosvenor UK Poker Tour

Launched in 2007, the GUKPT brings the excitement of the big game experience to a casino near you. Each festival features several warm-up events and either a £900 or £1,100 Main Event, with the stakes being raised in the tour's Grand Final.

Official Travel Partner for Dusk Till Dawn Poker

Dusk Till Dawn is Europe's premier Poker venue based in Nottingham, offering 45 poker tables with a capacity to comfortably sit 450 players at any one time with varied buy-ins to suit all levels.

Official Travel Partner for 888Live

With over 10 million registered members worldwide, 888Poker is the fastest growing online poker room. It has also been a forerunner in the online gaming industry and a pioneer in safe and responsible gaming since 1997.

Official Travel Partner for Goliath

The Grosvenor Goliath, Europe’s largest live poker tournament, is back and bigger than ever. Last year, it broke records with an incredible 10,584 entries, creating a £1,270,080 prize pool.

This year’s 11-day festival features 8 flights for the flagship £120 + £30 Goliath Main Event, along with a range of exciting side events. Highlights include the £900 + £100 GUKPT, £1,800 + £200 High Roller, £200 + £200 + £40 Mystery Bounty, and the £500 + £50 Goliath Cup. Players can also look forward to the legendary Joker’s Wild, a Ladies Event, a Seniors Event, a PLO 4 Card tournament, the APAT Championship, and numerous Redtooth Poker Events. Don’t miss out on the chance to be part of this iconic tournament!

Official Travel Partner for Irish Poker Open

The Irish Poker Open is the longest-running poker tournament in Europe with a history going back more than 45 years. It is considered an absolute must on the international poker calendar and always attracts a stellar crowd.

Official Travel Partner for Luxon Pay

Luxon Pay is a multi-currency digital wallet and is a safe and convenient way to deposit funds into merchants for quick and easy online payments. Luxon Pay eWallet enables you to hold multiple currencies and exchange them instantly.  

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.