0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0057 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-26' AND `url` = 'https://www.maineventtravel.com/tour/france-poker-series' ORDER BY `views` DESC

0.0079 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-26' AND `url` = 'https://www.maineventtravel.com/tour/france-poker-series'

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

0.0062 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.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` = 'france-poker-series'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'france-poker-series'

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

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

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

France Poker Series


France Poker Series (FPS) welcomes you to some of the most glamourous locations in 2024.

Upcoming Tour Stops

Tuesday 23rd April - Saturday 4th May, 2024

FPS Monte-Carlo

Sporting Monte-Carlo, 26 Avenue Princess Grace Monte Carlo 98000 Monaco

A stunning location. Players from around the world. It’s sure to be an incredible poker tournament. Are you ready to join the action and enjoy a once in a lifetime experience?

The star-studded FPS Monte-Carlo is back with all the glitz and the glamor the Principality of Monaco is famous for. If you’re searching for a live event to sample, this one is not to be missed.

With everything from the FPS Cup to the Main Event and High Roller tournaments, there’s going to be incredible poker from day one. Get ready to take your seat at the tables.

FPS Main Event: April 24-28 - €1,100

FPS Cup: April 26-27 - €550

FPS High Roller: April 26-28 - €2,200

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

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 8th - Monday 20th May, 2024

Belgian Poker Challenge

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

PokerStars welcomes you back to the renowned Belgian Poker Challenge after another year of quality action. Situated in Namur, the capital of Wallonia, this truly is a stop that mixes the cut and thrust of intense poker with the rustic beauty of the region.

Explore the ancient citadel, enjoy a UNESCO World Heritage Site or cruise along the river Meuse at the head of the stunning Ardennes. What about the poker? Well, there are big prize pools on offer again and you can claim your share of them when you take your seat at the tables.

Head down to the left bank of the Meuse and experience everything the prestigious Circus Casino Resort Namur has to offer. With a buy-in for most bankrolls, it’d be a shame to miss out on a live event that is growing in stature every year.

BPC Cup: Dates TBC - €330

BPC Main Event: Dates TBC - €1,100

BPC High Roller: Dates TBC - €2,200

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  

Monday 30th September - Sunday 6th October, 2024

FPS Aix Les Bains

Casino Grand Cercle Aix-les-Bains, 200 Rue du Casino, 73100 Aix-les-Bains, France

What’s better than playing world-class poker? How about playing in one of the most beautiful spots the France Poker Series (FPS) has to offer?

The good news is, the FPS has got you covered as FPS Aix-les-Bains returns after its incredible inaugural event in 2023. Situated on the banks of Lake Bourget, this spa town brings all the charm and elegance you’d expect from its picturesque location.

But it’s not all about the surroundings. Last year, the stop proved it’s an event to rival any on the tour, with thrilling action from the outset. As the Casino Grand Cercle is once again set to host, there’s no reason 2024 won’t be another year to remember for live poker aficionados in eastern France.

FPS Cup: Dates TBC - €330

FPS Main Event: Dates TBC - €1,100

FPS High Roller:  Dates TBC - €2,200

#FinalTableFreeroll Eligible Event - Click Here for Details on How You Can Win Back 100% of Your Tournament Travel Costs

    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.