0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0068 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/pages/page/partners'
ORDER BY `views` DESC

0.0098 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
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.0004 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.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.0035 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.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
  1. Home
  2. Partners

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 biggest live tournament in Europe, Grosvenor Goliath broke records in 2022 attracting a staggering field of 10,584 entries to create a £1,270,080 prize pool.

In addition to 8 flights into the flagship £120 + £30 Goliath Main Event this year’s 11-day festival includes a £900 + £100 GUKPT, £1800 + £200 High Roller, £200 + £200 + £40 Mystery Bounty, £500 + £50 Goliath Cup, along with the infamous Joker’s Wild, a Ladies Event, a Seniors Event, a PLO 4 Card, an APAT Championship Event, and a host of Redtooth Poker Events.

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 42 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.  

Official Travel Partner for the Malta Poker Festival

Set over an entire week, this massive poker festival brings together a lot of different nationalities -enjoying several poker tournaments. The festival runs alongside several “off felt” entertainment activities including the grand finale party.

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.