0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0150 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-10-09' 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.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.0003 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.0001 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'rds-royal-dublin-society'

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

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

0.0069 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'

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 26th March - Monday 6th April, 2026

Irish Poker Open

Irish Poker Open 2026

Dates have been announced for 2026!

    Find Hotels, Flights & More       Full Schedule Coming Soon  
Latest News & Blogs

GUKPT Blackpool Returns: Book Your Trip with Main Event Travel

GUKPT Blackpool returns with a packed festival schedule and the £1,100 Main Event, promising another exciting stop on the Grosvenor UK Poker Tour. Players can book their stay easily through Main Event Travel, the official travel partner of Grosvenor Poker.

Plan Your Journey to the Irish Open 2026

The Irish Open 2026 is set to return as Europe’s oldest and most iconic poker festival, combining world-class tournaments with Ireland’s legendary atmosphere and hospitality. Players can book their hotels, flights, and travel arrangements easily through Main Event Travel, the official travel partner of the event.
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.