Kings of Tallinn Summer Showdown 2023 - Live Updates

        
0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/21/91/updates'
ORDER BY `views` DESC

0.0082 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/21/91/updates'

0.0003 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` = '21'

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'

0.0206 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0047 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '82'
AND `published` = 1

0.0206 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '84'
AND `published` = 1

0.0204 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0043 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1

0.0200 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0038 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1

0.0202 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0041 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '93'
AND `published` = 1

0.0090 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '91'
ORDER BY `busted` ASC, `current_chips` DESC

0.0088 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` = '91'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0087 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4258'
ORDER BY `chip_change` DESC, `busted` ASC

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4257'
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` = '4256'
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` = '4255'
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` = '4254'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4253'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4252'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4249'
ORDER BY `chip_change` DESC, `busted` ASC

0.0239 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4246'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0087 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4240'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0087 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4234'
ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4231'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4228'
ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4226'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4224'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4223'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4221'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4219'
ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4215'
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` = '4213'
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` = '4206'
ORDER BY `chip_change` DESC, `busted` ASC

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4204'
ORDER BY `chip_change` DESC, `busted` ASC

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4201'
ORDER BY `chip_change` DESC, `busted` ASC

0.0087 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4200'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0077 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4185'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4184'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4180'
ORDER BY `chip_change` DESC, `busted` ASC

0.0049 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4175'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4172'
ORDER BY `chip_change` DESC, `busted` ASC

0.0162 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4171'
ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4169'
ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4168'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4162'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4161'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0048 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4150'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4146'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4145'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4140'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4139'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4134'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4133'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4127'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4123'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4120'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4118'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4116'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4113'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4108'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4104'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4100'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4097'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4094'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4092'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4089'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4086'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4085'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4083'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4082'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4080'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4079'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4074'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4073'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4071'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4068'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4067'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4066'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4064'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4062'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4061'
ORDER BY `chip_change` DESC, `busted` ASC

0.0161 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4060'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4059'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4058'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4057'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4055'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4052'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4051'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4049'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4048'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4047'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4046'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4044'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4043'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4040'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4039'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4037'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4036'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4035'
ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '91'
ORDER BY `busted` ASC, `current_chips` DESC

0.0040 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` = '91'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4258'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4257'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4256'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4255'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4254'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4253'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4252'
ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4249'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4246'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4243'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4242'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4240'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4237'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4236'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4234'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4231'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4228'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4226'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4224'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4223'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4221'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4219'
ORDER BY `chip_change` DESC, `busted` ASC

0.0162 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4215'
ORDER BY `chip_change` DESC, `busted` ASC

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4213'
ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4206'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4204'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4201'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4200'
ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4197'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4184'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4180'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4175'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4172'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4171'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4169'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0148 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4161'
ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4153'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4151'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4150'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4146'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4145'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4140'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4139'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4134'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4133'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4127'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4123'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4120'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4118'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4116'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4113'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4108'
ORDER BY `chip_change` DESC, `busted` ASC

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4104'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4100'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4097'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4094'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4092'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4089'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4086'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4085'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4083'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4082'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4080'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4079'
ORDER BY `chip_change` DESC, `busted` ASC

0.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4074'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4073'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4071'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4068'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4067'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4066'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4064'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4062'
ORDER BY `chip_change` DESC, `busted` ASC

0.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4061'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4060'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4059'
ORDER BY `chip_change` DESC, `busted` ASC

0.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4058'
ORDER BY `chip_change` DESC, `busted` ASC

0.0048 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4057'
ORDER BY `chip_change` DESC, `busted` ASC

0.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4055'
ORDER BY `chip_change` DESC, `busted` ASC

0.0148 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4052'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4051'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4047'
ORDER BY `chip_change` DESC, `busted` ASC

0.0108 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4046'
ORDER BY `chip_change` DESC, `busted` ASC

0.0161 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4044'
ORDER BY `chip_change` DESC, `busted` ASC

0.0108 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4043'
ORDER BY `chip_change` DESC, `busted` ASC

0.0396 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4040'
ORDER BY `chip_change` DESC, `busted` ASC

0.0085 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4039'
ORDER BY `chip_change` DESC, `busted` ASC

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4037'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0088 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '93'
ORDER BY `busted` ASC, `current_chips` DESC

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084

Translate

Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) Live Reporting - Day 4

Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

Current Level 32 Current Day 4

Blinds 100,000/200,000 Ante 200,000

Entries 564 Remaining 1

Prize Pool (EUR) €530,160 First Prize (EUR) €108,260

Chip Leaders Day 4

1	Kai E. J. Lehto		17,000,000

Day 1A Day 1B Day 2 Day 3 Day 4

1 New Update - Click to refresh

Live Updates - Day 3

Jätkame homme Posted Sunday 30th July, 2023 at 00:19(UTC+0) by maheaaatom

Kuna täna lahenduseni kuidagi ei jõutud, siis otsustas turniiridirektor mängijad puhkama lubada.

Peab ju homme kell 12:00 taas lauda istuma ning kes see puruväsinuna ikka mängida armastab. Seega jätkama pühapäeval samast seisut ehk kümnekesi. Ja mängime all kasiinos.

Meie mehi on mängus kolm ning kõigil on korralikud stäkid. Head ööd!

Player	Chips	Progress
Kai E. J. Lehto	3,202,000	1,277,000
Urmo Velvelt	2,665,000	335,000
Tarmo Tammel	2,340,000	850,000
Mikael Johannes Haapaniemi	2,130,000	980,000
Magnus Pukk	1,605,000	140,000
Tomi Tapani Arponen	1,535,000	760,000
Phil Gross	1,360,000	240,000
Nils Jakob Elias Linden	990,000	515,000
Ville-Matti Keränen	730,000	330,000
Tapio Ilmari Aaltonen	345,000	465,000

Lõpp paistab aga ei saabu Posted Sunday 30th July, 2023 at 00:00(UTC+0) by maheaaatom

Aaltonen ja Gross ei stalli, vaid proovivad ka all-in'e, kuid actionit pole ka järgnenud või...on pank poolitatud. Mõlemad mehed on siiski endiselt väga shordid ning hoiavad silma peal ka telelaual. All-in actionit on muide sealgi olnud.

Player	Chips	Progress
Kai E. J. Lehto	3,202,000	1,277,000
Urmo Velvelt	2,665,000	335,000
Tarmo Tammel	2,340,000	850,000
Mikael Johannes Haapaniemi	2,130,000	980,000
Magnus Pukk	1,605,000	140,000
Tomi Tapani Arponen	1,535,000	760,000
Phil Gross	1,360,000	240,000
Nils Jakob Elias Linden	990,000	515,000
Ville-Matti Keränen	730,000	330,000
Tapio Ilmari Aaltonen	345,000	465,000

Aaltonenil ja Grosil keeruline seis Posted Saturday 29th July, 2023 at 23:44(UTC+0) by maheaaatom

