0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0093 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2025-09-12' AND `url` = 'https://www.maineventtravel.com/tour/mid-states-poker-tour' ORDER BY `views` DESC

0.0234 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2025-09-12' AND `url` = 'https://www.maineventtravel.com/tour/mid-states-poker-tour'

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.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.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.0041 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` = 'mid-states-poker-tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `page_url` = 'mid-states-poker-tour'

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

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

0.0099 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.0006 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.0002 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%individual-tour-stop%'

English

Mid States Poker Tour


From the deepstack structures to the affordable buy-ins and popular gaming destinations, the MSPT is designed to cater directly to POKER PLAYERS — those who clamor for affordable buy-ins that offer a shot at large prize pools all while offering kind blind structures that allow for patient play without the fear of blinding out. In fact, the MSPT Main Event structure was personally designed and approved by Allen "Chainsaw" Kessler, a leading authority on poker structures.

Upcoming Tour Stops

Thursday 25th - Sunday 28th September, 2025

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

Nevada Poker State Championship  $300,000 Guarantee

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 30th September - Sunday 5th October, 2025

MSPT Potawatomi Casino

Potawatomi Casino, 1721 W Canal St, Milwaukee, WI 53233, United States

Wisconsin Poker State Championship  $500,000 Guarantee 

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 7th - Sunday 12th October, 2025

MSPT Firekeepers Casino

Firekeepers Casino, 11177 E Michigan Ave, Battle Creek, MI 49014, United States

Michigan Poker State Championship  $1,000,000 Guarantee 

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 9th - Sunday 19th October, 2025

MSPT Playground

Playground Poker Club, 1500 Unit C Route 138, Kahnawake, QC J0L 1B0

Canadian Poker Championship  $1,000,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 28th October - Sunday 2nd November, 2025

MSPT Riverside Casino

Riverside Casino & Golf Resort, 3184 Highway 22, Riverside, IA, United States

MSPT Festival  $300,000 Guarantee 

    Find Hotels, Flights & More       View Complete Schedule  

Tuesday 18th - Sunday 23rd November, 2025

MSPT Ameristar East Chicago

Ameristar Casino Hotel - East Chicago, 777 Ameristar Blvd. East Chicago, IN 46312

MSPT Festival  $300,000 Guarantee 

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 4th - Sunday 14th December, 2025

MSPT Running Aces Casino

Running Aces Casino, 15201 Zurich St, Columbus, MN 55025, United States

Winter Poker Classic Series  $600,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 1st - Sunday 4th January, 2026

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

New Years Poker Open  TBD Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 8th - Monday 19th January, 2026

MSPT Sycuan Casino Resort

Sycuan Casino, 5469 Casino Way, El Cajon, CA 92019, United States

100 GRAND STACK SERIES  $400,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 14th - Sunday 25th January, 2026

MSPT Bally's Black Hawk Casino

Bally's Casino Black Hawk, 300 Main St, Black Hawk, CO 80422, United States

Showdown Series  $400,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 29th January - Sunday 1st February, 2026

MSPT Talking Stick Resort

Talking Stick Resort, 9800 E Talking Stick Wy, Scottsdale, AZ 85256, United States

Diamond Poker Championship  $1,000,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 4th - Saturday 7th February, 2026

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

Poker Bowl X  TBD Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 17th - Sunday 22nd February, 2026

MSPT Potawatomi Casino

Potawatomi Casino, 1721 W Canal St, Milwaukee, WI 53233, United States

Club Poker Championship  $1,000,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 17th - Sunday 22nd March, 2026

MSPT Riverside Casino

Riverside Casino & Golf Resort, 3184 Highway 22, Riverside, IA, United States

MSPT Festival  $500,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 28th April - Sunday 3rd May, 2026

MSPT Potawatomi Casino

Potawatomi Casino, 1721 W Canal St, Milwaukee, WI 53233, United States

MSPT Festival  $1,000,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 12th - Sunday 17th May, 2026

MSPT Firekeepers Casino

FIREKEEPERS CASINO, 11177 E Michigan Ave, Battle Creek, MI 49014, USA

Michigan Poker State Championship  $1,500,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Monday 1st - Tuesday 30th June, 2026

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

Diamond Poker Championship (Dates TBD)  TBD Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 21st - Sunday 26th July, 2026

MSPT Riverside Casino

Riverside Casino & Golf Resort, 3184 Highway 22, Riverside, IA, United States

Iowa Poker State Championship  $500,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Wednesday 22nd July - Sunday 2nd August, 2026

MSPT Bally's Black Hawk Casino

Bally's Casino Black Hawk, 300 Main St, Black Hawk, CO 80422, United States

Colorado Poker State Championship  $600,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 1st - Wednesday 30th September, 2026

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

Nevada Poker State Championship (Dates TBD)  TBD Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 22nd - Sunday 27th September, 2026

MSPT Potawatomi Casino

Potawatomi Casino, 1721 W Canal St, Milwaukee, WI 53233, United States

Wisconsin Poker State Championship  $1,000,000 Guarantee

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 13th - Sunday 18th October, 2026

MSPT Firekeepers Casino

FIREKEEPERS CASINO, 11177 E Michigan Ave, Battle Creek, MI 49014, USA

SPADE POKER CHAMPIONSHIP  $1,500,000 Guarantee 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 3rd - Sunday 8th November, 2026

MSPT Riverside Casino

Riverside Casino & Golf Resort, 3184 Highway 22, Riverside, IA, United States

MSPT Festival  $500,000 Guarantee 

    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.