0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-07-06' AND `url` = 'https://www.maineventtravel.com/tour/partypoker-tour' ORDER BY `views` DESC

0.0107 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-07-06' AND `url` = 'https://www.maineventtravel.com/tour/partypoker-tour'

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

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

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'partypoker-tour'

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

0.0016 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` = '92' ORDER BY `tour_stops`.`start_date` ASC

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

PartyPoker Tour


Live events are back in 2025

From screen to scene, PartyPoker is giving our players the opportunity to join the action live. With five incredible events across the UK, the tour is not just poker – it’s a celebration of our poker community.

Upcoming Tour Stops

Tuesday 12th - Sunday 17th August, 2025

Glasgow

Alea Casino, Springfield Quay, Paisley Rd, Glasgow G5 8NP

Main Event Buy-In - £500 

Mini Main Buy-In - £150

High Roller - £1000

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 14th - Sunday 19th October, 2025

Birmingham

Genting International Casino, Resorts World at the NEC, Pendigo Way, Birmingham B40 1PU

Genting Casino is bringing the action of the PartyPoker Tour to Resort World Birmingham!

Birmingham isn't just a city - its a vibe. Known for its rich industrial heritage, cutting edge cultural scene, and diverse dining experiences, Resort World Genting, nestled on the edge of the Pendigo Lake, offers the perfect setting. 

  • £500 Main Event: 16th - 19th October
  • £150 Mini PPT: 14th - 16th October
  • £1000 High Roller: 19th October 

    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.