0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0095 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-06-02' 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.0041 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.0003 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.0015 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.0069 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%'

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

Friday 20th - Sunday 22nd June, 2025

Northern Poker Festival

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

Main Event Buy-In of €300 with a Festival Guarantee of €100,000. 

    Find Hotels, Flights & More       View Complete Schedule  

Saturday 05 July, 2025

Portlaoise €30k in a Day

The Killeshin Hotel, Dublin Rd, Ballyroan, Portlaoise, Co. Laois, R32 TYW7, Ireland

Main Event Buy-In - €170+€30

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd - Sunday 27th July, 2025

Summer in Dublin

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

€300 Main Event with Festival Guarantee of $250,00+

    Find Hotels, Flights & More       View Complete Schedule  

Saturday 16 August, 2025

Athlone €30k in a Day

Athlone Springs Hotel, R362, Monksland, Athlone, Co. Roscommon, N37 F9T3, Ireland

Festival Guarantee - €30,000

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 21st - Sunday 24th August, 2025

Galway Summer Festival

The Eglinton Casino, Eglinton Court, Eglinton Street, Galway, Co. Galway, H91 XF3X

Main Event Buy-In of €170 + €30 with a festival guarantee of €55,000

    Find Hotels, Flights & More       View Complete Schedule  

Monday 1st - Sunday 7th September, 2025

Sunny Beach Bulgaria

Platinum Casino, Sunny Beach, Bulgaria

More details to follow. 

Festival Guarantee - €200,000+

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Saturday 06 September, 2025

Limerick €40k in a Day

The Castletroy Park Hotel, University Gates, Dublin Rd, Limerick, Ireland

Main Event Buy-In: €170+€30

    Find Hotels, Flights & More       View Complete Schedule  

Friday 12th - Sunday 14th September, 2025

Donegal Poker Festival

Radisson Blu Hotel, Letterkenny, Paddy Harte Rd, Letterkenny, Co. Donegal, F92 FK15, Ireland

€300 Main Event with a Festival Guarantee of €100,000.

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 23rd - Sunday 28th September, 2025

The Killarney Festival 2025

Gleneagle Hotel, Muckross Road, Killarney, Kerry, Ireland

Main Event Buy-In €700 with a festival guarantee of €900,000.

    Find Hotels, Flights & More       View Complete Schedule  

Friday 17th - Sunday 19th October, 2025

Siege of Clonmel IV

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

More details coming soon. 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 4th - Sunday 9th November, 2025

London Poker Festival

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

Main Event Buy-In: £355+£45

Festival Guarantee - £350,000+

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 26th - Sunday 30th November, 2025

Dublin Winter Festival

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

Main Event Buy-In: €215+€35

    Find Hotels, Flights & More       View Complete Schedule  
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.