0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0092 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-may-wsopc-calgary-event-11' ORDER BY `views` DESC

0.0127 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-22' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-may-wsopc-calgary-event-11'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0003 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.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.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.0037 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.0005 SECONDS:
SELECT tour_stop_blogs.*, 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.logo as tour_stop_logo, 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 `friendly_url` = '2024-may-wsopc-calgary-event-11'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '125'

0.0279 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0059 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '299' AND `published` = 1

0.0282 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0058 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '301' AND `published` = 1

0.0279 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0056 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '304' AND `published` = 1

0.0279 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0056 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '306' AND `published` = 1

0.0001 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `id` = '306'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '125' AND `name` = '2'

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

0.0061 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` = '306' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '13612' 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` = '13611' 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` = '13607' 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` = '13606' 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` = '13605' ORDER BY `chip_change` DESC, `busted` ASC

0.0071 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` = '13604' 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` = '13603' 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` = '13602' 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` = '13601' 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` = '13600' ORDER BY `chip_change` DESC, `busted` ASC

0.0071 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` = '13599' 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` = '13594' 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` = '13593' 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` = '13590' 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` = '13589' 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` = '13585' 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` = '13581' 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` = '13578' 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` = '13577' ORDER BY `chip_change` DESC, `busted` ASC

0.0071 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` = '13574' 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` = '13573' 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` = '13570' 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` = '13569' 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` = '13568' 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` = '13567' 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` = '13565' 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` = '13564' 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` = '13561' 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` = '13559' 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` = '13555' 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` = '13556' 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` = '13552' 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` = '13551' 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` = '13550' 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` = '13549' 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` = '13548' 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` = '13542' 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` = '13539' 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` = '13538' 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` = '13537' 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` = '13536' 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` = '13531' 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` = '13530' 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` = '13529' 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` = '13528' 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` = '13527' 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` = '13526' 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` = '13525' 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` = '13524' 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` = '13523' 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` = '13522' 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` = '13521' 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` = '13518' 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` = '13515' 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` = '13514' 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` = '13513' 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` = '13512' 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` = '13511' 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` = '13508' 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` = '13507' 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` = '13506' 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` = '13503' 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` = '13502' 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` = '13499' 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` = '13496' 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` = '13495' 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` = '13494' 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` = '13493' 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` = '13490' 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` = '13489' 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` = '13487' 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` = '13486' 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` = '13483' 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` = '13482' 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` = '13479' 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` = '13476' 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` = '13475' 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` = '13474' 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` = '13473' 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` = '13472' 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` = '13469' 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` = '13468' 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` = '13467' 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` = '13465' 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` = '13464' 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` = '13463' 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` = '13454' 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` = '13453' 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` = '13452' 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` = '13451' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0056 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` = '306' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '13612' 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` = '13611' 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` = '13607' 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` = '13606' 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` = '13605' 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` = '13604' 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` = '13603' 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` = '13602' 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` = '13601' 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` = '13600' 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` = '13599' 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` = '13594' 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` = '13593' 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` = '13590' 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` = '13589' 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` = '13585' 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` = '13581' 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` = '13578' 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` = '13577' 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` = '13574' 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` = '13573' 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` = '13570' 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` = '13569' 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` = '13568' 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` = '13567' 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` = '13565' 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` = '13564' 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` = '13561' 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` = '13559' 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` = '13555' 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` = '13556' 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` = '13552' 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` = '13551' 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` = '13550' 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` = '13549' 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` = '13548' 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` = '13542' 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` = '13539' 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` = '13538' 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` = '13537' 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` = '13536' 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` = '13531' 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` = '13530' 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` = '13529' 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` = '13528' 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` = '13527' 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` = '13526' 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` = '13525' 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` = '13524' 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` = '13523' 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` = '13522' 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` = '13521' 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` = '13518' 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` = '13515' 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` = '13514' 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` = '13513' 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` = '13512' 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` = '13511' 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` = '13508' 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` = '13507' 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` = '13506' 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` = '13503' 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` = '13502' 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` = '13499' 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` = '13496' 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` = '13495' 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` = '13494' 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` = '13493' 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` = '13490' 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` = '13489' 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` = '13487' 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` = '13486' 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` = '13483' 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` = '13482' 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` = '13479' 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` = '13476' 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` = '13475' 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` = '13474' 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` = '13473' 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` = '13472' 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` = '13469' 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` = '13468' 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` = '13467' 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` = '13465' 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` = '13464' 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` = '13463' 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` = '13454' 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` = '13453' 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` = '13452' 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` = '13451' ORDER BY `chip_change` DESC, `busted` ASC

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

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

English
WSOPC Deerfoot Inn & Casino Event #11: $1,700 Main Event ($1,515 + $185) Live Reporting - Day 2

Current Level 35 Current Day 2
Blinds 300,000/600,000 Ante 600000
Entries 911 Remaining 1
Prize Pool (CAD) $CAD1,380,165 First Prize (CAD) $CAD228,734
1 New Update - Click to refresh
Live Updates - Day 2
Nicholas Teeuwen Takes Main Event Ring Out of Alberta for the First Time Posted Monday 13th May, 2024 at 20:36(UTC-7) by Lyle Bateman

It was a good run for Wild Rose Country - Alberta was five for five in WSOP-C Calgary Main Events coming into this sixth edition of the big game. The streak is over now thanks to Chatham, Ontario's Nicholas Teeuwen who put on a strong performance today to take it down.

Teeuwen has been very close to a ring here a couple of times already. He had two third-place finishes last May here at Deefoot, as well as three final table finishes in Circuit Online events on WSOP.ca in Ontario. Now, he finally made it through to the big finish here in May 2024, breaking the Alberta winning streak in the process.

The win today was his biggest cash by far with his previous best runs for $22k here at Deerfoot in the Fall Super Stack last year, followed by $20k in the $1k here at WSOP-C Calgary last May, In fact, this win today represents close to 3 times his previous lifetime earnings on Hendon.

The final hand of the game was a bit of a dream spot for him. He was the big leader and runner-up John Scalise shoved his short stack from the small blind. Teeuwen looked down at pocket kings and snapped it off, way ahead.

It wasn't without sweats though. Scalise was in with and flopped a gutshot draw before turning his queen, giving him a lot more outs for the river than he started with. The river bricked for Scalise though and Teeuwen was the proud owner of the new WSOP-C ring.

