0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0054 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-26'
AND `url` = 'https://www.maineventtravel.com/news'
ORDER BY `views` DESC

0.0079 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-04-26'
AND `url` = 'https://www.maineventtravel.com/news'

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

0.0062 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.0004 SECONDS: 
SELECT COUNT(*) AS `numrows` FROM `news_articles`

0.0040 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.0069 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.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` = '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.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.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.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.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` = '22'
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.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` = '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.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` = '27'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0005 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` = '28'
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.0025 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.0139 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.0065 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.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` = '31'
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.0114 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-26'
AND `news_articles`.`active` = '1'
ORDER BY `DATE` DESC, `id` DESC
 LIMIT 30

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.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%news-blogs%'
English
  1. Home
  2. News & Blogs

Latest News & Blogs

April 2024

All change at the Vic!

With events being relocated due to refurb, MainEventTravel has your back with great accommodation options near all the Grosvenor Casinos selected.

Geraghty wins 888poker LIVE UKPL Manchester

Scottish player Jamie Geraghty has won the 888poker LIVE UKPL Manchester Main Event for the biggest cash of his live poker career. Geraghty won £30,610 after outlasting a 328-entry field – and beating Josh Radley heads-up.

Win a Portugal Adventure Package including Accommodation + Main Event!

We are so excited about the festival that MET has organised a 5-Night hotel + Buy-in Playcation Package to Giveaway! 

Book a Playcation in Portugal this Summer!

Book with MainEventTravel.com and enjoy sun, fun, and poker along a 13km stretch of pristine sands and crystal-clear waters.

Mcaulay wins GUKPT Edinburgh

Huge congratulations to Scottish player Paul Mcaulay who has won GUKPT Edinburgh for £34,110. Mcaulay, who runs a flooring company near Glasgow, beat 2022 Player of the Year Matt Davenport heads-up to secure his first major tournament victory. There were 184 entries creating a prize pool of £153,980.

It’s All About Cyprus as MET Gets Players to EAPT & MPP with Hotels, Packages, Flights, AND a Giveaway! 

MainEventTravel.com has a $2200 Value Luxon Pay Mystery Bounty Package Giveaway for you! 

The GPI Nominated Malta Poker Festival is 2 weeks away!!!

MainEventTravel.com offers exclusive VIP Packages and Room Rates, ATOL Protected Flights, Buy-ins, and Off-the-Felt Activity tickets.

MainEventTravel.com offers EAPT Cyprus & MPP Packages, Hotels & Buy-ins at the Luxurious 5* Merit Hotel & Spa

With nearly $10,000,000 in guaranteed prize pools, this event is expected to exceed all expectations and MET is here to offer players the trip of a lifetime!

Win a Package for the 'FLIGHT TO MPP' at DTD with MainEventTravel.com

 The £340 Buy-in Flight To MPP plays as a Mystery Bounty where all players who make Day 2 will be playing for bounties, which include MPP Cyprus Packages and cash prizes, as well as a standard payout. 

2024 Irish Open Breaks Records

Players traveled from far and wide to attend Europe’s longest-running and largest poker festival.

MainEventTravel.com featured in PokerNews as Vegas Poker Travel Experts!

MainEventTravel.com has been featured in PokerNews as The Trip Leader If You're Heading to Vegas for the 2024 WSOP!

March 2024

Main Event Travel.com Offers IPT's Portugal Adventure Travel this Summer!

MainEventTravel.com is excited to extend some fantastic offers on Packages, Hotels, and ATOL-Protected Flights as well as Buy-ins for this festival set along a 13km stretch of pristine sands and crystal-clear waters.

Malta Madness is in effect, get 5% back when you book a Malta Hotel using Luxon Pay

Book a Hotel in Malta to stay 4 nights or more in April using Luxon Pay at checkout between now and the 27th of March for the Malta Poker Festival, EAPT Malta, or Battle of Malta and get 5% back in future travel credit.  

Geilich becomes two-time champ at GUKPT Blackpool

