0.0006 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0015 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/24', 1, '2024-04-24')

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

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '24'

0.0326 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` = '76' AND `published` = 1

0.0324 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0055 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '77' AND `published` = 1

0.0320 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0055 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '78' AND `published` = 1

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

0.0320 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0055 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '80' AND `published` = 1

0.0322 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` = '81' AND `published` = 1

0.0101 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '81' 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` = '81' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '3786' 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` = '3776' 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` = '3775' 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` = '3771' 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` = '3769' 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` = '3766' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0087 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '3758' 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` = '3756' 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` = '3751' 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` = '3750' 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` = '3749' 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` = '3747' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0087 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '3727' 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` = '3725' 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` = '3729' 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` = '3721' 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` = '3720' 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` = '3716' 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` = '3711' 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` = '3710' 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` = '3707' 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` = '3717' 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` = '3705' ORDER BY `chip_change` DESC, `busted` ASC

0.0087 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '3702' 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` = '3700' 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` = '3697' 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` = '3694' 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` = '3692' 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` = '3691' 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` = '3690' 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` = '3689' 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` = '3685' 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` = '3682' 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` = '3688' 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` = '3681' 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` = '3680' 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` = '3679' 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` = '81' ORDER BY `busted` ASC, `current_chips` DESC

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

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` = '3786' 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` = '3776' 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` = '3775' 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` = '3771' 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` = '3769' 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` = '3766' 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` = '3763' 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` = '3760' 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` = '3761' 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` = '3758' 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` = '3756' 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` = '3751' 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` = '3750' 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` = '3749' 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` = '3747' 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` = '3745' 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` = '3741' 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` = '3739' 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` = '3736' 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` = '3734' 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` = '3731' 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` = '3727' 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` = '3725' 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` = '3729' 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` = '3721' 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` = '3720' 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` = '3716' 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` = '3711' 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` = '3710' 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` = '3707' 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` = '3717' 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` = '3705' 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` = '3702' 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` = '3700' 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` = '3697' 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` = '3694' 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` = '3692' 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` = '3691' 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` = '3690' 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` = '3689' 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` = '3685' 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` = '3682' 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` = '3688' 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` = '3681' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

Translate
Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €555 Championship Live Reporting - Day 3

Current Level 37 Current Day 3
Blinds 200,000/400,000 Ante 400,000
Entries 573 Remaining 1
Prize Pool (EUR) €269,310 First Prize (EUR) €56,900
1 New Update - Click to refresh
Live Updates - Day 3
Maikel Homin Wins Kings of Tallinn Summer Showdown €555 Championship (€56,900) Posted Wednesday 26th July, 2023 at 20:48(UTC+2) by Jason Glatzer

Records were broken and a new Kings of Tallinn legend was made in the 2023 Kings of Tallinn Summer Showdown €555 Championship Event. Estonia's Maikel Homin (pictured above) began the final day with the second shortest stack of the final 14 players and dazzled both spectators and his opponents with an amazing performance to win the event for €56,900 at Olympic Park Casino and the Hilton Tallinn Park.

The event not only was the largest of its kind at the Kings of Tallinn Summer Showdown but proved to be the biggest in Kings of Tallinn history with 573 entries creating a huge €269,310 prize pool. This was even more than the record established in February to create a new gold standard when France's Benjamin Gros defeated a field of 559 entries to win the €55,500 top prize.

"I'm very happy about the win," said Homin. "Although I would have to win two or three more similar events to consider moving up stakes."

From an observer's point of view, it appeared that Homin didn't make any mistakes, at least any major ones. This was a concern of his at the start of the day, especially with a short stack.

"In my head, I understood I can't be making the same mistakes I make sometimes while playing online poker," Homin shared. "I often make silly moves when running deep."

The heads-up affair against Finland's Henri Antikainen spanned a few hours with the lead change going back and forth. Homin noticed his opponent changing up his style, and it was one of the more entertaining heads-up matches to follow in recent history.

Event #9: €555 Championship Final Table Results

Place Player Country Prize
1 Maikel Homin Estonia €56,900
2 Henri Antikainen Finland €38,450
3 Simon Forendal Sweden €22,760
4 Dmitri Dudakov Estonia €16,620
5 Michailas Miserkejevas Lithuania €13,010
6 Kim Lindstrom Finland €9,770
7 Janne Ojala Finland €6,700
8 Juho Heiska Finland €4,930
9 Jevgenijs Sapronenko Latvia €3,950

Event #9: €555 Championship Final Day Action

The final day began with Finnish poker streamer Juho Heiska in the lead with Henri Antikainen and Raivo Pinsel just a blind or two behind. On the flip, was the eventual winner Maikel Homin with a short stack.

In poker, no lead is safe and stacks can fall apart like they did for Pinsel who bubbled the final table when his king-eight was unable to hold against the jack-ten held by Michailas Miserkejevas. Antikainen managed to chip up and he began the final table with the chip. By this time, Homin was near the top of the pack.

A massive hand took place early at the final table where Heiska blew up his stack by three-bet jamming with king-ten suited. He ran into the queens of Ojala and Homin's cowboys to hit the rail, while Homin was inches away from the chip lead.

Dmitri Dudakov, who had the lead a few times on Day 2, took the lead after doubling through Miserkejevas in a blind vs. blind battle when his ace-nine held against ace-eight.

Dudakov's good fortunes came to an end shortly after Miserkevjevas dusted off his stack. First, Simon Forendal won a big flip against Dudakov when his fours were good against ace-jack before hitting the rail a short while later when his ace-deuce didn't match up well against Homin's ace-eight.

By this point, it was Antikainen with the big chip lead with just three players remaining. Homin doubled through Antikainen to take the chip lead but Antikainen fought back and regained control.

Homin then eliminated Forendal on a bad beat when his queen-seven got there against king-seven but was still facing a 2:1 chip disadvantage against Antikainen.

The lead went back and forth several times in the truly entertaining two-hour heads-up battle.  Eventually, Antikainen, who was quite aggressive at the final table, got his hand caught in the proverbial cookie jar. He jammed with middle pair on the flop with eight-seven and got no help to get beyond the top pair held by Homin with king-nine suited to be left with crumbs.

Antikainen (pictured below) nearly evened things up by doubling through Homin twice. Both times Homin was ahead when the chips went in preflop and it appeared that Antikainen regained momentum. However, time shortly after ran out for Antikainen. This time Antikainen got it in good with ace-queen but it didn't hold after Homin called with king-ten to fall one player shy of the title.

Congrats to Maikel Homin for his epic victory and we wish him and all of the players the best of luck during this week's Kings of Tallinn Summer Showdown.

Henri Antikainen Eliminated in 2nd Place (€38,450) Posted Wednesday 26th July, 2023 at 19:24(UTC+2) by Jason Glatzer

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

After a couple of bad beats, Maikel Homin won the last pot while slightly behind. Henri Antikainen opened for 1.1 million. Homin jammed and Antikainen snap-called off his stack of a little more than 7 million.

Henri Antikainen:
Maikel Homin:

Homin connected with his king on the board to win the tournament with two pair for a record top prize for this event of €56,900. Antikainen had tons of heart and took it well. Perhaps, the huge €38,450 runner-up prize helped soften the blow of falling one player short of the title.

Stay tuned for a recap of the final day of the 2023 Kings of Tallinn Summer Showdown €555 Championship and check out all of the final table payouts below:

Place Player Country Prize
1 Maikel Homin Estonia €56,900
2 Henri Antikainen Finland €38,450
3 Simon Forendal Sweden €22,760
4 Dmitri Dudakov Estonia €16,620
5 Michailas Miserkejevas Lithuania €13,010
6 Kim Lindstrom Finland €9,770
7 Janne Ojala Finland €6,700
8 Juho Heiska Finland €4,930
9 Jevgenijs Sapronenko Latvia €3,950
Player Chips Progress
Maikel Homin 17,200,000 7,000,000
Henri Antikainen 0 0
Antikainen on Crumbs Before Coming Back With Back-to-Back Doubles Posted Wednesday 26th July, 2023 at 19:07(UTC+2) by Jason Glatzer

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

Maikel Homin defended his big blind after Henri Antikainen min-raised. Antikainen checked the flop.

Homin bet 600,000. Antikainen jammed and Homin called off for 6,900,000. A crowd surrounded the table as the players showed their cards.

Maikel Homin:
Henri Antikainen:

"Seven please?" Antikainen pleaded.

Instead, he was drawing dead and on fumes after Homin improved to trips on the turn. The river ended the hand and Antikainen was on thin ice with crumbs in his stack.

He got a lucky double the next hand when his got there against after improving to trips on the board.

Shortly after, Antikainen jammed for 3,200,000 from the button and was called again.

Henri Antikainen:
Maikel Homin:

Antikainen connected with his eight on the board to get back into the thick of things.

Player Chips Progress
Maikel Homin 10,200,000 600,000
Henri Antikainen 7,000,000 600,000
Antikainen Doubles With Tens Posted Wednesday 26th July, 2023 at 18:54(UTC+2) by Jason Glatzer

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

Maikel Homin jammed from the button. Henri Antikainen looked down at his cards before he snap-called off his stack of 3.6 million.

Henri Antikainen:
Maikel Homin:

Antikainen's tens held on the runout to double his short stack.

Player Chips Progress
Maikel Homin 9,600,000 2,100,000
Henri Antikainen 7,600,000 2,100,000
18:49 (UTC+2)
Start of Level 37
Blinds: 200,000/400,000     Ante: 400,000
Heads-Up Break Posted Wednesday 26th July, 2023 at 18:39(UTC+2) by Jason Glatzer

The final two are on a 15-minute break. Blinds will increase to 200,000/400,000 with a 400,000 big blind ante.

Player Chips Progress
Maikel Homin 13,000,000 1,300,000
Henri Antikainen 4,200,000 1,300,000
Antikainen Bricks Double Belly Buster Posted Wednesday 26th July, 2023 at 18:12(UTC+2) by Jason Glatzer

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

Henri Antikainen (pictured below) won a couple of small pots before he min-raised the button and Maikel Homin defended his big blind to see the flop. Both players checked and Homin checked again on the turn.

Antikainen fired out for 900,000 and Homin called. The river completed the board. Homin checked and Antikainen bet 1,200,000. Homin went into the tank for a few minutes before making the call.

Antikainen turned over the and lost the pot to Homin who paired his four with the .

Player Chips Progress
Maikel Homin 12,200,000 1,200,000
Henri Antikainen 5,000,000 1,200,000
Homin in the Lead Posted Wednesday 26th July, 2023 at 18:04(UTC+2) by Jason Glatzer

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

Maikel Homin won a couple of small pots without showdowns to take the lead over Henri Antikainen.

Player Chips Progress
Maikel Homin 11,000,000 2,600,000
Henri Antikainen 6,200,000 2,600,000
18:03 (UTC+2)
Start of Level 36
Blinds: 150,000/300,000     Ante: 300,000
Homin Earns a Double After a Light Call Posted Wednesday 26th July, 2023 at 17:51(UTC+2) by Jason Glatzer

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

The action began small enough with a limped pot before Maikel Homin bet 275,000 on the flop. Henri Antikainen called before he called a bet of 600,000 on the turn. Homin open-jammed for 3,325,000 on the river. Antikainen tanked for several minutes before he called.

Homin turned over the for the third pair.

"You're good," said Antikainen.

"I'm good???!?" said a shocked Homin.

Antikainen had a bluff catcher with his but this wasn't good enough to beat what Homin was trying to get Antikainen off of. The stacks were fairly even for the first time during heads-up play after the hand.

Player Chips Progress
Henri Antikainen 8,800,000 4,000,000
Maikel Homin 8,400,000 4,000,000
King-High Gets the Job Done for Antikainen Posted Wednesday 26th July, 2023 at 17:43(UTC+2) by Jason Glatzer

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

Maikel Homin opened the button for 500,000. Henri Antikainen defended his big blind and both players checked the flop.

Antikainen fired out for 850,000 on the turn before the river paired the board. Both players checked.

"King-high," Antikainen said before showing his

Apparently, king-high was good as Homin mucked his cards and lost some chips he earned winning other small pots.

Player Chips Progress
Henri Antikainen 12,800,000 2,425,000
Maikel Homin 4,400,000 2,400,000
17:14 (UTC+2)
Start of Level 35
Blinds: 125,000/250,000     Ante: 250,000
Simon Forendal Eliminated in 3rd Place (€22,760) Posted Wednesday 26th July, 2023 at 17:11(UTC+2) by Jason Glatzer

Level 32: 100,000/200,000 (200,000)
Entries: 2/573

It was a heck of a run for Sweden's Simon Forendal (pictured below) and he could have potentially gone further if not for the following bad beat against Maikel Homin.

Homin jammed from the small blind and Forendal called off his short stack of under 10 big blinds from the big blind.

Simon Forendal:
Maikel Homin:

Homin nailed two pair on the flop and Forendal was out in third place for €22,760 after the turn and river didn't get him past Homin's two pair.

Meanwhile, Henri Antikainen will begin the heads-up battle against Homin with a nearly 2:1 chip advantage with both players already locking up €38,450 runner-up prize with a €56,900 top prize on the line for the winner.

Player Chips Progress
Henri Antikainen 10,375,000 125,000
Maikel Homin 6,800,000 300,000
Simon Forendal 0 0
Antikainen Back on Top Posted Wednesday 26th July, 2023 at 16:48(UTC+2) by Jason Glatzer

Level 32: 100,000/200,000 (200,000)
Entries: 3/573

The chip lead was short-lived for Maikel Homin and is back with Henri Antikainen. There were 1 million chips in the pot with the on the board after the turn when Homin check-called a bet of 750,000 by Antikainen.

Homin checked again on the river. Antikainen fired out for 1,400,000 and Homin quickly called.

Homin shook his head in what appeared to be frustration with Antikainen turning over the . Homin's cards went into the muck and the exciting three-handed play continued.

Player Chips Progress
Henri Antikainen 10,500,000 3,500,000
Maikel Homin 6,500,000 3,000,000
Homin Snags Chip Lead Off Antikainen Posted Wednesday 26th July, 2023 at 16:42(UTC+2) by Jason Glatzer

Level 32: 100,000/200,000 (200,000)
Entries: 3/573

There wasn't a ton in the pot when Henri Antikainen check-jammed the flop and was called by Maikel Homin for his stack of around 4 million.

Maikel Homin:
Henri Antikainen:

Homin's overpair held after the turn and river completed the board to take his first chip lead.

Player Chips Progress
Maikel Homin 9,500,000 4,200,000
Henri Antikainen 7,000,000 2,900,000
16:30 (UTC+2)
Start of Level 34
Blinds: 100,000/200,000     Ante: 200,000
Break Time Posted Wednesday 26th July, 2023 at 16:13(UTC+2) by Jason Glatzer

The final three players are on break for 15 minutes. Blinds will increase to 100,000/200,000 with a 200,000 big blind ante when the action resumes. 

Henri Antikainen jammed a river over a bet by Maikel Homin with the on the board. Homin tanked for a few minutes before he laid down his hand. Antikainen will have a massive chip lead once the action resumes.

Player Chips Progress
Henri Antikainen 10,425,000 6,325,000
Maikel Homin 4,800,000 500,000
Simon Forendal 1,950,000 1,150,000
Dmitri Dudakov Eliminated in 4th Place (€16,620) Posted Wednesday 26th July, 2023 at 15:56(UTC+2) by Jason Glatzer

Level 31: 75,000/150,000 (150,000)
Entries: 3/573

Maikel Homin min-raised the button before Dmitri Dudakov jammed for about a dozen big blinds. Homin snapped it off with Dudakov at risk.

Dmitri Dudakov:
Maikel Homin:

Dudakov wasn't happy about Homin's call but he pulled ahead with two pair on the flop. It was looking even better for Dudakov to double on the turn but the spiked the river to improve Homin to a better two pair to eliminate Dudakov.

Player Chips Progress
Maikel Homin 5,300,000 1,600,000
Dmitri Dudakov 0 0
Forendal Wins a Flip Against Dudakov Posted Wednesday 26th July, 2023 at 15:45(UTC+2) by Jason Glatzer

Level 31: 75,000/150,000 (150,000)
Entries: 4/573

Simon Forendal jammed for 1,450,000 from the button. Dmitri Dudakov came in over the top for about 3,200,000 from the small blind and Henri Antikainen folded from the big blind.

Simon Forendal:
Dmitri Dudakov:

Dudakov expressed his frustration on the turn after Forendal improved to a straight to win the flip after the ran out on the board.

Player Chips Progress
Simon Forendal 3,100,000 1,575,000
Dmitri Dudakov 1,700,000 2,400,000
15:37 (UTC+2)
Start of Level 33
Blinds: 75,000/150,000     Ante: 150,000
Michailas Miserkejevas Eliminated in 5th Place (€13,010) Posted Wednesday 26th July, 2023 at 15:17(UTC+2) by Jason Glatzer

Level 31: 50,000/125,000 (125,000)
Entries: 4/573

Michailas Miserkejevas (pictured below) folded a few hands before he jammed his decimated 225,000 chip stack from under the gun. Maikel Homin called from the button and Dmitri Dudakov called from the big blind.

Dudakov and Homin checked down the board.

Homin turned over the for the bottom pair. This won the pot to oust Miserkejevas in fifth place with Dudakov showing and Miserkejevas bricking his live cards with .

Player Chips Progress
Dmitri Dudakov 4,100,000 1,000,000
Maikel Homin 3,700,000 100,000
Michailas Miserkejevas 0 0
Dudakov Wins Massive Pot Against Miserkejevas Posted Wednesday 26th July, 2023 at 15:02(UTC+2) by Jason Glatzer

Level 31: 50,000/125,000 (125,000)
Entries: 5/573

Dmitri Dudakov jammed from the small blind with and was called by Michailas Miserkejevas with from the big blind.

Both players connected with their kickers to their ace on the runout. Dudakov had the better pair and doubled through Miserkejevas, who was left with crumbs after the hand.

Players went on a quick unscheduled toilet break after the hand.

Player Chips Progress
Dmitri Dudakov 5,100,000 2,400,000
Michailas Miserkejevas 250,000 2,550,000
Kim Lindstrom Eliminated in 6th Place (€9,770) Posted Wednesday 26th July, 2023 at 14:59(UTC+2) by Jason Glatzer

Level 31: 50,000/125,000 (125,000)
Entries: 5/573

Kim Lindstrom jammed his short stack from the small blind of five big blinds and was looked up by Simon Forendal from blinds.

Kim Lindstrom:
Simon Forendal:

Forendal's queen found some love on the board to eliminate Linstrom in sixth place for €9,770.

Player Chips Progress
Dmitri Dudakov 5,100,000 2,400,000
Michailas Miserkejevas 250,000 2,550,000
14:54 (UTC+2)
Start of Level 32
Blinds: 50,000/125,000     Ante: 125,000
Juho Heiska Eliminated in 7th Place (€6,700); Janne Ojala Eliminated in 8th Place (€4,930) Posted Wednesday 26th July, 2023 at 14:47(UTC+2) by Jason Glatzer

Level 31: 60,000/120,000 (100,000)
Entries: 6/573

Maikel Homin came into the final day with one of the shortest stacks and now is near the chip lead after eliminating Day 2 chip leader Juho Heiska (pictured above) and Janne Ojala (pictured below) as follows.

Homin opened for 250,000 from the hijack. Heiska jammed for 1,500,000 from the small blind. Ojala called off for 625,000 from the big blind. Homin, who barely had Heiska covered, snap-called when the action came back to him.

Janne Ojala:
Juho Heiska:
Maikel Homin:

Homin got nervous after the flop gave Heiska a pair to improve from along with a flush draw. Heiska bricked the turn and river and Homin's rockets held to eliminate Heiska in seventh place for €6,700 and Ojala in eighth place for €4,930.

Player Chips Progress
Maikel Homin 3,800,000 1,775,000
Janne Ojala 0 0
Juho Heiska 0 0
Jevgenijs Sapronenko Eliminated in 9th Place (€3,950) Posted Wednesday 26th July, 2023 at 14:39(UTC+2) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 8/573

Dmitri Dudakov opened for 225,000 from early position. Maikel Homin called from the small blind before Jevgenijs Sapronenko (pictured below) jammed for 300,000 from the big blind. Both Dudakov and Homin called to see the flop.

Homin check-called a bet of 175,000 before giving up on the turn after Dudakov bet 275,000.

Jevgenijs Sapronenko:
Dmitri Dudakov:

Dudakov flopped the nuts and by the time the cards were turned over Sapronenko was drawing dead. The river completed the board and Sapronenko was the first player to hit the rail at the final table.

Player Chips Progress
Dmitri Dudakov 2,700,000 500,000
Jevgenijs Sapronenko 0 0
Ojala Doubles Short Stack Posted Wednesday 26th July, 2023 at 14:24(UTC+2) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 9/573

Juho Heika jammed from the small blind before Janne Ojala called off his small stack of 300,000 from the big blind.

Janne Ojala:
Juho Heiska:

The flop improved Ojala to a set but he had a sweat with Heiska holding an open-ended straight draw.

Heiska was calling for an ace but he bricked the turn and river to double Ojala.

Player Chips Progress
Juho Heiska 1,400,000 50,000
Janne Ojala 700,000 350,000
Pinsel Bubbles Final Table Posted Wednesday 26th July, 2023 at 14:12(UTC+2) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 9/573

Raivo Pinsel began the day near the chip lead but was unable to parlay that into a final table appearance. The Estonian jammed for 650,000 from the cutoff and was called by Michailas Miserkevicius from the big blind.

Raivo Pinsel:
Michailas Miserkevicius:

Pinsel's king-high was unable to hold after Miserkevicius connected with his jack on the board. 

Players were immediately in their seats with the action resuming after Elena Kask snapped a photo of the group of nine.

Player Chips Progress
Michailas Miserkejevas 2,800,000 425,000
Raivo Pinsel 0 0
"Way Too Many Outs" Posted Wednesday 26th July, 2023 at 14:03(UTC+2) by Jason Glatzer

Level 30: 50,000/100,000 (100,000)
Entries: 10/573

Jonatan Fors (pictured below) jammed for 400,000 from under the gun and was cold-called by Michailas Miserkevicius from the button.

Jonatan Fors:
Michailas Miserkevicius:

The table remained silent after the flop but Fors spoke up after the turn.

"Way too many outs," Fors said about his two over cards, gutshot Broadway draw, and flush draw.

Fors saw it coming as a blank river completed the board to hit the rail in 11th place for €2,780.

"Good game," Fors said to the table before collecting his payout slip. 

Chip Counts at Break Posted Wednesday 26th July, 2023 at 13:50(UTC+2) by Jason Glatzer

Henri Antikainen held the lead at the break after winning a big hand against Juho Heiska without a showdown during Level 29. Check out all the chip counts below:

Player Chips Progress
Henri Antikainen 4,100,000 300,000
Michailas Miserkejevas 2,375,000 675,000
Dmitri Dudakov 2,200,000 900,000
Maikel Homin 2,025,000 925,000
Simon Forendal 1,525,000 125,000
Juho Heiska 1,450,000 50,000
Kim Lindstrom 1,150,000 130,000
Raivo Pinsel 850,000 1,480,000
Jevgenijs Sapronenko 750,000 555,000
Jonatan Fors 400,000 870,000
Janne Ojala 350,000 348,000
13:44 (UTC+2)
Start of Level 31
Blinds: 50,000/100,000     Ante: 100,000
Break Time Posted Wednesday 26th July, 2023 at 13:40(UTC+2) by Jason Glatzer

Players are on a 15-minute break. Blinds will increase to 50,000/100,000 with a 100,000 big blind ante when the action resumes.

Antikainen Takes the Chip Lead Posted Wednesday 26th July, 2023 at 13:24(UTC+2) by Jason Glatzer

Level 29: 40,000/80,000 (80,000)
Entries: 11/573

Juho Heiska three-bet Henri Antikainen's open to 320,000. Antikainen called to see the flop. Both players checked the flop before things got more interesting on the turn.

Antikainen check-raised Heiska's 250,000 to 650,000 and Heiska called. The river completed the board and Antikainen jammed. Heiska mentioned he thought his opponent was bluffing but a few minutes later folded to give Antikainen the chip lead.

Player Chips Progress
Henri Antikainen 3,800,000 1,435,000
Juho Heiska 1,500,000 1,400,000
Two Out at Same Time Posted Wednesday 26th July, 2023 at 13:15(UTC+2) by Jason Glatzer

Level 29: 40,000/80,000 (80,000)
Entries: 11/573

Two players hit the rail at the same time and it was a similar situation with the button jamming and the big blind calling.

The first to go was Steven Seller (pictured below). He open-jammed a short stack with and was actually ahead of Michailas Miserkejevas who called from the big blind with . The double-paired board improved Miserkejevas to a full house and Seller was out in 13th place for €2,320.

Moments later, it was Hendrik Diegenant, jammed his short stack with . Juho Heiska called from the big blind with and it looked like he would double up his opponent after Diegenant connected his ten on the flop. That all changed when Heiska improved to a better pair on the turn and Diegenant was eliminated in 12th place for €2,780.

Player Chips Progress
Juho Heiska 2,900,000 510,000
Michailas Miserkejevas 1,700,000 295,000
Steven Seller 0 0
Hendrik Diegenant 0 0
13:03 (UTC+2)
Start of Level 30
Blinds: 40,000/80,000     Ante: 80,000
Berggren First on the Rail Posted Wednesday 26th July, 2023 at 12:43(UTC+2) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 13/573

Moments after Homin doubled up, Phillip Berggren (pictured below) had different fortunes at the other table in play. Berggren jammed for less than 10 big blinds with before Simon Foredal three-bet shoved with .

The cowboys were more than good on the runout and Berggren was the first player on the rail on the final day in 14th place for €2,320.

Player Chips Progress
Simon Forendal 1,400,000 800,000
Phillip Berggren 0 0
Homin Doubles Through Dudakov Posted Wednesday 26th July, 2023 at 12:39(UTC+2) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 14/573

Maikel Homin jammed for 465,000 from the button over the min-raise open Dmitri Dudakov from the cutoff. Dudakov asked for a count before he called.

Maikel Homin:
Dmitri Dudakov:

Homin flopped Yahtzee as he nailed a straight on the flop and doubled through Dudakov after the turn and river completed the board.

Player Chips Progress
Dmitri Dudakov 1,300,000 185,000
Maikel Homin 1,100,000 420,000
Lindstrom Doubles Through Forendal Posted Wednesday 26th July, 2023 at 12:33(UTC+2) by Jason Glatzer

Level 28: 30,000/60,000 (60,000)
Entries: 14/573

Simon Forendal opened for 120,000 from the cutoff. Kim Lindstrom (pictured below) quickly jammed the button for 435,000. Forendal asked for a count before he called.

Kim Lindstrom:
Simon Forendal:

Lindstrom was ahead the entire way and doubled with a flush after the ran out on the board.

Player Chips Progress
Kim Lindstrom 1,020,000 952,500
Simon Forendal 600,000 435,000
12:23 (UTC+2)
Start of Level 29
Blinds: 30,000/60,000     Ante: 60,000
Everyone Loves a Chop Posted Wednesday 26th July, 2023 at 12:23(UTC+2) by Jason Glatzer

Level 27: 20,000/50,000 (50,000)
Entries: 14/573

The first all-in and call just took place on Table 11 but ended in no drama. Juho Heiska min-raised from early position before Maikel Homin jammed the button for 10 big blinds. Hendrik Diegenant four-bet jammed for a little more from the small blind and Heiska quickly got out of the way.

Maikel Homin:
Hendrik Diegenant:

Both players took back their stacks after a chop was apparent on the flop and the chop was made official after the turn and river competed the board.

Player Chips Progress
Hendrik Diegenant 650,000 325,000
Maikel Homin 600,000 80,000
Small Ball Posted Wednesday 26th July, 2023 at 12:16(UTC+2) by Jason Glatzer

Level 27: 20,000/50,000 (50,000)
Entries: 14/573

Despite the major fireworks last night, players are playing tight to the vest with the big money jumps and the final table looming. The short stacks are getting away with shoves at least for now.

Shuffle Up and Deal Posted Wednesday 26th July, 2023 at 12:00(UTC+2) by Jason Glatzer

Level 27: 20,000/50,000 (50,000)
Entries: 14/573

The action kicked off for the final day of the €555 Championship. Best of luck to all of the players.

11:59 (UTC+2)
Start of Level 28
Blinds: 20,000/50,000     Ante: 50,000
Who Will Win the €555 Championship? Posted Wednesday 26th July, 2023 at 10:37(UTC+2) by Jason Glatzer

The time is near and the mission is clear. There are just 14 players remaining from the record-breaking €555 Championship at the 2023 Kings of Tallinn Summer Showdown at Olympic Park Casino and the Hilton Tallinn Park.

Finland's Juho Heiska (pictured above) will enter the final day in the pole position with 2,390,000 in chips good for 48 big blinds. However,  Heiska's lead is far from secure there are two other players just a big blind or two behind with Henri Antikainen sitting on 2,365,000 and Raivo Pinsel with 2,330,000. While Heiska and Antikainen were near the top of the pack for a bit near the end of the day, Heiska catapulted his stack near the end of Day 2 after winning a miracle of a hand to end Day 2 with a two-outer on the river to end the dreams of €555 Championship glory for Roope Tarmi.

The final 14 players have each locked up €2,390 with much more on the line for every pay jump. Today's winner is slated to bank a tasty €56,900 top prize, which if no deal is made would surpass the previous record top prize of €55,500 won by Benjamin Gros at the 2023 Kings of Tallinn earlier this year.

The action will begin with the second half of Level 27 with blinds at 20,000/50,000 along with a 50,000 big blind ante. After this blind level, blind levels will increase every 40 minutes until a winner is crowned.

Stay tuned as we bring you the action of the 2023 Kings of Tallinn Summer Showdown €555 Championship starting at noon. Will one of the three chip leaders ship the event or will someone else rise to the occasion? Time will tell but in the meantime check out the opening chip counts for the day below:

Player Country Chips Big Blinds
Juho Heiska Finland 2,390,000 48
Henri Antikainen Finland 2,365,000 47
Raivo Pinsel Estonia 2,330,000 47
Dmitri Dudakov Estonia 1,485,000 30
Michailas Miserkejevas Lithuania 1,405,000 28
Jevgenijs Sapronenko Latvia 1,305,000 26
Jonatan Fors Finland 1,270,000 25
Simon Forendal Sweden 1,035,000 21
Hendrik Diegenant Belgium 975,000 20
Janne Ojala Finland 698,000 14
Philip Berggren Sweden 655,000 13
Steven Seller Estonia 654,000 13
Kim Lindstrom Finland 585,000 12
Maikel Homin Estonia 535,000 11
Final Day Seat Draw Posted Wednesday 26th July, 2023 at 10:27(UTC+2) by Jason Glatzer
Table Seat Player Country Chips Big Blinds
11 2 Hendrik Diegenant Belgium 975,000 20
11 3 Henri Antikainen Finland 2,365,000 47
11 4 Raivo Pinsel Estonia 2,330,000 47
11 5 Juho Heiska Finland 2,390,000 48
11 6 Jevgenijs Sapronenko Latvia 1,305,000 26
11 7 Dmitri Dudakov Estonia 1,485,000 30
11 8 Maikel Homin Estonia 535,000 11
12 1 Steven Seller Estonia 654,000 13
12 2 Jonatan Fors Finland 1,270,000 25
12 3 Janne Ojala Finland 698,000 14
12 4 Philip Berggren Sweden 655,000 13
12 5 Michailas Miserkejevas Lithuania 1,405,000 28
12 6 Simon Forendal Sweden 1,035,000 21
12 7 Kim Lindstrom Finland 585,000 12
10:27 (UTC+2)
Day 3 of Kings of Tallinn Summer Showdown 2023 Started
Level: 27     Blinds: 20,000/40,000     Ante: 40,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.