Gross loovutab kohe järgmises jaotuses veel korraliku panga soomlasele Haapaniemile ning langeb alla 10XBB. Kuigi parem pole ka Aaltoneni seis, kellel küll kuskile kiiret pole - igale foldile eelneb pikk mõtlemine.

Chipid on selgelt lauas ühes otsas - Haapaniemil, Urmol ja Tarmol.

Gross annab alla Posted Saturday 29th July, 2023 at 23:37(UTC+0) by maheaaatom

Phil Gross tuleb Tarmo Tammeli BB-d "sööma" (100K), kuid meie mees vastab 360K-ga. Gross callib.

Flop on ning Tarmo avab 180K-ga. Sakslane callib.

Turni järel läheb Tarmo all-in. Katab Grossi ilusti.

"Nii, mis mul on?" uurib sakslane. "Äss-poiss," vastab Tarmo. "Okei, aga mis siis sinul on," pärib Gross uuesti. Vastust ei tule. "Ok, teeme siis nii - mida mina arvan, mis sul on?" usutleb lõbus sakslane edasi.

Viimaks viskab ta siiski maha. Tarmo paneb lauale kaks kaarti ja lubab Grossil ühe neist avada. Selleks on emand. "Emandate paar," pakub Gross. Soomlane Aaltonen arvab, et hoopis äss-emand. Jälle üks mõtteülesanne.

Tõeline melu käib kasiinos Posted Saturday 29th July, 2023 at 23:16(UTC+0) by maheaaatom

Kui ülemisel korruse mängusaalis on ülimalt vaikne, sest allesjäänud turniiridel on vähe osalejaid, siis Olympic Casinos käib täielik laulupidu. Saal on paksult rahvast täis, cash käimas enam kui tosinal laual. Mis muud kui tõeline suurfestival, laupäev ju veel nagunii!

23:14 (UTC+0)

Start of Level 27
Blinds: 25,000/50,000 Ante: 50,000

Allesjäänud mängijate stäkid Posted Saturday 29th July, 2023 at 23:12(UTC+0) by maheaaatom

Väiksem stäkk on 13XBB, kokku on kolm alla-miljoni stäkke.

Mäng läks just uuesti käima ning kuna üks laud on alumisel ja teine ülemisel korrusel, siis EI MÄNGITA hand-by-hand.

Player	Chips	Progress
Kai E. J. Lehto	3,395,000	1,470,000
Urmo Velvelt	2,760,000	240,000
Mikael Johannes Haapaniemi	2,040,000	1,070,000
Tarmo Tammel	1,730,000	240,000
Ville-Matti Keränen	1,635,000	1,235,000
Phil Gross	1,600,000	1,430,000
Tomi Tapani Arponen	1,380,000	605,000
Magnus Pukk	970,000	775,000
Tapio Ilmari Aaltonen	720,000	90,000
Nils Jakob Elias Linden	685,000	210,000

11. koht - Ilya Nikiforov Posted Saturday 29th July, 2023 at 22:58(UTC+0) by maheaaatom

Ilya sai "õhtule" telelauas, seega me jaotuse käiku ei tea. Ja üleüldse algas ka tänane viimane paus 15 minutit.

Seejärel mängime kuni ühe langejani, siis on finaallaud koos.

Player		Chips	Progress
Ilya Nikiforov		0	0

Tarmo ja Urmo ristavad taas piike Posted Saturday 29th July, 2023 at 22:48(UTC+0) by maheaaatom

Urmo on selgelt laua agressor ning tundub, et ka Tarmo Tammelil on tema ees teatav aukartus.

Äsja olid samad mehed taas vastamisi, seekord andis aga Urmo turni järel alla ning Tarmo korjas umbes 500K panga endale. Mõlemal mehel on umbes 2,5M, millega domineeritakse oma lauda. Chiplooserid on endiselt samad, kuid seis on märksa ühtlasem kui varem.

Ootame endiselt kahte langejat.

Sakslasele veel üks duubel Posted Saturday 29th July, 2023 at 22:39(UTC+0) by maheaaatom

Seekord on actionis turniiri chipliider Haapaniemi. Nuppe lükatakse pärast floppi

Mõlemal mehel on mastitõmme (Grossil , soomlasel aga ) ning ka oluline eelis - lauast on paar käes.

Masti ei saa kumbki, kuid Gross tõmbab riverisse ässa ning on nüüd samuti miljoniklubis.

Ei lähe see Gross kuskile! Posted Saturday 29th July, 2023 at 22:28(UTC+0) by maheaaatom

Pärast floppi on Phil Gross oma 270K-ga keskel ning Urmo Velvelt callib kiirelt. No mis sel pagana sakslasel siis ikka olla saab?

Urmo näita uhkelt , kuid Gross nagu nõiutult . Turn ja river päästvat emandat ei too.

Ei lange keegi Posted Saturday 29th July, 2023 at 22:18(UTC+0) by maheaaatom

Üleval on viis mängijat, kellest kaks on väga suurt stäkki (Haapaniemi ja Urmo), üks keskmine (Tarmo Tammel) ning kaks väikest (Gross ja Aaltonen).

Viimastest "suutis" Gross just kolmandiku oma stäkist tõelise herocalli (äss-kõrge kuningas-kõrge vastu) teinud Haapanieme vastu maha bluffida, kuid Aaltonen suutis oma 350K ministäki jällegi (samuti Haapanieme vastu) igati ausalt duublisse saada: vs. .

Kui need mehed just all-in'is ei käi, hoiab tempot Urmo Velvelt.

22:10 (UTC+0)

Start of Level 26
Blinds: 20,000/40,000 Ante: 40,000

Urmo võtab võimsa skalbi Posted Saturday 29th July, 2023 at 22:07(UTC+0) by maheaaatom

Viimastes tasemetel väga halvasti jooksnud Anatoly Filatov kolmpanustab all-in ning saab flipi Urmo Velvelti vastu.

Anatoly:

Urmo:

Lauda .

Urmole ca. 650K chipilisa, kuid Anatolyst on siiski omamoodi kahju. Hea mängija, hea mäng, kuid mitte midagi lõpus pihta ei läinud.

Urmol nüüd ca. 3M. Väga kõva avaldus!

Player		Chips	Progress
Urmo Velvelt		3,000,000	1,700,000
Anatoly Filatov		0	0

Jätkame 12-kesi Posted Saturday 29th July, 2023 at 22:03(UTC+0) by maheaaatom

Telelauast langes Juho H. S. Heiska, seega oleme hetkel 12-kesi. Ühtlasi on surmkindel, et finaallauas on vähemalt üks (aga miks mitte neli) eestlast.

Keegi peab nüüd ülevalt allakorrusele minema ning selleks meheks on Tomi Arponen.

Urmole veel üks pank Posted Saturday 29th July, 2023 at 21:53(UTC+0) by maheaaatom

