0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0125 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/212'
ORDER BY `views` DESC
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '212'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'
0.0269 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` = '455'
AND `published` = 1
0.0268 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '457'
AND `published` = 1
0.0269 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '460'
AND `published` = 1
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '460'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 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` = '460'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19615'
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` = '19614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19608'
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` = '19606'
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` = '19605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19601'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19600'
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` = '19598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19589'
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` = '19588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19582'
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` = '19581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19558'
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` = '19555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19547'
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` = '19545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19539'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19534'
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` = '19531'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19528'
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` = '19524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19522'
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` = '19520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19519'
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` = '19514'
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` = '19512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19507'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19503'
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` = '19499'
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` = '19497'
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` = '19495'
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` = '19494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19492'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19491'
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` = '19487'
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` = '19486'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19483'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19482'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19481'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19479'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19474'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19470'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19468'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19464'
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` = '19461'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19460'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19459'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19458'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19456'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19452'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19453'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '457'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '460'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '460'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19610'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19606'
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` = '19605'
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` = '19601'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19586'
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` = '19584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19567'
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` = '19566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19558'
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` = '19555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19548'
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` = '19547'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19542'
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` = '19540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19539'
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` = '19535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19531'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19519'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19514'
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` = '19512'
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` = '19511'
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` = '19510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19507'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19503'
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` = '19499'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19497'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19495'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19492'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19491'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19487'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19486'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19483'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19482'
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` = '19481'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19479'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19474'
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` = '19471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19470'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19468'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19464'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19461'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19460'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19459'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19458'
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` = '19456'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19452'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19453'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '460'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
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 Autumn Edition 2024
Event #31: Kings of Tallinn €1,100 Main Event
Live Reporting - Day 4
Kings of Tallinn Autumn Edition 2024 - Live Reporting
Day 4 of Kings of Tallinn Autumn Edition 2024 Ended Level: 34 Blinds: 125,000/250,000 Ante: 250,000
Matias Siljander Crowned Champion After Incredible Comeback in First-Ever Kings of Tallinn: Autumn Edition Main Event (€130,300) Posted Sunday 27th October, 2024 at 22:48(UTC+0) by Frank Visser
For many a poker player, winning a Main Event is the stuff of dreams. The glory, trophy, and of course the loads of cash that come with victory encapsulate everything a tournament player is after. However, for Matias Siljander it seemed to be just another day at the office at Olympic Park Casino. He sat down for his sixth Main Event final table at the venue, and, like he had done twice before, came out on top as the victor.
Siljander captured his first official Kings of Tallinn Main Event trophy at the Autumn Edition and won €130,300, his best-ever score and first six-figure one. He started his heads-up battle against fellow Finnish grinder Elias Suhonen with a one-to-six chip disadvantage but managed to turn it around to ultimately be crowned the champion.
Siljander and Suhonen were part of the same team in the iconic Kings of Tallinn team competition. Each team consists of a maximum of four players, so to have two of them navigate the field of 701 entries to end up heads-up is a remarkable feat. However, while the valuable points they earned for their team resulted in some extra cash, it must have felt like just a bonus to the gargantuan sums they walked away with in the Main Event, with Suhonen's runner-up performance netting him a not-too-shabby €83,400.
Meanwhile, Greek player Enea Subashi took home the third-largest share of the €658,940 prize pool, with the €55,200 bronze medal tripling his total live earnings. Ukrainians Vasyl Laba and Serhii Leonov completed the top five, both hauling career-best scores as well.
€1,100 Main Event Final Table Results
Rank
Player
Country
Prize
1
Mathias Siljander
Finland
€130,300
2
Elias Suhonen
Finland
€83,400
3
Enea Subashi
Greece
€55,200
4
Vasyl Laba
Ukraine
€40,250
5
Serhii Leonov
Ukraine
€30,450
6
Aku-Oskari Uotila
Finland
€22,540
7
Daniel Clifford
Sweden
€17,400
8
Ruslan Stserbjuk
Estonia
€14,400
9
Simon Hassan
Sweden
€11,800
Day 4 Action
With the final nine returning to the table with an average stack of 60 big blinds, it was no surprise that the day started slowly. In fact, two levels went by without any eliminations, and not much had changed when the first break had been reached. Start-of-day chipleader Leonov still sat at the top, while short stacks Subashi and Simon Hassan remained at the bottom.
After the break, the fireworks finally kicked off. Hassan was the first to be eliminated when he got his top pair in against Subashi on the turn. Subashi had the same pair but rivered two pair to provide a sour exit in ninth for Hassan. About an hour later, Estonia's last hope Ruslan Stserbjuk got his chips in preflop with kings. He was up against the ace-king of Suhonen in a huge cooler. Suhonen spiked an ace on the flop to take down the pot, take over the chip lead, and eliminate Stserbjuk in eighth.
Stserbjuk's exit may have been sour, but it paled in comparison to Daniel Clifford's. Clifford had made a full house on the river and shoved in all of his chips. However, Suhonen had made a straight flush on the turn, knocking out the disillusioned Clifford in eighth place. Aku-Oskari Uotila was next in line to get coolered by Suhonen. He had rivered jacks full of aces but Suhonen had the last jack in his hand and eliminated his fellow countryman in sixth.
At that point, Suhonen had created a huge gap between him and Subashi in second place. Subashi closed the gap a bit by eliminating Leonov in fifth place with jacks against tens, only to see Suhonen knock out Laba in fourth in a preflop flip not much later, undoing his gains.
Short-Handed Play
Three-handed play lasted for two hours. It was here where Subashi, who had been relatively quiet up until that point, unleashed relentless aggression upon his two Finnish opponents, netting him a sizable chip lead. However, as he lived by the sword, he would die by the sword. After pulling off several successful bluffs, Subashi fired three streets with ace-high against Suhonen. Suhonen called down with top pair to reclaim his lead.
Not much later, Subashi called down with top pair against Suhonen's trips, leaving him with just ten big blinds. After a few orbits, he committed those to the middle and lost them to his nemesis as well.
By knocking out Subashi in third place, Suhonen started the heads-up match with a gigantic chip advantage. He had nearly 18 million chips at his disposal while Siljander was stuck with three million. However, Siljander quickly doubled up with a flush against a straight, after which he won the majority of pots to balance the chip counts evenly.
After some back-and-forth, Siljander finally created a gap with Suhonen when he called his triple barrel bluff with two pair. Suhonen started to mount a comeback from his one-to-four disadvantage, but ultimately the tournament ended like so many others: the players got it in the middle in a preflop flip. Siljander's ace-king made top pair against Suhonen's pocket tens, crowning him the Kings of Tallinn: Autumn Edition Main Event champion.
That concludes the live coverage of Kings of Tallinn: Autumn edition. However, the organization of renowned tournament series has more in store in the near future.
The Kings are stepping foot outside Estonia for the very first time as Kings of Vilnius takes place in the Lithuanian capital from November 15 to November 24, with a €250,000 guarantee Main Event.
Next up is the ladies-only Queens of Tallinn. The event returns to Olympic Park Casino from November 28 to December 1 after a successful first edition last year.
Last, but certainly not least, is the 10th Anniversary of Kings of Tallinn, which is already confirmed for February 21 to March 2 at the same Olympic Park Casino. The schedule is not yet known, but no doubt that more information will be made public soon.
Stay tuned for information and coverage of all the events above as the enthusiastic Baltic and Scandinavian poker scenes never rest.
Elias Suhonen Eliminated in 2nd Place (€83,400) Posted Sunday 27th October, 2024 at 19:48(UTC+0) by Frank Visser
Elias Suhonen raised his button to 600,000. Mathias Siljander then three-bet to 1,800,000 from the big blind, after which Suhonen moved all in for 7,500,000.
Siljander snap-called and the cards hit their backs.
Elias Suhonen: Mathias Siljander:
It looked like Suhonen's comeback would be completed when the flop and turn remained safe for him. However, the river brought the for Siljander's ace-king to river the best pair.
The opponents shared a handshake before Suhonen left the stage to pick up his runner-up cash.
Player
Chips
Progress
Mathias Siljander
21,025,000
7,000,000
Elias Suhonen
0
0
Suhonen Bluffs Siljander Posted Sunday 27th October, 2024 at 19:42(UTC+0) by Frank Visser
Elias Suhonen raised his button to 600,000 with and was called by Mathias Siljander in the big blind, who had . Siljander checked to Suhonen, who bet 1,000,000.
Siljander raised his arms in the air and correctly folded his bottom pair.
Player
Chips
Progress
Mathias Siljander
15,425,000
1,600,000
Elias Suhonen
5,600,000
1,600,000
19:30 (UTC+0)
Start of Level 34 Blinds: 125,000/250,000 Ante: 250,000
Siljander Takes Huge Lead Posted Sunday 27th October, 2024 at 19:23(UTC+0) by Frank Visser
Mathias Siljander raised his button to 400,000 with and saw Elias Suhonen three-bet to 1,400,000 in the big blind with . He called to the flop, where Suhonen fired a bet of 800,000.
Siljander called to the turn, where he was faced with a bet of 2,200,000. Once again, he called, and the hit the river. Suhonen spent a while in the tank before sliding in a bet of 2,000,000.
Siljander also thought for a while before pushing all in. Suhonen snap-folded his bluff as Siljander took a four-to-one lead with his two pair.
Player
Chips
Progress
Mathias Siljander
17,025,000
6,000,000
Elias Suhonen
4,000,000
6,000,000
Both Back to Eight Figures Posted Sunday 27th October, 2024 at 19:15(UTC+0) by Frank Visser
Mathias Siljander raised his button to 400,000 and Elias Suhonen called in the big blind.
The flop and turn were checked before Siljander fired 300,000 on the river. After some thought, Suhonen called with and won the pot against Siljander's .
Player
Chips
Progress
Mathias Siljander
11,025,000
1,600,000
Elias Suhonen
10,000,000
1,600,000
Siljander Creates Gap Again Posted Sunday 27th October, 2024 at 19:01(UTC+0) by Frank Visser
Mathias Siljander raised his button to 400,000 with and saw Elias Suhonen call in the big blind with .
The flop then checked through before Suhonen check-called 300,000 on the turn. The river saw Siljander size up to 1,100,000, which Suhonen quickly check-folded to.
Player
Chips
Progress
Mathias Siljander
12,625,000
1,900,000
Elias Suhonen
8,400,000
1,900,000
Suhonen Brings It Back Posted Sunday 27th October, 2024 at 18:57(UTC+0) by Frank Visser
Mathias Siljander raised his button to 400,000 with and Elias Suhonen called in the big blind with . He then checked the flop before raising Siljander's bet of 350,000 to 1,100,000.
Siljander tossed in a quick call but folded to Suhonen's bet of 1,600,000 on the turn.
Player
Chips
Progress
Mathias Siljander
10,725,000
1,500,000
Elias Suhonen
10,300,000
1,500,000
Suhonen Fires More Into Siljander's Stack Posted Sunday 27th October, 2024 at 18:53(UTC+0) by Frank Visser
Elias Suhonen raised to 500,000 on the button and saw Mathias Siljander call in the big blind. He continued for 300,000 on the flop, which Siljander check-called.
The turn checked through to the river, where Siljander bet 800,000. Suhonen wisely folded his pair as Siljander's lead grew.
Player
Chips
Progress
Mathias Siljander
12,225,000
600,000
Elias Suhonen
8,800,000
600,000
Suhonen Three-Bets Into Kings Posted Sunday 27th October, 2024 at 18:49(UTC+0) by Frank Visser
Mathias Siljander raised his button to 400,000 with . Elias Suhonen then three-bet to 1,400,000 in the big blind with , only to be four-bet by Siljander.
Suhonen quickly folded his jack-high to the three-million bet and saw Siljander take a noticeable lead.
Player
Chips
Progress
Mathias Siljander
11,625,000
625,000
Elias Suhonen
9,400,000
625,000
Siljander Makes It Even Posted Sunday 27th October, 2024 at 18:40(UTC+0) by Frank Visser
Elias Suhonen limped in on the button with the and Matthias Siljander made it 650,000 in the big blind with . Suhonen called to the flop, where he called the 400,000 continuation-bet of Siljander.
Both players checked the turn before Siljander checked the river as well. Suhonen piled in a bet of 2,400,000. Siljander then jammed all-in with his full house and Suhonen instantly folded his bluff.
Player
Chips
Progress
Mathias Siljander
11,000,000
3,600,000
Elias Suhonen
10,025,000
3,600,000
Siljander Trusts His Queen Posted Sunday 27th October, 2024 at 18:35(UTC+0) by Frank Visser
Mathias Siljander limped in with on the button and was raised to 600,000 by Elias Suhonen in the big blind, who had .
Suhonen continued for 400,000 on the flop and Siljander called. Suhonen gave up on the turn, checking to Siljander before folding to his bet of 1,400,000.
Player
Chips
Progress
Elias Suhonen
13,625,000
1,300,000
Mathias Siljander
7,400,000
1,300,000
Suhonen Takes Some Back Posted Sunday 27th October, 2024 at 18:25(UTC+0) by Frank Visser
Mathias Siljander limped in on the button and Elias Suhonen checked his option. graced the flop and saw Siljander bet 200,000. Suhonen called to the turn, where he also called Siljander's bet of 800,000.
The river was checked down for Suhonen to show down for two pair. Siljander had given up bluffign with and lost the sizable pot.
Player
Chips
Progress
Elias Suhonen
14,925,000
1,200,000
Mathias Siljander
6,100,000
1,200,000
18:21 (UTC+0)
Start of Level 33 Blinds: 10,000/200,000 Ante: 200,000
Siljander Doubles Up Posted Sunday 27th October, 2024 at 18:21(UTC+0) by Frank Visser
Elias Suhonen limped his button and saw Mathias Siljander make it 450,000 to go in the big blind. Suhonen made the call to a flop of , where Siljander checked to him.
He then fired 350,000, receiving a call from his opponent. The turn saw Suhonen size up to 750,000, which Siljander check-called as well.
On the turn, SIljander checked for a third time before snapping off the all-in bet by Suhonen.
Suhonen showed for a flopped straight, but Siljander had rivered a flush with and doubled up to a two-to-one disadvantage.
Player
Chips
Progress
Elias Suhonen
13,725,000
4,000,000
Mathias Siljander
7,300,000
4,000,000
Suljander Draws First Blood Posted Sunday 27th October, 2024 at 18:16(UTC+0) by Frank Visser
Elias Suhonen limped in on the button and Mathias Siljander checked the big blind. Suhonen fired 150,000 on the flop and was check-called by Siljander.
The turn went check-check and Siljander checked the river as well. Suhonen bet 450,000 and Siljander eventually flicked in the call.
Suhonen played the board with , and Siljander was awarded the pot with for two pair.
Player
Chips
Progress
Elias Suhonen
17,725,000
800,000
Mathias Siljander
3,300,000
800,000
Enea Subashi Eliminated in 3rd Place (€55,200) Posted Sunday 27th October, 2024 at 18:13(UTC+0) by Frank Visser
Enea Subashi raised his button to 300,000. Elias Suhonen made the call in the big blind, after which he check-called Subashi's bet of 475,000 on the flop.
The hit the turn, on which Suhonen led out for 650,000. Subashi put in a quick call before the river completed the board.
Unphased by the third diamond, Suhonen continued firing for 2,100,000, around half of Subashi's stack. The Greek thought for a bit and then flicked in a call.
Suhonen tabled for trip queens. Subashi mucked and lost the big pot, seeing Suhonen take a gigantic chip lead over the other two players.
Player
Chips
Progress
Elias Suhonen
16,000,000
4,000,000
Enea Subashi
2,300,000
4,200,000
Another Double for Siljander Posted Sunday 27th October, 2024 at 17:50(UTC+0) by Frank Visser
Mathias Siljander limped in from the small blind and Elias Suhonen checked in the big blind. Siljander check-called bets of 200,000 on the flop and 600,000 on the turn for the river to complete the board.
He then led out for 1,400,000 and was snapped off by his fellow Finn. Siljander tabled for a bluff with ace-high, while Suhonen had rivered the straight with and won the pot.
Siljander was left with just over 13 big blinds.
Player
Chips
Progress
Elias Suhonen
12,000,000
1,575,000
Mathias Siljander
2,000,000
2,675,000
17:19 (UTC+0)
Start of Level 32 Blinds: 100,000/150,000 Ante: 150,000
Evening Break Posted Sunday 27th October, 2024 at 16:54(UTC+0) by Frank Visser
The three players have been sent on a 25-minute break.
Player
Chips
Progress
Elias Suhonen
10,425,000
425,000
Enea Subashi
5,925,000
25,000
Mathias Siljander
4,675,000
225,000
Subashi Really Just Keeps Firing, Gifts Suhonen Big Lead Posted Sunday 27th October, 2024 at 16:53(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Enea Subashi on the button made it 250,000 to go. Elias Suhonen defended in the big blind and check-called the subsequent 325,000 Subashi put in on the flop.
Subashi bombed in 825,000 on the turn, which Suhonen check-called again. The then arrived on the river, where Subashi piled in a massive bet of 2,200,000 after a third check from Suhonen.
Suhonen flicked in a calling chip and saw his win against the of Subashi.
Player
Chips
Progress
Elias Suhonen
10,000,000
2,800,000
Enea Subashi
5,900,000
3,000,000
Subashi Just Keeps Firing Posted Sunday 27th October, 2024 at 16:45(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Elias Suhonen saw in the small blind and limped in. Enea Subashi looked down at in the big blind and checked his option.
Suhonen bet 140,000 on the flop and Subashi called. He slowed down and checked the turn to the Greek, who fired 375,000.
Suhonen called to the river, where he checked again. Subashi quickly put in 975,000 chips, to which Suhonen folded after some thinking time.
Player
Chips
Progress
Enea Subashi
8,900,000
900,000
Elias Suhonen
7,200,000
1,000,000
Suhonen Gets Even With Subashi Posted Sunday 27th October, 2024 at 16:37(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Elias Suhonen limped in from the small blind with before Enea Subashi made it 420,000 to go in the big blind with .
Suhonen called to the flop, where he check-called Subashi's bet of 400,000. The turn went check-check, after which Suhonen led out for 480,000.
Subashi quickly got rid of his hand and Suhonen was awarded the pot.
Player
Chips
Progress
Elias Suhonen
8,200,000
400,000
Enea Subashi
8,000,000
500,000
Subashi Gets Counterfeit Posted Sunday 27th October, 2024 at 16:33(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Enea Subashi limped in from the small blind, after which Mathias Siljander checked his big blind. Subashi put in another 120,000 on the flop, which Siljander called.
The turn checked through before Subashi put in 475,000 on the river. Siljander quickly called. Subashi could only show six-high with while Siljander took the pot with for queen-high.
Player
Chips
Progress
Enea Subashi
8,500,000
200,000
Mathias Siljander
4,900,000
100,000
Suhonen Puts in Four Bets, Subashi Makes It Five Posted Sunday 27th October, 2024 at 16:26(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Elias Suhonen looked at on the button and raised to 240,000. Enea Subashi found in the small blind and reraised to 660,000.
Suhonen pondered for a while before four-betting to 1,400,000, after which Subashi quickly five-bet to 3,400,000.
Suhonen seriously weighed his options for a while but ultimately could not find a jam as Subashi took down the huge pot preflop.
Player
Chips
Progress
Enea Subashi
8,700,000
1,400,000
Elias Suhonen
7,800,000
700,000
Siljander Doubles Through Chipleader Posted Sunday 27th October, 2024 at 16:18(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Enea Subashi raised his button to 250,000. Mathias Siljander then jammed all in for 2,400,000 in the small blind and was snap-called by Subashi.
Mathias Siljander: Enea Subashi:
Siljander's jacks faced no threat on the runout and he doubled up, making the game a more even affair.
Player
Chips
Progress
Enea Subashi
7,300,000
2,400,000
Mathias Siljander
5,000,000
2,600,000
Subashi Nearing Ten Million Posted Sunday 27th October, 2024 at 16:15(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Enea Subashi raised to 385,000 in the small blind with . Mathias Siljander called in the big blind, after which a flop fanned out.
Subashi continued for 350,000 and Siljander called. Subashi sized up to 875,000 on the turn and was met with an instant fold from Siljander's gutshot.
Player
Chips
Progress
Enea Subashi
9,700,000
600,000
Mathias Siljander
2,400,000
1,000,000
Subashi Secures Chiplead Posted Sunday 27th October, 2024 at 16:09(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 3/701
Elias Suhonen limped in from the small blind. Enea Subashi raised to 420,000 in the big blind, which Suhonen called.
Suhonen check-called a bet of 400,000 on the flop before the fell on the turn. Subashi sized up to 1,200,000, seeing Suhonen put in another call.
The river was checked down. Suhonen showed for a pair of queens, but Subashi took the pot with for two pair, and took resultingly took over the chiplead.
Player
Chips
Progress
Enea Subashi
9,100,000
2,000,000
Elias Suhonen
8,500,000
1,500,000
Updated Counts Posted Sunday 27th October, 2024 at 16:04(UTC+0) by Frank Visser
Player
Chips
Progress
Elias Suhonen
10,000,000
1,000,000
Enea Subashi
7,100,000
100,000
Mathias Siljander
3,400,000
100,000
Vasyl Laba Eliminated in 4th Place (€40,250) Posted Sunday 27th October, 2024 at 15:55(UTC+0) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 4/701
Elias Suhonen raised his button to 240,000. Vasyl Laba then three-bet jammed his button for 2,300,000, sending Suhonen in the tank.
After two minutes or so, Suhonen flicked in a calling chip to put the last Ukrainian player at risk.
Vasyl Laba: Elias Suhonen:
The board provided Laba with counterfeit outs, but the river did nothing for him. Suhonen's fives held and felted Laba in fourth place.
Player
Chips
Progress
Elias Suhonen
11,000,000
2,500,000
Vasyl Laba
0
0
15:48 (UTC+0)
Start of Level 31 Blinds: 60,000/120,000 Ante: 120,000
Even More for Laba Posted Sunday 27th October, 2024 at 15:48(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 4/701
Elias Suhonen raised his small blind to 300,000 with . Vasyl Laba defended in the big blind and saw a flop of .
Suhonen gave his weak hand up and check-folded to Laba's bet of 150,000.
Player
Chips
Progress
Elias Suhonen
8,500,000
300,000
Vasyl Laba
2,300,000
300,000
Laba Gets Some Chips Back Posted Sunday 27th October, 2024 at 15:45(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 4/701
Vasyl Laba raised to 200,000 under the gun with . It folded to Elias Suhonen in the big blind, who defended .
Laba bet 150,000 on the flop and Suhonen check-called. The fell on the turn, on which Suhonen check-folded to Laba's bet of 450,000.
Player
Chips
Progress
Elias Suhonen
8,800,000
500,000
Vasyl Laba
2,000,000
100,000
Serhii Leonov Eliminated in 5th Place (€30,450) Posted Sunday 27th October, 2024 at 15:37(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 5/701
Serhii Leonov raised to 200,000 under the gun. It folded to Enea Subashi on the button, who three-bet to 715,000. Leonov then jammed all in for 3,000,000 and Subashi called after a count and some consideration.
Serhii Leonov: Enea Subashi:
Subashi turned Leonov dead on , with the river rendered meaningless. The start-of-day chipleader could not continue his run and fell in fifth place.
Player
Chips
Progress
Enea Subashi
7,200,000
3,200,000
Serhii Leonov
0
0
Subashi Fights Back Posted Sunday 27th October, 2024 at 15:31(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 5/701
Elias Suhonen raised to 200,000 in the cutoff with . Enea Subashi found in the big blind and decided to put pressure on Suhonen with a three-bet to 775,000.
Suhonen, undeterred, called to the flop, where he was forced to fold to the 650,000 continuation-bet of Subashi.
Player
Chips
Progress
Elias Suhonen
9,300,000
600,000
Enea Subashi
4,000,000
500,000
Aku-Oskari Uotila Eliminated in 6th Place (€22,540) Posted Sunday 27th October, 2024 at 15:24(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 6/701
Aku-Oskari Uotila raised to 200,000 in the cutoff. Elias Suhonen called in the big blind and checked on the flop. Uotila put in the minimum bet of 100,000, which Suhonen raised to 350,000. Uotilla called and the turn emerged from the deck.
Suhonen put in a hefty bet of 800,000. Uotila pondered for a while and then called. The river put a third jack on the board. Suhonen tanked a while before putting Uotila all-in for 2,000,000.
Uotila snap-called and tabled for jacks full of aces. Suhonen played for quad jacks, however, and eliminated another player in a massive cooler.
Player
Chips
Progress
Elias Suhonen
9,900,000
3,400,000
Aku-Oskari Uotila
0
0
Suhonen Goes Wide, Siljander Profits Posted Sunday 27th October, 2024 at 15:18(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 6/701
Elias Suhonen sat under the gun and raised to 200,000. Mathias Siljander defended in the big blind and check-called 150,000 on the flop.
The turn checked through before Siljander bet 575,000 on the river. Suhonen mulled it over for a bit before finding a call.
Siljander tabled for top pair. It took down the pot as Suhonen played for second pair, which he added to the muck.
Player
Chips
Progress
Elias Suhonen
6,500,000
600,000
Mathias Siljander
3,500,000
1,100,000
Subashi Flops Set Three-Way Posted Sunday 27th October, 2024 at 15:14(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 6/701
Enea Subashi raised his to 225,000 under the gun. Serhii Leonov called with on the button before Aku-Oskari Uotila defended in the big blind.
Subashi bet 280,000 on the flop. Leonov instantly mucked his gutshot but Uotila stuck around with his open-ender. The turn improved neither player. Subashi sized up to 735,000 and was met with a check-fold from his opponent.
Player
Chips
Progress
Enea Subashi
3,500,000
700,000
Aku-Oskari Uotila
3,400,000
200,000
Serhii Leonov
2,800,000
300,000
Suhonen Surpasses Seven Million Posted Sunday 27th October, 2024 at 15:09(UTC+0) by Frank Visser
Player
Chips
Progress
Elias Suhonen
7,100,000
300,000
Aku-Oskari Uotila
3,600,000
215,000
Serhii Leonov
3,100,000
400,000
Enea Subashi
2,800,000
200,000
Mathias Siljander
2,400,000
0
Vasyl Laba
2,100,000
5,000
Siljander Doubles With Broadway Posted Sunday 27th October, 2024 at 15:02(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 6/701
Enea Subashi raised to 200,000 from the hijack. Mathias Siljander then three-bet jammed to 1,100,000 in the cutoff and Subashi called once the action folded back to him.
Eneas Subashi: Mathias Siljander:
Siljander was slightly behind but flopped additional outs on to make it a flip. The turn did nothing for either player, but the river did.
Siljander rivered a straight and doubled up to 24 big blinds.
Player
Chips
Progress
Enea Subashi
3,000,000
850,000
Mathias Siljander
2,400,000
1,320,000
Suhonen Adds More Posted Sunday 27th October, 2024 at 14:51(UTC+0) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 6/701
Elias Suhonen saw in the cutoff and raised to 200,000. Serhii Leonov decided to make it 550,000 on the button with , which Suhonen called.
The flop was checked through to the turn. Suhonen bet 900,000 and Leonov made a quick fold with his king-high.
Player
Chips
Progress
Elias Suhonen
6,800,000
755,000
Serhii Leonov
3,500,000
640,000
14:46 (UTC+0)
Start of Level 30 Blinds: 50,000/100,000 Ante: 100,000
Break Counts Posted Sunday 27th October, 2024 at 14:39(UTC+0) by Frank Visser
Player
Chips
Progress
Elias Suhonen
6,045,000
155,000
Serhii Leonov
4,140,000
40,000
Enea Subashi
3,850,000
50,000
Aku-Oskari Uotila
3,815,000
715,000
Vasyl Laba
2,095,000
405,000
Mathias Siljander
1,080,000
20,000
Break Time Posted Sunday 27th October, 2024 at 14:23(UTC+0) by Frank Visser
The six contenders have been sent on another 20-minute break.
Leonov Regains Some Chips Posted Sunday 27th October, 2024 at 14:19(UTC+0) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 6/701
Serhii Leonov was in the hijack and raised to 160,000. Enea Subashi defended his big blind and check-called when Leonov bet 100,000 on the flop.
The turn saw Leonov size up to 375,000. He was once again check-called by Subashi before the river checked through.
Subashi showed but his pair of eights were no good against the of Leonov, who won with top pair.
Player
Chips
Progress
Serhii Leonov
4,100,000
500,000
Enea Subashi
3,900,000
700,000
Daniel Clifford Eliminated in 7th Place (€17,400) Posted Sunday 27th October, 2024 at 14:15(UTC+0) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 7/701
Elias Suhonen put in a raise to 160,000 in the cutoff and Daniel Clifford defended his big blind after some thought.
Suhonen bet 120,000 on the flop, which Clifford check-raised to 400,000. Suhonen weighed his options for a bit before deciding to call.
The hit the turn and was checked through. The river then completed the board. Clifford shoved all in for 130,000 and was snap-called by Suhonen.
Clifford tabled for a full house, but surprisingly it was not enough as Suhonen had for the absolute nuts, a straight flush.
Clifford shook his head at the sick cooler as he took his exit in seventh place, seeing Suhonen grab a sizable chip lead.
Player
Chips
Progress
Elias Suhonen
6,200,000
1,900,000
Daniel Clifford
0
0
Updated Counts; Subashi Leads Posted Sunday 27th October, 2024 at 14:04(UTC+0) by Frank Visser
Player
Chips
Progress
Enea Subashi
4,600,000
400,000
Elias Suhonen
4,300,000
200,000
Serhii Leonov
3,600,000
700,000
Aku-Oskari Uotila
3,100,000
200,000
Vasyl Laba
2,500,000
0
Daniel Clifford
1,900,000
500,000
Mathias Siljander
1,100,000
400,000
Ruslan Stserbjuk Eliminated in 8th Place (€14,400) Posted Sunday 27th October, 2024 at 13:50(UTC+0) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 8/701
Ruslan Stserbjuk was automatically all-in in the big blind. Aku-Oskari Uotila then made it 160,000 to go in the hijack and Elias Suhonen called in the big blind.
The board checked through to the river. Uotila bet 160,000, which was enough to let Suhonen muck his .
Uotila tabled for a rivered straight, besting the of Stserbjuk and sending him home in eighth place.
Player
Chips
Progress
Elias Suhonen
4,500,000
200,000
Aku-Oskari Uotila
3,300,000
200,000
Ruslan Stserbjuk
0
0
Suhonen Doubles Up in Huge Cooler, Leaves Stserbjuk On Fumes Posted Sunday 27th October, 2024 at 13:41(UTC+0) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 8/701
Ruslan Stserbjuk raised to 160,000 under the gun. Daniel Clifford flat-called in the hijack before it folded to Elias Suhonen in the big blind.
He jammed all in for 2,200,000 and was called by Stserbjuk, who only played 65,000 more. Clifford quickly got rid of his and the cards went face-up.
Elias Suhonen: Ruslan Stserbjuk:
Suhonen needed to hit an ace to maintain his seat at the final table and did so on the flop. Stserbjuk still had a flush draw but it bricked on the runout as Suhonen doubled up.
Stserbjuk, meanwhile, was left with less than one big blind.
Player
Chips
Progress
Elias Suhonen
4,700,000
2,200,000
Ruslan Stserbjuk
65,000
1,935,000
Subashi Heroes Siljander With Bottom Pair Posted Sunday 27th October, 2024 at 13:35(UTC+0) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 8/701
Mathias Siljander open-raised to 160,000 under the gun. It folded to Enea Subashi in the big blind, who called.
Subashi checked the flop to Siljander, who bet 140,000. Subashi called to the turn, which both players checked. Siljander slid in 475,000 on the river, getting check-called by the Greek player.
He tabled for ace-high, but Subashi had for a pair of deuces and won the sizable pot.
Player
Chips
Progress
Enea Subashi
4,200,000
900,000
Mathias Siljander
1,500,000
1,050,000
13:31 (UTC+0)
Start of Level 29 Blinds: 40,000/80,000 Ante: 80,000
Laba Gives Up Posted Sunday 27th October, 2024 at 13:29(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Vasyl Laba opened to 120,000 on the button. Aku-Oskari Uotila called in the big blind and check-called when Laba tossed in 100,000 on the flop.
Uotila checked the turn as well before calling a bet of 355,000 from his opponent. The river was checked by both. Uotila opened up for top pair and won the pot against Laba's .
Player
Chips
Progress
Aku-Oskari Uotila
3,100,000
600,000
Vasyl Laba
2,500,000
600,000
Laba Gets Four-Bet Through Posted Sunday 27th October, 2024 at 13:24(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Enea Subashi kicked off the action with a raise to 125,000 in early position, having found . Serhii Leonov three-bet his button to 375,000 with after which Vasyl Laba four-bet to 700,000 in the small blind after looking down at .
Subashi folded and Leonov instantly followed suit, shipping the pot to Laba.
Player
Chips
Progress
Serhii Leonov
4,300,000
300,000
Enea Subashi
3,300,000
200,000
Vasyl Laba
3,100,000
700,000
Ukrainians Chop One Up Posted Sunday 27th October, 2024 at 13:18(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Serhii Leonov raised to 180,000 in the small blind and saw Vasyl Laba defend in the big blind.
Leonov continued for 140,000 on the flop and Laba called. Leonov sized up to 350,000 on the turn, once again seeing his fellow countryman call.
The river prompted both players to check. Leonov tabled for kings and eights, chopping the pot with Laba as he played the same hand with .
Player
Chips
Progress
Serhii Leonov
4,600,000
0
Vasyl Laba
2,400,000
100,000
Stserbjuk Bluffs Into Two Posted Sunday 27th October, 2024 at 13:11(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Vasyl Laba raised to 125,000 in early position with and was called by Aku-Oskari Uotila's in the hijack. Ruslan Stserbjuk also called in the big blind with , and the three saw a flop of .
It checked around to the turn, where Stserbjuk bet 150,000. Both Laba and Uotila called, after which the river completed the board.
Not afraid, Stserbjuk put another 420,000 in the middle. Laba folded his missed draw as did Uotila with his ace-high as Stserbjuk got his bluff through.
Player
Chips
Progress
Vasyl Laba
2,500,000
400,000
Aku-Oskari Uotila
2,500,000
550,000
Ruslan Stserbjuk
2,000,000
700,000
Suhonen Chips Up With Kings Posted Sunday 27th October, 2024 at 13:00(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Elias Suhonen looked down at in early position and raised to 120,000. Enea Subashi defended his big blind with and check-called Suhonen's bet of 110,000 on the flop.
Suhonen sized up to 480,000 on the turn. Subashi thought it over for a few moments but rightfully decided to fold his pair as Suhonen was awarded the pot.
Player
Chips
Progress
Enea Subashi
3,500,000
300,000
Elias Suhonen
2,500,000
100,000
Clifford Makes Straight Posted Sunday 27th October, 2024 at 12:57(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Serhii Leonov raised to 120,000 on the button. Daniel Clifford called in the big blind and led out for 100,000 on the flop. Leonov just called, after which the turn went check-check.
The river prompted Clifford to bet 125,000. After some consideration, Leonov put in the call. He was met with Clifford's for a straight and sent his for second pair into the muck.
Player
Chips
Progress
Serhii Leonov
4,600,000
400,000
Daniel Clifford
1,400,000
400,000
Subashi Fires Into Leonov Posted Sunday 27th October, 2024 at 12:52(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Enea Subashi raised to 125,000 in middle position with . Chipleader Serhii Leonov called in the small blind with and check-called Subashi's bet of 140,000 on the flop.
The turn did not slow Subashi down, as he fired for 375,000. Leonov check-called his two pair to the river. Subashi completed his triple barrel bluff by placing 600,000 in the middle. Leonov thought for a while but ultimately let go of the best hand.
Player
Chips
Progress
Serhii Leonov
5,000,000
600,000
Enea Subashi
3,800,000
800,000
Leonov Makes Flush in Three-Way Pot Posted Sunday 27th October, 2024 at 12:48(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 8/701
Vasyl Laba sat under the gun and raised to 120,000. Ruslan Stserbjuk called in the small blind, as did Serhii Leonov in the big blind.
It checked to Laba under the gun, who continued for 120,000. Both players called to the turn, which got checked through. The fell on the river and saw Leonov bet 280,000 after Stserbjov had checked.
Laba quickly got out of the way with but Stserbjov tossed in a call. Leonov showed for a flush, besting the of Stserbjov and dragging yet another pot.
Player
Chips
Progress
Serhii Leonov
5,600,000
1,010,000
Vasyl Laba
2,900,000
240,000
Ruslan Stserbjuk
1,300,000
500,000
History Repeats as Clifford Folds Best Hand Against Subashi Posted Sunday 27th October, 2024 at 12:41(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries 8/701
Daniel Clifford saw in middle position and raised to 125,000. Enea Subashi called in the cutoff with before Ruslan Stserbjuk defended his big blind with .
Clifford continued for 175,000 on the flop. Subashi called his open-ender before Stserbjuk folded his pair of nines.
The turn fell the . Subashi fired 290,000 once Clifford had checked, and once again got his opponent to fold the best hand.
Player
Chips
Progress
Enea Subashi
3,000,000
900,000
Ruslan Stserbjuk
1,800,000
310,000
Daniel Clifford
1,000,000
330,000
Simon Hassan Eliminated in 9th Place (€11,800) Posted Sunday 27th October, 2024 at 12:31(UTC+0) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries 9/701
Elias Suhonen raised to 120,000 in early position and was called by Simon Hassan in the seat next to him. Enea Subashi then defended his big blind, after which the flop hit the table.
It checked to Hassan, who bet 295,000, more than half his stack. Subashi called before Suhonen got out of the way with . The turn fell and saw Subashi jam all in. Hassan quickly called off his 235,000 remaining chips and the cards were tabled.
Simon Hassan: Enea Subashi:
Hassan was ahead, but Subashi had a plethora of outs to choose from. The river was one of them, making him two pair to send Hassan out as the first elimination of the day.
Player
Chips
Progress
Elias Suhonen
2,400,000
85,000
Enea Subashi
2,100,000
785,000
Simon Hassan
0
0
12:23 (UTC+0)
Start of Level 28 Blinds: 30,000/60,000 Ante: 60,000
Break Counts Posted Sunday 27th October, 2024 at 12:09(UTC+0) by Frank Visser
Player
Chips
Progress
Serhii Leonov
4,590,000
210,000
Vasyl Laba
3,140,000
160,000
Aku-Oskari Uotila
3,050,000
50,000
Mathias Siljander
2,550,000
150,000
Elias Suhonen
2,485,000
15,000
Ruslan Stserbjuk
2,110,000
110,000
Daniel Clifford
1,330,000
270,000
Enea Subashi
1,315,000
415,000
First Break of Final Table Posted Sunday 27th October, 2024 at 12:06(UTC+0) by Frank Visser
With no recorded bust-outs, the final nine have been sent on their first 20-minute break of the day.
Hassan's Run Continues as He Doubles Again Posted Sunday 27th October, 2024 at 12:04(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Simon Hassan raised all in for 275,000 in the cutoff. Serhii Leonov called in the small blind and a showdown was ordered.
Simon Hassan: Serhii Leonov:
The board ran out without a queen as the board doubled up Hassan for a second time in a short time.
Player
Chips
Progress
Serhii Leonov
4,800,000
200,000
Simon Hassan
650,000
265,000
Hassan Flops Gin to Double Up Posted Sunday 27th October, 2024 at 11:57(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Ruslan Stserbjuk raised to 100,000 under the gun and saw Simon Hassan defend his big blind. Hassan only had 55,000 behind, which he tossed in on the flop.
Stserbjuk made a quick call and the cards were tabled.
Simon Hassan: Ruslan Stserbjuk:
Hassan had flopped a big lead with his top pair. The turn made him two pair, which held on the river to double up.
Player
Chips
Progress
Ruslan Stserbjuk
2,000,000
100,000
Simon Hassan
385,000
180,000
Laba Squeezes One Through Posted Sunday 27th October, 2024 at 11:49(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Mathias Siljander sat in early position and raised to 100,000. Simon Hassan called off of his short stack before Vasyl Laba three-bet to 400,000 on the button with .
Both players opted to fold and the pot was shipped to Laba without the need for a flop.
Player
Chips
Progress
Vasyl Laba
3,300,000
300,000
Mathias Siljander
2,400,000
100,000
Simon Hassan
205,000
275,000
Leonov and Laba Battle in Blinds Posted Sunday 27th October, 2024 at 11:43(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Serhii Leonov raised his small blind to 175,000 and was called by fellow Ukrainian Vasyl Laba in the big blind. The flop and turn were checked through before Leonov bet 175,000 on the river.
Laba quickly called, but mucked his once Leonov tabled for tens and nines.
Player
Chips
Progress
Serhii Leonov
5,000,000
300,000
Vasyl Laba
3,000,000
200,000
Laba Calls Suhonen Down Posted Sunday 27th October, 2024 at 11:33(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Vasyl Laba in middle position raised to 100,000. Elias Suhonen defended his big blind before he check-raised Laba's min-bet of 50,000 to 225,000.
Laba quickly called and the pair saw the appear on the turn. Suhonen did not give up and tossed 400,000 in the pot. Undeterred, Laba still stuck around and called to the river.
Suhonen decided to check after a minute or so in the tank. Laba quickly checked behind and saw Suhonen table for a bluff. Laba turned over for the best hand and took down the large pot.
Player
Chips
Progress
Vasyl Laba
3,200,000
700,000
Elias Suhonen
2,500,000
700,000
Hassan Limps Himself Short Posted Sunday 27th October, 2024 at 11:22(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Simon Hassan limped in from middle position with and got Serhii Leonov to come along with in the hijack. Enea Subashi checked in the big blind, and the trio went to a flop of .
Subashi checked, Hassan bet 105,000, Leonov called, and Subashi folded. Leonov made a full house on the turn and slow-played by just calling the tiny bet of 80,000 that Hassan put out.
The river double-paired the board. Hassan checked before being put all-in for 480,000. Hassan made a quick fold and was left with less than ten big blinds.
Player
Chips
Progress
Serhii Leonov
4,700,000
400,000
Simon Hassan
480,000
235,000
Uotila Takes More From Lada Posted Sunday 27th October, 2024 at 11:16(UTC+0) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries 9/701
Aku-Oskari Uotila raised to 100,000 under the gun with . Vasyl Lada in the small blind made it 450,000 to go in the small blind with and Uotila called.
Lada checked the flop to Uotila, who fired 225,000. Lada quickly folded his top pair and forfeited the pot to Uotila.
Player
Chips
Progress
Aku-Oskari Uotila
3,100,000
500,000
Vasyl Laba
2,500,000
400,000
11:11 (UTC+0)
Start of Level 27 Blinds: 25,000/50,000 Ante: 50,000
Uotila Raises Lada Posted Sunday 27th October, 2024 at 11:09(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries 9/701
Vasyl Laba raised to 80,000 in middle position with . Aku-Oskari Uotila flatted in the hijack before a flop of appeared,
Laba placed a large bet of 205,000, which Uotila raised to 475,000. Laba let his hand go as Uotila took down the pot.
Player
Chips
Progress
Vasyl Laba
2,900,000
350,000
Aku-Oskari Uotila
2,600,000
310,000
Leonov Extends Lead With Four-Way Action Posted Sunday 27th October, 2024 at 11:00(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries 9/701
Ruslan Stserbjuk raised to 105,000 in early position with . Serhii Leonov called with in the seat next to him before Enea Subashi came along on the button with .
Elias Suhonen defended his big blind with and the four players went to a flop of . Stserbjuk placed a continuation-bet of 225,000, which was called by both Leonov's top set and Subashi's flush draw.
Suhonen mucked his overcards before the paired the board, locking up the pot for Leonov. Stserbjuk slowed down and checked, prompting Leonov to bet 325,000.
Subashi wisely got rid of his flush draw and Stserbjuk mucked his king-high as well, shipping the sizable pot to Leonov.
Player
Chips
Progress
Serhii Leonov
4,300,000
600,000
Elias Suhonen
3,200,000
100,000
Ruslan Stserbjuk
2,100,000
390,000
Enea Subashi
900,000
525,000
Clifford Erroneously Folds Kings Posted Sunday 27th October, 2024 at 10:50(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries 9/701
Daniel Clifford saw under the gun and raised to 80,000. Enea Subashi called in middle position with and a flop of was spread.
Clifford continued with a bet of 90,000, which Subashi quickly raised to 215,000. Clifford spent a minute or so in the tank before letting the best hand go as Subashi raked in the pot.
Player
Chips
Progress
Daniel Clifford
1,600,000
120,000
Enea Subashi
1,425,000
325,000
Leonov Starts off Aggressively Posted Sunday 27th October, 2024 at 10:42(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries 9/701
Elias Suhonen raised to 80,000 in the cutoff with . Serhii Leonov found in the big blind and three-bet to 325,000.
Suhonen mulled it over for a bit but ultimately folded his suited king and surrendered the first pot.
Player
Chips
Progress
Serhii Leonov
3,700,000
150,000
Elias Suhonen
3,300,000
100,000
Final Table Has Begun Posted Sunday 27th October, 2024 at 10:39(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries 9/701
The players have been introduced and have taken their seats. The shuffle up and deal has been ordered.
The final table of the Kings of Tallinn: Autumn Edition Main Event is underway.
10:38 (UTC+0)
Day 4 of Kings of Tallinn Autumn Edition 2024 Started Level: 26 Blinds: 20,000/40,000 Ante: 40,000
Mathias Siljander Searching Third Main Event Victory as Final Nine Return for Day 4 of Kings of Tallinn Autumn Edition Main Event Posted Sunday 27th October, 2024 at 08:56(UTC+0) by Frank Visser
All good things must come to an end. After a week of poker, fun, and camaraderie, the last day of the first-ever Kings of Tallinn: Autumn Edition has arrived. As is tradition, the final table of the €1,100 Main Event will be played out on this day. The €500,000 guarantee was smashed with 701 entries creating a prize pool of €658,940. Of those 701, only nine will return to Olympic Park Casino to battle for the glory and Main Event trophy.
Mathias Siljander is no stranger to this stage. The Finnish player has racked up over $800,000 in lifetime earnings, a good portion of which has been earned in Estonia. In fact, Siljander already has two Olympic Park Main Event trophies at home, along with a runner-up finish and bronze medal. This will be his first official Kings of Tallinn Main Event final table, however, and the top prize of €130,300 would be by far the biggest cash of his career.
Siljander is bringing 2,500,000 chips to the final table, equaling 63 big blinds at the start of play. This lands him in the middle of the pack, along with the last remaining Estonian Ruslan Stserbjuk (2,490,000), and Siljander's fellow Finn Aku-Oskari Uotila (2,290,000). Meanwhile, Ukraine's SerhiiLeonov has the chip lead with a stack of 3,550,000 after a dominating Day 3 performance, while Elias Suhonen closely follows with 3,400,000, most of which he got in a huge pot against Siljander at the end of Day 3.
Leonov's countryman Vasyl Laba sits in third with 3,250,000, while Swedes Daniel Clifford (1,720,000) and Simon Hassan (715,000) and Greek player Enea Subashi (1,100,000) are the shorter stacks on the table, which has an average stack of nearly 60 big blinds.
Final Table Draw and Chip Counts
Seat
Player
Country
Chip Count
Big Blinds
1
Daniel Clifford
Sweden
1,720,000
43
2
Aku-Oskari Uotila
Finland
2,290,000
57
3
Enea Subashi
Greece
1,100,000
28
4
Mathias Siljander
Finland
2,500,000
63
5
Elias Suhonen
Finland
3,400,000
85
6
Simon Hassan
Sweden
715,000
18
7
Ruslan Stserbjuk
Estonia
2,490,000
62
8
Serhii Leonov
Ukraine
3,550,000
89
9
Vasyl Laba
Ukraine
3,250,000
81
For five out of the nine players, the €11,800 they have locked up is already their largest-ever recorded cash. However, payjumps are happening after every elimination to increase that high score inch by inch, until the top spot of €130,300 is reached.
€1,100 Main Event Payouts
Place
Prize
1
€130,300
2
€83,400
3
€55,200
4
€40,250
5
€30,450
6
€22,540
7
€17,400
8
€14,400
9
€11,800
The final table will start at noon local time, with 26 minutes and seven seconds remaining in Level 26: 20,000/40,000 (40,000). Each subsequent level will have a duration of 60 minutes, with a break after every two levels. As it is the final day of the festival, the tournament will not stop before a winner is crowned.
Live reporting will be delayed by 30 minutes, the same delay the cards-up live stream by OlyBet.tv uses, to not give away any spoilers. Make sure to check back in by 12:30 as you do not want to miss the thrilling finale of the Kings of Tallinn: Autumn Edition Main Event.
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.
flop and 
turn remained safe for him. However, the river brought the 
for Siljander's ace-king to river the best pair.
and Mathias Siljander checked in the big blind with 
. 
board was checked to the 
river, where Siljander bet 500,000. Suhonen then raised to 1,800,000 and got Siljander to lay down the best hand.
and was called by Mathias Siljander in the big blind, who had 
and saw Elias Suhonen three-bet to 1,400,000 in the big blind with 
. He called to the 
flop, where Suhonen fired a bet of 800,000.
turn, where he was faced with a bet of 2,200,000. Once again, he called, and the 
hit the river. Suhonen spent a while in the tank before sliding in a bet of 2,000,000.
river. After some thought, Suhonen called with 
.
turn. The 
river, where Siljander bet 800,000. Suhonen wisely folded his pair as Siljander's lead grew.
. Elias Suhonen then three-bet to 1,400,000 in the big blind with 
and Matthias Siljander made it 650,000 in the big blind with 
flop, where he called the 400,000 continuation-bet of Siljander. 
.
, where Siljander checked to him.
turn saw Suhonen size up to 750,000, which Siljander check-called as well.
for a flopped straight, but Siljander had rivered a flush with 
for two pair.
and Enea Subashi checked in the big blind with 
in the small blind and limped in. Enea Subashi looked down at 
