0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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.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.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.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0071 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.0005 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.0003 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'grosvenor-poker-2550'

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

0.0012 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.0090 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.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.0004 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  1. Home
  2. Events
  3. Grosvenor Poker 25/50

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  
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.