0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0080 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/3/updates'
ORDER BY `views` DESC

0.0084 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/3/updates', 1, '2024-11-22')

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

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

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

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

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

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

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

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

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

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

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

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

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

0.0039 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.0296 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0066 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '224'
AND `published` = 1

0.0415 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0069 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '230'
AND `published` = 1

0.0292 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0064 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '231'
AND `published` = 1

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

0.0491 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` = '237'
AND `published` = 1

0.0288 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` = '240'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'
AND `name` = '3'

0.0074 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.0289 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.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` = '10741'
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` = '10740'
ORDER BY `chip_change` DESC, `busted` ASC

0.0107 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0110 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10719'
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` = '10714'
ORDER BY `chip_change` DESC, `busted` ASC

0.0107 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0294 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10708'
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` = '10706'
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` = '10705'
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` = '10702'
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` = '10700'
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` = '10699'
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` = '10695'
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` = '10693'
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` = '10690'
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` = '10688'
ORDER BY `chip_change` DESC, `busted` ASC

0.0272 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10684'
ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10681'
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` = '10678'
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` = '10676'
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` = '10674'
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` = '10670'
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` = '10666'
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` = '10663'
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` = '10662'
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` = '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.0276 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10650'
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` = '10646'
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` = '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.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` = '10638'
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` = '10630'
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` = '10628'
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` = '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.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` = '10622'
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` = '10618'
ORDER BY `chip_change` DESC, `busted` ASC

0.0279 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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.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` = '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.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` = '10597'
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` = '10592'
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` = '10590'
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` = '10589'
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` = '10584'
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` = '10581'
ORDER BY `chip_change` DESC, `busted` ASC

0.0278 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10573'
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` = '10571'
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` = '10575'
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` = '10567'
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` = '10566'
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` = '10564'
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` = '10561'
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` = '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.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` = '10546'
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` = '10542'
ORDER BY `chip_change` DESC, `busted` ASC

0.0277 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10540'
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` = '10536'
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` = '10531'
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` = '10530'
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` = '10525'
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` = '10522'
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` = '10519'
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` = '10517'
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` = '10507'
ORDER BY `chip_change` DESC, `busted` ASC

0.0391 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0064 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.0061 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.0061 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.0062 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.0064 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.0061 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.0064 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_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.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` = '10740'
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` = '10726'
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` = '10724'
ORDER BY `chip_change` DESC, `busted` ASC

0.0277 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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` = '10710'
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` = '10708'
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` = '10706'
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` = '10705'
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` = '10702'
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` = '10700'
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` = '10699'
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` = '10695'
ORDER BY `chip_change` DESC, `busted` ASC

0.0278 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0074 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10690'
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` = '10688'
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` = '10685'
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` = '10684'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10681'
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` = '10678'
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` = '10676'
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` = '10674'
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` = '10670'
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` = '10666'
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` = '10663'
ORDER BY `chip_change` DESC, `busted` ASC

0.0280 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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` = '10651'
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` = '10650'
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` = '10646'
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` = '10645'
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` = '10640'
ORDER BY `chip_change` DESC, `busted` ASC

0.0275 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10630'
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` = '10628'
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` = '10627'
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` = '10624'
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` = '10622'
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` = '10618'
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` = '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.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '10602'
ORDER BY `chip_change` DESC, `busted` ASC

0.0272 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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` = '10590'
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` = '10589'
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` = '10584'
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` = '10581'
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` = '10578'
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` = '10573'
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` = '10571'
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` = '10575'
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` = '10567'
ORDER BY `chip_change` DESC, `busted` ASC

0.0280 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10561'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10550'
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` = '10547'
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` = '10546'
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` = '10542'
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` = '10541'
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` = '10540'
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` = '10536'
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` = '10531'
ORDER BY `chip_change` DESC, `busted` ASC

