Kings of Tallinn - Kings of Tallinn Summer Showdown 2023 - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/4/updates'
ORDER BY `views` DESC

0.0090 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/4/updates'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0039 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'summer_showdown_main_2023'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'

0.0274 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1

0.0269 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0056 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '83'
AND `published` = 1

0.0271 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0056 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '85'
AND `published` = 1

0.0272 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0056 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '86'
AND `published` = 1

0.0271 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0054 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '90'
AND `published` = 1

0.0271 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0054 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '4'

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

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '92'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4293'
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` = '4291'
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` = '4289'
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` = '4284'
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` = '4282'
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` = '4270'
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` = '4269'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '92'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4373'
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` = '4369'
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` = '4367'
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` = '4366'
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` = '4362'
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` = '4360'
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` = '4358'
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` = '4356'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

English

Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event 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 33 Current Day 4

Blinds 100,000/200,000 Ante 200000

Entries 564 Remaining 1

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

Chip Leaders Day 4

1	Kai Lehto		17,000,000

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

1 New Update - Click to refresh

Live Updates - Day 4

Kai Lehto Wins 2023 Kings of Tallinn Summer Showdown Posted Sunday 30th July, 2023 at 18:08(UTC+0) by Jason Glatzer

After four long days, Finland's Kai Lehto defeated Phil Gross heads-up to win the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event for €108,260.

A recap will be published on the OlyBetEvents.com news section early on Monday. Here is a look at all of the final table payouts:

Place	Player	Country	Prize
1	Kai Lehto	Finland	€108,260
2	Phil Gross	Germany	€72,700
3	Urmo Velvelt	Estonia	€49,300
4	Ville Keranen	Finland	€34,900
5	Tarmo Tammel	Estonia	€25,600
6	Mikael Haapaniemi	Finland	€19,300
7	Tomi Arponen	Finland	€13,400
8	Magnus Pukk	Estonia	€10,100
9	Jakob Linden	Sweden	€7,700

Phil Gross Eliminated in 2nd Place (€72,700) Posted Sunday 30th July, 2023 at 18:06(UTC+0) by Jason Glatzer

Level 33: 100,000/200,000 (200,000)
Entries: 2/564

Phil Gross (pictured above) opened the button with for 400,000. Kai Lehto defended his big blind with to see the flop. Lehto checked and Gross continued with 300,000 with his top pair.

The turn didn't help or hurt either player. Gross bet 500,000 and Lehto check-called. Fireworks erupted after the pair the board on the river to push Lehto ahead with trip sixes.

Lehto checked one last time. Gross bet 1,300,000. Lehto went into the tank before he jammed. Gross called off for 5.1 million only to get the bad news.

Congrats to Kai Lehto for winning the 2023 Kings of Tallinn €1,100 Main Event for €108,260 and well played to Phil Gross who banked €72,700 for his efforts.

The recap of this event will be published at OlyBetEvents.com.

Player		Chips	Progress
Kai Lehto		17,000,000	8,400,000
Phil Gross		0	0

Gross Doubles With Ace-Nine Suited Posted Sunday 30th July, 2023 at 17:46(UTC+0) by Jason Glatzer

Level 33: 100,000/200,000 (200,000)
Entries: 2/564

Kai Lehto limped from the small blind. Phil Gross quickly jammed for 4.1 million. Lehto asked for a count before calling a minute later.

Phil Gross:
Kai Lehto:

Gross was ahead, but Lehto had two live cards. Both players bricked the . Gross doubled up with ace-high and the stacks were fairly even after the hand.

Player		Chips	Progress
Kai Lehto		8,600,000	2,300,000
Phil Gross		8,400,000	2,400,000

KoT Summer Showdown €3,000 High Roller Winner Juan Duenas Interview Posted Sunday 30th July, 2023 at 17:33(UTC+0) by Jason Glatzer

17:23 (UTC+0)

Start of Level 33
Blinds: 100,000/200,000 Ante: 200,000

Better Pair for Gross Posted Sunday 30th July, 2023 at 17:23(UTC+0) by Jason Glatzer

Level 32: 75,000/150,000 (150,000)
Entries: 2/564

Kai Lehto opened for a min-raise with from the button. Phil Gross defended his big blind with before improving to top pair on the flop.

Gross check-called a bet of 200,000 by Lehto. The river improved Lehto to an inferior pair. Gross checked and Lehto bet 575,000. Gross called and won the pot just before the blind level increased.

Player		Chips	Progress
Kai Lehto		10,900,000	900,000
Phil Gross		6,000,000	900,000

Gross Doubles With Snowmen Posted Sunday 30th July, 2023 at 16:53(UTC+0) by Jason Glatzer

Level 32: 75,000/150,000 (150,000)
Entries: 2/564

Phil Gross (pictured below) opened the button with a min-raise and was called by Kai Lehto from the big blind.

Gross continued for 300,000 on the flop. Lehto jammed and Gross called off for his stack of 2,200,000.

Phil Gross:
Kai Lehto:

It was a coin flip with Lehto holding top pair and Gross with tons of draws. The spiked the turn to improve Gross to a set and doubled his stack after the river completed the board.

Player		Chips	Progress
Kai Lehto		11,800,000	2,000,000
Phil Gross		5,100,000	2,000,000

Lehto Takes the Lead Posted Sunday 30th July, 2023 at 16:44(UTC+0) by Jason Glatzer

Level 32: 75,000/150,000 (150,000)
Entries: 2/564

Phil Gross opened for 375,000 from the button. Kai Lehto three-bet to 1,125,000 and Gross called.

Pandemonium took place after the came on the flop. Lehto continued for 600,000. Gross jammed and Lehto called off for 5,700,000.

Kai Lehto:
Phil Gross:

Lehto was ahead after pairing up his king but had to fade the flush draw and back door outs held by Gross.

Gross bricked the turn and river for Lehto to take a massive heads-up chip lead.

Player		Chips	Progress
Kai Lehto		13,800,000	6,600,000
Phil Gross		3,100,000	6,600,000

Lehto on the Comeback Trail Posted Sunday 30th July, 2023 at 16:33(UTC+0) by Jason Glatzer

Level 32: 75,000/150,000 (150,000)
Entries: 2/564

Phil Gross opened the button with a min-raise with before Kai Lehto defended his big blind with

Lehto improved to two pair on the flop and check-called a bet of 300,000 by Gross. Another check-call came by Lehto. This time it was for 500,000 after the turn, which improved Gross to an inferior two pair.

The river was checked down and Lehto narrowed the gap on Gross's chip lead.

Player		Chips	Progress
Phil Gross		9,700,000	2,900,000
Kai Lehto		7,200,000	2,875,000

16:24 (UTC+0)

Start of Level 32
Blinds: 75,000/150,000 Ante: 150,000

Urmo Velvelt Eliminated in 3rd Place (€49,300) Posted Sunday 30th July, 2023 at 16:00(UTC+0) by Jason Glatzer

Level 31: 50,000/125,000 (125,000)
Entries: 2/564

Phil Gross won a handful of smaller pots against Urmo Velvelt to extend his lead before he open-jammed the button. Velvet called off his stack of 1.9 million and it was a coin flip for Velvelt's tournament life.

Urmo Velvelt:
Phil Gross:

Velvelt was ahead after the flop and pulled even further ahead after the . Fortunes changed on the river as Gross improved to a better pair to eliminate Velvelt in third place for €49,300.

Meanwhile, Gross entered the heads-up action with triple the stack of Kai Lehto. Both players locked up €72,700 and unless a deal is made will be playing for the €108,260 top prize and, of course, the coveted Kings of Tallinn Summer Showdown Main Event trophy.

Players went on a short break after the hand.

Player	Chips	Progress
Phil Gross	12,600,000	6,500,000
Kai Lehto	4,325,000	775,000
Urmo Velvelt	0	0

Gross Takes the Lead Posted Sunday 30th July, 2023 at 15:48(UTC+0) by Jason Glatzer

Level 31: 50,000/125,000 (125,000)
Entries: 3/564

Phil Gross (pictured below) just took the chip lead for the first time on the final day of the Main Event.

It was a limped pot with Lehto leading out with for 150,000 on the flop. Gross with called with bottom pair. Lehto continued his aggression with a bet of 400,000 on the turn. Gross opted to call again and improved to a flush on the river.

Kai bet nearly the pot with a bet of 1,300,000. Gross asked for the pot to be spread and stared at his opponent for a couple of minutes. Gross eventually jammed and won a big pot after Lehto folded.

Player	Chips	Progress
Phil Gross	6,100,000	1,300,000
Urmo Velvelt	5,100,000	200,000
Kai Lehto	5,100,000	2,100,000

Interview With Fifth Place Finisher Tarmo Tammel Posted Sunday 30th July, 2023 at 15:34(UTC+0) by Jason Glatzer

Earlier this week, Kings of Tallinn Summer Showdown presenter Evely Pihela interviewed the local legend and fifth-place finisher in the 2023 KoT Summer Showdown Main Event Tarmo Tammel. Check out the interview below:

Final Table Payouts Posted Sunday 30th July, 2023 at 15:32(UTC+0) by Jason Glatzer

Place	Player	Country	Prize
1			€108,260
2			€72,700
3			€49,300
4	Ville Keranen	Finland	€34,900
5	Tarmo Tammel	Estonia	€25,600
6	Mikael Haapaniemi	Finland	€19,300
7	Tomi Arponen	Finland	€13,400
8	Magnus Pukk	Estonia	€10,100
9	Jakob Linden	Sweden	€7,700

Ville Keranen Eliminated in 4th Place (€34,900) Posted Sunday 30th July, 2023 at 15:30(UTC+0) by Jason Glatzer

Level 31: 50,000/125,000 (125,000)
Entries: 3/564

Ville Keranen (pictured below) won several flips but he was unable to win the following hand to hit the rail while he was ahead.

Kai Lehto opened for 250,000 from under the gun. Keranen three-bet shoved for 2,300,000 from the small blind. Lehto went into the tank before he found a call.

Ville Keranen:
Kai Lehto:

Keranen had Lehto dominated but sometimes the underdog wins. That is exactly what happened with Lehto winning a big pot while also eliminating Keranen after the .

Congrats to Keranen for an amazing run. Despite missing out on the podium he has plenty of reasons to celebrate with fourth place awarding €34,900.

Player	Chips	Progress
Kai Lehto	7,200,000	2,300,000
Urmo Velvelt	4,900,000	300,000
Phil Gross	4,800,000	1,200,000
Ville Keranen	0	0

15:22 (UTC+0)

Start of Level 31
Blinds: 50,000/125,000 Ante: 125,000

Another Double for Keranen Posted Sunday 30th July, 2023 at 15:12(UTC+0) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 4/564

Urmo Velvelt opened for 200,000 from under the gun. Phil Gross called with from the small blind before Ville Keranen three-bet shoved for 1,800,000 from the big blind. Velvelt went into the tank for a couple of minutes before eventually calling. Gross wasted no time in tossing away his suited rags and we were off to the races with Keranen at risk.

Ville Keranen:
Urmo Velvelt:

The flop pushed Keranen ahead. The turn further improved Keranen to trips and he earned a double-up after the river completed the board.

Meanwhile, Kai Lehto was pushed back into the chip lead by default and all four players are just a dozen big blinds apart in what is now a tightly-grouped final four.

Player	Chips	Progress
Kai Lehto	4,900,000	600,000
Urmo Velvelt	4,600,000	900,000
Ville Keranen	3,800,000	1,100,000
Phil Gross	3,600,000	600,000

Kicker Issues for Velvelt Posted Sunday 30th July, 2023 at 14:59(UTC+0) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 4/564

Urmo Velvelt opened for a min-raise from under the gun with and was called by Kai Lehto called from the button with .

Both players improved to top pair on the flop with Velvelt having some kicker issues. Velvelt led out for 300,000 and Lehto called.

Velvelt checked the turn. Lehto bet 825,000 and got a call. Both players checked the river and Lehto won a big pot to close the gap to under a big blind between him and Velvelt for the chip lead.

Player		Chips	Progress
Kai Lehto		5,500,000	1,100,000
Urmo Velvelt		5,500,000	300,000

Tarmo Tammel Eliminated in 5th Place (€25,600) Posted Sunday 30th July, 2023 at 14:26(UTC+0) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 4/564

Kai Lehto opened from the cutoff for 200,000. Phil Gross three-bet the button to 500,000. Tarmo Tammel (pictured below) four-bet shoved for 1,200,000 from the small blind. Lehto folded and Gross called.

Phil Gross:
Tarmo Tammel:

Tammel was in amazing shape. At least so we thought. Tarmo remained ahead after the flop and was still ahead after the turn. However, the turn did provide more outs to Gross with a seven completing a straight. The straight draw was completed after the river completed the board for Tammel to hit the rail on a bad beat in fifth place for €25,600.

Player	Chips	Progress
Kai Lehto	4,400,000	600,000
Phil Gross	4,200,000	1,300,000
Tarmo Tammel	0	0

Lehto Chips Up With Two Pair Posted Sunday 30th July, 2023 at 14:05(UTC+0) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 5/564

Phil Gross min-raised from under the gun with and was called by both Urmo Velvelt with and Kai Lehto with from the blinds.

Velvelt checked with his overpair on the flop before Lehto fired in a bet of 225,000 with his bottom pair. Gross called with his overcards and gutshot straight draw and Velvelt opted to call as well.

The turn would have completed a flush draw if either of the three players had three clubs. This card also improved Lehto with two pair. Velvelt checked again before Lehto bet 450,000. Gross snap-folded and Velvelt went into the tank before he opted to give up on his hand.

Player	Chips	Progress
Urmo Velvelt	5,800,000	700,000
Kai Lehto	3,800,000	700,000
Phil Gross	2,900,000	400,000

13:58 (UTC+0)

Start of Level 30
Blinds: 50,000/100,000 Ante: 100,000

Tammel Doubles Through Gross Before Break Posted Sunday 30th July, 2023 at 13:38(UTC+0) by Jason Glatzer

Level 29: 40,000/80,000 (80,000)
Entries: 5/564

Phil Gross opened for a min-raise from the button before Tarmo Tammel jammed for 620,000 from the small blind. Gross called and the cards were turned over.

Tarmo Tammel:
Phil Gross:

Tammel was behind and at risk of hitting the rail in fifth place. But he nailed his three on the flop and doubled his stack with two pair after the ran out on the board.

The final five players are on their first break at the final table. Blinds will increase to 50,000/100,000 with a 100,000 big blind ante when the action resumes.

Player	Chips	Progress
Urmo Velvelt	6,500,000	1,000,000
Phil Gross	3,300,000	300,000
Kai Lehto	3,100,000	0
Ville Keranen	2,700,000	1,300,000
Tarmo Tammel	1,400,000	420,000

Updated Final Table Payouts Posted Sunday 30th July, 2023 at 13:29(UTC+0) by Jason Glatzer

Place	Player	Country	Prize
1			€108,260
2			€72,700
3			€49,300
4			€34,900
5			€25,600
6	Mikael Haapaniemi	Finland	€19,300
7	Tomi Arponen	Finland	€13,400
8	Magnus Pukk	Estonia	€10,100
9	Jakob Linden	Sweden	€7,700

Mikael Haapaniemi Eliminated in 6th Place (€19,300) Posted Sunday 30th July, 2023 at 13:25(UTC+0) by Jason Glatzer

Level 29: 40,000/80,000 (80,000)
Entries: 5/564

Urmo Velvelt opened for 175,000 with from under the gun. Phil Gross called from the cutoff before Mikael Haapaniemi three-bet jammed for 1,400,000. Velvelt snap-folded and Gross went into the tank for a few minutes before he found a call.

Mikael Haapaniemi:
Phil Gross:

Gross got rewarded for the gutsy call after his jack paired on the runout to win the hand and effectively double.

Haapaniemi proved yesterday that he knows how to play a big stack but we will unfortunately not get the chance to see that on display at the final table after losing the flip for his tournament life. Congrats to Haapaniemi for his sixth-place finish for €19,300 and his solid poker throughout the event. Happaniemi had a series to be proud of and will have a trophy to bring home after previously winning Event #25: €250 NLH/PLO/PLO5 for €6,110.

Player	Chips	Progress
Urmo Velvelt	5,500,000	100,000
Phil Gross	3,600,000	1,500,000
Mikael Haapaniemi	0	0

Tammel Runs Big Slick Into Velvelt's Rockets Posted Sunday 30th July, 2023 at 13:08(UTC+0) by Jason Glatzer

Level 29: 40,000/80,000 (80,000)
Entries: 6/564

Phil Gross opened for 175,000 from the hijack with . Tarmo Tammel three-bet to 555,000 with . Online poker superstar Urmo Velvelt (pictured below) woke up with from the big blind and jammed for 2,600,000.

Gross snap-folded and Tammel went into the tank before he called in a sick cooler of a hand.

The flop would have improved Gross to two pair if he stuck around. Of course, it was an easy fold. Meanwhile, Tammel had thin hope with a back door flush draw. The back door opened to a front door on the turn to give both Velvelt and Tammel a sweat.

However, the blank completed the board to double Velvelt into the chip lead after winning the biggest pot thus far in the Main Event and kill Tammel's early momentum. While Tammel took the cooler in stride, it was the charismatic Gross appeared to be upset he couldn't find a way to realize his equity in this hand.

Player	Chips	Progress
Urmo Velvelt	5,400,000	2,900,000
Phil Gross	2,100,000	300,000
Tarmo Tammel	980,000	2,620,000

Updated Final Table Payouts Posted Sunday 30th July, 2023 at 12:59(UTC+0) by Jason Glatzer

Place	Player	Country	Prize
1			€108,260
2			€72,700
3			€49,300
4			€34,900
5			€25,600
6			€19,300
7	Tomi Arponen	Finland	€13,400
8	Magnus Pukk	Estonia	€10,100
9	Jakob Linden	Sweden	€7,700

Tomi Arponen Eliminated in 7th Place (€13,400) Posted Sunday 30th July, 2023 at 12:57(UTC+0) by Jason Glatzer

Level 29: 40,000/80,000 (80,000)
Entries: 6/564

Tomi Arponen (pictured below) jammed his short stack of 965,000 from under the gun. A bunch of players quickly folded before the action paused on Tarmo Tammel. A minute later Tammel folded and it was a heads-up showdown with Arponen at risk after Ville Keranen folded from the big blind.

Tomi Arponen:
Tarmo Tammel:

Arponen was in for a world of hurt and was drawing to a chop after the flop. Arponen's fate was sealed after he was drawing dead on the turn and was officially eliminated by Tammel in seventh place for €13,400 after the river completed the board.

Player		Chips	Progress
Tarmo Tammel		3,600,000	1,000,000
Tomi Arponen		0	0

12:52 (UTC+0)

Start of Level 29
Blinds: 40,000/80,000 Ante: 80,000

Updated Final Table Payouts Posted Sunday 30th July, 2023 at 12:50(UTC+0) by Jason Glatzer

Place	Player	Country	Prize
1			€108,260
2			€72,700
3			€49,300
4			€34,900
5			€25,600
6			€19,300
7			€13,400
8	Magnus Pukk	Estonia	€10,100
9	Jakob Linden	Sweden	€7,700

Magnus Pukk Eliminated in 8th Place (€10,100) Posted Sunday 30th July, 2023 at 12:49(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 7/564

Magnus Pukk (pictured below) opened with a min-raise with from early position and was called by Ville Keranen with from one seat over.

The flop hit both players hard. Pukk improved to top two pair but was far behind the bottom set held by Keranen. Pukk checked. Keranen jammed for 1,400,000 and Pukk quickly called.

The turn and the river completed the board and Pukk was eliminated in eighth place for €10,100.

Meanwhile, Keranen continues his hot final table run and went from the second shortest stack to the chip lead during the opening blind level.

Player	Chips	Progress
Ville Keranen	4,000,000	1,800,000
Kai Lehto	3,100,000	100,000
Tarmo Tammel	2,600,000	0
Urmo Velvelt	2,500,000	0
Mikael Haapaniemi	2,000,000	0
Phil Gross	1,800,000	100,000
Tomi Arponen	965,000	30,000
Magnus Pukk	0	0

Keranen Chips Up With Queens Posted Sunday 30th July, 2023 at 12:41(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 8/564

Tarmo Tammel opened for 120,000 with from early position before Magnus Pukk jacked it up to 280,000 from the hijack with . Ville Keranen four-bet to 430,000 with . Urmo Velvelt then woke up with from the big blind and opted to make a tight fold with all the action in front of him. Tammel folded as well and Pukk called.

Keranen improved to the top set on the flop. Pukk check-called a bet of 140,000. This was enough to get Pukk to fold. Despite not doubling up, Keranen has had a great early start to the final table where he came in with the second shortest stack and was in the middle of the pack after doubling up earlier and this hand.

Player	Chips	Progress
Tarmo Tammel	2,600,000	300,000
Urmo Velvelt	2,500,000	100,000
Ville Keranen	2,200,000	800,000
Magnus Pukk	1,600,000	1,200,000

Cowboys for Gross Posted Sunday 30th July, 2023 at 12:30(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 8/564

Mikael Haapaniemi opened for 120,000 from early position with . Kai Lehto three-bet to 320,000 from the hijack before Phil Gross jammed for 730,000 from the cutoff. Haapaniemi folded and Lehto called.

Phil Gross:
Kai Lehto:

Gross was in amazing shape with his cowboys and doubled his stack after no magic happened for Lehto on the runout.

Player	Chips	Progress
Kai Lehto	3,200,000	205,000
Mikael Haapaniemi	2,000,000	310,000
Phil Gross	1,700,000	700,000

Final Table Payouts Posted Sunday 30th July, 2023 at 12:25(UTC+0) by Jason Glatzer

Here is an updated look at the final table payouts:

Place	Player	Country	Prize
1			€108,260
2			€72,700
3			€49,300
4			€34,900
5			€25,600
6			€19,300
7			€13,400
8			€10,100
9	Jakob Linden	Sweden	€7,700

Jakob Linden Eliminated in 9th Place (€7,700) Posted Sunday 30th July, 2023 at 12:22(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 8/564

Jakob Linden jammed his short stack of 690,000 from middle position and was called by Magnus Pukk from the big blind.

Jakob Linden:
Magnus Pukk:

The flop kept Linden's cards live while also adding an eight to a straight along with a backdoor flush draw. The turn paired up Pukk to eliminate jacks and tens as outs for Linden but his backdoor flush draw became a real flush draw with one more card to come.

However, the paired up the board and Linden was the first player to hit the rail at the final table in ninth place for €7,700.

Player		Chips	Progress
Magnus Pukk		2,800,000	1,375,000
Jakob Linden		0	0

Big Slick for Tammel Posted Sunday 30th July, 2023 at 12:17(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 9/564

We've already had a lead change after two high-profile Estonians battled it out in the following hand.

Tarmo Tammel opened for 120,000 from early position with and was called by Urmo Velvelt with from the small blind. Both players improved to top pair on the flop with Tammel ahead with the better kicker. Velvelt check-called a bet of 105,000 before the blank came on the turn.

Both players checked and the river completed the board. Velvelt led out for 100,000. Tammel called to take down the pot.

Player		Chips	Progress
Tarmo Tammel		2,900,000	100,000
Urmo Velvelt		2,600,000	40,000

Keranen Off to Broadway Posted Sunday 30th July, 2023 at 12:08(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 9/564

Fireworks already erupted on the second hand of the final table. Tarmo Tammel opened for 120,000 from the cutoff with . Ville Keranen (pictured below) jammed his short stack of 610,000. Tomi Arponen rejammed for 2,050,000. Tammel folded and it was a heads-up showdown with Keranen at risk.

Ville Keranen:
Tomi Arponen:

Keranen was at risk of becoming the first player out at the final table and things went from bad to worse after Arponen nailed the top pair on the flop. The didn't change a thing. However, the spiked the river to improve Keranen to Broadway to stay alive and double his stack.

Player	Chips	Progress
Tarmo Tammel	2,800,000	100,000
Ville Keranen	1,400,000	670,000
Tomi Arponen	995,000	670,000

Final Table Stream Begins Posted Sunday 30th July, 2023 at 12:01(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 9/564

The action began 30 minutes ago at the final table with the stream beginning moments ago. Sit, back, relax, and watch the stream while also catching up on the action you missed in the blog.

Final Table Seat Draw Posted Sunday 30th July, 2023 at 11:09(UTC+0) by Jason Glatzer

Photos are being taken of the prestigious final nine players of the Kings of Tallinn Summer Showdown Main Event. The action will likely resume in 15 minutes with the entire final table live-streamed at OlyBet.tv, Facebook, and Delfi from the beginning until a winner is crowned.

There will be no spoilers in the blog today as we will report on a delay. This reporter will be in an out of the commentating booth with Andreas "Wiseguy" Hoglund hosting the action.

Seat	Player	Chips	Big Blinds
1	Ville Keranen	730,000	12
2	Tomi Arponen	1,665,000	28
3	Mikael Haapaniemi	2,310,000	39
4	Jakob Linden	840,000	14
5	Urmo Velvelt	2,640,000	44
6	Kai Lehto	3,405,000	57
7	Phil Gross	1,000,000	17
8	Tarmo Tammel	2,900,000	48
9	Magnus Pukk	1,425,000	24

Player	Chips	Progress
Kai Lehto	3,405,000	385,000
Tarmo Tammel	2,900,000	560,000
Urmo Velvelt	2,640,000	25,000
Mikael Haapaniemi	2,310,000	180,000
Tomi Arponen	1,665,000	130,000
Magnus Pukk	1,425,000	180,000
Phil Gross	1,000,000	360,000
Jakob Linden	840,000	150,000
Ville Keranen	730,000	0

Tapio Altonen Eliminated in 10th Place (€6,300) Posted Sunday 30th July, 2023 at 10:57(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 9/564

Tapio Altonen came into today with just six big blinds and a plan to do something within the next orbit and a half. The action came around to him in the big blind and he thought for a few minutes after Tarmo Tammel min-raised the button. Aaltonen eventually jammed for 285,000 and Tammel snap-called.

Tapio Altonen:
Tarmo Tammel:

Aaltonen's cards were live but his odds decreased after Tammel improved to top pair on the flop.

"Jack," Aaltonen was rooting for as this would have completed a gutshot to Broadway. However, Aaltonen was unable to improve on the turn and river and bubbled the final table. He didn't walk away empty-handed as he did collect the 10th place prize of €6,300.

Despite his dreams being crushed, Aaltonen showed tons of sportsmanship with hugs and handshakes to his opponents and rail after an impressive 3+ days of poker.

Player		Chips	Progress
Tarmo Tammel		2,900,000	560,000
Tapio Aaltonen		0	0

Cards in the Air Posted Sunday 30th July, 2023 at 10:35(UTC+0) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 10/564

Cards are in the air to start the final day of the Main Event. Best of luck to the final 10 players.

Who Will Win the Record Breaking Kings of Tallinn Summer Showdown Main Event? Posted Sunday 30th July, 2023 at 09:40(UTC+0) by Jason Glatzer

It has been a fantastic week at Olympic Park Casino and the Hilton Tallinn Park with the Kings of Tallinn Summer Showdown bringing record numbers to every event including the €1,100 Main Event which attracted 564 entries to create a €530,160 prize pool.

Today will be the day that we will learn who will earn the right to be crowned the Kings of Tallinn Summer Showdown Main Event champion.

Finland's Kai Lehto (pictured above) will be the clear chip leader to kick off the action with a 50 big blind stack of 3,020,000. Lehto's claim to the title is far from a certainty with many other formidable players in the mix including Urmo Velvelt (2,665,000) and Tarmo Tammel (2,340,000) also in the top three to start the day. Velvelt has had some decent results in Tallinn and online while Tammel (pictured below) came into the Kings of Tallinn Summer showdown with a record of 68 recorded cashes at Olympic Park Casino according to The Hendon Mob.

Meanwhile, Mikael Haapaniemi, Magnus Pukk, Tomi Arponen, the entertaining Phil Gross, Jakub Linden, Ville-Matte Keranen, and popular Finnish hero Tapio Altonen all are still in contention for the coveted trophy.

Time will tell which one of these players will join the Kings of Tallinn Summer Showdown royalty. The final 10 players already locked up €6,300 with payout jumps taking place every time a player hits the rail. It won't be a bad day's "work" for any of the remaining players but this is especially true for tonight's trophy winner will take home €108,260. Check out all of the final day payouts below:

Place	Prize
1	€108,260
2	€72,700
3	€49,300
4	€34,900
5	€25,600
6	€19,300
7	€13,400
8	€10,100
9	€7,700
10	€6,300

As Day 3 ended late, the organizers added an extra 30 minutes to the start time with cards in the air at 12:30 p.m. on Sunday with blinds increasing every hour.

There will be a break as soon as one player hits the rail for the TV table to be set up which will be broadcasted across a variety of channels including OlyBet.tv, Facebook, and Delfi.

Final Day Seat Draw Posted Sunday 30th July, 2023 at 09:11(UTC+0) by Jason Glatzer

Table	Seat	Player	Chips	Big Blinds
11	2	Tapio Aaltonen	345,000	6
11	3	Phil Gross	1,360,000	23
11	4	Urmo Velvelt	2,665,000	44
11	5	Tarmo Tammel	2,340,000	39
11	6	Mikael Haapaniemi	2,130,000	36

12	2	Tomi Arponen	1,535,000	26
12	3	Ville-Matti Keranen	730,000	12
12	6	Nils Linden	990,000	17
12	7	Kai Lehto	3,020,000	50
12	8	Magnus Pukk	1,605,000	27

09:08 (UTC+0)

Day 4 of Kings of Tallinn Summer Showdown 2023 Started
Level: 28 Blinds: 30,000/60,000 Ante: 60,000

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

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.

Browse

Useful Links

Subscribe to our newsletter