0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0060 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/86/updates'
ORDER BY `views` DESC
0.0087 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/86/updates'
0.0005 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.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
0.0231 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1
0.0213 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '83'
AND `published` = 1
0.0316 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '85'
AND `published` = 1
0.0239 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '86'
AND `published` = 1
0.0234 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0044 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '90'
AND `published` = 1
0.0245 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0168 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1
0.0093 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '86'
ORDER BY `busted` ASC, `current_chips` DESC
0.0082 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` = '86'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4030'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4012'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4007'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4004'
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` = '4002'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4001'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3991'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3983'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3980'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3971'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3962'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3956'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3945'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3944'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3937'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3924'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3917'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3903'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3901'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3892'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3894'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0176 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '86'
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` = '86'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4030'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4012'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4007'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4004'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4002'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4001'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3991'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3983'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3980'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3971'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3962'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3956'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3945'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3944'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3937'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3924'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3917'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3903'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3901'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3899'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3892'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3894'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0176 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3876'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 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.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Kings of Tallinn Summer Showdown 2023
2023 Tallinn Summer Showdown €1,100 Main Event
Live Reporting - Day 4
End-of-Day 2 Chip Counts Posted Saturday 29th July, 2023 at 08:24(UTC+0) by Jason Glatzer
Player
Chips
Big Blinds
Juan Carlos Vecino Duenas
709,000
118
Vlads Dolgilevics
674,000
112
Nils Linden
558,000
93
Mikael Haapaniemi
536,000
89
Tapio Aaltonen
492,000
82
Ville-Matti Keranen
478,000
80
Mauri Kristjan Dorbek
470,000
78
Yanis Sahli
457,000
76
Juho Heiska
440,000
73
Tomi Arponen
422,000
70
Phil Gross
406,000
68
Hendrik Diegenant
405,000
68
Kai Lehto
405,000
68
Siim Suviste
388,000
65
James Noonan
382,000
64
Kasper Mellanen
379,000
63
Guillermo Cifuentes
352,000
59
Dmitrijs Kornevs
352,000
59
Karolis Kutkauskas
326,000
54
Magnus Pukk
321,000
54
Konstantin Arber
320,000
53
Nick Penning
314,000
52
Keito Kaljulaid
307,000
51
Harri Seppa
295,000
49
Matias Arosuo
287,000
48
Feras Abid
285,000
48
Kristian Larsson
266,000
44
Ilya Nikiforov
258,000
43
Urmo Velvelt
251,000
42
Touko Berndtson
238,000
40
Jari Saviaho
238,000
40
Christian Steinbo
233,000
39
Herli Olop
221,000
37
Anna-Mari Hursti
220,000
37
Anatoly Filatov
213,000
36
Kristaps Deksnis
211,000
35
Lukas Rutkauskas
192,000
32
Daniel Jullumstro
191,000
32
Kaspar Laursoo
189,000
32
Henri Schalin
183,000
31
Aleksi Naski
182,000
30
Espen Sandvik
180,000
30
Anders Auset
172,000
29
Jordi Baixas
172,000
29
Igor Pihela Jr.
170,000
28
Tarmo Tammel
170,000
28
Kasparas Klezys
168,000
28
Vygerdas Jonikas
164,000
27
Hein Haraldsen
155,000
26
Tero Kilkanen
144,000
24
Jargo Alavali
139,000
23
Samuli Hietala
137,000
23
Stefan Bittger
136,000
23
Matias Kesanen
136,000
23
Edgars Beizaks
134,000
22
Jaana Kindsigo
132,000
22
Kaido Mikk
126,000
21
Luis Cruz
114,000
19
Ranno Sootla
112,000
19
Patrick Schratz
94,000
16
Andrei Mjagkov
89,000
15
Joonas Helin
84,000
14
Roberts Rumba
78,000
13
Sebastian Van Wonterghem
61,000
10
Hyunsil Park
58,000
10
Kalle Parkkinen
53,000
9
Ramunas Mika
51,000
9
Maksim Rusinov
39,000
7
Grantas Naujokas
33,000
6
Julian Herold
28,000
5
Martin Piik
12,000
2
No hand-by-hand Posted Friday 28th July, 2023 at 19:13(UTC+0) by Gia Carnestorm
Two players shared the unfortune to lose their all-in at the same time which means we are now down to 71 players. The updates regarding Main Event ends for today and Jason will be back tomorrow.
Overheard at a table Posted Friday 28th July, 2023 at 18:45(UTC+0) by Gia Carnestorm
Mauri Kristjan Dorbek says he knows he had been drinking to much wine today. Declares he can´t play sober, because he then is to intense. LOL!
Last level for today just started Posted Friday 28th July, 2023 at 18:29(UTC+0) by Gia Carnestorm
Still more than 50 minutes left of todays last level. 75 players still in. If we go down to pay-outs before this level ends, then day 2 ends, but if there is still more than 71 players left when this level is over, the game will continue.
18:26 (UTC+0)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Big hands Posted Friday 28th July, 2023 at 18:23(UTC+0) by Gia Carnestorm
Kasparas Klezys just lost a huge pot with KK. He races to 10k and Juho H. S. Heiska reraces to 25k, Kasparas races to 60k and Juho goes all-in, gets an insta call and shows AA. No helping cards for Kasparas with 125k left. Juho has around 520k.
Dealers have to announce every all-in. Posted Friday 28th July, 2023 at 18:12(UTC+0) by Gia Carnestorm
Henri Pietari Wagner and Teemu Aukusti Toikkanen goes all-in heads up. Henri shows AdAh. Then what? Teemu shows AcAs. No flush possible on the flop, split pot. When four more players are out, the pay-outs starts.
Hein Haraldsen wins comfortable Posted Friday 28th July, 2023 at 17:58(UTC+0) by Gia Carnestorm
Jari A. J. Saviaho races to 8k utg. Cut off+1 calls, so do the button and BB. Flop shows 8 6 2, rainbow. Jari bets 4k, Hein races to 10k, button and bb folds, Jari calls. Turn is Kh which makes a flush draw. Jari bets 40k and Hein goes all-in for 160k approx. Jari thinks for a while, says "did you hit the set", gets no answer and folds.
New TV-table Posted Friday 28th July, 2023 at 17:40(UTC+0) by Gia Carnestorm
After the break they changed players at the TV-table. It is the table with highest average ; 221.500. There is one player really short he has 70k with the blinds 2000/4000 BBA 4000. If there is a chip then there is a chair. Biggest stack on the table has Yanis Mehdi Sahli from France with 400k.
17:12 (UTC+0)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Third break for the day Posted Friday 28th July, 2023 at 17:12(UTC+0) by Gia Carnestorm
With 84 players left the average stack is 201.429. There are like five players really short stacked with stacks between 30 and 70k. A number of players have around 100k and are as well in the zone of danger since 13 more players must be eliminated before reaching the prize money.
In my opinion there is no difference in male and female players opportunities of winning. So few women play poker on a high level, moneywise. Still three ladies in, but I compare with Sweden were it almost always are at least 15% female players, and often two or more at the finale table. Is the reason the height of the buy-in? This I have been asking myself since I started playing poker 30 years ago. Will I ever get an answer?
Went down to check the TV-table Posted Friday 28th July, 2023 at 16:22(UTC+0) by Gia Carnestorm
There is one short stack at the TV-table and that is Kalle Elmeri Parkkinen with 70k. He still has 23 BB. 7 players have between 140k and 180 k. Chip leader at the table is Keito Kaljulaid.
We are now down to less than 100 players, to be exact 94 for the moment.
15:55 (UTC+0)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Concentration and focus are the keys in players room Posted Friday 28th July, 2023 at 15:34(UTC+0) by Gia Carnestorm
The only spot in the room where you can here a laughter is in the media area. That is because 35 more players have to be eliminated before the rest is in the money. We have a new chip leader with 530k; Juan Carlos Vecino Duenas.
Here are the prizes in € Posted Friday 28th July, 2023 at 15:12(UTC+0) by Gia Carnestorm
15 minutes break Posted Friday 28th July, 2023 at 14:44(UTC+0) by Gia Carnestorm
During this two ours session since last break almost 60 players have left the Main Event. Dreams and hopes down the drain, but there is always a tomorrow, always new games to play and a lot of open tables.
Siim Suviste takes down a 350k pot Posted Friday 28th July, 2023 at 14:31(UTC+0) by Gia Carnestorm
Siim who has BB versus Paul Koppe on the Button. I didn´t see the hand from start, but it is around 100k in the pot with the flop K T 7 rainbow. Slim bets 12.5k and Paul reraise to 25k. Slim calls. Turn Q makes a possible straight and a flush draw, both checks. River shows a 3, no flush. Slim thinks for a while and bets 55k. Paul quite quick says all-in for 110k, leaving Slim thinking for a long time. Paul makes a joke, putting on his hoodie saying - No tells from me, next time I will bring my sunglasses as well. Finally Slim calls and Paul says you win, showing A high. Slim shows TT and Paul is out. Is maybe TT the hand of the day?
8 biggest stacks Posted Friday 28th July, 2023 at 13:54(UTC+0) by Gia Carnestorm
Level 12 1000/2000 BBA 2000 160/564
Tapio Ilmari Aaltonen 450k Jargo Alaväli 350k Kristap Deksnis 325k Juan Carlos Vecino Duennas 300k Artjoms Hromovs 270k Karolis Kutkauskas 250k Vadims Milovs 250k Anna Mari Hursti 250k
13:52 (UTC+0)
Start of Level 12 Blinds: 1,000/2,000 Ante: 2,000
Alive and kicking! Posted Friday 28th July, 2023 at 13:52(UTC+0) by Gia Carnestorm
This is my first Live Report for more than ten years. Please don´t expect miracles, but hopefully you at least find the information expected. The first break for today is just over and it is the normal razzle and dazzle of chips in the room. The sound that make us love poker so much. Or maybe it is annoying for you? 184/564 players still in the game. Approx. 55 have starting stack (30000) or less. Chip leader with 264.500 is Vlad Dolgevics and all together have ten players more than 200k.
Hudge Chip Leader Posted Friday 28th July, 2023 at 13:27(UTC+0) by Gia Carnestorm
Tapio Ilmari Aaltonen is Chip Leader with approx. 450k. He raised pre flop UTG+1 and BB reraises. Flop comes A T 7 rainbow. BB bets and Tapio calls after thinking for a while. Turn shows J and gives an flush draw. BB is all-in and Tapio calls quick as a King Cobra. BB shows AK and Tapio has TT. Over and out for Kevin Victor Karenius.
Late Registration Closed; €530,160 Prize Pool Posted Friday 28th July, 2023 at 12:46(UTC+0) by Jason Glatzer
Level 11: 1,000/1,500 (1,500) Entries: 196/564
The action has resumed from the break which means late registration has closed. The record-breaking Kings of Tallinn Summer Showdown €1,100 Main Event attracted 564 entries for a €530,160 prize pool. Full payouts will be announced in the near future.
Best of luck to the 196 remaining players in their hunt for Kings of Tallinn Summer Showdown glory.
Gia Carnestrom will be handling the reporting for the day while your usual reporter Jason Glatzer will commentate both the second half of Day 2 of the Main Event before hopping into the High Roller.
12:39 (UTC+0)
Start of Level 11 Blinds: 1,000/1,500 Ante: 1,500
Break Time! Posted Friday 28th July, 2023 at 12:06(UTC+0) by Jason Glatzer
Players are playing their final few hands before heading on a 15-minute break. We will know the total number of entrants and the prize pool after the action resumes. The prize pool has already soared past €500,000! Amazing, especially considering there was no guarantee.
Gia Carnestrom will be handling the blog for Day 2 with Jason Glatzer moving over to the commentating booth to announce the second half of the Main Event and the €5,000 High Roller shortly after before coming back to report Day 3 and Day 4 of the Main Event.
Main Event Continues to Grow Posted Friday 28th July, 2023 at 11:32(UTC+0) by Jason Glatzer
Level 10: 700/1,400 (1,400) Entries: 199/528
More players and re-entries continue to file in and the prize pool is now inches away from €500,000. This was the guarantee during the winter-edition of the Kings of Tallinn and it appears this figure will be smashed even without a guarantee.
11:14 (UTC+0)
Start of Level 10 Blinds: 700/1,400 Ante: 1,400
Cards in the Air Posted Friday 28th July, 2023 at 10:09(UTC+0) by Jason Glatzer
Level 9: 600/1,200 (1,200) Entries: 221/490
Cards are in the air to start Day 2 of the Main Event. The field will continue to grow and grow but already 25 new players got into the mix before the start of the day.
Welcome to Day 2 of the €1,100 Main Event Posted Friday 28th July, 2023 at 09:58(UTC+0) by Jason Glatzer
Welcome to Day 2 of the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park.
The three opening flights attracted 465 entries with 196 players finding a bag. They will be joined by others with late registration open for the first two blind levels of the second day. After late registration, we will know the prize pool which currently stands at more than €437,000 and shortly after that the full payouts of the Main Event.
Day 1b chip leader Vlads Dolgilevics (pictured below) leads the way to start the day after advancing with 264,500. He is closely followed by Day 1c chip leader Phil Gross (261,500), Guillermo Cifuentes (253,000), Day 1a chip leader Feras Abid (221,000), and Kalle Parkkinen (218,100)
The plan for the day is to play eight more blind levels of one hour each. Your usual reporter Jason Glatzer will put down the pen and pick up the microphone as today is also the day of the inaugural Kings of Tallinn Summer Showdown €5,000 High Roller. However, the amazing Gia Carnestrom will take over with reporting starting after the first break when late registration is closed. Glatzer will be back on the floor for Day 3 and Day 4 of the Main Event until a winner is crowned.
Cards are scheduled to be in the air at noon with blinds at 600/1,200 along with a 1,200 big blind ante. Best of luck to all of the Main Event players!
Day 2 Seat Draw Posted Friday 28th July, 2023 at 09:53(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Ignacio Gonzales Garrido
66,500
55
1
2
Timo Tapio Koistinen
25,000
21
1
3
Casimir Lucas M. Seire
73,900
62
1
4
Jorgen Jakobsen
29,700
25
1
5
Sami M. O. Säämänen
65,300
54
1
6
Tapio Ilmari Aaltonen
212,600
177
1
8
Aleksejs Gusevs
31,500
26
1
9
Tomas Pinkevicius
22,900
19
2
1
Vlads Dolgilevics
264,500
220
2
2
Timo Petteri Laiho
24,200
20
2
3
Anders Auset
131,400
110
2
4
Henri Mikael Schalin
103,600
86
2
5
Ingus Arajs
83,900
70
2
7
Ville Heikki Juhana Konttinen
111,400
93
2
8
Andrei Mjagkov
53,400
45
2
9
Jani Alexanteri Tuovinen
87,500
73
3
1
Feras Michael Badir Abid
221,000
184
3
2
Ramunas Mika
42,600
36
3
3
Akseli Timonpoika Paalanen
67,000
56
3
4
Kent Ove Roed
80,100
67
3
5
Kaspars Butans
37,500
31
3
7
Johannes Hermann Többe
120,100
100
3
8
Mikael Johannes Haapaniemi
19,200
16
3
9
Joonas E. P. Helin
38,000
32
4
1
Anna-Mari Hursti
151,700
126
4
2
Jari-Pekka Juhola
64,400
54
4
3
Olli Juhani Muukkonen
84,500
70
4
4
Henri Pietari Wagner
93,500
78
4
5
Sebastian Ricken Van Wonterghem
168,800
141
4
6
Roope O. O. Tarmi
40,000
33
4
7
Julius Jesperi Tiihonen
27,500
23
4
8
Claudio Cecchi
76,300
64
5
1
Julius Kasperi Kettunen
38,100
32
5
2
Ivar Rühka
94,800
79
5
3
Alberto Martinez Gonzalez
24,000
20
5
4
Phil Gross
261,500
218
5
5
Thomas Haverstad
14,500
12
5
6
Michailas Miserkejevas
157,100
131
5
8
Jaana Kindsigo
75,900
63
5
9
Vaclav Hlasek
45,100
38
6
1
Jari Tapio Kärkkäinen
89,000
74
6
2
Sergei Oganesjan
22,300
19
6
3
Karolis Kutkauskas
191,100
159
6
5
Nick Martijn Penning
157,400
131
6
6
Victor Iglesias Descalzo
144,900
121
6
7
Patrick Johann Schratz
30,000
25
6
8
Anders Christiansen
58,900
49
6
9
Tarieli Ustiashvili
79,500
66
7
1
Niko Petro
80,100
67
7
2
Jordi Conejos Baixas
37,900
32
7
3
Peter Bumba
49,300
41
7
4
Pasi Tapani Sormunen
77,400
65
7
5
Kalle Tapani Lindholm
21,000
18
7
6
Harri Antero Juvonen
44,000
37
7
7
Pasi Pertti Aatos Laihinen
21,700
18
7
9
Sten Talviste
87,900
73
8
1
Yanis Mehdi Sahli
118,300
99
8
2
Vladislav Senkevic
64,200
54
8
3
Elias Oskari Vääräniemi
45,700
38
8
5
Daniel Jullumstro
105,700
88
8
6
Roope N.A Holma
96,300
80
8
7
Tarmo Tammel
20,200
17
8
8
Elias L. B. Suhonen
20,000
17
8
9
Christian Kay Steinbo
81,000
68
9
1
Tomas Ramanauskas
62,700
52
9
2
Fatih Gulgonul
55,200
46
9
3
Tomi Tapani Arponen
117,100
98
9
4
Kaido Mikk
36,800
31
9
6
Jari M.J. Mähönen
84,000
70
9
7
Guillermo Gordo Cifuentes
253,000
211
9
8
Touko Teivonpoika Berndtson
40,100
33
9
9
Markus L. Isosalo
50,900
42
10
1
James Noonan
24,500
20
10
2
Priit Vanem
30,000
25
10
3
Roni Robert Berg
49,500
41
10
4
Maksim Rusinov
90,100
75
10
5
Aleksandr Kuperman
51,700
43
10
6
Petteri Miettinen
42,500
35
10
7
Vu Hoang Vuong
38,400
32
10
8
Kevin Viktor Karenius
48,100
40
11
1
Maksim Petrov
32,500
27
11
2
Artjoms Hromovs
16,400
14
11
3
Georgi Abuladze
92,700
77
11
4
Janne Johannes Järvinen
66,500
55
11
5
Juan Carlos Vecino Duenas
163,800
137
11
6
Jussi P. K. Mattila
110,500
92
11
7
Steponas Venckus
36,900
31
11
9
Kai E. J. Lehto
101,300
84
12
1
Enea Subashi
82,400
69
12
3
Jargo Alaväli
213,000
178
12
4
Mario Antonio Colavita De La Grana
37,800
32
12
5
Kristaps Deksnis
130,400
109
12
6
Kasparas Klezys
88,100
73
12
8
Stefan Bittger
38,700
32
12
9
Jan Arthur Svendsen
62,000
52
13
2
Andres Aro
43,500
36
13
3
Viacheslav Sultanov
23,700
20
13
4
Andrey Koks
21,200
18
13
5
Anatoly Filatov
51,000
43
13
6
Eeti Tapani Löyttyniemi
8,300
7
13
8
Julian Herold
34,300
29
13
9
Espen Smorholm Sandvik
92,000
77
14
2
Konstantin Ärber
40,000
33
14
3
Erik Skjerven Borkvik
61,200
51
14
5
Jose M. H. Koistinen
18,200
15
14
6
Jan-Mikael Juhani Kesänen
106,700
89
14
7
Rafael Granados Gancedo
44,400
37
14
8
Hendrik Paul L. Diegenant
73,000
61
14
9
Ermo Kosk
105,200
88
15
1
Kaidar Viikman
46,700
39
15
2
Magnus Pukk
171,400
143
15
4
Markku Koplimaa
160,500
134
15
5
Urmo Velvelt
75,300
63
15
6
Vegard Aafedt Bukve
14,700
12
15
7
Tõnis Viik
34,600
29
15
8
Kasparas Drazdauskas
36,000
30
15
9
Kaius Kiidli
18,800
16
16
2
Ivar Vendelin
58,100
48
16
3
Aleksandr Jelpidiforov
32,200
27
16
5
Hein Haraldsen
53,800
45
16
6
Tuomas Mikael Jalonen
32,400
27
16
7
Sebastian Wahl
78,000
65
16
8
Luigi Tasca
20,800
17
16
9
Liutauras Armanavicius
57,400
48
17
1
Niki Juhani Nurmisto
55,900
47
17
2
Thor William Holm Morstol
45,300
38
17
4
Sergei Aleksejev
11,300
9
17
5
Luis Rodriguez Cruz
59,200
49
17
6
Kristaps Renga
134,400
112
17
7
Kalle Elmeri Parkkinen
218,100
182
17
9
Janne M. T. Nevalainen
67,400
56
18
1
Adria Comas I Roura
103,300
86
18
2
Henrik Veldhoen
28,900
24
18
3
Kaido Koorits
64,400
54
18
4
Oskar Ojaveer
29,300
24
18
6
Max August Avela
47,100
39
18
7
Vygerdas Jonikas
71,800
60
18
9
Aleksi Mikael Naski
67,400
56
19
1
Georgina James
85,900
72
19
2
Edgars Beizaks
45,500
38
19
4
Ville-Matti Keränen
74,300
62
19
5
Teemu Kalevi Leppälahti
67,300
56
19
7
Amid Zulkowitz
47,500
40
19
8
Raffael Wadl
37,900
32
19
9
Massimo Casabona
47,000
39
20
1
Aki Taisto Olavi Pyysing
49,800
42
20
2
Herli Olop
49,300
41
20
4
Matias Juhani Kesänen
41,100
34
20
5
Eetu Mikael Porkka
32,000
27
20
6
Mart Tammoja
28,400
24
20
8
Mauri Kristjan Dorbek
207,400
173
20
9
Henning Gunnar Andre
79,000
66
21
1
Mark Metsla
105,500
88
21
2
Paul Koppe
41,000
34
21
4
Siim Suviste
74,000
62
21
5
Jari Juhani Porkka
68,500
57
21
6
Dmitrijs Kornevs
58,900
49
21
7
Teemu Aukusti Toikkanen
42,500
35
21
8
Silver Simulask
25,200
21
21
9
Karlo Kivi
56,800
47
22
1
Martin Piik
65,300
54
22
3
Stephane Pascal Cordeille
75,600
63
22
4
Kristaps Sipols
30,900
26
22
5
Igor Pihela
79,200
66
22
6
Jorn Martinsen
27,400
23
22
7
Ville J. S. Pohjalainen
81,900
68
22
8
Harri Robert Seppä
80,900
67
22
9
Grantas Naujokas
70,400
59
25
1
Roberto Raffaele Caprio
69,800
58
25
2
Lars Emil Nydegger
27,500
23
25
4
Benjamin Arthur Victor Gros
67,500
56
25
5
Nils Jakob Elias Linden
134,900
112
25
6
Patrick Pfeiffer
21,000
18
25
8
Vadims Milovs
50,200
42
25
9
Sami Aleksi Pulliainen
82,000
68
26
1
Kasper J. O. Mellanen
28,800
24
26
3
Totti Matias Arosuo
60,800
51
26
4
Kristian Peder Larsson
62,100
52
26
6
Kaspar Laursoo
208,700
174
26
7
Juho H. S. Heiska
55,700
46
26
8
Christian Arstad
42,200
35
26
9
Jarmo Juhani Salonen
45,600
38
27
1
Tero Tapio Laurila
91,500
76
27
2
Ilya Nikiforov
96,900
81
27
3
Kaspars Kalnozols
127,900
107
27
5
Hengtao Zhu
49,600
41
27
6
Inigo Serrano Robles
49,300
41
27
8
Stanislav Smeljov
28,900
24
27
9
Tero Petteri Kilkanen
41,000
34
28
1
Hendrik Uibo
33,200
28
28
4
Jyrki Olavi Lampinen
59,200
49
28
5
Tarjei Forus
58,200
49
28
6
Tomi Petri Bondarew
22,900
19
28
7
Igor Pihela Jun.
149,100
124
28
8
Samuli Tero Hietala
45,700
38
28
9
Keito Kaljulaid
125,400
105
09:52 (UTC+0)
Day 2 of Kings of Tallinn Summer Showdown 2023 Started Level: 9 Blinds: 600/1,200 Ante: 1,200
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
