0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0096 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-04-02' AND `url` = 'https://www.maineventtravel.com/venue/rds-royal-dublin-society' ORDER BY `views` DESC

0.0124 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-04-02' AND `url` = 'https://www.maineventtravel.com/venue/rds-royal-dublin-society'

0.0004 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.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.0004 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.0055 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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'rds-royal-dublin-society'

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

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

0.0150 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.0012 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.0007 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)


Best known as Ireland's premier venue, the Royal Dublin Society (RDS) is the chosen venue for the Irish Poker Open

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

Thursday 10th - Monday 21st April, 2025

Irish Poker Open

Irish Poker Open 2025

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.

Major Events
April 2025
Sun 13th Irish Open Main Event Day 1A at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Wed 16th Irish Open Main Event Day 1B at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Thu 17th Irish Open Main Event Day 1C at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Fri 18th Irish Open Main Event Day 1D at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
Fri 18th Irish Open Main Event Day 1E at RDS (Royal Dublin Society) Buy In: €1000 + €150.00
    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Starts This Week! Last-Minute Rooms for the Irish Open

The highly anticipated Irish Open kicks off this week, and if you haven’t sorted your accommodation yet, don’t worry—there are still last-minute rooms available!

Top Hotels for the WSOP 2025: 2 Months to Go – Have You Booked Yet? Lock in the Best Rates Today!

The World Series of Poker (WSOP) is just two months away, and if you haven’t already secured your accommodation, now is the time to act! The WSOP is one of the most prestigious poker events in the world, drawing thousands of players and fans to Las Vegas for weeks of thrilling action.
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.