0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-dev`

0.0183 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-04-26' AND `url` = 'https://dev.maineventtravel.com/news/category/22' ORDER BY `views` DESC

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://dev.maineventtravel.com/news/category/22', 1, '2025-04-26')

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` = 'dev.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.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` = 'dev.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0003 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

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

0.0024 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.0056 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.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` = 'dev.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.0018 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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.0017 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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.0017 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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`.* 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.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` = 'dev.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.0021 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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.0023 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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.0017 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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`.* 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.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` = 'dev.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.0043 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.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` = 'dev.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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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.0021 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.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` = 'dev.maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'news'

0.0003 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 `news_categories`.* FROM `news_categories` WHERE `news_categories`.`id` = '22'

  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found  -  LIVE ENVIRONMENT  -  BRANCH : Branch not found
English

Main Event Travel News

February 2022

MainEventTravel.com partnering Casino Malta for two Battle of Malta festivals in 2022

For the first time ever, Casino Malta will be hosting two Battle of Malta festivals this year with the first event in April, followed by a second in the Autumn.

December 2018

Epic year for Main Event Travel

2018 was certainly one of the most exciting years that Main Event Travel has experienced since its launch in 2011 – with new clients, new events and fantastic new functionality on our amazing one-stop-shop website.

November 2018

Caribbean Party Poker hotel bargains up for grabs!

partypoker LIVE have made some fantastic Caribbean Poker Party hotel rooms available to all MainEventTravel customers so if you want to save some money while staying in the lap of luxury and super close to the tournament venue, now’s your chance.

Battle of Malta celebrates new champion & biggest Malta poker tournament ever

With a €1m guarantee for the flagship Main Event, Battle of Malta 2018 certainly set a high bar for success! But the giant 3,816-entry field for the Main Event and 13,000 tournament entries overall made this year’s Battle of Malta a spectacular success. If you were there, we hope you had fun! If you weren't, well you know what to do next year!!!

October 2018

MainEventTravel stalwart Mad Harper braves Battle of Malta SOBER to raise money for MacMillan

Mad Harper, MainEventTravel's content writer, is doing Dry October to raise money for MacMillan. We thought staying sober for a month wasn't tough enough - so we've brought her out to Battle of Malta where the beer is flowing and there's a party every 20 minutes ...

May 2018

Beyond the Strip – day trips from Vegas

With so much to do in Las Vegas itself, it can be hard to find time to explore beyond the city’s borders. However, even if you only have an afternoon spare, it’s well worth renting a car and heading out of town. Las Vegas is surrounded by stunning scenery and places like Lake Mead Hoover Dam and Red Rock Canyon are within easy driving distance.

April 2018

Need cash in Vegas this summer? Check out our Dollar Delivery service

No one wants to travel with wads of cash to Vegas and trying to transfer or exchange money once you’re there can be a real headache. MainEventTravel takes away the hassle with a bespoke, personal, on-site Dollar Delivery service.

New: Malta travel guide

Don't miss our comprehensive new travel guide to Malta. We have the full low-down on all the best places to visit, eat, drink and party – as well as when and where to play poker. With great events coming up in Malta like the Unibet Open, Unibet Deepstack Open and the Battle of Malta, now is the perfect time to start planning your trip to this beautiful Mediterranean island.

What's on in May

May has a bunch of poker events around the world including 888Live Barcelona, Unibet Open in Malta, Grosvenor Casino’s Goliath in Coventry, SuperStack and WPTs – and that’s before the World Series of Poker gets under way at the end of the month. Don't forget ! you can now book flights online at MainEventTravel.com as well as your accommodation.

Bars and Clubs in Malta

There’s certainly no shortage of places to drink and dance in Malta; from cosy family-run wine bars to giant nightclubs, Malta has it all. Highly recommended is Café del Mar where you can enjoy a fab day lazing by the pool in the sun before hotting it up in the evening with top DJs mixing it up.

Eating out in Malta

The heart of Malta's thriving nightlife scene is St Julians which lies about half hour north of the capital city of Valletta. This is where the three main casinos are all located – Casino Malta, Portomaso and Dragonara – and the area is heaving with great places to eat out.

Things to do in Malta

With its superbly sunny weather (more than 300 days a year), expansive beaches, thriving nightlife and 7,000 years of incredible history – including some of the oldest human structures in the world, there is a huge amount to see and do in Malta. It is also a place of stunning natural beauty.

Poker in Malta

Malta is a near perfect destination for a poker holiday – for starters, there’s lots of poker but there are also tons of other things to do. Whether it’s strolling around the gorgeous capital city of Valletta, clubbing all night in Paceville or chilling out at Golden Bay beach, Malta really does have something for everyone.

