Kings of Tallinn - Kings of Tallinn Summer Showdown 2023 - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_est_2023/1B/updates'
ORDER BY `views` DESC

0.0100 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_est_2023/1B/updates'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0004 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0040 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0006 SECONDS: 
SELECT tour_stop_blogs.*, 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.logo as tour_stop_logo, 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 `friendly_url` = 'summer_showdown_main_est_2023'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'

0.0290 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0077 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '82'
AND `published` = 1

0.0286 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '84'
AND `published` = 1

0.0290 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1

0.0288 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1

0.0287 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '93'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
AND `name` = '1B'

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '84'
ORDER BY `busted` ASC, `current_chips` DESC

0.0072 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` = '84'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '3871'
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` = '3868'
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` = '3867'
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` = '3865'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3864'
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` = '3863'
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` = '3861'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3860'
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` = '3859'
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` = '3855'
ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3854'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3853'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3851'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3850'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3848'
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` = '3844'
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` = '3842'
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` = '3841'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3839'
ORDER BY `chip_change` DESC, `busted` ASC

0.0067 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3837'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3836'
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` = '3834'
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` = '3833'
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` = '3832'
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` = '3829'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3827'
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` = '3826'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3824'
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` = '3821'
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` = '3819'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3818'
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` = '3817'
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` = '3815'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3813'
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` = '3812'
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` = '3810'
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` = '3806'
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` = '3804'
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` = '3802'
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` = '3801'
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` = '3798'
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` = '3797'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3796'
ORDER BY `chip_change` DESC, `busted` ASC

0.0083 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3794'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3793'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3792'
ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3791'
ORDER BY `chip_change` DESC, `busted` ASC

0.0082 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '84'
ORDER BY `busted` ASC, `current_chips` DESC

0.0083 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` = '84'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0132 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3871'
ORDER BY `chip_change` DESC, `busted` ASC

0.0108 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3868'
ORDER BY `chip_change` DESC, `busted` ASC

0.0126 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3867'
ORDER BY `chip_change` DESC, `busted` ASC

0.0128 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3865'
ORDER BY `chip_change` DESC, `busted` ASC

0.0128 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3864'
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` = '3863'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3861'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3860'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3859'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3855'
ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3854'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3853'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3851'
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` = '3850'
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` = '3848'
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` = '3844'
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` = '3842'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3841'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3839'
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` = '3837'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3836'
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` = '3834'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3833'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3832'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3829'
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` = '3827'
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` = '3826'
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` = '3824'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3821'
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` = '3819'
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` = '3818'
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` = '3817'
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` = '3815'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3813'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3812'
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` = '3810'
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` = '3806'
ORDER BY `chip_change` DESC, `busted` ASC

0.0064 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3804'
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` = '3802'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3801'
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` = '3798'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3797'
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` = '3796'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3794'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3793'
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` = '3792'
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` = '3791'
ORDER BY `chip_change` DESC, `busted` ASC

0.0057 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.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) Live Reporting - Day 4

Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

Current Level 32 Current Day 4

Blinds 100,000/200,000 Ante 200000

Entries 564 Remaining 1

Prize Pool (EUR) €530,160 First Prize (EUR) €108,260

Chip Leaders Day 4

1	Kai E. J. Lehto		17,000,000

Day 1A Day 1B Day 2 Day 3 Day 4

1 New Update - Click to refresh

Live Updates - Day 1B

Päeva 1C tulemused Posted Friday 28th July, 2023 at 06:53(UTC+0) by maheaaatom

Päevast 1C pääses ainsa eestlasena edasi Hendrik Uibo (33200). Sisseoste kogunes 70 ning kokku elas päeva üle 31 mängijat.

Turniiri auhinnapotis hetkel 437 100 eurot, kuid veel on võimalik kahe mängutaseme jooksul sisseoste teha.

Eestlaste stäkid päeva 1B järel Posted Thursday 27th July, 2023 at 19:21(UTC+0) by maheaaatom

Päeva 1B kaheksa parima seas on täpselt neli eestlast, seega tasub lugeda päeva kordaläinuks. Kokku pääses teise päeva 19 eestlast.

