0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

0.0004 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.0005 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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0069 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.0001 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.0035 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.0105 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.0009 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.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

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 27th - Saturday 28th March, 2026

APAT Championship

RDS (Royal Dublin Society), RDS, Merrion Road, Ballsbridge, Dublin 4

APAT Championship will take place during the Irish Open. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 10th - Sunday 12th April, 2026

APAT Newcastle

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

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 17th - Sunday 19th April, 2026

APAT Walsall

Grosvenor Casino Walsall, Bentley Mill Way, Walsall, West Midlands WS2 0LE

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 29th April - Sunday 3rd May, 2026

ECOAP

Grand Casino Asch, Czechia, Selbská 2721, 352 01 Aš, Czechia

Main Event Buy-In: €170.

    Find Hotels, Flights & More       View Complete Schedule  

Friday 15th - Sunday 17th May, 2026

APAT Leeds

Grosvenor Casino Leeds Westgate, Wellington Bridge Street, Leeds, LS3 1LW

More details to follow.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 19th - Sunday 21st June, 2026

APAT Coventry

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

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 26th - Sunday 28th June, 2026

APAT Glasgow

Grosvenor Casino Glasgow, Merchant City, 16/18 Glassford Street, Glasgow, G1 1UL

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 21st - Sunday 23rd August, 2026

APAT Birmingham

Grosvenor Casino Birmingham, 84 Hill Street, Birmingham, B5 4AH

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 4th - Sunday 6th September, 2026

APAT Edinburgh

Grosvenor Casino Edinburgh, 1 - 5 South Maybury, Edinburgh, EH12 8NE

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 25th - Sunday 27th September, 2026

APAT Portsmouth

Grosvenor Casino Portsmouth, Gunwharf Quays, Portsmouth, PO1 3TZ

More details to follow.

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 30th September - Sunday 4th October, 2026

APAT German Championship

Grand Casino Asch, Czechia, Selbská 2721, 352 01 Aš, Czechia

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 9th - Sunday 11th October, 2026

APAT Blackpool

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 22nd - Sunday 25th October, 2026

BCOAP

Genting Casino Stratford, Montfichet Road, Olympic Park, Stratford, London E20 1ET

British Championship of Amateur Poker 2026.

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 29th - Saturday 31st October, 2026

APAT Malta

The Casino at Portomaso, Portomaso, Malta

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 20th - Sunday 22nd November, 2026

APAT Reading

Grosvenor Casino Reading South, Rose Kiln Lane, Reading, RG2 0SN

More details to follow. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 27th - Sunday 29th November, 2026

APAT Poker Squads

Manchester235, Great Northern, 2 Watson St, Manchester, M3 4LP

More details to follow. 

    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.