0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0079 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-05' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/117/285/updates' ORDER BY `views` DESC

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/117/285/updates', 1, '2024-11-05')

0.0003 SECONDS:
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, 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_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `tour_stop_blogs`.`id` = '117'

0.0006 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '117'

0.0320 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0067 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '283' AND `published` = 1

0.0298 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0066 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '284' AND `published` = 1

0.0300 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0067 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '285' AND `published` = 1

0.0519 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0070 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '287' AND `published` = 1

0.0310 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0074 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '288' AND `published` = 1

0.0082 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '285' ORDER BY `busted` ASC, `current_chips` DESC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '285' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0285 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12755' ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12754' ORDER BY `chip_change` DESC, `busted` ASC

0.0090 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12753' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12752' ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12751' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12750' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12749' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12748' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12747' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12746' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12745' ORDER BY `chip_change` DESC, `busted` ASC

0.0274 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12744' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12743' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12736' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12735' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12734' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12733' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12732' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12731' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12727' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12726' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12723' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12722' ORDER BY `chip_change` DESC, `busted` ASC

0.0276 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12721' ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12720' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12719' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12718' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12717' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12716' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12715' ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12714' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12713' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12712' ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12711' ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12710' ORDER BY `chip_change` DESC, `busted` ASC

0.0279 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12709' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12708' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12707' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12706' ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12705' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12704' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12702' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12701' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12700' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12699' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12698' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12697' ORDER BY `chip_change` DESC, `busted` ASC

0.0276 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12696' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12695' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12694' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12693' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12692' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '285' ORDER BY `busted` ASC, `current_chips` DESC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '285' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0068 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12755' ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12754' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12753' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12752' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12751' ORDER BY `chip_change` DESC, `busted` ASC

0.0274 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12750' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12749' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12748' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12747' ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12746' ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12745' ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12744' ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12743' ORDER BY `chip_change` DESC, `busted` ASC

0.0098 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12736' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12735' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12734' ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12733' ORDER BY `chip_change` DESC, `busted` ASC

0.0170 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12732' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12731' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12727' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12726' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12723' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12722' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12721' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12720' ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12719' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12718' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12717' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12716' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12715' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12714' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12713' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12712' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12711' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12710' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12709' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12708' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12707' ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12706' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12705' ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12704' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12702' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12701' ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12700' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12699' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12698' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12697' ORDER BY `chip_change` DESC, `busted` ASC

0.0065 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12696' ORDER BY `chip_change` DESC, `busted` ASC

0.0082 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12695' ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12694' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12693' ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '12692' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '288' ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2445

Translate
WSOPC Deerfoot Inn & Casino Event #3: $400 4-Flight ($330 + $70) Live Reporting - Day 2

Current Level 31 Current Day 2
Blinds 150,000/250,000 Ante 250,000
Entries 1,101 Remaining 2
Prize Pool (CAD) $CAD363,330 First Prize (CAD) $CAD58,815
1 New Update - Click to refresh
Live Updates - Day 1D
Skytrain Leads Day 1d Counts Posted Saturday 4th May, 2024 at 21:48(UTC-7) by Lyle Bateman

Zeyu 'Skytrain' Huang was the only player on 1d to bag more than a million chips, but Romualdo Cusano wasn't too far away with 979k while Michael Baldwin bagged 801k for third place.

Day 1d Chips

Table

Seat

Player

Hometown

Chips

