0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0081 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-13'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/174'
ORDER BY `views` DESC
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '174'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '174'
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '382'
AND `published` = 1
0.0273 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '383'
AND `published` = 1
0.0275 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '385'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '386'
AND `published` = 1
0.0065 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.0062 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.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` = '16683'
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` = '16682'
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` = '16681'
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` = '16680'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16679'
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` = '16678'
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` = '16677'
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` = '16676'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16675'
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` = '16674'
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` = '16673'
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` = '16672'
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` = '16671'
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` = '16670'
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` = '16669'
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` = '16668'
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` = '16667'
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` = '16666'
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` = '16665'
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` = '16664'
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` = '16663'
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` = '16662'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16661'
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` = '16660'
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` = '16659'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16658'
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` = '16657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '16654'
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` = '16653'
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` = '16651'
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` = '16650'
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` = '16649'
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` = '16648'
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` = '16647'
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` = '16646'
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` = '16645'
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` = '16643'
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` = '16642'
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` = '16641'
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` = '16640'
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` = '16637'
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` = '16636'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16635'
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` = '16634'
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` = '16620'
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` = '16619'
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` = '16618'
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` = '386'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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.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` = '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.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` = '16681'
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` = '16680'
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` = '16679'
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` = '16678'
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` = '16677'
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` = '16676'
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` = '16675'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16674'
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` = '16673'
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` = '16672'
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` = '16671'
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` = '16670'
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` = '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.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` = '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.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` = '16663'
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` = '16662'
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` = '16661'
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` = '16660'
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` = '16659'
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` = '16658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16657'
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` = '16656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16655'
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` = '16654'
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` = '16653'
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` = '16651'
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` = '16650'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16649'
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` = '16648'
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` = '16647'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16646'
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` = '16645'
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` = '16643'
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` = '16642'
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` = '16641'
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` = '16640'
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` = '16637'
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` = '16636'
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` = '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.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` = '16620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16619'
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` = '16618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 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
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.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Deerfoot Inn and Casino
Event #3: $400 4-Flight ($330 + $70)
Live Reporting - 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
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.
against the set. He had a gutshot, but the ten paired on the river to brick his draw and give Louie the boat.
for Zhang against 
for Louie. The 
board missed both players so the ace-high took it down.
river but mucked when Louie bet 3 million, enough to put Zhang all in.
turn and for 550k on the 
so Flaherty doubled with the best set.
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.
flop, which Flaherty called to the 
turn.
for the flush and the win.
turn. Flaherty was the only caller to the 
flop and it didn't take Nahm long to get out of her way.
river sealed the deal for Nahm and sent Simmons packing in 7th.
flop and he fired 105k.
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."
