0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0072 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_estonian_championship_main_event/1/updates'
ORDER BY `views` DESC
0.0139 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_estonian_championship_main_event/1/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0041 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0006 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2023_estonian_championship_main_event'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'
0.0289 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '64'
AND `published` = 1
0.0288 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '65'
AND `published` = 1
0.0293 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '67'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'
AND `name` = '1'
0.0064 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.0069 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` = '64'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3003'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3002'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3001'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3000'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2999'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2997'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2996'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2993'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2992'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2991'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2990'
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` = '2989'
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` = '2988'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2987'
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` = '2986'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2985'
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` = '2984'
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` = '2983'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2982'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2981'
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` = '2980'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2979'
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` = '2978'
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` = '2977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2976'
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` = '2975'
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` = '2974'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2973'
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` = '2972'
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` = '2971'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2970'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2969'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2968'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2967'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2966'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2965'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2964'
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` = '2963'
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` = '2962'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2960'
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` = '2959'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2958'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2957'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2956'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2954'
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` = '2953'
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` = '2952'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2950'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2949'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2946'
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` = '2945'
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` = '2944'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2943'
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` = '2942'
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` = '2941'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2939'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2938'
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` = '2937'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2936'
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` = '2935'
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` = '2934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2933'
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` = '2932'
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` = '2931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2930'
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` = '2929'
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` = '2928'
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` = '2927'
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` = '2926'
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` = '2925'
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` = '2924'
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` = '2923'
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` = '2922'
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` = '2921'
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` = '2920'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2919'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2918'
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` = '2917'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2916'
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` = '2915'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2914'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2913'
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` = '2912'
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` = '2911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2909'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2908'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2907'
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` = '2906'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2905'
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` = '2904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2903'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2902'
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` = '2901'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 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.0061 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` = '64'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3003'
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` = '3002'
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` = '3001'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3000'
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` = '2999'
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` = '2998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2997'
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` = '2996'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2993'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2992'
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` = '2991'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2990'
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` = '2989'
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` = '2988'
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` = '2987'
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` = '2986'
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` = '2985'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2984'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2983'
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` = '2982'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2981'
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` = '2980'
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` = '2979'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2978'
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` = '2977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2976'
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` = '2975'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2974'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2973'
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` = '2972'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2971'
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` = '2970'
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` = '2969'
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` = '2968'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2967'
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` = '2966'
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` = '2965'
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` = '2964'
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` = '2963'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2962'
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` = '2961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2960'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2959'
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` = '2958'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2957'
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` = '2956'
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` = '2955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2954'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2952'
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` = '2951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2950'
ORDER BY `chip_change` DESC, `busted` ASC
0.0114 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2949'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2946'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2945'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2944'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2943'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2942'
ORDER BY `chip_change` DESC, `busted` ASC
0.0092 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2941'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2939'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2938'
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` = '2937'
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` = '2936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2935'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2934'
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` = '2933'
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` = '2932'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2931'
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` = '2930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2929'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2927'
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` = '2926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2925'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2924'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2923'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2922'
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` = '2921'
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` = '2920'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2919'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2918'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2917'
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` = '2916'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2915'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2914'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2913'
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` = '2912'
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` = '2911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2909'
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` = '2908'
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` = '2907'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2906'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2905'
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` = '2904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2903'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2902'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2901'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 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.0060 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.0060 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.0004 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 1 of Estonian Poker Championship Ended Level: 8 Blinds: 600/1,200 Ante: 1,200
EMV põhiturniiri esimene päev on läbi Posted Sunday 9th April, 2023 at 01:53(UTC+2) by maheaaatom
1B allesjäänud viis mängijat ajavad nupud kottidesse, et homme tagasi tulla. Seega jätkab põhiturniiri 67 mängijat, kelle kõigega kohtume juba kell 13:00. Kogu mäng käib 82 820 eurole.
1B saab läbi järgmiselt seisult:
Mario Jürgens, 119000
Taago Tamm, 109200
Paul Koppe, 101700
Priit Aavasalu, 97000
Roman Romanovskii, 23100
Head ööd!
Player
Chips
Progress
Mario Jürgens
119,000
0
Mario Jürgens
119,000
0
Paul Koppe
101,700
5,700
Priit Aavasalu
97,000
20,300
Roman Romanovskii
23,100
0
Kolm kuningat Posted Sunday 9th April, 2023 at 01:41(UTC+2) by maheaaatom
Mario ja Priit ajavad enne floppi taas panga suureks, kuid kui seal avatakse , jäävad mõlemad otsekui sõnatuks.
Turni järel proovib Mario 4000-ga, kuid Priit ei kavatsegi loobuda.
River checkitakse läbi. "Mul on maja...või õigemine ma vaatasin, et mul on maja," sõnab Mario ja heidab lauale .
See tähendab, et Priidul piisab ükskõik millistest muudest kaartidest panga võitmiseks. Ja mees võtabki selle -ga maha. "No ma tõesti vaatasin alguses, et mul on maja," pomiseb Mario.
Käsi, millega pole vähemalt häbi kaotada Posted Sunday 9th April, 2023 at 01:34(UTC+2) by maheaaatom
Martin Peek ja Priit Aavasalu on keskel pärast floppi ja turni .
Martin näitab flopanud rida (), Priidul on . Seekord on kaardiõnne Priidu poolt, river annab talle maja. Priidul on ka rohkem nööpe, seega jätkame 5-handed. Aga ega Martin ka kuigi õnnetu pole. Vähemalt käsi, millega pole häbi kaotada!
Taago õnnelik river Posted Sunday 9th April, 2023 at 01:27(UTC+2) by maheaaatom
Paul Koppe ja Taago Tamm vaatavad floppi . Taago checkib ette, Paul panustab 1200 ja saab calli.
Turn on ning kordub sama - Taago checkib, Paul paneb 4000 ja saab taas calli.
Riverisse avatatakse ning nüüd ründab 21400 panusega juba Taago.
Paul ei suuda foldida, Taago avab . Nice river!
Nupud püsivad Pauli ja Mario käes Posted Sunday 9th April, 2023 at 01:16(UTC+2) by maheaaatom
Paul Koppel on umbes 145K ja Mario Jürgensil 130K. Suht keskmise stäkiga on Taago Tamm, kolm ülejäänud mängijat on kõik selgelt alla keskmise.
Ühtlasi algas päeva viimane tase ning meil on mängida veel pool tundi. Blindid 600/1200/1200.
Mario kukutas veel ühe vastase Posted Sunday 9th April, 2023 at 01:10(UTC+2) by maheaaatom
Flopis on
Mario panustas 3200 ning Ilja-Ülo lükkas oma 17800 keskele.
"Sul on mastitõmme jah," uuris Mario, kuid callis siiski ära.
Ilja-Ülo avas , Mariol oli . Kõrgem kicker pidas, oleme 6-handed lauas.
Raigo Vaikma ässadest pole kasu Posted Sunday 9th April, 2023 at 01:02(UTC+2) by maheaaatom
Mario Jürgens ja Raigo Vaikma kukuvad nuppe lükkama pärast floppi . Mario juba vabandab ette, et tõenäoliselt võtab ta oma räpsuga Raigo välja...
Raigo avab uhkelt , Mariol on . Ja lähebki nii, nagu Mario "kartis". Riveris jookseb ruutu-tõmme kokku ja Raigo on mängust väljas.
1B-d jätkab 7, kogu avapäeva peale kokku 69 parimat.
Player
Chips
Progress
Raigo Vaikma
0
0
Paul jätkab liidrina Posted Sunday 9th April, 2023 at 00:55(UTC+2) by maheaaatom
Paul Koppel on endiselt ca. 125K stäkk ning Taagol umbes 100K kandis. Ka Mario Jürgens ei pea ka midagi häbenema, tal ca. 80K.
Kõigil ülejäänutel paistab olevat alla keskmise, kuid päris väike pole neist keegi. Mäng on üldiselt päris hoogne, nupud liiguvad käest kätte.
Mariuse tujutu mäng lõppes ebaõnnestunud flipiga Posted Sunday 9th April, 2023 at 00:49(UTC+2) by maheaaatom
Live-turniiride superäss Marius Morel ei paistanud täna kahjuks millegagi silma.
Viimased nupud läksid flipiga ( vs. ) Priit Aavasalule. Lauda ei midagi, mis oleks Mariust aidanud.
Jätkab 8 parimat.
Player
Chips
Progress
Marius Morel
0
0
Viimane tund Posted Sunday 9th April, 2023 at 00:42(UTC+2) by maheaaatom
Algas seitsmes tase (500/1000/1000) ning meil on täna veel täpselt tund aega mängida. Keskmine stäkk enam kui 80XBB.
Päeva 1B jätkab endiselt 9 mängijat. Koos päevaga 1A on seega järel 71 mängijat.
Taago ja Priit kemplevad Posted Sunday 9th April, 2023 at 00:35(UTC+2) by maheaaatom
Raigo Vaikma, Priit Aavasalu ja Taago Tamm vaatavad sõbralikult floppi . Seejärel läheb tõsiseks actioniks. Priit avab 1600-ga ning saab vastu 7200 panuse Taagolt. Priit callib.
Turn on , Priit checkib ette ja nüüd paneb Taago juba 9600.
Priit ei calli ja Taago võtab panga maha. Ta näitab ka reporteritele oma kaarte, kuid kuna ükski mängija neid ei näinud, ei tohi me neid ka siia kirja panna. Eks Priit võib pärast päeva lõppu ju Taagolt küsida.
1B "finaallaud" koos Posted Sunday 9th April, 2023 at 00:27(UTC+2) by maheaaatom
Jesus Ucero kukub oma -ga Roman Romanovskii otsa ning on mängust väljas. Allejäänud üheksa mängijat viidi ühele lauale.
Paul hoiab tempot Posted Sunday 9th April, 2023 at 00:19(UTC+2) by maheaaatom
Paul Koppe jätkab päeva 1B kaptenina ning tema stäkk on hetkel umbes 125K. Tõsi, mõnda aega tagasi andis ta Mariusele bad beadiga duubli, kuid on nüüd vaikselt jälle nupud tagasi korjanud. Üsna suur noos tuli Jesus Ucerolt, kes on nüüd lauas esimesena sihikul.
Käimas on kuues tase, blidid 400/800/800, endiselt 10 mängijat konkurentsis.
Player
Chips
Progress
Paul Koppe
125,000
29,000
Suurüllatuse ootel? Posted Sunday 9th April, 2023 at 00:10(UTC+2) by maheaaatom
Mullune EMV põhiturniir lõppes suurüllatusega - esikolmiku moodustasid vaid hobimängijad.
Kui vaadata praegust chippide seisu, võib sel aastal hobimängijaid veelgi rohkem tipus olla. Suurem osa tipp-proffidest on üldse puudu, hulk nimekaid staare kukkus ka avapäeval välja. Ja suurimad stäkidki on eranditult vaid hobimängijatel.
Mõnes mõttes on see just asi, mida me ootame. Mida rohkem uusi nimesid mänguga liitub ning mida rohkem nendest ka võita suudab, seda parem. Teisalt kerkib esile ka väike probleem - EMV põhiturniir hakkab muutuma pigem hobimängijate ja harrastajate vaheliseks mööduvõtuks, millest ei võta osa sugugi just Eesti absoluutne pokkeriparemik.
Mõned superstaarid eesotsas Mauri Dorbekuga on siiski kõrges mängus alles, saame näha, kuidas neil homme läheb.
Kaks cashilauda Posted Sunday 9th April, 2023 at 00:02(UTC+2) by maheaaatom
Käima on pandud ka teine cashilaud ning võimalik, et varsti alustab ka kolmas. Kuna bad beat Jackpot toob sisse lausa hiiglasliku summa, siis huvilistest puudu pole.
Cashi ja turnamängijate seltskond kattub küll vaid minimaalselt.
Veel kaks tundi mängida Posted Saturday 8th April, 2023 at 23:53(UTC+2) by maheaaatom
EMV põhiturniiri avapäev saab läbi umbes kell kolmveerand kaks.
Meil on veel kaks tundi mängida (hetkel tase 300/600/600), misjärel on täpselt selge kui palju inimesi homme jätkama pääseb.
1B-d juhib endiselt Paul Koppe.
Privador langes poistega Posted Saturday 8th April, 2023 at 23:49(UTC+2) by maheaaatom
Rain "Privador" Mölderkivi lükkas oma 20K keskele Paul Koppe vastu.
Paul:
Rain:
Laud midagi ei muutnud.
Player
Chips
Progress
Paul Koppe
96,000
21,500
Eesti meistrivõistluste põhiturniiril osaleb 164 mängijat Posted Saturday 8th April, 2023 at 23:46(UTC+2) by maheaaatom
Päeva 1B registeerumine on lõppenud ning enam keegi EMV põhiturniiriga liituda ei saa.
Kuna päeva 1A alustas 149 ning päeva 1B 15 mängijat, siis on EMV põhiturniiri lõplik osalejate arv 164 mängijat. Eelmisele aastale jääb see kahe mängijaga alla.
Mõnevõrra üllatav, sest turbopäevale oodati alguses siiski mõnevõrra rohkem mängijaid.
Mängijate stäkid pausi järel Posted Saturday 8th April, 2023 at 23:39(UTC+2) by maheaaatom
Kõige kobedam punktisumma on Priit Aavasalul (76700), heas seisus on ka Paul Koppe (74500), Taago Tamm (55000) ja Raigo Vaikma (55000).
Vahetult enne pausi langes välja ka Alar Neemsalu, kell jammingu callis ära Raigo Vaikma -ga. Alar mängis täna üldse kuidagi tujutult ja paugutas korduvalt ükskõik millise kaardiga.
Teiste stäkid on järgmised:
Martin Peek 49000
Roman Romanovski 25600
Mario Jürgens 22200
Ilja-Ülo Nukka 21400
Rain Mölderkivi, 20400
Jesus Ucero 19600
Marius Morel 18800
Player
Chips
Progress
Priit Aavasalu
76,700
0
Paul Koppe
74,500
0
Raigo Vaikma
55,000
0
Taago Tamm
55,000
0
Priidul on terasest munad Posted Saturday 8th April, 2023 at 23:25(UTC+2) by maheaaatom
Turniks oli lauas ja pangas tubli 15K. Juho lükkas oma allesjäänud nupud (ca. 10K) keskele ning Priit Aavasalu pidas pika mõttepausi.
Lõpuks Priit callis ning avas . Mis muud, kui paganama õige käik, sest vastas oli puhas bluff -ga. Siiski olid soomlasel mõned oudid, kuid Priidu õnneks river midagi ei muutnud. Ühtlasi algas ka päeva 1B esimene ja ainuke paus.
Joel J.A. Klasson langes välja Posted Saturday 8th April, 2023 at 23:19(UTC+2) by maheaaatom
Äsja lõviosa oma stäkist Paul Koppele kaotanud Joelil jäi alles vaid umbes 1500 punkti, mille ta järgmises jaotuses ka keskele lükkas.
Marius Morel vastas 3K ülepanusega ning kõik teised foldisid.
Joel:
Marius: . Joel sai küll flopist mastitõmbe, kuid pärale see ei jõudnud.
Alar aina lükkab ja lükkab Posted Saturday 8th April, 2023 at 23:14(UTC+2) by maheaaatom
Alar Neemsalu mängib väga lahtiselt ning on lühikese ajaga juba kolm korda all-in käinud.
"Ma ei viitsi mängida," pahvatab ta lõpuks. Calle pole siiani tulnud ja Alarl on suht korralik stäkk.
Lisandus veel üks mängija: Ilja-Ülo Nukka.
Ahti Käsi jooksis Taago ässade otsa Posted Saturday 8th April, 2023 at 22:57(UTC+2) by maheaaatom
Üsna lühikeseks jäänud Ahti Käsi jooksis oma -ga Taago Tamme otsa ning on sellega päeva 1B esimene langeja.
Võitja ehk Taago ei oska nagu midagi öelda. "Limpisin ässadega, teised hakkasid kütma. Easy call."
Suhteliselt vaikne õhtu Posted Saturday 8th April, 2023 at 22:50(UTC+2) by maheaaatom
Kuna Olympic Casinos hetkel mingit suuremat pidu ei käi, on tegemist suht tavapärase laupäeva õhtuga. Seda melu, mis oli 1A ajal, enam ei ole.
Cashgame käib ühel laual, kus mängijad on jahtimas hiiglaslikku Jackpotti. Turniiri reilib viis-kuus pealtvaatajat, valdavalt on tegemist Paul Koppe sõpradega.
Turbokaga liitus veel üks mängija - Mario Jürgens. Nüüd mehi juba 14.
Pauli ja Priidu stardikiirendus Posted Saturday 8th April, 2023 at 22:40(UTC+2) by maheaaatom
Paul Koppe ja Priit Aavasalu on suutnud esimese kahe mängutasemega oma stäki 40K peale kergitada. Nemad on ka päeva 1B hetkeliidrid.
Liitus ka 13. mängija - Juho Heiska. Jätkame endiselt kahes lauas.
1A mängujärgseid kommentaare Posted Saturday 8th April, 2023 at 22:30(UTC+2) by maheaaatom
Kert Raud lubab valmistuda paaristurniiriks, mida ta plaanib koos ühe sõbraga mängida. "Noh, ma loen enne ikka raamatuid ja õpin," lõõbib Kert.
Allan Arjut tõdeb, et chiplooserina teise päeva jõudmine polnud kindlasti eesmärgiks, "Üritasin lõpus shoveda, kuid ei leidnud kedagi."
Herli Olop kiidab jällegi Christelit. "Mõni teine oleks mu välja võtnud, kuid Christel säästis mind. Tal lihtsalt olid lõpus alati paremad kaardid ja ta lubas, et ei võta mind välja."
Katre Kokk ei taha üldse midagi lisada. Tema mäng jäi täna kahjuks õige lühikeseks. Aga õnneks on ees mitmeid teisi turniire!
Paul floppab masti Posted Saturday 8th April, 2023 at 22:23(UTC+2) by maheaaatom
Paul Koppe ja Rain Mölderkivi vaatavad floppi . Actioniks läheb pärast turni . "Privador" checkib ette, Paul paneb 2000 ja saab calli.
River on . Rain checkib taas, Paul paneb nüüd juba 3900 ning bluffi kartnud Rain callib nüüdki ära.
Paul avab flopanud nutsu . "Ah et kohe nii hästi," on Privador jahmunud.
Lisandus ka Taago Tamm Posted Saturday 8th April, 2023 at 22:15(UTC+2) by maheaaatom
Lauda istus ka Taago Tamm ning nüüd on turbotajaid juba tosinajagu.
Turboga saab liituda kuni esimese pausi lõpuni, mis peaks olema kuskil 23:40.
Ja nüüd päeva 1B juurde! Posted Saturday 8th April, 2023 at 22:10(UTC+2) by maheaaatom
Päevast 1B võtavad osa järgmised mängijad:
Priit Aavasalu
Ahti Käsi
Joel J. A. Klasson
Paul Koppe
Jesus Martinez Ucero
Rain Mölderkivi
Marius Morel
Alar Neemsalu
Martin Peek
Roman Romanovski
Raigo Vaikma
See turniir on juba toimunud 45 minutit ning midagi kuigi põnevat seal veel juhtunud pole. Kõik mängijad on lauas alles.
Päeva 1A kokkuvõte Posted Saturday 8th April, 2023 at 21:54(UTC+2) by maheaaatom
EMV põhiturniiri avapäevast 1A võttis osa 149 mängijat, kellest pääses jätkama 62 parimat. Liidrina lõpetas Rain Kandla (178 000), kuid edetabeli tipp on väga tihe. Vahetult Raini kannul on Ergo Maruste (172 800) ning Maikel Homin (167 100).
Vahetult lõpu eel juhtinud Andrey Koks andis kõvasti ära ning langes 180K pealt 63500-le. Lõpp polnud armuline ka Gert Laanemetsale, Madis Lepsile, Toivo Ojasoole ja Herli Olopile, kes ka kõvasti kaotasid, kuid püsivad siiski õnneks mängus.
Kuhu maandus aga vahepealne hirmvõimas chipliider Allan Arjut? Päeva viimasele kohale 12600 punktiga. Elu läheb edasi!
Turbokas algas Posted Saturday 8th April, 2023 at 21:28(UTC+2) by maheaaatom
Turbopäeva alustas 9 mängijat ning action toimub kahel laual.
Kõlavaimaks nimeks on Marius Morel, kuid kindlasti aitab actionit luua ka Paul Koppe. Paul ja Marius istuvad muide kõrvuti.
Päev 1A on läbi, Markku teise päeva ei jõua Posted Saturday 8th April, 2023 at 21:04(UTC+2) by maheaaatom
-ga mänginud Markku Koplimaa kaotab oma viimased nupud seti flopanud Martin Häidbergile.
Sellega on päev 1A ka läbi ning mängijad ajavad chippe kottidesse. Mängijate täpsed stäkid leiate juba õige pea.
Kohe peaks algama päev 1B, mida jätkame siinsamas lehel. Hetkel on koos umbes ühe laua jagu mängijaid. Väike paus, mille järel asume juba päeva 1B kallale.
Player
Chips
Progress
Markku Koplimaa
0
0
Raiko kaotab oma viimase flipi Posted Saturday 8th April, 2023 at 20:57(UTC+2) by maheaaatom
Raiko Murulauk lükkab oma viimased nupud sisse -ga, saades vastu märksa suurema stäkiga Tõnis Laumetsa . Lauda äss ning Raiko mäng selleks korraks läbi.
Player
Chips
Progress
Raiko Murulauk
0
0
2017. aasta EMV põhiturniiri võitja väljas Posted Saturday 8th April, 2023 at 20:50(UTC+2) by maheaaatom
Kristo Erala viimased nupud läksid -ga Gert Elmaste vastu. Oma stäkki Kristo täna kuidagi üles saada ei suutnud.
Väljas ka Mäido Kuusik ja Marko Vest, veel kümme minutit 1A lõpuni.
Player
Chips
Progress
Kristo Erala
0
0
Igor näitab kõrgeid torne Posted Saturday 8th April, 2023 at 20:44(UTC+2) by maheaaatom
Igor Pihela noorema ees on kõrged tornid, küll pole aga nende väärtus kaugeltki nii suur kui kaugelt paistab. Täiesti keskmine stäkk.
"Langesid äsja 30K peale, õnneks sain duublisse," räägib Igor ise. Viimati kaotatud pank talle aga rahu ei anna. "Mul BB-l , floppi tuleb . Viktor Mägi jammib, ma callin. Tal emandad, turn emand," kirjeldab Igor kaotatud jaotust.
Poole tundi 1A lõpuni Posted Saturday 8th April, 2023 at 20:28(UTC+2) by maheaaatom
Mängupäeva 1A lõpuni jääb veel umbes pool tundi.
Konkurentsis 68 mängijat, viimased väljalangejad on kõik teada-tuntud tegijad Sander Leigri, Mart Rinken, Marko Keskel, Jaagup Luhakooder, Marko Liblik ja Meelis Lepikult.
Player
Chips
Progress
Marko Keskel
0
0
Mart Rinken
0
0
Rahaboss Ergo Posted Saturday 8th April, 2023 at 20:23(UTC+2) by maheaaatom
Ergo Maruste pole täna küll ülearu palju mängulauas viibinud, kuid tema stäkk on võimas 150K. "Sain mõned head skalbid ja hakkasin vett jooma," naerab Ergo ise.
Väga korralik stäkk endiselt ka Andrey Koksil, ca. 180K.
Player
Chips
Progress
Andrey Koks
180,000
5,000
Ergo Maruste
150,000
0
Cashile! Posted Saturday 8th April, 2023 at 20:19(UTC+2) by maheaaatom
Avati ka cashgame ning Meelis Ahman tegi teatavaks, et Olympic Park Casino bad bead jackpot on hiiglaslik 31 419 eurot.
Nii suurt summat ei näe muide isegi põhiturniiri võitja. Ja Jackpoti saab kaotamise eest!
Martin võidab endalegi üllatavalt Posted Saturday 8th April, 2023 at 20:14(UTC+2) by maheaaatom
Martin Häidberg, Herli Olop ja Christel Piller vaatavad floppi . Martin ründab 3200-ga, Christel maksab.
Turn on , Martin paneb veel 4500 ja Christel ei lähe kuskile.
River on ning seekord Martin checkib. Samaga vastab ka Christel.
Martin näitab vastumeelselt ning on juba mõttes loobunud panga kaotusega, kuid ristit pole ka Christelil. Tal kõigest
Päeva 1A viimane tase on alanud Posted Saturday 8th April, 2023 at 20:04(UTC+2) by maheaaatom
Laudades on 73 pokkerisportlast, kes asuvad pidama tänast viimast võitlust. Kõik, kes sellest edukalt väljuvad, pääsevad jätkama homme kell 13:00 algaval teisel päeval.
Keskmine stäkk on 77265 punkti ehk pisut üle 60XBB. See tähendab, et mänguruumi on iseenesest küllaga. Samas vaevalt pakub kellelagi mõnu teist päeva vaid mõne üksiku žetooniga alustada. Küllap üritavad pisistäkid ikkagi end iga hinnaga üles saada.
20:02 (UTC+2)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Ermo Kosk langes Royali vastu Posted Saturday 8th April, 2023 at 19:58(UTC+2) by maheaaatom
Ermo Kosk paraku sellelt turniirilt oma karjääri seitsmendat Eesti meistritiilit ei saa. Oma viimased nupud (10XBB) läksid sisse -ga vastu.
Pange nüüd hoolikalt tähele ja kinnitage turvavööd: flopis avati ! "Päris uskumatu lugu, tegin sellest koguni pilti," näitas Ermo oma telefoni.
Väljas ka Roland Luik, Helina Tamm, Martin Piik, Aleksander Lammas, Silver Tiido, Yanis Mehdi Sahli, Arvo-Mart Elvisto, Tarmo Tammel ja Harry Liimal. Jätkab 74 parimat.
Player
Chips
Progress
Tarmo Tammel
0
0
Arvo-Mart Elvisto
0
0
Helina Tamm
0
0
Ermo Kosk
0
0
Roland Luik
0
0
3 naist Posted Saturday 8th April, 2023 at 19:52(UTC+2) by maheaaatom
Mängus on veel vaid kolm naist, kellest Christel Pilleril üsna mängitav 77K stäkk. Evelyl ja Airinil on üige napilt alla algstäki.
Evely tunnistab, et naisi võiks olla rohkem ning pakub välja, et järgmine aasta võiks korraldada ainult naistele mõeldud lisavalue'ga satelliite, et naiste pokkerit toetada. Miks mitte!
Joel ja Janek on pisut ära andnud Posted Saturday 8th April, 2023 at 19:43(UTC+2) by maheaaatom
Esimeste tasemete suurimad vaalad Joel Lindpere ning Janek Hin on omajagu ära andnud ning hetkel keskmiste (ca. 55-60K) stäkkidega.
Allan Arjut tiksub endiselt 40-50K vahel, sellest stäkist hoiab ta küünte ja hammastega kinni.
Player
Chips
Progress
Janek Hin
58,000
52,000
Joel Lindpere
57,000
4,000
Valik suuremaid stäkke Posted Saturday 8th April, 2023 at 19:41(UTC+2) by maheaaatom
Player
Chips
Progress
Andrey Koks
175,000
0
Eedi Kirves
152,000
0
Maikel Homin
150,000
0
Kaur Ajamaa
130,000
0
Gert Laanemets
101,000
31,000
Arko Akenpärg
100,000
0
Hispaanlaste read vähenevad Posted Saturday 8th April, 2023 at 19:22(UTC+2) by maheaaatom
Nn. peolauast (kus pidu on tegelikult ammu läbi, sest suurimad peoloomad ammu välja kukkunud) langes just sinna toodud hispaanlane Alberto Martinez Gonzalez, kes kaotas oma ministäki -ga Rivo Tamme -le.
Väljas on Tauri Küla, Robert Relander, Robin Tiits ja Maksim Petrov.
Kas turbot alustab tõesti vaid 3 mängijat? Posted Saturday 8th April, 2023 at 19:16(UTC+2) by maheaaatom
Turbokal on endiselt kirjas vaid kolm mängijat. Tõenäoliselt tuleb inimesi küll juurde, optimistlikult julgeks oodata nii 20-30 mängijat.
Hiliseid ärkajaid on palju, samuti neid, kes armastavad kiiret mängu. Enri Orav jpt.
19:15 (UTC+2)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
President jätab põhiturniiri vahele Posted Saturday 8th April, 2023 at 19:10(UTC+2) by maheaaatom
Kõigile, kes ootavad turniirile ETPF-i presidenti Laur Siboldit, peame edastama kurva sõnumi - Laur (ega ka mitte Ilona) sel aastal põhiturniiril ei osale.
Põhjuseks töö ja tegevus meelelahutusäris, mis ei jäta kolmapäevase turniiri mängimiseks lihtsalt aega. Laur Sibold on muide tulnud EMV põhiturniiril korra isegi teiseks. See juhtus 2021. aastal, mil temast sai jagu vaid hirmkuulus cashihai Taisto Janter.
Põhiturniiril ei osale ka näiteks Henri Käsper, tippässadest pole kindlasti kohal aga Ottomar Ladvat.
Proffide salanõupidamine? Posted Saturday 8th April, 2023 at 19:06(UTC+2) by maheaaatom
Tähelepanelikud inimesed on märganud, et iga pausi ajal kogunevad turniiril osalevad profimängijad (Koorits, Rinken jt.) Olympic Park kasiino vastas asuvasse Politseiparki ning peavad seal salanõu.
Huvitav, mis teemadel vestlus käib või käivad mehed end lihtsalt tuulutamas?
Mis proffidesse puutub, siis tuleb kahjuks tunnistada, et aasta-aastalt mängib EMV põhiturniiril muide järjest vähem elukutselisi mängijaid.
Päeva 1A viimane paus Posted Saturday 8th April, 2023 at 18:46(UTC+2) by maheaaatom
Mängijad lubati viimast korda jalgu sirutama (ja mõistagi ka flippama). Pärast seda jääb päeva lõpuni veel kaks 60-minutilist taset.
Konkurentsis on 90 mängijat, langenud on veel Ranel Käsi, Reido Sepp, Mark Metsla, Jordi Conejos Baixas ja Taavi Treiman. Ka Jaana Kindsigo on jätkajate nimekirjast kadunud.
Jätkame kell 19:00.
Player
Chips
Progress
Mark Metsla
0
0
Ranel Käsi
0
0
Rolandi suurepärane tõus Posted Saturday 8th April, 2023 at 18:43(UTC+2) by maheaaatom
Vahepeal vaid 7K-le langenud Roland Luik on nüüd umbes 100K stäkiga ning kuulub sellega liidrite sekka.
Steve Seller suutis mõned minutid tagasi oma 35K stäki Tauri Küla vastu duublisse saada - vs. . Samas lauas on Allan Arjut veelgi langenud ning nüüd on tema stäkk vaid 40K. Allan toob põhjuseks kahe flipi kaotamise. Vastasel juhul oleks ta lausa massiivne chipliider.
Player
Chips
Progress
Roland Luik
100,000
0
Üks stäkk tiksub tühja Posted Saturday 8th April, 2023 at 18:23(UTC+2) by maheaaatom
Üks stäkk tiksub üheksandas lauas tühja. (Selle omanik oma nime kohe kindlasti avaldada ei soovi, seega ei hakka me seda ka kirja panema). Igatahes meest ennast turniirialal ei ole.
Esimese viie ja poole tasemega on läinud kaotsi umbes kolmandik stäkist. Tea, kas päeva lõpuks sellest enam midagi alles jääbki.
Aga üheksandas lauas toimub muudki. Näiteks Toomas Orm suutis oma 18K stäki -ga Mart Rinkeni vastu duublisse saada. Flopis oli mastitõmme, river tõi lauda soldati.
Andrei Zevakin mängust väljas Posted Saturday 8th April, 2023 at 18:11(UTC+2) by maheaaatom
Tuhandete noorte iidol Andrei Zevakin lõpetas põhiturniiri avavaatuse 96. kohaga.
Väljas on ka Kert Raud, 2015. aasta põhiturniiri tšempion Kaupo Tenno ning Karli Kiin. Päeva 1A jätkab 93 pokkerisportlast.
Player
Chips
Progress
Andrei Zevakin
0
0
Kaupo Tenno
0
0
Kunn-kaheksa, no mis kaart sul on... Posted Saturday 8th April, 2023 at 18:05(UTC+2) by maheaaatom
Nii pahandab Tauri Külaga Allan Arjut, kes on langenud juba umbes 50K peale.
Viimane litakas tuli jaotuses, kus Tauri ja Allan vaatasid floppi . See chekiti läbi, turni järel pani Allan 5K ning riveri järel juba 10K. Tauri instacallis mõlemad tänavad ära ning avas . Allanil oli puhas bluff -ga.
Player
Chips
Progress
Allan Arjut
50,000
140,000
Rindeuudiseid Posted Saturday 8th April, 2023 at 17:55(UTC+2) by maheaaatom
Peeter Talviste annab duubli pisikese stäkiga (8K) Maksim Petrovile vs. .
Imre Leibold peab mõnda aega laua kõrval seisma ning jääb ühe ringi vahele. "Mind vist ei taheta sinna," mõtiskleb Imre, kuniks ta siiski lauda lubatakse.
Allan Arjut on omajagu ära andnud, tema stäkk umbes 100K kandis. Olevat seekord pocket kaheksatega kaotanud.
17:50 (UTC+2)
Start of Level 6 Blinds: 400/800 Ante: 800
Jõudsime sajani Posted Saturday 8th April, 2023 at 17:40(UTC+2) by maheaaatom
Turniiril on alles 100 parimat, seega oleme otsekui märkamatult saanud lahti igast teisest alustajast. Isegi pisut kiirem tempo, kui võis oodata.
Ohvrite nimistusse lisanduvad Jüri Kadak, Jimmy Philippe Dewerdt, Annika Haaviste, Dmitri Dudakov, Tapio Ilmari Aaltonen, Eha Pinsel, Tanel Evert, Tarmo Anton, Kert Hallik, Keito Kaljulaid, Kaius Kiidli, Danel Kunman ja Ruslan Stserbjuk.
Allani stiilinäide Posted Saturday 8th April, 2023 at 17:29(UTC+2) by maheaaatom
Allan Arjut mängib väga loose'ilt ja agressiivselt. Kuid kuna tal on oma laua ning ka turniiri suurim stäkk + teatav respect, siis naljalt teda keegi callima ei tule.
Tüüpiliseks näiteks on äsja nähtud 3-bet laua keskelt, millele reageeritakse tiuma mucki-ralliga.
Allan avab . "No mul oli ju päris hea või mis?" õrritab ta lauakaaslasi.
Veel üks suur stäkk - Lauri Liias Posted Saturday 8th April, 2023 at 17:12(UTC+2) by maheaaatom
Lauri Liias on hankinud 97K stäki, mis kuulub samuti turniiri suurimate sekka.
Lauri on EMV 2023-l juba ühe hea tulemuse teinud, nimelt jõudis ta heads-up turniiri poolfinaali.
Seal tuli küll alistuda hilisemale võitjale Martti Keelele, pronksimatšis ei hakanud Lauri hammas peale ka Kristo Eralale.
Turniiri liider on Allan Arjut Posted Saturday 8th April, 2023 at 17:04(UTC+2) by maheaaatom
Allan Arjut on suutnud ajada kokku 190K stäki, millele pole hetkel veel kellelgi vastast.
"Tegin nii, et panustasin 5K pimedalt. 30K stäkk läks all-in. Vaatasin ühte kaarti - kaheksa. Vaatasin teist kaarti ka - samuti kaheksa. Noh eks siis tuli muidugi callida. Äss-kunn, kaheksad pidasid," räägib Allan ise.
Väga suured stäkid on ka Janek Hinil ja Martin Häidbergil.
Player
Chips
Progress
Allan Arjut
190,000
0
Janek Hin
110,000
0
Martin Häidberg
98,700
19,500
Gert Elmaste
80,000
0
Rauno Arras
70,000
0
Gert Laanemets
70,000
0
1A lõplik osalejate number on 149 Posted Saturday 8th April, 2023 at 16:52(UTC+2) by maheaaatom
Pausi ajal ühtegi uut mänguhuvilist ei lisandunud, seega jäi lõplikuks 1A osalejate arvuks 149 mängijat. Neist 111 on lauas, viimasena langes konkurentsist juutuuber Robin Valting.
Player
Chips
Progress
Robin Valting
0
0
16:50 (UTC+2)
Start of Level 5 Blinds: 300/600 Ante: 600
Ta vist pani parema käe maha Posted Saturday 8th April, 2023 at 16:27(UTC+2) by maheaaatom
Helina Tamm ja Oskar Ojaveer vaatasid floppi . Helina checkis, Oskar panustas 3700 ning sai välkkiire calli. Turni avati , mis checkiti läbi. Riveri järel pani juba Helina 6200 ning Oskar muckis sekunditega. "Ta vist pani parema käe maha," naeris Helina.
Helinal on tubli 60K stäkk. Tema kõrval istuv Evely Pihela langes vahepeal päris pisikeseks, kuid suutis siis mastitõmbega pocket ässade vastu duublisse saada ning on mängus tagasi.
Veel mõned langejad: Johannes Siitan, Madis Otti, Sergei Oganesjan, Sigmar Heinpalu ja Kaspar Kaisel.
Ühtlasi algas turniiri teine paus, mille eel tegi Meelis Ahman tavapäraselt reklaami Flip & Go turniirile. Kõik, kes tahavad põhiturniiriga veel mängupäeval 1A liituda, peaksid seda nüüd tegema hiljemalt 15 minuti jooksul. Kes ei jõua, saavad aga osaleda turbopäeval, mis algab kell 21:00.
Oleme tagasi 15 minuti pärast.
Veel langejaid Posted Saturday 8th April, 2023 at 16:17(UTC+2) by maheaaatom
Lisaks eelpool mainitud Tomsonile ja Leinole on vahepeal langenud konkurentsist ka Ants Olev, Stanislav Smeljov, Raivo Pinsel, Robert Schmidt, Rikard Relander, Andres Lõiv ja Raimo Kaljulaid.
Saatuslik "all-in" kõlab juba päris sageli, kuigi keskmine stäkk on alles 75XBB.
Juba 149 mängijat Posted Saturday 8th April, 2023 at 16:14(UTC+2) by maheaaatom
Hilise registreerumise lõpuni jääb veel umbes pool tundi ning hetkel on päeva 1A alustanud juba 149 mängijat. Seda on mõnevõrra rohkem kui oodati, lisaks on üks stardipäev (kell 21:00 algav turbo) veel ees.
Homme on plaanis mängida kuni finaallauani, kuid hetkeseis näitab, et see võib tähendada enam kui 15 tunnist pokkerimaratoni.
"Eks me jooksvalt vaatame, mis seis on. Lisapäevi kindlasti ei tule, kuid kui asi peaks väga ekstreemseks minema, siis võib-olla päris finaallauni me ei mängi," kommenteeris Olympic Casino pokkerimänedžer Meelis Ahman. Tuleb arvestada, et esmaspäev on paljudele siiski tööpäev.
Täna polnud Leino päev Posted Saturday 8th April, 2023 at 16:06(UTC+2) by maheaaatom
Leino Piller purjetab oma 7K stäkiga keskele, saades vastu all-in panuse Mati Pirnilt.
Leino: , Mati . Flopis on kohe äss ning Leino mäng saab sellega mängitud.
"Peolaua" rikkur paistab olevat Ergo Maruste (ca. 45K), kes küll lauas ülearu sageli ei viibi. Nimelt on ta baarileti ääres lohutamas Priit Tomsonit, kes juba mõnda aega tagasi konkurentsist langes.
Sa loed nagu raamatut! Posted Saturday 8th April, 2023 at 15:57(UTC+2) by maheaaatom
13. lauas on vastamisi Markku Koplimaa ja Joel Lindpere.
Flopis on avatud . Joel checkib ette, Markku paneb 2800. "Palju sul taga on?" uurib Joel ning saab vastuseks, et üle 30K. Järgneb siiski call.
Turn on ning Joel checkib taas ette. Markku paneb nüüd juba 7200 ning seekord ei julge Joel enam vastu hakata.
"Kunnid jah?" uurib Markku. "Sa loed nagu raamatut," pomiseb Joel vastu. "Punased ka veel..."
Joeli sellest hoolimata kobe ca 80K stäkk.
Player
Chips
Progress
Joel Lindpere
80,000
27,000
15:53 (UTC+2)
Start of Level 4 Blinds: 200/500 Ante: 500
Herli ja Martin uhkustavad stäkkidega Posted Saturday 8th April, 2023 at 15:47(UTC+2) by maheaaatom
Kõrvuti istuvad Herli Olop ja Martin Häidberg on suutnud mõlemad üsna korralikud stäkid saada - Herlil on 74000, Martinil koguni 79200.
Sama laua ainuke naismängija Airin Pindis tunneb aga eelkõige rõõmu selle üle, et välja on kaunis kevad. Kaardid tal kahjuks kuigivõrd jooksnud ei ole, kuid õnneks on ka turniir veel noor.
Player
Chips
Progress
Martin Häidberg
79,200
0
Herli Olop
74,000
0
Rikard Relander crippled Posted Saturday 8th April, 2023 at 15:41(UTC+2) by maheaaatom
Rikard Relander ja Karl Kivastik on sees pärast floppi . Rikard avab kaks alumist paari (), Karl näitab aga top-paari + mastitõmmet . Nii turn kui river on kuningad ning Karl saab endalegi ootamatult panga kätte hoopis kahe kõrgema paariga. Rikardil jäi mõni tuhat nuppu järgi.
Hüvasti Katre! Posted Saturday 8th April, 2023 at 15:32(UTC+2) by maheaaatom
"Peolauast" langes juba mõnda aega väga pisikese stäkiga mänginud Katre Kokk. Küllap näeme teda aga ka mõnel teisel EMV turniiril, eelkõige naistekal.
Ohvreid on teisigi. Nii on konkurentsist väljas ka Heiki Raidlepp, Marko Niitav , Igor Pihela, Priit Hansalu, Hannes Keskküla, Tanel Tammela, Erik Aedviir, Indrek Reitalu, Tenno Pleksepp, Vladislav Zarov ja Mairo Tori.
Player
Chips
Progress
Katre Kokk
0
0
Hispaanlased on saabunud Posted Saturday 8th April, 2023 at 15:29(UTC+2) by maheaaatom
Turniiril võtsid just istet kaks kardetud hispaanlast Victor Amatiga eesotsas. Mullu jäid hispaanlased vägagi silma agressiivse ning kartmatu mänguga. Iseäranis andis tooni just Amat, kes jõudis ka chipliidrina finaallauda. Seal ei sujunud tema mäng aga kuidagi ning lõpptulemuseks jäi alles kaheksas koht.
Tarmo Tammel aktiivseid WSOP plaane ei pea Posted Saturday 8th April, 2023 at 15:24(UTC+2) by maheaaatom
Eesti pokkerikommuuni üks armastatuim mängija Tarmo Tammel vastas oma tulevikuplaanide kohta, et hetkel on neist veel rääkida, esialgu tuleb keskenduda EMV-le.
Kas Tarmo plaanib ka tänavu WSOP-le sõita? "Otsest plaani pole, kuigi ei välista. Satelliitidel veel aktiivselt ei mängi, sest tööd on palju," sõnas Tarmo.
WSOP 2022 tõi Tarmo Tammelile kaks cashi, mida võib pidada igati kordaläinud tulemuseks. Põhiturniiril tal samas cashida ei õnnestunud. "Ma lähen sinna ikkagi lõbutsema. Pokkeriturist, noh," lisab Tarmo Tammel.
Kui jutt juba WSOP-le läks, siis olgu lisatud, et valitsev maailmameister (WSOP põhiturniiri võitja) Espen Jorstad on ka Tallinnas elanud ning nii mõnelgi siinsel turniiril kaasa löönud. Andmeid, et Jorstad oleks ka EMV-l osalenud, meil küll ei ole.
Kuidas naistel läheb? Posted Saturday 8th April, 2023 at 15:09(UTC+2) by maheaaatom
Evely ja Christel on natuke nuppe juurde korjanud, neil mõlemal üle 40K.
Kõige rohkem on turniirialal märgata aga Katre Kokka, kes tunneb ülimat rõõmu selle üle, et tema laud on kõige lõbusam. Kahjuks pole Katre stäkist ainult suurt midagi järgi...
Kes on puudu? Viiekordne Eesti meister Catlin Müür põhiturniiril ei osale, kuid deep-stack ei ole üldiselt ka talle väga sobiv formaat. Samuti pole veel kohal Carmen-Elinat, Avet, Moonikat ja nii mõndagi teist, keda võiks kõigi eelduste kohaselt põhiturniirile oodata. Aga võib-olla näeme neid hoopis õhtuse turbol.
Tiitlikaitsja mängust väljas Posted Saturday 8th April, 2023 at 14:56(UTC+2) by maheaaatom
Mullu EMV põhiturniiri võitnud Magnus Pukk on kahjuks tänavuselt turniirilt väljas.
"Turniiri esimesel tasemel võitsin ma vaid ühe panga. Seda pocket emandatega, sain 400 nööpi. Ega hiljem ka kaarti polnud," tunnistab Magnus.
Viimased nupud läksid -ga pärast floppi . "Mul potit polnud, vastasel ka mitte. Aga tal oli see-eest üheksad. Sama hästi kui drawing dead," lõpetas Magnus.
Kes on puudu? Svenza! Posted Saturday 8th April, 2023 at 14:51(UTC+2) by maheaaatom
Selge on see, et põhiturniirist ei võta osa värvikas Tartu pokkeriäss Sven "Svenza" Reimaa.
Nimelt lõigati mehel paar päeva tagasi välja pimesool ning pokkerilauda naasta on kahjuks veel vara. Kindlasti on turniir Svenza puudumise tõttu märksa igavam.
Veel mõned langejad Posted Saturday 8th April, 2023 at 14:49(UTC+2) by maheaaatom
Tiimiturniiril alles esimest korda (!) Eesti meistriks tulnud Rain Heeringas on mängust väljas. Samuti ei kohta me edasises actionis Mart Kaljut.
Hetkel 136 mängijat 145 alustanust.
Joel räägib vutijuttu Posted Saturday 8th April, 2023 at 14:45(UTC+2) by maheaaatom
Endine vutistaar Joel Lindpere räägib oma lauakaaslastele jalgpalli vigastusest ning sellest, kes ja kui palju mänguväljakul teeskleb. Igatahes kõlama jääb see, et vahel veeretab Neymar end vutimurul ka niisama aga see käib mängu juurde.
"Kõige hullemad on just riivamisi saadud laksud ning vigastusi on vutimeestel palju," õpetab Joel.
Mõned suuremad stäkid Posted Saturday 8th April, 2023 at 14:43(UTC+2) by maheaaatom
Player
Chips
Progress
Madis Leps
71,000
0
Andrei Mjagkov
67,000
0
Toivo Ojasoo
63,000
0
Ragnar Linde
62,000
0
Ruben Rahumägi
58,000
0
Reido Sepp
58,000
0
Raiko Murulauk
57,000
0
Joel Lindpere
53,000
0
Jaan Kõrgema
47,000
0
Kolmandat taset alustab 136 mängijat Posted Saturday 8th April, 2023 at 14:31(UTC+2) by maheaaatom
Põhiturniiril on kirjas juba 142 mängijat, väljalangejaid siiani kuus. Vahetult enne pausi lõpetas ka Grigori Belimov.
1A-l saab liituda mänguda veel kuni viienda taseme alguseni. Eriti hiliseid ärkajaid ootab aga 1B, kus on hetkel küll kirjas vaid kolm mängijat. Ilmselgelt tuleb neid aga aegamööda juurde.
14:27 (UTC+2)
Start of Level 3 Blinds: 200/400 Ante: 400
Algas esimene paus Posted Saturday 8th April, 2023 at 14:08(UTC+2) by maheaaatom
Põhiturniir on jõudnud esimese pausini ning mängijad saavad 15 minutit jalgu sirutada. Kokku on pause plaanis kolm, vastavalt pärast teist, neljandat ja kuuendat taset. Mõistagi saab pauside ajal osaleda ka Flip & Go eelvoorudes. Turniiridirektori Meelis Ahmani sõnul on Flip & Go auhinnafondi kogunenud juba 11 000 eurot ning see paisub küllap juba täna oluliselt suuremaks.
On lisandunud veel üks langeja - kahekordne Eesti pokkerimeister Sten Talviste. Turniiril mängib mõistagi ka Steni isa Peeter, kes on suutnud koguni kolmel korral Eesti meistriks tulla.
Märgistatud kaardid? Posted Saturday 8th April, 2023 at 14:02(UTC+2) by maheaaatom
Roland Luik käib peolauda uut pakki nõudmas. Üks kaart olevat märgistatud. Kas keegi on enda kaardipaki kasiinosse kaasa võtnud.
"Muidu on siin kõik Olympicu pakid aga see üks siin on Fenikssi pakk," naljatleb Kert Raud. Ja siis vaatavad kõik Leino otsa, justkui oleks tema kõigest süüdi.
Floor reageerib muidugi koheselt ning lauda tuuaksegi uus kaardipakk.
Veiko Aava ja Martin Mänd mängust väljas Posted Saturday 8th April, 2023 at 13:58(UTC+2) by maheaaatom
"Veteranide lauast" langes viiekordne Eesti meister Veiko Aava. Seal ongi nüüd palju vaiksem...
Samuti on konkurentsist väljas Martin Mänd.
Kõvasti kisa on peolauast. Nimelt olla Leino Piller oma turniiri esimese käe võitnud. "Tund ja nelikümmend ja lõpuks sai kätte," naerab teisel pool lauda istuv Kert Raud.
Arvo-Mart Ameerika mägedel Posted Saturday 8th April, 2023 at 13:53(UTC+2) by maheaaatom
Mullune EMV põhiturniiri teine mees Arvo-Mart Elvisto on jõudnud koguni 7000-le punktile langeda (algstäkk 30000), kuid nüüd vaikselt mängu tagasi tulnud. Tal umbes 20K.
Erilisi mänguplaane Arvo-Mardil ei ole. Lisaks põhiturniirile oli alguses kavas ka Pot Limit Omaha Hi-Lo, kuid viimasel hetkel hakkas Arvo-Mart kartma, et tema oskused selles mängus on siiski pisut rooste läinud.
2022. aasta esikolmik on kohal Posted Saturday 8th April, 2023 at 13:48(UTC+2) by maheaaatom
Mullune EMV põhiturniir läks ajalukku sellega, et kolm tipmist kohta jagasid omavahel hobimängijad.
Kõik nad (Magnus Pukk, Arvo-Mart Elvisto ja Christel Piller) on lauas ka täna. Mullu oli osalejaid 166 ning see tulemus saab tõenäoliselt sel aastal ületatud.
Juba on kirjas 137 osalejat, kellest kaks on välja langenud. Lisaks Algerile ka Hanno Kerem, kes võitis just nimelt mullu koguni kaks Eesti meistritiitlit.
13:42 (UTC+2)
Start of Level 2 Blinds: 100/300 Ante: 300
Kaupo möllab lauas nr. 12 Posted Saturday 8th April, 2023 at 13:36(UTC+2) by maheaaatom
12. lauas olevat kõige aktiivsem mängija 2015. aasta EMV põhiturniiri võitja Kaupo Tenno.
Tõsi, ühest õige suurest pangast jäi Kaupo ka ilma. Nimelt kaitses ta blindi -ga Ranel Käsi vastu. Kuna flopis avati enam kui intrigeeriv , siis võite isegi aimata, milline paugutamine nüüd lahti läks.
Turn ja river olid mõlemad ässad, andes Ranelile maja. Kaupole läks see "nali" üsna kalliks maksma, sest ta uskus vist kuni riverini, et on ees. Aga kaotatud nööbid on mees vahepeal juba tagasi korjanud, seega pole katki veel midagi.
Esimene mängija väljas Posted Saturday 8th April, 2023 at 13:28(UTC+2) by maheaaatom
Esimene langeja on Alger Pissarev. Tema viimased nupud läksid sisse pärast floppi
Alger näitas , vastas Ragnar Linde .
Muide, Alger saigi soovitud rea riveril kätte. Paraku oli aga turni juba langenud ning riveri eel oli ta nagunii drawing dead.
Kuulsused EMV põhiturniiril Posted Saturday 8th April, 2023 at 13:21(UTC+2) by maheaaatom
Ergo Maruste on kutsunud turniirile suurepärase seltskonna meelelahutajaid, kes ka ise kaasa mängivad:
Põhja-Korea
Priit Tomson
Joel Lindpere
Andrei Zevakin
Robin Valting
Osad neist osalesid Robin Valtingu tiimi koosseisus ka meeskondlikul turniiril, kus neil küll kahjuks kuigi hästi ei läinud. Kõige kauem pidaski vastu juutuuber Valting ise, kuid kahjuks samuti mitte väga pikalt.
Joel Lindpere on korra EMV põhiturniiril lausa teiseks tulnud, seega on tegemist ka päris tõsise turniirihaiga.
Leino-lauas pidu käib Posted Saturday 8th April, 2023 at 13:12(UTC+2) by maheaaatom
Leino Pilleri lauas istub suurepärane seltskond eesotsas Leino enda, Tarmo Tammeli, Katre Koka, Roland Luige ja Ergo Marustega. Kohal on ka Kert Raud, kes oskab samuti heast möllust lugu pidada.
Leino pidavat olema kõige aktiivsem mängija. Aga ühtegi panka ta veel võitnud ei ole.
Eelnevale seltskonnale vastandub täielikult Mati Pirn, kes on suutnud selles piduses kambas liidriks tõusta.
Veiko ootab seeniorite turniiri Posted Saturday 8th April, 2023 at 13:00(UTC+2) by maheaaatom
Esimeses lauas on saanud kokku tõeliselt väärikas seltskond: Imre Leibold, Veiko Aava, Mauri Dorbek, Christel P....aga ka Rakvere veteranmängija Ants Olev.
"Kui ma 50 täis saan, siis tõstatan ettepaneku seeniorite turniiri korraldamiseks," naljatleb Veiko. Aga kas sellel turniiril osaleks tõesti ka mõni naine.
"Mina mängiks küll, mina vanust ei häbene," sõnab Christel kohe.
Hetkel on neil kõigil 50-ni veel aega, vaid Ants Olevil on see vertsapost juba ületatud. Aga mujal maailmas pidid 50+ turniirid tõesti ülipopid olema, eriti on neid kiitnud ka näiteks Henri Käsper.
12:54 (UTC+2)
Start of Level 1 Blinds: 100/200 Ante: 200
Ermo soovib ajalooliste saavutustega jätkata Posted Saturday 8th April, 2023 at 12:49(UTC+2) by maheaaatom
Eile hilisõhtul kahe ja poole tunnise tulise heads-up'i järel oma kuuenda Eesti meistritiitli võitnud Ermo Kosk on lauas, kus hetkel (vaid) 4 mängijat.
EMV-l kavatseb Ermo mängida aktiivselt ning sihikul on ka seitsmes tiitel, sest kuus meistrisõrmust on ju ka Meelis Ahmanil. Üksi edetabeli tipus olla oleks aga hoopis ägedam.
Tegelikult on Ermol üks salaunistus veel. Nimelt tahaks ta teist korda EMV põhiturniiri võita. 2018. aastal see õnnestus ning Ermo on teada-tuntud suurturniiride mees.
Naised põhiturniiril Posted Saturday 8th April, 2023 at 12:41(UTC+2) by maheaaatom
Eraldi pole mõtet tuntud pokkerimängijaid üles lugema hakata, kuna tegemist on ikkagi aasta tähtsaima Eesti mängijatele mõeldud pokkeriturniiriga ning suurem osa tippudest nagunii kohal.
Peatume siinkohal hoopis naistel. Lisaks Pillerite, Pihelate (ning ka Pinselite) õrnemale poolele on kohal:
Eilsel boutyl kolmandaks tulnud Jaana Kindsigo
Kolmekordne Eesti meister Airin Pindis
Kahekordne vabariigi tšempion Annika Haaviste
Alati koloriitne Katre Kokk
Viimasel ajal superheas hoos olev endine netiproff Helina Tamm
Aina koguneb Posted Saturday 8th April, 2023 at 12:35(UTC+2) by maheaaatom
Oleme juba ammu ületanud 100 mängija piiri, mõned osalejad on veel kassas. Hetkel on registreerujaid kokku juba 118.
Lisaks Pilleritele on võistlustules veel vähemalt üks pokkeripere. Mõistagi on tegemist Pihelatega, kes kohal lausa koosseisus isa-poeg-poja abikaasa.
Kuidas me täna mängime? Posted Saturday 8th April, 2023 at 12:25(UTC+2) by maheaaatom
Tuletame veelkord meelde, et EMV põhiturniiril puudub re-entry võimalus. Kui oled väljas, siis oled väljas. Seda kordab veelkord üle ka turniiridirektor Meelis Ahman.
Täna mängime 8 taset, igaüks 60 minutit. 1A saab seega läbi umbes kell 20:45, mille järel algab kohal 1B (turbopäev). Tõenäoliselt võistleb enamus mängijaid 1A-l. Meie ülekanne haarab ühe päevana nii 1A-d kui 1B-d.
Turniiri alguses keskendume rohkem mängijate muljetele, table talkile ning senistele-tulevastele sündmustele. Esimene päev on eelkõige turniirile sisseelamiseks, mänguruumi on palju ning kõige põnevamad sündmused ootavad meid ikkagi eelkõige teisel ka kolmandal päeval.
Pillerite sekeldused Posted Saturday 8th April, 2023 at 12:18(UTC+2) by maheaaatom
Täies koosseisus on turniiril esindatud Pillerite pokkeripere. Seejuures on mõlemad kasiinos vaid lühikese puhkepausi järel.
Põhjus lihtne - Leino tuli eilsel OlyBet Bounty King Progressive Bounty turniiril teiseks. Christeli arvates oleks ta küll pidanud võitma ning Urmo Velveltiga mitte diili sõlmima. "Leinol oli hoopis rohkem nuppe," kirjeldas Christel. Aga jutuajamist kuulnud Herli Olop näiteks arvas, et ega siis Urmole kaotada ka häbiasi pole.
Mõlemad mehed teenisid 2617 eurot, bountyd lisaks sellele. "Kuskil poolteist-kaks tonni oli kindlasti," hindas Leino enda saagi suurust.
EMV 2023 põhiturniir on alanud! Posted Saturday 8th April, 2023 at 12:12(UTC+2) by maheaaatom
Diilerid segasid kaardid ära ja jagasid mängijatele välja. Teravat ja põnevat pokkeriactionit pakkuv turniir on alanud!
Hetkel on laudades 93 mängijat.
Eesti meistrivõistluste põhiturniir algab laupäeval kell 12:00 Posted Wednesday 5th April, 2023 at 14:46(UTC+2) by maheaaatom
Käimasolevate Eesti meistrivõistluste (EMV) tähtsaima, 555-eurose osalustasuga No Limit Holdem põhiturniiri avapäev (1A) algab Olympic Park kasiinos laupäeval, 8. aprillil kell 12:00.
Mängijad alustavad 30 000 stardipunktiga, esimene tase on 100/200/200. Hiline registreerumine on lubatud kuni viienda taseme alguseni (umbes kell 16:30). Tegemist on freezeout turniiriga ning re-entry pole võimalik ei ühelgi tava- ega erandjuhul (ka mitte siis, kui peaksid näiteks esimeses jaotuses ässadega tappa saama).
Samal kuupäeval viiakse läbi ka avapäeva turboversioon (1B), mis algab samuti Olympic Park kasiinos kell 21:00. Seal käib mäng turboformaadis, muidu on kõik sama, mis 1A-lgi. Pane tähele, et 1A-l väljalangenud mängijad ei saa enam 1B-l osaleda!
Soovime sulle mõnusat ülekande jälgimist. Kui plaanid osaleda, siis osta pilet varakult!
14:39 (UTC+2)
Day 1 of Estonian Poker Championship Started Level:Blinds: 0/0 Ante: 0
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.