0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0113 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-28' AND `url` = 'https://www.maineventtravel.com/tour/apat' 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/apat'

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.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.0114 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.0008 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` = 'apat'

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

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

0.0024 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.0138 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

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

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  

Wednesday 02 October, 2024

APAT German Amateur Poker Championship

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

Oct 02, 2024, 05:00pm

Grand Casino Asch, Selbská 2721, 352 01 Aš 1, Czech Republic

Buy In: €120

    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  

Saturday 02 November, 2024

APAT Maltese Open Championship

The Casino at Portomaso, Portomaso, Malta

Nov 02, 2024, 05:00pm

Portomaso Casino, St Julian’s, Malta,

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 29th November - Sunday 1st December, 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.