0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0077 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_555_champ/3/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0035 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'kings_of_tallinn_autumn_2024_555_champ'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '210'
0.0290 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` = '447'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '448'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '449'
AND `published` = 1
0.0275 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '450'
AND `published` = 1
0.0275 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '452'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '210'
AND `name` = '3'
0.0059 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.0062 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` = '452'
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` = '19112'
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` = '19111'
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` = '19107'
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` = '19105'
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` = '19103'
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` = '19101'
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` = '19100'
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` = '19098'
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` = '19096'
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` = '19095'
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` = '19094'
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` = '19091'
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` = '19090'
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` = '19088'
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` = '19087'
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` = '19086'
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` = '19085'
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` = '19084'
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` = '19083'
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` = '19080'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19079'
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` = '19077'
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` = '19076'
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` = '19074'
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` = '19073'
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` = '19071'
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` = '19070'
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` = '19069'
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` = '19067'
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` = '19065'
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` = '19062'
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` = '19061'
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` = '19060'
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` = '19058'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19055'
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` = '19053'
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` = '19051'
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` = '19049'
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` = '19048'
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` = '19047'
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` = '19046'
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` = '19044'
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` = '19043'
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` = '19041'
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` = '19040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19038'
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` = '19037'
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` = '19036'
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` = '19035'
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` = '19031'
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` = '19030'
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` = '19021'
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` = '19029'
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` = '19028'
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` = '19020'
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` = '19025'
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` = '19023'
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` = '19014'
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` = '19022'
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` = '19011'
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` = '19016'
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` = '19009'
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` = '19013'
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` = '19005'
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` = '19003'
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` = '19012'
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` = '19010'
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` = '19007'
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` = '18998'
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` = '18992'
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` = '19001'
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` = '19000'
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` = '18990'
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` = '18999'
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` = '18987'
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` = '18997'
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` = '18984'
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` = '18994'
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` = '18991'
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` = '18982'
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` = '18989'
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` = '18979'
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` = '18986'
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` = '18977'
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` = '18981'
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` = '18975'
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` = '18974'
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` = '18969'
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` = '18970'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 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.0058 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.0059 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.0058 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.0060 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` = '452'
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` = '19112'
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` = '19111'
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` = '19107'
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` = '19105'
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` = '19103'
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` = '19101'
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` = '19100'
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` = '19098'
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` = '19096'
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` = '19095'
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` = '19094'
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` = '19091'
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` = '19090'
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` = '19088'
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` = '19087'
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` = '19086'
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` = '19085'
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` = '19084'
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` = '19083'
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` = '19080'
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` = '19079'
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` = '19077'
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` = '19076'
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` = '19074'
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` = '19073'
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` = '19071'
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` = '19070'
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` = '19069'
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` = '19067'
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` = '19065'
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` = '19062'
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` = '19061'
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` = '19060'
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` = '19058'
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` = '19055'
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` = '19053'
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` = '19051'
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` = '19049'
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` = '19048'
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` = '19047'
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` = '19046'
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` = '19044'
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` = '19043'
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` = '19041'
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` = '19040'
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` = '19038'
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` = '19037'
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` = '19036'
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` = '19035'
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` = '19031'
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` = '19030'
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` = '19021'
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` = '19029'
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` = '19028'
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` = '19027'
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` = '19020'
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` = '19025'
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` = '19023'
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` = '19014'
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` = '19022'
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` = '19011'
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` = '19016'
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` = '19009'
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` = '19013'
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` = '19005'
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` = '19003'
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` = '19012'
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` = '19010'
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` = '19007'
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` = '18998'
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` = '18992'
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` = '19001'
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` = '19000'
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` = '18990'
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` = '18999'
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` = '18987'
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` = '18997'
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` = '18984'
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` = '18994'
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` = '18991'
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` = '18982'
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` = '18989'
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` = '18979'
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` = '18986'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '18977'
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` = '18981'
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` = '18975'
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` = '18974'
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` = '18969'
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` = '18970'
ORDER BY `chip_change` DESC, `busted` ASC
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.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Day 3 of Kings of Tallinn Autumn Edition 2024 Ended Level: 35 Blinds: 150,000/300,000 Ante: 300,000
Joel Haapio Pulls Off Miraculous Comeback to Win Kings of Tallinn: Autumn Edition €555 Championship (€47,560) Posted Thursday 24th October, 2024 at 23:29(UTC+2) by Frank Visser
"Never give up," and "a chip and a chair." Phrases every poker player has heard at some point at the tables, but sometimes a situation looks dire enough to throw them into the wind. However, today, Joel Haapio proved that there is truth to the common statements. Haapio was down to a ten-to-one chip disadvantage at one point in the heads-up battle for the Kings of Tallinn: Autumn Edition €555 Championship, but ultimately persevered over Rasmus Lundstrom to take home the trophy and a career-best score of €47,560.
Meanwhile, Lundstrom limited the damage as he walked away with €41,200, also a record-setting score for him, as the players had made a heads-up deal when Lundstrom started the heads-up with a small chip advantage. Turkey's Koray Korkmaz took home the bronze medal and added €24,500 to his seven-figure live earnings, while €5,000 Progressive Bounty runner-up Justas Vaiciulionis and Finnish grinder Tommi Lankinen also made an appearance at the final table.
€555 Championship Final Table Results
Place
Player
Country
Prize
1
Joel Haapio
Finland
€47,560*
2
Rasmus Lundstrom
Finland
€41,200*
3
Koray Korkmaz
Turkey
€24,500
4
Algirdas Saveikis
Lithuania
€18,050
5
Justas Vaiciulionis
Lithuania
€13,250
6
Thanh Duan
Finland
€10,000
7
Tommi Lankinen
Finland
€7,350
8
Kristiana Stauere
Latvia
€5,800
9
Hanna Heinlo
Estonia
€4,700
* = denotes heads-up deal
Day 3 Action
At the start of Day 3, only 16 of the 583 entries returned to Olympic Park Casino to divide the lion's share of the €274,010 prize pool and determine who would walk away the champion. Estonian Powerhouses Tarmo Tammel and Igor Pihela Sr. started the day short and were quickly dispatched off in 16th and 14th place, earning €2,700 and €3,100 respectively.
The entertaining Timo Ruuska's (12th - €3,550) fate was ultimately decided by a dice roll as that is how he decided to call off against Vaiciulionis' flush. Ultimately, Finnish regular Juho Suutari ended up as the final table bubble boy, also eliminated by Vaiciulionis.
Lundstrom had come into the third day as a massive chipleader, but Korkmaz had worked his way up the rankings throughout the first two and a half hours of poker and started the final table with a slight edge.
Two ladies were still in contention when the final table got underway. Hanna Heinlo and Kristiana Stauere had been short throughout the later stages of Day 2 and the entirety of Day 3, but managed to climb the payjump ladder all the way to the final table. That is where their story ended, however, as Heinlo, Estonia's last hope, ended in ninth place while Stauere got her final ladder to eighth.
While Korkmaz and Lundstrom were busy battling for the chip lead, Vaiciulionis knocked out Lankinen in seventh. Six-handed play then continued for a while, and the stacks ended up relatively even at the first break of the final table.
However, Lundstrom soon pulled away from the pack again as he eliminated Thanh Doan in sixth place and not long after Vaiciulionis in fifth. Korkmaz joined him atop the counts by knocking out Algirdas Saveikis in fourth place, leaving Haapio as the absolute short stack three-handed.
Korkmaz's stay at the top would be short-lived, however, as Lundstrom hero-called his bluff with bottom pair before Haapio eliminated him not much later. The two Finns then agreed to a deal heads-up, leaving €8,000 and the trophy to play for.
Heads-Up Play
Lundstrom started the heads-up with a slight chip advantage and soon pulled away further as every pot seemed to head in his direction. A pattern occurred where Lundstrom had Haapio on the ropes and Haapio doubled up to stay in contention. In fact, Haapio won four at-risk all-ins until he finally had the chip advantage.
Finally, Haapio had Lundstrum at risk with pocket deuces against ace-deuce. The board remained free of any aces and Haapio's rail rushed toward him as they embraced in an emotional spectacle. He hoisted the trophy before cashing out his best-ever score and heading into the night to celebrate.
Thus concludes the live report of the €555 Championship. Be sure to come back to the live blog tomorrow as the reporting will shift to Day 2 of the prestigious €1,100 Main Event.
Joel Haapio Wins Kings of Tallinn: Autumn Edition's €555 Championship (€47,560) Posted Thursday 24th October, 2024 at 22:02(UTC+2) by Frank Visser
Joel Haapio open-jammed from the button and Rasmus Lundstrom called off his final 2,500,000 in the big blind.
Rasmus Lundstrom: Joel Haapio:
Lundstrom's rail screamed for an ace but the flop did not provide one. The turn changed the chants to a ten, but neither that nor an ace arrived on the river.
Lundstrom ended the tournament as the runner-up, taking home his best-ever live score of €41,200 after a heads-up deal.
Player
Chips
Progress
Joel Haapio
17,500,000
4,200,000
Rasmus Lundstrom
0
0
Lundstrom Wins Some Back Posted Thursday 24th October, 2024 at 21:47(UTC+2) by Frank Visser
Rasmus Lunstrom limped in on the button and Joel Haapio checked in the big blind. Lunstrom fired bets of 300,000 on the flop and 725,000 on the turn.
Haapio check-called both times until they both checked the river. Haapio played two pair with , but it was not enough as Lundstrom had made a flush with his and raked in the pot.
Player
Chips
Progress
Joel Haapio
13,300,000
1,000,000
Rasmus Lundstrom
4,200,000
1,000,000
Haapio Gets It In Again, Takes Over Chiplead Posted Thursday 24th October, 2024 at 21:40(UTC+2) by Frank Visser
Rasmus Lundstrom raised to 600,000 on the button, prompting Joel Haapio to defend.
Lundstrom continued for 900,000 on the flop. Haapio check-raised to 2,100,000, which Lundstrom called.
The fell on the turn. Haapio shoved all in for 4,300,000 and was snap-called by Lundstrom.
Joel Haapio: Rasmus Lundstrom:
Lundstrom had top pair but was an underdog against the two pair of Haapio. The river did not improve his hand and he doubled up his opponent once again.
Haapio gained a massive chip lead as the fortunes seemed to have reversed in the heads-up battle.
Player
Chips
Progress
Joel Haapio
14,300,000
7,000,000
Rasmus Lundstrom
3,200,000
7,000,000
Haapio Continues Closing the Gap Posted Thursday 24th October, 2024 at 21:36(UTC+2) by Frank Visser
Joel Haapio looked down at on the button and raised to 600,000. Rasmus Lundstrom called in the big blind with and check-called the 400,000 Haapio put in on the flop.
Haapio sized up to 1,200,000 on the turn with his top pair. Undeterred, Lundstrom kept floating and check-called again. Finally, Haapio jammed all in for 2,300,000 on the river, this time seeing Lundstrom check-fold his queen-high.
Player
Chips
Progress
Rasmus Lundstrom
10,200,000
1,600,000
Joel Haapio
7,300,000
1,600,000
Haapio Holds Hope After Second Double-Up Posted Thursday 24th October, 2024 at 21:29(UTC+2) by Frank Visser
Rasmus Lundstrom raised to 500,000 on the button, being called by Joel Haapio in the big blind.
Lundstrom continued for 275,000 on the flop and was check-raised to 650,000 by Haapio.
Undeterred, Lundstrom made the call. The rest of the board checked through. Lundstrom tabled for nines and sevens with a queen kicker, sending Haapio's for a counterfeit three into the muck.
Player
Chips
Progress
Rasmus Lundstrom
12,500,000
1,400,000
Joel Haapio
5,000,000
1,400,000
Haapio Halts Lundstrom's Momentum, Doubles Up Posted Thursday 24th October, 2024 at 20:51(UTC+2) by Frank Visser
Joel Haapio raised his button to 500,000 and saw Rasmus Lundstrom defend in the big blind. The flop fell , where Lundstrom check-called the 250,000 bet of Haapio.
The turn paired the board and was checked through. On the river, Lundstrom bet 2,000,000 and was snapped off by Haapio.
Lundstrom showed for trip sevens, beating the of Haapio and extending his lead.
Player
Chips
Progress
Rasmus Lundstrom
13,100,000
2,700,000
Joel Haapio
4,400,000
2,700,000
Play Resumes as Deal Agreed Upon Posted Thursday 24th October, 2024 at 20:40(UTC+2) by Frank Visser
Koray Korkmaz put his stack of 3,500,000 in from the small blind. Joel Haapio pondered for a few moments but eventually called in the big blind, covering Korkmaz by but a few chips.
Koray Korkmaz: Joel Haapio:
Neither player improved on the runout. Haapio's ace-high was the winning hand and he knocked out Korkmaz in third place.
Player
Chips
Progress
Rasmus Lundstrom
10,400,000
800,000
Joel Haapio
7,100,000
4,300,000
Koray Korkmaz
0
0
Lundstrom Makes Amazing Hero Call Against Korkmaz Posted Thursday 24th October, 2024 at 20:16(UTC+2) by Frank Visser
Algirdas Saveikis open-jammed his button for 2,700,000. Koray Korkmaz called in the small blind and had him covered.
Algirdas Saveikis: Koray Korkmaz:
Saveikiz needed help, and he received it on the flop. The turn reversed the fortunes, however, as Korkmaz made the higher pair. The river changed nothing as Saveikis waved off in fourth.
Player
Chips
Progress
Koray Korkmaz
8,000,000
4,700,000
Algirdas Saveikis
0
0
19:30 (UTC+2)
Start of Level 33 Blinds: 100,000/200,000 Ante: 200,000
Haapio Evens It Out With Korkmaz Posted Thursday 24th October, 2024 at 19:30(UTC+2) by Frank Visser
Level 32: 75,000/150,000 (150,000) Entries: 4/583
Joel Haapio raised to 300,000 under the gun. Koray Korkmaz defended his big blind and checked the flop.
Haapio bet 175,000 and Korkmaz called to the turn, where he led out for 175,000. Haapio put in a small raise to 375,000, which Korkmaz called.
The river was then checked down. Korkmaz tabled for bottom pair and had to see the pot being shipped to Haapio as he turned over for a higher pair.
Player
Chips
Progress
Koray Korkmaz
3,300,000
600,000
Joel Haapio
3,200,000
700,000
Justas Vaiciulionis Eliminated in 5th Place (€13,250) Posted Thursday 24th October, 2024 at 19:25(UTC+2) by Frank Visser
Level 32: 75,000/150,000 (150,000) Entries: 5/583
Rasmus Lundstrom raised to 300,000 in the small blind before Justas Vaiciulionis three-bet all in for 2,100,000 in the small blind.
Lundstrom snap-called and the cards were tabled.
Justas Vaiciulionis: Rasmus Lundstrom:
Vaiciulionis was dominated and was only drawing to a chop when the flop hit. The turn did nothing for him and the river sealed his fate as the fifth-place finisher.
Player
Chips
Progress
Rasmus Lundstrom
8,300,000
1,900,000
Justas Vaiciulionis
0
0
Korkmaz Spends Some Minutes in the Tank Posted Thursday 24th October, 2024 at 19:09(UTC+2) by Frank Visser
Level 32: 75,000/150,000 (150,000) Entries: 5/583
It folded to Koray Korkmaz on the button, who raised to 300,000 with .
Joel Haapio then three-bet shoved for 1,900,000 from the small blind with , sending Korkmaz into a tank of around five minutes.
Eventually, he let his hand go and the chips were shipped to Haapio.
Player
Chips
Progress
Koray Korkmaz
3,900,000
400,000
Joel Haapio
2,500,000
300,000
Thanh Doan Eliminated in 6th Place (€10,000) Posted Thursday 24th October, 2024 at 19:03(UTC+2) by Frank Visser
Level 32: 75,000/150,000 (150,000) Entries: 6/583
Rasmus Lundstrom raised to 300,000 under the gun. Thanh Doan then three-bet all in for 1,500,000 in the cutoff.
Lundstrom asked for a count, thought for a while, and put in a call.
Thanh Doan: Rasmus Lundstrom:
Lundstrom needed an ace to knock out Doan, but the flop brought him other opportunities. His flush came in on the turn, after which the river failed to pair the board.
Doan shook hands and said his goodbyes as hi exited in sixth place.
Player
Chips
Progress
Rasmus Lundstrom
6,400,000
1,900,000
Thanh Doan
0
0
Chip Update After Preflop Battles Posted Thursday 24th October, 2024 at 19:00(UTC+2) by Frank Visser
Player
Chips
Progress
Rasmus Lundstrom
4,500,000
400,000
Koray Korkmaz
4,300,000
550,000
Algirdas Saveikis
2,800,000
650,000
Justas Vaiciulionis
2,300,000
0
Joel Haapio
2,200,000
625,000
Thanh Doan
1,500,000
525,000
Vaiciulionis Three-Bets Into Kings Posted Thursday 24th October, 2024 at 18:48(UTC+2) by Frank Visser
Level 32: 75,000/150,000 (150,000) Entries: 6/583
Rasmus Lundstrom found under the gun and raised to 300,000. Justas Vaiciulionis looked down at in the hijack and three-bet to 750,000.
It folded back to Lundstrom, who tanked for a while and then jammed all in. Vaiciulionis snap-folded and the first pot after the break headed to Lundstrom.
Player
Chips
Progress
Rasmus Lundstrom
4,900,000
1,150,000
Justas Vaiciulionis
2,300,000
700,000
18:44 (UTC+2)
Start of Level 32 Blinds: 100,000/150,000 Ante: 150,000
Break Time Posted Thursday 24th October, 2024 at 18:32(UTC+2) by Frank Visser
The six remaining players have been sent on a 15-minute break.
Player
Chips
Progress
Rasmus Lundstrom
3,750,000
50,000
Koray Korkmaz
3,750,000
850,000
Justas Vaiciulionis
3,000,000
200,000
Joel Haapio
2,825,000
25,000
Algirdas Saveikis
2,150,000
550,000
Thanh Doan
2,025,000
275,000
Haapio Hauls Another Double-Up Posted Thursday 24th October, 2024 at 18:23(UTC+2) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 6/583
Joel Haapio open-jammed for 1,400,000 in the small blind. Rasmus Lundstrom spent some time in the big blind thinking it through before making the call.
Joel Haapio: Rasmus Lundstrom:
Haapio paired up on the flop while the turn removed some outs for Lundstrom. The river changed nothing as the field evened out further.
Player
Chips
Progress
Rasmus Lundstrom
3,800,000
1,600,000
Joel Haapio
2,800,000
1,700,000
Doan Gets Tiny Three-Bet Through Posted Thursday 24th October, 2024 at 18:20(UTC+2) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 6/583
Justas Vaiciulionis made a raise to 250,000 in the hijack with . Than Doan saw in the cutoff and reraised to 500,000.
Vaiciulionis spent some puzzled moments in the tank but eventually folded his cards as the pot was granted to Doan.
Player
Chips
Progress
Justas Vaiciulionis
3,200,000
100,000
Thanh Doan
2,300,000
100,000
Saveikas and Vaiciulionis Take It Post Flop Posted Thursday 24th October, 2024 at 18:11(UTC+2) by Frank Visser
Level 31: 60,000/120,000 (120,000) Entries: 6/583
After a period of pure preflop play, Algirdas Saveikas raised to 240,000 in the hijack with . Justas Vaiciulionis spent some time in the big blind before defending .
The flop checked through to the on the turn. Vaiciulionis weighed his options for a bit but ultimately checked. Saveikas bet 550,000 with his two pair and received an instant fold from Vaiciulionis' ducks.
Player
Chips
Progress
Justas Vaiciulionis
3,300,000
0
Algirdas Saveikis
1,600,000
400,000
17:55 (UTC+2)
Start of Level 31 Blinds: 60,000/120,000 Ante: 120,000
Tommi Lankinen Eliminated in 7th Place (€7,350) Posted Thursday 24th October, 2024 at 17:55(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 7/583
Thanh Doan open-jammed for 1,200,000 from middle position. It folded to Tommi Lankinen in the big blind, who called off for 1,100,000.
Tommi Lankinen: Thanh Doan:
The flop brought no help for Lankinen, although the turn did give him a gutshot. However, the river did not improve his hand, leaving him stranded in seventh.
Player
Chips
Progress
Thanh Doan
2,400,000
1,180,000
Tommi Lankinen
0
0
Haapio Doubles Up Through Korkmaz Posted Thursday 24th October, 2024 at 17:51(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 7/583
Koray Korkmaz raised to 200,000 on the button, after which small blind Joel Haapio three-bet jammed for 430,000. Korkmaz put in the extra chips and the players showed down.
Joel Haapio: Koray Korkmaz:
Haapio dominated Korkmaz. The flop brought some chop outs, which the turn brought in. The river was for Haapio, however, as he made a better two pair to double up.
Player
Chips
Progress
Koray Korkmaz
4,600,000
400,000
Joel Haapio
1,100,000
20,000
Korkmaz Puts Pressure on Posted Thursday 24th October, 2024 at 17:49(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 7/583
Algirdas Saveikis looked down at on the button and raised to 200,000. Koray Korkmaz found in the small blind and quickly moved all in.
Saveikis instantly folded as Korkmaz added some more chips.
Player
Chips
Progress
Koray Korkmaz
5,000,000
400,000
Algirdas Saveikis
1,200,000
365,000
Vaiciulionis Profits From Limping Posted Thursday 24th October, 2024 at 17:40(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 7/583
Justas Vaciulionis saw under the gun and decided to limp in. It then folded to Rasmus Lundstrom on the button, who made it 250,000 to go with . Tommi Lankinen defended his in the big blind before Vaciulionis came along as well.
The flop fell . It checked to Lundstrom, who fired 225,000. Lankinen quickly folded but Vaciulionis raised to 700,000 with his combo draw.
Lundstrom swiftly ditched his king-high as Vaciulionis picked up the pot.
Player
Chips
Progress
Rasmus Lundstrom
5,400,000
500,000
Justas Vaiciulionis
3,300,000
795,000
Tommi Lankinen
755,000
600,000
Kristiana Stauere Eliminated in 8th Place (€5,800) Posted Thursday 24th October, 2024 at 17:33(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 8/583
Rasmus Lundstrom open-jammed from the small blind. Kristiana Stauere called all-in for her final 340,000 in the big blinds and a showdown was had.
Kristiana Stauere: Rasmus Lundstrom:
Stauere flopped some hope as she made a pair on , but it was quickly dashed as the turn gave Lundstrom a higher one. The river did nothing to help her as the last lady departed in eighth place.
Player
Chips
Progress
Rasmus Lundstrom
5,900,000
500,000
Kristiana Stauere
0
0
Lundstrom Creates Gap Posted Thursday 24th October, 2024 at 17:28(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 8/583
Koray Korkmaz raised his button to 200,000 with . Rasmus Lundstrom looked down at in the big blind and defended.
Korkmaz continued for 175,000 on the flop, which Lundstrom called. The turn was checked through before the hit the river.
Lundstrom made an overbet of 1,100,000 and Korkmaz eventually mucked his ace-high.
Player
Chips
Progress
Rasmus Lundstrom
5,400,000
400,000
Koray Korkmaz
4,600,000
400,000
Lundstrom Gets Even With Korkmaz Posted Thursday 24th October, 2024 at 17:21(UTC+2) by Frank Visser
Level 30: 50,000/100,000 (100,000) Entries: 8/583
Koray Korkmaz raised to 200,000 under the gun with . Rasmus Lundstrom found in middle position and three-bet to 500,000.
Korkmaz gave it some thought but ultimately folded his suited connecter as the two ended up even in chips.
Player
Chips
Progress
Rasmus Lundstrom
5,000,000
920,000
Koray Korkmaz
5,000,000
100,000
17:12 (UTC+2)
Start of Level 30 Blinds: 50,000/100,000 Ante: 100,000
Hanna Heinlo Eliminated in 9th Place (€4,700) Posted Thursday 24th October, 2024 at 17:12(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 9/583
Koray Korkmaz raised to 160,000 in the cutoff. Hanna Heinlo committed her final 440,000 from the button and was quickly called by Korkmaz.
Hanna Heinlo: Koray Korkmaz:
Korkmaz paired his ace on the flop to take a big lead. The turn gave Heinlo's tens a gutshot, but it failed to come in on the river.
She was the first elimination of the final table, finishing in ninth place.
Player
Chips
Progress
Koray Korkmaz
4,900,000
345,000
Hanna Heinlo
0
0
Stauere Shoves All In Posted Thursday 24th October, 2024 at 17:08(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 9/583
Kristiana Stauere open-jammed in early position for her last 490,000 with .
Everybody else folded as Stauere welcomed the blinds to their new home.
Player
Chips
Progress
Kristiana Stauere
690,000
200,000
Final Table Underway Posted Thursday 24th October, 2024 at 16:57(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 9/583
The final nine players have been introduced as the cards are in the air for the final table of the €555 Championship.
Final Table Redraw Posted Thursday 24th October, 2024 at 16:37(UTC+2) by Frank Visser
Seat
Player
Country
Chip Count
Big Blinds
1
Justas Vaiciulionis
Lithuania
2,505,000
31
2
Thanh Doan
Finland
1,220,000
15
3
Algirdas Saveikis
Lithuania
1,565,000
20
4
Koray Korkmaz
Turkey
4,555,000
60
5
Hanna Heinlo
Estonia
640,000
8
6
Joel Haapio
Finland
1,080,000
14
7
Rasmus Lundstrom
Finland
4,080,000
51
8
Kristiana Stauere
Latvia
490,000
6
9
Tommi Lankinen
Finland
1,355,000
17
Player
Chips
Progress
Koray Korkmaz
4,555,000
145,000
Rasmus Lundstrom
4,080,000
20,000
Justas Vaiciulionis
2,505,000
5,000
Algirdas Saveikis
1,565,000
285,000
Tommi Lankinen
1,355,000
1,320,000
Thanh Doan
1,220,000
90,000
Joel Haapio
1,080,000
260,000
Hanna Heinlo
640,000
390,000
Kristiana Stauere
490,000
240,000
Final Table Break Posted Thursday 24th October, 2024 at 16:31(UTC+2) by Frank Visser
The players have been sent on a 20-minute break while the final table is being prepared.
Juho Suutari Eliminated in 10th Place (€4,000) Posted Thursday 24th October, 2024 at 16:30(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 10/583
Juho Suutari raised to 335,000 in the cutoff, about half his stack. Justas Vaiciulionis then three-bet jammed with the covering stack and Suutari snap-called once it had folded back to him.
Juho Suutari: Justas Vaiciulionis:
The flop was a sweaty one. Suutari flopped top pair but Vaiciulionis had a plethora of outs. The turn bricked but the river made Vaiciulionis a higher better.
Suutari knocked the table and instantly walked away as the final table of nine was set.
Player
Chips
Progress
Justas Vaiciulionis
2,500,000
1,850,000
Juho Suutari
0
0
Korkmaz Takes Lead in Battle of Pairs Posted Thursday 24th October, 2024 at 16:28(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 10/583
Koray Korkmaz raised to 160,000 under the gun. Rasmus Lundstrom peeled his cards on the button and flat-called.
The two big stacks went to a flop of , which was checked through. Korkmaz fired 400,000 on the turn and was called by Lundstrom.
The river was quickly checked down. Korkmaz tabled for a pair of nines, besting the of Lundstrom and grabbing a sizable chiplead.
Player
Chips
Progress
Koray Korkmaz
4,700,000
500,000
Rasmus Lundstrom
4,100,000
300,000
Ace-High Flush for Korkmaz to Take Lead Posted Thursday 24th October, 2024 at 16:19(UTC+2) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 10/583
Koray Korkmaz min-raised from under the gun with at the feature table and was called by Rasmus Lundstrom from the button with and by Joel Haapio with from the big blind.
All three players checked the all-heart flop. Korkmaz improved to the ace-high flush on the turn before the trio checked it around again.
Both Lundstrom and Haapio checked after the river completed the board. Korkmaz bet 400,000 and Lunstrom quickly folded. Meanwhile, Haapio went into the tank with his turned two-pair before he eventually called.
The first lead change of the final day took place, although not a big one with Korkmaz holding a few more chips than Lundstrom after the hand.
Player
Chips
Progress
Koray Korkmaz
4,200,000
700,000
Joel Haapio
640,000
40,000
Lankinen Eventually Check-Raises Saveikis Posted Thursday 24th October, 2024 at 16:12(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 10/583
Algirdas Saveikis raised to 160,000 under the gun. It folded to Tommi Lankinen in the big blind, who defended.
The flop fell . Lankinen checked, prompting Saveikis to bet 90,000. Lankinen spent a few minutes in the tank before tossing in a raise to 205,000, which garnered a quick fold.
Player
Chips
Progress
Algirdas Saveikis
1,850,000
235,000
Tommi Lankinen
1,350,000
285,000
Rockets for Haapio Posted Thursday 24th October, 2024 at 16:10(UTC+2) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 10/583
Joel Haapio min-raised with from the cutoff at the televised feature table before Rasmus Lundstrom with opted to defend his big blind with his suited connectors.
Lundstrom improved to bottom pair before he checked on the flop. Haapio, still ahead with an overpair, bet 100,000 and Haapio called.
After the turn paired the board, Lundstrom opted to bet 120,000. Haapio quickly called and the river completed the board.
Haapio opted for max-value with a jam of 400,000. Lundstrom paused for a moment before folding to his opponent's better hand.
Player
Chips
Progress
Rasmus Lundstrom
4,400,000
400,000
Joel Haapio
1,300,000
880,000
Heinlo Gets Some Breathing Room Posted Thursday 24th October, 2024 at 16:06(UTC+2) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 10/583
Rasmus Lundstrom opened for 160,000 with from under the gun. Hanno Heinlo looked down at her and three-bet jammed for 670,000. Koray Korkmaz paused with before folding from the small blind before Kristiana Steuere with got out of the way as well from the big blind.
Heinlo gained some breathing room without seeing a flop after Lundstrom quickly gave up on his hand opting not to gamble.
Player
Chips
Progress
Rasmus Lundstrom
4,800,000
890,000
Koray Korkmaz
3,500,000
25,000
Hanna Heinlo
1,030,000
360,000
Kristiana Stauere
730,000
160,000
Doan Doubles on Final Table Bubble Posted Thursday 24th October, 2024 at 15:58(UTC+2) by Frank Visser
Level 29: 40,000/80,000 (80,000) Entries: 10/583
It was folded to Thanh Doan in the small blind, who open-jammed for 490,000. Tommi Lankinen made a quick call in the big blind and the cards were tabled.
Thanh Doan: Tommi Lankinen:
Lankinen had a slight edge but Doan paired up on the board to double up.
Player
Chips
Progress
Thanh Doan
1,060,000
1,470,000
Tommi Lankinen
900,000
1,315,000
15:57 (UTC+2)
Start of Level 29 Blinds: 40,000/80,000 Ante: 80,000
First Break of Day 3 Posted Thursday 24th October, 2024 at 15:37(UTC+2) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 10/583
The ten remaining players have been sent on a 20-minute break. When they come back, the final table bubble will continue.
Player
Chips
Progress
Rasmus Lundstrom
4,990,000
390,000
Koray Korkmaz
3,475,000
1,475,000
Justas Vaiciulionis
1,705,000
1,100,000
Tommi Lankinen
1,635,000
580,000
Algirdas Saveikis
1,615,000
30,000
Juho Suutari
1,040,000
135,000
Kristiana Stauere
890,000
580,000
Kristiana Stauere
890,000
510,000
Joel Haapio
820,000
680,000
Hanna Heinlo
670,000
150,000
Thanh Doan
650,000
250,000
Pasi Laihinen Eliminated in 11th Place (€4,000) Posted Thursday 24th October, 2024 at 15:37(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 10/583
Pasi Laihinen jammed for 520,000 from the hijack before Rasmus Lundstrom three-bet to 1 million from the small blind. The cards were tabled after Hanna Heinlo folded from the big blind.
Pasi Laihinen: Rasmus Lundstrom:
Laihinen bricked the board and was eliminated in 11th place for €4,000 and the action was on the final table bubble just before the first break.
Player
Chips
Progress
Rasmus Lundstrom
5,300,000
1,000,000
Pasi Laihinen
0
0
Doan Doubles as He Fades All Draws Posted Thursday 24th October, 2024 at 15:21(UTC+2) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 11/583
Justas Vaiciulionis limped in from the small blind and Thanh Doan checked in the big blind. The pair checked through the flop before the fell on the turn.
Vaiciulionis bet 85,000 and Doan quickly jammed all in for 250,000. Vaiciulionis spent a minute or two in the tank before putting in the calling chips.
Thanh Doan: Justas Vaiciulionis:
Doan's pair was up against the straight and flush draw of Vaiciulionis. The on the river did not complete either of them, however, and Doan raked in his double-up.
Player
Chips
Progress
Justas Vaiciulionis
1,750,000
1,055,000
Thanh Doan
680,000
810,000
Stauere Wins With Aggression Posted Thursday 24th October, 2024 at 15:13(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 11/583
Kristiana Stauere raised to 120,000 with from the cutoff on the televised feature table before Joel Haapio with defended his big blind.
Haapio got a piece with middle pair on the flop and check-called a bet of 125,000 before the turn added more outs with an open-ended straight draw for Stauere.
Haapio checked again before Stauere bet 350,000 for nearly half her remaining stack. Haapio tanked for several moments before he gave up on the better hand.
Player
Chips
Progress
Kristiana Stauere
1,400,000
200,000
Joel Haapio
1,100,000
400,000
Lankinen Wins Back-to-Back All-Ins, Doubles Up Posted Thursday 24th October, 2024 at 15:07(UTC+2) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 11/583
One hand after eliminating Timo Ruuska, Tommi Lankinen three-bet jammed for 920,000 in the small blind. Thanh Doan, on the button, was the initial raiser and quickly called.
Tommi Lankinen: Thanh Doan:
Doan had the lead, but it disappeared on the flop. Lankinen's flopped pair of aces remained best on the runout and he doubled up, leaving Doan with less than seven big blinds.
Player
Chips
Progress
Tommi Lankinen
1,960,000
1,410,000
Thanh Doan
400,000
1,090,000
Timo Ruuska Eliminated in 12th Place (€3,550) Posted Thursday 24th October, 2024 at 15:05(UTC+2) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 11/583
Timo Ruuska raised all-in for 250,000 in the hijack and was called by Tommi Lankinen in the big blind.
Timo Ruuska: Tommi Lankinen:
The flop was great for Ruuska, making top pair and a flush draw. The turn did not improve Lankinen, but the river gave him trips, putting a bad beat on Ruuska.
Ruuska took it in stride and shook hands with Lankinen before exiting the tournament area.
Player
Chips
Progress
Tommi Lankinen
920,000
255,000
Timo Ruuska
0
0
Heinlo Doubles Through Chip Leader Lundstrom Posted Thursday 24th October, 2024 at 15:05(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 12/583
Rasmus Lundstrom hasn't let go of the chip lead since the start of the day. His stack didn't take too much of a dent as he went after the short-stacked Hanna Heinlo.
Lundstrom jammed for 5 million from the small blind. Heinlo took her time but eventually called off her stack of 380,000.
Hanna Heinlo: Rasmus Lundstrom:
It was a bit of a wide jam by Lundstrom but Heinlo still had a sweat as her opponent had two live cards. Lundstrom bricked the double-paired runout and Heinlo doubled her stack with her king kicker instead of a bad beat sending her to the rail.
Player
Chips
Progress
Rasmus Lundstrom
4,600,000
0
Hanna Heinlo
820,000
205,000
Korkmaz Flops a Flush Posted Thursday 24th October, 2024 at 14:58(UTC+2) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 12/583
Kristiana Stauere min-raised from under the gun with before Koray Korkmaz with defended his big blind.
Korkmaz flopped Yahzee as the flop improved him to a flush. Stauere bet 110,000 and Korkmaz check-called.
Both players checked the turn before Korkmaz went for value with a bet of 425,000 on the river. Stauere saved some chips with a quick fold while Korkmaz witnessed his stack soar above 2 million for the first time on the final day.
Player
Chips
Progress
Koray Korkmaz
2,000,000
100,000
Kristiana Stauere
1,200,000
500,000
14:50 (UTC+2)
Start of Level 28 Blinds: 30,000/60,000 Ante: 60,000
Saveikis Jams While Missing Crucial Fact Posted Thursday 24th October, 2024 at 14:48(UTC+2) by Frank Visser
Level 28: 30,000/60,000 (60,000) Entries: 12/583
Juho Suutari raised to 120,000 under the gun. The action folded to Algirdas Saveikis (pictured below), who quickly moved in for 1,110,000 in the small blind. The short-stacked Timo Ruuska got out of the way and it was back on Suutari.
"I don't think you saw me raise," Suutari repeated a few times while he spent some minutes thinking it through.
Eventually, he folded his cards. Saveikis admitted he indeed missed Suutari's open-raise and tabled to prove it, much to Suutari's frustration.
Player
Chips
Progress
Algirdas Saveikis
1,350,000
515,000
Juho Suutari
1,175,000
55,000
Lankinen Beats Big Slick to Double Up Posted Thursday 24th October, 2024 at 14:39(UTC+2) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries: 12/583
Tommi Lankinen put in his final 270,000 as first to act. The action folded to Justas Vaiciulionis in the small blind, who called.
Tommi Lankinen: Justas Vaiciulionis:
It was looking like the end of Lankinen's tournament run, but he paired his five on the flop. Neither the turn nor the river had a king in store for Vaiciulionis, and he doubled up his opponent.
Player
Chips
Progress
Justas Vaiciulionis
2,150,000
300,000
Tommi Lankinen
640,000
115,000
Mindaugas Kriauciunas Eliminated in 13th Place (€3,550) Posted Thursday 24th October, 2024 at 14:37(UTC+2) by Jason Glatzer
Level 27: 25,000/50,000 (50,000) Entries: 12/583
Rasmus Lundstrom min-raised from the cutoff. Mindaugas Kriauciunas three-bet jammed for 385,000 from the button and was quickly called by Lundstrom.
Mindaugas Kriauciunas: Rasmus Lundstrom:
Kriauciunas appeared to hit a good spot to get revenge from just a couple of hands before when Lundstrom hit trips on the river with the better hand when the chips were committed.
However, the runout improved Lundstrom to a flush to eliminate Kriauciunas in 13th place for €3,550.
Player
Chips
Progress
Rasmus Lundstrom
4,600,000
600,000
Mindaugas Kriauciunas
0
0
Lundstrom Pads Lead With Trips Posted Thursday 24th October, 2024 at 14:34(UTC+2) by Jason Glatzer
Level 27: 25,000/50,000 (50,000) Entries: 13/583
Rasmus Lundstrom (pictured below) defended his big blind with after Mindaugas Kriauciunas min-raised with from under the gun.
Both players checked after getting a piece of the flop before Lundstrom check-called a bet of 150,000 on the turn by Kriauciunas.
The river improved Lundstrom to trips. He fired out for a tiny bet of 80,000. Kriuaucinas called only to get the bad news. Meanwhile, Lundstrom padded his chip lead and hit the 4 million mark for the first time on the final day.
Player
Chips
Progress
Rasmus Lundstrom
4,000,000
400,000
Mindaugas Kriauciunas
560,000
330,000
Ruuska Rolls the Dice Posted Thursday 24th October, 2024 at 14:29(UTC+2) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries: 12/583
Arriving on the river with a board of in the middle, Timo Ruuska (pictured below) checked from the big blind to Justas Vaiciulionis in the hijack.
Vaiciulionis made a bet of 225,000 into the pot of 530,000, which was worth half of Ruuska's stack.
Ruuska spent a few minutes in the tank before he picked up the die he carried and cast it. It rolled a six and he immediately slammed in a call.
Vaiciulionis tabled for the second nuts and took down the pot, leaving Ruuska with five big blinds.
Player
Chips
Progress
Justas Vaiciulionis
2,505,000
655,000
Timo Ruuska
250,000
725,000
Everyone Loves a Chop Posted Thursday 24th October, 2024 at 14:29(UTC+2) by Jason Glatzer
Level 27: 25,000/50,000 (50,000) Entries: 13/583
Rasmus Lundstrom opened for 100,000 with from under the gun. Mindaugas Kriauciunas three bet to 250,000 with before Kristiana Stauere four-bet shoved with from the big blind.
Lundstrom quickly folded before Kriauciunas called off his stack of 805,000.
The two players chopped it up with no flushes possible after the ran out on the board.
Player
Chips
Progress
Rasmus Lundstrom
3,600,000
15,000
Kristiana Stauere
1,700,000
0
Mindaugas Kriauciunas
890,000
260,000
Lankinen Back Short After Doubling Saveikis Posted Thursday 24th October, 2024 at 14:22(UTC+2) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries: 13/583
Tommi Lankinen jammed all in from the small blind. Algirdas Saveikis (pictured below) was covered in the big blind and called off his stack of 560,000.
Algirdas Saveikis: Tommi Lankinen:
The board improved neither player, doubling up Saveikis with his king-queen high. Lankinen, meanwhile, was back down to five and a half big blinds.
Player
Chips
Progress
Algirdas Saveikis
1,070,000
235,000
Tommi Lankinen
275,000
90,000
Igor Pihela Sr. Eliminated in 14th Place (€3,100) Posted Thursday 24th October, 2024 at 14:21(UTC+2) by Jason Glatzer
Level 27: 25,000/50,000 (50,000) Entries: 13/583
Igor Pihela Sr. already had his stack of 85,000 committed preflop with 50,000 as the big blind and the rest as the ante from the big blind when Koray Korkmaz raised to 100,000 from under the gun.
Joel Haapio called from the small blind before he check-folded his facing a bet of 75,000 by Korkmaz. The cards were in trouble and Pihela needed some help.
Igor Pihela Sr.: Koray Korkmaz:
Pihela didn't get help on the turn and was eliminated in 14th place for €3,100 to his opponent's two pair after the river completed the board. The remaining 13 players each earned a pay jump to €3,550 with all of the eliminations thus far at the televised feature table on Day 3.
Player
Chips
Progress
Koray Korkmaz
1,900,000
175,000
Joel Haapio
1,500,000
75,000
Igor Pihela Sr.
0
0
Laihinen Gets Ruuska to Fold Posted Thursday 24th October, 2024 at 14:15(UTC+2) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries: 13/583
Timo Ruuska made a raise to 100,000 in the hijack. Pasi Laihinen (pictured below) sat in the cutoff and three-bet to 450,000, all of his chips.
The action folded back to Ruuska, who asked for a count but made a reluctant fold soon after.
Player
Chips
Progress
Timo Ruuska
875,000
100,000
Pasi Laihinen
700,000
70,000
Andrei Mjagkov Eliminated in 15th Place (€3,100) Posted Thursday 24th October, 2024 at 14:13(UTC+2) by Jason Glatzer
Level 27: 25,000/50,000 (50,000) Entries: 14/583
Igor Pihela Sr. jammed for 645,000 from under the gun. Kristiana Stauere had 560,000 in her stack when she called from the hijack. Stauere wasn't the only player at risk this hand. Andrei Mjagkov joined the party after he called off his stack of 410,000.
Andrei Mjagkov: Kristiana Stauere: Igor Pihela Sr.:
Four diamonds hit the board but Stauere effectively tripled up with a set while sending Mjagkov to the rail in 15th place for €3,100 after neither of her opponents had what it took to complete the flush.
Meanwhile, Pihela, who began the day with a short stack, was down to under two big blinds after the hand.
Player
Chips
Progress
Kristiana Stauere
1,700,000
1,140,000
Igor Pihela Sr.
85,000
560,000
Andrei Mjagkov
0
0
Heinlo Doubles Through Pihela Posted Thursday 24th October, 2024 at 14:08(UTC+2) by Jason Glatzer
Level 27: 25,000/50,000 (50,000) Entries: 15/583
Igor Pihela Sr. opened for 200,000 from early position. Hanna Heinlo three-bet shoved for 270,000. The action folded around to Pihela, who paused for several moments before tossing in a few more chips to call.
Hanna Heinlo: Igor Pihela Sr.:
Both players bricked the flop. Heinlo's ace-high was still good after the turn and no ace or nine followed with the river pairing the board for Heinlo to double her short stack.
Player
Chips
Progress
Igor Pihela Sr.
645,000
325,000
Hanna Heinlo
615,000
95,000
Lankinen Doubles Dire Stack Posted Thursday 24th October, 2024 at 14:04(UTC+2) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries: 15/583
Juho Suutari raised to 100,000 in middle position. Justas Vaiciulionis called in the hijack before Tommi Lankinen three-bet jammed for 290,000.
Suutari put in a minimum four-bet to isolate, forcing Vaiciulionis out of the pot.
Tommi Lankinen: Juho Suutari:
Lankinen paired up on the flop to take the lead, but Suutari turned a flush draw on the . The river bricked out, however, doubling up Lankinen.
Player
Chips
Progress
Justas Vaiciulionis
1,850,000
390,000
Juho Suutari
1,150,000
315,000
Tommi Lankinen
755,000
390,000
13:59 (UTC+2)
Start of Level 27 Blinds: 25,000/50,000 Ante: 50,000
Doan Shoves on Suutari Posted Thursday 24th October, 2024 at 13:55(UTC+2) by Frank Visser
Level 27: 25,000/50,000 (50,000) Entries: 15/583
Juho Suutari opened his button to 100,000. Thanh Doan looked at his cards in the big blind, thought for a couple of seconds, and jammed all in for 1,315,000.
Suutari looked puzzled and asked for a count. Not long after he had received the correct number, he let go of his cards and surrendered the pot.
Player
Chips
Progress
Thanh Doan
1,490,000
90,000
Juho Suutari
1,450,000
15,000
Tarmo Tammel Eliminated in 16th Place (€2,700) Posted Thursday 24th October, 2024 at 13:51(UTC+2) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 15/583
Four Estonians advanced to the final day of the €555 Championship. Igor Pihela Sr. held the shortest stack but chipped up early and pulled ahead of Estonian hero Tarmo Tammel.
Tammel jammed for 435,000 from under the gun. Pihela three-bet shoved for 480,000 from the hijack and it was likely that either an Estonian would be on the rail or would be down to just slightly more than a big blind after the cards were tabled.
Tarmo Tammel: Igor Pihela Sr.:
Pihela Sr. went from zero to hero to start the final table while sending Tammel to the cashier to collect the 16th place prize of €2,700 after improving to trips on the runout.
Meanwhile, the remaining 15 players laddered up the payout tables and are guaranteed at least a €3,100 payout.
Player
Chips
Progress
Igor Pihela Sr.
970,000
490,000
Tarmo Tammel
0
0
Suutari Sends Kriauciunas Into Tank Posted Thursday 24th October, 2024 at 13:40(UTC+2) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 16/583
Mindaugas Kriauciunas limped in from the small blind, after which Juho Suutari (pictured below) made it 100,000 to go in the big blind. Kriauciunas called before the pair checked through the flop and turn.
The then fell on the river, which Kriauciunas checked again. Suutari fired 140,000, and Kriauciunas tanked for a few minutes but ultimately found a fold.
Player
Chips
Progress
Juho Suutari
1,560,000
95,000
Mindaugas Kriauciunas
630,000
185,000
Pihela Here to Play Posted Thursday 24th October, 2024 at 13:39(UTC+2) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 16/583
Igor Pihela Sr. came in with a short stack and was firing right away to already nearly double without seeing a flop.
Pihela first jammed for 280,000 from early position at the feature table and the rest of the table folded. He then had more clubs with from under the gun the next hand and jammed for 380,000. Pihela added another 100,000 to his stack after the entire table folded.
Player
Chips
Progress
Igor Pihela Sr.
480,000
200,000
Play Underway; Updates on Delay Posted Thursday 24th October, 2024 at 13:04(UTC+2) by Frank Visser
Level 26: 20,000/40,000 (40,000) Entries: 16/583
The 16 remaining players have found their seats and the cards are in the air for the final day of the €555 Championship.
Stay tuned as the updates will follow on a 30-minute delay.
12:59 (UTC+2)
Day 3 of Kings of Tallinn Autumn Edition 2024 Started Level: 26 Blinds: 20,000/40,000 Ante: 40,000
Short Stacks Igor Pihela Sr. and Tarmo Tammel Battle for All-Time Money List on Final Day of €555 Championship Posted Thursday 24th October, 2024 at 11:56(UTC+2) by Frank Visser
Both Tarmo Tammel and Igor Pihela Sr. are among the most recognizable names in the Estonian poker scene. Today, at their home turf of the Olympic Park Casino, they could decide which spot they take on the prestigious all-time money list as the €555 Championship plays out its final day at Kings of Tallinn: Autumn Edition.
Only 16 players of the original 583 remain, of which Tammel sits in 14th with 465,000 chips, only 12 big blinds, while Pihela is dead last with a meager stack of 280,000. However, if Tammel, currently tenth on the Estonian all-time money list, spins it up he could overtake Pihela, who sits in ninth, as only €20,000 are between them and the top prize for this event is €52,760.
However, both Tammel and Pihela will have a tall task making a significant enough increase in their total live earnings, as they will have to combat monster chipleader Rasmus Lundstrom. Lundstrom managed to gather 3,615,000 chips on Day 2, more than twice as much as anyone else. Turkish player Koray Korkmaz sits in second with 1,725,000, while Thanh Doan completes the podium with a stack of 1,580,000.
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
Other notable names still having a shot at the trophy include Finnish grinders Juho Suutari (1,465,000) and Tommi Lankinen (365,000), and runner-up in the €5,000 Progressive Bounty earlier this week Justas Vaicilionis (1,460,000).
The majority of the €274,010 prize pool is still up for grabs, with each of the 16 players going home with at least €2,700. A payjump to €3,100 will be reached after one elimination, and the top six will all earn a five-figure payout.
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 action kicks off at 1 p.m. local time, with 19 minutes and 10 seconds left in Level 26: 20,000/40,000 (40,000). Each subsequent level will last for 40 minutes, with a break after every three levels, and play will not stop before a winner is crowned.
OlyBet.tv will have a cards-up live stream going from the very start. The stream will be on a 30-minute delay, and the live reporting will follow the same delay to prevent spoilers.
Stay tuned as the thrilling conclusion of the €555 Championship gets underway.
Seat Draw Posted Thursday 24th October, 2024 at 11:45(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
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.
flop did not provide one. The 
turn changed the chants to a ten, but neither that nor an ace arrived on the 
river.
flop and 725,000 on the 
turn.
river. Haapio played two pair with 
, but it was not enough as Lundstrom had made a flush with his 
flop. Haapio check-raised to 2,100,000, which Lundstrom called.
fell on the turn. Haapio shoved all in for 4,300,000 and was snap-called by Lundstrom.
river did not improve his hand and he doubled up his opponent once again.
on the button and raised to 600,000. Rasmus Lundstrom called in the big blind with 
and check-called the 400,000 Haapio put in on the 
flop.
turn with his top pair. Undeterred, Lundstrom kept floating and check-called again. Finally, Haapio jammed all in for 2,300,000 on the 
runout and consequently doubled up.
runout and doubled up his opponent.
flop.
turn, where Lundstrom checked again. Haapio fired 775,000 and Lundstrom called.
for bottom pair. Haapio played 
board checked through. Lundstrom tabled 
turn went check-check before the 
river failed to pair the board.
flop, which Lundstrom called. The 
£ GBP
$ USD
€ EUR