29 1 Zeyu 'Skytrain' Huang Calgary, AB 1,048,000
20 4 Romualdo Cusano n. Vancouver, BC 979,000
24 2 Michael Baldwin Calgary, AB 801,000
29 3 Mason St. Martin Calgary, AB 676,000
29 5 Sung Roh Toronto, ON 510,000
29 7 Adam Crockett n. Vancouver, BC 503,000
29 6 Kambiz Zamani Hudson, MA, USA 434,000
21 6 Shawn Taghavi Edmonton, AB 434,000
24 3 Clint Galloway Edmonton, AB 387,000
25 4 Guanghui Li Edmonton, AB 377,000
20 5 Kyle Kamachi Surrey, BC 360,000
21 7 Jerry Li Calgary, AB 282,000
29 2 Dolant Limbago Calgary, AB 216,000
22 3 Tyler Thomas Chestermere, AB 204,000
29 4 Sachin Sehgal Calgary, AB 187000
25 3 Ivan Chuvyrov Calgary, AB 185,000
20 9 Steven Arsenault Calgary, AB 164,000
22 2 Dusty Speta Crossfield, AB 145,000
29 9 Bill Duncan Kamloops, BC 129,000
25 5 Jason McArthur Calgary, AB 127,000
28 5 Marcus Culver Whistler, BC 79,000
Day 1d is Over Posted Saturday 4th May, 2024 at 21:32(UTC-7) by Lyle Bateman

Day 1d is over with 21 players bagging chips during Level 18. Oleksander Lobur was the unfortunate bag bubble tonight taking 22nd place for $1,030. While 39th place is yet to report in, the rest of the payouts are below, with a few players who requested anonymity.

Place

Player

Hometown

Prize

22 Oleksandr Lobur Ukraine $1,030
23 Thomas Taylor Calgary $1,030
24 Leo Leclerc
Navin Mb
$1,030
25 Paul Sokoloff
London Uk
$905
26 Dnr $905
27 Ryan Down Calgary $905
28 Adam Chipiuk
Edmonton
$809
29 Essan Saadeddine Calgary $809
30 Cody Koncz
Lethbridge
$809
31 Patrick Woelk
Abbotsford Bc
$737
32 Lonnie Gorrill Calgary $737
33 Manvir Dhaliwal Calgary $737
34 Krystian Hady Calgary $683
35 Ryan Teixeira
Edmonton
$683
36 Zishang Liu Calgary $683
37
Wesley Terpstra
$644
38 Dnr $644
39 $644
40 Hassan Issa
Chilliwack Bc
$644
41 Ryan Parungao
Navin Mb
$644
42 Claire Leclerc Calgary $644
43 Austin Vickers Calgary $644
44 Zhi Yang
Richmond Bc
$644
45 Shane Brotherwood Calgary $644
46 Jaskaran Brar
Rocky View
$620
47 Palvinder Brar Calgary $620
48 Agostinho Gomes
Vancouver
$620
49 Jordan Johnstone
Chestermere
$620
50 Abhizer Rajkotwala
Vancouver
$620
51 Garrett Birch
Prince George Bc
$620
52 Cory Malenfaut Regina $620
53 John Smith
Vancouver
$620
54 Roza-Pereira Seadon
New Westminister Bc
$620
55 Nicholas Andreas
Medicine Hat
$607
56 Peter Svoboda Calgary $607
57 Kevin Kammavong Calgary $607
58 Fred Werezak
Desert Blume Ab
$607
59 Boawei Sun Calgary $607
60 Fred Parsons
Kamloops Bc
$607
61 Antonio Ma Calgary $607
62 Haven Taylor Calgary $607
Bubble to End of Day Posted Saturday 4th May, 2024 at 21:08(UTC-7) by Lyle Bateman

They are down to 22 left now in 1d after Thomas Taylor hit the rais for 23rd place. That leaves them just one player off the end of the night with Level 18 just underway.

21:07 (UTC-7)
Start of Level 18
Blinds: 6,000/12,000     Ante: 12,000
Two Away from End Posted Saturday 4th May, 2024 at 21:01(UTC-7) by Lyle Bateman

Leo Leclerc was the most recent casualty from 1d for 24th place, leaving them just two eliminations off the end of the day with just over five minutes to play in Level 17.

Three Off the End of the Day Posted Saturday 4th May, 2024 at 20:55(UTC-7) by Lyle Bateman

They are down to 24 players left now with just over 10 minutes to play in Level 17. That means they are only three eliminations away from the money spots. Paul Sokoloff, and DNR player, and Ryan Down are the recent busts.

Corrected Payout List Posted Saturday 4th May, 2024 at 20:47(UTC-7) by Lyle Bateman