John Scalise Out in 2nd Place for $141,369 Posted Monday 13th May, 2024 at 19:30(UTC-7) by Lyle Bateman

John Scalise was in tough against Nick Teeuwen heads up tonight. Teeuwen has been close to a ring here a few times and he seemed determined to close it out this time. They started heads up pretty even, but Teeuwen was aggressive in attacking to chip him down.

He was all in a few times and managed to stay alive, but was never able to get back up into a lead. In the final hand, Teeuwen had about a 4:1 advantage, and Scalise worker up with suited cards and open-shoved, but ran into it.

John Scalise:
Nick Teeuwen:

There was no miracle for Scalise as he was looking for clubs, two-pair, or straight cards to stay alive. He flopped a gutty and turned his queen on , but it wasn't enough, and he had to settle for 2nd tonight.

Player Chips Progress
Nicholas Teeuwen 36,400,000 16,900,000
John Scalise 0 0
18:42 (UTC-7)
Start of Level 35
Blinds: 300,000/600,000     Ante: 600,000
Break Time Posted Monday 13th May, 2024 at 18:36(UTC-7) by Lyle Bateman

Nick Teeuwen has a small lead at the break.

Player Chips Progress
Nicholas Teeuwen 19,500,000 5,000,000
John Scalise 16,900,000 1,100,000
Scalise Boats Up Posted Monday 13th May, 2024 at 18:25(UTC-7) by Lyle Bateman

They both limped preflop and checked the flop. John Scalise check-called for 1 million on the turn, and then fired 2.5 million on the river. Nick Teeuwen called but mucked when Scalise showed queen-six for the turned boat. They are about less than 10 minutes from the next break.

Scalise Doubles but Still 2:1 Down Posted Monday 13th May, 2024 at 18:05(UTC-7) by Lyle Bateman

John Scalise had chipped down to 5.325 million when he shoved nines and Nick Teeuwen called with ace-four. Scalise flopped a set to take it down but the double basically just put him back to 2:1 down.

Teeuwen in the Lead Posted Monday 13th May, 2024 at 17:59(UTC-7) by Lyle Bateman

There are just over 30 minutes remaining in Level 34 and Nick Teeuwen is the chip leader now with about a 2:1 advantage. There haven't been many showdowns so far but Teeuwen is forcing the action on most hands.

Player Chips Progress
Nicholas Teeuwen 24,500,000 6,500,000
John Scalise 12,000,000 6,000,000
Even Steven Posted Monday 13th May, 2024 at 17:39(UTC-7) by Lyle Bateman

The heads up players are pretty much dead even now with around 18 million each.

Player Chips Progress
Nicholas Teeuwen 18,000,000 4,000,000
John Scalise 18,000,000 125,000
Zeyu 'Skytrain' Huang 0 0
17:35 (UTC-7)
Start of Level 34
Blinds: 250,000/500,000     Ante: 500,000
Zeyu Huang Out in 3rd Place for $104,641 Posted Monday 13th May, 2024 at 17:35(UTC-7) by Lyle Bateman

Zeyu "Skytrain" Huang's quest for a Main Event ring just came to an end when Nick Teeuwen shoved the small blind and Sktrain called from the big.

Skytrain:
Nick Teeuwen:

Teeuwen flopped a ten on to win the race and derail the Skytrain.

Teeuwen with Big Double Posted Monday 13th May, 2024 at 17:11(UTC-7) by Lyle Bateman

Shortly after they returned from their break, Nicholas Teeuwen shoved the small blind and after some tank-time, Zeyu Huang called from the big.

Nick Teeuwen:
Zeyu Huang:

"Do you think I punted?" Huang asked his rail as the board ran out .

Player Chips Progress
Nicholas Teeuwen 14,000,000 6,775,000
Zeyu 'Skytrain' Huang 3,500,000 7,525,000
Short Break Posted Monday 13th May, 2024 at 17:02(UTC-7) by Lyle Bateman

The final three players have taken an impromptu break with John Scalise in the lead now. The clock is still running while the players take their break.

Player Chips Progress
John Scalise 18,125,000 17,510,000
Zeyu 'Skytrain' Huang 11,025,000 5,075,000
Nicholas Teeuwen 7,225,000 2,100,000
David Labchuk Out in 4th Place for $78,393 Posted Monday 13th May, 2024 at 16:58(UTC-7) by Lyle Bateman

I missed the action while updating the HR numbers, but John Scalise sent David Labchuk to the payout line just recently. That means the remaining three players are all guaranteed a 6-figure score tonight, and that whoever wins will be collecting their very first Circuit ring.

There's still a race to decide if the Main Event title will stay in Alberta or not as Nicholas Teeuwen is still in the running to take it to Ontario.

16:17 (UTC-7)
Start of Level 33
Blinds: 200,000/400,000     Ante: 400,000
Break Time Posted Monday 13th May, 2024 at 16:17(UTC-7) by Lyle Bateman

Skytrain leads at the break with almost half the chips in play.

Player Chips Progress
Zeyu 'Skytrain' Huang 16,100,000 3,200,000
Nicholas Teeuwen 9,325,000 1,325,000
David Labchuk 4,800,000 500,000
John Scalise 615,000 4,135,000
Toms Varghese Out in 5th Place for $59,449 Posted Monday 13th May, 2024 at 16:01(UTC-7) by Lyle Bateman

They are down to 4 now in the Main after Toms Varghese hit the rail in 5th place. He shoved on John Scalise with the worst ace, but he got there on the turn with his kicker, only to see Scalise hit the better kicker on the river to kick him to the payout line.

Player Chips Progress
Toms Varghese 0 0
Varghese Folds a Big Ace Posted Monday 13th May, 2024 at 15:40(UTC-7) by Lyle Bateman

I arrived at the table with the flop showing and John Scalise with  700k bet out from the big blind. Toms Varghese was in the tank with the short stack on the button, and he eventually mucked.

"For the story," he said with a smile as he folded ace-king face up for the table to see.

Player Chips Progress
Zeyu 'Skytrain' Huang 12,900,000 100,000
Nicholas Teeuwen 8,000,000 1,700,000
David Labchuk 5,300,000 400,000
John Scalise 4,750,000 2,500,000
Toms Varghese 4,400,000 1,300,000
Teeuwen Has the Best Queen Posted Monday 13th May, 2024 at 15:28(UTC-7) by Lyle Bateman

