WSOP International Circuit - Deerfoot Inn and Casino - Live Coverage

        
0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0134 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-13'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsop-cal-aug-e3/2/updates'
ORDER BY `views` DESC

0.0211 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-13'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024-wsop-cal-aug-e3/2/updates'

0.0003 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.0007 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.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

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

0.0004 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0006 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0005 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 `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.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0077 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.0008 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-wsop-cal-aug-e3'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '174'

0.0364 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0090 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '382'
AND `published` = 1

0.0355 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0292 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '383'
AND `published` = 1

0.0338 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0081 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '385'
AND `published` = 1

0.0541 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0078 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '386'
AND `published` = 1

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '174'
AND `name` = '2'

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

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

0.0099 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16683'
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` = '16682'
ORDER BY `chip_change` DESC, `busted` ASC

0.0096 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16681'
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` = '16680'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0081 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16672'
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` = '16671'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16669'
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` = '16668'
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` = '16667'
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` = '16666'
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` = '16665'
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` = '16664'
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` = '16663'
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` = '16662'
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` = '16661'
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` = '16660'
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` = '16659'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0092 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16655'
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` = '16654'
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` = '16653'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16651'
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` = '16650'
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` = '16649'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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` = '16643'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0111 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16641'
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` = '16640'
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` = '16637'
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` = '16636'
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` = '16635'
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` = '16634'
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` = '16620'
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` = '16619'
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` = '16618'
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` = '386'
ORDER BY `busted` ASC, `current_chips` DESC

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

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` = '16683'
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` = '16682'
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` = '16681'
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` = '16680'
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` = '16679'
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` = '16678'
ORDER BY `chip_change` DESC, `busted` ASC

0.0077 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16677'
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` = '16676'
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` = '16675'
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` = '16674'
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` = '16673'
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` = '16672'
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` = '16671'
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` = '16670'
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` = '16669'
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` = '16668'
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` = '16667'
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` = '16666'
ORDER BY `chip_change` DESC, `busted` ASC

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

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` = '16664'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16663'
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` = '16662'
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` = '16661'
ORDER BY `chip_change` DESC, `busted` ASC

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` = '16660'
ORDER BY `chip_change` DESC, `busted` ASC

0.0076 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16659'
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` = '16658'
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` = '16657'
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` = '16656'
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` = '16655'
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` = '16654'
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` = '16653'
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` = '16651'
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` = '16650'
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` = '16649'
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` = '16648'
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` = '16647'
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` = '16646'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16645'
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` = '16643'
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` = '16642'
ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16641'
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` = '16640'
ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16637'
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` = '16636'
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` = '16635'
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` = '16634'
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` = '16620'
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` = '16619'
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` = '16618'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

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

Deerfoot Inn and Casino - Live Reporting Event #1: $400 Big 30 Stack ($330 + $70) Event #2:$600 NLH/PLO Mixed ($515 + $85) Event #3: $400 4-Flight ($330 + $70) Event #4: $600 Mystery Bounty ($515 + $85) Event #5: $400 Seniors ($330 + $70) Event #7: $1,000 Two-Day $1k ($875 + $125) Event #8: $500 Progressive Knockout ($420 + $80) Event #9: $400 Monster Stack NLH ($330 + $70) Event #10: $1,000 1k Turbo ($875 + $125) Event #11: $1,700 Main Event ($1,515 + $185) Event #12: $250 Flip & Go ($210 + $40) Event #13: $400 PLO Bounty ($330 + $70) Event #14: $400 Ladies ($330 + $70) Event #16: $250 Big 30 Stack ($200 + $50) Event #15: $2,200 High Roller ($1,965 + $235) Event #6: $400 Black Chip Bounty ($330 + $70)

Current Level 27 Current Day 2

Blinds - Ante -

Entries 905 Remaining 1

Prize Pool (CAD) $298,650 First Prize (CAD) $47,068

Chip Leaders Day 2

1	Phillip Louie		10,865,000

Day 1A Day 1BC Day 1D Day 2

1 New Update - Click to refresh

Live Updates - Day 2

Phillip Louie Wins 4-Flight for $47,068 Posted Sunday 11th August, 2024 at 21:41(UTC-7) by Lyle Bateman

