0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0066 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/21/93/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.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
0.0252 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` = '82'
AND `published` = 1
0.0244 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0035 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '84'
AND `published` = 1
0.0243 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0034 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1
0.0245 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0034 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1
0.0246 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.0054 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.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` = '93'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4375'
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` = '4374'
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` = '4372'
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` = '4371'
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` = '4370'
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` = '4368'
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` = '4365'
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` = '4364'
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` = '4363'
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` = '4361'
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` = '4359'
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` = '4357'
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` = '4355'
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` = '4354'
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` = '4351'
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` = '4350'
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` = '4349'
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` = '4346'
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` = '4344'
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` = '4341'
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` = '4340'
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` = '4338'
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` = '4336'
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` = '4334'
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` = '4333'
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` = '4332'
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` = '4325'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4320'
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` = '4318'
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` = '4316'
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` = '4314'
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` = '4311'
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` = '4309'
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` = '4305'
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` = '4303'
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` = '4301'
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` = '4297'
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` = '4294'
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` = '4290'
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` = '4287'
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` = '4285'
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` = '4280'
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` = '4274'
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` = '4268'
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` = '4267'
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` = '4265'
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` = '4264'
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` = '4263'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 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.0047 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '93'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4375'
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` = '4374'
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` = '4372'
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` = '4371'
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` = '4370'
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` = '4368'
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` = '4365'
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` = '4364'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4363'
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` = '4361'
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` = '4359'
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` = '4357'
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` = '4355'
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` = '4354'
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` = '4351'
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` = '4350'
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` = '4349'
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` = '4346'
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` = '4344'
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` = '4341'
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` = '4340'
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` = '4338'
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` = '4336'
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` = '4334'
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` = '4333'
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` = '4332'
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` = '4325'
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` = '4320'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4318'
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` = '4316'
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` = '4314'
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` = '4311'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4309'
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` = '4305'
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` = '4303'
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` = '4301'
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` = '4297'
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` = '4294'
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` = '4290'
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` = '4287'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4285'
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` = '4280'
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` = '4274'
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` = '4268'
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` = '4267'
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` = '4265'
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` = '4264'
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` = '4263'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 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
1. koht Kai Lehto 108 260 € Posted Sunday 30th July, 2023 at 18:04(UTC+0) by Mariliis Joras
Phil Gross avab 400 000. Tal täitsa ok kaart
Kai Lehto on vähem võimas, aga floppi võib ju vaadata.
Lauda ehk kõigile midagi.
Phili soovil panevad mõlemad veel 300 000 juurde.
Turn ja nüüd betib Phil 500 000. Tuleb call.
River !
Kai suudab end nüüdki vaos hoida ja checkib, aga kui Phil betib 1,3 miljonit, siis shoveb.
Nagu arvata võis, ei saa vastane enam foldida.
Ja lõpplahendus on käes.
Aega läks, aga mõlemad on tõelised tšempionid.
Player
Chips
Progress
Kai E. J. Lehto
17,000,000
8,100,000
2. koht Phil Gross 72 700 € Posted Sunday 30th July, 2023 at 18:01(UTC+0) by Mariliis Joras
Phil Grossi stäkk aina väheneb, kuniks see on Kai Lehto omast märgatavalt väiksem.
Mäng on mõlemad mehed ära väsitanud, kuid võitjana väljub olukorrast seekord soomlane.
Player
Chips
Progress
Phil Gross
0
0
Kolmas all-in ja call Posted Sunday 30th July, 2023 at 17:45(UTC+0) by Mariliis Joras
Kai Lehtol käes ja ta limbib.
Phil Gross leiab aga ja põrutab kõik sisse.
Kai läheb kaasa.
Lauda
Lõpplahendust ei saabu ikka veel.
Player
Chips
Progress
Phil Gross
8,600,000
500,000
Phil Gross
8,400,000
300,000
Phil kaotab veel ühe miljoni Posted Sunday 30th July, 2023 at 17:41(UTC+0) by Mariliis Joras
Phil Gross üritab Kai Lehtole kohta kätte näidata.
Kai tõstab 400 000 kahtede pocketiga.
Phil paneb 1,1 miljonit, ehkki endal vaid
Kai liigub nüüd all-ini ja Phil foldib.
Miljon lännu nagu mutiauku.
Phil kaotab suure hunniku žetoone Posted Sunday 30th July, 2023 at 17:39(UTC+0) by Mariliis Joras
Phil Gross ei usu, et Kai Lehto on tabanud.
Board
Phil ise on hittinud kuut. Kai aga kuningat.
Koos pre-flopi ja turni panusega kaotab Phil oma stäkist üle miljoni.
Täiesti võrdseks Posted Sunday 30th July, 2023 at 17:25(UTC+0) by Mariliis Joras
Kai Lehto ja Phil Gross vaatavad koos floppi ja sellise kõrge hinna eest nagu 1,2 miljonit.
Boardile saab Phil -ga pihta,
Kai midagi ei taba.
Kuigi rohkem actionit ei toimugi, on märkamatult stäkid peaaegu võrdseks tasakaalustunud.
Player
Chips
Progress
Kai E. J. Lehto
8,900,000
3,100,000
Phil Gross
8,100,000
3,000,000
17:22 (UTC+0)
Start of Level 32 Blinds: 100,000/200,000 Ante: 200,000
Phil teeb hea blufi Posted Sunday 30th July, 2023 at 17:19(UTC+0) by Mariliis Joras
Phil Grossil on flopis kahepoolne reatõmme, mis aga kohale ei tule.
Kai Lehto ei saa lauale samuti pihta, kuid showdowni korral võtaks võidu. Phil teeb riveris julge käigu ja surub all-ini. Calli ei tule.
Chipilisa on väike, aga alla 5 miljoni käes hoidva Phili jaoks on iga žetoon oluline.
Mõnus snooze-fest Posted Sunday 30th July, 2023 at 17:05(UTC+0) by Mariliis Joras
Mitte mingeid arenguid pole.
Vaadates kaarte, mis mängijatele kätte jagatakse, tuleb natuke ahastus peale. Aga lootust ka ei saa kaotada.
Sellise karika peale käib mäng:
Teine all-in ja call Posted Sunday 30th July, 2023 at 16:52(UTC+0) by Mariliis Joras
Phil Grossil on käes kaheksate pocket. Ta teeb tõste 300 000.
Kai Lehto pole midagi erilist, aga ta otsustab callida.
Flop ja Kai checkib.
Phil betib 300 000, aga Kai liigub nüüd all-ini ja saab ka calli.
Turn paneb pealtvaatajad ohkama.
River ja ei mingit lõpplahendust.
Player
Chips
Progress
Kai E. J. Lehto
12,000,000
2,000,000
Phil Gross
5,100,000
2,100,000
Esimene all-in ja call Posted Sunday 30th July, 2023 at 16:44(UTC+0) by Mariliis Joras
Phil Gross teeb tõste 375 000. Kai Lehtol on parem plaan - kui vaataks floppi õige 1,1 miljoni eest? Phil nõustub.
Kai betib 600 000, kuid Phil liigub nüüd all-ini.
Kail läheb natuke aega, et otsusele jõuda, kuid siit tulebki esimene all-ini call.
Kai avab
Phil püüab -ga masti.
Turn ei muuda midagi.
River ja Kai duublis.
Player
Chips
Progress
Kai E. J. Lehto
14,000,000
6,800,000
Phil Gross
3,000,000
6,700,000
Natuke juurde Posted Sunday 30th July, 2023 at 16:31(UTC+0) by Mariliis Joras
Flop sobib Kai Lehtole, kellel .
Ta laseb Phil Grossil show'd juhtida. Phil panustabki 300 000 ja saab calli. Endal tal käes
Turn annab paari ka Philile. 500 000 maksab Kai muidugi välja.
River checkitakse läbi. Kaardid lahti ja pank Kaile.
See muudab vahekorda oluliselt võrdsemaks.
Player
Chips
Progress
Phil Gross
9,700,000
2,900,000
Kai E. J. Lehto
7,200,000
2,875,000
Kai võitleb Posted Sunday 30th July, 2023 at 16:12(UTC+0) by Mariliis Joras
Kai Lehtol on küll väiksem stäkk, aga väikeste jaotuste haaval ronib ta stäkiredelil üles.
Jäme ots on Phili käes Posted Sunday 30th July, 2023 at 16:02(UTC+0) by Mariliis Joras
Stäkid heads upi eel.
Player
Chips
Progress
Phil Gross
12,600,000
400,000
Kai E. J. Lehto
4,325,000
1,875,000
Heads up algab pärast pisukest pausi Posted Sunday 30th July, 2023 at 15:48(UTC+0) by Mariliis Joras
Mängijad soovivad 20 minutit puhata ja on siis valmis välja selgitama, kelle Hendon Mobi andmed 100 000 võrra kasvavad.
3. koht Urmo Velvelt 49 300 € Posted Sunday 30th July, 2023 at 15:43(UTC+0) by Mariliis Joras
Urmo Velvelti agressiivne mäng on langetanud ta väikseimaks stäkiks. Kahjuks on vastastel rohkem õnne olnud.
Nüüd lähevad 1,9 miljonit sisse kaheksate taskupaariga, kuid seda alles pärast Phil Grossi all-ini. Philil .
Kuni riverini on kõik ilus, aga viimase kaardina avatakse äss ja meie mees out. Õnneks saab pisarad ära kuivatada 100-eurostega, sest neid antakse Urmole kassast terve hunnik.
Player
Chips
Progress
Phil Gross
13,000,000
7,400,000
Urmo Velvelt
0
0
Mees, kes ei karda all-inis käia Posted Sunday 30th July, 2023 at 15:36(UTC+0) by Mariliis Joras
Urmo Velvelt on mitu korda üritanud jõuga panka endale murda. Küll pre-flopis kipaka kaardiga tõsteid tehes kui ka juba avatud flopiga suurelt bettides.
Tema jõunumbritega läheb kaasa või sõidab nende peale all-ini Phil Gross. Mis tal viga - kogu aeg on pihtas.
Urmo on selliselt kaotanud juba õige mitu miljonit.
Phil võtab lisa Posted Sunday 30th July, 2023 at 15:30(UTC+0) by Mariliis Joras
Phil Gross mängib -ga ja hitib runner-runner masti.
Boardile
Kai Lehto üritab vastast üle kavaldada, tal -ga ebaõnnestunud reatõmme.
Riveri beti teeb ta 1,3 miljoni suuruse. Phil teeskleb nuputamise nägu, kuniks shoveb. Kai nägu vajub morniks ja kaardid lendava dmucki.
Väga hea chipilisa Philile.
Urmo mängib vastase üle Posted Sunday 30th July, 2023 at 15:23(UTC+0) by Mariliis Joras
Urmo Velvelt võtab jõuga panga maha.
Ta teeb pre tõste 250 000 ja saab uudishimuliku Phil Grossi kaasa, tollel .
Phil tabab flopis seitset ja lisatakse kummaltki veel 200 000 panka.
Turn ja Phil checkib. Urmo betib nüüd suurelt 500 000. Phil on ees, aga et lauas kaks pildikaarti, hakkab ta endas kahtlema. Kuniks näemegi foldi.
Hea töö!
Player
Chips
Progress
Urmo Velvelt
5,800,000
600,000
Võrdne seis Posted Sunday 30th July, 2023 at 15:08(UTC+0) by Mariliis Joras
Player
Chips
Progress
Kai E. J. Lehto
6,200,000
2,200,000
Phil Gross
5,600,000
3,000,000
Urmo Velvelt
5,200,000
900,000
4. koht Ville-Matti Keränen 34 900 € Posted Sunday 30th July, 2023 at 15:03(UTC+0) by Mariliis Joras
Nüüd lähevad soomlased omavahel sotte selgeks tegema.
Kai Lehto tõstab 250 000, mille peale Ville-Matti Keränen all-ini liigub.
Kail on taga natuke üle 4 miljoni ja Ville 2,3 miljonit saab selle kaardiga ära callida küll.
Kail
Villel
Kaardijumal potsatab floppi kümne ja turn ega river seisu enam ei muuda.
Oleme jõudnud TOP 3-ni!
Player
Chips
Progress
Ville-Matti Keränen
0
0
14:58 (UTC+0)
Start of Level 31 Blinds: 75,000/150,000 Ante: 150,000
Ville duubeldab Posted Sunday 30th July, 2023 at 14:48(UTC+0) by Mariliis Joras
Ville-Matti Keränen soovib stäkki suurendada, sest hetkel on ta kõige pisem.
Urmo Velvelt on ees teinud tõste 200 000 ja Ville shoveb 1,8 miljonit sisse.
Kuigi ka Phil Gross oli Urmo tõste callinud, tema kolmandaks ei tule.
Villel ja Urmol
Kohe flopis Villel kaheksate paar, kuid turnis juba kolmik.
Urmo peab välja maksma.
5. koht Tarmo Tammel 25 600 € Posted Sunday 30th July, 2023 at 14:25(UTC+0) by Mariliis Joras
Tarmo Tammeli kukkumine on tõeliselt õnnetu.
Phil Gross on ees 3bettinud 500 000 ja Tarmo näeb käes -d. Väike mõttepaus, kuid sisse need nupud lähevad.
Keegi teine ei calli, aga Phil võtab oma -ga väljakutse vastu.
Lauda jooksevad
Alles river annab Philile rea.
Mehed suruvad kätt ja mänguga minnakse edasi.
Player
Chips
Progress
Tarmo Tammel
0
0
Žetoonide seis Posted Sunday 30th July, 2023 at 14:09(UTC+0) by maheaaatom
Player
Chips
Progress
Urmo Velvelt
6,100,000
700,000
Kai E. J. Lehto
4,000,000
700,000
Phil Gross
2,600,000
1,000,000
Ville-Matti Keränen
2,600,000
1,200,000
Tarmo Tammel
1,700,000
300,000
14:07 (UTC+0)
Start of Level 30 Blinds: 50,000/100,000 Ante: 100,000
Side-actionit Posted Sunday 30th July, 2023 at 13:53(UTC+0) by maheaaatom
High-Roller läheneb samuti lõppelahendusele, ülemisel korrusel on aga toimumas kaks turniiri.
250 € NLH Progressive Bountyl on 105 sisseostu, re-entry ammu lõppenud ning 27 mängijat veel laudades.
Põhiturniiri turboversioon on meelitanud kohale umbes 50 erinevat mängijat, sellega on veel võimalik liituda. Peagi jätkub ka põhiturniiri finaali ülekanne.
Viimane pausieelne käsi annab Tarmole duubli Posted Sunday 30th July, 2023 at 13:38(UTC+0) by maheaaatom
Phil ) tuleb buttonilt blinde "sööma", Tarmo () vastab SB-lt 620K all-in'iga. Sakslaselt call.
Pole just kiita seis...Aga seekord on pokkerijumal meie mehe poolt. Flopis on kolm ning Tarmol taas 1,4M.
Põhiturniir läks esimesele pausile.
Player
Chips
Progress
Tarmo Tammel
1,400,000
420,000
Urmole 1,3M pank Posted Sunday 30th July, 2023 at 13:34(UTC+0) by maheaaatom
Urmo () avab 175K-ga ning Phil ) vastab kolmpanusega. Urmolt call.
Flop on ning sakslane katsetab uuesti - bet 250K. Urmolt taas call.
Turni järel saab Grossil julgus otsa ning ta checkib kiirelt. Nõrkust haistval Urmol piisab teha pisike panus, et 1,3M pank endale saada.
Viie parima VPIP näitajad finaallauas Posted Sunday 30th July, 2023 at 13:26(UTC+0) by maheaaatom
See number (34%) on selgelt kõrgeim Grossil ning madalaim Urmol ja Villel (25%). Tarmo ja Kai VPIP on 28%.
6. koht - Mikael Johannes Haapaniemi 19300 € Posted Sunday 30th July, 2023 at 13:21(UTC+0) by maheaaatom
Urmo () avab 175K-ga, Phil Gross ) tuleb kaasa.
BB-l istuv Mikael Johannes Haapaniemi ei löö aga kartma, vaid läheb oma 1,4M stäkiga all-in.
Urmo foldib kiirelt, kuid sakslane, kes on teinud varemgi võrdlemisi loogikavastaseid käike ... callib!
Flopis ongi poiss ning Gross võtab turniiri pikalt juhtinud Haapaniemi välja!
Player
Chips
Progress
Phil Gross
3,600,000
1,500,000
Mikael Johannes Haapaniemi
0
0
Urmo duubeldab läbi Tarmo Posted Sunday 30th July, 2023 at 13:10(UTC+0) by maheaaatom
Telelauas mängitakse väga suur käsi.
Phul Gross () avab 175K-ga, Tarmo kolmpanustab CO-lt 555K (), kuid BB-l istuval Urmol on !
Urmo ei taha midagi juhuse hooleks jätta ja läheb kohe all-in. Tarmol on ülimalt raske foldida ning call tuleb võrdlemisi kiirelt.
Flopis on (Phil oleks saanud kaks paari!), turn annab Tarmole mastitõmbe. River tagab võidu aga ikkagi Urmole.
Urmol nüüd 5,4M, Tarmol jääb 980K järgi.
Player
Chips
Progress
Urmo Velvelt
5,400,000
2,700,000
Tarmo Tammel
980,000
2,620,000
Milline on tiimide hetkeseis? Posted Sunday 30th July, 2023 at 13:05(UTC+0) by maheaaatom
"Antikaisen Opetuslapset" on endiselt edetabeli tipus ning paistab, et nende võitu ei kõiguta enam miski.
Eesti tiimidest on edukaim "Oskari Jooks" (hetkel kolmandad) aga High-Rollerilt on tulemas lisapunkte (Ranno ja Markku). Edetabel on seisuga täna kell 11:30.
Eesti tiimidest on hetkel "rahades" ka "Diamonds are Forever" (Mjagkov, Smeljov, Petrov, Dudakov). Aga vahed on väikesed.
Stäkkide seis Posted Sunday 30th July, 2023 at 12:52(UTC+0) by maheaaatom
Player
Chips
Progress
Ville-Matti Keränen
3,800,000
200,000
Tarmo Tammel
3,600,000
0
Kai E. J. Lehto
3,300,000
105,000
Urmo Velvelt
2,700,000
60,000
Phil Gross
2,100,000
400,000
Mikael Johannes Haapaniemi
1,500,000
800,000
12:50 (UTC+0)
Start of Level 29 Blinds: 40,000/80,000 Ante: 80,000
7. koht - Tomi Tapani Arponen 13400 € Posted Sunday 30th July, 2023 at 12:44(UTC+0) by maheaaatom
965K stäkiga Tomi Arponen lükkab oma nupud keskele (). Tarmo Tammel leiab , kuid ei tõtta sugugi kiirelt vastu all-in lükkama, vaid mõtleb, kas kuidagi õnnestuks ka Kai sisse meelitada.
Lõpuks Tarmo "vaid" callib, kuid Kail on niivõrd kehv kaart, et ta foldib kiirelt ega lähegi mingit actionit otsima.
Flop annab Tomile pisikesed võimalused panga poolitamiseks (rida või mast), kuid turni järel on ta drawing dead.
Tarmol nüüd 3,6M.
Player
Chips
Progress
Tarmo Tammel
3,600,000
700,000
Tomi Tapani Arponen
0
0
8. koht - Magnus Pukk 10 100 € Posted Sunday 30th July, 2023 at 12:37(UTC+0) by maheaaatom
Magnus avab 120K tõstega, Ville paneb natuke juurde (205K) ja Magnus callib.
Flop on
Ville avab 140K-ga, Magnus (1,4M) vastab aga all-in'iga. Villelt kiire call.
Magnus:
Ville:
Turn ja river meie meest ei päästa. Milline cooler!
Player
Chips
Progress
Ville-Matti Keränen
4,000,000
2,600,000
Magnus Pukk
0
0
Urmo suudab ka AK foldida Posted Sunday 30th July, 2023 at 12:29(UTC+0) by maheaaatom
Tarmo Tammel () avab 120K, Magnus () tõstab panused 280K-le ning tagatipuks lükkab Ville ) veel otsa - 430K.
BB-l istub aga Urmo , kes - uskuge või mitte - foldib.
Magnus aga asja niisama ei jäta, vaid callib.
Flop on Villele ideaalne. Ta panustab küll vaid 140K, kuid see on piisav, et Magnus foldiks.
Aga Urmo AK-fold on siiski tähelepanuväärne. Ju olid riidid väga hästi paigas. Ja tagatipuks tuleb tunnistada, et väga hea fold.
Sakslane duubeldab Posted Sunday 30th July, 2023 at 12:19(UTC+0) by maheaaatom
Haapanieme avab 120K (), chipliider Kai lükkab veel otsa - 320K. Phil Gross läheb oma stäkiga (700K) seejärel all-in ning pot committed Kai peab callima.
Phil:
Kai: . Lauda pudi, soomlane on juba pärast turni drawing dead.
Grossil nüüd 1,7M. Kai juhib endiselt (3,2M), kuid vahe eestlastega on vähenenud.
Player
Chips
Progress
Kai E. J. Lehto
3,200,000
205,000
Urmo Velvelt
2,600,000
40,000
Tarmo Tammel
2,500,000
400,000
Phil Gross
1,700,000
700,000
9. koht - Nils Jakob Elias Linden 7700 € Posted Sunday 30th July, 2023 at 12:15(UTC+0) by maheaaatom
Shortstäkiga (690K) Jakob lükkab -ga ning saab calli Magnus Puki -lt.
Jakobile lauas küll mastitõmme, kuid lauda lisandub ka kaks ässa.
Magnusel nüüd 2,1M. Väga hea!
Player
Chips
Progress
Magnus Pukk
2,100,000
675,000
Nils Jakob Elias Linden
0
0
Kaks väikest panka Tarmo ja Urmo vahel Posted Sunday 30th July, 2023 at 12:10(UTC+0) by maheaaatom
Urmo ja Tarmo mängivad omavahel kaks väikest panka, mis üldpilti küll väga palju ei muuda.
Esimesel korral teeb Tarmo tõelise hero-calli. Lauas , Tarmol , Urmol . Ju paistis ikka väga blufi moodi.
Teisel korral on hoopis Tarmol ning Urmol pisut nõrgem . Flopis on äss, kuid panused taas väga väikesed. See pank seega juba Tarmole.
Ville pääseb "auku" reaga Posted Sunday 30th July, 2023 at 11:56(UTC+0) by maheaaatom
Tarmo Tammel () avab 120K, Ville lükkab oma shortstacki all-in 610K ning sama teeb ka Tomi (1,6M). Tarmo loobub.
Ville:
Tomi:
Flop vaid kindlustab Tomi eduseisu, turn ei muuda samuti midagi.
. Kas esimene langeja? Villel on aga neli outi "auku rea" saamiseks ning üks neist - - sajab ka riverisse.
Player
Chips
Progress
Ville-Matti Keränen
1,400,000
670,000
Finaal algas Posted Sunday 30th July, 2023 at 11:19(UTC+0) by maheaaatom
Just mõni minut tagasi läks alumisel korrusel käima Summer Showdown põhiturniiri finaal.
Selleks, et vaatajatel oleks huvitavam põhiturniiri jälgida, toimub blogi sünkroonis TV-lauaga ehk 30-minutilise viivitusega. Kes aga januneb kohe pokkeriactioni järele, võib juba nüüd avada High-Rolleri finaali blogi.
Finaali blogi ja TV-ülekanne algab umbes kell 13:42.
Player
Chips
Progress
Kai E. J. Lehto
3,405,000
203,000
Tarmo Tammel
2,900,000
558,000
Urmo Velvelt
2,640,000
25,000
Mikael Johannes Haapaniemi
2,300,000
170,000
Tomi Tapani Arponen
1,665,000
130,000
Magnus Pukk
1,425,000
180,000
Phil Gross
1,000,000
360,000
Nils Jakob Elias Linden
840,000
150,000
Ville-Matti Keränen
730,000
0
Ja ongi finaallaud koos Posted Sunday 30th July, 2023 at 10:49(UTC+0) by maheaaatom
Finaalpäeva shortstack Tapio Ilmari Aaltonen küll eile natuke venitas mängu, kuid erilist tulemust sel ei olnud - pigem stäkk vähenes ning alustada tuli ikkagi selgest kaotusseisust.
Enam polnud aga venitada midagi ning Aaltonenil tuli üsna kiirelt nupud sisse lükata. Call tuli Tarmo Tammelilt.
Aaltonen:
Tarmo:
Lauda .
Finaallaud on sellega koos ning me kolime peagi kasiinosse. See tähendab vähemalt poole tunnist pausi, misjärel algab action juba TV-lauas.
Player
Chips
Progress
Tapio Ilmari Aaltonen
0
0
Sakslane mängib eelkõige inimesi, mitte kaarte Posted Sunday 30th July, 2023 at 10:43(UTC+0) by maheaaatom
Seda arvas eile õhtul Tarmo Tammel, kes mängis Phil Grossi vastu päris mitu huvitavat kätt.
Igatahes esimeses suures jaotuses annab Gross Haapaniemile umbes 350K ära. Turni järel sakslane murdub, kuigi praeb eelnevalt omajagu oma vastast ning katsub viimaselt sõnu välja pigistada. Grossi strateegia on pea alati sarnane - keerulistes kohtades alustab ta vastasega juttu, jälgides vastuseid, kehkeelt ja muud.
Gong on kõlanud! Posted Sunday 30th July, 2023 at 10:33(UTC+0) by maheaaatom
TOP10 on laudades ning kaardid läinud liikvele.
Täna on kavas veel High-Rolleri finaal (algab kell 13:00, saab jälgida läbi eraldi live-blogi), 250 € NLH Progressive Bounty (juba alanud, hetkel kohal umbes 50 mängijat) ning põhiturniiri turboversioon (sisseost 150 €, algab kell 14:00).
Neljas päev algab kell 12:30 Posted Sunday 30th July, 2023 at 10:15(UTC+0) by maheaaatom
Mängu algus natuke venib, alustatakse kell 12.30.
Mõlemad lauad pannakse käima ülemisel korrusel ning kui finaallaud on selge, siis kolitakse kasiinosse.
10:15 (UTC+0)
Day 4 of Kings of Tallinn Summer Showdown 2023 Started Level: 28 Blinds: 30,000/60,000 Ante: 60,000
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.