0.0007 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0247 SECONDS:
SELECT `views` FROM `page_views` WHERE `date` = '2024-02-23' AND `url` = 'https://www.maineventtravel.com/tour/france-poker-series' LIMIT 1

0.0016 SECONDS:
INSERT INTO `page_views` (`url`, `date`, `views`) VALUES ('https://www.maineventtravel.com/tour/france-poker-series', '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.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` = 'tour'

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

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

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

0.0133 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.0007 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.0002 SECONDS:
SELECT * FROM `tours` WHERE `id` = 'france-poker-series'

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

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

0.0035 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.0187 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.0016 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.0008 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.0005 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 2023.

Upcoming Tour Stops

Wednesday 14th - Sunday 25th February, 2024

FPS Paris

Palais des Congrès de Paris, 2 place de la Porte Maillot, 75017 Paris, France

That’s right. The France Poker Series (FPS) returns to Paris this February hot on the heels of EPT Paris. And with a new venue, it’s going to be bigger than ever thanks to the higher capacity of Le Palais des Congrès de Paris. So, if you’re looking for the thrill of live poker in the city of love on Valentine’s Day, now’s the perfect time to get involved.

With buy-ins for every bankroll to €1,100 for the Main Event, there’s something for everyone at the reinvigorated FPS Paris. PokerStars and Le Palais des Congrès de Paris can’t wait for you to see it.

FPS Main Event: February 14-19 - €1,100

FPS Cup: February 17-18 - €550

FPS High Roller: February 18-19 - €2,200

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

    Find Hotels, Flights & More       View Complete Schedule  

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: Dates TBC - €550

FPS High Roller: Dates TBC - €2,200

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

    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.