Kaspar Laursoo, 208 700
Mauri Dorbek, 207 400
Markku Koplimaa, 160 500
Igor Pihela noorem, 149 100
Keito Kaljulaid, 125 400
Ilya Nikiforov, 96 900
Sten Talviste, 87 900
Jaana Kindsigo, 75 900
Kaido Koorits, 64 400
Andrei Mjagkov, 53 400
Aleksandr Kuperman, 51 700
Herli Olop, 49 300
Kaidar Viikman, 46 700
Paul Koppe, 41 000
Maksim Petrov, 32 500
Priit Vanem, 30 000
Mart Tammoja, 28 400
Tarmo Tammel, 20 200
Kaius Kiidli, 18 800

Sellega ma tänaseks lõpetame, 1C tulemused saate teada homses kokkuvõttes. Oleme tagasi Olympic Park Casinos täpselt kell 12:00!

Jaana ründab viimasel käel Posted Thursday 27th July, 2023 at 18:51(UTC+0) by maheaaatom

Viimasel käel paugutab üks shortstack soomlane all-in ning sama käigu teeb ka Jaana Kindsigo, kelle stäkk on langenud pisut alla keskmise.

Soomlane avab , Jaanal on . Ja see peab ka kenasti vastu.

Chipid aeti kottidesse ning peagi avaldame me kõikide allesjäänud Eesti mängijate täpse punktiseisu.

Kolm viimast kätt Posted Thursday 27th July, 2023 at 18:35(UTC+0) by maheaaatom

Diilerid alustasid kolme viimase käe jagamist, mille järel saab päev 1B läbi. See on nüüd shortstäkkide absoluutselt viimane võimalus lükkama hakata!

Ranno tujutu õhtupoolik Posted Thursday 27th July, 2023 at 18:33(UTC+0) by maheaaatom

Ranno Sootla, kes on harjunud tempoka, aktiivse ja pingelise mänguga, oli sunnitud kogu 1B lihtsalt läbi tiksuma. Korra õnnestus küll oma väike stäkk ässadega duublisse saada (vist ainus korralik käsi täna), kuid äsja jäi Ranno ka sellest ilma. Olevat tõmbelt lükanud ning saanud calli kuningas-kõrgelt. Tõmmet kohale ei tulnud.

Kas uuele katsele 1C-l või teisel päeval. "Ei tea veel, vaatame," vastab Ranno ja marsib turniirialalt välja.

Mauril kõik hästi Posted Thursday 27th July, 2023 at 18:22(UTC+0) by maheaaatom

Mauri Dorbek palub öelda, et tal on 100K ning kõik hästi.

Igor Pihela noorem on veel natuke juurde hankinud ning umbes 150K peal. "Lõbusas" lauas on nii Jaanal, Kaidol kui Kaidaril napilt üle keskmise stäkk, seega samuti hästi.

Eestlastest endiselt rikkaim Kaspar Laursoo umbes 230K-ga.

Viimane mängutase Posted Thursday 27th July, 2023 at 18:01(UTC+0) by maheaaatom

Alanud on viimane mängutase ehk aeg, mil shortstäkkidel tuleb asuda duubleid otsima. Pole ju erilist pointi alustada teist päeva mingi 7K stäkiga, mõistlikum siis juba teha re-entry ja saada 30K punkti.

Auhinnafondis on 374 120 eurot, mis tõenäoliselt 1B jooksul enam väga ei kerki, kuid täieneb kindlasti juba täna õhtul ja homme lõunal. Pool miljonit eurot on endiselt vägagi realistlik eesmärk.

17:58 (UTC+0)

Start of Level 8
Blinds: 500/1,000 Ante: 1,000

Ranno leiab ässad Posted Thursday 27th July, 2023 at 17:57(UTC+0) by maheaaatom

Kõvasti kisa kostab kümnendast lauast. Ranno istub oma 8,5K stäkiga BB-l ning enne teda on tehtud 2,5K tõste ning ka 6,5K ületõste. Ranno kütab nupud sisse, algne tõstja foldib ning ületõstja mõistagi callib.

"I did it," hõiskab Ranno, tõuseb püsti, ajab koti selga ning valmistub minekuks. Ja avab ka kaardid: ! Vastas on , mis saavad küll enne riverit "auku" tõmbe, kuid ässad peavad siiski vastu.

