0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0071 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/news/article/With-Six-Weeks-to-go-NOW-is-the-Time-to-Book-IrishOpen-Hotels-'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/With-Six-Weeks-to-go-NOW-is-the-Time-to-Book-IrishOpen-Hotels-', 1, '2024-12-22')

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.0003 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.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.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.0036 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.0042 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.0077 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.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.0004 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.0036 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.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.0004 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.0030 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.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.0031 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.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.0046 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.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.0035 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.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.0038 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.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.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.0036 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.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.0004 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.0029 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.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.0070 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.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.0004 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.0049 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.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.0019 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` = 'With-Six-Weeks-to-go-NOW-is-the-Time-to-Book-IrishOpen-Hotels-'

0.0006 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-12-22'
AND `news_articles`.`active` = '1'
ORDER BY `DATE` DESC, `id` DESC
 LIMIT 5

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.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` = '964'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%article%'
English
  1. Home
  2. News & Blogs
  3. With Six Weeks to go Now is the Time to Book Irish Open Hotels!
Friday 16th February, 2024

With Six Weeks to go Now is the Time to Book Irish Open Hotels!

By Kelly Saxby
Live Events Main Event Travel News News

With just 6-weeks to go before one of the most prestigious and historic festivals in the world kicks off, now is the time to get your Irish Open Hotel booked (and your Flights if you haven't yet!!) 

The festival returns to RDS 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 Travel Partner to Irish Open, MET is offering amazing rates on Hotels from €117 per night, and Hotel + Buy-in Packages from  €1089!

4* Clayton Hotel Ballsbridge starting from €179 per night B&B

Select Pay Now on the Hotel search for this price OR purchase as part of a package...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.

4* Sandymount Hotel starting from €166 per night B&B

Select Pay Hotel and click on the Sandymount in the results to get the best price!! 

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.

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 in all Irish Open Multi-Day events!

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

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 from €215 per night B&B

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.

easyhotel Dublin - 2* - 2.56 miles to RDS from only €119 per night room only 

Cheap and cheerful option located in Dublin City Centre (below) 

Rusell Court - 3* - 1.56 miles to RDS from only €129 per night room only 

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.

PLUS

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.

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. 

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

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