Urmo haukab ka natuke Phil Grossi stäkist - esimesel top kaks paari, meie mehel kolmik.

Urmol nüüd 2,3M, Tarmol 1,5M. Viimasele ei anna muidugi kuidagi rahu see viimane käsi, kus ta oli sunnitud riveril ässad foldima. Äkki avaldab Urmo pärast turniiri saladuse?

Jätkame aga endiselt 13-kesi. Tomi Arponen käib just all-in'is Anatoly Filatovi vastu ning on selgelt taga ( vs. ), kuid river...jah river on . Anatolyle tuleb 340K välja maksta. Tuleb märkida, et live-turniiridel üle 5 miljoni teeninud mehel pole viimastel tasemetel kohe üldse õnne olnud. Mänginud on Anatoly tegelikult väga hästi.

Player		Chips	Progress
Urmo Velvelt		2,300,000	1,000,000
Tarmo Tammel		1,500,000	10,000

Tarmo foldib ässad Posted Saturday 29th July, 2023 at 21:45(UTC+0) by maheaaatom

Kõrvuti istuvad Tarmo Tammel ning Urmo Velvelt mängivad suure panga.

Flopi järel checkib Urmo ette, Tarmo paneb 70K ja saab calli.

Turn on , nüüd haarab ohjad juba Urmo - 160K. Tarmolt call.

River on ning Urmo panustab 275K.

Tarmo mõtleb umbes kolm minutit ja foldib lahtiselt ! Urmo ei näita. Las see jääda nüüd kõigile mõistatada, mis käsi võis ühel Eesti hinnatuimal turnaprol olla.

Kes on sihikul? Posted Saturday 29th July, 2023 at 21:36(UTC+0) by maheaaatom

Ülemisel korrusel on selgelt sihikul Tapio Aaltonen ja Tomi Arponen, mõlema stäkid on umbes 10-15XBB vahel. Tegelikult ei ole ka Phil Gross kuigi suur ning Anatoly Filatovgi on oma stäkist suure osa kaotanud.

Laua (ja turniiri) liider Mikael Johannes Haapaniemi mängib väga rahulikult, märksa aktiivsemad on laua suuruselt teine ja kolmas stäkk - Tarmo Tammel ja Urmo Velvelt. Aga lahendust pole siiani veel tulnud.

Grossi bluff ei lähe läbi Posted Saturday 29th July, 2023 at 21:30(UTC+0) by maheaaatom

Tarmo Tammelil õnnestub Phil Grossilt natuke nuppe saada.

Turniks on lauas ning pangas umbes 150K. Tarmo checkib ette, Phil teeb 100K panuse.

River checkitakse läbi. Tarmo näitab "kolme paari" - , Philil pole aga ässa, viite ega üldse midagi...

Urmole natuke lisa Posted Saturday 29th July, 2023 at 21:21(UTC+0) by maheaaatom

Urmo avab EP-lt 60K tõstega, Anatoly Filatov lükkab BB-lt 250K juurde.

Urmolt seepeale võrdlemisi kiire all-in ning ka Anatoly ei jää pikalt mõtlema - fold. Jälle, veerand stäkist justkui maast leitud!

Player		Chips	Progress
Urmo Velvelt		1,300,000	215,000

See turbo on ikka tõsine turbo! Posted Saturday 29th July, 2023 at 21:11(UTC+0) by maheaaatom

Turbokal osalev põhiturniiri 23. mees Herli Olop käib rääkimas, et 150 € turbokas on täiesti kreisi mäng. "10-minutilised levelid, mõtle ise," nerab Herli.

Ta heidab pilgu peale ka põhiturniiri poolfinaallauale ning poetab kiidusõna sakslase Phil Grossi suunas. "See on väga lahe tüüp! Vahel paneb ikka täiega hullu."

Eestlannadele kolmas ja neljas koht Posted Saturday 29th July, 2023 at 21:03(UTC+0) by maheaaatom

Queens of Tallinnal on käimas heads-up leedulanna ja austerlanna vahel.

Helina Tamm oli neljas ning Evely Pihela sai tunda siirast rõõmu kolmanda koha üle.

Jätkame, eestlaste stäkid on järgmised Posted Saturday 29th July, 2023 at 21:01(UTC+0) by maheaaatom

Mikael Johannes Haapaniemi on endiselt chipliider (3,11 miljonit), eestlased on järjest kohtadel 4-7.

Super High-Roller Anatoly Filatov, keda võib ka natuke eestlaseks lugeda, on umbes 2M peal. Tõsi esimese pausijärgse kaega jäi ta umbes veerandist oma stäkist ilma, andes valusa duubli vs. (river poiss).

Player	Chips	Progress
Mikael Johannes Haapaniemi	3,110,000	330,000
Magnus Pukk	1,745,000	1,145,000
Ilya Nikiforov	1,555,000	55,000
Tarmo Tammel	1,490,000	185,000
Urmo Velvelt	1,085,000	365,000

Hiinakas läbi Posted Saturday 29th July, 2023 at 20:33(UTC+0) by maheaaatom

Keskpäeval alanud hiinakas on lõppenud, võidu sai nimekas soomlane Risto Olavi Pönniö. 54 sisseostu, auhinnafond ligi 16 000 eurot.

OlyBet Mystery Bounty Kings on jõudnud 59 parimani (tehti 229 sisseostu), Soome Stud aga kuue finalistini (20 osalejat, ei ühtegi eestlast). NLH Turbo on siiani tõmmanud laudadesse 58 sisseostu. 555 €PLO 4/5 Card Progressive Bounty on märksa popim, sisseoste juba 131 (umbes pooled mängijad sees).

Põhiturniiri TV-lauas veel üks langeja - Feras Michael Badir Abid. Järel kuraditosin parimat. Pärast seda läks põhiturniir taas pausile, seekord 20 minutiks.

Naistekal TOP4 Posted Saturday 29th July, 2023 at 20:28(UTC+0) by maheaaatom

Queens of Tallinn on jõudnud tõenäoliselt viimase pausini ning hetkel on mängus neli kangelannat. Neist kaks on eestlased (Evely Pihela ja Helina Tamm), teised kaks aga väliskülalised.

Viienda koha, mis oli muuseas ka rahakoht, sai Mari-Liis Joa.

Urmo annab pisikesele stäkile duubli Posted Saturday 29th July, 2023 at 20:18(UTC+0) by maheaaatom

Ei midagi hullu, Phil Grossi stäkk oli vaid 4XBB.

Sakslane läks sisse -ga, Urmol oli . Flopis said mõlemad pihta (Urmo ässale ja Gross kuuele), kuid river tõi võidu shortstackile. Oh seda rõõmu, naeris ka Urmo.

16. koht - Siim Suviste 4500 € Posted Saturday 29th July, 2023 at 20:16(UTC+0) by maheaaatom

Siim langes TV-lauast, seega on meil tema viimase jaotuse kulg teadmata.