Ranno on täna mänginud väga silmapaistmatult, küllap pole ka olnud mitte mingisugust kaardijooksu. Endiselt tema kõrval istuval Herli Olopil läheb mõnevõrra paremini, tal endiselt üsna keskmine stäkk.

Neli suurima stäkiga eestlast Posted Thursday 27th July, 2023 at 17:47(UTC+0) by maheaaatom

Oleme jätnud tähelepanuta Kaspar Laursoo, kes on selgelt suurima stäkiga eestlane ning hetkel umbes 220K peal. Eriti võimsa panga sai ta äsja Jukka Ylitalo elimineerimisega (PFAI vs. ).

Markku Koplimaal on umbes 130K, Igor Pihela nooremal 130K ning Sten Talvistel 110K.

Auhinnafondis juba 366 600 eurot Posted Thursday 27th July, 2023 at 17:27(UTC+0) by maheaaatom

Auhinnafond jätkub paisumist, juba on sinna kogunenud 366 600 eurot. Tuletame meelde, et mänguga liitumiseks on veel kolm võimalust.

1) Päev 1B (täna on mängida ligikaudu 90 minutit)

2) Päev 1C (algab kell 21:00)

3) 2. päev (reede) - liituda saab kuni teise mängutaseme lõpuni, umbes kell 14:15.

Tarmo Tammelile re-entry Posted Thursday 27th July, 2023 at 17:19(UTC+0) by maheaaatom

Nii eile kui täna üsna kena stäki kokku saanud Tarmo Tammel (eile 80K, täna 100K) peab ikkagi re-entry järele minema.

Tänane suur stäkk oli läinud kahe käega - esimesel korral ei tulnud tõmme kokku ning teisel sattus ta mastivõimalusega lauas top-paariga flopanud rea vastu. Lisaks olla ka prillid katki läinud. Paha päev, kuid õnneks pole see veel läbi.

Algas viimane vaatus Posted Thursday 27th July, 2023 at 17:08(UTC+0) by maheaaatom

Päeva 1B viimane mängutsükkel (tasemed 7 ja 8) on alanud, niisamuti on läinud käima 250-eurone Sviten Special (esialgu küll vaid 21 mängijat ning ainsaks eestlaseks Heiti Riisberg).

Ei paista, et põhiturniiril oleks midagi eestlaste osas väga muutnud, vaid Kaido Koorits on saanud duubli ja tõusnud umbes 70K peale. Välja on langenud Martin H. ja Rasmus Parts.

17:02 (UTC+0)

Start of Level 7
Blinds: 400/800 Ante: 800

Paul saab ootamatu võidu Posted Thursday 27th July, 2023 at 16:33(UTC+0) by maheaaatom

Lauas on avatud ilma mastivõimaluseta. Pangas on päris kenake summa ja Paul teeb pärast riverit 7500 panuse. Vastane mõtleb natuke, otsustades viimaks siiski callida.

Paul avab -äss kõrge. Avab kohe väga vastumeelselt. Vastane vaatab lauda, vaatab oma kaart ja muckib kinniselt.

Paul on enam kui üllatunud. "Hea, et ma esimesena ei muckinud," tõdeb mees. Turniir viimasele pausile.

Torkas või donkas? Posted Thursday 27th July, 2023 at 16:05(UTC+0) by maheaaatom

Markku Koplimaa on oma stäkki järk-järgult kasvatanud ning jõudnud umbes 100K-ni. Ka Tarmo Tammelil sujub kenasti, temal nüüd umbes 80K.

Lõbusas lauas, kus peamisteks rääkijateks Jaana Kindsigo, Kaidar Viikman ning üks välismaalane (keda Jaana kogu aeg aasib), sai duubli Kaido Koorits. Kuningad vs. kaheksad, kuid Kaido sai sellega ainult napi algstäki peale tagasi.

Jaana oli jaotuse ajal hõivatud oma peamiste "sõpradega" rääkimisega ning uuris hiljem Kaidolt, et millal nupud läksid.

"Kohe donkas sisse," vastas Kaido.

"Torkas sisse?" ei kuulnud Jaana täpselt vastust.

"Ei, ma ütlesin, et donkas," vastas Kaido.

"Nojah, donkas muidugi. Ma ei saanud aru, et mis mõttes torkas!?" lõpetas Jaana. Laual taas lõbu laialt.

15:50 (UTC+0)

Start of Level 6
Blinds: 300/600 Ante: 600

Kui menukaks kujuneb päev 1C? Posted Thursday 27th July, 2023 at 15:49(UTC+0) by maheaaatom

Täna õhtul kell 21:00 algab stardipäev 1C, mis mängitakse turbo-formaadis. Mängutasemeid on samuti kaheksa, seega mingit eelist tava- või turboformaat ei oma.

Kui palju võiks sinna aga mängijaid tulla? Igor Pihela arvab, et tuginedes varasematelt kogemustele (iseäranis EMV põhiturniir) ei pruugi ülearu palju mängijaid tulla, kuid ta mainib, et võib vabalt ka eksida. Igori kõrval istuv Paul Koppe arvab seevastu, et tegelikult peaks just nimelt 1C-l osalema. "Paremad mängijad saavad kõik 1A-lt või 1B-lt edasi ning 1C tase peaks seega nõrgem olema," kõlab Pauli igati loogiline põhjendus.

Eilne mark ületatud Posted Thursday 27th July, 2023 at 15:34(UTC+0) by maheaaatom

1B sisseostude arv on kasvanud juba 190-ni ning eilne mark (188) sellega kindlalt ületatud. Puhast mänguaega on päeval 1B veel tubli kolm tundi.

Deep-stacki lõpptulemuseks jäi 181 sisseostu ning mäng käib 37430 eurole. Törts väiksema, 150-eurose Texas/Omaha late reg. saab ka peagi läbi ning hetkel on tehtud (vaid) 51 sisseostu. Kas tõesti liiga "odav" turniir?

Täna on kavas veel 250 € SVITEN Special, millele antakse stardipauk kell 19:00. Loomulikult ka satelliidid, Flip & Go'd ja rahamäng.

Mis värk nende telefonidega on? Posted Thursday 27th July, 2023 at 15:08(UTC+0) by maheaaatom

Kindlasti on paljudele pealtvaatajatele jäänud silma, et suur osa mängijatest näpib jaotuste vahelisel ajal oma telefone (n.ö. "käes olles" on telefoni kasutamine ning mitte-inglise keeles suhtlemine keelatud).

Milleks telefone kasutatakse? Mõni vaatab (pokkeri)videosid, mõni spordiülekandeid, paljud loevad ka ülekannet. Leidub ka uudiste lugejaid ning neidki, kes lausa mõnda filmi vaatavad või (eriti harvadel juhtudel) ka pokkerit või suisa kasiinomänge mängivad.

Enamasti suheldakse aga sõpradega. Paljudel tõsisematel (iseäranis elukutselistel) mängijatel on omad messengeri-grupid, kuhu pannakse kirja põnevaid mängitud käsi, bad beate ning punktiseise. Aga ühendust hoitakse ka pereliikmetega. Et kas laps on heas tujus ja koer söönud. Ja loomulikult peavad ka pereliikmed kõikide bad beatidega kursis olema!

Loeme raha Posted Thursday 27th July, 2023 at 15:01(UTC+0) by maheaaatom

Viienda tasemeni jõudnud põhiturniir on veel algfaasis (keskmine stäkk 75XBB), mistõttu ei tasuks mängijate punktiseisudest veel pikaleulatuvaid järeldusi teha. Aga mõnede keskmisest suuremate eestlaste numbrid siiski:

Sten Talviste, 90000
Tarmo Tammel, 72000
Kaspar Laursoo, 67000
Jaanus Veste, 60000
Herli Olop, 50000
Mauri Dorbek, 50000

Millal ületatakse eilse päeva tulemus? Posted Thursday 27th July, 2023 at 14:45(UTC+0) by maheaaatom

Kui eile mängitud päeval 1A tehti 188 sisseostu, siis täna on neid kogunenud juba 174 ning päev on alles poole peal. Seega pole küsimus niivõrd selles, kas eilne tulemus ületatakse, vaid MILLAL see ületatakse.

Auhinnafondis on juba magusad 340 280 eurot, seega on küll, mille nimel mängida.

