0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0063 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-04'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/91/251/updates'
ORDER BY `views` DESC
0.0003 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` = '91'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '91'
0.0287 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1
0.0285 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1
0.0289 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1
0.0282 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` = '256'
AND `published` = 1
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` = '263'
AND `published` = 1
0.0063 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '251'
ORDER BY `busted` ASC, `current_chips` DESC
0.0062 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` = '251'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '11215'
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` = '11206'
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` = '11200'
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` = '11184'
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` = '11177'
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` = '11171'
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` = '11166'
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` = '11161'
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` = '11151'
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` = '11148'
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` = '11145'
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` = '11143'
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` = '11138'
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` = '11130'
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` = '11124'
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` = '11122'
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` = '11115'
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` = '11113'
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` = '11100'
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` = '11098'
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` = '11097'
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` = '11093'
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` = '11092'
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` = '11083'
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` = '11073'
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` = '11068'
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` = '11067'
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` = '11065'
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` = '11058'
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` = '11055'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11046'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11043'
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` = '11042'
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` = '11040'
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` = '11039'
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` = '11036'
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` = '11033'
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` = '11030'
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` = '11025'
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` = '11020'
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` = '11017'
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` = '11014'
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` = '11012'
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` = '11006'
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` = '11002'
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` = '10999'
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` = '10998'
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` = '10994'
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` = '10993'
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` = '10989'
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` = '10988'
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` = '10987'
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` = '10982'
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` = '10979'
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` = '10978'
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` = '10977'
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` = '10972'
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` = '10968'
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` = '10965'
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` = '10960'
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` = '10956'
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` = '10953'
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` = '10952'
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` = '241'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '245'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '251'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 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` = '251'
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` = '11215'
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` = '11206'
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` = '11200'
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` = '11184'
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` = '11177'
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` = '11171'
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` = '11166'
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` = '11161'
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` = '11151'
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` = '11148'
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` = '11145'
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` = '11143'
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` = '11138'
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` = '11130'
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` = '11124'
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` = '11122'
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` = '11115'
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` = '11113'
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` = '11100'
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` = '11098'
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` = '11097'
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` = '11093'
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` = '11092'
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` = '11083'
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` = '11073'
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` = '11068'
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` = '11067'
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` = '11065'
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` = '11058'
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` = '11055'
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` = '11046'
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` = '11043'
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` = '11042'
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` = '11040'
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` = '11039'
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` = '11036'
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` = '11033'
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` = '11030'
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` = '11025'
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` = '11020'
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` = '11017'
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` = '11014'
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` = '11012'
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` = '11006'
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` = '11002'
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` = '10999'
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` = '10998'
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` = '10994'
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` = '10993'
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` = '10989'
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` = '10988'
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` = '10987'
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` = '10982'
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` = '10979'
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` = '10978'
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` = '10977'
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` = '10972'
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` = '10968'
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` = '10965'
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` = '10960'
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` = '10956'
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` = '10953'
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` = '10952'
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` = '251'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '256'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '263'
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 #29: €1,100 Main Event (English)
Live Reporting - Day 4
Day 2 of Kings of Tallinn 2024 Ended Level: 17 Blinds: 3,000/6,000 Ante: 6,000
Jani Vilmunen Leads Final 118 in Main Event Posted Friday 1st March, 2024 at 23:05(UTC+0) by Jason Glatzer
The 2024 Kings of Tallinn €1,100 Main Event more than lived up to its billing at Olympic Park Casino and the Hilton Tallinn Park. The €500,000 guarantee was a mere placeholder and players participated in record numbers with 914 total entries getting into the mix by the time late registration closed midway through Day 2 for a monumental prize pool of €859,160.
While all eyes are on the €151,860 top prize announced shortly after late registration was closed, today players primarily focused on getting into the money with the hopes of having a good stack for Day 3 and beyond.
Finland's Jani Vilmunen (pictured above) was on top at the end of the day to lead the 118 survivors after bagging up a huge stack of 968,000. Vilmunen has been in this spot before as he is a well-experienced pro with nearly $900,000 in cashes tracked at The Hendon Mob. The Finn also won a WSOP Europe in the £5,250 Pot Limit Omaha back in 2009.
Meanwhile, Lithuania's Mantas Tamulevicius fired his very first bullet on Day 2 and waited to the very last second to start the day with 12 big blinds. He made the most of his decision as he catapulted his 30,000 stack to 777,000 to finish just behind Vilmunen.
Kasper Mellanen (757,000), Osku Karttunen (654,000), and 2024 Kings of Tallinn €555 Championship runner-up Andrius Bielskis (600,000) round out the top five.
Other players finding bags into Day 3 were former Olympic poker manager Herli Olop (530,000), Maximilian Sanders (502,000), Steven Tool (400,000), OG online poker legend Ilari "Ziigmund" Sahamies (381,000), Josep Pastor (373,000), 2023 WSOP Circuit Tallinn Main Event champ Ignacio Garrido (357,000), Dominik Ostrowski (313,000), Tarmo Tammel (291,000), 2023 Kings of Tallinn €555 Championship winner Benjamin Gros (235,000), super high roller Paul Newey (219,000), 2024 Kings of Tallinn €555 PLO Mystery Bounty champ Paul Koppe (213,000), and Roope Tarmi (167,000).
Our new hero Christian Rysgaard began the day with the chip lead but now may have a new nickname from Sleeping Beauty that he earned during the €555 Championship to Cinderella if he can pull off some magic as he ended the day with exactly one chip worth 1,000.
Meanwhile, Day 2 ended when two Finnish players Henri Wagner and Sampo Ryyanen went out on the same hand at different tables through a long bubble lasting about a full blind level. Both players didn't go home empty-handed as they split a min-cash of €2,100 resulting in a €1,050 prize for each player.
Others on the rail earlier include 2023 Kings of Tallinn champ Priit Parmasto, 2007 Kings of Tallinn champ Matias Knaapinen, 2023 WSOP Circuit Tallinn Main Event runner-up Petteri Laiho, Jussi "PottiJussi" Mattila, Igor Pihela Sr., 2022 Battle of Malta champ Giuseppe Rosa, Queens of Tallinn host and FLIP women's poker community founder Daiva Byrne were among the players battling on Day 2 to fall short of the money.
Cards are back in the air for Day 3 on Saturday at Noon. We recommend all players get their bracelets as early as possible and be back in the tournament arena no later than 11:45 a.m. Best of luck to all of the players on Day 3 and beyond.
Final Day 2 Chip Counts Posted Friday 1st March, 2024 at 22:30(UTC+0) by Jason Glatzer
Player
Chips
Progress
Jani Vilmunen
968,000
623,000
Mantas Tamulevicius
777,000
747,000
Kasper Mellanen
757,000
487,000
Osku Karttunen
654,000
613,500
Andrius Bielskis
600,000
180,000
Frederik Brink
569,000
539,000
Edgaras Kausinis
552,000
531,600
Albert Gil
544,000
462,700
Herli Olop
530,000
230,000
Thomas Larsen
523,000
127,000
Maximilian Sanders
502,000
82,000
Mattias Hansen
457,000
3,000
Jani Tuovinen
448,000
274,600
Patrikas Aglinskas
427,000
122,000
Svein Mathiassen
425,000
357,800
Audrius Skucas
423,000
309,900
Sauli Haapaniemi
420,000
302,100
Jonatan Fors
417,000
388,700
Bengt-Anders Johnsson
404,000
321,400
Steven Tool
400,000
278,200
Niclas Mjelstad
390,000
141,000
Aleksi Naski
388,000
128,000
Ilari Sahamies
381,000
351,000
Josep Pastor
373,000
16,000
Ignacio Garrido
357,000
234,000
Trond Aanestad
346,000
271,000
Morten Norland
338,000
26,000
Miska Vihervuori
334,000
240,500
Johan Karlsson
333,000
53,000
Benny Hagberg
326,000
86,000
Even Rislov
316,000
287,700
Dominik Ostrowski
313,000
290,100
Greger Aktell
308,000
19,000
Tarmo Tammel
291,000
161,000
Sven Omland
286,000
14,000
Adrians Imsa
280,000
10,000
Aleksei Smirnov
268,000
8,000
Alexander Sokolovsky
249,000
211,200
Nikita Zarovs
247,000
155,300
Kaido Mikk
246,000
74,300
Marius Morel
246,000
84,000
Wissam Polus
244,000
49,000
Klavs Garselis
237,000
182,100
Tomi Arponen
236,000
130,600
Benjamin Gros
235,000
117,000
Rolandas Aglinskas
235,000
10,000
Jon Martinez
228,000
90,600
Paul Newey
219,000
78,000
Mihkel Vitsur
214,000
110,000
Paul Koppe
213,000
217,000
Jyrki Lampinen
209,000
150,500
Jimi Koponen
207,000
152,200
Enea Subashi
205,000
100,000
Viktor Eriksson
201,000
173,400
Sandis Blums
198,000
143,000
Ranel Kasi
198,000
17,500
Tarjei Forus
196,000
30,900
Kalle Parkkinen
194,000
114,500
Mykolas Guiga
193,000
148,000
Vytautas Laurinaitis
185,000
10,000
Per Engstrom
184,000
140,900
Gatis Maisins
182,000
105,800
Petteri Miettinen
180,000
112,500
Antti Perttula
180,000
77,300
Mark Metsla
177,000
112,400
Paulius Jucys
168,000
156,000
Mindaugas Kriauciunas
167,000
76,000
Roope Tarmi
167,000
10,500
Mikko Ylamaki
162,000
188,000
Tomi Rissanen
155,000
97,800
Jari-Pekka Juhola
154,000
92,800
Rytis Pranarauskas
153,000
67,000
Gediminas Dirmantas
153,000
17,000
Kenneth Svendsen
151,000
76,300
Henning Andre
150,000
10,000
Arto Lehtonen
145,000
63,300
Fritz Nygren
145,000
27,200
Sebastian Wahl
139,000
35,000
Kaius Kiidli
137,000
80,800
Kaur-Silver Koha
135,000
37,000
Henri Kasper
135,000
33,400
Peer Zahl
131,000
78,400
Stein Naerland
124,000
80,900
Anne Bezdek
117,000
89,700
Aurelijus Sipavicius
117,000
35,800
Rolf Jauring
112,000
32,000
Joonas Helin
108,000
42,000
Luca Beretta
107,000
272,000
Thomas Haverstad
106,000
55,300
Mairo Tori
98,000
39,600
Kris Tikka
96,000
9,000
Martynas Mockevicius
92,000
34,100
Van Akram Marcus
89,000
56,500
Sascha Manns
87,000
40,000
Matias Kesanen
86,000
56,000
Adria Comas I Roura
85,000
55,400
Shachar Haran
80,000
19,700
Peter Jaksland
73,000
10,600
Lauri Laast
72,000
13,800
Jesper Hansen
70,000
3,200
Mindaugas Jonaitis
66,000
4,300
Karl Linder
63,000
25,400
Jari Saviaho
62,000
32,000
Vasilijus Piskunovas
54,000
17,500
Jari Hurri
48,000
4,700
Matias Knaapinen
45,000
15,300
Oscar Peleg
43,000
11,500
Ignas Vaitulionis
43,000
27,000
Jari Mahonen
38,000
2,000
Vidar Furu Oie
37,000
278,000
Silver Simulask
30,000
100,000
Ignas Navickas
26,000
88,400
Andrei Silencov
25,000
40,000
Olegs Petrovskis
24,000
49,800
Ignas Jasinevicius
10,000
3,000
Richard Koppel
10,000
65,000
Javier Moya
5,000
16,000
Christian Rysgaard
1,000
0
Henri Wagner & Sampo Ryyanen Split a Min-Cash on Bubble Posted Friday 1st March, 2024 at 20:57(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (5,000) Entries: 120/914
It took just two hands after the break for the bubble to burst with two players hitting the rail at separate tables splitting the min-cash of €2,100 for €1,050 each.
Henri Wagner was the first to go. He had 6,000 in chips and was all-in before cards were dealt from the big blind and was up against Aurelijus Sipavicius who opened from the cutoff.
Wagner didn't look at his cards yet and flipped over the .
"Let the other card be a seven," one of Wagner's friends on the rail shouted.
Wagner took a peak and announced: "It's much better before turning over the .
Wagner's didn't get there against Sipavicius's after the ran out on the board.
Meanwhile, Sampo Ryyanen was also already committed from the big blind and also didn't look at his cards facing the shove by Mindaugas Jonitis from the small blind.
Sampo Ryyanen: Mindaugas Jonitis:
Ryyanen was ahead until the river on the board.
A round of applause took place after the hand as players were in the money heading into tomorrow. At least two players had some "bag issues."
Sascha Manns already entered the €250 Sviten Special event and was out the door quickly. Meanwhile, newly anointed Kings of Tallinn legend Christian "Sleeping Beauty" Rysgaard may have a new nickname coming. He had one chip worth 1,000 heading into tomorrow's Day 3.
Check out the amazing photos by Kings of Tallinn Photographer Elena Kask below:
Player
Chips
Progress
Christian Rysgaard
1,000
20,000
Henri Wagner
0
0
Sampo Ryyanen
0
0
Jasinevicius Survives Posted Friday 1st March, 2024 at 20:34(UTC+0) by Jason Glatzer
Level 17: 3,000/6,000 (5,000) Entries: 120/914
Ignas Jasinevicius had 6,000 chips and was all in in the big blind. Morten Norland three-bet Mattias Hansen to 40,000 preflop. Hansen called before both players checked the entire board.
Jasinevicius didn't look at his cards and had a beauty with . Norland had and his hand was mucked while Hansen held to chop the pot with Jasinevicius.
High fives went over to Jasinevicius from the rail as he survived the money bubble.
Player
Chips
Progress
Ignas Jasinevicius
13,000
42,000
20:21 (UTC+0)
Start of Level 17 Blinds: 3,000/6,000 Ante: 6,000
Final Break Posted Friday 1st March, 2024 at 20:08(UTC+0) by Jason Glatzer
Players are on a 15-minute break. Day 2 will conclude after the money bubble breaks.
Aglinskas Celebrates After Narrowly Missing Bubble Posted Friday 1st March, 2024 at 19:48(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 120/914
Rolandas Aglinskas had his last 76,000 committed on the board after the turn. Henning Andre called and a crowd submerged the table.
Rolandas Aglinskas: Henning Andre:
It was looking like showers on the bubble for Aglinskas but the river saved the day and he celebrated loudly after hitting his flush.
"Nice hand," Andre said after the hand showing some sportsmanship despite the loud display right next to him.
Player
Chips
Progress
Rolandas Aglinskas
225,000
9,000
Henning Andre
160,000
47,900
Bubble Reached After Suutari Hits Rail Posted Friday 1st March, 2024 at 19:19(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 120/914
Juho Suutari just hit the rail after getting it in the against the held by Fritz Nygren. He got nowhere on the board and the action was just one player away from being in the month.
Player
Chips
Progress
Juho Suutari
0
0
Rockets Hold for Zarev Against Omlando Posted Friday 1st March, 2024 at 19:05(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 121/914
Sven Omland (pictured below) jammed his big stack from the small blind before Nikita Zarovs called off from the big blind for his stack of 121,000.
A crowd gathered around the table after the other hands were played out at other tables.
Nikita Zarovs: Sven Omland:
Zarovs was nervous but it turned out he had no reason to be at the end with the safe running out on the board.
Player
Chips
Progress
Sven Omland
300,000
77,500
Nikita Zarev
247,000
217,000
Plan for Day 2 Posted Friday 1st March, 2024 at 18:58(UTC+0) by Jason Glatzer
The final plan for Day 2 was just announced. The day will end the later of the end of Level 16 or when the action reaches the money.
Chances are, it will be the end of the level which was the original schedule for the day.
Naski Doubles Vaitulionis Posted Friday 1st March, 2024 at 18:56(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 121/914
Aleksi Naski (pictured below) opened for 10,000 from the hijack before Ignas Vaitulionis three-bet shoved for 30,000 from the small blind. Naski looked down at his cards once more before he called.
Hands were being played out at other tables before a crowd gathered around the table.
Aleksi Naski: Ignas Vaitulionis:
The crowd was amazing when Naski pulled ahead with two pair on the flop. But Vaitulionis had Naski drawing dead after improving to a set of cowboys on the turn and officially doubled his stack after the river completed the board.
Player
Chips
Progress
Aleksi Naski
260,000
158,000
Ignas Vaitulionis
70,000
30,000
Two Away From the Money Posted Friday 1st March, 2024 at 18:43(UTC+0) by Jason Glatzer
Level 16: 2,000/5,000 (5,000) Entries: 121/914
The action is two players away from the money after Jazouli Idrissi, Mauri Dorbek, Robertas Smolskis, and Lars-Ove Johnsson lost their short stacks.
Johnsson got his short stack in on the turn with and was up against the held by Klavs Garselis with the board.
Johnsson had some kicker issues with both players holding the top pair. They weren't resolved on the river.
The action went hand-for-hand after the hand.
Player
Chips
Progress
Mauri Dorbek
0
0
Robertas Smolskis
0
0
Klavs Garselis
0
0
Jazouli Idrissi
0
0
Lars-Ove Johnsson
0
0
18:33 (UTC+0)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Dorbek With a Decision to Make Against Olop With Bubble Brewing Posted Friday 1st March, 2024 at 18:21(UTC+0) by Jason Glatzer
Level 15: 2,000/4,000 (4,000) Entries: 124/914
Mauri Dorbek (pictured below) bet 18,000 into a pot of a bit more with the on the board after the turn. Herli Olop jammed for the more than 15 big blinds Dorbek still had behind.
Dorbek went into the tank for more than five minutes during which time he was trying to get a reaction out of Olop. Eventually, the duo engaged in a discussion.
"What do you push all-in with?" Dorbek asked.
"Something like ace-jack," replied Olop.
"Do you have queens?" Dorbek followed up.
"I can't say," Olop said.
Dorbek apologized to the table for taking so long. However, the table didn't seem to mind.
"Will you show your cards?" asked Dorbek.
"You can choose one WHEN you fold," replied Olop predicting the future.
"Only one?" replied Dorbek.
"Only one, its better," said Olop.
Dorbek eventually folded and Olop invited him to choose a card to turn over.
"So you had queens," said Dorbek after the was turned over.
"Maybe yes, maybe no," Olop replied.
Meanwhile, 2020 KoT Main Event champion Johan Karlsson is also at the table with a healthy stack.
Player
Chips
Progress
Herli Olop
300,000
70,000
Johan Karlsson
280,000
177,300
Mauri Dorbek
59,000
53,100
Kennie Hermansson
0
0
Rauno Tahvonen
0
0
Sleeping Beauty Needs to Wake Up Posted Friday 1st March, 2024 at 18:15(UTC+0) by Jason Glatzer
Level 15: 2,000/4,000 (4,000) Entries: 130/914
Christian Rysgaard earned the nickname Sleeping Beauty in the €555 Championship when he took a nap during the dinner break with the chip lead with 45 players left thinking the day was over. He came back 3 hours later and battled out but fell short of the final day.
He had a good run on Day 1a of the Main Event and entered today with the chip lead. He lost a huge pot to Olop many hours ago and has since been hanging along. Now, someone needs to wake-up Sleeping Beauty at the tables as he is down to five big blinds.
However, there is a bubble looming and we hope to see him among the players to make the money, especially considering that Rysgaard has added to the tremendous atmosphere here at the Kings of Tallinn.
Player
Chips
Progress
Christian Rysgaard
21,000
129,000
Vygerdas Jonikas
0
0
Maher Mahmoud
0
0
Kaisa Suorsa
0
0
Allan Arjut
0
0
Day 7 Video Recap Posted Friday 1st March, 2024 at 17:53(UTC+0) by Jason Glatzer
Rockets For Hansen Posted Friday 1st March, 2024 at 17:50(UTC+0) by Jason Glatzer
Level 15: 2,000/4,000 (4,000) Entries: 134/914
A massive pot of more than 500,000 was in the middle, including a massive side pot. Rolf Jauring had his last 26,000 in the middle, while Mattias Hansen had a much bigger amount in 243,000 committed. Ignas Jasinevicius had his stack in as well with both players covered.
Rolf Jauring: Mattias Hansen: Ignas Jasinevicius:
"I'm alive" said Jauring.
Jauring went from alive to having decent odds to win the pot after nailing both a flush draw and a gutshot straight draw on the flop.
The turn didn't help either Jasinevicius or Jauring but the river completed Jauring's flush to triple his stack.
Meanwhile, Hansen won the massive side pot with his set of aces to catapult to near the top of the Day 2 leaderboard.
Player
Chips
Progress
Mattias Hansen
460,000
384,400
Rolf Jauring
80,000
50,000
Ignas Jasinevicius
55,000
155,000
Mathias Siljander
0
0
Erkka Lepola
0
0
Thomas Syversen
0
0
Mikko Aro
0
0
Ulf Bredenberg
0
0
Tomas Pinkevicius
0
0
Alf Onnestam
0
0
Simon Persson
0
0
Arnoldas Kolesnikovas
0
0
Anatolij Kulabin
0
0
Radoslaw MatyjaszczykÊ
0
0
Gustaf Soderholm
0
0
Sten Talviste
0
0
Jukka Moisio
0
0
Meet the Legend of the Sleeping Beauty at the Kings of Tallinn Posted Friday 1st March, 2024 at 17:19(UTC+0) by Jason Glatzer
Christian "Sleeping Beauty" Rysgaard began the day with the chip lead and is still hanging along despite doubling up Herli Olop in a big hand earlier today.
Check out Rysgaard's story in the video below:
Larsen Still Leading at Break Posted Friday 1st March, 2024 at 17:18(UTC+0) by Jason Glatzer
Player
Chips
Progress
Thomas Larsen
650,000
240,000
Paul Koppe
430,000
71,000
Andrius Bielskis
420,000
260,600
Maximilian Sanders
420,000
216,100
Josep Pastor
389,000
129,000
Herli Olop
370,000
10,000
Morten Norland
364,000
267,000
Marius Morel
330,000
160,000
Vidar Furu Oie
315,000
183,900
Patrikas Aglinskas
305,000
250,300
17:17 (UTC+0)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Eliminations Before Break Posted Friday 1st March, 2024 at 17:08(UTC+0) by Jason Glatzer
Player
Chips
Progress
Emanuele Mari
0
0
Petteri Laiho
0
0
Oskar Ojaveer
0
0
Giedrius Karpavicius
0
0
Dror Amiram
0
0
Adrian Espinosa
0
0
Pasi Sormunen
0
0
Olop Earns Killing Cap Posted Friday 1st March, 2024 at 17:05(UTC+0) by Jason Glatzer
Players are now on break. We noticed Herli Olop (photo without cap below, photo with cap to come soon) wearing a new autographed cap and he explained to us he won it during the Celebrity Event.
Olop eliminated the short-stacked Estonian celebrity Karl Killing when he flopped trips with king-deuce and improved to a full house. The action went check-check on both the flop and turn until Killing attempted to make a move on the river with jack-seven.
This was likely one of the easier calls for Olop this week. Meanwhile, the "Killing Cap" is crushing as Olop had around 380,000 in chips in his stack for one of the bigger stacks in the room.
Player
Chips
Progress
Herli Olop
380,000
35,000
Tammel Doubles Through Helin With Cowboys Posted Friday 1st March, 2024 at 16:46(UTC+0) by Jason Glatzer
Level 14: 1,500/3,000 (3,000) Entries: 157/914
Estonia's All-Time Cashes leader according to The Hendon Mob at international events at Olympic Park Casino three-bet jammed for 58,000 and was called by Joonas Helin, who originally opened one seat to his right.
Tarmo Tammel: Joonas Helin:
Tammel calmly watched the peacefully run out on the board resulting in a double-up through Helin.
Player
Chips
Progress
Joonas Helin
150,000
102,300
Tarmo Tammel
130,000
26,000
Pekka Ikonen
0
0
Jarkko Suokas
0
0
Touko Berndtson
0
0
John Lundqvist
0
0
Jan-Mikael Kesanen
0
0
Daiva Byrne
0
0
Ivo Rohula
0
0
Laurynas Cerniauskas
0
0
Priit Vanem
0
0
Oleksii Lubnin
0
0
George Sandford
0
0
Roni Berg
0
0
Angel Rodriguez
0
0
€5,000 High Roller Begins Posted Friday 1st March, 2024 at 16:16(UTC+0) by Jason Glatzer
The two-day €5,000 High Roller just kicked off with seven players. This figure will grow with late registration open for nine blind levels.
Federico Cipollini, Anatoly Filatov, Markku Koplimaa (pictured below), Marius Kudzmanas, Ilya Nikiforov, Mihails Nikitins, and Virpi Ojanen were the troopers battling it out from the opening bell.
Best of luck to all of the High Rollers this evening at the 2024 Kings of Tallinn.
€159,860 Top Prize Posted Friday 1st March, 2024 at 16:08(UTC+0) by Jason Glatzer
The payouts were just announced with the top 119 players going home with at least a €2,100 min-cash.
It only goes up from there until Sunday's eventual winner who will be awarded €151,860 barring any deals. This will be a new record prize at the Kings of Tallinn throughout its 10-year illustrious history.
You can check out the full payouts soon in the "Payouts" tab in our coverage.
16:03 (UTC+0)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Koks Runs Into Mellanen's Cowboys Posted Friday 1st March, 2024 at 16:03(UTC+0) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 175/914
Andrey Koks committed his stack on the flop and was up against the active Kasper Mellanen.
Andrey Koks: Kasper Mellanen:
Koks didn't seem thrilled about what he was up against, and who could blame him. Some new outs opened while others closed after the turn as a queen for two pair, now gives Mellanen a straight, and a king gives Koks the straight to beat trips.
However, the blank river completed for Mellanen to eliminate Koks.
Player
Chips
Progress
Kasper Mellanen
270,000
160,000
Algirdas Saveikis
0
0
Maksim Petrov
0
0
Algirgas Sukys
0
0
Samuli Hietala
0
0
Andrey Koks
0
0
Kuzulis Loses Short Stack to Dirmantas Posted Friday 1st March, 2024 at 15:55(UTC+0) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 183/914
Table 2 recently broke but not before two Lithuanians in Dangiris Kuzulis and Gedimnas Dirmantas clashed in a small pot that sent Kuzulis to the rail.
Kuzilis open-jammed for six big blinds from early position and was called by Dirmantas from the hijack.
Dangaris Kuzulis: Gediminas Dirmantas:
Ace-jack was good enough to beat ace-seven on the runout for Dirmantas to take claim to Kuzulis's stack.
Player
Chips
Progress
Gediminas Dirmantas
170,000
67,800
Dangiras Kuzulis
0
0
Mikael Haapaniemi
0
0
Niklas Vakkuri
0
0
Kaspars Mallons
0
0
Justas Semaska
0
0
Jussi Mattila
0
0
Adomas Juozapavicius
0
0
Santtu Leinonen
0
0
Markku Koplimaa
0
0
Reinis Zageris
0
0
Good Luck to Pihela Sr. in the High Roller Posted Friday 1st March, 2024 at 15:38(UTC+0) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 198/914
Players are dropping fast during Level 13 with dozens of players hitting the rail including Igor Pihela Sr. We won't disclose exactly the amount of times Pihela tried to build a stack only to end up end and enter again, but we do appreciate his determination. Unfortunately, despite a last bid at the end he was among the players to hit the rail.
We wish the local poker veteran Pihela better luck in the €5,000 High Roller, which kicks off at 6 p.m.
Meanwhile, Finnish poker journalist and player Aki Pyysing was also among those not to make it past Level 13.
Player
Chips
Progress
Tommi Lankinen
0
0
Marks Sergins
0
0
Audrius Laimelis
0
0
Kestutis Jungevicius
0
0
Michel Leibgorin
0
0
Jussi Vanhanen
0
0
Sander Leigri
0
0
Modestas Kryzanauskas
0
0
Aki Pyysing
0
0
Igor Pihela Sr.
0
0
Daiva Byrne Headlines the TV Table Posted Friday 1st March, 2024 at 15:16(UTC+0) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 226/914
Women's poker group FLIP founder and Queens of Tallinn host Daiva Byrne will headline the first t.v. table of the Main Event. The action should be live shortly and you can watch it by clicking on the 'Livestream" tab within our coverage or by heading to OlyBet.tv.
Sebastian Wahl, 2023 Kings of Tallinn €555 Champion winner Benjamin Gros, Juho Suutari, Jari Mahonen, Aleksi Naski, Jan-Mikael Kesanen, and Justas Semaska round off what promises to be an exciting t.v. table.
Player
Chips
Progress
Sebastian Wahl
174,000
70,900
Benjamin Gros
118,000
54,800
Aleksi Naski
102,000
1,200
Juho Suutari
89,000
64,700
Jari Mahonen
40,000
15,800
Justas Semaska
35,000
2,300
Daiva Byrne
29,000
13,900
Jan-Mikael Kesanen
27,500
47,300
Max Rotko
0
0
Peder Behr
0
0
Yaniv Peretz
0
0
Igor Pihela Sr.
0
0
Eli Danielsson Malca
0
0
Fernando Yerro
0
0
Gundars Zelcs
0
0
914 Entries Create Record-Breaking €859,160 Prize Pool Posted Friday 1st March, 2024 at 15:02(UTC+0) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 226/914
Late registration is officially closed. The clock is reading 914 entries with 226 players remaining but with all the action today the numbers will be checked, double-checked, and triple-checked before the official payouts are published. This created a record-breaking €859,160 prize pool for a €1,100 buy-in event in Estonia.
Best of luck to those still in action!
Eliminations Before Break Posted Friday 1st March, 2024 at 15:00(UTC+0) by Jason Glatzer
Player
Chips
Progress
Anatoly Filatov
0
0
Romans Krasins
0
0
Laur Sibold
0
0
Wissam Polus
0
0
Totti Arosuo
0
0
14:57 (UTC+0)
Start of Level 13 Blinds: 1,000/2,500 Ante: 2,500
Larsen Leads at Break Posted Friday 1st March, 2024 at 14:57(UTC+0) by Jason Glatzer
Thomas Larsen held the chip lead at the break. There is still a few minutes left to go before the action resumes.
Player
Chips
Progress
Thomas Larsen
410,000
362,400
Luca Beretta
379,000
243,300
Sven Omland
377,500
59,500
Paul Koppe
359,000
259,500
Mikko Ylamaki
350,000
257,000
Jani Vilmunen
345,000
237,700
Herli Olop
345,000
5,000
Enea Subashi
305,000
272,700
Rolandas Aglinskas
305,000
200,000
Paul Newey
297,000
232,300
Break Time Posted Friday 1st March, 2024 at 14:32(UTC+0) by Jason Glatzer
Most of the players are now on break while a few tables are taking longer to play their final hands. Late registration will be closed as soon as the break is over. We will announce the final tally along with the total prize pool with the payouts to come a little later.
Silencov Having Fun With Bet Sizes Posted Friday 1st March, 2024 at 14:30(UTC+0) by Jason Glatzer
Level 12: 1,000/2,000 (2,000) Entries: 222/894
Andrei Silencov bet 20,000 out of his stack of 24,500 from under the gun and was called by Ignas Jasinevicius from the cutoff.
Silencov min-bet 2,000 on the flop and another 2,000 on the turn and was called both times by Jasinevicius. A big jam of 500 in chips came on the river and Jasinevicius snap called.
Silencov's pulled ahead of Jasinevicius's to double his stack near the end of the late registration period.
Shortly after this hand, it was announced the final three hands of late registration.
Player
Chips
Progress
Ignas Jasinevicius
210,000
181,000
Andrei Silencov
65,000
500
Aleksander Lattikas
0
0
David Ozmen
0
0
Madis Muur
0
0
Henri Antikainen
0
0
Mihkel Vohla
0
0
Juuso Oksanen
0
0
Evaldas Kunickis
0
0
Ermo Kosk
0
0
Giuseppe Rosa
0
0
Eduards Rakuss
0
0
Recent Eliminations Posted Friday 1st March, 2024 at 14:12(UTC+0) by Jason Glatzer
Day 1c cihp leader Irmantas Bzeskis hit the rail recently along with all the players listed below.
Player
Chips
Progress
Michel Karim
0
0
Georgios Tsouloftas
0
0
Stanislav Agusevich
0
0
Martin Zobel
0
0
Joshua Stewart
0
0
Juha Kaitanen
0
0
Kristian Kostiander
0
0
Georgi Abuladze
0
0
Kaspars Butans
0
0
Martynas Kaulakys
0
0
Martin Heiberg
0
0
Irmantas Bzeskis
0
0
Tadas Pranckevicius
0
0
Andres Allsalu
0
0
Marten Rimmel
0
0
Jari Lahtinen
0
0
Kazimieras Ramaska
0
0
Jimmy Dewerdt
0
0
Martin Heiberg
0
0
Dmitrij Bogdanov
0
0
Olop Doubles Through Rysgaard Posted Friday 1st March, 2024 at 14:00(UTC+0) by Jason Glatzer
Level 12: 1,000/2,000 (2,000) Entries: 238/877
Overall chip leader from Day 1a in Christian "Sleeping Beauty" Rysgaard and Day 1c chip leader Irmantas Bzeskis have been sitting side by side since the beginning of the day. The day hasn't started off great for either of them, but they both are still battling away.
However, it has worked out well for former Olympic Casino Poker Manager Herli Olop (pictured below) after winning a big pot against Rysgaard.
Mathias Siljander opened for a min-raise before Rysgaard three-bet. Olop shared he four-bet to 30,000 and Rysgaard was the only player to call. Olop bet big on the flop and smaller on the turn. Rysgaard called both times before jamming the river for more than the 70,000 Olop had in his stack.
Olop called and doubled his stack with against .
Player
Chips
Progress
Herli Olop
350,000
218,500
Mathias Siljander
160,000
80,100
Christian Rysgaard
150,000
160,000
Irmantas Bzeskis
70,000
65,200
Roller Coaster Ride for Kasper Mellanen Posted Friday 1st March, 2024 at 13:39(UTC+0) by Jason Glatzer
Level 12: 1,000/2,000 (2,000) Entries: 257/856
It has been a roller coaster ride the last couple of hands for Kasper Mellanen during the closing moments of Level 11.
First Mellanen snagged the 25,000 in Egidijus Digrys's stack when his big slick was good against ace-seven. Next, Emanuele Mari got his stack of nearly 100,000 in and it was a 200,000 chip pot on the line with Mellanen ahead with kings against ace-king only to double his opponent after an ace hit the flop.
Last, but not least, he called a three-bet shove for about a starting stack by high-stakes stud Anatoly Filatov.
Anatoly Filatov: Kasper Mellanen:
Mellanen connected with the flop but was far behind the set Filatov improved to. Neither the turn nor the river was of any consequence for Filatov to officially double.
Meanwhile, the first-ever Kings of Tallinn Main Event champion Ranno Sootla hit the rail for the second time today.
Player
Chips
Progress
Emanuele Mari
205,000
157,400
Kasper Mellanen
110,000
104,000
Anatoly Filatov
65,000
35,000
Nikita Zarovs
0
0
Marko Olop
0
0
Juho Suutari
0
0
Viktor Chaikin
0
0
Peder Kjellen
0
0
Heikki Kinnunen
0
0
Elias Jalovaara
0
0
Egidijus Digrys
0
0
Mantas Bagocius
0
0
Ville-Tapio Mesirahta
0
0
Thomas Haverstad
0
0
Igor Pihela Sr.
0
0
Rytis Pranarauskas
0
0
Yuval Rosenberg
0
0
Henri Ojala
0
0
Lars Andersson
0
0
Kyosti Isberg
0
0
Jako Kuusik
0
0
Stanislav Smeljov
0
0
Laurynas Cerniauskas
0
0
Robertas Smolskis
0
0
13:27 (UTC+0)
Start of Level 12 Blinds: 1,000/2,000 Ante: 2,000
Prize Pool Over €800K Posted Friday 1st March, 2024 at 13:19(UTC+0) by Jason Glatzer
The record-breaking Main Event prize pool keeps on growing with the field now at 852 entries for a "lucky" prize pool of €800,880.
Player
Chips
Progress
Anatoly Filatov
30,000
0
Juuso Wiksten
0
0
Mihkel Merekula
0
0
Nikolaos Ktenas
0
0
Romas Bassus
0
0
Juho Heiska
0
0
Maciej Komorowski
0
0
Bartlomiej Kijak
0
0
Richard Melby
0
0
Johan Palokangas
0
0
Tapio Aaltonen
0
0
Steponas Venckus
0
0
Nils Linden
0
0
Silja Kinnunen
0
0
Modestas Kryzanauskas
0
0
Kaspars Mamons
0
0
Cowboys for Kaitanen Posted Friday 1st March, 2024 at 13:11(UTC+0) by Jason Glatzer
Level 11: 1,000/1,500 (1,500) Entries: 270/846
Juha Kaitanen opened for 3,000 from under the gun and was called by Kristian Kostiander (pictured below) from middle position. Richard Koppel three-bet the button to 11,500. Mykolas Guiga cold-called from the bit blind before Kaitanen five-bet shoved for 46,700. Kostiander and Koppel folded, while Guiga tossed a chip in to call.
Juha Kaitanen: Mykolas Guiga:
"I had ace-jack," said Koppel.
"I had fives," Kostiander added.
If Koppel had ace-jack he would have won after connecting with his ace on the runout. However, instead, Kaitanen's kings were good to double through Guiga.
Player
Chips
Progress
Juha Kaitanen
130,000
100,000
Richard Koppel
75,000
14,000
Kristian Kostiander
55,000
13,800
Mykolas Guiga
45,000
70,100
Big Slick No Good for Loikkanen Posted Friday 1st March, 2024 at 12:43(UTC+0) by Jason Glatzer
Level 11: 1,000/1,500 (1,500) Entries: 291/836
Michel Karim opened for 3,500 from middle position. Arto Loikkanen three-bet shoved for 18,500 from the hijack. Trond Aanestad went into the tank for about a minute before he four-bet jammed for 47,000 from the cutoff.
Karim, who chipped up a bit from the start of the day, asked for a count and then about 20 seconds later folded.
Arto Loikkanen: Trond Aanestad:
Sevens won the flip and Loikkanen headed to the rail after the ran out on the board.
Player
Chips
Progress
Michel Karim
190,000
61,100
Trond Aanestad
75,000
20,900
Phil Gross
0
0
Juha Elo
0
0
Jose Larios
0
0
Arto Loikkanen
0
0
Atkell, Omland, and Rysgaard Lead Main Event Posted Friday 1st March, 2024 at 12:32(UTC+0) by Jason Glatzer
Level 11: 1,000/1,500 (1,500) Entries: 296/835
Greger Aktell appeared to have the chip lead at the break followed by Kings of Tallinn €350 Cup champion Sven Omland (pictured below) and start-of-the-day chip leader Christian "Sleeping Beauty" Rysgaard.
Check out some of the bigger stacks from around the room below.
Player
Chips
Progress
Greger Aktell
327,000
185,800
Sven Omland
318,000
84,200
Christian Rysgaard
310,000
5,700
Adrians Imsa
290,000
84,400
Josep Pastor
260,000
63,600
Aleksei Smirnov
260,000
40,000
Henri Wagner
250,000
56,500
Niclas Mjelstad
249,000
144,700
Benny Hagberg
240,000
155,100
Kazimieras Ramaska
240,000
93,800
Kasper Mellanen
214,000
155,500
12:26 (UTC+0)
Start of Level 11 Blinds: 1,000/1,500 Ante: 1,500
More Level 10 Eliminations Posted Friday 1st March, 2024 at 12:25(UTC+0) by Jason Glatzer
Player
Chips
Progress
Marko Vest
0
0
Christopher Barlow
0
0
Daniel Mccormack
0
0
Totti Arosuo
0
0
Eedi Kirves
0
0
Terje Finsveen
0
0
George Sandford
0
0
Ville Jantunen
0
0
Hans Erlandsson
0
0
Jon Gurrutxaga
0
0
Artur Kulanurk
0
0
Vetle Holum
0
0
Zydrunas Karcemarskas
0
0
First Break Posted Friday 1st March, 2024 at 12:05(UTC+0) by Jason Glatzer
Get up and stretch! Players are on a 20-minute break. We will update some of the biggest stacks from around the room shortly after the action resumes.
"Don't Write This" Posted Friday 1st March, 2024 at 12:04(UTC+0) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 309/817
There is rarely a dull moment when Germany's Phil Gross (pictured below) is in Tallinn. He is a nice and funny guy that has a strong passion for poker.
"Don't write this," Gross said semi-seriously after we witnessed the following hand.
Gross three-bet jammed for about 16,000 and was looked up by Kaur-Silver Koha, who originally opened.
Phillip Gross: Kaur-Silver Koha:
"Nice hand," Gross said as he stood up to watch the from a step away from the table. However, he sat back down after the turn improved him to a flush. Koha was drawing dead and officially paid off Gross after the river completed the board.
Meanwhile, local hero Marius Morel was the table caption with 170,000.
Player
Chips
Progress
Marius Morel
170,000
91,400
Kaur-Silver Koha
98,000
17,300
Phil Gross
35,000
36,100
Max Rotko Loses the Max Posted Friday 1st March, 2024 at 11:52(UTC+0) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 309/817
We learned from Aki Pyysing that Max Rotko (pictured below) in Finnish translates to losing the max. Unfortunately, for Rotko he lived up to his name in a hand against Silver Simulask.
But before that hand happened, Allan Arjut shared that he paid off Rotko light with fives on a turn that improved Rotko to a flush to get back down to a starting stack.
Rotko and his improved stack then got it in on the flop against Simulask.
Max Rotko: Silver Simulask:
Simulask was ahead but there were a few outs that could help Rotko not lose the max. However, the number of outs faded after the turn improved Simulask to a full house and the blank river sent Rotko to the rail for the third time today.
Player
Chips
Progress
Silver Simulask
130,000
64,800
Aki Pyysing
42,000
9,600
Allan Arjut
31,000
3,200
Hanna Heinlo
0
0
Max Rotko
0
0
Eleftherios Sinnos
0
0
Paulius Glosas
0
0
Michael Ibba
0
0
Christos Leantzis
0
0
Algirgas Sukys
0
0
Emil Heikkinen
0
0
Kaspars Butans
0
0
Siim Suviste
0
0
Sander Lithun
0
0
Hai Hoang
0
0
Viktor Chaikin
0
0
Simo Raikkonen
0
0
Jan-Mikael Kesanen
0
0
Recent Eliminations Posted Friday 1st March, 2024 at 11:39(UTC+0) by Jason Glatzer
The following players including Finland's Anne-Mari Hursti hit the rail during the first half of Level 10.
Player
Chips
Progress
Andrea Benelli
0
0
Anne Koskinen
0
0
Doroslav Rasiukevic
0
0
Neeme Org
0
0
Dominykas Skrinska
0
0
Anna-Mari Hursti
0
0
Justas Vaiciulionis
0
0
Yana Gorskaya
0
0
Kent Lindback
0
0
Kim Lindstrom
0
0
Jaanus Veste
0
0
Martynas Kaulakys
0
0
Gisle Olsen
0
0
Patriks Svinka
0
0
Tanel Evert
0
0
Rickard Rohani
0
0
Aleksandr Kuperman
0
0
Andreas Werner
0
0
Risto Parnat
0
0
Niklas Gjersvold
0
0
Smirnov Flops a Straight Posted Friday 1st March, 2024 at 11:31(UTC+0) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 319/808
Aleksei Smirnov (pictured below) bet 31,000 into a pot of a little bit more with the on the board. Fernando Yerro tanked for about a minute before he called.
Smirnov turned over the . Yerro shook his head in frustration and mucked his hand after being unable to produce an equal or better straight.
Meanwhile, Vytautas Laurinaitis, who is sitting at the same table, chipped up a little as well since the start of the day.
Player
Chips
Progress
Aleksei Smirnov
220,000
50,000
Vytautas Laurinaitis
175,000
57,900
Fernando Yerro
35,000
35,400
800 Entries! Posted Friday 1st March, 2024 at 11:16(UTC+0) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 338/800
The record for the Main Event keeps getting bigger and bigger as the field has reached 800 entries for a €752,000 prize pool and growing!
Thank you to all of the players for contributing to the success of the Kings of Tallinn and may the cards be with you today.
2023 Kings of Tallinn Main Event Champ Parmasto Among the Level 9 Eliminations Posted Friday 1st March, 2024 at 11:12(UTC+0) by Jason Glatzer
2023 Kings of Tallinn Main Event champion Priit Parmasto hit the rail on Level 9 and hasn't yet re-entered. He wasn't the only one as all of the above players hit the rail and thus far having headed back to the registration desk.
Player
Chips
Progress
Hengtao Zhu
0
0
Seppo Parkkinen
0
0
Daniyel Destici
0
0
Massimo Casabona
0
0
Vladimir Trojak
0
0
Fatih Kizilkaya
0
0
Simone Battaglia
0
0
Luigi Tasca
0
0
Priit Parmasto
0
0
11:06 (UTC+0)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Tikka Gives Up to Lattikas Posted Friday 1st March, 2024 at 11:06(UTC+0) by Jason Glatzer
Level 9: 500/1,000 (1,000) Entries: 338/794
Kris Tikka (pictured below) bet 22,000 into a pot of at least 30,000 with the on the board. Aleksander Lattikas went into the tank for a couple of minutes before he jammed.
Tikka tanked for a minute before he asked for a count. Lattikas's jam of 72,800 was confirmed and Tikka tanked for around two more minutes before he folded.
Lattikas looked back down at his cards and updated to show his .
Several at the tables gasped or had their mouths open wide when he tabled with "nice play" being heard as well from a table away.
Player
Chips
Progress
Aleksander Lattikas
145,000
31,400
Kris Tikka
105,000
36,600
Day 2 Eliminations Posted Friday 1st March, 2024 at 10:54(UTC+0) by Jason Glatzer
The following players have hit the rail on Day 2. This list below represents players that haven't re-entered at the time of this post but might do so within the next four hours until late registration closes.
Player
Chips
Progress
Federico Cipollini
0
0
Darius Miklovas
0
0
Thor Morstol
0
0
Pasi Trollhjarta
0
0
Rytis Pranarauskas
0
0
Eetu Porkka
0
0
Ragnar Toompere
0
0
Joachim Gjerstad
0
0
Madis Ormisson
0
0
Adomas Juozapavicius
0
0
Ari Varonen
0
0
Andrei Harlanov-Voogla
0
0
Kiur Koster
0
0
Audrius Navickas
0
0
Meelis Suurorg
0
0
Tomas Kirchovas
0
0
Jesperi Jarvinen
0
0
Two Pair for Leibgorin Posted Friday 1st March, 2024 at 10:46(UTC+0) by Jason Glatzer
Level 9: 500/1,000 (1,000) Entries: 346/781
Michel Leibgorin re-entered at the start of the day and thus far it has been all peaches and ice cream for the French poker veteran.
Leibgorin recently jammed 15,000 into a pot of 35,000 with the on the board after the turn. Rolandas Aglinskas, who chipped up from his start-of-the-day stack, asked for a count and called about a minute later.
"I only have a seven," Leibgorin said as he turned over the .
Leibgorin seemed surprised he was ahead as Aglinskas tabled the .
"I have two pair!" Leibgorin said with a smile after the river completed the board to double his stack.
Player
Chips
Progress
Rolandas Aglinskas
105,000
32,600
Michel Leibgorin
65,000
35,000
Rockets Hold for Vaitulionis Against Pihela Sr. Posted Friday 1st March, 2024 at 10:31(UTC+0) by Jason Glatzer
Level 9: 500/1,000 (1,000) Entries: 344/775
Ignas Vaitulionis opened from middle position. Igor Pihela Sr. (pictured below) three-bet to 5,500 from the small blind. Vaitulionis called before Pihela Sr. jammed around a starting stack on the flop.
Igor Pihela Sr.: Ignas Vaitulionis:
Pihela Sr. needed a miracle to survive but there was no chance of that happening after he was drawing dead on the turn. The river completed the board and Pihela Sr. was walking towards the registration desk to re-enter for another chance at winning a slice of the record-breaking Main Event prize pool.
Player
Chips
Progress
Ignas Vaitulionis
100,000
40,900
Igor Pihela Sr.
30,000
44,500
Salonen Calls AFTER a Count Posted Friday 1st March, 2024 at 10:17(UTC+0) by Jason Glatzer
Level 9: 500/1,000 (1,000) Entries: 345/762
The action paused on Rytis Pranarauskas before he fired out a pot-sized jam into a pot of around 60,000 with the on the board.
"Count," said Jarmo Salonen.
"Call?" asked the dealer as Salonen's statement was unclear.
"Count," Salonon said a bit clearer.
Salonen opted to call a short while after the count was confirmed. Pranarauskas turned over the and was on the rail after Salonen tabled the for two pair.
Player
Chips
Progress
Jarmo Salonen
200,000
92,400
Rytis Pranarauskas
0
0
Prize Pool Over €700K Posted Friday 1st March, 2024 at 10:07(UTC+0) by Jason Glatzer
Level 9: 500/1,000 (1,000) Entries: 346/754
Kings of Tallinn Founder and Tournament Director Teresa Nousiainen welcomed the crowd for Day 2 of the record-breaking Kings of Tallinn Main Event.
The prize pool soared past €700,000 already with 23 new players coming into the mix before the first cards were dealt including Monika Leek, Giuseppe Rosa, and Maciej Komorowski.
Expect tons of action while late registration remains open and for the prize pool to grow. Best of luck to all of the players.
Player
Chips
Progress
Giuseppe Rosa
30,000
0
Maciej Komorowski
30,000
0
Monika Leek
30,000
0
10:04 (UTC+0)
Day 2 of Kings of Tallinn 2024 Started Level: 9 Blinds: 500/1,000 Ante: 1,000
Day 2 of the Record-Breaking Kings of Tallinn Main Event Begins at Noon Posted Friday 1st March, 2024 at 08:33(UTC+0) by Jason Glatzer
The 2024 Kings of Tallinn has been truly magical with the festival witnessing records breaking left and right. History has been made once again as the latest attendance record was shattered early on Thursday with the Kings of Tallinn €1,100 Main Event guaranteed to be the largest in history. Not only was the lofty €500,000 guarantee smashed with 731 runners so far for a €687,140 prize pool and growing but this is already guaranteed to be the largest €1,100 Main Event in Estonian poker history.
Day 2 will kick off on Friday at Noon with more players getting into the mix thanks to late registration and re-entries available for the first four blind levels of one hour each. Players buying in at the start of the day will play off a decent stack of 30 big blinds with a 30,000 starting stack and the 500/1,000 (1,000) blind level repeating at the start of the day.
Lithuania's Christian Rysgaard not only earned the name of "Sleepy Beauty" in the €555 Championship but is in the driver's seat to further cement the new legend's status in the Kings of Tallinn history books as he will begin Day 2 with a chip-leading stack of 304,300.
No other player bagged anything else that was close. However, three other players in 2024 Kings of Tallinn €350 Cup champion Sven Omland (233,800), Latvia's Adrian Imsa (205,600), and United Kingdom's Maximillian Sanders (203,900).
Sanders (pictured below), had the day off after bagging his big stack on Wednesday's Day 1a and made the most of it as he won a trophy on Thursday evening in the €250 NLH to bank €7,280.
The plan for today is to play eight blind levels of one hour each. However, this is subject to change. The field is expected to grow even bigger today, so the day may be extended.
Our reporting will begin when cards are in the air at 12 p.m. for Day 2. Players bagging on Day 2 will battle for two more days until the record-breaking Kings of Tallinn Main Event has been crowned.
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.