0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0059 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-06-21' AND `url` = 'https://www.maineventtravel.com/tour/irish-poker-tour' ORDER BY `views` DESC

0.0084 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-06-21' AND `url` = 'https://www.maineventtravel.com/tour/irish-poker-tour'

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

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

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` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0061 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.0002 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` = 'irish-poker-tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'irish-poker-tour'

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

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

0.0114 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.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` = 'news'

0.0004 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

Irish Poker Tour


At the Irish Poker Tour they pride themselves on timely, well-organized, relaxed, and player-friendly tournaments. Through tried and tested approaches and a passionate team, they have the formula to make the Irish Poker Tour a truly memorable experience.

Upcoming Tour Stops

Tuesday 18th - Monday 24th June, 2024

Portugal Adventure

Casino Troia, R. do Zimbro, 7570-789, Portugal

€400,000 Festival Guarantee  features €700 Buy-In Main Event with a €250,000 GTD

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Friday 28th - Sunday 30th June, 2024

Summer in Dublin

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

In partnership with Paddypower Poker, Summer in Dublin will be a two day event hosted at The Greenisle Hotel. 

Main Event Buy In - €220 + €30 with a festival guarantee of €150000

    Find Hotels, Flights & More       View Complete Schedule  

Friday 26th - Saturday 27th July, 2024

Irish Poker Tour: Cork

Macau Sporting Club, 16 St. Patrick's Quay, Cork, Ireland

Buy-In: €125+25 with a Festival Guarantee of €17,000

    Find Hotels, Flights & More       View Complete Schedule  

Friday 26th - Sunday 28th July, 2024

Northern Poker Festival

Fairways Hotel, Dublin Road, Haggardstown, Dundalk, Co. Louth, A91E6KC

Main Event Buy-in: €265 + €35

Festival Guarantee: €100,000

    Find Hotels, Flights & More       View Complete Schedule  

Saturday 17 August, 2024

€20K in a Day

McWilliam Park Hotel, Kilcolman Road, Boherduff, Claremorris, Co. Mayo, F12 D1W3, Ireland

Buy-in - €200 with a festival guarantee of €28,000

    Find Hotels, Flights & More       View Complete Schedule  

Friday 23rd - Sunday 25th August, 2024

Lunasa Lunacy Festival

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

Main Event Buy-In: €220 + €30

Festival Guarantee: €150,000 (Plus 10 x Killarney Packages)

    Find Hotels, Flights & More       View Complete Schedule  

Friday 13th - Sunday 15th September, 2024

Donegal Poker Festival

Clanree Hotel, Derry Road, Bunnagee, Letterkenny, Co. Donegal, Ireland

Main Event Buy-In: €265 + €35

Festival Guarantee: €100,000

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 25th - Sunday 29th September, 2024

The Killarney Festival

INEC Killarney, Muckross Rd, Killarney, Co. Kerry, Ireland

Irish Poker Tour returns to the Gleneagle/INEC in Killarney for what is possibly the most popular event of the year!

    Find Hotels, Flights & More       View Complete Schedule  

Friday 18th - Sunday 20th October, 2024

The Siege of Clonmel 2

The Talbot Hotel, Poppyfield Retail Park, Cahir Rd, Ballingarrane South, Clonmel, Co. Tipperary, E91 X0N7, Ireland

Main Event Buy-In: €170 + €30

Festival Guarantee: €100,000

    Find Hotels, Flights & More       View Complete Schedule  

Friday 15th - Sunday 17th November, 2024

Dublin Winter Festival

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

Buy-in: €260+€40

    Find Hotels, Flights & More       View Complete Schedule  

Friday 27th - Sunday 29th December, 2024

Irish Poker Tour Final

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

Buy-in: €170+€30

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 2nd - Sunday 5th January, 2025

Galway Poker Festival 2025

The Galmont Hotel, Lough Atalia Rd, Galway, H91 CYN3, Ireland

Buy-In:€700 

Festival Guarantee of €500,000

Check back for full schedule. 

    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.