0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/90/updates', 1, '2024-12-25')

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.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '25'

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

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

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

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

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

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

0.0060 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.0061 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.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` = '4259' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

0.0068 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0067 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '4229' 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` = '4217' 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` = '4214' 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` = '4211' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.0055 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.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` = '4259' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0058 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

Translate
Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 3
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 . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.