Grosvenor sponsored pro Ludovic Geilich has sensationally won a second GUKPT title, taking down the £1,250 buy-in Main Event in Blackpool for £56,150. His victory comes only two months after he joined Team Grosvenor and less than four months since finishing fourth in Blackpool last November.

Main Event Travel.com teams up with The Irish Poker Tour to Offer Portugal Adventure Travel

The tour and brand prides itself on timely, well-organized, relaxed, and player-friendly tournaments across Europe. And The Irish Poker Tour is about to embark on another exciting festival to offer players the perfect mix of sun, fun and top-class poker action with the Portugal Adventure, in Partnership with Paddy Power Poker

April's #FinalTableFreeroll Eligible Events!

April is shaping up to be another exciting month of many poker tournaments that are included in our exclusive promotion - #FinalTableFreeroll. The tournaments for April span not only the UK and Europe but also worldwide!

Nominate a Gal Pal to Win a Malta Poker Festival Ladies First VIP Package

MPF has teamed up with MET to GIVEAWAY a 5* Malta Poker Festival Ladies First VIP Package for Two as part of an ongoing initiative to promote, elevate, and celebrate women in poker around the world.

GUKPT Blackpool Schedule, Hotels & FTF

The third leg of Grosvenor’s GUKPT tour starts this week in Blackpool with an action-packed schedule.

Win Your Way to MPF this Spring at The Hippodrome London

Hippodrome Casino London will be hosting the first ever MPF Grand Event Remote Day 1 on Saturday 16th March as part of the March Madness mini-festival.

GUKPT Multi-Day Events Included in #FinalTableFreeroll Promotion

MainEventTravel.com is excited to announce that we are including all multi-day GUKPT events in our fantastic promotion, #FinalTableFreeroll, for Blackpool and the rest of 2024!

There is still time to book Malta Poker Festival VIP Packages, Hotels, and Flights at great rates!

MET is offering some fantastic accommodation options situated just minutes away from the Portomaso Casino and looks forward to welcoming players!

Luxon Pay Irish Open Booking Promotion Extended to 8th March

Book any Pre-paid Hotel between now and midnight Friday March 8th 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.

EAPT heads to Malta with a total guarantee of over €300,000

The EAPT continues its European tour. The next stop is Malta at the island nation's capital from April 5-10 with a total guarantee of over €300,000.

Marchington wins UK Poker Open; up next in Coventry – Goliath!

WSOP finalist Nick Marchington won his first-ever trophy at the UK Poker Open on Sunday after taking down the Main Event for £166,690.

Win a £500 Value Hippodrome Mystery Bounty Package

The Hippodrome Casino London has an exciting March Madness mini-festival this month, and MET has an exciting offer for you to attend!

Let MET take you to Value Town with some truly amazing offers for the €500k GPP SPM Nova Gorica

There are less than 3 weeks until the SPM at the Perla Resort with €500,000 guaranteed Main Event and €20,000 in Bonus Prizes!

Get 5% Back When You Book Irish Open Accommodation

Whether you crave proximity to the Dublin party scene, seek respite from bad beat stories, prefer budget-friendly options, or never make it to breakfast anyway, MET has great offers on Hotels in Dublin!

February 2024

Congratulations to Global Poker Awards Winners!

From exceptional player performances to notable contributions in the poker industry, the event celebrated the finest of 2023.

Get the Hotel Lowdown for GUKPT Blackpool 10th - 17th March

With just a couple of weeks before the GUKPT kicks off in the popular Lancashire seaside resort of Blackpool, now is the time to book!

Last Chance to Book Exclusive, Deeply Discounted Rooms at Clayton Ballsbridge for Irish Open

MET still has a few rooms available for Irish Open players at an exclusive, discounted rate of €179 per night Single B&B and €189 per night Double B&B.

Categories
Latest News & Blogs Live Events Main Event Travel News News GUKPT WSOP Travel Tips Blogs World Poker Tour Ask the TD
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.