Vähemal õnnestus mehel üks money-jump üle elada ning tasuka 4500 eurot.

14 parima seas (väljas ka viimane leedulane, Karolis Kutkauskas) on neli Eesti mängijat.

Eestlased heas seisus Posted Saturday 29th July, 2023 at 20:12(UTC+0) by maheaaatom

Turniri chipliider on küll Mikael Johannes Haapaniemi (2,78M), kuid kolm eestlast on kohtadel 4-6: alumisel korrusel meheteguseid teinud Tarmo Tammel 1675000 ning üleval säranud Ilya Nikiforov, 1610000 ja Urmo Velvelt 1450000.

Magnusel on 600K ja Siimul 460K.

Ülemisel korrusel nüüd Tarmo ja Urmo, ülejäänud kolm mängivad TV-lauas.

Player	Chips	Progress
Tarmo Tammel	1,675,000	1,355,000
Ilya Nikiforov	1,610,000	110,000
Urmo Velvelt	1,450,000	0
Magnus Pukk	600,000	10,000
Siim Suviste	460,000	65,000

Uus re-draw Posted Saturday 29th July, 2023 at 19:56(UTC+0) by maheaaatom

Telelauast aina langeb ja langeb ning üks mees sadas ka ülemiselt korruselt. Õnneks polnud keegi neist eestlane. Tarmo Tammel, Siim Suviste, Urmo Velvelt, Ilya Nikiforov ning Magnus Pukk on kenasti mängus sees, nagu ka 11 nende konkurenti. Kokku seega 16 mängijat.

See tähendab, et viiakse läbi täiendav re-draw - üks laud jääb üles ning teine läheb telepurki. Hetkel 15-20 minutiline tehniline paus.

Ilya saab ilma actionita 320K Posted Saturday 29th July, 2023 at 19:47(UTC+0) by maheaaatom

Turniiri chipliider Mikael Johannes Haapaniemi läheb 320K tõstega Ilya blindi "sööma", kuid tema halvaks üllatuseks vastab Ilya all-in'iga.

Soomlane callimiseks jõudu ei leia, meie mehel ikkagi kobe 1,2M stäkk. Ja nüüdsest on see juba 1,5M!

Player		Chips	Progress
Ilya Nikiforov		1,500,000	300,000

19:38 (UTC+0)

Start of Level 24
Blinds: 10,000/25,000 Ante: 25,000

Algas tänane viimane turniir Posted Saturday 29th July, 2023 at 19:29(UTC+0) by maheaaatom

Alanud on tänane viimane turniir, 150 € NLH Turbo. Osalejaid on hetkel küll vaid 20, kuid seda mitte põhjusel, et mängijaid poleks, vaid kõik on juba hõivatud teiste turniiridega.

Näiteks "igamehe turniiril" Olybet Mystery Bounty Kingil on tehtud 229 sisseostu, mis on väga võimas tulemus.

Naistes jõudis just finaalini ning eriti rõõmus oli festivali hostess Evely Pihela, kel õnnestus ka üheksa väljavalitu sekka pääseda.

Eestlaste hetkeseis Posted Saturday 29th July, 2023 at 19:21(UTC+0) by maheaaatom

Player	Chips	Progress
Urmo Velvelt	1,450,000	85,000
Ilya Nikiforov	1,200,000	40,000
Magnus Pukk	610,000	350,000
Siim Suviste	395,000	360,000

21. koht - Igor Pihela noorem 3900 € Posted Saturday 29th July, 2023 at 19:15(UTC+0) by maheaaatom

Igor Pihela läks -ga blinde ründama, BB kaitses -ga.

Flopis oli äss, kuid paraku ka kaks ristit. Turn tõi risti masti kohale, siis läksid ka nupud. Ja Igor oli kahjuks juba drawing dead.

Player		Chips	Progress
Igor Pihela noorem		0	0

Naistekas läheneb finaallauale Posted Saturday 29th July, 2023 at 19:13(UTC+0) by maheaaatom

Queens of Tallinn turniiril on alles 10 parimat, seega oleme kohe finaallauas. Allesjäänute hulgas on viis eestlannat ja viis külalist. Meie lippu hoiavad kõrgel Mari-Liis Joa, Evely Pihela, Helina Tamm, Christel Haller ja Karin Ehala.

Raha jagub viiele parimale, võitja saab 1568 eurot. On mille nimel mängida küll.

Siimu stäkk saab valusa hoobi Posted Saturday 29th July, 2023 at 19:08(UTC+0) by maheaaatom

Siim Suviste ründab EP-lt 40K, laheda nimega lätlane Roberts Rumba tõstab 130K-le ning Siim vastab pika mõtlemise järel all-in'iga. Roberts callib.

Siim:

Roberts:

Diiler avab flopi, kohe esimesena kaardina näeme ässa. Aga ei, juba järgmine kaart on kuningas. Ja ülejäänud kolm kaarti ei muuda enam midagi.

Tuleb 630K välja maksta, Siimul jääb vaid ca. 230K järgi...

Player		Chips	Progress
Siim Suviste		230,000	525,000

Tempo on taas maas Posted Saturday 29th July, 2023 at 19:03(UTC+0) by maheaaatom

Pärast Herli ja Nicki langemist on mängutempo taas maha tõmmatud, kuigi ülearu ruumi just mängijatel pole (keskmine stäkk 26XBB).

21 parima seas on 6 eestlast, kellest telelauas endiselt Tarmo Tammel. Ülejäänud mehed on ülemisel korrusel ning neil saame vahetult silma peal hoida.

23. koht - Herli Olop 3900 € Posted Saturday 29th July, 2023 at 18:31(UTC+0) by maheaaatom

Kahjuks kaotasime kohe 23. taseme alguses Herli Olopi. Tema ca 210K stäkk läks kahe jaotusega, mõlemad mündivisked. Esimeses oli Herlil vs. ). Turnis poiss.

80K jäi järgi (3XBB), millega ei õnnestunud mängu tagasi tulla. Viimased chipid läksid -ga vastu, juba flopis emand.

Herli sihid olid kohe kindlasti kõrgemal...

P.S. Kohe Herli järel langes ka Nick Martijn Penning, kes alustas 23. taset kõigest 10K punktiga. Seega hetkel 21 parimat järgi.

Player		Chips	Progress
Herli Olop		0	0
Nick Martijn Penning		0	0

18:28 (UTC+0)

Start of Level 23
Blinds: 10,000/20,000 Ante: 20,000

Õhtusöögi paus Posted Saturday 29th July, 2023 at 17:21(UTC+0) by maheaaatom

Algas 60-minutiline õhtusöögipaus ning lühipuhkusele läheb ka meie live-ülekanne.

Põhiturniiril jätkab endiselt 23 mängijat. Viimasel käel mängiti kahe välismaalase vahel küll üle pika aja ka all-in jaotus, kus läksid vastamisi ässad ja kuningad. Laud aga midagi ei muutnud ning ässade omanikust shortstack võttis vajaliku duubli.

