0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0084 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-16' 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.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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0072 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.0063 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.0082 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.0005 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'grosvenor-poker-2550'

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

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

0.0014 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.0518 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.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.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 28th August - Sunday 1st September, 2024

Edinburgh

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 28th August - Sunday 1st September, 2024

Coventry

Grosvenor Casino Coventry, Coventry Building Society Arena, Phoenix Way, Coventry, CV6 6GE

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 28th August - Sunday 1st September, 2024

Blackpool

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 28th August - Sunday 1st September, 2024

Portsmouth

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th September, 2024

Sheffield

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th September, 2024

Stockton

Grosvenor Casino Stockton, 4 Chandlers Wharf, Stockton-on-Tees, TS18 3BA

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 4th - Sunday 8th September, 2024

Cardiff

Grosvenor Casino Cardiff, Red Dragon Centre, Atlantic Wharf, Hemingway Road, Cardiff, CF10 4JY

A new date has been released for 25/50. 

Buy-in: £220+£30

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 25th - Sunday 29th September, 2024

Leeds

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 25th - Sunday 29th September, 2024

Blackpool

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 25th - Sunday 29th September, 2024

Birmingham

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

 

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 2nd - Sunday 6th October, 2024

Leicester

Grosvenor Casino Leicester, 90 Highcross Street, Leicester, LE1 4NN

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 2nd - Sunday 6th October, 2024

Reading South

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 2nd - Sunday 6th October, 2024

Bolton

Grosvenor Casino Bolton, Ormrod Street, Bolton, BL3 5DJ

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 2nd - Sunday 6th October, 2024

Newcastle

Grosvenor Casino Newcastle, 100 St James Boulevard, Newcastle Upon Tyne, NE1 4BN

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 2nd - Sunday 6th October, 2024

Edinburgh

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

Grosvenor's 25/50 2024 Calendar has been released!

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 23rd - Sunday 27th October, 2024

Walsall

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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

Grosvenor's 25/50 2024 Calendar has been released!

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.