0.0278 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '10525'
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` = '10522'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0063 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.0005 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(1)
  • 888poker UK Poker League(0)
  • APAT(2)
  • APPT(1)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(3)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(1)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(1)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(13)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(1)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(3)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

Kings of Tallinn 2024 Event #12: €555 Championship (English) Live Reporting - Day 3

Kings of Tallinn 2024 - Live Reporting

Event #12: €555 Championship (English) See other events

Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

---

Current Level 35 Current Day 3

---

Blinds 200,000/400,000 Ante 400000

Entries 700 Remaining 1

---

Prize Pool (EUR) €329,000 First Prize (EUR) €58,835

Chip Leaders Day 3

1

Mikko Ylamaki

21,000,000

Day 1A Day 1B Day 1C Day 1D Day 2 Day 3

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

21:57 (UTC+2)

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 Marinov and 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

Level 35: 200,000/400,000 (400,000)
Entries: 1/700

Mikko Ylämäki from Finland won the €555 Kings of Tallinn Championship after a long and swingy heads-up battle with Andrius Bielskis.

The victory saw him win €58,835 after a heads-up deal, and of course the glorious Kings of Tallinn trophy.

Stay tuned for a full recap of the finale.

Player		Chips	Progress
Mikko Ylamaki		21,000,000	6,000,000
Andrius Bielskis		0	0

Andrius Bielskis Eliminated in 2nd Place (€49,875) Posted Wednesday 28th February, 2024 at 20:26(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 1/700

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

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

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

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

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

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Andrius Bielskis jammed all in from the button for 1,800,000 and Mikko Ylämäki called in the big blind.

Andrius Bielskis:
Mikko Ylämäki:

Bielskis' queen-high remained the best hand on and he doubled up to a stack of ten big blinds.

Player		Chips	Progress
Mikko Ylamaki		17,000,000	0
Andrius Bielskis		4,000,000	400,000

Ylämäki Grabs Massive Chip Lead in Huge Flip Posted Wednesday 28th February, 2024 at 20:01(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

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

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

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

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

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

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Andrius Bielskis limped in from the button with before Mikko Ylämäki raised his big blind to 800,000 with and received a call from his opponent.

Ylämäki continued for 400,000 on the flop, which Bielskis raised to 1,200,000 with his flopped two pair.

Ylämäki put in the extra chips and both players checked on the subsequent turn. The river then completed the board , which was also checked down.

Bielskis' two pair won at showdown and Ylämäki was once again left with a stack of 15 big blinds.

Player		Chips	Progress
Andrius Bielskis		17,000,000	2,000,000
Mikko Ylamaki		4,500,000	1,700,000

Bielskis Widens Gap With "The Robbi" Posted Wednesday 28th February, 2024 at 19:44(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Andrius Bielskis raised to 650,000 on the button with and Mikko Ylämäki made the call with in the big blind.

Bielskis fired 400,000 chips on the flop and Ylämäki quickly check-folded to forfeit the pot.

Player		Chips	Progress
Andrius Bielskis		15,000,000	2,000,000
Mikko Ylamaki		6,200,000	2,000,000

Bielskis Hits Two Pair Posted Wednesday 28th February, 2024 at 19:40(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

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

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

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

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

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

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

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

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Mikko Ylämäki looked down at on the button and limped in, after which Andrius Bielskis checked the big blind with .

Bielskis quickly check-folded as Ylämäki flopped a set on the board, seeing a small pot go to Ylämäki.

Player		Chips	Progress
Andrius Bielskis		15,000,000	0
Mikko Ylamaki		5,900,000	500,000

Ylämäki Hits Trips for Survival Posted Wednesday 28th February, 2024 at 19:11(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

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

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

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

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikko Ylämäki and Andrius Bielskis have agreed to a deal, with Ylämäki taking home €56,980 and Bielskis being awarded €49,875.

The players are still playing for the trophy and €1,855 which will be awarded to the eventual champion.

Bielskis Five-Bet Jams Posted Wednesday 28th February, 2024 at 18:54(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikko Ylämäki raised to 500,000 on the button with and Andrius Bielskis three-bet to 1,500,000 with in the big blind.

Ylämäki furthered the raising war with a four-bet to 3,600,000, after which Bielskis shoved all in to put Ylämäki at risk for 9,800,000 chips.

Ylämäki, however, decided to fold and save his remaining chips for another time.

Player		Chips	Progress
Andrius Bielskis		15,000,000	4,000,000
Mikko Ylamaki		6,200,000	3,600,000

Bielskis Takes the Lead With Lucky Double-Up Posted Wednesday 28th February, 2024 at 18:49(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

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

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

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

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikka Ylämäki pushed all in from the small blind and Joonas Helin made the call in the big blind to put his 2,000,000 chips at risk.

Joonas Helin:
Mikka Ylämäki:

Neither player upgraded their hand on the runout, and Ylämäki's queen-high secured him a spot in the heads-up, sending Helin home in third place.

Player		Chips	Progress
Mikko Ylamaki		14,000,000	3,000,000
Andrius Bielskis		7,400,000	100,000
Joonas Helin		0	0

Oscar Peleg Eliminated in 4th Place (€20,100) Posted Wednesday 28th February, 2024 at 18:32(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 3/700

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

Level 33: 125,000/250,000 (250,000)
Entries: 4/700

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

Level 33: 125,000/250,000 (250,000)
Entries: 4/700

Mikko Ylämäki raised to 800,000 from the small blind with and Joonas Helin called from the big blind with . 

Ylämäki then continued for 500,000 on the flop and received a quick fold from his opponent, awarding him the pot

Player		Chips	Progress
Mikko Ylamaki		9,500,000	300,000
Joonas Helin		4,200,000	1,100,000

18:21 (UTC+2)

Start of Level 33
Blinds: 125,000/250,000     Ante: 250,000

Another Break Posted Wednesday 28th February, 2024 at 18:02(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 4/700

Four players remain, and they have been sent on a 20-minute break before play resumes.

Player		Chips	Progress
Mikko Ylamaki		9,200,000	400,000
Joonas Helin		5,300,000	600,000
Andrius Bielskis		4,100,000	400,000
Oscar Peleg		2,400,000	200,000

Bielskis Attempts Check-Raise Posted Wednesday 28th February, 2024 at 17:57(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 4/700

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

Level 32: 100,000/200,000 (200,000)
Entries: 4/700

Mikko Ylämäki jammed all in from the small blind and Jordi Baixas called in the big blind, being at risk with 3,100,000 chips.

Jordi Baixas:
Mikko Ylämäki:

This time, the cards were reversed, but the winning hand would remain the same as the board saw Ylämäki make trips to lock the pot up on the turn.

Baixas was sent home in 5th place and headed to the payout desk as play continued four-handed.

Player		Chips	Progress
Mikko Ylamaki		9,000,000	3,200,000
Jordi Baixas		0	0

Meet Queens of Tallinn Host & FLIP Founder Daiva "Baltic Blonde" Byrne Posted Wednesday 28th February, 2024 at 17:49(UTC+2) by Jason Glatzer

Ylämäki Loses Chip Lead, Doubles Up Baixas Posted Wednesday 28th February, 2024 at 17:45(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 5/700

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

Level 32: 100,000/200,000 (200,000)
Entries: 5/700

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

Level 32: 100,000/200,000 (200,000)
Entries: 5/700

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

Level 29: 50,000/100,000 (100,000)
Entries: 10/700

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

Level 29: 50,000/100,000 (100,000)
Entries: 11/700

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

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter