0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0111 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-28' AND `url` = 'https://www.maineventtravel.com/event/irish-poker-open-2023' ORDER BY `views` DESC

0.0021 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/event/irish-poker-open-2023', 1, '2024-03-28')

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

0.0003 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.0003 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.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.0007 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.0004 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.0009 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.0115 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 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-2023'

0.0043 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-2023'

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

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

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

0.0013 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1233'

0.0021 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1233'

0.0012 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1209'

0.0020 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1209'

0.0012 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1210'

0.0019 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1210'

0.0012 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1211'

0.0019 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1211'

0.0012 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1212'

0.0019 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1212'

0.0012 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1234'

0.0019 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1234'

0.0011 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1235'

0.0019 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1235'

0.0011 SECONDS:
SELECT * FROM `buy_ins` WHERE `event_id` = '1237'

0.0019 SECONDS:
SELECT * FROM `events` WHERE `shared_inventory_event_id` = '1237'

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.0120 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.0013 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.0006 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.0008 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` = 1781 AND `packages`.`active` = 1 ORDER BY `packages`.`special_price` ASC

0.0005 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
Mon 3rd - Mon 10th April, 2023

Irish Poker Open 2023

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

This year the Irish Open has a new home at the RDS in Ballsbridge, Dublin. Still offering the same great tournaments and the world-renowned 'craic', this series of events needs to be in your diary.

We have hotels close by the venue that are available at special rates you won't find anywhere else. 

Jump to...

Travel Search

Major Events

Tue
4
€5,000 HighRoller 8-Max Day RDS (Royal Dublin Society) €4800 + €200.00 Offline Registration Only
Wed
5
Irish Open Main Event Day 1A RDS (Royal Dublin Society) €1000 + €150.00 Offline Registration Only
Thu
6
Irish Open Main Event Day 1B RDS (Royal Dublin Society) €1000 + €150.00 Offline Registration Only
Fri
7
Irish Open Main Event Day 1C RDS (Royal Dublin Society) €1000 + €150.00 Offline Registration Only
Fri
7
Irish Open Main Event Day 1D - Turbo RDS (Royal Dublin Society) €1000 + €150.00 Offline Registration Only
Sat
8
Irish Open €3,000 HighRoller 8-Max RDS (Royal Dublin Society) €2750 + €250.00 Offline Registration Only
Sun
9
€1,100 NLH Mystery Bounty 8-Max (2 day event) RDS (Royal Dublin Society) €1000 + €100.00 Offline Registration Only
Mon
10
€1,100 NLH Mystery Bounty 8-Max (1 day event) RDS (Royal Dublin Society) €1000 + €100.00 Offline Registration Only
   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.