The heads-up part of the game went very fast with the entire thing over in just a few hands. The big spot came when Phillip Louie tank-called a 5-bet shove from Stephen "The Noodle" Nahm with pocket tens, leaving Nahm drawing to an ace. He missed and the tens held, giving Louie a huge lead. Just a couple of hands later, he slow-played a pair of queens to s flopped set, and was a huge favorite when the money went in on the turn with Nahm on draws. Louie's set rivered a boat to take it down in dominating fashion.

Stephen "The Noodle" Nahm Out in 2nd Place for $31,379 Posted Sunday 11th August, 2024 at 21:24(UTC-7) by Lyle Bateman

While the rest of the final table was a bit of a marathon tonight, the final two sprinted to the finish. In the first hand of heads up, Stephen Nahm 5-bet shoved ace-ten and Phillip Louie tank-called with pocket tens. The tens held and that gave Louie a huge lead with the double.

Just a couple of hands later, Louie slow-played a pair of queens to a flopped set. There was a bet and a call on the flop, but the money went in when a ten hit the turn. Nahm was drawing thin with against the set. He had a gutshot, but the ten paired on the river to brick his draw and give Louie the boat.

Player		Chips	Progress
Stephen 'The Noodle' Nahm		0	0

Leo Zhang Out in 3rd Place for $21,375 Posted Sunday 11th August, 2024 at 21:07(UTC-7) by Lyle Bateman

Leo Zhang will have to wait for another day to win his second ring. He's been nursing a short stack now for more than a level, and he finally shoved 765k with a suited queen. Phillip Louie called it off and it was for Zhang against for Louie. The board missed both players so the ace-high took it down.

That leaves Louie heads-up against Stephen 'The Noodle" Nahm with both players roughly even.

Player		Chips	Progress
Leo Zhang		0	0

Louie Takes it on Turn Posted Sunday 11th August, 2024 at 20:50(UTC-7) by Lyle Bateman

Leo Zhang raised the button to 225k and Phillip Louie called on the big blind. Louie check-raised the flop from 175k to 525. Zhang called to the river but mucked when Louie bet 3 million, enough to put Zhang all in.

Louie has Aces Posted Sunday 11th August, 2024 at 20:39(UTC-7) by Lyle Bateman

Phillip Louie raised to 200k from the button and Stephen 'The Noodle" Nahm called from the big blind. The Noodle checked the flop of , then called a bet of 150k from Louie.

Nahm check-called again for 425k on the turn and for 550k on the river. Louie showed down pocket aces and The Noodle mucked his hand. I was informed of "The Noodle" nickname for Nahm at the last break by his friend and rail Arif Dhalla.

20:10 (UTC-7)

Start of Level 27
Blinds: 0/0 Ante: 0

Break Chips Posted Sunday 11th August, 2024 at 20:10(UTC-7) by Lyle Bateman

This was going to be the scheduled dinner break, but the remaining players have decided to cancel that and just have a 15-minute break before coming back to finish it out. "Laurence" Phillip Louie has the big lead right now with more than 10 million, while Leo Zhang is on the shorty.

Player	Chips	Progress
Phillip Louie	10,865,000	8,515,000
Stephen Nahm	6,570,000	1,320,000
Leo Zhang	1,665,000	1,580,000

Gail Flaherty Out in 4th Place for $14,919 Posted Sunday 11th August, 2024 at 20:02(UTC-7) by Lyle Bateman

They are down to three now after Gail Flaherty lost her short stack to end her run in 4th place.

Player		Chips	Progress
Gail Flaherty		0	0

Louie Takes Lead with 8.5 Million; Flaherty Doubles Set over Set Posted Sunday 11th August, 2024 at 19:46(UTC-7) by Lyle Bateman