There was a discrepancy on the payouts but it's been resolved now. Most of the earliest cahses were correct but some positions have changed slightly in the list below.

Place

Player

Hometown

Prize

C">28 C)">Adam Chipiuk C">Edmonton $809
C">29 C)">Essan Saadeddine C">Calgary $809
C">30 C)">Cody Koncz C">Lethbridge $809
C">31 C)">Patrick Woelk C">Abbotsford Bc $737
C">32 C)">Lonnie Gorrill C">Calgary $737
C">33 C)">Manvir Dhaliwal C">Calgary $737
C">34 C)">Krystian Hady C">Calgary $683
C">35 C)">Ryan Teixeira C">Edmonton $683
C">36 C)">Zishang Liu C">Calgary $683
C">37 C)">Wesley Terpstra C"> $644
C">38 C)">Dnr C"> $644
C">39 C)"> C"> $644
C">40 C)">Hassan Issa C">Chilliwack Bc $644
C">41 C)">Ryan Parungao C">Navin Mb $644
C">42 C)">Claire Leclerc C">Calgary $644
C">43 C)">Austin Vickers C">Calgary $644
C">44 C)">Zhi Yang C">Richmond Bc $644
C">45 C)">Shane Brotherwood C">Calgary $644
C">46 C)">Jaskaran Brar C">Rocky View $620
C">47 C)">Palvinder Brar C">Calgary $620
C">48 C)">Agostinho Gomes C">Vancouver $620
C">49 C)">Jordan Johnstone C">Chestermere $620
C">50 C)">Abhizer Rajkotwala C">Vancouver $620
C">51 C)">Garrett Birch C">Prince George Bc $620
C">52 C)">Cory Malenfaut C">Regina $620
C">53 C)">John Smith C">Vancouver $620
C">54 C)">Roza-Pereira C">New Westminister Bc $620
C">55 C)">Nicholas Andreas C">Medicine Hat $607
C">56 C)">Peter Svoboda C">Calgary $607
C">57 C)">Kevin Kammavong C">Calgary $607
C">58 C)">Fred Werezak C">Desert Blume Ab $607
C">59 C)">Boawei Sun C">Calgary $607
C">60 C)">Fred Parsons C">Kamloops Bc $607
C">61 C)">Antonio Ma C">Calgary $607
C">62 C)">Haven Taylor C">Calgary $607
1d Cashers so Far Posted Saturday 4th May, 2024 at 20:26(UTC-7) by Lyle Bateman

Day 1d Payouts to 30th Place

Place

Player

Hometown

Prize

30 PATRICK WOELK PORT COQUITLAM #,##0","3":1}">$809
31 LONNIE GORRILL ABBOTSFORD BC #,##0","3":1}">$737
32 MANVIR DHALIWAL CALGARY #,##0","3":1}">$737
33 KRYSTIAN HADY CALGARY #,##0","3":1}">$737
34 RYAN TEIXEIRA CALGARY #,##0","3":1}">$683
35 ZISHANG LIU EDMONTON #,##0","3":1}">$683
36 WESLEY TERPSTRA CALGARY #,##0","3":1}">$683
37 DNR #,##0","3":1}">$644
38 ARMIN BAHMANPOUR VANCOUVER #,##0","3":1}">$644
39 HASSAN ISSA CALGARY #,##0","3":1}">$644
40 RYAN PARUNGAO CHILLIWACK BC #,##0","3":1}">$644
41 CLAIRE LECLERC NAVIN MB #,##0","3":1}">$644
42 AUSTIN VICKERS CALGARY #,##0","3":1}">$644
43 #,##0","3":1}">$644
44 ZHI YANG RICHMOND BC #,##0","3":1}">$644
45 SHANE BROTHERWOOD CALGARY #,##0","3":1}">$644
46 JASKARAN BRAR ROCKY VIEW #,##0","3":1}">$620
47 PALVINDER BRAR CALGARY #,##0","3":1}">$620
48 AGOSTINHO GOMES VANCOUVER #,##0","3":1}">$620
49 JORDAN JOHNSTONE CHESTERMERE #,##0","3":1}">$620
50 ABHIZER RAJKOTWALA VANCOUVER #,##0","3":1}">$620
51 GARRETT BIRCH PRINCE GEORGE BC #,##0","3":1}">$620
52 CORY MALENFAUT REGINA #,##0","3":1}">$620
53 JOHN SMITH VANCOUVER #,##0","3":1}">$620
54 ROZA-PEREIRA NEW WESTMINISTER BC #,##0","3":1}">$620
55 NICHOLAS ANDREAS MEDICINE HAT #,##0","3":1}">$607
56 PETER SVOBODA CALGARY #,##0","3":1}">$607
57 KEVIN Kammavong CALGARY #,##0","3":1}">$607
58 FRED WEREZAK DESERT BLUME AB #,##0","3":1}">$607
59 Boawei Sun Calgary #,##0","3":1}">$607
60 Fred Parsons Kamloops BC #,##0","3":1}">$607
61 Antonio Ma Calgary #,##0","3":1}">$607
62 Haven Taylor Calgary #,##0","3":1}">$607
20:24 (UTC-7)
Start of Level 17
Blinds: 5,000/10,000     Ante: 10,000
8 Off the End of Day at Final Break Posted Saturday 4th May, 2024 at 20:20(UTC-7) by Lyle Bateman

