0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0100 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-20' AND `url` = 'https://www.maineventtravel.com/tour/eapt' ORDER BY `views` DESC

0.0167 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-20' AND `url` = 'https://www.maineventtravel.com/tour/eapt'

0.0005 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.0007 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.0118 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.0007 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.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'eapt'

0.0004 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'eapt'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = '157'

0.0019 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '157' ORDER BY `tour_stops`.`start_date` ASC

0.0128 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `news_articles`.`active` = '1' ORDER BY `news_articles`.`date` DESC

0.0014 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` = 'news'

0.0007 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

EAPT


The EAPT has been hosting poker tournaments since 2013, which means 10 years of experience in providing top-notch poker experiences.

Our festivals have a vast geography, from Kyiv in Ukraine to the Caribbean, from Northern Cyprus to Kazakhstan, and from Montenegro to Altai.

Upcoming Tour Stops

Thursday 2nd - Sunday 12th May, 2024

EAPT Cyprus & Mediterranean Poker Party

Merit Royal Diamond, Mersin, Alsancak Mevkii Girne KKTC, 99350

The EAPT takes place alongside the Mediterranean Poker Party,  key events include:

  • Luxon Pay Mystery Bounty - $1,100 buy-in & $1M GPP
  • EAPT Grand Final - $2,200 buy-in & $2M GPP
  • MPP Main Event $5,300 buy-in & $5M GPP
  • EAPT Cyprus $1,100 buy-in & $500k GPP
  • MPP High Roller $10,400 buy-in & $1M GPP

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs 

    Find Hotels, Flights & More       View Complete Schedule  

Friday 17th - Monday 27th May, 2024

EAPT UK

Dusk Till Dawn, Redfield Way, Boulevard Retail Park, Lenton, Nottingham, NG7 2UW

EA Poker Tour is in the UK for the first time! 

UK poker fans will be treated to an extensive 11-day series of poker events at one of the country's top poker clubs. 

A packed schedule of major cup events and satellites, as well as side turbo tournaments in the evenings.

The Festival culminates in a £560 buy-in Main Event with a guaranteed prize pool of half a million pounds - the largest reported prize pool in the current EAPT season (excluding the Grand Final)

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs

    Find Hotels, Flights & More       Full Schedule Coming 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.