0.0239 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0133 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-23' AND `url` = 'https://www.maineventtravel.com/venue/rds-royal-dublin-society' LIMIT 1

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `date`, `views`) VALUES ('https://www.maineventtravel.com/venue/rds-royal-dublin-society', '2024-02-23', 1)

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

0.0003 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.0007 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.0123 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 * FROM `venues` WHERE `id` = 'rds-royal-dublin-society'

0.0007 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'rds-royal-dublin-society'

0.0020 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_stops`.`venue_id` = '12' ORDER BY `tour_stops`.`start_date` ASC

0.0552 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.0019 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.0008 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

English

RDS (Royal Dublin Society)


The chosen venue for the Irish Poker Open 2024 is the Royal Dublin Society (RDS). Located in the heart of Dublin City within walking distance of hotels, restaurants and bars, the RDS is synonymous with its 160,000 m2 campus in BallsbridgeDublinIreland. The premises include the ‘RDS Arena’, ‘RDS Simmonscourt’, ‘RDS Main Hall’ and other venues which are used regularly for exhibitions, concerts and sporting events like the Dublin Horse Show or as playground for the Leinster Rugby team.


Upcoming Events at this Venue

Monday 25th March - Monday 1st April, 2024

Irish Poker Open

Irish Poker Open 2024

As the Official Travel Partner of the Irish Open 2024 MET Offers Best Rates Available on Dublin Hotel & Packages

The Irish Poker Open is the longest-running No Limit Hold’em tournament outside of Vegas and the oldest in Europe with a history going back more than 43 years. The Irish Poker Open is considered an absolute must on the international poker calendar and always attracts a stellar crowd. 2023 seen the biggest event in Irish History with PokerStars qualifier David Docherty taking home a first prize of €365,000 topping the 2,491 entries and almost €2,500,000 prizepool.

Mini Irish Open: March 25-April 1 - €200 (€500,000 GTD)

Irish Open High Roller: March 26-27 - €5,000

Irish Open Main Event: March 27-April 1 - €1,150 (€1,000,000 GTD)

Irish Open High Roller: March 30-31 - €3,000

Irish Open PLO Mystery Bounty: March 30-31 - €1,100

Irish Open Mystery Bounty: March 31-April 1 - €1,100

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

Major Events
March 2024
Mon 25th Event 1: Irish Open €350 NLH 6-Max at RDS (Royal Dublin Society) Buy In: €310 + €40.00
Mon 25th Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/A at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Mon 25th Event 4: €550 PLO Mystery Bounty 8 Max at RDS (Royal Dublin Society) Buy In: €500 + €50.00
Tue 26th Event 6: €250 THMC The Hendon Mob Championship at RDS (Royal Dublin Society) Buy In: €215 + €35.00
Tue 26th Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/B at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Tue 26th Event 8: €5,000 HighRoller 8-Max at RDS (Royal Dublin Society) Buy In: €4750 + €250.00
Wed 27th Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Day 1/A at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Wed 27th Event 13: €350 America's Cup at RDS (Royal Dublin Society) Buy In: €310 + €40.00
Wed 27th Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/C at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Wed 27th Event 15: Championship Event - €350 PLO 6-Max at RDS (Royal Dublin Society) Buy In: €310 + €40.00
Thu 28th Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Day 1/B at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Thu 28th Event 18: €250 Irish Open Ladies Event at RDS (Royal Dublin Society) Buy In: €215 + €35.00
Thu 28th Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/D at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Thu 28th Event 20: €550 Mystery Bounty at RDS (Royal Dublin Society) Buy In: €500 + €50.00
Fri 29th Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Day 1/C at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Fri 29th Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Day 1/D at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Sat 30th Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/E at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Sat 30th Event 26: €550 JP Poker Masters at RDS (Royal Dublin Society) Buy In: €500 + €50.00
Sat 30th Event 27: €3,000 HighRoller 8-Max at RDS (Royal Dublin Society) Buy In: €2750 + €250.00
Sat 30th Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/F at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Sat 30th Event 28: €1,100 PLO Mystery Bounty at RDS (Royal Dublin Society) Buy In: €1000 + €100.00
Sun 31st Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/G at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Sun 31st Event 29: €1,100 NLH Mystery Bounty at RDS (Royal Dublin Society) Buy In: €1000 + €100.00
Sun 31st Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/H at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Sun 31st Event 2: Mini Irish Open €200 - €500,000 GTD Day 1/I at RDS (Royal Dublin Society) Buy In: €170 + €30.00
Sun 31st Event 30: €1,100 PLO at RDS (Royal Dublin Society) Buy In: €1000 + €100.00
April 2024
Mon 1st Event 31: €250 Irish Open Seniors Event at RDS (Royal Dublin Society) Buy In: €215 + €35.00
Mon 1st Event 32: €550 PLO 6-Max at RDS (Royal Dublin Society) Buy In: €500 + €50.00
Mon 1st Event 33: €1,100 NLH Turbo at RDS (Royal Dublin Society) Buy In: €1000 + €100.00
Mon 1st Event 34:€350 Liam Flood Memorial 6-Max Turbo Event at RDS (Royal Dublin Society) Buy In: €310 + €40.00
Mon 1st Event 35: €150 NLH Turbo at RDS (Royal Dublin Society) Buy In: €135 + €15.00
May 2024
Wed 1st Event 5: Championship Event - €350 NLH Heads-Up at RDS (Royal Dublin Society) Buy In: €0 + €0.00
Wed 1st Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Day 2 at RDS (Royal Dublin Society) Buy In: 0 + 0.00
Wed 1st Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Day 3 at RDS (Royal Dublin Society) Buy In: 0 + 0.00
Wed 1st Event 11: Irish Open €1,150 Main Event - €1,000,000 GTD Final at RDS (Royal Dublin Society) Buy In: 0 + 0.00
Wed 1st Event 2: Mini Irish Open €200 - €500,000 GTD Final at RDS (Royal Dublin Society) Buy In: 0 + 0.00
    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Get the Hotel Lowdown for GUKPT Blackpool 10th - 17th March

With just a couple of weeks before the GUKPT kicks off in the popular Lancashire seaside resort of Blackpool, now is the time to book!

Last Chance to Book Exclusive, Deeply Discounted Rooms at Clayton Ballsbridge for Irish Open

MET still has a few rooms available for Irish Open players at an exclusive, discounted rate of €179 per night Single B&B and €189 per night Double B&B.
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.