0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0070 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-11' AND `url` = 'https://www.maineventtravel.com/tour/wsop-international-circuit' ORDER BY `views` DESC

0.0103 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-11' AND `url` = 'https://www.maineventtravel.com/tour/wsop-international-circuit'

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.0003 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.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.0037 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.0005 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` = 'wsop-international-circuit'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'wsop-international-circuit'

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

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

0.0113 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.0010 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.0007 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

WSOP International Circuit


The World Series of Poker (WSOP) announced the return of its WSOP Circuit (WSOP-C), featuring 18 stops both domestic and international, that run through the end of the calendar year. The highly anticipated regional poker tour returns for its 20th season beginning Wednesday, July 19 at Choctaw Casino Resort immediately following the conclusion of the 2024 World Series of Poker in Las Vegas. Additional dates for 2025 will be announced later this fall.

Upcoming Tour Stops

Wednesday 1st - Tuesday 14th January, 2025

King's Resort

Kings Casino, Rozvadov 7 348 06 Rozvadov Czechia

Main Event Buy-In - €1100

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 8th - Monday 20th January, 2025

Deerfoot Inn and Casino

Deerfoot Inn & Casino, 11500 35 St SE #1000, Calgary, AB T2Z 3W4, Canada
    Find Hotels, Flights & More       View Complete Schedule  

Friday 10th - Sunday 19th January, 2025

Es Saadi Marrakech Resort

Casino de Marrakech, Rue Ibrahim El Mazini Hivernage, Marrakech 40000, Morocco

€1350  Main Event Buy-In

    Find Hotels, Flights & More       View Complete Schedule  

Friday 14th - Saturday 22nd March, 2025

Holland Casino

Holland Casino Amsterdam, Max Euweplein 62, 1017 MB Amsterdam, Netherlands

More details to follow

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Friday 11th - Tuesday 22nd April, 2025

Pasino Grand Partouche

Pasino Partouche La Grande Motte, 335 All. des Parcs, 34280 La Grande-Motte, France

More details to follow!

    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.