It doesn't look like Day 1d will go too much longer once players return from their break for Level 17. They are down to 29 left now and the bags will come out at 21. It seems likely that they'll play most of Level 17 at least but I'll be surprised if they make it as far as the end of Level 18.

12 Off the End of the Day Posted Saturday 4th May, 2024 at 20:06(UTC-7) by Lyle Bateman

There are just over 10 minutes remaining in Level 16 now with 33 players left in the game. That puts them 12 off the end of the night at 21 players and they have four scheduled levels after this one to get there.

19:45 (UTC-7)
Start of Level 16
Blinds: 4,000/8,000     Ante: 8,000
Down to 42 Left Posted Saturday 4th May, 2024 at 19:45(UTC-7) by Lyle Bateman

Payout So Far for Day 1d

Place

Player

Hometown

Prize

43 AUSTIN VICKERS CALGARY $644
44 ZHI YANG RICHMOND BC $644
45 SHANE BROTHERWOOD CALGARY $644
46 JASKARAN BRAR ROCKY VIEW $620
47 PALVINDER BRAR CALGARY $620
48 AGOSTINHO GOMES VANCOUVER $620
49 JORDAN JOHNSTONE CHESTERMERE $620
50 ABHIZER RAJKOTWALA VANCOUVER $620
51 GARRETT BIRCH PRINCE GEORGE BC $620
52 CORY MALENFAUT REGINA $620
53 JOHN SMITH VANCOUVER $620
54 ROZA-PEREIRA NEW WESTMINISTER BC $620
55 NICHOLAS ANDREAS MEDICINE HAT $607
56 PETER SVOBODA CALGARY $607
57 KEVIN Kammavong CALGARY $607
58 FRED WEREZAK DESERT BLUME AB $607
59 Boawei Sun Calgary $607
60 Fred Parsons Kamloops BC $607
61 Antonio Ma Calgary $607
62 Haven Taylor Calgary $607
Payouts So Far Posted Saturday 4th May, 2024 at 19:24(UTC-7) by Lyle Bateman

Day 1d Payouts So Far

Place

Player

Hometown

Prize

