0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0103 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/news/article/Vas-Nunes-wins-GUKPT-Grand-Final-2023' ORDER BY `views` DESC

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Vas-Nunes-wins-GUKPT-Grand-Final-2023', 1, '2024-10-15')

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.0002 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.0003 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.0002 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.0061 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.0036 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.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` = '11' 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.0035 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.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.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` = '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.0035 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.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.0037 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.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.0037 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.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` = '29' 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.0068 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.0048 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.0015 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` = 'Vas-Nunes-wins-GUKPT-Grand-Final-2023'

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-10-15' 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` = '917'

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

English
Monday 4th December, 2023

Vas Nunes wins GUKPT Grand Final 2023

By Mad Harper

The GUKPT Grand Final has wrapped up at the Poker Room in London’s iconic Grosvenor Victoria Casino with British player Paul Vas Nunes (pictured) scooping the top honours in the £2k Main Event. Sporting a fetching Christmas jumper, the Guildford-based pro told the Tower he’d been hoping for some gifts – and he was rewarded handsomely with a first prize of £140,000 and the GUKPT Grand Final trophy. 

Vas Nunes’s victory came nine years after he won GUKPT Reading and was runner-up in the 2014 Grand Final. Now 34, Nunes has racked up more than $1.9 million in live tournament winnings. Runner-up Alex Montgomery satellited into the event and put in a very creditable performance to scoop a career-best cash of £100,000. His best result prior to the Grand Final was finishing third at GUKPT Manchester in 2018 for £28,200.

GUKPT Luton champion Tom Hall, who has well over $3 million in live tournament winnings, finished fourth for £39,440 while well-known Brit Mathew Frankland, who has notched up $700k in live tournament winnings, achieved his best GUKPT result to date with an eighth place finish for £12,000.  

Cal Morreale wins Player of the Year

Cal Morreale’s 10th place (pictured below) in the Main Event – and winning the £500 4-card PLO event earlier in the week – secured his place at the top of the Grosvenor’s National Poker League leaderboard. Morreale, who has dominated the Player of the Year race this year, wins a £40,000 Grosvenor Sponsorship Package along with the coveted Grosvenor Casinos PoY Trophy. Based in Bedfordshire, Morreale has cashed at every single GUKPT held in 2023 including winning the GUKPT Manchester Main Event for £106,700 and finishing 2nd in the GUKPT London Main Event at the start of the year for £65,950. Other stellar achievements at Grosvenor tournaments this year include winning the Mini Main at the Grosvenor UK Poker Open in February for £58,480, a third place at GUKPT Blackpool, runner-up in the GUKPT Edinburgh Cup and winning the Mystery Bounty at 888poker LIVE Coventry in October. In fact, his winnings at Grosvenor live events this year total more than £330,000.

Morreale faced strong competition for this year’s Player of the Year title and had to fight hard to stay ahead of the likes of Robbie Bull, GUKPT Blackpool winner Lin Chen and Brandon Sheils. The 2023 Player of the Year Matt Davenport was also in the mix after winning the GUKPT Main Event at July’s Goliath and a string of cashes later in the year.

There were 325 entries in this year’s Grand Final creating a £55,600 prize pool. A total of 32 players got paid with a min cash worth £4,170. A host of big names made the money in the Grand Final including GUKPT Edinburgh champion Ludovic Geilich, GUKPT Coventry champion Joe Hindry and French November Niner Antoine Labat.

Sheils wins GUKPT Grand Final Cup

Brandon Sheils (pictured below) cemented a spectacular year at Grosvenor events by taking down the GUKPT Grand Final Cup for £30,730. Sheils made a deal heads up with runner-up Fraser Bellamy who cashed for £29,360. Arian Kashani, another strong contender for Player of the Year, was third for £15,430. There were 282 entries creating a £135,360 prize pool with 28 players cashing.

Woodhead beats star-studded final table to take down £1,250 Midi Main

It was a star-studded line-up for the final table of the £1,250 GUKPT Grand Final Midi Main tournament with eventual winner Stephen Woodhead (pictured below) up against the likes of GUKPT Coventry champion Jack Hardcastle, WSOP November Niner Antoine Saout, GUKPT Coventry champion Joe Hindry and GUKPT Blackpool High Roller champ Xu Hang en route to victory. After beating Grosvenor 25/25/ Reading winner David Mcconachie heads-up, Woodhead snagged a top prize of £88,808 – a cash which takes him well over the $400k mark in lifetime tournament winnings. Mcconachie won £61,680 for his runner-up finish with Hindry third for £67,710. There were 375 entries creating a total prize pool of £390,000. Among the 38 players who cashed were GUKPT Edinburgh champion Ludovic Geilich, Leo Worthington-Leese and Wynn Summer Classic champ Florian Duta.

Morreale triumphs in 4-card PLO event

Despite telling pals before the event that he can’t play PLO, Cal Morreale (pictured below) took down the £500 4-card PLO event at the start of the Grand Final. He cashed for £12,860 and added another 20.9 points to his Grosvenor Player of the Year tally. There were 87 entries generating a £41,760 prize pool. It was his fifth National Poker League tournament win of the year.

Shan Jiang took down the £200 Turbo Side Event for £7,880 after beating a 152-entry field. WSOP bracelet winner and GUKPT Coventry runner-up Richard 'Chufty' Ashby won the £900 PLO 4/5/6 High Roller after cutting a heads-up deal with GUKPT London Super High Roller winner Arthur Conan. Both players cashed for £18,600. Ashby, 51, has multiple WSOP final table appearances to his name and is currently ranked 43 in the UK all-time money list. There were 58 entries with eight players paid from the £68,260 prize pool.

The GUKPT Grand Final ran from November 23 to December 3 at the iconic Poker Room at the Grosvenor Victoria Casino. The 12-day end-of-season extravaganza is one of the biggest UK festivals of the year and a highlight of the GUKPT 17th season. There were more than 20 different tournaments on the schedule.

Grosvenor has already announced the dates for next year’s GUKPT, the tour’s 18th season. Next year’s calendar follows slightly different dates to 2023 but everyone’s favourite GUKPT stops are all featured! Leg 1 in London takes place from January 4-14 and then it will be off to GUKPT Manchester in February. Following that, it’s Blackpool in March, Leeds from April 4 to 14 and Luton starting April 25, London in May, then Edinburgh in June, a second trip to Luton in September, Blackpool #2 in October and then back to London for the Grand Final. Not to mention the return of the Grosvenor UK Poker Open event starting February 22 in Coventry. The flagship Goliath takes place in July and there are also at least 60 different 25/50 Series events. That’s a lot going on – but luckily you can start your planning now with MainEventTravel.com!

Win back up to 100% of Your Tournament Travel

2024 Grosvenor Poker GUKPT Main Events, UK Poker Open Main Event and Goliath Main Event will be eligible for MainEventTravel.com’s #FinalTableFreeroll, where you can win back up to 100% of Tournament Travel booked with MET! Simply tag MainEventTravel.com #FinalTableFreeroll on your socials when you book travel to get involved. Head to MainEventTravel.com > About Us > Promotions or click here for full details of the #FinalTableFreeroll and upcoming MET’s added value promotions!

Photo Credit - Grosvenor 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.