0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0078 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-24' AND `url` = 'https://www.maineventtravel.com/event/irish-poker-open-2025' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/event/irish-poker-open-2025', 1, '2024-12-24')

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.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

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.0004 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.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.0005 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.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` = 'page'

0.0039 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.0002 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, uapi_airports.name as airport_name, 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 `uapi_airports` ON `tour_stops`.`uapi_code` = `uapi_airports`.`airport_code` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`id` = 'irish-poker-open-2025'

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, uapi_airports.name as airport_name, 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 `uapi_airports` ON `tour_stops`.`uapi_code` = `uapi_airports`.`airport_code` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stops`.`page_url` = 'irish-poker-open-2025'

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

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

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

0.0009 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1558'

0.0011 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1558'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1559'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1559'

0.0007 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1560'

0.0010 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1560'

0.0008 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1561'

0.0014 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1561'

0.0010 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1562'

0.0018 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1562'

0.0003 SECONDS:
SELECT `uapi_airports`.*, `uapi_cities`.`name` as `city`, `uapi_countries`.`name` as `country` FROM `uapi_airports` JOIN `uapi_countries` ON `uapi_countries`.`country_code` = `uapi_airports`.`country_code` JOIN `uapi_cities` ON `uapi_cities`.`city_code` = `uapi_airports`.`reference_city` WHERE `airport_code` = 'DUB'

0.0093 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.0008 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.0007 SECONDS:
SELECT packages.*, currencies.name as currency_name, currencies.ISO_4217_code as currency_code, currencies.symbol as currency_symbol, hotels.name as hotel_name, hotels.main_image as hotel_image, hotels.description as hotel_description, rooms.board_extras as board_extras, rooms.room_type as room_type, rooms.max_occupancy as occupancy, tour_stops.name as tour_stop_name, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS tour_stop_logo, tours.name as tour_name, tours.logo as tour_logo FROM `packages` LEFT JOIN `currencies` ON `currencies`.`id` = `packages`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `packages`.`tour_stop_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `rooms` ON `rooms`.`id` = `packages`.`room_id` LEFT JOIN `hotels` ON `hotels`.`id` = `rooms`.`hotel_id` WHERE packages.available_until > CURDATE() AND `tour_stops`.`id` = 2574 AND `packages`.`active` = 1 ORDER BY `packages`.`special_price` 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` = 'package'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%all-events%'

English
Thu 10th - Mon 21st April, 2025

Irish Poker Open 2025

at RDS (Royal Dublin Society), RDS, Merrion Road, Ballsbridge, Dublin 4

The 2025 Irish Open is set to be the biggest and richest poker festival ever held in Ireland with an extra four days added to next year’s schedule. The Irish Open will be celebrating its 45th anniversary with a host of new events including a brand new €1,000,000 guaranteed Mystery Bounty, a new High Roller series with four €5,000 buy-in events and a €10,000 buy-in event. Additionally, there will be significantly increased guarantees for the Main Event, now at €2,500,000 and the hugely successful Mini Irish Open, with €1,000,000 guaranteed.

For the third consecutive year, the festival will be sponsored by global poker sites PokerStars and Paddy Power, giving hundreds of players the chance to qualify online. The festival is taking place at the prestigious Royal Dublin Society venue in Ballsbridge Dublin, with 12 days of non-stop poker action and off-the-felt entertainment running from April 10 to April 21.

Jump to...

Travel Search

Buy In FAQ

Major Events

Sun
13
Irish Open Main Event Day 1A RDS (Royal Dublin Society) + Buy In Now
Wed
16
Irish Open Main Event Day 1B RDS (Royal Dublin Society) + Buy In Now
Thu
17
Irish Open Main Event Day 1C RDS (Royal Dublin Society) + Buy In Now
Fri
18
Irish Open Main Event Day 1D RDS (Royal Dublin Society) + Buy In Now
Fri
18
Irish Open Main Event Day 1E RDS (Royal Dublin Society) + Buy In Now
   Download Full 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.