0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/tour/grosvenor-poker-2550' ORDER BY `views` DESC

0.0115 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-10-15' AND `url` = 'https://www.maineventtravel.com/tour/grosvenor-poker-2550'

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.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.0067 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.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.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'grosvenor-poker-2550'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'grosvenor-poker-2550'

0.0001 SECONDS:
SELECT * FROM `tours` WHERE `id` = '152'

0.0011 SECONDS:
SELECT tour_stops.*, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stops` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE tour_stops.end_date > CURDATE() AND tour_stops.active = 1 AND `tour_id` = '152' ORDER BY `tour_stops`.`start_date` ASC

0.0067 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 `news_articles`.`active` = '1' ORDER BY `news_articles`.`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.0003 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Grosvenor Poker 25/50


The 25/50 series offers a well-structured TWO-DAY tournament with a huge £50,000 guarantee.

The 25/50 is part of the Grosvenor 2024 NPL (National Poker League) offering players an opportunity to win prizes including packages valued at £5k, £10k, £15k, £20k, and a whopping £40,000 Package, as well as tickets to play in future NPL events, 

Simply play any NPL qualifying event, such as a GUKPT, 25/25, 25/50, or Deepstack, collect points, and climb the leaderboard – the higher you finish the bigger the prize! 

Payouts may change based on the amount collected, see Grosvenor Poker National Poker League for full details. 

MainEventTravel.com is the Official Travel Partner of Grosvenor Poker and Grosvenor Poker 25-50

 

 

Upcoming Tour Stops

Wednesday 23rd - Sunday 27th October, 2024

Walsall

Grosvenor Casino Walsall, Bentley Mill Way, Walsall, West Midlands WS2 0LE

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd - Sunday 27th October, 2024

London Luton

Grosvenor Casino Luton, 35 Park Street West, Luton, LU1 3BE

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd - Sunday 27th October, 2024

Manchester BNR

Grosvenor Casino Manchester, Bury New Road, 2 Ramsgate Street, Manchester, M8 9SG

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd - Sunday 27th October, 2024

Leeds

Grosvenor Casino Leeds Westgate, Wellington Bridge Street, Leeds, LS3 1LW

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd - Sunday 27th October, 2024

Glasgow

Grosvenor Casino Glasgow, Merchant City, 16/18 Glassford Street, Glasgow, G1 1UL

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 13th - Sunday 17th November, 2024

Liverpool

Grosvenor Casino Liverpool, 44 Chaloner Street, Liverpool, L3 4BF

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 13th - Sunday 17th November, 2024

Portsmouth

Grosvenor Casino Portsmouth, Gunwharf Quays, Portsmouth, PO1 3TZ

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 13th - Sunday 17th November, 2024

Birmingham

Grosvenor Casino Birmingham, 84 Hill Street, Birmingham, B5 4AH

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 13th - Sunday 17th November, 2024

Leeds

Grosvenor Casino Leeds Westgate, Wellington Bridge Street, Leeds, LS3 1LW

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 13th - Sunday 17th November, 2024

Edinburgh

Grosvenor Casino Edinburgh, 1 - 5 South Maybury, Edinburgh, EH12 8NE

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th December, 2024

Walsall

Grosvenor Casino Walsall, Bentley Mill Way, Walsall, West Midlands WS2 0LE

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th December, 2024

Reading South

Grosvenor Casino Reading South, Rose Kiln Lane, Reading, RG2 0SN

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th December, 2024

Manchester BNR

Grosvenor Casino Manchester, Bury New Road, 2 Ramsgate Street, Manchester, M8 9SG

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th December, 2024

Sheffield

Grosvenor Casino Sheffield, 87 Duchess Road, Sheffield, S2 4BG

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th December, 2024

Glasgow

Grosvenor Casino Glasgow, Merchant City, 16/18 Glassford Street, Glasgow, G1 1UL

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  
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.