0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0107 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-19' AND `url` = 'https://www.maineventtravel.com/news/category/19' ORDER BY `views` DESC

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/category/19', 1, '2024-03-19')

0.0006 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.0007 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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

0.0003 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.0018 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.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` = 'page'

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

0.0060 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.0137 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.0015 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.0057 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.0014 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.0051 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.0014 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.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` = '19' AND `news_articles`.`active` = 1 ORDER BY `date` DESC

0.0013 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.0084 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.0015 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.0061 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.0014 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.0062 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.0014 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.0063 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.0013 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.0051 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.0013 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.0121 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.0014 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.0074 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.0014 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.0063 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.0015 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.0009 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_categories` WHERE `news_categories`.`id` = '19'

English

Travel Tips

February 2024

Las Vegas Hotel Lowdown

It’s said that there are more hotel rooms in Las Vegas than in any other city in the world –130,000 and counting – so you’ll be spoilt for choice when you head to Sin City

January 2024

Sightseeing in Dublin

Dublin is an ideal destination for a city break – there is tons to do and your main problem will be how to cram it all in! However, Dublin is a very manageable city and it’s easy to get around on foot, or you can get a day ticket for the hop-on hop-off buses which pass by most of the main attractions.

Beat the January Blues with MainEventTravel and Luxon Pay

Blue Monday falls on the third Monday of every January and has been designated the most depressing day of the year thanks to a combination of bad weather, long nights, and the lingering aftermath of the festive period.

Hippodrome Casino London

The Hippodrome Casino is home to PokerStars LIVE, a partnership that ensures exemplary standards when it comes to hosting cash games and tournaments.

The Poker Room at the Vic

The Vic has legendary status for poker players with one of the longest-running and busiest card rooms in the capital. The Poker Room, which officially opened in 2013 after a full renovation.

Aspers Casino Westfield Stratford City

Aspers’ prestigious Stratford casino in London’s East End goes from strength to strength as a top poker destination. It’s the biggest card room in London with warm and friendly staff.

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.

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.

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.

Vegas on a Budget

For a city full of so much glitz and glam, there are a surprising number of things you can do totally for free in Las Vegas, as there are plenty of free attractions dotted throughout the city.

Main Event Travel's Vegas Guide: The Linq Promenade

Of all the many newish attractions in Vegas, the Caesars-owned 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.

July 2023

Top Tourism on Offer at EPT Barcelona!

Barcelona is known as one of the best places to play poker in Europe – and the Catalan capital frequently hosts some of the biggest tournaments on the continent. This August it’s time for EPT Barcelona, a giant festival featuring more than 60 different tournaments. The huge scale of the EPT Barcelona schedule – which combines the EPT with the national Estrellas Poker Tour – features events to suit budgets and bankrolls of all kinds.

May 2023

The Lowdown on Vegas Hotels!

It's said that there are more hotel rooms in Las Vegas than in any other city in the world –130,000 and counting – so regardless of your budget you’ll be spoilt for choice when you head to Sin City this summer!

May 2022

Vegas Dollar Delivery $ervice

As poker players ourselves, we know that getting your hands on your bankroll in cash is a #1 priority. At MainEventTravel.com, we have an easy and cost-effective solution that can help you remove the difficulties of getting hold of dollars in cash in Vegas.

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.

Malta

There has never been a better time to visit Malta. Not only is this gorgeous Mediterranean island full of beautiful beaches, world-famous historic sites and a thriving poker scene, but this year Malta is celebrating its role as European Capital Of Culture 2018.

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.

New: destination guides to Vegas and Macau

Main Event Travel is thrilled to announce that we are now providing a range of super-useful travel guides for top poker destinations around the world. We have the full low-down on places like Las Vegas and Macau – from advice on where to play, where to eat and drink, sight-seeing, how to get around and other top tips. With the WSOP only round the corner, and Macau events happening year-round, now is the time to start planning your trip.

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.

Poker, poker - and more poker

Tournaments are now a regular fixture in Macau but three of the biggest ones on the calendar are the APT Macau Championships, the APT Finale Macau 2018 and the recent APPT Macau.

Macau - where to eat and drink

With such a rich mix of cultures and influences, it’s no surprise that Macau is also something of a food tourism haven. The city has plenty of five-star dining options but local food is cheap and widely available.

Macau - Asia on your doorstep

What makes Macau so appealing for poker players isn’t just the non-stop poker action or local sight-seeing, it’s also Macau’s close proximity to some of Asia’s top holiday destinations.

March 2017

What’s on in April

What a bumper month of poker April promises with events all over the globe including WPTs, partypoker LIVE, GUKPT, Unibet Deepstack Open, Super Stack and Cash Game Festival.

February 2017

Top weekend of poker starting next Thursday - in Britain, Europe & North America!

Fancy a top-notch poker weekend? Well, you’re spoiled for choice next week with some truly amazing poker events starting Thursday February 23. Treats include Unibet Open London, Grand Prix Cork, Super Stack Spain, WPT Fallsview and WSOP Circuit in Vegas!

December 2016

MET takes off in 2017

MainEventTravel is thrilled to announce that early in 2017 we’ll be introducing both online flight booking and car rental on the MET website – making us truly a one-stop shop for poker players, wherever in the world you’re competing.

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.

November 2016

Fancy a trip to Vegas? December is perfect!

December is a really great time to visit Vegas with the Strip aglitter with holiday spirit. All the casinos try to better each other with millions of decorations, lights and mega-Christmas trees – and there’s nowhere better than Bellagio.

Jake Cody vlogs go viral!

British pro Jake Cody has proved he’s not just a whizz at poker, he’s also a dab hand when it comes to making video blogs as well. The EPT Deauville champion recently relocated to Florida with girlfriend Alex and daughter Ariana and has been documenting his progress over there with a series of funny and informative video posts.

October 2016

What's on in November!

It’s a packed month of poker in November – with events to whet your appetite right across the globe. Take your pick from sun-drenched events in the Caribbean to some super-lively events in the UK, across Europe, North America and beyond!

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.

May 2016

The MainEventTravel Guide to Las Vegas

We thought that you would like a quick summary of what is new and different to do in Las Vegas

MainEventTravel Dollar Delivery

At MainEventTravel we have an easy and cost effective solution that can help you remove the difficulties of getting your bankroll in cash.

New US Immigration Laws on Biometric Passports

As of April 1st 2016, only tourists who carry a biometric passport are allowed to travel to the USA.

October 2015

Faraz Jaka Shares Some Travel Tips for Berlin

Faraz Jaka share some 'Travel Tips' if your are travelling to the WSOPE in Berlin

September 2015

WPT Road Trips

We take a look at a couple of short Road Trips coming up on the World Poker Tour™ schedule.

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.