0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0098 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/news/article/There-are-two-ways-to-avoid-Vegas-FOMO-this-Summer-' ORDER BY `views` DESC

0.0087 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-16' AND `url` = 'https://www.maineventtravel.com/news/article/There-are-two-ways-to-avoid-Vegas-FOMO-this-Summer-'

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.0002 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.0001 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.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.0065 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.0035 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.0067 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.0033 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.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` = '18' 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.0028 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.0029 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.0040 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.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` = '27' 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.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` = '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.0027 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.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.0058 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.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` = '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.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.0014 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` = 'There-are-two-ways-to-avoid-Vegas-FOMO-this-Summer-'

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

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

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Tuesday 14th May, 2024

There are two ways to avoid Vegas FOMO this Summer!

By Mad Harper

If you want to avoid LVFOMO this Summer, either get your skates on and book your Vegas trip now, or just book yourself a trip to one of the many fantastic poker festivals taking place in Europe!


The WSOP attracts so much noise every year that it’s easy to forget that there are a ton of other poker festivals taking place over the Summer that promise just as much fun (and sun!)

 

If you can’t manage the trek to Vegas this year, you can easily cheer yourself up simply by taking a look at the MainEventTravel’s poker calendar. This handy resource enables you to check what’s on day-by-day or enjoy an overview of the whole month but, whichever way you use it, you’ll get the picture – it’s not all about Vegas!

 

What makes this summer’s poker action in Europe so enticing is that a lot of the tournaments are brand new stops such as the Irish Poker Tour’s eagerly-awaited Portugal Adventure, the UKIPT’s first trip to Malaga and the Unibet DeepStack Open UK which is joining forces with Aspers for the first time. Other treats on the near-horizon include WPT Prime’s new San Remo festival (which made its debut last year) and the new British Poker Series which is hosting a load of £50k guaranteed events this year.

 

European events often offer excellent accommodation options at great rates, quicker flight times, and an amazing array if affordable food and drink choices.

 

So here’s our lowdown on tourneys in Europe this summer – and don’t forget a lot of these events are eligible for MainEventTravel’s FinalTableFreeroll promotion giving you the chance to win 100% of your travel costs back in credits.

 

Irish Poker Tour’s Portugal Adventure – June 18 – 24 – The Irish Poker Tour’s new Portugal Adventure is another event which gives players the chance to enjoy a real poker holiday. With this in mind, tournaments don’t start until 4pm each day giving everyone plenty of time to enjoy the sun, the sea, swimming pool and all the other attractions. Taking place at Casino Tróia in the beautiful seaside resort of Setubal, the festival features €400,000 in overall prize pool guarantees. The €700, €250k guaranteed Main Event gets underway on June 20 with the first of four start flights. As Official Travel Partner MET has Packages, Buy-ins, Hotels, ATOL Protected Flights, and more, all at great rates! You can also contact us for a bespoke package info@maineventtravel.com

 

UKIPT Malaga – June 10-16 – Excitement is really building for this new PokerStars festival which brings the UKIPT and Estrellas Poker Tour together for a seven-day extravaganza in the Costa del Sol resort of Benalmadena. UKIPT Malaga takes place at Casino Torrequebrada, just 20 minutes from Malaga airport and 40 minutes from Malaga city centre. With sun, sea, beautiful beaches and one of Europe’s oldest port cities nearby, we’re expecting UKIPT Malaga to be a hugely popular spot. Highlights include the €2k ESPT/UKIPT High Roller from June 11-12, the €1,100 ESPT/UKIPT Main Event starting on June 12 and the €330 ESPT/UKIPT Cup kicking off on June 15.

 

The Festival Rozvadov – May 31 – June 9 – The Festival is heading back to Rozvadov at the end of the month with its exciting and madcap mix of poker tournaments (straightforward Hold’Em plus tons of other variants), cash game challenges, casino games and off-the-felt activities. There are 54 different events in total including a €500,000 guaranteed poker Main Event plus Blackjack tournament, Roulette tournament and Slots tournament.

 

GUKPT Leeds – May 30 – June 9 – the 18th season of the GUKPT is already in full swing and will be heading to Leeds for Leg 7 at the end of the month. There is a £900+£100 Main Event plus all the other usual attractions on a GUKPT schedule including Opener, Mini Main, PLO and GUKPT Cup.

 

Unibet DeepStack Open UK Aspers – June 1-9 – the UDSO first kicked off in 2009 and has been attracting mid-stakes players to events all over Europe and Morocco ever since. The tour doesn’t often come to the UK though so the forthcoming festival at Aspers is certainly something to celebrate. The UDSO will be truly national with Day 1s for the £500 Main Event taking place at both Aspers Newcastle and Aspers in Stratford, London. The six Day 1s will all stop at 15% players left awarding all players remaining with £900 in cash. Day 2 will resume in London on June 8. As well as the Main, other schedule highlights include the DSO Cup, DSO Gold high roller and DSO Omaha. 

Skill Poker Master Bratislava – July 2 - 8 - The Skill Poker Masters Main Event has a buy-in of €320+€30, a whopping €500k guarantee, and offers eight starting flights! IN addition, the High Roller will be played with a buy-in of €675+€75 and a €40k GPP. Omaha fans will also be in for a treat during the PLO Masters tournament, and the €30,000 Skill Mystery Bounty is sure to be attractive. 

USDO Barcelona – June 11-16 – if you get the taste for UDSO action at Aspers, you may enjoy a back-to-back UDSO experience with a trip to Barcelona for the UDSO starting there on June 11. Barcelona barely needs introducing as a poker destination – it’s got it all – fabulous city, amazing nightlife, sun, sea, sand and superb cuisine. UDSO Barcelona will feature a €490 + €60 Main Event, Mini UDSO, UDSO Gold and UDSO Cup.

 

USDO San Remo – July 23-28 – the third UDSO of the Summer is in gorgeous San Remo in Italy – just a hop, skip and a jump away from the Monaco border. San Remo Casino is an iconic and glamorous venue and perfectly located in this popular resort with lots of restaurants, bars and cafes nearby. UDSO San Remo will feature a €490 + €60 Main Event, €300 Mini DSO, €150 UDSO SuperStack, €200 UDSO Silver and UDSO Cup.

 

WPT Prime San Remo – May 31 – June 10 – the new WPT Prime tour made its debut in San Remo last year and is off there again at the end of the month. As well as the €1,100 Main Event which starts on June 6, there’s a massive number of other tourneys on the schedule including the €200 Opener, €250 SuperStack, €150 Bounty and €300 Mystery Bounty along with a €1,500 High Roller which gets underway on June 9. There were a massive 838 entries in last year’s Main Event with champion Simone Andrian winning €147,020.

 

BPS Aspers – June 20-23 – the new British Poker Series has lined up an amazing eight events at Aspers Stratford City, London's biggest poker room, for 2024. Coming up next month is BPS200 London with a £50,000 guaranteed Main Event costing just £200 + £30 to enter. There will also be a £120 tournament with £10k guarantee. The Series’ BPS200 MK event starts May 29 at the Aspers Casino in Milton Keynes and also features a £50k guaranteed prize pool for the £200 buy-in tournament.

Worldwide

If you have the time, inclination and funds to head further afield this summer, some major events are also taking place worldwide. Chief among them are WPT Macau which is taking place from June 20-24, the WPT Cambodia Passport to The World Championship at Nagaworld Integrated Resort from July 18-22, the BSOP Sao Paulo, Winter Millions from July 23 to 31 and APPT Manila 15 at the end of July.

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.