0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0119 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25' ORDER BY `views` DESC

0.0202 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-04-12' AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25'

0.0008 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` = '25'

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

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

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

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

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

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

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

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

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

0.0095 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '4352' 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` = '4348' 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` = '4347' 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` = '4345' 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` = '4343' 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` = '4342' 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` = '4339' 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` = '4335' 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` = '4330' 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` = '4327' 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` = '4321' 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` = '4317' 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` = '4315' 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` = '4310' 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` = '4308' 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` = '4307' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0102 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.0068 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '92' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

0.0092 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '4358' 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` = '4356' 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` = '4353' 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` = '4352' 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` = '4348' 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` = '4347' 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` = '4345' 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` = '4343' 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` = '4342' 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` = '4339' 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` = '4335' ORDER BY `chip_change` DESC, `busted` ASC

0.0092 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0095 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '4321' 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` = '4317' 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` = '4315' 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` = '4310' 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` = '4308' 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` = '4307' 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` = '4306' 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` = '4304' 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` = '4302' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0099 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0092 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0092 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0109 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.0030 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 Live Reporting - Day 4

Current Level 33 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
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
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.