0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0066 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/90/updates'
ORDER BY `views` DESC
0.0004 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.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
0.0212 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1
0.0204 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '83'
AND `published` = 1
0.0208 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '85'
AND `published` = 1
0.0214 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '86'
AND `published` = 1
0.0209 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '90'
AND `published` = 1
0.0214 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0102 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '90'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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` = '90'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4259'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4251'
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` = '4250'
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` = '4248'
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` = '4244'
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` = '4241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4239'
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` = '4235'
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` = '4230'
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` = '4229'
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` = '4217'
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` = '4214'
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` = '4211'
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` = '4208'
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` = '4207'
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` = '4202'
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` = '4196'
ORDER BY `chip_change` DESC, `busted` ASC
0.0152 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4186'
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` = '4182'
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` = '4179'
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` = '4178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4173'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4170'
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` = '4165'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4163'
ORDER BY `chip_change` DESC, `busted` ASC
0.0395 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4159'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4158'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4152'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4143'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4135'
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` = '4132'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4129'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4114'
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` = '4112'
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` = '4107'
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` = '4101'
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` = '4091'
ORDER BY `chip_change` DESC, `busted` ASC
0.0157 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4090'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4087'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4075'
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` = '4072'
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` = '4070'
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` = '4069'
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` = '4065'
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` = '4063'
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` = '4056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4053'
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` = '4050'
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` = '4045'
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` = '4042'
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` = '4038'
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` = '4034'
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` = '4033'
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` = '4032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4031'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '90'
ORDER BY `busted` ASC, `current_chips` DESC
0.0045 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` = '90'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4259'
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` = '4251'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4250'
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` = '4248'
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` = '4244'
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` = '4241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4239'
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` = '4235'
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` = '4230'
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` = '4229'
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` = '4217'
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` = '4214'
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` = '4211'
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` = '4208'
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` = '4207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4202'
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` = '4196'
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` = '4193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0207 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4182'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4179'
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` = '4178'
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` = '4173'
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` = '4170'
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` = '4165'
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` = '4163'
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` = '4159'
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` = '4158'
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` = '4152'
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` = '4143'
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` = '4135'
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` = '4132'
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` = '4129'
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` = '4130'
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` = '4122'
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` = '4114'
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` = '4112'
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` = '4107'
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` = '4101'
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` = '4091'
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` = '4090'
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` = '4087'
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` = '4075'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4072'
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` = '4070'
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` = '4069'
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` = '4065'
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` = '4063'
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` = '4056'
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` = '4054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4053'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4050'
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` = '4045'
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` = '4042'
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` = '4038'
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` = '4034'
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` = '4033'
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` = '4032'
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` = '4031'
ORDER BY `chip_change` DESC, `busted` ASC
0.0186 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.0004 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
Final Day 3 Chip Counts Posted Sunday 30th July, 2023 at 02:23(UTC+0) by Jason Glatzer
Place
Player
Chips
Big Blinds
1
Kai Lehto
3,020,000
50
2
Urmo Velvelt
2,665,000
44
3
Tarmo Tammel
2,340,000
39
4
Mikael Haapaniemi
2,130,000
36
5
Magnus Pukk
1,605,000
27
6
Tomi Arponen
1,535,000
26
7
Phil Gross
1,360,000
23
8
Nils Linden
990,000
17
9
Ville-Matti Keranen
730,000
12
10
Tapio Aaltonen
345,000
6
Player
Chips
Progress
Kai Lehto
3,320,000
75,000
Urmo Velvelt
2,665,000
95,000
Tarmo Tammel
2,340,000
610,000
Mikael Haapaniemi
2,130,000
90,000
Magnus Pukk
1,605,000
635,000
Tomi Arponen
1,535,000
155,000
Phil Gross
1,360,000
240,000
Nils Linden
990,000
305,000
Ville-Matti Keranen
730,000
905,000
Tapio Aaltonen
345,000
375,000
23:12 (UTC+0)
Start of Level 27 Blinds: 25,000/50,000 Ante: 50,000
Updated Chip Counts Posted Saturday 29th July, 2023 at 23:09(UTC+0) by Jason Glatzer
Player
Chips
Big Blinds
Kai Lehto
3,395,000
68
Urmo Velvelt
2,760,000
55
Mikael Haapaniemi
2,040,000
41
Tarmo Tammel
1,730,000
35
Ville-Matti Keränen
1,635,000
33
Phil Gross
1,600,000
32
Tomi Arponen
1,380,000
28
Magnus Pukk
970,000
19
Tapio Aaltonen
720,000
14
Nils Linden
685,000
14
Ilya Nikiforov Out at TV Table and Break Posted Saturday 29th July, 2023 at 22:57(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 10/564
Ilya Nikiforov just hit the rail moments before the break at the TV table. The action will resume one player away from the final table after a short 15-minute break.
Player
Chips
Progress
Ilya Nikiforov
0
0
Gross Doubles Again Posted Saturday 29th July, 2023 at 22:39(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 11/564
Phil Gross doubled his short stack before doubling it again in the following hand.
There wasn't much in the pot when Mikael Haapaniemi checked-raised the flop from 75,000 to 300,000. Gross jammed for 670,000 and Haapaniemi called.
Phil Gross: Mikael Haapaniemi:
Both players had the same flush draw with Gross drawing to the nuts. However, Gross was behind Haapaniemi's sevens if no spade came with both players holding blockers to each other. The turn was irrelevant but the river pushed Gross ahead with a better pair.
"Yes!" said Gross as his rail cheered.
Player
Chips
Progress
Mikael Haapaniemi
2,500,000
700,000
Phil Gross
1,400,000
600,000
Big Slick for Aaltonen Posted Saturday 29th July, 2023 at 22:19(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 11/564
Mikael Haapaniemi jammed from the small blind. Tapio Aaltonen (pictured below) looked down at his cards and called off his stack of 350,000.
Tapio Aaltonen: Mikael Haapaniemi:
Haapaniemi didn't soar past Aaltonen's big slick on the and Aaltonen let out a big smile after doubling his stack instead taking a bad beat and going to the rail.
Player
Chips
Progress
Mikael Haapaniemi
3,200,000
90,000
Tapio Aaltonen
740,000
170,000
Velvelt Dispatches Filatov Posted Saturday 29th July, 2023 at 22:12(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 11/564
GGPoker Ambassador Anatoly Filatov (pictured below) had a bit of bad luck losing two hands while he was ahead when the action was down to two tables. Moments ago, he lost a crucial flip and hit the rail in 12th place for €5,300 as follows.
Filatov three-bet jammed for 650,000 from the big blind and was called by Urmo Velvelt who opened from middle position.
Anatoly Filatov: Urmo Velvelt:
Velvelt connected not only connected but improved to a full house on the board to oust the most accomplished player that was remaining in the field.
Player
Chips
Progress
Urmo Velvelt
2,600,000
1,515,000
Anatoly Filatov
0
0
Heiska Out at TV Table Posted Saturday 29th July, 2023 at 22:08(UTC+0) by Jason Glatzer
Level 26: 20,000/40,000 (40,000) Entries: 12/564
Juho Heiska hit the rail at the TV table during the opening moments of Level 26 in 13th place for €4,500.
He got it in from the cutoff with suited against Ville-Matti Keranen's . You can check out the hand on the stream at OlyBet.tv.
Player
Chips
Progress
Ville-Matti Keranen
1,100,000
315,000
Juho Heiska
0
0
21:58 (UTC+0)
Start of Level 26 Blinds: 20,000/40,000 Ante: 40,000
Arponen Cracks Filatov's Cowboys Posted Saturday 29th July, 2023 at 21:56(UTC+0) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 13/564
"Just when I thought I was out, they pulled me back in," is a famous saying from the Sopranos. That saying applies to Tomi Arponen (pictured below) after he delivered GGPoker Ambassador Anatoly Filatov a bad beat.
Mikael Haapaniemi opened for a min-raise from the button before Arponen three-bet shoved for 365,000 from the small blind. Filatov four-bet shoved for close to 1,000,000 and Haapaniemi got out of the way.
Tomi Arponen: Anatoly Filatov:
It looked like we would be down to a dozen players but we remained at a dirty dozen but not without some drama. Nothing fancy happened on either the flop or the turn. Arponen began to stand up and even wished a player a 'good game' before shock came across on his face with the spiking the river to pull ahead of Filatov with a full house.
The rail around the outer table erupted as well. Filatov appeared to take it all well and just continued along with his massage despite suffering two bad beats this blind level in all-in and call situations.
Player
Chips
Progress
Tomi Arponen
850,000
275,000
Anatoly Filatov
600,000
1,100,000
Gross Delivers Bad Beat to Filatov Posted Saturday 29th July, 2023 at 21:06(UTC+0) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 13/564
Phil Gross three-bet shoved over the open by Anatoly Filatov for 375,000 and Filatov called.
Phil Gross: Anatoly Filatov:
Gross was asking for a jack and none came on the flop. He shouted from joy after the turn pushed him ahead and now begged the dealer not to deal a queen. Instead, it was the completing the board for Gross to double with two pair.
Player
Chips
Progress
Anatoly Filatov
1,700,000
425,000
Phil Gross
800,000
425,000
Updated Chip Counts Posted Saturday 29th July, 2023 at 21:02(UTC+0) by Jason Glatzer
Player
Chips
Big Blinds
Mikael Haapaniemi
3,110,000
104
Anatoly Filatov
2,125,000
71
Kai Lehto
2,100,000
70
Magnus Pukk
1,745,000
58
Ilya Nikiforov
1,550,000
52
Tarmo Tammel
1,490,000
50
Urmo Velvelt
1,085,000
36
Tapio Aaltonen
910,000
30
Ville-Matti Keranen
785,000
26
Tomi Arponen
575,000
19
Nils Linden
540,000
18
Juho Heiska
525,000
18
Phil Gross
375,000
13
Player
Chips
Progress
Mikael Haapaniemi
3,110,000
330,000
Anatoly Filatov
2,125,000
1,055,000
Kai Lehto
2,100,000
175,000
Magnus Pukk
1,745,000
1,145,000
Ilya Nikiforov
1,550,000
60,000
Tarmo Tammel
1,490,000
1,170,000
Urmo Velvelt
1,085,000
215,000
Tapio Aaltonen
910,000
100,000
Ville-Matti Keranen
785,000
307,000
Tomi Arponen
575,000
200,000
Nils Linden
540,000
65,000
Juho Heiska
525,000
545,000
Phil Gross
375,000
75,000
20:53 (UTC+0)
Start of Level 25 Blinds: 15,000/30,000 Ante: 30,000
Break Time Posted Saturday 29th July, 2023 at 20:35(UTC+0) by Jason Glatzer
The final 13 players are on a short 20-minute break. Blinds will increase to 15,000/30,000 with a 30,000 big blind ante when the action resumes.
Abid Out at TV Table Posted Saturday 29th July, 2023 at 20:34(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 13/564
Yet another elimination happened at the TV table. This time it was the formidable Feras Abid hitting the rail in 14th place for €4,500.
Player
Chips
Progress
Feras Abid
0
0
"I am the Best!" Posted Saturday 29th July, 2023 at 20:19(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 14/564
Phil Gross (pictured below) defended his big blind from the under the gun open by Urmo Velvelt before he jammed the 145,000 in chips he had remaining on the flop. Velevelt quickly called and the cards were turned over with Gross at risk.
Phil Gross: Urmo Velvelt:
Gross was grossly behind and that didn't change on the turn. However, the improved him to two pair to stay alive and double his stack.
"I am the best!" shouted an entertaining Gross at the table.
Velvelt appreciated the humor and was the first to laugh.
Player
Chips
Progress
Urmo Velvelt
1,300,000
65,000
Phil Gross
450,000
230,000
Two More Out at the TV Table Posted Saturday 29th July, 2023 at 20:12(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 14/564
Table redraw or no table redraw, it seems fireworks are taking place once again at the TV table as we are down to just 14 hopefuls Karolis Kutkauskas (pictured below) and Siim Suviste (pictured below Kutkauskas) hit the rail.
Player
Chips
Progress
Siim Suviste
0
0
Karolis Kutkauskas
0
0
Two Table Seat Draw and Updated Chip Counts Posted Saturday 29th July, 2023 at 20:05(UTC+0) by Jason Glatzer
Table
Seat
Player
Country
Chips
Big Blinds
11
1
Anatoly Filatov
Estonia
1,070,000
43
11
2
Tapio Aaltonen
Finland
810,000
32
11
3
Phil Gross
Germany
680,000
27
11
4
Urmo Velvelt
Estonia
1,365,000
55
11
5
Tarmo Tammel
Estonia
320,000
13
11
6
Mikael Haapaniemi
Finland
2,780,000
111
11
7
Tomi Arponen
Finland
775,000
31
11
8
Feras Abid
Finland
335,000
13
18
1
Siim Suviste
Estonia
460,000
18
18
2
Juho Heiska
Finland
1,070,000
43
18
3
Ville-Matti Keränen
Finland
400,000
16
18
4
Karolis Kutkauskas
Lithuania
370,000
15
18
5
Ilya Nikiforov
Estonia
1,610,000
64
18
6
Nils Linden
Denmark
475,000
19
18
7
Kai Lehto
Finland
1,925,000
77
18
8
Magnus Pukk
Estonia
600,000
24
Rumba Dusts It Off to Laiho Posted Saturday 29th July, 2023 at 19:53(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 16/564
The clock has stopped as the action is down to just two tables. There will be a redraw after Roberts Rumba dusted off his small stack with ace-trey to Kai Lehto's nine-seven after a seven hit the turn.
The final 16 players locked up at least €4,500 and the plan of the day is for players to bag up their stacks when the final table of nine players were reached.
Player
Chips
Progress
Kai Lehto
1,600,000
200,000
Roberts Rumba
0
0
Lehto Doubles Through Rumba Posted Saturday 29th July, 2023 at 19:50(UTC+0) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 17/564
Kai Lehto three-bet jammed the button for 670,000 and was called by a frustrated Roberts Rumba from the big blind.
Kai Lehto: Roberts Rumba:
It was a classic coin flip with Rumba pulling ahead after the flop and the turn. However, the spiked the river for Lehto to double his stack.
"Why is this always happening?" Rumba asked after losing yet another flip.
Rumba did double up his crumbs a short while later when his ace-deuce was good against jack-four but this didn't add too much breathing room to his stack.
Meanwhile, mayhem must be taking place at the TV as both Vygerdas Jonikas and Vlads Dolgilevics hit the rail under the lights and camera.
Player
Chips
Progress
Kai Lehto
1,400,000
995,000
Roberts Rumba
120,000
380,000
Vygerdas Jonikas
0
0
Vlads Dolgilevics
0
0
GG Gordo Posted Saturday 29th July, 2023 at 19:32(UTC+0) by Jason Glatzer
Guillermo Gordo Cifuentes hit the rail at the TV table in 20th place for €3,900. You can check out the action at OlyBet.tv.
Player
Chips
Progress
Guillermo Cifuentes
0
0
19:29 (UTC+0)
Start of Level 24 Blinds: 10,000/25,000 Ante: 25,000
Big Slick Good for Aaltonen Posted Saturday 29th July, 2023 at 19:29(UTC+0) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 20/564
It was a blind-on-blind battle between Roberts Rumba and Tapio Aaltonen with Altonen getting his 470,000 stack in the middle from the big blind and getting called by Rumba.
Tapio Aaltonen: Roberts Rumba:
Both players had premium cards in a cooler of a hand for Rumba. Aaltonen doubled his stack after the dry board kept ace-king ahead of ace-queen.
Player
Chips
Progress
Tapio Aaltonen
960,000
505,000
Roberts Rumba
500,000
395,000
Pihela Jr. Runs Into a Flush Posted Saturday 29th July, 2023 at 19:16(UTC+0) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 20/564
Igor Pihela Jr. just hit the rail around the same time Tomi Arponen doubled through Siim Suviste. The table shared that he min-raised with ace-jack. Flopped top pair but ran into a flush held by the player in the big blind.
Player
Chips
Progress
Igor Pihela Jr.
0
0
Cowboys for Arponen Posted Saturday 29th July, 2023 at 19:12(UTC+0) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 21/564
Siim Suveste min-raised from early position. Tomi Arponen (pictured below) three-bet the button to 130,000. Suveste ripped it in with a four-bet that covered the 630,000 Arponen had in his stack. Arponen called to create a pot north of 1 million in chips with Arponen at risk.
Tomi Arponen: Siim Suveste: .
Suveste improved to top pair on the flop but Arponen had that dominated with a set of cowboys. Arponen still had a sweat with a ten to Broadway for Silveste along with some backdoor outs. But the turn and river were drama free for Arponen to take a huge chunk from Suveste's stack.
Player
Chips
Progress
Tomi Arponen
1,300,000
400,000
Siim Suviste
250,000
650,000
A No Look Big Slick No Good for Penning Posted Saturday 29th July, 2023 at 18:42(UTC+0) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 21/564
Nick Penning (pictured below) came back from dinner break with just half a big blind. He folded a few hands until he tossed it in blind from under the gun.
Tapio Altonen limped from the small blind and Siim Suviste checked back his option from the big blind.
Tapio check-folded facing a bet of 25,000 from Suviste after the landed on the flop and the cards were turned over.
Nick Penning: Siim Suviste:
Penning was shocked at what he turned over but he was behind the two pair held by Suviste. Neither the turn nor the river helped start a Cinderella story for Penning and the tournament was down to 21 players.
Player
Chips
Progress
Siim Suviste
900,000
145,000
Nick Penning
0
0
Olop Loses Two Flips Posted Saturday 29th July, 2023 at 18:35(UTC+0) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 22/564
Herli Olop had an amazing run. But sometimes, good things must come to an end. Olop lost most of his 210,000 stack to Feras Abid after his eights were unable to win a flip against king-jack. Soon after, he lost the rest on another flip with sevens against Tomi Arponen's queen-jack.
Player
Chips
Progress
Tomi Arponen
900,000
25,000
Feras Abid
280,000
150,000
Herli Olop
0
0
18:23 (UTC+0)
Start of Level 23 Blinds: 10,000/20,000 Ante: 20,000
Updated Chip Counts at Dinner Break of Final 23 Players Posted Saturday 29th July, 2023 at 18:13(UTC+0) by Jason Glatzer
Place
Name
Chips
Big Blinds
1
Mikael Haapaniemi
2,405,000
120
2
Urmo Velvelt
1,365,000
68
3
Ilya Nikiforov
1,160,000
58
4
Magnus Pukk
960,000
48
5
Roberts Rumba
895,000
45
6
Tomi Arponen
875,000
44
7
Siim Suviste
755,000
38
8
Vygerdas Jonikas
690,000
35
9
Phil Gross
680,000
34
10
Vlads Dolgilevics
674,000
34
11
Nils Linden
595,000
30
12
Juho Heiska
575,000
29
13
Ville-Matti Keranen
478,000
24
14
Tapio Aaltonen
455,000
23
15
Kai Lehto
405,000
20
16
Guillermo Cifuentes
352,000
18
17
Igor Pihela Jr.
330,000
17
18
Karolis Kutkauskas
326,000
16
19
Anatoly Filatov
213,000
11
20
Herli Olop
210,000
11
21
Tarmo Tammel
170,000
9
22
Feras Abid
130,000
7
23
Nick Penning
10,000
1
Dinner Break Posted Saturday 29th July, 2023 at 17:17(UTC+0) by Jason Glatzer
Players are on a one-hour dinner break. We will update the full chip counts during the second half of the break. Bon appétit!
"You Can Watch it on TV Later" Posted Saturday 29th July, 2023 at 16:38(UTC+0) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 23/564
Phil Gross three-bet from the small blind preflop to bring the pot close to 200,000 after Mikael Haapaniemi called from the button.
Gross was quietly speaking in a whisper to Haapaniemi throughout the hand including after he continued for 100,000 on the flop. Haapaniemi called and Gross jammed the turn for 318,000.
Haapaniemi went into the tank and asked for a count. He appeared to be in pain about what to do and checked his cards more than once while also occasionally responding to the small talk by Gross.
Eventually, Haapaniemi folded and asked Gross if he'd show his hand.
"You can watch it on TV later," joked Gross as he was on the feature table earlier today.
A few seconds later, Gross showed his for an overpair to the board as the dealer began pushing the pot to him.
Meanwhile, Hendrik Diegenant hit the rail shortly before this hand in 24th place.
Player
Chips
Progress
Mikael Haapaniemi
1,325,000
52,000
Phil Gross
810,000
404,000
Players Cashing for €3,300 Posted Saturday 29th July, 2023 at 16:09(UTC+0) by Jason Glatzer
Place
Player
Prize
25
Touko Berndtson
€3,300
26
Patrick Schantz
€3,300
27
Kristian Larsson
€3,300
28
Anna-Mari Hursti
€3,300
29
Joonas Helin
€3,300
30
Edgars Beizaks
€3,300
31
Jari Saviaho
€3,300
32
Stefan Bittger
€3,300
Pihela Jr. Ousts Berndtson Posted Saturday 29th July, 2023 at 16:06(UTC+0) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 24/564
Touko Berndtson (pictured below) jammed the button for about five big blinds and was called by Igor Pihela Jr. from the big blind.
Touko Berndtson: Igor Pihela Jr.:
The flop improved Berndston to a pair but it wasn't as big of a pair as his opponent's paired-up jack. Neither the turn nor the river were cards Berndtson wanted to see and there will be a three-table redraw for the remaining 24 players after he hit the rail.
The action is resuming very soon and we will wait until the upcoming dinner break after this blind level to update the full chip counts of all remaining players.
Player
Chips
Progress
Igor Pihela Jr.
980,000
300,000
Touko Berndtson
0
0
15:55 (UTC+0)
Start of Level 22 Blinds: 10,000/15,000 Ante: 15,000
Slow Blind Level Posted Saturday 29th July, 2023 at 15:54(UTC+0) by Jason Glatzer
Level 21: 7,000/14,000 (14,000) Entries: 25/564
As is the case in most well-structured tournaments, there becomes a time when the action slows down before it heats up again.
After a flurry of eliminations, the action was slow most of Level 21. Patrick Schratz (pictured below) was one of two players to hit the rail during the level.
There will be a table redraw after we lose one more unfortunately sole from the Main Event.
Larsson Dusts Off His Short Stack Posted Saturday 29th July, 2023 at 15:21(UTC+0) by Jason Glatzer
Level 21: 7,000/14,000 (14,000) Entries: 26/564
Kristian Larsson (pictured below) was all-in from the big blind when Touko Berndtson limped from late position and Igor Pihela Jr. limped from the small blind to see the flop.
Pihela Jr. check-called a min-bet of 140,000 by Berndstson before both players checked the turn.
The river completed the board. Pihela Jr. checked again. Berndston fired out for 55,000 and Pihela's cards went into the muck nearly as fast as Berndston chips went into the pot.
Larsson turned over the which didn't get the job done against Berndtson's . Meanwhile, Anna-Mari Hursti just hit the rail right before this hand. She was not only the last woman standing in the Main Event, but also the €555 Championship.
Player
Chips
Progress
Igor Pihela Jr.
680,000
495,000
Touko Berndtson
400,000
162,000
Kristian Larsson
0
0
Anna-Mari Hursti
0
0
15:01 (UTC+0)
Start of Level 21 Blinds: 7,000/14,000 Ante: 14,000
Big Stacks at Break Posted Saturday 29th July, 2023 at 15:01(UTC+0) by Jason Glatzer
Player
Chips
Progress
Siim Suviste
1,680,000
280,000
Juho Heiska
1,357,000
627,000
Mikael Haapaniemi
1,273,000
313,000
Vlads Dolgilevics
1,250,000
540,000
Urmo Velvelt
1,000,000
749,000
Karolis Kutkauskas
800,000
150,000
Beizaks Runs Into Suviste's One Outer Posted Saturday 29th July, 2023 at 14:40(UTC+0) by Jason Glatzer
Level 20: 6,000/12,000 (12,000) Entries: 29/564
Jari Saviaho three-bet jammed for 250,000 from the button and was called by Siim Suviste from the small blind before Edgars Beizaks (pictured below), who originally opened, four-bet shoved for 450,000. Suviste asked for a count and about 30 seconds later found a call.
Jari Saviaho: Edgars Beizaks: Siim Suviste:
"Oh nice," Saviaho said about his ace being live. "Ace!"
While Saviaho needed some help it seemed like a dream spot for Beizaks as even if the ace came Silveste had only one out for a set. So, it seemed at least the side pot was in Beizaks' pocket. Dreams were shattered for Beizaks, but he took it well, after the case jack popped up on the board for Suviste to send Saviaho and Beizaks to the rail while likely taking the chip lead.
Players went on break shortly after this hand. We will update some of the top stacks from around the room during the break.
Player
Chips
Progress
Siim Suviste
1,400,000
1,012,000
Jari Saviaho
0
0
Edgars Beizaks
0
0
Players Cashing for €3,000 Posted Saturday 29th July, 2023 at 14:21(UTC+0) by Jason Glatzer
The following players including the start-of-the-day chip leader Juan Carlos Vecino Duenas (pictured above).
Place
Player
Prize
33
Lukas Rutkauskas
€3,000
34
Yanis Sahli
€3,000
35
James Noonan
€3,000
36
Aleksi Naski
€3,000
37
Christian Steinbo
€3,000
38
Jaana Kindsigo
€3,000
39
Juan Carlos Vecino Duenas
€3,000
40
Samuli Hietala
€3,000
Player
Chips
Progress
Samuli Hietala
0
0
Juan Carlos Vecino Duenas
0
0
Jaana Kindsigo
0
0
Christian Steinbo
0
0
Aleksi Naski
0
0
James Noonan
0
0
Yanis Sahli
0
0
Lukas Rutkauskas
0
0
13:44 (UTC+0)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Full House Not Strong Enough for Noonan Posted Saturday 29th July, 2023 at 13:44(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 40/564
There was a 700,000 pot with the chips getting in on the river with the on the board. James Noonan turned over the for a full house.
He was on the losing end of the pot as Kristian Larsson (pictured below) turned over for a better full house to earn a full double-up.
Player
Chips
Progress
Kristian Larsson
700,000
434,000
James Noonan
190,000
192,000
Igor Pihela Jr.
185,000
15,000
Players Cashing for €2,700 Posted Saturday 29th July, 2023 at 13:39(UTC+0) by Jason Glatzer
Place
Player
Prize
41
Daniel Jullumstro
€2,700
42
Jordi Baixas
€2,700
43
Hein Haraldsen
€2,700
44
Kasper Mellanen
€2,700
45
Matias Arosuo
€2,700
46
Andrei Mjagkov
€2,700
47
Mauri Dorbek
€2,700
48
Dmitrijs Kornevs
€2,700
Player
Chips
Progress
Andrei Mjagkov
0
0
Matias Arosuo
0
0
Kasper Mellanen
0
0
Hein Haraldsen
0
0
Jordi Baixas
0
0
Daniel Jullumstro
0
0
Dorbek Done Multi-Tabling Posted Saturday 29th July, 2023 at 13:01(UTC+0) by Jason Glatzer
Level 19: 5,000/10,000 (10,000) Entries: 46/564
Mauri Dorbek was running back and forth between the €150 GGPoker Flip&Go Mystery Bounty and the Main Event. Although he likely would have wished to continue this pattern, he will now be able to focus solely on the Mystery Bounty where he has some chips after losing his short stack in the Main Event.
Dorbek jammed for 45,000 from middle position and was called by Roberts Rumba.
Mauri Dorbek: Roberts Rumba:
Dorbek stood up and looked ready to run as soon as he saw how dominating his opponent's hand was. He stuck around to watch both the flop and the turn as he was drawing eight outs to a chop. The river paired the board and Dorbek hit the rail in 47th place. We wish him the best of luck in the Mystery Bounty!
Player
Chips
Progress
Roberts Rumba
325,000
45,000
Dmitrijs Kornevs
0
0
Mauri Dorbek
0
0
Big Stacks at Break Posted Saturday 29th July, 2023 at 12:42(UTC+0) by Jason Glatzer
Player
Chips
Progress
Juan Carlos Vecino Duenas
920,000
211,000
Anatoly Filatov
750,000
50,000
Juho Heiska
730,000
290,000
Nils Linden
700,000
0
Karolis Kutkauskas
650,000
0
Jordi Baixas
610,000
438,000
Anna-Mari Hursti
555,000
335,000
Magnus Pukk
512,000
191,000
12:38 (UTC+0)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
First Break Posted Saturday 29th July, 2023 at 12:23(UTC+0) by Jason Glatzer
Players are on their first break of Day 3. Blinds will increase to 5,000/10,000 with a 10,000 big blind ante when the action resumes.
Player
Chips
Progress
Anatoly Filatov
750,000
430,000
Nils Linden
700,000
142,000
Karolis Kutkauskas
650,000
324,000
Players Cashing for €2,400 Posted Saturday 29th July, 2023 at 12:17(UTC+0) by Jason Glatzer
Place
Player
Prize
49
Keito Kaljulaid
€2,400
50
Ranno Sootla
€2,400
51
Anders Auset
€2,400
52
Tero Kilkanen
€2,400
53
Henri Schalin
€2,400
54
Kasparas Klezys
€2,400
55
Maksim Rusinov
€2,400
56
Kaspar Laursoo
€2,400
Player
Chips
Progress
Keito Kaljulaid
0
0
Rumba Rivers Broadway Posted Saturday 29th July, 2023 at 12:14(UTC+0) by Jason Glatzer
Level 18: 4,000/8,000 (8,000) Entries: 49/564
Roberts Rumba four-bet jammed for 178,000 from the hijack and was called by Ilya Nikiforov from the button.
Roberts Rumba: Ilya Nikiforov:
It wasn't looking great for Rumba although oddly enough he gained some outs despite a king hitting the flop on the flop as now he had four jacks to draw to instead of three queens.
The turn didn't create any drama. However, Rumba shouted "yes" in delight after the river completed his Broadway draw to double his stack instead of hitting the rail.
Player
Chips
Progress
Roberts Rumba
370,000
292,000
Ilya Nikiforov
300,000
42,000
Maksim Rusinov
0
0
Kasparas Klezys
0
0
Henri Schalin
0
0
Tero Kilkanen
0
0
Anders Auset
0
0
Ranno Sootla
0
0
Payouts for €2,200 Posted Saturday 29th July, 2023 at 11:29(UTC+0) by Jason Glatzer
The following players including Harri Seppa (pictured above) banked €2,200 in the Main Event with the remaining field locking up at least a €2,400 payout.
Place
Player
Prize
57
Kaido Mikk
€2,200
58
Kristaps Deksnis
€2,200
59
Harri Seppa
€2,200
60
Espen Sandvik
€2,200
61
Luis Cruz
€2,200
62
Sebastian Van Wonterghem
€2,200
63
Ramunas Mika
€2,200
64
Grantas Naujokas
€2,200
11:24 (UTC+0)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Filatov Calls With a "Very Bad Hand" to Eliminate Laursoo Posted Saturday 29th July, 2023 at 11:23(UTC+0) by Jason Glatzer
Level 18: 4,000/8,000 (8,000) Entries: 56/564
Kaspar Laursoo (pictured below) four-bet jammed from the small blind. One player folded before GGPoker Ambassador Anatoly Filatov appeared to get his hand caught in the cookie jar.
"I have a very bad hand," Filatov said.
A few players couldn't hold back their laugh and shortly after Filatov called.
Kaspar Laursoo: Anatoly Filatov:
Laursoo was still ahead in the hand after the safe flop. However, he got out of his chair and began to gather his belongings after Filatov paired up on the turn. The river didn't get Laursoo back into the hand and he hit the rail early on Day 3.
Player
Chips
Progress
Anatoly Filatov
320,000
107,000
Harri Seppa
0
0
Kristaps Deksnis
0
0
Kaido Mikk
0
0
Kaspar Laursoo
0
0
Sandvik Loses a Flip & His Stack to Dolgilevics Posted Saturday 29th July, 2023 at 11:09(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 59/564
Yesterday's start-of-the-day chip leader Vlads Dolgilevics (pictured below) opened from the cutoff and was called by Vygerdas Jonikas from the button.
WSOP bracelet winner Espen Sandvik ripped it in for 25 big blinds. Dolgilevics called and Jonikas folded.
Espen Sandvik: Vlads Dolgilevics:
Dolgilevics won the flip after his queen found a friend on the board to eliminate the formidable Sandvik.
It is also time to say goodbye to Sandvik as after the hand he shared he will be leaving today to spend time with some of his family in Norway. As always, it was a pleasure to watch you compete throughout the week and we hope to see you at the WSOP Circuit Tallinn on Sept. 14-24.
Player
Chips
Progress
Vlads Dolgilevics
710,000
36,000
Ramunas Mika
0
0
Sebastian Van Wonterghem
0
0
Luis Cruz
0
0
Espen Sandvik
0
0
Min-Cash Club Posted Saturday 29th July, 2023 at 10:45(UTC+0) by Jason Glatzer
The following players (including Jargo Alavali pictured below) min-cashed the Main Event for €2,000. The remaining 64 players each locked up at least €2,200 with many more pay jumps to come.
Place
Player
Prize
65
Matias Kesanen
€ 2,000
66
Jargo Alavali
€ 2,000
67
Konstantin Ärber
€ 2,000
68
Kalle Parkkinen
€ 2,000
79
Martin Piik
€ 2,000
70
Julian Herold
€ 2,000
71
Hyunsil Park
€ 2,000
Naujokas Loses His Short Stack to Dorbek Posted Saturday 29th July, 2023 at 10:39(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (6,000) Entries: 64/564
Grantas Naujokas jammed his short stack of 13,000 from the button. Mauri Dorbek (pictured below) three-bet to 40,000 from the small blind and it was a heads-up showdown with Naujokas at risk after Maksim Rusinov folded from the big blind.
Grantas Naujokas: Mauri Dorbek:
Naujokas bricked the board to lose his short stack to Dorbek.
"Good game," Naujokas said with a smile showing good sportsmanship.
Meanwhile, Matias Kesanen, poker streamer Jargo Alavali, Konstantin Arber, Kalle Parkkinen, and Martin Piik all recently hit the rail.
Player
Chips
Progress
Mikael Haapaniemi
530,000
6,000
Mauri Dorbek
500,000
30,000
Konstantin Arber
0
0
Kalle Parkkinen
0
0
Jargo Alavali
0
0
Martin Piik
0
0
Matias Kesanen
0
0
Grantas Naujokas
0
0
Only Quads for Van Wonterghem Posted Saturday 29th July, 2023 at 10:21(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 69/564
Sebastian Van Wonterghem open-jammed for 59,000 from middle position and was looked up by Matias Kesanen.
Sebastian Van Wonterghem: Matias Kesanen:
While it was a coin flip when the chips went in, the board gave Van Wonterghem a hand to remember as he improved to quad sevens.
"Only quads," Edgars Beizaks said.
Meanwhile, Julian Herold and Hyunsil Park were the first two players to hit the rail on Day 3.
While we didn't witness Beizaks' "epic hand" he shared he had a big hand to start the day.
"I got a walk the very first hand," Beizaks said with a smile.
Player
Chips
Progress
Sebastian Van Wonterghem
130,000
69,000
Matias Kesanen
65,000
71,000
Julian Herold
0
0
Hyunsil Park
0
0
Action Begins Posted Saturday 29th July, 2023 at 10:09(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 71/564
The action has kicked off for Day 3 with just a few minutes remaining in Level 16. The big blind stacks listed in the seat draw are based on Level 17 as Level 16 will be history very soon.
Best of luck to all of the remaining Main Event players. The t.v. table began from the beginning. We will not report off the t.v. table today but you can check out the action at the OlyBet.tv website on a 30-minute delay with Andreas Hoglund hosting the action.
Juan Carlos Vecino Duenas Leads Main Event Posted Saturday 29th July, 2023 at 08:49(UTC+0) by Jason Glatzer
Juan Carlos Vecino Duenas (pictured above) is among the Spanish poker community that has lived in the Estonian capital of Tallinn for a number of years. The pressure is on, as Duenas comes into the penultimate day of the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event with a chip-leading stack of 709,000 good for 118 big blinds when the action resumes. Duenas is closely followed by the start of Day 2 chip leader Vlads Dolgilevics (674,000) with Nils Linden (558,000) and Mikael Haapaniemi (536,000) also more than halfway to becoming chip millionaires.
The Day 2 action ended with the final 71 players in the money for at least a €2,000 min-cash. However, today players will be moving up the payout ladder until eventually on Sunday the last player standing will win the €108,260 top prize. You can check out the full payouts by clicking on the Payouts tab within our coverage.
Blinds will begin at 3,000/6,000 along with a 6,000 big blind ante and increase every hour. The day's plan is to play down to a final table of nine players but it is possible that the day will end sooner depending on the pace of play.
The microphone was carefully stored away and the pen and pad you are used to are back with Jason Glatzer resuming the live reporting duties the rest of the way. The Day 3 action kicks off at noon on Saturday and we will be right along with you reporting many of the biggest hands, bad beats, and, of course, every payout ladder. As if this isn't all, there will be a televised feature table from the start of the day which you can view at olybet.tv and on a variety of Facebook channels.
Best of luck to all of the players!
Day 3 Seat Draw Posted Saturday 29th July, 2023 at 08:35(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
11
1
Ville-Matti Keranen
478,000
80
11
2
Samuli Hietala
137,000
23
11
3
Konstantin Arber
320,000
53
11
4
Tomi Arponen
422,000
70
11
5
Martin Piik
12,000
2
11
6
Phil Gross
406,000
68
11
7
Kaido Mikk
126,000
21
11
8
Luis Cruz
114,000
19
12
1
Touko Berndtson
238,000
40
12
2
James Noonan
382,000
64
12
3
Igor Pihela Jr.
170,000
28
12
4
Kristian Larsson
266,000
44
12
5
Jari Saviaho
238,000
40
12
6
Henri Schalin
183,000
31
12
7
Christian Steinbo
233,000
39
12
8
Tarmo Tammel
170,000
28
13
1
Daniel Jullumstro
191,000
32
13
2
Stefan Bittger
136,000
23
13
3
Ranno Sootla
112,000
19
13
4
Kalle Parkkinen
53,000
9
13
5
Maksim Rusinov
39,000
7
13
6
Juho Heiska
440,000
73
13
7
Matias Arosuo
287,000
48
13
8
Aleksi Naski
182,000
30
14
1
Kai Lehto
405,000
68
14
2
Espen Sandvik
180,000
30
14
3
Grantas Naujokas
33,000
6
14
4
Mauri Kristjan Dorbek
470,000
78
14
5
Urmo Velvelt
251,000
42
14
6
Yanis Sahli
457,000
76
14
7
Vlads Dolgilevics
674,000
112
14
8
Siim Suviste
388,000
65
15
1
Matias Kesanen
136,000
23
15
2
Magnus Pukk
321,000
54
15
3
Hendrik Diegenant
405,000
68
15
4
Edgars Beizaks
134,000
22
15
5
Roberts Rumba
78,000
13
15
6
Ramunas Mika
51,000
9
15
7
Sebastian Van Wonterghem
61,000
10
15
8
Hein Haraldsen
155,000
26
18
1
Patrick Schratz
94,000
16
18
2
Ilya Nikiforov
258,000
43
18
3
Joonas Helin
84,000
14
18
4
Anders Auset
172,000
29
18
5
Kasper Mellanen
379,000
63
18
6
Tapio Aaltonen
492,000
82
18
7
Nils Linden
558,000
93
18
8
Kristaps Deksnis
211,000
35
19
1
Juan Carlos Vecino Duenas
709,000
118
19
2
Vygerdas Jonikas
164,000
27
19
3
Anatoly Filatov
213,000
36
19
4
Jordi Baixas
172,000
29
19
5
Keito Kaljulaid
307,000
51
19
6
Kaspar Laursoo
189,000
32
19
7
Guillermo Cifuentes
352,000
59
19
8
Jargo Alavali
139,000
23
20
1
Andrei Mjagkov
89,000
15
20
2
Dmitrijs Kornevs
352,000
59
20
3
Herli Olop
221,000
37
20
4
Feras Abid
285,000
48
20
5
Lukas Rutkauskas
192,000
32
20
6
Kasparas Klezys
168,000
28
20
7
Anna-Mari Hursti
220,000
37
20
8
Tero Kilkanen
144,000
24
21
1
Mikael Haapaniemi
536,000
89
21
2
Julian Herold
28,000
5
21
3
Jaana Kindsigo
132,000
22
21
4
Karolis Kutkauskas
326,000
54
21
5
Hyunsil Park
58,000
10
21
6
Harri Seppa
295,000
49
21
7
Nick Penning
314,000
52
08:34 (UTC+0)
Day 3 of Kings of Tallinn Summer Showdown 2023 Started Level: 17 Blinds: 3,000/6,000 Ante: 6,000
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.
flop from 75,000 to 300,000. Gross jammed for 670,000 and Haapaniemi called.
turn was irrelevant but the 
river pushed Gross ahead with a better pair.
and Aaltonen let out a big smile after doubling his stack instead taking a bad beat and going to the rail.
suited against Ville-Matti Keranen's 
flop or the 
turn pushed him ahead and now begged the dealer not to deal a queen. Instead, it was the 
completing the board for Gross to double with two pair.
turn. However, the 
improved him to two pair to stay alive and double his stack.
river were drama free for Arponen to take a huge chunk from Suveste's stack.
which didn't get the job done against Berndtson's 
. Meanwhile, Anna-Mari Hursti just hit the rail right before this hand. She was not only the last woman standing in the Main Event, but also the €555 Championship.
for a better full house to earn a full double-up.
flop as now he had four jacks to draw to instead of three queens.
board to eliminate the formidable Sandvik.
