0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/25/83/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.0303 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0058 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '75' AND `published` = 1

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

0.0280 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` = '85' AND `published` = 1

0.0280 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.0283 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0055 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '90' AND `published` = 1

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

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

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

0.0107 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '3870' 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` = '3866' 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` = '3862' 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` = '3858' 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` = '3857' 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` = '3856' 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` = '3852' 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` = '3849' 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` = '3847' 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` = '3846' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0060 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '3840' 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` = '3838' 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` = '3835' 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` = '3831' 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` = '3830' 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` = '3828' 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` = '3825' 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` = '3823' 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` = '3822' 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` = '3820' 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` = '3816' 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` = '3814' 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` = '3811' 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` = '3809' 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` = '3808' 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` = '3807' 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` = '3805' 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` = '3803' 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` = '3800' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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` = '3870' 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` = '3866' 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` = '3862' 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` = '3858' 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` = '3857' 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` = '3856' 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` = '3852' 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` = '3849' 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` = '3847' 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` = '3846' 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` = '3845' 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` = '3843' 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` = '3840' 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` = '3838' 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` = '3835' 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` = '3831' 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` = '3830' 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` = '3828' 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` = '3825' 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` = '3823' 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` = '3822' 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` = '3820' 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` = '3816' 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` = '3814' 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` = '3811' 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` = '3809' 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` = '3808' 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` = '3807' 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` = '3805' 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` = '3803' 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` = '3800' 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` = '3799' 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` = '3795' 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` = '3790' ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0116 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.0006 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 1B
End-of-Day 1b Chip Counts Posted Thursday 27th July, 2023 at 20:08(UTC+0) by Jason Glatzer
Player  Chips  Big Blinds
Vlads Dolgilevics        264,500 220
Kalle Parkkinen        218,100 182
Kaspar Laursoo        208,700 174
Mauri Dorbek        207,400 173
Markku Koplimaa        160,500 134
Nick Penning        157,400 131
Michailas Miserkejevas        157,100 131
Igor Pihela Jr.        149,100 124
Kristaps Renga        134,400 112
Anders Auset        131,400 110
Kristaps Deksnis        130,400 109
Kaspars Kalnozols        127,900 107
Keito Kaljulaid        125,400 105
Ville Konttinen        111,400 93
Jussi Mattila        110,500 92
Daniel Jullumstro        105,700 88
Ilya Nikiforov          96,900 81
Espen Sandvik          92,000 77
Jari Karkkainen          89,000 74
Kasparas Klezys          88,100 73
Sten Talviste          87,900 73
Olli Muukkonen          84,500 70
Ingus Arajs          83,900 70
Sami Pulliainen          82,000 68
Ville Pohjalainen          81,900 68
Christian Steinbo          81,000 68
Harri Seppa          80,900 67
Niko Petro          80,100 67
Sebastian Wahl          78,000 65
Jaana Kindsigo          75,900 63
Ville-Matti Keranen          74,300 62
Vygerdas Jonikas          71,800 60
Roberto Caprio          69,800 58
Jari Porkka          68,500 57
Teemu Leppalahti          67,300 56
Janne Jarvinen          66,500 55
Kaido Koorits          64,400 54
Jan Svendsen          62,000 52
Erik Borkvik          61,200 51
Anders Christiansen          58,900 49
Dmitrijs Kornevs          58,900 49
Tarjei Forus          58,200 49
Liutauras Armanavicius          57,400 48
Fatih Gulgonul          55,200 46
Hein Haraldsen          53,800 45
Andrei Mjagkov          53,400 45
Aleksandr Kuperman          51,700 43
Markus Isosalo          50,900 42
Aki Pyysing          49,800 42
Roni Berg          49,500 41
Peter Bumba          49,300 41
Herli Olop          49,300 41
Kevin Karenius          48,100 40
Amid Zulkowitz          47,500 40
Kaidar Viikman          46,700 39
Samuli Hietala          45,700 38
Thor Morstol          45,300 38
Vaclav Hlasek          45,100 38
Rafael Gancedo          44,400 37
Ramunas Mika          42,600 36
Petteri Miettinen          42,500 35
Teemu Toikkanen          42,500 35
Christian Arstad          42,200 35
Tero Kilkanen          41,000 34
Paul Koppe          41,000 34
Konstantin Arber          40,000 33
Roope Tarmi          40,000 33
Julius Kettunen          38,100 32
Joonas Helin          38,000 32
Jordi Baixas          37,900 32
Raffael Wadl          37,900 32
Mario Colavita          37,800 32
Steponas Venckus          36,900 31
Julian Herold          34,300 29
Maksim Petrov          32,500 27
Aleksejs Gusevs          31,500 26
Priit Vanem          30,000 25
Jorgen Jakobsen          29,700 25
Henrik Veldhoen          28,900 24
Kasper Mellanen          28,800 24
Mart Tammoja          28,400 24
Jorn Martinsen          27,400 23
Petteri Laiho          24,200 20
Tomas Pinkevicius          22,900 19
Sergei Oganesjan          22,300 19
Pasi Laihinen          21,700 18
Tarmo Tammel          20,200 17
Mikael Haapaniemi          19,200 16
Kaius Kiidli          18,800 16
Thomas Haverstad          14,500 12
Final Three Hands Posted Thursday 27th July, 2023 at 18:36(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 96/205

The clock stopped and the floor announced the final three hands for the day. We will update the chip counts shortly after the action has concluded along with a short recap of the day.

Tomorrow's coverage will be sporadic as we will need to focus on the live-stream for the inaugural €5,000 High Roller. We will do our best to get a few updates but the blog will resume in full on Day 3 and Day 4 until a winner is crowned.

Parkkinen Soars With Rockets Posted Thursday 27th July, 2023 at 18:15(UTC+0) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 97/205

Fireworks erupted at Table 12 with Kalle Parkkinen (pictured below) now sitting with a massive pile of chips. The hand began with Pasi Sormunen jamming for 22,300 from middle position. The action paused on Parkkinen who opted to call from the hijack. Stein Borkvik three-bet jammed for 93,300 from the button and Parkkinen, who had his opponent covered, snap-called.

Pasi Sormunen:
Stein Borkvik:
Kalle Parkkinen:

What a spot for pocket rockets. Right near the end of Day 2 with two other players committing their stacks and Parkkinen a 90% favorite to win it all.

No drama happened on the board for Parkkinen to dispatch his two opponents in one hand.

Player Chips Progress
Kalle Parkkinen 210,000 180,000
Stein Borkvik 0 0
Pasi Sormunen 0 0
Final Day 1b Blind Level Begins Posted Thursday 27th July, 2023 at 17:51(UTC+0) by Jason Glatzer

The final blind level of Day 1b has kicked off with blinds at 500/1,000 along with a big blind ante of 1,000. The clock will stop with just a few minutes remaining and players will be informed how many hands will be played out at each table before surviving players bag their chips for tomorrow's Day 2.

17:50 (UTC+0)
Start of Level 8
Blinds: 500/1,000     Ante: 1,000
Straight Not Enough for Hatipoglu Posted Thursday 27th July, 2023 at 17:50(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 107/204

There wasn't a boatload of chips in the pot when Julius Kettunen bet 2,300 with the on the board after the turn. Bahadir Hatipoglu jammed over the top for about half a starting stack and Kettunen snap-called.

Bahadir Hatipolgu:
Julius Kettunen:

Despite turning a straight, Hatipoglu was drawing dead to Kettunen's full house. The blank river completed the board and Hatipoglu was on the rail for the third time during Day 1b.

Fortunately, this isn't baseball. So it isn't three strikes and you are out. He can hop back in not only during the rest of Day 1b but also during tonight's Day 1c which kicks off at 9 p.m. If this doesn't suit his tastes, he also can pop back into the action on Friday's Day 2 with late registration still open for the first two levels.

Player Chips Progress
Julius Kettunen 60,000 30,000
Bahadir Hatipoglu 0 0
Laursoo Wakes Up With Cowboys Posted Thursday 27th July, 2023 at 17:16(UTC+0) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 118/199

There are nearly 200 entries in the Day 1b field surpassing the 188 entries attracted during yesterday's Day 1a. Jukka Ylitalo just accounted for one of the new entries as he re-entered after losing his stack on the following hand.

Ylitalo opened and two players called. Kaspar Laursoo three-bet from the big blind and Ylitalo let it rip for his stack of more than 60,000. The two players that originally called, snap-folded and Laursoo wasted no time in calling in what became a massive pot.

Jukka Ylitalo:
Kaspar Laursoo:

It was bad timing for Ylitalo to jam 75 big blinds. He would have likely gotten a lot of hands to fold but Laursoo was going nowhere with his cowboys.

Despite showing tons of heart with the jam, Ylitalo got nowhere on the board and re-entered for his third bullet for the day after hitting the rail.

Player Chips Progress
Kaspar Laursoo 200,000 170,000
Jukka Ylitalo 30,000 0
16:55 (UTC+0)
Start of Level 7
Blinds: 400/800     Ante: 800
Break Time! Posted Thursday 27th July, 2023 at 16:30(UTC+0) by Jason Glatzer

Players are on their final break of Day 1b.

Berg Dusts Off His Short Stack Posted Thursday 27th July, 2023 at 16:30(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 125/195

Roni Berg three-bet jammed his last 6,000 and was called by Jonatan Fors, who opened up the action with a short stack from late position.

Roni Berg:
Jonatan Fors:

Berg pulled out ahead after his five connected with the flop and was still ahead after the turn. However, the came raining down on the river for Fors to pull ahead and Berg will need to re-enter if he wishes to have a shot at becoming the latest Kings of Tallinn Summer Showdown Main Event champion.

Player Chips Progress
Jonatan Fors 25,000 22,000
Roni Berg 0 0
Mattila Lays Down Two Pair Posted Thursday 27th July, 2023 at 16:17(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 127/193

Jussi Mattila (pictured below) was doing "Pot-Jussi" things and built up a nice stack on Day 1b. He lost a little of it in the following hand but not much.

Four players were still in the hand in a bloated pot of around 18,000 with the on the board after the turn. Both Jukka Ylitalo and Tarieli Ustiashvili checked. Mattila bet 3,400. Pasi Sormunen raised to 7,800 Ylitalo and Ustiashvili folded. 

Mattila folded a second later and immediately tabled the to the shock of Sormunen.

"I laid that down because it was you," said Mattila implying that his opponent always has it there.

"You play much differently than I remember," replied Sormunen.

Player Chips Progress
Jussi Mattila 120,000 90,000
Pasi Sormunen 55,000 25,000
Muukkonen Shows One Posted Thursday 27th July, 2023 at 15:57(UTC+0) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 134/190

Olli Muukkonen busted one bullet today but is off to a better start on the second bullet. He opened from early position for 1,200. Guillermo Cifuentes three-bet to 3,500 from middle position. The action paused on Muukkonen who eventually called to see the flop.

Cifuentes checked before Muukkonen bet 2,000. Cifuentes went into the tank for a couple of minutes and checked his cards multiple times before he over-jammed the pot for close to a starting stack. Cifuentes snap-folded and Muukkonen took down the pot.

"Show one, show one," said Jussi "Potti-Jussi" Mattila, who often attends major poker festivals in Tallinn.

Muukkonen quickly obliged and turned over the .

"Not that one," said someone else at the table.

We won't ever know whether it was a good fold or not for Cifuentes as we don't know what he had either. What we do know, is that he is off to a great start despite losing this smaller pot with 70,000 in chips.

Player Chips Progress
Guillermo Cifuentes 70,000 40,000
Olli Muukkonen 35,000 5,000
Jussi Mattila 30,000 0
15:37 (UTC+0)
Start of Level 6
Blinds: 300/600     Ante: 600
Dolgilevics Leading Day 1b Posted Thursday 27th July, 2023 at 15:24(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 143/172

Latvia's Vlads Dolgilevics appears to have the early chip lead on Day 1b with about 165,000 in chips.

Dolgilevics shared a hand that recently took place on Table 14. He already had a stack when he opened the cutoff with . The big blind defended and Dolgilevics check-called a bet of around 80% of the pot on the  flop. 

The big blind fired out for 80% after the paired the board on the turn. Dolgilevics shared he bet 2.5x and his opponent jammed for about 30,000 total. Dolgilevics called and his opponent tabled for an open-ended straight draw with no flush draw.

The blank completed the board on the river and it was happy days for Dolgilevics.

Player Chips Progress
Vlads Dolgilevics 165,000 135,000
Bumba Folds Top Pair Posted Thursday 27th July, 2023 at 14:49(UTC+0) by Jason Glatzer

Level 5: 200/500 (500)
Entries: 143/172

Massimo Altieri opened for 1,100 from the hijack. Peter Bumba bumped the pot up to 3,100 from the button and Altieri called.

Altieri check-called a bet of 2,500 on the flop before both players checked the turn. Altieri bet 9,000 on the river. Bumba went into the tank for a couple of minutes.

Eventually, Bumba folded but not before showing he had at least top pair after turning the face-up.

Player Chips Progress
Massimo Altieri 55,000 25,000
Peter Bumba 38,000 8,000
14:34 (UTC+0)
Start of Level 5
Blinds: 200/500     Ante: 500
Break Time Posted Thursday 27th July, 2023 at 14:23(UTC+0) by Jason Glatzer

Players are on a 15-minute break. Some are doing some more pineapple flips in the €150 GGPoker Flip&Go Mystery Bounty, while others heading to the OlyBet Bar & Grill pop-up restaurant.

We just checked out the pop-up restaurant, and it was pasta with tasty chorizo sauce and salad. It was both light and full of flavor, two qualities great for poker players and the media crew alike. Bon appetit!

Mika Leaves Muller With Crumbs Posted Thursday 27th July, 2023 at 14:03(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 137/154

A pot grew to 15,000 preflop between Ramunas Mika and Martin Muller when Mika bet 5,500 on the flop. Muller min-clicked it back to 11,000 and Mika called.

Both players checked the turn and Mika checked again on the river. Muller jammed for slightly more than the 16,000 remaining in his opponent's stack. Mika snap-called and it didn't end well for Muller as he was bluffing with . Mika was more than happy to double with his and Muller will need to re-enter in order to have a chance to run deep assuming he doesn't spin up his crumbs.

Player Chips Progress
Ramunas Mika 70,000 40,000
Martin Muller 600 29,400
Ustiashvili Felts Helin Posted Thursday 27th July, 2023 at 13:41(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 129/144

Tarieli Ustiashvili bet 4,000 into a pot of slightly more with the on the board on the river. Joonas Helin jammed for about 20,000 more and Ustiashvili tanked for several minutes.

He eventually decided his hand was too strong to lay down and called. Helin turned over the and got his hand caught in the cookie jar with Ustiashvili calling with the for the straight.

Player Chips Progress
Tarieli Ustiashvili 70,000 40,000
Joonas Helin 0 0
Cowboys for Haverstad Posted Thursday 27th July, 2023 at 13:33(UTC+0) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 122/138

We went to check out if anything was happening with GGPoker Ambassador Anatoly Filatov, who has called Tallinn his home for a number of years. The short answer to this question was not much is happening as he is down to 20,000 in chips.

However, the trip wasn't wasted as we did witness a hand at his table between Estonian resident Anthony Kauzloric and Thomas Haverstad.

There was around 8,000 in the pot in a three-bet pot when Haverstad continued from the small blind for 2,000 on the flop. Kauzloric called and more action came on the turn. Haverstad checked before he called a bet of 4,000. Both players checked the river.

Haverstad tabled and his cowboys held on an ace-high board with Kauzloric tossing his hand into the muck.

Player Chips Progress
Anthony Kauzloric 60,000 30,000
Thomas Haverstad 50,000 50,000
Anatoly Filatov 20,000 10,000
13:28 (UTC+0)
Start of Level 4
Blinds: 200/400     Ante: 400
"You Call the River?" Posted Thursday 27th July, 2023 at 13:20(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 119/130

Roberts Rumba fired out for 6,100 into a pot of around 15,000 with the on the board after the turn. Anders Christiansen went into the tank for a short time before he called.

Both players checked the river and Rumba turned over the for two pair. Christiansen won the pot with a better two pair after tabling the .

"You call river?" asked Rumba to Christiansen if he was facing a jam for his remaining 10,000 in chips.

Christiansen grinned and then came a small laugh.

"I don't know," Christiansen eventually replied. "It was a shitty spot."

Player Chips Progress
Anders Christiansen 49,000 19,000
Roberts Rumba 10,000 20,000
Good Start for Olop Posted Thursday 27th July, 2023 at 13:00(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 107/116

Back when this author was still in diapers was breaking into the industry, Herli Olop was always doing his best to help make the events in Estonia as amazing as he could for the players and staff. Olop is still around every festival but now as a poker player. 

He's off to a good start and just stacked Jari Hurri to catapult his stack to more than double the starting stack.

He shared that Martin Haidberg opened and was called by Hurri and and Olop before the flop was checked around. Olop then shared that he fired out a small bet on the turn which got Haidberg to fold.

Hurri called and what he thought was a good river in the turned out to be a disaster. Olop bet 8,000 into a built up pot of a bit more. Hurri jammed and Olop snapped him off.

Hurri held the for Broadway. However, this wasn't good enough as Olop flopped the absolute goods with to win the hand with a full house.

Player Chips Progress
Herli Olop 60,000 30,000
Jari Hurri 0 0
Perhaps Bielskis Gave Tammel Too Much Credit Posted Thursday 27th July, 2023 at 12:43(UTC+0) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 102/107

Tarmo Tammel jammed for 18,500 into a pot of what appeared to be slightly less with the  on the board before Andrius Bielskis (pictured below) went into the tank.

A few minutes went by and you were visibly able to watch the wheels of thought go through Bielskis's head. 

"OK, I will give you credit," Bielskis said as he folded his hand.

Bielskis showed the for the top pair. While this was a very strong hand, Tammel could have had this beat if he wasn't on a draw.

"I will only do this once," Tammel said as he tabled the . He had a monster draw on the turn with an open-ended straight draw, a flush draw, and his king still being live. As it turned out, it was a very nice bluff as it did get Bielskis make a huge laydown.

Bielskis is well-known in the Baltics as one of the best players in Lithuania and won a massive prize a few years back in the Sunday Millions Anniversary event. He also founded the "Pliusine Sesija" brand that boasts an amazing podcast if you can understand Lithuanian.

Player Chips Progress
Tarmo Tammel 40,000 8,000
Andrius Bielskis 16,000 14,000
12:17 (UTC+0)
Start of Level 3
Blinds: 100/300     Ante: 300
Break Time Posted Thursday 27th July, 2023 at 12:01(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 83/86

Players are on their first 15-minute break. More pineapple flips for the €150 GGPoker Flip&Go Mystery Bounty. There will be €10,000 added by GGPoker and the top mystery bounty prize will be at least €5,000 when Day 2 takes place on Saturday.

Meanwhile, Oskars Gailums, Olli Muukkonen, and Bahadir Hatipoglu all hit the rail during the second half of Level 2. This doesn't mean they won't have a chance to bag chips during Day 1b, as all three players already re-entered back into the action.

Player Chips Progress
Bahadir Hatipoglu 30,000 0
Olli Muukkonen 30,000 0
Oskars Gailums 30,000 0
Meet Yesterday's €555 Championship Winner Maikel Homin Posted Thursday 27th July, 2023 at 11:49(UTC+0) by Jason Glatzer

Kings of Tallinn Summer Showdown host Evely Pihela interviewed yesterday's €555 Championship winner Maikel Homin.

Homin dazzled his opponents and spectators alike with an amazing performance. Check out what he had to say in the video below:

Team Competition Registration Closing Soon Posted Thursday 27th July, 2023 at 11:46(UTC+0) by Jason Glatzer

The Kings of Tallinn Summer Showdown tournament director Teresa Nousiainen just announced that registration will close after the first break for the Team Competition. So be sure to get your teams together before its too late. Please see one of the staff if you need assistance forming your team.

"I Didn't Call Because You Are a Nice Guy" Posted Thursday 27th July, 2023 at 11:40(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 69/69

Lithuanian poker player Irmantas Bzeskis lives in Norway and since last year we have seen him around sporting a variety of NBA jerseys while walking around and playing. Yesterday was Vince Carter day and today is also an old-school look with the Sacramento Kings "Williams" Jersey with a 55 on the back. Old-school NBA followers will know that this is Jason "White Chocolate" Williams, who had his moments back in the day dazzling the crowds with his impressive passes.

That being said, it sounds like Bzeskis just made a decent laydown. He has been having fun with the other players at the table including Lasse Kolari. Kolari fired out for 6,500 into a pot of around 10,000 with the on the board after the river. Bzeskis tanked for a couple of minutes before he folded. Risto Parnat quickly folded after that.

Bzeskis shared he laid down for top two pair. 

"I didn't call because you are a nice guy," Bzeskis said to Kolari.

Kolari showed he was betting for value as he tabled the before collecting the pot.

Player Chips Progress
Lasse Kolari 45,000 15,000
Irmantas Bzeskis 30,000 0
Top Two Pair for Stiedl Posted Thursday 27th July, 2023 at 11:33(UTC+0) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 66/66

Tomas Pinkevicius fired out for 2,500 into a pot of around 4,000 with the on the board after the turn. Yvonne Stiedl called to see the river. Pinkevicius checked before Stiedl fired out for 4,000. Pinkevicius tanked for a couple of minutes before he called.

Stiedl turned over the for the top two pair. This was good enough as she took down the pot after Pinkevicius mucked his cards.

Player Chips Progress
Yvonne Stiedl 40,000 10,000
Tomas Pinkevicius 31,000 1,000
11:04 (UTC+0)
Start of Level 2
Blinds: 100/200     Ante: 200
Auset First to Double on Day 1b Posted Thursday 27th July, 2023 at 11:01(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 52/52

A bit of a cooler took place at Table 2 for Jonatan Fors but it isn't likely that Anders Auset (pictured below) is complaining one bit at all.

The hand began to build up preflop and it all started with Hein Haraldsen opening for 300 from under the gun. Auset called from one seat over and Triinu Ammussar did the same from the small blind before Fors three-bet to 1,500 from the big blind. Only Auset called with the other two players folding.

Fors fired out for 2,800 on the flop. Auset called and he called a bet of 3,000 after the turn. The river paired the board. You will see why this wasn't the best of cards for Fors soon enough. Fors bet 12,500. Auset tanked for a few moments before jamming over the top for about 18,000. Fors snap-called only to get some bad news.

Auset turned over the for a full house. Fors pushed his cards facedown before the dealer tabled his hand showing the for rivered trips.

Player Chips Progress
Anders Auset 60,000 30,000
Jonatan Fors 3,000 27,000
Early Two Pair for Tammel Posted Thursday 27th July, 2023 at 10:33(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 40/40

The Day 1b field has grown to 40 entries with more players continuously filing into the venue including local hero Tarmo Tammel.

It has been mostly small ball early on, including the following hand with Tammel where he bet 1,500 into a pot of 2,000 with the when he was first to act from the big blind. Kristaps Renga quickly called and mucked his cards after Tammel showed the for the top two pair.

Player Chips Progress
Tarmo Tammel 32,000 2,000
Kristaps Renga 28,000 2,000
Cards in the Air Posted Thursday 27th July, 2023 at 10:08(UTC+0) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 18/18

The cards are in the air to start Day 1a. Players will battle for eight one-hour blind levels until surviving players resume action for Day 2 on Friday at 12 p.m.

Gytis Bernatavicius, Tero Kilkanen, Maksim Petrov, Kristaps Renga, and Oskars Gailums are among the players opting to play from the start.

Player Chips Progress
Oskars Gailums 30,000 0
Kristaps Renga 30,000 0
Maksim Petrov 30,000 0
Tero Kilkanen 30,000 0
Gytis Bernatavicius 30,000 0
Welcome to Day 1b of the Kings of Tallinn Summer Showdown Main Event Posted Thursday 27th July, 2023 at 08:51(UTC+0) by Jason Glatzer

Get ready for some fun and excitement as poker players battle for what promises to be a massive prize pool in the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park.

The event provides an amazing structure with hour-long blind levels throughout the event providing players plenty of opportunities to showcase their skills. The only exception to this rule is the Day 1c flight kicking off at 9 p.m. This isn't exactly a turbo flight either but it does play twice as fast with 30-minute blind levels.

Players begin each opening flight with a deep stack of 30,000 in chips for 300 big blinds and can re-enter until their heart is content until late registration closes after the second blind level of Friday's Day 2. Surviving players will battle it out for three more days until a winner is crowned on Sunday.

Finnish poker powerhouse Feras Abid found himself in a familiar place in Tallinn as he bagged the Day 1a chip lead with 221,000. Day 1a attracted 188 players with 75 players advancing and we expect the Day 1b field to eclipse these figures. In other words, we can comfortably say that this will easily grow into the largest Main Event of the Kings of Tallinn Summer Showdown history.

Our coverage will focus today on Day 1c starting when the cards are in the air and will then continue throughout the week with detailed reports from Friday until a winner is crowned on Sunday. 

Best of luck to everyone playing and for those that aren't, sit back, relax, and enjoy the coverage.

08:40 (UTC+0)
Day 1B of Kings of Tallinn Summer Showdown 2023 Started
Level: 1     Blinds: 100/100     Ante: 100
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.