0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour/mid-states-poker-tour', 1, '2024-07-16')

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.0065 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.0002 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.0011 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.0080 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.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.0003 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

Wednesday 17th - Sunday 21st July, 2024

MSPT Riverside Casino

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

IOWA STATE POKER CHAMPIONSHIP  $300,000 GUARANTEE 

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 17th - Sunday 28th July, 2024

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 

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 1st - Sunday 4th August, 2024

MSPT Hollywood Casino

Hollywood Casino St Louis, 777 Casino Center Dr, Maryland Heights, MO 63043

MAIN EVENT  $300,000 GUARANTEE 

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Friday 9th - Sunday 11th August, 2024

MSPT Grand Falls Casino

Grand Falls Casino, 1415 Grand Falls Blvd, Larchwood, IA 51241

MAIN EVENT  $200,000 GUARANTEE 

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Wednesday 14th - Sunday 18th August, 2024

MSPT Jack Cleveland

Jack Cleveland Casino, 100 Public Square, Cleveland, OH 44113

MAIN EVENT  $500,000 GUARANTEE 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 27th August - Monday 2nd September, 2024

MSPT Ameristar East Chicago

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

MAIN EVENT 263  $300,000 GUARANTEE 

#FinalTableFreeroll Eligible Event

    Find Hotels, Flights & More       View Complete Schedule  

Thursday 5th - Sunday 8th September, 2024

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

Main Event 264 - $300,00 Guarantee

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 12th - Sunday 22nd September, 2024

Sycuan Casino Resort

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

Buy-in: TBC 

Guarantee: TBC

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Thursday 10th - Sunday 13th October, 2024

MSPT Firekeepers Casino

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

MICHIGAN STATE POKER CHAMPIONSHIP  $1,000,000 GUARANTEE 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

Tuesday 29th October - Sunday 3rd November, 2024

MSPT Riverside Casino

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

Main Event - $300,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.