0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-03-31'
AND `url` = 'https://www.maineventtravel.com/destination/articles/dublin-destination-guide/Irish-Poker-Open-2025-Europes-Longest-Running-Poker-Festival-Returns-April'
ORDER BY `views` DESC

0.0034 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/dublin-destination-guide/Irish-Poker-Open-2025-Europes-Longest-Running-Poker-Festival-Returns-April', 1, '2025-03-31')

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.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.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0037 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 `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.0002 SECONDS: 
SELECT destinations.*, uapi_airports.name as airport_name
FROM `destinations`
LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code`
WHERE `url` = 'dublin-destination-guide'

0.0016 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 `url_name` = 'Irish-Poker-Open-2025-Europes-Longest-Running-Poker-Festival-Returns-April'

0.0002 SECONDS: 
SELECT `news_categories`.*
FROM `news_article_categories`
LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id`
WHERE `news_article_categories`.`news_article_id` = '1078'

0.0039 SECONDS: 
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(53.3498053 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(53.3498053 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-6.2603097 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo
FROM `venues`
LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id`
JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
WHERE `tour_stops`.`active` = '1'
AND tour_stops.end_date > CURDATE()
HAVING `distance` <= 10
ORDER BY `tour_stops`.`start_date` ASC

0.0002 SECONDS: 
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title`
FROM `news_article_destinations`
JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id`
WHERE `news_articles`.`active` = 1
AND `destination_id` = 6
ORDER BY `news_article_destinations`.`display_order`
English
  1. Home
  2. Destination Guide - Dublin
  3. Irish Poker Open 2025: Europe’s Longest-Running Poker Festival Returns
Sunday 12th January, 2025

Irish Poker Open 2025: Europe’s Longest-Running Poker Festival Returns

By Antonia Shepherd
Live Events News

The highly anticipated Irish Poker Open 2025 is set to take place from 10th to 21st April at the Royal Dublin Society (RDS), Dublin. Renowned for its vibrant atmosphere and prestigious history, the event is expected to draw poker enthusiasts from around the globe, all vying for their share of fame and fortune.

This year’s festival boasts an impressive schedule of events, culminating in the €1,150 Main Event, which starts on 13th April. Known for its large fields and spirited competition, the Main Event will see players compete for a significant prize pool and the honour of becoming the next Irish Poker Open champion.

The festival also features a variety of side events catering to all bankrolls and preferences. Highlights include the €5,000 High Roller, the popular €250 Mini Irish Open, and a range of Omaha, mixed games, and turbo tournaments.

Plan Your Trip with MainEventTravel

For players travelling to Dublin, MainEventTravel is the Official Travel Partner for the Irish Poker Open 2025. With a seamless booking experience, they offer deals on accommodations near the Royal Dublin Society, ensuring you stay close to the action. Whether you're looking for luxury hotels or budget-friendly options, MainEventTravel has packages tailored to suit every player's needs.

In addition to accommodation, MainEventTravel provides assistance with flights, making it easy for players and fans to plan their journey. Their dedicated team ensures a hassle-free experience, allowing you to focus on enjoying the festival and competing on the felt.

A Legacy of Excellence

Established in 1980, the Irish Poker Open holds the distinction of being Europe’s longest-running poker tournament and the second-oldest in the world. The 2025 edition continues the tradition of blending elite poker competition with a unique atmosphere, making it a must-attend event on the poker calendar.

Join the Celebration

Don’t miss your chance to be part of poker history at the Irish Poker Open 2025. Whether you’re a seasoned pro or a recreational player, the festival promises unforgettable moments both on and off the felt. Book your trip today with MainEventTravel and get ready for an unforgettable poker experience in Dublin.

Photo Credit - Irish Poker Open

What's Hot in Dublin

Irish Poker Open 2025: Europe’s Longest-Running Poker Festival Returns The highly anticipated Irish Poker Open 2025 is set to take place from 10th to 21st April at the Royal Dublin Society (RDS), Dublin. Renowned for its vibrant atmosphere and prestigious history, the event is expected to draw poker enthusiasts from around the globe, all vying for their share of fame and fortune.
Top Hotels Near the RDS Arena for the Irish Open The Irish Open is one of Europe’s most prestigious poker tournaments, bringing players and fans from across the globe to Dublin’s RDS Arena. If you’re planning to attend, securing the right accommodation is key to a smooth and enjoyable experience. To help with your travel plans, we’ve handpicked five top hotels near the venue—offering comfort, convenience, and great amenities.
Sightseeing in Dublin Dublin is an ideal destination for a city break – there is tons to do and your main problem will be how to cram it all in! However, Dublin is a very manageable city and it’s easy to get around on foot, or you can get a day ticket for the hop-on hop-off buses which pass by most of the main attractions.

Events

Travel Search

Travel Search

Search for
Dates
From
To
Flying to Dublin Arpt (DUB)
Departing from
Passengers
Adults
Children
Staying in Dublin
Rooms
Guests
Adults
Children
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.