0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-23' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/2/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/2/updates', 1, '2024-12-23')

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.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

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

0.0001 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.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0005 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0040 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.0006 SECONDS:
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `friendly_url` = 'kings_of_tallinn_autumn_2024_main_event'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '212'

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

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

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

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '212' AND `name` = '2'

0.0061 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.0061 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '455' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '19277' 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` = '19276' 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` = '19275' 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` = '19272' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0059 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '455' ORDER BY `busted` ASC, `current_chips` DESC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '455' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '19277' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

0.0072 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19251' 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` = '19250' 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` = '19248' 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` = '19246' 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` = '19244' 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` = '19243' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0061 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '19225' 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` = '19224' 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` = '19223' 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` = '19222' 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` = '19218' 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` = '19217' 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` = '19215' 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` = '19212' 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` = '19209' 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` = '19208' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0059 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '455' ORDER BY `busted` ASC, `current_chips` DESC

0.0058 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '457' ORDER BY `busted` ASC, `current_chips` DESC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '460' ORDER BY `busted` ASC, `current_chips` DESC

0.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 2
00:51 (UTC+0)
Day 2 of Kings of Tallinn Autumn Edition 2024 Ended
Level: 19     Blinds: 4,000/8,000     Ante: 8,000
Rolandas Aglinskas Ends Extended Day 2 of €1,100 Main Event as Bubble Boy; 87 Progress Posted Saturday 26th October, 2024 at 00:51(UTC+0) by Frank Visser

It was a long day at Olympic Park Casino today. After 13 hours of play, the bubble in the Kings of Tallinn: Autumn Edition €1,100 Main Event had burst, securing the 87 surviving players a share of the €658,940 prize pool. But one man's gain is another man's loss, and this time it was Rolandas Aglinskas who was on the losing side. The Lithuanian player spent 13 hours playing his heart out only to end up in 88th place as the stone bubble after he was a big favorite preflop.

Immediately after Aglinskas' departure, the remaining 87 bagged up for Day 3. Serhii Leonov from Ukraine profited the most from the bubble, being the only player to bag a seven-figure stack. He grabbed the chip lead with 1,052,000, more than four times the average stacks, and a whopping 132 big blinds at the start of Day 3.

Leonov already had a respectable stack throughout the later part of the day, but he really started climbing the ranks when he picked off an overbet bluff by fellow top ten stack Angel Alonso on the soft bubble. He then spent the next 80 minutes exerting bubble pressure to end up with his massive pile of chips.

Meanwhile, Finnish regular Elias Suhonen was the only other player to end up with more than 100 big blinds as he ended the day with 896,000. Greek player Enea Subashi completes the top three with a stack of 712,000 while Luka Sorainen, Estonia's biggest stack Ranno Sootla, and Mitchell Hynam also secured a spot in the top ten.

End of Day 2 Top Ten Chip Counts

Rank Player Country Chip Count Big Blinds
1 Serhii Leonov Ukraine 1,052,00 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


Among the other survivors are 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).

Day 2 Action

Day 2 started with four levels of late registration still to go. After it had closed, the clock read 701 entries, of which 214 still remained. Quick goodbyes were said to €555 Championship runner-up Rasmus Lundstrom, Norwegian mixed game crusher Espen Sandvik, and Estonian poker mainstays Igor Pihela Sr. and Igor Pihela Jr.



Joshua Stewart
Juha Helppi, Aleksi Naski, and Markku Koplimaa also fell outside the top 100. The pace of play then slowed down significantly as the bubble kept creeping closer. Ermo Kosk was among the chipleaders with 105 left but was eliminated in 92nd about 90 minutes later. Gediminas Zimaitis fell in 90th and hand-for-hand play began shortly after, with two eliminations to go before the money.

It only took around 15 minutes to lose the first player when Ignas Navickas shoved his last chips into Subashi. However, the stone bubble lasted for no less than 45 minutes. In fact, Day 2 was supposed to end after Level 18 had been completed, but the tournament directors decided to play out the bubble, and Level 19 was reached.

Ultimately, it was in that level that Aglinskas became the bubble boy. His king-jack lost against the jack-seven of Samuli Segerman as a wave of relief and celebration went through the tournament room. The 87 remaining players had secured a min-cash of €2,200, but the big stacks will be more concerned with the massive €130,300 reserved for the eventual champion.

€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

Day 3 will commence tomorrow, October 26, at noon local time. Play will resume in Level 19: 4,000/8,000 with an 8,000 big blind ante. There are 52 minutes and 58 seconds remaining in said level, after which each subsequent level will last for 60 minutes.

The exact plan for Day 3 is not yet known, so be sure to check back in tomorrow as an exciting post-bubble bust-out bonanza is awaiting the prestigious Main Event.

End of Day 2 Chip Counts Posted Friday 25th October, 2024 at 23:58(UTC+0) by Frank Visser
Player Chips Progress
Serhii Leonov 1,052,000 272,000
Elias Suhonen 896,000 296,000
Enea Subashi 712,000 47,000
Angel Alonso 665,000 25,000
Tommy Piiroinen 653,000 333,000
Luka Sorainen 573,000 32,000
Ranno Sootla 562,000 0
Mitchell Hynam 552,000 0
Vu Vuong 550,000 51,000
Dmitrijs Petrenko 536,000 271,000
Josep Pastor 497,000 375,500
Julius Kettunen 481,000 46,000
Kalle Parkkinen 481,000 22,000
Borge Dypvik 420,000 5,000
Krisjanis Lauks 416,000 1,000
Egidijus Digrys 412,000 78,000
Jae Han Kim 409,000 199,000
Jose Domene 404,000 59,000
David Bright 385,000 93,000
Aivaras Kerusauskas 383,000 33,000
Eero Abbey 379,000 44,000
Daniel Clifford 371,000 0
Kristiana Stauere 349,000 209,000
Simon Hassan 329,000 129,000
Kristaps Sipols 318,000 272,000
Kasper Mellanen 317,000 57,000
Max Sanders 310,000 110,000
Albert Ostrovskij 287,000 18,000
Vadim Guk 285,000 200,000
Bahadir Hatipoglu 280,000 152,500
Artur Kulanurk 276,000 46,000
Jawad Habib 268,000 156,000
Edas Cimbolas 265,000 80,000
Pekka Ikonen 257,000 150,200
Kaius Kiidli 256,000 24,000
Jarkko Suokas 252,000 22,000
Gytis Lazauninkas 246,000 166,000
Edward Quinn 245,000 0
Sebastian Wahl 238,000 80,000
Jenny Westerlund 210,000 35,000
Martynas Saltis 209,000 39,000
Dmitri Dudakov 193,000 92,000
Vasy Laba 190,000 23,000
Adrian Luezas 183,000 102,000
Aku-Oskari Uotila 160,000 140,000
Samuli Segerman 150,000 2,000
Andrius Janca 147,000 133,000
Roman Jezov 130,000 30,000
Gert Laanemets 125,000 125,000
Rolands Norietis 120,000 13,000
Aleksandr Januskevic 120,000 0
Ruslan Stserbjuk 114,000 0
Andrejs Perederejevs 109,000 71,000
Stanislovas Vinicenka 106,000 51,000
Kaspars Renga 105,000 20,000
Klaudijus Bajoras 105,000 95,000
Mantas Stikelis 105,000 145,000
Gintaras Naglius 88,000 53,700
Jussi Hietalahti 85,000 30,000
Mikael Haapaniemi 81,000 84,000
Jari Mahonen 80,000 0
Stanislav Smeljov 80,000 67,000
Mathias Siljander 79,000 1,000
Roope Tarmi 79,000 101,000
Kim Rasmussen 77,000 22,000
Taago Tamm 77,000 38,000
Joonas Helin 74,000 116,000
Mark Metsla 68,000 3,000
Koray Korkmaz 67,000 8,000
Robert Kallikorm 66,000 134,000
Roberts Rumba 63,000 12,000
Miki Vea 62,000 0
Gonzalo Salinas 60,000 0
Mindaugas Kriaciunas 59,000 47,000
Johan Alen 56,000 0
Henri Ojala 53,000 172,000
Irmantas Rulis 50,000 0
Andzej Bilat 45,000 0
Bartosz Mielczarek 36,000 329,000
Edikas Jurgutis 34,000 56,000
Frederik Brink 32,000 37,000
Aleksei Gontsar 21,000 69,000
Tarmo Tammel 19,000 41,000
Oskar Silins 19,000 117,000
Hai Hoang 12,000 68,000
Day 2 Concludes Posted Friday 25th October, 2024 at 23:09(UTC+0) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 87/701

After an extended Day 2, the bubble of the Main Even has burst and the 87 remaining players have bagged their chips up.

Stay tuned for full chip counts and a recap of the day.

Rolandas Aglinskas Eliminated as Bubble Boy Posted Friday 25th October, 2024 at 23:04(UTC+0) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 88/701

Rolandas Aglinskas put his last 26,000 in from early position. The table then folded to Samuli Segerman in the big blind, who called.

Rolandas Aglinskas:
Samuli Segerman:

Aglinskas was in the best position he could be, dominating his opponent. The flop brought him no trouble, but the room fell dead silent as the turn gave Segerman a flush draw.

Aglinskas slammed his chair as the river arrived. Segerman had made a flush and the room exploded in cheers and applause. Aglinskas was the last to leave the room empty-handed as 87 players bagged up for Day 3.

Player Chips Progress
Samuli Segerman 152,000 22,000
Rolandas Aglinskas 0 0
Dypvik Shoves on Siljander Posted Friday 25th October, 2024 at 22:51(UTC+0) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 88/701

Borge Dypvik in the hijack and Mathias Siljander in the cutoff had created a pot of 90,000 when they both checked through the flop.

The emerged from the deck on the turn and saw Dypvik put Siljander all-in for 80,000. Siljander made a quick fold as the bubble continued.

Player Chips Progress
Borge Dypvik 425,000 85,000
Mathias Siljander 80,000 50,000
22:50 (UTC+0)
Start of Level 19
Blinds: 4,000/8,000     Ante: 8,000
Bubble Trouble? No, Bubble Triple! Posted Friday 25th October, 2024 at 22:38(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 88/701

Roberts Rumba had pushed his final chips in on a flop of . Aivaras Kerusauskas called in middle position and Julius Kettunen did so in the small blind, creating a pot of 75,000

The pair then checked through the turn and river for the side pot, and a showdown was had. Kerusauskas tabled for a pair of sixes while Kettunen showed for a pair of nines.

Rumba had the best hand with , however, and he let out a maniacal laugh while tripling up with his flush.

Player Chips Progress
Julius Kettunen 435,000 130,000
Aivaras Kerusauskas 350,000 200,500
Roberts Rumba 75,000 11,000
Kiidli Gets Some Value Posted Friday 25th October, 2024 at 22:30(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 88/701

Samuli Segerman checked from the big blind to Kaius Kiidli in the hijack on a turn of . He then bet 16,000 and Segerman put in a call.

The river was checked down. Segerman tabled for bottom pair and lost some chips to the of Kiidli, who won the pot with top pair.

Player Chips Progress
Kaius Kiidli 280,000 10,000
Samuli Segerman 130,000 20,000
Nada for Navickas Posted Friday 25th October, 2024 at 22:15(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Ignas Navickas had shoved all in for 25,000 in the hijack. Enea Subashi called in the cutoff and the cards went open once all other tables had finished.

Ignas Navickas:
Enea Subashi:

Navickas was slightly ahead and gained a bigger lead once the flop missed Subashi. The turn paired the Greek up, however, and the river could not save Navickas from being eliminated.

The field was left with 88 players, which means it had arrived on the stone bubble.

Player Chips Progress
Enea Subashi 665,000 150,000
Ignas Navickas 0 0
First All-In and Call Sees Brink Bink Posted Friday 25th October, 2024 at 22:08(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Frederik Brink open-jammed his last 27,000 under the gun. It folded to Kim Rasmussen in the big blind, who called off.

Frederik Brink:
Kim Rasmussen:

Brink needed to fade a nine to stay in contention for a cash, and he did so when the board brought him no trouble.

Player Chips Progress
Frederik Brink 69,000 70,600
Kim Rasmussen 55,000 103,800
Sorainen Puts Max-Imum Bubble Pressure Posted Friday 25th October, 2024 at 21:58(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Small blind Max Sanders checked on a completed board of . Big blind Luka Sorainen then put Sanders all-in for 200,000, a bet worth twice the pot.

Sanders spent some minutes as he agonizingly went over the hand but he ultimately decided to fold and the next hand was dealt.

Player Chips Progress
Luka Sorainen 605,000 80,000
Max Sanders 200,000 25,000
Tamm Doubles as Hand-for-Hand Begins Posted Friday 25th October, 2024 at 21:52(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Taago Tamm open-shoved his button for 53,000. Ignas Navickas slowly peeled his cards in the big blind, thought for some time, and then called.

Taago Tamm:
Ignas Navickas:

It was looking like Tamm would be eliminated as the penultimate player without cash, especially when the flop brought no help.

However, he made a runner-runner flush on the runout, doubling up and leaving Navickas with less than five big blinds.

After the hand, the floor announced that the tournament would go hand-for-hand with 89 players remaining. The day will not finish before the money is reached, even if that means an extra level is needed.

Player Chips Progress
Taago Tamm 115,000 65,000
Ignas Navickas 23,000 82,000
Zimaitis Falls to Leonov's Surge Posted Friday 25th October, 2024 at 21:43(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 90/701

Gediminas Zimaitis got his final 37,000 in from the big blind against Serhii Leonov in the hijack.

Gediminas Zimaitis:
Serhii Leonov:

Leonov was the only player to pair his hole cards on the board and eliminated Zimaitis three spots from the money.

Player Chips Progress
Serhii Leonov 780,000 30,000
Gediminas Zimaitis 0 0
Leonov and Alonso Play for Piles Posted Friday 25th October, 2024 at 21:39(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 90/701

Serhii Leonov (pictured) in the big blind and Angel Alonso under the gun had already inflated the pot to 100,000 by the time the turn was dealt. Leonov then checked and Alonso put in an overbet of 150,000.

Undeterred, Leonov called to the river, which went check-check. Leonov showed for second pair and took down the pot when Alonso's cards hit the muck.

Player Chips Progress
Serhii Leonov 750,000 250,000
Angel Alonso 690,000 188,000
Ostrovskij Hero Calls Westerlund at Crucial Stage Posted Friday 25th October, 2024 at 21:29(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 91/701

Arriving on a completed board of , Albert Ostrovskij checked form the small blind to Jenny Westerlund in the hijack.

Westerlund fired 50,000 into the pot of 80,000, sending Ostrovskij into the tank. After five minutes or so, he slammed in a call.

"Good call," Westerlund said as she sheepishly showed . Ostrovskij tabled for third pair and raked in the important pot.

Player Chips Progress
Albert Ostrovskij 305,000 253,000
Jenny Westerlund 175,000 212,000
21:16 (UTC+0)
Start of Level 18
Blinds: 3,000/6,000     Ante: 6,000
Getting Tantalizingly Close to the Money Posted Friday 25th October, 2024 at 21:14(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 91/701

Player Chips Progress
Ermo Kosk 0 0
Vasilijus Piskunovas 0 0
Danel Kunman 0 0
Nobody Expects the Spanish Inquisition, Not Even the Spanish Posted Friday 25th October, 2024 at 21:10(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 93/701

Adria Comas jammed all in for 53,000 in early position. The action folded to his fellow countryman Jose Domene, who called off after some thinking time.

Adria Comas:
Jose Larios:

Comas could not pair up on the board, sending him out six away from the money.

Player Chips Progress
Jose Domene 345,000 55,000
Adria Comas 0 0
Tamm Left Short on Soft Bubble as Wahl Doubles Posted Friday 25th October, 2024 at 21:02(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 93/701

Sebastian Wahl got his 74,000 in preflop from the hijack against Taago Tamm (pictured) in the small blind.

Sebastian Wahl:
Taago Tamm:

Wahl faded the ace on the runout, doubling him up. Tamm, meanwhile, was left with exactly ten big blinds.

Player Chips Progress
Sebastian Wahl 158,000 31,000
Taago Tamm 50,000 50,000
Asking Nicely Not Enough for Ajamaa Posted Friday 25th October, 2024 at 20:54(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 95/701

Krisjanis Lauks raised to 10,000 in the hijack. Kaur Ajamaa then committed his stack of 40,000 from the cutoff and Lauks called after some thinking time.

Kaur Ajamaa:
Krisjanis Lauks:

Ajamaa was a big favorite to double up, but the flop left him shaking his head. The offered him no improvement.

"Ace, please," he asked calmly before the river completed the board. No ace fell, and Ajamaa was eliminated just a few spots from the money.

Player Chips Progress
Krisjanis Lauks 415,000 85,000
Kaur Ajaama 0 0
Departures Since Break Posted Friday 25th October, 2024 at 20:47(UTC+0) by Frank Visser
Player Chips Progress
Mykhailo Mikhalov 0 0
Karolis Kutkauskas 0 0
Rasins Picks Wrong Time to Hero Posted Friday 25th October, 2024 at 20:45(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 99/701

Andris Rasins checked in early position on a completed board of . With a modest pot of 65,000 in the middle, Luka Sorainen over-bet all in.

Rasins snap-called for his stack of 80,000 and showed . However, Sorainen tabled for a set of eights and knocked Rasins out a dozen spots from the money.

Player Chips Progress
Luka Sorainen 525,000 35,000
Andris Rasins 0 0
Kettunen Takes It on Turn Posted Friday 25th October, 2024 at 20:32(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 101/701

Rolands Norietis raised to 12,000 in middle position. Julius Kettunen three-bet to 45,000 in the small blind and Norietis called.

Kettunen continued for 30,000 on the board, which Norietis called. The fell on the turn and saw Kettunen size up to 55,000.

Norietis had seen enough and quickly let go of his hand as he forfeited the pot.

Player Chips Progress
Julius Kettunen 305,000 160,000
Jose Domene 290,000 247,000
Klaudijus Bajoras 200,000 157,700
Rolands Norietis 107,000 98,000
Aleksei Gontsar 90,000 27,500
Edikas Jurgutis 90,000 195,000
Koray Korkmaz 75,000 41,000
Adria Comas 60,000 32,600
20:16 (UTC+0)
Start of Level 17
Blinds: 2,000/5,000     Ante: 5,000
Late-Night Leaders Posted Friday 25th October, 2024 at 20:10(UTC+0) by Frank Visser
Player Chips Progress
Vu Vuong 601,000 181,000
Elias Suhonen 600,000 328,000
Kristaps Sipols 590,000 90,000
Enea Subashi 515,000 105,000
Angel Alonso 502,000 28,000
Serhii Leonov 500,000 290,000
Egidijus Digrys 490,000 150,000
Kalle Parkkinen 459,000 324,000
Final Break of Day 2 Posted Friday 25th October, 2024 at 19:57(UTC+0) by Frank Visser

The 103 remaining players have been sent on their last 20-minute break of the night.

When they return, two more 60-minute levels will be played before the survivors bag up for Day 3.

Pre-Break Bust-Outs Posted Friday 25th October, 2024 at 19:55(UTC+0) by Frank Visser
Player Chips Progress
Zahid Bhuiyan 0 0
Kris Tikka 0 0
Kosk Wins Massive Three-Way Three-Bet Pot Posted Friday 25th October, 2024 at 19:44(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 105/701

Serhii Leonov had open-raised from early position and Ermo Kosk had called in the hijack. Aku-Oskari Uotila then put in a three-bet from the big blind, which both Leonov and Kosk called.

Once the flop graced the table, the pot had already grown to 90,000. Uotila continued for 18,000 and saw two calls once again. He then sized up to 40,000 on the turn, but again neither opponent got out of the way.

The river completed a flush draw, and it checked to Kosk, who bet 100,000. Uotila quickly mucked while Leonov took about 30 seconds to put his opponent on exactly jack-ten of spades. He consequently folded, showing the as he did so.

Player Chips Progress
Angel Alonso 530,000 165,000
Ermo Kosk 474,000 329,000
Aku-Oskari Uotila 300,000 15,000
Serhii Leonov 210,000 35,000
Joonas Helin 190,000 40,000
Roope Tarmi 180,000 105,000
Stanislav Smeljov 147,000 0
Gediminas Zimaitis 77,000 133,000
Tarmo Tammel 60,000 53,000
Berggren Starts Trek Home Posted Friday 25th October, 2024 at 19:29(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 110/701

In a three-bet pot worth around 50,000, David Berggren checked from middle position to preflop aggressor Adrian Luezas in the cutoff.

The flop read , and Luezas made a bet of 19,000. Berggren then quickly raised all in for 75,000 and was snapped off.

David Berggren:
Adrian Luezas:

Berggren was pipped. The turn provided some hope with a flush draw, but the river changed nothing. Berggren saw his chips being added to Luezas' stack and headed to the exit.

Player Chips Progress
Adrian Luezas 285,000 125,000
David Berggren 0 0
Rumba Hoovers Up Double-Up Posted Friday 25th October, 2024 at 19:16(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 113/701

Roberts Rumba open-jammed his 27,000 chips and was called by his neighbor Sauli Haapaniemi. 

Roberts Rumba:
Sauli Haapaniemi:

"Good luck, but to be honest, I hope you don't win," Haapaniemi said.

However, Rumba would win when the flop paired him up and the runout bricked out, doubling him up

Player Chips Progress
Sauli Haapaniemi 130,000 8,000
Roberts Rumba 64,000 51,000
Further Bust-Outs Posted Friday 25th October, 2024 at 19:09(UTC+0) by Frank Visser
Player Chips Progress
Jarmo Salonen 0 0
Aleksi Naski 0 0
Jonatan Fors 0 0
Justina Andriukeviciute 0 0
Ismo Barlund 0 0
Michael Engstrom 0 0
Risto Parnat 0 0
Rytis Pranarauskas 0 0
Daniel Smith 0 0
Iodis Falls into Lauks' Trap Posted Friday 25th October, 2024 at 19:03(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 123/701

Max Sanders had raised in early position and Krijanis Lauks (pictured) called in the small blind. Kanstantsin Iodis then jammed all in for 29,000. Sanders called but Lauks had other plans and back-raised to 89,000.

Sanders was baffled and thought for a while before mucking his hand.

Kanstantsin Iodis:
Krijanis Lauks:

"Wow, you did trap me!" Sanders exclaimed surprised. Meanwhile, the runout could not crack Lauks' kings and Iodis hit the rail.

Player Chips Progress
Krisjanis Lauks 330,000 40,000
Max Sanders 225,000 25,000
Kanstantsin Iodis 0 0
18:58 (UTC+0)
Start of Level 16
Blinds: 2,000/4,000     Ante: 4,000
Start-of-Day Leader Koistinen Bluffs Final Chips Off Posted Friday 25th October, 2024 at 18:58(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 125/701

Big blind Mikael Koistinen was checked to on a turn of by Dmitrijs Petrenko. He decided to bet 18,000 into the 33,000 pot, which Petrenko called.

The river brought the . Petrenko checked again, after which Koistinen jammed all in for 37,000. Petrenko mulled it over for 30 seconds or so but ultimately made the call.

Koistinen stood up and showed for king-high. Petrenko showed for top pair and knocked the start-of-day chipleader out before the money.

Player Chips Progress
Dmitrijs Petrenko 265,000 60,000
Mikael Koistinen 0 0
Saviaho Surrenders Final Chips Posted Friday 25th October, 2024 at 18:42(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 131/701

Jari Saviaho jammed his last 25,000 on the button and was looked up by Jussi Hietalahti in the big blind.

Jari Saviaho:
Jussi Hietalahti:

The runout did not bring a king, sendeing Saviaho to the rail.

Player Chips Progress
Jussi Hietalahti 115,000 94,800
Jari Saviaho 0 0
Juha Helppi Among Recent Eliminations Posted Friday 25th October, 2024 at 18:36(UTC+0) by Frank Visser

Player Chips Progress
Elias Vaaraniemi 0 0
Juha Helppi 0 0
Martin Keskkula 0 0
Sergei Kuznetsov 0 0
Erik Byhlin 0 0
Joonas Lyttinen 0 0
Jamie Dwan 0 0
Petrenko and Haapaniemi Play Friendly Three-Bet Pot Posted Friday 25th October, 2024 at 18:32(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 137/701

Dimitijs Petrenko in early position checked to three-better Mikael Haapaniemi (pictured) in the cutoff. He bet a measly 5,000 into a pot of 45,000 with a flop of on the table.

Petrenko called before the turn and river were checked through. Haapaniemi showed for top pair, but Petrenko had the better kicker and won the pot with .

Player Chips Progress
Dmitrijs Petrenko 205,000 175,000
Mikael Haapaniemi 165,000 42,300
Kerusauskas Holds to Double Posted Friday 25th October, 2024 at 18:25(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 140/701

Aivaras Kerusauskas in the hijack had three-bet Sauli Haapaniemi in early position preflop. Haapaniemi had called and checked the flop to Kerusauskas.

Kerusauskas then added 15,000 to the pot of 41,500, after which Haapaniemi quickly moved all in. Kerusauskas sighed but made a quick call for his stack of 54,000 regardless.

Aivaras Kerusauskas:
Sauli Haapaniemi:

Kerusauskas had the superior pair, and while the turn brought Haapaniemi a gutshot, the river gave him a set to double up.

Player Chips Progress
Aivaras Kerusauskas 149,500 49,500
Sauli Haapaniemi 122,000 68,000
Tarmi's Chips Get Flushed to Uotila Posted Friday 25th October, 2024 at 18:11(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 146/701

The action was picked up on a completed board of . Aku-Oskari Uotila (pictured) checked from the big blind to Roope Tarmi under the gun. Tarmi bet 35,000 into a pot of 30,000, which Uotila raised to 95,000.

Tarmi spent some time in the tank but ultimately called off. Uotila tabled for a flush and Tarmi's cards flew into the muck in defeat.

Player Chips Progress
Aku-Oskari Uotila 315,000 209,200
Roope Tarmi 75,000 1,000
17:56 (UTC+0)
Start of Level 15
Blinds: 1,500/3,000     Ante: 3,000
Assorted Dinner Counts Posted Friday 25th October, 2024 at 17:56(UTC+0) by Frank Visser
Player Chips Progress
Kristaps Sipols 500,000 437,000
Luka Sorainen 490,000 10,000
Vu Vuong 420,000 240,000
Enea Subashi 410,000 160,000
Jenny Westerlund 387,000 290,000
Bartosz Mielczarek 365,000 329,700
Angel Alonso 365,000 85,000
Borge Dypvik 340,000 200,000
Eero Abbey 335,000 70,000
Tommy Piiroinen 320,000 219,000
Kaius Kiidli 290,000 141,900
Krisjanis Lauks 290,000 15,000
Dmitri Dudakov 285,000 75,000
Edikas Jurgutis 285,000 61,000
Andrius Janca 280,000 230,000
Rytis Strigunas 275,000 86,300
Elias Suhonen 272,000 175,300
Kasper Mellanen 260,000 168,000
Gert Laanemets 250,000 0
Mantas Stikelis 250,000 20,000
Jarkko Suokas 230,000 200,000
Ismo Barlund 225,000 185,500
Henri Ojala 225,000 150,000
Jae Han Kim 210,000 180,000
Simon Hassan 200,000 152,600
Robert Kallikorm 200,000 90,200
Sauli Haapaniemi 190,000 136,500
Vasilijus Piskunovas 190,000 15,000
Edas Cimbolas 185,000 64,900
David Berggren 180,000 83,300
Martynas Saltis 170,000 12,500
Adrian Luezas 160,000 27,000
Aleksi Naski 160,000 20,000
Stanislav Smeljov 147,000 43,700
Julius Kettunen 145,000 115,000
Ermo Kosk 145,000 107,200
Daniel Smith 140,000 110,000
Martin Keskkula 135,000 25,200
Kalle Parkkinen 135,000 20,500
Zahid Bhuiyan 130,000 100,000
Sebastian Wahl 127,000 89,000
Kaspars Renga 125,000 85,000
Roberts Rumba 115,000 85,000
Ignas Navickas 105,000 50,000
Risto Parnat 105,000 12,300
Taago Tamm 100,000 70,000
Roman Jezov 100,000 64,400
Aivaras Kerusauskas 100,000 63,900
Vadim Guk 85,000 1,200
Hai Hoang 80,000 2,500
Michael Engstrom 65,000 35,000
Gonzalo Salinas 60,000 1,600
Stanislovas Vinicenka 55,000 25,000
Andrej Koriakin 55,000 49,200
Joonas Lyttinen 53,000 66,000
Mathias Siljander 30,000 12,800
Dinner Bell Rings Posted Friday 25th October, 2024 at 16:58(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 149/701

The remaining players have been sent on a 60-minute dinner break.

The tournament is expected to resume at 7:55 p.m. local time.

Alonso Jams River in Four-Bet Pot Posted Friday 25th October, 2024 at 16:57(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 151/701

Serhii Leonov had open-raised from the cutoff when Angel Alonso three-bet to 14,000 on the button. Leonov then made it 35,000 to go, which Alonso called.

Leonov fired 27,000 on the flop, receiving a call from Alonso. The turn was checked through before Leonov made a bet of 45,000 on the river.

Alonso pondered momentarily and then shoved all in for 150,000. Leonov took one last look at his cards before sending them to the muck, giving up on the pot.

Player Chips Progress
Angel Alonso 280,000 167,800
Serhii Leonov 175,000 75,000
Recent Eliminations Posted Friday 25th October, 2024 at 16:45(UTC+0) by Frank Visser
Player Chips Progress
Igor Pihela Sr. 0 0
Andre Magi 0 0
Joona Tuomi 0 0
Justas Vaiciulionis 0 0
Vismands Menjoks 0 0
Nils Linden 0 0
Juho Harkonen 0 0
Lauks Knocks Out Two Posted Friday 25th October, 2024 at 16:36(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 159/701

Audrius Navickas had raised preflop, after which Marius Morel jammed for about 25,000. Krisjanis Lauks (pictured) called cold, after which Navickas four-bet all in for 115,000.

Lauks snap-called with the covering stack, tabling all three holdings.

Marius Morel:
Audrius Navickas:
Krisjanis Lauks: 

The runout gave all players a full house, but Lauks' aces remained best as he eliminated both opponents.

"Man, I wish I got aces against kings," monster stack Luka Sorainen jokingly quipped.

Player Chips Progress
Luka Sorainen 500,000 157,000
Krisjanis Lauks 275,000 245,000
Audrius Navickas 0 0
Marius Morel 0 0
Numbers Confirmed; Payout Information Posted Friday 25th October, 2024 at 16:19(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 164/701

The 701 entries have created a prize pool of €658,940. 87 players will see a payday of at least €2,200, while the eventual champion walks away with €130,300.

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

Parkkinen Flips to Double-Up Posted Friday 25th October, 2024 at 16:10(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 170/701

Jamie Dwan raised to 5,000 under the gun. Vasilijus Piskunovas then three-bet to 14,000 in the seat next over before the action folded to Kalle Parkkinen in the big blind.

He counted his 53,000 chips before committing them to the middle. Dwan quickly got out of the way before Piskunovas snap-called.

Kalle Parkkinen:
Vasilijus Piskunovas:

Piskunovas remained ahead on the flopn but the turn gave Parkkinen a pair. The river did not bring a queen, doubling up Parkkinen.

Player Chips Progress
Vasilijus Piskunovas 175,000 25,000
Kalle Parkkinen 114,500 84,500
Jamie Dwan 70,000 60,000
15:56 (UTC+0)
Start of Level 14
Blinds: 1,000/2,500     Ante: 2,500
Saltis Seeks Double Posted Friday 25th October, 2024 at 15:55(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 181/701

Martynas Saltis had raised to 4,500 under the gun when Aleksi Naski called in the cutoff. Ignas Navickas then three-bet to 20,000 on the button.

With the action back on him, Saltis jammed all in for 74,000. Naski quickly got out of the way while Navickas stuck in a quick call.

Martynas Saltis:
Ignas Navickas:

Navickas needed a jack to knock out Saltis, but none came on the board and he doubled him up instead.

Player Chips Progress
Aleksi Naski 180,000 30,000
Martynas Saltis 157,500 127,500
Ignas Navickas 55,000 36,900
Assorted Eliminations Posted Friday 25th October, 2024 at 15:44(UTC+0) by Frank Visser
Player Chips Progress
Fritz Nygren 0 0
Ari Soini 0 0
Gianluca Trebbi 0 0
Johan Martinsen 0 0
Mario Munoz 0 0
Artjom Petskurov 0 0
Viktors Kurovs 0 0
Sven Omland 0 0
Victor Prior 0 0
Raimo Reimann 0 0
Jari-Pekka Juhola 0 0
Ville-Tappio Mesiranta 0 0
Rasmus Lundstrom 0 0
Michel Karim 0 0
Tommi Hakala 0 0
Kerem Hanno 0 0
Jauring Runs Into Aces Posted Friday 25th October, 2024 at 15:34(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 187/701

Joonas Helin had raised to 4,000 and Justas Vaiciulionis had called. Gediminas Zimaitis then three-bet to 15,000, which Rolf Jauring four-bet to 34,500.

The action folded back to Zimaitis, who put Jauring all-in for 65,000 in total. Jauring snap-called and the cards went on their backs.

Rolf Jauring:
Gediminas Zimaitis:

With one king reportedly folded by another player, Zimaitis flopped Jauring dead on . The runout was of little importance as Jauring knuckled the table and took his leave.

Player Chips Progress
Joonas Helin 230,000 200,000
Gediminas Zimaitis 210,000 177,300
Justas Vaiciulionis 55,000 25,000
Rolf Jauring 0 0
Vihervuori Experiences Death by Quads from Tarmi Posted Friday 25th October, 2024 at 15:16(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 200/701

Miska Vihervuori open-jammed for 38,000 in early position. It folded to Roope Tarmi in the big blind, who called off for 36,500.

Roope Tarmi:
Miska Vihervuori:

Tarmi took a massive lead on the flop and left his opponent drawing dead on the turn. The river gave him quads as the cherry on top. He doubled up and left Vihervuori with 1,500, which he would lose not much later.

Player Chips Progress
Roope Tarmi 76,000 43,900
Miska Vihervuori 0 0
Andriukevicute Doubles Fresh Stack Posted Friday 25th October, 2024 at 15:08(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 211/701

Justina Andriukevicute was one of the last entries, and she raised to 4,000 under the gun. Albert Ostrovskij defended his big blind, after which a flop of was spread.

Andriukevicute made a bet, which Ostrovskij check-raised to 8,000. Andriukevicute then three-bet all in for 26,000. Ostrovskij spent a few minutes playing with his chips and exhaling air before finally tossing in a call.

Justina Andriukeviciute:
Albert Ostrovskij:

Both players had an open-ender, but only Andriukeviciute's came in on the runout to double her up.

Player Chips Progress
Justina Andriukeviciute 63,000 33,000
Albert Ostrovskij 52,000 22,000
14:56 (UTC+0)
Start of Level 13
Blinds: 1,000/2,000     Ante: 2,000
Big Stacks on Break Posted Friday 25th October, 2024 at 14:48(UTC+0) by Frank Visser
Player Chips Progress
Karolis Kutkauskas 345,000 228,300
Luka Sorainen 343,000 93,000
Egidijus Digrys 340,000 167,100
Mantas Stikelis 270,000 30,000
Eero Abbey 265,000 60,000
Enea Subashi 250,000 130,000
Last Three Re-Entry Hands, Break After Posted Friday 25th October, 2024 at 14:25(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 207/687

The last three hands for re-entry are being dealt, after which the players will be sent on a 20-minute break.

After the break, late registraion will be closed and the numbers will be finalized.

Vuong Makes Adventurous Call to Chip Up Further Posted Friday 25th October, 2024 at 14:22(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 200/676

Sten Talviste tossed in his last 30,000 chips from the big blind and was looked up by Vo Vuang (pictured) on the button.

Sten Talviste:
Vo Vuang:

The flop made Talviste top pair, and the turn helped neither player. The made Vuang a flush, however, knocking out Talviste just before the break.

Player Chips Progress
Vu Vuong 180,000 109,200
Sten Talviste 0 0
Perederejevs Rebuilds by Knocking Out Kilkanen Posted Friday 25th October, 2024 at 14:13(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 199/674

Fritz Nygren made a raise to 3,000 in early position. Andrejs Perederejevs made it 8,500 to go in the cutoff, after which Tero Kilkanen called all-in for less.

Nygren also tossed in a call, after which he check-called 5,000 on the flop. Perederejevs sized up to 16,000 on the turn, which forced a check-fold from Nygren.

Tero Kilkanen:
Andrejs Perederejevs:

Kilkanen was still live, but the river did not improve his hand, meaning the end of this bullet.

Player Chips Progress
Andrejs Perederejevs 180,000 40,000
Fritz Nygren 165,000 15,000
Tero Kilkanen 0 0
Renga Makes Munoz Bluff Posted Friday 25th October, 2024 at 14:03(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 203/671

Kaspars Renga raised to 3,000 under the gun before Mario Munoz (pictured) made it 9,000 to go in the hijack. It folded back to Renga, who called to the flop. 

There, he check-called the 7,000 bet of Munoz before the turn went check-check. Renga also checked the river, prompting Munoz to bet 18,500.

Renga instantly called. Munoz sheepishly tabled for jack-high while Renga had the winning wheel with .

Player Chips Progress
Kaspars Renga 210,000 77,300
Mario Munoz 60,000 43,000
Dobre Departs Posted Friday 25th October, 2024 at 13:49(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 201/661

Marcel Dobre got his last 23,700 in against Borge Dypvik.

Marcel Dobre:
Borge Dypvik:

The runout did not contain a seven, sending Dobre out.

Player Chips Progress
Borge Dypvik 140,000 12,000
Marcel Dobre 0 0
Lazauninkas Loses to Linden Posted Friday 25th October, 2024 at 13:37(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 203/656

Erik Linden had pushed his stack of 23,700 in against Gytis Lazauninkas, who covered him.

Erik Linden:
Gytis Lazauninkas:

Linden had his ticket ready to hand to the dealer, but the board made him a pair of aces to win the pot and double up.

Player Chips Progress
Gytis Lazauninkas 80,000 20,000
Erik Linden 64,400 34,400
13:25 (UTC+0)
Start of Level 12
Blinds: 1,000/1,500     Ante: 1,500
Right Read, Wrong Call Posted Friday 25th October, 2024 at 13:25(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 211/654

47,000 chips were in the middle when big blind Edikas Jurgutis (pictured) bet 38,500 on a completed board of .

His opponent was Jawad Habib in middle position, who spent a few minutes in the tank. "Do you have a set?" Habib asked moments before slamming in a call.

Jurgutis indeed tabled for bottom set. Habib nodded his head and mucked his cards as the massive pot headed to Jurgutis.

Player Chips Progress
Edikas Jurgutis 224,000 124,000
Mindaugas Kriaciunas 138,000 32,000
Elias Vaaraniemi 114,000 2,000
Jawad Habib 112,000 44,400
Juho Harkonen 65,000 5,700
Jarmo Salonen 33,200 10,200
Albert Ostrovskij 30,000 0
Martynas Saltis 26,000 4,000
Tool Bluffs Big Slick, Lundstrom Calls Posted Friday 25th October, 2024 at 13:15(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 214/651

The completed board read when Steven Tool made an all-in bet into a pot of 70,000 from the big blind.

His opponent was Rasmus Lundstrom (pictured), who was at risk for 20,200 and made the call.

"Good call," Tool said as he turned over for top pair. Lundstrom had called with two pair, , and doubled up in the big pot.

Player Chips Progress
Rasmus Lundstrom 110,400 32,600
Steven Tool 35,000 26,900
Byhlin Building a Stack Posted Friday 25th October, 2024 at 13:03(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 217/649

Bjorge Dypvik was first to act and raised to 2,500. It folded to Erik Byhlin in the small blind, who three-bet to 11,000. Dypvik complied with a call and saw a flop of .

Byhlin fired 12,000 and received a quick call from Dypvik. He then sized up to 30,000 on the turn, which was enough to let Dypvik fold his hand.

Player Chips Progress
Erik Byhlin 166,000 136,000
Borge Dypvik 128,000 22,000
Hatipoglu Cracks Pihela Sr.'s Kings Posted Friday 25th October, 2024 at 12:49(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 219/645

Bahadir Hatipoglu had gone all in for 62,900 before the flop and was looked up by Igor Pihela Sr. (pictured).

Bahadir Hatipoglu:
Igor Pihela Sr.:

Hatipoglu stood up after the flop, but "Barry" came looking on the river. Hatipoglu cheered loudly and sat back down with double the number of chips.

Player Chips Progress
Bahadir Hatipoglu 127,500 97,500
Igor Pihela Sr. 85,000 15,000
Linden Back to Start After Paying Laba's Overbet Posted Friday 25th October, 2024 at 12:44(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 221/643

There were 34,000 chips in the pot when the board was completed. Vasyl Laba (pictured) sat in middle position and pondered for a bit before making a bet of 50,000.

His opponent was Nils Linden in the hijack, who quickly called. Laba turned over for a set of eights, causing Linden to add his cards to the muck.

Player Chips Progress
Vasy Laba 167,000 77,100
Nils Linden 30,000 0
Naglius Returns With Double-Up Posted Friday 25th October, 2024 at 12:32(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 231/643

Gintaras Naglius tossed in 15,000 from the big blind and was called by Hanno Kerem in early position.

Gintaras Naglius:
Hanno Kerem:

Naglius had Kerem pipped. That remained the case on the runout to double Naglius up.

Player Chips Progress
Gintaras Naglius 34,300 4,300
Kerem Hanno 17,500 12,500
12:24 (UTC+0)
Start of Level 11
Blinds: 600/1,200     Ante: 1,200
Biggest Stacks in the Room Posted Friday 25th October, 2024 at 12:19(UTC+0) by Frank Visser
Player Chips Progress
Mantas Stikelis 300,000 188,900
David Bright 292,000 88,900
Luka Sorainen 250,000 22,000
Patrik Zidek 230,000 158,400
Artur Kulanurk 230,000 149,600
Andrejs Perederejevs 220,000 2,500
Aleksi Naski 210,000 88,000
Dmitri Dudakov 210,000 8,700
Rolands Norietis 205,000 175,000
Mikael Koistinen 192,000 61,400
First Break Posted Friday 25th October, 2024 at 12:05(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 225/635

The players have been sent on a 20-minute break.

Soini Doubles Through Sorainen Posted Friday 25th October, 2024 at 12:00(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 229/634

Ari Soini got his 20,000 chips in the middle against Luka Sorainen, who had accumulated an even bigger stack than he started the day with.

Ari Soini:
Luka Sorainen:

Soini locked up the pot on the turn, leaving the river meaningless. Sorainen tossed Soini a few of his chips and play continued.

Player Chips Progress
Luka Sorainen 272,000 71,200
Ari Soini 43,000 13,000
Three-Way All-In Sees Two Worst Hands Win Posted Friday 25th October, 2024 at 11:52(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 228/630

Andre Magi was all-in for 18,400, Kristaps Sipols was so for 49,900, and Tarmo Tammel (pictured) had them both covered.

Andre Magi:
Kristaps Sipols:
Tarmo Tammel:

The flop gave Magi a flush draw, and it came in on the turn. Meanwhile, Sipols had turned his set, and nothing changed on the river.

Magi tripled up while Sipols also made a profit by raking in the big side pot. "Nice hands," Tammel said as he cut out the chips he owed.

Player Chips Progress
Tarmo Tammel 113,000 2,900
Kristaps Sipols 63,000 29,500
Andre Magi 58,200 28,200
Why? Posted Friday 25th October, 2024 at 11:44(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 232/627

Johan Martinsen had gone all in from the cutoff for 23,400 and had been called by Kaur Ajamaa (pictured) in the small blind.

Johan Martinsen:
Kaur Ajamaa:

Ajamaa flopped great on , leaving his opponent with two direct outs. The turn delivered some more, and the river was a brutal one, giving Martinsen top pair to take the pot.

"Why?" Ajamaa asked rhetorically before he paid his dues.

Player Chips Progress
Johan Martinsen 51,700 24,300
Kaur Ajaama 27,500 12,500
Westerlund Down to Five Figures After Encounter With Mikhalov Posted Friday 25th October, 2024 at 11:33(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 240/625

Mykhailo Mikhalov had raised his button when Jenny Westerlund made it 6,300 to go in the big blind. Mikhalov called before both players checked through the flop.

Westerlund checked again on the turn, after which Mikhalov bet 7,000. Westerlund called to the river, where she check-called Mikhalov's final bet of 22,000.

Mikhalov showed for a turned flush. Westerlund sighed and tossed her cards into the muck as she dove under 100 big blinds.

Player Chips Progress
Mykhailo Mikhalov 175,000 9,600
Jenny Westerlund 97,000 70,900
Kriaciunas Keeps Building Posted Friday 25th October, 2024 at 11:18(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 242/624

Not long after eliminating Niclas Mjelstad, Mindaugas Kriaciunas was seen playing a big pot of 58,000 from the small blind against Jarmo Salonen in the cutoff.

Kriaciunas fired 11,000 on a completed board of and received a sigh-call from his opponent. He turned over for a rivered straight and Salonen sent his cards to the muck in defeat.

Player Chips Progress
Mindaugas Kriaciunas 106,000 40,000
Jarmo Salonen 23,000 7,000
Mjelstad Made Quick Work Of Posted Friday 25th October, 2024 at 11:10(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 244/618

Niclas Mjelstad had just sat down with a fresh stack of 30,000 when he got his chips in against Mindaugas Kriaciunas.

Niclas Mjelstad:
Mindaugas Kriaciunas:

Kriaciunas made top pair on the flop while the turn gave him the better flush draw. Mjelstad did not hit a straight on the river and was eliminated.

Mjelstad has already won the €250 H.O.R.S.E. earlier this week but will have to re-enter the Main Event to add another trophy to his collection.

Player Chips Progress
Mindaugas Kriaciunas 66,000 25,000
Niclas Mjelstad 0 0
11:05 (UTC+0)
Start of Level 10
Blinds: 600/1,200     Ante: 1,200
Metsla Gives Trebbi Trouble Posted Friday 25th October, 2024 at 10:59(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 251/618

The action was picked up on a turn of . Mark Metsla bet 7,000 into a pot of 16,000 and was called almost instantly by Gianluca Trebbi on the button. 

Metsla then moved in for 17,500 on the river and was once again quickly called. He turned over for the nuts, beating the of Trebbi, who had called down with two pair.

Player Chips Progress
Mark Metsla 65,000 35,000
Gianluca Trebbi 46,200 28,800
Sandvik Sent Out After Calling Time on Self Posted Friday 25th October, 2024 at 10:48(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 249/607

Espen Sandvik was staring at Edikas Jurgutis' half-pot bet of 5,500 on a turn of for around two minutes when he called time on himself.

During his countdown, he made the call before the turn completed the board. He then led out for 2,000, which Jurgutis raised to 16,500.

Sandvik tossed in a quick call but mucked his cards once Jurgutis tabled for a full house. He was left with 5,000 chips, which he lost not much later as he was seen leaving the tournament area.

Player Chips Progress
Edikas Jurgutis 100,000 30,000
Espen Sandvik 0 0
Wahl Builds Further With Two Pair Posted Friday 25th October, 2024 at 10:41(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 250/601

Sebastian Wahl checked from the big blind on a turn of . Artjom Petskurov sat under the gun and tossed in a bet of 12,000 into the pot of 17,000, which Wahl called.

The river was checked down and Wahl tabled for two pair. Petskurov added his hand to the muck, seeing the pot shipped to Wahl.

Player Chips Progress
Sebastian Wahl 216,000 4,600
Artjom Petskurov 86,000 28,100
Vaaraniemi Veers Into Six-Figure Domain Posted Friday 25th October, 2024 at 10:28(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 251/595

Gisle Olsen had gone all in for 23,000 from the small blind and had been looked up by Elias Vaaraniemi in the cutoff.

Gisle Olsen:
Elias Vaaraniemi:

Olsen failed to pair his hole cards on the runout and was consequently eliminated.

Player Chips Progress
Elias Vaaraniemi 112,000 17,100
Gisle Olsen 0 0
Parts No Longer Plays Part Posted Friday 25th October, 2024 at 10:22(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 249/588

Rasmus Parts had gotten his stack of 34,800 in the middle from early position against Viktors Kurovs in middle position.

Rasmus Parts:
Viktos Kurovs:

The classic flip ended in Kurovs' favor when the flop did not help out Parts, and the latter took his exit from the tournament room.

Player Chips Progress
Viktors Kurovs 100,000 40,300
Rasmus Parts 0 0
Losing Start for Helppi Posted Friday 25th October, 2024 at 10:18(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 245/580

Kris Tikka and Juha Helppi were battling over a pot of 10,200 when Helppi checked from the small blind on a turn of .

Tikka bet 6,500 and Helppi called, causing the turn to appear. Helppi checked again, this time being met with a hefty bet of 17,500 from Tikka.

Helppi spent a minute or so in the tank before letting his hand go and forfeiting an early pot.

Player Chips Progress
Juha Helppi 136,700 11,000
Kris Tikka 87,700 7,500
Day 2 Underway Posted Friday 25th October, 2024 at 10:06(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 246/578

The button has been drawn, the players have taken their seats, and the cards are in the air for Day 2 of the Kings of Tallinn: Autumn Edition Main Event.

10:04 (UTC+0)
Day 2 of Kings of Tallinn Autumn Edition 2024 Started
Level: 9     Blinds: 500/1,000     Ante: 1,000
How Big Will The Prize Pool Get? Find Out on Day 2 of Kings of Tallinn: Autumn Edition Main Event Posted Friday 25th October, 2024 at 08:45(UTC+0) by Frank Visser

After four starting flights, 554 entries are on the clock for the €1,100 Kings of Tallinn: Autumn Edition Main Event. The €500,000 guarantee has already been surpassed, but with four more levels of late registration and unlimited re-entries, there is no telling how big the event will actually get.

Every player who registers today will receive 30,000 in chips for 25 big blinds, a far cry away from chipleader's Mikael Koistinen's 253,400. Since the pandemic, Koistinen has been playing live poker only sporadically, but he has returned with a bang, already having won the €350 8-Game earlier this week and now hunting his second trophy. Meanwhile, Dmitri Dudakov is the best Estonian, sitting in second with a stack of 218,700, while Sebastian Wahl and Luka Sorainen also secured a spot in the top ten.


Mikael Koistinen

Top Ten Chip Counts

Rank Player Country Chip Count Big Blinds
1 Mikael Koistinen Finland 254,400 254
2 Dmitri Dudakov Estonia 218,700 219
3 Andrejs Perederejevs Latvia 217,500 218
4 Sebastian Wahl Finland 211,400 211
5 David Bright United Kingdom 203,100 203
6 Luka Sorainen Finland 200,800 201
7 Rytis Strigunas Lithuania 188,700 188
8 Maykhailo Mykhaloc Ukraine 184,600 185
9 Vismands Menjoks Latvia 176,200 176
10 Egidijus Digrys Lithuania 172,900 173


Other notable names making an appearance on Day 2 include Finnish legend and €5,000 Progressive Bounty winner Juha Helppi (147.800), Aleksi Naski (122,000), Estonian Powerhouse Tarmo Tammel (110,100), and runner-up in yesterday's €555 Championship Rasmus Lundstrom (77,800).

Along with all other returning players, they will return to Olympic Park Casino at noon local time to play ten levels of 60 minutes each. Blinds will start in Level 9: 500/1,000 (1,000), and a break will be held after every two levels. Late registration closes at the start of Level 13, 4:40 p.m., where players can buy in for 15 big blinds. The last level will be 3,000/6,000 (6,000), after which the remaining players will bag up for Day 3.

Stay tuned as the thrilling Day 2 of the Kings of Tallinn Main Event will be reported live from start to finish.


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.