0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0101 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-28' AND `url` = 'https://www.maineventtravel.com/news/article/Whats-on-September' ORDER BY `views` DESC

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Whats-on-September', 1, '2024-03-28')

0.0005 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.0006 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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.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.0006 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.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` = 'page'

0.0115 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.0058 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.0129 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.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.0055 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.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.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.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.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.0082 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.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.0060 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.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` = '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.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.0060 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.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` = '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.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.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.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.0070 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.0027 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` = 'Whats-on-September'

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

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

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

English
Monday 21st August, 2017

What’s on in September!

By Mad Harper

After a relatively quiet August, poker really gets going next month with events right across Europe plus many more poker tournaments worldwide. Highlights include GUKPT Leeds, Redtooth Poker Tour Malta, the first Super Stack High Roller in Spain, WPTDeepstacks Vilamoura and Unibet Deepstack Open Vienna.

 

UK & Ireland

 

Cash Game Festival off to London!

Following a fantastic event in Bulgaria, Cash Game Festival off to London with a five-day sojourn at Aspers Casino in Stratford from September 20-24. Cash Game Festival is organised by people passionate about poker, parties and traveling. The Cash Game Festival offers 24/7 cash games with live online broadcasts straight from the two televised feature tables. 2017 has seen the tour grow to 11 events and the last event in Sunny Beach, Bulgaria filled almost all available tables at the casino.

 

Redtooth Poker Tour

After a sell-out Leg 2 in Bournemouth in August, the Redtooth Poker Tour is off to Malta in September. This debut European stop takes place at Casino Malta in the bustling resort of St Julians from September 15-18.

 

Tickets are exclusively and only available via MainEventTravel.com and we have special packages for seat+hotel bookings with a four-day stay in the sun including accommodation, breakfast, tournament entry and free bar welcome party with additional excursions available. We can even sort out flights to make things even easier for you. Check here to see full details.

 

The Redtooth Poker Tour comprises eight dealer dealt legs taking place around the UK & Europe with the winner of each leg winning a seat into VEGAS100 2018. The final table from EVERY leg will also win a UK National Final seat, a total of 90 seats awarded throughout the year! Redtooth Poker’s VEGAS100 competition has revolutionised pub poker in the UK with the country’s top 100 poker players – found via regional, national and online qualifiers – getting the chance to compete for the title of UK Pub Poker Champion in the poker capital of the world, Las Vegas.

 

GUKPT makes welcome return to Leeds

Following a record-breaking Goliath in Coventry, Grosvenor Casino’s popular GUKPT is back on the road with the £100k guarantee GUKPT Leeds running September 10-17. It’s a welcome return for the Leeds leg which had to be cancelled last year after the casino was badly damaged by floods. Stephen Foster won the 2015 edition after beating a 249-strong field for a £24,500 first prize. We are the tour’s Official Travel Partner and can help you find great accommodation for GUKPT Leeds as well as all other remaining stops on the 2017 GUKPT schedule.

 

The GUKPT is the longest running poker tour in the UK and now in its 11th season, welcoming poker enthusiasts from all across the UK for a week of fun poker action. As well as the packed schedule of satellites and tournaments, there will be plenty of cash games on offer.

 

Europe round-up

 

High rolling in Spain for Super Stack

The first Super Stack Spain High Roller is running at Casino Torrequebrada in Malaga from August 30 to September 3. With a €300 + €40 buy-in, this event offers a lot of fun for Super Stack regulars and new players. There are three start days for the Super Stack Spain High Roller with the final 1c flight starting at 8.30pm on Friday, September 1. Players are allowed two re-entries per Day 1. We’re Super Stack’s Official Travel Partner so look forward to sorting out your travel needs for this fab event. Super Stack will be back in Malaga in late September for a regular edition of Super Stack Spain.

 

WPTDeepstacks Vilamoura

The debut WPTDeepStacks Portugal event is taking place in the spectacular golf haven of Vilamoura. The event starts August 25 with Day 1b of the event on September 1. We’re the tour’s Official Travel Partner so check out our great hotel deals for WPTDeepStacks Portugal.

 

Located close to numerous championship golf courses, Vilamoura is a haven for golf players and a multitude of other attractions include a great marina with plentiful bars and restaurants as well as beautiful white sand beaches stretching for miles along the coast. The €200,000 guaranteed Main Event kicks off August 31 with a €1,100 buy-in. September also sees two WPTDeepstacks events in the States: WPTDeepStacks Immokalee from September 8-10 and WPTDeepStacks Oklahoma running September 22-25.

 

 

partypoker MILLIONS Russia

partypoker MILLIONS Russia is heading back to Russia next month for a huge event in Sochi from September 6-14. After smashing its $1 million Main Event guarantee in March, partypoker LIVE is now putting a $9,000,000 guarantee on the September schedule – including an amazing $5,000,000 guarantee Main Event starting September 9.  MainEventTravel has great rates at the partypoker-recommended Marriott Sochi Krasnaya Polyana Hotel – with eight nights for just $627. partypoker LIVE will also be in Ireland for partypoker Grand Prix Killarney which runs September 7-10.

 

Unibet DSO
Unibet Deepstack Open is hosting a fantastic event at Montesino Casino in Vienna from September 21-24. With an average of 500 participants at previous DeepStack Opens held at the Montesino, UDSO Vienna this is the leading destination for German, Italian, Swiss and French players on the UDSO circuit.

Mega Poker Series
The MegaPokerSeries returns with a stop in the famous Banco Casino in Bratislava. Lying close to both Vienna and Budapest, the Slovak capital is one of Europe’s most vibrant cities with tons of affordable bars, restaurants and nightclubs. MegaPokerSeries Bratislava runs September 13-17 with a €700 Main Event as well as €250 Mini.

Further afield

WPT Borgata
The $3 million guarantee WPT Borgata is running September 17-22 with a $3,500 Main Event at the Borgata Hotel Casino and Spa in Atlantic City. American pro Daniel Weinman won the record-breaking WPT Borgata Winter Poker Open last February and celebrated his 29th birthday with a monster cash of $892,433. WPT Maryland Live! also takes place next month, with a Main Event starting September 22 in Hanover.

WSOP on tour

The WSOP International Circuit is hosting a record number of stops as part of its 2017-18 schedule and has three events taking place in September: Campione  from September 1-1, WSOP Brazil from September 27 to October 4 and King's Casino in Rozvadoz from September 28-October 18. There are already 13 confirmed stops lined up this year, with additional stops expected to be added to the 2018 portion of the calendar.

 

WSOP Brazil, sponsored by partypoker LIVE, will be running September 27 to October 4 in the spectacular Bienal pavilion in Ibirapuera Park in Sao Paulo. This is partypoker’s first live event in the LATAM region where poker has been enjoying spectacular growth; more than eight million Brazilians already play poker, with over a million new players taking up the sport every year. The first WSOP Brazil event last year attracted more than 12,000 players across the eight-day festival. Among those set to compete is partypoker Ambassador and Brazil #1 Joao Simao.

 

World Cup of Cards is back!

After a fantastic debut last year, the World Cup of Cards is back at Canada’s famous Playground Poker Club in Montreal with an even bigger and better edition. Running through to September 13, the World Cup of Cards features over $6,000,000 in guaranteed prize pools in events designed to appeal to players of all experience levels.

 

We have tons of great hotels near the Playground so book today to take part in this fantastic festival.

 

Flagship events coming up at the World Cup of Cards include the partypoker Playground1000. With a $1,100 buy-in and 4 Day 1s, this is the second event in the WCC with a $1,000,000 prize pool guarantee. The new $2,200 buy-in partypoker Canadian Poker Championship boasts a massive $2,000,000 guarantee featuring 3 single re-entry speed starting flights and an additional single re-entry turbo starting flight.

 

PokerStars all over the place!

There are two PokerStars Festivals in September: PokerStars Festival Uruguay running September 16-23 in gorgeous Punta del Este and PokerStars Festival Dublin. PokerStars Festival Uruguay, the third and final Latin American stop of 2017, is sure to be one of the biggest PokerStars Festivals of the year, held in one of Uruguay’s most stunning resorts. PokerStars Festival Dublin at the end of the month is taking place at the Regency Hotel and includes a €700,000 guarantee Main Event. Take your pick from a variety of tournaments in a range of buy-ins - suitable for players of all levels!

 

MEGASTACK, PokerStars’ great new tournaments series for recreational players which launched in London in April, heads to France with La Grand Motte MEGASTACK from September 7-10 and then hosts a debut stop on the Iberian peninsula with Valencia MEGASTACK from September 13-17. Namur MEGASTACK is in France from September 13-17 and Sheffield MEGASTACK is running September 22-24 at Genting Casino.

 

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.