0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0066 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-03-29' AND `url` = 'https://www.maineventtravel.com/tour/apat' ORDER BY `views` DESC

0.0201 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-03-29' AND `url` = 'https://www.maineventtravel.com/tour/apat'

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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0006 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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 * 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.0042 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.0057 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'apat'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'apat'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '10'

0.0013 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` = '10' ORDER BY `tour_stops`.`start_date` ASC

0.0108 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.0006 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.0005 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.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

APAT

The Amateur Poker Association & Tour (APAT) was founded on August 1st, 2006, making it one of the oldest UK National Tours.

Since then, APAT has run multi-day National Amateur Championship poker tournaments in Austria, Belgium, Czech Republic, England, Estonia, Ireland, Scotland, Wales and the United States of America.

Upcoming Tour Stops

Friday 25 April, 2025

APAT Newcastle

Grosvenor Casino Newcastle, 100 St James Boulevard, Newcastle Upon Tyne, NE1 4BN

7pm

Buy-In: £140

Find Hotels, Flights & More Full Schedule Coming Soon

Saturday 03 May, 2025

APAT Malta

The Casino at Portomaso, Portomaso, Malta

5pm

Buy-In: €120

Find Hotels, Flights & More Full Schedule Coming Soon

Wednesday 21 May, 2025

ECOAP

Grosvenor Casino Coventry, Coventry Building Society Arena, Phoenix Way, Coventry, CV6 6GE

5pm

Buy-In: £140

Find Hotels, Flights & More Full Schedule Coming Soon

Friday 18 July, 2025

APAT Liverpool

Grosvenor Casino Liverpool, 44 Chaloner Street, Liverpool, L3 4BF

7pm

Buy-in: £140

Find Hotels, Flights & More Full Schedule Coming Soon

Wednesday 20th - Monday 25th August, 2025

WCOAP 2025

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

APAT are delighted to confirm WCOAP 2025 from Wed 20th to Mon 25th Aug hosted at Dusk Till Dawn, Nottingham, UK.

Whilst the International Team Championship will kick off events on Wed, the full schedule of events and further details will be confirmed in the coming weeks.

Find Hotels, Flights & More Full Schedule Coming Soon