0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0169 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-23' AND `url` = 'https://www.maineventtravel.com/venue/the-poker-room' LIMIT 1

0.0017 SECONDS:
INSERT INTO `page_views` (`url`, `date`, `views`) VALUES ('https://www.maineventtravel.com/venue/the-poker-room', '2024-02-23', 1)

0.0009 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.0005 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0009 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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` = 'tour'

0.0004 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

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` = 'tour'

0.0003 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0006 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.0157 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.0003 SECONDS:
SELECT * FROM `venues` WHERE `id` = 'the-poker-room'

0.0007 SECONDS:
SELECT * FROM `venues` WHERE `page_url` = 'the-poker-room'

0.0020 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_stops`.`venue_id` = '21' ORDER BY `tour_stops`.`start_date` ASC

0.0122 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.0022 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.0018 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` WHERE `white_label_version_id` = 0 AND `white_label_inclusions`.`entity_type` = 'news'

English

The Poker Room



Upcoming Events at this Venue

Wednesday 20th - Sunday 24th March, 2024

Grosvenor Poker 25/50

London: The Vic

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

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  


Wednesday 14th - Sunday 25th August, 2024

888poker LIVE

888poker London

888poker is heading to London in August 2024.

Check back for the full schedule. 

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 24th - Sunday 29th September, 2024

888poker UK Poker League

UKPL London

UKPL will be visiting London. The tour is set to take the UK by storm with exciting live events in various Grosvenor casinos across the country!

The Buy in fee is £500 + £60. Check out all the details and the schedule. 

Freeroll Your Next Poker Trip - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 23rd - Sunday 27th October, 2024

Grosvenor Poker 25/50

London: The Vic

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

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 21st November - Sunday 1st December, 2024

GUKPT Grosvenor

GUKPT London: The Vic Grand Final - Leg 10

GUKPT London features a £1800 + £200 Main Event.

Win Back Up to 100% of Your Tournament Travel Costs - #FinalTableFreeroll Eligible Event - Click Here for Details

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 4th - Sunday 8th December, 2024

Grosvenor Poker 25/50

London: The Vic

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

Buy in - £220 + £30

£50,000 GTD

    Find Hotels, Flights & More       View Complete Schedule  
Latest News & Blogs

Get the Hotel Lowdown for GUKPT Blackpool 10th - 17th March

With just a couple of weeks before the GUKPT kicks off in the popular Lancashire seaside resort of Blackpool, now is the time to book!

Last Chance to Book Exclusive, Deeply Discounted Rooms at Clayton Ballsbridge for Irish Open

MET still has a few rooms available for Irish Open players at an exclusive, discounted rate of €179 per night Single B&B and €189 per night Double B&B.
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.