MainEventTravel’s Vegas Guide: The LINQ Promenade

Of all the many attractions that have opened in Vegas in recent years, the LINQ Promenade has proved one of the most successful: an appealing, tree-lined open-air pedestrian walkway featuring tons of shops, restaurants, bars and attractions.

March 2018

Sightseeing in Macau

Macau has all the glitter and glamour of Las Vegas but combines the high-rise glitz of the Cotai Strip with a rich culture and history going back hundreds of years. Macau was the first European settlement in the Far East and a Portuguese colony for over 300 years.

June 2017

What’s on in July

It’s not all about the WSOP! If you don’t fancy Vegas, there are still several great poker events going on elsewhere in July

We have a cash! MET Vegas round-up

MainEventTravel CEO Fraser MacIntyre is on a roll at the WSOP! After finishing 237th out of a staggering 7,761 entries in the Millionaire Maker for $6,043, our hero is now on Day 2 in yet another event – the £1k Pot Limit Omaha!

May 2017

Congrats Fraser! Runner-up in 888Live Barcelona High Roller

MainEventTravel CEO Fraser MacIntyre is runner-up in the 888Live Make It Big Festival €2,200 High Roller in Barcelona. We're the Official Travel Partner for the festival and, if you fancy some sun, there’s still lots of time to enter the €500k guaranteed Main Event. Day 1b today at 6pm; 1c on Saturday at 3pm.

Fraser MacIntyre in top five in 888Live Barcelona High Roller

MainEventTravel.com’s Fraser MacIntyre is fourth in chips after bagging up 426,000 at the end of Day 1 of the 888Live Make It Big Festival €2,200 High Roller. Play resumes 5pm local time. MainEventTravel is 888Live’s Official Travel Partner for the festival offering great hotel deals in Barcelona.

April 2017

Celebrate the holiday weekend with tons of live poker

With the promise of the first bank holiday of the summer, there’s plenty of poker action this weekend all over Europe – and in Canada!

Countdown to 888Live Make It Big Festival in Barcelona

It's just over two weeks until the debut 888Live Make It Big Festival in Barcelona: 12 days of non-stop poker from May 11-22 and total guaranteed prize pool of over €700,000. We're the Official Travel Partner

December 2016

Heading east for the first WPT National Cambodia event

There’s a novel new stop from the WPT next year with the inaugural WPT National Cambodia in January.

Exotic destinations for January!

January is always an exciting month for poker players with two major destinations on offer plus a host of other exciting stops. The flagship events next month are the PokerStars Championship Bahamas from January 6-14 and the Aussie Millions from Jan 11 to 30.

October 2016

Less Than A Week To Go Before Hippodrome Autumn Classic

There's less than a week to go before the £250 + £25 Autumn Classic kicks off at The Hippodrome Casino in London.

Penultimate EPT Features 84-Event Schedule in Malta

The European Poker Tour will be heading to Malta for its penultimate event this month

November 9 Special Offer

Book your November Nine accommodation through Main Event Travel and we’ll give you a whopping 9% discount on the cost of your hotel.

Cash Game Festival Heads to Tallinn

Cash Game Festival is heading back to the city where it all got started – beautiful Tallinn, the capital of Estonia.

Grand Prix Poker Tour Heads Home to Nottingham

The Grand Prix Poker Tour is heading home to Dusk Till Dawn in Nottingham

888Poker London Festival

888poker will be launching its first 888Live Festival in London this month with an 11-day event running October 13-23 at Aspers Casino.

August 2016

PokerStars announces global Championship and Festival events

Today, PokerStars announced that beginning in 2017, its global live events will fall under one of two tours, the PokerStars Championship and PokerStars Festival.

February 2016

WSOP Announce 2016 Schedule

Non-stop poker action returns to the Rio All-Suite Hotel & Casino in Las Vegas from May 31 to July 18, 2016 as the 47th running of the poker's longest-running tournament series returns for its annual summer pilgrimage.

MainEventTravel.com & FiDPA Launch FiDPA Travel

MainEventTravel and FIDPA are delighted to announce the launch of FIDPA Travel

November 2015

Dale Garrad leaves MainEventTravel.com

Dale Garrad leaves MainEventTravel.com

October 2015

Bob Dylan Sang About It, People Are Scared of It

With the announcement of the GPL, we wonder why people are not always happy with new ideas.

September 2015

MainEventTravel.com News - Steve Warburton

2nd place in EPT Barcelona while proudly wearing the MET logo

August 2015

MainEventTravel.com News

MET announce Simon Deadman as brand ambassador

June 2015

MainEventTravel Launch WPT Travel

MainEventTravel.com are proud to announce the launch of a new website and partnership with the World Poker Tour (WPT)

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.