0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0059 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/21/87/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '21'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
0.0212 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '82'
AND `published` = 1
0.0206 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '84'
AND `published` = 1
0.0219 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1
0.0359 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '93'
AND `published` = 1
0.0050 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '87'
ORDER BY `busted` ASC, `current_chips` DESC
0.0040 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` = '87'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4024'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4013'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4011'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4009'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4006'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4005'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4000'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3999'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3996'
ORDER BY `chip_change` DESC, `busted` ASC
0.0146 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3992'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3986'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3985'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3981'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3975'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3973'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3966'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3965'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3963'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3959'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3952'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3946'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3943'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3932'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3929'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3921'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3916'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3914'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3913'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3907'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3905'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3902'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3900'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3898'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3897'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3895'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3890'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0095 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3883'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3880'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3877'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '87'
ORDER BY `busted` ASC, `current_chips` DESC
0.0042 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '87'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4024'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4013'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4011'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4009'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4006'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4005'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4000'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3999'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3996'
ORDER BY `chip_change` DESC, `busted` ASC
0.0147 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3992'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3986'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3985'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3981'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3975'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3973'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3966'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3965'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3963'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3959'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3952'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3946'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3943'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3932'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3929'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3921'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3916'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3914'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3913'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3912'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3907'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3905'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3902'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3900'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3898'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3897'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3896'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3895'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3890'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3889'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3888'
ORDER BY `chip_change` DESC, `busted` ASC
0.0147 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3885'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3884'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3883'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3882'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3881'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3880'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3877'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3874'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '93'
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 €1,100 Main Event (Estonian)
Live Reporting - Day 4
Žetoonide seis teise päeva järel Posted Friday 28th July, 2023 at 20:19(UTC+0) by maheaaatom
Viis suurimat stäkki kuuluvad väliskülalistele, eestlasi on mängus 16.
TOP5:
Juan Carlos Vecino Duenas, 709000 Vlads Dolgilevics, 674000 Nils Jakob Elias Linden, 558000 Mikael Johannes Haapaniemi, 536000 Tapio Ilmari Aaltonen, 492000
Eestlased: Mauri Dorbek, 470000 Siim Suviste, 388000 Magnus Pukk, 321000 Keito Kaljulaid, 307000 Ilya Nikiforov, 258000 Urmo Velvelt, 251000 Herli Olop, 221000 Kaspar Laursoo, 189000 Igor Pihela noorem, 170000 Tarmo Tammel, 170000 Jargo Alaväli, 139000 Jaana Kindsigo, 132000 Kaido Mikk, 126000 Ranno Sootla, 112000 Andrei Mjagkov, 89000 Martin Piik, 12000
Teine päev otsustati lõpetada Posted Friday 28th July, 2023 at 19:13(UTC+0) by maheaaatom
Kuigi teise päeva lõpuni peaks kella järgi jääma veel 13 minutit, otsustas turniiridirektor mängu tänaseks lõpetada.
Chipid aetakse kottidesse ning kõik mängijad naasevad laudadesse juba homme keskpäeval. Avaldame täpse chippide seisu lähema tunni jooksul.
Mull lõhkes kiiremini kui keegi uskudagi oskas Posted Friday 28th July, 2023 at 19:10(UTC+0) by maheaaatom
Mauri-laua shorstack läheb buttonilt all-in ning Mauri teeb any2 calli.
Shortstackil on , Mauril . Lauda ärtu mast. Mull ei lõhke.
Aga juba järgmise jaotusega kukub äkitselt mängust välja kaks mängijat korraga ja mullimäng saabki täiesti ootamatu lõpu. Kõigile allesjäänutele on tagatud vähemalt 2000 eurot. Palju õnne!
Pre-mull Posted Friday 28th July, 2023 at 19:04(UTC+0) by maheaaatom
73 mängijat on alles ning käimas pre-mull. See mäng on veninud juba päris pikale ning midagi olulist vahepeal toimunud pole.
Väikesed stäkid hoiavad oma pisukesest küünte ja hammatega kinni, lootuses et suured vastamisi jooksevad. Ja suured omakorda loodavad, et väikesed lihtsalt kokku kuivavad või närvid kaotavad. Korra juhtus see isegi Andrei Mjagkoviga, kes oma 57K -ga sisse lükkas.
Call tuli Herli Olopi -lt, flopist sai Herli veel koguni Royali tõmbe. Andrei suureks õnneks siiski nii turn kui river plangud. Risky business.
Tempo on juba pikka aega täielikult maas.
Ranno saab oma ministacki duublisse Posted Friday 28th July, 2023 at 18:34(UTC+0) by maheaaatom
Rannol õnnestub duubeldada -ga vastu. "No mis te arvate, milline range mul hetkel on," naerab Ranno pärast kaartide avamist. Emandad peavad probleemideta vastu. Rannol umbes 85K, endiselt 75 mängijat järgi.
Kõrvalturniiridelt Posted Friday 28th July, 2023 at 18:32(UTC+0) by maheaaatom
High-Rolleri hetkeseisust saate lugeda eraldi blogist, 150 € NLH-l on hiline registeerumine veel käimas ning hetkel tehtud 121 sisseostu, mida on isegi vähem kui võis oodata. Kuid mitmed tuntud seltskonnamängijad on kõigest hoolimata kohal.
5-Card Omaha on aga väga pop, sisseoste kogunes tervelt 192.
18:19 (UTC+0)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Eestlaste seisud Posted Friday 28th July, 2023 at 18:19(UTC+0) by maheaaatom
15. mängutaseme jooksul on suurem osa meie mängijatest pigem ära andnud ning ühtegi väga suurt stäkki enam eestlastel ei ole. Ka Mauri loovutas umbes 100K ühele leedukale, kuid tal on endiselt 400K järgi.
Samuti on igati korralik ühes lauas istuvate Siim Suviste ja Keito Kaljulaiu olukord, mõlemal umbes 360K.
Üsna korraliku stäkiga läks telelauda ka Igor Pihela.
Kokku peaks mängus olema 17 eestlast.
Player
Chips
Progress
Mauri Dorbek
400,000
205,000
Siim Suviste
360,000
286,000
Keito Kaljulaid
360,000
91,000
Magnus Pukk
310,000
50,000
Herli Olop
295,000
5,000
Kaspar Laursoo
220,000
80,000
Urmo Velvelt
210,000
10,000
Ilya Nikiforov
180,000
83,100
Jaana Kindsigo
180,000
65,000
Jargo Alaväli
180,000
60,000
Tarmo Tammel
170,000
40,000
Kaido Mikk
140,000
96,500
Ranno Sootla
75,000
5,000
Magnus annab väikese duubli Posted Friday 28th July, 2023 at 18:01(UTC+0) by maheaaatom
Magnus ründab blinde ning saab vastu 35K all-in panuse soomlaselt Joonas Helin'ilt.
Magnus avab , Joonasel on . Flopis on küll kaheksa, kuid ka kolm potit. Ja neljas poti on ka turnis. River Magnusele maja või nelikut ei too.
Herli-Mauri-Andrei lauas hoiab ohje esimene. Ta on teinud mitu tõste ja ületõstet ning respecti on piisavalt, et callijaid pole leidunud. Senistel Summer Showdown turniiridel erakordselt halba jooksu kogenud Herli on täna sõiduvees ning puudu ei tule ka enesekindlusest.
Kas Andrei "istub" ära? Posted Friday 28th July, 2023 at 17:52(UTC+0) by maheaaatom
Herli ja Mauri lauas istub väikese, umbes 50K (12X BB) stackiga Andrei Mjagkov. Andrei on suurepärane shortstack mängija, kel on lausa erakordne oskus pea alati ka rahadesse venitada.
Nüüd on rahadeni 8 kohta ning Andrei lootmas järjekordsele cashile. Üsna samas seisus on Ranno Sootla, kes ajab küll lauakaaslastega elavalt juttu, kuid mängib sama rahulikult.
Mark kaotab nelikule Posted Friday 28th July, 2023 at 17:41(UTC+0) by maheaaatom
Mark Metsla võtab flipi Patrick Johann Schratzi vastu, kaalul on Margi turniirielu.
Mark:
Patrick:
Kohe flopis kaks kümmet!
Väljas ka Georgi Abuladze ja Iver Rühka. Rahadeni on kõigest 10 kohta, mistõttu on ka mängutempo rahulikum kui enne. Küll mitte Mauri jaoks, kes oma lauakaaslastele raha ei anna.
Player
Chips
Progress
Ivar Rühka
0
0
Georgi Abuladze
0
0
Mark Metsla
0
0
Viimased kaks mängutaset Posted Friday 28th July, 2023 at 17:26(UTC+0) by maheaaatom
Mängijad on pausilt tagasi ning action läheb edasi.
Vaheajal tegime juttu Urmo Velveltiga, kes sai 14. tasemel olulist stäkilisa ning tõusis umbes 200K-le. Kas Urmot võiks isutada ka 5K High-Roller?
"Tase on seal muidugi väga tugev. Ottomar ja need Tartu poisid on väga head," kiidab Urmo, kes ka ise ülikõrges mängus sage külaline. Aga loomulikult kõlab mehe jutust vihje, et kõrges mängus osalemise peamine eeldus on ikkagi see, et seal leidub ka nõrgemaid mängijaid ning mida rohkem, seda parem.
Player
Chips
Progress
Urmo Velvelt
200,000
70,000
17:20 (UTC+0)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Kaks 600K+ stäkki Posted Friday 28th July, 2023 at 16:57(UTC+0) by maheaaatom
Turniiril on kaks stäkki, mis isegi pisut suuremad 600 tuhandest. Neist ühe omanik on hispaanlane Juan Duenas, teine kuulub aga Markku kukutanud Vlads Dolgilevicsiusele. Eestlastest endiselt edukaim Mauri Dorbek.
Algas põhiturniiri teise päeva viimane paus.
"Sajaviiekümnesed" kogunevad Posted Friday 28th July, 2023 at 16:51(UTC+0) by maheaaatom
Juba umbes veerand tunni pärast algab Olympic Casinos tänane kolmas side-event, mis sobib hästi kõikidele hobimängijatele reedeõhtuseks meelelahutuseks. Sisseost on kõigest 150 eurot.
Mängusaalis "Las Vegas" toimuval 5-kaardi Omahal on hetkel 120 sisseostu ning omahatajatega on teiste seas liitunud ka high-roller Markku Koplimaa. See ei välista, et Markku liitub siiski ka (kas tänase või homse) high-rolleriga.
Markku on öelnud, et turniiride valikul sõltub kõik enesetundest. Kui on õige olemine, siis pole ka 5K ja 10K turniirid tema jaoks erakordsed. Aga kui mitte, siis pole ka mingit vajadust vägisi pressima minna. Ja tuju on Markkul vaevalt suurem asi, sest põhiturniirilt langes ta välja ikka eriti valusa käega.
Ivar Rühka duubeldab Posted Friday 28th July, 2023 at 16:43(UTC+0) by maheaaatom
Shortstackiga (35K) Ivar Rühkal õnnestub oma -ga Mark Metslalt () duubel võtta. Margil on umbes 100K, nagu ka temaga samas lauas istuval Tarmo Tammelil.
Urmo Velvelt on oma seisu pisut parandanud ning tõusnud 130K peale. Magnus Pukil on selle laua suurim stäkk - umbes 360K.
Kahjuks ka kaks langejat: Sten Talviste ja Ivar Vendelin. Konkurentsis 88 parimat.
Player
Chips
Progress
Magnus Pukk
360,000
110,000
Urmo Velvelt
130,000
75,000
Mark Metsla
100,000
20,000
Sten Talviste
0
0
Ivar Vendelin
0
0
Mauri võidab võimsa panga Posted Friday 28th July, 2023 at 16:35(UTC+0) by maheaaatom
Mauri Dorbeku 27K kolmpanuse järel vaadatakse koos Anders Christianseniga floppi . Taanlane checkib ette, Mauri paneb 16K ja saab calli.
Turn on . Taanlane checkib taas ette, Mauri paneb 38 500 ning umbes 150K stäkiga Christiansen vastab all-in'iga. Maurilt instacall.
Anders:
Mauri:
Rivermidagi ei muuda.
"Ega ta ei saanudki sellest käest kuskile," arvas Mauri hiljem. Tema stäkk nüüd hiiglaslik 530K, mis peaks olema eestlastest suurim.
Player
Chips
Progress
Mauri Dorbek
530,000
335,000
Alla saja Posted Friday 28th July, 2023 at 16:13(UTC+0) by maheaaatom
Põhiturniiril on alles 99 parimat, seega pole rahakohad (71 parimat) enam üldsegi kaugel.
Eestlastel on kõik hästi, pärast Markku Koplimaa ülivalusat langemist pole pidanud ükski teine mängija turniirialalt lahkuma. Täna on mängida veel umbes 160 minutit.
Mauri purustas kaks vastast Posted Friday 28th July, 2023 at 16:11(UTC+0) by maheaaatom
Mauri võttis äsja ühe jaotusega välja kaks "turisti".
Üks shortstack pushis -ga, teine umbes 90K stäkiga mängija . Ja Mauril . Seekord oli laud just meie mehele armuline, tuues vajaliku poisi.
Mauril nüüd umbes 320K.
16:07 (UTC+0)
Start of Level 14 Blinds: 0/0 Ante: 0
"Pole see Herli midagi nii konservatiivne" Posted Friday 28th July, 2023 at 15:52(UTC+0) by maheaaatom
Nii kommenteerib Mauri Dorbek, kes näeb Herlit järjekordset kätt võitmas.
Herli läheb keskmiselt positsioonilt "röövima" ja saab buttoni kaasa. Flopis on , turnis . Mõlemal juhul panustab Herli ette (turnil koguni 15K) ja saab calli.
River on , mis checkitakse läbi.
Herli võtab panga maha, vastane ei näita. Seitse aastat suurturniiri vesise suuga pealt vaatanud Herli on põhiturniiril selgelt sõiduvees ning tema stäkk hetkel juba ca. 300K.
Player
Chips
Progress
Herli Olop
300,000
40,000
Markku Koplimaa ülivalusa käega väljas Posted Friday 28th July, 2023 at 15:47(UTC+0) by maheaaatom
Markku Koplimaa avas 5K, teist päeva liidrina alustanud Vlads Dolgilevics vastas 16K ületõstega. Markku lisas veel 30K ning lätlane lükkas all-in. Markkult kiire call.
Vlads:
Markku:
Emand flopis. Kuigi Markkul oli enne saatuslikku kätt 200K stäkk, oli lätlase oma siiski suurem. Väga valus...
Player
Chips
Progress
Markku Koplimaa
0
0
Magnus, Kaspar, Herli ja Igor liidrite seas Posted Friday 28th July, 2023 at 15:30(UTC+0) by maheaaatom
Loeme taas eestlaste stäkke. Pidevalt on oma punktisummat suurendanud Magnus Pukk, kel hetkel juba ca. 370K.
Kaspar on selgelt tõusnud (300K) ning ka Herli edeneb ilusti (260K). Umbes sama suur stäkk on ka Igor Pihelal.
Player
Chips
Progress
Kaspar Laursoo
300,000
140,000
Herli Olop
260,000
110,000
Igor Pihela noorem
260,000
10,000
Jargo Alaväli
240,000
110,000
Markku Koplimaa
205,000
5,000
Mauri Dorbek
195,000
15,000
Andrei Mjagkov
180,000
70,000
Tarmo Tammel
130,000
30,000
Jaana Kindsigo
115,000
25,000
Ranno Sootla
70,000
20,000
Martin Piik
55,000
10,300
Urmo Velvelt
55,000
20,300
Jätame hüvasti... Posted Friday 28th July, 2023 at 15:19(UTC+0) by maheaaatom
...järgmiste põhiturniiril osalevate Eesti mängijatega
Player
Chips
Progress
Andres Aro
0
0
Aleksandr Kuperman
0
0
Priit Vanem
0
0
Peagi on algamas TV-laua ülekanne Posted Friday 28th July, 2023 at 15:17(UTC+0) by maheaaatom
Umbes kell 17:20 algab TV-laua ülekanne. Täna on plaanis vahendada nii põhiturniiril toimuvat kui ka 5K High-Rollerit. Esimesena on telepurgis põhiturniiri mängijad. Actionit jälgi siin: https://olybet.tv/kings-of-tallinn-summer-showdown-2023-2
Algas 13 mängutase ja viie-kaardi Omaha Posted Friday 28th July, 2023 at 15:01(UTC+0) by maheaaatom
Põhiturniir läheb edasi. Turniiri võitja teenib 108 260 eurot, viimane rahakoht saab täpselt kaks tuhat.
Ühtlasi algas ka tänane teine kõrvalturniir - 250 € PLO 5 Card. Viimast alustas 23 mängijat, nende seas ka mitmeid eestlasi.
14:58 (UTC+0)
Start of Level 13 Blinds: 1,000/3,000 Ante: 3,000
Teine paus Posted Friday 28th July, 2023 at 14:43(UTC+0) by maheaaatom
123 allesjäänud mängijat suundusid pausitama. Viimase käega kaotas päris piraka poti Jargo Alaväli, kes langes nüüd umbes 200K peale.
Teist päeva eestlastest suuruselt teise stäkiga alustanud Kaspar Laursoo on umbes samas seisus mis päeva alguses, võib-olla natuke isegi juurde saanud. Keskmine stäkk on hetkel umbes 55XBB.
Player
Chips
Progress
Jargo Alaväli
200,000
150,000
Õnn soosib Igorit Posted Friday 28th July, 2023 at 14:37(UTC+0) by maheaaatom
Igor Pihela on kogu teise päeva hästi mänginud ning oma chipikuhja vaikselt, kuid stabiilselt suurendanud.
Äsja õnnestus veel 60K juurde saada, seda küll üsna kummalise jaotuse võiduga. Nimelt olid nii temal kui Jari-Pekka Juholal pocket soldatid, kuid lauda pandi neli potit ning just Igoril oli poti poiss.
Samas lauas on ka Tarmo Tammel, kes alustas päeva väga pisikese stäkiga, kuid on nüüd juba umbes 100K peal, millega on parasjagu mänguruumi.
Player
Chips
Progress
Igor Pihela noorem
270,000
114,000
Tarmo Tammel
100,000
79,800
Jah - TA on kohal! Posted Friday 28th July, 2023 at 14:25(UTC+0) by maheaaatom
Vahemärkusena olgu öeldud, et Summer Showdownile on saabunud tõeline "küürvaal" Ottomar Ladva, kes võttis natuke aega tagasi istet seisusekohasel 5K High-Rolleril.
Ja kangeid Eesti mehi on peale Ottomari teisigi. Tore on näha, et Eesti pokker on jõudnud tasemele, kus ülikõrgete sisseostudega turniirid osalemine on mitmete tippmängijate jaoks juba üsna tavaline ettevõtmine.
Eestlaste stäkke Posted Friday 28th July, 2023 at 14:19(UTC+0) by maheaaatom
Vahepealse ajaga on veelgi paranenud Herli seis, seevastu Jaana Kindsigo on pea poole oma stäkist ära andnud. Välja on langenud kaardi- ja stäkisurmas vaevelnud pokkeriproff Tõnis Viik.
Player
Chips
Progress
Magnus Pukk
250,000
40,000
Markku Koplimaa
210,000
49,500
Mauri Dorbek
180,000
30,000
Herli Olop
150,000
50,000
Andrei Mjagkov
110,000
56,600
Jaana Kindsigo
90,000
90,000
Mark Metsla
80,000
40,000
Ranno annab ära Posted Friday 28th July, 2023 at 14:16(UTC+0) by maheaaatom
Artjoms Hromovs ning Ranno Sootla mängivad (meeste stäkke arvestades) võrdlemisi suure panga.
Lauas on ning pangas umbes 30K. Pärast mastihõngulist riverit panustab esimesena juba lätlane, lükates keskele 15K.
Ranno callib paraja äginaga ära. Vastane avab , mis tekitab pisut hämmeldust. River oli Rannole üsnagi saatanlik, sest tal käes . Rannol umbes 50 järgi.
Player
Chips
Progress
Ranno Sootla
50,000
50,000
Täna polnud Kaido päev Posted Friday 28th July, 2023 at 14:02(UTC+0) by maheaaatom
Kaido Koorits ei suutnud kahjuks oma stäkki üles saada ning on mängust väljas. Sama käib ka kahjuks Kaidar Viikmani, vanema Pihela, Mirza ja Mart Tammoja kohta.
Lisaks neile pidi lauast püsti tõusma ka tänavuse EMV põhiturniiri kolmas mees Andrey Koks. Jätkab 142 parimat. Täpselt pooled neist saavad raha.
Player
Chips
Progress
Kaido Koorits
0
0
Kaidar Viikman
0
0
Mart Tammoja
0
0
Igor Pihela
0
0
Andrey Koks
0
0
Kaidar ja Martin otsivad lükkekohta Posted Friday 28th July, 2023 at 13:41(UTC+0) by maheaaatom
Üsna pisikeste stäkkidega Martin Piik ja Kaidar Viikman otsivad oma lükkekohti, mõlemal on alla 20XBb stäkk. Kaidaril on kõige krooniks ka erakordselt keeruline laud. Tõsi, seal istuvad profid Tõnis Viik ja Urmo Velvelt pole ka just kuigi paremas seisus.
Kahjuks on ka mitmeid langejaid. Nii ei suutnud täna oma mängu kuidagi käima saada Oskar Ojaveer ning ka Ermo Kosk polnud oma paremate päevade tasemel. Samuti on väljas Stanislav Smeljov.
Player
Chips
Progress
Oskar Ojaveer
0
0
Stanislav Smeljov
0
0
Ermo Kosk
0
0
Paul flippas mööda Posted Friday 28th July, 2023 at 13:30(UTC+0) by maheaaatom
Kahjuks langes äsja veel üks Eesti mängija, kelleks osutus Paul Koppe.
Paul olla flipanud kümnetega vastu ning seda ebaõnnestunult. Vastane tabas nimelt kuningat.
AMETLIK: Põhiturniiri auhinnafond on 530 160 eurot! Posted Friday 28th July, 2023 at 13:26(UTC+0) by maheaaatom
Summer Showdown põhiturniiril ületati senine osalejate arvu ja sisseostude rekord umbes kahekordselt ning mäng käib täpselt 530 160 eurole. Tegemist on kindla peale ühe suurima viimastel aastatel Eestis toimunud pokkeriturniiriga!
Sisseoste kogunes 564. Auhinnafond jaguneb 71 parima vahel, täpsed väljamaksed selguvad lähiajal.
Vaalad on laudades Posted Friday 28th July, 2023 at 13:20(UTC+0) by maheaaatom
Alanud on 5000 € High-Roller. Esialgu küll vaid neli mängijat, kuid neid tuleb vaikselt juurde. Ja loodetavasti istub lauda ka üks pokkerikuulsus, keda just äsja näha võis.
High-Roller turniirist valmib Mariliisi vahendusel samuti live-blogi, mida saab siinsamas OlyBet Events keskkonnas jälgida.
Allan mängust väljas Posted Friday 28th July, 2023 at 13:16(UTC+0) by maheaaatom
Mitu jaotust järjest agressiivselt mänginud Allan Arjut avab 3,5K tõstega, Jargo Alaväli paneb 10K juurde ning Allan nüüd juba 35K. Enam pääsu pole, Jargo vastab all-in'iga ja saab calli (Allani stäkk umbes 95K).
Jargo:
Allan:
Ässa ei tule, Allanile otsekui mõnituseks riverisse veel üks kuningas. Jargo stäkk kena 350K.
Player
Chips
Progress
Jargo Alaväli
350,000
110,000
Allan Arjut
0
0
Kaido Koorits võidab endalegi ootamatult Posted Friday 28th July, 2023 at 13:13(UTC+0) by maheaaatom
Kaido Koorits mängib umbes 20K panga ning saab endalegi ootamatu võidu.
Flopi järel checkib Vigerdas Jonikas, Kaido vajutab 6500 ja saab calli.
Turn ja river checkitakse läbi. Leedukas näitas ning Kaido saab panga -ga kätte.
Allan duubeldab Posted Friday 28th July, 2023 at 13:00(UTC+0) by maheaaatom
Allan Arjutil õnnestub üks endaga sama suur (ehk siis tegelikult väga väike) stäkk välja võtta.
Nupud läksid sisse pärast äss-high floppi, lauas kolm ristit. Allanil oli äss pihtas ja vastasel kuningas-kõrge mastitõmme. Meie mehe õnneks turn ja river plangud.
Sõjavägi kohustab Posted Friday 28th July, 2023 at 12:48(UTC+0) by maheaaatom
Nii laulis JMKE 1989. aastal ning laulus kõlanud tõde peab paika ka 2023. aastal.
Milles täpsemalt asi? Septembris toimuvad järjekordsed (massiivsed) kordusõppused, kuhu on kutsutud ka Eesti pokkerimängijaid. See aga tähendab, neil jääb esmakordselt Eestis toimuv WSOP Circuit kahjuks vahele.
12:42 (UTC+0)
Start of Level 11 Blinds: 1,000/1,500 Ante: 1,500
Palju sagimist Posted Friday 28th July, 2023 at 12:16(UTC+0) by maheaaatom
Turniirialal käib kõva sebimine ja sagimine, sest mängitakse viimaseid pausieelseid jaotusi.
Üle saali kostab aina hüüe "Seat open!" Alanud 20-minutilise pausi jooksul saavad kõik, kel nööbid viimseni otsas, veel turniiriga liituda.
Oleme peagi tagasi.
Tõnis leiab ässad Posted Friday 28th July, 2023 at 12:00(UTC+0) by maheaaatom
Väga pisikese stäkiga mänginud pokkeriproff Tõnis Viik saab viimaks oodatud duubli pocket ässadega vastu. Nuppe peab loovutama Urmo Velvelt, kelle seis on ka kõike muud kui hea.
Veel 10 minutit re-entry'te sooritamiseks, liiklus kassa vahel on vägagai aktiivne.
Eestlaste stäkke Posted Friday 28th July, 2023 at 11:51(UTC+0) by maheaaatom
Üheksas ja kümnes mängutase on olnud selgelt edukad Jaana Kindsigole, kes on oma seisu kõvasti parandanud.
Ka Jargo Alaväli on saanud natuke juurde, seevastu Kaspar Laursoo jällegi omajagu loovutanud.
Täna 30K lauda istunud meestest on Ranno Sootla selle juba umbes kolmekordistanud ning ka Allan Arjut on saanud pisut enam kui duubli.
Player
Chips
Progress
Jargo Alaväli
240,000
27,000
Jaana Kindsigo
180,000
104,100
Kaspar Laursoo
160,000
48,700
Igor Pihela noorem
156,000
6,900
Mark Metsla
120,000
14,500
Ranno Sootla
100,000
70,000
Paul Koppe
90,000
49,000
Allan Arjut
70,000
40,000
Pool miljonit täis! Posted Friday 28th July, 2023 at 11:39(UTC+0) by maheaaatom
Ootasime ja eeldasime, et põhiturniiri auhinnafond paisub poole miljoni euroseks ning täpselt nii on ka läinud.
Hetkeseisuga on kirjas 532 sisseostu ning pool miljonit on koos!
Kümnenda taseme lõpuni on veel pool tundi ning tõenäoliselt tuleb sisseoste veel omajagu juurde. Keskmine stäkk on 81K ehk 57XBB.
Olukorrast proffide lauas Posted Friday 28th July, 2023 at 11:35(UTC+0) by maheaaatom
Seda lauda valitseb Magnus Pukk (ca. 220K), Markku Koplimaa ja Urmo Velvelt on suhteliselt samas seisus mis päeva alguses (vastavalt 160K ja 80K), Kaidar on natuke ära andnud ning ka Tõnis pole oma mängu õieti käima saanud.
Teises põnevas eestlaste lauas andis just Mauri ca. 50K ära ühele kolmiku flopanud väliskülalisele. Aga Mauri stäkk on endiselt vähemalt kahekordne keskmine, seega pole paanikaks mingit põhjust.
Re-entry sai muide kirja ka pokkerimiljonär Anatoly Filatov ning äsja liitus mänguga ka avapäevadel üsna halvasti jooksnud Eesti superäss Ranno Sootla.
Mauri korjab Herlilt tagasi Posted Friday 28th July, 2023 at 11:18(UTC+0) by maheaaatom
Taas on vastamisi samad mehed, lihtsalt jaotuse stsenaarium on täiesti vastupidine eelmisele.
Seekord läheb Herli Mauri blindi sööma ning viimane alla ei anna.
Enne floppi läheb sisse 2,5, flop checkitakse läbi.
Turni järel panustab juba Mauri 3,5 ning jätkab seda ka pärast riverit . Herli ei usu ja callib.
Mauri avab ning korjab panga maha. Tema stäkk on nüüd taas üle 200K, sest alles õnnestus Mauril ka üks põhjanaaber välja lüüa.
11:14 (UTC+0)
Start of Level 10 Blinds: 0/0 Ante: 0
Kes on turniiri kuulsaim osaleja? Posted Friday 28th July, 2023 at 11:05(UTC+0) by maheaaatom
Ei, see pole Ranno Sootla ega isegi mitte Markku Koplimaa, vaid tõenäoliselt hoopis GGPoker esindusmängija Anatoly Filatov, kes elab muide Tallinnas!
Anatoly on 34-aastane Moskvas sündinud, kuid viimastel aastatel peamiselt Lääne-Euroopas elanud ning tegutsenud tippmängija, kelle kontol on üle 5 miljoni dollari Hendoni cashe ning väga korralik karjäär ka netipokkeris.
2019 aastal sai ta kolmanda koha WSOP Europe High-Roller turniiril (sisseost 100 000 eurot!) ja 2021. aastal võitis $10,300 Super MILLION$ põhiturniiri GG-võrgustikus, mis tõi talle sisse üle miljoni euro. Mees on muide varemgi Eestis mänginud, näiteks tänavusel Kings of Tallinn High-Rolleril oli ta teine.
Kui 1100-eurone sisseost on enamikule pokkerifännidest väga suur, siis miljonimänguga harjunud Anatoly jaoks on tegemist peenrahaga. Seega on ainult hea meel sellise tasemega meest Summer Showdownil näha.
500 sisseostu koos Posted Friday 28th July, 2023 at 10:53(UTC+0) by maheaaatom
Teine päev on alanud niivõrd tempokalt, et oodatud 500 sisseostu piir sai õige kiirelt täis.
Kõigi eelduste kohaselt jõuab ka auhinnafond oodatud poole miljoni euroni, sest sellest on puudu veel vaid paarkümmend sisseostu ning sagimine turniiriala ning kassa vahel on päris aktiivne.
Kõik mängijad on mahu suurde saali ära, neli lauda on viidud fuajeesse. Eestlastest veel niipalju, et Jaana Kindsigo on ka oma seisu märgatavalt parandanud ning nüüd selgelt üle keskmise stäkiga.
Mõned langejad Posted Friday 28th July, 2023 at 10:47(UTC+0) by maheaaatom
Juba on välja langenud / re-entry'le läinud paarkümmend osalejat, nende seas ka neli eestlast: Hendrik Uibo, Kaius Kiidli, Karlo Kivi ning Jüri Roots.
Väga karm laud Posted Friday 28th July, 2023 at 10:45(UTC+0) by maheaaatom
15. lauas on saanud kokku hirmkõva eestlaste seltskond:
- Viimase kahe aasta EMV põhiturniiri võitjad Magnus Pukk ja Kaidar Viikman
- Super High-Roller Urmo Velvelt
- Eesti läbi aegade edukaim turnamängija Markku Koplimaa
- Hinnatud pokkeriproff Tõnis Viik
Vaevalt tahaks keegi selles kambas mängida...
Allan pidas sõna Posted Friday 28th July, 2023 at 10:35(UTC+0) by maheaaatom
Allan ütles eilse päeva 1B ajal, et ainult nõrgad mängivad esimest päeva ning kõvad mehed istuvad lauda alles teisel päeval.
Ei olnud see nali midagi, Allan pidas 100% sõna. Nüüd ongi ta kenasti lauas ning istub täpselt Eesti superprofi Jargo Alavälja kõrval. 25XBB on täpselt see stäkk, millega saab esialgu veel rahulikult oma lükkekohta oodata.
Herli duubeldab läbi Mauri Posted Friday 28th July, 2023 at 10:31(UTC+0) by maheaaatom
50K stäkiga alustanud Herli Olop võttis kiire duubli, maksjaks oli seekord suur kodumaine konkurent Mauri Dorbek.
Mauri avab CO-lt, Herli kaitseb BB-d -ga.
Flopis , Herli checkib ette, Mauri paneb 3500 ja Herli callib.
Turn toob lauale mastivõimaluse. Herli check-callib taas Mauri 7,5K panust, jättes 30K järgi.
River on blank ning Mauri paneb Herli all-in. Viimane callib ning Mauri avab - puhas bluff.
"Tal nuppe nii palju, lükkas oma kuhjalt lihtsalt natuke tolmu maha," naerab rahulolev Herli.
Herli stäkk nüüd c. 100K, Mauril on umbes 150K.
Player
Chips
Progress
Mauri Dorbek
150,000
57,400
Herli Olop
100,000
50,700
Magnus Pukk võtab esimese skalbi Posted Friday 28th July, 2023 at 10:22(UTC+0) by maheaaatom
38K stäkiga Kasparas Drazdauskas tuleb blinde sööma ning BB-d kaitsev tunamullune EMV põhiturniiri võitja Magnus Pukk vastab all-in'iga.
Kasparaselt kiire call. Magnus avab , leedukal on . Laud tühi ning Magnuse stäkk nüüd 210K.
Player
Chips
Progress
Magnus Pukk
210,000
38,600
Kui kaua me tänane mängime? Posted Friday 28th July, 2023 at 10:17(UTC+0) by maheaaatom
Turniiridirektor Teresa kinnitusel on täna kavas mängida kaheksa taset sõltumata selles, kui palju mängijaid alles jääb.
See tähendab actionit kuni umbes üheksani. Ülekannet tasub aga kindlatsi jälgida ka pärast seda, sest just hilisõhtul jõuab kulminatsioonini tõeline "vaalade turniir", 5000 € High-Roller, tuntud ka kui "5K".
39 eestlast Posted Friday 28th July, 2023 at 10:13(UTC+0) by maheaaatom
Kaardid on õhus. 216 alustaja seas on 39 eestlast, täiesti uueks liitujaks meie meestest siiski vaid Jüri Roots.
Priit Vanem alustab samuti 30K stäkiga, kuid sellega lõpetas ta ka eilse päeva (1B).
Esimese kahe taseme jooksul on "lubatud" eksida (saab teha re-entry 25xBB), kuid hiljem enam mitte.
Mängijad kogunevad Posted Friday 28th July, 2023 at 09:58(UTC+0) by maheaaatom
Head pokkerisõbrad, tervitame teid taas kodusest pokkerimekast, Olympic Park Casinost.
Põhiturniiri teise päeva mängijad kogunevad laudadesse, väljas on veel kenake järjekord, mis ulatud lausa kasiino uksest tänavale. Mängu alustab hetkeseisuga 200 mängijat, nende seas nii esimese päeva üleelanud pokkerisportlased kui ka mõned uued liitujad.
Auhinafondis on juba ligi 450 tuhat eurot ning esikümnes kolm Eesti pokkerimängijat eeotsas Jargo Alaväljaga. Tuleb väga põnev päev!
09:42 (UTC+0)
Day 2 of Kings of Tallinn Summer Showdown 2023 Started Level: 9 Blinds: 600/1,200 Ante: 1,200
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.
, Mauril 
. Lauda ärtu mast. Mull ei lõhke.
-lt, flopist sai Herli veel koguni Royali tõmbe. Andrei suureks õnneks siiski nii turn kui river plangud. Risky business.
. Flopis on küll kaheksa, kuid ka kolm potit. Ja neljas poti on ka turnis. River Magnusele maja või nelikut ei too.
. Taanlane checkib taas ette, Mauri paneb 38 500 ning umbes 150K stäkiga Christiansen vastab all-in'iga. Maurilt instacall.
midagi ei muuda. 
, turnis 
. Mõlemal juhul panustab Herli ette (turnil koguni 15K) ja saab calli.
, mis checkitakse läbi. 
võtab panga maha, vastane ei näita. Seitse aastat suurturniiri vesise suuga pealt vaatanud Herli on põhiturniiril selgelt sõiduvees ning tema stäkk hetkel juba ca. 300K.
järel checkib Vigerdas Jonikas, Kaido vajutab 6500 ja saab calli.
checkitakse läbi. Leedukas näitas 
-ga kätte. 
läheb sisse 2,5, flop checkitakse läbi.
järel panustab juba Mauri 3,5 ning jätkab seda ka pärast riverit 
ning korjab panga maha. Tema stäkk on nüüd taas üle 200K, sest alles õnnestus Mauril ka üks põhjanaaber välja lüüa.
, Herli checkib ette, Mauri paneb 3500 ja Herli callib.
- puhas bluff. 
