Kings of Tallinn - Kings of Tallinn 2024 - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0075 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_350_Tallinn_Cup_Est'
ORDER BY `views` DESC

0.0111 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_350_Tallinn_Cup_Est'

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

0.0003 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.0003 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.0035 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.0005 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` = '2024_KOT_350_Tallinn_Cup_Est'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'

0.0282 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0059 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '220'
AND `published` = 1

0.0279 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '223'
AND `published` = 1

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

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'
AND `name` = '2'

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

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

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` = '9933'
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` = '9680'
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` = '9640'
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` = '9639'
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` = '9637'
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` = '9636'
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` = '9634'
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` = '9633'
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` = '9631'
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` = '9628'
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` = '9626'
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` = '9625'
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` = '9623'
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` = '9622'
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` = '9621'
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` = '9620'
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` = '9618'
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` = '9617'
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` = '9615'
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` = '9614'
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` = '9613'
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` = '9612'
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` = '9611'
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` = '9610'
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` = '9609'
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` = '9608'
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` = '9607'
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` = '9606'
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` = '9605'
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` = '9604'
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` = '9603'
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` = '9602'
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` = '9600'
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` = '9599'
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` = '9598'
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` = '9597'
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` = '9596'
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` = '9595'
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` = '9594'
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` = '9593'
ORDER BY `chip_change` DESC, `busted` ASC

0.0082 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9592'
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` = '9591'
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` = '9590'
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` = '9589'
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` = '9588'
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` = '9587'
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` = '9586'
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` = '9585'
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` = '9584'
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` = '9583'
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` = '9582'
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` = '9581'
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` = '9580'
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` = '9579'
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` = '9578'
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` = '9577'
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` = '9576'
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` = '9575'
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` = '9574'
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` = '9573'
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` = '9572'
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` = '9571'
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` = '9570'
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` = '9569'
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` = '9568'
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` = '9567'
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` = '9566'
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` = '9565'
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` = '9564'
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` = '9563'
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` = '9562'
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` = '9561'
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` = '9560'
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` = '9559'
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` = '9558'
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` = '9557'
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` = '9556'
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` = '9555'
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` = '9554'
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` = '9553'
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` = '9552'
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` = '9551'
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` = '9550'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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` = '9933'
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` = '9680'
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` = '9640'
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` = '9639'
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` = '9637'
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` = '9636'
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` = '9634'
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` = '9633'
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` = '9631'
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` = '9628'
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` = '9626'
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` = '9625'
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` = '9623'
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` = '9622'
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` = '9621'
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` = '9620'
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` = '9618'
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` = '9617'
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` = '9615'
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` = '9614'
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` = '9613'
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` = '9612'
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` = '9611'
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` = '9610'
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` = '9609'
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` = '9608'
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` = '9607'
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` = '9606'
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` = '9605'
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` = '9604'
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` = '9603'
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` = '9602'
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` = '9601'
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` = '9600'
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` = '9599'
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` = '9598'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9595'
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` = '9594'
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` = '9593'
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` = '9592'
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` = '9591'
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` = '9590'
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` = '9589'
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` = '9588'
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` = '9587'
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` = '9586'
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` = '9585'
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` = '9584'
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` = '9583'
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` = '9582'
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` = '9581'
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` = '9580'
ORDER BY `chip_change` DESC, `busted` ASC

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9579'
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` = '9578'
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` = '9577'
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` = '9576'
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` = '9575'
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` = '9574'
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` = '9573'
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` = '9572'
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` = '9571'
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` = '9570'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9565'
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` = '9564'
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` = '9563'
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` = '9562'
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` = '9561'
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` = '9560'
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` = '9559'
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` = '9558'
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` = '9557'
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` = '9556'
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` = '9555'
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` = '9554'
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` = '9553'
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` = '9552'
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` = '9551'
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` = '9550'
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` = '9549'
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` = '9548'
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` = '223'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351

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

English

Kings of Tallinn 2024 Event #3: €350 Kings of Tallinn Cup (Estonian) Live Reporting - Day 2

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Current Level 28 Current Day 2

Blinds 50,000/100,000 Ante 100000

Entries 313 Remaining 1

Prize Pool (EUR) €92,680 First Prize (EUR) €0

Chip Leaders Day 2

1	Sven Otto Omland		9,396,000
2	Oskar Ojaveer		200,000

Day 1 Day 2

1 New Update - Click to refresh

Live Updates - Day 2

13:15 (UTC+2)

Day 2 of Kings of Tallinn 2024 Ended
Level: 28 Blinds: 50,000/100,000 Ante: 100,000

Turniiri võitis norralane Sven Otto Omland Posted Sunday 25th February, 2024 at 10:14(UTC+2) by maheaaatom

Kings of Tallinn 2024 350 € CUP-il osutus parimaks norralane Sven Otto Omland, kes teenis 19 200 eurot. Talle järgnesid neli soomlast, neist esimesena WSOP Circuit Tallinn suurim võidumees Akseli Paalanen. Nagu arvata võis, ei kulunud võitja selgitamiseks kaua aega - pärast Dmitri Dudakovi langemist kuuendalt kohalt vaid natuke üle tunni.

Sellega võime 350 € CUP-ile lõplikult joone alla tõmmata ning jätkata juba 555 € Championshipiga.

6. koht Dmitri Dudakov 4120 € Posted Saturday 24th February, 2024 at 23:39(UTC+2) by maheaaatom

Kui sul on 6XBB stäkk ja buttonil pocket neljad, siis mis seal ikka mõelda.

Call tuleb SB-l istuvalt Juhana Konttinenilt, kellel on .

Lauda

Seekord läks siis nii. Aga Dmitri tegi sisuka mängu ning kindlasti näeme teda sel festivalil veel.

Sellega lõpetame ka tänase ülekande, alles on neli soomlast ja üks norralane. Tõsi - üks soomlane on Eestis alati väga hästi mänginud Akseli Paalanen, kes sai ka WSOP Circuit põhiturniiril kõige suurema auhinnaraha. Aga kes neist täpselt võitis, saate lugeda juba homsest päevakokkuvõttest.

Kohtume homme kell 12:00, mil hakkame elama kaasa juba 555 € Championship turniirile.

Player		Chips	Progress
Dmitri Dudakov		0	0

Kuus parimat Posted Saturday 24th February, 2024 at 23:31(UTC+2) by maheaaatom

Saime veel ühe langeja - vahepeal turniiri kindlalt juhtinud Heikki Juhani Piira on mängust väljas. Tema hiigelstäkk läks suuresti juba pool tundi tagasi pocket üheksatega pocket poiste vastu.

Keskmine stäkk on 15XBB, Dmitril on kindlasti duublit vaja.

See hirmus blindiring Posted Saturday 24th February, 2024 at 23:25(UTC+2) by maheaaatom

BB peab nüüd välja panema juba 100K + 100K ehk umbes kuuendiku keskmisest stäkist.

Just "sõitis" see vanker üle Dmitrist, kes on nüüd umbes 700K peal. Seda on täpselt 7XBB, kuid tema õnneks pole ka konkurentide seis palju lihtsam.

23:24 (UTC+2)

Start of Level 28
Blinds: 50,000/100,000 Ante: 100,000

Karjed fuajees Posted Saturday 24th February, 2024 at 23:19(UTC+2) by maheaaatom

Fuajees käib kohtutav karjumine ja möll, kaugelt võis jääda mulje justkui oleks WSOP põhiturniiri viimases jaotuses kuningate nelik ässade neliku vastu jooksnud.

Tegelikult polnud asi kaugeltki nii hull, lihtsalt alkohol oli lauas oma töö teinud ning "rahvaturniiril" sattusid vastamisi ja . Lauda tuli kaks poissi ning ühtlasi ka neli potit.

"Peaks tegema nii, et see mast ei loe!" prahvatas Madis Müür, kes ise samuti sellele jaotusele vahetult kaasa elas.

Omaha satelliidil hoog sees Posted Saturday 24th February, 2024 at 23:06(UTC+2) by maheaaatom

Kui alguses paistis, et Omaha satelliidil tuleb kindel overlay, siis nüüd see päris nii enam ei tundu. Juba on 37 sisseostu tehtud ja mäng väga lahtine.

Ühes kuue mängija lauas oli äsja 5 mängijat all-in ning kui üks õnnelik oli kogu panga endale saanud, jäigi järgi täpselt kaks mängijat. "Kas me hakkame nüüd omavahel heads-up mängima," viskab üks neist nalja. Ei, laud lüüakse mõistagi laiali.

22:53 (UTC+2)

Start of Level 27
Blinds: 40,000/80,000 Ante: 80,000

Kaardipaki vahetus ja paus Posted Saturday 24th February, 2024 at 22:39(UTC+2) by maheaaatom

Dmitri Dudakov osutab kaardipakis olevale ruutu kaheksale, mis olevat tema mõistes äratuntav. Floor uurib pakki, midagi erilist neile silma ei hakka. Aga selles olukorras kasiino mängijatele muidugi vastu vaidlema ei hakka.

Lauda tuuakse kiirelt uus pakk, millega jõutakse mängida täpselt kaks jaotust, sest turniiri katkestab 15-minutiline paus. Viimase jaotusega korjab veel pisut lisa Dmitri, sundides vastased pangast loobuma. Tal nüüd 1,2M.

Player		Chips	Progress
Dmitri Dudakov		1,200,000	200,000

Iseseisuvuspäevaturniiril 345 sisseostu Posted Saturday 24th February, 2024 at 22:29(UTC+2) by maheaaatom

Kinnitatud numbrid - esimesel Kings of Tallinn 2024 "rahvaturniiril" tehti 345 sisseostu ning mängitakse 42 159 eurole.

7 vaprat Posted Saturday 24th February, 2024 at 22:26(UTC+2) by maheaaatom

Lõpuks toimub üks PFAI all-in coinflip, kus jooksevad vastamisi

ja vastas pocket üheksad. Arto Lehtonen saab küll flopis ässale pihta, kuid turn on saatuslik üheksa ning tuleb lauast püsti tõusta.

Kuidas läheb aga Dmitril? Õnneks hästi! Ta on natuke juurde kogunud ning praegu umbes miljoni peal.

Player		Chips	Progress
Dmitri Dudakov		1,000,000	100,000

Täna tuleb veel üks turniir Posted Saturday 24th February, 2024 at 22:14(UTC+2) by maheaaatom

Täna kell 23:00 algab veel üks õige kaval turniir. Selleks on 80-eurone 555 € Championship megasatikas, kus on väga korralik garantii - koguni 10 piletit.

Esimesed 8 taset on 15-minutilised, järgmised vältavad 10 minutit (ühesõnaga megaturbo). Hiline registeerumine vältab täpselt kaks tundi ehk umbes kell üheni öösel.

Lõpuks ka esimene finaallaua bust-out Posted Saturday 24th February, 2024 at 22:10(UTC+2) by maheaaatom

Eelmise jaotusega vastasele duubli andnud Marko Mikael Hynynenile jäi üsna vähe järgi ning sellega ta mängu tagasi tulla ei suutnud.

Seega jätkame kaheksakesi ning igaüks on endale juba taganud vähemalt 2450 eurot.

22:08 (UTC+2)

Start of Level 26
Blinds: 30,000/60,000 Ante: 60,000

Teresa loosib tasuta turniiripileti Posted Saturday 24th February, 2024 at 22:08(UTC+2) by maheaaatom

Vahepeal toimus 555 € loosimine kõikide mängijate vahel, kes osalesid Iseseisvuspäeva turniiril.

"Võitja on....Stanislav!" kuulutab turniiridirektor Teresa välja. Kui palju meid neid Stanislave on? Eks ta ikka Smeljovile läheb.

Dmitri saab natuke juurde Posted Saturday 24th February, 2024 at 22:02(UTC+2) by maheaaatom

Heikki Piira callib buttonilt, SB foldib ja Dmitri checkib BB-lt.

Flop on , Dmitri checkib ette, soomlane paneb uuesti 50K ja saab calli.

Turn on ning nüüd on soomlase check-panus juba 125K. Dmitril on umbes 400K järgi, kuid ta callib jälle.

RIver checkitakse läbi. Dmitri avab ning Piira muckib kinniselt.

See oli oluline lisa, muidu oleks Dmitril juba väga-väga raskeks läinud. Nüüd on tal umbes 700K ehk 14XBB.

Melu kasiinos Posted Saturday 24th February, 2024 at 21:51(UTC+2) by maheaaatom

Kasiinos on käimas cashgame kaheksal laual, kuid õhtu on veel noor, sest möllu on omajagu, kuid mitte veel päris nii palju kui eile.

Igatahes võis juba näha ka maailmakuulsat Soome highrollerit Ilari Sahamiest, kes tänavugi Tallinnasse lõbutsema on tulnud. Mida Ilari täpselt mängida plaanib, me muiudgi veel ei tea.

21:42 (UTC+2)

Start of Level 25
Blinds: 25,000/50,000 Ante: 50,000

Dmitril 700K Posted Saturday 24th February, 2024 at 21:37(UTC+2) by maheaaatom

Dmitri stäkk on umbes 700K (keskmine miljoni kandis) ning viimasel levelil ta erilist actionit pakkunud pole. Korra käis küll all-in'is, kuid ühtegi calli ei järgnenud. Endiselt üheksa parimat järgi.

Player		Chips	Progress
Dmitri Dudakov		700,000	200,000

Tänavune rekord on juba ületatud Posted Saturday 24th February, 2024 at 21:34(UTC+2) by maheaaatom

Iseseisvuspäevaturniiril on tehtud juba 316 sisseostu ning ületatud sellega nii avaturniiri kui käimasoleva 350 CUP-i tulemus. Tõsi - re-entry periood saab kohe ka läbi (veel kolm kätt) kuid juba on turniiri auhinnfondi kogunenud pea 40 tuhat eurot.

Suures saalis on mõnda aega käimas ka PLO 60-eurone satelliit, mille auhinnagarantii on 5 x 555 € piletit. Kuna hetkel on laudades vaid 12 mängijat, võib siit isegi pisikest overlayd haista.

21:15 (UTC+2)

Start of Level 24
Blinds: 20,000/40,000 Ante: 40,000

Läänerindel muutusteta Posted Saturday 24th February, 2024 at 21:14(UTC+2) by maheaaatom

Kui enne finaali käis korralik rabistamine, siis nüüd mängitakse väga tasakaalukalt ning keegi välja langenud ei ole. Dmitri stäkk paistab olevat finaali väikseim, kuid seda on siiski tubli 20XBB ning Dmitri senine mäng on olnud väga arukas. Ehk rumalaid ja läbimõtlema otsuseid ta vaevalt teeb. Loodame parimat!

Finaallaud koos Posted Saturday 24th February, 2024 at 20:51(UTC+2) by maheaaatom

Ka finaallaua mullikoht selgus väga kiirelt ning allesjäänud 9 mängijat viidi kokku. Mis peamine, Dmitri on nende hulgas!

Käib finaallaua mullimäng Posted Saturday 24th February, 2024 at 20:47(UTC+2) by maheaaatom

Oleme kaotanud üsna lühikese ajaga kolm shortstacki ning jätkame hetkel kümnekesi.

Mõlemas lauas on viis mängijat, Dmitri lauas on kolm mängijat üsna võrdset ning üks väga suur (umbes 2,5M). Dmitril umbes 850K.

Mäng jätkub Posted Saturday 24th February, 2024 at 20:36(UTC+2) by maheaaatom

Võistlejad on laudades tagasi ning me jätkame tasemel 15K/30K, keskmine stäkk 722K.

Iseseisvuspäevaturniiril käib oodatult kõva möll, diilima on aetud isegi need inimesed, kes tavaelus teiste diilerite tööd juhivad. Hetkel 268 sisseostu ja 225 unikaalset mängijat laudades.

"Hiinakal" on alles 21 parimat, nende seas ka 3 eestlast: Siim Suviste, Mati Pirn ja Kristjan Abakanov. PLO turniiril on tehtud 88 sisseostu, hetkel laudades 48 mängijat.

20:34 (UTC+2)

Start of Level 23
Blinds: 15,000/30,000 Ante: 30,000

Õhtusöögipaus Posted Saturday 24th February, 2024 at 19:36(UTC+2) by maheaaatom

350 € CUP-il algas õhtusöögipaus (60 minutit), alles on endiselt kuraditosin parimat.

Iseseisvuspäevaturniir on alanud, Dmitrile stäkilisa Posted Saturday 24th February, 2024 at 19:29(UTC+2) by maheaaatom

Iseseisvuspäeva turniir on läinud käima, laudades 182 mängijat. Aga neid tuleb kindlasti juurde, sest IKKA veel on kassas järjekord! Ja võimalik, et laudade arvu ka suurendatakse.

CUP-ilt langes just välja lakkamatu jutuvadaga Eestis elab soomlane Tapio Aaltonen, kelle unistus olla turniiri "parim eestlane" seekord ei täitunud. Dmitri Dudakov on kenasti sees ning ka omajagu stäkki juurde hankinud. Tal umbes 900K.

Player		Chips	Progress
Dmitri Dudakov		900,000	150,000

Iseseisuvuspäevaturniiri algus venib Posted Saturday 24th February, 2024 at 19:12(UTC+2) by maheaaatom

Järjekorrad on pikad nii kassasse, pileti järele kui ka garderoobi (küll puudub täielikult baarisaba), et turniiri algusega tuleb natuke oodata, kuniks kõik mängijad oma koha leiavad.

Hetkel on kirjas 143 mängijat, kuid see number suureneb pea iga sekundiga.

Ahvikiirusel kulgev 350 € CUP Posted Saturday 24th February, 2024 at 19:06(UTC+2) by maheaaatom

Meie peamise vaatluse all oleval karikaturniiril on gaas totaalselt põhja lükatud ning oleme jõudnud juba 15 parimani. Mänguruumi on endiselt vaid umbes 25xBB jagu. Dudakov ongi mängus täpselt keskmise stäkiga.

Elegantne järjekord treppidel Posted Saturday 24th February, 2024 at 19:02(UTC+2) by maheaaatom

150-eurost turniiri ründavad tõelised hordid, sest kassa järjekord ulatub treppideni ning kulgeb treppidest alla.

Aga on ka nutikamaid mängijaid, kes on pileti varem soetanud ning pääsevad kohe lauakaarti välja võtma. Näiteks perekond Leiboldid.

"Me oleme WSOP-l käinud, me teame seda värki," ei varja Kairit oma teadmisi.

19:00 (UTC+2)

Start of Level 22
Blinds: 10,000/25,000 Ante: 25,000

18. koht Oskar Ojaveer 890 € Posted Saturday 24th February, 2024 at 18:52(UTC+2) by maheaaatom

10BB stäkiga Oskar läheb kaitsma oma BB-d -ga, vastas on . Laud Oskarit ei päästa.

Kui Oskar läheb tšeki järele, uurib ka floor, et mis kaardiga sa siis välja langesid. "Kas sellest oleneb, kui suur tšekk mulle antakse," naljatleb Oskar vastu.

20. koht Maksim Han 890 € Posted Saturday 24th February, 2024 at 18:43(UTC+2) by maheaaatom

Kahjuks jäime ilma ka Maksim Hanist, kelle kaart viimase tunni-kahe jooksul lihtsalt ei jooksnud.

Ida-Virumaalt pärit Maksimi seni parim saavutus on kümnes koht Kings of Tallinn 2022 Championship turniirilt.

Õnneks on hea uudis ka - Dmitri Dudakov on tõusnud 750K peale! Oskaril endiselt umbes 200K.

Player	Chips	Progress
Dmitri Dudakov	750,000	350,000
Oskar Ojaveer	200,000	120,000
Maksim Han	0	0

22. koht Peep Kivistik 890 € Posted Saturday 24th February, 2024 at 18:34(UTC+2) by maheaaatom

Peep hängis nii mulli eel kui järel üsna pisikese stäkiga ning seda oluliselt suurendada ta ei suutnud. Tasuks 22. koht ning 890 eurot.

Peame nüüd lootma vaid kolmele Eesti mängijale - Dmitri Dudakovile, Maksim Hanile ja Oskar Ojaveerile. Ja miks mitte ka lakkamatult rääkivale Tapio Aaltonenile :)

Player		Chips	Progress
Peep Kivistik		0	0

18:32 (UTC+2)

Start of Level 21
Blinds: 10,000/20,000 Ante: 20,000

VIDEO: Kings of Tallinn 2024 Kick Off podcast Posted Saturday 24th February, 2024 at 18:25(UTC+2) by maheaaatom

Teiste turniiride hetkeseis Posted Saturday 24th February, 2024 at 18:23(UTC+2) by maheaaatom

PLO-le on tehtud 60 sisseoste ning üks suurfavoriite Andres Abakanov on oma bulleti juba ära kasutanud. Muidugi, tal on veel võimalus mängu naasta.

Hiinakale tehti 67 sisseostu, mis on selle mänguformaadi kohta väga tubli näitaja. PLO satelliit on ka lõppenud, planeeritud 5 pileti asemel anti neid ära koguni 10.

Oskar elimineerib viimase naismängija Posted Saturday 24th February, 2024 at 18:16(UTC+2) by maheaaatom

Oskar Ojaveer kaotas (enda sõnul open-enderiga gämmeldes) umbes poole oma stäkist ning callis seejärel allesjäänud 175K-ga Karita Koppineni all-in'i. Naisel võis olla umbes 100 000 punkti.

Oskar:

Karita:

Jaotus laheneb Oskarile soodsalt, kuigi kaugeltki mitte viisakalt. Lauda kümme. Alles kaks tosinat mängijat, naisi kahjuks nende seas enam pole.

Oskaril 320K.

Player		Chips	Progress
Oskar Ojaveer		320,000	20,000

Dudakovile oluline skalp Posted Saturday 24th February, 2024 at 18:07(UTC+2) by maheaaatom

Dmitri Dudakov callib ära ühe 130K stäkiga mängija all-in'i ning leiab end üsna soodsast seisust - vs. .

Okei, vastane saab turnil küll mastitõmbe, kuid kohale seda ei tule. Dmitril nüüd taas umbes 400K.

Player		Chips	Progress
Dmitri Dudakov		400,000	120,000

Omade stäkid Posted Saturday 24th February, 2024 at 18:01(UTC+2) by maheaaatom

Kahjuks on kõik meie mängijad nuppe loovutanud, napilt üle keskmise stäkiga on vaid Oskar Ojaveer.

Player	Chips	Progress
Oskar Ojaveer	340,000	60,000
Dmitri Dudakov	280,000	220,000
Maksim Han	200,000	120,000
Peep Kivistik	120,000	30,000

17:59 (UTC+2)

Start of Level 20
Blinds: 10,000/15,000 Ante: 15,000

32. koht Tatjana Valujeva 700 € Posted Saturday 24th February, 2024 at 17:47(UTC+2) by maheaaatom

Turniiri selgelt parimal Eesti naismängijal Tatjanal on alles imevähe nööpe ning ta on nendega sisuliselt sund all-in'is.

Tatjana avab , vastas . Kuna flopis avatakse kaks ruutut, pole seis esteks üldsegi halb. Paraku turn ega river midagi ei muuda.

Ühtlasi algas paus, alles 30 parimat.

Player		Chips	Progress
Tatjana Valujeva		0	0

Laulupeo ootel Posted Saturday 24th February, 2024 at 17:39(UTC+2) by maheaaatom

Vähem kui poolteist tundi on jäänud tänase Iseseisvuspäeva eriturniiri alguseni, kuhu mahub korraga kuni 200 mängijat. Kuna turniiri sisseost on mõnusalt madal (150 eurot), siis on osalejate seas kindlasti ka palju hobimängijaid.

Turniiril on kasulik osaleda ka põhjusel, et sellel osalejate vahel loositakse välja pileteid homsele 555 € Championshipile.

37. koht Marten Rimmel 700 € Posted Saturday 24th February, 2024 at 17:36(UTC+2) by maheaaatom

Marten Rimmel, kes cashis ka ühel Tallinnas toimunud WSOP Circuit turniiril ning mullusuvisel Summer Showdown'il, saab tasuks 37. koha eest 700 eurot.

34 parimat järgi, eestlasi on neist viis.

Mull lõhkes üheainsa käega Posted Saturday 24th February, 2024 at 17:18(UTC+2) by maheaaatom

Pikka kabetamist on ei tule, juba järgmise käega on mull lõhkenud ning allesjäänud 39 mängijat on teeninud vähemalt 700 eurot. Mullimeheks jääb põhjanaaber Matti Salminen.

Rahades on kuus Eesti mängijat. Suurimad stäkid on Dmitri Dudakovil ning Oskar Ojaveeril, mõlemad mängivad ka aktiivselt ning agressiivselt.

Player		Chips	Progress
Dmitri Dudakov		500,000	220,000
Oskar Ojaveer		400,000	100,000

17:10 (UTC+2)

Start of Level 19
Blinds: 6,000/12,000 Ante: 12,000

Virgo väljas, algas mullimäng Posted Saturday 24th February, 2024 at 17:10(UTC+2) by maheaaatom

Action toimub pärast floppi . Vastane checkib ette, Virgo panustab umbes poole oma stäkist ning saab all-in panuse vastu. Enam pole mingit pääsu, Virgo peab callima ning avab . Vastane on kahjuks ideaalselt floppi tabanud () ning turn ja river on plangud.

Sellega oleme jõudnud 40 parimani ning mäng jätkub hand-by-hand.

Player		Chips	Progress
Virgo Laansoo		0	0

Algas PLO 4/5 Cards Posted Saturday 24th February, 2024 at 17:03(UTC+2) by maheaaatom

Suures saalis on mängijad võtmas istet 555 € Omaha turniiril. Kirjas on 22 mängijat, kuid nende arv kasvab tõenäoliselt kiiresti. Eestlastest on kohal Omaha-mängude superässad Georgi Voomets ja Andres Abakanov, kes mõlemad nii PLO-d kui PLO Hi-Lo'd tõesti harukordselt hästi valdavad.

"Hiinlased" vahetavad muljeid Posted Saturday 24th February, 2024 at 17:00(UTC+2) by maheaaatom

Fuejeest õnnestus kinni püüda Mati Pirn ja Kristjan Abakanov, kes on ühed nendest, kes OFC Pineapple võitu jahivad.

Miks siis ikkagi tasub mängida Hiina pokkerit? Mõlemad sõnavad, et esiteks hoiab see mängijaid pidevalt tegevuses ning tänase turniiri reeglid on ka hästi mängijasõbralikud, kuna puudub piiramatu Fantasy Landi võimalus, millega on võimalik teisi mängijaid kiirelt bustoks tõmmata.

"Hobimängijatele on Hiina pokker suurepärane mäng," kiidab Kristjan.

Kaks privaatturniiri külalistele Posted Saturday 24th February, 2024 at 16:41(UTC+2) by maheaaatom

Suures saalis on lisaks KOT Cup-ile käimas ka kaks privaatturniiri, üks suurem ja teine väiksem.

Suuremal on külalisteks paarkümmend sädelevat Soome prouat, kellele turniiridirektor Teresa julgelt pokkerit ning mängureegleid tutvustab. Midagi sarnast võisime näha ka kolm kuud tagasi toimunud Queens of Tallinnal.

16:38 (UTC+2)

Start of Level 18
Blinds: 5,000/10,000 Ante: 10,000

Omade stäkke Posted Saturday 24th February, 2024 at 16:35(UTC+2) by maheaaatom

Oleme jõudnud 45 parimani ning Eesti mängijaid on sees 7. Olgu siis lisaks Tatjanale loetud üle ka kõikide teiste stäkid.

Player	Chips	Progress
Maksim Han	320,000	50,000
Oskar Ojaveer	300,000	160,000
Dmitri Dudakov	280,000	150,000
Virgo Laansoo	210,000	0
Marten Rimmel	140,000	110,000
Peep Kivistik	100,000	50,000

Tatjana püsib mängus Posted Saturday 24th February, 2024 at 16:29(UTC+2) by maheaaatom

Preflopis läheb sisse kolm väikest stäkki, üks neist meie Tatjana Valujeva.

Tatjana avab , vastas on ning . Päris hea seis.

Tatjana õnnetuseks on flop tõeliselt halb, ka turn midagi ei muuda. Tema õnneks toob river siiski päästva rea.

Tatjanal nüüd umbes 160K. Meie mängijatest väljas seni hüva stäkki omanud Anton Konnov.

Player		Chips	Progress
Tatjana Valujeva		160,000	5,000
Anton Konnov		0	0

16:12 (UTC+2)

Start of Level 17
Blinds: 4,000/8,000 Ante: 8,000

Pausile läheb 61 mängijat Posted Saturday 24th February, 2024 at 15:55(UTC+2) by maheaaatom

350 € CUP teise päeva teisele pausile läheb 61 parimat. Mullini on veel aega, kuigi mänguruumi pole kellelgi just ülearu palju (keskmine umbes 25XBB). Kõigi eelduste kohaselt võiks võitja selguda umbes südaööks.

Eestlasi on mängus kaheksa.

Turniiri võitjale 19 200 eurot Posted Saturday 24th February, 2024 at 15:39(UTC+2) by maheaaatom

Sarnaselt Kings of Tallinn avaturniirile jagub auhinnaraha nüüdki 39 parimale. Kuna sisseost on aga törts suurem (350 vs. 250), on ka auhinnarahad summaarselt pisud suuremad.

Võitjale seega 19200 eurot, viimane rahakoht saab 700 €. Kahjuks ei pretendeeri sellele ei Ranno Sootla ega Aleksei Smirnov, kes mõlemad just äsja välja langesid. Küllap näeme neid mõlemaid aga aktiivselt teistel turniiridel osalemas.

Player		Chips	Progress
Ranno Sootla		0	0
Aleksei Smirnov		0	0

Virgo edeneb Posted Saturday 24th February, 2024 at 15:35(UTC+2) by maheaaatom

Virgo Laansoo on tõusnud umbes 210K peale ning sellega ilusti konkurentsis.

Äsja sai tubli lisa ka Maksim Han, kel niigi väga suur stäkk. Lauas avati ning Maksim panustas ette kõik tänavad, vastavalt 25K, 35K ja 45K. Riveril andis seni kohusetundlikult callinud soomlane alla.

Player		Chips	Progress
Virgo Laansoo		210,000	180,000

Dmitri annab natuke ära Posted Saturday 24th February, 2024 at 15:27(UTC+2) by maheaaatom

Dmitri avab MP-lt 12K-ga, saab calli buttonilt ning all-in panuse (umbes 22K) BB-l istuvalt Frederico Alvesilt.

Dmitri vastab 50K ületõstega, et BB isoloeerida ning saab sellega ka hakkama. Paraku ei suuda tema Alvesi -t üllatada.

Dmitri sellest hoolimata umbes keskmine stäkk, 135K. Oluliselt on kosunud Ranno Sootla (150K) ning juurde on saanud ka Oskar Ojaveer (umbes 140K).

Player	Chips	Progress
Ranno Sootla	150,000	100,000
Oskar Ojaveer	140,000	35,000
Dmitri Dudakov	130,000	55,000

15:23 (UTC+2)

Start of Level 16
Blinds: 3,000/6,000 Ante: 6,000

Maksimile võimas duubel Posted Saturday 24th February, 2024 at 15:17(UTC+2) by maheaaatom

Maksim Han suudab oma -ga kümnete vastu kena duubli võtta (PFAI). Tema stäkk nüüd muljetavaldav 270K.

Paraku on omade seast ka neli langejat ning eestlasi nüüd alles veel 11. Pluss mõistagi Eestis elav soomlane Tapio Aaltonen, kes soovib rõhutada, et vähemalt iseseisvuspäeval on temagi eestlane.

Player	Chips	Progress
Maksim Han	270,000	130,000
Stanislav Smeljov	0	0
Silver Simulask	0	0
Maksim Petrov	0	0
Kristjan Maasalu	0	0

Teele on luurel Posted Saturday 24th February, 2024 at 15:10(UTC+2) by maheaaatom

Kings of Tallinn 2024 hostess on tuntud laulja ning pokkerimängija, alati särav ning lõbus Teele Viira.

Keda Teele täna intervjueerima hakkab, pole hetkel veel teada. Igatahes on ta laudade vahel ringi liikumas ning vaikselt "ohvreid" otsimas.

Hiinlased alustasid Posted Saturday 24th February, 2024 at 15:08(UTC+2) by maheaaatom

Kaardid läksid liikvele ka OFC Pineapple turniiril ning 23 osaleja seas on 6 eestlast. Meeldiv on näha, et seda äärmiselt põnevat mängu, mis muide on leiutatud Soomes, harrastab aina enam ka eestlasi. Ja mõistagi on kohal Mati Pirn!

14:54 (UTC+2)

Start of Level 15
Blinds: 2,000/5,000 Ante: 5,000

Põnev külaline Inglismaalt Posted Saturday 24th February, 2024 at 14:53(UTC+2) by maheaaatom

Turniirilt küll kahjuks juba välja langenud ning täna kahte bulletit kasutanud inglane Paul Newey on mängija, kes väärib erilist tähelepanu.

Tegemist on tuntud ärimehega, kelle varandus ulatub sadadesse miljonitesse eurodesse. Muuhulgas on ta osalenud 1M$ sisseostuga WSOP Big One for One Drop turniiridel, kus suutnud ka rahadesse jõuda. Ühtekokku on mees teeninud live-turniiridel üle 5 miljoni euro.

Newey on pälvinud tähelepanu ka high-stakes kasiinomängijana, kes suutnud ka kasiino kassa tühjaks mängida. Ja selle raha siis mõni aeg hiljem taas kaotada... Küllap saab teda näha ka Olympic Casino VIP-toas.

Eesti mängija stäkke Posted Saturday 24th February, 2024 at 14:43(UTC+2) by maheaaatom

Hästi on edenenud Anton Konnov, Tatjana Valujeva, Peep Kivistik ning Maksim Han. Ranno on omajagu ära andnud ning otsib 50K stäkiga omi võimalusi.

Player	Chips	Progress
Anton Konnov	190,000	100,500
Tatjana Valujeva	155,000	125,000
Peep Kivistik	150,000	87,500
Maksim Han	140,000	110,000
Aleksei Smirnov	115,000	35,500
Oskar Ojaveer	105,000	24,500
Maksim Petrov	100,000	4,000
Dmitri Dudakov	75,000	0
Kristjan Maasalu	60,000	30,000
Stanislav Smeljov	60,000	12,000
Ranno Sootla	50,000	65,000

Urmo välkvisiit Posted Saturday 24th February, 2024 at 14:30(UTC+2) by maheaaatom

Päris viimasel hetkel jõudis mänguga liituda ka kuulus highroller Urmo Velvelt, kelle välkvisiit jäi kahjuks küll suhteliselt lühikeseks.

Mees suutis alguses päris kenasti oma stäki üles saada, kaotas seejärel suurema sellest 70%-ga favoriit olles ning sai oma viimasele PFAI lükkele kaks calli.

Maha jooksis ning Urmo () ei tabanud kahjuks midagi. Vastased checkisid boardi läbi ning pank võideti pocket seitsmetega.

14:27 (UTC+2)

Start of Level 14
Blinds: 2,000/4,000 Ante: 4,000

Eestlased langevad Posted Saturday 24th February, 2024 at 14:17(UTC+2) by maheaaatom

Väljas on nii ambitsioonikas noormängija Hendrik Uibo, nimekad ässad Mark Metsla ja Martin Piik, alles täna mängu alustanud highroller Taago Tamm kui ka aastaid tagasi Ida-Virumaa pokkeriturniiridel säranud Vladislav Han. Jätkab 108 parimat.

Player		Chips	Progress
Vladislav Han		0	0
Hendrik Uibo		0	0
Andres Lõiv		0	0

Nüüd läheb mänguks Posted Saturday 24th February, 2024 at 13:58(UTC+2) by maheaaatom

Mängijad on taas laudades, enam eksida ei saa.

Esialgsetel andmetel kogunes sisseoste 313 ning auhinnafondi 92 679 eurot. Selle nimel jätkab heitlust 126 pokkerisportlast.

13:57 (UTC+2)

Start of Level 13
Blinds: 1,500/3,000 Ante: 3,000

Eelmäng sai läbi Posted Saturday 24th February, 2024 at 13:38(UTC+2) by maheaaatom

Mängijad lubati 15 minutiks puhkama ning selle jooksul on veel võimalik mänguga liituda, alustades actionit 10XBB-ga.

Mängus peaks olema umbes 20 Eesti mängijat, ühe viimasena on sellega liitunud ka mulluse EMV põhiturniiri teine mees ning tuntud high-roller Taago Tamm.

"Täna on vähe rahulikum mäng kui eile," nendib Silver Simulask, kes alustas 28K-ga, kuid on nüüd juba 76K peal, mis on täpselt keskmine stäkk.

Kolm viimast kätt Posted Saturday 24th February, 2024 at 13:34(UTC+2) by maheaaatom

Alustati kolme viimase "re-entry käe" jagamist, misjärel läheb turniir lühikeseks ajaks pausile.

Ihaldatud 300 sisseostu piir saadi just täis, kuid auhinnafond päris kuuekohaliseks ikka ei tõuse. Sellest hoolimata on juba praegu auhinnapotis vägevad 89 422 eurot.

Rannol 115K Posted Saturday 24th February, 2024 at 13:23(UTC+2) by maheaaatom

Ranno, kelle stäkk oli päeva alguses 36500, on teinud head tööd ning tõusnud juba 115K peale.

Veel kümmekond minutit re-entry tegemiseks, sisseostude arv on liginemas 300-le.

Player		Chips	Progress
Ranno Sootla		115,000	250,000

Allan suundus Omahatama Posted Saturday 24th February, 2024 at 13:16(UTC+2) by maheaaatom

Eile hüva mängu näidanud Allan Arjut on kahjuks 350 € Championship'ilt välja langenud. Et mees mängu naasta ei kavatse, näitab see, et hetkel võib teda näha juba PLO satelliidil.

Viimane algas küll vaid 15 minutit tagasi, kuid juba on mängimas 45 pokkerisõpra. Jagamisele läheb vähemalt viis 555 € PLO 4/5 Cards Mystery Bounty piletit.

13:09 (UTC+2)

Start of Level 12
Blinds: 1,000/2,500 Ante: 2,500

Teised tänased turniirid Posted Saturday 24th February, 2024 at 13:09(UTC+2) by maheaaatom

Lisaks käimasolevale 350 € CUP teisele päevale on täna veel kavas kolm turniiri, mille võitja teenib koha Kings of Tallinn võitjate auväärses nimekirjas:

Kell 15:00 algab 150 € OFC Pineapple (Hiina pokker)
Kell 17:00 algab PLO 4/5 Cards (555 €) Mystery Bounty
Kell 19:00 algab Iseseisvuspäeva eriturniiri (NLH, sisseost kõigest 150 €)

Lisaks viiakse täna läbi ka kolm satelliiti:

Kell 13:00 algab 60 € sisseostuga PLO 5 satelliit tänasele 555 € PLO Omaha 4 & 5 Cards Mystery Bountyle, 5 x 555 € piletit GTD
Kell 21:00 algab teine satelliit samale PLO turniirile (sama sisseost ja samad tingimused)
Kell 23:00 algab 80 € Megasatelliit homme algavale 555 € Championship turniirile, 10 x 555 € piletit GTD.

Kas 10XBB on piisav? Posted Saturday 24th February, 2024 at 13:01(UTC+2) by maheaaatom

Peagi on algamas viimane tase, mille jooksul saab veel re-entry õlekõrre järgi haarata.

Kui sa peaksid liituma mänguga viimase pausi ajal, siis saad alustada täpselt 10XBB stäkiga. Aga ajalugu on näidanud, et ka niimoodi liitudes on vägagi kaugele jõutud.

12:35 (UTC+2)

Start of Level 11
Blinds: 1,000/2,000 Ante: 2,000

35 uut tulijat! Posted Saturday 24th February, 2024 at 12:31(UTC+2) by maheaaatom

Esimese poole tunni jooksul on mänguga liitunud juba umbes 35 uut pokkerisõpra.

Hetkel laudades 141 mängijat ning auhinnafond on paisunud 75 tuhande euroni.

Anna Astahhova avaturniiril kaheksas Posted Saturday 24th February, 2024 at 12:25(UTC+2) by maheaaatom

Täna öösel sai läbi ka 250 € sisseostuga Kings of Tallinn avaturniir, millel tehti koguni 305 sisseostu.

Kaks parimat tegid diili, võitis Daniel Lakka Soomest. Meie parimana sai Anna Astahhova kaheksanda koha ning teenis 1700 eurot auhinnaraha.

Keskmisest suuremad eestlaste stäkid Posted Saturday 24th February, 2024 at 12:20(UTC+2) by maheaaatom

Mängus on üle 20 eestlase, kuid eeldatavalt tuleb neid tänase esimese kolme mängutaseme jooksul veel juurde. Üheksal neist on keskmisest suurem stäkk.

P.S. Kui keegi märkas K-Holdem keskkonnas Ranno Sootlal 365K stäkki, siis igaks juhuks mainime, et tegemist oli veaga ning tegelikult on Rannol 36 500 punkti.

Player	Chips	Progress
Kevin Didvig	111,000	81,000
Maksim Petrov	96,000	204,000
Anton Konnov	89,500	59,500
Oskar Ojaveer	80,500	30,500
Aleksei Smirnov	79,500	15,500
Stanislav Smeljov	72,000	7,000
Vladislav Han	71,000	41,000
Andres Lõiv	62,500	32,500
Peep Kivistik	62,500	12,500

Teine päev on alanud Posted Saturday 24th February, 2024 at 12:13(UTC+2) by maheaaatom

Head lugejad, soovime teile kõigile head Eesti Vabariigi aastapäeva!

Mängijad on laudades taas istet võtnud ning teine päev on alanud. Täna mängime veel 3 x 30 minutit, mille jooksul on lubatud teha re-entry. Seejärel lüüakse auhinnafond lukku ning mängitakse kuni võitja selgumiseni.

12:10 (UTC+2)

Day 2 of Kings of Tallinn 2024 Started
Level: 10 Blinds: 1,000/1,500 Ante: 1,500

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