0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0075 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/20/74/updates'
ORDER BY `views` DESC
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '20'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '20'
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '74'
AND `published` = 1
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '74'
ORDER BY `busted` ASC, `current_chips` DESC
0.0053 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` = '74'
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` = '3677'
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` = '3676'
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` = '3675'
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` = '3674'
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` = '3673'
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` = '3672'
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` = '3671'
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` = '3670'
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` = '3669'
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` = '3668'
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` = '3667'
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` = '3665'
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` = '3664'
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` = '3663'
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` = '3662'
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` = '3661'
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` = '3660'
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` = '3659'
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` = '3657'
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` = '3656'
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` = '3655'
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` = '3654'
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` = '3653'
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` = '3652'
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` = '3651'
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` = '3650'
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` = '3649'
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` = '3648'
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` = '3647'
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` = '3646'
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` = '3645'
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` = '3644'
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` = '3643'
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` = '3642'
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` = '3640'
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` = '3639'
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` = '3638'
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` = '3636'
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` = '3635'
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` = '3633'
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` = '3631'
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` = '3628'
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` = '3627'
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` = '3625'
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` = '3624'
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` = '3623'
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` = '3621'
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` = '3619'
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` = '3617'
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` = '3616'
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` = '3615'
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` = '3614'
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` = '3613'
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` = '3611'
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` = '3610'
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` = '3608'
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` = '3607'
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` = '3606'
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` = '3603'
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` = '3601'
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` = '3600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3598'
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` = '3596'
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` = '3594'
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` = '3592'
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` = '3590'
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` = '3589'
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` = '3588'
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` = '3587'
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` = '3586'
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` = '3585'
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` = '3580'
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` = '3577'
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` = '3494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3493'
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` = '74'
ORDER BY `busted` ASC, `current_chips` DESC
0.0047 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` = '74'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '3677'
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` = '3676'
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` = '3675'
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` = '3674'
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` = '3673'
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` = '3672'
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` = '3671'
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` = '3670'
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` = '3669'
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` = '3668'
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` = '3667'
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` = '3665'
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` = '3664'
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` = '3663'
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` = '3662'
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` = '3661'
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` = '3660'
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` = '3659'
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` = '3657'
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` = '3656'
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` = '3655'
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` = '3654'
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` = '3653'
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` = '3652'
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` = '3651'
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` = '3650'
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` = '3649'
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` = '3648'
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` = '3647'
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` = '3646'
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` = '3645'
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` = '3644'
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` = '3643'
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` = '3642'
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` = '3640'
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` = '3639'
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` = '3638'
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` = '3636'
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` = '3635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3633'
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` = '3631'
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` = '3628'
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` = '3627'
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` = '3625'
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` = '3624'
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` = '3623'
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` = '3621'
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` = '3619'
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` = '3617'
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` = '3616'
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` = '3615'
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` = '3614'
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` = '3613'
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` = '3611'
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` = '3610'
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` = '3608'
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` = '3607'
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` = '3606'
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` = '3603'
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` = '3601'
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` = '3600'
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` = '3598'
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` = '3596'
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` = '3594'
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` = '3592'
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` = '3590'
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` = '3589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3588'
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` = '3587'
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` = '3586'
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` = '3585'
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` = '3580'
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` = '3577'
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` = '3494'
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` = '3493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '74'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
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 Summer Showdown 2023
2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian)
Live Reporting - Day 1
Mehed sõlmivad diili Posted Wednesday 26th July, 2023 at 02:42(UTC+0) by Mariliis Joras
Järel on kaks soomlast, kes soovivad omavahel rahakokkulepet sõlmida.
Algne plaan näeb ette, et Miko Miettinen võtab 8000 € ja Jari Kärkkäinenile jääb 7000 €, kuid mängu jätkatakse 200 € peale. Sellele plaanile tõmmatakse kriips peale, sest nii väikese vahe pärast pole mõtet diilerit kinni hoida.
Floor pakub välja lahenduse, mis meestele sobib.
Mikole läheb 7500 €, Jari võtab 6500 € ja mäng jätkub 1200 € peale. Nii on õiglane ja asjal ka mõte sees.
Selle infoga tänaseks lõpetamegi. Lõplikud auhinnasummad saavad uuendatud homme.
Suur tänu lugejatele, kes leidsid aega blogist läbi tulla. Ootame kõiki tagasi juba homme, mil stardib põhiturniiri esimene mängupäev.
3. koht Tarjei Forus 4350 € Posted Wednesday 26th July, 2023 at 02:35(UTC+0) by Mariliis Joras
Kulub mitu katset, aga lõpuks saadakse Tarjei Forusest jagu.
Mees peaks oma tulemusega igati rahule olema, arvestades fakti, et ta alles mõni minut tagasi avastas, et on top 3 sekka jõudnud.
4. koht Pierre Stefan Sven-Erik Bryhagen 3470 € Posted Wednesday 26th July, 2023 at 02:13(UTC+0) by Mariliis Joras
Aga ei, pole surematu ka Sven-Erik Bryhagen. Temast saab lõpuks jagu Tarjei Forus.
Kuidas kogu aeg välja imeda? Posted Wednesday 26th July, 2023 at 02:12(UTC+0) by Mariliis Joras
Tuleb küsida Sven-Erik Bryhageni käest, sest temal tuleb see välja lausa imeliselt.
Stiilinäide:
Sven-Erik sunnitud all-inis -ga.
Vastas
Boardile
5. koht Casimir Lucas M. Seire 2504 € Posted Wednesday 26th July, 2023 at 02:05(UTC+0) by Mariliis Joras
Ka Casimir Lucas M. Seire langeb ässade saagiks. Seekord on need Tarjei Foruse käes.
6. koht Lawend Mardini Himmo 1960 € Posted Wednesday 26th July, 2023 at 02:04(UTC+0) by Mariliis Joras
Lawend Mardini Himmo liigub all-ini ja saab calli.
Jari Käskkäinen tõmbab varrukast järjekordse ässade pocketi ja teeb rootslase pihuks ja põrmuks.
7. koht Patrick Pfeiffer 1490 € Posted Wednesday 26th July, 2023 at 02:00(UTC+0) by Mariliis Joras
Patrick Pfeiffer läheb võimsa pauguga.
All-ini callib BB-l istuv Miko Miettinen, kellel .
Mikole jookseb maha straight flush, nii et Patricku kaardid ei ole siin mitte vähimalgi määral olulised.
8. koht Jonas Lapinskas 1145 € Posted Wednesday 26th July, 2023 at 01:56(UTC+0) by Mariliis Joras
Paigast kangutatakse Jonas Lapinskas, kelle võtab ette Miko Miettinen.
on parem kui ja seda ei muuda ka lauakaardid.
9. koht Aleksi Matti Juhana Halme 885 € Posted Wednesday 26th July, 2023 at 01:48(UTC+0) by Mariliis Joras
Selleks, et Aleksi Halme 9. kohale jääks, tuli jaotuses osaleda neljal mängijal.
Kõige pisema stäkiga oli muide hoopis Sven-Erik Bryhagen, kes on rongi all käinud ja sealt välja tulnud täna kordi ja kordi. Ja teeb seda nüüdki.
saab ässale pihta ja stäkk neljakordistub.
Aleksi midagi ei taba.
Ära ootab Posted Wednesday 26th July, 2023 at 01:44(UTC+0) by Mariliis Joras
Jari Kärkkäinen paneb oma 395 000 sisse, kui Tarjei Forus ees 125 000 tõstab. BB loobub.
Saamegi sõitma.
Tarjeil , kuid Järi on ära oodanud ässade pocketi. See teenib duubli.
Vabandust, ma olen purjus Posted Wednesday 26th July, 2023 at 01:38(UTC+0) by Mariliis Joras
Niimoodi vabandab chipliider.
Ja ta tõesti on.
Kuigi norrakeelsest jutust aru ei saa, räägivad hääletoon ja intonatsioon enda eest.
Teistel on nuppe oluliselt vähem, mistõttu all-inid mõeldakse eriti pingsalt läbi ja ega neid tegelikult ei näe ka.
Keskmine stäkk on kukkunud alla 10 BB.
Üks kutsub padelit mängima Posted Wednesday 26th July, 2023 at 01:21(UTC+0) by Mariliis Joras
Mitte mind, vaid teid, head lugejad.
Homme Viru Keskuses. Pokkerile on see hea vaheldus, et mõistust tuulutada.
Kolivad ühte lauda Posted Wednesday 26th July, 2023 at 01:18(UTC+0) by Mariliis Joras
Väike paus, et kõik jõuaks ümber kolida. Finaallaud on koos.
10. koht Aleksi Mikael Naski 690 € Posted Wednesday 26th July, 2023 at 01:17(UTC+0) by Mariliis Joras
Miko Miettinen on oma mängu leidnud.
Tema saab flopist kaks paari ja Aleksi Naski, kellel väiksem stäkk, peab lauast tõusma.
Viimane, kes veel 690 €-ga leppima peab, nüüd hakkavad rahad tõusma.,
Välja võlub Posted Wednesday 26th July, 2023 at 01:12(UTC+0) by Mariliis Joras
Üle pika aja on korraga kolm inimest all-inis.
Väikseima stäkiga on Niclas Mjelstad, kes näitas terve turniiri tugevat mängu. Võimalik, et teda toetas ka kaardijooks, sest ühel hetkel hakkas kõik justkui allamäge vedama ja stäkk kuivas kokku. Kuid seni oli ta pikalt turniiri liider. Niclase kaardid on ja chippe väga vähe.
Vastas Miko Miettinen -ga ning kolmas mees -ga.
"Miks sa pead alati domineerima," küsib Miko retooriliselt ja hakkab endale siis kuningat välja võluma. Loits töötab.
Niclas out, teiselt mehelt duubel.
Teeme siis niisama kokkuvõtteid Posted Wednesday 26th July, 2023 at 01:07(UTC+0) by Mariliis Joras
Eestlastele enam kaasa elada ei saa. See erineb kardinaalselt eelmisest Celebrity turniirist, mille võitis just Eesti mängija, Mark Metsla.
Seekordne võitja võib olla potentsiaalselt neljast rahvusest. Meil on järel kaks norrakat, viis soomlast, kaks rootslast ja üks taanlane.
Kahe mängija rahvus on märkimata, kuid nime järgi võib üks olla soomlane ja teine võib-olla et isegi lätlane.
Nii inetut lõppu ei ole Martin ära teeninud Posted Wednesday 26th July, 2023 at 01:03(UTC+0) by Mariliis Joras
Martin Taska ootab kannatlikult ja võiks ju arvata, et see saab väärikalt tasutud... Ent juhtub täiesti vastupidine.
Martini all-ini callib ära vastane -ga. Martinil endal .
Flop ja vastasel rida.
Selliselt jääme ilma oma viimasest eestlasest ja see on väga kurb.
Player
Chips
Progress
Martin Taska
0
0
Keskmine stäkk vaid 10BB-d Posted Wednesday 26th July, 2023 at 00:59(UTC+0) by Mariliis Joras
Lars Nydegger kukub välja. Kui suure osa stäkist kaotab vs , mil vastasele mast, siis viimased kaardid lähevad suvalise kribuga.
Nüüd on keskmine stäkk napilt üle 400 000, kuid BB juba 40 000.
Üles ja alla Posted Wednesday 26th July, 2023 at 00:55(UTC+0) by Mariliis Joras
Täna läheb veel pikalt, sest kipub olema nii, et väiksed duubeldavad ja mäng ei lõpegi.
Väga enesekindlalt callis üks mees teise all-ini ära kahtede pocketiga ja ütles veel juurde: "Deuces never lose."
Vastas olid soldatid.
Floppi kohe kaks ja tundus, et nii ongi. Aga river soldat ja paneme edasi.
Vaid üks eestlane järel Posted Wednesday 26th July, 2023 at 00:47(UTC+0) by Mariliis Joras
Ian-Erik Valge callib ees tehtud tõste 60 000, mis on antud hetkel miinimumtõste.
Nüüd liigub üks mängija all-ini, seejärel teine talle järele. Esialgne tõstja loobub, aga Ian-Erik tunneb, et on committed. Või siis meeldib see kaart talle väga. Oma -ga on nüüd temagi all-inis.
Vastas emandad ja kolmed.
Laud imesid ei tee ja emandate omanik vabaneb korraga kahest vastasest.
Player
Chips
Progress
Ian-Erik Valge
0
0
Tapio out Posted Wednesday 26th July, 2023 at 00:32(UTC+0) by Mariliis Joras
Tapio Aaltonen loodab duubeldada kümnete taskuga. Vastasel , mis saab kokku kõrgema paari.
Seekord siis sedapsi.
On käes järjekordne money jump. Järgmine väljakukkuja lahkub 450 €-ga.
Kaks totakat duublit Posted Wednesday 26th July, 2023 at 00:26(UTC+0) by Mariliis Joras
Martin Taska maksab kaks korda samale mehele välja duubli seisust, kus tal endal on palju parem kaart kui vastasel. Lihtsalt õnne on pinginaabril rohkem.
Martini stäkk on piisavalt kena, nii et katastroofi ei kaasne, aga rohkem taolisi lööke küll vastu võtta ei saa.
Aitab heategevusest, on aeg tagasi võtta.
Mast ei tule kokku Posted Wednesday 26th July, 2023 at 00:20(UTC+0) by Mariliis Joras
Vladislav Topilskiy -l on lootust risti masti tabada.
Vastane -ga on pihta saanud kümnele.
Paraku viimast vajalikku ristit boardil ei avata.
Vladislavi saagiks jääb 390 € auhinnaraha.
Player
Chips
Progress
Vladislav Topilskiy
0
0
Nii on hea pausilt tulla Posted Wednesday 26th July, 2023 at 00:13(UTC+0) by Mariliis Joras
Kui kohe käest kunnide pocketi leiad ja ka actioniks läheb, ei saa ju väga kurta.
Ian-Erik Valge all-ini callib maha kahtede pocketiga mängiv vastane.
Laud seisu ei muuda.
Asja ainus miinus on see, et Ian-Eriku stäkk ei ole just teab mis suur.
18 parimat pausil Posted Tuesday 25th July, 2023 at 23:55(UTC+0) by Mariliis Joras
15 minutit lubatakse mängijatel puhata.
Nüüd mahutakse ära kahte lauda.
Täname Tapiot Posted Tuesday 25th July, 2023 at 23:54(UTC+0) by Mariliis Joras
Tapio Aaltonen ei ole küll verelt eestlane, aga kodustatud soomlane on ta küll. Seetõttu elame kaasa ka tema edule.
Äsja võttis ta ühe vastase välja ja seegi teeb rõõmsaks.
sai pihta kolmikule. Vastase jõuetu.
Häid uudiseid ka vahele Posted Tuesday 25th July, 2023 at 23:51(UTC+0) by Mariliis Joras
Martin Taska toob meile häid uudiseid.
Emandate pocket peab vastase -le vastu.
Selle tulemusena üks mängija jälle vähem ja Martini stäkk suurem.
Player
Chips
Progress
Martin Taska
244,000
75,000
Keegi ei taha minna Posted Tuesday 25th July, 2023 at 23:45(UTC+0) by Mariliis Joras
Ja see on ka arusaadav, sest rahad on tõusmas alles 390 € peale.
Just selle summaga peab aga üks Soome mängija leppima, kui shoveb -ga ja saab calli -lt.
Kõrgem kaart seekord mängib.
Kaks eestlast korraga Posted Tuesday 25th July, 2023 at 23:32(UTC+0) by Mariliis Joras
3-way all-inis osaleb kaks eestlast ja üks soomlane.
on Marius Morelil.
Marko Keskel mängib -ga.
Soomlasel märksa kangem pocket - .
Kunnidest saab flopis set ja meie mehed ajavad end toolidelt püsti.
Player
Chips
Progress
Marius Morel
0
0
Marko Keskel
0
0
Geir-Kristjani auks Posted Tuesday 25th July, 2023 at 23:27(UTC+0) by Mariliis Joras
Vladislav Topilskiyl tekib võimalus Geir-Kristjan Suurpere stäki laastanud soomlasele kätte maksta.
Tema ministäkki tahaks callida ka Ian-Erik Valge, kuid Vladislavi tõste kupatab teise jaotusest välja.
Vladislavil -ga eduseis, sest vastas .
Flop on korraks kahtlane, kuid riverisse ja õiglus võidutseb.
Tõnis saab osa money jumpist Posted Tuesday 25th July, 2023 at 23:21(UTC+0) by Mariliis Joras
Tõnis Viik lõpetab 32. kohal ja teenib selle eest 340 €.
Ta on küll esimene, kes saab miinimumist veidi rohkem raha, kuid ma võin kihla vedada, et ta eelistanuks pigem edasi mängida.
Player
Chips
Progress
Tõnis Viik
0
0
Hanno out Posted Tuesday 25th July, 2023 at 23:19(UTC+0) by Mariliis Joras
34. positsioonilt leiame Hanno Liiva.
Juba pikemat aega vireles ta väikse stäki otsas. Kahjuks õnn ei pöördunud. Hanno peab samuti miinimumiga leppima.
Player
Chips
Progress
Hanno Liiva
0
0
Järjekordne traagika Posted Tuesday 25th July, 2023 at 23:17(UTC+0) by Mariliis Joras
Elades kaasa Geir-Kristjan Suurpere draamale jääb nägemata Mairold Millerti viimane käsi. Kahjuks on tema nimigi nüüd min cashi saanute nimekirjas...
Sellegipoolest oli ta kõige kaugemale jõudnud Eesti kuulsus ja selle üle saab ta vaid uhkust tunda.
Player
Chips
Progress
Mairold Millert
0
0
Vaja raudseid närve Posted Tuesday 25th July, 2023 at 23:15(UTC+0) by Mariliis Joras
Geir-Kristjan Suurperel on pocket, mis näib kenasti vastu pidavat, kuniks lahti tehakse river. Seal on kuningas, täpselt sobiv -ga mängivale vastasele.
Duubli välja maksnud Geir-Kristjanile jääb järele 8000 žetooni, mis on väiksem kui BB.
Kohe järgmise käega on ta all-inis ja leiab käest emandate pocketi - jumala hea koht tagasi tulemiseks, kas pole?
Vastas on Ian-Erik Valge -ga (ta on BB).
Ja flop, palun väga, annab Ian-Erikule kaks paari.
Geir-Kristjan peab leppima min cashiga.
Player
Chips
Progress
Geir-Kristjan Suurpere
0
0
Vähemalt pole mull eestlane Posted Tuesday 25th July, 2023 at 23:06(UTC+0) by Mariliis Joras
Mullimäng saab läbi sama kiirelt nagu algas. Selle positsiooniga ei pea vähemasti ükski eestlane leppima.
Algas mullimäng Posted Tuesday 25th July, 2023 at 23:04(UTC+0) by Mariliis Joras
Kahjuks käivitab selle meie mängija.
Maksim Petrov liigub all-ini -ga ja saab calli kolmedelt.
Flop ei too oute mitte juurde, vaid võtab neid hoopis vähemaks.
Päästvat kuningat ei tulegi.
Player
Chips
Progress
Maksim Petrov
0
0
Standard... Posted Tuesday 25th July, 2023 at 22:54(UTC+0) by Mariliis Joras
Herli Olopi lõpp on küll traagiline.
Laua ja ilmselt terve turniiri suurim stäkk pigistab Herli pihtide vahele ja kuna Herlil käes , siis ei ole mingit foldimist.
Vastas .
Lauda
"Standard minu jooks," kommenteerib Herli ise. Nii vähe jäi puudu!
Player
Chips
Progress
Herli Olop
0
0
Mull läheneb mühinal Posted Tuesday 25th July, 2023 at 22:48(UTC+0) by Mariliis Joras
Veel kuus mängijat jäävad täna tühjade kätega, kõik ülejäänud saavad kompensatsiooni. Kas suurt või väikest, on juba nende endi kätes.
Naxerile vajalik duubel Posted Tuesday 25th July, 2023 at 22:47(UTC+0) by Mariliis Joras
Kaks pocketit lähevad tantsule.
Marko Keskeli on ees, vastas kolmed.
Laud täiesti ebaoluline ja suurem pocket peab.
Player
Chips
Progress
Marko Keskel
107,000
46,000
Kellele kaasa elame? Posted Tuesday 25th July, 2023 at 22:41(UTC+0) by Mariliis Joras
Õnneks mõned tuttavad näod on, kelle edule kaasa elada.
Player
Chips
Progress
Marius Morel
175,000
160,000
Martin Taska
169,000
154,000
Mairold Millert
114,000
60,000
Vladislav Topilskiy
87,000
72,000
Tõnis Viik
74,000
59,000
Maksim Petrov
73,000
58,000
Geir-Kristjan Suurpere
69,000
54,000
Herli Olop
67,000
52,000
Marko Keskel
61,000
46,000
Hanno Liiva
47,000
32,000
Ian-Erik Valge
46,000
31,000
Madis Ormisson
0
0
Kaidar Viikman
0
0
Ralf Rogov
0
0
Veel eestlasi läinud Posted Tuesday 25th July, 2023 at 22:24(UTC+0) by Mariliis Joras
Artur Külanurk on nüüdseks out.
Hans Aare stäkk oli paarkümmend minutit tagasi just selline, et ellu jäämiseks tuli tegusid teha. -ga ta korra all-inis ka käis, kuid actionit ei saanud. Saagiks vaid blindid.
Nüüdseks on paraku ka Hansu turniir läbi.
Veel halbu uudiseid Eestisse Posted Tuesday 25th July, 2023 at 21:51(UTC+0) by Mariliis Joras
Pärast pausi ei ole meiega enam jätkamas ei Kristi Kirsi, Gert Laanemetsa, Ander Heidmetsa ega Erio Ermanni.
Liigume pausile ilma Priiduta Posted Tuesday 25th July, 2023 at 21:48(UTC+0) by Mariliis Joras
Priit Pajusaar läheb all-ini kahe mehe vastu.
Kaardiks , mis pole küll teab mis monster, aga ka mitte päris lootusetu.
Ühel vastasel emandate pocket ja Priidul on šanssi isegi pärast floppi, kus on emand, nimelt võib ta veel tabada masti. Kuid riverisse potit ei tule.
Eestlastest parim kuulsus on seega Mairold Millert!
Mängijad nüüd 20 minutiks pausil.
Väljamaksed teada Posted Tuesday 25th July, 2023 at 21:41(UTC+0) by Mariliis Joras
Õige pea toome teieni ka väljamaksete suurused.
Nii palju oskame kohe öelda, et rahaga lahkub 39 parimat ja esikohale on ette nähtud ei vähem ega rohkem kui 9100 eurot.
Herli teab, kuidas lohutada Posted Tuesday 25th July, 2023 at 21:38(UTC+0) by Mariliis Joras
Johanna Randmannil veab, et ta on ühes lauas just Herli Olopiga. Kuigi Johanna kukub välja, saab ta Herlilt kaasa lohutava kommentaari.
Floppi vaadati miinimumtõste 6000 eest.
Boardile ja ees üks check.
Johanna betib 5000, mille peale vastane shoveb. Johanna uurib diilerilt, mis võimalused tal on ja läheb siis ise ka all-ini.
Johannal , vastasel .
Kohe turnis on kardetud poti ja sellest mülkast Johanna enam välja ei rabele.
"Sa tegid kõik õigesti, sa olid ees," lohutab Herli.
"Nii tore mäng!" õhkab aga Johanna, nii et võib-olla oleme ühe pokkerisõbra juurde saanud.
Kaasas toeks olnud Jaanus Saks, kes ise juba mõnda aega tagasi välja kukkus, lahkutakse saalist hea emotsiooniga.
Ralf saab noosi Posted Tuesday 25th July, 2023 at 21:27(UTC+0) by Mariliis Joras
Boardil ja algab närvide mäng.
Ralf Rogov ja Siim Siimson koos all-inis.
Siimul . Üheksa õmbleks aukliku rea tervikuks.
Ralfil .
Üheksat lauas ei avata, kuid kuningas tuleb. Ralfi eduseis kindel ja stäkk ka suurem.
Suurelt ei tooda, aga raisku ka ei lähe Posted Tuesday 25th July, 2023 at 21:19(UTC+0) by Mariliis Joras
Mairold Millert särab jälle ässade pocketiga.
Seekord on tal vastas ministäkiga mees, kellel käes .
Flopis on küll kohe neli, aga ka äss. Nii et Mairoldil täiesti higistamisvaba jaotus.
Paul andis nupud ise ära Posted Tuesday 25th July, 2023 at 21:07(UTC+0) by Mariliis Joras
Paul Koppe võttis enne Kristi Kirsilt duubli, aga andis intressidega tagasi.
"Ise andis. Ajas minuga juttu ja arvas, et ma ei näe, mis ta teeb," kõkutab Kristi rõõmsalt tagantjärele.
Marek Selgeveer on samuti sunnitud lõpetama. Tema viimsed riismed lähevad keskele -ga, kuid lauas ainult Broadway kaardid ja vastasel rida koos.
Mairoldi laastamistöö jätkub Posted Tuesday 25th July, 2023 at 20:59(UTC+0) by Mariliis Joras
Ei, Mairold Millerti hiiter pole lõppenud.
Allan Pukk saab esimest korda täna pocketi. Need on kuningad ja see on just sobiv kaart, millega Mairoldi all-in ära callida.
Viied on üsna nirus seisus. Aga seda vaid kuni flopini. Seal see vajalik viis ongi.
Mairold vabandab Allani ees liiga tegemise pärast, lüüakse nukke ja Allan seab end lahkuma.
Seekord on Peeter parem Posted Tuesday 25th July, 2023 at 20:53(UTC+0) by Mariliis Joras
Rivaliteet Erkki Sarapuu ja Peeter Antsovi vahel on läbi. Seekord osutus paremaks Peeter. Õnneks nägi ta Erkki viimast jaotust pealt ja saab sellest meilegi rääkida.
"A9o-ga läks all-ini. Pre. Vastas ässad," kõlas Peetri kokkuvõte.
Boardilt polnud erilist abi oota, seda enam, et seal avati ka paki viimane äss.
Paul külvab segadust Posted Tuesday 25th July, 2023 at 20:49(UTC+0) by Mariliis Joras
Kus võimalus end ilmutab, seal Paul Koppe selle ka ära kasutab.
Ta saadetakse lauda nr 10 ja palutakse istuda kohale nr 2. Aga Pauli pea töötab teisiti. Kui tema näeb, et samas lauas kohal nr 8 on koht vaba Kristi Kirsi kõrval, siis sinna tema ka istuma potsatab.
Floor on õnneks armuline ja teeb süsteemis vajalikud muudatused.
Kristi on seltskonna üle rõõmus, aga sooviks Paulile vähem duubleid anda. Siis oleks asjal rohkem jumet.
Robi võtab suuna koju Posted Tuesday 25th July, 2023 at 20:34(UTC+0) by Mariliis Joras
Robert Rool lõpetab täna 200 parima hulgas.
Kui mõnda aega tagasi tema laua juurest möödusime, ütles üks lauakaaslastest, et Robi on vaikne ja ettevaatlik, liiga palju jaotusi kaasa ei mängi. Aga paistab, et õnnest tuli seekord puudu, sest nüüd näeme meest saalist väljumas.
Vanad sõbrad jälle koos Posted Tuesday 25th July, 2023 at 20:31(UTC+0) by Mariliis Joras
Peeter Antsov ja Erkki Sarapuu ei ole veel välja selgitanud, kumb on laua kõvem mees. Vaeva selleks igatahes nähakse.
Floppi vaadatakse 5000 eest (BB on hetkel 1000) ja selle summa eest on kaasas ka kolmas mees.
Lauda ja kui Peeter checkib, siis Erkkilt 12 000.
Üks fold, Peetri kord. "No millele sa nüüd pihta said?" küsib ta Erkkilt, kes selget vastust ei anna.
"All-in," põrutab nüüd Peeter. Erkkilt insta call.
Peeter avab , Erkkil on .
Lõpplahendus on split, sest boardile juurde ja .
Rekord löödud? Posted Tuesday 25th July, 2023 at 20:25(UTC+0) by Mariliis Joras
Paistab, et oleme löönud Celebrity Eventi rekordi. Veel kunagi pole sisseostude arv ulatunud üle 350, aga paistab, et täna see just nii on.
Lõplikud numbrid on veel kinnitamisel, kuid esialgsete andmete kohaselt tehti 352 sisseostu.
Auhinnafondi suuruseks näidatakse 43 014 eurot ja loomulikult on ka see rekordiline.
Kaardid jälle õhus Posted Tuesday 25th July, 2023 at 20:22(UTC+0) by Mariliis Joras
Paus sai läbi ja mängijad on tagasi laudades.
Mairold Millertil oli vahepeal huvitav lugu rääkida. Tal on päris kobe stäkk, mis ulatub kahekordse keskmise kanti.
Mõnusa lisa sai Mairold kahe keskmisest erilisema jaotusega. Kui ühel korral hittis ta -ga poissi ja võttis maha panga -lt, siis teisel korral hittis tema riveris setti, samal ajal kui vastase oli paari tabanud juba flopis.
"Loodetavasti jätkub sellist õnne ka hilisemaks," avaldas ta lootust.
Player
Chips
Progress
Mairold Millert
54,000
39,000
Korea kaotab parema kaardiga Posted Tuesday 25th July, 2023 at 19:57(UTC+0) by Mariliis Joras
Korea ehk Karl Kivastik mängib oma viimase käe kahe vastase vastu.
Teda on püüdma tuldud nii kui -ga.
Koreal endal
Võiks ju loota, et ehk seekord parem kaart ka peab, kuid kahjuks avatakse lauas kuus ja see kustutab Korea lootused.
"Ma tulen ka kohe järgi," surub Jaanus Saks kaasvõitleja kätt ja viskab õhku kurjaendelise ennustuse.
Viimased kolm kätt ja siis liigume pausile. Järgmisest levelist alates re-entryt enam teha ei saa.
Kristi saab oma revanši Posted Tuesday 25th July, 2023 at 19:51(UTC+0) by Mariliis Joras
Kristi Kirs pidi mõnda aega tagasi Maarja-Liis Ilusa kavalusele alluma, aga nüüd on aeg revanšiks.
Kristi tõstab o-ga.
Maarja on buttonil ja uurib, palju Kristil veel taga.
"Okou," mõtleb Kristi samal ajal. Kuid shove asemel tuleb lihtsalt call.
Flopis kohe kaks soldatit. Sündmusteni jõutakse alles riveris. Kristi teeb väikse beti, Maarja liigub all-ini ja nüüd on callida juba lihtne.
Maarja avab kümnete pocketi ja ulatab lisaks chippidele Kristile ka oma nännikoti. Turniir tema jaoks läbi. Põnevusega ootame teda aga järgmistele üritustele - Maarjas on pokkerimängijale omast kuraasi.
Kui ässad ei toida.. Posted Tuesday 25th July, 2023 at 19:42(UTC+0) by Mariliis Joras
Andrei Mjagkov saab suure saagi. Ta mängib -ga, mis saab flopis mastiostu. Riveris tuleb see kohale.
Teisel mehel meel kurb, sest tal olid ässad... Aga stäkk väiksem ja nüüd tuleb lauast tõusta.
Laura out Posted Tuesday 25th July, 2023 at 19:34(UTC+0) by Mariliis Joras
Laura Pritsi nupud on kahjuks otsa lõppenud. Viimased libisesid Allan Puki ette, kui viimane tabas masti.
Tegelikult ütleb Allan, et mängis Laura vastu veel teisigi värvikaid jaotusi ja kui Laura isegi hittis kenasti, siis Allanil õnnestus kohe pärast seda veelgi paremini hittida. Ju ei olnud Laura õhtu.
Aga loodetavasti oli kogemus tulemist väärt.
Erkkil on missioon Posted Tuesday 25th July, 2023 at 19:27(UTC+0) by Mariliis Joras
Erkki Sarapuu on olnud kuulsuste turniiril kõige kaugemale jõudnud kuulsus ja on täiesti selge, et väiksemaid ambitsioone ei ole tal ka täna.
Stäkk on jõudsalt paisunud ja sama hoogsalt paneb ta edasi. Samal ajal käib muidugi ka suu, sest kui mehel poleks nii head suuvärki nagu tal on, ei teakski me tast võib-olla mitte midagi.
Floppi vaadatakse min-raise'i eest. Tuhat tuleb lauda kolmelt mehelt.
flopis.
Ees checkid ja Erkki betib 2400. Talle tuleb üks call.
Turn ja taas ees check. Erkki soovib nüüd 3000 ja ei jää seegi call tulemata.
River ja Peeter Antsovilt uuesti check. "Ega sa võid ka checkida," juhendab ta Erkkit. Aga nii lihtsalt see ei lähe. Erkki kõmmutab nüüd lauda 18 000 ega ole isegi all-inis. Küll aga peaks kõik sisse panema Peeter, juhul kui ta callida sooviks. Kuid ta ei soovi.
Erkki näitab üht kaarti, milleks on . Tehtagu sellest omad järeldused.
Jaan andis näole Posted Tuesday 25th July, 2023 at 19:18(UTC+0) by Mariliis Joras
Meie pokkerit mängivate kuulsuste hulka pidi täna kuuluma ka Jaan Pehk, aga ei olnud 100% kindel, kas ta ikka siia jõuab.
Jaan jõudis. Aga jõudis ka juba bustida.
Kell 12 üllatussatikas Posted Tuesday 25th July, 2023 at 19:16(UTC+0) by Mariliis Joras
Head uudised kõigile neile, kellel täna südaööl midagi teha pole.
Nimelt algab kl 00.00 120-eurose sisseostuga satelliitturniir, kus on garanteeritud viis 1500-eurost WSOP Circuit in Tallinn turniiripääset.
Esimesed 8 levelit vältavad 15 minutit ja selle aja jooksul on avatud ka late reg. Pärast seda lühenevad tasemed 10-minutilisteks. Algstäkk on 10 000 žetooni.
Maarjal on riukalik külg Posted Tuesday 25th July, 2023 at 19:08(UTC+0) by Mariliis Joras
Kristi Kirs teatab, et sellest, kuidas Maarja blufib, võiks rohkem kirjutada.
Kelle vastu, uurime.
"Kõigi!" kinnitavad Kristi ja Andres Puusepp kui ühest suust. Andrese arvates võiks lausa Kroonika sellesse täpsemini süveneda.
Kristi sai oma koosa kätte, kui boardil oli neli ruutut. Maarja bettis ja Kristi kartis, et tema ruutust on Maarjal kindlasti kõrgem ruutu. Aga võta näpust, ruutusid Maarjal polnud. Nii tõestas ta, et "diamonds are a girl's best friend" isegi siis, kui endal neid pole.
Näeme ka Evelyt, ainult et mitte lauas Posted Tuesday 25th July, 2023 at 18:58(UTC+0) by Mariliis Joras
Modell ja pokkerikaunitar Evely Pihela oli veel talvisel kuulsuste üritusel ise lauas, üks bountydest. Sel festivalil on ta aga haaranud mikrofoni, millega käia teistelt küsimas: "Mis tunne on?"
Hetk tagasi püüdis ta punase mikrofoni taha Jarek Kasari, kes chippidest valla sai.
Jarek on alati positiivne ja võtab ka täna sõltumata tulemusest kaasa ainult head elamused.
Auhinnafond paisub Posted Tuesday 25th July, 2023 at 18:52(UTC+0) by Mariliis Joras
Auhinnafondis on juba peaaegu 30 000 eurot, mida pole üldse vähe. Veel 4 taseme jagu on aega liituda hilise registreerujana või teha re-entry. Seega teame juba praegu, et auhinnafond veel kasvab.
Aga kui palju?
Näiteks talvisel Kings of Tallinna festivalil kogunes samasuguse struktuuri ja ülesehitusega turniiril auhinnafondi napilt üle 40 000 euro. Tookord oli unikaalsete mängijate arv 257, re-entreyd tehti 74.
Täna ja praegu on sisseostude arv 244. Nii et tulemuse kordamiseks on veel minna.
Koridori kuulsusi ei jagunud Posted Tuesday 25th July, 2023 at 18:44(UTC+0) by Mariliis Joras
Marius Morel on oma laua kuulsaim mängija. Ta on nimelt sattunud koridori istuma, kuid kõik kuulsused näikse olevat paigutatud konverentsisaali.
See muidugi Mariust mitte kuidagi ei takista. Stäkki on ta juba kõvasti kasvatanud.
Käimas on meil parasjagu neljas level ja blindid 100/300/300. Praktiliselt 30 mängijat on nuppudest lahti saanud. Kuulsatest on väljas Henrik Raave, kes esmapilgul ennast tagasi sisse ostnud pole. Sama ei saa öelda aga näiteks Toomas Marrandi ja Mihkel Kesa kohta - mõlemad on pärast esimest katset mängus tagasi.
Kuidas kõigil läheb? Posted Tuesday 25th July, 2023 at 18:33(UTC+0) by Mariliis Joras
Laura Prits võitis suure käe ilma, et ta väga täpselt läbi oleks hammustanud, mis toimus. Õnneks abistab teda brošüür, kus on laias laastus kirjas, millega üldse mängida ja milline kaardikombinatsioon võidu annab.
Hoopis kogenum on Maarja, kes alles kogub hoogu. Ilusa stardikäega võtab ta nõuks callida Masse Mirzoudi pre-flopi tõste 500.
Flopis lisavad mõlemad veel 500 ja sama juhtub turnis. Riveris hoog raugeb.
Maarja on pihta saanud üheksale, kuid midagi enamat ta laualt välja ei pigista. Seekord jääb Masse peale, sest oma o-ga on ta hittinud ässa.
Andres Puusepp alles jälgib olukorda. Kohe kui kaarti antakse, on teda igatahes mängu oodata, sest näpud juba sügelevad.
Laura põikab kuuli eest Posted Tuesday 25th July, 2023 at 18:14(UTC+0) by Mariliis Joras
Laura Pritsil veab, sest kuigi tal oli kindel plaan jaotuses osaleda, otsustab ta pärast Mairold Millerti suurt tõstet 1700 foldida.
Marita Mägi ei heitu. Kahekesi vaadataksegi floppi.
Kumbki paneb panka veel ca 1500.
Turn on
Mairold nüüd checkib, kuid Marita beti 3500 maksab.
Riverisse
Mairoldi check siin enam lisasaaki ei tooda, sest Marita on ilmselt oma olukorra läbi hammustanud.
Kaardid tehakse lahti ja ongi nii nagu võis arvata - Mairoldil ässade pocket. Marita oma kaarte ei näita.
Esimeses lauas aega ei raisata Posted Tuesday 25th July, 2023 at 18:03(UTC+0) by Mariliis Joras
Lauas nr 1 istuvad koos Erkki Sarapuu ja Jarek Kasar.
Neist esimene on lennuka mänguga, nagu alati. UTG-lt teeb ta tõste ja saab 4 calli. C-bet flopis on piisav, et kõik foldima saada.
Järgmises jaotuses on innukaim pool Ardo Kiirkivi. Floppi hinnaga 600 vaadatakse kolmekesi, aga kui see on äss kõrge ja Ardo c-betib 1200, lähevad kõik maha, sh BB Erkki.
Üks minut, üks tool Posted Tuesday 25th July, 2023 at 17:59(UTC+0) by Mariliis Joras
Mäng pole õieti alanudki, kui juba on meil üks "tool" lahti.
See mees on kuulus küll, aga mitte Kroonika veergudel, vaid pokkerimängijate seas. Mr Kaidar Viikman isiklikult on kellegi üles duubeldanud. Kuna see juhtus teises toas, siis jäi nägemata, kes chipid endale sai.
Fännidel pole kurvastamiseks siiski põhjust, sest Kaidar tegi re-entry.
Ja olemegi startimas Posted Tuesday 25th July, 2023 at 17:54(UTC+0) by Mariliis Joras
Stiilne hilinemine on kuulsustele ju lubatud.
15 minutit akadeemilist möödas, hakkavadki kuulsused kaamerate sähvides uksest sisenema.
Naisstaaridest on esindatud lauljannad Laura Prits, Maarja-Liis Ilus ja Johanna Randmann.
Ülejäänud on mehed. Kohal on raadiohääl Erkki Sarapuu, 5Miinuse Korea, helilooja Priit Pajusaar, multitalent Mairold Millert, saatejuht Robert Rool, raadiohääl Andres Puusepp, räppar Jaanus Saks, muusik Chalice ehk Jarek Kasar ja laulja Henrik Raave.
Muidugi on meil ka terve rida Soome kuulsusi ja isegi üks kaugema kandi mees, kes on muuhulgas seltskonnamängu Pictionary autor.
Kuulsustega tasub igal juhul jaotusi mängida, sest kui õnnestub mõni välja võtta, ootab elimineerijat nännikott. Ja kellele siis nänn ei meeldiks!
Mängijaid aina koguneb Posted Tuesday 25th July, 2023 at 17:23(UTC+0) by Mariliis Joras
Veel mõni tund tagasi oli osalejate arv 30 ringis, kuid see on jõudsalt kasvama hakanud. Hetkeseisuga stardib umbes 100 mängijat.
Tervelt 8 taset on aega vaikselt juurde tiksuda, nii et kes õiges ajaks ei jõua, ei pea muretsema.
Tegemist on tõsise turboturniiriga, kus tasemed kestavad ainult 15 minutit. Algstäkk 15 000 annab küll veidi mänguruumi, aga mitte kauaks. Seega on oodata agressiivset andmist!
Tore on tõdeda, et mängijate nimekirjast leiame ka mitmeid tuttavaid "pokkerikuulsusi", kes pole pidanud paljuks oma teisipäeva õhtu pokkerile ohverdada. Hoiame silma peal nii paljudel eestlastel, kui vähegi võimalik.
Fotol olevad noormehed on puhtalt illustreerivad. Päris fotosid tuleb täna tegema võimas profifotograafide tandem - Elena Kask ja Tambet Kask.
Tere, kuulsad ja kummalised Posted Tuesday 25th July, 2023 at 17:11(UTC+0) by Mariliis Joras
Head pokkerisõbrad!
Lõpuks saab avapaugu ka Summer Showdowni eestikeelne bloginädal. Alustame suurejooneliselt, jälgides kõrvalt, kui hästi või halvasti kuulsused pokkerit mängida oskavad.
Mõned toredad ja kõlavad nimed on juba kirjas, aga kes täpselt lauda istub, sellest lähemalt turniiri algusajal, mil teame, kes kutsututest läbi vihma ja tuule ka päriselt kohale on jõudnud.
Turniiri kanname live-blogis üle otsast lõpuni, nii et haarakem kohv ja küpsised ligi.
Welcome to the Kings of Tallinn Summer Showdown! Posted Thursday 20th July, 2023 at 10:57(UTC+0) by Jason Glatzer
Welcome to the 2023 Kings of Tallinn Summer Showdown at the plush surroundings at Olympic Park Casino and the adjacent Hilton Tallinn Park for an exciting 10 days of poker from July 21-30.
The festival boasts 53 numbered events along with cash games running 24 hours a day in a variety of poker variants and stakes.
Our coverage will begin July 25 with the €150 Celebrity Special with many local celebrities competing with a bounty on their head.
Stay tuned to see who will win the Celebrity Special and other events at the 2023 Kings of Tallinn Summer Showdown.
10:44 (UTC+0)
Day 1 of Kings of Tallinn Summer Showdown 2023 Started Level:Blinds: 0/0 Ante: 0
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.