51 GARRETT BIRCH PRINCE GEORGE BC #,##0","3":1}">$620
52 CORY MALENFAUT REGINA #,##0","3":1}">$620
53 JOHN SMITH VANCOUVER #,##0","3":1}">$620
54 ROZA-PEREIRA NEW WESTMINISTER BC #,##0","3":1}">$620
55 NICHOLAS ANDREAS MEDICINE HAT #,##0","3":1}">$607
56 PETER SVOBODA CALGARY #,##0","3":1}">$607
57 KEVIN Kammavong CALGARY #,##0","3":1}">$607
58 FRED WEREZAK DESERT BLUME #,##0","3":1}">$607
59 Boawei Sun Calgary #,##0","3":1}">$607
60 Fred Parsons Kamloops BC #,##0","3":1}">$607
61 Antonio Ma Calgary #,##0","3":1}">$607
62 Haven Taylor Calgary #,##0","3":1}">$607
19:22 (UTC-7)
Start of Level 15
Blinds: 3,000/6,000     Ante: 6,000
In the Money Posted Saturday 4th May, 2024 at 19:10(UTC-7) by Lyle Bateman

I went for a quick dinner and when I returned they were already in the money in Day 1d. The field is down to 57 remaining now, but there is a line at the payout desk, so things are moving quickly. So far, Haven Taylor, Antonio Ma, Fred Parsons, Baowei Sun, and Fred Werezak have collected payouts with more to come shortly.

19:08 (UTC-7)
Start of Level 14
Blinds: 3,000/5,000     Ante: 5,000
Back from Dinner Posted Saturday 4th May, 2024 at 18:15(UTC-7) by Lyle Bateman

The dinner break is nearly over and there are 75 players returning to action in Level 13. That puts them 13 off the money spots for tonight, so it looks like the bubble play will start near the end of this level or the start of Level 14.

18:13 (UTC-7)
Start of Level 13
Blinds: 2,000/4,000     Ante: 4,000
Dinner Time with 81 Left Posted Saturday 4th May, 2024 at 17:31(UTC-7) by Lyle Bateman

They are down to 81 players left in 1d now with players heading out for dinner. They'll be back in action in Level 13 in about 45 minutes, with 19 players to go until the money spots.

15 Minutes to Dinner Posted Saturday 4th May, 2024 at 17:17(UTC-7) by Lyle Bateman

There are just under 15 minutes to go in Level 12 with the dinner break scheduled at the end of this level. They are down to 90 players left in the game so there will still be a way to go till the bubble once they return from dinner.

17:00 (UTC-7)
Start of Level 12
Blinds: 2,000/3,000     Ante: 3,000
99 Players Left in 1d Posted Saturday 4th May, 2024 at 16:54(UTC-7) by Lyle Bateman

1d is now down to less than 100 players left alive now with just over 5 minutes to play in Level 11. They'll go for dinner at the end of Level 12, and when they return from dinner there are 8 more levels on the schedule for today. The day will end early if they hit 21 players before the end of Level 20 and at this point, it looks like an even bet as to which endpoint will kick in.

Tentative Day 2 Prizes are In, $58k for the Winner Posted Saturday 4th May, 2024 at 16:46(UTC-7) by Lyle Bateman

The Day 2 prizes have been released, but they are based on the assumption that today's flight plays down to 21 players. For the time being, I'm not going to publish them until we get confirmation that they are official, but regardless of the finish tonight, it looks like 1st place tomorrow should be set to pocket at least $58k. If they play down to 21 today, then 57 players will be returning tomorrow with the min-cash spots starting at $1,374.

Day 1d Payouts are In Posted Saturday 4th May, 2024 at 16:41(UTC-7) by Lyle Bateman

The Day 1d payouts are now up and the 1d field is confirmed at 412 for 1,101 in total across all four flights. Players will start getting paid tonight at 62nd place, and at least 21 players will bag up at the end of the night.

Day 1d Payouts

Place

Prize

1-21 Day 2
22 $1,030
23 $1,030
24 $1,030
25 $905
26 $905
27 $905
28 $809
29 $809
30 $809
31 $737
32 $737
33 $737
34 $683
35 $683
36 $683
37 $644
38 $644
39 $644
40 $644
41 $644
42 $644
43 $644
44 $644
45 $644
46 $620
47 $620
48 $620
49 $620
50 $620
51 $620
52 $620
53 $620
54 $620
55 $607
56 $607
57 $607
58 $607
59 $607
60 $607
61 $607
62 $607
16:36 (UTC-7)
Start of Level 11
Blinds: 1,500/2,500     Ante: 2,500
Dow to 135 Left Posted Saturday 4th May, 2024 at 16:05(UTC-7) by Lyle Bateman

