0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0012 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/92/255/updates', 1, '2024-11-25')

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

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '92'

0.0363 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0063 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '255'
AND `published` = 1

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

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

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

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11461'
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` = '11428'
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` = '11425'
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` = '11417'
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` = '11415'
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` = '11411'
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` = '11409'
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` = '11402'
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` = '11401'
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` = '11396'
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` = '11395'
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` = '11391'
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` = '11389'
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` = '11383'
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` = '11381'
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` = '11375'
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` = '11365'
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` = '11362'
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` = '11359'
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` = '11358'
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` = '11353'
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` = '11350'
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` = '11347'
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` = '11345'
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` = '11341'
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` = '11339'
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` = '11337'
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` = '11335'
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` = '11330'
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` = '11324'
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` = '11320'
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` = '11316'
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` = '11314'
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` = '11308'
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` = '11303'
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` = '11299'
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` = '11296'
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` = '11294'
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` = '11290'
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` = '11289'
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` = '11284'
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` = '11281'
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` = '11279'
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` = '11272'
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` = '11266'
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` = '11259'
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` = '11255'
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` = '11254'
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` = '11252'
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` = '11249'
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` = '11246'
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` = '11243'
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` = '11241'
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` = '11214'
ORDER BY `chip_change` DESC, `busted` ASC

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

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` = '11463'
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` = '11461'
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` = '11429'
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` = '11428'
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` = '11425'
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` = '11417'
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` = '11415'
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` = '11411'
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` = '11409'
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` = '11402'
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` = '11401'
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` = '11396'
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` = '11395'
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` = '11391'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11365'
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` = '11362'
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` = '11359'
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` = '11358'
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` = '11353'
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` = '11350'
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` = '11347'
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` = '11345'
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` = '11341'
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` = '11339'
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` = '11337'
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` = '11335'
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` = '11330'
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` = '11324'
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` = '11320'
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` = '11316'
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` = '11314'
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` = '11308'
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` = '11303'
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` = '11299'
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` = '11296'
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` = '11294'
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` = '11290'
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` = '11289'
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` = '11284'
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` = '11281'
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` = '11279'
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` = '11272'
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` = '11266'
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` = '11259'
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` = '11255'
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` = '11254'
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` = '11252'
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` = '11249'
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` = '11246'
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` = '11243'
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` = '11241'
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` = '11214'
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` = '255'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

Translate

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Eesti
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Nederlands
• Ελληνικά
• Русский

Kings of Tallinn 2024 Event #42: €5,000 High Roller (English) Live Reporting - Day 2

Kings of Tallinn 2024 - Live Reporting

Event #42: €5,000 High Roller (English) See other events

Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

---

Current Level 20 Current Day 2

---

Blinds 25,000/50,000 Ante 50,000

Entries 29 Remaining 1

---

Prize Pool (EUR) €132,240 First Prize (EUR) €47,290

Chip Leaders Day 2

1

Markkos Ladev

3,800,000

Day 2

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 2

18:46 (UTC+2)

Day 2 of Kings of Tallinn 2024 Ended
Level: 20     Blinds: 25,000/50,000     Ante: 50,000

Hometown Hero Markkos Ladev Wins Maiden Live Poker Title in Kings of Tallinn €5,000 High Roller Posted Saturday 2nd March, 2024 at 18:44(UTC+2) by Frank Visser

Just one Estonian player made it to the final table of the Kings of Tallinn €5,000 High Roller. However, it turned out that one was all they needed, as Markkos Ladev was the final one standing after nearly five hours of play. He put on a dominating performance and came back from a two-to-one chip disadvantage heads up against Federico Cipollini to claim the title and €47,290. Cipollini had to make do with the runner-up prize of €33,100, while Pasi Sormunen, Eelis Parssinen, and Marius Kudzmanas were the other household names to claim a piece of the €132,200 prize pool.

Ladev started appearing in the live circuit just last year but quickly became a staple in high rollers all across Europe. Although he had banked a few six-figure scores in deep runs, a title and trophy eluded him yet. That changed today, as he was awarded the beautiful Kings of Tallinn trophy for his first-ever live poker tournament victory, doing it on the home turf of Olympic Park Casino.

Kings of Tallinn €5,000 High Roller Results

Place	Player	Country	Prize
1	Markkos Ladev	Estonia	€47,290
2	Federico Cipollini	Italy	€33,100
3	Pasi Sormunen	Finland	€23,750
4	Eelis Parssinen	Finland	€16,250
5	Marius Kudzmanas	Lithuania	€11,850

At the start of the second and final day of the tournament, the 29-man field had been whittled down to seven players, who took their seats at the final table. However, with only five spots being paid, two more had to leave empty-handed. After the players played through one level, Mikael Haapaniemi lost a big flip to Ladev and was the first to book an exit, while his fellow Finn Torsti Kettula got his short stack in three-way just a few minutes later and could not secure a triple-up.  Kettula received the title of bubble boy while the other five players played on with the min-cash secured.

About one level later, Ladev rivered the nut flush against Kudzmanas' turned two pair, and the Lithuanian bracelet winner paid his all-in. Kudzmanas was left with less than a small blind, which he would lose not much later against start-of-day chipleader Sormunen. Ladev then stole the chip lead from Sormunen shortly thereafter with a set against top pair. Meanwhile, Cipollini had stayed relatively quiet throughout the final table until he eliminated high-stakes PLO icon Parssinen in a straight-over-straight situation. From that point on, he picked up steam and eventually took over the chip lead, which he extended when he eliminated Sormunen in third place.

The unorthodox Sormunen had picked bad timing to shove his 15 big blinds in the middle with ten-four offsuit and could not win against the king-queen of Cipollini. However, Cipollini would soon make a similar mistake as he five-bet jammed seven-five offsuit in the queens of Ladev a few hands into heads-up play. His two-to-one chip advantage was transferred to the Estonian, which he used to his full advantage. 

Cipollini was granted one comeback when his ace-jack won against Ladev's jack-three in a preflop all-in, but he was soon grinded back down to 15 big blinds again by Ladev. The next preflop all-in, Cipollini had the inferior hand with nine-eight suited against the pocket nines of Ladev, and he could not hit his straight draw to stay alive. 

Thus, Ladev was awarded the €5,000 High Roller title and trophy, concluding the live coverage of the tournament. But do not fret, as the blog of the €1,100 Main Event is still ongoing to quench the thirst for Baltic poker action.

Federico Cipollini Eliminated in 2nd Place (€33,100) Posted Saturday 2nd March, 2024 at 17:45(UTC+2) by Frank Visser

Level 20: 25,000/50,000 (50,000)
Entries: 1/29

Markkos Ladev limped in from the button and Federico Cipollini jammed in his 700,000 chips from the big blind.

Ladev quickly called and the cards went on their backs.

Federico Cipollini:
Markkos Ladev:

Cipollini was heavily dominated but turned some outs on . However, his straight draw did not come in on the river, and he became the runner-up of the Kings of Tallinn €5,000 High Roller.

Player		Chips	Progress
Markkos Ladev		2,900,000	900,000
Federico Cipollini		0	0

Cipollini Back Under One Million Posted Saturday 2nd March, 2024 at 17:33(UTC+2) by Frank Visser

Level 20: 25,000/50,000 (50,000)
Entries: 2/29

Federico Cipollini raised to 125,000 on the button with and Markkos Ladev made the call in the big blind with .

Ladev then checked on the flop, after which Cipollini made a bet of 130,000. Ladev put n the same amount for a call and the arrived on the turn.

Ladev checked again and this time Cipollini checked back. The river completed the board and Laadev flicked in a bet of 325,000.

Cipollini swiftly mucked his ace-high as Ladev had a two-to-one lead once more.

Player		Chips	Progress
Markkos Ladev		2,000,000	300,000
Federico Cipollini		925,000	375,000

Ladev Gets Some Back Posted Saturday 2nd March, 2024 at 17:22(UTC+2) by Frank Visser

Level 20: 25,000/50,000 (50,000)
Entries: 2/29

Markkos Ladev limped in on the button with and Federico Cipollini checked his in the big blind. Cipollini then check-called Ladev's bet of 50,000 on the flop and the turn hit the felt.

Ladev fired a big bet of 250,000 chips after another check from his opponent, this time folding a fold from the better hand.

Player		Chips	Progress
Markkos Ladev		1,700,000	200,000
Federico Cipollini		1,300,000	200,000

17:19 (UTC+2)

Start of Level 20
Blinds: 25,000/50,000     Ante: 50,000

Another Break Posted Saturday 2nd March, 2024 at 17:13(UTC+2) by Frank Visser

The two players have been sent on a 10-minute break before the heads-up continues.

Cipollini Gets Even Posted Saturday 2nd March, 2024 at 17:13(UTC+2) by Frank Visser

Level 19: 20,000/40,000 (40,000)
Entries: 2/29

Federico Cipollini limped in from the button and Markkos Ladev went all in from the big blind, covering Cipollini's stack of 680,000 chips.

Cipollini made a quick call and the cards went on their backs.

Federico Cipollini:
Markkos Ladev:

Neither player paired up on the board, meaning that Cipollini's ace-high brought him the double-up to even out the stacks.

Player		Chips	Progress
Federico Cipollini		1,500,000	630,000
Markkos Ladev		1,500,000	500,000

Ladev Picks Up Queens Again Posted Saturday 2nd March, 2024 at 16:56(UTC+2) by Frank Visser

Level 19: 20,000/40,000 (40,000)
Entries: 2/29

Markkos Ladev raised to 80,000 on the button with and Federico Cipollini called his in the big blind.

The flop saw Cipollini check-fold to Ladev's 130,000 bet as the hand turned out to be short-lived.

Player		Chips	Progress
Markkos Ladev		2,000,000	200,000
Federico Cipollini		870,000	230,000

Cipollini Flops Tripollini Posted Saturday 2nd March, 2024 at 16:52(UTC+2) by Frank Visser

Level 19: 20,000/40,000 (40,000)
Entries: 2/29

Markkos Ladev raised to 80,000 on the button with and Cipollini made the call with in the big blind.

Cipollini checked on the flop before Ladev made a bet of 40,000. Cipollini raised to 135,000 and that took down the pot as Ladev quickly mucked.

Player		Chips	Progress
Markkos Ladev		1,800,000	200,000
Federico Cipollini		1,100,000	180,000

16:41 (UTC+2)

Start of Level 19
Blinds: 20,000/40,000     Ante: 40,000

Ladev Doubles Up After Five-Bet Bluff Posted Saturday 2nd March, 2024 at 16:38(UTC+2) by Frank Visser

Level 18: 15,000/30,000 (30,000)
Entries: 2/29

Markkos Ladev raised to 65,000 on the button with before Federico Cipollini made a three-bet to 205,000 from the big blind.

Ladev spent some time thinking things through and put 355,000 chips in the middle, after which Cipollini shoved all in to put Ladev at risk for stack of just under one million chips.

Ladev snap called and a showdown followed.

Markkus Ladev:
Federico Cipollini:

Cipollini's ambitious move could not bring forth a miracle as Ladev's queens steadily held on the runout, seeing him double up and establishing a firm lead.

Player		Chips	Progress
Markkos Ladev		2,000,000	900,000
Federico Cipollini		920,000	880,000

Ladev Rivers Straight Posted Saturday 2nd March, 2024 at 16:33(UTC+2) by Frank Visser

Level 18: 15,000/30,000 (30,000)
Entries: 2/29

Markkos Ladev raised his to 65,000 on the button and Federico Cipollini called in the big blind with . Ladev then bet 40,000 chips on the board and Cipollini made the check-call.

The turn was checked through before the river completed the board. Cipollini check-called Ladev's 175,000 bet, but his two pair was no match against Ladev's straight.

Player		Chips	Progress
Federico Cipollini		1,800,000	300,000
Markkos Ladev		1,100,000	335,000

Cipollini Draws First Blood Posted Saturday 2nd March, 2024 at 16:29(UTC+2) by Frank Visser

Level 18: 15,000/30,000 (30,000)
Entries: 2/29

Federico Cipollini raised his button to 70,000 with and Markkus Ladev made the call with in the big blind.

The flop was checked through before Cipollini made a 75,000 bet on the turn, seeing his opponent check-fold.

Player		Chips	Progress
Federico Cipollini		2,100,000	100,000
Markkos Ladev		765,000	15,000

A Small Break Before Heads Up Posted Saturday 2nd March, 2024 at 16:20(UTC+2) by Frank Visser

Federico Cipollini and Markkos Ladev are taking a small five-minute break before the tournament resumes.

Pasi Sormunen Eliminated in 3rd Place (€23,750) Posted Saturday 2nd March, 2024 at 16:18(UTC+2) by Frank Visser

Level 18: 15,000/30,000 (30,000)
Entries: 2/29

Markkos Ladev raised to 60,000 on the button and Federico Cipollini made the call in the small blind. Pasi Sormunen then jammed in his 460,000 chips from the big blind, which caused Ladev to fold.

Cipollini, on the other hand, asked for a count and made the call after thinking it over.

Pasi Sormunen:
Federico Cipollini:

Sormunen's ten-four could not do the trick as he was drawing dead on the runout. The river did not matter anymore and Sormunen's mistimed all-in sent him to the rail in third place.

Player		Chips	Progress
Federico Cipollini		2,000,000	500,000
Markkos Ladev		885,000	135,000
Pasi Sormunen		0	0

16:02 (UTC+2)

Start of Level 18
Blinds: 15,000/30,000     Ante: 30,000

Cipollini Makes Correct Call to Extend Lead Posted Saturday 2nd March, 2024 at 15:48(UTC+2) by Frank Visser

Level 17: 10,000/25,000 (25,000)
Entries: 3/29

Markkos Ladev limped in from the small blind with and Federico Cipollini checked his in the big blind.

Ladev then bet out 25,000 chips on the flop, which Cipollini raised to 70,000. Ladev called with his middle pair before both players checked on the turn.

The river then completed the board and Ladev loaded up 175,000 chips to put in the middle. Cipollini mulled his decision over for a while before making the call with his rivered trips to take a big lead over his opponents.

Player		Chips	Progress
Federico Cipollini		1,500,000	300,000
Markkos Ladev		750,000	250,000

Cipollini Takes Over Lead Posted Saturday 2nd March, 2024 at 15:43(UTC+2) by Frank Visser

Level 17: 10,000/25,000 (25,000)
Entries: 3/29

Federico Cipollini raised to 55,000 on the button with and Markkos Ladev made the call in the big blind with . Ladev then check-called the 60,000 bet Cipollini put out on the flop before the turn went check-check.

Ladev checked again on the river, leading Cipollini to bet out 150,000 with his turned pair. Ladev spent some time in the tank before making the call but had to forfeit the pot when Cipollini flipped over the superior pair.

Player		Chips	Progress
Federico Cipollini		1,200,000	305,000
Markkos Ladev		1,000,000	300,000

Ladev Shoves on Both Posted Saturday 2nd March, 2024 at 15:39(UTC+2) by Frank Visser

Level 17: 10,000/25,000 (25,000)
Entries: 3/29

Markkos Ladev raised to 50,000 on the button with and Federico Cipollini made the call in the small blind with . 

Pasi Sormunen then squeezed to 175,000 from the button with and Ladev shoved all in, covering both of his opponents. They folded in quick succession and the pot was sent to Ladev, who extended his lead.

Player		Chips	Progress
Markkos Ladev		1,300,000	200,000
Federico Cipollini		895,000	205,000
Pasi Sormunen		695,000	200,000

Sormunen and Ladev See a River Posted Saturday 2nd March, 2024 at 15:35(UTC+2) by Frank Visser

Level 17: 10,000/25,000 (25,000)
Entries: 3/29

Pasi Sormunen limped in from the small blind with and Markkos Ladev checked in the big blind. The subsequent flop was checked twice, as was the turn.

The river saw Sormunen put in 85,000 chips with his pair of sixes and Ladev quickly laid down his pair of deuces.

Player		Chips	Progress
Markkos Ladev		1,100,000	0
Pasi Sormunen		895,000	75,000

Sormunen Barrels Twice Posted Saturday 2nd March, 2024 at 15:30(UTC+2) by Frank Visser

Level 17: 10,000/25,000 (25,000)
Entries: 3/29

Pasi Sormunen raised to 75,000 in the small blind with and Markkos Ladev made the call in the big blind with .

Sormunen continued for 45,000 on the flop and Ladev called with his queen-high. Sormunen did not relent on the turn and fired another 105,000 chips into the middle.

This time, Ladev relinquished his cards to the dealer and Sormunen raked in the pot.

Player		Chips	Progress
Markkos Ladev		1,100,000	0
Pasi Sormunen		820,000	95,000

15:26 (UTC+2)

Start of Level 17
Blinds: 10,000/25,000     Ante: 25,000

Sormunen Floats to Win Posted Saturday 2nd March, 2024 at 15:21(UTC+2) by Frank Visser

Level 16: 10,000/20,000 (20,000)
Entries: 3/29

Federico Cipollini limped in from the small blind with and Pasi Sormunen checked in the big blind.

Cipollini bet 25,000 on the flop and 50,000 on the turn, both being called by Sormunen. The river saw Cipollini check to Sormunen, who fired for 85,000 chips. 

Cipollini spent some time thinking it over before mucking his cards and sending the pot to Sormunen.

Player		Chips	Progress
Federico Cipollini		1,100,000	100,000
Pasi Sormunen		725,000	95,000

Sormunen Descends Further Posted Saturday 2nd March, 2024 at 15:18(UTC+2) by Frank Visser

Level 16: 10,000/20,000 (20,000)
Entries: 3/29

Pasi Sormunen raised his to 45,000 on the button and Federico Cipollini called in the big blind.

The flop went check-check before Sormunen made a bet of 45,000 on the turn. Cipollini check-raised to 150,000 and Sormunen hastily let go of his cards.

Player		Chips	Progress
Federico Cipollini		1,200,000	210,000
Pasi Sormunen		630,000	150,000

Cipollini Finds Agression to Inch Closer to Lead Posted Saturday 2nd March, 2024 at 15:11(UTC+2) by Frank Visser

Level 16: 10,000/20,000 (20,000)
Entries: 3/29

Federico Cipollini raised to 50,000 on the button with and Markkos Ladev made the call in the big blind with . 

Ladev led out for 35,000 on the flop but Cipollini had none of it and raised to 125,000, forcing Ladev to fold his gutshot.

Player		Chips	Progress
Markkos Ladev		1,100,000	200,000
Federico Cipollini		990,000	115,000

Cipollini Four-Bet Shoves Posted Saturday 2nd March, 2024 at 15:09(UTC+2) by Frank Visser

Level 16: 10,000/20,000 (20,000)
Entries: 3/29

Federico Cipollini raised to 60,000 in the small blind with , which Pasi Sormunen three-bet to 160,000 from the big blind with .

Cipollini quickly announced his all-in for 695,000 and Sormunen instantly mucked his cards.

Player		Chips	Progress
Federico Cipollini		875,000	140,000
Pasi Sormunen		780,000	65,000

Eelis Parssinen Eliminated in 4th Place (€16,250) Posted Saturday 2nd March, 2024 at 15:06(UTC+2) by Frank Visser

Level 16: 10,000/20,000 (20,000)
Entries: 3/29

Federico Cipollini raised to 50,000 on the button with and Eelis Parssinen made the call in the big blind with . Parssinen then checked on the flop and Cipollini made a bet of 45,000.

Parssinen tossed in a call and the turn went check-check. On the river, Parsinnen checked again, after which Cipollini put him all in for 109,000. Parssinen tanked for a bit but eventually decided he could not fold his straight and called it off.

Cipollini tabled his flopped Broadway for the nuts and Parssinen quickly headed to the payout desk to gather his fourth-place winnings.

Player		Chips	Progress
Federico Cipollini		735,000	349,000
Eelis Parssinen		0	0

Cipollini Books Double-Up Posted Saturday 2nd March, 2024 at 15:01(UTC+2) by Frank Visser

Level 16: 10,000/20,000 (20,000)
Entries: 4/29

Markkos Ladev raised his button to 40,000 and Federico Cipollini shipped it all in from the small blind. 

Ladev called the 173,000 chips the Italian had in his stack and the cards were tabled.

Federico Cipollini:
Markkos Ladev:

Both players made two pair on the runout, but Cipollini had the better one and doubled up.

Player		Chips	Progress
Markkos Ladev		1,300,000	200,000
Federico Cipollini		386,000	173,000

14:55 (UTC+2)

Start of Level 16
Blinds: 10,000/20,000     Ante: 20,000

First Break Posted Saturday 2nd March, 2024 at 14:40(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

After an eventful first few levels, the four remaining players have been sent on a 20-minute break.

Player		Chips	Progress
Markkos Ladev		1,500,000	100,000
Pasi Sormunen		845,000	10,000
Eelis Parssinen		299,000	146,000
Federico Cipollini		213,000	0

Cipollini Folds Top Pair Posted Saturday 2nd March, 2024 at 14:35(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

Federico Cipollini raised to 35,000 under the gun with and the action folded to Markkos Ladev, who defended in the big blind. Ladev then led out for 25,000 on the flop and the was turned.

Ladev continued with another bet of 90,000 and Cipollini correctly mucked his pair of tens after thinking through the situation for a bit.

Player		Chips	Progress
Markkos Ladev		1,400,000	100,000
Frederico Cipollini		253,000	115,000

Sormunen and Ladev Tangle Again Posted Saturday 2nd March, 2024 at 14:31(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

Markkos Ladev raised to 30,000 on the button with and Pasi Sormunen made it 95,000 to go from the big blind with .

Ladev made the call but quickly mucked his cards once Sormunen fired 75,000 on the board.

Player		Chips	Progress
Markkos Ladev		1,300,000	100,000
Pasi Sormunen		855,000	105,000

Sormunen Mistimes Aggression Posted Saturday 2nd March, 2024 at 14:28(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

Markkos Ladev raised to 30,000 on the button with and Pasi Sormunen made it 95,000 to go from the big blind with .

Ladev made the call but quickly mucked his cards once Sormunen fired 75,000 on the board.

Player		Chips	Progress
Markkos Ladev		1,400,000	200,000
Pasi Sormunen		750,000	162,000

Chipleaders Go to Battle Posted Saturday 2nd March, 2024 at 14:24(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

Pasi Sormunen raised his button to 35,000 with and Markkos Ladev made the call in the big blind with .

Sormunen continued for 30,000 on the flop but folded quickly once Ladev put in a check-raise to 100,000, forfeiting the pot.

Player		Chips	Progress
Markkos Ladev		1,200,000	0
Pasi Sormunen		912,000	60,000

Cipollini Finds a Spot Posted Saturday 2nd March, 2024 at 14:19(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

Pasi Sormunen raised to 30,000 under the gun with and the action folded to Federico Cipollini in the big blind, who pushed all in for 308,000 with .

Sormunen took some time to think over the spot but eventually settled on a fold, granting a pot to the quiet Cipollini.

Player		Chips	Progress
Pasi Sormunen		972,000	5,000
Frederico Cipollini		368,000	70,000

Sormunen Fights Back Posted Saturday 2nd March, 2024 at 14:13(UTC+2) by Frank Visser

Level 15: 10,000/15,000 (15,000)
Entries: 4/29

Markkus Ladev raised to 30,000 on the button with before Pasi Sormunen three-bet to 95,000 in the big blind with . Ladev put in the call and a flop of emerged from the deck.

Sormunen fired another 95,000 into the middle and Ladev quickly folded his cards, seeing the gap between the two players lessen.

 

Player		Chips	Progress
Markkos Ladev		1,200,000	100,000
Pasi Sormunen		977,000	105,000

14:10 (UTC+2)

Start of Level 15
Blinds: 10,000/15,000     Ante: 15,000

Ladev Hits Set on Sormunen, Takes Over Chip Lead Posted Saturday 2nd March, 2024 at 14:09(UTC+2) by Frank Visser

Level 14: 6,000/12,000 (12,000)
Entries: 4/29

Pasi Sormunen raised to 24,000 on the button with and Markkos Ladev made the call in the big blind with .

Both players checked on the flop before the turn hit the felt. Ladev made a bet of 65,000 with his set of sevens and Sormunen made the call with his turned top pair.

The river improved neither player and saw Ladev fire another bet, of 190,000 chips. Sormunen weighed his options for a bit before making the call, but his cards quickly hit the muck at showdown and the big pot was shipped to Ladev

Player		Chips	Progress
Markkos Ladev		1,300,000	313,000
Pasi Sormunen		872,000	328,000

Marius Kudzmanas Eliminated in 5th Place (€11,850) Posted Saturday 2nd March, 2024 at 14:04(UTC+2) by Frank Visser

Level 14: 6,000/12,000 (12,000)
Entries: 4/29

Marius Kudzmanas put in his final 3,000 chips from the cutoff. Pasi Sormunen then completed the small blind and Eelis Parssinen checked in the big blind.

The two players in the side pot checked on the flop and turn. Sormunen then fired 12,000 on the river and Parssinen took one last look at his cards before throwing them away.

Sormunen opened for Broadway, more than enough to beat the of Kudzmanas, who ended up with nine-high and busted in fifth place.

Player		Chips	Progress
Pasi Sormunen		1,200,000	100,000
Eelis Parssinen		445,000	49,000
Marius Kudzmanas		0	0

Ladev Doubles Up in Three-Bet Pot, Leaves Kudzmanas On Fumes Posted Saturday 2nd March, 2024 at 13:58(UTC+2) by Frank Visser

Level 14: 6,000/12,000 (12,000)
Entries: 5/29

Markkos Ladev raised to 25,000 on the button with and Marius Kudzmanas three-bet to 107,000 in the small blind with . Ladev threw in a call and a flop of was dealt.

Kudzmanas made a continuation-bet of 55,000 and Ladev made the call to see the turn. Kudzmanas slowed down with a check, causing Ladev to bet 55,000 chips this time.

Kudzmanas put in a call with his two pair and the river completed the board. Kudzmanas checked once more, and Ladev spent some time in the tank before deciding to put his entire stack of 258,000 in.

Kudzmanas took his time to think things through but eventually stuck in a call. He saw Ladev's rivered flush at showdown and his two pair went into the muck

Player		Chips	Progress
Markkos Ladev		987,000	512,000
Marius Kudzmanas		3,000	463,000

Ladev Loses Second Blind-On-Blind Battle Posted Saturday 2nd March, 2024 at 13:49(UTC+2) by Frank Visser

Level 14: 6,000/12,000 (12,000)
Entries: 5/29

Markkos Ladev limped in with in the small blind and Marius Kudzmanas checked his option with in the big blind. 

The flop was checked by both and Ladev did so again on the turn. Kudzmanas put in 30,000 chips with his gutshot and Ladev swiftly tossed his cards into the muck.

Player		Chips	Progress
Markkos Ladev		475,000	12,000
Marius Kudzmanas		466,000	12,000

Parssinen Trips Up Ladev Posted Saturday 2nd March, 2024 at 13:44(UTC+2) by Frank Visser

Level 14: 6,000/12,000 (12,000)
Entries: 5/29

Eelis Parssinen sat in the small blind with and limped in. Markkos Ladev checked in the big blind and the flop fanned out. 

Parssinen made the minimum bet of 12,000 and Ladev came along with a call. The turn was flipped over and Parssinen continued for 40,000. 

This time, Ladev found a quick fold and the small pot was awarded to Parssinen.

Player		Chips	Progress
Eelis Parssinen		494,000	83,000
Markkos Ladev		487,000	120,000

13:40 (UTC+2)

Start of Level 14
Blinds: 6,000/12,000     Ante: 12,000

Sormunen Puts Pressure With Chip Lead Posted Saturday 2nd March, 2024 at 13:31(UTC+2) by Frank Visser

Level 13: 5,000/10,000 (10,000)
Entries: 5/29

Marius Kudzmanas made it 20,000 to go with on the button and Federico Cipollini called his in the small blind.

Pasi Sormunen looked down at in the big blind, making it 85,000 to go. This forced the other players out of the pot as Sormunen extended his chip lead.

Player		Chips	Progress
Pasi Sormunen		1,100,000	100,000
Marius Kudzmanas		454,000	45,000
Frederico Cipollini		298,000	40,000

Torsti Kettula Bubbles €5,000 High Roller Posted Saturday 2nd March, 2024 at 13:23(UTC+2) by Frank Visser

Level 13: 5,000/10,000 (10,000)
Entries: 5/29

Pasi Sormunen raised to 20,000 on the button, after which short stack Torsti Kettula jammed his remaining 52,000 chips in from the small blind. Eelis Parssinen then made it 115,000 to go in the big blind and Sormunen made the call to create a side pot.

Parssinen checked on the subsequent  flop and called the 75,000-chip bet Sormunen put in the middle. Both players checked on the turn and the river fell.

Parssinen checked once more, but Sormunen made another bet of 75,000. Parssinen flicked in a call and Sormunen tabled for a full house. Parssinen lost with his lesser full house with , and Kettula just played the trips on the board with , resulting in his elimination in sixth place

The five remaining players are now all in the money and have secured at least the min-cash of €11,850.

Player		Chips	Progress
Pasi Sormunen		1,000,000	232,000
Eelis Parssinen		411,000	226,000
Torsti Kettula		0	0

Haapaniemi First to Go Posted Saturday 2nd March, 2024 at 13:16(UTC+2) by Frank Visser

Level 13: 5,000/10,000 (10,000)
Entries: 6/29

Markkos Ladev sat in middle position and raised it to 20,000. Mikael Haapaniemi then made it 54,000 to go on the button and the action folded back to Ladev.

Ladev shoved all in, covering the 224,000 chips Haapaniemi had in his stack. Haapaniemi made a quick call and the cards were tabled.

Mikael Haapaniemi:
Markkos Ladev:

The board remained clean for Haapaniemi's jacks, but the saw Ladev's Big Slick river the better pair.

Haapaniemi was the first elimination of the final table, meaning that the remaining six payers had arrived on the bubble.

Player		Chips	Progress
Markkos Ladev		607,000	249,000
Mikael Haapaniemi		0	0

13:10 (UTC+2)

Start of Level 13
Blinds: 5,000/10,000     Ante: 10,000

Cipollini Gets Squeeze Through Posted Saturday 2nd March, 2024 at 13:09(UTC+2) by Frank Visser

Level 12: 4,000/8,000 (8,000)
Entries: 7/29

Markkos Ladev raised to 16,000 with in the cutoff and Marius Kudzmanas flat-called on the button with .

Federico Cipollini then made it 79,000 to go from the small blind with , causing the two other players to muck their cards, and he took down a pot uncontested.

Player		Chips	Progress
Marius Kudzmanas		499,000	16,000
Markkos Ladev		358,000	16,000
Frederico Cipollini		338,000	48,000

Near-Family Pot Posted Saturday 2nd March, 2024 at 13:06(UTC+2) by Frank Visser

Level 12: 4,000/8,000 (8,000)
Entries: 7/29

Mikael Haapaniemi limped in from under the gun with and Pasi Sormunen followed suit with in the next seat over. Eelis Parssinen came along with in the cutoff and Markkos Ladev called with on the button as well. 

Marius Kudzmanas then completed in the small blind before Federico Cipollini checked his in the big blind.

All six players checked on the flop before Haapaniemi was the first one to bet on the turn, for an amount of 15,000. Parssinen called with his top pair, as did Ladev with his nut flush. The other players got out of the way and the arrived on the river.

Haapaniemi and Parssinen checked to Ladev, who opted for a sizing of 80,000. Both of his opponents swiftly mucked their top pair, shipping the six-way pot to Ladev.

Player		Chips	Progress
Pasi Sormunen		768,000	20,000
Eelis Parssinen		637,000	27,000
Marius Kudzmanas		515,000	32,000
Markkos Ladev		374,000	58,000
Frederico Cipollini		290,000	16,000
Mikael Haapaniemi		244,000	23,000
Torsti Kettula		72,000	20,000

Sormunen Bluffs Kudzmanas Posted Saturday 2nd March, 2024 at 12:57(UTC+2) by Frank Visser

Level 12: 4,000/8,000 (8,000)
Entries: 7/29

Marius Kudzmanas raised to 16,000 under the gun with and Pasi Sormunen made the call in the cutoff with . Both players then checked on the before the was turned.

Kudzmanas checked once more but Sormunen fired a bet of 17,000. Kudzmanas made the call with his pair and the river completed the board.

Kudzmanas checked his rivered set to the chip leader, who put 28,000 more chips into the middle. Kudzmanas just called and won when Sormunen could only table his bluff.

Player		Chips	Progress
Pasi Sormunen		748,000	61,000
Marius Kudzmanas		547,000	81,000

Chip Leaders Finds Rockets Posted Saturday 2nd March, 2024 at 12:53(UTC+2) by Frank Visser

Level 12: 4,000/8,000 (8,000)
Entries: 7/29

Pasi Sormunen looked down at on the button and raised it to 20,000. Eelis Parssinen called in the big blind with and a flop of was dealt.

Sormunen continued for another 20,000 but a quick check-fold followed from his opponent.

Player		Chips	Progress
Pasi Sormunen		809,000	53,000
Eelis Parssinen		664,000	28,000

High Roller Final Table Has Begun Posted Saturday 2nd March, 2024 at 12:49(UTC+2) by Frank Visser

Level 12: 4,000/8,000 (8,000)
Entries: 7/29

All seven players have taken their seats, the button has been drawn on seat 5, and the cards are in the air.

The final table of the €5,000 High Roller is officially underway.

12:47 (UTC+2)

Day 2 of Kings of Tallinn 2024 Started
Level: 12     Blinds: 4,000/8,000     Ante: 8,000

Pasi Sormunen Brings Chip Lead to Final Table of €5,000 High Roller Posted Saturday 2nd March, 2024 at 04:03(UTC+2) by Frank Visser

The €5,000 High Roller is the biggest buy-in on the 2024 Kings of Tallinn schedule, seeing an increase from the €3,000 price point it knew in previous years. It was thus no surprise that the best of the best Nordic and Baltic poker players showed up at Olympic Park Casino in Tallinn to create a field of 29 entries and a prize pool of €132,240.

On Day 1, they played down to a final table of seven players, seeing as the tournament was played six-max, before bagging and tagging. Pasi Sormunen accumulated the most chips during that process, securing a bag with 756,000 chips, more than seven and a half starting stacks and nearly 100 big blinds at the start of Day 2. Sormunen is best known for his third place at EPT Barcelona 2013, where he donned an iconic shiny hat together with fellow Finn Kimmo Kurko, who ended up as runner-up. However, Sormunen is also a Kings of Tallinn champion, winning a €550 Turbo Six-Max back in 2021 and is in a prime position to win another six-max trophy in the High Roller today.

In close pursuit is high-stakes PLO crusher and Finnish bracelet winner Eelis Parssinen, who won the Kings of Tallinn High Roller in 2018 and starts Day 2 with 692,000 chips in pursuit of his second title. Lithuanian regular Marius Kudzmanas, meanwhile, completes the podium with a stack of 466,000. Estonian hope Markkos Ladev is also in contention with a below-average stack of 316,000, as is Frederico Cipollini (306,000) from Italy. The Finnish pair of Mikael Haapaniemi (267,000) and Torsti Ketulla (92,000) find themselves at the bottom of the leaderboard, the latter being the absolute short stack with less than a starting stack.

€5,000 High Roller Final Table Seat Draw

Seat	Player	Country	Chip Count	Big blinds
1	Eelis Parssinen	Finland	692,000	87
2	Markkos Ladev	Estonia	316,000	40
3	Marius Kudzmanas	Lithuania	446,000	56
4	Frederico Cipollini	Italy	306,000	38
5	Mikael Haapaniemi	Finland	267,000	33
6	Pasi Sormunen	Finland	756,000	95
7	Torsti Ketulla	Finland	92,000	12

Two more players will need to leave empty-handed as only the top five spots will receive a payout. The five-figure min-cash of €11,850 awaits the fifth-place finisher, while the eventual winner walks away with €47,290, the trophy, and the everlasting glory of becoming a Kings of Tallinn High Roller champion.

When play resumes at 12:15 local time, 20 minutes of Level 12: 4,000/8,000 will be played before the rest of the tournament is played out with 30-minute levels. A small break will be had after every four of them, and the day will finish when a winner has been crowned.

Live reporting will commence at 12:45 p.m. to stay in sync with the cards-up live stream on OlyBet.tv, which operates on a 30-minute delay. Check back in at that time to not miss any of the high-stakes action straight from the Estonian capital.