0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0074 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-04'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/91/256/updates'
ORDER BY `views` DESC
0.0006 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '91'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
0.0278 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` = '241'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
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` = '250'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1
0.0275 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '256'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '256'
ORDER BY `busted` ASC, `current_chips` DESC
0.0068 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` = '256'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11636'
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` = '11635'
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` = '11626'
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` = '11623'
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` = '11621'
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` = '11620'
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` = '11619'
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` = '11615'
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` = '11613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11612'
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` = '11608'
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` = '11602'
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` = '11589'
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` = '11600'
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` = '11598'
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` = '11591'
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` = '11573'
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` = '11570'
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` = '11564'
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` = '11584'
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` = '11583'
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` = '11582'
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` = '11580'
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` = '11596'
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` = '11579'
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` = '11578'
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` = '11572'
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` = '11571'
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` = '11575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11569'
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` = '11551'
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` = '11547'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11549'
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` = '11545'
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` = '11541'
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` = '11520'
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` = '11540'
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` = '11518'
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` = '11528'
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` = '11524'
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` = '11522'
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` = '11508'
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` = '11517'
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` = '11503'
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` = '11514'
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` = '11498'
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` = '11511'
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` = '11493'
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` = '11490'
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` = '11488'
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` = '11483'
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` = '11473'
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` = '11471'
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` = '11464'
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` = '11455'
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` = '11447'
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` = '11439'
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` = '11436'
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` = '11435'
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` = '11420'
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` = '11407'
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` = '11404'
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` = '11398'
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` = '11397'
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` = '11385'
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` = '11384'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11378'
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` = '11370'
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` = '11366'
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` = '11355'
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` = '11352'
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` = '11349'
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` = '11344'
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` = '11340'
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` = '11331'
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` = '11327'
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` = '11323'
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` = '11317'
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` = '11313'
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` = '11297'
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` = '11288'
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` = '11283'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11274'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11267'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11257'
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` = '11256'
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` = '11247'
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` = '11240'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11236'
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` = '11232'
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` = '11230'
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` = '11227'
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` = '11226'
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` = '11225'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11216'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '241'
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` = '245'
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` = '251'
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` = '256'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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` = '256'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11636'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11626'
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` = '11623'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11621'
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` = '11620'
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` = '11619'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11615'
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` = '11613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11612'
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` = '11608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11589'
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` = '11600'
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` = '11598'
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` = '11591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11570'
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` = '11564'
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` = '11584'
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` = '11583'
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` = '11582'
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` = '11580'
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` = '11596'
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` = '11579'
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` = '11578'
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` = '11572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11571'
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` = '11575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11569'
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` = '11551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11547'
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` = '11530'
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` = '11549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11541'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11540'
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` = '11518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11528'
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` = '11524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11522'
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` = '11508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11503'
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` = '11514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11498'
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` = '11511'
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` = '11493'
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` = '11490'
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` = '11488'
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` = '11483'
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` = '11473'
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` = '11471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11464'
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` = '11455'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11447'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11439'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11436'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11435'
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` = '11420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11398'
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` = '11397'
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` = '11385'
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` = '11384'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11378'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11370'
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` = '11366'
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` = '11355'
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` = '11352'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11349'
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` = '11344'
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` = '11340'
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` = '11331'
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` = '11327'
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` = '11323'
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` = '11317'
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` = '11313'
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` = '11297'
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` = '11288'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11283'
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` = '11274'
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` = '11267'
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` = '11257'
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` = '11256'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11247'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11240'
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` = '11236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11232'
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` = '11230'
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` = '11227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11226'
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` = '11225'
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` = '11216'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '256'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '263'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Kings of Tallinn 2024
Event #29: €1,100 Main Event (English)
Live Reporting - Day 4
Day 3 of Kings of Tallinn 2024 Ended Level: 26 Blinds: 20,000/50,000 Ante: 50,000
Edgaras Kausinis Leads 11 Survivors After Penultimate Day of Main Event Posted Sunday 3rd March, 2024 at 00:26(UTC+0) by Frank Visser
Today at noon, 118 players returned for Day 3 of the €1,100 Kings of Tallinn Main Event. After 13 hours of intense poker, only 11 still had chips to bag up for the final day. Putting the most chips into his bag was Lithuania's Edgaras Kausinis, ending up with 4,600,000 of them, good for 77 big blinds at the start of Day 4. Kausinis has not played much live poker, but recently won the €1,100 High Roller at Ace Breaker Vilnius as his breakout performance, and is looking to add a second trophy at the Main Event in Tallinn.
In hot pursuit of Kausinis is Aleksi Naski, who bagged 4,230,000 chips. The Finn has known countless deep runs at Olympic Park Casino since 2019 and is looking to achieve an incredible feat as making the final table would mean he did so back-to-back, having finished in sixth place at the Kings of Tallinn Main Event last year. Swedish veteran Greger Aktell, whose first recorded cash stems from 2005, rounds at the top three stacks with 3,725,000 chips.
Other players who made it through to the final day include ex-Olympic Poker Manager and last Estonian standing Herli Olop (2,120,000), British high roller Paul Newey (1,565,000), and winner of last year's Kings of Tallinn €550 Championship Benjamin Gros (1,365,000).
End of Day 3 Chip Counts
Rank
Player
Country
Chip Count
Day 4 Big Blinds
1
Edgaras Kausinis
Lithuania
4,600,000
77
2
Aleksi Naski
Finland
4,230,000
71
3
Greger Aktell
Sweden
3,725,000
62
4
Even Rislov
Norway
2,995,000
50
5
Wissam Polus
Sweden
2,340,000
39
6
Herli Olop
Estonia
2,120,000
35
7
Mantas Tamulevicius
Lithuania
1,895,000
32
8
Paul Newey
United Kingdom
1,565,000
26
9
Benjamin Gros
France
1,365,000
23
10
Mindaugas Jonaitis
Lithuania
1,325,000
22
11
Frederik Brink
Denmark
1,240,000
21
However, before the end of the day was reached, 107 players had to say their goodbyes. As the field had reached the money the day before, there was no shortage of all-ins, and Jari Mahonen, Jon Martinez, Thomas Haverstad, Ilari Sahamies, Max Sanders, and Andrius Bielskis were all eliminated before dinner time had even arrived. Meanwhile, players such as Sebastian Wahl and Roope Tarmi did not make it to the three-table redraw, while Kaido Mikk was the final casualty of the day in 12th place.
The 11 remaining players have all locked up at least €10,500 of the €859,160 prize pool, but all eyes will be on the gargantuan €151,860 first-place prize. Play will resume tomorrow at noon local time, with the cards-up stream on OlyBet.tv and the live report being on a 30-minute security delay. Blinds will restart at Level 27: 30,000/60,000 with a 60,000 big blind ante and all levels will last for 60 minutes.
Check back in then to find who takes home the Kings of Tallinn Main Event trophy as the premier Baltic poker festival concludes.
Final Day 3 Chip Counts and Final Day Seat Draw Posted Saturday 2nd March, 2024 at 23:38(UTC+0) by Jason Glatzer
Table
Seat
Player
Country
Chips
Big Blinds
1
1
Mindaugas Jonaitis
Lithuania
1,325,000
22
1
5
Aleksi Naski
Finland
4,230,000
71
1
6
Mantas Tamulevicius
Lithuania
1,895,000
32
1
7
Even Rislov
Norway
2,995,000
50
1
8
Greger Aktell
Sweden
3,725,000
62
2
1
Edgaras Kausinis
Lithuania
4,600,000
77
2
1
Frederik Brink
Denmark
1,240,000
21
2
2
Paul Newey
United Kingdom
1,565,000
26
2
3
Wissam Polus
Sweden
2,340,000
39
2
6
Herli Olop
Estonia
2,120,000
35
2
7
Benjamin Gros
France
1,365,000
23
Player
Chips
Progress
Edgaras Kausinis
4,600,000
400,000
Aleksi Naski
4,230,000
130,000
Greger Aktell
3,725,000
25,000
Even Rislov
2,995,000
305,000
Wissam Polus
2,340,000
140,000
Herli Olop
2,120,000
100,000
Mantas Tamulevicius
1,895,000
5,000
Paul Newey
1,565,000
735,000
Benjamin Gros
1,365,000
1,335,000
Mindaugas Jonaitis
1,325,000
25,000
Frederik Brink
1,240,000
815,000
Bag and Tag Posted Saturday 2nd March, 2024 at 23:29(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
The tournament direction has announced that Day 3 has reached its end with 11 players remaining in the Main Event.
They will return tomorrow at noon local time to decide who will become the 2024 Kings of Tallinn champion.
Stay tuned for the chip counts and a recap of Day 3.
Naski Ships Another One Posted Saturday 2nd March, 2024 at 23:26(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
Aleksi Naski raised to 150,000 in the small blind with and Mantas Tamulevicius called with in the big blind. Naski then continued for 120,000 on the flop and Tamulevicius stuck around with his pocket pair.
The subsequent turn was checked through, and so was the river. Naski's pair of queens won at showdown and he crossed the four-million mark as a result.
Player
Chips
Progress
Aleksi Naski
4,100,000
300,000
Mantas Tamulevicius
1,900,000
300,000
Jonaitis Plays It Tricky Posted Saturday 2nd March, 2024 at 23:23(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
Greger Aktell made it 110,000 to go on the button and Mindaugas Jonaitis flat-called in the small blind. Aleksi Naski defended the big blind and a flop of fanned out.
The action checked to Aktell, who continued for 110,000. Jonaitis then shipped in his stack of 470,000 and Naski got out of the way before Aktell made the call.
Mindaugas Jonaitis: Greger Aktell:
Aktell needed to hit runner-runner outs agains Jonaitis' kings, but he was drawing dead on the turn instead. The river gave him a meaningless pair as Jonaitis booked a crucial double-up.
Player
Chips
Progress
Aleksi Naski
3,800,000
100,000
Greger Aktell
3,700,000
600,000
Mindaugas Jonaitis
1,300,000
320,000
Naski's Big Slick gets Value Posted Saturday 2nd March, 2024 at 23:18(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
Aleksi Naski raised to 100,000 as first to act with and Mantas Tamulevicius made the call in the cutoff with . Greger Aktell also called in the small blind with and the subsequent flop was checked through.
Naski then made a bet of 200,000 on the turn. Tamulevicius stuck around with a call before Aktell mucked his hand.
Naski sized up to 550,000 on the turn and a quick fold followed from Tamulevicius, seeing another pot go to the Finn.
Player
Chips
Progress
Greger Aktell
4,300,000
100,000
Aleksi Naski
3,900,000
600,000
Mantas Tamulevicius
2,200,000
600,000
Naski Outkicks Rislov Posted Saturday 2nd March, 2024 at 23:09(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
Even Rislov raised to 100,000 with from the cutoff and Aleksi Naski defended in the big blind.
The flop and turn were checked by both players before the river brought them both a pair.
Naski checked to Rislov, who bet 105,000. Naski snap-called and was awarded the pot with his better kicker.
Player
Chips
Progress
Aleksi Naski
3,300,000
500,000
Even Rislov
3,300,000
0
Rislov's Float Works Out Posted Saturday 2nd March, 2024 at 23:04(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
Mantas Tamulevicius raised to 110,000 with on the button and Even Rislov called in the small blind with . Greger Aktell defended his big blind with and a flop of was dealt.
The action checked to Tamulevicius, who continued for 125,000. Rislov stuck around with a call before Aktell got out of the way. The turn hit the felt and both players opted to check, leading to the river emerging from the deck.
Rislov fired 325,000 with his top pair and a quick fold followed from Tamulevicius.
Player
Chips
Progress
Even Rislov
3,300,000
300,000
Mantas Tamulevicius
2,800,000
500,000
Mikk Misses Out on Day 4 Posted Saturday 2nd March, 2024 at 22:56(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 11/914
Greger Aktell raised to 100,000 from the hijack and Kaido Mikk piled in his last 455,000 chips from the button. The action folded back to Aktell, who weighed his options before putting in the call.
Kaido Mikk: Greger Aktell:
The flop remained safe for Mikk's superior ace, but Aktell paired his seven on the turn. The river could not save Mikk and he departed from the Main Event in 12th place.
Player
Chips
Progress
Greger Aktell
4,400,000
900,000
Kaido Mikk
0
0
Naski Four-Bets Rislov Posted Saturday 2nd March, 2024 at 22:50(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 12/914
Aleksi Naski looked down at under the gun and raised to 100,000. Even Rislov then made it 285,000 to go in the cutoff with and the action folded back to Naski, who clicked it back to 595,000.
Rislov mulled it over for a bit but eventually laid his hand down as the pot was awarded to Naski uncontested.
Player
Chips
Progress
Even Rislov
3,000,000
600,000
Aleksi Naski
2,800,000
400,000
Aktell Loses Some to Tamulevicius Posted Saturday 2nd March, 2024 at 22:42(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 12/914
Greger Aktell raised to 100,000 with in the hijack and Mantas Tamulevicius called his in the big blind. Tamulevicius then check-called Aktell's bet of 150,000 on the flop before the turn was checked by both.
Tamulevicius bet out for 125,000 chips on the river and took down the pot as Aktell did not make any moves with his suited connector.
Player
Chips
Progress
Greger Aktell
3,500,000
100,000
Mantas Tamulevicius
3,300,000
200,000
Newey Doubles Through Brink Posted Saturday 2nd March, 2024 at 22:38(UTC+0) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 12/914
Frederik Brink (pictured below) min-raised the button before Paul Newey jammed for 1,070,000. Brink found the call but it took some time for the cards to be turned over as there was a hand at the feature table that took a couple of minutes with the action now hand-for-hand on the soft bubble. The cards were eventually turned over after the hand ended at the feature table.
Paul Newey: Frederik Brink:
A crowd gathered, and they were mostly cheering for the poker legend Newey. There was little drama after Newey hit a set on the flop and he had Brink drawing dead on the turn. The river completed the action for Newey to officially double through Brink.
Player
Chips
Progress
Paul Newey
2,300,000
700,000
Frederik Brink
425,000
180,000
Rislov Flops Big in Three-Way Three-Bet Pot Posted Saturday 2nd March, 2024 at 22:37(UTC+0) by Frank Visser
Level 26: 25,000/50,000 (50,000) Entries: 12/914
Even Rislov raised to 125,000 from the hijack with and Mindaugas Jonaitis called on the button. Aleksi Naski tanked for a while in the big blind with before putting in a three-bet to 385,000.
Rislov put in the call and Jonaitis came along with his sixes as well. The flop came down and Naski made a bet of 125,000. Rislov just called and Jonaitis paid to see a turn as well.
The then hit the felt and Naski slowed down with a check. Brislov reached for 450,000 chips and pushed them in the middle, forcing Jonaitis out of the pot. After a few minutes, Naski followed suit, and the big pot was shipped to Rislov.
Player
Chips
Progress
Even Rislov
3,400,000
1,000,000
Aleksi Naski
2,400,000
300,000
Mindaugas Jonaitis
980,000
620,000
22:26 (UTC+0)
Start of Level 26 Blinds: 20,000/50,000 Ante: 50,000
Updated Feature Table Counts Posted Saturday 2nd March, 2024 at 22:14(UTC+0) by Frank Visser
Level 25: 20,000/40,000 (40,000) Entries: 12/914
Player
Chips
Progress
Greger Aktell
3,600,000
700,000
Mantas Tamulevicius
3,100,000
400,000
Aleksi Naski
2,700,000
800,000
Even Rislov
2,400,000
1,360,000
Mindaugas Jonaitis
1,600,000
1,020,000
Kaido Mikk
705,000
560,000
Kausinis Continues to Roll on Side Table Posted Saturday 2nd March, 2024 at 22:12(UTC+0) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 12/914
Herli Olop opened for 80,000 from early position. Luca Beretta three-bet to 140,000 with just 10,000 back from one seat over. Edgaras Kausinis jammed for more than 4 million. Olop folded and Beretta called off his crumbs.
Luca Beretta: Edgaras Kausinis:
Beretta lost the flip after the ran out on the board to hit the rail, while Kausinis extended his chip lead.
Player
Chips
Progress
Edgaras Kausinis
4,900,000
3,560,000
Luca Beretta
0
0
Newey Doubles Through Beretta Posted Saturday 2nd March, 2024 at 22:10(UTC+0) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 13/914
Luca Beretta opened for a min-raise from the hijack. Paul Newey shoved for 610,000. Beretta, who barely had Newey covered, called.
Paul Newey: Luca Beretta:
Newey won the flip to leave his opponent short on chips after Beretta bricked the board.
Player
Chips
Progress
Paul Newey
1,320,000
540,000
Luca Beretta
125,000
890,000
Olop Busts Ostrowski Posted Saturday 2nd March, 2024 at 22:03(UTC+0) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 13/914
Herli Olop opened before he called a three-bet jam by Dominik Ostrowski for six big blinds.
Dominik Ostrowski: Herli Olop:
Olop won the flip with a full house to eliminate Ostrowski after the ran out on the board.
Player
Chips
Progress
Herli Olop
2,300,000
220,000
Dominik Ostrowski
0
0
Kausinis Busts Aglinskas Posted Saturday 2nd March, 2024 at 21:55(UTC+0) by Frank Visser
Level 25: 20,000/40,000 (40,000) Entries: 14/914
More Lithuanian vs. Lithuanian crime took place. This time, it resulted in Rolandas Aglinskas hitting the rail.
Paul Newey opened for 80,000 from the hijack. Aglinskas called before Edgaras Kausinis three-bet shoved for 2,700,000.
"Call," said Aglinskas out of turn.
The floor was called and it was ruled that Aglinskas call stood as long as Newey didn't change the action.
Eventually, Newey folded and Aglinskas's call was reconfirmed.
Rolandas Aglinskas: Edgaras Kausinis:
The Lithuanian rail was asking for an ace but they got much better with Kausinis nailing a full house on the flop. Aglinskas was drawing dead on the turn and was officially eliminated in 15th place after the river completed the board.
Player
Chips
Progress
Edgaras Kausinis
3,700,000
1,000,000
Rolandas Aglinskas
0
0
Top Pair Good for Kausinis Posted Saturday 2nd March, 2024 at 21:48(UTC+0) by Frank Visser
Level 25: 20,000/40,000 (40,000) Entries: 15/914
2024 Vilnius Ace Breaker High Roller champion Edgaras Kausinis just won a big hand against Estonian hero Herli "Killing Cap" Olop.
It was a blind vs. blind battle with Kausinis betting 100,000 on the flop. Olop jacked it up to 375,000 and Kausinis called.
Kausinis check-called a bet by Olop for 325,000 on the turn before both players checked the river.
Kausinis turned over and his top pair with the worst kicker did the job with Olop tossing his hand into the muck.
Player
Chips
Progress
Edgaras Kausinis
2,700,000
1,360,000
Herli Olop
2,000,000
80,000
Newey on Fire; Ousts Zarovs Posted Saturday 2nd March, 2024 at 21:36(UTC+0) by Frank Visser
Level 25: 20,000/40,000 (40,000) Entries: 15/914
Paul Newey opened for a min-raise with ace-king before he called a three-bet jam for about 5 big blinds by Nikita Zarovs with king-queen suited.
Newey had Zarovs dominated. Both players nailed their king but Zarovs hit the rail thanks to unresolved kicker issues.
Player
Chips
Progress
Paul Newey
1,600,000
400,000
Nikita Zarovs
0
0
Rockets for Newey Posted Saturday 2nd March, 2024 at 21:30(UTC+0) by Frank Visser
Level 25: 20,000/40,000 (40,000) Entries: 16/914
Dominik Ostrowski opened for a min-raise from early position before he called a three-bet jam by Paul Newey from the cutoff.
Paul Newey: Dominik Ostrowski:
Newey's aces not only held but he improved to the nut flush to double through Ostrowski after the ran out on the board.
Player
Chips
Progress
Paul Newey
1,200,000
420,000
Dominik Ostrowski
550,000
950,000
21:26 (UTC+0)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Gros Ousts Tammel Posted Saturday 2nd March, 2024 at 21:10(UTC+0) by Frank Visser
Level 25: 20,000/40,000 (40,000) Entries: 16/914
Tarmo Tammel added another cash to his record cashes at Olympic Park Casino in international events. Unfortunately, his time has come to an end.
Tammel three-bet shoved for about 13 big blinds and was called by Benjamin Gros.
Tarmo Tammel: Benjamin Gros:
Gros took out Tammel with two pair after the ran out on the board.
Player
Chips
Progress
Benjamin Gros
2,700,000
100,000
Tarmo Tammel
0
0
An Evening Break Posted Saturday 2nd March, 2024 at 21:00(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (40,000) Entries: 17/914
Only 17 player remain in the Main Event and they have been sent on a 20-minute break.
Mockevicius Mocked on Way Out Posted Saturday 2nd March, 2024 at 20:49(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (40,000) Entries: 17/914
Martynas Mockevicius three-bet jammed for 15 big blinds from the blinds and was called by Rolandas Aglinskas.
Martynas Mockevicius: Rolandas Aglinskas:
There was no camaraderie between the two Lithuanians as Aglinskas did a loud celebration along with a small stroll around the rail after he hit a flush on the runout to oust his countrymate Mockevicius.
Player
Chips
Progress
Patrikas Aglinskas
1,227,000
800,000
Martynas Mockevicius
0
0
Omland Omitted From Main Event Posted Saturday 2nd March, 2024 at 20:45(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (40,000) Entries: 18/914
2024 Kings of Talllinn €350 Cup champion Sven Omland just ended another impressive run, this time in the Main Event.
He got short trying to make a move against Mantas Tamaulevicius before getting his crumbs in a few hands later against the same player.
Sven Omland: Mantas Tamulevicius:
Omland had some hope after the turn on the board but at the end didn't get the river he needed to start a Cinderella story to end his run in 20th place.
Player
Chips
Progress
Mantas Tamulevicius
2,700,000
1,700,000
Sven Omland
0
0
Blind-On-Blind Violence Leaves Smirnov Without Chips Posted Saturday 2nd March, 2024 at 20:40(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (40,000) Entries: 19/914
Aleksei Smirnov raised to 100,000 chips from the small blind and Greger Aktell three-bet to 300,000 from the big blind. Smirnov then four-bet jammed to put his 1,300,000 chips at risk and Aktell flicked in an instant call.
Aleksei Smirnov: Greger Aktell:
Smirnov paired up the wrong card on the runout and was sent to the exit in 20th place.
Player
Chips
Progress
Greger Aktell
2,900,000
1,700,000
Aleksei Smirnov
0
0
Hagberg Falls to Naski Posted Saturday 2nd March, 2024 at 20:35(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (30,000) Entries: 20/914
Benny Hagberg raised to 60,000 in the cutoff with and Aleksi Naski made the call on the button with . Aleksei Smirnov also came along in the big blind with and a flop of was dealt.
Smirnov checked to Hagberg, who continued for 75,000 chips. Naski made the call before Smirnov got out of the way. The turn saw Hagberg check to Naski, who fired 155,000 with his newly acquired two pair.
Hagberg made the call and the river completed the board. Hagberg checked once more and Naski put his opponent all in for his final 240,000 chips.
Hagberg thought it over for a bit but ended up flicking in a calling chips, and his top pair was no good against the two pair of Naski. He exited in 21st place while Naski chipped up further.
Player
Chips
Progress
Aleksi Naski
3,500,000
200,000
Aleksei Smirnov
1,300,000
200,000
Benny Hagberg
0
0
Big Double for Tamulevicius Posted Saturday 2nd March, 2024 at 20:28(UTC+0) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 21/914
There wasn't too much in the pot when Sven Omland bet 100,000 on the flop. Mantas Tamulevicius raised to 250,000. Omland jammed the more than 1.1 million his opponent had in his stack and Tamulevicius called.
Mantas Tamulevicius: Sven Omland:
It was bad timing for Omland to make a move and he was drawing dead after pairing up on the turn. He began to count his chips after the river completed the board.
Player
Chips
Progress
Mantas Tamulevicius
2,600,000
1,600,000
Sven Omland
125,000
840,000
Beretta Doubles With Sixes Posted Saturday 2nd March, 2024 at 20:20(UTC+0) by Jason Glatzer
Level 24: 15,000/30,000 (30,000) Entries: 21/914
Luca Beretta three-bet jammed for 490,000 from the big blind and was called by Dominik Ostrowski from the small blind.
Luca Beretta: Dominik Ostrowski:
Beretta doubled his stack through Ostrowski after his sixes held on the board.
Player
Chips
Progress
Dominik Ostrowski
1,500,000
500,000
Luca Beretta
1,015,000
805,000
Big Slick for Gros to Oust Skucas Posted Saturday 2nd March, 2024 at 20:10(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 21/914
Benjamin Gros (pictured below) opened from under the gun before he called a three-bet shove by the short-stacked Audrius Skucas.
Audrius Skucas: Benjamin Gros:
The board didn't help Skucas get ahead of Gros and he was eliminated in 22nd place.
Player
Chips
Progress
Benjamin Gros
2,800,000
360,000
Audrius Skucas
0
0
Polus Fights Back Posted Saturday 2nd March, 2024 at 20:05(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (30,000) Entries: 22/914
Aleksi Naski made it 100,000 to go in the small blind with and Wissam Polus defended the big blind with .
The flop saw Naski continue for 50,000 chips, which Polus raised to 130,000. Naski let his hand go and the small pot was awarded to Polus.
Player
Chips
Progress
Aleksi Naski
3,300,000
100,000
Wissam Polus
2,200,000
0
Aktell Three-Bets Flop Posted Saturday 2nd March, 2024 at 20:01(UTC+0) by Frank Visser
Level 24: 15,000/30,000 (30,000) Entries: 22/914
Aleksi Naski raised to 60,000 under the gun with and Greger Aktell made the call in the cutoff with . The flop came down and Naski checked his set to Aktell, who fired a bet of 60,000.
Naski made a raise to 150,000, but Aktell was a non-believer and three-bet to 400,000 with his queen-high. Naski just called, after which both players checked through the turn and river.
Naski's set won the pot at showdown and the chipleader added even more chips to his massive stack.
Player
Chips
Progress
Aleksi Naski
3,400,000
500,000
Greger Aktell
1,200,000
400,000
19:56 (UTC+0)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Full House for Mockevicius Posted Saturday 2nd March, 2024 at 19:56(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 22/914
Martynas Mockevicius three-bet jammed for 365,000 and was called by the opener Luca Beretta (pictured below).
Martynas Mockevicius: Luca Beretta:
We were nearly down to 21 players but instead, Mockevicius improved to a full house on the board to secure a double-up.
Player
Chips
Progress
Martynas Mockevicius
800,000
10,000
Luca Beretta
210,000
400,000
Newey Chips Up Posted Saturday 2nd March, 2024 at 19:55(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 22/914
Paul Newey raised to 50,000 in the hijack with and he took down the pot as the rest of the table folded.
A few hands later, he found under the gun and raised to 50,000. Aleksei Smirnov called with in the small blind and Greger Aktell came along with in the big blind.
The action checked to Newey on the flop and he raked in another pot with a continuation-bet of 65,000, to which both players quickly folded.
Player
Chips
Progress
Greger Aktell
1,600,000
195,000
Aleksei Smirnov
1,100,000
0
Paul Newey
780,000
410,000
Ostrowski Cracks Pastor's Cowboys Posted Saturday 2nd March, 2024 at 19:39(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 22/914
Josep Pastor got his short stack in good from middle position and was up against Dominik Ostrowski from late position.
Josep Pastor: Dominik Ostrowski:
Ostrowski connected with his ace on the runout to eliminate Pastor in 23rd place.
Player
Chips
Progress
Dominik Ostrowski
2,000,000
400,000
Josep Pastor
0
0
Naski On a Roll Posted Saturday 2nd March, 2024 at 19:38(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 23/914
Aleksi Naski raised to 50,000 on the button with and Wissam Polus made the call with in the small blind. Aleksei Smirnov also came along with in the big blind, and the trio saw a flop of .
Polus decided to lead out of 65,000 with his king-high, forcing Smirnov to fold his second pair. Naski was not going anywhere with his two pair, however, and stuck in a call.
Polus slowed down on the turn and checked to Naski. The latter then bet 85,000 and Polus quickly exited the pot and mucked his cards.
Player
Chips
Progress
Aleksi Naski
2,900,000
200,000
Wissam Polus
2,200,000
100,000
Aleksei Smirnov
1,100,000
200,000
Chipleaders Play Small Pot Posted Saturday 2nd March, 2024 at 19:33(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 23/914
Aleksi Naski limped in from the small blind with and Wissam Polus checked his big blind with . Polus then called a 30,000 bet from Naski on the flop before both players checked the turn.
The fell on the river and Naski threw out a pot-sized bet of 135,000 chips. Polus folded his third pair and Naski took down another pot.
Player
Chips
Progress
Aleksi Naski
2,700,000
100,000
Wissam Polus
2,300,000
100,000
Naski Extends Lead Posted Saturday 2nd March, 2024 at 19:29(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 23/914
Benny Hagberg limped in from the small blind with and chipleader Aleksi Naski raised to 75,000 in the big blind with .
Hagberg made the call with his ducks and a flop of was spread. Both players checked and the hit the turn. Hagberg checked again and Naski checked behind once more.
The river saw Naski make a bet of 75,000 but Hagberg quickly folded his deuces.
Player
Chips
Progress
Aleksi Naski
2,600,000
105,000
Benny Hagberg
675,000
205,000
Polus Ousts Tarmi Posted Saturday 2nd March, 2024 at 19:14(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 23/914
Bengt-Anders Johnsson hit the rail on Table 11 before another player in Roope Tarmi followed. Wissam Polus opened for 55,000 from early position. Roope Tarmi jammed for 460,000 from the button. Polus counted out some chips before calling moments later.
Roope Tarmi: William Polus:
Ace-jack was good on the runout for Tarmi's impressive Main Event run to come to an end. Kasper Mellanen also recently hit the rail and players were on a short break for a three-table redraw.
Player
Chips
Progress
Wissam Polus
2,200,000
560,000
Kasper Mellanen
0
0
Roope Tarmi
0
0
Bengt-Anders Johnsson
0
0
Disastrous Flop Sends Vilmunen Home Posted Saturday 2nd March, 2024 at 19:12(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 26/914
Rolandas Aglinskas raised to 50,000 chips from the cutoff and Jani Vilmunen defended the big blind. The flop came down and Aglinskas continued for 75,000, which Vilmunen raised to 165,000.
Aglinskas then shoved all in for 600,000 and Vilmunen called with slightly less.
Jani Vilmunen: Rolandas Aglinskas:
Aglinskas' superior trips remained the best hand throughout the turn and river, sending Vilmunen out of the Main Event.
Player
Chips
Progress
Rolandas Aglinskas
1,300,000
580,000
Jani Vilmunen
0
0
Ostrowski Sends Short Stack Ninja Silencov to the Rail Posted Saturday 2nd March, 2024 at 18:55(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 27/914
Andrei Silencov three-bet jammed for 160,000 from the button and was called by Dominik Ostrowski (pictured below), who opened from middle position.
Andrei Silencov: Dominik Ostrowski:
Ostrowski connected with his king on the to eliminate the Day 3 short-stacked ninja Silencov in 28th place.
Player
Chips
Progress
Dominik Ostrowski
1,600,000
125,000
Andrei Silencov
0
0
Beretta Books Double-Up Posted Saturday 2nd March, 2024 at 18:55(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 29/914
Luca Beretta jammed all in for 280,000 on the button and Jani Vilmunen made the call in the small blind.
Luca Beretta: Jani Vilmunen:
Beretta turned some extra outs on , and one of them hit the river with the . His pair of jacks doubled him up, ending up with nearly the same stack as his adversary Vilmunen.
Player
Chips
Progress
Jani Vilmunen
645,000
455,000
Luca Beretta
610,000
320,000
Garrido Runs Into Smirnov's Rockets Posted Saturday 2nd March, 2024 at 18:48(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 29/914
2023 WSOP Circuit Tallinn Main Event champion Ignacio Garrido called off his 20+ big blind stack in a set-up of a hand against Aleksei Smirnov.
Ignacio Garrido: Aleksei Smirnov:
There was no Lady Luck with the queens for Garrido and he his deep run short of another Main Event title in Tallinn.
Player
Chips
Progress
Aleksei Smirnov
1,300,000
525,000
Ignacio Garrido
0
0
Vilmunen Bluffs Beretta Posted Saturday 2nd March, 2024 at 18:48(UTC+0) by Frank Visser
Level 23: 10,000/25,000 (25,000) Entries: 29/914
Jani Vilmunen raised to 50,000 from under the gun with and Luca Beretta made the call in the big blind with .
The flop came down and Vilmunen made a bet of 30,000 after Beretta checked. Beretta tossed in a call for the turn to hit the felt. Beretta checked once more and Vilmunen sized up to 90,000 chips.
Beretta stuck around with a call and the river completed the board. A third check followed from Beretta and Vilmunen emptied the clip with a bet of 200,000, the majority of Beretta's stack.
Beretta took one more look at his cards and took some minutes to figure out his course of action. Eventually, he decided to muck his two pair and leave himself with around 12 big blinds.
Player
Chips
Progress
Jani Vilmunen
1,100,000
255,000
Luca Beretta
290,000
110,000
Sixes Good for Brink Posted Saturday 2nd March, 2024 at 18:40(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 29/914
Frederik Brink jammed for 285,000 from under the gun and was called by Aleksi Naski from the big blind.
Frederik Brink: Aleksi Naski:
The board did the job for Brink to double through the chip leader straight off the dinner break.
Player
Chips
Progress
Aleksi Naski
2,495,000
310,000
Frederik Brink
605,000
320,000
Players Back From Break Posted Saturday 2nd March, 2024 at 18:08(UTC+0) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 29/914
Players are back from the dinner break. We will now be posting on a 30 minute delay to avoid any spoilers for those also watching the stream of the feature table at OlyBet.tv.
18:07 (UTC+0)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Chip Counts at Dinner Break Posted Saturday 2nd March, 2024 at 17:38(UTC+0) by Jason Glatzer
Player
Chips
Progress
Aleksi Naski
2,805,000
295,000
Benjamin Gros
2,440,000
160,000
Herli Olop
2,080,000
120,000
Wissam Polus
1,640,000
515,000
Dominik Ostrowski
1,475,000
745,000
Greger Aktell
1,405,000
655,000
Edgaras Kausinis
1,340,000
835,000
Kaido Mikk
1,265,000
1,083,000
Even Rislov
1,040,000
260,000
Nikita Zarovs
1,010,000
763,000
Mantas Tamulevicius
1,000,000
150,000
Sven Omland
965,000
679,000
Audrius Skucas
895,000
290,000
Jani Vilmunen
845,000
105,000
Tarmo Tammel
815,000
215,000
Martynas Mockevicius
810,000
210,000
Aleksei Smirnov
775,000
175,000
Rolandas Aglinskas
720,000
405,000
Mindaugas Jonaitis
580,000
140,000
Ignacio Garrido
485,000
128,000
Bengt-Anders Johnsson
485,000
81,000
Roope Tarmi
480,000
230,000
Benny Hagberg
470,000
144,000
Luca Beretta
400,000
385,000
Josep Pastor
375,000
80,000
Paul Newey
370,000
20,000
Kasper Mellanen
360,000
265,000
Frederik Brink
285,000
675,000
Andrei Silencov
205,000
180,000
Sebastian Wahl
0
0
Jimi Koponen
0
0
Dinner Break Posted Saturday 2nd March, 2024 at 17:05(UTC+0) by Jason Glatzer
Players are on a 60-minute dinner break. We will provide a full chip count update of the remaining players during the second half of the break.
Gros Cracks Gil's Rockets With Cowboys Posted Saturday 2nd March, 2024 at 17:05(UTC+0) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 31/914
Even Rislov opened the action followed by a call from Benjamin Gros (pictured below) before Albert Gil three-bet. Rislov folded, Gros four-bet shoved for 1.3 million and Gil called off his stack of 1 million in amazing shape with the best hand in poker.
Albert Gil: Benjamin Gros:
It was looking like Gil would jump past 2 million in chips. The odds were more on his side after both the flop and the turn. However, Gros apologized to Gil for a soft celebration after hitting his two outer on the river to eliminate Gil and catapult to near the top of the chip leaderboard.
Player
Chips
Progress
Aleksi Naski
2,800,000
710,000
Benjamin Gros
2,300,000
1,300,000
Albert Gil
0
0
Newey Doubles Through Tamulevicius Posted Saturday 2nd March, 2024 at 16:48(UTC+0) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 32/914
Mantas Tamulevicius opened from under the gun. Paul Newey three-bet shoved for 170,000 from the button and Tamulevicius snap-called.
Paul Newey: Mantas Tamulevicius:
Newey's nines pipped Tamulevicius's eights and he doubled up after there were no unwelcomed surprises on the board.
Player
Chips
Progress
Mantas Tamulevicius
850,000
100,000
Paul Newey
390,000
171,000
Trond Aanestad
0
0
Cowboys Hold for Gil Posted Saturday 2nd March, 2024 at 16:32(UTC+0) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 33/914
Albert Gil (pictured below) had his stack in the middle on the flop and was up against Mindaugas Jonaitis.
Albert Gil: Mindaugas Jonaitis:
Gil was ahead but Jonaitis could easily get there for a flush with any hearts along with some back door possibilities. The back door was shut on the turn and no spade came on the river for Gil to double through Jonaitis.
Meanwhile, €555 Championship runner-up Andrius Bielskis, Ranel Kasi, and Svein Mathiassen all recently hit the rail to leave just 33 players remaining in the Main Event.
Player
Chips
Progress
Albert Gil
800,000
256,000
Mindaugas Jonaitis
720,000
180,000
Svein Mathiassen
0
0
Ranel Kasi
0
0
Andrius Bielskis
0
0
Quad Jacks for Jonaitis Posted Saturday 2nd March, 2024 at 16:13(UTC+0) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 36/914
Jyrki Lampinen (pictured below) min-raised from early position and was called by Even Rislov from late position before Mindaugas Jonaitis squeezed for more than 15 big blinds. Lampinen called for less before Rislov went into the tank for about five minute before he opted to call having both players covered.
Jyrki Lampinen: Mindaugas Jonaitis: Even Rislov:
It was a rollercoaster of a board. Lampinen pulled out ahead with top pair on the flop. Rislov got there for Broadway on the turn. The turn also gave Jonaitis some hope as he had a set but still needed to improve from there.
Jonaitis improved in the biggest way possible to quad jacks after the spiked the river.
Player
Chips
Progress
Even Rislov
1,300,000
984,000
Mindaugas Jonaitis
900,000
834,000
Jyrki Lampinen
0
0
Olop Headlining the TV Table Posted Saturday 2nd March, 2024 at 16:03(UTC+0) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 37/914
There was a short unscheduled break after Level 21 when Table 12 moved to the TV table. Herli Olop, and his Killing Cap, will be the table captain with nearly 2 million in chips.
You can check out the opening chip counts from the TV table below and can watch the action shortly at OlyBet.tv on a 30-minute delay with hole cards exposed.
Player
Chips
Progress
Herli Olop
1,960,000
1,100,000
Luca Beretta
785,000
678,000
Greger Aktell
750,000
155,000
Andrius Bielskis
485,000
245,000
Josep Pastor
455,000
82,000
Sebastian Wahl
390,000
251,000
Rolandas Aglinskas
315,000
413,000
15:59 (UTC+0)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Lampinen Turns a Wheel Posted Saturday 2nd March, 2024 at 15:59(UTC+0) by Jason Glatzer
Level 21: 10,000/15,000 (15,000) Entries: 37/914
Kasper Mellanen jammed from the small blind and was called by Jyrki Lampinen for his 10 big blind stack from the big blind.
Jyrki Lampinen: Kasper Mellanen:
Mellanen pulled out ahead on the flop but Lampinen cheered as he nailed a wheel on the turn. The river completed the board for Lampinen to double through Mellanen.
Player
Chips
Progress
Kasper Mellanen
625,000
195,000
Jyrki Lampinen
325,000
116,000
Jonatan Fors
0
0
Morten Norland
0
0
Tammel Takes Out Perttula Posted Saturday 2nd March, 2024 at 15:27(UTC+0) by Jason Glatzer
Level 21: 10,000/15,000 (15,000) Entries: 39/914
Antti Perttula jammed from early position his short stack and was called by Tarmo Tammel from one seat over.
Antti Perttula: Tarmo Tammel:
Perttula bricked the runout to hit the rail to Tammel's paired up queen. Also recently eliminated were Osku Karttunen, Paulius Jucys, and Klavs Garselis.
Karttunen had a big stack but lost a bit of it with ace-king suited in two hands. The final hand, Benjamin Gros nailed a full house with his nines to put the nail in Karttunen's coffin.
Player
Chips
Progress
Benjamin Gros
1,000,000
765,000
Tarmo Tammel
600,000
20,000
Paulius Jucys
0
0
Osku Karttunen
0
0
Antti Perttula
0
0
Klavs Garselis
0
0
Jucys Dusts Off Haapaniemi Posted Saturday 2nd March, 2024 at 15:05(UTC+0) by Jason Glatzer
Level 21: 10,000/15,000 (15,000) Entries: 43/914
Sauli Haapaniemi lost most of his stack when his king-queen was no good against an opponent's ace-jack. Shortly after, he jammed for four big blinds and was called by Paulius Jucys (pictured below) from the big blind.
Sauli Haapaniemi was ahead with ace-five, but not by much with Jucys holding queen-ten. Jucys took down the hand and eliminated Haapaniemi in 45th place after queen hit the board.
Player
Chips
Progress
Paulius Jucys
475,000
307,000
Tomi Rissanen
0
0
Kris Tikka
0
0
Sauli Haapaniemi
0
0
Forus Falls Victim to Olop's Killing Cap Posted Saturday 2nd March, 2024 at 14:58(UTC+0) by Jason Glatzer
Level 21: 10,000/15,000 (15,000) Entries: 45/914
Herli Olop brought back the "Killing Cap" and it has done some killing. Olop dubbed his cap this name after he earned an autographed cap by Karl Killing after eliminating the Estonian celebrity songwriter and musician in the €150 Celebrity Event earlier this week.
Whether or not it is Olop or his Killing Cap is up for debate but either way, Tarjei Forus was on the rail as follows.
Forus jammed for 105,000 from the small blind and Olop and his magical cap called from the big blind.
Tarjei Forus: Herli Olop:
Forus got out of his seat and only really had one live card in his deuce. No love happened on the board for Forus to become the latest victim of Herli Olop's Killing Cap.
Player
Chips
Progress
Herli Olop
860,000
115,000
Tarjei Forus
0
0
14:45 (UTC+0)
Start of Level 21 Blinds: 10,000/15,000 Ante: 15,000
Aces Cracked for Sanders Posted Saturday 2nd March, 2024 at 14:44(UTC+0) by Jason Glatzer
We lost two players in the closing minutes of the blind level. Maximilian Sanders (pictured above) had his aces cracked by Jimi Koponen with king-queen after they got it preflop in with two queens coming out on the board. Meanwhile, Enea Subashi also hit the rail.
Aleksi Naski has been on fire and leads the 47 survivors still battling with more than 2 million at the break. Check out the big stacks at the break below:
Player
Chips
Progress
Aleksi Naski
2,090,000
590,000
Wissam Polus
1,125,000
881,000
Frederik Brink
960,000
148,000
Jani Vilmunen
950,000
17,000
Osku Karttunen
920,000
20,000
Kasper Mellanen
820,000
47,000
Mantas Tamulevicius
750,000
320,000
Herli Olop
745,000
45,000
Dominik Ostrowski
730,000
421,000
Andrius Bielskis
730,000
40,000
Audrius Skucas
605,000
182,000
Enea Subashi
0
0
Maximilian Sanders
0
0
Second Break Posted Saturday 2nd March, 2024 at 14:25(UTC+0) by Jason Glatzer
Players are about to head off on their second break of Day 3. We will update the bigger stacks from around the room when the action resumes shortly.
Tens Good for Garselis Posted Saturday 2nd March, 2024 at 14:24(UTC+0) by Jason Glatzer
Level 20: 6,000/12,000 (12,000) Entries: 49/914
Martynas Mockevicius opened for 25,000 from the button before Klavs Garselis three-bet shoved for 155,000. Mockevicius looked down at his opponent's stack before he called.
Klavs Garselis: Martynas Mockevicius:
Garselis doubled through Mockevicius after his tens proved to be enough on the runout.
Player
Chips
Progress
Martynas Mockevicius
600,000
508,000
Klavs Garselis
328,000
91,000
Alexander Sokolovsky
0
0
Recent Eliminations Posted Saturday 2nd March, 2024 at 14:13(UTC+0) by Jason Glatzer
Player
Chips
Progress
Peer Zahl
0
0
Gediminas Dirmantas
0
0
Thomas Larsen
0
0
Miska Vihervuori
0
0
Chip Leader Naski Eliminates Andre Posted Saturday 2nd March, 2024 at 13:54(UTC+0) by Jason Glatzer
Level 20: 6,000/12,000 (12,000) Entries: 54/914
Henning Andre jammed a short stack from the cutoff and was looked up by Aleksi Naski (pictured below) from the button.
Henning Andre: Aleksi Naski:
Naski's big slick won the flip to eliminate Andre after the runout improved him to top two pair while also taking the overall chip lead.
Meanwhile, Ilari Sahamies shared he ran nines into an opponent's aces to hit the rail.
Player
Chips
Progress
Aleksi Naski
1,500,000
1,112,000
Ilari Sahamies
0
0
Henning Andre
0
0
Steven Tool
0
0
Patrikas Aglinskas
0
0
Sandis Blums
0
0
Mikk Delivers Cooler to Blums Posted Saturday 2nd March, 2024 at 13:49(UTC+0) by Jason Glatzer
Level 20: 6,000/12,000 (12,000) Entries: 60/914
Kaido Mikk (pictured below) jammed for 81,000 from under the gun and was called by Sandis Blums from the big blind.
Kaido Mikk: Sandis Blums:
Normally we would be looking at a chopped pot but Mikk nailed a flush on the runout to double his stack through Blums.
Player
Chips
Progress
Sandis Blums
370,000
172,000
Kaido Mikk
182,000
64,000
Thomas Haverstad
0
0
Peter Jaksland
0
0
Viktor Eriksson
0
0
Mattias Hansen
0
0
13:30 (UTC+0)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Big Slick No Good for Ylamaki Posted Saturday 2nd March, 2024 at 13:28(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 64/914
2024 Kings of Tallinn €555 Championship winner Mikko Ylamaki (pictured below) jammed for about a dozen big blinds before Osku Karttunen cold-called from late position.
Mikko Ylamaki: Osku Karttunen:
Ylamaki had some hope on the flop as not only was his ace live but so was a flush draw. However, Karttunen won the pot and sent Ylamaki to the rail after the turn and river completed the board.
Player
Chips
Progress
Osku Karttunen
900,000
35,000
Mikko Ylamaki
0
0
Straight Flush for Tammel Posted Saturday 2nd March, 2024 at 13:23(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 65/914
Thomas Larsen jammed over the bet made by Tarmo Tammel on the flop. Tammel called and the cards were turned over.
Tarmo Tammel: Thomas Larsen:
Tammel was ahead with his pair and had tons of draws to improve from there. The turn improved Tammel to a straight flush. Larsen was drawing dead and paid Tammel off after the river completed the board.
Meanwhile, 2020 Kings of Tallinn champion Johan Karlsson hit the rail at the same time when his nines were unable to win a flip against ace-jack around the same time at a different table.
Player
Chips
Progress
Tarmo Tammel
620,000
329,000
Thomas Larsen
230,000
293,000
Queens of Tallinn Mystery Bounty Begins Posted Saturday 2nd March, 2024 at 13:14(UTC+0) by Jason Glatzer
The €150 Queens of Tallinn Mystery Bounty already has a few dozen ladies from the start with 41 entries including host and FLIP founder Daiva Byrne.
Kelly Limonova, Christel Haller, Kristi Kirs, Tove Christensen, Monika Leek, the third-place finisher in 2023 Queens of Tallinn Main Event Indre Martoviciute, runner-up Caitlin Muur, and Diana Toht are among the early entries.
The ladies appear to already be having fun and we wish them the best of luck in their quest for a 2024 Kings of Tallinn trophy.
Sahamies Ousts Kasper Posted Saturday 2nd March, 2024 at 13:10(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 66/914
Two poker legends in Henri Kasper (pictured below) and Ilari "Ziigmund" Sahamies tangled up in a hand resulting in Kasper losing his stack. Kasper opened from late position and was called by Sahamies from the big blind.
Sahamies check-raised the flop before he called a shove of around 15 big blinds by Kasper.
Henri Kasper: Ilari Sahamies:
It was a strong hand for Kasper with top two pair but he needed a four outer or some runner-runner magic to survive against Sahamies's flopped straight. Neither the turn nor the river provided any relief and Kasper hit the rail in 67th place.
Player
Chips
Progress
Ilari Sahamies
435,000
54,000
Mihkel Vitsur
0
0
Kaur-Silver Koha
0
0
Adrians Imsa
0
0
Kenneth Svendsen
0
0
Kaius Kiidli
0
0
Henri Kasper
0
0
Zahl Doubles With Jacks Posted Saturday 2nd March, 2024 at 12:55(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 72/914
Mihkel Vitsur opened the button before Peer Zahl three-bet 115,000 out of his stack of 140,000 from the big blind. Vitsur four-bet jammed and Zahl went into the tank perhaps due to a pay jump looming for several minutes until a player called time.
"Will you be counting down?" asked Zahl.
The floor confirmed they would and he called as soon as the countdown began.
Peer Zahl: Mihkel Vitsur:
Zahl clapped in the air after his jacks held to double his stack on the board.
Meanwhile, Joonas Helin (pictured below) hit the rail at a different table when he ran his ace-queen into queens to leave just 72 players remaining.
Player
Chips
Progress
Peer Zahl
305,000
174,000
Mihkel Vitsur
205,000
9,000
Joonas Helin
0
0
Full House for Ostrowski Posted Saturday 2nd March, 2024 at 12:46(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 73/914
Rolandas Aglinskas opened from the hijack before he called a three-bet shove by Dominik Ostrowski (pictured below) from the big blind for 147,000.
Dominik Ostrowski: Rolandas Aglinskas:
Ostrowski's flip turned out to be more than OK as he improved to a full house on the runout to double through Aglinskas instead of hitting the rail.
Player
Chips
Progress
Rolandas Aglinskas
728,000
97,000
Dominik Ostrowski
309,000
4,000
Paul Koppe
0
0
Norland Doubles Haapaniemi Posted Saturday 2nd March, 2024 at 12:40(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 74/914
Morten Norland (pictured below) min-raised the button before Sauli Haapaniemi three-bet shoved for 118,000. Norland called and Haapaniemi was flipping for his tournament life.
Sauli Haapaniemi: Morten Norland:
Haapaniemi connected with his nine on the flop and never looked back to double his stack after the ran out on the board.
Player
Chips
Progress
Morten Norland
540,000
202,000
Sauli Haapaniemi
256,000
164,000
Tamulevicius Chip Millionaire at Break Posted Saturday 2nd March, 2024 at 12:32(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 74/914
Mantas Tamulevicius was the chip leader at the break with more than 1 million. Check out some of the bigger stacks from around the room.
Player
Chips
Progress
Mantas Tamulevicius
1,070,000
400,000
Jani Vilmunen
933,000
35,000
Osku Karttunen
865,000
211,000
Rolandas Aglinskas
825,000
590,000
Frederik Brink
812,000
243,000
Kasper Mellanen
773,000
16,000
Herli Olop
700,000
170,000
Andrius Bielskis
690,000
90,000
Greger Aktell
595,000
287,000
Ignas Vaitulionis
0
0
Fritz Nygren
0
0
Mark Metsla
0
0
Marius Morel
0
0
12:27 (UTC+0)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
First Break Posted Saturday 2nd March, 2024 at 12:10(UTC+0) by Jason Glatzer
Players are about to embark on their first 15-minute break. We will update some of the bigger stacks from around the room after the break.
Player
Chips
Progress
Jon Martinez
0
0
Stein Naerland
0
0
Gatis Maisins
0
0
Smirnov Delivers Bad Beat to Laurinaitis Posted Saturday 2nd March, 2024 at 11:58(UTC+0) by Jason Glatzer
Level 18: 4,000/8,000 (8,000) Entries: 81/914
Vytautas Laurinaitis (pictured below) jammed for around 170,000 into a pot of a bet more on the board after the turn and was called by Aleksi Smirnov.
Vytautas Laurinaitis: Aleksi Smirnov:
Laurinaitis was ahead but had a huge sweat with tons of possibilities for Smirnov to improve from top pair including a flush draw. However, it was a better two pair for Smirnov after the river completed the board to eliminate Laurinaitis.
Player
Chips
Progress
Aleksei Smirnov
600,000
332,000
Per Engstrom
0
0
Vasilijus Piskunovas
0
0
Vytautas Laurinaitis
0
0
Eriksson Doubles After Cowboys Beat Ladies Posted Saturday 2nd March, 2024 at 11:47(UTC+0) by Jason Glatzer
Level 18: 4,000/8,000 (8,000) Entries: 85/914
Aleksi Naski min-raised from the hijack before Jon Martinez three-bet to 44,000 from the cutoff. Viktor Eriksson (pictured below) four-bet shoved for 109,000 from the blinds. Naski quickly folded while Martinez quickly found a call.
Viktor Eriksson: Jon Martinez:
Cowboys were good against ladies for Eriksson to double up after the ran out on the board.
Player
Chips
Progress
Viktor Eriksson
254,000
53,000
Jon Martinez
70,000
158,000
Mairo Tori
0
0
Petteri Miettinen
0
0
Kalle Parkkinen
0
0
Jani Tuovinen
0
0
Team Jari Down Posted Saturday 2nd March, 2024 at 11:32(UTC+0) by Jason Glatzer
Level 18: 4,000/8,000 (8,000) Entries: 89/914
As we mentioned a couple of times already, all four players from the team Four of a Kind Jari's were in the mix on today's penultimate day of the Main Event.
However, none of the Jari's lasted long as three of them were on the rail within the first hour leaving just the short-stacked Jari Saviaho as their potential savior.
Saviaho was all in from the big blind before the cards were dealt. Luca Beretta min-raised from middle position and the rest of the table folded.
Jari Saviaho: Luca Beretta:
Saviaho was thrilled to have live cards. However, he didn't get any traction on the board and he joined his teammates Jari-Pekka Juhola, Jari Mahonen, and Jari Hurri on the rail. We wish all four Jari's the best of luck in the side events today.
Player
Chips
Progress
Aurelijus Sipavicius
0
0
Tomi Arponen
0
0
Jari Saviaho
0
0
Svendsen Doubles Through Tamulevicius Posted Saturday 2nd March, 2024 at 11:24(UTC+0) by Jason Glatzer
Level 18: 4,000/8,000 (8,000) Entries: 92/914
Mantas Tamulevicius opened for 18,000 from under the gun. Kenneth Svendsen three-bet shoved for 71,000 from one seat over. Tamulevicius found a call when the action folded around to him leaving Svendsen at risk in a coin flip situation.
Kenneth Svendsen: Mantas Tamulevicius:
Tamulevicius, who fired his first and only bullet in the Main Event seconds before late registration closed, improved to trips on the board. But Svendsen didn't have much of a sweat as he flopped a set of snowmen and had Tamulevicius drawing dead on the turn to double his stack.
Meanwhile, the affable Sascha Manns lost his short stack around the same time at a different table.
Player
Chips
Progress
Mantas Tamulevicius
670,000
107,000
Kenneth Svendsen
162,000
11,000
Sascha Manns
0
0
Shachar Haran
0
0
11:14 (UTC+0)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Nines Good for Henning Andre to Double Through Mjelstad Posted Saturday 2nd March, 2024 at 11:13(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 94/914
Niclas Mjelstad (pictured below) min-raised from the cutoff before he called a three-bet jam by Henning Andre for 85,000 from the button.
Henning Andre: Niclas Mjelstad:
Andre had a sweat to survive despite nailing a set on the flop as Mjelstad had tons of hope with a flush draw. Running sixes in the turn and river improved Mjelstad to a flush but Andre doubled up anyway as this card also improved him to a full house.
Meanwhile, the Four of a Kind Jari's is down to its last Jari after Jari Hurri hit the rail.
Player
Chips
Progress
Niclas Mjelstad
350,000
40,000
Henning Andre
185,000
35,000
Karl Linder
0
0
Rytis Pranarauskas
0
0
Jesper Hansen
0
0
Lauri Laast
0
0
Jari Hurri
0
0
Tarmi Ousts Bezdek in Classic Flip Posted Saturday 2nd March, 2024 at 10:53(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 99/914
Roope Tarmi opened for a min-raise from under the gun. Anne Bezdek three-bet jammed for more than a dozen big blinds from the button and Tarmi called.
Anne Bezdek: Roope Tarmi:
Bezdek flew out of her chair after Tarmi improved to trips on the flop and headed to the cashier after neither the turn nor the river were of any help.
Player
Chips
Progress
Roope Tarmi
250,000
83,000
Adria Comas I Roura
0
0
Anne Bezdek
0
0
One More Jari Down; Two Jari's Remaining Posted Saturday 2nd March, 2024 at 10:44(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 101/914
The clock was paused temporarily due to a small technical problem but as soon as the action resumed we lost a second player from the Four of a King Jaris.
Jari Mahonen (pictured below) jammed from under the gun for 23,000 before Mairo Tori came over the top for 84,000 from late position.
Jari Mahonen: Mairo Tori:
Mahonen got some help and improved to two pair to double his stack on the board. However, his good fortunes ended there.
The next hand, Tori jammed from late position and was called by Mahonen.
Jari Mahonen: Mairo Tori:
It was looking like Mahonen was about to go on a run but instead hit the rail after Tori delivered a bad beat with a full house on the board.
Player
Chips
Progress
Mairo Tori
180,000
82,000
Jari Mahonen
0
0
One Jari Down Posted Saturday 2nd March, 2024 at 10:24(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 102/914
Jari-Pekka Juhola (pictured below) defended from the big blind the early position open by Enea Subashi before getting his short stack in on the flop.
Jari-Pekka Juhola: Enea Subashi:
Juhola's top pair needed some help but none was on the way with the turn and river completing the board.
Juhola is on the team Four of a Kind Jaris for the Team Competition. All four Jari's advanced to Day 3 with Jari Mahonen, Jari Hurri, and Jari Saviaho rounding out the team. Best of luck to the three remaining Jari's.
In other news, the legend of Sleeping Beauty has ended as he lost his one chip with other players losing bigger stacks in the opening moments.
Player
Chips
Progress
Enea Subashi
300,000
95,000
Jari-Pekka Juhola
0
0
Christian Rysgaard
0
0
Mindaugas Kriauciunas
0
0
Rolf Jauring
0
0
Olegs Petrovskis
0
0
Ignas Navickas
0
0
Silver Simulask
0
0
Oscar Peleg
0
0
Matias Knaapinen
0
0
Early Eliminations Posted Saturday 2nd March, 2024 at 10:12(UTC+0) by Jason Glatzer
The following players hit the rail in the opening moments:
Player
Chips
Progress
Arto Lehtonen
0
0
Ignas Jasinevicius
0
0
Javier Moya
0
0
Vidar Furu Oie
0
0
Peleg Wins a Flip With Fives Posted Saturday 2nd March, 2024 at 10:11(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 115/914
Three players already hit the rail on the opening hand including last night's side-event trophy winner Matias Kesanen and it could have been more but Oscar Peleg won a flip to survive as follows.
Peleg jammed his stack under the gun with 43,000 and was called by Edgaras Kausinis from the button.
Oscar Peleg: Edgaras Kausinis:
"Flipping, whew," said Peleg.
The flip quickly turned to Peleg's advantage after improving to a set on the flop.
"Well, that was a good flop," said Peleg.
Kausinis was drawing dead on the turn and Peleg doubled his stack with a full house on the river.
Player
Chips
Progress
Edgaras Kausinis
505,000
47,000
Oscar Peleg
101,000
58,000
Richard Koppel
0
0
Matias Kesanen
0
0
Marcus Van Akram
0
0
Cards in the Air Posted Saturday 2nd March, 2024 at 10:02(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 118/914
Cards are in the air for Day 3 of the Main Event. Best of luck to all of the players.
10:01 (UTC+0)
Day 3 of Kings of Tallinn 2024 Started Level: 17 Blinds: 3,000/6,000 Ante: 6,000
Players Unbagging Chip(s) Posted Saturday 2nd March, 2024 at 10:00(UTC+0) by Jason Glatzer
The Main Event players have arrived and are in the process of unbagging their chips or in the case of Christian "Sleeping Beauty" Rysgaard he is unbagging a single chip of 1,000.
The action should start near on time with most players already in their seats. Best of luck to all of the Day 3 players.
Who Will Advance to the Final Table of the Main Event? Posted Saturday 2nd March, 2024 at 08:45(UTC+0) by Jason Glatzer
The action will get hotter and more serious on Saturday in the 2024 Kings of Tallinn Main Event with the record-breaking field of 914 entries down to 118 players after yesterday's action ended when the money bubble broke.
Returning players are each guaranteed €2,100 with payouts jumping up fast from there until tomorrow's eventual winner walks away with the beautiful trophy and the €151,860 top prize.
Finland's Jani Vilnumen (pictured above) will kick off the day in the captain's chair after ending Day 2 with a huge stack of 968,000. Vilmunen has been in this spot before as he is a well-experienced pro with nearly $900,000 in cashes tracked at The Hendon Mob. The Finn also won a WSOP Europe in the £5,250 Pot Limit Omaha back in 2009.
Meanwhile, Lithuania'sMantas Tamuleviciusfired his very first bullet on Day 2 and waited until the very last second to start the day with 12 big blinds. He made the most of his decision as he catapulted his 30,000 stack to 777,000 to finish just behind Vilmunen.
Kasper Mellanen(757,000),Osku Karttunen(654,000), and 2024 Kings of Tallinn €555 Championship runner-upAndrius Bielskis(600,000) round out the top five.
Olympic poker managerHerli Olop(530,000), MaximilianSanders (502,000), Steven Tool (400,000), OG online poker legend Ilari "Ziigmund" Sahamies (381,000), Josep Pastor (373,000), 2023 WSOP Circuit Tallinn Main Event champ Ignacio Garrido (357,000), Dominik Ostrowski (313,000), Tarmo Tammel (291,000), 2023 Kings of Tallinn €555 Championship winner Benjamin Gros (235,000), super high roller Paul Newey (219,000), 2024 Kings of Tallinn €555 PLO Mystery Bounty champ Paul Koppe (213,000), and Roope Tarmi (167,000) are jus some of the names to look out for with many other notable players still in the mix.
Our new hero Christian Rysgaard began Day 2 with the chip lead but needs to pull off some magic as he will begin Day 3 with exactly one chip worth 1,000.
The plan for Day 3 is to play down to a final table of nine players. Players should be prepared for a longer day than what they experienced during the opening flights and Day 2.
Our coverage begins when cards are in the air at 12 p.m. Best of luck to all of the remaining players in their hunt for Kings of Tallinn glory!
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
and Mantas Tamulevicius called with 
in the big blind. Naski then continued for 120,000 on the 
flop and Tamulevicius stuck around with his pocket pair.
turn was checked through, and so was the 
river. Naski's pair of queens won at showdown and he crossed the four-million mark as a result.
fanned out.
turn instead. The 
and Mantas Tamulevicius made the call in the cutoff with 
. Greger Aktell also called in the small blind with 
and the subsequent 
turn. Tamulevicius stuck around with a call before Aktell mucked his hand.
turn and a quick fold followed from Tamulevicius, seeing another pot go to the Finn.
flop and 
turn were checked by both players before the 
river brought them both a pair.
on the button and Even Rislov called in the small blind with 
. Greger Aktell defended his big blind with 
was dealt. 
in the hijack and Mantas Tamulevicius called his 
flop before the 
turn was checked by both.
and Mindaugas Jonaitis called 
then hit the felt and Naski slowed down with a check. Brislov reached for 450,000 chips and pushed them in the middle, forcing Jonaitis out of the pot. After a few minutes, Naski followed suit, and the big pot was shipped to Rislov.
turn and was officially eliminated in 15th place after the 
river completed the board.
turn before both players checked the 
ran out on the board.
and a flop of 
and Wissam Polus defended the big blind with 
. Polus then called a 30,000 bet from Naski on the 
board.