Pausi jooksul paneme kirja ka kõikide allesjäänud mängijate (nii eestlased kui teised) täpse chippide seisu.

Magnus kõrvetab Igorit Posted Saturday 29th July, 2023 at 17:07(UTC+0) by maheaaatom

Magnus Pukk ja Igor Pihela mängivad omavahel võrdlemisi suure pangaga käe.

Pärast floppi on lauas juba ligi 400K.

Turn lisab intriigi. See checkitakse küll viisakalt läbi.

Riveri järel checkib Igor taas ning Magnus haistab võimalust - all'in! Igor ei calli.

Urmo Herlit ei hellita Posted Saturday 29th July, 2023 at 16:59(UTC+0) by maheaaatom

Urmo Velvelt ja Herli Olop mängivad omavahel jaotuse, mis vältab terve igaviku.

Urmo alustab MP-lt tavapärase 30K panusega ning Herli kaitseb oma BB-d.

Flop on , Herli checkib ette, Urmo paneb 25K ja saab calli.

Turni järel kordub sama, seekord on ainult panused juba 25K.

Riveri üritab hoopis Herli initsiatiivi haarata, tehes omakorda 45K panuse.

Urmo mõtleb kaua, küsib Herli stäkki ja lükkab seejärel all-in. Herli viskab koheselt lauale lõhkiläinud kahepoolse reatõmbe ().

Siim kaotab ässadele Posted Saturday 29th July, 2023 at 16:48(UTC+0) by maheaaatom

Siim Suviste kolmpanuse järel vaadatakse koos Tomi Arponeniga floppi . Soomlane checkib ette, Siim paneb 60K ja saab calli.

Turn on ning siin aetakse ka nupud sisse. Ega soomlasel polegi rohkem kui 152K, Siimul seevastu umbes 900K nupukuhi.

Tomi:

Siim:

River midagi ei muuda.

Player		Chips	Progress
Siim Suviste		750,000	280,000

Igor annab duubli Posted Saturday 29th July, 2023 at 16:40(UTC+0) by maheaaatom

Eestis elav soomlane Tapio Aaltonen avab 30K-ga, Igor tõstab üle 105K-le ning soomlane vastab 263K all-in'iga. Igor callib.

Tapio:

Igor:

Lauda poiss ning Igor kaotab umbes veerandi oma stäkist. Üks langeja on vahepeal ka (Hendrik Paul L. Diegenant) ning me jätkame 23-kesi.

Player		Chips	Progress
Igor Pihela noorem		750,000	210,000

Eestlaste stäkid Posted Saturday 29th July, 2023 at 16:31(UTC+0) by maheaaatom

Player	Chips	Progress
Ilya Nikiforov	1,200,000	200,000
Urmo Velvelt	1,080,000	300,000
Siim Suviste	1,030,000	20,000
Igor Pihela noorem	960,000	310,000
Magnus Pukk	620,000	270,000
Herli Olop	480,000	180,000

Re-draw läbi, mäng jätkub Posted Saturday 29th July, 2023 at 16:28(UTC+0) by maheaaatom

Umbes veerand tundi väldanud tehnilise paus sai läbi ning kaardid on taas õhus.

Telepurki läks Tarmo Tammel, kõik ülejäänud 6 Eesti mängijat jätkavad ülemisel korrusel.

16:08 (UTC+0)

Start of Level 22
Blinds: 10,000/15,000 Ante: 15,000

Igor elimineerib ministäki Posted Saturday 29th July, 2023 at 16:07(UTC+0) by maheaaatom

Igor karistab mikrostäkiga keskele liikunud Touko Teivonpoika Berndtsoni, callides tema ilusa tõmbekäe () ära . Pihta saavad mõlemad, Igori paar on aga suurem. Tema stäkk nüüd pea miljon.

Hetkel viiakse läbi re-draw. Ülemine korrus jätkab nüüd kahel laual, lisaks ka kasiinos mängitav telelaud.

Player		Chips	Progress
Igor Pihela noorem		980,000	330,000

Kiirpõige teistele turniiridele Posted Saturday 29th July, 2023 at 15:46(UTC+0) by maheaaatom

Naistekale on tehtud 34 sisseostu, mida on natuke vähem kui oodatud, kuid liitumine on veel avatud.

"Täitsa hea turniir on, 20K algstäkk. Palju parem mängida kui nendel, kus anti ainult 10K või 15K," kiidab näiteks selle formaadi valitsejanna Catlin Müür.

Just alanud Finnish 5 Card Stud toimub hetkel vaid kahel laual, kuid küllap lisandub uusi mängijaid peagi. Käima on läinud ka 150-eurone Mystery Bounty, kus on aga kirjas juba üle 100 osaleja. Samuti paistab üsna menukas olevat hiinakas (mis algas juba keskpäeval) - osalejaid üle 50.

"Suurel" Mystery Bountyl on alles 8 parimat ning mängus juba päris kopsakad auhinnarahad. Kogu turniiri auhinnafond on üle 56 000 euro!

Urmo kaotab umbes viiendiku stäkist Posted Saturday 29th July, 2023 at 15:31(UTC+0) by maheaaatom

Urmo Velvelt üritab Nick Penningu vastu positsiooni omades panka kätte saada, rünnates viimast nii pärast floppi kui ka turni ja riverit . Kahel viimasel tänaval on panused mõlemad korral 80K, vastane check-callib kõikidel kordadel.

Urmo avab , vastas on flopis saadud kahepoolne reatõmme , mis turnis paariks täieneb.

Urmol umbes 780K järgi.

Player	Chips	Progress
Siim Suviste	1,050,000	400,000
Ilya Nikiforov	1,000,000	550,000
Urmo Velvelt	780,000	130,000
Tarmo Tammel	320,000	20,000

Igor sai mäele, Siimul oli kõvasti õnne Posted Saturday 29th July, 2023 at 15:18(UTC+0) by maheaaatom

Igor Pihela noorem võitis just üliolulise flipi -ga vastu ning duubeldas oma stäki umbes 650K-le.

Pisut varem võitis väga suure käe ka Siim Suviste, kel oli - mis seal salata - ka roppu moodi õnne. Nimelt suutis ta PFAI käes oma -ga saada jagu nii -st kui -st, tabades flopis 1-outer poissi.

Player		Chips	Progress
Igor Pihela noorem		650,000	350,000

Nüüd ainult mehed Posted Saturday 29th July, 2023 at 15:14(UTC+0) by maheaaatom

Soomlanna Anna-Mari Hursti langemise järel (28. koht) jätkavad põhiturniiri ainult mehed.

Rahadesse jõudis täpselt kolm naist, lisaks Anna-Marile ja Jaana Kindsigole ka Hyunsil Park.

Herli ja Magnuse muljeid Posted Saturday 29th July, 2023 at 15:03(UTC+0) by maheaaatom

