0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0067 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/91'
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.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0039 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1
0.0246 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0036 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1
0.0246 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0034 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '256'
AND `published` = 1
0.0251 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1
0.0055 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.0042 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` = '263'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11881'
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` = '11879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11872'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11870'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11861'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11858'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11855'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11853'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11848'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11842'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11840'
ORDER BY `chip_change` DESC, `busted` ASC
0.0090 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11836'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11835'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11827'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11826'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11821'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11814'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11812'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11811'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11810'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11808'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11806'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11803'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11802'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11801'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11797'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11796'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11794'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11793'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11791'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11790'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11785'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11783'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11775'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11773'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11769'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11763'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11747'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11743'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11686'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11682'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11681'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11676'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11670'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11667'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11662'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11652'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11650'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11647'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11644'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11639'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11640'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 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.0054 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.0055 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_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '256'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 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.0049 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` = '263'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11879'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11878'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11875'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11872'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11870'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11869'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11867'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11863'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11861'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11858'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11855'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11853'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11851'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11849'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11848'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11842'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11840'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11836'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11835'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11827'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11826'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11821'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11814'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11812'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11811'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11810'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11808'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11806'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11803'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11802'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11801'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11797'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11796'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11794'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11793'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11791'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11790'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11786'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11785'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11783'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11775'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11773'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11769'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11767'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11763'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11747'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11743'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11738'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11704'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11686'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11682'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11681'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11676'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11670'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11667'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11662'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11652'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11650'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11647'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11644'
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` = '11639'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11640'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 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 4 of Kings of Tallinn 2024 Ended Level: 35 Blinds: 200,000/400,000 Ante: 400,000
Edgaras Kausinis Crowned King of Tallinn After Conquering Record-Breaking Main Event Posted Sunday 3rd March, 2024 at 22:18(UTC+0) by Frank Visser
The 2024 Kings of Tallinn €1,100 Main Event drew a massive field of 914 entries, absolutely obliterating the previous record of 716 entries, stemming from last year. An equally gigantic prize pool of €859,160 was created, and when all was said and done, EdgarasKausinis was the first-ever Lithuanian Kings of Tallinn Main Event winner taking home the lion's share of €120,910, the trophy, and the ever-lasting glory of becoming a Kings of Tallinn champion.
Kausinis' live breakout was just a month ago at OlyBet Ace Break Vilnius, where he won the €1,100 High Roller, though it has been said that Kausinis has plenty of experience playing tournaments online. Today, he added another trophy to his newly forming collection, along with a new career-best score.
Kausinis made a three-way deal with his fellow countryman Mantas Tamulevicius, whom he defeated heads up after a short but swingy battle, and Aleksi Naksi from Finland, who was on his second consecutive Kings of Tallinn Main Event final table after finishing sixth in 2023. They both took home €105,000, while the likes of 2023 €550 Championship winner Benjamin Gros and businessman and high roller Paul Newey secured a five-figure payout on the final table of eight.
€1,100 Main Event Final Table Results
Rank
Player
Country
Prize
1
Edgaras Kausinis
Lithuania
€120,910*
2
Mantas Tamulevicius
Lithuania
€105,000*
3
Aleksi Naski
Finland
€105,000*
4
Benjamin Gros
France
€54,800
5
Even Rislov
Norway
€39,600
6
Greger Aktell
Sweden
€30,350
7
Wissam Polus
Sweden
€23,100
8
Paul Newey
United Kingdom
€17,800
*=Denotes three-way deal
Day 4 Action
Eleven hopefuls returned to Olympic Park Casino in Tallinn for the final day of the Main Event, but two more had to depart before a final table could be formed. Danish poker legend Frederik Brink bowed out in 11th soon after the day had started, running tens into kings. Last Estonian standing Herli Olop then followed quickly in tenth, while simultaneously Mindaugas Jonaitis took a bad beat on the outer table to send eight players to the final table.
Once there, the play slowed down significantly. After nearly two hours without eliminations, Newey bit the dust as he could not spin up his seven blinds. What followed was a three-and-a-half-hour-long standoff between seven players, seeing multiple double-ups and several changes in the chip lead. Eventually, Wissam Polus had enough and three-bet jammed eleven big blinds with four-three offsuit. He could not best the ace-king of Naski and was sent home in seventh place.
A few hands later, fellow Swede Greger Aktell joined Polus on the rail after his ace-king ran into the aces of Tamulevicius. In the meantime, the stacks had become shallower with the increasing blinds, and eventually, the five remaining players all had roughly the same number of chips. However, as it goes with poker, someone has to be on the short end, and that turned out to be Even Rislov. The Norwegian could not improve his ace-queen against the ace-king of Kausinis and was eliminated in fifth.
The same Kausinis won a flip against Gros to knock the Frenchman out in fourth, and the three remaining players played for a few minutes before they went off to discuss a deal. After the numbers were agreed upon and they had shaken hands, Naski bluffed off most of his stack on a four-flush board before eventually losing a coin flip to Kausinis to fall in third place.
The heads-up was then set up between Kausinis and Tamulevicius. The Lithuanians battled only briefly, with Tamulevicius receiving a double-up at the beginning to take the lead. However, Kausinis got value with a straight to take it right back and made another straight a few hands later to seal the deal, getting it all in against Tamulevicius' top pair, who was already drawing dead.
That concludes the coverage for the record-breaking 2024 edition of Kings of Tallinn, but numerous other poker festivals are sure to follow in the Estonian capital, with Queens of Tallinn and WSOPC Tallinn, already having been announced.
Edgaras Kausinis Wins Biggest-Ever Kings of Tallinn Main Event (€120,910) Posted Sunday 3rd March, 2024 at 20:58(UTC+0) by Frank Visser
Edgaras Kausinis limped his button and Mantas Tamulevicius made it 1,400,000 to go from the big blind. Kausinis paid to see a flop of .
Tamulevicius continued for 1,400,000 chips and Kausinis just called with his flopped straight. The turn fell and Tamulevicius jammed all in for 5,000,000 chips. An instant call followed from his opponent as the cards were tabled.
Mantas Tamulevicius: Edgaras Kausinis:
Tamulevicius was already drawing dead against the flopped straight of Kausinis. The meaningless river was dealt as a formality while the two Lithuanian players shook hands.
Tamulevicius had to be content with becoming the runner-up, while Kausinis was declared the Main Event champion.
Player
Chips
Progress
Edgaras Kausinis
27,000,000
9,000,000
Mantas Tamulevicius
0
0
Kausinis Hits Right Back Posted Sunday 3rd March, 2024 at 20:44(UTC+0) by Frank Visser
Edgaras Kausinis limped in with on the button and Mantas Tamulevicius made it 1,200,000 to go with on the button. Kausinis made the call to see a flop of .
Tamulevicius made another bet of 1,200,000 and Kausinis called. The turn was checked by both before the river completed Kausinis' straight.
Tamulevicius checked once more, after which Kausinis bet 4,000,000 chips. Tamulevicius made a quick call, seeing his middle pair lose against the straight of Kausinis.
Player
Chips
Progress
Edgaras Kausinis
18,000,000
7,000,000
Mantas Tamulevicius
9,400,000
6,600,000
Tamulevicius Takes Over Lead Posted Sunday 3rd March, 2024 at 20:38(UTC+0) by Frank Visser
Edgaras Kausinis limped in from the sall blind with and Aleksi Naski checked his in the big blind. Kausinis flopped a straight on and bet 300,000, which Naksi called with his top pair.
The inconsequential turn was dealt and Kausinis put 1,500,000 chips in the middle. Naski put in the same amount for a call before the river completed the board.
The fourth diamond saw Kausinis slow down as he checked to Naski. Naski put on the pressure with an all-in bet of 4,400,000 effectively and sent Kausinis into a small tank.
Eventually, Kausinis slammed in a call and saw that his straight was good enough to double him up, leaving Naski with ten big blinds.
Player
Chips
Progress
Edgaras Kausinis
13,000,000
3,000,000
Aleksi Naski
3,000,000
3,500,000
Deal Numbers Posted Sunday 3rd March, 2024 at 20:06(UTC+0) by Frank Visser
Aleksi Naski raised to 600,000 on the button with and Edgaras Kausinis called in the big blind.
The turn and turn were checked by both before the fell on the river. Kausinis bet his two pair for 875,000 and Naski snap called his ace-high, seeing his chips being added to Kausinis' stack.
Player
Chips
Progress
Edgaras Kausinis
10,000,000
1,400,000
Aleksi Naski
6,500,000
800,000
Benjamin Gros Eliminated in 4th Place (€54,800) Posted Sunday 3rd March, 2024 at 19:40(UTC+0) by Frank Visser
Benjamin Gros limped in from the small blind and Edgaras Kausinis jammed all in from the big blind, covering Gros' stack of 3,900,000.
Gros rechecked his cards before putting in a quick call, and the holdings were revealed.
Benjamin Gros: Edgaras Kausinis:
Gros' nines remained ahead on the flop but the turn saw Kausinis take a massive lead. Gros could not hit a set on the river and he was eliminated in fourth place.
Player
Chips
Progress
Edgaras Kausinis
8,600,000
3,700,000
Benjamin Gros
0
0
Naski Fails to Hit Posted Sunday 3rd March, 2024 at 19:36(UTC+0) by Frank Visser
Aleksi Naski limped in from the small blind with and Mantas Tamulevicius checked in the big blind. The flop came down and Naski checked to Tamulevicius.
The latter then fired 400,000 chips and Naski called. The turn saw Tamulevicius increase the bet to 600,000. Naski still stuck around with a call and the river completed the board.
Both players checked and Tamulevicius' pair of tens won at showdown.
Player
Chips
Progress
Mantas Tamulevicius
11,000,000
1,900,000
Aleksi Naski
7,300,000
1,200,000
Naski Survives Flip Posted Sunday 3rd March, 2024 at 19:30(UTC+0) by Frank Visser
Aleksi Naski raised to 1,500,000 under the gun, the majority of his stack. Edgaras Kausinis then pushed all in from the big blind with the covering stack and Naski made the call.
Aleksi Naski: Edgaras Kausinis:
The deck brought a sweat on , but Naski faded all outs on the river and doubled up to second in chips.
Player
Chips
Progress
Aleksi Naski
8,500,000
4,900,000
Edgaras Kausinis
4,900,000
4,200,000
19:22 (UTC+0)
Start of Level 34 Blinds: 150,000/300,000 Ante: 300,000
Tamulevicius Wins Lithuanian Battle Posted Sunday 3rd March, 2024 at 19:20(UTC+0) by Frank Visser
Mantas Tamulevicius raised to 525,000 with under the gun and Aleksi Naski defended his big blind with . Naski checked on the flop before calling Tamulevicius' 550,000 bet.
The turn brought Naski even more outs as he check-called 900,000 more chips. However, the river did not bring help and he lost went two checks brought the hands to showdown.
Player
Chips
Progress
Mantas Tamulevicius
7,900,000
2,900,000
Aleksi Naski
3,600,000
1,900,000
Even Rislov Eliminated in 5th Place (€39,600) Posted Sunday 3rd March, 2024 at 19:04(UTC+0) by Frank Visser
Benjamin Gros went all in on the button for 2,300,000 and Aleksi Naski snap-called in the big blind.
Benjamin Gros: Aleksi Naski:
The flop saw Gros jump ahead in the flip, while the turn meant he could not lose anymore. No chop appeared on the river and Gros doubled up, resulting in the final five players being very close in the chip counts.
Player
Chips
Progress
Aleksi Naski
5,500,000
1,400,000
Benjamin Gros
4,900,000
1,800,000
Rislov Doubles, Nears Chip Lead Posted Sunday 3rd March, 2024 at 18:33(UTC+0) by Frank Visser
Even Rislov sat in the cutoff and raised to 500,000. Chipleader Aleksi Naski defended his big blind and a flop of fanned out.
Naski checked to the preflop raiser on the flop. Rislov bet 450,000 and Naski raised to 950,000.
Erislov then jammed all in for 2,700,000 chips and Naski quickly called.
Even Rislov: Aleksi Naski:
Naski had flopped a flush draw and was almost flipping against the cowboys of Rislov. However, the turn did not bring him anything and the river upgraded Rislov to a set.
Rislov doubled up and ended up with nearly the same stack as Naski.
Player
Chips
Progress
Aleksi Naski
6,900,000
3,100,000
Even Rislov
6,700,000
2,200,000
18:24 (UTC+0)
Start of Level 33 Blinds: 125,000/250,000 Ante: 250,000
A Shorter Break Posted Sunday 3rd March, 2024 at 18:08(UTC+0) by Frank Visser
Benjamin Gros raised to 550,000 in the small blind with and Edgaras Kausinis called the big blind with . Both players then checked on the flop before the came on the turn.
Gros and Kausinis checked again and the river completed the board. Gross reached for 800,000 chips and put them in the middle and a quick call followed from Kausinis.
Kausinis' top pair won at showdown, leaving Gros with a stack of 15 big blinds.
Player
Chips
Progress
Edgaras Kausinis
6,000,000
1,800,000
Benjamin Gros
3,100,000
900,000
Naski Takes More From Tamulevicius Posted Sunday 3rd March, 2024 at 17:55(UTC+0) by Frank Visser
Aleksi Naski raised to 400,000 on the button with and Mantas Tamulevicius called in the small blind with . The flop fell and Tamulevicius check-called the 300,000 bet of Naski.
Another check followed from Tamulevicius on the turn, after which Naski made a big bet of 1,250,000. Tamulevicius quickly gave up the best hand and Naski's stack increased to eight figures.
Player
Chips
Progress
Aleksi Naski
10,000,000
400,000
Mantas Tamulevicius
5,000,000
1,100,000
Naski Gets Value Posted Sunday 3rd March, 2024 at 17:45(UTC+0) by Frank Visser
Aleksi Naski raised to 400,000 with in the cutoff and Mantas Tamulevicius flat-called on the button.
Naski then check-called Tamulevicius' 350,000-chip bet on the flop before the was turned. Another check followed from Naski, and this time Tamulevicius followed suit.
The river completed the board and gave Tamulevicius a pair. Naski fired 425,000 chips into the middle and Tamulevicius made an instant call.
Naski's top pair won him the pot at showdown as he extended his chip lead, ending up with nearly 50 big blinds.
Player
Chips
Progress
Aleksi Naski
9,600,000
1,700,000
Mantas Tamulevicius
6,100,000
1,200,000
Greger Aktell Eliminated in 6th Place (€30,350) Posted Sunday 3rd March, 2024 at 17:40(UTC+0) by Frank Visser
Aleksi Naski raised to 400,000 from the hijack with and Even Brislov called on the button with . Benjamin Gros sat in the small blind with and three-bet to 1,500,000 around half of his stack.
The other players quickly folded their cards and Gros increased his stack significantly without showdown.
Player
Chips
Progress
Aleksi Naski
7,900,000
400,000
Even Rislov
4,500,000
400,000
Benjamin Gros
4,000,000
1,200,000
Updated Counts as Naski Builds Big Lead Posted Sunday 3rd March, 2024 at 17:31(UTC+0) by Frank Visser
Player
Chips
Progress
Aleksi Naski
8,300,000
400,000
Even Rislov
4,900,000
100,000
Edgaras Kausinis
4,200,000
600,000
Mantas Tamulevicius
3,900,000
600,000
Greger Aktell
3,300,000
600,000
Benjamin Gros
2,800,000
700,000
Wissam Polus Eliminated in 7th Place (€23,100) Posted Sunday 3rd March, 2024 at 17:19(UTC+0) by Frank Visser
Aleksi Naski raised to 400,000 from the cutoff before Wissam Polus jammed all in from the big blind for 2,200,000.
Naski immediately called and the cards were tabled.
Wissam Polus: Aleksi Naski:
Polus' move seemed to be rewarded on the flop, but the turn gave Naski the higher pair. The river was of no help to either player and Polus was eliminated in seventh place.
Player
Chips
Progress
Aleksi Naski
7,900,000
1,900,000
Wissam Polus
0
0
Tamulevicius Tries to Hero Posted Sunday 3rd March, 2024 at 17:15(UTC+0) by Frank Visser
Even Rislov raised to 400,000 as first to act and Mantas Tamulevicius called in the big blind.
The pair checked through the flop and turn before Rislov bet 450,000 on the river.
Tamulevicius threw in a quick call with his pair of fives but was outmatched by the pair of aces of Rislov, who was awarded the pot.
Player
Chips
Progress
Even Rislov
4,800,000
1,300,000
Mantas Tamulevicius
4,500,000
600,000
17:06 (UTC+0)
Start of Level 32 Blinds: 100,000/200,000 Ante: 200,000
Polus Finds Unconventional Shove Posted Sunday 3rd March, 2024 at 17:06(UTC+0) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 7/914
Aleksi Naski raised to 300,000 from middle position with and the action folded to Wissam Polus on the button, who shoved all in for 1,700,000 with .
Everyone on the table folded, including Naski, and Polus' risky move gathered some chips to stay alive.
Player
Chips
Progress
Aleksi Naski
6,000,000
100,000
Wissam Polus
2,400,000
200,000
Rislov Wins Three-Way Affair Posted Sunday 3rd March, 2024 at 16:47(UTC+0) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 7/914
Aleksi Naski raised to 300,000 from the hijack with and Mantas Tamulevicius called in the cutoff with . Even Rislov also flicked in the chips on the button with and the flop of emerged from the deck.
The action checked to Rislovl and he bet 450,000 with his top pair. Naski folded his eights and Tamulevicius tossed his cards into the muck as well, seeing Rislov chip up further.
Player
Chips
Progress
Aleksi Naski
6,100,000
400,000
Mantas Tamulevicius
5,100,000
100,000
Even Rislov
3,500,000
1,300,000
Kausinis Wins Battle of Blinds Posted Sunday 3rd March, 2024 at 16:34(UTC+0) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 7/914
Benjamin Gros limped in from the small blind with , which Edgaras Kausinis raised to 550,000 with in the big blind. Gross made the call and a flop of appeared.
Gros checked before Kausinis continued for 300,000. Gross flicked in a call for the turn to hit felt. Kausinis fired 900,000 more into the pot and it was enough to let Gros fold his gutshot.
Player
Chips
Progress
Edgaras Kausinis
4,800,000
1,000,000
Benjamin Gros
3,500,000
1,200,000
Four-Bet Chips Up Tamulevicius Posted Sunday 3rd March, 2024 at 16:21(UTC+0) by Frank Visser
Level 31: 75,000/150,000 (150,000) Entries: 7/914
Mantas Tamulevicius opened the action with a raise to 350,000 from under the gun with . Benjamin Gross flat-called in the cutoff before Aleksi Naski made it 1,100,000 to go in the big blind with .
Tamulevicius jammed all in for 3,600,000, which folded out both of his opponents and awarded him the pot.
Player
Chips
Progress
Aleksi Naski
6,500,000
900,000
Mantas Tamulevicius
5,200,000
1,400,000
Benjamin Gros
4,700,000
1,000,000
16:06 (UTC+0)
Start of Level 31 Blinds: 75,000/150,000 Ante: 150,000
Another Break for Seven Posted Sunday 3rd March, 2024 at 15:44(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Another level went by without any eliminations, and the players were sent on a 25-minute break at the end of it.
Naski Wins Three-Bet Pot Posted Sunday 3rd March, 2024 at 15:42(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Greger Aktell in the cutoff raised to 250,000 with before Aleksi Naski made it 575,000 to go on the button with . Aktell made the call and a flop of appeared on the table.
Aktell checked to Naski, who made a bet of 175,000. Aktell floated with his queen-high and the subsequent turn was checked by both.
The river then completed the board and was also checked down, seeing Naski's ace-high take down the pot at showdown.
Player
Chips
Progress
Aleksi Naski
7,400,000
1,000,000
Greger Aktell
2,700,000
700,000
Naski Takes Pot from Polus to Reclaim Lead Posted Sunday 3rd March, 2024 at 15:36(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Wissam Polus raised to 300,000 with in the hijack and Aleksi Naski made the call with in the big blind. The flop gave Naski two pair and he check-called the 200,000 chips Polus put out.
Polus continued for 675,000 on the subsequent turn, after which Naski jammed all in. Polus' king-high quickly disappeared into the muck and he was left with just over 20 big blinds.
Player
Chips
Progress
Aleksi Naski
6,400,000
1,400,000
Wissam Polus
2,600,000
1,200,000
Gros Squeezes One In To Take Over Lead Posted Sunday 3rd March, 2024 at 15:28(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Greger Aktell raised to 250,000 from under the gun with and Even Rislov called in the cutoff with . Benjamin Gros then looked at in the small blind, who made a three-bet to 900,000.
Aktell quickly folded and Rislov eventually followed suit.
Player
Chips
Progress
Benjamin Gros
5,700,000
1,200,000
Greger Aktell
3,400,000
0
Even Rislov
2,200,000
700,000
Rislov Catches Lucky Double-Up Posted Sunday 3rd March, 2024 at 15:19(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Even Rislov jammed his 1,300,000 chips in the middle from under the gun and Aleksi Naski made the call in the small blind.
Even Rislov: Aleksi Naski:
Rislov had one foot out the door when the flop appeared. However, the turn saw him take a commanding lead, and the river sealed the deal.
Rislov booked a double-up to just over 20 big blinds, while Naski saw his lead decrease.
Player
Chips
Progress
Aleksi Naski
5,000,000
1,500,000
Even Rislov
2,900,000
1,200,000
Polus Battles Leader Posted Sunday 3rd March, 2024 at 15:13(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Aleksi Naski raised to 250,000 from under the gun with and Wissam Polus made the call in the cutoff with .
Naski checked the flop to Polus, who made a bet of 400,000. A quick fold followed from Naski and the pot was shipped to Polus.
Player
Chips
Progress
Aleksi Naski
6,500,000
100,000
Wissam Polus
3,800,000
200,000
Small Pause to Resolve Technical Difficulties Posted Sunday 3rd March, 2024 at 15:02(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
The players have been sent on a short 5-minute break to resolve some technical issues on the TV table.
Kausinis Demoted to Average After Doubling Up Gros Posted Sunday 3rd March, 2024 at 14:58(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Benjamin Gros sat under the gun and raised to 250,000. Edgaras Kausinis called from the next seat over and the pair went off to a flop of
Both players checked and the arrived on the turn. Gros kept up the slow play and checked once more, after which Kausinis bet 400,000.
Gros shoved all in for 1,800,000 and Kausinis made a quick call.
Benjamin Gros: Edgaras Kausinis:
Gros' overpair held when the river paired the board, seeing him double up to more than an average stack. Former chip leader Kausinis, on the other hand, descended to the middle of the pack.
Player
Chips
Progress
Benjamin Gros
4,500,000
1,600,000
Edgaras Kausinis
3,800,000
2,300,000
Aktell Finds Double-Up Posted Sunday 3rd March, 2024 at 14:48(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Benjamin Gros raised to 275,000 from the cutoff and Edgaras Kausinis called on the button. Greger Aktell then jammed all in for 1,400,000 chips from the small blind and Kausinis looked him up after Gros had folded.
Greger Aktell: Edgaras Kausinis:
The board posed no threat to Aktell's kings, and he booked a double-up.
Player
Chips
Progress
Edgaras Kausinis
6,100,000
1,500,000
Greger Aktell
3,400,000
1,500,000
Kausinis Keeps Building Lead Posted Sunday 3rd March, 2024 at 14:44(UTC+0) by Frank Visser
Level 30: 50,000/125,000 (125,000) Entries: 7/914
Wissam Polus raised to 250,000 from the cutoff with and Edgaras Kausinis flat-called in the small blind with .
The flop saw Kausinis pair his ace, and he check-called the 200,000-chip bet of Polus. Kausinis led out for 500,000 on the turn. Polus pondered the situation for a couple of minutes, but ultimately said goodbye to his jack-high as he forfeited the pot.
Player
Chips
Progress
Edgaras Kausinis
7,600,000
700,000
Wissam Polus
4,000,000
1,100,000
14:40 (UTC+0)
Start of Level 30 Blinds: 50,000/125,000 Ante: 125,000
Rislov Becomes Shorter Posted Sunday 3rd March, 2024 at 14:39(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Even Rislov raised to 225,000 with from the cutoff and Edgaras Kausinis defended this big blind with .
Kausinis checked to Rislov on the flop, after which the Norwegian fired 200,000 chips. Kausinis raised to 500,000 with his top pair and Rislov eventually folded his cards to forfeit the pot.
Player
Chips
Progress
Edgaras Kausinis
6,900,000
500,000
Even Rislov
1,700,000
500,000
Naski Conquers Chip Lead Posted Sunday 3rd March, 2024 at 14:32(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Edgaras Kausinis opened his to 200,000 from middle position and Aleksi Naski flat-called in the cutoff. Even Rislov also came along with in the small blind and the trio checked through the subsequent flop of .
The turn paired up Naski and he fired a bet of 550,000 once the action checked to him. Both other players laid down their hands and Naski chipped up further to take the chip lead from Kausinis.
Player
Chips
Progress
Aleksi Naski
6,600,000
600,000
Edgaras Kausinis
6,400,000
0
Even Rislov
2,200,000
200,000
Naski Continues to Build Posted Sunday 3rd March, 2024 at 14:27(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Aleksi Naski raised his button to 200,000 with and Even Rislov called with in the big blind. Naski continued for 175,000 chips on the flop and Rislov called, after having checked at first.
The turn went check-check and the river saw the same action, seeing Naski win the pot with king-high.
Player
Chips
Progress
Aleksi Naski
6,000,000
500,000
Even Rislov
2,400,000
500,000
Naski Takes From Tamulevicius Posted Sunday 3rd March, 2024 at 14:24(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Aleksi Naski limped in from the small blind with and called when Mantas Tamulevicius made it 325,000 in the big blind with .
Naski checked to Tamulevicius on the flop, after which the latter bet 275,000. Naski put forth a call with his better top pair and the turn rolled off.
Tamulevicius put in another 700,000 chips and Naski once again check-called. The river slowed down the action as both players checked. Naski tabled his pair of jacks and raked in a sizable pot.
Player
Chips
Progress
Aleksi Naski
5,500,000
1,200,000
Mantas Tamulevicius
3,800,000
1,100,000
Naski Not to Be Pushed Around Posted Sunday 3rd March, 2024 at 14:16(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Aleksi Naski raised to 250,000 with from middle position before chip leader Edgaras Kausinis three-bet to 750,000 with in the big blind.
Naski clicked it back to 1,300,000 and Kausinis quickly gave his cards to the dealer, surrendering the pot.
Player
Chips
Progress
Edgaras Kausinis
6,400,000
400,000
Aleksi Naski
4,300,000
1,200,000
Tamulevicius Wins With Rockets Posted Sunday 3rd March, 2024 at 14:06(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Mantas Tamulevicius looked down at in the small blind and sneakily limped in. Even Rislov checked his in the big blind and a flop of was dealt.
Tamulevicius bet 150,000 with his aces and Rislov called his bottom pair. On the turn, Tamulevicius sized up to 375,000 and Rislov still stuck around with a call.
The river then arrived and Tamulevicius fired a third barrel of 525,000 chips. Rislov tanked for a bit but eventually gave up his threes as the pot was shipped to Tamulevicius.
Player
Chips
Progress
Mantas Tamulevicius
4,900,000
0
Even Rislov
2,900,000
700,000
Kausinis Bluffs Naski to Extend Lead Posted Sunday 3rd March, 2024 at 13:59(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Edgaras Kausinis raised his button to 200,000 with and Aleksi Naski defended the big blind with . Kausinis continued for 325,000 on the flop and Naski check-called.
Naski checked to Kausinis again on the turn, who sized up to 850,000 chips. Naski put in another call, after which the river completed the board.
After a third check from Naski, Kausinis fired 1,200,000 chips with his queen-high. Naski gave his ace-high some serious thought but eventually added his cards to the muck, surrendering the pot to Kausinis.
Player
Chips
Progress
Edgaras Kausinis
6,800,000
1,500,000
Aleksi Naski
3,100,000
1,500,000
Kausinis Finds a Squeeze Posted Sunday 3rd March, 2024 at 13:48(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Aleksi Naski raised to 200,000 under the gun with and Even Rislov called in the hijack with . Edgaras Kausinis then woke up with in the small blind and put in a three-bet to 800,000.
Naski folded his nines and Rislov also mucked his cards, seeing the pot awarded to Kausinis.
Player
Chips
Progress
Edgaras Kausinis
5,300,000
600,000
Aleksi Naski
4,600,000
200,000
Even Rislov
3,600,000
0
Paul Newey Eliminated in 8th Place (€17,800) Posted Sunday 3rd March, 2024 at 13:42(UTC+0) by Frank Visser
Level 29: 50,000/100,000 (100,000) Entries: 7/914
Aleksi Naski raised to 200,000 in middle position before Paul Newey jammed all in from the small blind for 675,000. Naski debated his decision for a bit but eventually stuck in the call.
Paul Newey: Aleksi Naski:
It was basically the best-case scenario for Newey, but Naski paired his king on the flop. Newey could not hit a better hand on the runout and he was the first elimination of the final table.
Player
Chips
Progress
Aleksi Naski
4,800,000
700,000
Paul Newey
0
0
13:35 (UTC+0)
Start of Level 29 Blinds: 50,000/100,000 Ante: 100,000
A Small Break Posted Sunday 3rd March, 2024 at 13:14(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
With no all-ins so far at the final table, the eight players have been sent on a 20-minute break.
Kausinis' Descent Continues Posted Sunday 3rd March, 2024 at 13:13(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Edgaras Kausinis raised to 160,000 with in the hijack and Even Rislov made the call with in the big blind. Rislov check-called the 80,000 bet Kausinis put out on the flop before both players checked the turn.
The river was also knuckled down, seeing Rislov's pair of queens take the pot at showdown.
Player
Chips
Progress
Edgaras Kausinis
4,700,000
200,000
Even Rislov
3,600,000
0
Polus Grabs Lead With Four-Bet Posted Sunday 3rd March, 2024 at 13:09(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Wissam Polus raised to 160,000 in middle position with before Edgaras Kausinis three-bet to 425,000 with on the button.
Not enough for Polus, who stuck in a reraise to 1,400,000 and was awarded the pot uncontested when Kausinis quickly mucked.
Player
Chips
Progress
Wissam Polus
5,100,000
1,200,000
Edgaras Kausinis
4,900,000
400,000
Naski Gets Value From Aktell Posted Sunday 3rd March, 2024 at 13:04(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Aleksi Naski raised to 160,000 under the gun with , seeing Edgaras Kausinis call in the small blind with . Greger Aktell defended the big blind with and the dealer spread the flop of .
It checked to Naski, who fired 285,000, which folded out Kasinis. Aktell made the call with his inferior pair of kings, after which the was turned. Aktell checked once more and Naski made a bet of 550,000.
Aktell quickly called once more and the river completed the board. Naski decided to check behind after Aktell did so first. Both players tabled their cards and Naski was awarded the pot with his better kicker.
Player
Chips
Progress
Edgaras Kausinis
5,300,000
500,000
Aleksi Naski
4,100,000
1,200,000
Greger Aktell
1,900,000
1,100,000
Gros Finds Royalty Posted Sunday 3rd March, 2024 at 12:53(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Benjamin Gros raised to 160,000 under the gun with and Aleksi Naski called his in the hijack. Even Rislov found on the button and three-bet to 450,000.
The action folded back to Gros, who four-bet his kings to 1,900,000 chips, leaving only 185,000 behind. Naski quickly folded and Rislov eventually followed suit, seeing Gros win the pot uncontested.
Player
Chips
Progress
Even Rislov
3,600,000
500,000
Benjamin Gros
2,900,000
1,160,000
Aleksi Naski
2,900,000
300,000
Rislov Picks Off Aktell's Move Posted Sunday 3rd March, 2024 at 12:45(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Gregor Aktell raised to 160,000 in the cutoff with and Even Rislov defended in the big blind. The flop paired Rislov and he check-called Aktell's bet of 150,000.
The fell on the turn, which prompted Rislov to lead out for 250,000. Aktell quickly raised to 700,000 and Rislov put in chips for a call.
The river completed the board, on which both players quickly checked. Rislov's pair of jacks won at showdown as he won a big pot off Aktell.
Player
Chips
Progress
Even Rislov
4,100,000
1,000,000
Greger Aktell
3,000,000
700,000
Aktell Flops Nuts Posted Sunday 3rd March, 2024 at 12:36(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Even Rislov raised to 160,000 from early position with and Greger Aktell came along from the small blind with . Rislov fired 125,000 on the flop and Aktell just check-called with his straight.
The turn went check-check before Aktell fired 425,000 on the river. Rislov gave it some thought but eventually let go of his fours, shipping the pot to Aktell.
Player
Chips
Progress
Greger Aktell
3,700,000
100,000
Even Rislov
3,100,000
195,000
Polus Three-Bets Flop Posted Sunday 3rd March, 2024 at 12:25(UTC+0) by Frank Visser
Level 28: 40,000/80,000 (80,000) Entries: 8/914
Edgaras Kausinis opened it up to 160,000 with in early position and Wissam Polus called with in the small blind. The flop fell and Polus led out for 100,000.
Kausinis responded with a raise to 320,000, not believing Polus' lead. Polus, however, was also a non-believer as he put in a three-bet to 800,000, receiving a quick fold from his opponent.
Player
Chips
Progress
Edgaras Kausinis
5,800,000
200,000
Wissam Polus
3,900,000
400,000
12:17 (UTC+0)
Start of Level 28 Blinds: 40,000/80,000 Ante: 80,000
Tamulevicius Catches Polus Posted Sunday 3rd March, 2024 at 12:17(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 8/914
Wissam Polus made it 120,000 to go with in early position and Aleksi Naski called in the small blind with . Mantas Tamulevicius defended his in the big blind and a flop of was fanned.
The action checked to Polus, who fired a bet of 105,000. Naski called, and so did Tamulevicius. The turn was checked by all before the river completed the board.
Once again the action was checked to Polus, who threw in 430,000 chips. Naski got out of the way but Tamulevicius flicked in a call and won the pot with his pair of aces.
Player
Chips
Progress
Mantas Tamulevicius
4,900,000
835,000
Wissam Polus
3,500,000
685,000
Aleksi Naski
3,200,000
200,000
Naski Starts Off Aggressively Posted Sunday 3rd March, 2024 at 12:11(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 8/914
Edgaras Kausinis raised to 120,000 on the button with and Greger Aktell called in the small blind with .
Aleksi Naski then made it 480,000 to go in the big blind with and both his opponents laid their hands down.
Player
Chips
Progress
Edgaras Kausinis
6,000,000
115,000
Greger Aktell
3,600,000
75,000
Aleksi Naski
3,400,000
245,000
Cards Back in the Air Posted Sunday 3rd March, 2024 at 12:08(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 8/914
The eight remaining players have taken their seats as the final table of the Main Event is officially underway.
Final Table Seat Draw and Chip Counts Posted Sunday 3rd March, 2024 at 11:44(UTC+0) by Frank Visser
Seat
Player
Country
Chip Count
Big Blinds
1
Even Rislov
Norway
3,295,000
55
2
Wissam Polus
Sweden
4,185,000
70
3
Paul Newey
United Kingdom
1,075,000
18
4
Benjamin Gros
France
1,740,000
29
5
Edgaras Kausinis
Lithuania
6,115,000
102
6
Greger Aktell
Sweden
3,675,000
61
7
Aleksi Naski
Finland
3,155,000
53
8
Mantas Tamulevicius
Lithuania
4,065,000
68
Player
Chips
Progress
Edgaras Kausinis
6,115,000
415,000
Wissam Polus
4,185,000
15,000
Mantas Tamulevicius
4,065,000
35,000
Greger Aktell
3,675,000
50,000
Even Rislov
3,295,000
300,000
Aleksi Naski
3,155,000
1,075,000
Benjamin Gros
1,740,000
560,000
Paul Newey
1,075,000
125,000
Pre-Final Table Break Posted Sunday 3rd March, 2024 at 11:35(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 8/914
The eight remaining players have been sent on a 30-minute break as the final table is being prepared.
Mindaugas Jonaitis Eliminated in 9th Place (€13,500) Posted Sunday 3rd March, 2024 at 11:34(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 8/914
Simultaneously with Olop's bust-out, Greger Aktell open-raised under the gun at the side table, after which Mindaugas Jonaitis three-bet all in for 900,000 chips.
Mantas Tamulevicius made the call in the big blind with the covering stack before Aktell got out of the way.
Mindaugas Jonaitis: Mantas Tamulevicius:
It looked like a prime spot for Jonaitis to double up, but the flop paired Tamulevicius' queen. The turn brought some chop outs, but the river spelled the end for Jonaitis's Main Event run, which came to a halt in ninth place.
Player
Chips
Progress
Mantas Tamulevicius
4,100,000
2,205,000
Mindaugas Jonaitis
0
0
Herli Olop Eliminated in 10th Place (€10,500) Posted Sunday 3rd March, 2024 at 11:28(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 9/914
Edgaras Kausinis raised to 120,000 in the cutoff and Herli Olop shipped his 1,400,000 chips in the middle from the button. The action folded back to Kausinis, who asked for a count and flicked in a call.
Herli Olop: Edgaras Kausinis:
The board gave both players a full house, but Kausinis' nines remained superior to burst the final table bubble.
Player
Chips
Progress
Edgaras Kausinis
5,700,000
1,600,000
Herli Olop
0
0
Gros Turns Nuts Posted Sunday 3rd March, 2024 at 11:24(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 10/914
Edgaras Kausinis raised to 120,000 with on the button and Benjamin Gros defended in the big blind. Both players then checked through the flop before the arrived on the turn.
Gros led out for 140,000 with his flush and Kausinis called his top pair. The river completed the board and saw Gros fire another 140,000 in the middle.
Kausinis instantly called, but his cards were added to the muck once Gros tabled his spades.
Player
Chips
Progress
Edgaras Kausinis
4,100,000
900,000
Benjamin Gros
2,300,000
600,000
Olop Punishes Polus Posted Sunday 3rd March, 2024 at 11:18(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 10/914
Herli Olop raised to 120,000 under the gun with and Wissam Polus came along with in the small blind.
Olop continued for 80,000 on the flop and Polus quickly check-folded to mark the end of the hand.
Player
Chips
Progress
Wissam Polus
4,200,000
300,000
Herli Olop
1,400,000
200,000
Newey Stays Afloat Posted Sunday 3rd March, 2024 at 11:12(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 10/914
Benjamin Gros limped in from the small blind with and Paul Newey checked his in the big blind. Gros bet out 60,000 on the flop, but Newey raised to 210,000 with his top pair.
Gros quickly folded his cards and the small yet important pot was shipped to Newey.
Player
Chips
Progress
Benjamin Gros
1,700,000
200,000
Paul Newey
1,200,000
100,000
Polus Hits the Turn Posted Sunday 3rd March, 2024 at 11:06(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 10/914
Wissam Polus raised his button to 120,000 with and Herli Olop defended the big blind with . Olop then check-called Polus' 80,000-chip bet on the flop before the was turned.
Olop checked once more and Polus tossed in 340,000 chips with his straight. Olop took his time but eventually found the correct fold with his two pair, sending another pot to Polus.
Player
Chips
Progress
Wissam Polus
4,500,000
400,000
Herli Olop
1,200,000
200,000
Kausinis Extends Lead Posted Sunday 3rd March, 2024 at 10:56(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 10/914
Edgaras Kausinis raised to 120,000 from the cutoff with and Herli Olop called with on the button. Kausinis continued for 160,000 on the flop, which was enough to rake in the pot as Olop mucked his cards.
The next hand, Kausinis made it 120,000 to go under the gun with and took down the pot as all other players folded.
Player
Chips
Progress
Edgaras Kausinis
5,000,000
200,000
Herli Olop
1,400,000
300,000
Frederik Brink Eliminated in 11th Place (€10,500) Posted Sunday 3rd March, 2024 at 10:49(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 10/914
Frederik Brink made a min-raise of 120,000 in the cutoff before Wissam Polus three-bet to 415,000 in the small blind.
Brink shoved all in for 1,100,000 chips and a snap-call followed from Polus.
Frederik Brink: Wissam Polus:
Brink could not hit a ten on the board, resulting in the first elimination of the day.
Player
Chips
Progress
Wissam Polus
4,100,000
1,300,000
Frederik Brink
0
0
Polus Goes on Adventure Posted Sunday 3rd March, 2024 at 10:46(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 11/914
Edgaras Kausinis raised to 120,000 with under the gun and Herli Olop three-bet to 350,000 in the hijack with . Wissam Polus then cold-called in the big blind with before Kausinis got out of the way.
Polus decided to lead out for 410,000 on the flop, causing Olop to fold his jack-high. Polus' unconventional line awarded him an important pot as he chipped up.
Player
Chips
Progress
Edgaras Kausinis
4,800,000
100,000
Wissam Polus
2,800,000
460,000
Herli Olop
1,700,000
420,000
Newey With Kicker Problems Posted Sunday 3rd March, 2024 at 10:41(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 11/914
Edgaras Kausinis looked down at and raised to 120,000 from the hijack. The action folded to Paul Newey in the big blind, who defended .
The flop was checked through but Kausinis made a large bet of 250,000 on the turn. Newey check-called and the river completed the board.
Two more checks followed, and Kausinis' better kicker granted him the pot at showdown.
Player
Chips
Progress
Edgaras Kausinis
4,900,000
400,000
Paul Newey
1,300,000
265,000
Gros Came to Play Posted Sunday 3rd March, 2024 at 10:35(UTC+0) by Frank Visser
Level 27: 30,000/60,000 (60,000) Entries: 11/914
Edgaras Kausinis raised his button to 120,000 with and Benjamin Gros weighed his options in the big blind with .
Eventually, he made it 390,000 to go, causing a quick fold from the chipleader.
Player
Chips
Progress
Edgaras Kausinis
4,500,000
100,000
Benjamin Gros
1,500,000
135,000
Cards in the Air for the Final Day Posted Sunday 3rd March, 2024 at 10:04(UTC+0) by Jason Glatzer
Cards are in the air for the final day. This will be our last post of the day in real time as we will will report on a 30-minute delay to not give away any spoilers to those also watching the event unfold via the exclusive OlyBet livestream with hole cards exposed at OlyBet.tv.
10:03 (UTC+0)
Day 4 of Kings of Tallinn 2024 Started Level: 27 Blinds: 30,000/60,000 Ante: 60,000
Aleksi Naski Looking for Back-To-Back Kings of Tallinn Main Event Final Tables as 11 Return for Final Day Posted Sunday 3rd March, 2024 at 10:01(UTC+0) by Frank Visser
On Sunday, March 5, 2023, Aleksi Naski took his seat on the final day of the Kings of Tallinn €1,100 Main Event. Today, 52 weeks later, he gets a second shot at glory as once again he found his way to Day 4. Last year, Naski finished sixth, but this time around he is aiming for the first-place prize of €151,860, which is the largest piece of the €859,160 prize pool, and of course the magnificent Main Event trophy.
Already outlasting 903 players, Naski comes into the final day second in chips out of the 11 hopefuls returning on the final day, who all have secured €10,500 for their efforts so far. With a stack of 4,230,000 chips, he will have 71 big blinds available as he tries to maneuver himself to victory. The only player who managed to acquire more than that is Vilnius Ace Breaker High Roller champion Edgaras Kausinis, who will sit down with 4,600,000 chips at the start of play. Meanwhile, Swedish poker veteran Greger Aktell is the third and only other player with more than 50 big blinds with his stack of 3,725,000.
Naski knows what it takes to win, having six live titles to his name. However, he is not the only player still in the field with that experience as EPT Madrid 2012 champion Frederik Brink is also in contention, although coming in with the shortest stack of 1,240,000 chips. Brink even has a million-dollar score at the Aussie Millions in 2010, and is miraculously enough not the only one left in the field who has achieved such a feat. British high roller Paul Newey graced Tallinn with a visit and will bring 1,565,000 chips into the Main Event finale. Newey not only has a seven-figure score, it also came in a seven-figure buy-in, as a reference of how high he truly rolls. The money may mean not as much to him as to some others, but the glory of hoisting the trophy will be no less.
Meanwhile, most of the spectators in Olympic Park Casino will be rooting for the last Estonian still in the field, Herli Olop, an ex-poker manager and beloved face of the Estonian community. With 2,120,000 chips to his name, Olop is right in the middle of the pack. Also among the 11 returning are Kings of Tallinn 2023 €550 Championship winner Benjamin Gros (1,365,000) and the Lithuanian duo of Mantas Tamulevicius (1,895,000) and Mindaugas Jonaitis (1,325,000).
Start of Day 4 Chip Counts
Rank
Player
Country
Chip Count
Big Blinds
1
Edgaras Kausinis
Lithuania
4,600,000
77
2
Aleksi Naski
Finland
4,230,000
71
3
Greger Aktell
Sweden
3,725,000
62
4
Even Rislov
Norway
2,995,000
50
5
Wissam Polus
Sweden
2,340,000
39
6
Herli Olop
Estonia
2,120,000
35
7
Mantas Tamulevicius
Lithuania
1,895,000
32
8
Paul Newey
United Kingdom
1,565,000
26
9
Benjamin Gros
France
1,365,000
23
10
Mindaugas Jonaitis
Lithuania
1,325,000
22
11
Frederik Brink
Denmark
1,240,000
21
The players will reconvene at noon local time to play down to a Main Event champion. The blinds will start in Level 27: 30,000/60,000 with a 60,000 big blind ante, and levels will last 60 minutes each. A break is scheduled after every two of them to offer the players some respite from the battle.
The live reporting will stay in sync with the cards-up stream at OlyBet.tv, and will thus operate on a 30-minute security delay. Stay tuned to not miss any action from the thrilling conclusion of the 2024 Kings of Tallinn Main Event.
Day 4 Seat Draw Posted Sunday 3rd March, 2024 at 03:04(UTC+0) by Frank Visser
Table
Seat
Player
Country
Chips
Big Blinds
1
1
Mindaugas Jonaitis
Lithuania
1,325,000
22
1
5
Aleksi Naski
Finland
4,230,000
71
1
6
Mantas Tamulevicius
Lithuania
1,895,000
32
1
7
Even Rislov
Norway
2,995,000
50
1
8
Greger Aktell
Sweden
3,725,000
62
2
1
Edgaras Kausinis
Lithuania
4,600,000
77
2
1
Frederik Brink
Denmark
1,240,000
21
2
2
Paul Newey
United Kingdom
1,565,000
26
2
3
Wissam Polus
Sweden
2,340,000
39
2
6
Herli Olop
Estonia
2,120,000
35
2
7
Benjamin Gros
France
1,365,000
23
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.