Nicholas Teeuwen raised under the gun to 600k and John Scalise called from the big blind. He check-called for 450k on the flop, and against for 1.4 million on the turn.

Scalise checked again on the river and, after some time in the tank, Teeuwen checked it back. Both players had a queen, but Teeuwen's king kicked Scalise's deuce to the curb.

15:09 (UTC-7)
Start of Level 32
Blinds: 150,000/300,000     Ante: 300,000
Scalise Defends Small Posted Monday 13th May, 2024 at 15:05(UTC-7) by Lyle Bateman

Zeyu "Skytrain" Huang raised the button to 500k and John Scalise called from the small blind. He check-called for 650k on the flop and both players checked the turn.

Scalise led out for 2 million on the river and Huang mucked quickly.

"Good Luck to Me" Posted Monday 13th May, 2024 at 14:57(UTC-7) by Lyle Bateman

David Labchuk raised the button to 550k, then hit the tank when Toms Varghese shoved for 2.2 million from the small blind, with the comment "Good luck to me". He eventually mucked his hand for Varghese to chip up to over 3 million.

Player Chips Progress
Zeyu 'Skytrain' Huang 13,000,000 2,000,000
John Scalise 7,250,000 450,000
Nicholas Teeuwen 6,300,000 3,100,000
David Labchuk 5,700,000 2,300,000
Toms Varghese 3,100,000 700,000
Chip Updates Posted Monday 13th May, 2024 at 14:41(UTC-7) by Lyle Bateman
Player Chips Progress
Zeyu 'Skytrain' Huang 11,000,000 4,400,000
David Labchuk 8,000,000 475,000
John Scalise 7,700,000 4,775,000
Toms Varghese 3,800,000 800,000
Nicholas Teeuwen 3,200,000 2,075,000
Teeuwen Doubles Posted Monday 13th May, 2024 at 14:34(UTC-7) by Lyle Bateman

John Scalise limped the small blind, then snap-called when Nicholas Teeuwen shoved the big. Teeuwen looked to be in rough shape with against , but he hit a five on the flop then ran out to hearts for the big double to stay in the game.

Scalise Trips Up Teeuwen Posted Monday 13th May, 2024 at 14:28(UTC-7) by Lyle Bateman

Nicholas Teeuwen raised to 500k under the gun and John Scalise defended his big blind. Scalise check-called for $400k on the flop. He check-called again for 900k on the turn and both players checked the river. Teeuwen mucked when Scalise shoved for the rivered trips.

With five players left, only Teeuwen has the chance to break the Alberta Main Event dominance. Every previous Main has been won by an Alberta player, and it's looking good for that streak to go six for six now with four of the five remaining players, including the chip leader, hailing from Wild Rose Country. Don't count Teeuwen out though - He's been within spitting distance of a rin here a few times already, and he looks hungry to finally take one down.

14:22 (UTC-7)
Start of Level 31
Blinds: 150,000/250,000     Ante: 250,000
Hardcastle Coolered for 6th Place Posted Monday 13th May, 2024 at 14:06(UTC-7) by Lyle Bateman

While I missed the action directly, winner John Scalise related the hand to me as the break began. It was the final hand before the break when John Scalise raised the button to 450k and Jack Hardcastle called from the big blind. Hardcastle check-called 400k on the two-diamond flop and both players checked the brick turn card.

The river brought both the flush and a four-card straight on the board and Hardcastle bet nearly his whole stack with 1.5 million, then called the rest off when Scalise shoved. Scalise had the nut flush with ace-queen of diamonds while Hardcastle rivered the top end of the straight with jack-nine, but it wasn't enough and the "British phenom" will have to wait until next time for his first Circuit ring.

Player Chips Progress
John Scalise 12,475,000 7,875,000
David Labchuk 7,525,000 975,000
Zeyu 'Skytrain' Huang 6,600,000 1,100,000
Nicholas Teeuwen 5,275,000 4,275,000
Toms Varghese 4,600,000 600,000
Jack Hardcastle 0 0
Hardcastle Takes One Posted Monday 13th May, 2024 at 13:54(UTC-7) by Lyle Bateman

Jack Hardcastle raised to 400k from the hijack and John Scalise called from the big blind. Scalise check-called for 300k on the flop and they both checked the turn.

Scalise checked the river, then called when Hardcastle slid out 550k, but mucked his hand when the Brit rolled over for second pair on the flop. They'll be off for their first break of the day in about 2 minutes and I'll grab accurate chip counts while they are away from the table.

Scalise Tales One Blind on Blind Posted Monday 13th May, 2024 at 13:39(UTC-7) by Lyle Bateman

It was limped preflop between John Scalise in the small blind and Nicholas Teeuwen in the big. They both checked through the flop and Scalise led for 325k on the turn. Teeuwen called to the river but then folded to a bet of 500k from Scalise.

Flush over Flush Posted Monday 13th May, 2024 at 13:24(UTC-7) by Lyle Bateman

Nicholas Teeuwen raised to 400k from the button, and David Labchuk defended his big blind with a call. It all kicked off on the flop when Labchuk check-raised from 300k to 1 million, then snapped off the shove from Teeuwen.

Nicholas Teeuwen:
David Labchuk:

Both players were drawing to the diamond flush and various straights, with Labchuk open-ended and Teeuwen on the gutty to the queen. on the turn gave them both the flush, but left both players on straight flush draws. river bricked out, and Teeuwen's ace-high flush was the winner.

Labchuk Takes it from Small Posted Monday 13th May, 2024 at 13:06(UTC-7) by Lyle Bateman

Nicholas Teeuwen opened to 400k from the cutoff, and he was called by Jack Hardcastle on the button, as well as David Labchuk and Toms Varghese in the blinds. They all checked the flop, but on the turn Labchuk led out for 600 and got folds around to take the pot. Below is a look at the estimated chips to start Level 30

Player Chips Progress
David Labchuk 8,500,000 1,395,000
Zeyu 'Skytrain' Huang 5,500,000 2,680,000
Toms Varghese 5,200,000 735,000
Jack Hardcastle 4,700,000 2,250,000
John Scalise 4,600,000 90,000
13:06 (UTC-7)
Start of Level 30
Blinds: 100,000/200,000     Ante: 200,000
Labchuk Puts Huang in the Blender Posted Monday 13th May, 2024 at 12:44(UTC-7) by Lyle Bateman

