0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0078 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-30'
AND `url` = 'https://www.maineventtravel.com/news/article/Luxon-Pay-Irish-Open-Booking-Promotion-Extended-to-8th-March'
ORDER BY `views` DESC

0.0091 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-30'
AND `url` = 'https://www.maineventtravel.com/news/article/Luxon-Pay-Irish-Open-Booking-Promotion-Extended-to-8th-March'

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.0004 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.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` = '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.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.0071 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.0041 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.0093 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.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` = '16'
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.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` = '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.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` = '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.0178 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.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.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.0045 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.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.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` = '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.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.0045 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.0012 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.0032 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.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.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.0235 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.0012 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.0053 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.0122 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` = 'Luxon-Pay-Irish-Open-Booking-Promotion-Extended-to-8th-March'

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

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

0.0002 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%article%'
English
  1. Home
  2. News & Blogs
  3. Luxon Pay Irish Open Booking Promotion Extended to 8th March
Monday 4th March, 2024

Luxon Pay Irish Open Booking Promotion Extended to 8th March

By Kelly Saxby
Live Events Main Event Travel News

EXTENDED TO MIDNIGHT 8TH MARCH

Book any Pre-paid Hotel between now and midnight Friday March 8th UTC for 4 nights or more using Luxon Pay at checkout to stay in Dublin during the Irish Open, and we’ll give you 5% back in future travel credit.

If you've waited until the 11th hour to book your Irish Open accommodation, don't worry, MainEventTravel.com has you covered! 

Whether you crave proximity to the Dublin party scene, seek respite from bad beat stories off the felt, prefer budget-friendly options, or you never make it to breakfast anyway so there’s no sense paying for it, MET has great offers for you on Hotels near RDS and throughout Dublin

Visit MET’s Irish open Event page and search using Pay Now Hotels. You’ll find nightly rates that are better than most other online travel agencies AND you can snag a Bonus Travel Credit!

Below are some of the handpicked hotels scattered across Dublin that we recommend you consider. And don’t forget MET’s exclusive added value #FinalTableFreeroll promotion, where you can win back up to 100% of your Tournament travel costs booked with MET!

Butlers Townhouse – 4 Star – 0.45miles from RDS – From €175 per night

Butlers Townhouse is an elegant boutique hotel located in the heart of Ballsbridge. The 20-bedroom Victorian townhouse has been tastefully restored to its former glory. The boutique hotel offers a cozy and intimate atmosphere, featuring individually designed bedrooms giving the guest a unique taste of Victorian life.

Hilton Dublin – 4 Star – 1.22miles from RDS – From €187 per night

Nestled in the heart of Ireland's vibrant capital city, Hilton Dublin stands as a beacon of modern luxury and sophistication. This contemporary hotel seamlessly blends timeless elegance with cutting-edge design, offering a haven for poker travellers. Boasting stylishly appointed rooms and suites, each with stunning views of the city or the Grand Canal, guests are treated to a truly immersive experience. Whether you're getting involved in all the action at the RDS Arena, or simply unwinding in the hotel's leisure facilities after a couple of busy days on the felt, Hilton Dublin promises an unforgettable stay where Irish hospitality meets global excellence.

Marlin Hotel Stephen Green – 4 Star – 1.68miles from RDS – From €180 per night

The contemporary 300–room Marlin Hotel Stephen Green is situated in an unbeatable location. Located overlooking the iconic St. Stephen's Green, the hotel offers a prime location for poker players looking for the excitement of the Irish Poker Open. From cosy rooms to lounge-inspired spaces to work and socialise including their outdoor terrace, the Marlin Hotel offers a perfect place to work, rest and play.

Clayton Hotel Burlington Road – 4 Star - 0.85miles from RDS – From €153 per night

The hotel is located just a short distance away from the many attractions that this historical city has to offer. The RDS Arena is within walking distance of the hotel or take advantage of the transport links close to the hotel. This wonderful hotel enjoys a charming architectural design, blending effortlessly with its culturally rich surroundings. The guest rooms are beautifully designed, offering a cocoon in which to escape the bustle of the city that lies just outside. The hotel features 2 wonderful restaurants, where delectable dining is just waiting to be enjoyed.

Clayton Hotel Leopardstown – 4 Star – 4miles from RDS - €138 per night

As part of the Clayton Hotels group, this establishment offers modern simplicity with a traditional twist. The spacious and superbly appointed en-suite rooms include satellite TV, a safe, and tea and coffee making facilities, ensuring a blend of modern amenities and traditional hospitality. With the great transport links that Dublin has to offer, it will make travel to and from the excitement of the Irish Poker Open easily accessible!


Clayton Hotel Liffey Valley – 4 Star – 7.38miles from RDS - €134 per night

This charming and elegant hotel is situated in the suburbs of Dublin, with good public transport and road links to the city centre and the RDS Arena. Guest rooms are tastefully appointed and take care of the utmost details. They are individually decorated and exude an elegant and enchanting atmosphere that guarantees poker travellers will enjoy a pleasant stay.

Russell Court – 3 Star – 1.54miles from RDS - €139 per night

Behind the traditional exterior of the Russell Court Hotel lies a labyrinth of bars, nightclubs, private function rooms, and Dublin’s award-winning best beer garden. The hotel has 40 beautifully styled guest bedrooms and has been able to retain all its stunning Georgian charm whilst incorporating Dublin’s trendiest nightlife experience. The hotel is home to the infamous Dicey’s Garden but also is home to two nightclubs – Krystle Nightclub and the over 30’s Bond! Russell Court Hotel is very much made for guests looking to enjoy all the opportunities of the Irish Poker Open whilst enjoying the bustling nightlife that Dublin has to offer.

Harcourt Hotel – 3 Star – 1.48miles from RDS - €148 per night

Formerly the home of George Bernard Shaw, the hotel is situated off the southwest of St. Stephen’s Green. Located on the lively Harcourt Street, this boutique hotel seamlessly blends historic charm with modern comfort. Harcourt Hotel is not just a place to rest; it's a destination with a lively atmosphere. With a variety of bars, including the renowned DTWO Bar, Garden and Club, the hotel is a hotspot for entertainment, ensuring a memorable nightlife experience. Just steps away from Dublin's cultural landmarks and nightlife attractions, Harcourt Hotel invites any poker travellers to discover the rich tapestry of the city while enjoying the distinctive warmth of Irish hospitality.

Crowne Plaza Dublin Blanchardstown – 4 Star – 8.01miles from RDS - €131 per night

Discover contemporary luxury at Crowne Plaza Dublin Blanchardstown, a sophisticated haven in the heart of Dublin's thriving business and leisure district. This modern hotel seamlessly combines upscale comfort with cutting-edge design, catering to the needs of discerning travelers. Stylishly appointed rooms and suites provide a serene retreat, complemented by state-of-the-art amenities.

Crowne Plaza Dublin Airport - 4 Star – 5.34miles from RDS - €124 per night

Situated close to Dublin International Airport, this hotel is a fantastic option for anyone who is flying into Dublin to be close to the action of the Irish Poker Open. From the hotel, it is only a 15 minute drive into the city centre and to all the excitement on the felt. Overlooking the 85-acre Santry Demesne, the hotel is in the perfect spot away from the hustle and bustle of the city centre, and can enjoy the first glimpses of spring.

Hilton Dublin Airport – 4 Star – 5.61miles from RDS - €144 per night

Hilton Dublin Airport is a contemporary 4-star hotel just 20 minutes from Dublin city centre with convenient access to Dublin Airport. The hotel offers a relaxing atmosphere for guests to unwind whilst delivering all of the required business facilities for a top-class experience. Choose from a variety of guest rooms, including upgraded deluxe rooms, family rooms, and suites. Large soundproof windows offer plenty of light without any noise and a choice of thoughtful amenities are available, including WiFi access, a work desk, a laptop safe, and a large flat-screen TV.

Pembrooke Townhouse – 4 Star – 0.5miles from RDS - €195 per night

Included in the Michelin Guide and chosen as ‘One of the top 100 places to stay in Ireland’, this boutique townhouse offers a unique blend of historical elegance and contemporary comfort. Individually designed rooms and suites provide a cozy retreat, featuring a harmonious mix of modern amenities and classic decor. Pembrooke Townhouse's central location invites poker travellers to explore Dublin's iconic attractions, cultural landmarks, and vibrant neighborhoods on foot.

Grand Canal – 4 Star – 0.81miles from RDS – From €192 per night

Located in the heart of the city centre and next to the Grand Canal, the hotel offers an ideal base for exploring all that Dublin has to offer. Situated close to the RDS arena, it is within walking distance of all the excitement of the Irish poker open. the hotel boasts a prime location to great transport links making it easy to get around the city. The hotel has spacious and modern bedrooms that cater to all needs.

Book your 4 night+ Hotel stay during Irish Open before midnight on March 8th using Luxon Pay at checkout, and we’ll give you 5% back in future travel credit.

Ts & Cs apply.

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.