0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0068 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/132/updates'
ORDER BY `views` DESC
0.0007 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` = '33'
0.0006 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0294 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.0290 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1
0.0287 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0072 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '130'
AND `published` = 1
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1
0.0306 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0094 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '135'
AND `published` = 1
0.0392 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0094 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '138'
AND `published` = 1
0.0120 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '132'
ORDER BY `busted` ASC, `current_chips` DESC
0.0116 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` = '132'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0127 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5801'
ORDER BY `chip_change` DESC, `busted` ASC
0.0090 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5800'
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` = '5799'
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` = '5792'
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` = '5791'
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` = '5789'
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` = '5787'
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` = '5786'
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` = '5784'
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` = '5783'
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` = '5779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5778'
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` = '5775'
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` = '5773'
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` = '5772'
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` = '5767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5765'
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` = '5764'
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` = '5762'
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` = '5763'
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` = '5760'
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` = '5758'
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` = '5754'
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` = '5753'
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` = '5752'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5749'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5747'
ORDER BY `chip_change` DESC, `busted` ASC
0.0152 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5746'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5728'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0092 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5739'
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` = '5738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5733'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5731'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5726'
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` = '5725'
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` = '5724'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5723'
ORDER BY `chip_change` DESC, `busted` ASC
0.0273 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5720'
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` = '5719'
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` = '5714'
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` = '5711'
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` = '5710'
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` = '5712'
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` = '5703'
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` = '5701'
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` = '5699'
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` = '5704'
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` = '5695'
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` = '5696'
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` = '5693'
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` = '5691'
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` = '5689'
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` = '5688'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5687'
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` = '5685'
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` = '5684'
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` = '5680'
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` = '5677'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5675'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5671'
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` = '5668'
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` = '5664'
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` = '5661'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '132'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 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` = '132'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5801'
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` = '5800'
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` = '5799'
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` = '5792'
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` = '5791'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5789'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5787'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5784'
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` = '5783'
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` = '5779'
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` = '5778'
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` = '5775'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5773'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5772'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5767'
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` = '5765'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5764'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5762'
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` = '5763'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5760'
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` = '5758'
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` = '5754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5753'
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` = '5752'
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` = '5749'
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` = '5747'
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` = '5746'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5728'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5742'
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` = '5739'
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` = '5738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5733'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5730'
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` = '5731'
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` = '5726'
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` = '5725'
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` = '5724'
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` = '5722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5723'
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` = '5720'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5719'
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` = '5717'
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` = '5714'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5711'
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` = '5710'
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` = '5712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5703'
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` = '5701'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5699'
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` = '5704'
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` = '5695'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5696'
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` = '5693'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5691'
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` = '5689'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5688'
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` = '5687'
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` = '5685'
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` = '5684'
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` = '5680'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5677'
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` = '5675'
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` = '5671'
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` = '5668'
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` = '5664'
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` = '5661'
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` = '5658'
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` = '5657'
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` = '5656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '138'
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 #6: €1,500 WSOPC Tallinn Main Event
Live Reporting - Day 4
Uibo Leads Final 60 Players in €1,500 WSOPC Tallinn Main Event Posted Friday 22nd September, 2023 at 21:14(UTC+0) by Alaxandar Georgiev
Players were ready for battle for the second of four days in the flagship event of the 2023 World Series of Poker Circuit (WSOPC) Tallinn in the €1 million guaranteed Event #6: €1,500 Main Event on Friday at Olympic Park Casino and the Hilton Park Tallinn.
Local Estonian hero Henrik Uibo (pictured above) was the star of the day as he transformed his stack of 149,000 chips he began the day with into a massive 1,765,000 stack after taking the chip lead midway through the day at the televised feature table at OlyBet.tv.
The four opening flights attracted 617 entries and 282 survivors. Late registration remained open for the first two levels of Day 2 with the field eventually growing by another 102 entries to a final total of 719 entries.
Payouts were announced shortly after late registration closed with the top 87 players locking down at least a min-cash of €3,050 with €211,500 on the line for Sunday's eventual Main Event ring champion.
The electric atmosphere added to the excitement with a €1 million guaranteed prize pool which was especially felt around the bubble which lasted nearly a full blind level causing many of the shorter stacks to sweat it out hoping another player would hit the rail.
For a while, the short stacks kept doubling whether via a flip or utter domination. However, all good things must come to an end for one unfortunate player with Latvia's Kristaps Renga running his jacks unsuccessfully into Seppo Parkkinen's cowboys to finish on player shy for the money on the bubble (pictured below). After that several players went out in the money with the 60 returning players all locking up at least €3,300.
Uibo isn't the only chip millionaire in the mix as several others ended Day 2 with seven-figure stacks including Akseli Paalanen (1,300,000), Marko Harkonen (1,205,000), Luca Beretta (1,155,000), Vu Hoang Vuong (1,135,000), Jesus Ucero (1,100,000), Artur Kulanurk (1,085,000), and the aforementioned Seppo Parkkinen (1,015,000).
Day 2 Top 10 Leaderboard
Place
Name
Chips
Big Blinds
1
Hendrik Uibo
1,765,000
71
2
Akseli Paalanen
1,300,000
52
3
Marko Harkonen
1,205,000
48
4
Luca Beretta
1,155,000
46
5
Vu Hoang Vuong
1,135,000
45
6
Jesus Ucero
1,100,000
44
7
Artur Kulanurk
1,085,000
43
8
Seppo Parkkinen
1,015,000
41
9
Mario Linno
980,000
39
10
Jon Ander Martinez
915,000
37
Tomorrow promises to be another exciting day as the Main Event will play down to a final table of nine hopefuls. Our blog will kick off when cards are in the air at 12 p.m. on Saturday. Of course, you can also follow along with the feature table on the live stream on a 30-minute delay with hole cards exposed. See you tomorrow and best of luck to all of the final 60 players in the 2023 WSOPC Tallinn €1,500 Main Event.
Authors: Alexandar Georgiev & Jason Glatzer Images: Elena Kask and Tambet Kask
End-of-Day 2 Chip Counts Posted Friday 22nd September, 2023 at 19:34(UTC+0) by Jason Glatzer
Name
Chips
Big Blinds
Hendrik Uibo
1,765,000
71
Akseli Paalanen
1,300,000
52
Marko Harkonen
1,205,000
48
Luca Beretta
1,155,000
46
Vu Hoang Vuong
1,135,000
45
Jesus Ucero
1,100,000
44
Artur Kulanurk
1,085,000
43
Seppo Parkkinen
1,015,000
41
Mario Linno
980,000
39
Jon Ander Martinez
915,000
37
Bartlomiej Kijak
910,000
36
Kyosti Isberg
880,000
35
Maruen Zormati
865,000
35
Anders Hansson
855,000
34
Emanuele Mari
795,000
32
Ekrem Atush
780,000
31
Pekka Ikonen
780,000
31
Jari-Pekka Juhola
655,000
26
Ignacio Garrido
650,000
26
Andzej Zinkevic
640,000
26
Tomasz Mroz
605,000
24
Stanislavas Macugins
595,000
24
Maciej Komorowski
595,000
24
David Asqino
585,000
23
Aleksandr Arutjunov
565,000
23
Emil Hovmark
555,000
22
Urmo Velvelt
535,000
21
Henri Antikainen
505,000
20
Andrius Bielskis
505,000
20
Alger Pissarev
490,000
20
Jimi Koponen
480,000
19
Deividas Butnoras
470,000
19
Adrians Imsa
465,000
19
Tornike Tchitadze
455,000
18
Mairo Tori
450,000
18
Jun Beum Chun
445,000
18
Ermo Kosk
430,000
17
Remigijus Dzerva
410,000
16
Max Rotko
405,000
16
Gilles Simon
405,000
16
Hannes Praks
400,000
16
Anna-Mari Hursti
395,000
16
Aigars Taukacs
385,000
15
Kris Tikka
380,000
15
Joni Rantamaki
375,000
15
Jose Larios Domene
355,000
14
Steponas Venckus
350,000
14
Samuel Richards
340,000
14
Toms Civcs
330,000
13
Juho Suutari
320,000
13
Igor Yaroshevskyy
315,000
13
Kasper Mellanen
315,000
13
Sebastian Wahl
305,000
12
Kevin Karenius
280,000
11
Youngseo Yoon
220,000
9
Martin Piik
215,000
9
Adria Comas I Roura
210,000
8
Amanullah Tahiri
175,000
7
Antti Eeva
140,000
6
Karl Relander
135,000
5
Payouts Thru Day 2 Posted Friday 22nd September, 2023 at 19:24(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€211,500
2
€137,250
3
€84,200
4
€64,100
5
€48,750
6
€34,150
7
€26,150
8
€21,550
9
€17,700
10
€14,550
11
€11,800
12
€9,600
13
€9,600
14
€7,750
15
€7,750
16
€6,000
17
€6,000
18
€6,000
19
€6,000
20
€6,000
21
€6,000
22
€6,000
23
€6,000
24
€5,250
25
€5,250
26
€5,250
27
€5,250
28
€5,250
29
€5,250
30
€5,250
31
€5,250
32
€4,750
33
€4,750
34
€4,750
35
€4,750
36
€4,750
37
€4,750
38
€4,750
39
€4,750
40
€4,250
41
€4,250
42
€4,250
43
€4,250
44
€4,250
45
€4,250
46
€4,250
47
€4,250
48
€3,750
49
€3,750
50
€3,750
51
€3,750
52
€3,750
53
€3,750
54
€3,750
55
€3,750
56
€3,300
57
€3,300
58
€3,300
59
€3,300
60
€3,300
61
Mauri Dorbek
Estonia
€3,300
62
Rasmus Sepping
Estonia
€3,300
63
Paulius Mikaliunas
Lithuania
€3,300
64
Tarmo Tammel
Estonia
€3,300
65
Andrey Koks
Estonia
€3,300
66
Kert Hallik
Estonia
€3,300
67
Priit Vallap
Estonia
€3,300
68
Tomi Hietala
Finland
€3,300
69
Jonatan Fors
Finland
€3,300
70
Karlis Kreslins
Latvia
€3,300
71
Mark Metsla
Estonia
€3,300
72
Egon Kaljulaid
Estonia
€3,050
73
Keito Kaljulaid
Estonia
€3,050
74
Priit Parmasto
Estonia
€3,050
75
Roope Holma
Finland
€3,050
76
Vidar Assersen
Norway
€3,050
77
Steven Seller
Estonia
€3,050
78
Peng Yi-Zhan
TWN
€3,050
79
Herli Olop
Estonia
€3,050
80
Sergei Aleksejev
Estonia
€3,050
81
Markuss Rukkalns
Latvia
€3,050
82
Mohammed Al-Khazraji
Finland
€3,050
83
Agnius Ismailovas
Lithuania
€3,050
84
Jon Kyte
Norway
€3,050
85
Kare Hallamaa
Finland
€3,050
86
Johan Martinsen
Finland
€3,050
87
Mikko Ylamaki
Finland
€3,050
Player
Chips
Progress
Mark Metsla
0
0
Rasmus Sepping
0
0
Paulius Mikaliunas
0
0
Tarmo Tammel
0
0
Andrey Koks
0
0
Kert Hallik
0
0
Priit Vallap
0
0
Tomi Hietala
0
0
Jonatan Fors
0
0
Karlis Kreslins
0
0
Mauri Dorbek
0
0
"Royal Please" Posted Friday 22nd September, 2023 at 18:19(UTC+0) by Alaxandar Georgiev
Level 20: 10,000/20,000 (20,000) Entries: 65/719
Mario Linno opened the pot to 50,000 and Andrey Koks three-bet small to 105,000. Linno called and the dealer revealed flop on which Linno jammed it all in for 215,000 followed by a snap call from Koks.
Andrey Koks: Mario Linno:
"Royal please," Koks said as he needed the jack of diamonds to make a royal flush.
The turn didn't give him anything, neither did the river.
Great pot for Linno right before end of Day 2.
Player
Chips
Progress
Mario Linno
590,000
65,000
Andrey Koks
290,000
460,000
Final Five Hands Posted Friday 22nd September, 2023 at 18:16(UTC+0) by Jason Glatzer
The floor just announced the final five hands for Day 2. The surviving players will return to action for Day 3 at noon EEST on Saturday.
Stay tuned for an update on the full chip counts along with a recap of the day shortly after the action officially concludes.
The Min-Cash Club Posted Friday 22nd September, 2023 at 18:14(UTC+0) by Jason Glatzer
The following players min-cashed the Main Event for €3,050 with the remaining field locking down at least €3,300.
Place
Player
Country
Prize
72
Egon Kaljulaid
Estonia
€3,050
73
Keito Kaljulaid
Estonia
€3,050
74
Priit Parmasto
Estonia
€3,050
75
Roope Holma
Finlad
€3,050
76
Vidar Assersen
Norway
€3,050
77
Steven Seller
Estonia
€3,050
78
Peng Yi-Zhan
Taiwan
€3,050
79
Herli Olop
Estonia
€3,050
80
Sergei Aleksejev
Estonia
€3,050
81
Markuss Rukkalns
Latvia
€3,050
82
Mohammed Al-Khazraji
Finland
€3,050
83
Agnius Ismailovas
Lithuania
€3,050
84
Jon Kyte
Norway
€3,050
85
Kare Hallamaa
Finland
€3,050
86
Johan Martinsen
Finland
€3,050
87
Mikko Ylamaki
Finland
€3,050
Player
Chips
Progress
Mikko Ylamaki
0
0
Priit Parmasto
0
0
Roope Holma
0
0
Vidar Assersen
0
0
Steven Seller
0
0
Yi-Zhan Peng
0
0
Herli Olop
0
0
Sergei Aleksejev
0
0
Markuss Rukkalns
0
0
Agnius Ismailovas
0
0
Jon Kyte
0
0
Kare Hallamaa
0
0
Johan Martinsen
0
0
Egon Kaljulaid
0
0
"It's Happening" - But Not the Way Kaljulaid Thinks Posted Friday 22nd September, 2023 at 18:07(UTC+0) by Jason Glatzer
Level 20: 10,000/20,000 (20,000) Entries: 71/719
Urmo Kosk was down to just 2.5 big blinds near the bubble and could complete a Cinderella story depending on how the next few days go.
Meanwhile, Keito Kaljulaid was hoping to start his own Cinderella story but Kosk made those dreams crash and burn.
Kaljulaid got his crumbs in with and was up against Kosk with .
The flop catapulted Kaljulaid in the lead and he was excited with his phone out after the turn.
"It's happening!" proclaimed Kaljulaid.
Unfortunately for Kaljulaid, the spiked the river to improve Kosk to Broadway to end his run in the Main Event.
Player
Chips
Progress
Ermo Kosk
400,000
247,500
Keito Kaljulaid
0
0
Rantamaki Loses With The Rockets Posted Friday 22nd September, 2023 at 18:05(UTC+0) by Alaxandar Georgiev
Level 20: 10,000/20,000 (20,000) Entries: 78/719
After an open to 45,000, Karl Relander called followed by a three-bet by Joni Rantamaki to 185,000 from the small blind, original raiser folded and Relander decided to take it to the flop.
The was bet by Rantamaki for 40,000 and Relander shoved it all in for his remaining 120,000 chips, a call followed from the Finn.
Joni Rantamaki: Karl Relander:
Relander had an open-ended straight draw and a flush draw as well, which was bad news for Rantamaki's aces.
The turn completed both the straight and the flush for the Estonian and Rantamaki needed another heart to win the hand.
The on the river was a complete brick and Relander won the big pot 30 minutes before the end of Day 2.
Player
Chips
Progress
Karl Relander
680,000
565,000
Joni Rantamaki
680,000
375,000
17:50 (UTC+0)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
Renga Bubbles Main Event Posted Friday 22nd September, 2023 at 17:50(UTC+0) by Alaxandar Georgiev
Kaspars Renga jammed his last eight blinds from early position and was called by Seppo Parkkinen.
Seppo Parkkinen: Kaspars Renga:
The flop did increase Renga's chances of winning the hand and another diamond meant he was looking for a ten, jack, or a diamond to stay in the tournament.
The river was and Kaspars Renga bubbles the main event.
All other players will cash for at least €3,050 and will be playing the last 40 minutes of Day 2.
Player
Chips
Progress
Seppo Parkkinen
320,000
282,000
Kaspars Renga
0
0
Online Ring Event Begins at 8 p.m. Exclusively at OlyBet Poker Posted Friday 22nd September, 2023 at 17:38(UTC+0) by Jason Glatzer
Event #10: WSOPC €350 NLH Olybet Online Event will kick off at 8 p.m. at OlyBet Poker.
A handful of players already shared they plan to multi-table the online event on their phone while playing in one of the two live ring events currently in action.
Best of luck to all of the online players!
Hursti Wins a Flip on the Bubble Posted Friday 22nd September, 2023 at 17:32(UTC+0) by Jason Glatzer
Level 19: 10,000/15,000 (15,000) Entries: 88/719
Anna-Mari Hursti squeezed for 120,000. Two players folded before Kasper Mellanen called.
Anna-Mari Hursti: Kasper Mellanen:
Hursti won the important flip after the ran out on the board. Another hand was dealt at each table after Hursti doubled her stack.
Player
Chips
Progress
Kasper Mellanen
420,000
330,000
Anna-Mari Hursti
300,000
233,500
Another Double on the Bubble Posted Friday 22nd September, 2023 at 17:25(UTC+0) by Jason Glatzer
Level 19: 10,000/15,000 (15,000) Entries: 88/719
Sebastian Wahl jammed for 220,000 from early position and was called by Sergei Aleksejev from middle position.
Sebastian Wahl: Sergei Aleksejev:
Wahl's ladies were good enough after Aleksejev bricked the board with his big slick.
Meanwhile, Aleksejev was down to just four big blinds after the hand.
Player
Chips
Progress
Sebastian Wahl
480,000
329,500
Sergei Aleksejev
60,000
125,000
Rockets Good for Beretta on the Bubble Posted Friday 22nd September, 2023 at 17:16(UTC+0) by Jason Glatzer
Level 19: 10,000/15,000 (15,000) Entries: 88/719
Luca Beretta got his 365,000 stack in the middle before the flop in a hand against Mario Linno.
Luca Beretta: Mario Linno:
The board ran clean for Beretta's rockets to double through Linno on the money bubble.
Player
Chips
Progress
Luca Beretta
775,000
701,500
Mario Linno
525,000
428,000
Hand-For-Hand on Money Bubble Posted Friday 22nd September, 2023 at 17:13(UTC+0) by Jason Glatzer
Level 19: 10,000/15,000 (15,000) Entries: 88/719
Finland's Kalle Salmela hit the rail in 89th place. The action was hand-for-hand on the money bubble shortly after.
A couple of hands of bubble play already took place with no drama. Stay tuned to see how the bubble action goes down.
Player
Chips
Progress
Kalle Salmela
0
0
Big Slick No Good for Biz Posted Friday 22nd September, 2023 at 16:54(UTC+0) by Jason Glatzer
Level 19: 10,000/15,000 (15,000) Entries: 89/719
The action is just one player for the money after a few eliminations including Turkey's Mustafa Biz.
Biz three-bet jammed in late position and was called by Rasmus Sepping who opened from middle position.
Mustafa Biz: Rasmus Sepping:
Biz bricked the board to hit the rail just short of the money. Meanwhile, Algirdas Saveikis and Juha Helppi also hit the rail to leave just 89 remaining.
Player
Chips
Progress
Rasmus Sepping
0
469,000
Algirdas Saveikis
0
0
Mustafa Biz
0
0
Juha Helppi
0
0
16:46 (UTC+0)
Start of Level 19 Blinds: 10,000/15,000 Ante: 15,000
Big Stacks On The Break Posted Friday 22nd September, 2023 at 16:43(UTC+0) by Alaxandar Georgiev
We are down to the last 92 players with 87 paid. Hendrik Uibo continues to be the chip leader with over 1,300,000 chips.
Check out some of the bigger stacks down below.
Player
Chips
Progress
Hendrik Uibo
1,300,000
584,000
Joni Rantamaki
1,055,000
275,000
Jon Ander Martinez
915,000
709,500
Andrey Koks
750,000
70,000
Vu Hoang Vuong
725,000
139,000
Mauri Dorbek
700,000
462,500
Emil Hovmark
700,000
280,000
David Asqino
670,000
370,000
Bartlomiej Kijak
580,000
501,000
Roope Holma
500,000
448,000
Final Break Posted Friday 22nd September, 2023 at 16:29(UTC+0) by Jason Glatzer
Players are on their final break of Day 2. The Main Event will be five away from the money with two more blind levels to go for the day when the action resumes.
Player
Chips
Progress
Christoffer Bering
0
0
Igor Pihela Sr.
0
0
Mantas Bagocius
0
0
Einar Hersdal
0
0
Mauro-Mark Musting
0
0
Stephen Groom
0
0
Aleksejev Runs Into The Blades Posted Friday 22nd September, 2023 at 16:28(UTC+0) by Alaxandar Georgiev
Level 18: 6,000/12,000 (12,000) Entries: 92/719
Vu Hoang Vuong raised UTG+1, everyone folded except Sergei Aleksejev who was on the big blind and jammed it all in, a snap call followed from Vuong.
Vu Hoang Vuong: Sergei Aleksejev:
Both players had monster starting hands, but Vuong had the better one with his pocket aces.
The almost ended Aleksejev's chances of wining the pot and the next card meant that Vuong won the massive 586,000 pot.
Player
Chips
Progress
Vu Hoang Vuong
586,000
326,000
Sergei Aleksejev
185,000
260,000
Koks Ousts Start of Day Chip Leader Holmberg Posted Friday 22nd September, 2023 at 16:27(UTC+0) by Jason Glatzer
Level 18: 6,000/12,000 (12,000) Entries: 92/719
Start of the day chip leader Joel Holmberg is on the rail a few players away from the money.
Andrey Koks limped from under the gun before a player in middle position called. Holmberg jammed from the small blind for 118,000. Koks called and the rest of the table folded.
Joel Holmberg: Andrey Koks:
"Good luck," Koks said to Holmberg.
No luck came Holmberg's way with the running out on the board.
Player
Chips
Progress
Andrey Koks
680,000
300,000
Joel Holmberg
0
0
Fun Main Event Stats (Part 1) Posted Friday 22nd September, 2023 at 16:10(UTC+0) by Jason Glatzer
We will update you with some fun stats over the next few days about the Main Event.
The first piece of knowledge you already know is that the Main Event attracted 719 entries. This was a result of 539 unique players and 180 re-entries.
Finland boasted both the most unique players and entries with 141 uniques and 227 entries, while the home country of Estonia was second with 126 uniques and 180 entries.
One lesson learned here is that both Finnish and Estonian players are re-entering more on average when compared to the entire field. Will this result in a Main Event champion from one of these countries? Time will tell.
Best of luck to all of the remaining players regardless of their home country.
Chun Holds The Line Posted Friday 22nd September, 2023 at 15:56(UTC+0) by Alaxandar Georgiev
Level 17: 5,000/10,000 (10,000) Entries: 99/719
Christoffer Bering opened the pot by throwing 22,000 in the middle from the hijack, on his left Jun Beum Chun raised him to 65,000 followed by a call from Bering.
The flop was checked by Bering and the Japanese bet 65,000 chips. Norway's Bering jammed it all in and Chun called for his remaining 259,000.
Christoffer Bering: Jun Beum Chun:
Bering had a flush draw with a gutter to the straight and Chun needed to dodge a lot of cards. The on the turn gave his opponent even more outs since he paired his eight.
The on the river brought some relief to Chun and he scooped the whole pot worth over 520,000 chips.
Player
Chips
Progress
Jun Beum Chun
528,000
282,000
Christoffer Bering
35,000
63,000
15:50 (UTC+0)
Start of Level 18 Blinds: 6,000/12,000 Ante: 12,000
Sorainen Taps the Table Posted Friday 22nd September, 2023 at 15:50(UTC+0) by Jason Glatzer
Level 17: 5,000/10,000 (10,000) Entries: 100/719
Day 1a chip leader Joni Rantamaki opened for 22,000 from under the gun before Luka Sorainen three-bet shoved for 136,000.
Henri Anttikainen went into the tank from the small blind and asked for a count. A couple of minutes later, he folded. Meanwhile, Rantamaki took a quick peek at his cards to make sure he had what he thought he had and called.
Luka Sorainen: Joni Rantamaki:
"Oh #$&@," Sorainen said out of frustration when seeing what he was up against.
Sorainen got out of his chair after things went from bad to worse with Rantamaki nailing a set on the flop. The turn and river completed the board and Sorainen tapped the table.
"Good luck!" Sorainen said with true sportsmanship.
Player
Chips
Progress
Joni Rantamaki
780,000
320,000
Touko Berndtson
0
0
Juuso Elsinen
0
0
Tadas Karosas
0
0
Eemil Tuominen
0
0
Luka Sorainen
0
0
Big Cooler Near Top 100 Posted Friday 22nd September, 2023 at 15:38(UTC+0) by Alaxandar Georgiev
Level 17: 5,000/10,000 (10,000) Entries: 103/719
Gilles Simon raised to 20,000 from an early position, got a call from the player next to him followed by a big all-in from Adria Comas I Roura for 290,000 chips, which Simon quickly called for 240,000.
Gilles Simon: Adria Comas I Roura:
Simon managed to hold his big hand on the board and it was a massive cooler for Roura few players off the top 100 with 87 players paid.
Roura was left with only 50,000 and needs to battle his way through.
Player
Chips
Progress
Gilles Simon
530,000
95,000
Adria Comas I Roura
50,000
131,500
Sultanov Busts The Tournament Posted Friday 22nd September, 2023 at 15:27(UTC+0) by Alaxandar Georgiev
Level 17: 5,000/10,000 (10,000) Entries: 108/719
WSOPC €555 NLH Winner Viacheslav Sultanov went all in against Tomasz Mroz for his last 90,000 chips.
Viacheslav Sultanov: Tomasz Mroz:
Sultanov was behind and needed some help, but didn't get it on flop, neither on the turn. The river locked the pot for Poland's Mroz and our WSOPC winner is eliminated in 109th place
Player
Chips
Progress
Tomasz Mroz
580,000
100,000
Viacheslav Sultanov
0
0
Recent Eliminations Posted Friday 22nd September, 2023 at 15:21(UTC+0) by Jason Glatzer
The action is getting closer to the money with 109 entries and 87 players going home with at least a €3,050 min-cash for more than double the €1,500 buy-in for the Main Event.
Below are some of the players recently on the rail short of the money:
Player
Chips
Progress
Hendry Kullamae
0
0
Carl Halvarsson
0
0
Gert Laanemets
0
0
Maikel Homin
0
0
Giovanni Memola
0
0
Richard Koppel
0
0
Mathias Siljander
0
0
Ranno Sootla
0
0
Maksim Petrov
0
0
Calle Hansson
0
0
Albert Gorelik
0
0
Kaspars Butans
0
0
Morten Bremseth
0
0
15:11 (UTC+0)
Start of Level 17 Blinds: 5,000/10,000 Ante: 10,000
Mairo Tori Gets His Daily Quads Posted Friday 22nd September, 2023 at 15:10(UTC+0) by Alaxandar Georgiev
Level 16: 4,000/8,000 (8,000) Entries: 119/719
With more than 170,000 chips already in the Pot Mairo Tori was thinking a lot on the river after his opponent checked on the low paired board of and decided to bet another 55,000.
His opponent paid the bet and Tori showed and won the hand with his quads.
Player
Chips
Progress
Mairo Tori
370,000
312,500
Video Recap From Day 8 Posted Friday 22nd September, 2023 at 14:59(UTC+0) by Jason Glatzer
Recent Eliminations Posted Friday 22nd September, 2023 at 14:58(UTC+0) by Jason Glatzer
The payouts can all now be found in the Payouts tab.
Check out the recent eliminations below:
Player
Chips
Progress
Ruslan Stserbjuk
0
0
Igor Pihela Jr.
0
0
Ingus Arajs
0
0
Jan-Mikael Kesanen
0
0
Ramunas Mika
0
0
Petteri Kalenius
0
0
Eedi Kirves
0
0
Dmitrijs Meless
0
0
Aleksei Smirnov
0
0
Oskar Ojaveer
0
0
Matus Fecisko
0
0
Pyry Kekalainen
0
0
Hai Hoang
0
0
Magnus Pukk
0
0
€211,500 to the Winner in the Main Event! Posted Friday 22nd September, 2023 at 14:52(UTC+0) by Lina Olofsson
The tournament director Teresa Nousiainen just announced the prize pool in the first-ever Main Event of the 2023 WSOP Circuit here in Tallinn. The guaranteed prize pool of €1 million will be spread over the top 87 players in this tournament with €3,050 for a minimum.
The winner in this tournament will walk away with as much as €211,500 apart from the golden WSOPC ring (and the huge blue winners check you might have seen Aleksei Smirnov trying to fit into his Bolt taxi the other day in one of our previous updates).
Herli Olop is one of the players still on the field competing for the €211,500 to the winner
Table 15 to the Stream Posted Friday 22nd September, 2023 at 14:46(UTC+0) by Lina Olofsson
As the play resumes we're changing the players at our feature table here from the Main Event as table number 15 goes on with the following players.
You can watch it together with our amazing commentators Andreas and George with a 30-minute delay at our LIVE STREAM.
Player
Chips
Progress
Hendrik Uibo
716,000
34,000
Stephen Groom
315,000
200,000
Kalle Salmela
293,000
194,500
Marko Harkonen
233,000
112,000
Igor Pihela Jr.
210,000
0
Ranno Sootla
171,000
87,000
Carl Halvarsson
138,000
78,000
Koponen Doubles Short Stack Against Dorbek Posted Friday 22nd September, 2023 at 14:36(UTC+0) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 140/719
Jimi Koponen lost a good portion of his stack and was down to just a handful of big blinds when they were committed in a pot preflop against Mauri Dorbek (pictured below).
Jimi Koponen: Mauri Dorbek:
Koponen was slightly behind but pulled far ahead when his queen connected on the flop. Neither the turn nor the river created any more drama for Koponen to double his short stack against Dorbek.
Player
Chips
Progress
Mauri Dorbek
350,000
112,500
Jimi Koponen
95,000
3,000
Kimmo Kurko
0
0
Ruslan Stserbjuk
0
0
Hai Hoang
0
0
Pyry Kekalainen
0
0
Matus Fecisko
0
0
Oskar Ojaveer
0
0
14:26 (UTC+0)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
Hovmark Still Holds the Fort during the Second Break of the Day Posted Friday 22nd September, 2023 at 14:26(UTC+0) by Lina Olofsson
Emil Hovmark lost some chips towards the end of the 15th level in the Main Event but still holds down the fort with 141 players remaining of the 719 entries in this tournament where we play for an astonishing €1 million guaranteed prize pool.
At the break, Hovmark sits with 980,000 in front of him over at table six in the Grand Ballroom here at Hilton Park and Olympic Casino in the Estonian capital.
Below you'll find some other interesting names and stacks from across the field.
Player
Chips
Progress
Emil Hovmark
980,000
95,000
Anders Hansson
455,000
195,000
Toms Civcs
450,000
334,500
Sergei Aleksejev
445,000
404,500
Gilles Simon
435,000
215,000
Aigars Taukacs
390,000
240,500
Eemil Tuominen
365,000
123,000
Andrius Bielskis
295,000
90,000
Mauri Dorbek
237,500
128,000
Calle Hansson
103,000
4,000
Various Big Stacks At Break Posted Friday 22nd September, 2023 at 14:25(UTC+0) by Alaxandar Georgiev
Players are soon returning from their short break, check out some of the bigger stacks in the field below.
Player
Chips
Progress
Maciej Komorowski
840,000
724,500
Hendrik Uibo
750,000
620,000
Jonatan Fors
720,000
423,000
Jon Kyte
500,000
30,000
Jesus Ucero
480,000
358,000
Tomasz Mroz
480,000
324,000
Joni Rantamaki
460,000
188,000
Eliminations Near the End of Level 15 Posted Friday 22nd September, 2023 at 14:17(UTC+0) by Jason Glatzer
Player
Chips
Progress
Aleksi Naski
0
0
Joshua Marquardt
0
0
Ken Okada
0
0
Max Avela
0
0
Juha Elo
0
0
Priit Oja
0
0
Vilius Zabarauskas
0
0
Tommi Lankinen
0
0
Mantas Ramanaukas
0
0
Aleksandrs Kasincevs
0
0
Kimmo Kurko
0
0
Okada Runs Into Trouble Posted Friday 22nd September, 2023 at 14:13(UTC+0) by Alaxandar Georgiev
Level 15: 3,000/6,000 (6,000) Entries: 144/719
Henri Antikainen raised 15,000 and got three-bet from Ken Okada to 45,000 chips. Antikainen jammed it all in and Okada called.
Henri Antikainen: Ken Okada:
No luck for Okada on the board as Finland's Antikainen wins with the better hand.
Player
Chips
Progress
Henri Antikainen
440,000
275,000
Ken Okada
0
0
Break Time Posted Friday 22nd September, 2023 at 14:02(UTC+0) by Jason Glatzer
Players are on their second 20-minute break. Blinds will increase to 4,000/8,000 with an 8,000 big blind ante when the action resumes. We will update the biggest stacks from around the room shortly after the break.
Player
Chips
Progress
Mantas Bagocius
300,000
60,000
Elias Talvitie
258,000
208,000
Full House for Talvitie Posted Friday 22nd September, 2023 at 14:01(UTC+0) by Jason Glatzer
Level 15: 3,000/6,000 (6,000) Entries: 155/719
Elias Talvitie three-bet jammed 122,000 chips from the button and was called by Mantas Bagocius on the small blind. The original raiser folded and players revealed their cards.
Elias Talvitie: Mantas Bagocius:
The ran out on the board to improve Talvitie to win the hand.
Player
Chips
Progress
Mantas Bagocius
300,000
60,000
Elias Talvitie
258,000
208,000
Zormati Ousts Heinlo Posted Friday 22nd September, 2023 at 13:38(UTC+0) by Jason Glatzer
Level 15: 3,000/6,000 (6,000) Entries: 159/719
Maruen Zormati min-raised the button before Hanna Heinlo three-bet shoved for 15,000 from the small blind. Giovanni Memola called from the small blind and Zormati called as well to see the flop.
Memola checked. Zormati bet 7,000 which was enough to get Memola out of the way.
Hanna Heinlo: Maruen Zormati:
The turn was safe for Heinlo and she began to ask for a third seven.
Instead, Heinlo shook her head in disgust after Zormati completed his flush on the river to win the hand and eliminate Heinlo.
Player
Chips
Progress
Giovanni Memola
275,000
175,500
Maruen Zormati
200,000
38,000
Davor Pavic
0
0
Jordi Baixas
0
0
Arko Akenparg
0
0
Joel Ylismaki
0
0
Niki Nurmisto
0
0
Jarmo Salonen
0
0
Glen Gaines
0
0
Stefan Bittger
0
0
Teemu Toikanen
0
0
Teemu Toikkanen
0
0
Martin Sedlak
0
0
Arturs Daugis
0
0
Eriks Krumins
0
0
Vygerdas Jonikas
0
0
Stanislovas Norkus
0
0
Christopher Berggren
0
0
Hanna Heinlo
0
0
13:22 (UTC+0)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
Yoon Drives the Bad Beat Train Against Valent Posted Friday 22nd September, 2023 at 13:22(UTC+0) by Jason Glatzer
Level 14: 2,000/5,000 (5,000) Entries: 175/719
The entire stack of Martin Valent went in on the turn with the in a hand against Youngseo Yoon.
Martin Valent: Youngseo Yoon:
Valent appeared to be in an amazing spot to double with a straight and just had to sweat three outs. The poker gods were cruel to Valent with the bad beat express train delivering a on the river to improve Yoon to a better straight and send Valent to the rail.
Player
Chips
Progress
Youngseo Yoon
300,000
250,000
Quang Doan
0
0
Risto Parnat
0
0
Davis Modans
0
0
Aki Pyysing
0
0
Markku Koplimaa
0
0
Jose Koistinen
0
0
Martin Koppl
0
0
Julian Selinger
0
0
Arturs Sutens
0
0
Martin Naveiro
0
0
Tero Hakanen
0
0
Ryan Mandara
0
0
Kai Lehto
0
0
Arthur Boatman
0
0
Josep Pastor De Ramon
0
0
Ori Hasson
0
0
Antti Karkkainen
0
0
Martin Valent
0
0
Wagner Loses The Big One Posted Friday 22nd September, 2023 at 13:16(UTC+0) by Alaxandar Georgiev
Level 14: 2,000/5,000 (5,000) Entries: 184/719
Gilles Simon opened by raising to 10,000, Henri Wagner sitting on the button re-raised to 23,000 chips followed by a 59,000 four-bet from Simon.
Wagner announced he was all in for 290,000 chips and Simon snap called.
Gilles Simon: Henri Wagner:
Behind against Wagner's strong hand Simon needed to see an ace, but didn't get one on the flop. The turn gave Simon some outs for a straight on the river.
The river was was not what the EPT champion wanted to see. Simon won the massive 600,000 pot and Wagner was eliminated.
Player
Chips
Progress
Gilles Simon
650,000
438,500
Henri Wagner
0
0
Hovmark Clear Chip Leader After Eliminating Kellner Posted Friday 22nd September, 2023 at 12:57(UTC+0) by Jason Glatzer
Level 14: 2,000/5,000 (5,000) Entries: 202/719
Unfortunately, KelsterMania is over. Kelly Kellner moved to a new table alongside the chip leader Emil Hovmark.
The duo got involved in a 1 million chip pot. Kellner check-called a bet on the flop before leading out for 80,000 on the turn. Hovmark called and Kellner jammed his big stack on the river.
Hovmark tanked for several minutes before he called. Kellner turned over for trip kings. Strong hand, but not strong enough as Hovmark took down the pot with a flush after turning over the .
"I am going to need to walk this one off," the vibrant Kellner shared.
We wish Kellner the best of luck the rest of the way and to continue to enjoy his Tallinn experience despite this very rough blow.
Player
Chips
Progress
Emil Hovmark
1,075,000
725,000
Ville-Matti Keranen
0
0
Rasmus Lundstrom
0
0
Aurelijus Sipavicius
0
0
Jaime Susarte
0
0
Jorge Bravo
0
0
Szymon Bujok
0
0
Nedas Nanys
0
0
Silver Simulask
0
0
Kelly Kellner
0
0
Recent Elims Posted Friday 22nd September, 2023 at 12:49(UTC+0) by Jason Glatzer
Level 14: 2,000/5,000 (5,000) Entries: 213/719
The following players hit the rail during the second half of Level 13:
Player
Chips
Progress
Roope Tarmi
0
0
Vadims Milovs
0
0
Matias Arosuo
0
0
Lars Jonsson
0
0
Valters Cernevskis
0
0
Saku Turtia
0
0
Andrius Simonovicius
0
0
Pavel Solodovnikov
0
0
Henri Antikainen
0
0
Rikard Relander
0
0
12:43 (UTC+0)
Start of Level 14 Blinds: 2,000/5,000 Ante: 5,000
Massive Pot For Jon Kyte Posted Friday 22nd September, 2023 at 12:42(UTC+0) by Alaxandar Georgiev
Level 13: 2,000/4,000 (4,000) Entries: 205/719
Nedas Nanys raised from an early position to 8,000 and the €1,100 WSOPC PLO champion Jon Kyte called from the button followed by a three-bet by Rasmus Lundstrom to 38,000.
Nanys pushed his remaining 71,000 chips and Kyte called, Lundstrum jammed for about 240,000 chips, and Kyte snap-called.
Nedas Nanys: Jon Kyte: Rasmus Lundstrom:
Brilliantly limped Kings from Kyte made him a favorite for the massive 530,000 chips pot.
The flop was which gave Lundstrum some chance to win the pot by getting another Jack.
The turn and the river were good for Kyte and he scooped the massive pot. Lundstrom was left with around 10,000 chips which he managed to double with a pair of fives the next hand.
Player
Chips
Progress
Jon Kyte
530,000
483,000
Rasmus Lundstrom
10,000
59,500
Nedas Nanys
0
0
Kelster Mania is Alive Posted Friday 22nd September, 2023 at 12:31(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 (4,000) Entries: 235/719
Kelly Kellner (pictured below) flew over from Canada to enjoy the WSOP Circuit Tallinn. He has been making the most of his first visit to the Estonian capital both on and away from the felts.
Kellner has had a hot hand to start Day 2 with tens multiple times and most recently winning a monster pot with an even better hand.
Georgios Skarparis opened for 10,000. Kellner jacked it up to 45,000. Skarparis four-bet shoved for tons of chips and Kellner called.
Georgios Skarparis: Kelly Kellner:
The didn't help Skarparis. But even if he had aces he would have lost anyway as Kellner nailed a set and then a full house to win a huge pot.
"KelsterMania is alive!" Kelly said with enthusiasm after the hand.
Player
Chips
Progress
Kelly Kellner
535,000
250,000
Georgios Skarparis
0
0
Joona Ranta-Nilkku
0
0
Tomi Bondarew
0
0
Janne Havio
0
0
Teemu Sanaksenaho
0
0
Karolis Kutkauskas
0
0
Konsta Heikkila
0
0
Elias Vaaraniemi
0
0
Antti Veerberk
0
0
Robin Palm
0
0
Big Double For Sedlak Posted Friday 22nd September, 2023 at 12:27(UTC+0) by Alaxandar Georgiev
Level 13: 2,000/4,000 (4,000) Entries: 235/719
After just calling preflop Martin Sedlak played the board brilliantly as chips went flying against Tomi Bondarew on the river who was eliminated in 236th place after mucking his cards to Sedlak's .
The German scooped the pot and is now sitting at 240,000 chips.
Player
Chips
Progress
Martin Sedlak
240,000
131,000
Tomi Bondarew
0
0
Trips for Groom Posted Friday 22nd September, 2023 at 12:18(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 (4,000) Entries: 246/719
Stephen Groom checked with the on the board with around 120,000 in the pot before Josep Pastor De Ramon went into the tank. Eventually, De Ramon bet 50,000 and Groom snap-called.
De Ramon turned over the but lost a big pot to Groom who had trips with .
Player
Chips
Progress
Raivo Pinsel
0
0
Georgios Tsouloftas
0
0
Kaupo Tenno
0
0
Rinalds Zimka
0
0
Santtu Leinonen
0
0
Jyrki Lampinen
0
0
Ilari Sahamies
0
0
Kristo Erala
0
0
Viktors Semjonovs
0
0
719 Entries! Posted Friday 22nd September, 2023 at 12:05(UTC+0) by Jason Glatzer
Level 13: 2,000/4,000 (4,000) Entries: 264/719
Late registration is now closed for the Main Event. The event attracted 719 entries, meaning there is some added value for the players thanks to the €1 million guaranteed prize pool.
Payouts will be announced shortly.
12:03 (UTC+0)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
Eliminations Before the Break Posted Friday 22nd September, 2023 at 12:03(UTC+0) by Jason Glatzer
Player
Chips
Progress
Alius Riskevicius
0
0
Torbjorn Larsen
0
0
Claudio Cecchi
0
0
Eeti Loyttyniemi
0
0
Dominik Ostrowski
0
0
Vasilij Barna
0
0
Khalid Dghaim
0
0
Justus Kursi
0
0
Johan Karlsson
0
0
Rasmus Eino
0
0
Edgars Gendvilis
0
0
Michele Tocci
0
0
Chip Count Update On The Break Posted Friday 22nd September, 2023 at 11:57(UTC+0) by Alaxandar Georgiev
Check out some of the bigger stacks down below.
Player
Chips
Progress
Mantas Bagocius
500,000
215,500
Andrey Koks
380,000
253,000
Urmo Velvelt
320,000
27,000
Paulius Mikaliunas
300,000
245,000
David Asqino
300,000
174,500
Touko Berndtson
295,000
76,000
Kelly Kellner
285,000
171,500
Georgios Skarparis
270,000
59,500
Anders Hansson
260,000
134,000
Aleksei Smirnov
230,000
25,500
Final Three Hands Posted Friday 22nd September, 2023 at 11:35(UTC+0) by Jason Glatzer
The floor announced that each table would play three more hands. Late registration will remain open during the break.
After the break, we will announce the total field size and shortly after that release the payouts.
Larsen Cracks Aces with Quads Posted Friday 22nd September, 2023 at 11:33(UTC+0) by Jason Glatzer
Level 12: 1,500/3,000 (3,000) Entries: 271/708
Emil Hovmark opened for 5,500 from the cutoff before Ronny Albrigtsen three-bet shoved from the button. Albert Ostrowski four-bet shoved for more than 100,000. Hovmark tanked for several minutes before the clock was called. About halfway through his time, he tossed in a chip to call.
Ronny Albrigtsen: Albert Ostrowski: Emil Hovmark:
The flop pushed Hovmark ahead and he improved to quads on the turn. Ostrowski appeared to be in disbelief and took his phone camera out to snap a photo after a blank hit the river.
Hovmark stood up to apologize for the bad beat to the stunned Ostrowski before both of his opponents left the table.
Player
Chips
Progress
Emil Hovmark
350,000
236,500
Albert Ostrovskij
0
0
Benjamin Dixon
0
0
Lukasz Balbierz
0
0
Sergejs Piratovs
0
0
Inigo Serrano Robles
0
0
Raido Tsmir
0
0
Niko Palonen
0
0
Justas Semaska
0
0
Steven Tool
0
0
Samuli Hietala
0
0
Karolis Kutkauskas
0
0
Xiaolei Chen
0
0
Juha Kaitanen
0
0
Ronny Albrigtsen
0
0
More Than 700 Entries; Pyysing Sets New Personal Record Posted Friday 22nd September, 2023 at 11:16(UTC+0) by Jason Glatzer
Players keep filling in and the field now has more than 700 entries. Aki Pyysing (pictured below) was on his third Day 2 re-entry and shared with the media that this is a new personal record for the very seasoned poker guru and journalist.
Player
Chips
Progress
Aki Pyysing
70,000
20,000
Fives No Good for Pyysing Posted Friday 22nd September, 2023 at 11:04(UTC+0) by Jason Glatzer
Level 12: 1,500/3,000 (3,000) Entries: 288/694
Aki Pyysing jammed for 55,000 from early position and was called by Vu Hoang Vuong from the blinds.
Aki Pyysing: Vu Hoang Vuong:
Pyysing's fives got nowhere against sevens after with the running out on the board.
Player
Chips
Progress
Vu Hoang Vuong
260,000
107,000
Aki Pyysing
0
0
Marko Vest
0
0
Charles-Eric Benoit
0
0
Johannes Levola
0
0
Marco Kolle
0
0
Dmitri Dudakov
0
0
Tanaka Yusuke
0
0
Jevgenijs Sapronenko
0
0
Aleksandr Jelpidiforov
0
0
Vincas Tamasauskas
0
0
Roberts Rumba
0
0
Rauno Remmel
0
0
10:52 (UTC+0)
Start of Level 12 Blinds: 1,500/3,000 Ante: 3,000
"Double Me, Please" Posted Friday 22nd September, 2023 at 10:44(UTC+0) by Jason Glatzer
Level 11: 1,000/2,500 (2,500) Entries: 301/679
Jarmo Salonen opened for 5,500 from under the gun before Jari Mahonen three-bet shoved from middle position for 50,000.
"Well, well," Salonen said to his country-mate.
"Well, well," said Mahonen right as Salonen was about to call. "Double me up, please."
Jari Mahonen: Jarmo Salonen:
The board didn't push Mahonen past Salonen and he headed back to the cashier to re-enter while Salonen added to his already impressive chip stack.
Player
Chips
Progress
Jarmo Salonen
260,000
71,000
Topi Palenius
0
0
Tapio Aaltonen
0
0
Aleksei Gontsar
0
0
Janne Havio
0
0
Matias Knaapinen
0
0
Joshua Stewart
0
0
Aleksander Lammas
0
0
Tomi Arponen
0
0
Markku Koplimaa
0
0
Johan Alen
0
0
Giuseppe Rosa
0
0
Anne Bezdek
0
0
Jeffrey Sarwer
0
0
Kaido Mikk
0
0
Baavo Pohlak
0
0
Jari Mahonen
0
0
Karosas Doesn't Push Isberg Off Two Pair Posted Friday 22nd September, 2023 at 10:33(UTC+0) by Jason Glatzer
Level 11: 1,000/2,500 (2,500) Entries: 308/667
The Main Event field has been growing with already 50 new entries getting into the mix. This means the tables outside the main ballroom are in use including where the following hand took place at Table 41.
It was a small blind vs. blind pot when Tadas Karosas check-raised Kyosti Isberg from 7,000 to 18,000 with the on the board after the turn. Isberg called and both players checked the river.
Karosas turned over and this was no match to the two pair by Isberg with .
Player
Chips
Progress
Kyosti Isberg
190,000
9,500
Tadas Karosas
75,000
9,500
Edgars Beizaks
0
0
David Spysschaert
0
0
Jose Koistinen
0
0
Rasmus Sepping
0
0
Mauri Dorbek
0
0
Max Avela
0
0
Ilya Nikiforov
0
0
Vladimiras Meckovskis
0
0
Kalle Parkkinen
0
0
Steven Seller
0
0
Queens "Get There" Against Tens Posted Friday 22nd September, 2023 at 10:23(UTC+0) by Jason Glatzer
Level 11: 1,000/2,500 (2,500) Entries: 314/650
Mairo Tori opened for a min-raise from under the gun before Akseli Paalanen three-bet jammed for 46,000 from the button. Ken Okada four-bet shoved for two big blinds more from the small blind and Tori folded.
Akseli Paalanen: Ken Okada:
It appeared Paalanen would hit the rail after the flop improved Okada to a set of tens. However, the turn changed everything back as it was with Paalanen back on top. Okada got out of his chair ready to leave the tournament area after the river completed the board but the dealer quickly called him back as he had some crumbs to potentially spin up. Okada dusted this off shortly after and was on the rail potentially getting ready to re-enter.
Player
Chips
Progress
Akseli Paalanen
95,000
49,000
Ken Okada
0
0
Juha Nikkola
0
0
Sten Talviste
0
0
Juho Sallinen
0
0
Olafs Karlins
0
0
Kaido Kuusemae
0
0
Niko Linnama
0
0
Verneri Sivula
0
0
Tomas Molcan
0
0
Min Ho Cho
0
0
Day 2 Begins Posted Friday 22nd September, 2023 at 10:09(UTC+0) by Jason Glatzer
Level 11: 1,000/2,500 (2,500) Entries: 312/647
Even before the start of the action, 30 new players joined on Day 2 to bring the total field up to 645 entries and counting.
Players have unbagged their chips followed by some preliminary announcements. Cards were in the air moments later. Best of luck to all of the Day 2 players.
Day 2 Begins at Noon Posted Friday 22nd September, 2023 at 09:02(UTC+0) by Jason Glatzer
Welcome to what promises to be an exciting day as the €1 million guaranteed WSOPC Tallinn €1,500 Main Event progresses to Day 2 on Friday at noon at the luxurious surroundings of Olympic Park Casino and the Hilton Tallinn Park.
The plan for today is for players to battle for 10 more blind levels of 40 minutes each in hopes of putting themselves in a prime position to advance to Sunday's final table.
The first two levels will be action-packed as players can still late register and re-enter up until the start of the third blind level of the day. The field stood at 617 entries after the four opening flights with plenty of more players expected, especially considering at least 15 new players are coming into the field via last night's midnight mega satellite.
Finland's Joel Holmberg bagged the overall chip lead on Day 1c with 318,000. He was the only player above 300,000 to end any of the opening flights with Jonatan Fors, Day 1b chip leader Urmo Velvelt, Estonia's Tarmo Tammel (pictured below), and Lithuania's Mantas Bagocius all not too far from Holmberg to start Day 2.
Place
Player
Country
Chips
Big Blinds
1
Joel Holmberg
Finland
318,000
127
2
Jonatan Fors
Finland
297,000
119
3
Urmo Velvelt
Estonia
293,000
117
4
Tarmo Tammel
Estonia
290,000
116
5
Mantas Bagocius
Lithuania
284,500
114
6
Santeri Piiroinen
Finland
281,000
112
7
Joni Rantamaki
Finland
272,000
109
8
Pyry Kekalainen
Finland
267,500
107
9
Igor Pihela Sr.
Estonia
257,000
103
10
Juho Suutari
Finland
251,500
101
Our coverage begins for Day 2 when cards are in the air at noon. Best of luck to all of the Day 2 players!
Day 2 Seat Draw Posted Thursday 21st September, 2023 at 23:59(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Jari-Pekka Juhola
93,000
37
1
2
Paulius Mikaliunas
55,000
22
1
3
Torbjörn Larsen
132,000
53
1
5
Magnus Pukk
93,500
37
1
6
Inigo Martin
147,500
59
1
7
Gilles Simon
211,500
85
1
8
Jeffrey Sarwer
80,000
32
2
1
Silver Simulask
65,000
26
2
3
Georgios Skarparis
210,500
84
2
4
Calle Hansson
107,000
43
2
5
Janne Havio
50,000
20
2
6
Vladimiras Meckovskis
74,500
30
2
7
Algirdas Saveikis
106,000
42
2
8
Vasilij Barna
154,000
62
3
1
Priit Parmasto
116,000
46
3
2
Khalid Dghaim
146,000
58
3
4
Maikel Homin
44,000
18
3
5
Danel Kunman
36,000
14
3
6
Kaupo Tenno
54,000
22
3
7
Jarmo Salonen
189,000
76
3
8
Anne Bezdek
62,000
25
4
1
Jari Mähonen
56,000
22
4
2
Justas Semaska
57,500
23
4
3
Adria Comas I Roura
181,500
73
4
5
Johan Karlsson
71,000
28
4
6
Eedi Kirves
134,000
54
4
7
Viacheslav Sultanov
56,000
22
4
8
Sebastian Wahl
150,500
60
5
1
Davor Pavic
19,500
8
5
2
Rinalds Zimka
98,000
39
5
4
Edgars Gendvilis
88,000
35
5
5
Vidar Assersen
163,500
65
5
6
Totti Arosuo
82,000
33
5
7
Alger Pissarev
71,500
29
5
8
Karolis Kutkauskas
112,000
45
6
1
Ronny Albrigtsen
103,000
41
6
2
Martin Piik
82,000
33
6
4
Albert Ostrovskij
159,000
64
6
5
Niko Palonen
67,500
27
6
6
Teemu Toikkanen
203,000
81
6
7
Andzej Zinkevic
125,000
50
6
8
Emil Hovmark
113,500
45
7
2
Antti Kärkkäinen
155,000
62
7
3
Ilya Nikiforov
101,000
40
7
4
Juho Sallinen
30,000
12
7
5
Mantas Bagocius
284,500
114
7
6
Luca Beretta
73,500
29
7
7
Anna-Mari Hursti
66,500
27
7
8
Tomi Bondarew
55,000
22
8
1
Juha Kaitanen
48,500
19
8
2
Joni Rantamäki
272,000
109
8
3
Charles-Eric Benoit
39,500
16
8
4
Jyrki Lampinen
73,500
29
8
5
Keito Kaljulaid
40,500
16
8
6
Kaspars Butans
53,000
21
8
8
Martin Köppl
83,000
33
9
1
Priit Oja
111,000
44
9
2
Georgios Tsouloftas
207,000
83
9
3
Raivo Pinsel
231,500
93
9
4
Seppo Parkkinen
38,000
15
9
5
Tapio Aaltonen
113,500
45
9
6
Giuseppe Rosa
61,000
24
9
7
Tero Hakanen
114,000
46
10
2
Maksim Petrov
165,000
66
10
3
Roberts Rumba
50,000
20
10
4
Mauro-Mark Musting
175,000
70
10
5
Santtu Leinonen
87,000
35
10
6
Atte Franssila
99,000
40
10
7
Viktors Semjonovs
50,500
20
10
8
Jesus Martinez Ucero
122,000
49
11
1
Rikard Relander
74,000
30
11
2
James Noonan
69,500
28
11
3
Ilari Sahamies
56,500
23
11
4
Herli Olop
36,500
15
11
5
Jan-Mikael Kesänen
157,500
63
11
6
Andrius Simonovicius
142,000
57
11
8
Kaspars Renga
56,000
22
12
1
Eriks Krumins
176,500
71
12
2
Arturs Sutens
137,000
55
12
4
Tornike Tchitadze
116,000
46
12
5
Martin Lategui
63,000
25
12
6
Artur Külanurk
189,000
76
12
7
Kare Hallamaa
218,500
87
12
8
Tarmo Tammel
290,000
116
13
1
Raido Tsmir
19,000
8
13
2
Christopher Berggren
109,500
44
13
3
Kris Tikka
50,000
20
13
5
Justus Kursi
121,500
49
13
6
Deividas Butnoras
155,500
62
13
7
Hendry Kullamäe
126,500
51
13
8
Max Avela
152,000
61
14
1
Kaido Kuusemäe
34,000
14
14
3
Akseli Paalanen
46,000
18
14
4
Ken Okada
51,000
20
14
5
Tomi Hietala
120,000
48
14
6
Marko Vest
28,500
11
14
7
Xiaolei Chen
101,500
41
14
8
Mairo Tori
57,500
23
15
1
Marko Härkönen
121,000
48
15
2
Josep Pastor De Ramon
162,000
65
15
4
Inigo Serrano Robles
31,500
13
15
5
Hendrik Uibo
149,000
60
15
6
Vincas Tamasauskas
65,000
26
15
7
Vadims Milovs
102,000
41
15
8
Stephen Groom
115,000
46
16
2
Martin Valent
140,000
56
16
3
David Asqino
125,500
50
16
4
Marek Selgeveer
84,000
34
16
5
Mark Metsla
181,000
72
16
6
Marco Kölle
190,000
76
16
7
Mario Linno
97,000
39
16
8
Agnius Ismailovas
175,000
70
17
1
Samuli Hietala
80,000
32
17
2
Ruslan Stserbjuk
169,500
68
17
3
Joshua Stewart
74,500
30
17
5
Touko Berndtson
219,000
88
17
6
Topi Palenius
20,500
8
17
7
Ermo Kosk
152,500
61
17
8
Kasper Mellanen
90,000
36
18
1
Teemu Sanaksenaho
57,500
23
18
2
Vygerdas Jonikas
147,000
59
18
3
Tomi Arponen
38,000
15
18
4
Dominik Ostrowski
50,500
20
18
5
Mustafa Biz
89,000
36
18
7
Roope Holma
52,000
21
18
8
Aigars Taukacs
149,500
60
19
2
Niko Petro
111,000
44
19
3
David Spysschaert
141,000
56
19
4
Anders Hansson
126,000
50
19
5
Jevgenijs Sapronenko
56,000
22
19
6
Hanna Heinlo
68,500
27
19
7
Giovanni Paolo Memola
99,500
40
19
8
Aleksi Naski
120,500
48
20
1
Vu Hoang Vuong
153,000
61
20
2
Jose Larios Domene
99,500
40
20
3
Davis Modans
92,000
37
20
5
Urmo Velvelt
293,000
117
20
6
Richard Koppel
127,500
51
20
7
Jordi Baixas
115,000
46
20
8
Roope Tarmi
233,500
93
21
1
Verneri Häkkinen
115,000
46
21
2
Stefan Bittger
41,000
16
21
3
Aleksei Smirnov
204,500
82
21
5
Gert Laanemets
91,000
36
21
6
Arturs Daugis
123,500
49
21
7
Tomasz Mroz
156,000
62
21
8
Benjamin Dixon
87,000
35
22
1
Jon Kyte
47,000
19
22
2
Rasmus Lundström
69,500
28
22
3
Kristo Erala
51,000
20
22
4
Mantas Ramanauskas
140,000
56
22
5
Konsta Heikkilä
92,000
37
22
6
Robin Palm
132,500
53
22
7
Arko Akenpärg
104,000
42
23
1
Antti Veerberk
147,000
59
23
2
Rasmus Eino
108,500
43
23
3
Joshua Marquardt
114,000
46
23
4
Amanullah Tahiri
120,000
48
23
5
Jorge Bravo
51,000
20
23
6
Niko Linnama
148,000
59
23
7
Karl Relander
115,000
46
24
2
Mauri Dorbek
109,500
44
24
3
Ranno Sootla
84,000
34
24
4
Aleksandr Arutjunov
99,000
40
24
5
Alius Riskevicius
60,000
24
24
6
Johannes Levola
80,000
32
24
7
Albert Gorelik
145,000
58
24
8
Sergei Aleksejev
40,500
16
25
1
Michele Tocci
52,500
21
25
2
Aurelijus Sipavicius
58,000
23
25
4
Tanaka Yusuke
145,000
58
25
5
Edgars Beizaks
34,500
14
25
6
Tommi Lankinen
102,000
41
25
7
Igor Pihela Jr.
210,000
84
25
8
Ramunas Mika
51,000
20
26
1
Rasmus Sepping
34,500
14
26
2
Damian Siewert
66,500
27
26
3
Kelly Kellner
108,500
43
26
4
Jaime Susarte
145,000
58
26
5
Kaido Mikk
51,000
20
26
6
Andrey Koks
127,000
51
26
8
Emanuele Mari
100,000
40
27
1
Toms Civcs
115,500
46
27
3
Verneri Sivula
49,500
20
27
4
Steven Tool
93,500
37
27
5
Kimmo Kurko
177,500
71
27
6
Eemil Tuominen
242,000
97
27
7
Joel Ylismäki
48,500
19
27
8
Kevin Karenius
74,500
30
28
1
Aleksei Gontsar
65,000
26
28
3
JonatanFors
297,000
119
28
4
Juho Suutari
251,500
101
28
5
Jose Koistinen
17,500
7
28
6
Max Rotko
129,500
52
28
7
Aleksandrs Kasincevs
126,000
50
28
8
Ville-Matti Keränen
66,000
26
29
1
Priit Vallap
190,500
76
29
2
Kai Lehto
102,500
41
29
3
Egon Kaljulaid
75,500
30
29
4
Kalle Salmela
98,500
39
29
5
Dmitri Dudakov
122,500
49
29
6
Eeti Löyttyniemi
118,000
47
29
8
Markku Koplimaa
26,000
10
30
1
Dmitrijs Meless
82,000
33
30
2
Stanislovas Norkus
81,500
33
30
3
Jimi Koponen
98,000
39
30
5
Andrius Bielskis
205,000
82
30
6
Lukasz Balbierz
83,500
33
30
7
Matus Fecisko
46,000
18
30
8
Glen Gaines
70,000
28
31
2
EinarHersdal
102,000
41
31
3
Juuso Elsinen
181,000
72
31
4
Lars Jonsson
191,000
76
31
5
Ignacio Gonzalez Garrido
75,000
30
31
6
Steven Seller
17,500
7
31
7
Igor Pihela Sr.
257,000
103
31
8
Quang Doan
92,000
37
32
1
Claudio Cecchi
100,000
40
32
2
Ori Hasson
71,500
29
32
3
Johan Martinsen
117,000
47
32
4
Morten Bremseth
100,000
40
32
5
Tomas Molcan
27,000
11
32
6
Christoffer Bering
98,000
39
32
7
Aleksander Lammas
47,500
19
33
1
Hai Hoang
165,000
66
33
2
Santeri Piiroinen
281,000
112
33
3
Nedas Nanys
164,000
66
33
5
Henri Antikainen
165,000
66
33
6
Antti Eeva
98,000
39
33
7
Adrians Imsa
105,000
42
33
8
Samuel Richards
194,500
78
34
1
Maciej Komorowski
115,500
46
34
2
Pekka Ikonen
203,500
81
34
3
Niki Nurmisto
44,000
18
34
4
Markuss Rukkalns
120,000
48
34
6
Baavo Pohlak
82,500
33
34
7
Min Ho Cho
42,500
17
34
8
Maruen Zormati
162,000
65
35
1
Rauno Remmel
30,000
12
35
2
Mikko Ylämäki
152,500
61
35
3
Juha Nikkola
88,500
35
35
5
Jun Beum Chun
246,000
98
35
6
Sami Suominen
27,000
11
35
7
Arthur Boatman
128,000
51
35
8
Kalle Parkkinen
29,500
12
36
1
Oskar Ojaveer
227,500
91
36
2
Pyry Kekäläinen
267,500
107
36
3
Saku Turtia
65,000
26
36
5
Julian Selinger
114,000
46
36
6
Joel Holmberg
318,000
127
36
7
Juha Elo
137,000
55
36
8
Yi-Zhan Peng
215,000
86
37
1
Bartlomiej Kijak
79,000
32
37
4
Hannes Praks
199,500
80
37
5
Ingus Arajs
161,000
64
37
6
Juha Helppi
123,000
49
37
7
Sten Talviste
30,000
12
37
8
Olafs Karlins
12,000
5
38
1
Jon Ander Martinez
205,500
82
38
2
Mathias Siljander
159,500
64
38
4
Steponas Venckus
34,000
14
38
5
Vilius Zabarauskas
101,500
41
38
6
Elias Vääräniemi
104,500
42
38
8
Ryan Mandara
42,000
17
39
2
Kert Hallik
70,000
28
39
3
Szymon Bujok
143,000
57
39
4
Sergejs Piratovs
71,000
28
39
5
Pavel Solodovnikov
92,500
37
39
7
Jani Haarala
58,000
23
39
8
Johan Erik Alen
33,500
13
40
2
Martin Sedlak
109,000
44
40
3
Risto Pärnat
86,000
34
40
5
Joona Ranta-Nilkku
66,500
27
40
6
Carl Halvarsson
60,000
24
40
7
Dan Korsunskyy
73,000
29
40
8
Aleksandr Jelpidiforov
65,000
26
41
1
Karlis Kreslins
75,000
30
41
2
Tadas Karosas
65,500
26
41
4
Kyösti Isberg
180,500
72
41
5
Matias Knaapinen
68,500
27
41
6
Valters Cernevskis
50,000
20
41
8
Eirimas Tomkevicius
137,000
55
23:55 (UTC+0)
Day 2 of WSOPC Tallinn Started Level: 11 Blinds: 1,000/2,500 Ante: 2,500
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.