0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0203 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2026-02-06'
AND `url` = 'https://www.maineventtravel.com/tour/pokerstars-open'
ORDER BY `views` DESC

0.0214 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2026-02-06'
AND `url` = 'https://www.maineventtravel.com/tour/pokerstars-open'

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

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

0.0004 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.0082 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.0004 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.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'pokerstars-open'

0.0003 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'pokerstars-open'

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

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

0.0092 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.0004 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  1. Home
  2. Events
  3. PokerStars Open

PokerStars Open


A new era of live poker in Europe began in 2025 with the launch of the PokerStars Open, an exciting new tour consolidating PokerStars’ popular and prestigious regional tours under one dynamic banner.

The PokerStars Open combines the best elements of the UK and Ireland Poker Tour (UKIPT), Eureka Poker Tour, Estrellas Poker Tour (ESPT), and France Poker Series (FPS) to create a schedule of unmissable events across some of Europe’s most vibrant destinations. 

Upcoming Tour Stops

Monday 16th - Monday 23rd March, 2026

Pokerstars Open Philadelphia

Live! Casino & Hotel Philadelphia , 900 Packer Ave, Philadelphia, PA 19148, United States

PokerStars Open Philadelphia is back at Live! Casino & Hotel Philadelphia, the premier destination for poker in Pennsylvania. 

The inaugural PSO Philly event delivered record-breaking fields and a seven-figure prize pool. Year two raises the bar with seven PokerStars Open trophies on the line, and a full week of exciting high-level tournament action, special guests, giveaways, and a few surprises in store.
    Find Hotels, Flights & More       View Complete Schedule  
Wednesday 27th May - Sunday 7th June, 2026

PokerStars Open Namur

Grand Casino de Namur, Avenue Baron de Moreau 1, 5000 Namur, Belgium

2025 was a record-breaking year for the PokerStars Open Namur. Last year, there were 1,572 entries and €1,493,400 offered in total prize pools, but that doesn’t mean we’re resting on our laurels. This time, we’re aiming to take Namur to the next level – more players, bigger guaranteed prizes and on-the-felt action to rival the entire PokerStars Open. Talk about the biggest poker festival in Belgium.

One thing that won’t change is the location. Namur is an historical city split by two rivers. On the right side, you’ll find the old town that’s home to the ancient Citadel which has been given UNESCO World Heritage status. To the left is the Circus Casino Resort Namur, a venue fit to host a popular live poker event in the heart of Wallonia.

So, whichever side you choose when you’re in Namur, you’ll never be far away from the action, whether it’s at the tables or off-the-felt.
    Find Hotels, Flights & More       Full Schedule Coming Soon  
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.