The board read and Zeyu Huang checked his big blind, then raised the bet from David Labchuk on the button. Huang made it 1.175 million, but Labchuk re-popped it all-in for 6.825 million.

That sent Huamg into the blender as he agonized over the spot. "I have an overpaid," he said quietly a few times as he was considering his decision. He finally elected to give up his hand as the call was for most of his stack.

Hardcastle Doubles Back Posted Monday 13th May, 2024 at 12:14(UTC-7) by Lyle Bateman

In the next hand, it folded to Jack Hardcastle in the small blind and he shoved the short stack. David Labchuk called him off from the big for a race between his fours and Hardcastle's king-queen overs. Hardcastle flopped a queen and turned a king to take the fours out and grab a double to stay alive.

Big Blind Special for Teeuwen Posted Monday 13th May, 2024 at 12:10(UTC-7) by Lyle Bateman

Jack Hardcastle opened under the gun to 300k and Nicholas Teeuwen defended his big blind with a call. He check-called for 275k on the flop, and again for 700k on the turn. They both checked the river and Teeuwen's jack-three out-turned Hardcastle's ace-seven.

Back for the Final Day Posted Monday 13th May, 2024 at 12:04(UTC-7) by Lyle Bateman

The Main Event is underway with the final 6 players in action. Today the play down to a winner with everyone so far guaranteed at $45k with the winner set to pocket almost $230k.

12:01 (UTC-7)
Start of Level 29
Blinds: 0/0     Ante: 0
Nicholas Teeuwen Leads Final 6 Posted Monday 13th May, 2024 at 00:18(UTC-7) by Lyle Bateman

Day 2 is over with 6 players left in the action and Nicholas Teeuwen leads the way with a bit more than 9.5 million chips. Zeyu "Skytrain" Huang is about 1.5 million behind, while David Labchuk, who won his second ring in the Seniors this series, is in third and looking for his third ring and first non-seniors ring.

Day 3 Chips

Table

Seat

Player

Home

Chips

FT 1 Jack Hardcastle Southsea, UK 2,450,000
FT 2 David Labchuk Calgary, AB 7,105,000
FT 3 Toms Varghese Calgary, AB 4,465,000
FT 4 Zeyu 'Skytrain' Huang Calgary, AB 8,180,000
FT 5 John Scalise Calgary, AB 4,690,000
FT 6 Nicholas Teeuwen Chatham, ON 9,550,000
Player Chips Progress
Nicholas Teeuwen 9,550,000 2,250,000
Zeyu 'Skytrain' Huang 8,180,000 320,000
David Labchuk 7,105,000 805,000
John Scalise 4,690,000 1,510,000
Toms Varghese 4,465,000 1,365,000
Jack Hardcastle 2,450,000 950,000
Huang Sets Up Hardcastle Posted Monday 13th May, 2024 at 00:04(UTC-7) by Lyle Bateman

In the second-last hand of the night, Zeyu Huang raised the cutoff to 240k and Jack Hardcastle called from the big blind. Hardcastle check-called for 330k on the flop, and they both checked the turn. When the hit the river, Hardcastle bet 1.32 million, and Huang called.

Jack Hardcastle:
Zeyu Huang:

Hardcastle flopped top pair, but Huang flopped the set for the win. Day 2 is now complete and the final six players are bagging up for the night. Stay tuned for the final 6 chip stacks shortly.

Labchuk Rivers It Posted Sunday 12th May, 2024 at 23:56(UTC-7) by Lyle Bateman

David Labchuk raised the button to 250k, then called when Toms Varghese reraised the small blind to 610k. On the flop Varghese check-called for 400, then both players checked down through the turn and river. Varghese had the best ace with ace-queen, but the ace-nine for Labchuk got there on the river, though he elected not to value bet his two pair.

Hardcastle Defends Big Posted Sunday 12th May, 2024 at 23:45(UTC-7) by Lyle Bateman

John Scalise opened the button to 275k but Jack Hardcastle repopped it to 900k. Scalise called to the flop where Hardcastle led for 500k and took it down.

They are now 15 minutes away from the end of Day 2.

Gaetano Buda Out on 7th Place for $35,483 Posted Sunday 12th May, 2024 at 23:37(UTC-7) by Lyle Bateman

David Labchuk opened early to 250k and Gaetano Buda shoved the small blind for 860k. Labchuk asked for a count, then called it off.

Gaetano Buda:
David Labchuk:

Labchuk flopped a pair and turned his flush on the board to send Buda out in 7th place. There are now about 20 minutes to play in Day 2.

Chip Updates Posted Sunday 12th May, 2024 at 23:10(UTC-7) by Lyle Bateman
Player Chips Progress
Zeyu 'Skytrain' Huang 8,500,000 2,150,000
Nicholas Teeuwen 7,300,000 2,020,000
David Labchuk 6,300,000 200,000
John Scalise 6,200,000 3,080,000
Jack Hardcastle 3,400,000 2,100,000
Toms Varghese 3,100,000 1,400,000
Gaetano Buda 1,800,000 300,000
Tyler Panas 0 0
Ambrose Ng 0 0
Ki Nam 0 0
Tyler Panas Out in 8th Place for $27,935 Posted Sunday 12th May, 2024 at 23:03(UTC-7) by Lyle Bateman

The river is the killer so far for final table players. Tyler Panas got his money in against big stack Zeyu Huang for a race with pocket jacks against Huang's ace-queen. The board of until the river, which sent him to the rail in 8th place.

Final Level of Day 2 Posted Sunday 12th May, 2024 at 23:01(UTC-7) by Lyle Bateman

They are into the final level of Day 2 now with the start of Level 28.

22:59 (UTC-7)
Start of Level 28
Blinds: 60,000/120,000     Ante: 120,000
Scalise Pips Hardcastle Posted Sunday 12th May, 2024 at 22:59(UTC-7) by Lyle Bateman

John Scalise raised to 350k early, and Jack Hardcastle called from the button. Scalise check-called for 300k on the flop and both players checked the turn.

When Scalise checked again on the river, Hardcastle pushed out 500k. Scalise called quickly, and his ace-queen was just ahead of the ace-jack for Hardcastle.

Ki Nam Out in 9th Place for $22,277 Posted Sunday 12th May, 2024 at 22:52(UTC-7) by Lyle Bateman