Kasiinos kogub tuure cashgame, samuti seatakse üles telelauda. Teleülekannet saab nautida alates homsest.

Keeruline laud Posted Thursday 27th July, 2023 at 14:40(UTC+0) by maheaaatom

Kui enamus mängijatest tegid pausi ajal suitsu, käisid söömas või flippamas, siis pokkeriprofid (Paul, Ranno, Kaido jt.) mängisid näiteks hoopis Politseipargis palli. Seegi mõnus vahepala!

Herli kurtis, et tema laud (nr. 10) on muutunud väga raskeks. "Lambaid siin ei ole, kõik on head mängijad. Isegi Ranno (kes istub Herli kõrval) on suhteliselt rahulik. Tuleb oma kohta oodata."

14:37 (UTC+0)

Start of Level 5
Blinds: 200/500 Ante: 500

Gamblema! Posted Thursday 27th July, 2023 at 14:19(UTC+0) by maheaaatom

Põhiturniiril osalejad lasti puhkama ning mõistagi saab pausi ajal ka flipata.

Flippamisel on kindlasti pointi, sest juhul kui peaks õnnestuma oma jaotus võita, siis ootab sind koht laupäevases finaalis. Ja seal on sulle kindlustatud:

Hendoni cash
Võimalus võita 5000-eurone pearaha
Osaleda turniiril, millele GGPoker lisab 10 000 eurot!

"Odav" NLH/PLO/PLO5 kogub hoogu Posted Thursday 27th July, 2023 at 14:01(UTC+0) by maheaaatom

Juba tunnike on käinud vaid 150-eurose osalustasuga NLH/PLO/PLO5, mis viiakse läbi väikeses konverentsiruumis (tuntud ka kui "Las Vegas").

Hetkel on osalejaid küll vaid 18, kuid liituda saab umbes kell poole kuueni. Seevastu 250-eurose deepstackil on jõutud juba 132 osalejani. Põhiturniiri hüpersatikas on läbi, eestlastest sai pileti Hendrik Uibo, kes ka kohe põhiturniiril istet võttis.

Ässad saabuvad Posted Thursday 27th July, 2023 at 13:53(UTC+0) by maheaaatom

Just saabusid turniirialale Ranno Sootla, Kaido Koorits ning Paul Koppe, samuti mees, kes vaid harva rahadesse ei jõua - Andrei Mjagkov.

Kahjuks on küll turniirilt väljas ka teine eestlanna Triinu Ammusaar, kel pole sarnaselt Helinale samuti re-entry plaanis.

Helina Tamm mängust väljas Posted Thursday 27th July, 2023 at 13:40(UTC+0) by maheaaatom

Neljanda taseme alguses kaotasime kahjuks Helina Tamme, kes ei suutnud oma pocket ässadega vastase kümnetest jagu saada. Olla teine kohusetundlikult maksnud ning riveril masti saanud...

Helina plaanib mängida ka teistel Summer Showdown turniiridel, kuid Mainil tõenäoliselt enam mitte.

Noorem Pihela nelikuga mängus tagasi Posted Thursday 27th July, 2023 at 13:22(UTC+0) by maheaaatom

Samuti täna uuele katsele tulnud Igor Pihela noorem liigub nagu Ameerika mägedel. Kohe esimese käega pani ta hakkama 19K ning paistis, et tuleb juba re-entry't tegema minna.

Aga ei, pisut hiljem õnnestus Igoril saada kena duubel. Nimelt tuli tema pocket kümnetele lauas kaks kümmet lisa. "Ma siin kaotan pidevalt nelikutele, lõpuks jagatakse see mulle ka," on Igor rahul (eile sai ta tõepoolest väga valusa kaotuse top maja vs. nelik).

13:18 (UTC+0)

Start of Level 4
Blinds: 200/400 Ante: 400

300 tonni on koos! Posted Thursday 27th July, 2023 at 13:18(UTC+0) by maheaaatom

Kohe algab tänane neljas mängutase ning auhinnafond on juba kerkinud 300 tuhande euroni. Täna 132 sisseostu nming hetkel laudades 121 mängijat. Veel on ruumi viieks-kuueks lauaks.

