0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0084 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-22' AND `url` = 'https://www.maineventtravel.com/tour/apat' LIMIT 1

0.0014 SECONDS:
REPLACE INTO `page_views` (views, `date`, `url`) VALUES (views + 1, '2024-02-22', 'https://www.maineventtravel.com/tour/apat')

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.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.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.0127 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.0009 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.0007 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` = 'apat'

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

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

0.0023 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.0122 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.0030 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

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

Wednesday 21st - Sunday 25th February, 2024

ECOAP 2024

Aspers Casino Westfield Stratford City, Montfichet Road, Olympic Park, Stratford, E20 1ET

ECOAP 2024 will be hosted at Aspers Casino Stratford! 

Buy in - £120.00

Check out the full schedule. 

    Find Hotels, Flights & More       View Complete Schedule  

Friday 22 March, 2024

APAT Open Championship 2024

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

6pm at Manchester 

Buy In: £120.00

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Saturday 27 April, 2024

APAT Mediterranean Championship 2024

The Casino at Portomaso, Portomaso, Malta

1pm at the Portomaso Casino

Buy In: €120

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 1st - Thursday 2nd May, 2024

APAT Irish Championship 2024

The Green Isle Hotel, St John's Dr, Newlands Cross, Dublin 22, D22 F9F4, Ireland

2pm at the GreenIsle Hotel.

Buy In €250.00

    Find Hotels, Flights & More       View Complete Schedule  

Friday 17 May, 2024

APAT Scottish Championship 2024

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

7pm at Grosvenor Casino Glasgow. 

Buy In £120.00

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 14 June, 2024

APAT UK Championship 2024

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

7pm Grosvenor Casino Leeds

Buy In: £120.00

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 21 August, 2024

WCOAP 2024

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

3pm at Dusk Till Dawn

Buy In: TBC

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 18 October, 2024

APAT English Championship 2024

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

Grosvenor Casino Blackpool at 7pm

Buy In: £120

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 15 November, 2024

APAT UK & Ire Championship 2024

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

7pm at Grosvenor Casino Newcastle 

Buy In: £120.00

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 29 November, 2024

APAT Poker Squads Live 2024

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

7pm at Dusk Till Dawn 

Buy In: £120.00

    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.