It was a bit of a brutal beat that sent Ki Nam to the rail. David Labchuk opened under the gun to 200k and Ki Nam, to his immediate left, clicked the all-in button. It folded back around to Labchuk, who called with pocket eights, only to run into the rockets.

It all looked good for Nam to double until the river of the river when Labchuk got there with the set to send him home.

Player Chips Progress
David Labchuk 6,500,000 1,050,000
Ki Nam 0 0
Ambrose Ng Out in 10th Place for $17,997 Posted Sunday 12th May, 2024 at 22:41(UTC-7) by Lyle Bateman

They are down to nine left with 20 minutes to play in Level 27 after Ambrose Ng was the first player off the final table. I missed the action as I've been having some wifi issues getting the pictures sorted out.

Final Table Faces Posted Sunday 12th May, 2024 at 22:39(UTC-7) by Lyle Bateman

Final Two Levels of Play for Day 2 Posted Sunday 12th May, 2024 at 22:20(UTC-7) by Lyle Bateman
Player Chips Progress
Zeyu 'Skytrain' Huang 6,350,000 650,000
Jack Hardcastle 5,500,000 1,800,000
David Labchuk 5,450,000 450,000
Nicholas Teeuwen 5,280,000 320,000
John Scalise 3,120,000 380,000
Tyler Panas 2,550,000 550,000
Ambrose Ng 2,150,000 150,000
Ki Nam 1,900,000 300,000
Toms Varghese 1,700,000 1,000,000
Gaetano Buda 1,500,000 0
21:59 (UTC-7)
Start of Level 27
Blinds: 50,000/100,000     Ante: 100,000
Final Table Time Posted Sunday 12th May, 2024 at 21:36(UTC-7) by Lyle Bateman

They are setting the final table now after quick exits from Tommy Nguyen and Kyle Bonazzo, one from each table.

Player Chips Progress
Tommy Nguyen 0 0
Kyle Bonazzo 0 0
Nam Doubles Posted Sunday 12th May, 2024 at 21:30(UTC-7) by Lyle Bateman

In a blind on blind hand, Ki Nam and Ambrose Ng got it in with Nam on fours and Ng on pocket sevens. Ng turned his seven, but Nam rivered a four for the set and the win. Meanwhile, on the same table, Skytrain is riding high at about 5.7 million.

Player Chips Progress
Zeyu 'Skytrain' Huang 5,700,000 1,695,000
Ambrose Ng 2,300,000 500,000
Ki Nam 2,200,000 500,000
Buda Doubles Posted Sunday 12th May, 2024 at 21:16(UTC-7) by Lyle Bateman

It was the most classic of races between Gaetano Buda and John Scalise with Buda at risk on the short stack. He had big slick to the pocket queens for Scalise. Buda flopped his king and then called for bricks, with the deck appearing to listen.

Player Chips Progress
John Scalise 3,500,000 600,000
Gaetano Buda 1,500,000 800,000
Two Off the Final Table Posted Sunday 12th May, 2024 at 21:09(UTC-7) by Lyle Bateman

Tey are down to 12 left in the Main Event after two recent eliminations. Kenneth Der and Matt Hall (who managed to go a couple of spots better than his 17th Main Event finish in January) were the recent busts to bring it to 12.

Player Chips Progress
Matthew Hall 0 0
Kenneth Der 0 0
Down to 14 Left Posted Sunday 12th May, 2024 at 21:01(UTC-7) by Lyle Bateman

There are 14 players left in the Main now with about 35 minutes to play in Level 26. Mike Leah was the most recent bust for $14,731.

Player Chips Progress
Mike Leah 0 0
Full Stack Updates to Start Level 26 Posted Sunday 12th May, 2024 at 20:44(UTC-7) by Lyle Bateman

Here is a look at the final 15 stacks in play with Level 26 just underway.

Player Chips Progress
David Labchuk 5,900,000 1,400,000
Nicholas Teeuwen 5,600,000 300,000
John Scalise 4,100,000 1,000,000
Zeyu 'Skytrain' Huang 4,005,000 1,705,000
Jack Hardcastle 3,700,000 700,000
Kyle Bonazzo 2,300,000 300,000
Tyler Panas 2,000,000 1,700,000
Ambrose Ng 1,800,000 1,261,000
Ki Nam 1,700,000 1,163,000
Kenneth Der 1,100,000 2,000,000
Mike Leah 905,000 1,095,000
Tommy Nguyen 860,000 160,000
Gaetano Buda 700,000 368,000
Toms Varghese 700,000 100,000
Matthew Hall 400,000 200,000
Dustin Centanni 0 0
20:36 (UTC-7)
Start of Level 26
Blinds: 40,000/80,000     Ante: 80,000
Some More Day 2 Faces Posted Sunday 12th May, 2024 at 20:20(UTC-7) by Lyle Bateman

Player Chips Progress
Michael Flanagan 0 0
Final Four Levels of the Day 2 Posted Sunday 12th May, 2024 at 19:48(UTC-7) by Lyle Bateman

The final 17 players are back from dinner and there are now four levels to play in Day 2. I had a look around at the break, and whole I don't have all the chips yet, here are a few updates.

Player Chips Progress
Nicholas Teeuwen 5,300,000 4,846,000
David Labchuk 4,500,000 3,990,000
John Scalise 3,100,000 0
Kenneth Der 3,100,000 800,000
Jack Hardcastle 3,000,000 2,583,000
Zeyu 'Skytrain' Huang 2,300,000 200,000
Kyle Bonazzo 2,000,000 1,595,000
Mike Leah 2,000,000 200,000
Toms Varghese 800,000 193,000
Tommy Nguyen 700,000 800,000
Matthew Hall 600,000 74,000
John Calliou 0 0
Vincent Lam 0 0
Brett Worton 0 0
19:34 (UTC-7)
Start of Level 25
Blinds: 30,000/60,000     Ante: 60,000
On Dinner with 17 Left Posted Sunday 12th May, 2024 at 18:52(UTC-7) by Lyle Bateman

The dinner break has just begun in the Main Event with 17 players still left in the game. They'll be back in action in about 45 minutes for the final four levels of Day 2 play.

10 Minutes to Dinner Posted Sunday 12th May, 2024 at 18:38(UTC-7) by Lyle Bateman

They are about 10 minutes from the dinner break now with the field just breaking down to the final two tables. Brett Worton and Vincent Lam were the most recent players to hit the rail.

Down to 20 Posted Sunday 12th May, 2024 at 18:07(UTC-7) by Lyle Bateman

