0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0082 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/3/updates'
ORDER BY `views` DESC
0.0116 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/3/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0003 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.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.0040 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.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` = '2024_KOT_555_Champ'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '224'
AND `published` = 1
0.0310 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0079 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '230'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '231'
AND `published` = 1
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '236'
AND `published` = 1
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '237'
AND `published` = 1
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '240'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'
AND `name` = '3'
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '240'
ORDER BY `busted` ASC, `current_chips` DESC
0.0066 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` = '240'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10741'
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` = '10740'
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` = '10726'
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` = '10724'
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` = '10719'
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` = '10714'
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` = '10711'
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` = '10710'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10708'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10705'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10700'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10695'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10693'
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` = '10690'
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` = '10688'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10685'
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` = '10684'
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` = '10681'
ORDER BY `chip_change` DESC, `busted` ASC
0.0132 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10678'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10676'
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` = '10674'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10670'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10666'
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` = '10663'
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` = '10662'
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` = '10660'
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` = '10658'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10651'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10650'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10646'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10645'
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` = '10640'
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` = '10638'
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` = '10630'
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` = '10628'
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` = '10627'
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` = '10624'
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` = '10622'
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` = '10618'
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` = '10615'
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` = '10610'
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` = '10608'
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` = '10605'
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` = '10602'
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` = '10600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10584'
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` = '10581'
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` = '10578'
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` = '10573'
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` = '10571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10567'
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` = '10566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10564'
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` = '10561'
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` = '10550'
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` = '10547'
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` = '10546'
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` = '10542'
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` = '10541'
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` = '10540'
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` = '10536'
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` = '10531'
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` = '10530'
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` = '10525'
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` = '10522'
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` = '10519'
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` = '10517'
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` = '10507'
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` = '10474'
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` = '224'
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` = '230'
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` = '231'
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` = '236'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '237'
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` = '240'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 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` = '240'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10741'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10740'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0119 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10724'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10719'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10714'
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` = '10711'
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` = '10710'
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` = '10708'
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` = '10706'
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` = '10705'
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` = '10702'
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` = '10700'
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` = '10699'
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` = '10695'
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` = '10693'
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` = '10690'
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` = '10688'
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` = '10685'
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` = '10684'
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` = '10681'
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` = '10678'
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` = '10676'
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` = '10674'
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` = '10670'
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` = '10666'
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` = '10663'
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` = '10662'
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` = '10660'
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` = '10658'
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` = '10651'
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` = '10650'
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` = '10646'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10645'
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` = '10640'
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` = '10638'
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` = '10630'
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` = '10628'
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` = '10627'
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` = '10624'
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` = '10622'
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` = '10618'
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` = '10615'
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` = '10610'
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` = '10608'
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` = '10605'
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` = '10602'
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` = '10600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10597'
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` = '10592'
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` = '10590'
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` = '10589'
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` = '10584'
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` = '10581'
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` = '10578'
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` = '10573'
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` = '10571'
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` = '10575'
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` = '10567'
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` = '10566'
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` = '10564'
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` = '10561'
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` = '10550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10547'
ORDER BY `chip_change` DESC, `busted` ASC
0.0132 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0132 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10541'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10540'
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` = '10536'
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` = '10531'
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` = '10530'
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` = '10525'
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` = '10522'
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` = '10519'
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` = '10517'
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` = '10507'
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` = '10474'
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` = '240'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
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 2024 Ended Level: 35 Blinds: 200,000/400,000 Ante: 400,000
Reigning Finnish Champion Mikko Ylämäki Conquers Enormous Field to Win the €555 Kings of Tallinn Championship Posted Wednesday 28th February, 2024 at 21:56(UTC+2) by Frank Visser
The €555 Kings of Tallinn Championship brought a huge crowd of 700 entries to Olympic Park Casino in Tallinn, creating a massive prize pool of €329,000, a new record for this tournament. After three days of battle, Mikko Ylämäki from Finland was victorious over all of them, winning €58,835 after a heads-up deal with Andrius Bielskis. Bielskis had to console himself with the €49,875 he received as runner-up but had to see the trophy be awarded to Ylämäki after a nearly two-hour heads-up.
Ylämäki, who was crowned Finnish champion after winning the €560 Main Event in Helsinki back in October, secured his largest-ever recorded cash with the victory, with his previous largest being set in Tallinn as well. The Finnish player is a regularly seen guest in the Estonian capital, most recently finishing in fifth place in the €3,000 High Roller at Kings of Tallinn 2023.
Ylämäki defeated some tough competition on his way to victory, not only beating the very accomplished Bielskis heads-up but also defeating the likes of long-time Finnish crusher Joonas Helin and Kings of Tallinn trophy owner Touko Berndtson at the final table.
€555 Championship Final Table Results
Place
Player
Country
Prize
1
Mikko Ylämäki
Finland
€58,835*
2
Andrius Bielskis
Lithuania
€49,875*
3
Joonas Helin
Finland
€27,900
4
Oscar Peleg
Sweden
€20,100
5
Jordi Baixas
Spain
€15,200
6
Aleksandrs Krumins
Latvia
€11,250
7
Touko Berndtson
Finland
€8,700
8
Matte Karjalainen
Finland
€7,200
9
Knut Trulsen
Norway
€5,890
* = Denotes heads-up deal
Day 3 Action
After an elongated Day 2 left 13 players returning to Day 3, four eliminations had to take place before the streamed final table of nine could begin. The short-stacked Adrians Imsa was the first to fall, after which Jan-Mikael Kesanen quickly followed. The tournament then went on for another hour without anyone leaving, but ultimately Svetozar Marinovand Konsta Heikkila fell in quick succession to leave a final table of nine.
After a few minutes of play, Knut Trulsen became the shortest stack when two other players doubled up. He got his final blinds in with pocket fives and could not win against the tens of Helin. The war of attrition then began as several players doubled up their short stacks before Matte Karjalainen fell victim to then-chipleader Andrius Bielskis in a blind-on-blind confrontation.
Berndtson soon followed when Helin’s ace-queen beat his pocket queens for a sour exit, and Aleksandrs Krumins, who started the final table with the most chips but had gotten short, was eliminated in sixth place soon thereafter, marking Ylämäki’s first knock-out of the final table. Spain’s Jordi Baixas also fell after a mistimed three-bet shove against the same Ylämäki not long after that.
Meanwhile, short-stack ninja Oscar Peleg suddenly found himself among the final four, but that is where his story ended as he could not win a flip against Ylämäki. The Finn scored his third elimination in a row and would add a fourth to that just one orbit later when he ousted Helin with the better hand blind-on-blind.
Heads-Up
It was looking like Ylämäki’s day when he started heads-up play with a three-to-one chip advantage. He even had Bielskis all in with top pair against ace-high on a flop mere moments after restarting the tournament, but Bielskis made runner-runner trips to secure his double-up and take a small lead.
Ylämäki then got lucky of his own when his flopped second pair won against the top pair of Bielskis to stay alive in an all-in situation, and was at risk a second time not much later but won two flips in quick succession to secure a huge chip lead.
Bielskis was granted one comeback by winning a flip of his own, but the back-and-forth heads-up battle finally ended when Ylämäki’s king-jack held against the king-nine of Bielskis, securing him the title, the trophy, and the €1,855 the players left in the middle after striking a deal.
That concludes the story of the record-breaking €555 Kings of Tallinn Championship, but be sure to check out the live reports of the other events in the Estonian capital as well, among which the flagship €1,100 Main Event.
Mikko Ylämäki Overcomes Huge Field to Become the €555 Kings of Tallinn Championship Champion (€58,835) Posted Wednesday 28th February, 2024 at 20:31(UTC+2) by Frank Visser
Andrius Bielskis looked down at on the button and limped in. Mikko Ylämäki then raised to 1,200,000 in the big blind with before Bielskis quickly jammed all in for 8,000,000.
Ylämäki spent some time in the tank before putting in the call to put Bielskis at risk.
Andrius Bielskis: Mikko Ylämäki:
Bielskis found a gutshot on the turn on , but neither that nor his nine came in on the river and he had to console himself with becoming the runner-up and cashing for the €49,875 he secured himself in the heads-up deal.
Player
Chips
Progress
Mikko Ylamaki
21,000,000
6,000,000
Andrius Bielskis
0
0
Ylämäki Wins Big Pot With Nines Posted Wednesday 28th February, 2024 at 20:18(UTC+2) by Frank Visser
Mikko Ylämäki limped in from the button with and Andrius Bielskis checked his option in the big blind with . Bielskis checked on the flop, after which Ylämäki made a bet of 400,000.
Bielskis raised to 1,200,000 with his top pair, but Ylämäki three-bet to 2,500,000. Bielskis put in the chips for a call and the turn was dealt.
Bielskis checked to Ylämäki, who opted for a bet of 1,500,000. Bielskis once again obliged with a call and the river rolled off.
Bielskis checked once again and Ylämäki thought for a while before checking behind. His pocket nines won at showdown, once again creating a large gap between the two players.
Player
Chips
Progress
Mikko Ylamaki
15,000,000
5,200,000
Andrius Bielskis
6,400,000
4,600,000
Bielskis Regains Lead as Heads Up Continues Posted Wednesday 28th February, 2024 at 20:12(UTC+2) by Frank Visser
Andrius Bielskis jammed his 5,400,000 chips in from the button and Mikko Ylämäki snap called from the big blind.
Andrius Bielskis: Mikko Ylämäki:
Another flip for the tournament win, but it was yet again the at-risk player who won when Bielskis fours held on the runout to secure him his double-up and even a small chip lead.
Player
Chips
Progress
Andrius Bielskis
11,000,000
7,000,000
Mikko Ylamaki
9,800,000
7,200,000
Bielskis Still In the Game Posted Wednesday 28th February, 2024 at 20:06(UTC+2) by Frank Visser
Andrius Bielskis limped in from the button and Mikko Ylämäki jammed all in for 8,500,000 from the big blind. Bielskis thought it over for a while before slamming in the call to put his opponent at risk once more.
Mikko Ylämäki: Andrius Bielskis:
Ylämäki remained ahead throughout the runout, securing his double-up and a massive chip lead as Bielskis was left with only nine big blinds.
Player
Chips
Progress
Mikko Ylamaki
17,000,000
7,900,000
Andrius Bielskis
3,600,000
8,400,000
Ylämäki Finds the Fold Posted Wednesday 28th February, 2024 at 19:57(UTC+2) by Frank Visser
Andrius Bielskis limped in with on the button and Mikko Ylämäki checked his in the big blind. Ylämäki then checked on the flop and called the subsequent 600,000 bet of Bielskis. The turn was checked through before the river completed the board.
Ylämäki checked his ace-high once more, but Bielskis made a bet of 2,000,000 with his turned full house. Ylämäki spent some time in the tank before finding a fold, saving him some chips.
Player
Chips
Progress
Andrius Bielskis
12,000,000
0
Mikko Ylamaki
9,100,000
200,000
Ylämäki Wins Flip to Stay Alive Posted Wednesday 28th February, 2024 at 19:52(UTC+2) by Frank Visser
Mikko Ylämäki limped in from the button before Andrius Bielskus jammed all in from the big blind. Ylämäki quickly called his 4,500,000 stack off, and the cards were tabled.
Mikko Ylämäki: Andrius Bielskis:
Ylämäki hit top pair on the flop, and did not look back on the runout. He secured a double-up and the stacks were once again close to even.
Player
Chips
Progress
Andrius Bielskis
12,000,000
5,000,000
Mikko Ylamaki
9,300,000
4,800,000
19:49 (UTC+2)
Start of Level 35 Blinds: 200,000/400,000 Ante: 400,000
Ylämäki Loses With Big Slick Posted Wednesday 28th February, 2024 at 19:48(UTC+2) by Frank Visser
Andrius Bielskis limped in with on the button and Mikko Ylämäki checked in the big blind. Ylämäki then check-called Bielskis' bet of 300,000 on the board before both players checked the turn.
The river was also knuckled down, and Bielskis' two pair took down the pot at showdown.
Player
Chips
Progress
Andrius Bielskis
13,000,000
1,000,000
Mikko Ylamaki
8,200,000
1,100,000
Bielskis Picks Bad Time to Bluff Posted Wednesday 28th February, 2024 at 19:30(UTC+2) by Frank Visser
Andrius Bielskis limped in with from the button and Mikko Ylämäki checked his in the big blind. Bielskis then made a bet of 300,000 on the flop after a check from Ylämäki.
Ylämäki made the call and the turn hit the felt. Ylämäki checked once more but Bielskis did not relent and put forth 900,000 chips. Ylämäki called again with his top pair, leading to the river completing the board.
Bielskis decided to give up his bluff as two quick checks followed each other, and Ylämäki took down the pot at showdown to even the stacks even more.
Player
Chips
Progress
Andrius Bielskis
12,000,000
1,000,000
Mikko Ylamaki
9,300,000
1,500,000
Ylämäki On the Rise Posted Wednesday 28th February, 2024 at 19:26(UTC+2) by Frank Visser
Mikko Ylämäki limped in from the button with and Andrius Bielskis checked his in the big blind.
The flop was checked through before Ylämäki made a bet of 400,000 on the turn. Bielskis check-called, and did so too when Ylämäki bet 500,000 on the river.
Ylämäki's second pair won him a sizable pot as the chip difference between the two players lessened.
Player
Chips
Progress
Andrius Bielskis
13,000,000
3,000,000
Mikko Ylamaki
7,800,000
3,100,000
Ylämäki Folds a Pair Posted Wednesday 28th February, 2024 at 19:20(UTC+2) by Frank Visser
Mikko Ylämäki raised to 600,000 on the button with and Andrius Bielskis defended his big blind with . The flop was checked by both players before Bielskis made a bet of 1,000,000 on the turn.
Ylämäki thought it over but ultimately folded his third pair, leaving him with just over 15 big blinds.
Player
Chips
Progress
Andrius Bielskis
16,000,000
1,000,000
Mikko Ylamaki
4,700,000
1,200,000
Ylämäki's Set Gains Little Posted Wednesday 28th February, 2024 at 19:17(UTC+2) by Frank Visser
Mikko Ylämäki shoved in his 3,000,000 chips from the button and Andrius Bielskis made the call in the big blind.
Mikko Ylämäki: Andrius Bielskis:
The flop paired up both players, but increased Bielskis' lead. It was looking like he might win the tournament in this hand, but the turn spelled disaster for him as Ylämäki upgraded to trips.
The river put some salt in Bielskis' wound as his two pair was not good enough to beat Ylämäki, who doubled up to just over 20 big blinds.
Player
Chips
Progress
Andrius Bielskis
15,000,000
2,000,000
Mikko Ylamaki
6,400,000
2,700,000
19:07 (UTC+2)
Start of Level 34 Blinds: 150,000/300,000 Ante: 300,000
Bielskis Extends Lead Posted Wednesday 28th February, 2024 at 19:05(UTC+2) by Frank Visser
Andrius Bielskis limped in with on the button and Mikko Ylämäki made it 800,000 to go on the button with .
The flop fell and Ylämäki made a bet of 700,000. Bielskis then jammed all in with his flush draw, forcing a quick fold from his opponent and widening the gap between the two remaining contestants.
Player
Chips
Progress
Andrius Bielskis
17,000,000
2,000,000
Mikko Ylamaki
3,700,000
2,500,000
Heads-Up Deal Posted Wednesday 28th February, 2024 at 18:58(UTC+2) by Frank Visser
Andrius Bielskis raised to 525,000 on the button which Mikko Ylämäki called in the big blind.
The flop was checked by Ylämäki, after which Bielskis put forth a bet of 400,000. Ylämäki then raised to 800,000 and Bielskis pushed all in for 5,000,000 chips.
Ylämäki made the call and both holdings were tabled for the cameras.
Andrius Bielskis: Mikko Ylämäki:
Ylämäki had a solid lead with his top pair, but it was obliterated by the turn. The river upgraded Bielskis to trips, and his chips were counted as he doubled up and grabbed the chip lead from his opponent.
Player
Chips
Progress
Andrius Bielskis
11,000,000
5,500,000
Mikko Ylamaki
9,800,000
6,200,000
Bielskis Makes a Move Posted Wednesday 28th February, 2024 at 18:45(UTC+2) by Frank Visser
Mikko Ylämäki raised to 500,000 on the button with and Andrius Bielskis called in the big blind with .
Bielskis then check-called Ylämäki's 450,000 bet on the flop before Ylämäki fired 500,000 more on the turn, after another check from Bielskis.
Bielskis then raised to 1,300,000 and Ylämäki stuck around with his middle pair as he tossed in a call.
The river gave Ylämäki two pair, but Bielskis quickly surrendered as he check-folded to a 2,000,000 bet from his opponent, surrendering the pot to Ylämäki.
Player
Chips
Progress
Mikko Ylamaki
16,000,000
2,000,000
Andrius Bielskis
5,500,000
1,900,000
Joonas Helin Eliminated in 3rd Place (€27,900) Posted Wednesday 28th February, 2024 at 18:37(UTC+2) by Frank Visser
Oscar Peleg jammed all in from the small blind for 1,900,000 chips, and he received an instant call from chipleader Mikko Ylämäki in the big blind.
Oscar Peleg: Mikko Ylämäki:
The flop and turn gave Peleg a plethora of outs, but he bricked them all on the river. Peleg gave some fist bumps before leaving the table to collect his fourth-place winnings.
Player
Chips
Progress
Mikko Ylamaki
11,000,000
1,500,000
Oscar Peleg
0
0
Bielskis Gets Paid Posted Wednesday 28th February, 2024 at 18:29(UTC+2) by Frank Visser
Joonas Helin limped in from the small blind with and Andrius Bielskis checked his in the big blind.
Both players flopped pairs on the flop, on which Helin bet 250,000 chips and Bielskis called. The turn then saw Helin slow down with a check, resulting in a 350,000 bet from Bielskis.
Helin called to see the river, on which he faced a 1,800,000 bet from his opponent. He immediately flicked in a calling chip to pay off the big bet, but saw his bottom two pair was no good against the trips of Bielskis.
Helin was left with about six big blinds, while Bielskis secured a second place on the leaderboard.
Player
Chips
Progress
Andrius Bielskis
7,500,000
3,400,000
Joonas Helin
1,600,000
2,600,000
Ylämäki Wins First Pot Post-Break Posted Wednesday 28th February, 2024 at 18:24(UTC+2) by Frank Visser
Mikko Ylämäki raised to 400,000 from the cutoff with and Andrius Bielskis made the call in the big blind with .
Bielskis then checked to Ylämäki on the flop, after which the latter bet 250,000. Bielskis then made it 650,000 to go and Ylämäki put in a call.
The turn was then checked by both players before Bielskis checked again on the river. Ylämäki, on the other hand, made a bet of 700,000 with his pair of queens, forcing Bielskis to fold his bottom pair and surrender the pot.
Player
Chips
Progress
Mikko Ylamaki
9,600,000
600,000
Andrius Bielskis
4,500,000
1,300,000
Jordi Baixas Eliminated in 5th Place (€15,200) Posted Wednesday 28th February, 2024 at 17:51(UTC+2) by Frank Visser
Mikko Ylämäki raised to 400,000 from the cutoff and Jordi Baixas jammed all in from the button for 1,400,000 chips. Ylämäki made the call and the cards went on their backs.
Jordi Baixas: Mikko Ylämäki:
The board helped neither player and Baixas thus doubled up with the better preflop hand.
Player
Chips
Progress
Mikko Ylamaki
5,800,000
1,000,000
Jordi Baixas
3,300,000
500,000
Ylämäki Claims Chip Lead Posted Wednesday 28th February, 2024 at 17:40(UTC+2) by Frank Visser
Andrius Bielskis pushed his large stack in from the button and was called by Mikko Ylämäki in the big blind, who was risking 3,400,000 chips by doing so.
Andrius Bielskis: Mikko Ylämäki:
The flop saw Bielskis flop a gutshot for some extra outs, but the turn and river remained clean for Ylämäki, who doubled up and took over the chip lead.
Player
Chips
Progress
Mikko Ylamaki
6,800,000
2,900,000
Andrius Bielskis
5,800,000
3,300,000
Peleg's Ace Remains In Play Posted Wednesday 28th February, 2024 at 17:29(UTC+2) by Frank Visser
Andrius Bielskis shipped it in from the small blind and Oscar Peleg made the call in the big blind to put his 1,200,000 chips at risk.
Oscar Peleg: Andrius Bielskis:
The board brought two pair with , resulting in Peleg's ace kicker taking down the pot and doubling him up.
Player
Chips
Progress
Andrius Bielskis
9,100,000
100,000
Oscar Peleg
2,600,000
1,200,000
17:26 (UTC+2)
Start of Level 32 Blinds: 100,000/200,000 Ante: 200,000
Aleksandrs Krumins Eliminated in 6th Place (€11,250) Posted Wednesday 28th February, 2024 at 17:25(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 5/700
Mikko Ylämäki raised to 300,000 on the button and called the subsequent all-in for 1,300,000 from former chipleader Aleksandrs Krumins in the small blind.
Aleksandrs Krumins: Mikko Ylämäki:
Ylämäki paired up on the flop to take a commanding lead, but the turn gave Krumins some hope. The river did not bring his straight, however, and he said his goodbyes before leaving the table in fifth place.
Player
Chips
Progress
Mikko Ylamaki
3,900,000
1,300,000
Aleksandrs Krumins
0
0
Peleg Gets It In Good Posted Wednesday 28th February, 2024 at 17:20(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 6/700
Joonas Helin raised to 300,000 from the cutoff before Oscar Peleg went all in for 550,000 in the small blind.
Helin put in the extra chips for a call and the cards were shown down.
Oscar Peleg: Joonas Helin:
Peleg flopped two pair on and had Helin drawing dead on the turn. The river was meaningless and Peleg stacked up his newly acquired chips to stay in contention.
Player
Chips
Progress
Joonas Helin
4,700,000
500,000
Oscar Peleg
1,400,000
200,000
Ylämäki's Queens Do the Trick Posted Wednesday 28th February, 2024 at 17:16(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 6/700
Mikko Ylämäki jammed all in for 1,100,000 chips in the hijack and Jordi Baixas made the call on the button with the covering stack.
Mikko Ylämäki: Jordi Baixas:
This time, the ladies faced no troubles on the runout and Ylämäki booked another double-up.
Player
Chips
Progress
Jordi Baixas
2,800,000
1,100,000
Mikko Ylamaki
2,600,000
1,100,000
Touko Berndtson Eliminated in 7th Place (€8,700) Posted Wednesday 28th February, 2024 at 17:12(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 6/700
Joonas Helin sat in middle position and raised to 300,000. Touko Berndtson then put in 2,400,000 chips from the button for an all-in and it folded back to Helin.
After asking for a count and tanking for a while, he slammed in the chips for a call to put his opponent at risk.
Touko Berndtson: Joonas Helin:
It was looking like Berntson was set for a double-up, but the flop saw Helin hit an ace to take a dominant lead. The turn left Berndtson with one out to hit, and it did not arrive on the river, resulting in his elimination in seventh place.
Player
Chips
Progress
Joonas Helin
5,200,000
1,900,000
Touko Berndtson
0
0
Baixas Wins Flip for Tournament Life Posted Wednesday 28th February, 2024 at 17:07(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 7/700
Jordi Baixas opened to 1,000,000 from middle position, his usual half-stack sizing, and the action folded to Andrius Bielskis in the cutoff, who put Baixas all in for 1,750,000.
Baixas made the call and was at risk against the chipleader as the cards went on their backs.
Jordi Baixas: Andrius Bielskis:
Baixas flopped some extra outs on the flop, but the turn took some away as it gave Bielskis a flush draw.
However, the river saw Baixas make second pair for the best hand and he raked in an important double-up as he shot up the ranks.
Player
Chips
Progress
Andrius Bielskis
9,000,000
1,000,000
Jordi Baixas
3,900,000
2,200,000
Video Highlights From Day 5 Posted Wednesday 28th February, 2024 at 16:50(UTC+2) by Jason Glatzer
Check out the video highlights below from Day 5 of the 2024 Kings of Tallinn powered by OlyBet at Olympic Park Casino and the Hilton Tallinn Park:
Matte Karjalainen Eliminated in 8th Place (€7,200) Posted Wednesday 28th February, 2024 at 16:50(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 7/700
Matte Karjalainen shipped his 1,100,000 stack in from the small blind and was quickly called by Andrius Bielskis in the big blind.
Matte Karjalainen: Andrius Bielskis:
Karjalainen took the lead on the flop, but it turned out to be a deception as the turn saw Bielskis hit a better pair.
The river did nothing for either player and Karjalainen took his exit in 8th place after a rollercoaster of a final table, while Bielskis extended his chip lead to an eight-figure stack.
Player
Chips
Progress
Andrius Bielskis
10,000,000
1,300,000
Matte Karjalainen
0
0
Ylämäki Doubles Right Back Posted Wednesday 28th February, 2024 at 16:46(UTC+2) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 8/700
Mikko Ylämäki pushed his final 550,000 chips in from the cutoff and was looked up by Aleksandrs Krumins on the button.
Mikko Ylämäki: Aleksandrs Krumins:
Ylämäki would not lose two flips in a row as the board saw his tens hold up for the win. He raked in a double-up of his own as the short stacks ended up very close in the counts.
Player
Chips
Progress
Aleksandrs Krumins
1,700,000
800,000
Mikko Ylamaki
1,500,000
950,000
16:42 (UTC+2)
Start of Level 31 Blinds: 75,000/150,000 Ante: 150,000
Baixas' Turn to Double Up Posted Wednesday 28th February, 2024 at 16:41(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Jordi Baixas raised to 500,000 as first to act and the action folded to Mikko Ylämäki in the small blind, who pushed all in for 1,200,000.
Baixas made the call with a smaller stack of 725,000 and the cards were turned over.
Jordi Baixas: Mikko Ylämäki:
The paired up Baixas to take the lead in the flop, while the turn upgraded him to trips. Ylämäki could not hit a full house on the river and Baixas doubled up, leaving Ylämäki as the shortest stack on the table.
Player
Chips
Progress
Jordi Baixas
1,700,000
975,000
Mikko Ylamaki
550,000
2,050,000
Berndtson Chips Up Posted Wednesday 28th February, 2024 at 16:37(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Alekandrs Krumins made a raise to 250,000 from early position with . Chipleader Andrius Bielskis thought for a while on the button before flicking in a call with , and big blind Touko Berndtson came along in the big blind as well, with .
The flop saw Berndtson check before Krumins continued for 175,000, which got Bielskis to fold quickly. Berndtson, however, shipped all of his 1,400,000 chips in the middle.
Krumins weighed his options for a bit before electing to make the correct fold, and Berndtson was awarded some much-valued chips.
Player
Chips
Progress
Andrius Bielskis
8,700,000
1,000,000
Touko Berndtson
2,500,000
290,000
Aleksandrs Krumins
2,500,000
700,000
Karjalainen Doubles Versus Baixas Posted Wednesday 28th February, 2024 at 16:30(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Jordi Baixas raised to 500,000 from the cutoff before Matte Karjalainen went all in for 575,000 in the small blind. The action folded back to Baixas, who put in the few extra chips for a call.
Matte Karjalainen: Jordi Baixas:
Karjalainen was the only one to pair his kicker on the board, resulting in his double-up and leaving Baixas with just a few big blinds.
Player
Chips
Progress
Matte Karjalainen
1,400,000
0
Jordi Baixas
725,000
575,000
Helin Gets to Squeeze Posted Wednesday 28th February, 2024 at 16:25(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Andrius Bielskis looked down at in early position and raised to 250,000. Aleksandrs Krumins made the call on the button with before Joonas Helin jammed all in for 2,600,000 from the big blind with .
Bielskis pondered his options for a while before letting his cards go, while Krumins was quicker with his decision and snap folded to forfeit the pot to Helin.
Player
Chips
Progress
Andrius Bielskis
7,700,000
200,000
Joonas Helin
3,300,000
600,000
Aleksandrs Krumins
3,200,000
200,000
Bielskis Puts New-Found Chips to Use Posted Wednesday 28th February, 2024 at 16:21(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Andrius Bielskis open-jammed his big stack from the cutoff with and Oscar Peleg was on the button with .
He thought about it for a bit before eventually folding, and the blinds quickly followed suit to add some more chips to Bielskis' stack.
Player
Chips
Progress
Andrius Bielskis
7,900,000
200,000
Oscar Peleg
1,200,000
300,000
Bielskis Grabs Chip Lead in Huge Cooler Posted Wednesday 28th February, 2024 at 16:13(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Aleksandrs Krumins made it 275,000 to go from the hijack with , after which the action folded to Andrius Bielskis in the big blind, who found .
Bielskis made it 900,000 to go and Krumins just made the call, whereafter the flop was dealt. Bielskis continued for 525,000 and once again Krumins just flatted.
The turn was checked by both players before Bielskis jammed all in for 2,300,000 on the river. Krumins asked for a count and sat in the tank for a bit before making the call.
Bielskis tabled his full house for the win, while Krumins' Big Slick disappeared into the muck. Bielskis doubled up to just under eight million chips and nabbed the chip lead by doing so.
Player
Chips
Progress
Andrius Bielskis
7,700,000
3,600,000
Aleksandrs Krumins
3,400,000
2,500,000
Baixas Tries to Steal Posted Wednesday 28th February, 2024 at 16:08(UTC+2) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 8/700
Jordi Baixas raised to 300,000 on the button with . Joonas Helin was in the small blind with and put Baixas all in for his stack of 1,600,000.
Baixas quickly mucked his cards and surrendered some of his precious chips to Helin.
Player
Chips
Progress
Joonas Helin
2,700,000
0
Jordi Baixas
1,300,000
300,000
16:00 (UTC+2)
Start of Level 30 Blinds: 50,000/125,000 Ante: 120,000
A Small Break Posted Wednesday 28th February, 2024 at 15:39(UTC+2) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 8/700
The eight remaining players have been sent on a 20-minute break after the first few hands of the final table.
Knut Trulsen Eliminated in 9th Place (€5,890) Posted Wednesday 28th February, 2024 at 15:29(UTC+2) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 8/700
Joonas Helin raised to 200,000 under the gun before the action folded to Knut Trulsen on the button. He went all in for 945,000 chips, which Helin covered as he made the call.
Knut Trulsen: Joonas Helin:
Helin's superior pocket pair faced no resistance on the runout and Trulsen was the first player eliminated from the final table.
Player
Chips
Progress
Joonas Helin
2,700,000
1,200,000
Knut Trulsen
0
0
Krumins Goes For It All Posted Wednesday 28th February, 2024 at 15:27(UTC+2) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 9/700
Mikko Ylämäki raised to 200,000 from the cutoff with and Aleksandrs Krumins made the call on the button with . Both of the blinds got out of the way and a flop of was spread.
Ylämäki checked to Kumins, who made a bet of 225,000 with his full house. Ylämäki called with his pair of sixes and did so too when Krumins sized up to 450,000 on the turn.
The river then completed the board and Krumins announced "all-in" after another check from Ylämäki. Ylämäki thought about it for a bit but ultimately folded, saving his 1,800,000 chips for another pot.
Player
Chips
Progress
Aleksandrs Krumins
7,000,000
1,100,000
Mikko Ylamaki
1,800,000
800,000
Aces for Krumins Posted Wednesday 28th February, 2024 at 15:25(UTC+2) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 9/700
Joonas Helin raised to 200,000 from early position with and Mikko Ylamaki came along from the button with .
Aleksandrs Krumins then put in a three-bet to 650,000 from the big blind with , which caused the other two players to fold their holdings.
Player
Chips
Progress
Aleksandrs Krumins
5,900,000
985,000
Mikko Ylamaki
2,600,000
45,000
Joonas Helin
1,500,000
200,000
Peleg Also Books Double-Up Posted Wednesday 28th February, 2024 at 15:21(UTC+2) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 9/700
Jordi Baixas raised to 200,000 from early position before Oscar Peleg shoved 610,000 chips in from the button. Baixas asked for a count before putting in the extra chips for a call.
Oscar Peleg: Jordi Baixas:
Peleg flopped top pair on , but it also saw Baixas flop an open-ended straight draw.
However, the runout bricked out for Baixas, seeing his opponent double up.
Player
Chips
Progress
Oscar Peleg
1,500,000
365,000
Jordi Baixas
1,000,000
640,000
Karjalianen Doubles Up First Hand Posted Wednesday 28th February, 2024 at 15:14(UTC+2) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 9/700
Matte Karjalainen jammed all in from the small blind for 645,000 and was called by Andrius Bielskis in the big blind.
Matte Karjalainen: Andrius Bielskis:
The board ran out and Karjalainen's better hand made a pair to secure the double-up.
Player
Chips
Progress
Andrius Bielskis
4,100,000
770,000
Matte Karjalainen
1,400,000
755,000
Final Table Underway Posted Wednesday 28th February, 2024 at 15:08(UTC+2) by Frank Visser
The nine remaining players have taken their seats and the cards are in the air.
Stay tuned for all the action of the final table of the €555 Kings of Tallinn Championship.
Final Table Seat Draw and Chip Counts Posted Wednesday 28th February, 2024 at 14:24(UTC+2) by Jason Glatzer
Seat
Player
Country
Chips
Big Blinds
1
Aleksandrs Krumins
Latvia
4,915,000
49
2
Jordi Baixas
Spain
1,640,000
16
3
Joonas Helin
Finland
1,700,000
17
4
Matte Karjalainen
Finland
645,000
6
5
Andrius Bielskis
Lithuania
4,870,000
49
6
Oscar Peleg
Sweden
1,135,000
11
7
Touko Berndtson
FInland
2,210,000
22
8
Mikko Ylämäki
Finland
2,645,000
26
9
Knut Trulsen
Norway
1,195,000
12
Player
Chips
Progress
Aleksandrs Krumins
4,915,000
15,000
Andrius Bielskis
4,870,000
430,000
Mikko Ylamaki
2,645,000
105,000
Touko Berndtson
2,210,000
90,000
Joonas Helin
1,700,000
600,000
Jordi Baixas
1,640,000
40,000
Knut Trulsen
1,195,000
310,000
Oscar Peleg
1,135,000
2,145,000
Matte Karjalainen
645,000
575,000
Konsta Heikkila Eliminated in 10th Place (€4,700) Posted Wednesday 28th February, 2024 at 14:17(UTC+2) by Jason Glatzer
Level 29: 50,000/100,000 (100,000) Entries: 9/700
Konsta Heikkila four-bet jammed around a dozen big blinds from middle position and was called by Aleksandrs Krumins.
Konsta Heikkila: Aleksandrs Krumins:
It was a bit of a cooler to run jacks into queens during five-handed play but poker can be cruel. Heikkila bubbled the final table while earning the 10th place prize of €4,700 after the board didn't save him.
We will post the final table seat draw in a few minutes. Players are on a short break before they will hit the lights and cameras for the live-streamed final table at OlyBet.tv. Our coverage will be on the same 30-minute delay as the stream but we will be with you until a winner is crowned.
Player
Chips
Progress
Aleksandrs Krumins
4,900,000
3,165,000
Konsta Heikkil?
0
0
Svetozar Marinov Eliminated in 11th Place (€4,700) Posted Wednesday 28th February, 2024 at 14:14(UTC+2) by Jason Glatzer
It was a heck of a run and almost a true comeback for Bulgaria's Svetozar Marinov. But sometimes good things come to an end.
Andrius Bielskis jammed from the small blind before Marinov called off his stack of around 10 big blinds from the big blind.
Svetozar Marinov: Andrius Bielskis:
Bielskis connected with his jack straight off the bat and never looked back to eliminate Marinov in 11th place for €4,700 after the ran out on the board.
There was another pot brewing at the same time at the other table. Spoiler alert! We reached a final table moments after this hand.
Player
Chips
Progress
Andrius Bielskis
4,900,000
2,300,000
Svetozar Marinov
0
0
Cinderella Story for Marinov? Posted Wednesday 28th February, 2024 at 14:04(UTC+2) by Jason Glatzer
Svetozar Marinov was down to just 40,000 in chips and now has a seven-figure stack. He doubled again, this time against Touko Berndtson when his king-four held against jack-trey.
Is this a Cinderella story in the making? Time will tell with the final table to begin quite soon with a few players short on chips.
Player
Chips
Progress
Touko Berndtson
2,300,000
760,000
Svetozar Marinov
1,000,000
720,000
14:00 (UTC+2)
Start of Level 29 Blinds: 50,000/100,000 Ante: 100,000
Baixas Leaves Marinov on Fumes Posted Wednesday 28th February, 2024 at 14:00(UTC+2) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 11/700
Andrius Bielskis min-raised from under the gun before Svetozar Marinov jammed for 750,000 from the button. Jordi Baixas (pictured below) called off his stack of 710,000 before Bielskis folded.
Jordi Baixas: Svetozar Marinov:
Baixas's jacks held and even improved to a full house on the board to leave Marinov with just 40,000 in the stack.
Marinov got his 40,000 in from the cutoff. Marinov raised to 200,000 from the button and the players in the blinds folded.
Svetozar Marinov: Jordi Baixas:
Marinov won the flop after Baixas failed to connect with the runout.
Player
Chips
Progress
Jordi Baixas
1,600,000
410,000
Svetozar Marinov
280,000
1,720,000
Action Slowed Down Posted Wednesday 28th February, 2024 at 13:46(UTC+2) by Jason Glatzer
Level 28: 40,000/80,000 (80,000) Entries: 11/700
There have been nearly no flops during Level 28 as players tighten up with the final table just two players.
13:18 (UTC+2)
Start of Level 28 Blinds: 40,000/80,000 Ante: 80,000
Jan-Mikael Kesanen Eliminated in 12th Place (€3,600) Posted Wednesday 28th February, 2024 at 13:18(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 11/700
Finland's Jan-Mikael Kesanen bet 360,000 from under the gun leaving just 5,000 in chips in his stack. He was called by Svetozar Marinov before the remaining 5,000 went in on the flop.
Jan-Mikael Kesanen: Svetozar Marinov:
Kesanen was understandably not thrilled about falling far behind in what was a flip situation and was eliminated in 12th place for €3,600 after the turn and river completed the board.
Player
Chips
Progress
Svetozar Marinov
2,000,000
260,000
Jan-Mikael Kesanen
0
0
Adrians Imsa Eliminated in 13th Place (€3,600) Posted Wednesday 28th February, 2024 at 12:57(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 12/700
Adrians Imsa was the first player to hit the rail on the final day. He jammed his short stack of approximately 10 big blinds from late position and was called by the red-hot Joonas Helin from the big blind.
Adrians Imsa: Joonas Helin:
The snowmen held on the runout to send Imsa to the rail in 13th place for €3,600. Meanwhile, Helin, who began the day as a short stack, now has one of the bigger stacks in the field.
Player
Chips
Progress
Joonas Helin
2,300,000
1,000,000
Adrians Imsa
0
0
Helin Doubles Through Bielskis Posted Wednesday 28th February, 2024 at 12:41(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 13/700
Andrius Bielskis min-raised from under the gun before Joonas Helin three-bet jammed for about 10 big blinds from the big blind. Bielskis snap-called and Helin wished his opponent good luck.
Joonas Helin: Andrius Bielskis:
It was Helin who had the good luck as he connected with his queen on the runout to double through Bielskis instead of hitting the rail.
Player
Chips
Progress
Andrius Bielskis
2,600,000
700,000
Joonas Helin
1,300,000
645,000
Cards in the AIr Posted Wednesday 28th February, 2024 at 12:29(UTC+2) by Jason Glatzer
Level 27: 30,000/60,000 (60,000) Entries: 13/700
Cards are in the air to start the final day of the €555 Championship. We will report the action in real-time until the live-streamed final table is reached.
12:26 (UTC+2)
Day 3 of Kings of Tallinn 2024 Started Level: 27 Blinds: 30,000/60,000 Ante: 60,000
Record-Breaking Field Sees 13 Return for Final Day of €555 Championship Posted Wednesday 28th February, 2024 at 11:35(UTC+2) by Frank Visser
Throughout four starting flights, and some additional entries on Day 2, a whopping 700 entries have been made in the Kings of Tallinn €555 Championship. This number absolutely shattered the previous record of 573 entries and created an eye-watering prize pool of €329,000.
The field was set to play down to a final table, but after an arduous battle on Day 2, 13 players were still standing as they bagged up for the finale. Lithuania's Andrius Bielskis leads them with 3,300,000 chips, although he is virtually tied with his nearest contender Oscar Peleg from Sweden, who will start today with 3,280,000 chips.
Both players will bring roughly 55 big blinds into Day 3, a big lead over Bulgaria's Svetozar Marinov, who sits in third with almost half of that with 1,740,000 chips. Meanwhile, Finnish players Joonas Helin and Jan-Mikael Kesänen find themselves at risk of missing the final table, sitting down with 655,000 and 665,000 chips respectively, just 11 big blinds.
Start of Day 3 Chip Counts
Rank
Player
Country
Chip Count
Big Blinds
1
Andrius Bielskis
Lithuania
3,300,000
55
2
Oscar Peleg
Sweden
3,280,000
55
3
Svetozar Marinov
Bulgaria
1,740,000
29
4
Aleksandrs Krumins
Latvia
1,735,000
29
5
Touko Berndtson
Finland
1,540,000
26
6
Knut Trulsen
Norway
1,505,000
25
7
Matte Karjalainen
Finalnd
1,220,000
20
8
Jordi Baixas
Spain
1,190,000
20
9
Mikko Ylämäki
Finland
935,000
16
10
Konsta Heikkilä
Finland
925,000
15
11
Adrians Imsa
Latvia
710,000
12
12
Jan-Mikael Kesänen
Finland
665,000
11
13
Joonas Helin
Finland
655,000
11
All returning players are guaranteed €3,600, but everyone will be hunting the €65,360 that comes with winning the tournament. When they return, they will start with blinds at 30,000/60,000 with a 60,000 big blind ante. Blind levels will be 40 minutes in length throughout the remainder of the tournament, and enough of them will be played for a champion to be crowned.
With the late finish of Day 2, Day 3 will start at 12:30 p.m. local time, with OlyBet.tv providing cards-up coverage from 1 p.m. onwards, on half an hour delay. The live reporting will commence at the same time to not spoil anything from the live stream, so check back in at that time to not miss any of the poker action from the Estonian capital.
Final Day Seating Assignments Posted Wednesday 28th February, 2024 at 02:59(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Jan-Mikael Kesänen
665,000
11
1
3
Adrians Imsa
710,000
12
1
4
Svetozar Marinov
1,740,000
29
1
5
Jordi Baixas
1,190,000
20
1
6
Joonas Helin
655,000
11
1
8
Andrius Bielskis
3,300,000
55
2
1
Konsta Heikkilä
925,000
15
2
2
Touko Berndtson
1,540,000
26
2
3
Knut Trulsen
1,505,000
25
2
4
Aleksandrs Krumins
1,735,000
29
2
5
Matte Karjalainen
1,220,000
20
2
6
Itai Peleg
3,280,000
55
2
8
Mikko Ylämäki
935,000
16
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.