0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0111 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-27'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/92'
ORDER BY `views` DESC
0.0008 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.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '92'
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '255'
AND `published` = 1
0.0061 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.0060 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.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` = '11463'
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` = '11461'
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` = '11428'
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` = '11425'
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` = '11417'
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` = '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.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` = '11409'
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` = '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.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` = '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.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` = '11391'
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` = '11389'
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` = '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.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` = '11375'
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` = '11365'
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` = '11362'
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` = '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.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` = '11353'
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` = '11350'
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` = '11347'
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` = '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.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` = '11339'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11337'
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` = '11335'
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` = '11330'
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` = '11324'
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` = '11320'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11316'
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` = '11314'
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` = '11308'
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` = '11303'
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` = '11299'
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` = '11296'
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` = '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.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` = '11289'
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` = '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.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` = '11279'
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` = '11272'
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` = '11266'
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` = '11259'
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` = '11255'
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` = '11254'
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` = '11252'
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` = '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.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.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` = '11241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '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.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` = '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.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` = '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.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` = '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.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` = '11409'
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` = '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.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` = '11396'
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` = '11395'
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` = '11391'
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` = '11389'
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` = '11383'
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` = '11381'
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` = '11375'
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` = '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.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` = '11353'
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` = '11350'
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` = '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.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` = '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.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` = '11337'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '11324'
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` = '11320'
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` = '11316'
ORDER BY `chip_change` DESC, `busted` ASC
0.0102 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0114 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '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.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` = '11281'
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` = '11279'
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` = '11272'
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` = '11266'
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` = '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.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` = '11252'
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` = '11249'
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` = '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.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.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.0059 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
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Kings of Tallinn 2024
Event #42: €5,000 High Roller (English)
Live Reporting - Day 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.
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
. 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.
and Markkos Ladev made the call in the big blind with 
.
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.
river completed the board and Laadev flicked in a bet of 325,000.
and Federico Cipollini checked his 
in the big blind. Cipollini then check-called Ladev's bet of 50,000 on the 
flop and the 
board, meaning that Cipollini's ace-high brought him the double-up to even out the stacks.
and Federico Cipollini called his 
and Cipollini made the call with 
runout, seeing him double up and establishing a firm lead.
to 65,000 on the button and Federico Cipollini called in the big blind with 
in the big blind.
turn, seeing his opponent check-fold.
flop, which Cipollini raised to 70,000. Ladev called with his middle pair before both players checked on the 
turn.
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.
and Markkos Ladev made the call in the big blind with 
and Markkos Ladev checked 
turn.
and Markkos Ladev made the call in the big blind with 
flop was checked by both and Ladev did so again on the 
