0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0081 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-05-19' 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.0005 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' 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 * 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.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0073 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.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.0012 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.0066 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.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

Saturday 25th - Tuesday 28th May, 2024

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

$1,100 Main Event Buy-in with a guaranteed prize pool of $500,000

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

    Find Hotels, Flights & More       View Complete Schedule  

Monday 3rd - Wednesday 5th June, 2024

MSPT The Venetian

The Venetian, The Venetian, Las Vegas, Nevada

$1,600 Main Event Buy-in with a guaranteed prize pool of $750,000

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

    Find Hotels, Flights & More       View Complete Schedule  

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 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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 

    Find Hotels, Flights & More       Full Schedule Coming Soon  

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 

    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.