Telelaud jätkab ka pärast pausi samas koosseisus ning peamiseks põhjuseks on üks mees - Juho Heiska, kes mängib ülimalt loose-agressive mängu.

Üsna hästi jooksnud Juhol on muide ka turniiri suurim stäkk ning seetõttu paistab Herli ja Magnuse strateegia olema lihtne - tuleb oodata oma kohta ning üritada seisu parandada. Aga õnneks on mõlemal kõvasti mänguruumi ning mõlema sihiks mõistagi finaallaud.

14:59 (UTC+0)

Start of Level 21
Blinds: 7,000/14,000 Ante: 14,000

Teine paus Posted Saturday 29th July, 2023 at 14:40(UTC+0) by maheaaatom

Puhkama läheb 29 mängijat. Kõik 7 eestlast on kenasti mängus.

Oleme tagasi 15 minuti pärast.

Urmo annab shordile duubli Posted Saturday 29th July, 2023 at 14:27(UTC+0) by maheaaatom

Nick Martijn Penning avab 25K-ga, Urmo tõstab 75K üle. Nick paneb seejärel oma 186K stäki keskele ning Urmo callib kiirelt.

Nick:

Urmo:

Ässad peavad vastu. Endiselt 31 parimat mängus.

Player		Chips	Progress
Urmo Velvelt		910,000	190,000

Urmole veel lisa Posted Saturday 29th July, 2023 at 14:19(UTC+0) by maheaaatom

Urmo on tõusnud üle maagilise miljoni, tema stäkk hetkel 1,1M. Rohkem on vaid lätlasel Vlads Dolgilevicsis (ca. 1,3M).

Urmo on Eesti live-rahalistis küll alles 81. kohal, kuid selgelt on tegemist siiski online-proga. Tema kontos on näiteks nii WSOP Circuiti võit kui WSOP Online põhiturniiril saavutatud ülikõrge neljas koht.

Player		Chips	Progress
Vlads Dolgilevics		1,300,000	626,000
Urmo Velvelt		1,100,000	200,000

Eestlaste stäkid Posted Saturday 29th July, 2023 at 14:08(UTC+0) by maheaaatom

Player	Chips	Progress
Urmo Velvelt	900,000	130,000
Siim Suviste	650,000	80,000
Ilya Nikiforov	450,000	60,000
Igor Pihela noorem	300,000	120,000
Tarmo Tammel	300,000	110,000

34 parimat Posted Saturday 29th July, 2023 at 13:57(UTC+0) by maheaaatom

Põhiturniiril on alles 34 parimat ning kordame veelkord üle, et täna on plaanis mängida kas kuni finaallauani või (kui selleni ei jõuta), siis umbes kella kaheni, et finalistid saaksid ka väheke puhata.

Naistekas kogub samuti hoogu, juba on kohal alati särtsakad Kristi Kirs, Catlin Müür, Kati Pruel jt., seega igav sealsetel osalejatel kindlasti ei ole. Nii naisteka kui High-Rolleriga saab liituda kaheksanda taseme lõpuni. Naistekal vältavad tasemed 20, High-Rolleril 30 minutit.

Siim vajutab gaasi Posted Saturday 29th July, 2023 at 13:48(UTC+0) by maheaaatom

Viimased kaks kätt EP-lt võitnud Siim Suviste paistab silma võrdlemisi agressiivse mänguga ega ole kohkunud ka all-in lükkeid tegemast.

Mees on selgelt laua agressoriks, kuigi suurim stäkk on endiselt Urmo Velvelti käes. Ja Urmo on Siimu suhtes pigem soodsal positsioonil.

13:43 (UTC+0)

Start of Level 20
Blinds: 6,000/12,000 Ante: 12,000

Ülemise korruse eestlaste stäkid Posted Saturday 29th July, 2023 at 13:37(UTC+0) by maheaaatom

Telelauas on kaks meie mängijat - Magnus Pukk ning (jälle) Herli Olop. Kokku on mängus seitse Eesti pokkerisportlast. Ülemisel korrusel on oluliselt paranenud Tarmo Tammeli seis, kuid ka Urmo Velvelt on oma niigi suurt stäkk veel omajagu suurendanud.

Player	Chips	Progress
Urmo Velvelt	770,000	250,000
Siim Suviste	570,000	50,000
Ilya Nikiforov	510,000	30,000
Tarmo Tammel	410,000	210,000
Igor Pihela noorem	180,000	170,000

38. koht - Jaana Kindsigo 3000 € Posted Saturday 29th July, 2023 at 13:29(UTC+0) by maheaaatom

Jaana jookseb oma pocket kolmedega Edgars Beizaksi otsa.

Flop annab vastasele tõmbeid juurde, turn on aga Jaanale niivõrd halb, et ta on hoobilt drawing dead. River ebaoluline .

Jaana on küll turniiri parim Eesti naine, kuid mitte edukaim naine kokkuvõttes. Soomlanna Anna-Mari Hursti on endiselt sees ning tema stäkk on päris korralik.

Player		Chips	Progress
Jaana Kindsigo		0	0

Päevad pole vennad Posted Saturday 29th July, 2023 at 13:22(UTC+0) by maheaaatom

Kolmandat päeva liidrina alustanud Juan Carlos Vecino Duenas peab leppima kõigest 39. kohaga.

Turniiri liidrid paistavad olevat Vlads Dolgilevics ja Karolis Kutkauskas, kuid väga korralikud stäkid on ka eestlastel Urmo Velveltil ja äsja mainitud Siim Suvistel.

Player		Chips	Progress
Juan Carlos Vecino Duenas		0	0

Siimule väike skalp Posted Saturday 29th July, 2023 at 13:18(UTC+0) by maheaaatom

Mikrostäkiga Samuli Hietala pushis SB-lt -ga ning sai calli BB-l olevalt Siim Suvistelt, kel olid pocket kaheksad. Siimu käsi pidas ka kenasti vastu. Tal väga korralik umbes 620K stäkk.

Player		Chips	Progress
Siim Suviste		620,000	120,000

Järgmine money-jump Posted Saturday 29th July, 2023 at 13:14(UTC+0) by maheaaatom

Vahepeal langes välja veel kaks välismaalast ning me jätkame 40-kesi. Kõik allesjäänud on endale taganud vähemalt 3000 eurot.

Käima on läinud ka 3000 € High-Roller ning 150 € naistekas. High-Rollerist valmib eraldi ülekanne, mille eest kannab hoolt "Marjakas".

45. koht Andrei Mjagkov, 46. koht Mauri Dorbek - mõlemad 2700 eurot Posted Saturday 29th July, 2023 at 13:11(UTC+0) by maheaaatom

Nii Mauril kui Andreil olid alla 10XBB stäkid ning seega ei tulnud kummagi väljalangemine ka mingi üllatusena.

