0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0070 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_est_2023/3/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 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.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0036 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` = 'summer_showdown_main_est_2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
0.0288 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '82'
AND `published` = 1
0.0295 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '84'
AND `published` = 1
0.0299 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1
0.0300 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0070 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1
0.0360 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0079 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '93'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
AND `name` = '3'
0.0090 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '91'
ORDER BY `busted` ASC, `current_chips` DESC
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_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '91'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4258'
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` = '4257'
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` = '4256'
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` = '4255'
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` = '4254'
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` = '4253'
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` = '4252'
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` = '4249'
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` = '4246'
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` = '4243'
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` = '4242'
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` = '4240'
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` = '4237'
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` = '4236'
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` = '4234'
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` = '4231'
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` = '4228'
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` = '4226'
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` = '4224'
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` = '4223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4221'
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` = '4219'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4215'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4213'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4204'
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` = '4201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4197'
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` = '4190'
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` = '4185'
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` = '4184'
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` = '4180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4175'
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` = '4172'
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` = '4171'
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` = '4169'
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` = '4168'
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` = '4162'
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` = '4161'
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` = '4153'
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` = '4151'
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` = '4150'
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` = '4146'
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` = '4145'
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` = '4140'
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` = '4139'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4134'
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` = '4133'
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` = '4127'
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` = '4123'
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` = '4120'
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` = '4118'
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` = '4116'
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` = '4113'
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` = '4108'
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` = '4104'
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` = '4100'
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` = '4097'
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` = '4094'
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` = '4092'
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` = '4089'
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` = '4086'
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` = '4085'
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` = '4083'
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` = '4082'
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` = '4080'
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` = '4079'
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` = '4074'
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` = '4073'
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` = '4071'
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` = '4068'
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` = '4067'
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` = '4066'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4064'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4062'
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` = '4061'
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` = '4060'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4059'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4058'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4057'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4055'
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` = '4052'
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` = '4051'
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` = '4049'
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` = '4048'
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` = '4047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4046'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4044'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4043'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4039'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4037'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4036'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4035'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '91'
ORDER BY `busted` ASC, `current_chips` DESC
0.0076 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` = '91'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4258'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4257'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4256'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4255'
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` = '4254'
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` = '4253'
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` = '4252'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4249'
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` = '4246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4240'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4237'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4231'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4226'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4224'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4221'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4219'
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` = '4215'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4213'
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` = '4206'
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` = '4204'
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` = '4201'
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` = '4200'
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` = '4197'
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` = '4190'
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` = '4185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4180'
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` = '4175'
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` = '4172'
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` = '4171'
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` = '4169'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4168'
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` = '4162'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4161'
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` = '4153'
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` = '4151'
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` = '4150'
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` = '4146'
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` = '4145'
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` = '4140'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4139'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4134'
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` = '4133'
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` = '4127'
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` = '4123'
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` = '4120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4118'
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` = '4116'
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` = '4113'
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` = '4108'
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` = '4104'
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` = '4100'
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` = '4097'
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` = '4094'
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` = '4092'
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` = '4089'
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` = '4086'
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` = '4085'
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` = '4083'
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` = '4082'
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` = '4080'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4079'
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` = '4074'
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` = '4073'
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` = '4071'
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` = '4068'
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` = '4067'
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` = '4066'
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` = '4064'
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` = '4062'
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` = '4061'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4060'
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` = '4059'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4058'
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` = '4057'
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` = '4055'
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` = '4052'
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` = '4051'
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` = '4049'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4048'
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` = '4047'
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` = '4046'
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` = '4044'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4043'
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` = '4040'
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` = '4039'
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` = '4037'
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` = '4036'
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` = '4035'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '93'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Jätkame homme Posted Sunday 30th July, 2023 at 00:19(UTC+0) by maheaaatom
Kuna täna lahenduseni kuidagi ei jõutud, siis otsustas turniiridirektor mängijad puhkama lubada.
Peab ju homme kell 12:00 taas lauda istuma ning kes see puruväsinuna ikka mängida armastab. Seega jätkama pühapäeval samast seisut ehk kümnekesi. Ja mängime all kasiinos.
Meie mehi on mängus kolm ning kõigil on korralikud stäkid. Head ööd!
Player
Chips
Progress
Kai E. J. Lehto
3,202,000
1,277,000
Urmo Velvelt
2,665,000
335,000
Tarmo Tammel
2,340,000
850,000
Mikael Johannes Haapaniemi
2,130,000
980,000
Magnus Pukk
1,605,000
140,000
Tomi Tapani Arponen
1,535,000
760,000
Phil Gross
1,360,000
240,000
Nils Jakob Elias Linden
990,000
515,000
Ville-Matti Keränen
730,000
330,000
Tapio Ilmari Aaltonen
345,000
465,000
Lõpp paistab aga ei saabu Posted Sunday 30th July, 2023 at 00:00(UTC+0) by maheaaatom
Aaltonen ja Gross ei stalli, vaid proovivad ka all-in'e, kuid actionit pole ka järgnenud või...on pank poolitatud. Mõlemad mehed on siiski endiselt väga shordid ning hoiavad silma peal ka telelaual. All-in actionit on muide sealgi olnud.
Player
Chips
Progress
Kai E. J. Lehto
3,202,000
1,277,000
Urmo Velvelt
2,665,000
335,000
Tarmo Tammel
2,340,000
850,000
Mikael Johannes Haapaniemi
2,130,000
980,000
Magnus Pukk
1,605,000
140,000
Tomi Tapani Arponen
1,535,000
760,000
Phil Gross
1,360,000
240,000
Nils Jakob Elias Linden
990,000
515,000
Ville-Matti Keränen
730,000
330,000
Tapio Ilmari Aaltonen
345,000
465,000
Aaltonenil ja Grosil keeruline seis Posted Saturday 29th July, 2023 at 23:44(UTC+0) by maheaaatom
Gross loovutab kohe järgmises jaotuses veel korraliku panga soomlasele Haapaniemile ning langeb alla 10XBB. Kuigi parem pole ka Aaltoneni seis, kellel küll kuskile kiiret pole - igale foldile eelneb pikk mõtlemine.
Chipid on selgelt lauas ühes otsas - Haapaniemil, Urmol ja Tarmol.
Gross annab alla Posted Saturday 29th July, 2023 at 23:37(UTC+0) by maheaaatom
Phil Gross tuleb Tarmo Tammeli BB-d "sööma" (100K), kuid meie mees vastab 360K-ga. Gross callib.
Flop on ning Tarmo avab 180K-ga. Sakslane callib.
Turni järel läheb Tarmo all-in. Katab Grossi ilusti.
"Nii, mis mul on?" uurib sakslane. "Äss-poiss," vastab Tarmo. "Okei, aga mis siis sinul on," pärib Gross uuesti. Vastust ei tule. "Ok, teeme siis nii - mida mina arvan, mis sul on?" usutleb lõbus sakslane edasi.
Viimaks viskab ta siiski maha. Tarmo paneb lauale kaks kaarti ja lubab Grossil ühe neist avada. Selleks on emand. "Emandate paar," pakub Gross. Soomlane Aaltonen arvab, et hoopis äss-emand. Jälle üks mõtteülesanne.
Tõeline melu käib kasiinos Posted Saturday 29th July, 2023 at 23:16(UTC+0) by maheaaatom
Kui ülemisel korruse mängusaalis on ülimalt vaikne, sest allesjäänud turniiridel on vähe osalejaid, siis Olympic Casinos käib täielik laulupidu. Saal on paksult rahvast täis, cash käimas enam kui tosinal laual. Mis muud kui tõeline suurfestival, laupäev ju veel nagunii!
23:14 (UTC+0)
Start of Level 27 Blinds: 25,000/50,000 Ante: 50,000
Allesjäänud mängijate stäkid Posted Saturday 29th July, 2023 at 23:12(UTC+0) by maheaaatom
Väiksem stäkk on 13XBB, kokku on kolm alla-miljoni stäkke.
Mäng läks just uuesti käima ning kuna üks laud on alumisel ja teine ülemisel korrusel, siis EI MÄNGITA hand-by-hand.
Player
Chips
Progress
Kai E. J. Lehto
3,395,000
1,470,000
Urmo Velvelt
2,760,000
240,000
Mikael Johannes Haapaniemi
2,040,000
1,070,000
Tarmo Tammel
1,730,000
240,000
Ville-Matti Keränen
1,635,000
1,235,000
Phil Gross
1,600,000
1,430,000
Tomi Tapani Arponen
1,380,000
605,000
Magnus Pukk
970,000
775,000
Tapio Ilmari Aaltonen
720,000
90,000
Nils Jakob Elias Linden
685,000
210,000
11. koht - Ilya Nikiforov Posted Saturday 29th July, 2023 at 22:58(UTC+0) by maheaaatom
Ilya sai "õhtule" telelauas, seega me jaotuse käiku ei tea. Ja üleüldse algas ka tänane viimane paus 15 minutit.
Seejärel mängime kuni ühe langejani, siis on finaallaud koos.
Player
Chips
Progress
Ilya Nikiforov
0
0
Tarmo ja Urmo ristavad taas piike Posted Saturday 29th July, 2023 at 22:48(UTC+0) by maheaaatom
Urmo on selgelt laua agressor ning tundub, et ka Tarmo Tammelil on tema ees teatav aukartus.
Äsja olid samad mehed taas vastamisi, seekord andis aga Urmo turni järel alla ning Tarmo korjas umbes 500K panga endale. Mõlemal mehel on umbes 2,5M, millega domineeritakse oma lauda. Chiplooserid on endiselt samad, kuid seis on märksa ühtlasem kui varem.
Ootame endiselt kahte langejat.
Sakslasele veel üks duubel Posted Saturday 29th July, 2023 at 22:39(UTC+0) by maheaaatom
Seekord on actionis turniiri chipliider Haapaniemi. Nuppe lükatakse pärast floppi
Mõlemal mehel on mastitõmme (Grossil , soomlasel aga ) ning ka oluline eelis - lauast on paar käes.
Masti ei saa kumbki, kuid Gross tõmbab riverisse ässa ning on nüüd samuti miljoniklubis.
Ei lähe see Gross kuskile! Posted Saturday 29th July, 2023 at 22:28(UTC+0) by maheaaatom
Pärast floppi on Phil Gross oma 270K-ga keskel ning Urmo Velvelt callib kiirelt. No mis sel pagana sakslasel siis ikka olla saab?
Urmo näita uhkelt , kuid Gross nagu nõiutult . Turn ja river päästvat emandat ei too.
Ei lange keegi Posted Saturday 29th July, 2023 at 22:18(UTC+0) by maheaaatom
Üleval on viis mängijat, kellest kaks on väga suurt stäkki (Haapaniemi ja Urmo), üks keskmine (Tarmo Tammel) ning kaks väikest (Gross ja Aaltonen).
Viimastest "suutis" Gross just kolmandiku oma stäkist tõelise herocalli (äss-kõrge kuningas-kõrge vastu) teinud Haapanieme vastu maha bluffida, kuid Aaltonen suutis oma 350K ministäki jällegi (samuti Haapanieme vastu) igati ausalt duublisse saada: vs. .
Kui need mehed just all-in'is ei käi, hoiab tempot Urmo Velvelt.
22:10 (UTC+0)
Start of Level 26 Blinds: 20,000/40,000 Ante: 40,000
Urmo võtab võimsa skalbi Posted Saturday 29th July, 2023 at 22:07(UTC+0) by maheaaatom
Viimastes tasemetel väga halvasti jooksnud Anatoly Filatov kolmpanustab all-in ning saab flipi Urmo Velvelti vastu.
Anatoly:
Urmo:
Lauda .
Urmole ca. 650K chipilisa, kuid Anatolyst on siiski omamoodi kahju. Hea mängija, hea mäng, kuid mitte midagi lõpus pihta ei läinud.
Urmol nüüd ca. 3M. Väga kõva avaldus!
Player
Chips
Progress
Urmo Velvelt
3,000,000
1,700,000
Anatoly Filatov
0
0
Jätkame 12-kesi Posted Saturday 29th July, 2023 at 22:03(UTC+0) by maheaaatom
Telelauast langes Juho H. S. Heiska, seega oleme hetkel 12-kesi. Ühtlasi on surmkindel, et finaallauas on vähemalt üks (aga miks mitte neli) eestlast.
Keegi peab nüüd ülevalt allakorrusele minema ning selleks meheks on Tomi Arponen.
Urmole veel üks pank Posted Saturday 29th July, 2023 at 21:53(UTC+0) by maheaaatom
Urmo haukab ka natuke Phil Grossi stäkist - esimesel top kaks paari, meie mehel kolmik.
Urmol nüüd 2,3M, Tarmol 1,5M. Viimasele ei anna muidugi kuidagi rahu see viimane käsi, kus ta oli sunnitud riveril ässad foldima. Äkki avaldab Urmo pärast turniiri saladuse?
Jätkame aga endiselt 13-kesi. Tomi Arponen käib just all-in'is Anatoly Filatovi vastu ning on selgelt taga ( vs. ), kuid river...jah river on . Anatolyle tuleb 340K välja maksta. Tuleb märkida, et live-turniiridel üle 5 miljoni teeninud mehel pole viimastel tasemetel kohe üldse õnne olnud. Mänginud on Anatoly tegelikult väga hästi.
Player
Chips
Progress
Urmo Velvelt
2,300,000
1,000,000
Tarmo Tammel
1,500,000
10,000
Tarmo foldib ässad Posted Saturday 29th July, 2023 at 21:45(UTC+0) by maheaaatom
Kõrvuti istuvad Tarmo Tammel ning Urmo Velvelt mängivad suure panga.
Flopi järel checkib Urmo ette, Tarmo paneb 70K ja saab calli.
Turn on , nüüd haarab ohjad juba Urmo - 160K. Tarmolt call.
River on ning Urmo panustab 275K.
Tarmo mõtleb umbes kolm minutit ja foldib lahtiselt ! Urmo ei näita. Las see jääda nüüd kõigile mõistatada, mis käsi võis ühel Eesti hinnatuimal turnaprol olla.
Kes on sihikul? Posted Saturday 29th July, 2023 at 21:36(UTC+0) by maheaaatom
Ülemisel korrusel on selgelt sihikul Tapio Aaltonen ja Tomi Arponen, mõlema stäkid on umbes 10-15XBB vahel. Tegelikult ei ole ka Phil Gross kuigi suur ning Anatoly Filatovgi on oma stäkist suure osa kaotanud.
Laua (ja turniiri) liider Mikael Johannes Haapaniemi mängib väga rahulikult, märksa aktiivsemad on laua suuruselt teine ja kolmas stäkk - Tarmo Tammel ja Urmo Velvelt. Aga lahendust pole siiani veel tulnud.
Grossi bluff ei lähe läbi Posted Saturday 29th July, 2023 at 21:30(UTC+0) by maheaaatom
Tarmo Tammelil õnnestub Phil Grossilt natuke nuppe saada.
Turniks on lauas ning pangas umbes 150K. Tarmo checkib ette, Phil teeb 100K panuse.
River checkitakse läbi. Tarmo näitab "kolme paari" - , Philil pole aga ässa, viite ega üldse midagi...
Urmole natuke lisa Posted Saturday 29th July, 2023 at 21:21(UTC+0) by maheaaatom
Urmolt seepeale võrdlemisi kiire all-in ning ka Anatoly ei jää pikalt mõtlema - fold. Jälle, veerand stäkist justkui maast leitud!
Player
Chips
Progress
Urmo Velvelt
1,300,000
215,000
See turbo on ikka tõsine turbo! Posted Saturday 29th July, 2023 at 21:11(UTC+0) by maheaaatom
Turbokal osalev põhiturniiri 23. mees Herli Olop käib rääkimas, et 150 € turbokas on täiesti kreisi mäng. "10-minutilised levelid, mõtle ise," nerab Herli.
Ta heidab pilgu peale ka põhiturniiri poolfinaallauale ning poetab kiidusõna sakslase Phil Grossi suunas. "See on väga lahe tüüp! Vahel paneb ikka täiega hullu."
Eestlannadele kolmas ja neljas koht Posted Saturday 29th July, 2023 at 21:03(UTC+0) by maheaaatom
Queens of Tallinnal on käimas heads-up leedulanna ja austerlanna vahel.
Helina Tamm oli neljas ning Evely Pihela sai tunda siirast rõõmu kolmanda koha üle.
Jätkame, eestlaste stäkid on järgmised Posted Saturday 29th July, 2023 at 21:01(UTC+0) by maheaaatom
Mikael Johannes Haapaniemi on endiselt chipliider (3,11 miljonit), eestlased on järjest kohtadel 4-7.
Super High-Roller Anatoly Filatov, keda võib ka natuke eestlaseks lugeda, on umbes 2M peal. Tõsi esimese pausijärgse kaega jäi ta umbes veerandist oma stäkist ilma, andes valusa duubli vs. (river poiss).
Player
Chips
Progress
Mikael Johannes Haapaniemi
3,110,000
330,000
Magnus Pukk
1,745,000
1,145,000
Ilya Nikiforov
1,555,000
55,000
Tarmo Tammel
1,490,000
185,000
Urmo Velvelt
1,085,000
365,000
Hiinakas läbi Posted Saturday 29th July, 2023 at 20:33(UTC+0) by maheaaatom
Keskpäeval alanud hiinakas on lõppenud, võidu sai nimekas soomlane Risto Olavi Pönniö. 54 sisseostu, auhinnafond ligi 16 000 eurot.
OlyBet Mystery Bounty Kings on jõudnud 59 parimani (tehti 229 sisseostu), Soome Stud aga kuue finalistini (20 osalejat, ei ühtegi eestlast). NLH Turbo on siiani tõmmanud laudadesse 58 sisseostu. 555 €PLO 4/5 Card Progressive Bounty on märksa popim, sisseoste juba 131 (umbes pooled mängijad sees).
Põhiturniiri TV-lauas veel üks langeja - Feras Michael Badir Abid. Järel kuraditosin parimat. Pärast seda läks põhiturniir taas pausile, seekord 20 minutiks.
Naistekal TOP4 Posted Saturday 29th July, 2023 at 20:28(UTC+0) by maheaaatom
Queens of Tallinn on jõudnud tõenäoliselt viimase pausini ning hetkel on mängus neli kangelannat. Neist kaks on eestlased (Evely Pihela ja Helina Tamm), teised kaks aga väliskülalised.
Viienda koha, mis oli muuseas ka rahakoht, sai Mari-Liis Joa.
Urmo annab pisikesele stäkile duubli Posted Saturday 29th July, 2023 at 20:18(UTC+0) by maheaaatom
Ei midagi hullu, Phil Grossi stäkk oli vaid 4XBB.
Sakslane läks sisse -ga, Urmol oli . Flopis said mõlemad pihta (Urmo ässale ja Gross kuuele), kuid river tõi võidu shortstackile. Oh seda rõõmu, naeris ka Urmo.
16. koht - Siim Suviste 4500 € Posted Saturday 29th July, 2023 at 20:16(UTC+0) by maheaaatom
Siim langes TV-lauast, seega on meil tema viimase jaotuse kulg teadmata.
Vähemal õnnestus mehel üks money-jump üle elada ning tasuka 4500 eurot.
14 parima seas (väljas ka viimane leedulane, Karolis Kutkauskas) on neli Eesti mängijat.
Eestlased heas seisus Posted Saturday 29th July, 2023 at 20:12(UTC+0) by maheaaatom
Turniri chipliider on küll Mikael Johannes Haapaniemi (2,78M), kuid kolm eestlast on kohtadel 4-6: alumisel korrusel meheteguseid teinud Tarmo Tammel 1675000 ning üleval säranud Ilya Nikiforov, 1610000 ja Urmo Velvelt 1450000.
Magnusel on 600K ja Siimul 460K.
Ülemisel korrusel nüüd Tarmo ja Urmo, ülejäänud kolm mängivad TV-lauas.
Player
Chips
Progress
Tarmo Tammel
1,675,000
1,355,000
Ilya Nikiforov
1,610,000
110,000
Urmo Velvelt
1,450,000
0
Magnus Pukk
600,000
10,000
Siim Suviste
460,000
65,000
Uus re-draw Posted Saturday 29th July, 2023 at 19:56(UTC+0) by maheaaatom
Telelauast aina langeb ja langeb ning üks mees sadas ka ülemiselt korruselt. Õnneks polnud keegi neist eestlane. Tarmo Tammel, Siim Suviste, Urmo Velvelt, Ilya Nikiforov ning Magnus Pukk on kenasti mängus sees, nagu ka 11 nende konkurenti. Kokku seega 16 mängijat.
See tähendab, et viiakse läbi täiendav re-draw - üks laud jääb üles ning teine läheb telepurki. Hetkel 15-20 minutiline tehniline paus.
Ilya saab ilma actionita 320K Posted Saturday 29th July, 2023 at 19:47(UTC+0) by maheaaatom
Turniiri chipliider Mikael Johannes Haapaniemi läheb 320K tõstega Ilya blindi "sööma", kuid tema halvaks üllatuseks vastab Ilya all-in'iga.
Soomlane callimiseks jõudu ei leia, meie mehel ikkagi kobe 1,2M stäkk. Ja nüüdsest on see juba 1,5M!
Player
Chips
Progress
Ilya Nikiforov
1,500,000
300,000
19:38 (UTC+0)
Start of Level 24 Blinds: 10,000/25,000 Ante: 25,000
Algas tänane viimane turniir Posted Saturday 29th July, 2023 at 19:29(UTC+0) by maheaaatom
Alanud on tänane viimane turniir, 150 € NLH Turbo. Osalejaid on hetkel küll vaid 20, kuid seda mitte põhjusel, et mängijaid poleks, vaid kõik on juba hõivatud teiste turniiridega.
Näiteks "igamehe turniiril" Olybet Mystery Bounty Kingil on tehtud 229 sisseostu, mis on väga võimas tulemus.
Naistes jõudis just finaalini ning eriti rõõmus oli festivali hostess Evely Pihela, kel õnnestus ka üheksa väljavalitu sekka pääseda.
Eestlaste hetkeseis Posted Saturday 29th July, 2023 at 19:21(UTC+0) by maheaaatom
Player
Chips
Progress
Urmo Velvelt
1,450,000
85,000
Ilya Nikiforov
1,200,000
40,000
Magnus Pukk
610,000
350,000
Siim Suviste
395,000
360,000
21. koht - Igor Pihela noorem 3900 € Posted Saturday 29th July, 2023 at 19:15(UTC+0) by maheaaatom
Igor Pihela läks -ga blinde ründama, BB kaitses -ga.
Flopis oli äss, kuid paraku ka kaks ristit. Turn tõi risti masti kohale, siis läksid ka nupud. Ja Igor oli kahjuks juba drawing dead.
Player
Chips
Progress
Igor Pihela noorem
0
0
Naistekas läheneb finaallauale Posted Saturday 29th July, 2023 at 19:13(UTC+0) by maheaaatom
Queens of Tallinn turniiril on alles 10 parimat, seega oleme kohe finaallauas. Allesjäänute hulgas on viis eestlannat ja viis külalist. Meie lippu hoiavad kõrgel Mari-Liis Joa, Evely Pihela, Helina Tamm, Christel Haller ja Karin Ehala.
Raha jagub viiele parimale, võitja saab 1568 eurot. On mille nimel mängida küll.
Siimu stäkk saab valusa hoobi Posted Saturday 29th July, 2023 at 19:08(UTC+0) by maheaaatom
Siim Suviste ründab EP-lt 40K, laheda nimega lätlane Roberts Rumba tõstab 130K-le ning Siim vastab pika mõtlemise järel all-in'iga. Roberts callib.
Siim:
Roberts:
Diiler avab flopi, kohe esimesena kaardina näeme ässa. Aga ei, juba järgmine kaart on kuningas. Ja ülejäänud kolm kaarti ei muuda enam midagi.
Tuleb 630K välja maksta, Siimul jääb vaid ca. 230K järgi...
Player
Chips
Progress
Siim Suviste
230,000
525,000
Tempo on taas maas Posted Saturday 29th July, 2023 at 19:03(UTC+0) by maheaaatom
Pärast Herli ja Nicki langemist on mängutempo taas maha tõmmatud, kuigi ülearu ruumi just mängijatel pole (keskmine stäkk 26XBB).
21 parima seas on 6 eestlast, kellest telelauas endiselt Tarmo Tammel. Ülejäänud mehed on ülemisel korrusel ning neil saame vahetult silma peal hoida.
23. koht - Herli Olop 3900 € Posted Saturday 29th July, 2023 at 18:31(UTC+0) by maheaaatom
Kahjuks kaotasime kohe 23. taseme alguses Herli Olopi. Tema ca 210K stäkk läks kahe jaotusega, mõlemad mündivisked. Esimeses oli Herlil vs. ). Turnis poiss.
80K jäi järgi (3XBB), millega ei õnnestunud mängu tagasi tulla. Viimased chipid läksid -ga vastu, juba flopis emand.
Herli sihid olid kohe kindlasti kõrgemal...
P.S. Kohe Herli järel langes ka Nick Martijn Penning, kes alustas 23. taset kõigest 10K punktiga. Seega hetkel 21 parimat järgi.
Player
Chips
Progress
Herli Olop
0
0
Nick Martijn Penning
0
0
18:28 (UTC+0)
Start of Level 23 Blinds: 10,000/20,000 Ante: 20,000
Õhtusöögi paus Posted Saturday 29th July, 2023 at 17:21(UTC+0) by maheaaatom
Algas 60-minutiline õhtusöögipaus ning lühipuhkusele läheb ka meie live-ülekanne.
Põhiturniiril jätkab endiselt 23 mängijat. Viimasel käel mängiti kahe välismaalase vahel küll üle pika aja ka all-in jaotus, kus läksid vastamisi ässad ja kuningad. Laud aga midagi ei muutnud ning ässade omanikust shortstack võttis vajaliku duubli.
Pausi jooksul paneme kirja ka kõikide allesjäänud mängijate (nii eestlased kui teised) täpse chippide seisu.
Magnus kõrvetab Igorit Posted Saturday 29th July, 2023 at 17:07(UTC+0) by maheaaatom
Magnus Pukk ja Igor Pihela mängivad omavahel võrdlemisi suure pangaga käe.
Pärast floppi on lauas juba ligi 400K.
Turn lisab intriigi. See checkitakse küll viisakalt läbi.
Riveri järel checkib Igor taas ning Magnus haistab võimalust - all'in! Igor ei calli.
Urmo Herlit ei hellita Posted Saturday 29th July, 2023 at 16:59(UTC+0) by maheaaatom
Urmo Velvelt ja Herli Olop mängivad omavahel jaotuse, mis vältab terve igaviku.
Urmo alustab MP-lt tavapärase 30K panusega ning Herli kaitseb oma BB-d.
Flop on , Herli checkib ette, Urmo paneb 25K ja saab calli.
Turni järel kordub sama, seekord on ainult panused juba 25K.
Riveri üritab hoopis Herli initsiatiivi haarata, tehes omakorda 45K panuse.
Urmo mõtleb kaua, küsib Herli stäkki ja lükkab seejärel all-in. Herli viskab koheselt lauale lõhkiläinud kahepoolse reatõmbe ().
Siim kaotab ässadele Posted Saturday 29th July, 2023 at 16:48(UTC+0) by maheaaatom
Siim Suviste kolmpanuse järel vaadatakse koos Tomi Arponeniga floppi . Soomlane checkib ette, Siim paneb 60K ja saab calli.
Turn on ning siin aetakse ka nupud sisse. Ega soomlasel polegi rohkem kui 152K, Siimul seevastu umbes 900K nupukuhi.
Tomi:
Siim:
River midagi ei muuda.
Player
Chips
Progress
Siim Suviste
750,000
280,000
Igor annab duubli Posted Saturday 29th July, 2023 at 16:40(UTC+0) by maheaaatom
Eestis elav soomlane Tapio Aaltonen avab 30K-ga, Igor tõstab üle 105K-le ning soomlane vastab 263K all-in'iga. Igor callib.
Tapio:
Igor:
Lauda poiss ning Igor kaotab umbes veerandi oma stäkist. Üks langeja on vahepeal ka (Hendrik Paul L. Diegenant) ning me jätkame 23-kesi.
Player
Chips
Progress
Igor Pihela noorem
750,000
210,000
Eestlaste stäkid Posted Saturday 29th July, 2023 at 16:31(UTC+0) by maheaaatom
Player
Chips
Progress
Ilya Nikiforov
1,200,000
200,000
Urmo Velvelt
1,080,000
300,000
Siim Suviste
1,030,000
20,000
Igor Pihela noorem
960,000
310,000
Magnus Pukk
620,000
270,000
Herli Olop
480,000
180,000
Re-draw läbi, mäng jätkub Posted Saturday 29th July, 2023 at 16:28(UTC+0) by maheaaatom
Umbes veerand tundi väldanud tehnilise paus sai läbi ning kaardid on taas õhus.
Telepurki läks Tarmo Tammel, kõik ülejäänud 6 Eesti mängijat jätkavad ülemisel korrusel.
16:08 (UTC+0)
Start of Level 22 Blinds: 10,000/15,000 Ante: 15,000
Igor elimineerib ministäki Posted Saturday 29th July, 2023 at 16:07(UTC+0) by maheaaatom
Igor karistab mikrostäkiga keskele liikunud Touko Teivonpoika Berndtsoni, callides tema ilusa tõmbekäe () ära . Pihta saavad mõlemad, Igori paar on aga suurem. Tema stäkk nüüd pea miljon.
Hetkel viiakse läbi re-draw. Ülemine korrus jätkab nüüd kahel laual, lisaks ka kasiinos mängitav telelaud.
Player
Chips
Progress
Igor Pihela noorem
980,000
330,000
Kiirpõige teistele turniiridele Posted Saturday 29th July, 2023 at 15:46(UTC+0) by maheaaatom
Naistekale on tehtud 34 sisseostu, mida on natuke vähem kui oodatud, kuid liitumine on veel avatud.
"Täitsa hea turniir on, 20K algstäkk. Palju parem mängida kui nendel, kus anti ainult 10K või 15K," kiidab näiteks selle formaadi valitsejanna Catlin Müür.
Just alanud Finnish 5 Card Stud toimub hetkel vaid kahel laual, kuid küllap lisandub uusi mängijaid peagi. Käima on läinud ka 150-eurone Mystery Bounty, kus on aga kirjas juba üle 100 osaleja. Samuti paistab üsna menukas olevat hiinakas (mis algas juba keskpäeval) - osalejaid üle 50.
"Suurel" Mystery Bountyl on alles 8 parimat ning mängus juba päris kopsakad auhinnarahad. Kogu turniiri auhinnafond on üle 56 000 euro!
Urmo kaotab umbes viiendiku stäkist Posted Saturday 29th July, 2023 at 15:31(UTC+0) by maheaaatom
Urmo Velvelt üritab Nick Penningu vastu positsiooni omades panka kätte saada, rünnates viimast nii pärast floppi kui ka turni ja riverit . Kahel viimasel tänaval on panused mõlemad korral 80K, vastane check-callib kõikidel kordadel.
Urmo avab , vastas on flopis saadud kahepoolne reatõmme , mis turnis paariks täieneb.
Urmol umbes 780K järgi.
Player
Chips
Progress
Siim Suviste
1,050,000
400,000
Ilya Nikiforov
1,000,000
550,000
Urmo Velvelt
780,000
130,000
Tarmo Tammel
320,000
20,000
Igor sai mäele, Siimul oli kõvasti õnne Posted Saturday 29th July, 2023 at 15:18(UTC+0) by maheaaatom
Igor Pihela noorem võitis just üliolulise flipi -ga vastu ning duubeldas oma stäki umbes 650K-le.
Pisut varem võitis väga suure käe ka Siim Suviste, kel oli - mis seal salata - ka roppu moodi õnne. Nimelt suutis ta PFAI käes oma -ga saada jagu nii -st kui -st, tabades flopis 1-outer poissi.
Player
Chips
Progress
Igor Pihela noorem
650,000
350,000
Nüüd ainult mehed Posted Saturday 29th July, 2023 at 15:14(UTC+0) by maheaaatom
Soomlanna Anna-Mari Hursti langemise järel (28. koht) jätkavad põhiturniiri ainult mehed.
Rahadesse jõudis täpselt kolm naist, lisaks Anna-Marile ja Jaana Kindsigole ka Hyunsil Park.
Herli ja Magnuse muljeid Posted Saturday 29th July, 2023 at 15:03(UTC+0) by maheaaatom
Telelaud jätkab ka pärast pausi samas koosseisus ning peamiseks põhjuseks on üks mees - Juho Heiska, kes mängib ülimalt loose-agressive mängu.
Üsna hästi jooksnud Juhol on muide ka turniiri suurim stäkk ning seetõttu paistab Herli ja Magnuse strateegia olema lihtne - tuleb oodata oma kohta ning üritada seisu parandada. Aga õnneks on mõlemal kõvasti mänguruumi ning mõlema sihiks mõistagi finaallaud.
14:59 (UTC+0)
Start of Level 21 Blinds: 7,000/14,000 Ante: 14,000
Teine paus Posted Saturday 29th July, 2023 at 14:40(UTC+0) by maheaaatom
Puhkama läheb 29 mängijat. Kõik 7 eestlast on kenasti mängus.
Oleme tagasi 15 minuti pärast.
Urmo annab shordile duubli Posted Saturday 29th July, 2023 at 14:27(UTC+0) by maheaaatom
Nick Martijn Penning avab 25K-ga, Urmo tõstab 75K üle. Nick paneb seejärel oma 186K stäki keskele ning Urmo callib kiirelt.
Nick:
Urmo:
Ässad peavad vastu. Endiselt 31 parimat mängus.
Player
Chips
Progress
Urmo Velvelt
910,000
190,000
Urmole veel lisa Posted Saturday 29th July, 2023 at 14:19(UTC+0) by maheaaatom
Urmo on tõusnud üle maagilise miljoni, tema stäkk hetkel 1,1M. Rohkem on vaid lätlasel Vlads Dolgilevicsis (ca. 1,3M).
Urmo on Eesti live-rahalistis küll alles 81. kohal, kuid selgelt on tegemist siiski online-proga. Tema kontos on näiteks nii WSOP Circuiti võit kui WSOP Online põhiturniiril saavutatud ülikõrge neljas koht.
Player
Chips
Progress
Vlads Dolgilevics
1,300,000
626,000
Urmo Velvelt
1,100,000
200,000
Eestlaste stäkid Posted Saturday 29th July, 2023 at 14:08(UTC+0) by maheaaatom
Player
Chips
Progress
Urmo Velvelt
900,000
130,000
Siim Suviste
650,000
80,000
Ilya Nikiforov
450,000
60,000
Igor Pihela noorem
300,000
120,000
Tarmo Tammel
300,000
110,000
34 parimat Posted Saturday 29th July, 2023 at 13:57(UTC+0) by maheaaatom
Põhiturniiril on alles 34 parimat ning kordame veelkord üle, et täna on plaanis mängida kas kuni finaallauani või (kui selleni ei jõuta), siis umbes kella kaheni, et finalistid saaksid ka väheke puhata.
Naistekas kogub samuti hoogu, juba on kohal alati särtsakad Kristi Kirs, Catlin Müür, Kati Pruel jt., seega igav sealsetel osalejatel kindlasti ei ole. Nii naisteka kui High-Rolleriga saab liituda kaheksanda taseme lõpuni. Naistekal vältavad tasemed 20, High-Rolleril 30 minutit.
Siim vajutab gaasi Posted Saturday 29th July, 2023 at 13:48(UTC+0) by maheaaatom
Viimased kaks kätt EP-lt võitnud Siim Suviste paistab silma võrdlemisi agressiivse mänguga ega ole kohkunud ka all-in lükkeid tegemast.
Mees on selgelt laua agressoriks, kuigi suurim stäkk on endiselt Urmo Velvelti käes. Ja Urmo on Siimu suhtes pigem soodsal positsioonil.
13:43 (UTC+0)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Ülemise korruse eestlaste stäkid Posted Saturday 29th July, 2023 at 13:37(UTC+0) by maheaaatom
Telelauas on kaks meie mängijat - Magnus Pukk ning (jälle) Herli Olop. Kokku on mängus seitse Eesti pokkerisportlast. Ülemisel korrusel on oluliselt paranenud Tarmo Tammeli seis, kuid ka Urmo Velvelt on oma niigi suurt stäkk veel omajagu suurendanud.
Player
Chips
Progress
Urmo Velvelt
770,000
250,000
Siim Suviste
570,000
50,000
Ilya Nikiforov
510,000
30,000
Tarmo Tammel
410,000
210,000
Igor Pihela noorem
180,000
170,000
38. koht - Jaana Kindsigo 3000 € Posted Saturday 29th July, 2023 at 13:29(UTC+0) by maheaaatom
Jaana jookseb oma pocket kolmedega Edgars Beizaksi otsa.
Flop annab vastasele tõmbeid juurde, turn on aga Jaanale niivõrd halb, et ta on hoobilt drawing dead. River ebaoluline .
Jaana on küll turniiri parim Eesti naine, kuid mitte edukaim naine kokkuvõttes. Soomlanna Anna-Mari Hursti on endiselt sees ning tema stäkk on päris korralik.
Player
Chips
Progress
Jaana Kindsigo
0
0
Päevad pole vennad Posted Saturday 29th July, 2023 at 13:22(UTC+0) by maheaaatom
Kolmandat päeva liidrina alustanud Juan Carlos Vecino Duenas peab leppima kõigest 39. kohaga.
Turniiri liidrid paistavad olevat Vlads Dolgilevics ja Karolis Kutkauskas, kuid väga korralikud stäkid on ka eestlastel Urmo Velveltil ja äsja mainitud Siim Suvistel.
Player
Chips
Progress
Juan Carlos Vecino Duenas
0
0
Siimule väike skalp Posted Saturday 29th July, 2023 at 13:18(UTC+0) by maheaaatom
Mikrostäkiga Samuli Hietala pushis SB-lt -ga ning sai calli BB-l olevalt Siim Suvistelt, kel olid pocket kaheksad. Siimu käsi pidas ka kenasti vastu. Tal väga korralik umbes 620K stäkk.
Player
Chips
Progress
Siim Suviste
620,000
120,000
Järgmine money-jump Posted Saturday 29th July, 2023 at 13:14(UTC+0) by maheaaatom
Vahepeal langes välja veel kaks välismaalast ning me jätkame 40-kesi. Kõik allesjäänud on endale taganud vähemalt 3000 eurot.
Käima on läinud ka 3000 € High-Roller ning 150 € naistekas. High-Rollerist valmib eraldi ülekanne, mille eest kannab hoolt "Marjakas".
45. koht Andrei Mjagkov, 46. koht Mauri Dorbek - mõlemad 2700 eurot Posted Saturday 29th July, 2023 at 13:11(UTC+0) by maheaaatom
Nii Mauril kui Andreil olid alla 10XBB stäkid ning seega ei tulnud kummagi väljalangemine ka mingi üllatusena.
Andrei viimaseks käeks jäi vs. , floppi kümme. Mauri nupud läksid -ga pocket kuute vastu.
Tegelikult kaotas Mauri oma suure stäki aga kahe eelnevatel tasemetel mängitud käega, millest esimene oli suhteliselt õnnetu, teine aga puhas cooler. Vähemalt hea, et suur osa nuppudest läks teisele eestlasele, Urmo Velveltile.
Player
Chips
Progress
Andrei Mjagkov
0
0
Mauri Dorbek
0
0
Eestlaste stäkid Posted Saturday 29th July, 2023 at 12:55(UTC+0) by maheaaatom
Telelauas on ainsa eestlasena Magnus Pukk.
Player
Chips
Progress
Urmo Velvelt
520,000
38,000
Siim Suviste
500,000
110,000
Ilya Nikiforov
480,000
222,000
Igor Pihela noorem
350,000
70,000
Magnus Pukk
350,000
30,000
Herli Olop
300,000
79,000
Jaana Kindsigo
300,000
0
Tarmo Tammel
200,000
40,000
Andrei Mjagkov
70,000
19,000
Herli alustab kiire duubliga Posted Saturday 29th July, 2023 at 12:44(UTC+0) by maheaaatom
Põhiturniir läheb edasi ning äsjane telelaua seltskond jätkab mängu ülemisel korrusel.
Kohe esimene käsi on tulus Herli Olopilt. TV-lauas langes ta küll üsna väikeseks, kuid saab kohe kiire duubli.
Dmitrijs Kornevs lükkab -ga Herlil on . Kõrgem paar peab.
Samal ajal kostab kõvasti ise ka Flip&Go turniirilt, nimelt võeti maha 5000-eurone bounty. Pole vaha 150-eurose sisseostu kohta.
12:38 (UTC+0)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Algas esimene paus Posted Saturday 29th July, 2023 at 12:21(UTC+0) by maheaaatom
Väga sisukad ning haaravad esimesed kaks mängutaste on selja taga.
Kohtume põhiturniiri vaatajatega juba 15 minuti pärast.
12:20 (UTC+0)
Start of Level 18 Blinds: 0/0 Ante: 0
Maurit hammustanud Urmo eskorditi alumisele korrusele Posted Saturday 29th July, 2023 at 12:18(UTC+0) by maheaaatom
High-Roller Urmo Velvelt saadeti just telelauda, mis võimadab kõikide ülekande vaatajatel elada juba peagi kaasa tõeliselt kõrgetasemelisele Eesti mängijale.
Enne seda jõudis ta aga teha tõsiselt haiget Mauri Dorbekule. Jooksis kokku set vs. set ( vs. ning Mauril jäi kõigest umbes 100K järgi. Urmo stäkk aga juba 558K.
Player
Chips
Progress
Urmo Velvelt
558,000
198,000
Mauri Dorbek
100,000
220,000
49. koht - Keito Kaljulaid 2400 € Posted Saturday 29th July, 2023 at 12:14(UTC+0) by maheaaatom
Pokkeris palju tegusid teinud Saaremaa meeste Kaljulaidude dünastia liige Keito Kaljulaid lõpetab turniiri 49. kohaga.
Keito näitas sisukat mängu nii esimesel kui teisel päeval. 18. tasemel jäi tema stäkk küll juba alla keskmise. Hea töö ikkagi!
Player
Chips
Progress
Keito Kaljulaid
0
0
Miks sul emandaid ei olnud? Oops... Posted Saturday 29th July, 2023 at 12:11(UTC+0) by maheaaatom
11. lauas on all-in'is kaks mängijat, üks neist Jaana Kindsigo.
Mõlemad avavad ning diiler asub kaarte lauda panema.
"Miks sul kuningad on? Sul oleksid pidanud emandad olema," nokib Jaana oma vastast. Vaevalt jõuab ta oma lause lõpetada, kui diiler avab riverisse emanda.
"Oops, sul oleks võinud siis hoopis poisid olla," naerab Jaana. Mõlemad mängijad korjavad oma žetooonid tagasi.
Player
Chips
Progress
Urmo Velvelt
558,000
198,000
Mauri Dorbek
100,000
220,000
50. koht - Ranno Sootla 2400 € Posted Saturday 29th July, 2023 at 12:08(UTC+0) by maheaaatom
10-20XBB vahel virelenud Ranno Sootla ei suutnud rongi alt pääseda. Täna tasuks 50. koht, natuke abiks ikka. Vähemalt on Rannol hea võimalus ka 3000 € High-Rolleril kätt proovida (see turniir algab kell 15:00)
Oleme jõudnud 49 parimani.
Meie mängijate punktiseisud Posted Saturday 29th July, 2023 at 11:48(UTC+0) by maheaaatom
Endiselt 54 parimat konkurentsis.
Player
Chips
Progress
Siim Suviste
390,000
2,000
Urmo Velvelt
360,000
10,000
Magnus Pukk
320,000
1,000
Igor Pihela noorem
280,000
20,000
Tarmo Tammel
240,000
35,000
Keito Kaljulaid
210,000
97,000
Ranno Sootla
85,000
27,000
Mauri kaotab hiigelpanga Posted Saturday 29th July, 2023 at 11:40(UTC+0) by maheaaatom
Mauri avab EP-lt -ga, mille vastab eestlasi varemgi palju kimbutanud (muuhulgas ka eile emandatega Markku Koplimaa ässad tapnud) Vlads Dolgilevics 38K ületõstega.
Selle järel läheb all-in üks shortstack (61K) ning Mauri paneb veelgi otsa (95K), saades Vladsilt calli.
Flop on , Mauri alustab 60K panusega, lätlane vastab 150K-ga ja saab calli.
Turn on ning lätlane lükkab all-in. Mauri mõtleb pikalt, kuid foldib.
Vlads avab ! (hästi tabatud turn), shortstackil oli . Seega kokkuvõttes ikkagi õige fold. Mauril umbes 320K järgi.
Player
Chips
Progress
Mauri Dorbek
320,000
270,000
Jaana kiljub Posted Saturday 29th July, 2023 at 11:32(UTC+0) by maheaaatom
Jaana Kindsigol õnnestus oma -ga nut-rida saada ning oma stäkk duubeldada. Tal on hetkel umbes 300K, mis on umbes keskmine punktisumma.
Player
Chips
Progress
Jaana Kindsigo
300,000
168,000
Telelaud käimas Posted Saturday 29th July, 2023 at 11:30(UTC+0) by maheaaatom
Eestlastest on telelauas Herli Olop ja Andrei Mjagkov.
56. koht - Kaspar Laursoo 2400 € Posted Saturday 29th July, 2023 at 11:26(UTC+0) by maheaaatom
Esimesel päeval eestlastest parimat mängu näidanud Kaspar Laursoo vaevles pikalt kaardisurmas ega suutnud ka täna oma stäkki üles saada. Ometi, vähemalt viimases käes oli selleks hea võimalus.
Kaspar sai nupud sisse -ga ning kaasa kuulsa pokkerimiljonäri Anatoly Filatovi, kes sooritas calli enda sõnul "väga halva käega". Selleks oli , kuid jaotuse võitmiseks sellest ometi piisas. Turn poiss.
Jätkab 54 parimat.
Player
Chips
Progress
Kaspar Laursoo
0
0
57. koht - Kaido Mikk 2200 € Posted Saturday 29th July, 2023 at 11:22(UTC+0) by maheaaatom
Mulluse Coolbet Open Tallinn põhiturniiri võitja Kaido Mikk ei suutnud kogu turniiri vältel kuigi suurt stäkki saada, kuid rahadesse tulekuks oli seda ometi piisavalt.
Kahjuks ei jõudnud aga mees kõrgemale 57. kohast. Preemiaks 2200 eurot.
Player
Chips
Progress
Kaido Mikk
0
0
Ilya tõuseb Posted Saturday 29th July, 2023 at 11:19(UTC+0) by maheaaatom
Äsja maja flopanud Ilya Nikiforov on tõusnud juba 650K peale, mis on võimas avaldus.
Ilya on kõva mängumees, Eesti läbi aegade edetabeli üheksas. Tema suurimaks kordaminekuks on WSOP turboturniiri kolmas koht, kuid mullu võitis ta näiteks Kings of Tallinna High-Rolleri.
Ranno uskumatu kannatus Posted Saturday 29th July, 2023 at 11:08(UTC+0) by maheaaatom
Ranno on mänginud kogu teise päeva lõpu ning ka kolmanda alguse uskumatult kannatlikult ning väike stäkk enamat võimaldagi.
2200 eurot pole kindlasti see, mida Ranno sooviks, sest ainuüksi sisseostudele kulus tal suurem summa.
Jaana Kindsigo ongi alustanud multi-table'ima, mis pole niivõrd lihtne - tema laud 555 € turniiril asub sisuliselt saali teises otsas. Aga Jaana on käbe ning selleks ei kulu tal üle paarikümne sekundi. Jaana stäkk umbes 180K.
Igor ja Tarmo Posted Saturday 29th July, 2023 at 10:58(UTC+0) by maheaaatom
Tarmo Tammel ja Igor Pihela on justkui vennad - mõlemad on mänginud pikalt ühes lauas ning alustasid ka päeva sendi pealt sama punktisummaga (170 000).
Esimese 50 minutiga on Igor oluliselt juurde hankinud ning Tarmogi on natuke lisanööpe saanud. Igoril juba üle 300K.
Player
Chips
Progress
Igor Pihela noorem
300,000
130,000
Tarmo Tammel
205,000
35,000
Esimene money-jump Posted Saturday 29th July, 2023 at 10:51(UTC+0) by maheaaatom
Põhiturniiril on alles 61 parimat ning natuke aega tagasi toimus ka esimene money-jump, mis tagas kõikidele allesjäänutele vähemalt 200 eurot ekstrat. Õnneks vahepeal ühtegi eestlast rohkem langenud pole, meie mehi on sees kuraditosin ning naisi täpselt üks - Jaana Kindsigo.
Naised turniiripileti jahil Posted Saturday 29th July, 2023 at 10:49(UTC+0) by maheaaatom
5 garanteeritud piletiga naisteka satikal on hetkel hetkel 34 mängijat (alustas 37). Nende seas on nii mõnedki hästi tuntud tegijad nagu Christel Haller, Kristi Kirs, Katre Kokk ja Ave Lepik, kes kõik löövad igal juhul kaasa ka 150-eurosel naistekal, mis algab kell 15:00.
Mis aga kõige parem, naisteka satikal osalemine on täiesti TASUTA!
Mauri ja Urmo korjavad lisa Posted Saturday 29th July, 2023 at 10:44(UTC+0) by maheaaatom
Mauri Dorbek kaebas enne kolmanda päeva algust, et tema laud on väga raske - vastased head ning neil lisaks ka suured stäkid. Üheks vastaseks on muide Eesti high-roller Urmo Velvelt.
Hea on aga see, et mõlemad mehed on suutnud esimese poole tunni saginaga oma seisu parandada - Mauril on 590K ning Urmol 370K.
Player
Chips
Progress
Mauri Dorbek
590,000
120,000
Urmo Velvelt
370,000
119,000
Multi-Jaana Posted Saturday 29th July, 2023 at 10:39(UTC+0) by maheaaatom
Põhiturniiril ainsa Eesti naisena rahadesse jõudnud Jaana Kindsigol õnnestus pääseda ka 555 € turniiri teise päeva, seega peaks ta hetkel mängima üheaegselt kahte turniiri.
Kuigi suurt stäkki tal põhiturniiril küll paraku pole, seega proovib Jaana seda kibekiiretsi üle saada. Viimane all-in -ga vastu lõppes lõppes igatahes panga poolitamisega.
66. koht - Jargo Alaväli 2000 € Posted Saturday 29th July, 2023 at 10:27(UTC+0) by maheaaatom
Jargo Alaväli kuulus küll pikka aega turniiri liidrite sekka, kuid teise päeva lõpp ning esimese algus polnud talle sugugi armulised.
Päeva alustas mees pisut enam kui 20XBB-ga ning kõrgela tõusta kahjuks ei õnnestunud.
Player
Chips
Progress
Jargo Alaväli
0
0
69. koht - Martin Piik 2000 € Posted Saturday 29th July, 2023 at 10:24(UTC+0) by maheaaatom
Martin Piik alustas tänast turniiri 12 000 punkti ehk kahe suure blindiga. Seega polnud ka tema väljalangemises midagi üllatuslikku.
Player
Chips
Progress
Martin Piik
0
0
10:20 (UTC+0)
Start of Level 17 Blinds: 3,000/6,000 Ante: 6,000
Kolmas päev on alanud Posted Saturday 29th July, 2023 at 10:13(UTC+0) by maheaaatom
Mängijad on laudades kohal ning just pandi käima ka kolmas päev. Täna mängitakse eeldavatalt kuni finaallauani, kuid kui mäng peaks venima väga pikaks, siis on võimalik, et see peatatakse ka varem.
Samaaegselt on käimas veel naisteka satelliit (osaleda saab TASUTA!), Bounty-turniiri teine päev, Flip&Go finaal, High-Rolleri supersatikas ning ka 350-eurone hiinakas. Ühesõnaga möllu kui palju!
10:11 (UTC+0)
Day 3 of Kings of Tallinn Summer Showdown 2023 Started Level: 16 Blinds: 2,000/5,000 Ante: 5,000
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
ning Tarmo avab 180K-ga. Sakslane callib.
järel läheb Tarmo all-in. Katab Grossi ilusti.
, soomlasel aga 
) ning ka oluline eelis - lauast on paar käes. 
on Phil Gross oma 270K-ga keskel ning Urmo Velvelt callib kiirelt. No mis sel pagana sakslasel siis ikka olla saab?
, kuid Gross nagu nõiutult 
vs. 
järel checkib Urmo ette, Tarmo paneb 70K ja saab calli.
, nüüd haarab ohjad juba Urmo - 160K. Tarmolt call.
ning Urmo panustab 275K. 
, Philil pole aga ässa, viite ega üldse midagi...
-ga, Urmol oli 
tõi võidu shortstackile. Oh seda rõõmu, naeris ka Urmo.
-ga. 
üritab hoopis Herli initsiatiivi haarata, tehes omakorda 45K panuse. 
ning siin aetakse ka nupud sisse. Ega soomlasel polegi rohkem kui 152K, Siimul seevastu umbes 900K nupukuhi.
kui ka turni 
annab vastasele tõmbeid juurde, turn
-ga pocket kuute vastu.
ning lätlane lükkab all-in. Mauri mõtleb pikalt, kuid foldib. 
-ga ning kaasa kuulsa pokkerimiljonäri Anatoly Filatovi, kes sooritas calli enda sõnul "väga halva käega". Selleks oli 
£ GBP
$ USD
€ EUR
