0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

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

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.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.0161 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.0012 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%'

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