0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0077 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-29' AND `url` = 'https://www.maineventtravel.com/news/article/Worldwide-Poker-this-August' ORDER BY `views` DESC

0.0009 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Worldwide-Poker-this-August', 1, '2024-04-29')

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.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0005 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.0007 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.0082 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.0072 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.0698 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.0084 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.0064 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.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.1908 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.0081 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.0603 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.0019 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.0079 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.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.0558 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.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.0049 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.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.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` = '28' 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.0610 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.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.0105 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.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.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.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.0020 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` = 'Worldwide-Poker-this-August'

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

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

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

English
Monday 24th July, 2023

Worldwide Poker this August

By Mad Harper

August offers a real feast of poker worldwide. Whether you fancy somewhere close to home or a truly exotic destination like Panama or Taiwan, MainEventTravel’s global reach and innovative calendar feature make it easy to choose both when and where you’d like to play. 

Well-known tours like the EPT, WPT, APPT, 888Live and WSOP Circuit all have festivals going on this August - but next month might also be the time to try out something new. Stateside, there is the celebrated Venetian Deepstack Vegas festival or the Mid States Poker Tour which has two events next month – in St Louis and Grand Falls. There’s also a bunch of events in Europe so if you fancy a tasty poker/beach holiday combo, then why not check out WPT Prime France in Aix-en-Provence, USDO Gujan Mestras near Bordeaux or EPT Barcelona?

You can use the calendar to search for events by month, and then fine-tune your search by filtering by tour, location, month or day. It’s a great tool for sorting out your favourite events – and if you’re logged into your account, you can also save all your options to your own personalised schedule using the “My Calendar” feature.

WSOP Super Circuit

Sponsored by GGPoker, the 18-day WSOP® Super Circuit festival is making its London comeback in August after a break of some 13 years. WSOP Super Circuit London will feature 15 official Circuit ring events from July 27 to August 13 and is offering more than £7 million in tournament guarantees.

APPT Manilla

APPT Manilla is running from July 27 to August 6 at Okada Manila in Paranaque. The APPT venue will be at the Coral Lounge right next to PokerStars Live Manila poker room. This is a massive festival with some 50 different tournaments on the schedule including the APPT

National starting July 29 which comes with a PHP 5 million guaranteed prize pool and the Main Event starting August 3 with a mouth-watering PHP 20 million guaranteed prize pool.

Venetian Deepstack Vegas

If you’re a deepstack poker fan then there’s no better place to head for this August than the Venetian DeepStack Showdown. The Venetian is a sumptuous Italian-style casino located right on the Strip and it’s been a mecca for deepstack players for more than 15 years. With 40 different tournaments on the schedule – and more than $850,000 in guaranteed tournament prize pools, the upcoming Venetian DeepStack Showdown is all the excuse you need to spend time in Sin City. It’s taking place throughout August with at least one tournament every single day.

MSPT – Mid Stakes Poker Tour

MSPT St Louis is the first of two Mid Stakes Poker Tour events taking place in August. The St Louis edition runs August 1-6 at the Hollywood Casino in St Louis. The Grand Falls edition is happening from August 18-20. The MSPT first launched in 2009 and was conceived as a series of affordable deepstack NL Limit Hold’em tournaments for "weekend warriors." The tour is geared toward recreational players but plenty of big-name poker pros have taken their shot at a MSPT title over the years including a bunch of Europeans such as Sergio Aido, Erwan Pecheux, Marvin Rettenmaier, and Ludovic Geilich.

WPT Prime France and Taiwan

You could describe the WPT’s new Prime series as “WPT Lite”. The tour has been designed to combine the premier poker tournament experience of a WPT Main Tour stop with affordable and more accessible buy-ins. WPT Prime France is running from August 3-6 at Pasino Grand in beautiful Aix-en-Provence. The €1,100 Main Event starts on August 2 with four starting flights including a Day 1d turbo. The schedule features 18 tournaments in all including an Omaha event, High Roller, Superstack and Progressive Knockout. WPT Prime Taiwan (pictured) is running from August 8-21 with a $1 million guaranteed total prize pool and 46 separate events on the schedule The TWD 33,000 Main Event starts on August 17 with three starting flights. Other highlights include a Mystery Bounty, 8-Max Championship, Seniors 50+ and even a Hyper Turbo High Roller.

LAPT Panama

PokerStars is all over the globe in August and its Latin American Poker Tour festival in Central America  – LAPT Panama – promises to be a lot of fun. The festival runs from August 4-8 and there are 17 different tournaments on the schedule including the $1,500 LAPT Main Event, two single-day £3k tournaments, a $5k High Roller and a $3k High Roller Progressive knockout on the final day.

 888 Live Bucharest

Bucharest in August. Bucharest (pictured) is a very popular stop on this tour - nicknamed the Little Paris of the East, the Romanian capital also has a long and rich cultural history with tons of art museums and landmark structures.

GUKPT London

GUKPT London, one of the most prestigious tournaments on the GUKPT calendar, kicks off at the Poker Room at the iconic Grosvenor Victoria Casino next month. The festival is taking place August 17-27 and will be the tour’s second visit to the capital this year. At the first leg back in January, Jonathan McCann scored his biggest ever live cash by taking down the £1,250 buy-in Main Event for £89,122. There were 459 entries in all, generating a £504,900 prize pool with a total of 44 players finishing in the money. Don’t miss MainEventTravel’s fantastic giveaway promotion giving players the chance to win a £1,750 prize package.  

EPT Barcelona

EPT Barcelona is taking place this year from August 21 to September 3 at Casino de Barcelona in the buzzy resort area of Port Olimpic. Huge numbers are expected after last year’s record-breaking field; the 2022 edition was the biggest Main Event in EPT history with 2,294 entries – more than ten times the 229 players who attended the very first EPT Barcelona 19 years ago.

USDO Gujan Mestras, France

The Unibet Deepstack Open series will be celebrating its tenth event with USDO Gujan Mestras this August. Located next to Bordeaux, France, Gujan Mestras is a lovely seaside resort on the Bassin d’Arcachon. Running from August 22-27, the schedule really packs it in with a €550 Main Event, plus a load of side events including the Mini UDSO, UDSO SuperStack, and Progressive Knockout. With an average 450 entries for every tournament, Gujan Mestras is very popular with both local amateurs and visiting tourists.

APAT Nottingham

The World Championship of Amateur Poker is taking place at Dusk Till Dawn in Nottingham from Wednesday 23rd August to Monday 28th August. There are four live Day 1s for the €180 Main Event. Other tournaments include the Tag Championship, Triple Draw Championship, Win the Button and Shootout Championship.

“WORLD SERIES OF POKER AND ASSOCIATED LOGOS AND DESIGNS ARE TRADEMARKS AND SERVICE MARKS OF CAESARS INTERACTIVE ENTERTAINMENT, LLC. MAIN EVENT TRAVEL IS NOT AFFILIATED IN ANY WAY WITH CAESARS INTERACTIVE ENTERTAINMENT, LLC OR THE WORLD SERIES OF POKER.”

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.