0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0090 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/24/80/updates'
ORDER BY `views` DESC
0.0088 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/24/80/updates'
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '24'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
0.0230 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0040 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '76'
AND `published` = 1
0.0232 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0039 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '77'
AND `published` = 1
0.0235 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0036 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '78'
AND `published` = 1
0.0741 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '79'
AND `published` = 1
0.0781 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '80'
AND `published` = 1
0.0235 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '81'
AND `published` = 1
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '80'
ORDER BY `busted` ASC, `current_chips` DESC
0.0590 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` = '80'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3678'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3666'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3641'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3632'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3630'
ORDER BY `chip_change` DESC, `busted` ASC
0.0585 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3622'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3618'
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` = '3612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0592 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0677 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0688 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0289 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0971 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0783 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0783 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3573'
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` = '3574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0222 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3572'
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` = '3571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0625 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3570'
ORDER BY `chip_change` DESC, `busted` ASC
0.1101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0189 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0615 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0148 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0198 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0807 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0216 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0961 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0877 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0877 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0907 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0277 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0994 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3556'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0829 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0170 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0629 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0208 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0616 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0232 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3547'
ORDER BY `chip_change` DESC, `busted` ASC
0.2718 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0157 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3544'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0155 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0672 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3541'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3540'
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` = '3539'
ORDER BY `chip_change` DESC, `busted` ASC
0.0138 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0556 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3537'
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` = '3536'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '80'
ORDER BY `busted` ASC, `current_chips` DESC
0.0050 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` = '80'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3678'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3666'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3641'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0567 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3632'
ORDER BY `chip_change` DESC, `busted` ASC
0.0164 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3630'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0887 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0202 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3622'
ORDER BY `chip_change` DESC, `busted` ASC
0.2052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0580 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0161 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0632 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3595'
ORDER BY `chip_change` DESC, `busted` ASC
0.4742 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0269 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0832 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0713 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0224 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0222 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0803 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0747 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3578'
ORDER BY `chip_change` DESC, `busted` ASC
0.3287 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3576'
ORDER BY `chip_change` DESC, `busted` ASC
0.2782 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0205 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0851 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0222 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3572'
ORDER BY `chip_change` DESC, `busted` ASC
0.3002 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0644 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0132 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0177 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0154 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0754 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0843 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0140 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0133 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3563'
ORDER BY `chip_change` DESC, `busted` ASC
0.2995 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0721 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0159 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3559'
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` = '3558'
ORDER BY `chip_change` DESC, `busted` ASC
0.3676 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3556'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3555'
ORDER BY `chip_change` DESC, `busted` ASC
0.3798 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0173 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0131 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3551'
ORDER BY `chip_change` DESC, `busted` ASC
0.1765 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0142 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3549'
ORDER BY `chip_change` DESC, `busted` ASC
0.3084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3547'
ORDER BY `chip_change` DESC, `busted` ASC
0.0576 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3544'
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` = '3543'
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` = '3542'
ORDER BY `chip_change` DESC, `busted` ASC
0.1612 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3541'
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` = '3540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3539'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3537'
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` = '3536'
ORDER BY `chip_change` DESC, `busted` ASC
0.0133 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0584 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '81'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
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
Ελληνικά
Русский
Kings of Tallinn Summer Showdown 2023
2023 Tallinn Summer Showdown €555 Championship
Live Reporting - Day 3
Day 2 of Kings of Tallinn Summer Showdown 2023 Ended Level: 27 Blinds: 20,000/40,000 Ante: 40,000
Final Day Seat Draw and Chip Counts Posted Wednesday 26th July, 2023 at 03:35(UTC+2) by Jason Glatzer
"Did I end the day with the chip lead?" asked Juho Heiska (pictured below) as he was bagging chips.
Indeed he was with 2,390,000, but not by much with two players nipping at his heels in Henri Antikainen (2,365,000) and Raivo Pinsel (2,330,000).
While both Heiska and Antikainen both were sitting comfortably on more than 2 million for a while, Pinsel was nearly a short stack if not for a miracle river to eliminate Roope Tarmi.
Good night, and see you again when the cards are in the air for the final day on Wednesday at 12 p.m. Time will tell who will win the largest €555 Championship in Kings of Tallinn history and the huge €56,900 top prize.
Table
Seat
Player
Country
Chips
Big Blinds
11
2
Hendrik Diegenant
Belgium
975,000
20
11
3
Henri Antikainen
Finland
2,365,000
47
11
4
Raivo Pinsel
Estonia
2,330,000
47
11
5
Juho Heiska
Finland
2,390,000
48
11
6
Jevgenijs Sapronenko
Latvia
1,305,000
26
11
7
Dmitri Dudakov
Estonia
1,485,000
30
11
8
Maikel Homin
Estonia
535,000
11
12
1
Steven Seller
Estonia
654,000
13
12
2
Jonatan Fors
Finland
1,270,000
25
12
3
Janne Ojala
Finland
698,000
14
12
4
Philip Berggren
Sweden
655,000
13
12
5
Michailas Miserkejevas
Lithuania
1,405,000
28
12
6
Simon Forendal
Sweden
1,035,000
21
12
7
Kim Lindstrom
Finland
585,000
12
Pinsel Delivers Tarmi a Bad Beat to End Day 2 Posted Wednesday 26th July, 2023 at 01:23(UTC+2) by Jason Glatzer
Level 27: 20,000/50,000 (50,000) Entries: 14/573
Fireworks erupted at Table 12 with Roope Tarmi taking a bad beat after play was announced for the end of the night after the hand in play was concluded. Edvinas Tarasevicius got his short stack in with , with Tarmi happy to commit his stack with . Meanwhile, Raivo Pinsel had them both covered with .
Tarmi would have had an amazing end of the night if his cowboys could hold. Instead, he will be free to play another event tomorrow even though things seemed safe after the flop and the turn. However, the Pinsel celebrated after the spiked the river to give him a set of nines to eliminate both Tarasevicius and Tarmi to leave 14 players remaining when Day 3 begins on Wednesday at 12 p.m.
We will post the chip counts and seat draw for the final 14 players as soon as it is available.
Player
Chips
Progress
Raivo Pinsel
2,335,000
1,911,000
Edvinas Tarasevicius
0
0
Roope Tarmi
0
0
Play Paused After Napel Hit the Rail Posted Wednesday 26th July, 2023 at 01:08(UTC+2) by Jason Glatzer
Level 27: 20,000/40,000 (40,000) Entries: 16/573
Start of Day 2 chip leader Tobias Napel went deep in the €555 Championship only to lose his short stack near the end of the evening when his was no good against the held by Phillip Berggren.
The floor asked the other tables to stop after the hand they were as the day will end after one more hand at the two other tables.
Player
Chips
Progress
Phillip Berggren
655,000
526,500
Tobias Napel
0
0
Final Day 2 Blind Level Posted Wednesday 26th July, 2023 at 00:49(UTC+2) by Jason Glatzer
Day 2 has reached its final blind level of the evening. If two more players hit the rail, the day will end before the blind level is completed. Otherwise, the action will continue until the clock reads zero.
We will then come back fresh with a blow-by-blow account of every elimination and as many key hands as possible. More importantly, the players will be fresh thanks to this being a three-day event as opposed to a two-day event in the past. Great job by the management at Olympic Park Casino and our esteemed tournament director Teresa Nousiainen and it is easy to see why many players call the venue the most player-friendly casino in Europe.
00:45 (UTC+2)
Start of Level 27 Blinds: 20,000/40,000 Ante: 40,000
Event Info Posted Wednesday 26th July, 2023 at 00:26(UTC+2) by Jason Glatzer
We just learned that Day 2 will end the sooner of when the action is down to 16 players or the next break which is less than one hour. Surviving players will then resume their battle at 12 p.m. on Wednesday until a champion is crowned in this prestigious record-breaking event.
Arajs Doubles Through Tarmi Posted Wednesday 26th July, 2023 at 00:13(UTC+2) by Jason Glatzer
Level 26: 15,000/30,000 (30,000) Entries: 23/573
Roope Tarmi min-raised the button. Ingus Arajs (pictured below) three-bet jammed his short stack of 125,000 from the small blind and Tarmi quickly called.
Ingus Arajs: Roope Tarmi:
Arajs had a small equity advance and won the hand with top pair after the ran out on the board.
Player
Chips
Progress
Roope Tarmi
760,000
346,000
Ingus Arajs
310,000
140,000
00:02 (UTC+2)
Start of Level 26 Blinds: 15,000/30,000 Ante: 30,000
Two Pair for Smeljov Posted Tuesday 25th July, 2023 at 23:42(UTC+2) by Jason Glatzer
Level 25: 10,000/25,000 (25,000) Entries: 23/573
There wasn't much in the pot when Stanislav Smeljov check-jammed the for 160,000 for 160,000 over the continuation bet by Ingus Arajs from early position.
Stanislav Smeljov: Ingus Arajs:
It wasn't the worst of flops for Smeljov as he had two pair when the chips went in. Meanwhile, Arajs, despite being far behind, gained some additional equity on the turn with an open-ended straight draw. The river was no good for Arajs and Smeljov earned a double.
Player
Chips
Progress
Stanislav Smeljov
450,000
341,500
Ingus Arajs
450,000
90,000
23:23 (UTC+2)
Start of Level 25 Blinds: 10,000/25,000 Ante: 25,000
Break Time Posted Tuesday 25th July, 2023 at 23:08(UTC+2) by Jason Glatzer
Players are on a 15-minute break. Blinds will increase to 10,000/25,000 with a 25,000 big blind ante when the action resumes.
Players Cashing for €1,710 Posted Tuesday 25th July, 2023 at 23:05(UTC+2) by Jason Glatzer
The following players cashed for €1,710 in the €555 Championship. The final 24 players locked up at least a €2,010 payday.
Place
Player
Prize
25
Juan Carlos Vecino Duenas
€1,710
26
Anna-Mari Hursti
€1,710
27
Ermo Kosk
€1,710
28
Martins Sulte
€1,710
29
Mihhail Skola
€1,710
30
Johannes Tobbe
€1,710
31
Erikas Gordejevas
€1,710
32
Sondre Stormyr
€1,710
Player
Chips
Progress
Sondre Stormyr
0
0
Erikas Gordejevas
0
0
Johannes Hermann Tobbe
0
0
Mihhail Skola
0
0
Martins Sulte
0
0
Ermo Kosk
0
0
Anna-Mari Hursti
0
0
Juan Carlos Vecino Duenas
0
0
Parkkinen Applauds Homin's Bluff Posted Tuesday 25th July, 2023 at 22:29(UTC+2) by Jason Glatzer
Level 24: 10,000/20,000 (20,000) Entries: 25/573
Kalle Parkkinen checked the flop with about 100,000 in the pot. Maikel Homin bet 35,000 and Parkkinen raised to 125,000. Homin paused for a few moments before he called.
Homin checked the turn. Parkkinen fired out for 130,000 about 20 seconds later and Homin folded.
Parkkinen turned over the to show his bluff. Parkkinen responded with a small applause before the next hand was dealt.
Meanwhile, Juho Heiska keeps piling on chips and became the first player above 2 million. Anne-Mari Hursti shared earlier that she lost her decent stack of chips trying to pull a bluff on Heiska.
Player
Chips
Progress
Juho Heiska
2,100,000
1,150,000
Kalle Parkkinen
950,000
301,000
Maikel Homin
680,000
170,000
Anna-Mari Hursti
0
0
22:16 (UTC+2)
Start of Level 24 Blinds: 10,000/20,000 Ante: 20,000
Eliminated for €1,510 Posted Tuesday 25th July, 2023 at 21:39(UTC+2) by Jason Glatzer
The following players recently hit the rail. They all nearly tripled their €555 buy-in to bank a healthy €1,510 prize with the remaining 32 players guaranteed at least a €1,710 payout.
Place
Player
Prize
33
Erik Int
€1,510
34
Ignacio Garrido
€1,510
35
Romas Bassus
€1,510
36
Henri Schalin
€1,510
37
Tomi Arponen
€1,510
38
Kristjan Maasalu
€1,510
39
Nick Penning
€1,510
40
Ivar Simmer
€1,510
21:34 (UTC+2)
Start of Level 23 Blinds: 10,000/15,000 Ante: 15,000
Heiska Ousts Garrido Posted Tuesday 25th July, 2023 at 21:29(UTC+2) by Jason Glatzer
Level 22: 7,000/14,000 (12,000) Entries: 33/573
Ignacio Garrido jammed for about 6 big blinds from the small blind. Juho Heiska asked for a stack breakdown before he called from the big blind.
Juho Heiska: Ignacio Garrido:
Heiska pulled ahead after his ten connected with the flop. The turn added a few more outs for Garrido with now a queen that would improve Heiska to two more would improve Garrido to a straight. THe river completed the board and Garrido collected his payouts slip before leaving the tournament arena.
Player
Chips
Progress
Juho Heiska
950,000
41,000
Nick Penning
0
0
Tomi Arponen
0
0
Henri Schalin
0
0
Romas Bassus
0
0
Ignacio Garrido
0
0
WSOP Circuit Satellite at Midnight Posted Tuesday 25th July, 2023 at 21:14(UTC+2) by Jason Glatzer
The WSOP Circuit is heading to Olympic Park Casino where 12 coveted WSOP gold rings will be awarded across 11 days from Sept. 14-24.
With this in mind, Olympic Park Casino will celebrate alongside you with an added €120 satellite to the schedule tonight at midnight that was just announced that guarantees at least five seats to the WSOP Circuit Tallinn €1,500 Main Event.tel
We imagine there might be some added value here as it wasn't originally on the schedule and many players are busy playing other tournaments or cash games. That being said, keep this in mind if you bust out of an event as late registration is open for eight blind levels and won't close until after 2 a.m.
The first eight levels will boast 15-minute blind levels before things get even quicker from there with high-octane 10-minute blind levels. Best of luck to all the WSOP Circuit satellite players. Who knows, you can be among the first to punch your ticket to the most prestigious event in the history of Olympic Park Casino.
Action Resumes Posted Tuesday 25th July, 2023 at 21:07(UTC+2) by Jason Glatzer
The €555 Championship has resumed its action for Day 2 with blinds at 7,000/14,000 along with a 14,000 big blind ante.
Top Chip Stacks at Break Posted Tuesday 25th July, 2023 at 20:52(UTC+2) by Jason Glatzer
Place
Player
Chips
1
Henri Antikainen
1,335,000
2
Juho Heiska
991,000
3
Maikel Homin
850,000
4
Anna-Mari Hursti
847,000
5
Steven Seller
815,000
6
Dmitri Dudakov
791,000
7
Jonatan Fors
777,000
8
Tobias Napel
703,000
9
Kalle Parkkinen
649,000
10
Romas Bassus
581,000
11
Aleksi Lindholm
575,000
12
Espen Sandvik
522,000
13
Raivo Pinsel
424,000
14
Roope Tarmi
414,000
Player
Chips
Progress
Henri Antikainen
1,335,000
135,000
Juho Heiska
991,000
961,000
Maikel Homin
850,000
470,000
Anna-Mari Hursti
847,000
773,000
Steven Seller
815,000
520,000
Dmitri Dudakov
791,000
9,000
Jonatan Fors
777,000
427,000
Tobias Napel
703,000
353,000
Kalle Parkkinen
649,000
199,000
Romas Bassus
581,000
543,500
Aleksi Lindholm
575,000
315,000
Espen Sandvik
522,000
297,000
Raivo Pinsel
424,000
14,000
Roope Tarmi
414,000
114,000
20:52 (UTC+2)
Start of Level 22 Blinds: 7,000/14,000 Ante: 14,000
Cashed for €1,345 & Dinner Break Posted Tuesday 25th July, 2023 at 19:54(UTC+2) by Jason Glatzer
The following players cashed for €1,345 with Ivar Simmar becoming the first player to ladder up to €1,510 with his 40th place finish. The 39 remaining players just headed off to a one-hour dinner break. We will update some of the bigger stacks from around the room during the break.
Place
Player
Prize
41
Lawend Himmo
€1,345
42
Inigo Robles
€1,345
43
Markku Koplimaa
€1,345
44
Janne Nevalainen
€1,345
45
Jarno Salonen
€1,345
46
Dainius Kudarauskas
€1,345
47
James Noonan
€1,345
48
Marius Morel
€1,345
Player
Chips
Progress
Ivar Simmer
0
0
Marius Morel
0
0
James Noonan
0
0
Dainius Kudarauskas
0
0
Jarno Salonen
0
0
Janne Nevalainen
0
0
Markku Koplimaa
0
0
Inigo Robles
0
0
Lawend Himmo
0
0
Celebrity Event Introductions Posted Tuesday 25th July, 2023 at 19:48(UTC+2) by Jason Glatzer
Kings of Tallinn Summer Showdown Tournament Director Teresa Nousiainen and our festival's host Evely Pihela are introducing the celebrities for the €150 Celebrity Event.
This event always produces tons of energy and excitement. While we are focusing on the €555 Championship, there is a blog in Estonian that you can translate into English on this event.
Good luck to all the celebrities and players!
One Outer to a Royal for Antikainen to Oust Koplimaa Posted Tuesday 25th July, 2023 at 19:38(UTC+2) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 42/573
It's not every day you see a royal flush. It is even less likely to see the cooler that Markku Koplimaa (pictured above) just took in a hand against Henri Antikainen where he had a full house against his opponent's royal flush.
There were more than 600,000 in the pot preflop with Koplimaa at risk with his against Antikainen's .
Both players were alive and well after the flop before Koplimaa improved to what appeared to be an unbeatable hand after the turn improved his hand to a full house.
The was the only card in the deck that would send Koplimaa packing. Unfortunately, for the Estonian legend that is exactly what spiked the river and the table was in shock.
It was another incredible run for Koplimaa, who began the day with less than a starting stack. Koplimaa took it well and at least he will have a story to tell that he will unlikely forget for a while.
Meanwhile, Antikainen appeared to be in the chip lead after the hand with a huge stack of approximately 1,200,000 for around 100 big blinds.
Player
Chips
Progress
Henri Antikainen
1,200,000
1,143,500
Markku Koplimaa
0
0
Homin's Hand Caught in the Cookie Jar Posted Tuesday 25th July, 2023 at 19:29(UTC+2) by Jason Glatzer
Level 21: 6,000/12,000 (12,000) Entries: 44/573
Maikel Homen checked with the on the board after the river before Martins Sulte bet 39,000 into a pot of nearly 100,000. Homen raised to 130,000 and Sulte went into the tank before he jammed for not too much more.
We can only assume that Homen was bluffing as he didn't ask for a count. Neither player showed their hand and Sulte caught Homen's hand in the cookie jar to significantly increase his stack.
Player
Chips
Progress
Maikel Homin
380,000
240,000
Martins Sulte
330,000
279,500
Cashed for €1,210 Posted Tuesday 25th July, 2023 at 19:22(UTC+2) by Jason Glatzer
The following players cashed for €1,210 in the €555 Main Event. The remaining field each locked up. The final 48 players each locked up €1,345 after Vaclovas Galune hit the rail in 49th place.
Place
Player
Prize
49
Vaclovas Galaune
€1,210
50
Uku Valner
€1,210
51
Joel Lehtinen
€1,210
52
Miko Ylikoski
€1,210
53
Kristaps Renga
€1,210
54
Tanel Tammela
€1,210
55
Bartosz Wesolek
€1,210
56
Priit Vanem
€1,210
Player
Chips
Progress
Priit Vanem
0
0
Bartosz Wesolek
0
0
Tanel Tammela
0
0
Kristaps Renga
0
0
Miko Ylikoski
0
0
Joel Lehtinen
0
0
Uku Valner
0
0
Vaclovas Galaune
0
0
19:17 (UTC+2)
Start of Level 21 Blinds: 6,000/12,000 Ante: 12,000
Sandvik Doubles Duenas Posted Tuesday 25th July, 2023 at 19:05(UTC+2) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 50/573
Espen Sandvik three-bet squeezed the button over an opener and a caller before Juan Carlos Vecino Duenas four-bet shoved for 155,000 from the small blind. Everyone folded but Sandvik and the cards were turned over with Duenas at risk.
Juan Carlos Vecino Duenas: Espen Sandvik:
Sandvik had live cards to potentially eliminate Duenas but none of those cards came on the board for Duenas to stay alive and double his stack.
Player
Chips
Progress
Juan Carlos Vecino Duenas
330,000
145,000
Espen Sandvik
225,000
35,000
Cashing for €1,100 Posted Tuesday 25th July, 2023 at 18:55(UTC+2) by Jason Glatzer
The following players cashed for €1,100 in the €555 Championship.
Place
Player
Prize
57
Sami Saamanen
€1,100
58
Ville-Oskari Turja
€1,100
59
Tomas Mickus
€1,100
60
Elias Vaaraniemi
€1,100
61
Riku Koivurinne
€1,100
62
Yvonne Stiedl
€1,100
63
Thomas Haverstad
€1,100
64
Taago Tamm
€1,100
Player
Chips
Progress
Taago Tamm
0
0
Thomas Haverstad
0
0
Yvonne Stiedl
0
0
Riku Koivurinne
0
0
Elias Vaaraniemi
0
0
Tomas Mickus
0
0
Ville-Oskari Turja
0
0
Sami Saamanen
0
0
Min-Cashers Posted Tuesday 25th July, 2023 at 18:45(UTC+2) by Jason Glatzer
Players are enjoying themselves at the welcome drinks. The atmosphere is through the roof and players are enjoying chatting along with each other and the celebrities in attendance.
Meanwhile, the following players min-cashed the €555 Championship for €1,000 with Maksim Petrov (pictured below) the first player out for a full min-cash.
Place
Player
Prize
65
Julian Herold
€1,000
66
Risto Parnat
€1,000
67
Lucas Miguel Cravero
€1,000
68
Dino Dinler
€1,000
69
Alexander Aaneland
€1,000
70
Maksim Petrov
€1,000
Player
Chips
Progress
Maksim Petrov
0
0
Alexander Aaneland
0
0
Dino Dinler
0
0
Lucas Miguel Cravero
0
0
Risto Parnat
0
0
Julian Herold
0
0
18:35 (UTC+2)
Start of Level 20 Blinds: 5,000/10,000 Ante: 10,000
Two Players Out on the Bubble Posted Tuesday 25th July, 2023 at 18:26(UTC+2) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 70/573
Two players just hit the rail on the same hand during the money bubble and will split the €1,000 min-cash.
Paul Koppe was the first to go. He opened for three big blinds before calling off for around 20 big blinds in total facing a jam by Dmitri Dudakov.
Paul Koppe: Dmitri Dudakov:
Dudakov not only won the flip but also nailed a set of ducks on the .
The action then moved to one table over when this time big slick wasn't facing a flip but took a bad beat instead.
Most of the chips were in preflop before Jaarko Tirkkonen got the rest in on the flop. Kalle Parkkinen called and it was looking good for Tirkkonen to double his stack.
Jaarko Tirkkonen: Kalle Parkkinen:
Tirkkonen needed to fade a queen along with some backdoors. The spiked the turn and a couple of the players on the rail were calling for a king to get Tirkkonen back ahead. Instead, he hit the rail after the river completed the board.
We will take a short break from the coverage to run downstairs to check out the vibe from the welcome drinks but won't miss too much of the action.
Player
Chips
Progress
Dmitri Dudakov
800,000
290,000
Kalle Parkkinen
450,000
376,500
Paul Koppe
0
0
Jaarko Tirkkonen
0
0
Petrov Doubles on the Bubble Posted Tuesday 25th July, 2023 at 18:13(UTC+2) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 72/573
Maksim Petrov jammed for 27,000 from early position and was called by Amin Asikainen from the big blind.
Maksim Petrov: Amin Asikainen:
A crowd gathered before the ran out on the board to improve both players to a pair of kings. The ace-kicker did the job for Petrov for him to double his stack on the bubble.
Player
Chips
Progress
Amin Asikainen
330,000
270,000
Maksim Petrov
74,000
91,000
Bad Beat Near Bubble for Laurila Posted Tuesday 25th July, 2023 at 17:56(UTC+2) by Jason Glatzer
Level 19: 4,000/8,000 (8,000) Entries: 72/573
Tomi Arponen (pictured below) just hit the rail and the action is now hand-for-hand on the money bubble. Here is how it went down.
A player opened before Arponen three-bet jammed for 129,000. Tero Laurila asked for a count. He then tanked for ages before he called off his stack for a little less. The other player in the hand folded and it was a heads-up showdown with Laurila at risk.
Tero Laurila: Tomi Arponen:
Unfortunately for Laurila, his cowboys were unable to hold with Arponen connecting with his ace on the board.
Player
Chips
Progress
Tomi Arponen
240,000
174,000
Tero Laurila
0
0
Vygerdas Jonikas
0
0
Mario Colavita
0
0
17:44 (UTC+2)
Start of Level 19 Blinds: 4,000/8,000 Ante: 8,000
Break Time & Welcome Drinks Soon Posted Tuesday 25th July, 2023 at 17:30(UTC+2) by Jason Glatzer
Players are on a one-hour dinner break just two players away from the money with 73 players remaining and 71 players walking away with at least a €1,000 min-cash. As we explained earlier, players can upgrade their min-cash to a €1,100 Kings of Tallinn Main Event ticket if they so choose and gain an extra €100 in value for free.
Welcome drinks will also take place at 6 p.m. on the casino floor.
Sandvik Ousts Pfeiffer Near the Bubble Posted Tuesday 25th July, 2023 at 17:18(UTC+2) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 76/573
Espen Sandvik min-raised under the gun before Patrick Pfeiffer three-bet jammed his short stack of 28,000. Dmitri Dudakov cold-called from the small blind before Sandvik called as well.
Dudakov and Sandvik both checked the flop before Dudakov check-folded a bet of 27,000 by Sandvik on the turn. Immediately after this, Sandvik and Pfeiffer turned over their cards.
Patrick Pfeiffer: Espen Sandvik:
A blank came on the river and Pheiffer was eliminated shortly before the bubble.
Player
Chips
Progress
Dmitri Dudakov
510,000
50,000
Espen Sandvik
260,000
212,500
Ramunas Mika
0
0
Raffael Wadl
0
0
Patrick Pfeiffer
0
0
Tarmi Wins Big With Sevens Posted Tuesday 25th July, 2023 at 17:02(UTC+2) by Jason Glatzer
Level 18: 3,000/6,000 (6,000) Entries: 79/573
Roope Tarmi opened for a min-raise from under the gun before his opponent three-bet shoved from middle position. It folded around to Tarmi who snap-called and his opponent was flipping for his tournament life.
Opponent: Roope Tarmi:
His opponent tapped the table to represent "good game" after the flop improved to a set. All eyes were on the board after the turn gave him some life with a flush draw. However, Tarmi's opponent tapped the table again after he bricked the river and Tarmi won the hand with a full house.
Player
Chips
Progress
Roope Tarmi
300,000
43,000
Joshua Dittmann
0
0
Hyunsil Park
0
0
Igor Pihela Jr.
0
0
Christian Steinbo
0
0
Martin Piik
0
0
Indre Martoviciute
0
0
Jarkko Suokas
0
0
Yevhen Roshchebak
0
0
Steponas Venckus
0
0
Anders Auset
0
0
Paul Koppe
0
0
Dinner Break After This Blind Level Posted Tuesday 25th July, 2023 at 16:53(UTC+2) by Jason Glatzer
The blinds have just increased to 3,000/6,000 with a 6,000 big blind ante. After this level, players will go on a 60-minute dinner break. This also gives players enough time for the meet-and-greet welcome drinks at 6 p.m.
This reporter will be downstairs with his wife (and his notepad). Feel free to drop by with any stories about your experience we can share in the blog.
In other news, we are now just 10 players away from the money. It is possible the money bubble breaks before the dinner break but it might also be after.
16:51 (UTC+2)
Start of Level 18 Blinds: 3,000/6,000 Ante: 6,000
"I Bet Too Much on the Turn" Posted Tuesday 25th July, 2023 at 16:43(UTC+2) by Jason Glatzer
Level 17: 2,000/5,000 (5,000) Entries: 90/573
There were about 135,000 in the pot with the on the board after the turn when Paul Koppe checked. Dmitri Dudakov bet 65,000 and Koppe thought it over for a moment before he folded.
Koppe flashed the . Dudakov returned the favor and showed he flopped the nuts with .
"I bet too much on the turn," Dudakov said after the hand.
Player
Chips
Progress
Dmitri Dudakov
460,000
70,000
Paul Koppe
235,000
164,000
Orjan Skommo
0
0
Jani Tuovinen
0
0
Rene Krause
0
0
Tapio Vihakas
0
0
Rough River Card for Mellanen Posted Tuesday 25th July, 2023 at 16:31(UTC+2) by Jason Glatzer
Level 17: 2,000/5,000 (5,000) Entries: 94/573
Bartosz Wesolek opened for 10,000 from the hijack and was called by Tobias Napel before Kasper Mellanen three-bet jammed for 71,000. Wesolek four-bet shoved for about 185,000 and Napel folded.
Kasper Mellanen: Bartosz Wesolek:
Wesolek was ahead after the but began to count out his chips ready to pay off his opponent after Mellanen connected his jack on the turn. However, the river completed a gutshot straight draw for Wesolek to win the hand and eliminate Mellanen.
"Good game," Mellanen said politely with some sportsmanship before leaving the table.
Player
Chips
Progress
Bartosz Wesolek
270,000
182,500
Kasper Mellanen
0
0
Tonis Viik
0
0
Marko Vest
0
0
Xiaolei Chen
0
0
Henrik Veldhoen
0
0
Joacim Blom
0
0
Fabian Bartuschk
0
0
Enea Subashi
0
0
Tapio Aaltonen
0
0
16:15 (UTC+2)
Start of Level 17 Blinds: 2,000/5,000 Ante: 5,000
Record €56,900 Top Prize! Posted Tuesday 25th July, 2023 at 16:01(UTC+2) by Jason Glatzer
The payouts have been announced with tomorrow's winner going home with a €56,900 top prize, which is a new record for this event. Players that min-cash for €1,000 can opt to exchange their min-cash for something better as instead they can claim a Kings of Tallinn Summer Showdown Main Event seat valued at €1,100.
A total of 71 players will win at least a piece of the €269,310 prize pool. Check out all of the payouts below.
Place
Payout
1
€56,900
2
€38,450
3
€22,760
4
€16,620
5
€13,010
6
€9,770
7
€6,700
8
€4,930
9
€3,950
10
€3,300
11-12
€2,780
13-16
€2,320
17-24
€2,010
25-32
€1,710
33-40
€1,510
41-48
€1,345
49-56
€1,210
57-64
€1,100
65-71
€1,000
Ighanoussene Runs Into Nevalainen's Cowboys Posted Tuesday 25th July, 2023 at 15:54(UTC+2) by Jason Glatzer
Level 16: 2,000/4,000 (4,000) Entries: 105/573
Reda Ighanoussene three-bet jammed from the big blind and was called by Janne Nevalainen who opened from middle position.
Reda Ighanoussene: Janne Nevalainen:
Ighanoussene was unable to get ahead of Nevalainen's cowboys and hit the rail after the hit the board.
Meanwhile, the payouts were just announced. We will post the full payouts in five to ten minutes but in the meantime we will give a couple of spoilers. The top prize will be a record €56,900 with the top 71 players going home with at least a €1,000 min-cash. Min-cashers can also get even more value as they can choose to instead snag a Kings of Tallinn Summer Showdown €1,100 Main Event ticket instead of the min-cash for an extra €100 in value.
Player
Chips
Progress
Janne Nevalainen
240,000
140,000
Sander Leigri
0
0
Tarjei Forus
0
0
Nikita Padisaar
0
0
Jari Karkkainen
0
0
Reda Ighanoussene
0
0
15:34 (UTC+2)
Start of Level 16 Blinds: 2,000/4,000 Ante: 4,000
Big Stacks at Break Posted Tuesday 25th July, 2023 at 15:34(UTC+2) by Jason Glatzer
Here is a look at some of the bigger stacks from around the room. Also on the list below are the handful of players that hit the rail just before the break.
Player
Chips
Progress
Raffael Wadl
425,000
169,500
Raivo Pinsel
410,000
183,500
Dmitri Dudakov
390,000
298,000
Priit Vanem
375,000
290,000
Ingus Arajs
360,000
262,500
Jonatan Fors
350,000
287,500
Tobias Napel
350,000
12,000
Jaakko Tirkkonen
330,000
303,500
Simon Forendal
310,000
46,000
Steven Seller
295,000
134,500
Aleksi Lindholm
260,000
230,000
Leo Colin
0
0
Gytis Bernatavicius
0
0
David Lopez De Miguel
0
0
Joonas Siren
0
0
Alenas Pelegrimas
0
0
Siim Suviste
0
0
Marko Harkonen
0
0
Patrick Schratz
0
0
Second Break Posted Tuesday 25th July, 2023 at 15:09(UTC+2) by Jason Glatzer
Players are about to go on their second break. We will update some of the bigger stacks in the blog around the room during the break.
Expect some excitement outside the tournament area with more pineapple GGPoker Flip&Go Mystery Bounty flips taking place as they will all week long.
"Good Flip" Posted Tuesday 25th July, 2023 at 15:02(UTC+2) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 125/573
Janne Nevalainen min-raised the button. Alberto Gonzalez three-bet jammed for 10 big blinds from the small blind. Nevalainen went into the tank for more than a minute before he called.
Alberto Gonzalez: Janne Nevalainen:
Gonzalez was ahead but pulled even further in front after his ace connected on the flop. Nevalainen was drawing dead on the turn and the hand was made official after the river completed the board.
"Nice flip," Nevalainen said with a smile to Gonzalez.
Player
Chips
Progress
Janne Nevalainen
100,000
31,000
Alberto Gonzalez
65,000
20,000
Johannes Cleven
0
0
Totti Arosuo
0
0
Marko Vartinen
0
0
Karlis Kreilis
0
0
Mikko Ylamaki
0
0
Allan Pukk
0
0
Keito Kaljulaid
0
0
Venckus Hits His Deuce Posted Tuesday 25th July, 2023 at 14:49(UTC+2) by Jason Glatzer
Level 15: 1,500/3,000 (3,000) Entries: 135/573
Steponas Venckus jammed for seven big blinds from the cutoff. Doroslav Rasiukevitc asked for a count before he called.
Steponas Venckus: Doroslav Rasiukevic:
Rasiukevitc seemed less than thrilled to double his opponent after Venckus connected with his deuce on the board.
Meanwhile, the popular Herli Olop won't create a massive rail at the final table as he was one of the recent players to lose their stacks and head to the locker room.
Player
Chips
Progress
Doroslav Rasiukevitc
80,000
1,000
Steponas Venckus
50,000
22,000
Jussi Karpanen
0
0
Adria Comas I Roura
0
0
Georgi Abuladze
0
0
Herli Olop
0
0
Jordi Baixas
0
0
Aleksandr Kuperman
0
0
Rikard Relander
0
0
Martin Kalmus
0
0
Thor Dahlbeck
0
0
14:37 (UTC+2)
Start of Level 15 Blinds: 1,500/3,000 Ante: 3,000
A Lucky Trey Saves Kaljulaid Posted Tuesday 25th July, 2023 at 14:28(UTC+2) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 147/573
Keito Kaljulaid jammed for 23,500 from the hijack. Patrick Schratz fired out an isolation three-bet from the cutoff and the rest of the table folded.
Keito Kaljulaid: Patrick Schratz:
It was looking like Kaljulaid was about to head to the showers but instead, he delivered a bad beat to Schratz and doubled his stack after his trey found a friend on the board.
Meanwhile, local hero and WSOP bracelet winner Ranno Sootla hit the rail along with a handful of others.
Player
Chips
Progress
Keito Kaljulaid
65,000
26,000
Patrick Schratz
50,000
4,000
Knut Trulsen
0
0
Aurimas Stanevicius
0
0
Vlads Dolgilevics
0
0
Ranno Sootla
0
0
Kasparas Drazdauskas
0
0
Asikainen Wins a Flip Against Sootla Posted Tuesday 25th July, 2023 at 14:16(UTC+2) by Jason Glatzer
Level 14: 1,000/2,500 (2,500) Entries: 152/573
Amin Asikainen three-bet jammed for less than 10 big blinds over the open by Ranno Sootla. Sootla called and Asikainen was flipping for his tournament life.
Amin Asikainen: Ranno Sootla:
"Yes!" Asikainen said with a fist pump in the air after he won the hand with a better two pair on the runout to stay alive and double his stack.
Player
Chips
Progress
Amin Asikainen
60,000
43,000
Ranno Sootla
50,000
29,500
Priit Oja
0
0
Kent Roed
0
0
Miika Toyras
0
0
Aleksi Mikael Naski
0
0
Guillermo Cifuentes
0
0
14:03 (UTC+2)
Start of Level 14 Blinds: 1,000/2,500 Ante: 2,500
Galaune Felts Isosalo Posted Tuesday 25th July, 2023 at 14:00(UTC+2) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 163/573
Vaclovas Galaune opened for 4,000 from under the gun before Markus Isosalo jammed for 23,000 from the hijack. Maksim Petrov tanked for about a minute before he called from the small blind and Galune called as well.
Both Petrov and Galune checked the flop and checked again on the turn. Petrov checked again on the river and folded to a bet of 25,000 by Galune.
Isosalo turned over the for the top pair but he lost his stack to Galune who turned over the for the same top pair but a better kicker.
Meanwhile, we won't have a returning champion. Benjamin Gros won this event for €55,500 in February and late registered during Day 2. He just hit the rail meaning we will have a new trophy winner in this event.
Player
Chips
Progress
Maksim Petrov
165,000
4,500
Vaclovas Galaune
125,000
59,500
Rauno Remmel
0
0
Janne Nevalainen
0
0
Jukka Moisio
0
0
Peter Wieczorek
0
0
Benjamin Gros
0
0
Daragh Davey
0
0
Ranel Kasi
0
0
Elvinas Vitkevi_ius
0
0
Robert Rohr
0
0
Andrius Bielskis
0
0
Mikael Haapaniemi
0
0
Nils Linden
0
0
Mark Metsla
0
0
Ari Varonen
0
0
71 Players Paid Posted Tuesday 25th July, 2023 at 13:39(UTC+2) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 187/573
The payouts will be finalized shortly, but in the meantime, Tournament Director Teresa Nousiainen announced to the crowd that the €555 Championship will payout the top 71 players with hand-for-hand taking place during a table-balanced bubble.
Kindsigo Ousts Nikkels Posted Tuesday 25th July, 2023 at 13:36(UTC+2) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 187/573
Many of the short-stacked players are losing their stacks including Sjoerd Nikkels to Jaana Kindsigo as follows:
Kindsigo opened from early position for 4,500. Nikkels jammed for 7,500 from the button before Stanislav Smeljov went into the tank for about a minute from the big blind. Smeljov had one last look at Kindsigo's stack before he folded.
Sjoerd Nikkels: Jaana Kindsigo:
Neither player improved on the paired board. Kindsigo's jack-kicker came into play and Nikkels was on the rail.
Player
Chips
Progress
Jaana Kindsigo
135,000
35,000
Per Kasten
0
0
Maria Heilala
0
0
Carl Lockmer
0
0
Jonas Lapinskas
0
0
Pertti Salakari
0
0
Sjoerd Nikkels
0
0
Sandvik Runs Into Suviste's Full House Posted Tuesday 25th July, 2023 at 13:25(UTC+2) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 201/573
Espen Sandvik bet 15,000 into a pot of 30,000 with the on the board after the turn and was quickly called by Siim Suviste. Sandvik effectively jammed the river and Suviste's chips were in the pot a micro-second later for his entire stack of 39,500.
Sandvik tabled a strong two-pair with but lost a huge chunk of his stack with Suviste showing the for a flopped set before improving to a full house on the turn.
Player
Chips
Progress
Siim Suviste
140,000
84,500
Espen Sandvik
47,500
106,500
Saulius Tumosa
0
0
Eimantas Venckus
0
0
Rait Kaimer
0
0
New Kings of Tallinn Record! Posted Tuesday 25th July, 2023 at 13:16(UTC+2) by Jason Glatzer
Level 13: 1,000/2,000 (2,000) Entries: 204/573
Not only was the summer record set in the Kings of Tallinn Summer Showdown €555 Championship, but a new overall Kings of Tallinn record was established in this event with 573 entries creating a €269,310 prize pool.
This beat the previous record set in February with 559 entries getting into the mix before Benjamin Gros won the title for €55,500.
The payouts for this event will be announced soon.
13:15 (UTC+2)
Start of Level 13 Blinds: 1,000/2,000 Ante: 2,000
More Eliminations Before Break Posted Tuesday 25th July, 2023 at 13:02(UTC+2) by Jason Glatzer
Player
Chips
Progress
Sarosh Mir
0
0
Samuli Hietala
0
0
Jonas PedersenÊ
0
0
Markus Isosalo
0
0
Henri Antikainen
0
0
Igor Pihela
0
0
Ville Pohjalainen
0
0
Endre Oren
0
0
Break Time Posted Tuesday 25th July, 2023 at 12:46(UTC+2) by Jason Glatzer
Players are on a quick break with late registration closing as soon as the action resumes. The field was at 547 entries at the break and could break the overall Kings of Tallinn record set in February with just 13 more entries. Either way, this is a new summer record. Amazing job to the players!
Chen Propels Stack With Rockets Posted Tuesday 25th July, 2023 at 12:45(UTC+2) by Jason Glatzer
Level 12: 1,000/1,500 (1,500) Entries: 198/545
Romans Krasins open jammed for around 10 big blinds from early position. Xiaolei Chen, who began the day with just 11,500, three-bet shoved for a little less than 40,000 from one seat over and the rest of the table folded.
Roman Krasins: Xiaolei Chen:
Krasins got out of his seat on the flop and was drawing dead after Chen improved to a set on the turn. The river inconsequentially further improved Chen to a full house to win the hand for a great start of Day 2 for the Finn.
Player
Chips
Progress
Xiaolei Chen
60,000
48,500
Stefan Bittger
0
0
Peep Kivistik
0
0
Stefan Schrittwieser
0
0
Tarmo Tammel
0
0
Johan Ekdahl
0
0
Christian Arstad
0
0
Romans Krasins
0
0
Miserkejevas Felts Two Posted Tuesday 25th July, 2023 at 12:33(UTC+2) by Jason Glatzer
Level 12: 1,000/1,500 (1,500) Entries: 204/533
Michailas Miserkejevas just won a monster pot and eliminated two players as follows.
Andzej Zinkevic bet 20,000 into a pot of around double that on the flop. Miserkejevas min-clicked to 40,000 before Erikas Gordejevas four-bet shoved for around 80,000. Zinkevic instantly called off for a little less and it was a three-way showdown after Miserkejevas snap-called as well.
Erikas Gordejevas: Andzej Zinkevic: Michailas Miserkejevas:
Miserkejevas got it in good with his bottom set but had to fade some cards if he wanted to eliminate two players and add tons of chips to his stack with Gordejevas holding an overpair and Zinkevic needing a spade to complete a flush. Blanks came for both of his opponents on the turn and the river to take down the pot.
A handful of other players lost their stacks as you can tell from the chip count update below. Some of these players may re-enter as they still have a bit of time to do so with the first blind level of the day about halfway through.
Player
Chips
Progress
Michailas Miserkejevas
390,000
205,500
Erikas Gordejevas
0
0
Rein Ingland
0
0
Anu Lilja
0
0
Ahmed Al-Naji
0
0
Erik Borkvik
0
0
Tommy Olavi Piironen
0
0
Andzej Zinkevic
0
0
Alberto Gonzalez
0
0
Erik Borkvik
0
0
Edvinas Tarasevicius
0
0
Vytautas Kacerauskas
0
0
Oskar Ojaveer
0
0
Edgars Beizaks
0
0
Saara Ylianttila
0
0
Jari Lahtinen
0
0
Kristjan Kuning
0
0
Andrey Koks
0
0
Donatas Pilinkus
0
0
Al-Naji Doubles With Sevens Posted Tuesday 25th July, 2023 at 12:14(UTC+2) by Jason Glatzer
Level 12: 1,000/1,500 (1,500) Entries: 211/525
Alexander Aaneland opened for 2,500 from middle position before he called a three-bet jam by Ahmed Al-Naji to 27,000 from the cutoff.
Ahmed Al-Naji: Alexander Aaneland:
Al-Naji was safe after the flop but the turn opened up a ton of draws with a ten completing Broadway and any club completing a flush. Aaneland's king and queen were both live as well but lost a chunk of his stack by doubling Al-Naji after a blank river completed the board.
Player
Chips
Progress
Ahmed Al-Naji
58,500
28,500
Alexander Aaneland
35,000
28,500
Cards in the Air Posted Tuesday 25th July, 2023 at 12:06(UTC+2) by Jason Glatzer
Level 12: 1,000/1,500 (1,500) Entries: 208/522
Cards are in the air to start Day 2 with already 22 new entries getting into the mix. This figure will continue to grow throughout the opening blind level with late registration closing before the start of Level 13.
Welcome to Day 2 of the €555 Championship Posted Tuesday 25th July, 2023 at 08:55(UTC+2) by Jason Glatzer
Welcome to the second of the three-day €555 Championship at the Kings of Tallinn Summer Showdown at Olympic Park Casino and the adjoining Hilton Tallinn Park.
Today will be an action-packed day full of excitement as the action will play down to a final table of just nine hopefuls. Blinds will start at 800/1,600 with a 1,600 big blind ante and increase every 40 minutes throughout the day.
There were exactly 500 entries to get into the action during the four opening flights taking place over the past couple of days to add €235,000 to the prize pool. This is already shattered attendance records for the Kings of Tallinn Summer Showdown and is approaching the record for the Kings of Tallinn brand altogether that was set in February when 559 entries came out in full force before France's Benjamin Gros won the title for €55,500.
More players will still get involved with late registration and re-entries permitted until the start of the second blind level of the day. With plenty of short stacks in play, expect some mayhem to start off the day. The payouts will be announced shortly after late registration is closed.
Netherlands' Tobias Napel (pictured above) leads the way entering today's action over the 186 opening day survivors after parlaying his 30,000 opening stack into a massive pile of 338,000 in chips.
Top 10 Chip Counts
Place
Player
Country
Chips
Big Blinds
1
Tobias Napel
Netherlands
338,000
211
2
Simon Forendal
Sweden
264,000
165
3
Roope Tarmi
Finland
257,000
161
4
Raffael Wadl
Austria
255,500
160
5
Raivo Pinsel
Estonia
226,500
142
6
Taago Tamm
Estonia
212,000
133
7
Sami Saamanen
Finland
206,500
129
8
Ivar Simmer
Estonia
191,500
120
9
Tanel Tammela
Estonia
186,500
117
10
Juan Carlos Vecino Duenas
Spain
185,000
116
Cards are in the air at noon and we will be right alongside you reporting the action throughout the day.
Day 2 Seat Draw Posted Tuesday 25th July, 2023 at 08:21(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Raffael Wadl
255,500
160
1
2
Kim Lindstrom
67,500
42
1
3
Herli Olop
34,000
21
1
4
Christian Steinbo
35,000
22
1
6
Endre Vigdal Oren
118,000
74
1
7
Oskar Ojaveer
40,000
25
1
8
Mark Metsla
44,000
28
1
9
Per Kasten
62,500
39
2
1
Ingus Arajs
97,500
61
2
2
Rene Krause
64,000
40
2
3
Gytis Bernatavicius
97,000
61
2
5
Robert Rohr
34,500
22
2
6
Tanel Tammela
186,500
117
2
7
Aleksandr Kuperman
39,000
24
2
8
Miika Toyras
32,000
20
2
9
Mikko Ylamaki
55,000
34
3
1
Ari Varonen
83,500
52
3
2
Anu Lilja
14,500
9
3
4
Indre Martoviciute
87,500
55
3
5
Kristjan Kuning
46,500
29
3
6
Bartosz Wesolek
87,500
55
3
7
Paul Koppe
71,000
44
3
8
Rauno Remmel
70,000
44
4
2
Johan Ekdahl
43,500
27
4
3
Rein Ingland
22,000
14
4
4
Kalle Elmeri Parkkinen
73,500
46
4
5
Johannes Tobbe
52,500
33
4
6
Keito Kaljulaid
39,000
24
4
7
Aurimas Stanevicius
44,000
28
4
8
Allan Pukk
77,500
48
4
9
Igor Pihela
127,000
79
5
1
Rait Kaimer
61,500
38
5
3
Tomas Mickus
165,000
103
5
4
Igor Pihela Jun.
92,500
58
5
5
Thomas Haverstad
80,500
50
5
6
David Lopez De Miguel
84,000
53
5
7
Maksim Petrov
169,500
106
5
8
Ramunas Mika
131,000
82
5
9
Marko Vartinen
91,000
57
6
1
Jani Tuovinen
56,500
35
6
2
Markku Koplimaa
25,000
16
6
3
Romas Bassus
37,500
23
6
5
Vlads Dolgilevics
102,000
64
6
6
Joacim Blom
90,500
57
6
7
Julian Herold
111,000
69
6
8
Anders Christiansen
25,500
16
6
9
Thor Dahlbeck
97,000
61
7
1
Yevhen Roshchebak
104,500
65
7
2
Andzej Zinkevic
49,500
31
7
3
Michailas Miserkejevas
184,500
115
7
5
Jari Lahtinen
51,500
32
7
6
Tommy Piironen
87,000
54
7
7
Erikas Gordejevas
135,500
85
7
8
Simon Forendal
264,000
165
7
9
Mikael Haapaniemi
47,500
30
8
1
Priit Vanem
85,000
53
8
2
Miko Ylikoski
104,500
65
8
4
Xiaolei Chen
11,500
7
8
5
Yvonne Stiedl
148,000
93
8
6
Stefan Bittger
32,000
20
8
7
Kristaps Renga
43,000
27
8
8
Stanislav Smeljov
108,500
68
8
9
Henri Antikainen
56,500
35
9
1
Henrik Veldhoen
102,000
64
9
2
Kristjan Maasalu
68,000
43
9
3
Patrick Schratz
54,000
34
9
4
Marko Härkönen
59,000
37
9
5
Elias Oskari Vääräniemi
64,000
40
9
7
Sondre Stormyr
140,000
88
9
8
Erik Int
107,000
67
9
9
Sarosh Mir
75,000
47
10
2
Kent Roed
38,500
24
10
3
Bo Berggren
128,500
80
10
4
Hendrik Diegenant
73,000
46
10
5
Martin Muller
52,500
33
10
6
Tapio Aaltonen
69,000
43
10
7
Saulius Tumosa
144,000
90
10
8
Lawend Himmo
31,000
19
10
9
Andrius Bielskis
55,000
34
11
1
Johannes Cleven
77,500
48
11
2
Siim Suviste
55,500
35
11
3
Jordi Baixas
39,500
25
11
5
Jussi Karpanen
41,000
26
11
6
Espen Sandvik
154,000
96
11
7
Juan Carlos Vecino Duenas
185,000
116
11
8
Roope Tarmi
257,000
161
11
9
Patrick Pfeiffer
91,000
57
12
1
Marko Vest
29,000
18
12
2
Anton Pereyaslov
147,000
92
12
3
Ranno Sootla
20,500
13
12
5
Edgars Beizaks
18,500
12
12
7
Tonis Viik
82,000
51
12
8
Jari Karkkainen
62,500
39
12
9
Tapio Vihakas
37,000
23
13
2
Priit Oja
55,500
35
13
3
Henri Schalin
80,000
50
13
4
Steponas Venckus
28,000
18
13
5
Mihhail Skola
95,500
60
13
6
Ranel Kasi
48,500
30
13
7
Doroslav Rasiukevitc
79,000
49
13
8
Jonas Pedersen
31,500
20
13
9
Saara Ylianttila
55,000
34
14
2
Reda Ighanoussene
29,000
18
14
3
Vygerdas Jonikas
125,500
78
14
4
Maria Heilala
65,000
41
14
5
Lucas Cravero
92,500
58
14
6
Janne Nevalainen
69,000
43
14
7
Alexander Aaneland
63,500
40
14
8
Donatas Pilinkus
27,000
17
14
9
Ville Pohjalainen
34,000
21
15
1
Elvinas Vitkevi?ius
85,500
53
15
3
Nils Linden
36,500
23
15
4
Enea Subashi
67,500
42
15
5
Peter Wieczorek
19,000
12
15
6
Anna-Mari Hursti
74,000
46
15
7
Jonas Lapinskas
41,500
26
15
8
Jevgenijs Sapronenko
141,500
88
15
9
Rikard Relander
66,500
42
16
1
Tero Laurila
31,500
20
16
2
Joshua Dittmann
83,500
52
16
3
Ville-Oskari Sebastian Turja
120,000
75
16
4
Leo Colin
41,500
26
16
7
Christian Arstad
27,500
17
16
8
Jukka Moisio
10,500
7
16
9
Stefan Schrittwieser
31,000
19
17
1
Peep Kivistik
55,000
34
17
2
Guillermo Gordo Cifuentes
77,500
48
17
3
Hyunsil Park
60,500
38
17
4
Fabian Bartuschk
109,500
68
17
5
Martins Sulte
50,500
32
17
7
Steven Seller
160,500
100
17
8
Kaido Mikk
17,000
11
17
9
Jarkko Juhani Suokas
135,500
85
18
1
Tomi Arponen
66,000
41
18
2
Pertti Salakari
90,500
57
18
3
Taago Tamm
212,000
133
18
5
Markus Isosalo
39,000
24
18
6
Maikel Homin
140,000
88
18
7
Raivo Pinsel
226,500
142
18
9
Uku Valner
45,000
28
19
1
Jonatan Fors
62,500
39
19
2
Sami Saamanen
206,500
129
19
3
Joonas Siren
71,500
45
19
4
Carl Lockmer
90,000
56
19
5
Samuli Hietala
69,500
43
19
6
Knut Trulsen
57,000
36
19
8
Alberto Gonzalez
45,000
28
19
9
James Noonan
172,000
108
20
1
Alenas Pelegrimas
47,500
30
20
3
Tobias Napel
338,000
211
20
4
Georgi Abuladze
72,500
45
20
5
Riku Koivurinne
36,000
23
20
6
Edvinas Tarasevicius
24,500
15
20
7
Aleksi Mikael Naski
123,500
77
20
8
Ignacio Garrido
66,000
41
20
9
Ermo Kosk
71,500
45
21
1
Sander Leigri
46,500
29
21
2
Mario Colavita
171,500
107
21
3
Joel Lehtinen
78,500
49
21
4
Tarmo Tammel
25,000
16
21
5
Eimantas Venckus
24,000
15
21
6
Vytautas Kacerauskas
11,500
7
21
7
Marius Morel
56,500
35
21
9
Kasparas Drazdauskas
56,500
35
22
1
Ivar Simmer
191,500
120
22
3
Jaakko Tirkkonen
26,500
17
22
4
Nick Penning
172,500
108
22
5
Anders Auset
150,000
94
22
6
Adria Comas I Roura
78,500
49
22
8
Karlis Kreilis
53,000
33
22
9
Nikita Padisaar
102,500
64
34
1
Jaana Kindsigo
100,000
63
34
2
Martin Kalmus
23,500
15
34
5
Risto Parnat
75,000
47
34
6
Orjan Skommo
51,000
32
34
7
Vaclovas Galaune
65,500
41
34
8
Amin Asikainen
17,000
11
34
9
Kasper Mellanen
111,000
69
36
1
Martin Piik
83,000
52
36
3
Erik Borkvik
53,500
33
36
4
Dmitri Dudakov
92,000
58
36
5
Andrey Koks
39,500
25
36
6
Dainius Kudarauskas
110,000
69
36
7
Tarjei Forus
75,500
47
36
8
Inigo Robles
80,000
50
36
9
Vasilij Barna
131,500
82
08:21 (UTC+2)
Day 2 of Kings of Tallinn Summer Showdown 2023 Started Level: 12 Blinds: 800/1,600 Ante: 1,600
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.
, with Tarmi happy to commit his stack with 
. Meanwhile, Raivo Pinsel had them both covered with 
.
flop and the 
turn. However, the Pinsel celebrated after the 
spiked the river to give him a set of nines to eliminate both Tarasevicius and Tarmi to leave 14 players remaining when Day 3 begins on Wednesday at 12 p.m.
was no good against the 
held by Phillip Berggren.
ran out on the board.
for 160,000 for 160,000 over the continuation bet by Ingus Arajs from early position.
flop with about 100,000 in the pot. Maikel Homin bet 35,000 and Parkkinen raised to 125,000. Homin paused for a few moments before he called.
river completed the board and Garrido collected his payouts slip before leaving the tournament arena.
was the only card in the deck that would send Koplimaa packing. Unfortunately, for the Estonian legend that is exactly what spiked the river and the table was in shock.
.
flop before Dudakov check-folded a bet of 27,000 by Sandvik on the 
river completed the board.
for a flopped set before improving to a full house on the turn.
