0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0112 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-10-27'
AND `url` = 'https://www.maineventtravel.com/destination/articles/dublin-destination-guide/Plan-Your-Journey-to-the-Irish-Open-2026'
ORDER BY `views` DESC

0.0085 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/dublin-destination-guide/Plan-Your-Journey-to-the-Irish-Open-2026', 1, '2025-10-27')

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.0005 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.0041 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.0005 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.0003 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.0018 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` = 'Plan-Your-Journey-to-the-Irish-Open-2026'

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` = '1103'

0.0042 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. Plan Your Journey to the Irish Open 2026
Tuesday 23rd September, 2025

Plan Your Journey to the Irish Open 2026

By Antonia Shepherd
Live Events Blogs

The wait is nearly over—the legendary Irish Open is set to return in 2026, and players from all over the world are already making plans to be part of Europe’s oldest and most celebrated poker festival. Known for its unique blend of thrilling competition, vibrant social atmosphere, and rich tradition, the Irish Open is more than just a poker tournament—it’s an experience that captures the very heart of the game.

For decades, the Irish Open has been the highlight of the European poker calendar, attracting both seasoned professionals and enthusiastic newcomers. With a heritage stretching back to 1980, it has established itself as the longest-running No Limit Texas Hold’em tournament in Europe and a true “bucket list” event for poker lovers. Every year, the festival combines the intensity of high-stakes action with the warm, welcoming energy that only Ireland can provide.

The 2026 edition promises to raise the bar yet again, with a packed schedule of events, side tournaments to suit every bankroll, and of course, the iconic Main Event that has produced some of the most memorable champions in the game’s history. Off the tables, players can expect lively evenings filled with music, laughter, and the unmistakable Irish craic that makes this festival unlike any other in the world.

To ensure your trip is smooth and stress-free, Main Event Travel is once again proud to be the Official Travel Partner of the Irish Open 2026. From securing the best hotel packages close to the action, to arranging flights, transfers, and full travel itineraries, Main Event Travel offers a simple and convenient one-stop service designed with poker players in mind. By booking through the Official Travel Partner, you’ll save time, avoid the hassle of managing multiple reservations, and have the reassurance that all your plans are taken care of.

Whether you’re planning your first Irish Open or returning for another unforgettable year, now is the time to make sure your calendar is clear and your plans are in place. The Irish Open is more than just a tournament series—it’s a meeting point for friends, a celebration of the game we love, and a tradition that keeps growing stronger with every year.

Mark your diaries, spread the word, and start planning your trip now. The Irish Open 2026 is coming—and you won’t want to miss a single hand. Book today with Main Event Travel, and get ready to be part of history.

What's Hot in Dublin

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.
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.