Level 10 has just begun and they are down to 135 players left alive. Among the players still in the game today are Lorne Voth, Sunny Lubana Allen Shen, Kali Shuali, Fay Barker, Jordan Banfield, Shane Brotherwood, Claire Leclerc, and Zeyu "Skytrain" Huang.

16:01 (UTC-7)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
Down to 162 Left in 1d Posted Saturday 4th May, 2024 at 15:43(UTC-7) by Lyle Bateman

The ya re down to 162 players left in Flight 1d now with a bit more than 15 minutes to play in Level 9. They'll go for a dinner break following Level 12 and then return to play until the end of Level 20, or they hit 21 players, whichever comes first.4

Day 1d and Day 2 prizes should be out shortly and I'll confirm all the numbers then.

1,100 Entries Cracked Posted Saturday 4th May, 2024 at 15:33(UTC-7) by Lyle Bateman

Entries are now closed for the 4-Flight and the unofficial total for 1d was 412 entries. That means the total field size hit 1,101 for total prizes of $363,330.

While those numbers are still yet to be confirmed, if they hold it will mean 62 players get a piece of the prize money from today, with at least 21 advancing to Day 2 on Sunday.

15:30 (UTC-7)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Second Break Posted Saturday 4th May, 2024 at 15:17(UTC-7) by Lyle Bateman

Level 8 is coming to a close and that means there are just 15 minutes to get into the game. 1d is over 400 entries and the total field is nearing 1,100.

Final Level of Entry for 4-Flight Posted Saturday 4th May, 2024 at 14:47(UTC-7) by Lyle Bateman

The 4-Flight game is into the final level of entries now so there is about 45 minutes to get into this game. The total field is now 21 away from 1,100 and the 1d field is 10 away from 400 total entries.

14:45 (UTC-7)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
27 Entries from 1,100 Posted Saturday 4th May, 2024 at 14:42(UTC-7) by Lyle Bateman

The total field size for E3 is now up to 1,073 so they are inching ever closer to 1,100 total entries. This year is already more than 100 entries above last year, and with 45 minutes still left to enter, it looks like 1,100 isn't out of the question.

More than $350k in Prizes Posted Saturday 4th May, 2024 at 14:30(UTC-7) by Lyle Bateman

There is about an hour left to get into the game still, and the prize pool just capped $350k with 1,064 entries in total across all four flights. Day 1d has 375 entries alone now, and it looks like a decent bet to flirt with 400 before entries close at the start of Level 9. There are now about 15 minutes remaining in Level 7, and they'll take another break following Level 8 before entries close for good on the 4-Flight.

14:15 (UTC-7)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
More than $340k in Prizes Posted Saturday 4th May, 2024 at 14:03(UTC-7) by Lyle Bateman

The 4-flight field is now up to 1,031 for prizes of $340,230. With about 90 minutes left to enter the game, it looks possible the prize pool will crack $350k, though that would require another 28 entries before the beginning of Level 9. There are about 10 minutes remaining in Level 6 at the moment.

Nearing $335k in Prizes Posted Saturday 4th May, 2024 at 13:48(UTC-7) by Lyle Bateman

Level 6 is just beginning with the total field up to 1,015 and prizes of $334,950. Toby Wu, Michael Smith, Doug Lee, Shane Brotherwood, and Thomas Taylor are among the players I've spotted in the field today.

13:43 (UTC-7)
Start of Level 6
Blinds: 400/800     Ante: 800
More than 1,000 Entries Posted Saturday 4th May, 2024 at 13:36(UTC-7) by Lyle Bateman

The 4-Flight field just capped 1,000 entries with 315 on the board now for Day 1d. That also pushes the prize pool over $330k with just under two hours to go in registration.

300 Entries on the Board Posted Saturday 4th May, 2024 at 13:19(UTC-7) by Lyle Bateman

