0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0104 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-29' AND `url` = 'https://www.maineventtravel.com/news/article/Eames-wins-GUKPT-Luton' ORDER BY `views` DESC

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Eames-wins-GUKPT-Luton', 1, '2024-03-29')

0.0010 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.0008 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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

0.0114 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.0059 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.0131 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.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.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` = '16' 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.0053 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.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` = '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.0089 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.0061 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.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.0062 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.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.0059 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.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` = '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.0124 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.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` = '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` = 'Eames-wins-GUKPT-Luton'

0.0011 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-29' 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.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.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` = '458'

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

English
Monday 16th October, 2017

Eames snags first GUKPT title in Luton

By Mad Harper

John Eames has won GUKPT Luton for £68,350 and his first GUKPT title after a dominating performance on yesterday’s final table.

 

The next GUKPT is GUKPT Blackpool from November 5-12 so bag your accommodation early! We are the tour’s Official Travel Partner and can help you find great hotels near the tournament venue.

 

Luton was Eames’s third final table at a GUKPT after he finished fifth in Brighton in 2010 (for £9,600) and eighth in Walsall three years ago for £2,700. It was also his biggest cash on the tour and takes his live tournament winnings to nearly $2.2 million. He has cashes going back ten years including big wins in Vegas, Vienna, Prague and Barcelona.

 

There were 239 entries for Leg 8 of this year’s GUKPT tour creating a £239,000 prize pool. Grosvenor Ambassador Will Kassouf, who was ninth at the recent GUKPT Leeds stop, had another deep run, finishing 21st £2,150. Three spots later, fellow Ambassador Joe Beevers was eliminated, finishing 18th for £2,390.

 

GUKPT Blackpool

It’s now just three weeks until the penultimate event of the 2017 GUKPT tour in Blackpool. Leg 9 takes place November 5-12 and features a £200k guarantee Main Event. There will also be a bunch of great side events including a £20k guarantee Mini Main. British pro Tom Middleton won last year’s GUKPT Blackpool after a three-way chop with Tom Hall and Richard Kellett, awarding him the title and £56,255 payday. There were 251 entries creating a prize pool of €251,000. The GUKPT Blackpool festival, one of the highlights of the UK live events circuit, is held at Grosvenor Casino Blackpool right on the city’s famous seafront.

 

The GUKPT Grand Final London starts November 19 at the Poker Room above the iconic Grosvenor Victoria Casino in Edgware Road. Now celebrating its 11th season, the GUKPT is the longest running poker tour in the UK, welcoming poker enthusiasts from all across the country for a packed week of fun poker action.

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.