0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0077 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/3/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0005 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0036 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, 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.logo as tour_stop_logo, 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 `friendly_url` = 'kings_of_tallinn_autumn_2024_main_event'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '455'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '457'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0164 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '460'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'
AND `name` = '3'
0.0069 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.0078 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` = '457'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19420'
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` = '19419'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19418'
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` = '19413'
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` = '19417'
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` = '19407'
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` = '19416'
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` = '19415'
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` = '19406'
ORDER BY `chip_change` DESC, `busted` ASC
0.0162 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19411'
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` = '19404'
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` = '19401'
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` = '19397'
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` = '19402'
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` = '19396'
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` = '19394'
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` = '19399'
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` = '19391'
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` = '19385'
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` = '19390'
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` = '19389'
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` = '19388'
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` = '19384'
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` = '19387'
ORDER BY `chip_change` DESC, `busted` ASC
0.0165 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19377'
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` = '19382'
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` = '19375'
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` = '19374'
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` = '19372'
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` = '19368'
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` = '19379'
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` = '19365'
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` = '19363'
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` = '19362'
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` = '19358'
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` = '19356'
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` = '19354'
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` = '19352'
ORDER BY `chip_change` DESC, `busted` ASC
0.0167 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19351'
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` = '19348'
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` = '19347'
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` = '19344'
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` = '19343'
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` = '19342'
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` = '19341'
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` = '19338'
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` = '19337'
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` = '19336'
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` = '19334'
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` = '19333'
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` = '19331'
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` = '19327'
ORDER BY `chip_change` DESC, `busted` ASC
0.0168 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19326'
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` = '19325'
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` = '19324'
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` = '19322'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19321'
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` = '19320'
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` = '19317'
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` = '19316'
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` = '19315'
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` = '19313'
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` = '19312'
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` = '19311'
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` = '19308'
ORDER BY `chip_change` DESC, `busted` ASC
0.0174 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19306'
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` = '19305'
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` = '19301'
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` = '19298'
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` = '19297'
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` = '19296'
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` = '19293'
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` = '19290'
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` = '19288'
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` = '19286'
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` = '19284'
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` = '19282'
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` = '19281'
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` = '19278'
ORDER BY `chip_change` DESC, `busted` ASC
0.0168 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.0059 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.0061 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` = '457'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19419'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19418'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19413'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19417'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19416'
ORDER BY `chip_change` DESC, `busted` ASC
0.0172 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19415'
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` = '19406'
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` = '19411'
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` = '19404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19401'
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` = '19397'
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` = '19402'
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` = '19396'
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` = '19394'
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` = '19399'
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` = '19391'
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` = '19385'
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` = '19390'
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` = '19389'
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` = '19388'
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` = '19384'
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` = '19387'
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` = '19377'
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` = '19382'
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` = '19375'
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` = '19374'
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` = '19372'
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` = '19368'
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` = '19379'
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` = '19365'
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` = '19363'
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` = '19362'
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` = '19358'
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` = '19356'
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` = '19354'
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` = '19352'
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` = '19351'
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` = '19348'
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` = '19347'
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` = '19344'
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` = '19343'
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` = '19342'
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` = '19341'
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` = '19338'
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` = '19337'
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` = '19336'
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` = '19334'
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` = '19333'
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` = '19331'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19327'
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` = '19326'
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` = '19325'
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` = '19324'
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` = '19322'
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` = '19321'
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` = '19320'
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` = '19317'
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` = '19316'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19315'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19313'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19312'
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` = '19311'
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` = '19308'
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` = '19306'
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` = '19305'
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` = '19301'
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` = '19298'
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` = '19297'
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` = '19296'
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` = '19293'
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` = '19290'
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` = '19288'
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` = '19286'
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` = '19284'
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` = '19282'
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` = '19281'
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` = '19278'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 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.0069 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.
Day 3 of Kings of Tallinn Autumn Edition 2024 Ended Level: 26 Blinds: 20,000/40,000 Ante: 40,000
Serhii Leonov Dominates Day 3 of Kings of Tallinn Autumn Edition Main Event; Bags Chip Lead as Final Table Set Posted Saturday 26th October, 2024 at 21:11(UTC+0) by Frank Visser
Today at noon, 87 players out of 701 returned to Olympic Park Casino for Day 3 of the Kings of Tallinn: Autumn Edition €1,100 Main Event. Serhii Leonov started as an overwhelming chipleader, and, nine and a half hours later, he finished the night with the lead as well.
At a blitzing pace, the field was brought down to the final table of nine players. Leonov bagged 3,550,000, good for 89 big blinds when the final table starts. Leonov chipped up steadily throughout the early stages of the day, but more importantly, he won the majority of his all-ins at the later stage and rode the run-good to the chiplead.
Finnish grinder Elias Suhonen sits only a few blinds behind Leonov, having bagged 3,400,000 after a huge pot with his fellow Finn Mathias Siljander went his way. Siljander still bagged 2,500,000 for a fourth-place spot, while Leonov's fellow countryman Vasyl Laba occupies the last place on the podium with a stack of 3,250,000.
Ruslan Stserbjuk is Estonia's last hope and will bring 2,490,000 to the final table. Meanwhile, Simon Hassan bagged the fewest chips with 715,000, but will still have 18 big blinds at his disposal when play resumes.
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
Day 3 Action
The 87 returning players had bagged the previous night just after the money bubble for the €658,940 prize pool. With 36 players sitting on 15 big blinds or less, it was no surprise that within two hours the field had been cut down by over 30 people. Among the early eliminations were Jari Mahonen (71st - €2,500), Frederik Brink (65th - €2,500), Tarmo Tammel (64th - €2,500), and €550 Championship finalist Koray Kormaz (57th - €2,500).
The pace was expected to slow down, but the opposite proved to be true. The three-table redraw was hit not long after the second break of the day, with the likes of Roope Tarmi (42th - €2,800), Sebastian Wahl (34th - €3,200), Ranno Sootla (29th - €3,600), and Luka Sorainen (28th - €3,600) hitting the rail. Eventually, Aivaras Kerusauskas was eliminated in 25th, leaving three tables in play.
The players moved to the TV area, where the knock-outs kept coming in rapidly. Mitchell Hynam (23rd - €4,300) jammed his ace-jack into the aces of Leonov, helping him to some more chips. Just 15 minutes later, Leonov scored another elimination when his combo draw came in against Krisjaniks Lauks (19th - €4,300). Bahadir Hatipoglu finished in 18th when he four-bet jammed ace-ten off-suit before Julius Kettunen fell to Aku-Oskari Uotila to mark two tables left.
All of this happened within 40 minutes. Dimitrijs Petrenko (16th - €4,300) and Andrejs Perederejevs (15th - €5,600) then departed in the 30 minutes left until the dinner break, which only sent 14 players to eat. Kristiana Stauere got close to her second major final table of the week but ultimately fell in 13th for €7,200.
In keeping with the theme of Day 3, Jose Domene (12th - €7,200), Borge Dypvik (11th - €9,400), and Klaudijus Bajoras (10th - €9,400) were eliminated within fifteen minutes of each other, setting the final table of nine in stone. Those nine players bagged with an average stack of nearly sixty big blinds and will return tomorrow to play out the final table.
The final table will commence tomorrow, October 27, at noon local time. There are 26 minutes and seven seconds remaining in Level 26: 20,000/40,000 (40,000). All other levels will last for 60 minutes each, with a break after every two.
All finalists have locked up a five-figure score of €11,800, but are tantalizingly close to the massive sum of €130,300 that is reserved for the eventual champion.
Final Table Payouts
€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
Day 4 will not stop until a winner is crowned, so be sure to check the blog tomorrow to find out who will be pronounced the champion and win the prestigious Kings of Tallinn trophy.
End of Day 3 Posted Saturday 26th October, 2024 at 20:08(UTC+0) by Frank Visser
With the final table bubble burst, the final nine players have bagged up as the day has ended.
Stay tuned for a full recap of the day.
Player
Chips
Progress
Serhii Leonov
3,550,000
550,000
Elias Suhonen
3,400,000
1,360,000
Vasyl Laba
3,250,000
50,000
Mathias Siljander
2,500,000
0
Ruslan Stserbjuk
2,490,000
590,000
Aku-Oskari Uotila
2,290,000
110,000
Daniel Clifford
1,720,000
280,000
Enea Subashi
1,100,000
0
Simon Hassan
715,000
5,000
Klaudijus Bajoras Eliminated in 10th Place (€9,400) Posted Saturday 26th October, 2024 at 20:03(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 10/701
Mathias Siljander raised to 80,000 from the cutoff. Small blind Klaudijus Bajoras moved all in for 550,000. Siljander took a quick glance at his cards and called immediately.
Klaudijus Bajoras: Mathias Siljander:
The board provided Bajoras with no hope. He was eliminated in tenth as the final table bubble. The remaining nine players bagged up and will return tomorrow at noon to crown a champion.
Player
Chips
Progress
Mathias Siljander
2,500,000
240,000
Klaudijus Bajoras
0
0
Borde Dypvik Eliminated in 11th Place (€9,400) Posted Saturday 26th October, 2024 at 19:59(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 11/701
Borge Dypvik jammed all in for 130,000 under the gun. Ruslan Stserbjuk called in the small blind before Vasyl Laba followed suit in the big blind.
Stserbjuk then bet 175,000 into the dry side pot on the flop, getting rid of Laba's and going to showdown.
Borge Dypvik: Ruslan Stserbjuk:
Dypvik was left to running outs, but the turn left him drawing dead instead. He said his goodbyes as the river rolled off and took his exit in 11th place.
Player
Chips
Progress
Vasyl Laba
3,300,000
615,000
Ruslan Stserbjuk
1,900,000
300,000
Borge Dypvik
0
0
Jose Domene Eliminated in 12th Place (€7,200) Posted Saturday 26th October, 2024 at 19:51(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 12/701
Elias Suhonen raised his button to 80,000 and was called by Jose Domene in the big blind. Domene checked to Suhonen on the flop, and the latter continued for 55,000.
Domene jammed in his stack of 375,000 and was snapped off by Suhonen.
Jose Domene: Elias Suhonen:
Domene's lesser pair did not improve on the runout and he was sent to the rail in 12th place.
Player
Chips
Progress
Elias Suhonen
3,450,000
1,630,000
Jose Domene
0
0
Dypvik Runs Into Aces; Left Critically Short After Doubling Uotila Posted Saturday 26th October, 2024 at 19:51(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 12/701
Borge Dypvik raised to 120,000 on the button. Aku-Oskari Uotila (pictured) sat in the small blind and put in a three-bet to 395,000. Borge spent a few moments thinking before four-bet shoving for 1,300,000.
Uotila snap-called, playing 1,200,000, and the cards were tabled.
Aku-Oskari Uotila: Borde Dypvik:
Dypvik had run into the nuts, and the flop could not save him. He doubled up Uotila and was left with just over three big blinds.
Player
Chips
Progress
Aku-Oskari Uotila
2,400,000
1,200,000
Borge Dypvik
130,000
810,000
Leonov Picks Up Cowboys Posted Saturday 26th October, 2024 at 19:46(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 12/701
Serhii Leonov raised to 110,000 under the gun after finding . Ruslan Stserbjuk called in the cutoff with and Aku-Oskari Uotila defended in the big blind.
Leonov continued for 110,000 on the flop, getting only Stserbjuk along to the turn. Both players checked to the river, where Leonov picked the aggression back up and bet 450,000.
Stserbjuk spent some time in the tank but ultimately found the correct fold. Leonov took the pot and chipped back up to over four million.
Player
Chips
Progress
Serhii Leonov
4,100,000
225,000
Ruslan Stserbjuk
1,600,000
905,000
Aku-Oskari Uotila
1,200,000
230,000
Hassan Hauls Vital Double-Up Posted Saturday 26th October, 2024 at 19:41(UTC+0) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 12/701
Simon Hassan open-jammed his 325,000 from the cutoff. The action folded to Enea Subashi in the big blind, who made the call.
Simon Hassan: Enea Subashi:
Subashi was not granted a set on the runout and thus doubled up Hassan.
"I needed that," Hassan stated as he raked in his chips.
Player
Chips
Progress
Enea Subashi
1,100,000
285,000
Simon Hassan
710,000
365,000
19:33 (UTC+0)
Start of Level 26 Blinds: 20,000/40,000 Ante: 40,000
Suhonen Sends Siljander in Ten-Minute Tank Posted Saturday 26th October, 2024 at 19:33(UTC+0) by Frank Visser
Level 25: 15,000/30,000 (30,000) Entries: 12/701
Mathias Siljander in the small blind had three-bet Elias Suhonen (pictured) in the hijack preflop. Suhonen called and also called when Siljander fired a c-bet on the flop.
With the pot nearing 1,000,000, Siljander then sized up to 575,000 on the turn. Suhonen stuck around and called to the river, where he was checked to.
Suhonen moved all in for 1,130,000. Siljander spent roughly ten minutes tanking before finding a fold and sending the gargantuan pot to his fellow Finn.
Player
Chips
Progress
Elias Suhonen
3,130,000
1,310,000
Mathias Siljander
1,850,000
900,000
Siljander Keeps Stacking at Outer Table Posted Saturday 26th October, 2024 at 19:19(UTC+0) by Frank Visser
Level 25: 15,000/30,000 (30,000) Entries: 12/701
Klaudijus Bajoras raised to 60,000 in the hijack and Mathias Siljander defended his big blind. Bajoras put in a continuation-bet of 50,000 on the flop, seeing his opponent check-call.
The turn was checked through to the river. Siljander piled in 175,000, prompting Bajoris to let go of his cards.
Player
Chips
Progress
Mathias Siljander
3,000,000
890,000
Klaudijus Bajoras
1,000,000
270,000
Kristiana Stauere Eliminated in 13th Place (€7,200) Posted Saturday 26th October, 2024 at 18:54(UTC+0) by Frank Visser
Level 25: 15,000/30,000 (30,000) Entries: 13/701
Kristiana Stauere got her 165,000 in from the hijack against Mathias Siljander under the gun.
Kristiana Stauere: Mathias Siljander:
Stauere had the dominating hand, but that quickly changed when the flop gave Siljander two pair. The turn made Stauere a straight, however, making her a dominate favorite once again.
But, her fate would be sealed on the river. Siljander made a full house and sent Stauere home in 13th, just shy of her second major final table of the week.
Player
Chips
Progress
Mathias Siljander
2,750,000
640,000
Kristiana Stauere
0
0
Max Sanders Eliminated in 14th (€5,600) Posted Saturday 26th October, 2024 at 18:54(UTC+0) by Frank Visser
Level 25: 15,000/30,000 (30,000) Entries: 14/701
Max Sanders raised to 60,000 under the gun. Daniel Clifford three-bet his button to 150,000, after which Sanders moved all in for 505,000.
Clifford snap-called and the cards were flipped up.
Max Sanders: Daniel Clifford:
Sanders turned some chop outs on the board, but the river did nothing for him and he departed in 14th.
Player
Chips
Progress
Daniel Clifford
2,000,000
595,000
Max Sanders
0
0
Stauere Shortest by Far Posted Saturday 26th October, 2024 at 18:51(UTC+0) by Frank Visser
Level 25: 15,000/30,000 (30,000) Entries: 14/701
Kristiana Stauere limped in from the small blind and Klaudijus Bajoras checked his big blind.
Stauere fired 30,000 on the flop but was raised all-in by Bajoras. She quickly folded and had just over five big blinds remaining.
Player
Chips
Progress
Klaudijus Bajoras
1,300,000
415,000
Kristiana Stauere
165,000
190,000
Subashi's Cold-Call Brings No Heat Posted Saturday 26th October, 2024 at 18:38(UTC+0) by Frank Visser
Level 25: 15,000/30,000 (30,000) Entries: 14/701
Jose Domene raised to 60,000 under the gun. Klaudijus Bajors took some time before putting a three-bet to 140,000 on the button, which Enea Subashi in the big blind quickly called.
Domene got out of the way for a flop of to appear. Bajors continued for 130,000 and Subashi check-called. The turn saw Bajors assemble a bet of 300,000, getting a check-fold from Subashi and taking down the pot.
Player
Chips
Progress
Enea Subashi
1,385,000
185,000
Klaudijus Bajoras
1,270,000
385,000
Jose Domene
600,000
40,000
18:29 (UTC+0)
Start of Level 25 Blinds: 15,000/30,000 Ante: 30,000
Dinner Counts Posted Saturday 26th October, 2024 at 17:46(UTC+0) by Frank Visser
Player
Chips
Progress
Serhii Leonov
3,875,000
375,000
Vasyl Laba
2,685,000
485,000
Ruslan Stserbjuk
2,505,000
105,000
Mathias Siljander
2,110,000
10,000
Elias Suhonen
1,820,000
270,000
Enea Subashi
1,570,000
20,000
Aku-Oskari Uotila
1,430,000
170,000
Daniel Clifford
1,405,000
295,000
Borge Dypvik
940,000
960,000
Klaudijus Bajoras
885,000
240,000
Jose Domene
640,000
395,000
Max Sanders
460,000
140,000
Kristiana Stauere
355,000
30,000
Simon Hassan
345,000
280,000
Dinner Time Posted Saturday 26th October, 2024 at 17:43(UTC+0) by Frank Visser
The players have been sent on a 45-minute dinner break.
The coverage is expected to resume at 8:25 p.m. local time.
Stserbjuk Steals From Leonov's Stack Posted Saturday 26th October, 2024 at 17:40(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 14/701
Serhii Leonov raised to 50,000 in middle position with . Ruslan Stserbjuk made it 150,000 to go in the cutoff with , which Leonov called.
The flop checked through. Leonov led out for 125,000 on the turn, seeing Stserbjuk call. The river slowed Leonov down and he check-folded to Stserbjuk's bet of 275,000.
Player
Chips
Progress
Serhii Leonov
3,500,000
300,000
Ruslan Stserbjuk
2,400,000
500,000
Sanders Triples Up Posted Saturday 26th October, 2024 at 17:35(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 14/701
Serhii Leonov raised to 50,000 in the hijack. Ruslan Stserbjuk called on the button before Max Sanders three-bet to 185,000 in the big blind, leaving only 5,000 behind.
The flop checked to Stserbjuk, who bet 220,000. Sanders committed his final chip before Leonov mucked his .
Max Sanders: Ruslan Stserbjuk:
Stserbjuk was drwaing to runner-runner outs. The brought the chance for a chop, but the river changed nothing as Sanders took in his triple-up.
Player
Chips
Progress
Serhii Leonov
3,800,000
200,000
Ruslan Stserbjuk
1,900,000
400,000
Max Sanders
600,000
265,000
Stserbjuk Ships Three-Way Three-Bet Pot Posted Saturday 26th October, 2024 at 17:29(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 14/701
Vasyl Laba saw under the gun and raised to 50,000. Serhii Leonov called with on the button before Ruslan Stserbjuk three-bet to 150,000 in the big blind with .
Both Laba and Leonov called, and a flop of was spread. Stserbjuk fired 175,000 and got both pocket pairs to fold, winning him the sizable pot.
Player
Chips
Progress
Serhii Leonov
4,000,000
705,000
Ruslan Stserbjuk
2,300,000
100,000
Vasyl Laba
2,200,000
1,550,000
Andrejs Perederejevs Eliminated in 15th Place (€5,600) Posted Saturday 26th October, 2024 at 17:22(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 15/701
Andrejs Perederejevs tossed his final 100,000 in from early position. It went to Enea Subushi in the big blind, who shrugged and put in a call.
Andrejs Perederejevs: Enea Subushi:
The window card was amazing for Perederejevs, but the that followed less so. Subushi flopped trips to take a huge lead. Still, Perederejevs turned a flush draw with the for some extra hope.
It all fell flat on the river, however, and he was eliminated in 15th place.
Player
Chips
Progress
Enea Subashi
1,550,000
40,000
Andrejs Perederejevs
0
0
Dimitrijs Petrenko Eliminated in 16th Place (€4,300) Posted Saturday 26th October, 2024 at 17:20(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 16/701
Daniel Clifford raised to 50,000 in middle position. The action folded to Dmitrijs Petrenko in the big blind, who went all in for 660,000.
Clifford called lightning-fast, and the cards were shown to the camera.
Dmitrijs Petrenko: Daniel Clifford:
Petrenko did not see an ace emerge from the deck on the board and was eliminated on the first hand of the final two tables.
Player
Chips
Progress
Daniel Clifford
1,700,000
545,000
Dmitrijs Petrenko
0
0
Julius Kettunen Eliminated in 17th Place (€4,300) Posted Saturday 26th October, 2024 at 16:59(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 17/701
Serhii Leonov raised to 50,000 in the cutoff. Julius Kettunen then tossed in his final 245,000 in the small blind. Aku-Oskari Uotila rejammed in the big blind, folding out Leonov.
Julius Kettunen: Aku-Oskari Uotila:
Kettunen was in bad shape and could not hit his seven on the runout to become the final player eliminated before the two-table redraw.
Player
Chips
Progress
Aku-Oskari Uotila
1,600,000
350,000
Julius Kettunen
0
0
Bahadir Hatipoglu Eliminated in 18th Place (€4,300) Posted Saturday 26th October, 2024 at 16:58(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 18/701
Bahadir Hatipoglu raised to 55,000 under the gun. Mathias Siljander then three-bet to 150,000 in the cutoff, after which Hatipoglu quickly four-bet to 500,000, more than half his stack.
Siljander put his opponent all in and received a call.
Bahadir Hatipoglu: Mathias Siljander:
Hatipoglu was caught making a move, and it went unrewarded when the runout failed to bring him an ace, causing him to be eliminated in 18th place.
Player
Chips
Progress
Mathias Siljander
2,100,000
1,545,000
Bahadir Hatipoglu
0
0
Krisjaniks Lauks Eliminated in 19th Place (€4,300) Posted Saturday 26th October, 2024 at 16:42(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 19/701
Krisjaniks Lauks got his stack of 750,000 in on a flop of against Serhii Leonov.
Krisjaniks Lauks: Serhii Leonov:
Lauks' overpair was up against the combo draw of Leonov, and with the way the Ukrainian had been running, it was no surprise that the turn locked up the pot for him with a straight.
Lauks was left shaking his head as the meaningless river completed the board and he swiftly left the tournament area to collect his payout.
Player
Chips
Progress
Serhii Leonov
4,150,000
1,605,000
Krisjanis Lauks
0
0
Tommy Piiroinen Eliminated in 20th Place (€4,300) Posted Saturday 26th October, 2024 at 16:35(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 20/701
Tommy Piiroinen and Borge Dypvik got their stacks in preflop, with Dypvik's 925,000 being at risk.
Borge Dypvik: Tommy Piiroinen:
Dypvik won "el classico" as the board made him a full house and had Piiroinen drawing dead on the turn. He doubled up while leaving Piiroinen with two big blinds, which he would lose not long after to be eliminated.
Player
Chips
Progress
Borge Dypvik
1,900,000
1,020,000
Tommy Piiroinen
0
0
Mikael Haapaniemi Eliminated in 21st Place (€4,300) Posted Saturday 26th October, 2024 at 16:34(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 21/701
Mikael Haapaniemi open-shoved his last few chips from the small blind and was quickly called by Vasyl Laba in the big blind.
Mikael Haapaniemi: Vasyl Laba:
Laba won the flip as Haapaniemi failed to pair up on the board and was eliminated in 21st.
Player
Chips
Progress
Vasyl Laba
650,000
375,000
Mikael Haapaniemi
0
0
Kristaps Sipols Eliminated in 22nd Place; Mitchell Hynam Eliminated in 23rd Place (€4,300) Posted Saturday 26th October, 2024 at 16:26(UTC+0) by Frank Visser
Level 24: 10,000/25,000 (25,000) Entries: 23/701
Mitchell Hynam (pictured) got his stack of 400,000 or so in from under the gun against Serhii Leonov.
Mitchell Hynam : Serhii Leonov:
Hynam could not perform a miracle and perished against the aces of the chipleader. One hand later, Kristaps Sipols departed from the same table in 22nd.
Player
Chips
Progress
Serhii Leonov
3,100,000
555,000
Kristaps Sipols
0
0
Mitchell Hynam
0
0
16:25 (UTC+0)
Start of Level 24 Blinds: 10,000/25,000 Ante: 25,000
Edas Cimbolas Eliminated in 24th Place (€3,600) Posted Saturday 26th October, 2024 at 16:20(UTC+0) by Frank Visser
Level 23: 10,000/20,000 (20,000) Entries: 24/701
Elias Suhonen opened his button and Edas Cimbolas defended his big blind. The flop fell , and the rest of Cimbolas' 225,000 chips were committed.
Edas Cimbolas: Elias Suhonen:
Cimbolas' flopped pair was behind Suhonen's overpair. The turn removed some of his outs, and the river sealed the deal as Cimbolas was the first to depart from the final three tables.
Player
Chips
Progress
Elias Suhonen
1,550,000
350,000
Edas Cimbolas
0
0
Reporting on Delay Posted Saturday 26th October, 2024 at 15:47(UTC+0) by Frank Visser
Level 23: 10,000/20,000 (20,000) Entries: 24/701
With the final three tables reached, the reporting will move to a 30-minute delay to prevent spoiling the live stream.
Expect the coverage to resume around 6:15 p.m. local time.
Three-Table Redraw Posted Saturday 26th October, 2024 at 15:46(UTC+0) by Frank Visser
Table
Seat
Player
Country
Chip Count
Big Blinds
1
1
Bahadir Hatipoglu
Turkey
625,000
31
1
2
Andrejs Perederejevs
Latvia
360,000
18
1
3
Daniel Clifford
Sweden
1,155,000
58
1
4
Mathias Siljander
Finland
555,000
28
1
5
Klaudijus Bajoras
Lithuania
1,125,000
56
1
6
Jose Domene
Spain
1,035,000
52
1
7
Kristiana Stauere
Latvia
385,000
19
1
8
Julius Kettunen
Finland
300,000
15
2
1
Tommy Piiroinen
Finland
1,110,000
56
2
2
Borge Dypvik
Norway
880,000
44
2
3
Mikael Haapaniemi
Finland
550,000
28
2
4
Vasyl Laba
Ukraine
275,000
14
2
5
Elias Suhonen
Finland
1,200,000
60
2
6
Max Sanders
England
865,000
43
2
7
Edas Cimbolas
Lithuania
300,000
15
2
8
Dmitrijs Petrenko
Latvia
750,000
38
3
1
Mitchell Hynam
England
435,000
22
3
2
Serhii Leonov
Ukraine
2,545,000
127
3
3
Ruslan Stserbjuk
Estonia
2,200,000
110
3
4
Krisjanis Lauks
Latvia
615,000
31
3
5
Aku-Oskari Uotila
Finland
1,250,000
63
3
6
Enea Subashi
Greece
1,590,000
80
3
7
Simon Hassan
Sweden
275,000
14
3
8
Kristaps Sipols
Latvia
250,000
13
Player
Chips
Progress
Serhii Leonov
2,545,000
295,000
Ruslan Stserbjuk
2,200,000
25,000
Enea Subashi
1,590,000
10,000
Aku-Oskari Uotila
1,250,000
200,000
Elias Suhonen
1,200,000
500,000
Daniel Clifford
1,155,000
20,000
Klaudijus Bajoras
1,125,000
25,000
Tommy Piiroinen
1,110,000
15,000
Jose Domene
1,035,000
115,000
Borge Dypvik
880,000
570,000
Max Sanders
865,000
15,000
Dmitrijs Petrenko
750,000
150,000
Bahadir Hatipoglu
625,000
40,000
Krisjanis Lauks
615,000
145,000
Mathias Siljander
555,000
165,000
Mikael Haapaniemi
550,000
115,000
Mitchell Hynam
435,000
30,000
Kristiana Stauere
385,000
35,000
Andrejs Perederejevs
360,000
10,000
Edas Cimbolas
300,000
50,000
Julius Kettunen
300,000
225,000
Simon Hassan
275,000
185,000
Vasyl Laba
275,000
425,000
Simon Hassan
250,000
210,000
Kerusauskas Misses Three-Table Redraw Posted Saturday 26th October, 2024 at 15:23(UTC+0) by Frank Visser
Level 23: 10,000/20,000 (20,000) Entries: 25/701
Klaudius Bajoras had raised preflop and Aivaras Kerusauskas three-bet jammed for 350,000. Bajoras instantly called and the cards were tabled.
Aivaras Kerusauskas: Klaudius Bajoras:
For the second all-in in a row, Bajoras needed a ten. However, this time it did not show itself on the board and Bajoras was eliminated in 25th place.
Player
Chips
Progress
Klaudijus Bajoras
1,100,000
750,000
Aivaras Kerusauskas
0
0
Kerusauskas Survives Posted Saturday 26th October, 2024 at 15:10(UTC+0) by Frank Visser
Level 23: 10,000/20,000 (20,000) Entries: 25/701
Julius Kettunen had opened his button when Aivaras Kerusauskas jammed all in from the small blind for 160,000. Kettunen made a quick call and the cards were tabled.
Aivaras Kerusauskas: Julius Kettunen:
Kettunen was in front big time, but Kerusauskas turned two pair on the board to double up and stay in contention.
Player
Chips
Progress
Julius Kettunen
525,000
195,000
Aivaras Kerusauskas
360,000
70,000
One Elimination Away From Three-Table Redraw Posted Saturday 26th October, 2024 at 15:00(UTC+0) by Frank Visser
Player
Chips
Progress
Kim Rasmussen
0
0
Angel Alonso
0
0
Ranno Sootla
0
0
Sorainen Sent Out by Leonov Posted Saturday 26th October, 2024 at 14:57(UTC+0) by Frank Visser
Level 23: 10,000/20,000 (20,000) Entries: 28/701
Serhii Leonov (pictured) had opened under the gun when Luka Sorainen pushed in his stack of 350,000 from the cutoff. It folded back to Leonov, who made a quick call.
Luka Sorainen: Serhii Leonov:
The flop and turn remained safe for Sorainen, but Leonov's run could not be stopped as the river made him top pair. He eliminated Sorainen, who amicably said his goodbyes before picking up his payout.
Player
Chips
Progress
Serhii Leonov
2,250,000
250,000
Luka Sorainen
0
0
Sipols Left Short After Encounter With Subashi Posted Saturday 26th October, 2024 at 14:50(UTC+0) by Frank Visser
Level 23: 10,000/20,000 (20,000) Entries: 29/701
Kristaps Sipols checked in the hijack on a flop of and Enea Subashi (pictured) fired a bet of 50,000 on the button. Sipols called to the turn, where he check-called another bet, of 95,000.
The river saw Subashi complete his triple barrel as he tossed 150,000 in the middle. Sipols made a reluctant fold and left himself with 10 big blinds.
Player
Chips
Progress
Enea Subashi
1,600,000
370,000
Kristaps Sipols
200,000
225,000
14:38 (UTC+0)
Start of Level 23 Blinds: 10,000/20,000 Ante: 20,000
Updated Counts Posted Saturday 26th October, 2024 at 14:36(UTC+0) by Frank Visser
Player
Chips
Progress
Ruslan Stserbjuk
2,225,000
125,000
Serhii Leonov
2,000,000
100,000
Aku-Oskari Uotila
1,450,000
50,000
Borge Dypvik
1,450,000
85,000
Enea Subashi
1,230,000
45,000
Daniel Clifford
1,175,000
495,000
Jose Domene
1,150,000
20,000
Tommy Piiroinen
1,095,000
205,000
Max Sanders
850,000
365,000
Vasyl Laba
700,000
20,000
Elias Suhonen
700,000
200,000
Dmitrijs Petrenko
600,000
40,000
Bahadir Hatipoglu
585,000
280,000
Krisjanis Lauks
470,000
35,000
Simon Hassan
460,000
122,000
Luka Sorainen
450,000
55,000
Angel Alonso
450,000
183,000
Mikael Haapaniemi
435,000
193,000
Kristaps Sipols
425,000
197,000
Kristiana Stauere
420,000
231,000
Mitchell Hynam
405,000
170,000
Mathias Siljander
390,000
125,000
Andrejs Perederejevs
370,000
35,000
Klaudijus Bajoras
350,000
114,000
Julius Kettunen
330,000
105,000
Aivaras Kerusauskas
290,000
3,000
Kim Rasmussen
265,000
5,000
Edas Cimbolas
250,000
5,000
Ranno Sootla
80,000
350,000
Break Time Posted Saturday 26th October, 2024 at 14:17(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 29/701
The final 29 players have been sent on another 20-minute break.
Kallikorm Departs Pre-Break Posted Saturday 26th October, 2024 at 14:16(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 30/701
Elias Suhonen had raised from middle position when Robert Kallikorm three-bet all in for 107,000 on the button. Suhonen made a quick call and the cards went face-up.
Robert Kallikorm: Elias Suhonen:
Kallikorm hit his ace on the turn, but Suhonen rivered a flush on the river to knock him out anyway. Kallikorm joined Sebastian Wahl and Egidijus Digrys on the rail, who were the other eliminations in this level.
Player
Chips
Progress
Elias Suhonen
900,000
225,000
Egidijus Digrys
0
0
Sebastian Wahl
0
0
Robert Kallikorm
0
0
Kettunen Binks River to Double Up Posted Saturday 26th October, 2024 at 14:11(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 31/701
Julius Kettunen had gotten his stack of 100,000 in the middle from the big blind against Kim Rasmussen on the button.
Julius Kettunen: Kim Rasmussen:
Rasmussen's ace-high remained ahead on the flop and turn, but the river made Kettunen a pair to double up, leaving Rasmussen with 18 big blinds.
Player
Chips
Progress
Kim Rasmussen
270,000
35,000
Julius Kettunen
225,000
5,000
Stserbjuk Sends Vuong Home in Massive Cooler, Plays More Than 2 Million Posted Saturday 26th October, 2024 at 14:07(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 32/701
After several preflop raises, Vu Vuong (pictured) got his stack of 850,000 in the middle from the small blind against Ruslan Stserbjuk in middle position, who covered him.
Vu Vuong: Ruslan Stserbjuk:
It was a massive cooler for a pot worth well over 100 big blinds. Vuong flopped some hope on , but it turned out to be vain as the turn did not improve him and the river made Stserbjuk a set.
He eliminated Vuong, who had an above-average stack, and took over the lead in the tournament.
Player
Chips
Progress
Ruslan Stserbjuk
2,100,000
1,891,000
Vu Vuong
0
0
Quinn Last to Leave on Five Tables Posted Saturday 26th October, 2024 at 13:57(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 33/701
Jose Domene ni the big blind and Edward Quinn under the gun were heads up on a turn of . Domene checked to Quinn, who fired a bet. Domene then put Quinn all-in for 370,000, which the latter snap-called.
Edward Quinn: Jose Domene:
Quinn needed help against the two pair of Domene, but the Spaniard made a full house on the river instead to eliminate the Irishman in 33rd.
Player
Chips
Progress
Jose Domene
1,170,000
415,000
Edward Quinn
0
0
Laba Best on Three-Way River Posted Saturday 26th October, 2024 at 13:49(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 34/701
Hijack Vasyl Laba, cutoff Kristaps Sipols, and button Bahadir Hatipoglu were three-way on a turn of . Laba checked to Sipols, who bet 54,000. Both Hatipoglu and Laba called and the river was dealt.
Sipols fired 83,000, this time folding out Hatipoglu. Laba called after a minute in the tank, however, and tabled for trip tens. Sipols' were the lesser trips, and he lost the sizable pot to Laba
Player
Chips
Progress
Bahadir Hatipoglu
865,000
214,000
Vasy Laba
680,000
70,000
Kristaps Sipols
622,000
48,000
Dypvik and Suhonen Play Four-Bet Pot Posted Saturday 26th October, 2024 at 13:44(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 34/701
Bjorge Dypvik had raised under the gun when Elias Suhonen three-bet to 95,000 in the seat next to him. The action folded back to Dypvik, who clicked it back to 255,000.
Suhonen put in a call to the flop, but there he folded to the 175,000 Dypvik put in the middle.
Player
Chips
Progress
Borge Dypvik
1,535,000
285,000
Elias Suhonen
675,000
240,000
Other Assorted Counts Posted Saturday 26th October, 2024 at 13:36(UTC+0) by Frank Visser
Player
Chips
Progress
Aku-Oskari Uotila
1,400,000
470,000
Borge Dypvik
1,250,000
316,000
Edward Quinn
340,000
80,000
Edas Cimbolas
245,000
95,000
Robert Kallikorm
215,000
80,000
Lazauninkas Does Not Survive Wide Jam Posted Saturday 26th October, 2024 at 13:35(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 35/701
Serhii Leonov had open-raised his button when Gytis Lazauninkas jammed all in for 260,000 in the big blind. Leonov asked for a count and then made the call.
Gytis Lazauninkas: Serhii Leonov:
Lazauninkas was very live against Leonov's hand, but he did not pair up on the runout and was thus eliminated.
Player
Chips
Progress
Serhii Leonov
1,900,000
360,000
Gytis Lazauninkas
0
0
Domene and Suhonen Play Three-Bet Pot Posted Saturday 26th October, 2024 at 13:32(UTC+0) by Frank Visser
Level 22: 10,000/15,000 (15,000) Entries: 35/701
Jose Domene raised his hijack to 30,000. Elias Suhonen three-bet to 115,000 from the small blind and Domene put in a call. Suhonen continued for 90,000 on the board, receiving a call from Domene.
Suhonen then checked the turn. Domene thought for a while before putting in a bet of 150,000, which was snap-folded to by Suhonen.
Player
Chips
Progress
Elias Suhonen
915,000
85,000
Jose Domene
755,000
15,000
13:17 (UTC+0)
Start of Level 22 Blinds: 10,000/15,000 Ante: 15,000
Last Eliminations From Level 21 Posted Saturday 26th October, 2024 at 13:17(UTC+0) by Frank Visser
Player
Chips
Progress
Kasper Mellanen
0
0
Edikas Jurgutis
0
0
Eero Abbey
0
0
Jae Han Kim
0
0
Habib Heads Home Posted Saturday 26th October, 2024 at 13:13(UTC+0) by Frank Visser
Level 21: 6,000/12,000 (12,000) Entries: 39/701
Jawad Habib open-jammed from early position for 132,000. Dmitrijs Petrenko called on the button, after which the blinds folded.
Jawad Habib: Dmitrijs Petrenko:
Habib needed an ace, but none came on the board and he was consequently eliminated.
Player
Chips
Progress
Dmitrijs Petrenko
640,000
331,000
Jawad Habib
0
0
Leonov's Pressure Leaves Two Short Posted Saturday 26th October, 2024 at 13:04(UTC+0) by Frank Visser
Level 21: 6,000/12,000 (12,000) Entries: 40/701
Julius Kettunen raised to 24,000 in the hijack and was called by Serhii Leonov on the button and Edikas Jurgutis, who only played 53,000 in total, in the big blind.
Kettunen continued for 14,000 on the flop, seeing Leonov call and Jurgutis check-fold. Kettunen slowed down on the turn and checked to his opponent.
Leonov picked up the aggression and fired 55,000. Kettunen made a quick call to the river, which he checked again. Leonov then put him all-in for 220,000 and Kettunen folded after some thinking time.
Player
Chips
Progress
Serhii Leonov
1,540,000
290,000
Julius Kettunen
220,000
185,000
Edikas Jurgutis
29,000
71,000
Five Tables Remain Posted Saturday 26th October, 2024 at 12:53(UTC+0) by Frank Visser
Player
Chips
Progress
Mindaugas Kriaciunas
0
0
Roope Tarmi
0
0
Jarkko Suokas
0
0
Westerlund Winning No More Posted Saturday 26th October, 2024 at 12:45(UTC+0) by Frank Visser
Level 21: 6,000/12,000 (12,000) Entries: 42/701
Jenny Westerlund four-bet jammed for 292,000 under the gun and was called by Vu Vuong in the cutoff, who had three-bet her.
Jenny Westerlund: Vu Vuong:
Vuong's superior pair held without a sweat on the runout and he eliminated Westerlund in the process.
Player
Chips
Progress
Vu Vuong
1,040,000
375,000
Jenny Westerlund
0
0
Gontsar Gone After Five-Way Flop Posted Saturday 26th October, 2024 at 12:42(UTC+0) by Frank Visser
Level 21: 6,000/12,000 (12,000) Entries: 44/701
Daniel Clifford raised to 25,000 in the hijack. Vasyl Laba called in the cutoff, as did Kristaps Sipols on the button. Bahadir Hatipoglu came along from the small blind before Aleksei Gontsar defended his big blind.
Hatipoglu checked the flop to Gontsar, who jammed all in for 167,000. Clifford and Laba quickly folded before Sipols made the call. Hatipoglu also got out of the way and the cards were shown.
Aleksei Gontsar: Kristaps Sipols:
Gontsar needed running cards to stay in the tournament, but the turn had him drawing dead instead. He said his goodbyes as the river rolled off and collected his payout.
Player
Chips
Progress
Vasy Laba
750,000
160,000
Daniel Clifford
680,000
135,000
Kristaps Sipols
670,000
290,000
Bahadir Hatipoglu
651,000
99,000
Mitchell Hynam
575,000
110,000
Max Sanders
485,000
80,000
Aleksei Gontsar
0
0
Bajoras Saved by River Posted Saturday 26th October, 2024 at 12:24(UTC+0) by Frank Visser
Level 21: 6,000/12,000 (12,000) Entries: 45/701
Klaudijus Bajoras moved all in for 103,000 under the gun and was called by chipleader Serhii Leonov in the hijack.
Klaudijus Bajoras: Serhii Leonov:
It looked like game over for Bajoras on the flop, and the turn gave him no relief either.
He stood up from his chair but quickly sat back down as the river completed the board. He had rivered a set to double up and take some chips off of Leonov's huge stack.
Player
Chips
Progress
Serhii Leonov
1,250,000
100,000
Klaudijus Bajoras
236,000
121,000
12:17 (UTC+0)
Start of Level 21 Blinds: 6,000/12,000 Ante: 12,000
Full Chip Counts Posted Saturday 26th October, 2024 at 12:16(UTC+0) by Frank Visser
Player
Chips
Progress
Serhii Leonov
1,350,000
298,000
Enea Subashi
1,275,000
220,000
Borge Dypvik
934,000
514,000
Aku-Oskari Uotila
930,000
770,000
Vasy Laba
910,000
460,000
Tommy Piiroinen
890,000
10,000
Elias Suhonen
830,000
66,000
Bahadir Hatipoglu
750,000
212,000
Jose Domene
740,000
336,000
Vu Vuong
665,000
200,000
Kristiana Stauere
651,000
302,000
Angel Alonso
633,000
32,000
Egidijus Digrys
615,000
203,000
Daniel Clifford
545,000
174,000
Luka Sorainen
505,000
68,000
Mitchell Hynam
465,000
87,000
Krisjanis Lauks
435,000
19,000
Ranno Sootla
430,000
132,000
Max Sanders
405,000
30,000
Julius Kettunen
405,000
10,000
Eero Abbey
400,000
15,000
Jae Han Kim
380,000
29,000
Kristaps Sipols
380,000
35,000
Roope Tarmi
370,000
291,000
Simon Hassan
338,000
9,000
Andrejs Perederejevs
335,000
226,000
Gytis Lazauninkas
335,000
89,000
Jenny Westerlund
330,000
17,000
Dmitrijs Petrenko
309,000
227,000
Kim Rasmussen
305,000
228,000
Aivaras Kerusauskas
293,000
33,000
Kasper Mellanen
284,000
33,000
Mathias Siljander
265,000
186,000
Edward Quinn
260,000
65,000
Mikael Haapaniemi
242,000
161,000
Aleksei Gontsar
225,000
105,000
Ruslan Stserbjuk
209,000
109,000
Jawad Habib
204,000
64,000
Edas Cimbolas
150,000
115,000
Robert Kallikorm
135,000
69,000
Mindaugas Kriaciunas
125,000
120,000
Sebastian Wahl
122,000
116,000
Klaudijus Bajoras
115,000
10,000
Edikas Jurgutis
100,000
66,000
Jarkko Suokas
69,000
183,000
First Break of Day 3 Posted Saturday 26th October, 2024 at 11:55(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 45/701
The players have been sent on their first 20-minute break of the day.
Latest Eliminations Posted Saturday 26th October, 2024 at 11:55(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 45/701
Player
Chips
Progress
Henri Ojala
0
0
Kaspars Renga
0
0
Dmitri Dudakov
0
0
Rolands Norietis
0
0
Rytis Strigunas
0
0
David Bright
0
0
Kalle Parkkinen
0
0
Aleksandr Januskevic
0
0
Adrian Luezas
0
0
Pekka Ikonen
0
0
Kriaciunas Doubles With Quads Posted Saturday 26th October, 2024 at 11:51(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 47/701
Enea Subashi raised to 20,000 in middle position. Mindaugas Kriauciunas put in 70,000 in the hijack and Subashi called.
The flop checked through before Subashi led out for 15,000 on the turn. Kriaciunas called to the river, where he was put all-in for 25,000.
He instantly called. Subashi tabled for an ace kicker but Kriaciunas casually showed quads with to double up.
Player
Chips
Progress
Enea Subashi
1,055,000
70,000
Mindaugas Kriaciunas
245,000
186,000
Insane Cooler Eliminates Kulanurk and Kiidli; Subashi Surpasses Seven Figures Posted Saturday 26th October, 2024 at 11:41(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 52/701
Kaius Kiidli open-jammed from 110,000 under the gun. Enea Subashi called in early position and the action folded to Artur Kulanurk (pictured) in the big blind. He put his own stack of 190,000 in the middle and was snap-called by Subashi.
Kaius Kiidli: Artur Kulanurk: Enea Subashi:
The flop was an explosive one. Kulanruk flopped top set to have a huge shot at cracking Subashi's aces, while Kiidli remained alive with a gutshot.
However, the turn reversed the situation. Subashi regained his monstrous lead with a set of aces and left Kulanurk with one out. The river changed nothing, eliminating both Estonians at the hands of Subashi.
Player
Chips
Progress
Enea Subashi
1,125,000
413,000
Artur Kulanurk
0
0
Kaius Kiidli
0
0
Korkmaz's Run at Second Final Table Ends Posted Saturday 26th October, 2024 at 11:27(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 57/701
Tommy Piiroinen made it 20,000 to go in the hijack. Koray Korkmaz then went all in for 190,000 on the button and the action folded back to Piiroinen.
He sat in the tank for several minutes before finally electing to call.
Koray Korkmaz: Tommy Piiroinen:
"I had a bad feeling," Piiroinen explained himself. However, it turned out his feelings misled him as the runout gave his tens no trouble and knocked out Korkmaz.
Player
Chips
Progress
Tommy Piiroinen
900,000
247,000
Koray Korkmaz
0
0
Hatipoglu Hauls Huge Double-Up Posted Saturday 26th October, 2024 at 11:23(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 57/701
Vasyl Laba raised to 20,000 on the button. Rytis Strigunas flat-called in the small blind before Bahadir Hatipoglu went all in for 254,000 in the big blind.
Laba quickly folded but Strigunas snap-called with the covering stack.
Bahadir Hatipoglu: Rytis Strigunas:
Hatipoglu flopped a pair on put Strigunas made a gutshot. The turn changed nothing while the turn rivered Hatipoglu chips to rake in the double-up.
Strigunas, meanwhile, was left with just five big blinds.
Player
Chips
Progress
Bahadir Hatipoglu
538,000
258,000
Vasy Laba
450,000
55,000
Rytis Strigunas
50,000
225,000
Kettunen Shoves on Luezas Posted Saturday 26th October, 2024 at 11:11(UTC+0) by Frank Visser
Level 20: 5,000/10,000 (10,000) Entries: 58/701
Julius Kettunen raised to 20,000 under the gun and was three-bet to 50,000 by his neighbor Adrian Luezas. It folded back to Kettunen, who called.
Luezas continued for 30,000 on the flop and Kettunen check-called. The turn was checked through before Kettunen went all in for 210,000 on the river.
Luezas snap-folded and the pot was shipped to Kettunen.
Player
Chips
Progress
Kristaps Sipols
415,000
97,000
Julius Kettunen
395,000
85,000
Eero Abbey
385,000
6,000
Aivaras Kerusauskas
260,000
123,000
Adrian Luezas
230,000
47,000
David Bright
206,000
179,000
Aleksei Gontsar
120,000
4,000
Ruslan Stserbjuk
100,000
14,000
10:55 (UTC+0)
Start of Level 20 Blinds: 5,000/10,000 Ante: 10,000
Remaining Eliminations in Level 19 Posted Saturday 26th October, 2024 at 10:55(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 58/701
Player
Chips
Progress
Bartosz Mielczarek
0
0
Josep Pastor
0
0
Andrius Janca
0
0
Vadim Guk
0
0
Roberts Rumba
0
0
Frederik Brink
0
0
Tarmo Tammel
0
0
Samuli Segerman
0
0
Gert Laanemets
0
0
Albert Ostrovskij
0
0
Gintaras Naglius
0
0
Jezov Runs Into Laba's Aces Posted Saturday 26th October, 2024 at 10:52(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 63/701
Roman Jezov open-jammed for 61,000 under the gun. Vasyl Laba (pictured) cut out calling chips and put them in the middle from the hijack, after which the rest of the table folded.
Roman Jezov: Vasyl Laba:
Jezov had run into the nuts, but the flop gave him some hope. His straight draw failed to come in on the turn or river, however, and he was eliminated during the first level of the day.
Player
Chips
Progress
Vasy Laba
505,000
315,000
Roman Jezov
0
0
Gontsar Finds Another Double Posted Saturday 26th October, 2024 at 10:44(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 69/701
Aleksei Gontsar had 52,000, which he got in from the button against Julius Kettunen in the hijack.
Aleksei Gontsar: Julius Kettunen:
Kettunen was a heavy underdog and was drawing dead after the turn. He paid off Gontsar as the hit the river, seeing him turn his stack of two and a half big blinds at the start of the day to one of 15 big blinds.
Player
Chips
Progress
Julius Kettunen
310,000
171,000
Aleksei Gontsar
124,000
103,000
Other Victims of Bust-Out Bonanza Posted Saturday 26th October, 2024 at 10:31(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 70/701
Player
Chips
Progress
Jari Mahonen
0
0
Oskar Silins
0
0
Mark Metsla
0
0
Miki Vea
0
0
Mantas Stikelis
0
0
Joonas Helin
0
0
Martynas Saltis
0
0
Stanislovas Vinicenka
0
0
Taago Tamm
0
0
Gonzalo Salinas
0
0
Hai Hoang
0
0
Jussi Hietalahti
0
0
Stanislav Smeljov
0
0
Johan Alen
0
0
Algirdas Sukys
0
0
Rulis' Victory Ruled Out by Sanders Posted Saturday 26th October, 2024 at 10:26(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 81/701
Irmantas Rulis had open-jammed his final 50,000 or so from middle position and was called by Max Sanders (pictured) in the big blind.
Irmantas Rulis: Max Sanders:
Rulis' pair remained ahead on the board until the gave Sanders a better pair on the river. Rulis departed from the Main Event and left to pick up his min-cash.
Player
Chips
Progress
Max Sanders
375,000
65,000
Irmantas Rulis
0
0
Bilat Busts Blind-on-Blind Posted Saturday 26th October, 2024 at 10:21(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 83/701
Andzej Bilat tossed in his last 70,000 or so from the small blind and was called by Edward Quinn (pictured) in the big blind.
Andzej Bilat: Edward Quinn:
The flop brought Bilat two extra outs, but neither a queen nor an ace was in store on the runout. Quinn departed the Main Event after playing only a few hands on Day 3.
Player
Chips
Progress
Edward Quinn
325,000
80,000
Andzej Bilat
0
0
Westerlund Three-Bet Jams Turn Posted Saturday 26th October, 2024 at 10:17(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 85/701
The action was caught on a turn of . Sofia Westerlund bet 27,000 into a pot of 90,000 under the gun, which Vu Vuong raised to 80,000 in the hijack.
Westerlund fought back with an all-in three-bet of 172,000. Vuong spent a while in the tank but eventually knocked the table and folded his cards.
Player
Chips
Progress
Vu Vuong
465,000
85,000
Jenny Westerlund
347,000
137,000
Day 2 Underway Posted Saturday 26th October, 2024 at 10:04(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 87/701
The 87 returning players have found their seats and the cards are in the air for the third day of the Main Event.
10:03 (UTC+0)
Day 3 of Kings of Tallinn Autumn Edition 2024 Started Level: 19 Blinds: 4,000/8,000 Ante: 8,000
Serhii Leonov Brings Monster Lead Into Day 3 of Kings of Tallinn: Autumn Edition Main Event Posted Saturday 26th October, 2024 at 08:57(UTC+0) by Frank Visser
The first-ever Kings of Tallinn: Autumn Edition €1,100 Main Event was a huge success, attracting 701 entries to Olympic Park Casino and smashing the €500,000 guarantee with a prize pool of €658,940. Today, 87 players return for Day 3, all in the money as the tournament stopped when the bubble burst yesterday.
Leading the pack is Ukraine's Serhii Leonov. This is not Leonov's first Kings of Tallinn, but it will be his first Main Event cash. However, Leonov will not be thinking about the min-cash he made as he accumulated 1,052,000 chips on Day 2, more than four times the average stack, worth 132 big blinds. Rather, his mind will be occupied with the €130,300 first-place prize. Leonov will have to reach the final table to match his best-ever live score, and he has made a good start in doing so with his monster chip lead.
Finnish grinder Elias Suhonen sits in second with 896,000 and is the only other player with more than 100 big blinds. Suhonen is no stranger in Tallinn and is hunting his second Kings of Tallinn trophy. His best result in the Main Event is 32nd place in 2021, aiming to improve that placement this time. Greek player Enea Subashi completes the podium with a stack of 712,000 as he booked back-to-back Main Event cashes, while 2015 Main Event winner and bracelet holder Ranno Sootla is the best Estonian in seventh.
Top Ten Chip Counts
Rank
Player
Country
Chip Count
Big Blinds
1
Serhii Leonov
Ukraine
1,052,000
132
2
Elias Suhonen
Finland
896,000
112
3
Enea Subashi
Greece
712,000
89
4
Angel Alonso
Spain
665,000
83
5
Tommy Piiroinen
Finland
653,000
82
6
Luka Sorainen
Finland
573,000
72
7
Ranno Sootla
Estonia
562,000
70
8
Mitchell Hynam
United Kingdom
552,000
69
9
Vu Vuong
Finland
550,000
69
10
Dmitrijs Petrenko
Latvia
536,000
67
Max Sanders (310,000), Gytis Lazauninkas (246,000), Sebastian Wahl (238,000), Jari Mahonen (80,000), Roope Tarmi (79,000), Henri Ojala (53,000), and Tarmo Tammel (19,000) are also among the returning players, while the two remaining ladies Kristiana Stauere and Jenny Westerlund have healthy stacks of 349,000 and 210,000 respectively.
Jenny Westerlund
All returning players have locked up a min-cash of €2,200. Five-figure payouts will start when the final table of nine is reached, which is scheduled to be the ending point of Day 3, meaning another long day of poker is in the cards for the players.
€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
10-11
€9,400
12-13
€7,200
14-15
€5,600
16-23
€4,300
24-31
€3,600
32-39
€3,200
40-55
€2,800
56-71
€2,500
72-87
€2,200
With 36 players returning with 15 big blinds or less after a long bubble, the beginning stages of Day 3 promise to be fast and explosive. Blinds will restart with 52 minutes and 58 seconds on the clock in Level 19: 4,000/8,000 (8,000). Each subsequent level will have a duration of 60 minutes, with a break after every two levels.
As stated, Day 3 is scheduled to play down to the final table, so be sure to check in with the live report to find out who books their seat on the big stage at the inaugural 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.