Day 1d just hit 300 entries for a total of 989 across all four flights so far. That puts the combined prizes at $326,370 with more than 2 hours left to get into this one. Among the other players I've spotted today in the mix are Antoine Saddleback, Kim Pham, Juss Viet, Stephen Dauphinais, Matt Kwong, Teo Sanchez, and Ryan Smith, but that is still FAR from a comprehensive list.

13:16 (UTC-7)
Start of Level 5
Blinds: 300/600     Ante: 600
Ahead of Last May Posted Saturday 4th May, 2024 at 13:02(UTC-7) by Lyle Bateman

The break following Level 4 is about to begin and the four-flight field is now ahead of last May's numbers with 972 total now. It looks pretty certain at this point that they'll end up with more than 1,000 entries, as they are less than 30 away from that now with 2.5 hours left to enter. While previous flights have tended to slow considerably as late entry ends, given this is the last chance for a bag in this event, it seems likely the reentries will be brisk right up until the final moment.

With 972 entries, the prizes now are a bit more than $320k.

16 Off May 2023 Posted Saturday 4th May, 2024 at 12:32(UTC-7) by Lyle Bateman

Level 4 has just begun and the 1d field is now up to 259 entries for 948 in total. That puts the prizes at $312,840 with about 3 hours left to enter the game.

At this point, beating last May's 964 seems like a lock, and the 4-day field could flirt with 1,000 entries by the start of Level 9 tonight.

12:30 (UTC-7)
Start of Level 4
Blinds: 300/500     Ante: 500
Less than 40 Entries Away from Last May's Total Posted Saturday 4th May, 2024 at 12:20(UTC-7) by Lyle Bateman

The field is up to 928 now across all four starting flights. Last May, this event saw a total of 964 entries so this year looks to be on pace to break that total with entries still open for more than 3 hours.

So far, I haven't had a good look around the room yet, but as expected, there are a lot of familiar faces out there today. For an early list, from my spot behind the computer, I can see Nicholas Peterson, Phil Wright, Dave Howat, Zeyu "Skytrain" Huang, Hari Aujla, and Claire Leclerc. Leclerc was among the players to cash in yesterday's flight 1b.

More than $300k in Prizes Posted Saturday 4th May, 2024 at 12:07(UTC-7) by Lyle Bateman

The action for Day 1d is now in Level 3 with the field already up to 229 entries. That puts the total field up to 918 across all four days so far for $302,940 in prizes.

12:02 (UTC-7)
Start of Level 3
Blinds: 200/400     Ante: 400
Day 1d is Set to go with 689 Entries Already Posted Saturday 4th May, 2024 at 03:15(UTC-7) by Lyle Bateman

Event #3: $400 4-Flight ($330 + $70)

Date: Day 1a/c: May 2/3, 2024, 4 PM, Day 1b/d: May 3/4, 2024, 11AM
Start Stack: 20,000
Blinds: 30 Min
Late Entry: 8 Levels (~8:30 PM/3:30 PM)
Day 1 Ends: 20 Levels or 5% of the field (Level 20 should end about 3 AM/11:30 PM)

The 4-Flight is among the most popular events of the series, and previous editions of the game have crushed local field size records. In January of this year, the field across all 4 starting days topped out at an astonishing 1,715 entries while last May's numbers hit 964.

The first flight gets going at 4 PM on Thursday with two more flights on Friday and a final shot at a bag on Saturday morning. Day 2 will pay out the big money on Sunday, but 15%-5% on Day 1 will also be heading home with money as Day 1 play goes until there are 5% of the field left, or until the end of Level 20, whichever comes first.

Entries are open for the first 8 levels of play on Day 1, which will put the last chance to enter at either 8:30 PM for the late start days, or 3:30 PM for the early start days. Day 1b & c of this event will be my focus on Friday, but for today, Day 1a won't get much coverage until after Event #2 is complete.

03:12 (UTC-7)
Day 1D of WSOPC Deerfoot Inn & Casino Started
Level: 1     Blinds: 100/200     Ante: 200
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.