0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_estonian_championship_main_event'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0063 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.0004 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` = '2023_estonian_championship_main_event'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'
0.0249 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '64'
AND `published` = 1
0.0252 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '65'
AND `published` = 1
0.0254 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '67'
AND `published` = 1
0.0049 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` = '67'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'
AND `name` = '3'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '67'
ORDER BY `busted` ASC, `current_chips` DESC
0.0051 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` = '67'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3231'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3225'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3221'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3217'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3215'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3213'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3209'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3192'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3188'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3176'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3175'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3174'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3173'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3172'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3170'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3165'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3163'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3162'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3159'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3156'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3152'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3150'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3147'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3144'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3143'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3136'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3129'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3125'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3112'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3109'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3108'
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` = '3107'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3104'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3102'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3101'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3100'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3097'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3096'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3095'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '64'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '65'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '67'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '67'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3231'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3228'
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` = '3227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3225'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3221'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3217'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3215'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3213'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3209'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3192'
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` = '3190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3188'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3176'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3175'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3174'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3173'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3172'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3170'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3165'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3163'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3162'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3159'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3156'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3152'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3150'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3147'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3144'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3143'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3136'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3129'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3125'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3112'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3109'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3108'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3107'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3104'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3102'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3101'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3100'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3097'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3096'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3095'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '67'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2020
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.
Day 3 of Estonian Poker Championship Ended Level: 25 Blinds: 30,000/60,000 Ante: 60,000
EMV põhiturniiri võitja on Kaidar Viikman - 14699 € Posted Saturday 15th April, 2023 at 21:56(UTC+2) by maheaaatom
Finaali kuuenda punktisummaga alustanud Kaidar Viikman sai EMV põhiturniiril teenitud võidu. Jah, täna jooksid tal tõepoolest ka kaardid kõige paremini (ainuüksi kolm ässade paari), kuid turniiripokkeris ei põhine võit ometi ainult kaardiõnnel.
Kaidari algus oli luurav, kuid mäng edenedes muutus ta järjest agresiivsemaks ning lõpuks suutis ka oma nimekad konkurendid üle kavaldada. Ässadega Taago Tamme bluffima meelitamine oli puhas klassika. Sellega haaras Kaidar ohjad kindlalt ette kätte ega loovutanud neid enam kellelegi.
See on Kaidar kolmas Eesti meistritiitel. Tõsise töömehe, ETPF-i hinge ning suure pokkerisõbrana on Kaidar tähtsaima Eestisisese pokkeriturniiri võidu igati välja teeninud ning väärt ainult kiidusõnu!
Nende positiivsete nootidega me tänaseks lõpetame ning täname kõiki, kes jälgisid EMV 2023 live-blogi. Aga seda lehte ei tasuks veel kinni panna, sest Olympic Casinos jätkub paaride turniir ning ETPF-i aastagala. Viimase päevakokkuvõte leiate juba pühapäeva hommikul siitsamast OlyBetEvents.com lehelt.
2. koht - Taago Tamm 14400 € Posted Saturday 15th April, 2023 at 21:49(UTC+2) by maheaaatom
Kõik pole veel lõppenud, sest turn annab Taagole pea hea portsu oute. Aga kohele neist siiski ükski ei jõua, sest river on blank . Turniir on lõppenud, Taagole ägeda mängu eest tasuks 14400 eurot.
Player
Chips
Progress
Kaidar Viikman
4,920,000
1,820,000
Taago Tamm
0
0
21:43 (UTC+2)
Start of Level 25 Blinds: 30,000/60,000 Ante: 60,000
Mehed teevad diili Posted Saturday 15th April, 2023 at 21:39(UTC+2) by maheaaatom
Järjekordne all-in - Taagol ning Kaidaril on vastu panna . Laud toob Taagole veel ühe üheksa juurde ning duubli 1,8M peale.
Kuulsime ka diilist, millega mõlemad teenivad vähemalt 14 400 eurot ning võitjale jääb 299 eurot ekstrat.
Player
Chips
Progress
Kaidar Viikman
3,100,000
700,000
Taago Tamm
1,800,000
600,000
Taago Tamm jääb ellu Posted Saturday 15th April, 2023 at 21:35(UTC+2) by maheaaatom
Juba paistis, et mäng on läbi, mis läbi, sest Taago on keskel -ga Kaidar Viikmani vastu.
Aga show läheb siiski edasi, sest Taago tõmbab lauast rea kokku!
Pidu läheb aina hoogsamaks, laval on bänd.
Taago kaotus kasvab Posted Saturday 15th April, 2023 at 21:33(UTC+2) by maheaaatom
Taago üritab veelkord bluffida, kuid Kaidar callib ta tuimalt maha. Nüüd on Taagol järgi veel vaid 430K ning ta on juba enam kui 1:10 taga.
Player
Chips
Progress
Kaidar Viikman
3,100,000
700,000
Taago Tamm
1,800,000
600,000
Algas ETPF-i auhinnagala Posted Saturday 15th April, 2023 at 21:27(UTC+2) by maheaaatom
Õhtujuht Andres Puusepp on laval ning juhatamas sisse ETPF-i aastagalat. Samuti on sõna võtmas Olympic Casino pokkerimänedžer Meelis Ahman.
Paaride turniiril on sees 14 parimat. Vaikselt läheb edasi ka põhiturniiri heads-up. Mäng on üsna luurav, Kaidar on veel pisut lisa saanud ning juhib hetkel juba umbes 6:1.
3. koht - Andrey Koks 9300 € Posted Saturday 15th April, 2023 at 21:17(UTC+2) by maheaaatom
Andrey Koks lükkab oma shortstäki sisse -ga ning saab calli Kaidar Viikmani -lt.
Taaskord on kaardijumalad Kaidari poolel. Turn on !
Turniiri mõnda aega lausa ülivõimsa ülekaaluga juhtiv Andrey saab tasuks kolmanda koha eest 9300 eurot auhinnaraha, mis on mehe senise live-karjääri suurim.
Head-up algab Kaidari 3:1 eduseisus (Kaidar 3,8M, Taago 1,2M). Väike tehniline paus.
Player
Chips
Progress
Kaidar Viikman
3,800,000
800,000
Taago Tamm
1,200,000
100,000
Andrey Koks
0
0
Kaidar seab Taagole lõksu ja läheb liidriks Posted Saturday 15th April, 2023 at 21:11(UTC+2) by maheaaatom
Taago Tamm ründab -ga ning pocket ässad saanud Kaidar lihtsalt callib. Flopis on . Taago paneb 150K ja saab jällegi vaid calli.
Turni järel paneb Taago juba 300K ning call järgneb ka nüüd.
River on ning Taago lähebki oodatult all-in. Loomulikult Kaidar callib ning võtab hiiglasliku 3M panga maha.
Tema nüüd ka selgelt uus chipliider. See võis vabalt olla selle turniiri võtmekäsi.
Player
Chips
Progress
Kaidar Viikman
3,000,000
1,800,000
Taago Tamm
1,100,000
1,100,000
Andrey Koks
790,000
25,000
4. koht - Kaido Koorits 7000 € Posted Saturday 15th April, 2023 at 21:03(UTC+2) by maheaaatom
Finaali liidrina alustanud pokkeristaar Kaido Koorits on kahjuks mängust väljas.
Viimaseks käeks jääb flip pocket neljadega Kaidar Viikmani vastu. Turn on äss.
Player
Chips
Progress
Kaido Koorits
0
0
Laksakas Kaidole Posted Saturday 15th April, 2023 at 20:55(UTC+2) by maheaaatom
Kaido () üritab taas panka jõuga maha võtta. Vastas Taago Tamme .
Flopis on ning Taago avab 125K-ga, kuid Kaido vastab 360K ülestõstega.
Taago ei jää passima ning läheb all-in. Selle järel foldib Kaido koheselt.
Taago ja Kaido pushivad kordamööda Posted Saturday 15th April, 2023 at 20:48(UTC+2) by maheaaatom
Kui ei pushi Kaido, siis pushib Taago. Ja kui Taago ei pushi, on Kaido nupud keskel. Kaido stäkk on taas tõusnud üle miljoni.
Enim kannatab selles möllus kõige rahulikumalt mängiv Andrey. Kaidar on justkui kaval rebane, kes ootab rahulikult oma kohti. Ja lehed on Kaidaril täna väga hästi jooksnud.
Kaido saab Valerilt noomida Posted Saturday 15th April, 2023 at 20:44(UTC+2) by maheaaatom
Turniiridirektor Valeri käib vahepeal Kaidot noomimas ja palub tal nupud korralikult tornidesse laduda ja stäkki mitte varjata. Karistust siiski ei järgne, piirdutakse hoiatusega.
Kaido ja Taago on endiselt kõige aktiivsemad mängijad, kuid meeste stäkkides on oluline vahe. Taago on chipliider, Kaidol aga väikseim stäkk.
Player
Chips
Progress
Taago Tamm
2,200,000
500,000
Kaidar Viikman
1,200,000
100,000
Andrey Koks
765,000
15,000
Kaido Koorits
735,000
565,000
Ave ja Kristo ei pidanud suurele pingele vastu Posted Saturday 15th April, 2023 at 20:37(UTC+2) by maheaaatom
Paaristurniiri favoriidid Kristo Erala ja Ave Lepik on mängust väljas. Viimased nupud kaotas Kristo ja need võttis ära Teele Viira.
Teelel on muide hirmuäratavalt suur stäkk ning ajaloost on teada, et temagi on just nimelt selle turniiri ühel korral varem võitnud. Täna mängib Teele koos Mairold Millertiga.
20:35 (UTC+2)
Start of Level 24 Blinds: 25,000/50,000 Ante: 50,000
KÜSIMUS: Kui kaugel on paaride turniir? Posted Saturday 15th April, 2023 at 20:33(UTC+2) by maheaaatom
Ja VASTUS: 20 parimat paari on konkurentsis.
Põhiturniiri finaal läks samuti edasi ning kasiinosse on juba omajagu rahvast kogunenud. Näiteks vastne viiekordne Eesti meister Marko Kolk tuli kohale just selleks, et oma meistrisõrmus kätte saada. Paaristurniiril ta ei osale.
Kaido mängus tagasi Posted Saturday 15th April, 2023 at 20:15(UTC+2) by maheaaatom
Kaido Koorits on mängus tagasi!
Duubel tuleb läbi Kaidar Viikmani - Kaidol on ja Kaidaril . Kicker peab kuni lõpuni, Kaidol nüüd taas 1,3 miljonit.
Chipliider endiselt Taago Tamm 1,7M. Seisud muutuvad kogu aeg ja pidevalt. Algas järjekordne paus, tõenäoliselt mitte viimane tänasel turniiril.
Player
Chips
Progress
Taago Tamm
1,700,000
746,000
Kaido Koorits
1,300,000
300,000
Kaidar Viikman
1,100,000
600,000
Andrey Koks
780,000
68,000
Kaido duubeldab läbi Kaidari Posted Saturday 15th April, 2023 at 20:06(UTC+2) by maheaaatom
Kaido lükkab enne floppi sisse ja saab Kaidarilt callib.
Kaido:
Kaidar:
Flop ja turn on Kaidarile ohutud, riverisse avatakse aga ! Oh neid emotsioone!
Player
Chips
Progress
Kaido Koorits
520,000
480,000
Kaidar loputab Kaidoga põrandat Posted Saturday 15th April, 2023 at 19:59(UTC+2) by maheaaatom
Kaidar on vahepeal vist lõvikonservi söönud, sest tal on piisavalt julgust Kaido bluff pärast lauas avatud kaarte kuningas-kõrgega ära callida. Õige otsus, Kaidol on vaid . Hea kättemaks finaali alguses saadud "laksude eest" ning 450K pank Kaidarile.
Kaido on juba väga raskes seisus, tal vaid 9xBB. Aga senine mäng on näidanud, et kuni sul on chippe ja tool, kus istuda, on kõik alles ees.
5. koht - Erik Põlluveer 4800 € Posted Saturday 15th April, 2023 at 19:52(UTC+2) by maheaaatom
Erik peab suruma ning on selleks väga hea käsi.
Vastas Taago Tamme , kes saab kohe flopist ühe ässa juurde. Midagi ei muuda ka turn ega river. Ja vahepeal lausa lootusetus seisus olnud Taago Tamm on sisuliselt chipliider.
Tubli töö Erik, kuigi üks koht jäi olulise edetabeli võitmiseks kahjuks puudu. EMV 2023 Aasta Mängija on seega Ermo Kosk. Palju õnne!
Player
Chips
Progress
Erik Põlluveer
0
0
Stäkkide seis Posted Saturday 15th April, 2023 at 19:44(UTC+2) by maheaaatom
Player
Chips
Progress
Kaidar Viikman
1,700,000
500,000
Kaido Koorits
1,000,000
372,000
Taago Tamm
954,000
379,000
Andrey Koks
848,000
127,000
Erik Põlluveer
355,000
427,000
Andrey duubeldab läbi Kaido Posted Saturday 15th April, 2023 at 19:39(UTC+2) by maheaaatom
Andrey lükkab oma 10XBB stäki sisse ja saab Kaido Kooritsalt calli.
Andrey:
Kaido:
Flop sobib suurepäraselt Andreyle, kuid turn viib hoopis Kaido ette. Kas kõik? Ei. River toob Andreyle masti.
Taago võtab duubli läbi Eeriku Posted Saturday 15th April, 2023 at 19:30(UTC+2) by maheaaatom
Taago Tamm ja Erik Põlluveer on enne floppi sees:
Taago:
Erik:
Erikul on stäkk kaks korda suurem, ta on tugevalt ees ning kaalul ei vähem ega rohkem kui "Aasta Mängija" tiitel.
Paraku on flopis ja üheksa eluga Taago jätkab mängu.
Paaride turniiril sai hiline regamine läbi Posted Saturday 15th April, 2023 at 19:25(UTC+2) by maheaaatom
Paaride turniiril käib mäng 10 400 eurole ning sisseoste oli 52. Erinevaid paare peaks olema 40-45 vahel.
Äsja oli paaride turniiril ka paus ning lõppes hiline registeerumine. Melu on hea ning lauad lõbusaid inimesi täis.
Chipliidrist chiplooseriks? Posted Saturday 15th April, 2023 at 19:15(UTC+2) by maheaaatom
Andrey on veelgi langenud, nüüd juba umbes 500K peale.
Ja ega ta väga julge all-in ka minna, just foldis Andrey Taago Tamme all-in'i peale võrdlemisi korraliku . Tuletame meelde, et mingis faasis oli Andreyl umbes sama palju chippe kui teistel kokku. Paraku muutus sellega aga ka Andrey enda mäng liiga passiivseks ning konkurendid kasutasid seda ära.
Suurturniiride kogemus on Andreyl hea, kuid päris nii tugeva live-turniiri finaallauas ta varem veel mänginud ei ole.
Kui kaua täna läheb? Posted Saturday 15th April, 2023 at 19:12(UTC+2) by maheaaatom
Mullu vältas finaal üheksa ja pool tundi. See tähendaks, et täna käiks mäng sel juhul kella 22:30-ni.
9-11 tundi oleks ka finaali prognoositav kestvus. Tõsi, kell 21:00 algab gala ning lavale tuleb ka bänd, kuid põhiturniir läheb ikka edasi ning küllap jõutakse võitjale ka gala ajal auhind üle anda.
Kõik sõltub muidugi ka sellest, kes lõppmängu jäävad. Hetkel paistab, et meil on kaks aktiivset, kaks passiivset ning üks keskmine mängija. Agressoriks on endiselt Kaido, kes on kahel eelmisel käel vastaseid kiusanud.
19:03 (UTC+2)
Start of Level 23 Blinds: 20,000/40,000 Ante: 40,000
Stäkkide seis Posted Saturday 15th April, 2023 at 19:01(UTC+2) by maheaaatom
Player
Chips
Progress
Kaidar Viikman
2,200,000
700,000
Erik Põlluveer
782,000
295,000
Andrey Koks
721,000
479,000
Kaido Koorits
628,000
20,000
Taago Tamm
575,000
625,000
Kaidar survestab...lõpuks! Posted Saturday 15th April, 2023 at 18:57(UTC+2) by maheaaatom
Andrey ( ) tuleb blinde sööma, Kaidar Viikman () vastab all-in'iga. Küllap ka selleks, et tema järel istuva üsna ettearvamatu ning agressiivse Taago Tamme analoogset panust ennustada.
Kõik foldivad. Tubli Kaidar, julge mäng! Finaali alguses suure chipliidi saavutanud Andrey on langenud juba alla 800K.
46 paari Posted Saturday 15th April, 2023 at 18:52(UTC+2) by maheaaatom
Paaride turniirile on lisandunud mõned uued paarid ning nüüd on tehtud juba 46 sisseostu. Tõsi, mõned neist on ka väljalangenud paaride re-entryd.
Kristol ja Avel polegi just kuigi suur stäkk. Aga turniir on siiski ka selgelt algfaasis.
Vaikselt hakatakse valmistuma ka aastagalaks, vahuveini pokaalid (kuigi tühjad) on igatahes valmis pandud.
Kaido võtab natuke tagasi Posted Saturday 15th April, 2023 at 18:45(UTC+2) by maheaaatom
Kaido ja Taago on mõlemad actioni-mehed ja seekord on Kaido see, kes Taago ületõstele all-in'iga vastab.
Kuna Taago ilmselgelt bluffis, siis ta all-in'i vaatama ei lähe.
Järgmises jaotuses on all-in Erik Põlluveer, taaskord calle saamata. Jälle kaotab natuke raha Andrey Koks.
Ja ülejärgmine jaotus - Kaido saab ässad ning soodsa olukorra, Taago tuleb tema blindi kallele. Paraku piisab vaid pisikesest ületõstest, et Taago loobuks.
Kaidar taas liidriks, Taagol 1,2M Posted Saturday 15th April, 2023 at 18:41(UTC+2) by maheaaatom
Taago ja Andrey vaatavad floppi . Andrey on küll selgelt ees ( vs. ), kuid Andrey õnnetuseks on turn . See checkitakse küll läbi ja pärast riverit teeb Taago pisikese panuse, mis meelitab Andrey callima.
Korralik pank Taagole ja Andrey langeb 1,2M peale.
Järgmises jaotuses on taas superkaart Kaidaril - . Kaido üritab seda panka blufiga maha võtta ning kaotab pea poole oma stäkist. Liidriks tõuseb taas Kaidar.
Player
Chips
Progress
Kaidar Viikman
1,500,000
300,000
Taago Tamm
1,200,000
877,000
Andrey Koks
1,200,000
500,000
Kaido Koorits
608,000
492,000
Erik Põlluveer
487,000
90,000
Erik jääb ellu Posted Saturday 15th April, 2023 at 18:33(UTC+2) by maheaaatom
Erik on keskel -ga, kuid tema õnnetuseks on Kaidar Viikman TAAS (!!!) kaardi leinud ning mõistagi ei kavatse oma -st loobuda.
Flop midagi head ei tõota. Hoopis parem on turn , mis toob Erikule portsu oute. Ja üks neist - - jõuab ka kohale. Pank pooleks!
Kaido läheb taas Kaidarist mööda Posted Saturday 15th April, 2023 at 18:31(UTC+2) by maheaaatom
Kaidar teeb bluffari kuulsusega Kaido vastu järjekordse hero-calli, kuid seekord Kaido ei bluffinudki. Ebaõnnestunud käik läks maksma ligi 300K.
Juba järgmises käes üritab Kaidar () meelitada algset tõstjat Kaidot () vähemalt callima. Ei - panus oli liiga suur (200K) ning Kaido ei soovinud gämblema minna.
Kas Erik kangutab end "Aasta Mängijaks"? Posted Saturday 15th April, 2023 at 18:25(UTC+2) by maheaaatom
Kui Erik Põlluveeril õnnestuks veel üks väljalangemine üle elada, oleks tee "Aasta Mängija" tiitlile vaba.
Lihtne see aga olema ei saa, sest Erik on chiplooser. Äsja preflopist 4-bet all-in'i teinud Taago Tamm (, calle ei tulnud) korjas oma stäkile 50% lisa ning ronis taas Erikust mööda.
Stäkkide seis Posted Saturday 15th April, 2023 at 18:21(UTC+2) by maheaaatom
Player
Chips
Progress
Andrey Koks
1,700,000
100,000
Kaidar Viikman
1,200,000
100,000
Kaido Koorits
1,100,000
100,000
Erik Põlluveer
577,000
232,000
Taago Tamm
323,000
0
18:19 (UTC+2)
Start of Level 22 Blinds: 15,000/30,000 Ante: 30,000
Kaidar püüdis Taago blufi Posted Saturday 15th April, 2023 at 18:08(UTC+2) by maheaaatom
Viimane käsi enne teist pausi pakkus taas korraliku intriigi. Riveriks on lauas
ning Kaidari () pisikesele panusele vastab Taago Tamm () 225K re-raise'iga.
Kaidar mõtleb küll pikalt, kuid alla ei anna. Õnnestunud call tõstab ta 1,1M peale, blufiga armetult vahele jäänud Taago potsatab 323K-le.
Oleme niisiis pausil.
Player
Chips
Progress
Kaidar Viikman
1,100,000
228,000
Taago Tamm
323,000
246,000
6. koht - Mario Jürgens 3900 € Posted Saturday 15th April, 2023 at 17:59(UTC+2) by maheaaatom
Mario ( ) alustab 51K tõstega, Kaido Koorits () vastab all-in'iga. Ja Mario - võrdlemisi üllatuslikult - callib! Tõsi, tema stäkk oli ka suhteliselt väike, mängu jäi panna vaid umbes 9XBB jagu.
Flop toob küll seitsme, kuid ei enamat. Jätkab viis parimat.
Player
Chips
Progress
Kaido Koorits
1,200,000
100,000
Mario Jürgens
0
0
Kaidar tõuseb Posted Saturday 15th April, 2023 at 17:51(UTC+2) by maheaaatom
Kaidar saab Mario Jürgensi käest suure panga. Mõlemad mehed said flopist reatõmbe ning kuigi Kaidar oma oli väiksem, jõudis just see pärale.
River tõi Kaidarile lisaks ka masti, mis küll midagi ei muutnud. Ta lükkas ka all-in, kuid Mariol ilmselgelt millegagi callida ei olnud. Pank oli siiski suur ja Mario langes 11xxBB peale.
Järgmies jaotuses parandab oma positsiooni pisut Erik Põlluveer, kelle saab jagu Taago Tamme pocket kümnetest. Kuigi palju raha keskele küll paraku ei lähe ning emand-high flopile pihta saanud Erik mängib taas võib-olla liigagi rahulikult.
Andrey on väga rahulikuks jäänud Posted Saturday 15th April, 2023 at 17:43(UTC+2) by maheaaatom
Andrey Koks on küll endiselt chipliider, kuid mängib ülirahulikult. Initsiatiivi hoiab pigem Kaido Koorits, kuigi Andreyl on 800K suurem stäkk.
Kõik ülejäänud pigem ootavad õigeid kohti. Üsna hästi on edenenud aga Taago Tamm, kes on vaikselt tõusnud samasse kohta, kus ta päeva alguses oli.
Player
Chips
Progress
Andrey Koks
1,800,000
200,000
Kaido Koorits
1,100,000
387,000
Taago Tamm
745,000
176,000
Erik jätab ilmse võidukäe callimata Posted Saturday 15th April, 2023 at 17:35(UTC+2) by maheaaatom
Erik ( ) ja Taago () vaatavad floppi , ka turn ei too üllataval kombel actionit.
Riveri järel lükkab Taago oma 215K stäki keskele.
Kuigi Erikul on kaks paari ning juba pangas olevat raha arvestades peaks see olema instacall, foldib ta oma käe pika mõtlemise järel. Nii läheb raskeks EMV "Aasta Mängijaks" saada.
Player
Chips
Progress
Taago Tamm
569,000
171,000
Erik Põlluveer
345,000
159,000
Mängijate stäkid Posted Saturday 15th April, 2023 at 17:25(UTC+2) by maheaaatom
Player
Chips
Progress
Andrey Koks
2,000,000
100,000
Kaidar Viikman
872,000
90,000
Kaido Koorits
713,000
262,000
Erik Põlluveer
504,000
249,000
Mario Jürgens
415,000
68,000
Taago Tamm
398,000
164,000
37 paari Posted Saturday 15th April, 2023 at 17:17(UTC+2) by maheaaatom
Just niipalju pokkeripaare on paaride turniiril mängus. Selgituseks - mängitakse ühe stäkiga kuniks nuppe jätkub. Võib ka ühe re-entry teha.
Baarileti ääres õnnestus näha ka Marko "Naxer" Keskelit, kes jäi eile ülinapilt ilma Flip & Go turniiri tiitli kaitsmisest. "Tal oli viimases jaotuses vist üks blind rohkem. Mul mast, tal kaks paari, riveriga sai maja kätte," meenutab endiselt VIIEKORDNE Eesti meister Naxer oma öiseid üleelamusi.
7. koht - Rivo Tamm 3200 € Posted Saturday 15th April, 2023 at 17:09(UTC+2) by maheaaatom
Päeva suuruselt teise stäkiga alustanud Rivo on jäänud niivõrd lühikeseks, et -ga pole tal enam midagi oodata või mõelda.
Call tuleb seekord Kaidar Viikmanilt (). Juba flopis on kaks ruutut ning turn toob Kaidarile ka masti kohale.
Player
Chips
Progress
Kaidar Viikman
807,000
25,000
Rivo Tamm
0
0
Kaido viga jätab Taago mängu Posted Saturday 15th April, 2023 at 17:02(UTC+2) by maheaaatom
Floppi vaatab kolm mängijat - Andrey, Kaido ja Taago.
Taago ( ) lükkab oma 124K stäkinatukese keskele ja saab kiirelt calli Andreylt (). Seejuures viskab Kaido oma käe () maha.
Saatuslik viga, sest Andrey laua abiga midagi kokku ei saa, Kaido oleks aga kõrgema kickeriga Taago välja võtnud.
Paaristurniiri favoriit saabus Posted Saturday 15th April, 2023 at 16:55(UTC+2) by maheaaatom
Kui põhiturniiri võib võita kes iganes, siis paaristurniiril on selge favoriit juba ammu paigas.
Mõistagi on selleks Ave Lepik, kes viimasel viiel-kuuel aastal vist ainult ühel korral esikolmikust välja jäänud.
Tiitli on ta võitnud koos Gert Laanemetsaga. Mullu tuli Ave teiseks, toona mängiti aga koos 2017. aasta EMV põhiturniiri meistri Kristo Eralaga. Sama pokkeriduo asub heitlusesse ka täna.
Kaidar kaotab "Chuck Norrisele" Posted Saturday 15th April, 2023 at 16:46(UTC+2) by maheaaatom
Flop on Kaidarile mööda mis mööda. Ta checkib ette ja Kaidol piisab teha väike bluff, et pank maha korjata.
16:41 (UTC+2)
Start of Level 21 Blinds: 12,000/24,000 Ante: 24,000
Blind blindi vastu Posted Saturday 15th April, 2023 at 16:35(UTC+2) by maheaaatom
300K stäkiga Erik ründab SB-lt ja BB-l -ga istuv Kaido Koorits peab pika mõttepausi.
Erikul pole just ülearu tight mängija reputatsiooniga, lisaks on Kaidol ka suht hea tõmbekaart.
Ei, vara veel. Lõpuks Kaido siiski foldib.
Paarimängijad kogunevad Posted Saturday 15th April, 2023 at 16:31(UTC+2) by maheaaatom
Olympic Park kasiinos on juba näha erinevaid Eesti pokkerimängijaid, kelle eesmärgiks kell 17:00 algav paaristurniir.
Kohal on juba näiteks Kristo Erala, Maili Tannbaum, Mati Pirn, Kert Raud jt. Mõned neist vaatavad ka TV ekraanilt põhiturniiri live-ülekannet.
Kaido võtab Andreylt tagasi Posted Saturday 15th April, 2023 at 16:29(UTC+2) by maheaaatom
Kaido () ja Andrey () vaatavad floppi . Andrey checkib ette ja Kaido teeb 83K panuse.
Turn on , mis checkitakse läbi. Riveri järel läheb Andrey 80K-ga proovima, kuid see panus on selgelt liiga väike, et Kaidot eemale peletada.
Call tuleb ning Kaido kraabib 476K panga endale.
Player
Chips
Progress
Andrey Koks
2,100,000
100,000
Kaido Koorits
975,000
253,000
Kaido ründab shortstäkke Posted Saturday 15th April, 2023 at 16:22(UTC+2) by maheaaatom
Kaido istub nii Mario kui Taago suhtes positsioonil ning ei anna neile hõlpu. Kui talle jagatakse, lükkab mees kohe nuppe. Blindidel olevatel shortidel midagi head käes ei ole ja tulevad kiired foldid. Aga mänguruumi neil jälle märksa vähem...
Suured poisid omavahel Posted Saturday 15th April, 2023 at 16:15(UTC+2) by maheaaatom
Kaido Koorits tuleb -ga blinde sööma ja saab kaasa chipliider Andrey Koksi ( ).
Flop sobib mõlemale.
Andrey checkib, Kaido paneb 56K ja saab calli.
Turn ei muuda midagi. Kaido poolt läheb seekord sisse 126K ja Andrey ei jäta siingi callimata.
River . Andrey checkib ette ja Kaido proovib 266K blufiga panka kätte saada.
Andrey mõtleb päris pikalt, lausudes viimaks "Doesn't make any sense". Ja callib ära.
Nüüd on Andrey juba ülivõimas chipliider ja Kaido langeb lihtsurelike sekka.
Player
Chips
Progress
Andrey Koks
2,200,000
500,000
Kaido Koorits
722,000
478,000
15:51 (UTC+2)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
8. koht - Kaur Ajamaa 2500 € Posted Saturday 15th April, 2023 at 15:50(UTC+2) by maheaaatom
Kaidar: ! Turn ega river Kauri ei päästa ning tal jääb napp 14K alles. Järgmises jaotuses võtab Kaidar sellegi ära. Kaurilt siiski väga korralik saavutus, kaks aastat järjest EMV finaallauda pääseda on kõva sõna!
Pärast jaotuse lõppu algas finaali esimene paus, oleme tagasi 15 minuti pärast.
Player
Chips
Progress
Andrey Koks
1,700,000
100,000
Kaido Koorits
1,200,000
0
Kaidar Viikman
782,000
286,000
Rivo Tamm
382,000
97,000
Mario Jürgens
347,000
67,000
Erik Põlluveer
255,000
180,000
Taago Tamm
234,000
32,000
Kaur Ajamaa
0
0
Erik ei julge Posted Saturday 15th April, 2023 at 15:43(UTC+2) by maheaaatom
Erik Põlluveer läheb küll , kuid Rivo Tammel on niivõrd hea reputatsioon, et tema all-in käigule Erik ei vasta.
Oli õige otsus ka, sest Rivol tõepoolest parem kaart ().
9. koht - Kristjan Maasalu 1700 € Posted Saturday 15th April, 2023 at 15:36(UTC+2) by maheaaatom
Andrey avab 35K tõstega ning Kristjan Maasalu vastab 177K all-in'iga. Andrey callib.
Andrey:
Kristjan:
Flopis avatakse kaheksa ning pärast turni on Kristjan drawing dead.
Player
Chips
Progress
Andrey Koks
1,800,000
280,000
Kristjan Maasalu
0
0
Andrey võtab veel juurde Posted Saturday 15th April, 2023 at 15:27(UTC+2) by maheaaatom
Kaks panka järjest võitnud Andrey on tõusnud juba üle 1,5M ning hoiab konkurentidel survet. Tõsi, tal on kaarte ka olnud.
Kõrgeim agressioonifaktor ning iseäranis table-talki eestvedamine on aga selgelt Kaido käes. Kõige passiivsem on siiani olnud Rivo.
Player
Chips
Progress
Andrey Koks
1,520,000
320,000
Mariole duubel Posted Saturday 15th April, 2023 at 15:19(UTC+2) by maheaaatom
Mario lükkab -ga ja saab vastu all-in panuse Taago Tamme -lt.
Flopis on poiss ning Mario jääb mängu. Nüüd on Taago seis juba õige hapuks läinud, tal vaid 266K järgi.
Player
Chips
Progress
Mario Jürgens
414,000
199,000
Taago Tamm
266,000
47,000
Ka Kaido käib all-in Posted Saturday 15th April, 2023 at 15:13(UTC+2) by maheaaatom
Suurima stäkiga Kaido Koorits näitab, et ka tema oskab all-in lükata. See on vastuseks Kristjan Maasalu tõstele -ga. Vastuseks kiired foldid (Kaidol on pocket poiste paar).
Väheke sai juurde Taago Tamm, kes nägi ära, et flop läks kõigile mööda ning oskas õiges kohas bluffida.
Taagol julgust jätkub Posted Saturday 15th April, 2023 at 15:04(UTC+2) by maheaaatom
Taago Tamm käib oma 313K stäkiga all-in'is ning sunnib foldima ka Kaur Ajamaa . Taagol polnud muide enamat -st.
Suur pank Kaurile Posted Saturday 15th April, 2023 at 15:01(UTC+2) by maheaaatom
Kaur Ajamaa parandab oluliselt oma seisu, tõmmates juurde 165K punkti. Lõviosa sellest tuleb Rivo Tammelt.
Kauril olid pocket soldatid, Rivol suur hulk tõmbeid, mis küll ükski kohale ei jõudnud.
Turniiri selged liidrid on aga endiselt Kaido ja Andrey, kõik ülejäänud on alla keskmise stäkkidega. Varsti läheb paugutamiseks, pange tähele!
Mängijate punktiseisud Posted Saturday 15th April, 2023 at 14:58(UTC+2) by maheaaatom
Player
Chips
Progress
Andrey Koks
1,200,000
100,000
Kaido Koorits
1,200,000
100,000
Kaidar Viikman
496,000
48,000
Rivo Tamm
479,000
402,000
Erik Põlluveer
435,000
48,000
Taago Tamm
313,000
38,000
Kristjan Maasalu
268,000
40,000
Kaur Ajamaa
250,000
89,000
Mario Jürgens
215,000
8,000
Kristjan duubeldab, Mario uus shortstäkk Posted Saturday 15th April, 2023 at 14:53(UTC+2) by maheaaatom
Kristjan lükkab emandatega ja saab vastu teise väikese stäki Mario Jürgensi . Lauda numbripuru ja Kristjanile taas duubel. Chippide üldarvult läheb ta nüüd napilt Mariost mööda.
Player
Chips
Progress
Kristjan Maasalu
228,000
94,000
Mario Jürgens
223,000
129,000
Mario käib all-in'is Posted Saturday 15th April, 2023 at 14:43(UTC+2) by maheaaatom
Mario läheb -ga röövima, kuid Taago Tamm 3-panustab (75K) kaartidega . Mario ei anna alla.
Kuningas-high flopi järel ei soovi Mario midagi juhuse hooleks jätta ning lükkab kiirelt all-in. Loomulikult pole Taagol enam millegagi callida.
Ei ole see päev Taagole hästi alanud...
Player
Chips
Progress
Taago Tamm
390,000
115,000
Mario Jürgens
341,000
11,000
14:40 (UTC+2)
Start of Level 19 Blinds: 8,000/16,000 Ante: 16,000
Kristjan Maasalu saab duubli Posted Saturday 15th April, 2023 at 14:34(UTC+2) by maheaaatom
Kristjan Maasalu läheb proovima ja saab vastu Taago Tamme (). Flopis nii poiss kui üheksa.
Finaalis endiselt üheksa alles, Kristjan on tagasi samas seisus, mis päeva alguses.
Player
Chips
Progress
Kristjan Maasalu
134,000
46,000
Andrey võtab Kaurilt tagasi ning saab samuti miljonäriks Posted Saturday 15th April, 2023 at 14:32(UTC+2) by maheaaatom
Järgmies jaotuses jagatakse Andreyle täna juba teist korda pocket ässad ning õnnetul kombel saab Kaur Ajamaa () õnnetul kombel top-paarile pihta.
Andrey korjab valuet kõikidel tänavatel ning saab korraliku panga. "Valus," tõdeb Kaur.
Player
Chips
Progress
Andrey Koks
1,100,000
316,000
Kaur Ajamaa
339,000
212,000
Kaido võtab Andreylt valuet Posted Saturday 15th April, 2023 at 14:27(UTC+2) by maheaaatom
Ässaga mastitõmbe saanud Kaido meelistab Andrey bluffima ja korjab check-raise'iga umbes 130K panga maha.
Järmises jaotuses saab Andrey ( ) küll emand-high flopis kenasti pihta, kuid ei panusta. Checkid sobivad Kaidole ( ), kes saab turnist ässa ning omakorda ise kõrgeima paari.
Kaido on kaval ning võtab valuet nii turnil kui riveril. Saab makstud ka.
Player
Chips
Progress
Kaido Koorits
1,300,000
300,000
Andrey Koks
784,000
168,000
Kaido liidriks Posted Saturday 15th April, 2023 at 14:14(UTC+2) by maheaaatom
Veel ühe väikese panga võitnud Kaido tõusis miljoni chipini ning võttis liidripositsiooni Andreylt üle.
Player
Chips
Progress
Kaido Koorits
1,000,000
8,000
Kaido näksab Kaurilt Posted Saturday 15th April, 2023 at 14:12(UTC+2) by maheaaatom
Neli mängijat vaatab floppi . Kaur avab 35K-ga ja saab calli vaid positsioonilt istuvalt Kaidolt.
Turn on ning nüüd Kaur checkib. Kaido paneb nüüd 45K ja Kaur muckib.
(Meeste kaardid: Kaur ja Kaido )
Kaidol on nüüd peaaaegu sama palju kui Andreyl.
Kristjanil selg vastu seina Posted Saturday 15th April, 2023 at 14:06(UTC+2) by maheaaatom
Kristjan Maasalu stäkk on langenud 88K peale, mis on vaid 7XBB.
Esimese pooltunni selgelt agressiivseimaid mängijad on Andrey, Kaido ja Taago. Neist viimasele on lahtine mäng küll üsna kalliks maksma läinud...
Eriku, Mairo, Kaidari ja Mario pole veel agressiooni näidanud.
Player
Chips
Progress
Kristjan Maasalu
88,000
42,000
Andrey tõuseb uueks liidriks Posted Saturday 15th April, 2023 at 14:00(UTC+2) by maheaaatom
Andrey, Kaido ja Taago vaatavad esimese eestvõtmisel 110K-ga emand-high floppi.
Andrey tulistab 75K ja korjab panga maha. Tal nüüd 952 000, mis viib ta mängu liidriks.
(Kõigil meestel olid käes paarid - Andreyl soldatid, Kaidol kaheksad ja Taagol kolmed).
Player
Chips
Progress
Andrey Koks
952,000
174,000
Erik korjab kõvasti juurde Posted Saturday 15th April, 2023 at 13:55(UTC+2) by maheaaatom
Erik ja Taago vaatavad floppi . Erik panustab 32K ja saab Taagolt calli.
Turn on ning Erik avab taas 105K panusega. Taago callib jälle
River on ning see chekitakse läbi.
Erik avab , Taagol on untsu läinud mastitõmme -.
Meeste stäkid nüüd suhteliselt võrdsed: Taagol 505K ja Erikul 483K
Player
Chips
Progress
Taago Tamm
505,000
213,000
Erik Põlluveer
483,000
201,000
Mis on täna veel kavas? Posted Saturday 15th April, 2023 at 13:32(UTC+2) by maheaaatom
Kell 17:00 algab paaristurniir ning kell 21:00 aastagala. DJ Alvar Orula käis ka just oma varustust paika sättimas, tema hakkab meist lõbustama õhtupoole.
Kommentaator Kristjan Laas on samuti kohal ning köhib just oma häält puhtaks.
Veel veerand tundi ülekande alguseni!
Kellest saab EMV 2023 Aasta Mängija? Posted Saturday 15th April, 2023 at 13:27(UTC+2) by maheaaatom
Hetkeseis Aasta Mängija arvestuses on järgmine:
Ermo Kosk 59 punkti
Markku Koplimaa 48 punkti
Marko Kolk 42 punkti
Erik Põlluveer 38 punkti
Ermo, Markku ja Marko enam punkte juurde teenida ei saa. Erik Põlluveer võidab juhul kui saavutab põhiturniiril vähemalt neljanda koha. Esikolmikusse võib tõusta ka Kristjan Maasalu (parimal juhul teiseks), kuid selleks on vaja ideaalset asjade kokkulangemist.
Põhiturniiri finaal on alanud! Posted Saturday 15th April, 2023 at 13:15(UTC+2) by maheaaatom
Turniiridirektor Meelis Ahman juhatas mängijad pidulikult laudadesse ning tehti ära ka finaallauda pildid.
Täpselt kell 13:14 läks mäng käima. Kuna nii meie ülekanne kui live-stream on 30-minutilise viivitusega, siis põhiturniiri uuendustega läheb veel natuke aega.
Põhiturniiri finalistide tutvustus Posted Friday 14th April, 2023 at 10:46(UTC+2) by maheaaatom
Kaido Koorits
Punkte: 992 000
Eesti meistritiitleid: 4
Koht Hendoni Eesti rahalistis: 35
Kaido on elukutseline pokkerimängija ning avalikkusele ka selgelt tuntuim finalist. Oma esimese meistritiitli võitis ta juba 2011. aastal ning viimase alles mullu paarismängus. Kaido tugevuseks on nii agressiivne mängustiil kui table-talk, lisaks on tal ka suurim stäkk. Seega hoiab tõenäoliselt just Kaido finaallauas tempot.
--
Rivo Tamm
Punkte: 881 000
Eesti meistritiitleid: 0
Koht Hendoni Eesti rahalistis: 526
Rivo teekond finaallaua suuruselt teiseks stäkiks kulges otsekui märkamatult. Teda polnud küll ülearu näha, kuid targad otsused ning õiged käigud tagasid kokkuvõttes edu. Rivol on kaks EMV põhiturniiri cashi ning 10 aastat tagasi jõudis ta ka finaallauda, saavutades toona kuuenda koha.
--
Andrey Koks
Punkte: 778 000
Eesti meistritiitleid: 0
Koht Hendoni Eesti rahalistis: 259
Sarnaselt Rivole polnud ka IT-taustaga Andrey mäng põhiturniiri esimesel ja teisel päeval ülearu silmatorkav, küll aga tulemuslik. Alati sõbralik Andrey on mänginud pokkerit üle 10 aastat ning korjanud erinevatelt Eestis toimuvatelt turniiridelt ka ridamisi neljakohalisi cashe. Eriti aktiivseks on ta muutunud aga just viimasel aastal.
---
Taago Tamm
Punkte: 718 000
Eesti meistritiitleid: 0
Koht Hendoni Eesti rahalistis: 69
Erinevalt kahest eelmisest mehest paistis Taago turniiri esimestel päevadel vägagi silma. Ta jõudis olla korduvalt ka turniiri chipliider ning mängis üldse väga aktiivselt. Deep-stack turniirid Taagole sobivad, ta on olnud selles formaadis võidukas nii Kings of Tallinnal kui Tallinn Summer Showdownil. Mullusel Battle of Maltal jõudis ta koguni kahel päeval järjest poodiumile. Kindlasti alustab Taago ka EMV põhiturniiri finaali vaid võidumõtetega.
---
Kaur Ajamaa
Punkte: 551 000
Eesti meistritiitleid: 0
Koht Hendoni Eesti rahalistis: 232
Kaur on ambitsioonikas ja kirglik mängija, kellel on samuti üsna korralik live-mängude kogemus. Ta on ainus põhiturniiri finalist, kes jõudis sinna ka eelmisel aastal (toona viies koht). Tõenäoliselt üsna ebamugav vastane kõigile.
---
Kaidar Viikman
Punkte: 448 000
Eesti meistritiitleid: 2
Koht Hendoni Eesti rahalistis: 347
ETPF-i tööhobusena tuntud Kaidar Viikman jäi teel finaali väga tagasihoidlikuks, tuues esile hoopis vastaste head taset. See võis aga olla vaid sõjakavalus. Kaidaril on kaks EMV tiitlit, tohutu mängukogemus ning ta oli muuseas ka see mees, kes sai teise koha 12 aastat tagasi toimunud tollasel maailma läbi aegade suurimal online-turniiril (200 000 osalejat).
---
Mario Jürgens
Punkte: 330 000
Eesti meistritiitleid: 0
Koht Hendoni Eesti rahalistis: 930
Mario alustas EMV põhiturniiri turbopäevast (muide koos Taago Tammega), mille ta ka võitis. Teisel päeval pidas mehe stäkk samuti ilusti vastu. Live-pokkeris on Mario finalistidest võib-olla isegi kõige tundmatum, kuid cashe on ta noppinud näiteks nii tänavusel kui ka mullusel Kings of Tallinnal.
---
Erik Põlluveer
Punkte: 282 000
Eesti meistritiitleid: 2
Koht Hendoni Eesti rahalistis: 218
Erik on Kaido ja Taago kõrval kolmas raskekaallane, kelle ainsaks nõrkuseks on suhteliselt väike stäkk. Kogemusi on mehel kõvasti ning ka tänavustel tiitlivõistlustel on Erik kulgenud soodsas pärituules. High-rolleril teine, 8-Game'is kolmas, Pot Limit Omaha Hi-Lo's kuues... Vähemalt neljas koht põhiturniiril tagaks talle suure tõenäosusega ka EMV "Aasta Mängija" tiitli.
---
Kristjan Maasalu
Punkte: 130 000
Eesti meistritiitleid: 0
Koht Hendoni Eesti rahalistis: 158
Kristjan on hästi tuntud kõikidele Eesti hobimängijatele. Ta on mänginud üle 10 aasta peamiselt väikese sisseostuga turniire ning olnud paljudel neist ka edukas. 2019. aastal oli ta EMV põhiturniiril kümnes, nüüd on seegi saavutus ületatud. Ainus häda on selles, et Kristjani stäkk on paganama väike. Aga üks duubel, siis teinegi...ja ega tea midagi!
EMV põhiturniiri finaal algab kell 13:00 Posted Friday 14th April, 2023 at 09:52(UTC+2) by maheaaatom
Laupäeval selgub Olympic Park kasiinos EMV tähtsaima, 555-eurose sisseostuga põhiturniiri tšempion. Samuti toimub paaristurniir ning pidulik auhinnagala.
Meie blogi toimub telelauaga sünkroonis ning põhiturniiril toimuvast kirjutame seega 30-minutilise nihkega (seega alustame umbes kell 13:30-13:45). Paaristurniirist ja muust põnevast kirjutame aga reaalajas. Ülekanne toimub kuni põhiturniiri võitja selgumiseni. Eelkõige sobib blogi neile pokkerifännidele, kes ei soovi kogu aeg telepilti vaadata, kuid olla siiski kursis kõige olulisemate sündmuste ning finaali kulgemisega.
09:44 (UTC+2)
Day 3 of Estonian Poker Championship Started Level: 18 Blinds: 6,000/12,000 Ante: 12,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.