0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/22'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '22'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '22'
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0044 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '89'
AND `published` = 1
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '89'
ORDER BY `busted` ASC, `current_chips` DESC
0.0043 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` = '89'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4029'
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` = '4028'
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` = '4027'
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` = '4026'
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` = '4025'
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` = '4023'
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` = '4022'
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` = '4021'
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` = '4020'
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` = '4019'
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` = '4018'
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` = '4017'
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` = '4016'
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` = '4015'
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` = '4014'
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` = '4010'
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` = '4008'
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` = '3997'
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` = '3993'
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` = '3990'
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` = '3989'
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` = '3988'
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` = '3987'
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` = '3984'
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` = '3982'
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` = '3979'
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` = '3978'
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` = '3976'
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` = '3974'
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` = '3972'
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` = '3970'
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` = '3969'
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` = '3968'
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` = '3967'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3964'
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` = '3960'
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` = '3958'
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` = '3957'
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` = '3954'
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` = '3950'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3949'
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` = '3942'
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` = '3941'
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` = '3939'
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` = '3938'
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` = '3935'
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` = '3933'
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` = '3931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0273 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3928'
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` = '3927'
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` = '3925'
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` = '3923'
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` = '3922'
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` = '3920'
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` = '3919'
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` = '3915'
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` = '3911'
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` = '3909'
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` = '3908'
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` = '89'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '89'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4029'
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` = '4028'
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` = '4027'
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` = '4026'
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` = '4025'
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` = '4023'
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` = '4022'
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` = '4021'
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` = '4020'
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` = '4019'
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` = '4018'
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` = '4017'
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` = '4016'
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` = '4015'
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` = '4014'
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` = '4010'
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` = '4008'
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` = '3997'
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` = '3993'
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` = '3990'
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` = '3989'
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` = '3988'
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` = '3987'
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` = '3984'
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` = '3982'
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` = '3979'
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` = '3978'
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` = '3976'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3974'
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` = '3972'
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` = '3970'
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` = '3969'
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` = '3968'
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` = '3967'
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` = '3964'
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` = '3960'
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` = '3958'
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` = '3957'
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` = '3954'
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` = '3950'
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` = '3949'
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` = '3942'
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` = '3941'
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` = '3939'
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` = '3938'
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` = '3935'
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` = '3933'
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` = '3931'
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` = '3930'
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` = '3928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3927'
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` = '3925'
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` = '3923'
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` = '3922'
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` = '3920'
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` = '3919'
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` = '3915'
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` = '3911'
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` = '3909'
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` = '3908'
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` = '89'
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 €5,000 High Roller (Estonian)
Live Reporting - Day 1
Finaallaud käima Posted Friday 28th July, 2023 at 20:37(UTC+0) by Mariliis Joras
Jukka Ylitalo üheksad saavad Casimir Seire kuningate käest tappa.
Lauakaardid lihtsalt ei aita.
Nüüd on järel 7 mängijat, kuid selle asemel, et hakata mängima 3 ja 4 mängijaga laudades, tõstetakse kõik 7 ühte lauda kokku.
Suur duubel Posted Friday 28th July, 2023 at 20:34(UTC+0) by Mariliis Joras
Andre Henning saab suure duubli, kui Robert Rohri vastu tõstma läheb. Nupud saadakse sisse veel enne floppi.
Andrel kuningad, Robertil soldatid.
Lauakaardid Andret ei ohusta ja Roberti suur stäkk saab rüüstatud.
Järel 8 mängijat Posted Friday 28th July, 2023 at 20:23(UTC+0) by Mariliis Joras
Välja on kukkunud ka Pasi Sormunen. Jätkab 8 parimat.
6 neist pääseb telelauda, mis ilmselt stardibki just siis, kui finaallaud koos.
Neli pole kohtu seadus Posted Friday 28th July, 2023 at 20:21(UTC+0) by Mariliis Joras
Roope Tormi neli sisseostu täna soovitud tulemust ei toonud.
Viimases jaotuses Casimir Seire vastu.
Ässa lauda ei tule.
Nagu liiv sõrmede vahelt Posted Friday 28th July, 2023 at 20:19(UTC+0) by Mariliis Joras
Casimir Seire stäkk on kokku kuivamas.
16 000 eest läheb ta ühes Andrius Bielskisega floppi vaatama.
lauda.
Casimir check-raiseb Andriuse beti 13 000 suurelt 40 000 peale. Saab calli.
Turn checkitakse läbi.
River toob Casimirilt 32 000.
Ta ei tahaks mitte seda kaotada, kuid et Andrius callib, siis peab minna laskma.
Casimiril -g bluff.
Andriuse on parem.
20:06 (UTC+0)
Start of Level 13 Blinds: 5,000/10,000 Ante: 10,000
Jussi fännid saavad ka nutta Posted Friday 28th July, 2023 at 19:49(UTC+0) by Mariliis Joras
Jussi Mattila on paraku out.
Player
Chips
Progress
Jussi P. K. Mattila
0
0
Hirmus halvad uudised meile Posted Friday 28th July, 2023 at 19:48(UTC+0) by Mariliis Joras
Jukka Ylitalo on käest leidnud monsteri. Tema pre-flopi tõste on 26 000, taga on tal veidi üle 100 000.
Ottomar Ladva stäkk on ka 100 000+ kandis ja leides käest pocketi, näeb ta head võimalust.
on Jukkal.
"Kindel värk," teeb ta oma võidu juba teatavaks.
Diiler veel nii kindel pole, pakkudes ära sõnumise võimalust. Kuid ei, kaardijumal pole kümnete pocketiga mängiva Ottomari poolt.
Meie mees on out.
Player
Chips
Progress
Ottomar Ladva
0
0
19:36 (UTC+0)
Start of Level 12 Blinds: 4,000/8,000 Ante: 8,000
Võitjale üle 50k Posted Friday 28th July, 2023 at 19:36(UTC+0) by Mariliis Joras
Väljamaksed on nüüd teada. Võitja läheb koju üle 50 000 euroga.
Kokku jagub krõbisevat viiele parimale.
Mehel on tõsi taga Posted Friday 28th July, 2023 at 19:34(UTC+0) by Mariliis Joras
Andrius Bielskis on ohtlik mees. Ka Ottomar Ladva saab tema jõudu enda peal tunda.
10 000 eest vaadatakse kahekesi floppi.
ja Andrius checkib.
Ottomarilt bet 9000 ja nüüd Andrius tõstab, nõudes 27 000. Selle Ottomar ka maksab.
Turn ja Andrius checkib.
Ottomar püüab panka 23 000-ga maha võtta, aga kui Andrius all-ini liigub, lülitab Ottomar sisse tagurpidi käigu.
Casper hoos Posted Friday 28th July, 2023 at 19:25(UTC+0) by Mariliis Joras
Ka Juha Helppi turniirieluküünla kustutas Casper Schantz.
vs
Parem kaart mängib.
Player
Chips
Progress
Juha Ilmari Helppi
0
0
Väiksed teevad lükkeid Posted Friday 28th July, 2023 at 19:24(UTC+0) by Mariliis Joras
Janne Järvinen shoveb pärast Casper Schantzi tõstet 25 000. Temalt tuleb ka call.
Jannel
Casperil
Board annab Casperile lausa maja. Väiksema stäkiga Janne out.
Veel üks mängija peab kukkuma ja siis on järel kahe laua jagu mängijaid.
Kiirelt läbi Posted Friday 28th July, 2023 at 19:21(UTC+0) by Mariliis Joras
Juan Duenasel on plaan suunduda põhiturniirilt High rollerile. Talle antakse 10 minutit aega ja õnneks mahub ta ajalimiidi sisse.
Nupud kotis, istub ta maha ja saab mängida kõvad 5 minutit.
Nuppe paneb ta flopis
Käes Juanil
Vastas
Turn ja river enam seisu ei muuda ja mees kommenteerib ka ise: "That was quick."
Paistab, et rohkem põhiturniirilt keegi ei liitunudki. Nüüd jätkame 14 mängijaga.
Väike viivitus Posted Friday 28th July, 2023 at 19:08(UTC+0) by Mariliis Joras
Natuke tuli mängijatel oodata, kuid nüüd on kaardid taas õhus.
Vähemalt üks mängija, kes on veel põhiturniiril sees, soovis tulla mängima ka High rollerit. Sisseostu ta juba tegi, kuid stäkki pole lauale tiksuma veel pandud - oodatakse mulli lõhkmist.
19:01 (UTC+0)
Start of Level 11 Blinds: 3,000/6,000 Ante: 6,000
Ja ongi dinner break Posted Friday 28th July, 2023 at 18:03(UTC+0) by Mariliis Joras
Enne pausi läks, nagu arvata võis, rüseluseks.
Oma nuppudest jäid ilma nii Pasi Sormunen kui Roope Tarmi. Viimane tegi küll kiire re-entry ja on nüüd konkurentsis tagasi.
Kui kell tiksus nulli, kuulutati välja kolm viimast re-entry kätt ja täpselt kolmanda käega sai otsa ka Markkos Ladevi mäng.
Ta lükkab -ga, sest callida võib teda üksnes BB-l istuv Jukka Ylitalo. Jukka seda ka teeb, pannes vastu .
Esialgu saab kahele pihta Markkos, kuid seejärel hitib Jukka kuut.
Hetkel jääb eestlaste au kaitsma Ottomar Ladva. Kuid võimalik, et pausi jooksul lisandub meie mängijaid veel.
Late reg on avatud kella 21-ni.
Player
Chips
Progress
Ottomar Ladva
248,500
132,500
Markkos Ladev
0
0
Toimub eestlaste rappimine Posted Friday 28th July, 2023 at 17:42(UTC+0) by Mariliis Joras
Oleme sihikul.
All-ini satub Ahto Kingsepp ja enne floppi, nii nagu Priit Parmasto paar minutit varem.
tabab riveris küll soldatit, kuid Andrius Bielskis mängib kuningate pocketiga ja see hoiab.
Player
Chips
Progress
Ahto Kingsepp
0
0
Kaotame Priidu Posted Friday 28th July, 2023 at 17:39(UTC+0) by Mariliis Joras
Priit Parmasto on pre-flop all-inis üheksate pocketiga. Vastas Max Avela -ga.
Lauda
Kahjuks on vastasel nuppe rohkem.
Player
Chips
Progress
Priit Parmasto
0
0
Pasi saab oma koosa Posted Friday 28th July, 2023 at 17:35(UTC+0) by Mariliis Joras
Pasi Sormunen loputas küll Markkos Ladevit, aga sai kohe ka ise hoobi.
boardil.
Andrius Bielskis shoveb 80 000, ka pangas on juba väga palju žetoone.
Pasi otsustab callida.
Andriuse on floppi tabanud ideaalselt.
Pasi tähtsusetu.
Äsja võidetud suur koorem tuleb edasi anda. Loodame, et see jõuab rigniga ka mõne meie meheni. Lisaks Markkosele istub samas lauas Ahto Kingsepp.
17:32 (UTC+0)
Start of Level 10 Blinds: 2,000/5,000 Ante: 5,000
Vot see on valus Posted Friday 28th July, 2023 at 17:30(UTC+0) by Mariliis Joras
Andrius Bielskis teeb miinimumntõste, et 8000 eest floppi näha. Pasi Sormunen kõigest callib. Markkos Ladev buttonil teeb tõste 29 000 ja jääb Pasiga kahekesi.
flopis, mis checkitakse läbi.
Turn ja Pasi betib 20 000. Markkos calllib.
River toob Pasilt 75 000. Sellega paneb ta Markkose proovile, kuid viimane on teadupärast kartmatu.
Markkose call on väga valus, sest Pasi näitab
Markkose kaarte me ei näe. Järele jääb nüüd väga vähe nuppe...
Ottomar saab ohvri Posted Friday 28th July, 2023 at 17:16(UTC+0) by Mariliis Joras
Ottomar Ladva käes on parem kui vastase .
See tähendab kehvema kaardiga mängijale bustimist.
Tema iste saab kohe uue omaniku - Juha Helppi on tagasi.
Player
Chips
Progress
Juha Ilmari Helppi
100,000
0
Helppi vabastab istme Posted Friday 28th July, 2023 at 17:10(UTC+0) by Mariliis Joras
Juha Helppi viimaseks käeks jääb üheksate pocket.
Vastas Robert Rohr -ga, mis tabab runner-runner masti.
Kogenud pokkerimängijana ei tee Juha teist nägugi. Õigemini teeb ta naerunäo. Aga on ka meest tagasi turniirile oodata?
Player
Chips
Progress
Juha Ilmari Helppi
0
0
16:56 (UTC+0)
Start of Level 9 Blinds: 2,000/5,000 Ante: 5,000
Priit kühveldab rohelisi Posted Friday 28th July, 2023 at 16:53(UTC+0) by Mariliis Joras
Rohelised chipid on väärt 25 000. Ja neid saab Priit Parmasto juurde.
Üsna kulukaks läheb jaotus boardiga Jani Tuovinenile.
Priidu tabab hästi.
100k piir kenasti ületatud Posted Friday 28th July, 2023 at 16:48(UTC+0) by Mariliis Joras
Juba 25 sisseostu on turniirile tehtud ja auhinnafondis julgelt üle 100 000 euro. Võimalik, et kohe on sisseoste 26, sest Markkos Ladev võttis äsja Roope Tarmi välja.
Laual oli , kui nupud sisse saadi.
Roopel ja Markkosel
River jättis Markkose kaks paari mängima ja soomlane out.
Player
Chips
Progress
Roope O. O. Tarmi
0
0
Rikkad ei nuta Posted Friday 28th July, 2023 at 16:38(UTC+0) by Mariliis Joras
Nad haaravad rinnataskust järgmise 5k ja naasevad lauda.
Jussi Mattila viimane käsi
Casper Schantzil samal ajal
Lauakaardid tühised ja Jussi viimased 32 500 lähevad Casperile.
Oma kolmanda bulleti on lendu lasknud Markkos Ladev.
Rasked otsused Posted Friday 28th July, 2023 at 16:32(UTC+0) by Mariliis Joras
Ahto Kingsepal on keeruline.
Flop ja Andrius Bielskis betib. Ahtolt call.
Turn ja Andrius shoveb. Tal on 72 500 nuppu. Ahtol endal ca 10 000 võrra rohkem. Umbes sama palju on ka pangas.
Mida teha?
Ahto veeretab käes -d ja ei suuda otsustada.
Kuigi siin mängus antakse otsustamiseks aega, ütleb ühel lauakaaslasel lõpuks närv üles ja ta kutsub aja välja. Selle kasutab Ahto lõpuni ja foldib oma kaardid siis lahtiselt.
Kas Andrius hingab kergendatult või oleks ta tegelikult calli soovinud, me teada ei saagi.
16:22 (UTC+0)
Start of Level 8 Blinds: 2,000/4,000 Ante: 4,000
Ja ongi back Posted Friday 28th July, 2023 at 16:20(UTC+0) by Mariliis Joras
Nii Markkos Ladev kui Roope Tarmi on tagasi mängus.
Player
Chips
Progress
Roope O. O. Tarmi
100,000
0
Markkos Ladev
72,200
0
BRB Posted Friday 28th July, 2023 at 16:18(UTC+0) by Mariliis Joras
Casper Schantz avab 5000. Roope Tarmi callib. Jussi Mattila callib ja tegelikult noolivad nad kõik BB-l istuva Markkos Ladevi skalpi. Vahepeal on Markkos kukkunud 16 000 peale.
Markkos vaatab oma kaarti ja shovebki.
Nonii, Casper callib. Ja kõigile üllatuseks vajutab calli ka Roope. Jussi on ainus soomlane, kes putku paneb.
Markkosel (üks risti)
Roopel
Casperil
Jussi rikub tuju, teatades, et tema foldis kuued.
Boardilt abi ei tulegi:
Markkos on juba lauast püsti tõusnud ja teatab: "Be right back."
Ka Roope ässad on ribadeks.
Player
Chips
Progress
Roope O. O. Tarmi
0
0
Markkos Ladev
0
0
Uus hingamine Posted Friday 28th July, 2023 at 16:09(UTC+0) by Mariliis Joras
"Kuidas läheb?" uurib Jussi Mattila, nn eestlaste laua värskeim liige.
"Mitte eriti hästi," vastab Ottomar Ladva.
"Miks?" küsitakse vastu.
"Liiga passiivne laud," kurdab Ottomar.
Jussi lubab, et see kõik on kohe muutumas, sest tema on ometigi lauas. Kohe hõikab ta kohale baaridaami ja asub uurima, kellele viina tellida. Kuna kõigil on viinad juba olemas, palutakse baaridaamil alles mõne aja pärast uuesti tagasi tulla.
Jussi mängib oma esimese käe, tehes pre-flopis tõste 6000. Nüüd läheb Markkos Ladev 66 000-ga all-ini ja Jussil on võimalus oma agressiivsust demonstreerida.
Aga see hetk ei ole veel saabunud. Esialgu fold.
Player
Chips
Progress
Jussi P. K. Mattila
100,000
0
15:51 (UTC+0)
Start of Level 6 Blinds: 1,000/2,500 Ante: 2,500
Mängijad pausil Posted Friday 28th July, 2023 at 15:39(UTC+0) by Mariliis Joras
Algas päeva esimene paus.
Selliste stäkkidega lähevad meie mehed puhkust pidama.
Player
Chips
Progress
Priit Parmasto
145,000
45,000
Ottomar Ladva
116,000
16,000
Ahto Kingsepp
115,400
15,400
Markkos Ladev
72,200
27,800
Saab duubli Posted Friday 28th July, 2023 at 15:36(UTC+0) by Mariliis Joras
Ottomar Ladva on endiselt stäki suurendamisega ametis.
CO-lt teeb ta tõste 4500 ja saab calli buttonil istuvalt Casper Schantzilt.
Flopis
Ottomar check-raiseb Casperi 5000 hoopis 15 500 peale. Läheb korda.
Turn toob mõlemalt mehelt veel 13 500 panka, ikka Ottomari soovil.
River ja nüüd Ottomar all-inis. Casperist seekord callijat pole.
Teised mehed kõrvalt aga kõkutavad, et see jaotus oligi praktiliselt nagu duubel.
Viimaks ka mõni showdown Posted Friday 28th July, 2023 at 15:25(UTC+0) by Mariliis Joras
Mäng on tempo maha võtnud ja ei näe me suuri panuseid ega ka showdowne.
Üks siiski tuleb.
Flopis betib Casper Schantz ja saab Ottomar Ladvalt calli.
Turn checkitakse läbi.
River ja Ottomar küsib 6500. Casper vajab väikest mõttepausi, kuid callib ikkagi ära.
See Ottomarile meeldib. Kiirelt kaardid lahti ja näeme -ga riverdatud rida.
Stäkk sai väikse lisa.
15:02 (UTC+0)
Start of Level 5 Blinds: 1,000/2,000 Ante: 2,000
Ottomar proovib tagasi teenida Posted Friday 28th July, 2023 at 15:01(UTC+0) by Mariliis Joras
Ottomar Ladva stäkk on mõneti kokku kuivanud. 25 000 väärtusega žetoone on tal ainult üks. Aga töö stäki kasvatamise nimel käib.
Praegusel tasemel ei ole pre-flopi tõsted 15 000 ja rohkemgi mingi haruldus. Mõnikord saadakse ka actionit, kuid mõnikord raugeb kõik turnis-riveris.
Vahepeal on mänguga liitunud veel üks soomlane, kuid osalejate arvult oleme hetkel 12 peale pidama jäänud.
Üks konkurent taas vähem Posted Friday 28th July, 2023 at 14:41(UTC+0) by Mariliis Joras
Hollandlane Michel Molenaar on tänaseks lõpetanud.
Tal, nagu kõigil teistelgi, on veel aega end uuesti sisse osta, kui selleks peaks soovi olema. Late reg ja re-entry periood kestab 8. taseme lõpuni. Siis algab õhtusöögipaus. Muide, õhtusöök on kõrgelennulistele täna tasuta.
Nende hüvanguks, kes soovivad turniiriga liituda vahetult enne late regi lõppu, on tänane struktuur tehtud tavapärasest erinev. Nimelt korratakse pärast pausi levelit 2500/5000/5000. Seda selleks, et alles mängu alustanutel oleks stardipakul 20BB-d.
Player
Chips
Progress
Michel J.M Molenaar
0
0
Eesti lauda seguneb soomlane Posted Friday 28th July, 2023 at 14:38(UTC+0) by Mariliis Joras
Roope Tarmi ei ole siinsele rahvale sugugi tundmatu mängija. Igal suurfestivalil on ta kohal. Nii tänagi.
Priit Parmasto selja taha ilmub aga üks vari, kes surub käed õlgadele ja kukub masseerima. "Ranno," pakub Priit nägemata, kellega tegu. Ja ta ei eksi.
"Miks sa main'i mängima ei tulnud?" küsib Ranno sõbralt. "Netis oli liiga hea run," ütleb Priit. Nüüd siis teame meiegi.
Player
Chips
Progress
Roope O. O. Tarmi
100,000
0
14:35 (UTC+0)
Start of Level 4 Blinds: 800/1,600 Ante: 1,600
Kui suurelt, siis suurelt Posted Friday 28th July, 2023 at 14:34(UTC+0) by Mariliis Joras
Ahto Kingsepp teeb tavapärase tõste 2400. Ottomar Ladval on ulakas tuju - raise 11 000. Ahtot see ei heiduta.
Flop
Ottomar jätkab 5500-ga ja Ahto kaasas.
Turn ja hetkeks võetakse hoog maha.
River ning ootame Ottomari seisukohta. Ta loeb välja 10 000.
Ahto callib ja saamegi meeste kaarte näha.
Ottomaril kõigest äss kõrge:
Ahtol
Vot nii mängivad suured poisid.
Pirakas pank läheb Ahtole.
Priit võtab tagasi Posted Friday 28th July, 2023 at 14:23(UTC+0) by Mariliis Joras
Jälle on Ahto Kingsepp ja Priit Parmasto vastakuti.
Floppi vaadatakse 2400 eest.
checkitakse läbi.
Turn toob Priidult beti 1800 ja Ahto callib.
River ja Priit küsib 5500. Kui Ahto tõstaks 12 000 peale, tekiks lausa väike deja vu. Aga Ahto piirdub calliga.
"Full house," ütleb Priit, kui näitab
Ahtol maja pole, tema näitab ühte kaarti, milleks . Oli tabamus temalgi.
Lisandub Soome verd Posted Friday 28th July, 2023 at 14:17(UTC+0) by Mariliis Joras
Juha Helppi oli turniiriliste seast veel puudu. See viga sai äsja parandatud.
Player
Chips
Progress
Juha Ilmari Helppi
100,000
0
Korralik flop Posted Friday 28th July, 2023 at 14:15(UTC+0) by Mariliis Joras
Ahto Kingsepp ja Priit Parmasto vaatavad 2500 eest floppi.
maha ja see checkitakse läbi.
Turn ja mõlemad checkivad uuesti.
River toob Priidult 5500, kuid nüüd elavneb ka Ahto, bettides 12 000. Priit vaatab oma stäkki ja leiab, et praegu veel võib. Call!
Ahto avab , olles flopanud rea. Sellest panga võitmiseks piisab. Nice hand, kiidab ka Priit.
Teame juba ette, et mänguga on liituma oodata ka Ottomar Ladvat. Aga kas temagi tuuakse siia eestlaste lauda?
Jah, täpselt nii. Meil on turniiril neli eestlast ja kõik nad on tõstetud ühte lauda.
Ahto Kingespp
Player
Chips
Progress
Ottomar Ladva
100,000
0
14:10 (UTC+0)
Start of Level 3 Blinds: 600/1,200 Ante: 1,200
Rahvast tuli juurde Posted Friday 28th July, 2023 at 14:01(UTC+0) by Mariliis Joras
Nüüd saame käia kahe laua tegemisi jälgimas.
Tere tulemast, Markkos Ladev ja Priit Parmasto!
Player
Chips
Progress
Priit Parmasto
100,000
0
Markkos Ladev
100,000
0
Ja ongi üks väljas Posted Friday 28th July, 2023 at 13:59(UTC+0) by Mariliis Joras
Jõuame laua juurde hetkel, kui kogu board on avatud:
Jube kahju, et ei näinud, kuidas asi sinna jõudis, kuid pangas on ligi 70 000 chippi ja Sondre Stormyr on pärast Robert Rohri checki all-ini liikunud.
Showdown maksab juba niigi kõvasti kõmmutanud Robertile ca 40 000 nuppu.
Mees ragistab ajusid, nii et terve saal kajab. Keegi teda tagant ei kiirusta, sest otsus on tõesti oluline.
Ja näemegi calli! Jess!
Kaardid selili: Sondrel -ga bluff.
Robertil
Player
Chips
Progress
Sondre Stormyr
0
0
Kui palju osalejaid tuleb? Posted Friday 28th July, 2023 at 13:52(UTC+0) by Mariliis Joras
Kas sina oskad arvata?
Korraldusliku tiimi arvates võiks lõpuks 20 mängijat kokku tiksuda.
Kuuenda tulijana potsatab lauda hollandlane Michel Molenaar.
Player
Chips
Progress
Michel J.M Molenaar
100,000
0
Pocketeid liigub Posted Friday 28th July, 2023 at 13:50(UTC+0) by Mariliis Joras
Ahto Kingsepp teeb ületõste ja määrab flopi hinnaks 6000. Robert Rohrile see sobib.
Board chechitakse läbi kuni turnini.
Viimasel tänaval küsib Robert 2800 ja selle ta ka saab, sest Ahto ei paista olevat foldija mees.
Roberti paneb Ahto aga muckima.
Uusi mängijaid on praeguse seisuga lisandunud vaid üks. Andrius Bielskis on samuti istet võtnud.
Põhiturniirilt kukkus välja Igor Pihela Sn, mis võib aga tähendada, et saame peagi ühe Eesti mängija juurde.
13:46 (UTC+0)
Start of Level 2 Blinds: 500/1,000 Ante: 1,000
Neljas mees ka lauas Posted Friday 28th July, 2023 at 13:31(UTC+0) by Mariliis Joras
Kolme mängijaga oleme juba tuttavad, aga neljas saabub väikse hilinemisega. Siiski enne esimese taseme lõppu.
Lõbus sakslane Robert Rohr tervitab kaasvõitlejaid ja liitub actioniga.
Sondre on hoos Posted Friday 28th July, 2023 at 13:29(UTC+0) by Mariliis Joras
Turn ja Ahto checkib. Sondrelt 2200 ja Ahto callib.
River ja nüüd on Sondre juba enesekindlam. Kui Ahto checkib, tuleb Sondrelt 5500 lauda. Ahto otsustab maksta.
Sondre avab ja siia pole Ahtol midagi vastu panna. Muck.
Saab ka kolmekesi Posted Friday 28th July, 2023 at 13:22(UTC+0) by Mariliis Joras
Üks mängijatest ei ole lauda veel jõudnudki, kuid see ei tähenda, et käiks miski fold-fest. Mäng on mõnusalt lahtine.
SB-l istuv Sondre Stormyr limbib ja BB Anders Bjronsen laseb sellel juhtuda. Ahto Kingsepp ei osale.
Flop
Sondre betib 1200 ja saab calli.
Turn ja nüüd Sondre checkib.
Kui Anders betib 2000, siis püüab Sondre tõstega panka kätte saada, kuid Andersi jaoks ei ole probleem nõutud 4700 maksta.
River on Sondrele tõsiselt halb, sest oma -ga on ta nüüd kahte paari tabanud.
Bet 4400 lauda ja Anders snäpib. Arusaadav, miks - tal .
Selge see, et kõrgemad kaks paari on Andersil ja see mahlane pank läheb talle.
13:11 (UTC+0)
Start of Level 1 Blinds: 400/800 Ante: 800
Eriti High rollerid alustavad Posted Friday 28th July, 2023 at 13:09(UTC+0) by Mariliis Joras
Tere kõigile!
Oleme jõudnud festivali kõige kallima turniirini - tervelt 5000 eurot tuleb välja käia neil, kes soovivad osa saada High roller 6max turniirist.
Kuigi turniirikell on juba kõlanud, käib mäng hetkel kõigest nelja mehe vahel. Kas neljast keegi on ka eestlane? Väga hea küsimus, aitäh küsijale.
Ahto Kingsepp on selline kodumaine nimi, kelle osalejate nimekirjast leiame. Kohe läheme uurima, kuidas Ahtol läheb.
13:00 (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.