0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-05-02' AND `url` = 'https://www.maineventtravel.com/news/article/MET-Offers-Best-Rates-Available-For-2024-Irish-Open-Hotels-and-Packages' ORDER BY `views` DESC

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/MET-Offers-Best-Rates-Available-For-2024-Irish-Open-Hotels-and-Packages', 1, '2024-05-02')

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.0002 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.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.0063 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.0036 SECONDS:
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date FROM `news_categories` JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` GROUP BY `news_categories`.`id`

0.0080 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '11' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0048 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '16' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0037 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '18' AND `news_articles`.`active` = 1 ORDER BY `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'

0.0034 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '19' AND `news_articles`.`active` = 1 ORDER BY `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'

0.0054 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '22' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0042 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '23' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0044 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '27' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0144 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '28' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0040 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '29' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0125 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '30' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

0.0064 SECONDS:
SELECT `news_articles`.* FROM `news_articles` LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id` WHERE `news_article_categories`.`news_category_id` = '31' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

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

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` = 'MET-Offers-Best-Rates-Available-For-2024-Irish-Open-Hotels-and-Packages'

0.0008 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 `date` <= '2024-05-02' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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

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

0.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Monday 8th January, 2024

MET Offers Best Rates Available For 2024 Irish Open Hotels & Packages

By Kelly Saxby

Following the record-breaking success of the 2023 Irish Open in its new home at the historic Royal Dublin Society in Ballsbridge, Dublin, the festival returns for eight-days from March 25 to April 1 2024 and features a €1 million guaranteed Main Event and a €200 buy-in Mini Irish Open with €500,000 guarantee.

As OTP once again for 2024, MainEventTravel.com is offering amazing rates on Hotel +  Buy-in Packages PLUS SOME OF THE BEST RATES AVAILABLE ONLINE AT THESE FEATURED HOTELS:

MET has fantastic Pre-paid and Pay When You Stay rates at loads of Hotels dotted around Dublin, and players can book their Accommodation, Flights, and Buy-ins all in one place. Book today to get the best rates!

Don’t forget booking with MET means you can get involved in our #FinalTableFreeroll promotion where you can win back up to 100% of Tournament Travel booked with MET.

The Clayton Ballsbridge - 4* - 0.21 miles to RDS - starting from €179 per night B&B

A stone's throw from the RDS, the hotel is a traditional four-star nestled in the heart of Dublin's gorgeous Ballsbridge district that has been restored to the highest standards with spacious rooms (pictured below). Amenities include the newly launched Grandstand Bar & Restaurant where a traditional fry-up awaits you or the Vitality Breakfast Selection if you’re after a less carb-heavy option.

Sandymount Dublin - 4* - 0.46 miles to RDS - starting from €166 per night B&B

A hidden gem, known for its long and breezy beach and beautifully landscaped gardens, providing idyllic walks. Sandymount Hotel was awarded 4-star status in 2017 after an €8 million refurbishment including the upgrade of bedrooms (pictured below), the Line Out Bar, and Whitty’s Restaurant and outdoor terrace. Buffet-style breakfast featuring a full Irish and continental, and room service available. 

Head to MET's Irish Open 2024 Event Page today to book these amazing rates while they are available!! 

Herbert Park - 4* - 0.15 miles to RDS

A fantastic four-star hotel (pictured below) that lies close to the main entrance of the RDS and overlooks a magnificent 48-acre park. It’s the perfect place to relax after a hard day at the poker tables with facilities that include a bar, restaurant, coffee shop and fully-equipped fitness centre.

The Intercontinental Dublin - 5* - 0.17 mile to RDS

Located on two acres of gardens, InterContinental Dublin is the capital's only true five-star urban resort (pictured below) where traditional luxury meets old-school glamour. The InterContinental is only a short stroll away from the RDS Arena and all the action on the felt. 

 

Pembroke Townhouse - 4* - 0.50 mile to RDS

Pembroke Townhouse is 4-star Guesthouse (pictured below) located in the heart of Dublin’s Georgian district, Ballsbridge. Impeccably restored in 2019 & attentively staffed, they continue to merge traditional Georgian elegance with contemporary style to create a Townhouse with its own unique, welcoming personality. 

 

Hilton Dublin - 4* - 1.22 miles to RDS

Overlooking the Grand Canal in Dublin’s city centre, Hilton Dublin (pictured below) is located less than 1.5 miles from the RDS Arena. The Charlemont tram stop is a two-minute walk, providing easy access to sights, shops, concerts, and the action on the felt. They offer indoor secure car parking, event space, a restaurant and bar, a fitness centre, and free WiFi.

 

Staycity Dublin Mark Street - 3* - 1.53 miles to RDS 

The Staycity aparthotel (pictured below) is bang smack in the centre of the action, brushing up next to the historic Trinity College and just around the corner from the National Gallery. With great transport links on their doorstep, it makes it easy to travel to the RDS Arena for all the excitement of the Irish Poker Open.

 

3* Russell Court starting from €129 per night 

Steeped in History and Georgian charm, Harcourt street is now home to Dublin’s liveliest and trendiest bars and nightclubs. The hotel boasts 40 beautifully styled guest bedrooms while incorporating Dublin’s trendiest nightlife experience. The Russell Court Hotel (pictured below) is under 2 miles from the action but is located in the heart of Dublin's nightlife.

Staycity City Quay - 3* - 1.6 miles to RDS

The super-central aparthotel (pictured below) boasts views across the famous River Liffey. Just up the road from Trinity College and close to Dublin's City Centre, it is a great hotel to mix both poker and sightseeing. 

 

MainEventTravel.com also has FANTASTIC deals on  Special Offer Buy-in + Accommodation Packages for the Irish Open. Head to the website to book one of 8 Special Offer Packages today! 

Advance Buy-ins

In addition to providing packages, hotels, and flights, MainEventTravel.com will also has Buy-ins available for purchase online, saving you exchanging and carrying loads of currency in advance of your trip. Register for the Main Event, the Mini Irish Open, the High Roller, the PLO Mystery Bounty, the Ladies, the Seniors, the Liam Flood Memorial, THMC and more. 

#FinalTableFreeroll 

The Irish Open Main Event is one of the many #FinalTableFreeroll Eligible Events in 2024 PLUS as OTP  we have added ALL MULTI-DAY SIDE EVENTS to this list including:

  • Mini Irish Open
  • High Rollers
  • PLO 6-Max
  • JP Poker Masters
  • PLO Mystery Bounty 8 Max

View the full list of eligible events #FinalTableFreeroll

To get involved simply book your VIP Package, Hotel or Flights with MET, tag @MainEventTravel using #FinalTableFreeroll on socials, and you’ll be in with a shot to win back up to 100% of your Tournament Travel! There is no additional cost to enter. 

Kelly Saxby, MET Retail Sales & Marketing Consultant, said: “#FinalTableFreeroll is a truly massive promotion, and we hope to see MainEventTravel awarding players thousands in travel credit this year. This promotion means your entire travel expense could be on us, making you a winner both on and off the table. You are booking poker travel anyway, so why not do it with a provider that gives you an opportunity to win back up to 100% of your Tournament Travel.”

Bespoke Poker Travel

MET is the Poker Travel site created by Poker Players who know what matters to you! Looking for a bespoke travel package? Want more nights added to a package? Email irishopen@maineventtravel.com with your requirements and we can create a travel package tailored to you!

Semi-professional poker player and MainEventTravel Managing Director Fraser MacIntyre, said: “We are absolutely delighted once again to be the Official Travel Partner to Europe’s longest-running, most prestigious and lively poker festival. We look forward to assisting every player making their way to Dublin with all their travel needs!  

The Irish Open

The 2023 Irish Open Main Event was the biggest poker tournament ever held in Ireland and attracted a staggering 2,491 entries. The prize pool more than double the guarantee at €2,428,725 and players were awarded more than €4.5 million in prize money across the whole festival.

The Irish Open – the longest-running No Limit poker tournament in Europe – is a hugely popular event and a mainstay of the European poker calendar. Thousands attend the event every year and past Main Event champions include the likes of James Mitchell, Kevin Vandersmissen, Ian Simpson, Patrick Clarke, Griffin Benger, Steve O’Dwyer and – most recently – Scottish poker wiz and UKIPT Player of the Year 2023, David Docherty.

The €1,000,000 guaranteed Main Event, coupled with legendary Dublin hospitality, makes the Irish Open a truly unmissable event. Since it was first held back in 1981, the event is now the longest-running No Limit Texas Hold’em poker tournament in the world after the World Series of Poker. The festival has become a must-attend stop on the international poker circuit for players from as far afield as Australia, Canada and the USA – and provides craic on a level seen nowhere else in the world.

Full schedule available here.

Photo Credit: Irish Open

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.