0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/news/article/whats-on-december'
ORDER BY `views` DESC

0.0101 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/news/article/whats-on-december'

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.0003 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.0002 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.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.0039 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.0038 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.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` = '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.0041 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.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.0034 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.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.0034 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.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.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` = '22'
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.0041 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.0041 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.0039 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.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.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` = '29'
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.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.0072 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.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.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.0019 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-december'

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

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

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%article%'
English
  1. Home
  2. News & Blogs
  3. What's on in December
Saturday 25th November, 2017

What's on in December

By Mad Harper
Live Events News

With a host of events in glamorous European cities, along with events in the UK and amazing destinations worldwide, there are plenty of ways to bring 2017 to an exciting end! December offers a perfect month of poker, whatever your budget; we’re looking forward to some cracking events.

 

Get your dancing shoes on!

If you’re based in Scotland, then don’t miss a great night in Edinburgh. Poker player Ross Gaff is behind a fantastic charity event in Edinburgh on December 23 featuring top DJ Jack Eye Jones. The party, which is being held at the city’s La Belle dance club, is raising funds for the Edinburgh Dog & Cat home. As well as Jones, other big names on the bill include Paton, Robbie Graham and Jamie Mac.

 

UK poker tournaments

The English Amateur Poker Championship kicks off on December 1, giving all us wannabe pros the chance to test our skills against other like-minded amateurs. The Amateur Poker Association’s premier live event includes a £75 + £7 Main Event and £42 PLO8 and takes place at Grosvenor Casino Reading from December 1 to 3. We have a lot of great hotels in Reading including the Ibis, Novotel and Best Western.

The Amateur Poker Association & Tour created the UK’s first national poker tour in 2006.  Since then, APAT has developed into a global operator holding multiple festivals in Europe and North America, in addition to a comprehensive schedule in the UK. Members who have final tabled APAT national events have gone on to win WSOP, WPT, EPT, Irish Open, GUKPT and many other internationally recognised professional poker titles.

MEGASTACK Luton

PokerStars’ popular MEGASTACKS tour heads to Luton next month with a £170 buy-in event running December 7-10 at Genting Casino. MEGASTACKS are designed to offer recreational players the chance to hone their skills in a well-run live, deepstack poker tournament without breaking the bank. All PokerStars MEGASTACK events take place over the weekend, cost £170 to enter and have three start flights – with one re-entry per day. Players also get a generous 50,000 starting stack.

Unibet UK Manchester The Unibet UK Poker Tour is back in December with the fifth and final stop of the year - a £40,000 guarantee event in Manchester. We are the tour’s Official Travel partner and have lots of great hotel options for Manchester including Marriott, Renaissance and Britannia.

The £200+£20 buy-in Unibet UK Manchester event runs December 8-10 offers and players a 25,000 starting stack with 40 minute blinds and one re-entry allowed per starting day. Day 1a is on December 8 at 7pm with Day 1b at 1pm on December 9.

 

Redtooth Poker Tour

Redtooth winds up a hugely successful 2017 with a final event in Nottingham on December 17. Tickets are exclusively available via MainEventTravel.com and we have special seat+hotel packages available. Redtooth has more than 200,000 registered players around the UK, all vying to qualify for VEGAS 100. Nottingham is the last of eight legs held during 2017. 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.

 

TOURNAMENTS IN EUROPE

WPTDeepstacks Deauville

WPTDeepStacks has enjoyed a cracking first season in Europe and will be celebrating the year-end with a final 2017 stop in Deauville. The PMU.fr WPTDeepStacks Deauville festival takes place December 6-10 at Casino Barrière Deauville, with the €1,200 Main Event running December 8-11. You can sort out everything you need on our site including buy-ins for the WPTDS Opener, Main Event and High Roller. The schedule also includes a €200 Survivor tourney, the PMU.fr Carte Blanche event, a PLO/Omaha High tourney and a €3k Platinum 6-max.

 

WPT Berlin: Do note that we have a special hotel offer available for the forthcoming WPTDeepStacks European Championships in Berlin in January – full details here.

 

SuperStack

Super Stack Spain has gone from strength to strength this year with a ton of events right across the country including Malaga, Lloret de Mar and San Roque along with Gibraltar.

 

The final event of the year is Super Stack Spain - Malaga which takes place December 14-18. As always, events kick off with Day 1a on the Thursday at 8pm, and Day 1b the same time again on Friday. If you’re short on time, you can also fly in on the Saturday for Day 1C which starts at 8pm local time. Following the fantastic Super Stack structure, players get a 30,000 stack for the €170 buy-in event with 30 minute blind levels.

 

All Super Stack destinations are easy and cheap to get to. There are numerous return flights from the UK to Malaga for as little as £50, giving players the chance of a fab weekend in Spain at an easily affordable cost. MainEventTravel is Super Stack’s Official Travel partner and can arrange fantastic hotel deals for all Super Stack events.

 

partypoker Fitzwilliam November Poker Festival Dublin

The Fitzwilliam Poker Festival Dublin has a new sponsor this year – partypoker – and is looking forward to another bumper event. Hosted by Kara Scott, with commentary from Jesse May and Padraig Parkinson, the €450 Main Event runs December 1-4. Every event at the 2016 edition sold out so bag your accommodation early for this fun tourney!

 

Forges-les-Eaux MEGASTACK

Like all MEGASTACK events, Forges-les-Eaux MEGASTACK has a a €40,000 guarantee and costs just €170 to enter. The event features two starting flights, with one re-entry per day. The event is running December 14-17 at Casino Le Domaine De Forges. There is also a MEGASTACK Prague event taking place in Prague as part of PokerStars Championship Prague and a MEGASTACK Luton event running December 7-10.

 

PokerStars Prague

PokerStars’ annual Prague blockbuster takes place this year from December 7-18. The PokerStars Championship Prague incorporates a great MEGASTACK event this year along with the €5,300 Main Event, the €10,300 High Roller and €50,000,000 Super High Roller. There are 43 tournaments in all including tried-and-tested favourites such as the Prague Poker Cup. Prague is always a hugely popular stop and a fabulous place to visit in December; an idyllic winter setting aglow with festive Christmas markets. We have a range of great hotels in Prague including the tournament venue itself – the Hilton Prague – plus the Jury’s Inn, Grandior, Hotel Unic and many more.

 

Unibet Open Bucharest

The beautiful city of Bucharest is the venue for the last Unibet Open of the year. The event starts tomorrow through  to December 3 in the Romanian capital and features a €500,000 guarantee for the Main Event.

 

Last year, Bucharest was the biggest Unibet Open ever held with a staggering 603 entries. Romanian player Traian Bostan took it down – on home soil – for €100,000 after staging a superb comeback from less than four big blinds. Daiva Byrne, now a Unibet Ambassador, won the Ladies Battle Royale.

 

This year’s event, which is being held at the JW Marriott Bucharest Grand Hotel, features a ton of side events including the €170 Monsterstack, €2k High Roller, €200 Progressive Super Knockout and €100 Ladies Event. There are also turbo and hyper tubos on the schedule along with a €200 PLO tournament.  

 

 

FURTHER AFIELD

 

WPT Five Diamond World Poker Classic

 

 

December is a really great time to visit Las Vegas with the Strip glowing with high-florescence holiday spirit. With all the casinos vying to impress, there’s nowhere better than the Bellagio with for decorations, lights and mega-Christmas trees. As luck would have it, Bellagio also hosts one of the big poker events of the year in December, the WPT Five Diamond World Poker Classic.

 

The overall festival runs from November 24 with the six-day $10,000 Main Event starting December 5. The Five Diamond World Poker Classic has been a part of the World Poker Tour for all 16 seasons, dating back to 2002. Previous winners include Gus Hansen, Daniel Negreanu, Joe Hachem, and Antonio Esfandiari.

 

WPTDeepstacks, California

The WPTDeepstacks Championship in Thunder Valley is next month with a $1,000,000 guarantee for the Main Event. The whole festival runs from November 24 to December 5 with the Main finishing off a great two weeks of poker. The buy-in is $2,500 with two start flights and unlimited re-entries. There will be a live stream from the final table on December 5. Thunder Valley is near Sacramento in northern California, and a two-hour drive from both Reno and San Francisco.

WSOP Circuit, Sydney The WSOP is in Sydney next month with a Circuit event featuring a total of 13 events. The events kicks off on November 28 and runs through to December 18. Promising to be even bigger and better than the debut WSOP Sydney last year, the event will feature 13 tournaments over 21 days – with 14 coveted WSOP Gold Circuit Rings up for grabs and at least $3.8 million in guaranteed prize pools across the whole series. The jewel in the crown – the $2,200 buy-in Main Event – comes with a $2 million guarantee and there are tons of live satellites, and four start flights. Also on the schedule are a $500,000 guaranteed Opening Event, a $20,000 buy-in High Roller, a $1,100 Monster Stack Event, Masters Event, Mixed games, Omaha events and more.

Featured Articles
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
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.