Action was on the turn reading [tc8h4c9h and after a check from big blind Stephen Nahm, "Laurence" Louie shoved 3.31 million into an already massive pot. Nahm was in the tank for several minutes before finally letting it go, and Louie took over the lead.

On the next hand, Gail Flaherty, who has gotten short, shoved for a bit more than 500k over an open from Leo Zhang. He called and it was pair over pair with Flaherty on jacks and Zhang on threes. Both players flopped a set on so Flaherty doubled with the best set.

19:25 (UTC-7)

Start of Level 26
Blinds: 0/0 Ante: 0

David Kang Out in 5th Place for $10,676 Posted Sunday 11th August, 2024 at 19:24(UTC-7) by Lyle Bateman

I arrived at the table with action on the turn and the board reading . Small blind Gail Flaherty checked before big blind Stephen Nahm bet 125k. Button David Kang tossed out a 500k plaque for a raise, sending Flaherty's cards to the muck, but Nahm shoved a covering stack.

Kang hit the tank for a few minutes before finally tossing in the call to put himself at risk. He was on top pair with but Nahm flopped the big blind special with for two pair. The river was a brick for Kang, and he was off to collect 5th place money. The hand gives Nahm a huge lead now 4 ways.

Player		Chips	Progress
Hee Chan 'David' Kang		0	0

Kang Gets a Double Posted Sunday 11th August, 2024 at 19:14(UTC-7) by Lyle Bateman

It was a big preflop confrontation when David Kang raised to 325k and Gail Flaherty raised all-in from his left. Kamg snapped it off with pocket kings against Flaherty's pocket sevens. It doesn't always come seven, as Kang flopped his king for the top set leaving Flaherty drawing to running sevens. She bricked and Kang is closing in on 4 million now after doubling from 1.8 million.

Flaherty Flushes Posted Sunday 11th August, 2024 at 19:06(UTC-7) by Lyle Bateman

Leo Zhang opend to 125k from the hijack and Gail Flaherty called from the button. Zhang fired 130k on the flop, which Flaherty called to the turn.

Zhang bet 225k and Flaherty flatted to the river. Zhang check-called for 200k, then quickly mucked when Flaherty rolled over for the flush and the win.

Lee Clark Out in 6th Place for $7,837 Posted Sunday 11th August, 2024 at 18:44(UTC-7) by Lyle Bateman

Lee Clark was trying to fly like Superman to another ring here today, but he just fell short ending in 6th place. I missed the action while I was writing the last post, but even after his recent chip-up, he was still on well less than 10 bigs.

Player		Chips	Progress
Funcle' Lee Clark		0	0

Lee Gets Near-Double; Nahm Gets Agro Posted Sunday 11th August, 2024 at 18:42(UTC-7) by Lyle Bateman

Lee CLark has been nursing fumes for a while now, and he managed to get a 75% chip up when he raised to 180k from the cutoff, leaving just 25k behind, and everyone folded to him. He added 150k in blinds and antes to his previous stack of 205k.

In the next hand, Leo Zhang and Stephen Nahm got into it a bit. Nahm raised to 125k preflop and Zhang came along from the button to a flop of Nahm bet 100k, but Zhang came over the top for 250k. Nahm wasn't having it though, and he tossed out 650k, forcing a fold from Zhang. Nahm is the table captain at the moment both in terms of chips and action.

18:28 (UTC-7)

Start of Level 25
Blinds: 0/0 Ante: 0

Louie and Flaherty Stack Chips Posted Sunday 11th August, 2024 at 18:28(UTC-7) by Lyle Bateman

In a couple of FT hands, both Gail Flaherty and Phillip Louie have stacked some chips. In the first hand, Louie made it 110k to go and got calls from Flaherty on the button and Lee Clark in the big blind.

They all checked the flop and after a check from Clark, Louie bet 140k on the turn. Flaherty was the only caller to the river, but she mucked when Louie fired 500k.

One hand later, Flaherty limp-called from the hijack after Stephen Nahm made it 150k from the cutoff. Flaherty switched gears and led for 500k on the flop and it didn't take Nahm long to get out of her way.

Level 24 is about to start.

Caleb Simmons Out in 7th Place for $5,906 Posted Sunday 11th August, 2024 at 18:18(UTC-7) by Lyle Bateman

Caleb Simmons came into today as the chip leader, and he was able to hold that spot for a bit, but ultimately, he ended his run in 7th place tonight after a big 4-way hand. Simmons opened the middle to 100k, and got calls from Gail Flaherty on the button, as well as Stephen Nahm in the small and Lee Clark in the big.

The flop is when it all kicked off. It checked to Simmons who fired 210k, which Flaherty called before Nahm raised it up to 800k, Clark got out of the way before Simmons shoved 1.565 million sending Falherty's cards to the muck.

Caleb Simmons:
Stephen Nahm:

Simmons was on top pair, second kicker, but Nahm was on second pair and had massive draws to straights and flushes. The turn did nothing, but the river sealed the deal for Nahm and sent Simmons packing in 7th.

Player		Chips	Progress
Caleb Simmons		0	0

FT Chips at Break Posted Sunday 11th August, 2024 at 17:44(UTC-7) by Lyle Bateman

T	S	Player	Hometown	Chips
22	2	Stephen Nahm	Burnaby, BC	5,250,000
22	4	"Funcle" Lee Clark	Calgary, AB	745,000
22	5	Phillip Louie	Revelstoke, BC	2,350,000
22	6	Caleb Simmons	Calgary, AB	2,115,000
22	7	Leo Zhang	Edmonton, AB	3,245,000
22	8	Hee Chan 'David' Kang	Vancouver, BC	1,425,000
22	9	Gail Flaherty	Calgary, AB	4,150,000

Player	Chips	Progress
Stephen Nahm	5,250,000	4,865,000
Gail Flaherty	4,150,000	2,030,000
Leo Zhang	3,245,000	3,078,000
Phillip Louie	2,350,000	1,908,000
Caleb Simmons	2,115,000	420,000
Hee Chan 'David' Kang	1,425,000	925,000
Funcle' Lee Clark	745,000	441,000

17:41 (UTC-7)

Start of Level 24
Blinds: 0/0 Ante: 0

Michael Malm Out in 8th Place for $4,572 Posted Sunday 11th August, 2024 at 17:34(UTC-7) by Lyle Bateman

They are down to 7 just before the break after Michael Malm hit the cage for 8th place. He was pretty short near the end of the level, and he got one shove through, but couldn't survive to the break.

Player		Chips	Progress
Michael Malm		0	0

"Laurence" Takes it on the Turn Posted Sunday 11th August, 2024 at 17:32(UTC-7) by Lyle Bateman

Phillip Louie, who I originally misidentified yesterday as his brother Laurence, raised it up to 85k from the middle and got two callers from Gail Flaherty on the button and big blind Stephen Nahm. It checked to Louie on the flop and he fired 105k.

Only Flaherty called to the river, but she mucked when Louie fired 150k. Before the hand, Louie joked that I should keep calling him Laurence as it would be "funny."

Couple of Three Bets Posted Sunday 11th August, 2024 at 17:20(UTC-7) by Lyle Bateman

In the first hand, Leo Zhang raised to 90k before mucking his hand after Stephen Nahm raised it up to 300k. On the following hand, Michael Malm raised the button to 135k but also had to muck after big blind Lee Clark, who has traded in his ring-winning "Funcle" T-Shirt for a Superman cap this time around, shoved for about 500k.

Ethan Figueroa Out in 9th Place for $3,638 Posted Sunday 11th August, 2024 at 17:11(UTC-7) by Lyle Bateman

They are down to 8 left now in Event #3 with just over 20 minutes to play until the next break. Ethan Figueroa was the player to grab 9th place money worth $3,638.

Player		Chips	Progress
Ethan Figueroa		0	0

Tony Mendes Out in 10th Place for $2,979 Posted Sunday 11th August, 2024 at 17:09(UTC-7) by Lyle Bateman

Tony Mendes, who bagged the lead from Day 1a, was the first to exit the final table tonight in 10th place for $2,979.

Player		Chips	Progress
Tony Mendes		0	0
Brant Taylor		0	0

Final Table Time Posted Sunday 11th August, 2024 at 17:07(UTC-7) by Lyle Bateman

They are down to the final table of 10 players now after Brant Taylor was the bubble to the FT tonight. There are just under 30 minutes left in Level 23, and I'll grab full chip counts for the remaining players at the break.

E3 Final Table

T	S	Player	Hometown	Chips
22	1	Michael Malm	Calgary, AB
22	2	Stephen Nahm	Burnaby, BC
22	3	Ethan Figueroa	Austin, TX
22	4	"Funcle" Lee Clark	Calgary, AB
22	5	Phillip Louie	Revelstoke, BC
22	6	Caleb Simmons	Calgary, AB
22	7	Leo Zhang	Edmonton, AB
22	8	Tony Mendes	Canada
22	9	Hee Chan 'David' Kang	Vancouver, BC
22	10	Gail Flaherty	Calgary, AB

17:02 (UTC-7)

Start of Level 23
Blinds: 0/0 Ante: 0

Final Table Bubble Posted Sunday 11th August, 2024 at 16:32(UTC-7) by Lyle Bateman

The are down to 11 left now on the bubble to the final table. Hassan Issa and Nohad Teliani were the recent exits to bring them to 11.

Player		Chips	Progress
Nohad Teliani		0	0
Hassan Issa		0	0

13 Remain Posted Sunday 11th August, 2024 at 16:26(UTC-7) by Lyle Bateman

Sebastian Fallu was the most recent casualty here on Day 2 to bring the field to 13. There are about 20 minutes to play in Leel 22 with the next break scheduled for the end of Level 23.

Player		Chips	Progress
Sebastien Fallu		0	0

Down to 14 Left Posted Sunday 11th August, 2024 at 16:11(UTC-7) by Lyle Bateman

They are down to 14 players left in Day 2 now with Zhi Jiang and Brad Bernier among the recent busts. One player, Tom T, wishes not to be fully identified, so he is in the payouts as DNR today.

Player		Chips	Progress
Zhi Jiang		0	0
Brad Bernier		0	0
Tom T		0	0

16:08 (UTC-7)

Start of Level 22
Blinds: 15,000/25,000 Ante: 25,000

Final Two Tables Posted Sunday 11th August, 2024 at 15:48(UTC-7) by Lyle Bateman

They are down to 17 now after the exits of Calgary's Paul Brar and Dennis Ashmore. They've just redrawn for new seats at the final two tables.

Player		Chips	Progress
Paul Brar		0	0
Dennis Ashmore		0	0

Down to 20 Posted Sunday 11th August, 2024 at 15:42(UTC-7) by Lyle Bateman

Melanie Romanowski from Langley. BC and Calgary's Chris Hodgins were the most recent players to hit the payout desk for $1,957. There are now 19 players left alive, one away from the final two tables.

Player		Chips	Progress
Chris Hodgins		0	0
Melanie Romanowski		0	0

45-Minute Levels Underway Posted Sunday 11th August, 2024 at 15:29(UTC-7) by Lyle Bateman

With the start of Level 21, the Day 2 structure is now in play with levels now running for 45 minutes. The field is now down to 22 remaining with Aidan Klingbeil ($1,811), runner-up from the Mix game Nima Hesamfar, as well as Rauno Tahvonen, Evan Casey, Scott Galant, and Chase Cromwell cashing out for $1,957 recently hitting the cash cage.

Player		Chips	Progress
Chase Cromwell		0	0
Evan Casey		0	0
Scott Gallant		0	0
Nima Hesamfar		0	0
Rauno Tahvonen		0	0
Aidan Klinbeil		0	0

Simmons Still Leading Posted Sunday 11th August, 2024 at 15:03(UTC-7) by Lyle Bateman

Caleb Simmons has doubled his stack from the start of the day with more than 2.5 million in front of him now, but David Kang is nipping at his heels with 2.35 million. Gail Flaherty, who came into today second in chips has also more than doubled her start-of-day stack and is playing 2.12 million now.

Player	Chips	Progress
Caleb Simmons	2,535,000	1,378,000
Hee Chan 'David' Kang	2,350,000	1,657,000
Gail Flaherty	2,120,000	1,188,000

15:00 (UTC-7)

Start of Level 21
Blinds: 10,000/20,000 Ante: 20,000

First Break of the Day Posted Sunday 11th August, 2024 at 14:55(UTC-7) by Lyle Bateman

They are heading out for their first break of Day 2 with the conclusion of Level 20. There are 27 remaining in the game now on the final three tables. I'll have a look around at the break for some current stacks.

Down to Final Three Tables Posted Sunday 11th August, 2024 at 14:52(UTC-7) by Lyle Bateman

They are down to 27 remaining in Day 2 now. Among the recent players to bust from the final four tables were triple-ring and WPT winner David Ko, as well as Toms Varghese. Payouts to 28th place will be updated shortly in the backend.

Player		Chips	Progress
Soon Yi Kang		0	0
Guoqing 'Jack' Wu		0	0
David Ko		0	0
Mark Inglis		0	0
Toms Varghese		0	0
Adam Cygman		0	0
Ali Seyednabian		0	0
Lorne Wilmot		0	0
Chris Watson		0	0

14:21 (UTC-7)

Start of Level 20
Blinds: 10,000/15,000 Ante: 15,000

Final Four Tables Posted Sunday 11th August, 2024 at 14:15(UTC-7) by Lyle Bateman

Manitoba's Claire Leclerc, as well as the winner of this event in May, Peter Darlington, were among the recent players to cash out before the final four tables.

Player		Chips	Progress
Claire Leclerc		0	0
Peter Darlington		0	0
Michael Baldwin		0	0

Down to 39 Posted Sunday 11th August, 2024 at 14:05(UTC-7) by Lyle Bateman

Johnny Dalphond just hit the payout desk for 40th place, with payouts to 41st place loaded into the backend now.

Player		Chips	Progress
Max Fernandez		0	0
Pushpinder Singh		0	0
Kim Pham		0	0
Dwayne Reid		0	0
John Dalphond		0	0

13:52 (UTC-7)

Start of Level 19
Blinds: 6,000/12,000 Ante: 12,000

Down to 44 Posted Sunday 11th August, 2024 at 13:44(UTC-7) by Lyle Bateman

There are just under 10 minutes left to play in Level 18 and the field is down to 44 now. Christian Mirkovic and Tianshu Liu have joined Krystian Hady and CHad Riddell in the Day 2 min-cash line.

Player		Chips	Progress
Chad Riddell		0	0
Krystian Hady		0	0
Tianshin Lin		0	0
Christian Mirkovic		0	0

46 Players Left Posted Sunday 11th August, 2024 at 13:24(UTC-7) by Lyle Bateman

They lost a couple of players in the opening level today to bring the remaining field down to 46 left. Chad Riddell and micro-stack Krystian Hady were the two payouts so far. I'll update the payouts in the backend shortly, but meanwhile, here's a look at today's Day 2 field.

13:21 (UTC-7)

Start of Level 18
Blinds: 5,000/10,000 Ante: 10,000

Day 2 is Underway! Posted Sunday 11th August, 2024 at 13:02(UTC-7) by Lyle Bateman

Day 2 of the 4-Flight is now underway with 48 players returning to fight for $47k up top. There are just under 20 minutes left in Level 17 to start the day, as the blinds were rolled back to the earliest endpoint from any Day 1, which turned out to be 1b ending in Level 17.

Seat Assignments by Table Posted Sunday 11th August, 2024 at 00:08(UTC-7) by Lyle Bateman

Table 21

T	S	Player	Hometown	Chips
21	1	Claire Leclerc	Navin, MB	215,000
21	2	Lorne Wilmot	White Rock, BC	468,000
21	3	Ethan Figueroa	Austin, TX	296,000
21	4	Christian Mirkovic	Calgary, AB	211,000
21	5	Brad Bernier	Red Deer, AB	490,000
21	6	Kim Pham	Calgary, AB	423,000
21	7	"Funcle" Lee Clark	Calgary, AB	304,000
21	8	Gail Flaherty	Calgary, AB	932,000

Table 22

T	S	Player	Hometown	Chips
22	1	Tom T	Edmonton, AB	344,000
22	2	Pushpinder Singh	Calgary, AB	210,000
22	3	Toms Varghese	Calgary, AB	195,000
22	5	Adam Cygman	Calgary, AB	461,000
22	6	Hee Chan 'David' Kang	Vancouver, BC	693,000
22	7	Tony Mendes	Canada	828,000
22	8	Paul Brar	Calgary, AB	269,000
22	9	Rauno Tahvonen	Fernie, BC	436,000

Table 23

T	S	Player	Hometown	Chips
23	1	Brant Taylor	Vancouver, BC	244,000
23	2	Caleb Simmons	Calgary, AB	1,157,000
23	3	Peter Darlington	Calgary, AB	565,000
23	4	Zhi Jiang	Edmonton, AB	323,000
23	5	Max Fernandez	Calgary, AB	205,000
23	6	John Dalphond	Leduc, AB	353,000
23	8	Dwayne Reid	Calgary, AB	850,000
23	9	Michael Baldwin	Calgary, AB	625,000

Table 24

T	S	Player	Hometown	Chips
24	1	Chris Hodgins	Calgary, AB	345,000
24	2	Chase Cromwell	Calgary, AB	467,000
24	4	Tianshin Lin	Calgary, AB	201,000
24	5	Stephen Nahm	Burnaby, BC	385,000
24	6	Melanie Rowanowski	Langley, BC	147,000
24	7	Ali Seyednabian	Calgary, AB	243,000
24	8	Nohad Teliani	Edmonton, AB	268,000
24	9	Dennis Ashmore	Calgary, AB	297,000

Table 29

T	S	Player	Hometown	Chips
29	1	Phillip Louie	Revelstoke, BC	442,000
29	2	Hassan Issa	Calgary, AB	210,000
29	3	Soon Yi Kang	Edmonton, AB	272,000
29	4	David Ko	Burnaby, BC	490,000
29	5	Michael Malm	Calgary, AB	551,000
29	6	Leo Zhang	Edmonton, AB	167,000
29	7	Guoqing 'Jack' Wu	Calgary, AB	584,000
29	8	Mark Inglis	Port Alice, BC	326,000

Table 30

T	S	Player	Hometown	Chips
30	2	Nima Hesamfar	Vancouver, BC	152,000
30	3	Sebastien Fallu	Bragg Creek, AB	352,000
30	4	Chad Riddell	Calgary, AB	174,000
30	5	Evan Casey	Regina, SK	250,000
30	6	Scott Gallant	Calgary, AB	162,000
30	7	Aidan Klinbeil	Calgary, AB	192,000
30	8	Krystian Hady	Lethbridge, AB	18,000
30	9	Chris Watson	Abbotsford, BC	368,000

Day 2 is Set with Caleb Simmons Stacking Big Posted Sunday 11th August, 2024 at 00:02(UTC-7) by Lyle Bateman

Event #3:	$400 4-Flight ($330 + $70)
Date:	Day 2: Aug 11, 2024, 1 pm
Blinds:	30 Min
Entries:	905
Prizes:	$298,650
1st Place:	$47,068

The stage is set for Day 2 of the 4-Flight Sunday at 1 pm. Caleb Simmons is the player to beat coming into the day as he was the only player to find seven digits for his bag. Gail Flaherty came close on Friday night with 932k, but Simmons is the only one over a million. The rest of the flight leaders fill out the top four with Dwayne Reid on 850k and Tony Mendes on 828k. Full stack details are under the Chip Counts tab.

Day 2 action kicks off at 1 pm on Sunday and they'll play down to a winner before they finish. I'll be following this one until it finishes tomorrow and I should be on the floor for the start. Stay tuned for seat assignments coming up shortly.

Player		Chips	Progress
Caleb Simmons		1,157,000	0
Gail Flaherty		932,000	0
Dwayne Reid		850,000	0
Tony Mendes		828,000	0
Hee Chan 'David' Kang		693,000	0

23:45 (UTC-7)

Day 2 of Deerfoot Inn and Casino Started
Level: 17 Blinds: 4,000/8,000 Ante: 8,000

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Your search results are valid for . More Info

Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.

T

S

Player

Hometown

Chips

E3 Final Table

T

S

Player

Hometown

Chips

Table 21

T

S

Player

Hometown

Chips

Table 22

T

S

Player

Hometown

Chips

Table 23

T

S

Player

Hometown

Chips

Table 24

T

S

Player

Hometown

Chips

Table 29

T

S

Player

Hometown

Chips

Table 30

T

S

Player

Hometown

Chips

Browse

Useful Links

Subscribe to our newsletter