0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-dev`

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

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://dev.maineventtravel.com/pages/page/partners', 1, '2025-04-26')

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` = 'dev.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.0002 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` = 'dev.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.0002 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` = 'dev.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.0027 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` = 'dev.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` = 'partners'

0.0002 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%/page/partners%'
  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found
English
  1. Home
  2. Partners

Partners


MainEventTravel.com is the Official Travel Partner of 888Live.  More Details are available from 888poker Live Events.

MainEventTravel.com is the Official Travel Partner of Aspers Casino. The poker room is the home of the world's top poker tournaments including the WPT, Unibet Open and 888 Live.

It is the biggest card room in London with warm and friendly staff and a real community vibe between the players, playing poker couldn’t be more fun! With a wide variety of tournaments and cash games on offer to suit all levels, they have got something for everyone.

 

 

MainEventTravel.com is the Official Travel and Marketing Partner of the Battle of Malta. This award-winning event broke its own records in 2018 with 3,816 and 2019 with 4,657 players taking part in the main event. MainEventTravel.com is not only the official supplier of hotel packages but also provides event logistic support, digital marketing services and event consultancy.

MainEventTravel.com is the Official Travel Partner of the Irish Poker Open, the longest-running poker tournament in Europe. We are delighted to be a partner to this Irish 'institution' and we offer hotel rooms for the event, alongside tournament buy-ins.

MainEventTravel.com is The Official Travel Partner of the 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 £500 or £1,000 Main Event, with the stakes being raised in the tour's Grand Final.

 

 

MainEventTravel.com is the Official Travel Partner of the Redtooth Poker Tour, the UK’s number one pub poker tour giving players from around the UK the feel of going on a poker tour at an affordable price. You can find further details on the Redtooth Poker Tour including dates and venues via the Redtooth Poker website www.redtoothpoker.com/rpt

 

 

MainEventTravel.com is the Official Travel Partner of the World Poker Tour. The WPT offers numerous great locations for the live Poker player. MainEventTravel.com have a dedicated website www.WPTtravel.com to ensure both the WPT Main Tour and the WPTDeepstacks & National Tour schedules are up to date and able to furnish you with our accommodation offers. 

 

 

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.