0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0080 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-may-wsopc-calgary-event-11'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 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.0005 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.0005 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0043 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.0291 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '299'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '301'
AND `published` = 1
0.0298 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '304'
AND `published` = 1
0.0312 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '306'
AND `published` = 1
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '306'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '125'
AND `name` = '2'
0.0173 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.0081 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '306'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0186 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13600'
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` = '13599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13593'
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` = '13590'
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` = '13589'
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` = '13585'
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` = '13581'
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` = '13578'
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` = '13577'
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` = '13574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0167 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13569'
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` = '13568'
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` = '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.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` = '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.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` = '13559'
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` = '13555'
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` = '13556'
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` = '13552'
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` = '13551'
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` = '13550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0168 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13548'
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` = '13542'
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` = '13539'
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` = '13538'
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` = '13537'
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` = '13536'
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` = '13531'
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` = '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.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` = '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.0267 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13525'
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` = '13524'
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` = '13523'
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` = '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.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` = '13518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13515'
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` = '13514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13508'
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` = '13507'
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` = '13506'
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` = '13503'
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` = '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.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` = '13496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13495'
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` = '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.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` = '13490'
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` = '13489'
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` = '13487'
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` = '13486'
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` = '13483'
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` = '13482'
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` = '13479'
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` = '13476'
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` = '13475'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13474'
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` = '13473'
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` = '13472'
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` = '13469'
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` = '13468'
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` = '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.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` = '13464'
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` = '13463'
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` = '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.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` = '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.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.0059 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.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` = '13611'
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` = '13607'
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` = '13606'
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` = '13605'
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` = '13604'
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` = '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.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` = '13601'
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` = '13600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13599'
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` = '13594'
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` = '13593'
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` = '13590'
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` = '13589'
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` = '13585'
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` = '13581'
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` = '13578'
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` = '13577'
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` = '13574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13573'
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` = '13570'
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` = '13569'
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` = '13568'
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` = '13567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13565'
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` = '13564'
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` = '13561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13556'
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` = '13552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13549'
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` = '13548'
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` = '13542'
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` = '13539'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13538'
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` = '13537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13536'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13531'
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` = '13530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13529'
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` = '13528'
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` = '13527'
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` = '13526'
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` = '13525'
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` = '13524'
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` = '13523'
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` = '13522'
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` = '13521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13518'
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` = '13515'
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` = '13514'
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` = '13513'
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` = '13512'
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` = '13511'
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` = '13508'
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` = '13507'
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` = '13506'
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` = '13503'
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` = '13502'
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` = '13499'
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` = '13496'
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` = '13495'
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` = '13494'
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` = '13493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13490'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '13487'
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` = '13486'
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` = '13483'
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` = '13482'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '13479'
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` = '13476'
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` = '13475'
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` = '13474'
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` = '13473'
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` = '13472'
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` = '13469'
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` = '13468'
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` = '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.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` = '13464'
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` = '13463'
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` = '13454'
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` = '13453'
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` = '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.0060 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
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
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 .
Go to checkoutMore 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.