0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_555_champ/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.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

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

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

0.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.0002 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 `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0003 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.0002 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.0034 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

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

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

0.0281 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0060 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '447' AND `published` = 1

0.0278 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0058 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '448' AND `published` = 1

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

0.0279 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0057 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '450' AND `published` = 1

0.0278 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0057 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '452' AND `published` = 1

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '210' AND `name` = '2'

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

0.0063 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` = '450' 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` = '18968' 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` = '18967' 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` = '18966' 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` = '18964' 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` = '18962' 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` = '18961' 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` = '18960' 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` = '18957' 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` = '18958' 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` = '18955' 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` = '18953' 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` = '18952' 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` = '18948' 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` = '18947' 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` = '18944' 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` = '18946' 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` = '18941' 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` = '18940' 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` = '18939' 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` = '18935' 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` = '18934' 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` = '18933' 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` = '18931' 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` = '18929' 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` = '18928' 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` = '18927' 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` = '18926' 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` = '18922' 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` = '18921' 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` = '18918' 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` = '18917' 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` = '18916' 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` = '18915' 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` = '18914' 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` = '18912' 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` = '18910' 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` = '18908' 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` = '18907' 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` = '18903' 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` = '18902' 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` = '18901' 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` = '18900' 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` = '18899' 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` = '18898' 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` = '18895' 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` = '18894' 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` = '18893' 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` = '18891' 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` = '18888' 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` = '18886' 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` = '18884' 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` = '18881' 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` = '18880' 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` = '18877' 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` = '18876' 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` = '18875' 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` = '18874' 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` = '18872' 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` = '18870' 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` = '18869' 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` = '18865' 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` = '18864' 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` = '18863' 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` = '18860' 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` = '18859' ORDER BY `chip_change` DESC, `busted` ASC

0.0105 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '18858' 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` = '18856' 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` = '18855' 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` = '18852' 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` = '18851' 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` = '18850' 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` = '18849' 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` = '18848' 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` = '18844' 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` = '18843' 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` = '18838' 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` = '18837' 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` = '18836' 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` = '18835' 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` = '18832' 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` = '18830' 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` = '18826' 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` = '18825' 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` = '18823' 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` = '18821' 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` = '18818' 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` = '18816' 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` = '18815' 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` = '18810' 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` = '447' ORDER BY `busted` ASC, `current_chips` DESC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '448' 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` = '449' ORDER BY `busted` ASC, `current_chips` DESC

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

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

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

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

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

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