Andrei viimaseks käeks jäi vs. , floppi kümme. Mauri nupud läksid -ga pocket kuute vastu.

Tegelikult kaotas Mauri oma suure stäki aga kahe eelnevatel tasemetel mängitud käega, millest esimene oli suhteliselt õnnetu, teine aga puhas cooler. Vähemalt hea, et suur osa nuppudest läks teisele eestlasele, Urmo Velveltile.

Player		Chips	Progress
Andrei Mjagkov		0	0
Mauri Dorbek		0	0

Eestlaste stäkid Posted Saturday 29th July, 2023 at 12:55(UTC+0) by maheaaatom

Telelauas on ainsa eestlasena Magnus Pukk.

Player	Chips	Progress
Urmo Velvelt	520,000	38,000
Siim Suviste	500,000	110,000
Ilya Nikiforov	480,000	222,000
Igor Pihela noorem	350,000	70,000
Magnus Pukk	350,000	30,000
Herli Olop	300,000	79,000
Jaana Kindsigo	300,000	0
Tarmo Tammel	200,000	40,000
Andrei Mjagkov	70,000	19,000

Herli alustab kiire duubliga Posted Saturday 29th July, 2023 at 12:44(UTC+0) by maheaaatom

Põhiturniir läheb edasi ning äsjane telelaua seltskond jätkab mängu ülemisel korrusel.

Kohe esimene käsi on tulus Herli Olopilt. TV-lauas langes ta küll üsna väikeseks, kuid saab kohe kiire duubli.

Dmitrijs Kornevs lükkab -ga Herlil on . Kõrgem paar peab.

Samal ajal kostab kõvasti ise ka Flip&Go turniirilt, nimelt võeti maha 5000-eurone bounty. Pole vaha 150-eurose sisseostu kohta.

12:38 (UTC+0)

Start of Level 19
Blinds: 5,000/10,000 Ante: 10,000

Algas esimene paus Posted Saturday 29th July, 2023 at 12:21(UTC+0) by maheaaatom

Väga sisukad ning haaravad esimesed kaks mängutaste on selja taga.

Kohtume põhiturniiri vaatajatega juba 15 minuti pärast.

12:20 (UTC+0)

Start of Level 18
Blinds: 0/0 Ante: 0

Maurit hammustanud Urmo eskorditi alumisele korrusele Posted Saturday 29th July, 2023 at 12:18(UTC+0) by maheaaatom

High-Roller Urmo Velvelt saadeti just telelauda, mis võimadab kõikide ülekande vaatajatel elada juba peagi kaasa tõeliselt kõrgetasemelisele Eesti mängijale.

