0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0074 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-10-28' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/3/updates' ORDER BY `views` DESC

0.0525 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-10-28' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/3/updates'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0001 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.0001 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.0004 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.0070 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.0353 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.0066 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '212'

0.1279 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0276 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '455' AND `published` = 1

0.1845 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.1540 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '457' AND `published` = 1

0.1045 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0110 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '460' AND `published` = 1

0.0135 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '212' AND `name` = '3'

0.0256 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.0500 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.0138 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19420' ORDER BY `chip_change` DESC, `busted` ASC

0.0257 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0190 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0513 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0252 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0253 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0374 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0326 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0323 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0293 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0393 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0606 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19397' ORDER BY `chip_change` DESC, `busted` ASC

0.0930 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0263 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0332 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0410 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0206 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0191 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0197 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0459 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0314 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0194 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0475 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0310 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0641 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19375' ORDER BY `chip_change` DESC, `busted` ASC

0.0135 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0298 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0494 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0342 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0274 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0476 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0141 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0332 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0431 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0220 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0710 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0133 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19351' ORDER BY `chip_change` DESC, `busted` ASC

0.0202 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19348' ORDER BY `chip_change` DESC, `busted` ASC

0.0346 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0442 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0395 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0258 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0372 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0101 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0460 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0544 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0139 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1837 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0193 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0277 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19327' ORDER BY `chip_change` DESC, `busted` ASC

0.0429 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0192 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0257 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0466 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0258 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0256 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0483 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0436 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1629 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0124 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0249 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0198 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19308' ORDER BY `chip_change` DESC, `busted` ASC

0.0351 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19305' ORDER BY `chip_change` DESC, `busted` ASC

0.0468 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1467 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0187 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0337 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0434 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0213 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0256 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1113 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0414 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0207 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0196 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1147 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0786 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.0192 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.0877 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.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` = '19420' ORDER BY `chip_change` DESC, `busted` ASC

0.0893 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0126 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0923 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0524 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19407' ORDER BY `chip_change` DESC, `busted` ASC

0.0138 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19416' 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` = '19415' ORDER BY `chip_change` DESC, `busted` ASC

0.0200 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0940 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19404' ORDER BY `chip_change` DESC, `busted` ASC

0.0141 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19397' ORDER BY `chip_change` DESC, `busted` ASC

0.0294 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0200 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0130 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0249 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0410 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0129 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0097 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19390' ORDER BY `chip_change` DESC, `busted` ASC

0.0128 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0155 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19388' ORDER BY `chip_change` DESC, `busted` ASC

0.0196 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0365 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0076 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19377' 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` = '19382' ORDER BY `chip_change` DESC, `busted` ASC

0.0080 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19374' 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` = '19372' 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` = '19368' 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` = '19379' 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` = '19365' 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` = '19363' ORDER BY `chip_change` DESC, `busted` ASC

0.0274 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19358' 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` = '19356' 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` = '19354' 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` = '19352' 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` = '19351' 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` = '19348' 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` = '19347' 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` = '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.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` = '19342' 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` = '19341' ORDER BY `chip_change` DESC, `busted` ASC

0.0274 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19336' 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` = '19334' 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` = '19333' 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` = '19331' 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` = '19327' 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` = '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.0076 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19324' 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` = '19322' 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` = '19321' ORDER BY `chip_change` DESC, `busted` ASC

0.0280 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19317' ORDER BY `chip_change` DESC, `busted` ASC

0.0117 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19315' ORDER BY `chip_change` DESC, `busted` ASC

0.0147 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.0483 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19306' 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` = '19305' 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` = '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.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` = '19297' 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` = '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.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` = '19290' 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` = '19288' 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` = '19286' 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` = '19284' ORDER BY `chip_change` DESC, `busted` ASC

0.0271 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '19281' 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` = '19278' ORDER BY `chip_change` DESC, `busted` ASC

0.0063 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_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

English
Kings of Tallinn Autumn Edition 2024 Event #31: Kings of Tallinn €1,100 Main Event Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 3
21:20 (UTC+0)
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 EventSerhii 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 . More 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.