0.0117 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '18960' 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` = '18957' 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` = '18958' 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` = '18955' 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` = '18953' 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` = '18952' 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` = '18948' 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` = '18947' 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` = '18944' 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` = '18946' 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` = '18941' 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` = '18940' 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` = '18939' 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` = '18935' 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` = '18934' 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` = '18933' 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` = '18931' 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` = '18929' 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` = '18928' 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` = '18927' 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` = '18926' 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` = '18922' 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` = '18921' 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` = '18918' 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` = '18917' 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` = '18916' 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` = '18915' 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` = '18914' 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` = '18912' 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` = '18910' 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` = '18908' 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` = '18907' 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` = '18903' 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` = '18902' 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` = '18901' 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` = '18900' 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` = '18899' 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` = '18898' 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` = '18895' 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` = '18894' 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` = '18893' 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` = '18891' 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` = '18888' 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` = '18886' 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` = '18884' 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` = '18881' 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` = '18880' 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` = '18877' 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` = '18876' 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` = '18875' 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` = '18874' 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` = '18872' 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` = '18870' 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` = '18869' 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` = '18865' 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` = '18864' 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` = '18863' 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` = '18860' 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` = '18859' 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` = '18858' 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` = '18856' 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` = '18855' 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` = '18852' 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` = '18851' 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` = '18850' 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` = '18849' 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` = '18848' 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` = '18844' 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` = '18843' 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` = '18838' 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` = '18837' 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` = '18836' 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` = '18835' 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` = '18832' 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` = '18830' 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` = '18826' 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` = '18825' 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` = '18823' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0063 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '452' 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 #20 €555 NLH Kings of Tallinn Championship Live Reporting - Day 3
1 New Update - Click to refresh
Live Updates - Day 2
03:28 (UTC+2)
Day 2 of Kings of Tallinn Autumn Edition 2024 Ended
Level: 26     Blinds: 20,000/40,000     Ante: 40,000
Serial Winner Rasmus Lundstrom Bags Massive Lead on Day 2 of €555 Championship Posted Thursday 24th October, 2024 at 03:27(UTC+2) by Frank Visser

After a 14-hour day, the 583 entries of the €555 Championship at Kings of Tallinn: Autumn Edition were whittled down to just 16 remaining players. Rasmus Lundstrom stood atop of the counts when the day finished, having bagged a massive pile of 3,615,000 chips, more than twice the amount of his nearest contender and 90 big blinds at the start of Day 3.

Lundstrom is a regularly seen guest at Olympic Park Casino in Tallinn, with all his recorded live cashes coming from the Estonian capital. Lundstrom's first appearance happened only just over a year ago,  but he has racked up no less than four victories in that timeframe, in addition to three other final tables. Now, the Finn is poised to make a run at his fifth trophy, a remarkable feat.

Meanwhile, Turkish player Koray Korkmaz, who occupies the tenth spot on his country's all-time money list, sits in second place on the leaderboard with 1,725,000. Lundstrom's fellow Finn Thanh Doan completes the podium with a stack of 1,580,000, while Joel Haapio is only one chip behind with 1,575,000.

End of Day 2 Top Ten Chip Counts

Rank Player Country Chip Count Big Blinds
1 Rasmus Lundstrom Finland 3,615,000 90
2 Koray Korkmaz Turkey 1,725,000 43
3 Thanh Doan Finland 1,580,000 40
4 Joel Haapio Finland 1,575,000 39
5 Juho Suutari Finland 1,465,000 37
6 Justas Vaiciulionis Lithuania 1,460,000 37
7 Timo Ruuska Finland 975,000 24
8 Algirdas Saveikis Lithuania 835,000 21
9 Mindaugas Kriauciunas Lithuania 815,000 20
10 Andrei Mjagkov Lithuania 635,000 16


Among the six short stacks are the final ladies standing Kristiana Stauere (560,000) and Hanno Heinlo (520,000), and tenth and ninth on Estonia's all-time money list Tarmo Tammel (455,000) and Igor Pihela Sr. (280,000).

Day 2 Action

It seems eons ago, but Day 2 started with three levels of late registration still open. After everyone had their chance to fire a reentry, yesterday's €5,000 Progressive Bounty Winner Juha Helppi was among the first dozens of eliminations, along with defending champion Mikko Ylamaki. They were joined at the rail by the likes of Sebastian Whal, Touko BerndtsonMitchell HynamPhil Gross, and Maximilian Sanders, who all fell outisde of the top 100.

With 71 places receiving a part of the €274,010 prize pool, the money was getting closer at that point. Roope Tarmi and Luka Sorainen were eliminated a few tables away, but ultimately it was Markku Koplimaa who went home with nothing but the unfortunate title of bubble boy.

Once in the money, Igor Pihela Jr. (54th - €1,200) and Jari Mahonen (45th - €1,200) were among the quick exits while the likes of Aleksi Naski (36th - €1,350) and Joshua Stewart (27th - €1,850) got a bit further but couldn't make it to the end of the day.

Kalle Parkkinen's elimination in 25th heralded a three-table redraw. Among the final eliminations of the night was start-of-day chipleader Theophile George (21st - €2,100) until Kristjan Maasalu got knocked in 17th for €2,700 to leave two tables remaining. They then bagged up for the third and final day.

The 16 remaining players have all guaranteed themselves €2,700, but all eyes will be on the first-place prize of €52,760. 

Remaining Payouts

Place Prize
1 €52,760
2 €36,000
3 €24,500
4 €18,050
5 €13,250
6 €10,000
7 €7,350
8 €5,800
9 €4,700
10-11 €4,000
12-13 €3,550
14-15 €3,100
16 €2,700


The fight for that pile of cash, along with the trophy of course, will recommence tomorrow, October 24, at 1 p.m. local time when the third and final day starts. The tournament will resume with 19 minutes and 10 seconds left in Level 26: 20,000/40,000 (40,000), after which each subsequent level will last 40 minutes.

Day 3 will not stop play until a winner is crowned, so be sure to check back in tomorrow to find out who will be the newest Kings of Tallinn champion.

End of Day 2 Chip Counts; Day 3 Seat Draw Posted Thursday 24th October, 2024 at 02:46(UTC+2) by Frank Visser
Table Seat Player Country Chip Count Big Blinds
1 1 Koray Korkmaz Turkey 1,725,000 43
1 2 Kristiana Stauere Latvia 560,000 14
1 3 Rasmus Lundstrom Finland 3,615,000 90
1 4 Andrei Mjagkov Estonia 635,000 16
1 5 Tarmo Tammel Estonia 455,000 11
1 6 Hanna Heinlo Estonia 520,000 13
1 7 Joel Haapio Finland 1,575,000 39
1 8 Igor Pihela Sr. Estonia 280,000 7
2 1 Thanh Doan Finland 1,580,000 40
2 2 Tommi Lankinen Finland 365,000 9
2 3 Algirdas Saveikis Lithuania 835,000 21
2 4 Timo Ruuska Finland 975,000 24
2 5 Pasi Laihinen Finland 630,000 16
2 6 Mindaugas Kriauciunas Lithuania 815,000 20
2 7 Juho Suutari Finland 1,465,000 37
2 8 Justas Vaiciulionis Lithuania 1,460,000 37

Player Chips Progress
Rasmus Lundstrom 3,615,000 115,000
Koray Korkmaz 1,725,000 275,000
Thanh Doan 1,580,000 540,000
Joel Haapio 1,575,000 325,000
Juho Suutari 1,465,000 15,000
Justas Vaiciulionis 1,460,000 385,000
Timo Ruuska 975,000 505,000
Algirdas Saveikis 835,000 589,000
Mindaugas Kriauciunas 815,000 255,000
Andrei Mjagkov 635,000 190,000
Pasi Laihinen 630,000 295,000
Kristiana Stauere 560,000 15,000
Hanna Heinlo 520,000 100,000
Tarmo Tammel 465,000 232,000
Tommi Lankinen 365,000 100,000
Igor Pihela Sr. 280,000 1,585,000
Day 2 Concludes Posted Thursday 24th October, 2024 at 02:03(UTC+2) by Frank Visser

Level 26: 20,000/40,000 (40,000)
Entries: 16/583

With 16 players remaining and 19 minutes and 10 seconds left to play in Level 26, Day 2 of the €555 Championship has reached its conclusion.

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

Kristjan Maasalu Eliminated in 17th Place (€2,700) Posted Thursday 24th October, 2024 at 02:02(UTC+2) by Frank Visser

Level 26: 20,000/40,000 (40,000)
Entries: 17/583

Kristjan Maasalu got his last 580,000 in from the button against Juho Suutari in the cutoff and was at risk.

Kristjan Maasalu:
Juho Suutari:

Both players had a set as the was turned, but the remained free of quads, eliminating Maasalu in 17th.

He was the final player to leave the tournament area on Day 2 as the 16 remaining players started bagging up for Day 3.

Player Chips Progress
Juho Suutari 1,450,000 1,112,000
Kristjan Maasalu 0 0
Modestas Kryzanauskas Eliminated in 18th Place (€2,400) Posted Thursday 24th October, 2024 at 01:51(UTC+2) by Frank Visser

Level 26: 20,000/40,000 (40,000)
Entries: 18/583

Kristiana Stauere on the button had Modestas Kryzanauskas all-in in the small blind for his last 150,000 chips.

Modestas Kryzanauskas:
Kristiana Stauere:

Kryzanauskas stood no chance on the runout and was eliminated by Stauere's set on the turn.

Player Chips Progress
Kristiana Stauere 575,000 155,000
Modestas Kryzanauskas 0 0
Doan Spikes Ace to Stay in Contention Posted Thursday 24th October, 2024 at 01:43(UTC+2) by Frank Visser

Level 26: 20,000/40,000 (40,000)
Entries: 18/583

Thanh Doan open-shipped his stack of 480,000 under the gun and was looked up by Tommi Lankinen in the small blind, who covered him.

Thanh Doan:
Tommi Lankinen:

Doan was an underdog but turned an ace on the runout to bink his three-outer and double up, trading stacks with Lankinen.

Player Chips Progress
Thanh Doan 1,040,000 340,000
Tommi Lankinen 465,000 365,000
01:34 (UTC+2)
Start of Level 26
Blinds: 20,000/40,000     Ante: 40,000
Heinlo Flips to Late-Night Double Posted Thursday 24th October, 2024 at 01:33(UTC+2) by Frank Visser

Level 25: 15,000/30,000 (30,000)
Entries: 18/583

Hanna Heinlo jammed her button for 280,000 and was called by Joel Haapio in the small blind.

Hanna Heinlo:
Joel Haapio:

Heinlo flopped a set on and had Haapio drawing dead on the turn to secure the double-up. Haapio's rail needled him as they mockingly cheered the river, but Heinlo's double was already set in stone.

Player Chips Progress
Joel Haapio 1,900,000 15,000
Hanna Heinlo 620,000 280,000
Joakim Brochard Eliminated in 19th Place (€2,400); Audrius Navickas Eliminated in 20th Place (€2,400) Posted Thursday 24th October, 2024 at 01:30(UTC+2) by Frank Visser

Level 25: 15,000/30,000 (30,000)
Entries: 20/583

Andrei Mjagkov open-jammed for 400,000 in the cutoff and was called by Joakim Brochard on the button, who played 350,000.

Joakim Brochard:
Andrei Mjagkov:

Mjagkov's higher pair faced no threats on the runout and he eliminated Brochard from the tournament.

Simultaneously, Audrius Navickas was eliminated at another table.

Player Chips Progress
Andrei Mjagkov 825,000 543,000
Joakim Brochard 0 0
Audrius Navickas 0 0
Theophile George Eliminated in 21st Place (€2,100) Posted Thursday 24th October, 2024 at 01:15(UTC+2) by Frank Visser

Level 25: 15,000/30,000 (30,000)
Entries: 21/583

Current chipleader Rasmus Lundstrom in the cutoff and start-of-day chipleader Theophile George in the big blind were heads up in a massive pot of 875,000.

Lundstrom then jammed all in on the completed board of . George let out a sigh but put his stack of 770,000 in the middle fairly quickly

Lundstrom tabled was retrieved as per the rules. George left the tournament area to collect his payout while Lundstrom's monstrous stack grew even more.

Player Chips Progress
Rasmus Lundstrom 3,500,000 2,900,000
Theophile George 0 0
Massive Cooler Doubles Up Haapio Massively Posted Thursday 24th October, 2024 at 01:09(UTC+2) by Frank Visser

Level 25: 15,000/30,000 (30,000)
Entries: 21/583

Joel Haapio had raised from the hijack and Modestas Kryzanauskas three-bet on the button. The action folded back to Haapio, who four-bet all in for 905,000 and received a quick call.

Joel Haapio:
Modestas Kryzanauskas: [acks}

Kryznauskas had ran ace-king into aces, but flopped some hope on . Neither the turn nor the river could bring him relief, however, and he doubled up his opponent.

Player Chips Progress
Joel Haapio 1,885,000 1,145,000
Modestas Kryzanauskas 255,000 605,000
Otto Kiiskinen Eliminated in 22nd Place (€2,100) Posted Thursday 24th October, 2024 at 01:00(UTC+2) by Frank Visser

Level 25: 15,000/30,000 (30,000)
Entries: 22/583

Koray Korkmaz raised to 60,000 in the hijack and Otto Kiiskinen called all-in for 50,000 in the big blind.

Otto Kiiskinen:
Koray Korkmaz:

Kiiskinen was in bad shape, and when Korkmaz made two pair on the runout, the Finn took his exit.

Player Chips Progress
Koray Korkmaz 1,450,000 145,000
Otto Kiiskinen 0 0
00:53 (UTC+2)
Start of Level 25
Blinds: 15,000/30,000     Ante: 30,000
Nightly Break Posted Thursday 24th October, 2024 at 00:40(UTC+2) by Frank Visser

Level 24: 10,000/25,000 (25,000)
Entries: 22/583

The 22 remaining players have been sent on a 15-minute break.

Day 2 will end when 16 remain or the end of Level 26 is reached.

Korkmaz Doubles Up, Leaves Kiiskinen With Crumbs Posted Thursday 24th October, 2024 at 00:39(UTC+2) by Frank Visser

Level 24: 10,000/25,000 (25,000)
Entries: 22/583

In the last hand before the break, Otto Kiiskinen raised to 65,000 in the hijack. Justus Vaiciulionis made it 175,000 to go in the cutoff before Koray Korkmaz four-bet jammed for 540,000 in the small blind.

Kiiskinen sighed but stuck in a call and Vaiciulionis got out of the way.

Koray Korkmaz:
Otto Kiiskinen:

Korkmaz needed to fade an ace to double up, and he did so when the board ran out . Kiiskinen paid off Korkmaz and was left with four big blinds.

Player Chips Progress
Koray Korkmaz 1,305,000 1,010,000
Justas Vaiciulionis 1,075,000 235,000
Otto Kiiskinen 100,000 330,000
Dmitri Dudakov Eliminated in 23rd Place (€2,100) Posted Thursday 24th October, 2024 at 00:30(UTC+2) by Frank Visser

Level 24: 10,000/25,000 (25,000)
Entries: 23/583

Dmitri Dudakov under the gun and Mindaugas Kriauciunas in the hijack got it all in preflop, with Kriauciunas' stack of 505,000 being covered by a small margin,

Mindaugas Kriauciunas:
Dmitri Dudakov:

Kriauciunas; superior ace remained best on and he doubled up.

Dudakov was left with 75,000, which he got in next hand in the big blind against Theophile George in the hijack.

Dmitri Dudakov:
Theophile George:

Dudakov had run into Big Slick again, and again he would lose as the runout meant George's king kicker played.

Player Chips Progress
Mindaugas Kriauciunas 1,070,000 804,000
Theophile George 800,000 25,000
Dmitri Dudakov 0 0
Tommy Piiroinen Eliminated in 24th Place (€1,850) Posted Thursday 24th October, 2024 at 00:20(UTC+2) by Frank Visser

Level 24: 10,000/25,000 (25,000)
Entries: 24/583

Tommy Piiroinen open-jammed for 250,000 under the gun and was called by Igor Pihela Sr. in the hijack.

Tommy Piiroinen:
Igor Pihela Sr.:

It was looking good for Piiroinen's chances to double up, however, the turn gave Pihela a flush draw. It came in on the river, sending Piiroinen home with a sour exit.

Player Chips Progress
Igor Pihela Sr. 1,865,000 240,000
Tommy Piiroinen 0 0
Flurry of Bust-Outs Means Three Tables Left Posted Thursday 24th October, 2024 at 00:07(UTC+2) by Frank Visser

Level 24: 10,000/25,000 (25,000)
Entries: 24/583

At one table, Joshua Stewart got his final chips in with preflop against and lost on the runout.

At another table, Kaius Kiidli lost a flip with against on and was also eliminated.

Kalle Parkkinen was left with no chips soon thereafter and the three-table redraw was reached.

Player Chips Progress
Kalle Parkkinen 0 0
Kaius Kiidli 0 0
Joshua Stewart 0 0
Remaining Eliminations from Level 23 Posted Wednesday 23rd October, 2024 at 23:54(UTC+2) by Frank Visser
Player Chips Progress
Jyri Merivirta 0 0
Pasi Trollhjarta 0 0
Nils Butevics 0 0
23:53 (UTC+2)
Start of Level 24
Blinds: 10,000/25,000     Ante: 25,000
Pihela Sr. Stacks Up as Rahikka Ousted Posted Wednesday 23rd October, 2024 at 23:53(UTC+2) by Frank Visser

Level 23: 10,000/20,000 (20,000)
Entries: 28/583

Heikki Rahikka in the hijack and Igor Pihela Sr. on the button were involved in a pot of 350,000. On a turn of , Rahikka checked to Pihela, who bet 75,000.

Rahikka raised to 175,000, after which Pihela jammed all in. Rahikka thought for but moments before he called off his stack of 400,000.

Heikki Rahikka:
Igor Pihela Sr.:

Rahikka made the wrong read and needed to hit a nine to stay in the tournament. The river brought the instead, eliminating him and seeing Pihela chip up to a massive stack.

Player Chips Progress
Igor Pihela Sr. 1,625,000 775,000
Heikki Rahikka 0 0
Piiroinen Doubles Up Without Going All-In Posted Wednesday 23rd October, 2024 at 23:44(UTC+2) by Frank Visser

Level 23: 10,000/20,000 (20,000)
Entries: 29/583

Tommy Piiroinen made it 100,000 to go in the small blind, leaving only 10,000 behind. Otto Kisskinen called in the big blind, and the pair checked through the board.

Piiroinen tabled for a jack kicker, while Kiiskinen lost the pot with for a ten kicker.

Player Chips Progress
Otto Kiiskinen 430,000 179,000
Tommy Piiroinen 230,000 135,000
Stikelis Can't Stick It Out Posted Wednesday 23rd October, 2024 at 23:34(UTC+2) by Frank Visser

Level 23: 10,000/20,000 (20,000)
Entries: 31/583

Mantas Stikelis open-jammed his last 165,000 from middle position and was called by Thanh Doan in the small blind.

Mantas Stikelis:
Thanh Doan:

Doan made a set on the runout to eliminate Stikelis in 31st.

Player Chips Progress
Thanh Doan 700,000 70,000
Mantas Stikelis 0 0
Heinlo Hauls Another Double-Up Posted Wednesday 23rd October, 2024 at 23:22(UTC+2) by Frank Visser

Level 23: 10,000/20,000 (20,000)
Entries: 31/583

Hanna Heinlo got her stack of 150,000 in from the small blind against Koray Korkaz under the gun.

Hanna Heinlo:
Koray Korkmaz:

Heinlo's dominating hand held on the runout and she doubled up, much to her delight.

Player Chips Progress
Hanna Heinlo 340,000 146,000
Koray Korkmaz 295,000 95,000
23:13 (UTC+2)
Start of Level 23
Blinds: 10,000/20,000     Ante: 20,000
Kryzanauskas Clicks Back to Chip Up Posted Wednesday 23rd October, 2024 at 23:13(UTC+2) by Frank Visser

Level 22: 10,000/15,000 (15,000)
Entries: 32/583

Big blind Heikki Rahikka bet 50,000 into a pot of 205,000 on a turn of . Modestas Kryzanauskas put in a modest raise to 105,000 in the cutoff, which folded out Koray Korkmaz on the button.

Rahikka called to the river, where both players checked. Rahikka tabled for a pair of queens, but Kryzanauskas had better with for a pair of kings and raked in the pot.

Player Chips Progress
Modestas Kryzanauskas 860,000 135,000
Koray Korkmaz 390,000 165,000
Heikki Rahikka 375,000 175,000
Four Tables Reached in Record Pace Posted Wednesday 23rd October, 2024 at 23:05(UTC+2) by Frank Visser

Level 22: 10,000/15,000 (15,000)
Entries: 32/583

Player Chips Progress
Hassan Sey 0 0
Serhii Chalap 0 0
Haresh Thaker 0 0
Edas Cimbolas 0 0
Gonzalo Perez 0 0
Naski Departs as Pihela Sr. Ships Three-Way Posted Wednesday 23rd October, 2024 at 23:03(UTC+2) by Frank Visser

Level 22: 10,000/15,000 (15,000)
Entries: 35/583

The action was caught on a turn of . With around 200,000 in the pot, Aleksi Naski went all in for 125,000 from the small blind. Tommy Piiroinen called in the hijack, as did Igor Pihela Sr. in the cutoff.

Piiroinen check-folded to Pihela's bet of 100,000 on the river, and a showdown was ordered. Naksi tabled for a pair of queens, but it was no good against the of Pihela, who had flopped two pair and eliminated Naksi.

Player Chips Progress
Igor Pihela Sr. 850,000 585,000
Tommy Piiroinen 365,000 80,000
Aleksi Naski 0 0
Other Eliminations Posted Wednesday 23rd October, 2024 at 22:54(UTC+2) by Frank Visser
Player Chips Progress
Jari-Pekka Juhola 0 0
Audrius Skucas 0 0
Ricardas Lukauskas 0 0
Rene Peterkopf 0 0
Jari Mahonen 0 0
Mark Metsla 0 0
Kolakovs Departs, Five Tables Remain Posted Wednesday 23rd October, 2024 at 22:52(UTC+2) by Frank Visser

Level 22: 10,000/15,000 (15,000)
Entries: 41/583

It folded to Andrejs Kovalovs in the small blind, who jammed all in for 155,000. Pasi Laihinen asked for a count and made the call with a slightly covering stack.

Andrejs Kovalovs:
Pasi Laihinen:

Laihinen's ace-high remained best on the board and he sent Kovalovs to the rail in 41st.

Player Chips Progress
Pasi Laihinen 335,000 33,000
Andrejs Kovalovs 0 0
Alves Annihilated Posted Wednesday 23rd October, 2024 at 22:41(UTC+2) by Frank Visser

Level 22: 10,000/15,000 (15,000)
Entries: 44/583

Frederico Alves jammed all in for 230,000 from middle position. Kristjan Maasalu called on the button before the blinds got out of the way.

Frederico Alves:
Kristjan Maasalu:

Maasalu's aces had Alves' jacks dead on the turn. Alves took his leave as the river rolled off and Maasalu chipped up to nearly one million.

Player Chips Progress
Kristjan Maasalu 975,000 220,000
Frederico Alves 0 0
22:34 (UTC+2)
Start of Level 22
Blinds: 10,000/15,000     Ante: 15,000
Assorted Break Counts Posted Wednesday 23rd October, 2024 at 22:34(UTC+2) by Frank Visser
Player Chips Progress
Kaius Kiidli 850,000 543,000
Gonzalo Perez 800,000 30,000
Theophile George 775,000 590,000
Thanh Doan 770,000 480,000
Kristjan Maasalu 755,000 295,000
Joel Haapio 740,000 75,000
Modestas Kryzanauskas 725,000 280,000
Dmitri Dudakov 670,000 365,000
Kalle Parkkinen 650,000 478,000
Jari-Pekka Juhola 650,000 120,000
Rasmus Lundstrom 600,000 110,000
Break Time Posted Wednesday 23rd October, 2024 at 22:18(UTC+2) by Frank Visser

Level 20: 6,000/12,000 (12,000)
Entries: 46/583

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

Next Slew of Bust-Outs Posted Wednesday 23rd October, 2024 at 22:08(UTC+2) by Frank Visser
Player Chips Progress
Miika Toyras 0 0
Audrius Laimelis 0 0
Bartlomiej Kijak 0 0
Stanislav Smeljov 0 0
Vidar Assersen 0 0
Igor Pihela Jr. 0 0
Enea Subashi 0 0
Jose Koistinen 0 0
Aurimas Stanevicius 0 0
Rytis Pranarauskas 0 0
Linden Loses Flip for Tournament Life Posted Wednesday 23rd October, 2024 at 22:05(UTC+2) by Frank Visser

Level 21: 6,000/12,000 (12,000)
Entries: 47/583

Algirdas Saveikis made an open-raise of 24,000 in early position. Nils Linden then three-bet all-in for 103,000 in the hijack. Small blind Haresh Thaker called before Saveikis rejammed, covering Thaker's stack of 308,000.

Thaker spent some time in the tank but eventually put his opponent on ace-king and folded his cards.

Nils Linden:
Algirdas Saveikis:

Thaker had made the right read. Saveikis paired his ace on the flop. Linden already stood up, but the turn gave him a flush draw.

However, the river did not bring it, and Linden quickly headed to the payout desk.

Player Chips Progress
Kristjan Maasalu 460,000 121,000
Mantas Stikelis 275,000 75,000
Igor Pihela Sr. 265,000 81,000
Enea Subashi 255,000 90,000
Aleksi Naski 245,000 290,000
Haresh Thaker 205,000 67,000
Nils Linden 0 0
Playtime Commences as Heinlo Doubles Up Posted Wednesday 23rd October, 2024 at 22:00(UTC+2) by Frank Visser

Level 21: 6,000/12,000 (12,000)
Entries: 51/583

Hanna Heinlo had gotten her stack of 88,000 in from the big blind against Koray Korkmaz in early position.

Hanna Heinlo:
Koray Korkmaz:

Heinlo won the flip when she paired her ace on the board. 

"It's time to play, boys," she stated as she raked in her newly acquired chips.

Player Chips Progress
Koray Korkmaz 225,000 189,000
Hanna Heinlo 194,000 51,000
Alves Hits Lady to Triple Posted Wednesday 23rd October, 2024 at 21:48(UTC+2) by Frank Visser

Level 21: 6,000/12,000 (12,000)
Entries: 55/583

Frederico Alves had gone all in from the small blind for 46,000 and was looked up by Timo Ruuska in the cutoff and Audrius Navickas on the button.

Frederico Alves:
Audrius Navickas:
Timo Ruuska:

"Come, come, my lady," Alves uttered. He got what he wanted, as the brought him a queen to triple up.

"So stupid," concluded Ruuska after he had paid his part of the pot.

Player Chips Progress
Timo Ruuska 470,000 155,000
Audrius Navickas 180,000 47,000
Frederico Alves 162,000 99,000
21:38 (UTC+2)
Start of Level 21
Blinds: 6,000/12,000     Ante: 12,000
First ITM Finishers Posted Wednesday 23rd October, 2024 at 21:37(UTC+2) by Frank Visser
Player Chips Progress
Vasyl Laba 0 0
Andre Magi 0 0
Rokas Asipauskas 0 0
Edikas Jurgutis 0 0
Tanel Evert 0 0
Taavi Pusa 0 0
Kenneth Amundsen 0 0
Gintaras Naglius 0 0
Benjamin Gros 0 0
Lukas Paliulis 0 0
Serhii Leonov 0 0
Maksim Petrov 0 0
Stikelis Doubles Through Naski Posted Wednesday 23rd October, 2024 at 21:32(UTC+2) by Frank Visser

Level 20: 5,000/10,000 (10,000)
Entries: 62/583

Mantas Stikelis got his last 75,000 or so in from the cutoff against Aleksi Naski in the hijack.

Mantas Stikelis:
Aleksi Naski:

Stikelis just needed to fade an ace, and he did so on the board to secure a double-up.

Player Chips Progress
Aleksi Naski 535,000 55,000
Mantas Stikelis 200,000 5,000
Kiiskinen Fades Paint Posted Wednesday 23rd October, 2024 at 21:29(UTC+2) by Frank Visser

Level 20: 5,000/10,000 (10,000)
Entries: 63/583

Otto Kiiskinen had open-jammed from under the gun for 113,000 and had been called by Rasmus Lundstrom in the cutoff.

Otto Kisskinen:
Rasmus Lundstrom:

"No paint!" yelled Lundstrom. Only one picture appeared on the runout, and Kisskinen doubled up with his pair of fives.

Player Chips Progress
Rasmus Lundstrom 490,000 105,000
Otto Kiiskinen 251,000 100,000
Suutari Gets Paid Posted Wednesday 23rd October, 2024 at 21:24(UTC+2) by Frank Visser

Level 20: 5,000/10,000 (10,000)
Entries: 64/583

Big blind Juho Suutari bet 50,000 into a pot of 110,000 on a turn of . Justas Vaiciulionis called in the hijack before the fell on the river.

Suutari jammed all in for 64,000, sending Vaiciulionis in the tank for a minute or two. Eventually, he put in a call. Suutari tabled for a straight to the seven, narrowly beating Vaiciulionis, who had for a straight to the six.


Juho Suutari

Player Chips Progress
Justas Vaiciulionis 840,000 100,000
Kristiana Stauere 420,000 0
Thanh Doan 405,000 115,000
Juho Suutari 338,000 103,000
Mindaugas Kriauciunas 280,000 14,000
Tarmo Tammel 179,000 54,000
Igor Pihela Jr. 155,000 50,000
Serhii Leonov 153,000 112,000
Markku Koplimaa Bubbles €555 Championship Posted Wednesday 23rd October, 2024 at 21:11(UTC+2) by Frank Visser

Level 20: 5,000/10,000 (10,000)
Entries: 72/583

Markku Koplimaa had gotten his stack of 148,000 in preflop from the hijack against Gonzalo Perez under the gun.

Markku Koplimaa: 
Gonzalo Perez:

Koplimaa was dominated. He needed a jack to avoid becoming the bubble boy, but the deck had none in store on the board.

Perez's queens held and Koplimaa departed the tournament in 72nd as the last player without a cash.


Markku Kooplimaa

Player Chips Progress
Gonzalo Perez 770,000 280,000
Markku Koplimaa 0 0
Merivirta Survives Sweaty All-In on Bubble Posted Wednesday 23rd October, 2024 at 21:07(UTC+2) by Frank Visser

Level 20: 5,000/10,000 (10,000)
Entries: 72/583

Joel Haapio had raised under the gun when Jyri Merivarta went all in for 52,000 in the hijack. Haapio made a quick call once the action had folded back to him, and the cards were tabled.

Jyri Merivarta:
Joel Haapio:

Neither player improved on the runout, meaning that Merivarta doubled up and the bubble continued.

Player Chips Progress
Joel Haapio 665,000 211,000
Jyri Merivirta 129,000 37,000
20:55 (UTC+2)
Start of Level 20
Blinds: 5,000/10,000     Ante: 10,000
Ruuska Bluffs Lankinen, Karenius Last to Depart Before Hand-for-Hand Posted Wednesday 23rd October, 2024 at 20:47(UTC+2) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 72/583

A pot of 75,000 had been brewed between Tommi Lankinen under the gun and Timo Ruuska in the cutoff. A turn of was on the table when Lankinen checked.

Ruuska bet 60,000, seeing Lankinen call. The river completed the board, on which Lankinen checked agin. Ruuska put him all-in for 100,000, sending Lakinen into the tank.

After five minutes or so, Ruuska called the clock. With ten seconds left in his countdown, Lankinen made the fold. Ruuska victoriously tabled for a stone-cold bluff and was awarded the pot.

Meanwhile, Kevin Karenius departed in 73rd as the tournament arrived on the stone bubble and hand-for-hand play began.


Timo Ruuska

Player Chips Progress
Timo Ruuska 625,000 100,000
Tommi Lankinen 100,000 120,000
Harri Karenius 0 0
Kevin Karenius 0 0
Pre-Bubble Bustouts Posted Wednesday 23rd October, 2024 at 20:25(UTC+2) by Frank Visser
Player Chips Progress
Kristaps Renga 0 0
Kamil Borowiec 0 0
Aleksandr Jelpidiforov 0 0
Jon Gurrutxaga 0 0
Jose Domene 0 0
Fabian Bartuschk 0 0
Brochard Coolers Sey as Evert Finds Huge Fold Posted Wednesday 23rd October, 2024 at 20:24(UTC+2) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 75/583

Hassan Sey raised to 16,000 under the gun and Evert Tanel three-bet to 40,000 in cutoff. Joakim Brochard then four-bet jammed for 173,000. 

Sey thought for a bit before also going all in, with the covering stack. Tanel sighed as he folded his face-up and the remaining pair showed down.

Joakim Brochard:
Hassan Sey:

Sey had one out left in the deck, and he did not find it on the runout. He doubled up Brochard but was left with a healthy stack.

Player Chips Progress
Joakim Brochard 400,000 200,000
Hassan Sey 170,000 10,000
Tanel Evert 135,000 40,000
Toyras Gives "River Masterclass" Posted Wednesday 23rd October, 2024 at 20:10(UTC+2) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 76/583

Modestas Kryzanauskas had raised from early position and the action folded to Miika Toyras in the big blind. He jammed all in for 133,000 and received a quick call from his opponent.

Miika Toyras:
Modestas Kryzanauskas:

Toyras pleaded for a lady, and he got one on the river. 

"River masterclass," he excitedly exclaimed as he raked in his double-up.

Player Chips Progress
Modestas Kryzanauskas 445,000 95,000
Miika Toyras 278,000 137,000
20:01 (UTC+2)
Start of Level 19
Blinds: 4,000/8,000     Ante: 8,000
Full Dinner Counts Posted Wednesday 23rd October, 2024 at 20:01(UTC+2) by Frank Visser
Player Chips Progress
Justas Vaiciulionis 740,000 710,000
Modestas Kryzanauskas 540,000 315,000
Jari-Pekka Juhola 530,000 392,300
Timo Ruuska 525,000 353,000
Gonzalo Perez 490,000 105,000
Aleksi Naski 480,000 448,700
Joel Haapio 454,000 179,000
Vasyl Laba 431,000 221,100
Kristiana Stauere 420,000 360,200
Koray Korkmaz 414,000 320,500
Rasmus Lundstrom 385,000 88,000
Igor Pihela Sr. 346,000 134,000
Kristjan Maasalu 339,000 235,200
Kaius Kiidli 307,000 8,000
Dmitri Dudakov 305,000 164,500
Pasi Laihinen 302,000 272,000
Thanh Doan 290,000 55,000
Tommy Piiroinen 285,000 219,400
Andrei Mjagkov 282,000 114,000
Ricardas Lukauskas 275,000 179,900
Andrejs Kovalovs 268,000 158,000
Mindaugas Kriauciunas 266,000 171,000
Serhii Leonov 265,000 179,200
Joshua Stewart 255,000 50,000
Mark Metsla 250,000 182,200
Algirdas Saveikis 246,000 195,000
Juho Suutari 235,000 98,000
Tarmo Tammel 233,000 3,600
Pasi Trollhjarta 230,000 135,200
Audrius Navickas 227,000 112,000
Jari Mahonen 220,000 190,000
Tommi Lankinen 220,000 7,000
Igor Pihela Jr. 205,000 25,000
Joakim Brochard 200,000 168,300
Heikki Rahikka 200,000 97,500
Audrius Skucas 199,300 152,800
Markku Koplimaa 195,000 158,200
Mantas Stikelis 195,000 96,900
Lukas Paliulis 192,000 70,700
Taavi Pusa 192,000 50,400
Edas Cimbolas 191,000 102,300
Jose Koistinen 185,000 90,000
Theophile George 185,000 50,000
Kenneth Amundsen 176,000 146,000
Audrius Laimelis 175,000 63,200
Tanel Evert 175,000 18,000
Rytis Pranarauskas 172,000 103,000
Kalle Parkkinen 172,000 47,000
Erik Lucas Byhlin 170,000 150,000
Enea Subashi 165,000 95,000
Hassan Sey 160,000 88,700
Kristaps Sipols 156,000 119,000
Rene Peterkopf 155,000 111,800
Otto Kiiskinen 151,000 139,000
Stanislav Smeljov 150,000 80,000
Bartlomiej Kijak 145,000 115,000
Hanna Heinlo 143,000 92,400
Miika Toyras 141,000 21,000
Haresh Thaker 138,000 28,000
Benjamin Gros 126,000 94,000
Jon Gurrutxaga 115,000 71,900
Maksim Petrov 108,000 16,600
Jose Domene 105,000 30,000
Vidar Assersen 105,000 2,400
Serhii Chalap 103,000 35,400
Nils Butevics 97,000 57,700
Jyri Merivirta 92,000 71,500
Nils Linden 90,000 60,000
Aurimas Stanevicius 85,000 2,100
Edikas Jurgutis 80,000 42,400
Aleksandr Jelpidiforov 75,000 600
Kamil Borowiec 74,000 10,400
Gintaras Naglius 71,000 41,000
Frederico Alves 63,000 13,600
Rokas Asipauskas 55,000 2,800
Kristaps Renga 55,000 18,000
Kevin Karenius 30,000 10,000
Andre Magi -6,500 68,500
Dinner Break Posted Wednesday 23rd October, 2024 at 18:57(UTC+2) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 79/583

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

They will come back around 7:55 p.m. local time as the bubble is in sight.

Pre-Dinner Bust-Outs Posted Wednesday 23rd October, 2024 at 18:56(UTC+2) by Frank Visser
Player Chips Progress
Sami Starck 0 0
Roope Tarmi 0 0
Antonio Saez Zamorano 0 0
Maikel Homin 0 0
Menno De Velde 0 0
Artturi Hannula 0 0
Luka Sorainen 0 0
Joel Salmirinne 0 0
Adrian Espinosa 0 0
Harijs Erglis 0 0
Kari Petri Martikainen 0 0
Oskari Piira 0 0
Mykhailo Chekarev 0 0
Joni Petri Lahti 0 0
Suutari Doubles on Soft Bubble Posted Wednesday 23rd October, 2024 at 18:52(UTC+2) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 80/583

Igor Pihela Jr. had raised from the button when Juho Suutari three-bet jammed for 124,000 in the big blind. Pihela asked for a count and then made the call with the covering stack.

Juho Suutari:
Igor Pihela Jr.:

Suutari's higher kicker remained in play on the runout, securing his double-up nine spots away from the money.

Player Chips Progress
Igor Pihela Jr. 180,000 129,300
Juho Suutari 137,000 89,800
Karenius Left Short After Running Into Pihela Sr.'s Nuts Posted Wednesday 23rd October, 2024 at 18:41(UTC+2) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 83/583

In a pot worth 60,000, Igor Pihela Sr. checked from the small blind to Kevin Karenius on the button. 

Karenius fired a bet of 25,000, which Pihela min-raised to 50,000. Karenius complied with a call, after which he also called the 33,000 Pihela put in on the river.

Pihela tabled for top full house. Karenius took a few seconds to process the hand and then added his cards to the muck in defeat, being left with just over three big blinds.

Player Chips Progress
Igor Pihela Sr. 480,000 227,000
Kevin Viktor Karenius 20,000 4,000
Subashi Receives Lucky Double-Up Posted Wednesday 23rd October, 2024 at 18:28(UTC+2) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 86/583

Bartlomiej Kijak had raised to 13,000 in middle position and received a call from Algirdas Saveikis in the hijack when cutoff Enea Subashi jammed all in for 57,000.

Kristjan Maasalu sat in the small blind and called before the other two players got out of the way.

Enea Subashi:
Kristjan Maasalu:

Subashi was behind but flopped a straight on to take the lead. The turn and river did not pair the board, securing the double-up for Subashi.

Player Chips Progress
Kristjan Maasalu 260,000 156,200
Algirdas Saveikis 215,000 164,000
Enea Subashi 152,000 82,000
Bartlomiej Kijak 120,000 90,000
18:18 (UTC+2)
Start of Level 18
Blinds: 3,000/6,000     Ante: 6,000
Lankinen Triples In Three-Way Cooler Posted Wednesday 23rd October, 2024 at 18:17(UTC+2) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 94/583

Tommi Lankinen was all-in for 67,000 under the gun and was looked up by both Kari Martikainen in the hijack and Harri Karenius on the button.

Tommi Lankinen:
Kari Martikainen:
Harri Karenius:

Lankinen's queens flopped a set on , and although his opponents flopped a gutshot, he locked up the pot when he filled up on the turn. The river did not matter anymore as Lankinen raked in the pot and left both his opponents short.

Player Chips Progress
Tommi Lankinen 213,000 183,000
Kari Petri Martikainen 45,000 27,300
Harri Karenius 20,000 10,000
Less Than 100 Remain Posted Wednesday 23rd October, 2024 at 18:03(UTC+2) by Frank Visser
Player Chips Progress
Veikka Keto-Tokoi 0 0
Dan Tolppanen 0 0
Kaido Mikk 0 0
Enrique Martinez 0 0
Sergejs Cugainovs 0 0
Mihn Thang Ngo 0 0
Aleksandr Arutjunov 0 0
Nils Veipans 0 0
Jari Saviaho 0 0
Tarjei Forus 0 0
Indre Martoviciute-Kasten 0 0
Viktor Snotko 0 0
Vasilij Barna 0 0
Mikael Haapaniemi 0 0
Danel Kunman 0 0
Alberto Martinez Gonzalez 0 0
Teemu Toikkanen 0 0
Robert Kallikorm 0 0
Angel Rodriguez 0 0
Bartosz Wojciech Wesolek 0 0
Damaskin Dusted by Doan Posted Wednesday 23rd October, 2024 at 17:58(UTC+2) by Frank Visser

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

Quang Thanh Doan had raised form early position when Dmitri Damaskin pushed his 50,000 in the middle from the big blind. Doan called and the cards were flipped up.

Dmitri Damaskin:
Quang Thanh Doan:

Doan paired up on the flop and the runout could not save Damaskin from his demise.

Player Chips Progress
Quang Thanh Doan 235,000 178,500
Dmitri Damaskin 0 0
Koistinen Saved by River Posted Wednesday 23rd October, 2024 at 17:49(UTC+2) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 104/583

Jose Koistinen went all in for 44,000 in the hijack. Miika Toyras spent a few minutes tanking in the big blind but ultimately made the call.

Jose Koistinen:
Miika Toyras:

Toyras vaulted ahead on the flop, and the turn remained safe. The river saw Koistinen rebink the better pair, however, as he stayed in contention.

Player Chips Progress
Miika Toyras 120,000 60,000
Jose Koistinen 95,000 0
Sanders' Story Ends Posted Wednesday 23rd October, 2024 at 17:44(UTC+2) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 107/583

On a completed board of , small blind Joshua Stewart had put enough chips in the middle to put Maximilian Sanders all-in in the cutoff.

Sanders had 40,000 remaining, and eventually made the call into the pot of 50,000. Stewart turned over for top pair, leaving Sanders' for ace-high in the dust.

Player Chips Progress
Joshua Stewart 205,000 125,000
Maximilian Sanders 0 0
17:35 (UTC+2)
Start of Level 17
Blinds: 2,000/5,000     Ante: 5,000
Lundstrom Wins Three-Way Pot, Expands Stack Posted Wednesday 23rd October, 2024 at 17:31(UTC+2) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 117/583

Big blind Veikka Keto-Tokoi was seen betting 15,000 on a turn of . Roope Tarmi called under the gun before cutoff Rasmus Lundstrom came along as well.

The river was checked to Lundstrom, who fired 60,000. Keto-Tokoi quickly folded but Tarmi tossed in a quick call. Lundstrom showed for a flush and raked in the pot as Tarmi's cards hit the muck.

Player Chips Progress
Rasmus Lundstrom 473,000 105,000
Veikka Keto-Tokoi 125,000 95,000
Roope Tarmi 70,000 40,000
Recent Eliminations Posted Wednesday 23rd October, 2024 at 17:22(UTC+2) by Frank Visser
Player Chips Progress
Jon Ander Martinez 0 0
Inigo Naveiro Martin 0 0
Vasilijus Piskunovas 0 0
Steven Tool 0 0
Jimmy Dewerdt 0 0
Ingus Arajs 0 0
Ignas Navickas 0 0
Frederik Brink 0 0
Mathias Siljander 0 0
Sargon Esfendiyari 0 0
Phil Gross 0 0
Joonas Helin 0 0
Jokubas Jancevicius 0 0
Mitchell Hynam 0 0
Toikkanen Plays It Super Slow Posted Wednesday 23rd October, 2024 at 17:18(UTC+2) by Frank Visser

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

Teemu Toikkanen raised to 8,000 in early position and was called by Kaius Kiidli in the seat next to him. The rest of the table folded and the flop appeared.

Toikkanen checked to Kiidli, who bet 7,000. Toikkanen took some time before tossing in a call. The subsequent turn and river were checked down.

Toikkanen surprisingly tabled for a set of aces. He won the small pot, putting a small dent in Kiidli's stack.

Player Chips Progress
Kaius Kiidli 315,000 243,900
Benjamin Gros 220,000 151,800
Andrei Mjagkov 168,000 111,500
Teemu Toikkanen 145,000 115,000
Audrius Navickas 115,000 65,000
Enea Subashi 70,000 30,800
Andre Magi 62,000 21,800
Tarjei Forus 43,000 13,000
Sander Leigri 28,200 26,100
Sipols Short After Doubling Shortie Posted Wednesday 23rd October, 2024 at 17:04(UTC+2) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 126/583

Kristaps Sipols had open-raised from the hijack when big blind Sami Starck tossed in his stack of 44,000. Sipols made a quick call and the cards were tabled.

Sami Starck:
Kristaps Sipols:

Sipols failed to improve on the runout and doubled up Starck. He was left with just over nine big blinds.

Player Chips Progress
Sami Starck 94,000 24,900
Kristaps Sipols 37,000 12,300
16:55 (UTC+2)
Start of Level 16
Blinds: 2,000/4,000     Ante: 4,000
Assorted Big Stacks in Break Posted Wednesday 23rd October, 2024 at 16:46(UTC+2) by Frank Visser
Player Chips Progress
Gonzalo Perez 385,000 231,300
Rasmus Lundstrom 368,000 214,100
Adrian Espinosa 312,000 220,000
Otto Kiiskinen 290,000 230,000
Joel Haapio 275,000 194,700
Igor Pihela Sr. 253,000 204,400
Break Time Posted Wednesday 23rd October, 2024 at 16:36(UTC+2) by Frank Visser

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

The 131 remaining players have been sent on a 20-minute break. Below are some of the latest exits in the €555 Championship.

Player Chips Progress
Bartosz Mielczarek 0 0
Tobias Napel 0 0
Egidijus Digrys 0 0
Josep Pastor De Ramon 0 0
Irmantas Bzeskis 0 0
David Bright 0 0
Marius Bareisis 0 0
Peter Kvisthammar 0 0
Iikka Vaisanen 0 0
Andres Abakanov 0 0
Martin Piik 0 0
Viktors Caikins 0 0
Touko Berndtson 0 0
Kelly Limonova 0 0
Jenny Westerlund 0 0
Borge Dypvik 0 0
Gross Calls for Chop, Doubles Up Parkkinen Posted Wednesday 23rd October, 2024 at 16:35(UTC+2) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 134/583

Phil Gross had raised to 7,500 under the gun when Kalle Parkkinen made it 21,000 to go in the seat next to him. The action folded back to Gross, who instantly called.

Gross check-called bets of 10,000 on the flop and 28,500 on the turn before the fell on the river.

After a third check from Gross, Parkkinen shoved all in for 47,000. "Call for a chop," Gross said as he tossed in a calling chips.

However, nothing would be chopped as Parkkinen played for an overpair, doubling up against the of Gross.

Player Chips Progress
Modestas Kryzanauskas 225,000 155,200
Kalle Parkkinen 219,000 189,000
Miika Toyras 180,000 150,000
Phil Gross 180,000 80,000
Menno De Velde 155,000 74,400
Robert Kallikorm 125,000 103,000
Frederik Brink 120,000 90,000
Haresh Thaker 110,000 11,800
Jose Koistinen 95,000 27,000
Hannula Shoves Into Big Stack Byhlin Posted Wednesday 23rd October, 2024 at 16:20(UTC+2) by Frank Visser

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

The action was picked up on a turn of . With a pot of 46,500 in between Artturi Hannula in the big blind and Erik Byhlin under the gun, Hannula made a bet of 22,000. 

Byhlin called after some thinking time and the rolled off on the river. Hannula announced his all-in for roughly 80,000. Byhlin passed his cards to the dealer and forfeited the large pot to his neighbor.

Player Chips Progress
Erik Lucas Byhlin 320,000 273,800
Artturi Hannula 170,500 66,500
Theophile George 135,000 138,700
Andrejs Kovalovs 110,000 40,900
Joshua Stewart 80,000 50,000
Jose Larios Domene 75,000 2,000
Stanislav Smeljov 70,000 44,600
Jokubas Jancevicius 67,500 18,700
Merivirta Sucks Out on Sanders Posted Wednesday 23rd October, 2024 at 16:06(UTC+2) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 143/583

Jyri Merivirta had raised to 6,500 in early position. Maximilian Sanders called in the seat next to him before Kristaps Renga also came along in the small blind. 

Renga checked to Merivirta on the flop. He bet 6,000, Sanders called, and Renga got out of the way. Merivirta sized up to 10,000 on the turn, after which Sanders put him all-in for 63,000 total.

Merivirta spent around 30 seconds in the tank before putting in a call for his tournament life.

Jyri Merivirta:
Maximilian Sanders:

"Good luck," Sanders said to Merivirta. Maybe he was he had not wished his opponent luck, however, as the river elicited some whines from Sanders. 

Merivirta had hit a better pair to double up, leaving Sanders with a stack of 25 big blinds.

Player Chips Progress
Jyri Tapio Merivirta 163,500 78,500
Kristaps Renga 73,000 62,000
Maximilian Sanders 55,000 26,500
15:55 (UTC+2)
Start of Level 15
Blinds: 1,500/3,000     Ante: 3,000
Defending Champion Ylamaki Among Recent Knock-Outs Posted Wednesday 23rd October, 2024 at 15:53(UTC+2) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 147/583

Player Chips Progress
Niclas Mjelstad 0 0
Aleksandr Januskevic 0 0
Sebastian Wahl 0 0
Riitta Sahala 0 0
Algirdas Sukys 0 0
Anthony Kauzloric 0 0
Seppo Parkkinen 0 0
Toivo Rinne 0 0
Klaudijus Bajoras 0 0
Julius Kasperi Kettunen 0 0
Stanislovas Vinicenka 0 0
Mikko Ylamaki 0 0
Kris Tikka 0 0
Dittmann Ditches Last Chips Posted Wednesday 23rd October, 2024 at 15:48(UTC+2) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 153/583

Marco Dittmann had gone all in for his final 15,000 in middle position and was called by Sargon Esfendiyari in the hijack.

Marco Dittmann:
Sargon Esfendiyari:

Dittman dominated Esfendiyari. The flop changed nothing, but the turn gave Esfendiyari two pair to take a massive lead.

The river could not save Dittmann, who quickly took his exit.

Player Chips Progress
Sargon Esfendiyari 135,000 108,000
Marco Dittmann 0 0
Hannula Holds to Double Up Posted Wednesday 23rd October, 2024 at 15:44(UTC+2) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 155/583

Arturri Hannula had raised to 5,000 under the gun. Jose Larios Domene then three-bet to 15,000 on the button, after which Hannula jammed all in for 46,000.

Larios snap-called and the cards went open.

Arturri Hannula:
Jose Larios Domene:

Hannula faded the aces and kings in the deck on the runout and resultingly doubled up.

Player Chips Progress
Artturi Hannula 104,000 74,000
Jose Larios Domene 73,000 20,200
Most Recent Bust-Outs Posted Wednesday 23rd October, 2024 at 15:31(UTC+2) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 161/583

Player Chips Progress
Tony Westby 0 0
Gisle Olsen 0 0
Lars Hole 0 0
Ignacio Gonzalez Garrido 0 0
Sondre Stormyr 0 0
Richard Koppel 0 0
Totti Arosuo 0 0
Mykhailo Mikhalov 0 0
Povilas Jakutis 0 0
Aleksandr Scastnyj 0 0
Julien Fuchs 0 0
Kaspars Butans 0 0
Juha Helppi 0 0
Adria Comas Roura 0 0
Rytis Strigunas 0 0
Ignotas Tamasauskas 0 0
Kazimieras Sileikis 0 0
Payout Information Posted Wednesday 23rd October, 2024 at 15:26(UTC+2) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 168/583

The 583 entries have created a prize pool of €274,010. A min-cash of €1,100 is guaranteed for the top 71 finishers, while the first-place prize is a staggering €52,760.

Place Prize
1 €52,760
2

€36,000

3 €24,500
4 €18,050
5 €13,250
6 €10,000
7 €7,350
8 €5,800
9 €4,700
10-11 €4,000
12-13 €3,550
14-15 €3,100
16-17 €2,700
18-20 €2,400
21-23 €2,100

24-27

€1,850

28-31

€1,600

32-39

€1,350

40-55

€1,200

56-71

€1,100

15:15 (UTC+2)
Start of Level 14
Blinds: 1,000/2,500     Ante: 2,500
More Eliminations Posted Wednesday 23rd October, 2024 at 15:11(UTC+2) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 180/583

Player Chips Progress
Yaniv Peretz 0 0
Elias Suhonen 0 0
Jonatan Fors 0 0
Irmantas Rulis 0 0
Janne Nevalainen 0 0
Mati Pirn 0 0
Verneri Hakkinen 0 0
Emil Rutevik 0 0
Hendrik Uibo 0 0
Per-Thorben Kasten 0 0
Daniel Smith 0 0
Alius Riskevicius 0 0
Gytis Lazauninkas 0 0
Jesus Martinez Ucero 0 0
Ben Roto 0 0
Risto P?rnat 0 0
Siim Suviste 0 0
Alvils Bijons 0 0
Pavel Plotnikov 0 0
Sauli Haapaniemi 0 0
Michael Uguccioni 0 0
Jarkko Suokas 0 0
Matias Knaapinen 0 0
Mjelstad Goes Runner-Runner to Eliminate Komorowski Posted Wednesday 23rd October, 2024 at 15:06(UTC+2) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 183/583

Maciej Komorowski had put in his stack of 20,000 from the hijack and was looked up by Niclas Mjelstad in the small blind.

Maciej Komorowski:
Niclas Mjelstad:

Komorowski was poised to win the flip after the flop, but the runout made Mjelstad a straight to rake in the pot and knock his opponent out.


Niclas Mjelstad

Player Chips Progress
Niclas Mjelstad 82,000 45,600
Maciej Komorowski 0 0
Merivirta Makes Quads in Three-Way All-In Posted Wednesday 23rd October, 2024 at 15:01(UTC+2) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 193/583

Mantas Ungulaitis had jammed all in for 19,000 under the gun. Hijack Kristaps Renga reshoved, after which Jyri Merivirta in the small blind called all-in for 31,000 as well.

Mantas Ungulaitis:
Jyri Merivirta:
Kristaps Renga:

Renga had a good chance to knock out two players, but Merivirta hit a set on the flop to take a massive lead. The turn left Ungulaitis drawing dead, while the river made Marivirta quads to nearly triple up.

Player Chips Progress
Kristaps Renga 135,000 27,000
Jyri Tapio Merivirta 85,000 54,400
Mantas Ungulaitis 0 0
First Post-Registration Eliminations Posted Wednesday 23rd October, 2024 at 14:50(UTC+2) by Frank Visser
Player Chips Progress
Raimo Reimann 0 0
Ulf Ulvrell 0 0
Karolis Kutkauskas 0 0
Aisikaer Aikeremu 0 0
Hengtao Zhu 0 0
Kasper Mellanen 0 0
Andrius Janca 0 0
Eero Abbey 0 0
Gatis Popovs 0 0
Patrik Zidek 0 0
Elvijs Kergalvis 0 0
Andzej Bilat 0 0
Joona Koivisto 0 0
Tapio Vihakas 0 0
Pekka Lamberg 0 0
Sergio Mediavilla 0 0
Live Reporting Underway Posted Wednesday 23rd October, 2024 at 14:36(UTC+2) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 220/583

With 220 players seated of the total 583 who registered, Level 13 has begun and so has the live reporting.

14:35 (UTC+2)
Day 2 of Kings of Tallinn Autumn Edition 2024 Started
Level: 13     Blinds: 1,000/2,000     Ante: 2,000
Phil Gross Looking for More Tallinn Success With Second-Biggest Stack at Start of €555 Kings of Tallinn Autumn Edition Championship Day 2 Posted Wednesday 23rd October, 2024 at 13:18(UTC+2) by Frank Visser

German player Phil Gross has known many a success at Olympic Park Casino in Tallinn. In fact, all but one cashes on his Hendon Mob come from the Estonian capital. His largest-ever score is his runner-up finish in the Kings of Tallinn Summer Showdown Main Event for €72,000, while his first-ever live tournament victory came with a ring when he was victorious in the €555 Event. 

Now, he has set himself up for more glory as Gross bagged one of the biggest stacks across the three starting flights of the €555 Championship at the inaugural Kings of Tallinn: Autumn Edition. With 260,000 in his bag, he started Day 2 today at noon with 217 big blinds, having only the Frenchman Theophile George in front of him, who began with 273,700 chips. Estonian crusher Tarmo Tammel, who sits in tenth place on the hosting country's all-time money list, completes the podium with a stack of 229,400.

Start of Day 2 Top Ten Chip Counts

Rank Player Country Chip Count

Big Blinds

1 Theophile George France 273,700 228
2 Phil Gross Germany 260,000 217
3 Tarmo Tammel Estonia 229,400 191
4 Vasyl Laba Ukraine 209,900 175
5 Mikael Haapaniemi Finland 193,300 161
6 Timo Ruuska Finland 172,000 143
7 Alberto Martinez Gonzalez Spain 164,400 137
8 Tanel Evert Estonia 157,700 131
9 Nils Butevics Latvia 154,700 129
10 Rasmus Lundstrom Finland 153,900 128


In total, 194 players out of the 447 entries made it through to Day 2. However, late registration remains open until the start of Level 12 at 2:20 p.m. local time. The starting stack of 30,000 will be worth 15 big blinds at that point, and the live reporting is set to start at the same time. Day 2 is scheduled to play down to the final 16 players, and with 40-minute levels throughout, a long day is ahead for those who run deep.

Stay tuned as the action from Day 2 of the €555 Championship, as well as the prize pool and payout information, will be brought live to you in just one hour.


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.