0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0072 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_555_champ/2/updates'
ORDER BY `views` DESC
0.0113 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_555_champ/2/updates'
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0004 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.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0006 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 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.0004 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.0005 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0005 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.0062 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.0007 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.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '210'
0.0276 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.0272 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '448'
AND `published` = 1
0.0269 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '449'
AND `published` = 1
0.0271 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '450'
AND `published` = 1
0.0271 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` = '452'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '210'
AND `name` = '2'
0.0061 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.0064 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.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.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` = '18967'
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` = '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.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` = '18962'
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` = '18961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18960'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '18955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18953'
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` = '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.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` = '18947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18941'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18940'
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` = '18939'
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` = '18935'
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` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18929'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '18926'
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` = '18922'
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` = '18921'
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` = '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.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` = '18916'
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` = '18915'
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` = '18914'
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` = '18912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18908'
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` = '18907'
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` = '18903'
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` = '18902'
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` = '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.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` = '18898'
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` = '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.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` = '18891'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18884'
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` = '18881'
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` = '18880'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '18870'
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` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18860'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18859'
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` = '18858'
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` = '18856'
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` = '18855'
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` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18850'
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` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '18838'
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` = '18837'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18836'
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` = '18835'
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` = '18832'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18830'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18826'
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` = '18825'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18823'
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` = '18821'
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` = '18818'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18816'
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` = '18815'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18810'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 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.0057 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.0058 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.0059 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '450'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '18968'
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` = '18967'
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` = '18966'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18964'
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` = '18962'
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` = '18961'
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` = '18960'
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` = '18957'
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` = '18958'
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` = '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.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` = '18952'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18948'
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` = '18947'
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` = '18944'
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` = '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.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` = '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.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` = '18931'
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` = '18929'
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` = '18928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18927'
ORDER BY `chip_change` DESC, `busted` ASC
0.0098 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '18921'
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` = '18918'
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` = '18917'
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` = '18916'
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` = '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.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` = '18910'
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` = '18908'
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` = '18907'
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` = '18903'
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` = '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.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` = '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.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` = '18898'
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` = '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.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` = '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.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` = '18888'
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` = '18886'
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` = '18884'
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` = '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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18877'
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` = '18876'
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` = '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.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` = '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.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` = '18865'
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` = '18864'
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` = '18863'
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` = '18860'
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` = '18859'
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` = '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.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` = '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.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` = '18849'
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` = '18848'
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` = '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.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` = '18838'
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` = '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.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` = '18835'
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` = '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.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` = '18826'
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` = '18825'
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` = '18823'
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` = '18821'
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` = '18818'
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` = '18816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18810'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '450'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '452'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Day 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 Berndtson, Mitchell Hynam, Phil 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.
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 .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
remained free of quads, eliminating Maasalu in 17th.
runout and was eliminated by Stauere's set on the turn.
runout to bink his three-outer and double up, trading stacks with Lankinen.
and had Haapio drawing dead on the 
turn to secure the double-up. Haapio's rail needled him as they mockingly cheered the 
. George let out a sigh but put his stack of 770,000 in the middle fairly quickly
turn nor the 
and he doubled up.
runout meant George's king kicker played.
river, sending Piiroinen home with a sour exit.
turn remained safe. The 
£ GBP
$ USD
€ EUR