The clock was paused for about 15 minutes as the payouts have just jumped above 10k, so players are required to fill out some forms for AGLC with any $10k+ cash. The clock is running again with 40 minutes to play in Level 24 with the dinner break scheduled after this level.

Once they return for dinner, they'll play four more levels in Day 2 before the remaining players bag up for the night.

22 Left to Start Level 24 Posted Sunday 12th May, 2024 at 17:52(UTC-7) by Lyle Bateman

Level 24 has just begun with 22 players left in the field. Full prizes (with the exception of 42nd place, who hasn't had their payslip authorized yet) are listed under the Payouts tab now. Meanwhile, below is a look at a few faces from the final 25 players in the field.

17:45 (UTC-7)
Start of Level 24
Blinds: 25,000/50,000     Ante: 50,000
Down to 25 Posted Sunday 12th May, 2024 at 17:26(UTC-7) by Lyle Bateman

There are just under 15 minutes to play in Level 23 and the Main Event field is down to 25 players left. It looks like Kenneth Der is the chip leader right now with almost 4 million. Below is a look at a few other big stacks at the moment.

Player Chips Progress
Kenneth Der 3,900,000 3,024,000
John Scalise 3,100,000 300,000
Zeyu 'Skytrain' Huang 2,500,000 700,000
Mike Leah 2,200,000 1,300,000
Tommy Nguyen 1,500,000 1,000,000
Three Table Redraw Posted Sunday 12th May, 2024 at 17:03(UTC-7) by Lyle Bateman

They are down to 27 players left now and they are redrawing for new seats at the final three tables. There are just over 30 minutes to play in Level 23 with the dinner break scheduled following Level 24 in about 90 minutes.

30 Players Remain in the Main Posted Sunday 12th May, 2024 at 16:46(UTC-7) by Lyle Bateman

They are down to 30 players left in the Main now, and most of the prizes are updated. 32nd and 42nd places haven't checked in to get their payslips authorized yet, so those spots are blank, but the rest of the prizes to 31st place are now updated.

Back in Action for Level 23 Posted Sunday 12th May, 2024 at 16:36(UTC-7) by Lyle Bateman

The final 32 players are now back in their seats for the start of Level 23.

16:26 (UTC-7)
Start of Level 23
Blinds: 20,000/40,000     Ante: 40,000
Some Chip Updates Posted Sunday 12th May, 2024 at 16:22(UTC-7) by Lyle Bateman

The final 33 players are on their second break of the day now, and it looks like Zeyu 'Skytrain' Huang is the current leader with about 3.2 million in front of him. John Scalise and Tommy Nguyen are both playing more than 2.5 million.

Player Chips Progress
Zeyu 'Skytrain' Huang 3,200,000 2,320,000
John Scalise 2,800,000 2,061,000
Tommy Nguyen 2,500,000 1,304,000
Mike Leah 900,000 363,000
Four Tables Posted Sunday 12th May, 2024 at 16:01(UTC-7) by Lyle Bateman

They are down to 35 players remaining now on the final dour tables with just over 15 minutes to play in Level 22. The second break of Day 2 is scheduled at the end of this level with the 45-minute dinner break scheduled for the end of Level 24 in about 2.5 hours.

Nearing Four Tables Posted Sunday 12th May, 2024 at 15:38(UTC-7) by Lyle Bateman

They are nearing four tables now with 38 players left in the Main as Level 22 begins.

15:18 (UTC-7)
Start of Level 22
Blinds: 15,000/30,000     Ante: 30,000
42 Remain Posted Sunday 12th May, 2024 at 15:03(UTC-7) by Lyle Bateman

There are about 15 minutes to play in Level 21 and they are down to 42 players remaining in the Main Event now. Paul Brar was among the recent busts with many of the Main Event busts heading straight over to the high roller, which is also in action this afternoon in the Chrome room.

Down to 5 Tables Posted Sunday 12th May, 2024 at 14:42(UTC-7) by Lyle Bateman

They are down to 44 players left in the game now with Julius Roque and Shane Chief among the recent players to hit the rail. There are now just over 30 minutes to play in Level 21 with the average stack a bit more than 40 bigs right now.

Nearing Five Tables Posted Sunday 12th May, 2024 at 14:32(UTC-7) by Lyle Bateman

Full prizes to 49th place are updated under the Payouts tab now with the field down to 48 remaining with 45 minutes to play in Level 21. Among the recent busts were Eric Davis, Roman Gallivan, Tang Jooce, and Andrew Goosen.

52 Left Posted Sunday 12th May, 2024 at 14:20(UTC-7) by Lyle Bateman

They are down to 52 remaining now shortly after the start of Level 21. Day 2 is scheduled to play until the end of Level 28 with any remaining players returning for the final day of play on Monday.

14:18 (UTC-7)
Start of Level 21
Blinds: 15,000/25,000     Ante: 25,000
Break Time with 54 Remaining Posted Sunday 12th May, 2024 at 14:05(UTC-7) by Lyle Bateman

They are down to 54 players left in the game now as the first break of Day 2 approaches. Among the recent busts were DJ Sharma, Duff Charette (who won his first ring earlier in the series), Hua Zang (who was third in the Monster Stack), and Chris Clisby.

62 Left Posted Sunday 12th May, 2024 at 13:50(UTC-7) by Lyle Bateman

They are down to 62 remaining in Day 2 of the Main Event now. Among the players to hit the rail early today was Day 2 chip leader Nate Drury. I didn't see the hand, but it looked like he took a bad beat before heading to the cash cage, Other recent busts include previous Main Event winner Cody McKay, Andy Truong, Jason Tran, Mal Hagan, and Johnny Yu, who managed to turn a max-late entry in Day 1c into a pretty decent cash of $3,936. Yu, at least, says he plans to jump into today's high roller as well, so he should do well with more of a full stack.

Full prizes to 63rd place are loaded into the Payouts tab now.

13:01 (UTC-7)
Start of Level 20
Blinds: 10,000/20,000     Ante: 20,000
Down to 68 Posted Sunday 12th May, 2024 at 12:53(UTC-7) by Lyle Bateman

There are 68 players left in the game with just under 10 minutes left in the opening level of Day 2. I am still trying to clean up my admin work for the High Roller and last night's results, so I'm still watching the game from the sidelines.

75 Players Left Posted Sunday 12th May, 2024 at 12:23(UTC-7) by Lyle Bateman

They are down to 75 players left now with just under 40 minutes to play in Level 19. Prizes to 76th place are updated under the Payouts tab.

Action Underway on Day 2 Posted Sunday 12th May, 2024 at 12:16(UTC-7) by Lyle Bateman

The action is underway for Day 2 and there are already calls of seat empty from various parts of the floor. They are already down to 77 and dropping fast. The early part of my day will likely be mostly updating payouts in the backend while I clean up my final posts from yesterday and get set up for the high roller, but I should be able to start watching the action in an hour or two.

Day 2 Seats by Name Posted Sunday 12th May, 2024 at 03:00(UTC-7) by Lyle Bateman

Day 2 Seats by Name

T

S

Player

Home

Chips

26 7 Aaron Quon Langley, BC 514,000
24 6 Ambrose Ng Edmonton, AB 539,000
21 2 Andrew Goosen Abbotsford, BC 233,000
23 2 Andy Truong Calgary, AB 434,000
21 4 Benjamin Veinstin Edmonton, AB 228,000
24 5 Brad Field Grande Prairie, AB 115,000
23 4 Brendan Faulkner Calgary, AB 121,000
20 5 Brett Worton Edmonton, AB 232,000
20 4 Brian Adnerson North Battleford, SK 403,000
30 7 Bryan Maenevin Stony Plain, AB 270,000
29 1 Chaudhary Faisal Langley, BC 586,000
22 8 Chris Clisby Winnipeg, MB 195,000
20 1 Chris Hak Edmonton, AB 257,000
24 2 Christian Mirkovic Calgary, AB 224,000
26 9 Chun Kit Kwan Hong Kong 698,000
21 7 Cody McKay Daysland, AB 360,000
21 8 Colten Yamagishi Edmonton, AB 42,000
28 3 Darlene Lee Vancouver, BC 494,000
20 9 David Labchuk Calgary, AB 510,000
25 3 DJ Sharma Edmonton, AB 539,000
22 4 Duff Charette Ottawa, ON 249,000
24 4 Dustin Centanni Surrey, BC 529,000
30 9 Eric Davis Calgary, AB 71,000
22 5 Eric Wasylenko Winnipeg, MB 659,000
24 9 Gaetano Buda Klienburg, ON 332,000
22 7 Glenn Tarasoff Saskatoon, SK 310,000
28 6 Gordon Wong Vancouver, BC 362,000
23 7 Griffin Ristevski Toronto, ON 173,000
29 9 Hari Aujla Surrey, BC 180000
20 8 Hua Zang Richmond, BC 332,000
24 3 Jack Hardcastle Southsea, UK 417,000
29 8 Jacob Hobday Pickering, ON 122,000
23 9 Jason Heang Edmonton, AB 240,000
28 2 Jason Tran Edmonton, AB 111,000
30 5 Jeff Bryde Maple Ridge, BC 465,000
22 6 Jeffrey Reardon Whitby, ON 335,000
25 7 John Calliou Fishing Lake, AB 557,000
26 2 John Scalise Calgary, AB 739,000
26 3 Johnny Yu Kelowna, BC 144,000
23 8 Jolnar Teliani Edmonton, AB 255,000
20 6 Joon 'Huge Hammer' Park Vancouver, BC 508,000
29 3 Julius Roque Lethbridge, AB 331,000
29 4 Kenneth Der Grande Prairie, AB 876,000
30 6 Kenny Ens Abbotsford, BC 418,000
29 2 Ki Nam Langley, BC 537,000
26 4 Kwong Shing Au Kamloops, BC 313,000
21 5 Kyle Bonazzo Grande Prairie, AB 405,000
21 6 Kyle Ho Coquitlam, BC 749,000
21 3 Leslie Sam Port Alberni, BC 173,000
22 1 Mal Hagan Abbotsford, BC 215,000
22 9 Manfred Gunter Ottawa, ON 356,000
21 1 Mark Inglis Port Alice, BC 172,000
22 3 Martinus Kaspers Campbell River, BC 278,000
23 5 Matthew Hall Whistler, BC 674,000
26 6 Michael Flanagan Victoria, BC 507,000
24 1 Mike Leah Toronto, ON 1,263,000
24 1 Nate Drury Abbotsford, BC 1,301,000
24 7 Nicholas Teeuwen CHatham, ON 454,000
28 1 Nohad Teliani Edmonton, AB 650000
24 8 Paul Brar Edmonton, AB 534,000
20 3 Pav Braich Edmonton, AB 518,000
30 4 Qi Xi Huang Richmond, BC 1,275,000
28 8 Regan Duong Calgary, AB 413,000
26 5 Robert Dore Calgary, AB 122,000
30 8 Roman Gallivan Calgary, AB 239,000
25 5 Ryan Down Calgary, AB 629,000
21 9 Shane Brotherwood Calgary, AB 195,000
22 2 Shane Chief Calgary, AB 201,000
20 2 Shawn Taghavi Edmonton, AB 461,000
29 7 Steve Parkin Calgary, AB 124,000
30 1 Sunny Lubana Saskatoon, SK 910,000
29 5 Tang Jooce Toronto, ON 406,000
23 6 Tedde Ballanger Burlington, ON 213,000
25 4 Thomas Taylor Calgary, AB 645,000
25 6 Tommy Nguyen Toronto, ON 1,196,000
25 8 Toms Varghese Calgary, AB 607,000
28 5 Trevor Shishkin Saskatoon, SK 463,000
25 1 Tuan Luu Calgary, AB 61,000
28 7 Tyler Hurman Calgary, AB 269,000
26 8 Tyler Panas Calgary, AB 300,000
25 2 Varanpreet Sidhu Edmonton, AB 493,000
20 7 Vincent Lam Edmonton, AB 741,000
25 9 Xi Xiang Li Vancouver, BC 406,000
29 6 Zenni Petros Winnipeg, MB 325,000
28 9 Zeyu 'Skytrain' Huang Calgary, AB 880,000
23 3 Zhigang Yang Richmond, BC 328,000
Day 2 Seats Posted Sunday 12th May, 2024 at 02:58(UTC-7) by Lyle Bateman

Day 2 Seat Assignments by Seat

T

S

Player

Hometown

Chips
20 1 Chris Hak Edmonton, AB 257,000
20 2 Shawn Taghavi Edmonton, AB 461,000
20 3 Pav Braich Edmonton, AB 518,000
20 4 Brian Adnerson North Battleford, SK 403,000
20 5 Brett Worton Edmonton, AB 232,000
20 6 Joon 'Huge Hammer' Park Vancouver, BC 508,000
20 7 Vincent Lam Edmonton, AB 741,000
20 8 Hua Zang Richmond, BC 332,000
20 9 David Labchuk Calgary, AB 510,000
21 1 Mark Inglis Port Alice, BC 172,000
21 2 Andrew Goosen Abbotsford, BC 233,000
21 3 Leslie Sam Port Alberni, BC 173,000
21 4 Benjamin Veinstin Edmonton, AB 228,000
21 5 Kyle Bonazzo Grande Prairie, AB 405,000
21 6 Kyle Ho Coquitlam, BC 749,000
21 7 Cody McKay Daysland, AB 360,000
21 8 Colten Yamagishi Edmonton, AB 42,000
21 9 Shane Brotherwood Calgary, AB 195,000
22 1 Mal Hagan Abbotsford, BC 215,000
22 2 Shane Chief Calgary, AB 201,000
22 3 Martinus Kaspers Campbell River, BC 278,000
22 4 Duff Charette Ottawa, ON 249,000
22 5 Eric Wasylenko Winnipeg, MB 659,000
22 6 Jeffrey Reardon Whitby, ON 335,000
22 7 Glenn Tarasoff Saskatoon, SK 310,000
22 8 Chris Clisby Winnipeg, MB 195,000
22 9 Manfred Gunter Ottawa, ON 356,000
23 2 Andy Truong Calgary, AB 434,000
23 3 Zhigang Yang Richmond, BC 328,000
23 4 Brendan Faulkner Calgary, AB 121,000
23 5 Matthew Hall Whistler, BC 674,000
23 6 Tedde Ballanger Burlington, ON 213,000
23 7 Griffin Ristevski Toronto, ON 173,000
23 8 Jolnar Teliani Edmonton, AB 255,000
23 9 Jason Heang Edmonton, AB 240,000
24 1 Nate Drury Abbotsford, BC 1,301,000
24 1 Mike Leah Toronto, ON 1,263,000
24 2 Christian Mirkovic Calgary, AB 224,000
24 3 Jack Hardcastle Southsea, UK 417,000
24 4 Dustin Centanni Surrey, BC 529,000
24 5 Brad Field Grande Prairie, AB 115,000
24 6 Ambrose Ng Edmonton, AB 539,000
24 7 Nicholas Teeuwen CHatham, ON 454,000
24 8 Paul Brar Edmonton, AB 534,000
24 9 Gaetano Buda Klienburg, ON 332,000
25 1 Tuan Luu Calgary, AB 61,000
25 2 Varanpreet Sidhu Edmonton, AB 493,000
25 3 DJ Sharma Edmonton, AB 539,000
25 4 Thomas Taylor Calgary, AB 645,000
25 5 Ryan Down Calgary, AB 629,000
25 6 Tommy Nguyen Toronto, ON 1,196,000
25 7 John Calliou Fishing Lake, AB 557,000
25 8 Toms Varghese Calgary, AB 607,000
25 9 Xi Xiang Li Vancouver, BC 406,000
26 2 John Scalise Calgary, AB 739,000
26 3 Johnny Yu Kelowna, BC 144,000
26 4 Kwong Shing Au Kamloops, BC 313,000
26 5 Robert Dore Calgary, AB 122,000
26 6 Michael Flanagan Victoria, BC 507,000
26 7 Aaron Quon Langley, BC 514,000
26 8 Tyler Panas Calgary, AB 300,000
26 9 Chun Kit Kwan Hong Kong 698,000
28 1 Nohad Teliani Edmonton, AB 650000
28 2 Jason Tran Edmonton, AB 111,000
28 3 Darlene Lee Vancouver, BC 494,000
28 5 Trevor Shishkin Saskatoon, SK 463,000
28 6 Gordon Wong Vancouver, BC 362,000
28 7 Tyler Hurman Calgary, AB 269,000
28 8 Regan Duong Calgary, AB 413,000
28 9 Zeyu 'Skytrain' Huang Calgary, AB 880,000
29 1 Chaudhary Faisal Langley, BC 586,000
29 2 Ki Nam Langley, BC 537,000
29 3 Julius Roque Lethbridge, AB 331,000
29 4 Kenneth Der Grande Prairie, AB 876,000
29 5 Tang Jooce Toronto, ON 406,000
29 6 Zenni Petros Winnipeg, MB 325,000
29 7 Steve Parkin Calgary, AB 124,000
29 8 Jacob Hobday Pickering, ON 122,000
29 9 Hari Aujla Surrey, BC 180000
30 1 Sunny Lubana Saskatoon, SK 910,000
30 4 Qi Xi Huang Richmond, BC 1,275,000
30 5 Jeff Bryde Maple Ridge, BC 465,000
30 6 Kenny Ens Abbotsford, BC 418,000
30 7 Bryan Maenevin Stony Plain, AB 270,000
30 8 Roman Gallivan Calgary, AB 239,000
30 9 Eric Davis Calgary, AB 71,000
Nate Drury Leads 86 Players Returning for Day 2 Posted Sunday 12th May, 2024 at 02:51(UTC-7) by Lyle Bateman

Event #11: $1,700 Main Event ($1,515 + $185)

Day 2: May 12, 2024, Noon
Day 3: May 13, 2024, Noon
Blinds: 60 Min
Entries: 911
Prizes: $1,380,165

There are four players coming into Day 2 with a million or more, but Nate Drury has the biggest stack of them all with just over 1.3 million. He leads Qi Xi Huang, Mike "GoLeafsGoEh" Leah, and Tommy Nguyen in the millionaire club. Sunny Lubana might be an honourary member as the 5th-place stack coming to Day 2 with 910k.

Full stacks for Day 2 are under the Chip Counts tab. I won't have eyes on an official prize list tonight, but based on my estimates, I expect 1st place to be around $200k, but I'll update the prizes ASAP in the morning.

The Day 2 action kicks off at noon on Sunday and they'll play until the end of Level 28, it required. If there are still players in the game, they'll return Monday at noon to finish it out.

02:33 (UTC-7)
Day 2 of WSOPC Deerfoot Inn & Casino Started
Level: 19     Blinds: 10,000/15,000     Ante: 15,000

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.