Herli meelitas soomlase lõksu Posted Thursday 27th July, 2023 at 13:05(UTC+0) by maheaaatom

Kümnendas lauas on Herlil rahulolev ilme. "Lootsin, et kuus päeva kestev kaardisurm võiks põhiturniiril ju ometi lõppeda ja lõpuks saingi ühe korraliku käe."

Nimelt jagati talle ning flop lausa ideaalne . Intriigi suurendasid ka turn ja river , pärast mida ei suutnud oma -ga rea saanud soomlane Jari Pekka Hurri enam kuidagi foldida.

Herlil umbes 65K.

Liiga palju respecti Posted Thursday 27th July, 2023 at 12:52(UTC+0) by maheaaatom

Tarmo Tammel on tuntud mängumees nii Eestis kui ka lähiregioonis ning usutakse, et niisama ta kunagi ei lahmi. Samas ei tähenda see aga seda, et Tarmo kunagi ei blufiks.

Heaks näiteks on äsja mängitud käsi, kus Tarmo lükkas all-in pärast lauas avatud kaarte . Leedulane mõtles pikalt, foldides viimaks avatult . Tarmol oli . Pärast turni suurepärane tõmme, kuid riverist talle mingit kasu polnud. Kuid lõppude lõpuks, mis seal vahet on - pank tuli ju Tarmole!

Pausiga lisandus palju uusi mängijaid Posted Thursday 27th July, 2023 at 12:25(UTC+0) by maheaaatom

Pausi jooksul liitus põhiturniiriga tubli 15 mängijat, nende seas ka Eesti suurim turniiristaar Markku Koplimaa.

Markku näitas eile väga sisukat mängu 8-Game'is, kus saavutas tubli neljanda koha. Muide, 8-Game osutus üldse väga populaarseks, sisseoste oli koguni 110. Nii, et leidub neid sagemängude austajaid küll.

Markku plaanib Summer Showdownil väga aktiivselt mängida ning "Oskari-tiimile" ka palju punkte tuua.

Vahepeal saadi viimaks käima ka 20-eurone subsatikas ning 250-eurose deepstacki osalejate arv on juba liginemas sajale.

12:22 (UTC+0)

Start of Level 3
Blinds: 100/300 Ante: 300

Esimene paus Posted Thursday 27th July, 2023 at 12:03(UTC+0) by maheaaatom

Põhiturniiril on esimesed kaks mängutaset läbi ning osalejad saavad minna jalgu sirutama. Midagi kuigi olulist esimese 120 minuti jooksul toimunud ei ole, sisseoste on kogunenud 87 ning turniiri auhinnafond on ületanud veerand miljoni euro piiri.

Vaheajal ootavad mängijaid mõistagi ka 150-eurosed flipid.

Esimene langeja põhiturniiril päeval 1B Posted Thursday 27th July, 2023 at 11:44(UTC+0) by maheaaatom

Põhiturniiril teisel stardipäeval kulus tubli poolteist tundi esimese langejani. Õnnetuks osutus üks lõunanaaber.

Hetkel on laudades 77 mängijat ning vaikselt lisandunub ka uusi alustajaid. Eesti naiste ridu täidab nimekas turniiriäss ning endine netipro Helina Tamm, kes on lauas rõõmus nagu alati. Samuti jõudis just kohale ka Herli Olop.

Satelliit ootab mängijaid Posted Thursday 27th July, 2023 at 11:40(UTC+0) by maheaaatom

Väikeses saalis pidi kell 13:00 algama järjekordne 20-eurone reigivaba subsatikas 5000 € High-Rollerile ning diileridki on kenasti laudades ootamas, kuid turniir alga siiski enne, kui on kogunenud 12 mängijat.

Hetkel on mängijaid 9 ning oodatakse veel kolme inimest, et saaks mängu lõpuks käima panna.

Küll on üsna menukas 250 € deep-stack, kus juba 60 erinevat mängijat.

11:04 (UTC+0)

Start of Level 2
Blinds: 100/200 Ante: 200

Põhiturniiri esimene mängutase väljalangejaid ei toonud Posted Thursday 27th July, 2023 at 11:04(UTC+0) by maheaaatom

Põhiturniiril sai läbi esimene mängutase ning kõik hetkel alustanud 52 pokkerisportlast on endiselt laudades.

