0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0089 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-16' 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.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.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.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.0006 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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'irish-poker-tour'

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

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

0.0016 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.0102 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 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

    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.