0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0081 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/38/136/updates'
ORDER BY `views` DESC
0.0120 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/38/136/updates'
0.0005 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` = '38'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '38'
0.0285 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0080 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '136'
AND `published` = 1
0.0325 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0074 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '139'
AND `published` = 1
0.0081 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '136'
ORDER BY `busted` ASC, `current_chips` DESC
0.0095 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` = '136'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6008'
ORDER BY `chip_change` DESC, `busted` ASC
0.0118 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6007'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6004'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6003'
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` = '6006'
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` = '6002'
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` = '6001'
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` = '6005'
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` = '5999'
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` = '5998'
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` = '6000'
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` = '5997'
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` = '5995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5993'
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` = '5992'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5996'
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` = '5991'
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` = '5990'
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` = '5989'
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` = '5988'
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` = '5987'
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` = '5986'
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` = '5985'
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` = '5984'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5983'
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` = '5982'
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` = '5981'
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` = '5980'
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` = '5978'
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` = '5977'
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` = '5976'
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` = '5974'
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` = '5973'
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` = '5972'
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` = '5971'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5970'
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` = '5969'
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` = '5968'
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` = '5967'
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` = '5965'
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` = '5966'
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` = '5964'
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` = '5963'
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` = '5962'
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` = '5961'
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` = '5960'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5959'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5957'
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` = '5958'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5956'
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` = '5954'
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` = '5949'
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` = '5953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5950'
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` = '5945'
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` = '5939'
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` = '5936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5937'
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` = '5935'
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` = '5926'
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` = '5924'
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` = '5920'
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` = '5917'
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` = '5919'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5911'
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` = '5905'
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` = '5900'
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` = '5899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5890'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5872'
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` = '5865'
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` = '5862'
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` = '5861'
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` = '5858'
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` = '5853'
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` = '5852'
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` = '5842'
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` = '5831'
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` = '5840'
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` = '5816'
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` = '5820'
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` = '5813'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '136'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 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` = '136'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '6008'
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` = '6007'
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` = '6004'
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` = '6003'
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` = '6006'
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` = '6002'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6001'
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` = '6005'
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` = '5999'
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` = '5998'
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` = '6000'
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` = '5997'
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` = '5995'
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` = '5994'
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` = '5993'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5992'
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` = '5996'
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` = '5991'
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` = '5990'
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` = '5989'
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` = '5988'
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` = '5987'
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` = '5986'
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` = '5985'
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` = '5984'
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` = '5983'
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` = '5982'
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` = '5981'
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` = '5980'
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` = '5978'
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` = '5977'
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` = '5976'
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` = '5974'
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` = '5973'
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` = '5972'
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` = '5971'
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` = '5970'
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` = '5969'
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` = '5968'
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` = '5967'
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` = '5965'
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` = '5966'
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` = '5964'
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` = '5963'
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` = '5962'
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` = '5961'
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` = '5960'
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` = '5959'
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` = '5957'
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` = '5958'
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` = '5956'
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` = '5954'
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` = '5949'
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` = '5953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5950'
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` = '5945'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5939'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5936'
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` = '5937'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5935'
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` = '5926'
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` = '5924'
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` = '5920'
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` = '5917'
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` = '5919'
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` = '5911'
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` = '5905'
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` = '5900'
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` = '5899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5890'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5883'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5872'
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` = '5865'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5862'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5861'
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` = '5858'
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` = '5853'
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` = '5852'
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` = '5842'
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` = '5831'
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` = '5840'
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` = '5816'
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` = '5820'
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` = '5813'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '139'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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
Ελληνικά
Русский
WSOPC Tallinn
Event #11: €3,000 No-Limit Hold'em 6 Handed
Live Reporting - Day 2
Elias Suhonen Leads Event #11: €3,000 NLH Final Table Posted Sunday 24th September, 2023 at 00:46(UTC+0) by Lina Olofsson
When the registration closed here in 2023 WSOPC Tallinn in the 11th Ring Event this €3,000 buy-in tournament had a whooping 97 entries. This made a total prize pool of €260,736 up for grabs and €78,280 for the winner.
As the tournament passed midnight after 12 hours of play the bubble burst making the last eleven players still in the field at least a €6,400 payday. It would take another hour and a half before the tournament was down to the final seven at the final table. As Yi-Zhan Peng was eliminated in eighth place (€8,850) the tournament clock stopped at level 21 as the tournament continues at noon tomorrow Sunday to crown yet another winner of the luxurious golden WSOPC ring.
The Finnish player Elias Suhonen leads the final seven with almost one million in chips before Estonian home player Markku Koplimaa is right behind.
Final table chip count:
Place
Name
Country
Chips
1
Elias Suhonen
Finland
990,000
2
Markku Koplimaa
Estonia
965,000
4
Roope Tarmi
Finland
875,000
5
Tommi Lankinen
Finland
805,000
6
Deividas Butnoras
Lithuania
375,000
7
Ilya Nikiforov
Estonia
120,000
Final Table Seat draw:
Seat
Name
Country
Chips
1
Elias Suhonen
Finland
990,000
2
Markku Koplimaa
Estonia
965,000
4
Tommi Lankinen
Finland
805,000
5
Roope Tarmi
Finland
875,000
6
Deividas Butnoras
Lithuania
375,000
7
Ilya Nikiforov
Estonia
120,000
Final Table Payouts
The final seven players each secured a minimum of €10,750 on Sunday as the play resumes at noon.
Check out the payouts below:
1
€78,280
2
€50,450
3
€34,550
4
€25,050
5
€18,450
6
€14,000
7
€10,750
End of Day 1 Chip Counts Posted Saturday 23rd September, 2023 at 23:51(UTC+0) by Frank Visser
Player
Chips
Progress
Elias Suhonen
990,000
422,000
Markku Koplimaa
965,000
390,000
Roope Tarmi
875,000
90,000
Tommi Lankinen
805,000
325,000
Mauri Dorbek
720,000
195,000
Deividas Butnoras
375,000
280,000
Ilya Nikiforov
120,000
70,000
Yi-Zhan Peng Eliminated in 8th Place (€8,850) Posted Saturday 23rd September, 2023 at 23:44(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 7/97
Mauri Dorbek opened from the cutoff and Yi-Zhan Peng jammed his stack of 225,000 in the middle from the small blind. Dorbek asked for a count and called once he received the correct number from the dealer to put Peng at risk.
Yi-Zhan Peng: Mauri Dorbek:
Dorbek had Peng drawing dead on the turn when emerged from the deck. The river would be the final card dealt on Day 1 of Event #11, as the remaining seven players bagged and tagged to come back tomorrow for Day 2.
Stay tuned for a recap of the day and exact chip counts of the final seven players.
Player
Chips
Progress
Mauri Dorbek
720,000
340,000
Yi-Zhan Peng
0
0
Sebastian Wahl Eliminated in 9th Place (€7,556) Posted Saturday 23rd September, 2023 at 23:40(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 8/97
Sebastian Wahl jammed in his last chips from the button and was looked up by Mauri Dorbek in the big blind.
Sebastian Wahl: Mauri Dorbek:
No ten appeared for Wahl on the board, and the river remained free of chop outs as well. He was eliminated in 9th place and the field now needs one more elimination in order for the day to end.
Player
Chips
Progress
Mauri Dorbek
475,000
195,000
Sebastian Wahl
0
0
23:39 (UTC+0)
Start of Level 21 Blinds: 10,000/25,000 Ante: 25,000
A Small Relief for Those Who are Left Posted Saturday 23rd September, 2023 at 23:27(UTC+0) by Frank Visser
The nine remaining players are sent on a short 15-minute break to recollect their thoughts after the gruelling bubble phase.
Touko Berndtson Eliminated in 10th Place (€6,400) Posted Saturday 23rd September, 2023 at 23:26(UTC+0) by Frank Visser
Level 20: 10,000/20,000 (20,000) Entries: 9/97
Elias Suhonen raised to 40,000 from under the gun and received a call from Yi-Zhan Peng on the button. Touko Berndtson then three-bet all-in to 90,000 chips and received a four-bet from Suhonen, which would also put Peng all-in.
Peng, however, decided to fold, and the other two players shared a showdown.
Touko Berndtson: Elias Suhonen:
Berndtson needed a lot of help, but it did not arrive on the board. Suhonen's eights held up and eliminated Berndtson in tenth place.
Player
Chips
Progress
Elias Suhonen
1,100,000
662,000
Yi-Zhan Peng
120,000
230,000
Touko Berndtson
0
0
Juha Helppi Eliminated in 11th Place (€6,400) Posted Saturday 23rd September, 2023 at 23:24(UTC+0) by Lina Olofsson
Level 20: 10,000/20,000 (20,000) Entries: 10/97
Juha Helppi was one of the short stacks as they finally had reached the money in this tournament. But his journey would come to an end in a classic coin flip on the feature table against Roope Tarmi after Tarmi raised it up to 40K and Helppi pushed his 210K over the line and was called.
Helppi: Tarmi:
The board ran out and that was it for Juha Helppi who got €6,400 for his 11th place finish in this tournament.
Player
Chips
Progress
Juha Helppi
0
0
The Bubble Doubles Continue with Dorbek Posted Saturday 23rd September, 2023 at 23:18(UTC+0) by Frank Visser
Level 20: 10,000/20,000 (20,000) Entries: 12/97
Big stack Elias Suhonen made a raise to 260,000 when it folded to him in the small blind, and Mauri Dorbek made the call in the big blind for 160,000.
Mauri Dorbek: Elias Suhonen:
"I have a great suck-out hand," claimed Suhonen. However, this time the best hand stayed in the lead on the board, securing yet another double-up on the bubble.
Player
Chips
Progress
Elias Suhonen
750,000
312,000
Mauri Dorbek
380,000
100,000
Nikiforov Causes Triple Double-Up Posted Saturday 23rd September, 2023 at 23:02(UTC+0) by Frank Visser
Level 20: 10,000/20,000 (20,000) Entries: 12/97
Yi-Zhan Peng raised to 90,000 from under the gun and the action folded the short-stacked Ilya Nikiforov called all-in for less from the big blind.
Ilya Nikiforov: Yi-Zhan Peng:
The board brought many outs for Peng on , but the remained clean for Nikiforov, resulting in the third straight double-up on the bubble of the €3,0000 No Limit Hold'em.
Player
Chips
Progress
Yi-Zhan Peng
275,000
141,000
Ilya Nikiforov
190,000
41,000
22:52 (UTC+0)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
Wahl Doubles Up in His Turn Posted Saturday 23rd September, 2023 at 22:50(UTC+0) by Frank Visser
Level 19: 10,000/15,000 (15,000) Entries: 12/97
The action folded to Yi-Zhan Peng on the button, who made the minimum raise to 30,000. Sebastian Wahl only had 55,000 left in the big blind, and put them all in. Peng made the call and another showdown was ordered.
Sebastian Wahl: Yi-Zhan Peng:
Neither player paired their hole cards on the runout, and Wahl's ace kicker won him an important double-up as the bubble continues in Event #11.
Player
Chips
Progress
Yi-Zhan Peng
350,000
66,000
Sebastian Wahl
135,000
373,000
Berndtson Survives the First All-In of the Bubble Posted Saturday 23rd September, 2023 at 22:45(UTC+0) by Frank Visser
Level 19: 10,000/15,000 (15,000) Entries: 12/97
Touko Berndtson jammed all-in from the hijack for his final 110,000 and got looked up by Sebastian Wahl in the cutoff.
Touko Berndtson: Sebastian Wahl:
It was a flip to burst the bubble, but Berndtson made a full house on and faded the outs for a better full house on the river, doubling up instead.
Player
Chips
Progress
Touko Berndtson
250,000
129,000
Sebastian Wahl
85,000
423,000
Final Two Tables Seat Draw Posted Saturday 23rd September, 2023 at 22:09(UTC+0) by Frank Visser
Table
Seat
Player
Country
Chip Count
1
1
Juha Helppi
Finland
250,000
1
2
Paulius Vaitiekunas
Lithuania
275,000
1
3
Markku Koplimaa
Estonia
575,000
1
4
Tommi Lankinen
Finland
480,000
1
5
Deividas Butnoras
Lithuania
655,000
1
6
Roope Tarmi
Finland
785,000
2
1
Ilya Nikiforov
Estonia
149,000
2
2
Yi-Zhan Peng
Taiwan
416,000
2
3
Touko Berndtson
Finland
121,000
2
4
Sebastian Wahl
Finland
296,000
2
5
Elias Suhonen
Finland
424,000
2
6
Mauri Dorbek
Estonia
280,000
Player
Chips
Progress
Roope Tarmi
785,000
115,000
Deividas Butnoras
655,000
276,000
Markku Koplimaa
575,000
370,000
Tommi Lankinen
480,000
123,000
Sebastian Wahl
424,000
212,000
Elias Suhonen
424,000
14,000
Yi-Zhan Peng
416,000
36,000
Sebastian Wahl
296,000
84,000
Mauri Dorbek
280,000
2,000
Paulius Vaitiekunas
275,000
15,000
Juha Helppi
250,000
104,000
Ilya Nikiforov
149,000
1,000
Touko Berndtson
121,000
17,000
Live Reporting Now on Delay Posted Saturday 23rd September, 2023 at 22:01(UTC+0) by Frank Visser
In order to accommodate the viewers of the stream, the live report will now operate on a 30-minute delay.
Ahola Last to Miss Final Two Tables Posted Saturday 23rd September, 2023 at 21:54(UTC+0) by Frank Visser
Level 19: 10,000/15,000 (15,000) Entries: 12/97
Raimo Ahola, being left short-stacked after the previous confrontation, got all of his remaining chips in against his nemesis Roope Tarmi.
Raimo Ahola: Roope Tarmi:
Ahola had a slight lead, but it disappeared on the flop. Ahola pleaded for an ace, but none came on the runout, and he was eliminated in 13th position, creating two final tables of 12 players, of which 11 will get paid.
Player
Chips
Progress
Roope Tarmi
900,000
126,000
Raimo Ahola
0
0
Aleksi Naski Eliminated from the Feature Table Posted Saturday 23rd September, 2023 at 21:51(UTC+0) by Lina Olofsson
Level 19: 10,000/15,000 (15,000) Entries: 14/97
With 284,000 in his stack Finn Elias Suhonen raised it up to 36,000 over at the feature table and his fellow countrymen Aleksi Naski tanked for a while and decided to push his 287,000 over the line. Suhonen didn't need much time to make the call.
Naski: Suhonen:
The board ran out and the ten as a kicker held up for Suhonen eliminating Aleksi Naski in 14th place.
Player
Chips
Progress
Aleksi Naski
0
0
Tarmi Wins Huge Flip, Naski No Longer Among the Field Posted Saturday 23rd September, 2023 at 21:50(UTC+0) by Frank Visser
Level 18: 10,000/15,000 (15,000) Entries: 13/97
Roope Tarmi (pictured) and Raimo Ahola once again clashed in a big preflop confrontation. This time, Tarmi had raised to 30,000 from the cutoff and Ahola responded with a three-bet to 78,000.
Tarmi then four-bet all-in for 367,000 chips and sent Ahola deep into the tank. After a count of his opponent's chips as well as his own, he ultimately made the call, putting Tarmi at risk.
Roope Tarmi: Raimo Ahola:
It was a huge flip, and it would be decided in Tarmi's favor when he made trips on , despite Ahola's attempt to yell a jack into existence.
Meanwhile, Aleksi Naski was eliminated from the feature table.
Player
Chips
Progress
Roope Tarmi
774,000
431,000
Raimo Ahola
110,000
540,000
Aleksi Naski
0
0
21:35 (UTC+0)
Start of Level 19 Blinds: 10,000/15,000 Ante: 15,000
Berndtson Secures a Much-Needed Double-Up Posted Saturday 23rd September, 2023 at 21:35(UTC+0) by Frank Visser
Level 18: 6,000/12,000 (12,000) Entries: 14/97
Touko Berndtson was down to just three big blinds, and he committed them from the cutoff. Ilya Nikiforov was sitting on the button and made the call, while the blinds got out of the way.
Touko Berndtson: Ilya Nikiforov:
It was looking dire for Berndtson, but the flop gave him a flush draw and sprung some hope in him. The turn completed his flush and secured the pot, making the river a meaningless byproduct.
Player
Chips
Progress
Ilya Nikiforov
150,000
64,000
Touko Berndtson
104,000
127,000
Vaitiekunas Doubles Through Helppi Posted Saturday 23rd September, 2023 at 21:25(UTC+0) by Frank Visser
Level 18: 6,000/12,000 (12,000) Entries: 14/97
Paulius Vaitiekunas and Juha Helppi got their chips in preflop in a blind-on-blind encounter, with Vaitiekunas' 139,000 chips being at risk.
Paulius Vaitiekunas: Juha Helppi:
Vaitiekunas had the dominating hand, and he would secure the double-up when the board ran out , leaving Helppi now short himself.
Player
Chips
Progress
Paulius Vaitiekunas
290,000
102,000
Juha Helppi
146,000
134,000
Dorbek's River Shove Torments Helppi Posted Saturday 23rd September, 2023 at 21:19(UTC+0) by Frank Visser
Level 18: 6,000/12,000 (12,000) Entries: 14/97
Juha Helppi and Mauri Dorbek were heads-up in a pot worth 150,000 chips. The completed board of lay in front of the players and Helppi checked to Dorbek from the big blind.
Dorber, sitting in the under the gun position, then went all-in for 128,000. Helppi had a tough time thinking over his decision, but ultimately chose to fold his hand and award his opponent the pot.
Player
Chips
Progress
Juha Helppi
280,000
156,000
Mauri Dorbek
278,000
89,000
21:07 (UTC+0)
Start of Level 18 Blinds: 6,000/12,000 Ante: 12,000
Ahola's Magic Number Nets Him Another Pot Posted Saturday 23rd September, 2023 at 21:07(UTC+0) by Frank Visser
Level 17: 5,000/10,000 (10,000) Entries: 14/97
Roope Tarmi and Raimo Ahola tangled again when the former raised to 20,000 from under the gun and the latter three-bet to 70,000 from the cutoff. Tarmi made the call and the pair saw a flop of appear.
Tarmi checked to Ahola, who bet out 38,000. Tarmi then made the call before both players checked through the turn.
On the river, Tarmi checked once more and Ahola gleefully announced a bet of 69,000. Tarmi let out a chuckle before relinquishing his hand and the pot. "Gentleman" Ahola then tabled for flopped top pair.
Player
Chips
Progress
Raimo Ahola
650,000
60,000
Roope Tarmi
343,000
182,000
Ahola Shows the Bluff Posted Saturday 23rd September, 2023 at 20:54(UTC+0) by Frank Visser
Level 17: 5,000/10,000 (10,000) Entries: 15/97
Raimo Ahola raised and faced a 58,000 three-bet from Sebastian Wahl. Ahola then promptly four-bet jammed his stack in the middle, covering Wahl's remaining 212,000 chips.
Wahl thought it over for a bit before letting his hand go, only to get shown the by Ahola.
"It was suited!" Ahola defended himself.
Meanwhile, Kristaps Renga joined the casualties as the bubble of Event #11 draws closer.
Player
Chips
Progress
Raimo Ahola
590,000
60,000
Sebastian Wahl
212,000
74,000
Kristaps Renga
0
0
Tarmi Gets Maximum Value Posted Saturday 23rd September, 2023 at 20:47(UTC+0) by Frank Visser
Level 17: 5,000/10,000 (10,000) Entries: 17/97
Raimo Ahola raised to 20,000 from under the gun and Roope Tarmi defended his big blind. The flop then checked through before the turn saw Tarmi bet 37,000.
Ahola made the call, but as the river completed the board he lamented his decision, claiming that he thought it was only 17,000.
Both players then checked thereafter, with Tarmi's being good at showdown, even though Ahola checked his cards several times over in order to find something better.
Player
Chips
Progress
Raimo Ahola
530,000
27,000
Roope Tarmi
525,000
109,000
20:35 (UTC+0)
Start of Level 17 Blinds: 5,000/10,000 Ante: 10,000
A Small Break Posted Saturday 23rd September, 2023 at 20:24(UTC+0) by Frank Visser
The remaining players have been sent on a small 15-minute break.
Parkkinen Doubles as Onoufriou Busts Posted Saturday 23rd September, 2023 at 20:23(UTC+0) by Frank Visser
Roope Tarmi raised to 16,000 from under the gun and the action folded to Seppo Parkkinen in the big blind, who jammed all in for 73,000.
Tarmi gave it a quick think before complying with a call, and the cards went on their backs.
Seppo Parkkinen: Roope Tarmi:
Parkkinen was rooting for a royal flush, but it became impossible on the flop. The turn provided him with a grim outlook, but the river saved him and kept him alive in the tournament, doubling him up in the meantime.
Before that, Antonius Onoufriou was the first to be eliminated from the final three tables in an unseen hand.
Player
Chips
Progress
Roope Tarmi
416,000
137,000
Seppo Parkkinen
158,000
68,000
Antonios Onoufriou
0
0
Final Three Table Redraw Posted Saturday 23rd September, 2023 at 20:05(UTC+0) by Frank Visser
Table
Seat
Player
Country
Chip Count
1
1
Elias Suhonen
Finland
438,000
1
2
Joni Jouhkimainen
Finland
550,000
1
3
Tommi Lankinen
Finland
357,000
1
4
Markku Koplimaa
Estonia
205,000
1
5
Aleksi Naski
Finland
196,000
1
6
Kristaps Renga
Latvia
94,000
2
1
Raimo Ahola
Finland
503,000
2
2
Sebastian Wahl
Finland
286,000
2
3
Deividas Butnoras
Lithuania
379,000
2
4
Antonios Onoufriou
Cyprus
120,000
2
5
Seppo Parkkinen
Finland
90,000
2
6
Roope Tarmi
Finland
279,000
3
1
Touko Berndtson
Finland
231,000
3
2
Yi-Zhan Peng
Taiwan
380,000
3
3
Ilya Nikiforov
Estonia
214,000
3
4
Paulius Vaitiekunas
Lithuania
188,000
3
5
Juha Helppi
Finland
124,000
3
6
Kristjan Dorbek
Estonia
189,000
The Dinner at The Able Butcher Posted Saturday 23rd September, 2023 at 19:44(UTC+0) by Lina Olofsson
Here are some pictures from the dinner break as our players was treated to a dinner up at The Able Butcher by the tournament organization.
You'll find all of today's pictures in the Gallery above by our photographers Tambert and Elena Kask. Enjoy!
Final Three Tables Posted Saturday 23rd September, 2023 at 19:43(UTC+0) by Frank Visser
Eighteen players now remain in Ring Event #11, which means the final three tables of this six-max tournament have been reached.
19:36 (UTC+0)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
Peng's Run Continues, Busts Mikaliunas Posted Saturday 23rd September, 2023 at 19:31(UTC+0) by Frank Visser
Level 15: 3,000/6,000 (6,000) Entries: 21/97
Paulius Mikaliunas open-jammed for his last 34,000 chips from under the gun. Yi-Zhan Peng was sitting next to him and isolated the player with a small three-bet, forcing the other four players at the table out of the pot. The two players then tabled their cards and a flip was revealed.
Paulius Mikaliunas: Yi-Zhan Peng:
Neither over Mikaliunas' overcards appeared on the runout and Peng's pocket fours held on to secure the victory in another pot.
Player
Chips
Progress
Yi-Zhan Peng
319,000
49,000
Paulius Mikaliunas
0
0
Peng Forces Renga Into the Tank Posted Saturday 23rd September, 2023 at 19:26(UTC+0) by Frank Visser
Level 15: 3,000/6,000 (6,000) Entries: 23/97
Yi-Zhan Peng (pictured) opened for 15,000 from the cutoff and Kristaps Renga defended the big blind. The flop of then saw Renga check-call a 13,000 continuation-bet from Peng before both players checked the turn.
On the river, Renga led out for 30,000 chips, only to be faced with an all-in raise from Peng, covering him by a little bit.
Renga went deep into the tank and could only let his hand go once the clock had been called on him by another player on the table, ultimately surrendering the pot to Peng.
Player
Chips
Progress
Yi-Zhan Peng
270,000
215,000
Kristaps Renga
83,000
43,000
19:06 (UTC+0)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
The Ladies Like Koplimaa Posted Saturday 23rd September, 2023 at 19:05(UTC+0) by Alaxandar Georgiev
Level 14: 2,000/5,000 (5,000) Entries: 24/97
Markku Koplimaa raised to 10,000 from the cutoff and got three-bet from Paulius Mikaliunas followed by an all-in for 110,000 chips from Koplimaa, a snap-call from the Lithuanian and we went to showdown.
Markku Koplimaa: Paulius Mikaliunas:
A lady is all that Koplimaa needed and he got on on the flop. Now he needed to hold it off, the turn and river helped him do that and get another double-up.
Paulius Mikaliunas was left with about 40,000 chips after he lost the hand.
Player
Chips
Progress
Markku Koplimaa
225,000
137,000
Paulius Mikaliunas
40,000
175,000
Vaitiekunas Leads By Example Posted Saturday 23rd September, 2023 at 19:05(UTC+0) by Frank Visser
Level 14: 2,000/5,000 (5,000) Entries: 25/97
Markku Koplimaa open-raised to 11,000 from the button and Paulius Vaitiekunas called from the big blind.
Vaitiekunas then led out on the flop for a size of 10,000 and Koplimaa made the call. A bigger bet of 34,000 followed from Vaitiekunas on the turn. He again received a call from his opponent.
The river then completed the board and Vaitiekunas completed the triple barrel by betting 41,000 chips, leaving himself only a single big blind behind. This visibly distraught Koplimaa, who ultimately elected to let his hand go and forfeit the pot to Vaitiekunas.
Player
Chips
Progress
Paulius Vaitiekunas
158,000
108,000
Markku Koplimaa
100,000
12,000
Jouhkimainen Sniffs Out a Bluff Posted Saturday 23rd September, 2023 at 18:52(UTC+0) by Frank Visser
Level 14: 2,000/5,000 (5,000) Entries: 25/97
Joni Jouhkimainen raised to 11,000 from the cutoff and the action folded to Riku Koivurinne in the big blind. He then elected for a three-bet to 38,000.
Jouhkimainen mulled over his options for a while before putting a big stack of T-5,000 chips in the middle, effectively putting his opponent all-in.
Koivurinne took one last glance at his cards before quickly folding, surrendering the pot to Jouhkimainen.
Player
Chips
Progress
Joni Jouhkimainen
690,000
180,000
Riku Koivurinne
101,000
92,000
Payouts Announced Posted Saturday 23rd September, 2023 at 18:44(UTC+0) by Frank Visser
The payouts for Ring Event #11 are announced. 11 players will reach the money, with a minimum cash of €6,400 for places 11 and 10. First place will receive €78,280 and of course the coveted WSOPC ring.
Place
Prize
1
#,##0","3":1}">€78,280
2
€50,450
3
€34,550
4
€25,050
5
€18,450
6
€14,000
7
€10,750
8
€8,850
9
€7,556
10
€6,400
11
€6,400
18:40 (UTC+0)
Start of Level 14 Blinds: 2,000/5,000 Ante: 5,000
Suutari Has Been Gutted Posted Saturday 23rd September, 2023 at 18:35(UTC+0) by Alaxandar Georgiev
Level 13: 2,000/4,000 (4,000) Entries: 28/97
Joni Jouhkimainen raised from the cutoff and got the call from Juho Suutari on the big blind. Suutari checked the flop and our chip leader bet 7,000 into the pot which Suutari called.
The turn was checked by both players. All of the action happened on the river when Suutari bet first for 21,000 and Jouhkimainen raised 200,000 making Suutari play for all of his remaining 88,000 behind.
Suutari took his time to think and called.
Juho Suutari: Joni Jouhkimainen:
Another big one goes to the chip leader as the jack on the river completed his gutshot straight draw. He scooped the hand and is now playing with a massive 500,000 stack with 28 players remaining.
Player
Chips
Progress
Joni Jouhkimainen
510,000
125,000
Juho Suutari
0
0
Naski Not Out Yet Posted Saturday 23rd September, 2023 at 18:33(UTC+0) by Frank Visser
Level 13: 2,000/4,000 (4,000) Entries: 32/97
Juho Suutari raised to 8,000 from the cutoff and the short-stacked Aleksi Naski defended his big blind.
On a flop of , Naski check-raised a 4,000 beto from Suutari to an all-in of 16,000, getting a quick fold in return and thus chipping up and staying alive in the tournament.
Player
Chips
Progress
Juho Suutari
129,000
79,000
Aleksi Naski
47,000
3,000
Important Double Up For Koplimaa Posted Saturday 23rd September, 2023 at 18:24(UTC+0) by Alaxandar Georgiev
Level 13: 2,000/4,000 (4,000) Entries: 34/97
Yi-Zhan Peng raised from under the gun to 8,000 and Markku Koplimaa jammed it all in for his remaining 42,000 chips, Peng had a bit of time to think and made the call.
Yi-Zhan Peng: Markku Koplimaa:
The flop gave Koplimaa a much-needed pair and he managed to hold it through the turn and the river doubling up to 88,000 chips.
Player
Chips
Progress
Markku Koplimaa
88,000
58,000
Yi-Zhan Peng
55,000
23,000
Ahola Is a Gentleman Posted Saturday 23rd September, 2023 at 18:24(UTC+0) by Frank Visser
Level 13: 2,000/4,000 (4,000) Entries: 34/97
Raimo Ahola raised to 8,000 from the hijack and Mantas Bagocius was the only caller on the button. The pair then saw a flop of , on which Ahola continued for another 8,000 chips. Bagocius made the call and the two saw a turn of being dealt.
After asking how much his opponent played, Ahola stated that his "mathematics are very good" before firing out a big bet of 27,000.
"I like that," Ahola remarked when Bagocius put in the calling chips.
The river then appeared and Ahola swiftly shoved all in, covering Bagocius' 97,000 remaining chips. Bagocius thought it over for a bit but ultimately folded his hand.
"Because I'm a gentleman," Ahola explained before tabling his for the world to see.
Player
Chips
Progress
Raimo Ahola
335,000
230,000
Mantas Bagocius
97,000
67,000
17:59 (UTC+0)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
Notable Stacks from the Break Posted Saturday 23rd September, 2023 at 17:58(UTC+0) by Lina Olofsson
We've spotted some notable stacks around the tables as the players are now returning to their seats after a nice dinner up at The Able Butcher.
Player
Chips
Progress
Joni Jouhkimainen
385,000
5,000
Tapio Aaltonen
287,000
90,000
Seppo Parkinen
240,000
190,000
Paulius Mikaliunas
215,000
165,000
Riku Koivurinne
193,000
17,000
Mauri Dorbek
180,000
63,000
Garijs Rozkalns
173,000
17,000
On Air! Posted Saturday 23rd September, 2023 at 17:54(UTC+0) by Lina Olofsson
It's ten minutes left on the dinner break for the remaining 32 players in the field and when they come back two of the tables will go on air as they're right now moved to the feature and the secondary feature table outside the grand ballroom.
On the feature table, you will be able to see players like Juha Helppi, Roope Tarmi, and Antonius Onoufriou. Watch it on our LIVE STREAM here from Tallinn with a 30-minute delay starting at 20.30 local time.
Players Moving Up to The Able Butcher Posted Saturday 23rd September, 2023 at 17:24(UTC+0) by Lina Olofsson
As they've reached the dinner break in the €3,000 6-max tournament the TD Teresa Nousiainen just welcomed the remaining 31 players in the field up to The Able Butcher on the second floor at Hilton Park.
"We always do this when we have a €3K or a €5K here in Tallinn as a treat for the players", Teresa told us. A very nice gesture by the fantastic tournament organizers here in the WSOP Circuit and the players are in for a real treat as this is a very fancy restaurant with amazing food.
While they get to enjoy a nice meal your fellow reporters are going to make a chip count as soon as they are done with the color-ups of all the blue chips (the 500's).
Pihela (Sr.) Calls Two All-Ins Posted Saturday 23rd September, 2023 at 17:04(UTC+0) by Alaxandar Georgiev
Level 12: 1,500/3,000 (3,000) Entries: 36/93
Igor Pihela (Sr.) opened the pot, Jyri Merivirta and Joni Jouhkimainen called from the small and big blind respectively.
The flop got a lot of action after Merivirta jammed it all in for 60,000 chips, Jouhkimainen re-shoved for 140,000 and Pihela (Sr.) had exactly that much left behind and called the two all-ins.
Jyri Merivirta: Joni Jouhkimainen: Igor Pihela (Sr.):
Both Merivirta and Jouhkimainen flopped top pair with very good kickers behind while Pihela had a hand that could crush both of them with his flush draw and gutshot to a straight.
The turn was and Pihela (Sr.) made his flush, Jouhkimainen needed another club to win it all.
The river was the which got the Finn a better flush winning him a massive pot and busting out both players.
Player
Chips
Progress
Joni Jouhkimainen
380,000
290,000
Igor Pihela Sr.
0
0
Jyri Merivirta
0
0
Pyysing Is Used to Bubble Posted Saturday 23rd September, 2023 at 16:53(UTC+0) by Lina Olofsson
They are down to 37 players left in the €3,000 6-max as there are ten minutes before the dinner break and amongst today's notable names in the field we had a little talk with the well-renowned Finn Aki Pyysing.
Pyysing was the unlucky player who was eliminated in 16th place in yesterday's marathon tournament - the €660 PLO Hi/Lo which ended at 7.30 am this morning - with 15 spots getting paid.
"It wasn't my first and it won't be my last bubble", the experienced player commented when we stopped by his table where he sits with Igor Pihela Jr. among others. This is Pyysing's second bullet in today's tournament but we surely hope he won't bubble this one as the prize pool is up to €249,984.
Player
Chips
Progress
Aki Pyysing
142,000
92,000
Ahola Doubles Up With The Blades Posted Saturday 23rd September, 2023 at 16:29(UTC+0) by Alaxandar Georgiev
Level 12: 1,500/3,000 (3,000) Entries: 38/93
Markku Koplimaa opened the pot and got three-bet by Raimo Ahola, Koplimaa called from under the gun.
The flop and had a lot of action as Koplimaa was just calling Ahola's bets. The pot was already more than 100,000 and everything went in for Ahola on the river and Koplimaa called for 80,000 chips.
Markku Koplimaa: Raimo Ahola:
Ahola managed to win it all and get a full double-up with his pocket blades. Koplimaa was left with around 30,000 chips.
Player
Chips
Progress
Raimo Ahola
270,000
165,000
Markku Koplimaa
30,000
121,000
No Luck for Sweden in the 6-max Posted Saturday 23rd September, 2023 at 16:26(UTC+0) by Lina Olofsson
As earlier mentioned Erik Friberg said he wouldn't come back to Tallinn if busting out of this event and firing three bullets in the Main Event. It's sad to say that we might not see Friberg here in Tallinn again as he didn't manage to spin his stack (well, half of what he started with) up and get into the action as he was eliminated earlier.
His fellow countrymen and former Kings of Tallinn Champion Johan Karlsson didn't catch much luck after the second break of today either as he was eliminated a few minutes ago.
That leaves the hopes to Erik Howmark who's one of the nine final players in the Main Event who's playing the final tomorrow. If you haven't already jump into our coverage from that tournament too and catch up with all the action from day three.
No luck for Karlsson or Friberg in the €3,000 6-max
Player
Chips
Progress
Johan Karlsson
0
0
Erik Friberg
0
0
16:21 (UTC+0)
Start of Level 12 Blinds: 1,500/3,000 Ante: 3,000
The River Killer Posted Saturday 23rd September, 2023 at 16:19(UTC+0) by Alaxandar Georgiev
Level 11: 1,000/2,500 (2,500) Entries: 38/91
Deividas Butnoras called Ermo Kosk's all-in from the small blind for about 25,000 chips pre-flop.
Deividas Butnoras: Ermo Kosk:
The flop didn't look good for Kosk, since Butnoras managed to pair his king with both players pairing their six.
The on the turn was a great card for Kosk and he sat back in his chair only to witness the spike the river to improve Butnoras to a boat just before the dinner break.
Player
Chips
Progress
Deividas Butnoras
300,000
250,000
Ermo Kosk
0
0
Second, Third, or Fourth Times a Charm? Posted Saturday 23rd September, 2023 at 16:15(UTC+0) by Lina Olofsson
Even though this is the most expensive tournament during this festival here in Tallinn during the WSOP Circuit you could assume it wouldn't be as we've seen several players firing both a second, third, and fourth bullet after busting out.
The record holder as of Level 11 is Igor Pihela Sr. who fired a total amount of five bullets for €3,000 each. However, this bullet so far seems to have been a better one for the father of the two Estonian Pihelas in today's field. Igor Pihela Jr. was seen hitting the door during the last level but was soon found at the tables again building his new starting stack.
Juha Helppi is another player who hasn't been too lucky with his first bullets and just took his fourth chance in the tournament as he sat down with a fresh 50,000 in the starting stack. Mihails Morozovs hopes for a "third time's a charm" as he also took some early hits and now bought in three times.
Player
Chips
Progress
Igor Pihela Sr.
115,000
65,000
Igor Pihela Jr.
84,000
57,000
Juha Helppi
50,000
40,000
Mihails Morozovs
10,000
40,000
A Lot of Action in the Six Max Posted Saturday 23rd September, 2023 at 16:03(UTC+0) by Lina Olofsson
As they are on the 11th level in the €3,000 it's now only two more levels if anyone feels like joining the action in this 6-max tournament which now has an astonishing 87 entries.
We just received some more pictures from our brilliant photographer Elena Kask. All of them you'll find in the Gallery above but here are a few of them.
15:52 (UTC+0)
Start of Level 11 Blinds: 1,000/2,500 Ante: 2,500
Morozovs Eliminated By Ahola Posted Saturday 23rd September, 2023 at 15:50(UTC+0) by Alaxandar Georgiev
Level 10: 1,000/2,000 (2,000) Entries: 41/87
Mihails Morozovs jammed 27,000 from the button and got called by Raimo Ahola who lost a bit of his stack after the third break.
Mihails Morozovs: Raimo Ahola:
The flop wasn't the best for Morozovs as Ahola now had a flush draw and was way ahead. No luck for Morozovs on the turn and the river.
Player
Chips
Progress
Raimo Ahola
105,000
75,000
Mihails Morozovs
0
0
Will Mr Bean Bring Luck to Professional Motorcyclist Rozkalns? Posted Saturday 23rd September, 2023 at 15:45(UTC+0) by Lina Olofsson
As we walked by table number four we asked Garijs Rozkalns about his card protector and lucky charm. We asked if it was Mr Bean and Rozkalns smiled and said "Yes of course! He's the best" and showed us his leg where he had the best Mr Bean tattoo ever.
Garijs Rozkalns is not only a poker player, but he's also a professional motorcycle and car driver from Latvia where he's known under the nickname "Garix". He comes from a three generation of professional motorcyclists with his father and grandfather also being very successful at the speed tracks. We asked which of the two sports - superbike or poker - they started with the first and Rozkalns laughed and told us he's been driving motorcycles since the age of only four. And his two sons at the age of six and eight obviously also competes in the very same sport.
The Mr. Bean teddy bear in front of him is just the start. He told us about the tattoo on his leg which he also sees as his lucky charm. He actually did it just before one of the superbike tournaments he won over the years and underneath his nickname on the leg he has all of his winnings at the tracks.
But now this entertaining Latvian is here and has pulled up his sleeves in the tournament where we play for the big bucks as 84 players entered the field creating a prize pool of €225,792 so far. But as previously mentioned the registration closes at the end of the 12th level so there's still time if anyone wants to join the excitement here in this six-max actionfilled tournament.
Player
Chips
Progress
Garijs Rozkalns
190,000
100,000
15:24 (UTC+0)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Kicker Issues for Jouhkimainen Posted Saturday 23rd September, 2023 at 15:21(UTC+0) by Alaxandar Georgiev
Level 9: 1,000/1,500 (1,500) Entries: 45/78
Joni Jouhkimainen opened for 6,000 before Riku Koivurinne three-bet to 18,500 from the big blind. Jouhkimainen called to see the flop. Both players checked before Jouhkimainen bet 20,000 on the turn. Koivurinne called and the river came the which would make a straight for anyone who had a jack in their hand. Both players checked again and it went to a showdown.
Joni Jouhkimainen: Riku Koivurinne:
Both players had the same pair. Koivurinne's kicker was better and the dealer awarded him the pot.
Player
Chips
Progress
Riku Koivurinne
210,000
0
Joni Jouhkimainen
90,000
28,000
Chips During the Break Posted Saturday 23rd September, 2023 at 15:09(UTC+0) by Lina Olofsson
When the players went on a 20-minute-long break we found some notable stacks in the field of the remaining 46.
Player
Chips
Progress
Riku Koivurinne
210,000
160,000
Tapio Aaltonen
197,000
137,000
Ilya Nikiforov
162,000
44,000
Damian Siewert
155,000
105,000
Mantas Bogocius
152,000
77,000
Markku Koplimaa
151,000
101,000
Igor Yaroshevskyy
143,000
92,000
Kristaps Renga
126,000
12,000
Joni Jouhkimainen
118,000
38,000
Mauri Dorbek
117,000
37,000
Jan-Mikael Kesanen
106,000
16,000
Touko Berndtson
99,000
49,000
Johan Karlsson
97,000
47,000
Tommi Lankinen
96,000
46,000
Martin Sedlak
92,000
34,000
Sebastian Wahl
77,000
27,000
Ori Hasson
74,500
5,500
Igor Pihela Jr.
27,000
23,000
If Friberg Busts He Won't Return to Tallinn Posted Saturday 23rd September, 2023 at 15:01(UTC+0) by Lina Olofsson
We chatted with WSOP Main Event finalist Erik Friberg during the break. He had a rough start to this tournament and is down to 25,500 in his stack.
"If I bust this tournament I will never come back to Tallinn," Friberg said. "Either they are really good at bluffing or I played the best game of my life."
As the tournament started again with the blinds 1,000/1,500 with a big blind ante of 1,500 there's still the opportunity to buy into Event #11: €3,000 NLHE, which so far has attracted 75 entries in total.
Player
Chips
Progress
Erik Friberg
25,500
24,500
14:48 (UTC+0)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
Big Three-Way All In Posted Saturday 23rd September, 2023 at 14:33(UTC+0) by Alaxandar Georgiev
Level 8: 600/1,200 (1,200) Entries: 46/71
Max Avela opened for 2,500 from under the gun and was called by Jan-Mikael Kesanen from the cutoff. The action erupted soon after as Raimo Ahola three-bet jammed from the big blind.
Avela quickly called before Kesanen went into the tank and called as well.
Raimo Ahola: Max Avela: Jan-Mikael Kesanen:
Ahola screamed in excitement as his cards were live against two pocket pairs and appeared equally thrilled about connecting with the flop.
The turn improved him further to an unnecessary two-pair. The river bricked for both Kesanen and Avela for Ahola to win a massive pot.
Player
Chips
Progress
Raimo Ahola
180,000
130,000
Jan-Mikael Kesanen
90,000
10,000
Max Avela
2,300
47,700
Renga Tangles With Peng Posted Saturday 23rd September, 2023 at 14:16(UTC+0) by Alaxandar Georgiev
Level 8: 600/1,200 (1,200) Entries: 47/70
There was already 20,000 in the pot with the board after the turn when Kristaps Renga check-jammed a bet by Yi-Zhan Peng from 8,000 to 46,800.
Peng tanked before eventually finding a call.
Kristaps Renga: Yi-Zhan Peng:
The river completed the board for Renga to scoop the pot. Players headed on break after this hand.
Player
Chips
Progress
Kristaps Renga
114,000
64,000
Yi-Zhan Peng
78,000
28,000
14:03 (UTC+0)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Rozkalns Eliminates Sahiti Posted Saturday 23rd September, 2023 at 14:03(UTC+0) by Alaxandar Georgiev
Level 7: 500/1,000 (1,000) Entries: 48/68
Armend Sahiti jammed his last 15 blinds from under the gun and got called by Garijs Rozkalns (pictured below) on the big blind.
Armend Sahiti: {as] Garijs Rozkalns:
Sahiti sighed as he saw his opponent's hand, he needed some help but got exactly the opposite on the flop as Rozkalns already paired his King.
The turn was which meant Sahiti was drawing dead, the couldn't change that and Sahiti was eliminated from the tournament.
Player
Chips
Progress
Garijs Rozkalns
90,000
19,000
Armend Sahiti
0
0
Okada Cracks Hasson's Cowboys Posted Saturday 23rd September, 2023 at 13:55(UTC+0) by Alaxandar Georgiev
Level 7: 500/1000 (1000) Entries: 51/68
Chips went flying between Ken Okada and Ori Hasson preflop as Okada put all of his 17,000 chips in, followed by a call from Hasson.
Ken Okada: Ori Hasson :
Okada was behind and needed to hit a ten to survive on his second bullet. The dealer revealed the flop and he indeed banged a set on the flop.
The turn and the changed nothing for Hasson and Okada doubles his stack instead of hitting the rail.
Player
Chips
Progress
Ori Hasson
80,000
5,000
Ken Okada
34,000
16,000
Four-Three Good for Jouhkimainen Posted Saturday 23rd September, 2023 at 13:43(UTC+0) by Alaxandar Georgiev
Level 6: 400/800 (800) Entries: 50/63
Joni Jouhkimainen raised from under the gun and WSOP bracelet winner Erik Friberg called. before Tapio Aaltonen three-bet to 6,600. Jouhkimainen called and Friberg folded.
Both players checked the flop. Aaltonen checked the turn and Jouhkimainen threw a small bet of 2,000, which Aaltonen raised to 4,000 followed by a quick call.
The river was on which Aaltonen continued for 14,300 and Jouhkimainen snap-called.
Joni Jouhkimainen: Tapio Aaltonen:
Both players laughed about the hand between each other as Jouhkimainen scooped the pot.
Player
Chips
Progress
Joni Jouhkimainen
80,000
30,000
Tapio Aaltonen
60,000
30,000
Big Flip For Helppi Posted Saturday 23rd September, 2023 at 13:42(UTC+0) by Alaxandar Georgiev
Level 6: 400/800 (800) Entries: 52/62
Edgaras Gendvilis opened to 1,800 from under the gun and got three-bet to 5,200 by Juha Helppi (pictured below), shortly after the Latvian jammed all of his 41,000 chips in the middle and got called.
Edgaras Gendvilis: Juha Helppi:
A big flip for both players as Gendvilis was the one that needed to hit a pair. He didn't manage to get on the flop, neither on the turn, nor the river.
Finland's Helppi managed to scoop the pot with his ladies.
Player
Chips
Progress
Juha Helppi
90,000
40,000
Edgars Gendvilis
0
0
13:35 (UTC+0)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Pictures From Today Posted Saturday 23rd September, 2023 at 13:30(UTC+0) by Lina Olofsson
Here are some pictures from today's €3,000 No-Limit Hold'em ring event as the field has grown to 63 entries with 50 players remaining .
There are tons of familiar faces in the field for what promises to be an interesting tournament. They will play down to the final table of six before the day finishes and then the tournament will resume tomorrow until there's a winner to be crowned.
13:01 (UTC+0)
Start of Level 6 Blinds: 400/800 Ante: 800
Everyone Loves A Chop Pot Posted Saturday 23rd September, 2023 at 13:01(UTC+0) by Alaxandar Georgiev
Level 5: 300/600 (600) Entries: 52/60
WSOPC €1,100 NLH Winner Aleksei Smirnov got involved in a big hand against Igor Yaroshevskyy.
With 7,000 already in the middle, Smirnov checked on the flop followed by a 4,000 bet by the Ukrainian, which Smirnov called.
Big bet on the turn from Yaroshevskyy and Smirnov tanked and finally went all in - snap call from his opponent for 45,000 and both players revealed.
Aleksei Smirnov: Igor Yaroshevskyy:
Both players had the same hand and chopped up the pot in the end.
12:31 (UTC+0)
Start of Level 5 Blinds: 300/600 Ante: 600
Bigger Stacks at Break Posted Saturday 23rd September, 2023 at 12:23(UTC+0) by Alaxandar Georgiev
Check out some of the players that grew their stack during the first few levels down below.
Player
Chips
Progress
Ilya Nikiforov
118,000
68,000
Jan-Mikael Kesanen
100,000
50,000
Tapio Aaltonen
90,000
40,000
Ori Hasson
85,000
29,000
Mauri Dorbek
80,000
30,000
Mantas Bogocius
75,000
25,000
Kosk & Karttunen Chop it Up Posted Saturday 23rd September, 2023 at 12:11(UTC+0) by Alaxandar Georgiev
Level 4: 200/500 (500) Entries: 42/45
Mustafa Biz raised first to 1,100, Osku Karttunen and Ermo Kosk both called.
The flop was checked by Kosk and Biz. Karttunen bet 1,000 and Kosk quickly raised him to 3,000.
The turn was the which already completed some possible straights. Kosk bet 4,100 and Karttunen called.
Another dangerous river as the dealer put making it a straight on the board for both players. Kosk bet 6,000 and the Finn called.
Osku Karttunen: Ermo Kosk:
Both players flopped monsters but ended up splitting up the pot.
Players went on their first 20-minute break after the hand.
Player
Chips
Progress
Ermo Kosk
70,000
20,000
Osku Karttunen
48,000
2,000
Rozkalns Wins Four-Bet Pot Posted Saturday 23rd September, 2023 at 12:00(UTC+0) by Alaxandar Georgiev
Level 4: 200/500 (500) Entries: 42/45
Juha Helppi three-bet the open of Garijs Rozklans to 3,300 and Igor Yaroshevskyy and Tomi Arponen called. Rozkalns four-bet to 10,500 and Yaroshevskyy was the only one who called.
Both players checked it down to the river on the board.
Garijs Rozkalns: Igor Yaroshevskyy:
Rozkalns's pair of kings was good enough to take down an early pot.
Player
Chips
Progress
Garijs Rozkalns
71,000
21,000
Igor Yaroshevskyy
51,000
1,000
11:41 (UTC+0)
Start of Level 4 Blinds: 200/500 Ante: 500
Tough Spot For Sedlak Posted Saturday 23rd September, 2023 at 11:40(UTC+0) by Alaxandar Georgiev
Level 3: 200/400 (400) Entries: 36/39
Martin Sedlak opened the pot by raising to 1,000. Ori Hasson three-bet to 5,000 and Sedlak called.
Hasson bet 9,000 on the flop which Sedlak quickly called.
The turn came and Hasson jammed for 26,000. Sedlak tanked before he opted to fold his hand.
Player
Chips
Progress
Martin Sedlak
58,000
8,000
Ori Hasson
56,000
6,000
11:11 (UTC+0)
Start of Level 3 Blinds: 200/400 Ante: 400
Early Entries in the Field Posted Saturday 23rd September, 2023 at 11:09(UTC+0) by Alaxandar Georgiev
Check out some of the first players who registered for the €3,000 NLH event. Local legend Urmo Velvet, Igor Pihela Jr., WSOP bracelet winner Erik Friberg and two-time WSOP bracelet winner Juha Helppi are among the early entrants.
Player
Country
Armend Sahiti
Finland
Dalius Ulevicius
Lithuania
Garijs Rozkalns
Latvia
Ilya Nikiforov
Estonia
Jan-Mikael Kesanen
Finland
Joona Ranta-Nilkku
Finland
Juha Helppi
Finland
Kristaps Renga
Latvia
Mihails Morozovs
Latvia
Osku Karttunen
Finland
Tapio Aaltonen
Finland
Tomi Arponen
Finland
Yi Zhan Peng
Taiwan
Damian Jan Siewert
Poland
Ermo Kosk
Estonia
Mauri Dorbek
Estonia
Sebastian Wahl
Finland
Velvelt Urmo
Estonia
Jan-Mikael Kesanen
Finland
Christoffer Bering
Denmark
Mustafa Biz
Turkey
Roope Tarmi
Finland
Igor Pihela (Jr.)
Estonia
Jari Mahonen
Finland
Ori Hasson
Israel
Igor Yaroshevskyy
Ukraine
Antonios Onoufriou
Cyprus
10:40 (UTC+0)
Start of Level 2 Blinds: 100/300 Ante: 300
Welcome to Day 1 Of The €3,000 WSOPC NLH Posted Saturday 23rd September, 2023 at 10:11(UTC+0) by Alaxandar Georgiev
The biggest buy-in ring event in the two-day Event #10: €3,000 WSOPC Tallinn No-Limit Hold'em. Expect some big names in the field including Finnish poker legend Juha Helppi.
Players start the six-handed affair with 50,000 chips with blinds at 100/200 along with a 200 big blind ante and increase every 30 minutes. Players have plenty of opportunity to build a big stack as re-entries are available during the first 12 levels.
The OlyBet live reporting team will live report this event from start to finish with a feature table appearing later in the evening after the Main Event is down to just nine players.
10:10 (UTC+0)
Start of Level 1 Blinds: 100/200 Ante: 200
09:54 (UTC+0)
Day 1 of WSOPC Tallinn Started Level:Blinds: 0/0 Ante: 0
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.
emerged from the deck. The 
river would be the final card dealt on Day 1 of Event #11, as the remaining seven players bagged and tagged to come back tomorrow for Day 2.
board, and the 
river remained free of chop outs as well. He was eliminated in 9th place and the field now needs one more elimination in order for the day to end.
and that was it for Juha Helppi who got €6,400 for his 11th place finish in this tournament. 
board, securing yet another double-up on the bubble.
flop. Ahola pleaded for an ace, but none came on the 
completed his flush and secured the pot, making the 
lay in front of the players and Helppi checked to Dorbek from the big blind.
being good at showdown, even though Ahola checked his cards several times over in order to find something better.
turn and 
river doubling up to 88,000 chips.