Eestlastest on lisandunud Sten Talviste, Mart Tammoja ja Dmitri Dudakov.

Vot see on tõeline team-spirit! Posted Thursday 27th July, 2023 at 11:01(UTC+0) by maheaaatom

Kolmapäeva hilisõhtu seisuga juhib tiimide arvestuses ülivõimsalt soomlaste sats "Antikaisen opetuslapset".

Võistkonna liider on Henri Antikainen, kes jäi meile hästi meelde eilselt Championship turniirilt. Tiimipunktide tõttu keeldus Henri igasugustest diilidest. Isegi siis, kui mängus olid sõna otseses mõttes kümned tuhanded. Lõpuks pidi mees Maikel Hominile alla vanduma, jäädes ilma nii rahast kui esikohapunktidest. Aga saak oli sellest hoolimata väga hea ning viis Antikaise tiimi vähemalt võistkondlikuks arvestuseks tabeli tippu.

Tiimivõistlusest võtab osa kümneid võistkondi ning viie parima satsi vahel läheb jagamisele 2% üldisest auhinnafondist. Eesti tiimidest on hetkel parim kolmandat kohta hoidev Oskari Jooks, kuhu kuuluvad pokkeriprofid Tõnis Viik, Oskar Ojaveer, Markku Koplimaa ja Ranno Sootla.

Tähelepanu Deep-Stacki austajad! Posted Thursday 27th July, 2023 at 10:51(UTC+0) by maheaaatom

Juba kümnekonna minuti pärast (kell 13:00) algab Summer Showdown Event #33 - 250 € NLH Deep Stack. Kuna turniir on suhteliselt väikese sisseostuga ja sügava struktuuriga, siis võib seda julgelt soovitada ka kõikidele hobimängijatele.

Alustatakse 30 000 punktiga, Mängitakse 30-minutiliste tasemetega (alustatakse 100/100), hiline regamine kestab 8 mängutaset.

Hüper-satikal 54 sisseostu Posted Thursday 27th July, 2023 at 10:44(UTC+0) by maheaaatom

Fuajees toimuval hüpersatikal on juba tehtud 54 sisseostu ning võitlus kolme põhiturniiri pileti nimel käib täiega hooga.

Võib eeldada, et enamus osalejatest plaanib nagunii põhiturniiril mängida, kuid miks mitte üritada võita turniiripilet kõigest 60 euroga!

Veel eestlasi Posted Thursday 27th July, 2023 at 10:31(UTC+0) by maheaaatom

Jaana pole sugugi ainus Eesti naismängija, kohal on ka Triinu Ammusaar Pärnust.

Samuti on turniiril "Waimu sõdalane" Martin H., suurturniiridel ikka ja jälle osalev Maksim Petrov ning ka Risto Pärnat.

Aga mängijaid liitub iga minutiga!

Uuele katsele Posted Thursday 27th July, 2023 at 10:26(UTC+0) by maheaaatom

Teiste seas on uuel katsel nii Mauri Dorbek, Jaana Kindsigo, Aleksandr Kuperman kui ka Tarmo Tammel.

Tarmo käis eile ka 80K peal ära ja kõik tundus sujuvat, kuid kahjuks lõpetasid tema päeva mitmed coolerid. "Tegin mitu väga head foldi, kuid kasu neist kokkuvõttes ikkagi ei olnud," räägib Tarmo ise.

Päev 1B on alanud Posted Thursday 27th July, 2023 at 10:13(UTC+0) by maheaaatom

Põhiturniiri teine päev on alanud. Hetkel on laudades veel kõigest 22 mängijat, mis tähendab seda, et action on veel väga noor.

Kuna ühtegi teist turniiri eilsest pooleli ei jäänud, siis valitseb ka turniirialal pigem üsna unine meeleolu. Küll toimub aga fuajees 60-eurone hüpersatikas, kus on garanteeritud kolm 1100-eurost põhiturniiri piletit.

10:11 (UTC+0)

Day 2A of Kings of Tallinn Summer Showdown 2023 Started
Level: 1 Blinds: 100/100 Ante: 100

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Your search results are valid for . More 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.

Browse

Useful Links

Subscribe to our newsletter