0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-13'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/186/402/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '186'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '186'
0.0258 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '402'
AND `published` = 1
0.0064 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '402'
ORDER BY `busted` ASC, `current_chips` DESC
0.0064 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` = '402'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17371'
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` = '17370'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17369'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17368'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17366'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17365'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17364'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17358'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17355'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17354'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17353'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17352'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17351'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17350'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17349'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17342'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17341'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17340'
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` = '17339'
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` = '17338'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17337'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17336'
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` = '17335'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17334'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17333'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17326'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17325'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17324'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17323'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17320'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17319'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17318'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17309'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17308'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17304'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17303'
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` = '17294'
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` = '17293'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17290'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17289'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17287'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17286'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17279'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17278'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17275'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17274'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17273'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17264'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17263'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17262'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17249'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17248'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17247'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17244'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17232'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17230'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '402'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '402'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17371'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17370'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17369'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17368'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17366'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17365'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17364'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17358'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17355'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17354'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17353'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17352'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17351'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17350'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17349'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17342'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17341'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17340'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17339'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17338'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17337'
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` = '17336'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17335'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17334'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17333'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17326'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17325'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17324'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17323'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17320'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17319'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17318'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17309'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17308'
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` = '17304'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17303'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17294'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17293'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17290'
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` = '17289'
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` = '17287'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17286'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17279'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17278'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17275'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17274'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17273'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17264'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17263'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17262'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17249'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17248'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17247'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17244'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17232'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17230'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '17220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '402'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 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 #15: $2,200 High Roller ($1,965 + $235)
Live Reporting - Day 1
Homan Mohammadi Wins his First Ring in the High Roller Posted Tuesday 20th August, 2024 at 00:05(UTC-7) by Lyle Bateman
Homan Mohammadi has been close to a ring before with a couple of other final table finishes in past WSOP-C series in Richmond, BC back in the day, but this is the first time he's been the last player standing in a Circuit event. He came into Day 2 with the second stack, and held a big stack through most of the day. He was the chip leader throughout most of the final table.
He used the stack well, pressuring other players in ICM spots to steal chips and maintain the big stack, happy to get out of the way when he met action on a steal. He wasn't scared to call for value either, and at one point he had half of the chips in play with 5 players left. 3rd place Duff Charette did take over the lead briefly three-handed, but it didn't last long, Charette was out about 20 minutes later and though it was runner-up Taran Parmar who collected Charette's chips, it still left Mohammadi in command.
Heads up was pretty quick and the money went in with both players on connected cards. Mohammadi had the best hand technically but they were likely to chop the pot quite often. Mohammadi turned a pair to take a big lead though, and Parmar couldn't catch up.
This is Mohammadi's 4th win on the live felt, but not his biggest score. He'll have more than $700k in live earnings once this one is recorded with this one slotting in third on his list of biggest cashes just above his 2nd place here in 2021 in the Main Event at the Summer Super Stack and a bit below his 2013 3rd place in the Richmond Circuit Main Event.
Taran Parmar Out in 2nd Place for $59,489 Posted Monday 19th August, 2024 at 23:13(UTC-7) by Lyle Bateman
Taran Parmar had quite a run today in the High Roller, ending up second. He was short for most of the final table, but played the shirt stack very well, mostly avoiding the big pots other players got into. In the process, he managed to ladder over several other bigger stacks throughout the day. During heads up, he never had the chip lead and it ended fairly quickly. On the final hand, they both had connected cards, but winner Homan Mohammadi turned a pair to take the lead and held for the win.
Player
Chips
Progress
Taran Parmar
0
0
Chips Heads Up Posted Monday 19th August, 2024 at 22:15(UTC-7) by Lyle Bateman
Player
Chips
Progress
Homan Mohammadi
5,100,000
2,010,000
Taran Parmar
2,500,000
1,130,000
Duff Charette
0
0
Duff Charette Out in 3rd Place for $40,862 Posted Monday 19th August, 2024 at 22:07(UTC-7) by Lyle Bateman
They are heads up in the High Roller now after Duff Charette ran into the queens of Taran Parmar. Charette was on king-jack and Parmar asked for the board to be "clean". The flop came out and the table laughed.
"Is that clean enough for you?" asked the dealer, Harvie. on the turn and river were irrelevant and Charette hit the rail for 3rd. He's had a good series though, with this being his third top-three finish of the series, and completing his gold/silver/bronze collection.
22:00 (UTC-7)
Start of Level 27 Blinds: 50,000/100,000 Ante: 100,000
Parmar Gets a Small One with Kings Posted Monday 19th August, 2024 at 22:00(UTC-7) by Lyle Bateman
Taran Parmar opened the button to 200k and Duff Charette called from the big blind. They both checked the flop and turn, and Charette check-called for 210 on the river. Charette had a five, but the kings for Parmar were good, though the flop slowed Parmar down a bit for value.
Charette Takes the Lead Posted Monday 19th August, 2024 at 21:48(UTC-7) by Lyle Bateman
Duff Charette opened the button, the shoved when Homan Mohammadi raised it. Mohammadi called it down with the big stack, and was racing with against pocket sixes. The board ran clean for the sixes and Charrette doubled into the lead.
Player
Chips
Progress
Duff Charette
3,350,000
2,450,000
Homan Mohammadi
3,090,000
210,000
Taran Parmar
1,370,000
270,000
21:18 (UTC-7)
Start of Level 26 Blinds: 40,000/80,000 Ante: 80,000
Daniel Lefebvre Our in 4th Place for $28,778 Posted Monday 19th August, 2024 at 21:18(UTC-7) by Lyle Bateman
They are down to 3 left in the High Roller now after Daniel Lefebvre ended his day in 4th. It was a pretty brutal spot blind on blind as Lefebvre raised to 180k, then called the shove from Duff Charette in the big blind. Lefebvre had against but Lefebvre flopped the world . The turn paired the board with giving Charette a flush draw as well, but on the gave them both a pair of aces with a pair of sevens but Charette's kicker played for the win.
Player
Chips
Progress
Daniel Lefebvre
0
0
Lefebvre Doubles Posted Monday 19th August, 2024 at 21:07(UTC-7) by Lyle Bateman
Homan Mohammadi opened to 120k under the gun and Daniel Lefebvre shoved the button for 830k. Mohammadi snap-called good with queens against king-jack, but the board had other ideas, flopping a jack and turning a king to give Lefebvre two pair for the win.
Player
Chips
Progress
Homan Mohammadi
3,300,000
445,000
Daniel Lefebvre
1,810,000
760,000
"Do you want to sleep tonight"? Posted Monday 19th August, 2024 at 20:55(UTC-7) by Lyle Bateman
I picked up the action on the flop reading and Homan Mohammadi check-raised from the small blind to 425 over the bet from Damiel Lefebvre worth 120. Lefebvre called to the turn and Mohammadi shoved the covering stack. Lefebvre tank-folded his hand.
"Do you want to sleep tonight?" Mohammadi asked. Lefebvre said yes and Mohammadi showed a seven.
"Thank you for showing."
Parmar Doubles to Stay Alive Posted Monday 19th August, 2024 at 20:47(UTC-7) by Lyle Bateman
Taran Parmar has been the short stack for much of the final table, but he just found a double to chip up. It was blind on blind when Duff Charette raised enough to put Parmar all in for his final 445k. Parmar opened his hand, found queen-jack, and called it off. He was up against ace-five but a jack on the flop put him ahead and he held to chip up to more than a million.
Player
Chips
Progress
Taran Parmar
1,100,000
475,000
Duff Charette
900,000
465,000
20:33 (UTC-7)
Start of Level 25 Blinds: 30,000/60,000 Ante: 60,000
David Labchuk Out in 5th Place for $20,794 Posted Monday 19th August, 2024 at 20:31(UTC-7) by Lyle Bateman
They are down to 4 left now after David Labchuk flopped open-ended against Daniel Lefebvre's aces blind on blind. It was limped preflop, and it all kicked off on the flop. Lefebvre bet near pot, Labchuk raised, Lefebvre reraised, then called the ship from Labchuk with a bit more. The board ran out to a double paired board and no straight cards came for Labchuk so he sent his stack to Lefebvre.
Player
Chips
Progress
Homan Mohammadi
3,745,000
45,000
Duff Charette
1,365,000
265,000
Daniel Lefebvre
1,050,000
500,000
Taran Parmar
625,000
25,000
David :Labchuk
0
0
Mohammadi Fires Back Posted Monday 19th August, 2024 at 20:14(UTC-7) by Lyle Bateman
Homan Mohammadi opened to 105k from the cutoff and Daniel Lefebvre three-bet the button to 250k. It folded back around to Mohammadi and he asked how much Lefebvre was playing. He had chipped up a bit on the previous hand and had just over a million to start the hand. Mohammadi fired back the four-bet to 650k and Lefebvre quickly mucked.
James Du Out in 6th Place for $15,425 Posted Monday 19th August, 2024 at 20:07(UTC-7) by Lyle Bateman
There are just five players left in the High Roller now with James Du finishing 6th tonight. Homan Mohammadi is the big leader right now with about half the chips in play.
Player
Chips
Progress
Homan Mohammadi
3,700,000
2,998,000
David :Labchuk
1,600,000
1,482,000
Duff Charette
1,100,000
858,000
Taran Parmar
600,000
420,000
Daniel Lefebvre
550,000
185,000
Dave McLeod
0
0
Colten Yamagishi
0
0
David Ko
0
0
Zeyu Du
0
0
19:38 (UTC-7)
Start of Level 24 Blinds: 25,000/50,000 Ante: 50,000
David Ko Out in 7th Place for $11,756 Posted Monday 19th August, 2024 at 19:15(UTC-7) by Lyle Bateman
David Ko picked up the first five-figure score tonight for 7th place worth $11,756.
Colten Yamagishi Out in 8th Place for $9,212 Posted Monday 19th August, 2024 at 19:11(UTC-7) by Lyle Bateman
Colten Yamagishi took the final payout of less than $10k today as he ended his run in 8th place tonight.
Dave McLeod Out in 9th Place for $7,427 Posted Monday 19th August, 2024 at 19:09(UTC-7) by Lyle Bateman
Thet are down to 8 left in the High Roller after Dav McLeod busted out in 9th. I'm still working on finishing up posts on the Main Event so I've missed most of the action in this one but I should be over watching shortly.
18:56 (UTC-7)
Start of Level 23 Blinds: 20,000/40,000 Ante: 40,000
Scott Hill Out in 10th Place for $6,167 Posted Monday 19th August, 2024 at 18:39(UTC-7) by Lyle Bateman
They are down to 9 left in the High Roller now as Scott Hill just hit the payout desk for 10th place. I missed the action getting pictures uploaded.
Final Table Faces Posted Monday 19th August, 2024 at 18:37(UTC-7) by Lyle Bateman
Fat Wong Bubbles Final Table Posted Monday 19th August, 2024 at 18:16(UTC-7) by Lyle Bateman
Fat Wong was the player to bubble the final table tonight in the High Roller shortly after the dinner break. That puts them down to 10 and I'll grab some final table photos shortly.
Back from Dinner Posted Monday 19th August, 2024 at 18:14(UTC-7) by Lyle Bateman
The High Roller is back from the dinner break now with 11 players left, one off the final table. It looks like David Labchuk is the current leader with about 1.6 million in front of him while David Ko has 1.16 million and Colten Yamagishi has 800k. Homan Mohammadi looks to be down to about 600k.
18:11 (UTC-7)
Start of Level 22 Blinds: 15,000/30,000 Ante: 30,000
Down to 11 Posted Monday 19th August, 2024 at 17:05(UTC-7) by Lyle Bateman
They are on the Final Table bubble now with 11 players left in the game. Gary Rroprai, Kris Steinbach, and Andy Truong were the recent busts to get them to 11.
17:03 (UTC-7)
Start of Level 21 Blinds: 15,000/25,000 Ante: 25,000
14 Left in the High Roller Posted Monday 19th August, 2024 at 16:30(UTC-7) by Lyle Bateman
There are 14 players left in the High Roller now with start-of-day leader DJ Sharma the most recent player to hit the rail Chris Ckisby also had a big stack to start the day and he was out in 18th today, Right now it looks like Homan Mohammadi and David Ko are the co-leaders with both players on about 1 million and the two players from the west coast are seated side by side with Mohammadi on Ko's left.
16:25 (UTC-7)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
Final Two Tables for High Rollers Posted Monday 19th August, 2024 at 15:57(UTC-7) by Lyle Bateman
They are down to the final two tables in the High Roller now with 17 remaining. We still haven't seen 24th place show up to get their payslip authorized so that spot is still blank, but the rest of the prizes so far today are updated under the Payouts tab.
15:52 (UTC-7)
Start of Level 19 Blinds: 10,000/15,000 Ante: 15,000
22 Left in High Roller Posted Monday 19th August, 2024 at 14:16(UTC-7) by Lyle Bateman
The Main is on their first break of the day with 3 players left so I'm still not watching this game very closely. They are down to 22 now with seven pay spots already claimed but two players haven't checked in with the desk yet so the prizes under the Payouts tab are not complete, but five of the seven cashers so far are listed there now.
14:13 (UTC-7)
Start of Level 17 Blinds: 5,000/10,000 Ante: 10,000
High Roller Action UNderway Posted Monday 19th August, 2024 at 13:13(UTC-7) by Lyle Bateman
They are nearing the bubble now in the High Roller with the field down to 31 about 15 minutes into the day. I won't be watching this one too closely until the Main finishes.
13:12 (UTC-7)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
Day 2 Seats Posted Monday 19th August, 2024 at 02:32(UTC-7) by Lyle Bateman
Day 2 Setas by Table
Table
Seat
Player
Home
Chips
63
1
Chris Clisby
Winnipeg,MB
630,000
63
2
Aaron Quon
Langley, BC
138,000
63
3
Taran Parmar
Edmonton, AB
180,000
63
4
David Labchuk
Calgary, AB
118,000
63
5
Hari Aujla
Surrey, BC
27,000
63
6
Scott Hill
Vancouver, BC
273,000
63
7
Kris Steinbach
Sherwood Park, AB
318,000
63
9
DJ Sharma
Edmonton, AB
744,000
Table
Seat
Player
Home
Chips
69
1
Pavlo Vertiiko
Vancouver, BC
202,000
69
2
Daniel Lefebvre
Saskatoon, SK
365,000
69
3
David Ko
Burnaby, BC
248,000
69
4
Wei Wu
Burnaby, BC
36,000
69
5
Ryan Cairns
Edmonton, AB
118,000
69
6
Duff Charette
Ottawa, ON
242,000
69
8
Andy Truong
Calgary, AB
243,000
69
9
Michael 'Berby' Bernstein
Edmonton, AB
68,000
Table
Seat
Player
Home
Chips
71
1
Gary Rooprai
Vancouver, BC
263,000
71
2
Homan Mohammadi
Vancouver, BC
702,000
71
3
Colten Yamagishi
Edmonton, AB
473,000
71
4
Christ Lastiwka
Edmonton, AB
215,000
71
5
Gaetano Buda
Kleinburg, ON
113,000
71
6
Ray Muzyka
Edmonton, AB
114,000
71
7
Lina Niu
Edmonton, AB
145,000
71
8
Dave McLeod
Aklavik, NT
192,000
71
9
Vince Lam
Edmonton, AB
149,000
Table
Seat
Player
Home
Chips
73
1
Zeyu Du
Richmond, BC
220,000
73
2
Jae Whan Lee
Vancouver, BC
278,000
73
3
Darlene Lee
Vancouver, BC
97,000
73
4
Alex Bylicki
Vancouver, BC
156,000
73
5
Fat Wong
Calgary, AB
177,000
73
6
Sheraz Nasir
Edmonton, AB
78,000
73
7
Sunny Lubana
Saskatoon, SK
288,000
73
9
Jimmy Lee
Edmonton, AB
98000
73
8
Tyler Panas
Calgary, AB
48,000
73
9
Jimmy Lee
Edmonton, AB
98000
73
8
Tyler Panas
Calgary, AB
48,000
Day 2 Seats by Name
Table
Seat
Player
Home
Chips
63
2
Aaron Quon
Langley, BC
138,000
73
4
Alex Bylicki
Vancouver, BC
156,000
69
8
Andy Truong
Calgary, AB
243,000
63
1
Chris Clisby
Winnipeg,MB
630,000
71
4
Christ Lastiwka
Edmonton, AB
215,000
71
3
Colten Yamagishi
Edmonton, AB
473,000
69
2
Daniel Lefebvre
Saskatoon, SK
365,000
73
3
Darlene Lee
Vancouver, BC
97,000
71
8
Dave McLeod
Aklavik, NT
192,000
63
4
David Labchuk
Calgary, AB
118,000
69
3
David Ko
Burnaby, BC
248,000
63
9
DJ Sharma
Edmonton, AB
744,000
69
6
Duff Charette
Ottawa, ON
242,000
73
5
Fat Wong
Calgary, AB
177,000
71
5
Gaetano Buda
Kleinburg, ON
113,000
71
1
Gary Rooprai
Vancouver, BC
263,000
63
5
Hari Aujla
Surrey, BC
27,000
71
2
Homan Mohammadi
Vancouver, BC
702,000
73
2
Jae Whan Lee
Vancouver, BC
278,000
73
9
Jimmy Lee
Edmonton, AB
98000
63
7
Kris Steinbach
Sherwood Park, AB
318,000
71
7
Lina Niu
Edmonton, AB
145,000
69
9
Michael 'Berby' Bernstein
Edmonton, AB
68,000
69
1
Pavlo Vertiiko
Vancouver, BC
202,000
71
6
Ray Muzyka
Edmonton, AB
114,000
69
5
Ryan Cairns
Edmonton, AB
118,000
63
6
Scott Hill
Vancouver, BC
273,000
73
6
Sheraz Nasir
Edmonton, AB
78,000
73
7
Sunny Lubana
Saskatoon, SK
288,000
63
3
Taran Parmar
Edmonton, AB
180,000
73
8
Tyler Panas
Calgary, AB
48,000
71
9
Vince Lam
Edmonton, AB
149,000
69
4
Wei Wu
Burnaby, BC
36,000
73
1
Zeyu Du
Richmond, BC
220,000
Day 2 Seats by Stack
Table
Seat
Player
Home
Chips
63
9
DJ Sharma
Edmonton, AB
744,000
71
2
Homan Mohammadi
Vancouver, BC
702,000
63
1
Chris Clisby
Winnipeg, MB
630,000
71
3
Colten Yamagishi
Edmonton, AB
473,000
69
2
Daniel Lefebvre
Saskatoon, SK
365,000
63
7
Kris Steinbach
Sherwood Park, AB
318,000
73
7
Sunny Lubana
Saskatoon, SK
288,000
73
2
Jae Whan Lee
Vancouver, BC
278,000
63
6
Scott Hill
Vancouver, BC
273,000
71
1
Gary Rooprai
Vancouver, BC
263,000
69
3
David Ko
Burnaby, BC
248,000
69
8
Andy Truong
Calgary, AB
243,000
69
6
Duff Charette
Ottawa, ON
242,000
73
1
Zeyu Du
Richmond, BC
220,000
71
4
Christ Lastiwka
Edmonton, AB
215,000
69
1
Pavlo Vertiiko
Vancouver, BC
202,000
71
8
Dave McLeod
Aklavik, NT
192,000
63
3
Taran Parmar
Edmonton, AB
180,000
73
5
Fat Wong
Calgary, AB
177,000
73
4
Alex Bylicki
Vancouver, BC
156,000
71
9
Vince Lam
Edmonton, AB
149,000
71
7
Lina Niu
Edmonton, AB
145,000
63
2
Aaron Quon
Langley, BC
138,000
63
4
David Labchuk
Calgary, AB
118,000
69
5
Ryan Cairns
Edmonton, AB
118,000
71
6
Ray Muzyka
Edmonton, AB
114,000
71
5
Gaetano Buda
Kleinburg, ON
113,000
73
9
Jimmy Lee
Edmonton, AB
98000
73
3
Darlene Lee
Vancouver, BC
97,000
73
6
Sheraz Nasir
Edmonton, AB
78,000
69
9
Michael 'Berby' Bernstein
Edmonton, AB
68,000
73
8
Tyler Panas
Calgary, AB
48,000
69
4
Wei Wu
Burnaby, BC
36,000
63
5
Hari Aujla
Surrey, BC
27,000
Day 2 in the High Roller is SHARMA TIME! Posted Monday 19th August, 2024 at 02:23(UTC-7) by Lyle Bateman
When they finished 15 levels of play today, the High Roller ended with 34 players left. That means five players will have to go home from Day 2 empty-handed. Day 1 of this game was a raucous affair and while I didn't get to watch much of it, it was clear from the noise coming from the other side of the Sundance Room that they were having a lot of fun.
As is often the case, some of the loudest noise in the room came from DJ Sharma, who can often be heard shouting "It's Sharma TIME!" while hands are running out. I heard that a fair bit tonight, and it's easy to see why - the Edmonton McDonald's magnate bagged the biggest stack of the day with 744k. Vancouver's Homan Mohammadi wasn't far behind with just over 700k. Chris Clisby, Colten Yamagishi, and Daniel Lefebvre, whose streak of High Roller wins on the other Alberta poker tour recently came to an end, also bagged top-five stacks for the second day.
The final day of play in this one kicks off at 1 pm on Monday and action will be in the Sundance Room. They start in Level 16 with blinds at 4k/8k/8k and they'll play down to the ring. I'll be watching the final five in the Main Event as my 1st priority early in the day, but I have a suspicion that won't take long to finish and I'll be over on the High Roller coverage within a few hours of the game kicking off.
Full stacks are in the Chip Counts tab, and stay tuned for the seat assignments for Day 2.
Down to 4 Tables Posted Monday 19th August, 2024 at 00:47(UTC-7) by Lyle Bateman
They are 8 players off the money with just under 30 minutes to go in the night. They've just broken down to the final four tables with 36 players left and among them is Gaetano Buda, who was having a bad run here this time around but may be in a position to improve it a little here at least. I'll have eyes on the bags in a while, but some are below with DJ Sharma leading the way.
Player
Chips
DJ Sharma
540,000
Chris Clisby
450,000
Colten Yamagishi
420,000
Sunny Lubana
320,000
Kris Steinbach
320,000
Andy Truong
240,000
Duff Charette
200,000
Arif Dhalla
190,000
Yussef Hmama
150,000
Daniel Lefebvre
150,000
David Ko
134,000
Ryan Cairns
120,000
Jimmy Lee
120,000
Michael Bernstein
100,000
Tyler Panas
60,000
00:21 (UTC-7)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
Almost $90k for the Winner Posted Monday 19th August, 2024 at 00:09(UTC-7) by Lyle Bateman
The prizes are in and posted under the Payouts tab, but the field of 192 is confirmed, which beat the May total by 41 entries. The prize pool is $377,280 in total and the winner tomorrow will get $88,743. Seven players at the final table will get scores of $10k or better, and 29 players will get some piece of the pie.
They are down to 38 left with just under 15 minutes to go in Level 14 and one more level to play tonight after this one. While I haven't had eyes on much of the action, I do have ears and this has been a loud one tonight (I joked earlier that I've covered team tournaments that were quieter than this one) and it's been clear even from across the room that the chips have been flying around pretty freely tonight. There's a very good chance they'll play into the money before the bags come out, but there are still nine players to go before then.
00:04 (UTC-7)
Start of Level 14 Blinds: 3,000/5,000 Ante: 5,000
192 Entries (Unofficial) After Reg Posted Sunday 18th August, 2024 at 23:07(UTC-7) by Lyle Bateman
Reg is now closed and they finished with 192 entries on the board. Those numbers are yet to be confirmed but if they hold, 29 players will be getting some piece of $377,280 in prizes. The prize pool should be posted shortly and I'll confirm the numbers then.
23:04 (UTC-7)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
15 Min Left in Entries Posted Sunday 18th August, 2024 at 22:48(UTC-7) by Lyle Bateman
They are just 15 minutes away from the end of entries now with the end of Level 12. Entries will be closed when they return from the break and currently, there are 187 entries on the board for prizes of $367,455 with 63 players left in the game.
22:46 (UTC-7)
Start of Level 12 Blinds: 2,000/3,000 Ante: 3,000
High Roller Beats May with Almost $325k in Prizes Posted Sunday 18th August, 2024 at 21:17(UTC-7) by Lyle Bateman
There are still more than an hour left in entries for the High Roller, and they are already ahead of the May total of 151. The numbers now are up to 164 entries for prizes of $322,260 but the game has been a bit wild with lots of action, lots loud fun, and lots of chips flying around the room, so I fully expect more rebuys before the end of the game.
One player here this week is having a rough go of it. Gaetano Buda was on the final table of the Main Event in May and took 7th for $35k. This time around, however, he's been on the wrong end of the deck. He's just rebought into the High Roller after telling me outside that he's getting "rivered on every hand." Poker can be a brutal game, and we can probably all relate to how Buda is feeling this series.
21:12 (UTC-7)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Six Off May's Total Posted Sunday 18th August, 2024 at 19:17(UTC-7) by Lyle Bateman
Level 8 has just begun and they are up to 145 entries in the High Roller now with 108 players still listed in action on the board though I expect the number of live bodies in the game is a bit less than that as I'm only seeing 11 tables in play right now.
19:13 (UTC-7)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Nearing $260k in Prizes Posted Sunday 18th August, 2024 at 18:07(UTC-7) by Lyle Bateman
The field is up to 132 entries in the High Roller now, just 20 entries away from matching May's total. That puts the prizes right now at just under $260k with entries open until the start of Level 13, which should be around 11 pm tonight. They'll bag at the end of 15 levels tonight and return to finish it out tomorrow. Below is a look at the remaining players in the Main Event, which is playing across the Sundance room from the High Roller, as well as a look at the High Roller field.
18:04 (UTC-7)
Start of Level 6 Blinds: 400/800 Ante: 800
First Break Posted Sunday 18th August, 2024 at 16:08(UTC-7) by Lyle Bateman
The High Roller game has played three levels and they are out for their first break of the day. There are 112 entries on the board for prizes of more than $220k and 9 levels left to enter the game today.
More than $200k in Prizes Posted Sunday 18th August, 2024 at 15:45(UTC-7) by Lyle Bateman
Level 3 is about half complete now with the field over 100 entries and prizes of $200,430. Entries are still open for most of the day so expect that number to grow. In May, this High Roller game got 151 entries, so this one looks like it could meet or beat May's numbers, though that remains to be seen as the day plays on. Among the players seated for the big game are Canada's 11th-best money winner and multiple ring/bracelet winner, Mike Leah, as well as Chris Clisbym Stepehen Dauphinais (who scored big in Vegas this summer with 3rd in the Milly), and Sheraz Nasir.
There are also quite a few players who have busted Day 2 of the Main and jumped across to High Roller action including Ryan Cairns, DJ Sharma, Chun Kwan, Greg 'Greg Goes All In' Liow, Homan Mohammadi, and Kris Steinbach.
15:39 (UTC-7)
Day 1 of Deerfoot Inn and Casino Started Level: 3 Blinds: 200/400 Ante: 400
Second to Last Ring Event this Series is the High Roller Posted Sunday 18th August, 2024 at 12:49(UTC-7) by Lyle Bateman
Event #15:
$2,200 High Roller ($1,965 + $235)
Date:
Aug 18, 2024, 2 pm
Blinds:
40 Minutes
Start Stack:
40,000
Late Reg:
12 Levels (~11 pm)
Day 1 Ends:
End of Level 15
The High Roller is the second to last ring event of the series. For $2,200, players will start the day with 40k in chips for 40-minute levels all tournament. They play 12 levels of poker with entries open on Day 1, putting the last chance to enter the game at about 11 pm Sunday evening. After entries close, they'll play three more levels before they bag up for the night to return for Monday's Day 2.
I will most likely be focused on the Main Event for most of the day, but these two games should be playing out in the same room so I should be able to have some eyes on the High Roller as well later in the day.
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.
and the table laughed.
on the turn and river were irrelevant and Charette hit the rail for 3rd. He's had a good series though, with this being his third top-three finish of the series, and completing his gold/silver/bronze collection.
flop and turn, and Charette check-called for 210 on the 
river. Charette had a five, but the kings for Parmar were good, though the flop slowed Parmar down a bit for value.
against pocket sixes. The board ran clean for the sixes and Charrette doubled into the lead.
against 
but Lefebvre flopped the world 
giving Charette a flush draw as well, but 
and Homan Mohammadi check-raised from the small blind to 425 over the bet from Damiel Lefebvre worth 120. Lefebvre called to the 
turn and Mohammadi shoved the covering stack. Lefebvre tank-folded his hand.
