0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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.0005 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.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'eapt'

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

0.0020 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.0123 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.0006 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

Friday 5th - Wednesday 10th April, 2024

EAPT Malta

The Casino at Portomaso, Portomaso, Malta

Get 5% Back When You Book a Malta Hotel for 4 nights or more and checkout using Luxon Pay

€560 Main Event buy-in, €200,000 prize pool guarantee + 5 EAPT Grand Final entry packages worth €5,000 each

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       View Complete Schedule  

Sunday 5th - Thursday 9th May, 2024

EAPT North Cyprus Grand Final

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

The EAPT Grand Final will take place from the 5th to the 9th of May at the luxurious Merit Royal Diamond Casino-Hotel in Cyprus. Some of the EAPT events have truly remarkable guarantees.

Main Event buy-in $2000 + $200 | $2.000.000 GTD

#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  

Saturday 11th - Tuesday 14th May, 2024

EAPT Cyprus

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

EAPT Cyprus will take place from 11th - 14th May 2024.

$1000+$100 Buy in 

$1000000 GTD

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    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

Main Event buy-in £1000+£100 | £500K GTD

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