Enne seda jõudis ta aga teha tõsiselt haiget Mauri Dorbekule. Jooksis kokku set vs. set ( vs. ning Mauril jäi kõigest umbes 100K järgi. Urmo stäkk aga juba 558K.

Player		Chips	Progress
Urmo Velvelt		558,000	198,000
Mauri Dorbek		100,000	220,000

49. koht - Keito Kaljulaid 2400 € Posted Saturday 29th July, 2023 at 12:14(UTC+0) by maheaaatom

Pokkeris palju tegusid teinud Saaremaa meeste Kaljulaidude dünastia liige Keito Kaljulaid lõpetab turniiri 49. kohaga.

Keito näitas sisukat mängu nii esimesel kui teisel päeval. 18. tasemel jäi tema stäkk küll juba alla keskmise. Hea töö ikkagi!

Player		Chips	Progress
Keito Kaljulaid		0	0

Miks sul emandaid ei olnud? Oops... Posted Saturday 29th July, 2023 at 12:11(UTC+0) by maheaaatom

11. lauas on all-in'is kaks mängijat, üks neist Jaana Kindsigo.

Mõlemad avavad ning diiler asub kaarte lauda panema.

"Miks sul kuningad on? Sul oleksid pidanud emandad olema," nokib Jaana oma vastast. Vaevalt jõuab ta oma lause lõpetada, kui diiler avab riverisse emanda.

"Oops, sul oleks võinud siis hoopis poisid olla," naerab Jaana. Mõlemad mängijad korjavad oma žetooonid tagasi.

Player		Chips	Progress
Urmo Velvelt		558,000	198,000
Mauri Dorbek		100,000	220,000

50. koht - Ranno Sootla 2400 € Posted Saturday 29th July, 2023 at 12:08(UTC+0) by maheaaatom

10-20XBB vahel virelenud Ranno Sootla ei suutnud rongi alt pääseda. Täna tasuks 50. koht, natuke abiks ikka. Vähemalt on Rannol hea võimalus ka 3000 € High-Rolleril kätt proovida (see turniir algab kell 15:00)

Oleme jõudnud 49 parimani.

Meie mängijate punktiseisud Posted Saturday 29th July, 2023 at 11:48(UTC+0) by maheaaatom

Endiselt 54 parimat konkurentsis.

Player	Chips	Progress
Siim Suviste	390,000	2,000
Urmo Velvelt	360,000	10,000
Magnus Pukk	320,000	1,000
Igor Pihela noorem	280,000	20,000
Tarmo Tammel	240,000	35,000
Keito Kaljulaid	210,000	97,000
Ranno Sootla	85,000	27,000

Mauri kaotab hiigelpanga Posted Saturday 29th July, 2023 at 11:40(UTC+0) by maheaaatom

Mauri avab EP-lt -ga, mille vastab eestlasi varemgi palju kimbutanud (muuhulgas ka eile emandatega Markku Koplimaa ässad tapnud) Vlads Dolgilevics 38K ületõstega.

Selle järel läheb all-in üks shortstack (61K) ning Mauri paneb veelgi otsa (95K), saades Vladsilt calli.

Flop on , Mauri alustab 60K panusega, lätlane vastab 150K-ga ja saab calli.

Turn on ning lätlane lükkab all-in. Mauri mõtleb pikalt, kuid foldib.

Vlads avab ! (hästi tabatud turn), shortstackil oli . Seega kokkuvõttes ikkagi õige fold. Mauril umbes 320K järgi.

Player		Chips	Progress
Mauri Dorbek		320,000	270,000

Jaana kiljub Posted Saturday 29th July, 2023 at 11:32(UTC+0) by maheaaatom

Jaana Kindsigol õnnestus oma -ga nut-rida saada ning oma stäkk duubeldada. Tal on hetkel umbes 300K, mis on umbes keskmine punktisumma.

Player		Chips	Progress
Jaana Kindsigo		300,000	168,000

Telelaud käimas Posted Saturday 29th July, 2023 at 11:30(UTC+0) by maheaaatom

Kes soovivad näha telelaua ülekannet, klõpsavad lingile https://olybet.tv/kings-of-tallinn-summer-showdown-2023-2/

Eestlastest on telelauas Herli Olop ja Andrei Mjagkov.

56. koht - Kaspar Laursoo 2400 € Posted Saturday 29th July, 2023 at 11:26(UTC+0) by maheaaatom

Esimesel päeval eestlastest parimat mängu näidanud Kaspar Laursoo vaevles pikalt kaardisurmas ega suutnud ka täna oma stäkki üles saada. Ometi, vähemalt viimases käes oli selleks hea võimalus.

Kaspar sai nupud sisse -ga ning kaasa kuulsa pokkerimiljonäri Anatoly Filatovi, kes sooritas calli enda sõnul "väga halva käega". Selleks oli , kuid jaotuse võitmiseks sellest ometi piisas. Turn poiss.

Jätkab 54 parimat.

Player		Chips	Progress
Kaspar Laursoo		0	0

57. koht - Kaido Mikk 2200 € Posted Saturday 29th July, 2023 at 11:22(UTC+0) by maheaaatom

Mulluse Coolbet Open Tallinn põhiturniiri võitja Kaido Mikk ei suutnud kogu turniiri vältel kuigi suurt stäkki saada, kuid rahadesse tulekuks oli seda ometi piisavalt.

Kahjuks ei jõudnud aga mees kõrgemale 57. kohast. Preemiaks 2200 eurot.

Player		Chips	Progress
Kaido Mikk		0	0

Ilya tõuseb Posted Saturday 29th July, 2023 at 11:19(UTC+0) by maheaaatom

Äsja maja flopanud Ilya Nikiforov on tõusnud juba 650K peale, mis on võimas avaldus.

Ilya on kõva mängumees, Eesti läbi aegade edetabeli üheksas. Tema suurimaks kordaminekuks on WSOP turboturniiri kolmas koht, kuid mullu võitis ta näiteks Kings of Tallinna High-Rolleri.

Ranno uskumatu kannatus Posted Saturday 29th July, 2023 at 11:08(UTC+0) by maheaaatom

Ranno on mänginud kogu teise päeva lõpu ning ka kolmanda alguse uskumatult kannatlikult ning väike stäkk enamat võimaldagi.

2200 eurot pole kindlasti see, mida Ranno sooviks, sest ainuüksi sisseostudele kulus tal suurem summa.

Jaana Kindsigo ongi alustanud multi-table'ima, mis pole niivõrd lihtne - tema laud 555 € turniiril asub sisuliselt saali teises otsas. Aga Jaana on käbe ning selleks ei kulu tal üle paarikümne sekundi. Jaana stäkk umbes 180K.

Igor ja Tarmo Posted Saturday 29th July, 2023 at 10:58(UTC+0) by maheaaatom

Tarmo Tammel ja Igor Pihela on justkui vennad - mõlemad on mänginud pikalt ühes lauas ning alustasid ka päeva sendi pealt sama punktisummaga (170 000).

Esimese 50 minutiga on Igor oluliselt juurde hankinud ning Tarmogi on natuke lisanööpe saanud. Igoril juba üle 300K.

Player		Chips	Progress
Igor Pihela noorem		300,000	130,000
Tarmo Tammel		205,000	35,000

Esimene money-jump Posted Saturday 29th July, 2023 at 10:51(UTC+0) by maheaaatom

Põhiturniiril on alles 61 parimat ning natuke aega tagasi toimus ka esimene money-jump, mis tagas kõikidele allesjäänutele vähemalt 200 eurot ekstrat. Õnneks vahepeal ühtegi eestlast rohkem langenud pole, meie mehi on sees kuraditosin ning naisi täpselt üks - Jaana Kindsigo.

Naised turniiripileti jahil Posted Saturday 29th July, 2023 at 10:49(UTC+0) by maheaaatom

5 garanteeritud piletiga naisteka satikal on hetkel hetkel 34 mängijat (alustas 37). Nende seas on nii mõnedki hästi tuntud tegijad nagu Christel Haller, Kristi Kirs, Katre Kokk ja Ave Lepik, kes kõik löövad igal juhul kaasa ka 150-eurosel naistekal, mis algab kell 15:00.

Mis aga kõige parem, naisteka satikal osalemine on täiesti TASUTA!

Mauri ja Urmo korjavad lisa Posted Saturday 29th July, 2023 at 10:44(UTC+0) by maheaaatom

Mauri Dorbek kaebas enne kolmanda päeva algust, et tema laud on väga raske - vastased head ning neil lisaks ka suured stäkid. Üheks vastaseks on muide Eesti high-roller Urmo Velvelt.

Hea on aga see, et mõlemad mehed on suutnud esimese poole tunni saginaga oma seisu parandada - Mauril on 590K ning Urmol 370K.

Player		Chips	Progress
Mauri Dorbek		590,000	120,000
Urmo Velvelt		370,000	119,000

Multi-Jaana Posted Saturday 29th July, 2023 at 10:39(UTC+0) by maheaaatom

Põhiturniiril ainsa Eesti naisena rahadesse jõudnud Jaana Kindsigol õnnestus pääseda ka 555 € turniiri teise päeva, seega peaks ta hetkel mängima üheaegselt kahte turniiri.

Kuigi suurt stäkki tal põhiturniiril küll paraku pole, seega proovib Jaana seda kibekiiretsi üle saada. Viimane all-in -ga vastu lõppes lõppes igatahes panga poolitamisega.

66. koht - Jargo Alaväli 2000 € Posted Saturday 29th July, 2023 at 10:27(UTC+0) by maheaaatom

Jargo Alaväli kuulus küll pikka aega turniiri liidrite sekka, kuid teise päeva lõpp ning esimese algus polnud talle sugugi armulised.

Päeva alustas mees pisut enam kui 20XBB-ga ning kõrgela tõusta kahjuks ei õnnestunud.

Player		Chips	Progress
Jargo Alaväli		0	0

69. koht - Martin Piik 2000 € Posted Saturday 29th July, 2023 at 10:24(UTC+0) by maheaaatom

Martin Piik alustas tänast turniiri 12 000 punkti ehk kahe suure blindiga. Seega polnud ka tema väljalangemises midagi üllatuslikku.

Player		Chips	Progress
Martin Piik		0	0

10:20 (UTC+0)

Start of Level 17
Blinds: 3,000/6,000 Ante: 6,000

Kolmas päev on alanud Posted Saturday 29th July, 2023 at 10:13(UTC+0) by maheaaatom

Mängijad on laudades kohal ning just pandi käima ka kolmas päev. Täna mängitakse eeldavatalt kuni finaallauani, kuid kui mäng peaks venima väga pikaks, siis on võimalik, et see peatatakse ka varem.

Samaaegselt on käimas veel naisteka satelliit (osaleda saab TASUTA!), Bounty-turniiri teine päev, Flip&Go finaal, High-Rolleri supersatikas ning ka 350-eurone hiinakas. Ühesõnaga möllu kui palju!

10:11 (UTC+0)

Day 3 of Kings of Tallinn Summer Showdown 2023 Started
Level: 16 Blinds: 2,000/5,000 Ante: 5,000

Your search results are valid for . More 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.