0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0066 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_estonian_championship_main_event/2/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.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.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0040 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2023_estonian_championship_main_event'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'
0.0309 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '64'
AND `published` = 1
0.0272 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '65'
AND `published` = 1
0.0271 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '67'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'
AND `name` = '2'
0.0061 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.0064 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` = '65'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '3094'
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` = '3093'
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` = '3092'
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` = '3091'
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` = '3090'
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` = '3089'
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` = '3088'
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` = '3087'
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` = '3086'
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` = '3085'
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` = '3084'
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` = '3083'
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` = '3082'
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` = '3081'
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` = '3080'
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` = '3079'
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` = '3078'
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` = '3077'
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` = '3076'
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` = '3075'
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` = '3074'
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` = '3073'
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` = '3072'
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` = '3071'
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` = '3070'
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` = '3069'
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` = '3068'
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` = '3067'
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` = '3066'
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` = '3065'
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` = '3064'
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` = '3063'
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` = '3062'
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` = '3061'
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` = '3060'
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` = '3059'
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` = '3058'
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` = '3057'
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` = '3056'
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` = '3055'
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` = '3054'
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` = '3053'
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` = '3052'
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` = '3051'
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` = '3050'
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` = '3049'
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` = '3048'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3047'
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` = '3046'
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` = '3045'
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` = '3044'
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` = '3043'
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` = '3042'
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` = '3041'
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` = '3040'
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` = '3039'
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` = '3038'
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` = '3037'
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` = '3036'
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` = '3035'
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` = '3034'
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` = '3033'
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` = '3032'
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` = '3031'
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` = '3030'
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` = '3029'
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` = '3028'
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` = '3027'
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` = '3026'
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` = '3025'
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` = '3024'
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` = '3023'
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` = '3022'
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` = '3021'
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` = '3020'
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` = '3019'
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` = '3018'
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` = '3017'
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` = '3016'
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` = '3015'
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` = '3014'
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` = '3013'
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` = '3012'
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` = '3011'
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` = '3010'
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` = '3009'
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` = '3008'
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` = '3007'
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` = '3006'
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` = '3005'
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` = '3004'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 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.0058 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.0056 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` = '65'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '3094'
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` = '3093'
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` = '3092'
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` = '3091'
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` = '3090'
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` = '3089'
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` = '3088'
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` = '3087'
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` = '3086'
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` = '3085'
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` = '3084'
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` = '3083'
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` = '3082'
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` = '3081'
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` = '3080'
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` = '3079'
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` = '3078'
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` = '3077'
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` = '3076'
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` = '3075'
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` = '3074'
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` = '3073'
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` = '3072'
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` = '3071'
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` = '3070'
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` = '3069'
ORDER BY `chip_change` DESC, `busted` ASC
0.0146 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3068'
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` = '3067'
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` = '3066'
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` = '3065'
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` = '3064'
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` = '3063'
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` = '3062'
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` = '3061'
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` = '3060'
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` = '3059'
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` = '3058'
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` = '3057'
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` = '3056'
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` = '3055'
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` = '3054'
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` = '3053'
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` = '3052'
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` = '3051'
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` = '3050'
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` = '3049'
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` = '3048'
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` = '3047'
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` = '3046'
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` = '3045'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3044'
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` = '3043'
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` = '3042'
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` = '3041'
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` = '3040'
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` = '3039'
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` = '3038'
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` = '3037'
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` = '3036'
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` = '3035'
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` = '3034'
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` = '3033'
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` = '3032'
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` = '3031'
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` = '3030'
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` = '3029'
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` = '3028'
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` = '3027'
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` = '3026'
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` = '3025'
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` = '3024'
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` = '3023'
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` = '3022'
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` = '3021'
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` = '3020'
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` = '3019'
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` = '3018'
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` = '3017'
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` = '3016'
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` = '3015'
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` = '3014'
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` = '3013'
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` = '3012'
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` = '3011'
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` = '3010'
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` = '3009'
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` = '3008'
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` = '3007'
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` = '3006'
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` = '3005'
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` = '3004'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '65'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '67'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2020
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Day 2 of Estonian Poker Championship Ended Level: 18 Blinds: 6,000/12,000 Ante: 12,000
EMV põhiturniiri finaali läheb liidrina Kaido Koorits Posted Monday 10th April, 2023 at 00:15(UTC+2) by maheaaatom
Nagu eeldada võis, oli täna väga põnev päev ning 11-tunnise mängu tulemusena sai selgeks ka finaallaua koosseis. Liidrina läheb sinna pokkeriproff Kaido Koorits, kuid omad võimalused on ka teistel.
Kohtume uuesti laupäeval, mil asume selgitama EMV kõige tähtsama turniiri võitjat. Blogi toimub sünkroonis teleülekandega ning selle kõrval kirjutame ka paaride turniirist ning Olympic Casinos toimuvast auhinnagalast.
Seniks kõigile head ööd ning edukat töönädalat!
Põhiturniiri finalistide stäkid:
1. Kaido Koorits - 992 000 2. Rivo Tamm - 881 000 3. Andrey Koks - 778 000 4. Taago Tamm - 718 000 5. Kaur Ajamaa - 551 000 6. Kaidar Viikman - 448 000 7. Mario Jürgens - 330 000 8. Erik Põlluveer - 282 000 9. Kristjan Maasalu - 130 000
10. koht - Peeter Talviste 1600 € Posted Monday 10th April, 2023 at 00:07(UTC+2) by maheaaatom
Vanameister Peeter Talviste alistas viimases jaotuses küll Arko, kuid kaotas oma nupud ikkagi Andreyle, saavutades sellega kümnenda koha.
Aga Peetri mängu oli mõnus jälgida. Nii mõnigi kord näitas ta noortele kolleegidele, et vana rebasega tuleb neil ka edaspidi arvestada. Sellega sai finaallaud kokku ning mängijad pakivad nööpe kottidesse.
11. koht - Arko Akenpärg 1600 € Posted Monday 10th April, 2023 at 00:05(UTC+2) by maheaaatom
Tänane lõpplahendus saabub üsna kiirelt ja ootamatult.
Andrey Koks tuleb blinde "sööma" ning saab vastu all-in panused nii Arkolt kui Peetrilt.
Peeter:
Arko:
Andrey: . Flopis on äss ning turn ja river ei muuda midagi. Nii Arko kui Peeter teenivad 1600 eurot.
Player
Chips
Progress
Arko Akenpärg
0
0
Peeter Talviste
0
0
12. koht - Igor Pihela 1600 € Posted Monday 10th April, 2023 at 00:01(UTC+2) by maheaaatom
Telelaua kõige väiksema stäkiga Igor Pihela langes konkurentsist välja. Mis täpselt juhtus, vaadake ülekandest.
23:51 (UTC+2)
Start of Level 18 Blinds: 6,000/12,000 Ante: 12,000
Ka Arko on raskustes Posted Sunday 9th April, 2023 at 23:49(UTC+2) by maheaaatom
Peetril kõrval istuv Arko on samuti pidevalt nuppe kaotanud, peamiselt tänu Kaido Kooritsa peentele trikkidele. Tema stäkk on suhteliselt sama Peetriga ning mängustaadium push-fold.
Vahepeal sai läbi ka high-rolleri satikas. Läks päris kiirelt, vaid kolm ja pool tundi.
Põhiturniiril käivitus mängutase nr. 18.
Peetril on varuks õige kavalad trikid Posted Sunday 9th April, 2023 at 23:44(UTC+2) by maheaaatom
Kaido Koorits tuleb tavapäraselt 20K tõstega (2XBB) blinde sööma ning saab SB-l istuvalt 82K stäkiga Peeter Talvistelt calli (!) "Nii, ilmselgelt ässad," on Kaido kindel.
Aga head lehed leiab ka Arko, kes kibeleb ise all-in lükkama. "Sul on mutid jah? Tahad ässade vastu sattuda või," norib Kaido. Viimaks Arko lihtsalt callib.
Flopis avatakse ning Peeter lükkab esimesena kiirelt all-in.
Nooremad mehed on jahmunud. Mõlemad kahtlustavad ülepaari ja foldivad.
Peeter näitab lahtiselt puhast bluffi !
Ärge kandke vana rebast maha!
High-Rolleri satikas läheneb lõpule Posted Sunday 9th April, 2023 at 23:34(UTC+2) by maheaaatom
"Loomade turniiril" tehti 16 sisseostu ning hetkel on konkurentsis 3 parimat. Neist üks saab turniiripileti ning teine koht portsu sularaha.
Telepurgis valitseb Kaidar Posted Sunday 9th April, 2023 at 23:32(UTC+2) by maheaaatom
Telelauas toimuvast me üksikasjalikult kirjutama ei hakka, kuid niipalju võime öelda, et liidriks on seal Kaidar Viikman ning kõige väiksem stäkk on Igor Pihelal. Samas blidid kedagi otseselt veel ei ahista.
Blindid ahistavad Peetrit Posted Sunday 9th April, 2023 at 23:26(UTC+2) by maheaaatom
Blindring käib korra üle Peeter Talvistest, kellele konkurendid üldse hõlpu ei anna. Kordamööda paigutavad all-in'e nii Kaido Koorits kui Kristjan Maasalu, kuigi viimane neist on ise samuti väga short.
Floppi pole sel lauas juba mõnda aega nähtud. Peetril hakkab aeg otsa saama...
13. koht - Toomas Kukemilk Posted Sunday 9th April, 2023 at 23:11(UTC+2) by maheaaatom
Preflop all-in.
Toomas:
Kaur Ajamaa:
Poisid peavad. "Jess," rõõmustab Kaur. Nööbid loetakse üle, Kauril on umbes 260K ning Toomasel õige napilt vähem.
12 parimat sees.
Player
Chips
Progress
Toomas Kukemilk
0
0
Peetri pea on sihikul Posted Sunday 9th April, 2023 at 23:08(UTC+2) by maheaaatom
Kaido Kooritsale suure panga kaotanud Peeter Talviste (Kaido lükkas pärast turni, kus lauas oli kolm mastikaarti all-in, sundides Peetri foldima) on langenud umbes 12-13XBB peale.
Sellega on ta mitte-telelaua väiksem stäkk ning sisuliselt on teda ootamas push-fold mäng.
Taago juhib endiselt Posted Sunday 9th April, 2023 at 22:59(UTC+2) by maheaaatom
Ka 17. taset alustab liidrina Taago Tamm, kel on 811 000 punkti. Kaido Koorits omab 683K, Andrey Koks 579K, Kaidar Viikman 514K ning Erik Põlluveer 500K stäkki. Kõik uuendatud stäkid leiad sektsioonist "Chip Counts".
Muide Kaidar on jätkuvalt skeptiline oma finaalipääsu osas. "Selles lauas võib kõike juhtuda," selgitab mees.
Paus Posted Sunday 9th April, 2023 at 22:36(UTC+2) by maheaaatom
15-minutilisele pausile läheb kuraditosin mängijat. See ei pruugi, kuid heal juhul isegi võib olla tänane viimane paus.
Pausi lõpus toome teieni ka täpse chipcounti.
Lonkavaid saakloomi enam ei ole Posted Sunday 9th April, 2023 at 22:28(UTC+2) by maheaaatom
Kuigi vahepeal langes mängijaid nagu loogu, on nüüd tempo märgatavalt langenud. Mitte-telelauas pole ühtegi alla 20XBB stäkki (ka Kaur suutis pärast lauda naasmist üsna kiirelt duubli saada) ning mäng just ülearu lahtine ei ole.
Laua agressor peaks kõigi eelduste kohaselt olema pokkeriproff Kaido Koorits, kel on ka suurim stäkk. Aga vastasedki pole papist poisid.
Täielik loomade jalgpall! Posted Sunday 9th April, 2023 at 22:22(UTC+2) by maheaaatom
Nii iseloomustab käimasolevate high-rolleri satikat sealt just välja kukkunud Puhja pokkerihing Toivo Ojasoo.
Ta ei ole nõus isegi surmanuhtluse ähvardusel re-entryt tegema. "Vot selle laua peaks täies koosseisus sinna päris high-rollerite turniirile saatma," pahvatab Toivo lõpuks.
Kes tahab järgi proovida, võib veel lauda istuda. Aega on selleks umbes kümmekond minutit.
14. koht - Priit Aavasalu 1300 € Posted Sunday 9th April, 2023 at 22:16(UTC+2) by maheaaatom
Priit Aavasalu jooksis oma -ga Arko Akenpärgi otsa. Kuuldavasti polnud see esimene kord, mil Arko täna kuningaid nägi.
"Istuge siin siis kaua," sõnad Priit mängukaaslastele hüvastijätuks. Tasuks sisuka mängu eest 1300 eurot auhinnaraha.
Jätkab kuraditosin parimat.
Player
Chips
Progress
Priit Aavasalu
0
0
15. koht - Maikel Homin 1300 € Posted Sunday 9th April, 2023 at 22:07(UTC+2) by maheaaatom
Vahepeal ka turniiri üldliidri staatust nautinud Maikel Homin langeb telelauast välja ning tema osaks saab 15. koht koos 1300 euroga. Mis täpsemalt juhtus, vaadake ülekandest.
Oleme finaallauast täpselt viie mängija kaugusel, keskmine stäkk on aga taas tõusnud üle 40XBB.
Player
Chips
Progress
Maikel Homin
0
0
Allesjäänud mängijate varasemad saavutused EMV-l Posted Sunday 9th April, 2023 at 22:05(UTC+2) by maheaaatom
Kaido Koorits on tulnud Eesti pokkerimeistriks koguni neljal korral. Kolm meistrisõrmust on Peeter Talvistel, kaks Igor Pihela nooremal ja Erik Põlluveeril. Ühe tiitli on võitnud Kaidar Viikman.
Mitte-telelaua suurimad stäkid Posted Sunday 9th April, 2023 at 21:55(UTC+2) by maheaaatom
Mitte-telelauas on suurim kogus mängumärke suurturniiridel sageli osaleval Andrey Koksil - umbes 700K.
Kaido Koorits võib uhkustada 410 stäkiga, lauas on tagasi ka Kaur Ajamaa.
Telelauas hoiavad ohje Taago Tamm ja Erik Põlluveer.
Kaidari esimene EMV põhiturniiri cash Posted Sunday 9th April, 2023 at 21:50(UTC+2) by maheaaatom
Kaidar Viikman on osalenud EMV põhiturniiril neljal-viiel korral, kuid rahadesse pole seejuures veel kunagi tulnud. Nüüd on esimene cash tõsiasi ning koht vähemalt esimese 15 hulgas kindel.
Kas Kaidar loodab ka finaallauda jõuda? "Selleks peaks toimuma laudade vahetus, mul on väga raske laud," vastab Kaidar. Kuidas tal seal läheb, saate jälgida telelaua ülekandest.
21:47 (UTC+2)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
16. koht - Kaarel Lepik 1100 € Posted Sunday 9th April, 2023 at 21:44(UTC+2) by maheaaatom
Ka Kaarli stäkk oli pärast viimast pausi alla 20XBB ning imet teha sellega ta ei suutnud.
Kaarel lubas osaleda kindlasti ka high-rolleril, mille satikalauas on muide juba 9 mängijat.
Kaarel Lepiku seniseks suurimaks saavutuseks on poole miljoni euro võitmine internetis Spin & Go turniiril ning Unibet Open põhiturniiri esikoht Kopenhaagenis.
Player
Chips
Progress
Kaarel Lepik
0
0
Kus Kaur on? Posted Sunday 9th April, 2023 at 21:38(UTC+2) by maheaaatom
Kaur Ajamaa on oma lauast juba pikka aega kadunud olnud ning tema stäkk tiksub vaikselt maha. Tal on hetkel ca. 130K järgi, mis on umbes 16XBB.
Kaur lubas 5 minuti pärast mängus tagasi olla. Kus ta käis, ei tea. Ju oli vajadus.
17. koht - Miroslav Poptsenko 1100 € Posted Sunday 9th April, 2023 at 21:30(UTC+2) by maheaaatom
Miroslav kaotas lõviosa oma stäkist flipiga Priit Aavasalu vastu ( vs. , Priit tõmbas laua abiga rea kokku). Tal jäi umbes 15K alles, mille võttis ära Kaarel Lepik.
Player
Chips
Progress
Miroslav Poptsenko
0
0
18. koht - Eedi Kirves 1100 € Posted Sunday 9th April, 2023 at 21:19(UTC+2) by maheaaatom
Üks langeja ka telelauast - taas väga pisikese stäkiga Eedi Kirves.
Player
Chips
Progress
Eedi Kirves
0
0
19. koht Andres Samarüütel - 1100 € Posted Sunday 9th April, 2023 at 21:17(UTC+2) by maheaaatom
Andres Samarüütelil oli alles vaid 4XBB stäkk, millega imet teha ei õnnestunud.
Andres on tõeline vanameister, kes tuli Eesti pokkerimeistriks juba 2011. aastal, olles toona parim Pot Limit Omaha 6-maxis.
Player
Chips
Progress
Andres Samarüütel
0
0
21:13 (UTC+2)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
20. koht - Janek Hin 900 € Posted Sunday 9th April, 2023 at 21:13(UTC+2) by maheaaatom
55K stäkiga Janek kaotas oma nööbid blindide sõjas flipiga -ga vastu. Temalegi 900 eurot.
Player
Chips
Progress
Janek Hin
0
0
Andres Samarüütel
0
0
Algas high-rolleri satikas Posted Sunday 9th April, 2023 at 21:11(UTC+2) by maheaaatom
High-rolleri satikas algas kõigest nelja mängijaga. Aga kohal on Puhja vanameister Toivo Ojasoo, seega peaks easy money lauas nagu olema küll...
21. koht - Rauno Arras 900 € Posted Sunday 9th April, 2023 at 21:04(UTC+2) by maheaaatom
Vaid napilt pärast Christelit langes konkurentsist ka Rauno Arras, kes oli üks kuuest viimati mainitud ministäkiga mängijast.
Oma 11XBB lükkas ta sisse -ga, sattudes kuningate otsa. Rauno sai küll flopist ässa, kuid paraku oli seal ka kuningas.
Tasuks temalegi 900 eurot.
Player
Chips
Progress
Rauno Arras
0
0
22. koht - Christel Piller 900 € Posted Sunday 9th April, 2023 at 21:00(UTC+2) by maheaaatom
Igor Pihela tuli BB-l istuvat pisistäkiga Christelit -ga kiusama ning Christel callis -ga ära. Lauda seitse.
Kahel järjestikusel EMV-l rahadesse jõudmine on tubli saavutus ning midagi häbeneda Christelil küll pole. Ja tema mullune imemäng ning tubli kolmas koht on veel kõigil meeles.
Kahjuks jätkame nüüd ainult ilma naisteta :(
Player
Chips
Progress
Christel Piller
0
0
Kõik on graafikus Posted Sunday 9th April, 2023 at 20:48(UTC+2) by maheaaatom
Võrreldes mulluse põhiturniiriga oleme endiselt ajas 2-3 tundi taga, mis prognoosib, et EMV põhiturniir peaks jõudma finaallauani täna öösel umbes kella 12-2 vahel.
Finaal mängitakse laupäeval.
Taago läheneb miljonile Posted Sunday 9th April, 2023 at 20:45(UTC+2) by maheaaatom
Kõikide mängijate punktiseisud on uuendatud. Juhib endiselt Taago Tamm, kel on lausa 948 000 punkti.
Teine on Kaido Koorits (488 000), kolmas aga Igor Pihela (379 000)
Mängus on ka kuus pisistäkki, kel kõigil alla 100K punkti (alla 15xBB). Keskmine stäkk on seevastu ligi 40XBB.
Paus 30 minutit Posted Sunday 9th April, 2023 at 20:07(UTC+2) by maheaaatom
Mängijad lubati 30-minutilisele õhtusöögipausile. Päris viimases pausieelses käes suutis Christel oma 24K ministäki duublisse saada ( vs. , turn kuningas) ning saab nüüd pool tundi rahulikult sõjanõu pidada.
23. koht - Imre Leibold 900 € Posted Sunday 9th April, 2023 at 20:02(UTC+2) by maheaaatom
Telelauast langes Imre Leibold ( vs. ). Imre nupud omistas Toomas Kukemilk.
Olemegi rahades! Posted Sunday 9th April, 2023 at 19:55(UTC+2) by maheaaatom
Ruben Rahumägi lükkas oma nupud keskele ning sai kaks calli.
Lauas avati , mis checkiti külmavereliselt lõpuni.
Ruben avas ning Andres Samarüütel korjas -ga panga maha.
"Te peate mulle nüüd tonni andma," naeris vanameister Andres. Ruben saab lohutuseks chipikohvri ja Christel on JÄLLE (vähemalt) rahades!
Player
Chips
Progress
Ruben Rahumägi
0
0
Rubenil 6500 punkti Posted Sunday 9th April, 2023 at 19:50(UTC+2) by maheaaatom
Ruben Rahumägi stäkk on napp 6500 punkti. See tähendab, et kui blindiring temani jõuab, on mees igal juhul sund all-in.
Christelil on 10XBB, kuid hetkekl on blindiring temast just üle sõitmas ning see läheb maksma veerandi stäkist. Ühesõnaga - Christelil on aega oodata küll ja küll. Eriti kui arvestada, et tema lauas on rida agressoreid - Pihela, Koorits ja Lepik.
Player
Chips
Progress
Ruben Rahumägi
6,500
70,500
Kaido loovutab Igorile Posted Sunday 9th April, 2023 at 19:43(UTC+2) by maheaaatom
Kaido Koorits ja Igor Pihela mängivad suure panga ning teevad näo nagu teisi lauas ei olekski.
Flopiks on pangas juba tubli 80K ning turni järel jätkab Igor 57K panusega. Kaido callib, riveril avatakse , mille järel lükkab Igor all-in. "Kunn-üheksa jah," pomiseb Kaido, kuid foldib suhteliselt kiirelt.
Mullimäng jätkub. Igor tõuseb 320K peale, kuid Kaido stäkk on endiselt tema omast suurem.
Player
Chips
Progress
Igor Pihela noorem
320,000
70,000
Igor pääseb rongi alt Posted Sunday 9th April, 2023 at 19:34(UTC+2) by maheaaatom
Seekord on lükkajaks 107 500 stäkiga Igor Pihela noorem ja callijaks Kaarel Lepik.
Igor avab , Kaarlil on . Kas kõik? Flopis avatakse siiski kuningas ning Igor saab oma stäki duublisse. Väga halb uudis Christelile ja Rubenile...
Ruben rõõmustab Christeli SB üle Posted Sunday 9th April, 2023 at 19:30(UTC+2) by maheaaatom
16K stäkiga (3XBB) Ruben Rahumägi lükkab keskelt ning saab mõistagi calli BB-l istuvalt Kaido Kooritsalt.
Mõlemal mehel on , pank läheb pooleks.
Mida Ruben siis võitis? Christel Pilleri 1500-se SB, mille viimane foldis. "Raskel ajal abiks seegi," ei kaota Ruben optimismi.
Kolm suurimat stäkki Posted Sunday 9th April, 2023 at 19:26(UTC+2) by maheaaatom
Player
Chips
Progress
Taago Tamm
720,000
80,000
Kaido Koorits
590,000
260,000
Erik Põlluveer
390,000
150,000
Infoks satelliidimängijatele Posted Sunday 9th April, 2023 at 19:21(UTC+2) by maheaaatom
Täna kell 21:00 algab Olympic Casinos EMV High-Roller turniir 110-eurose sisseostuga satelliit.
Alustatakse 10 000 punktiga ning tasemed vältavad vaid 15 minutit. Esimese 90 minuti jooksul on lubatud ka re-entry.
High-Roller turniir ise toimub kolmapäeval ning pilet sinna on väärt 1100 eurot.
Mullimäng on alanud Posted Sunday 9th April, 2023 at 19:18(UTC+2) by maheaaatom
Pre-mulliks ei jää ükski kolmest sihikul olevast mängijast, vaid hoopis Aleksei Gontsar.
Mäng jätkub hand-by-hand. Esimene langeja raha ei saa, küll aga paneb Olympic Casino välja väikese lohutusauhinna chipikohvri näol. 23. koht teenib aga juba 900 eurot puhast raha.
Player
Chips
Progress
Aleksei Gontsar
0
0
Kes on sihikul? Posted Sunday 9th April, 2023 at 19:00(UTC+2) by maheaaatom
Turniiril on kolm väikest stäkki, kes võiksid olla kõigil sihikul: Christel Piller, Ruben Rahumägi ja Eedi Kirves.
Christelil on sarnane kogemus eelmisest aastast, siis oli tal veel väiksem stäkk. Ja millega kõik lõppes - kolmanda kohaga!
18:52 (UTC+2)
Start of Level 14 Blinds: 2,500/5,000 Ante: 5,000
Rohelised seekord ei võida Posted Sunday 9th April, 2023 at 18:52(UTC+2) by maheaaatom
Ergo Maruste mäng oli pärast viimast pausi võrdlemisi liimist lahti ning ta jagas oma stäki lauakaaslaste vahel laiali. Viimase jupi sai Kaido Koorits, kes on nüüd mängus umbes 330K-ga.
Jätkab 25 parimat, käes on pre-mull.
Player
Chips
Progress
Kaido Koorits
330,000
223,400
Ergo Maruste
0
0
Langes Toomas Orm, veel kolm kohta mullini Posted Sunday 9th April, 2023 at 18:48(UTC+2) by maheaaatom
Toomas Orm langes -ga, tema kukutajaks aga Igor Pihela . Samas jaotuses suutis Ruben Rahumägi veel enne floppi poisid foldida, mis osutus väga targaks otsuseks.
Igori stäkk on 250K, mullini on kolm kohta.
Player
Chips
Progress
Igor Pihela noorem
250,000
108,400
Toomas Orm
0
0
Veel suuri stäkke Posted Sunday 9th April, 2023 at 18:39(UTC+2) by maheaaatom
Veel neli suuremat stäkki. Nende kõrval ka üks langeja - Sten Rõngelep. Jätkab 27 parimat.
Player
Chips
Progress
Kaarel Lepik
257,500
17,500
Andrey Koks
238,000
8,000
Maikel Homin
230,000
8,100
Kristjan Maasalu
200,000
122,100
Taago tõuseb uueks liidriks Posted Sunday 9th April, 2023 at 18:36(UTC+2) by maheaaatom
Kalev Lepiku all-in panust callivad suurte stäkkidega Taago Tamm ja Maikel Homin.
Flopi järel lükkab ka Taago oma stäki keskele ning Maikel looobub. "Huuh," hingab Taago sügavalt välja. On näha, et Maikeli calli ta küll ei soovinud.
Taago avab mastitõmbe , Kalevil on . Turn toob ka masti kohale. "Oota, sa pole veel kaotanud," rahustab Taago vastast. Paraku on river , mis midagi ei muuda.
Taago stäkk nüüd 640K.
Player
Chips
Progress
Taago Tamm
640,000
190,000
Kalev Lepik
0
0
Võmba FM Pauli ei aita Posted Sunday 9th April, 2023 at 18:24(UTC+2) by maheaaatom
Lauas Põlva veebiraadiot Võmba FM-i kuulanud ning seda ka kaaslastele mängitanud Paul Koppe on kahjuks mängust väljas.
Paulil oli selgelt alla keskmise stäkk, seega polnud ka väljakukkumises sel hetkel midagi üllatavat. Aga lõbus mängukaaslane oli ta kõigile!
Samuti on väljas Artur Grigorjev ja Tõnis Laumets.
Player
Chips
Progress
Tõnis Laumets
0
0
Artur Grigorjev
0
0
Paul Koppe
0
0
Erik on esirikkur, Martin mängust väljas Posted Sunday 9th April, 2023 at 18:20(UTC+2) by maheaaatom
Arvate, et Taago tõusis nüüd turniiri chipliidriks?
Oh ei. Tema lauas on üks mees veel rikkam ning selleks on loomulikult Erik Põlluveer umbes 540K stäkiga.
Ka Kaidar Viikman on korralikult tõusnud ning nüüd umbes 260K peal.
Christel Piller suutis oma 35K stäki just duubeldada -ga emandate vastu. Christelile kohe flopist mast.
Küll kukkus aga samas lauast juba järgmises jaotuses Martin Häidberg. Jätkab 31 parimat.
Player
Chips
Progress
Erik Põlluveer
540,000
260,000
Martin Häidberg
0
0
Taago kukutab kaks konkurenti korraga Posted Sunday 9th April, 2023 at 18:13(UTC+2) by maheaaatom
Kaheksandas lauas kütavad nuppe kolm meest:
Taago Tamm:
Marek Sepp:
Mauri Dorbek:
Lauda jookseb ning kuna Taagol oli konkurentidest pisut enam, kukutab ta korraga kaks vastast. Taago stäkk umbes 450K.
Player
Chips
Progress
Taago Tamm
450,000
280,800
Marek Sepp
0
0
Mauri Dorbek
0
0
Peeter ja Janek flippavad Posted Sunday 9th April, 2023 at 18:03(UTC+2) by maheaaatom
Peeter Talviste ja Janek Hin võtavad flipi.
Peeter
Janek: . Laud toob mõlemale midagi -
Peeter saab reaga panga kätte. Nüüd on mõlema mehe stäkid võrdsed - nii Peetril kui Janekil on umbes 100K.
Player
Chips
Progress
Janek Hin
100,000
6,000
Peeter Talviste
100,000
115,600
17:55 (UTC+2)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
Teist päeva liidrina alustanud Rain Kandla on mängust väljas Posted Sunday 9th April, 2023 at 17:54(UTC+2) by maheaaatom
Rain Kandla alustas küll EMV põhiturniiri teist päeva liidrina, kuid paraku ei sujunud seal mäng kohe kuidagi. Ja nüüd ongi Rain mängust väljas.
Teiselt kohalt alustanud Ergo Maruste on mängus enam-vähem sama stäkiga, millega ta ka täna alustas. See on ca 180 000, umbes kolmandiku jagu üle keskmise.
Player
Chips
Progress
Rain Kandla
0
0
Arutatakse õhtusöögipausi üle Posted Sunday 9th April, 2023 at 17:24(UTC+2) by maheaaatom
Hetkel käib mängu kõrvalt arutelu võimaliku õhtusöögipausi osas.
Esialgne pakkumine on see teha järgmise pausi ajal (ca. kell 19:30) kestvusega 30-45 minutit. Samas leidub mängijaid, kes arvavad, et enne võiks mull lõhkeda.
Mauri viskab veel nalja, et võiks esmalt korraldada tunnise pausi pausi üle arutamiseks.
Esialgu läheme aga tavalisele pausile. Allesjäänud 36 mängijaga (vahetult pausi eel langes Gert Elmaste) kohtume 15 minuti pärast.
Player
Chips
Progress
Gert Elmaste
0
0
Ainsa naisena jätkab Christel Piller Posted Sunday 9th April, 2023 at 17:14(UTC+2) by maheaaatom
Paraku langes Evely konkurentsist just eelmise postituse kirjutamise ajal. Ta läks lükkama -ga, kuid sattus õnnetul kombel Kaidar Viikmani ässade otsa.
Väljas on ka Erki Niitlaan.
Ainsa naisena jätkava Christel stäkk on umbes 45K. Mullu sellest piisas, Christel suutis mullimängu 1-2 BB pealt end üldarvestuses kolmandaks tinistada.
Player
Chips
Progress
Erki Niitlaan
0
0
Evely Pihela
0
0
Evely ootab oma kaarte Posted Sunday 9th April, 2023 at 17:08(UTC+2) by maheaaatom
Kaks korda EMV põhiturniiril rahadesse tulnud Evely Pihelal on 15XBB stäkk ning naise enda sõnul kannatab sellega hetkel veel kaarte oodata, kuid alla 10XBB tuleb juba nii või naa pushima hakata.
Mida aga pole, on kaardid. Samuti kurdab Evely, et tegemist on väga raske lauaga (Kaidar, Christel, Kaarel, Andrey, Peeter, Ergo).
Fotograaf Lenka julgustab vahepeal püsti tõusnud Evelyt, et küllap sa jõuad kaugemale kui Igor ja istu rahulikult maha. Telelauas mängival Igoril on keskmisest pisut suurem stäkk.
16:59 (UTC+2)
Start of Level 12 Blinds: 1,500/3,000 Ante: 3,000
Kolm suurimat stäkki Posted Sunday 9th April, 2023 at 16:57(UTC+2) by maheaaatom
Turniiri liider peaks olema Erik Põlluveer, kel on umbes 280 000 punkti.
Andrey Koks ja Kaur Ajamaa võivad mõlemad uhkustada umbes 230K stäkiga.
Player
Chips
Progress
Erik Põlluveer
280,000
102,200
Andrey Koks
230,000
146,100
Kaur Ajamaa
230,000
70,000
Eedi Kirves pääseb napilt Posted Sunday 9th April, 2023 at 16:46(UTC+2) by maheaaatom
Eedi Kirves on enne floppi sees Peeter Talviste vastu.
Eedi:
Peeter:
Floppi ! Turn on , mis annab Eedile rea-oute juurde, river aga toobki selle kohale. Eedi stäkk just ülearu suur ei olnud ja Peetriga ei juhtu väga midagi.
Üks langeja ka - Rain E. ei kerki paraku kõrgemale 40. kohast.
Player
Chips
Progress
Rain E.
0
0
Ainult eestlased Posted Sunday 9th April, 2023 at 16:35(UTC+2) by maheaaatom
Mulluse põhiturniiri finaallauda liidrina läinud agressiivne hispaanlane Victor Amat on mängust välja ning nüüd peaks turniiril jätkatama tõesti ainult eestlased.
Võrreldes mullusega osales hispaanlasi ka oluliselt vähem.
Player
Chips
Progress
Andrei Mjagkov
0
0
Victor Amat
0
0
16:28 (UTC+2)
Start of Level 11 Blinds: 1,200/2,400 Ante: 2,400
Veel langejaid : Karl Kivastik ja Lauri Liias Posted Sunday 9th April, 2023 at 16:24(UTC+2) by maheaaatom
Vahepeal on langenud välja veel kaks mängijat, nende seas ka EMV heads-up turniiri poolfinalist Lauri Liias.
Mis Karl Kivastikuga telelauas juhtus, saate vaadata peagi juba ülekandest. Avaldame ka teise salapärase telelaua langeja nime - selleks oli Mati Pirn. Viimane läks muidugi ka telelauda ülipisikese stäkiga.
Steven kuivas kokku Posted Sunday 9th April, 2023 at 16:09(UTC+2) by maheaaatom
Steven Seller kaotas oma viimased nupud -ga Christel Pilleri -le. Kuna Steveni stäkk oli viimase lükke eel vaid 5XBB, polnud selles jaotuses midagi erakorralist.
Väljas on ka Andres Leppik ning üks üks mängija ka telelauast. See tähendab, et ülejääud mängijad viidi kokku viiele lauale.
Player
Chips
Progress
Mati Pirn
0
0
Andres Leppik
0
0
Steven Seller
0
0
Kaarel haarab ohjad Posted Sunday 9th April, 2023 at 15:57(UTC+2) by maheaaatom
Kaarel Lepik on tõusnud 11. mängutaseme esimese poolega juba 240K peale ning sellega üks turniiri kindlatest liidritest.
Viimases jaotuses hankis ta natuke lisa Evely Pihelalt.
Sõda toimus blindidel, floppi vaadati 26000-ga.
Kaarel teatas esimesena, et on all-in ning Evely foldis üsna kiirelt.
Player
Chips
Progress
Kaarel Lepik
240,000
125,600
Peagi algab telelaud, Taavi ja Airin on väljas Posted Sunday 9th April, 2023 at 15:51(UTC+2) by maheaaatom
Tegelikult on telelaud juba mõnda aga käimas, kuid vaatajad näevad seda 30-minutilise viivitusega. Veel viis-kuus minutit kannatust ja võite teleülekannet vaatama hakata. Seal istub muide üsna põnev seltskond - Pihela, Koorits, Koppe, jt.
Põhiturniirilt ka kaks langejat: Taavi Tamm ning Airin Pindis. Mõlemal olid ka selgelt alla keskmise stäkid. Turniiri jätkab kaks naist.
Player
Chips
Progress
Airin Pindis
0
0
Taavi Tamm
0
0
9. ja 10. taseme suurimad võitjad ja kaotajad Posted Sunday 9th April, 2023 at 15:43(UTC+2) by maheaaatom
Tänased kolm esimest taset olid kõige edukamad Peeter Talvistele, Taago Tammele ja Sten Rõngelepale.
Kes olid suurimad kaotajad? Eks ikka need, kes välja kukkusid. Ühtegi kuuekohalist stäkki me ei kaotanud, kuid mõned keskmise punktisummaga alustanud mängijad siiski.
Turniiri esiviisik 10 mängutaseme järel Posted Sunday 9th April, 2023 at 15:34(UTC+2) by maheaaatom
Kõik chipcountid on uuendatud, turniiri esiviisik on hetkel järgmine (sulgudes saak viimase kahe taseme ajal):
Millistele naistele meeldib telelaud? Posted Sunday 9th April, 2023 at 15:03(UTC+2) by maheaaatom
Me teame, et telelauda ei kipu Airin Pindis ning nüüd sedagi, et ka Christel Piller eelistaks mitte keemareta ees mängida.
Uurisime Christelilt, et millised Eesti naismängijad võiksid aga olla just suured telelaua sõbrad. "Carmen-Elina näiteks. Ja Siiri. Tegelikult on neid päris palju," teeb Christel oma pakkumise.
Märkamatult oleme jõudnud turniiri esimese pausini.
Siim Silver Salumaa ei üllata Posted Sunday 9th April, 2023 at 14:56(UTC+2) by maheaaatom
Siim Silver Salumaal oli kõige väiksem stäkk (alla 10XBB) ning lõpuks jäi ta sellest ka lõplikult ilma.
Jätkab 49 mängijat.
Player
Chips
Progress
Siim Silver Salumaa
0
0
Ajagraafiku võrdlus eelmise aastaga Posted Sunday 9th April, 2023 at 14:54(UTC+2) by maheaaatom
2022. aasta EMV põhiturniiri teist päeva alustas 50 mängijat, täpselt samas seisus olema ka praegu.
Tollal alustati mänguga kell 12:00, hetkel on kell 14:50.
Finalistid olid selged kell 21:30. Kui sel aastal läheb kõik täpselt nii nagu eelmisel, lõppeb päev kell natuke pärast südaööd.
Aga nagu öeldakse - aastad pole vennad. Sel aastal on mängijatel ka 50% rohkem punkte (algstäkk 30000 mulluse 20000 vastu), samas on turniiri struktuur õige natuke kiirem.
Reporter "Maheaatom" prognoosib finalistide selgumist kuskile kella 00:00-02:00 vahele ehk korrigeerib tunni võrra oma varasemat ennustust. See tähendaks 11-13 tunnist teist päeva.
Player
Chips
Progress
Siim Silver Salumaa
0
0
Maikel Homin telelauda ei kipu Posted Sunday 9th April, 2023 at 14:47(UTC+2) by maheaaatom
Maikel Homin uurib, et mis kell telelaud algab ning lisab, et tema sinna küll minna ei taha. "Siin kõik profid vaatavad, et mida see donk teeb," naljatleb Maikel.
Maikel alustas teist päeva suuruselt kolmanda punktisummaga. Tema stäkk on hetkel 210K, mis on turniiri üks suurimaid. Täpsed chipcountid avaldame pärast esimese pausi lõppu pisut rohkem kui poole tunni pärast.
Üks väljalangeja ka - Adria Comas I Roura
Player
Chips
Progress
Maikel Homin
210,000
42,900
Adria Comas I Roura
0
0
Peeter võtab kaks korraga, nende seas ka Joel Lindpere Posted Sunday 9th April, 2023 at 14:40(UTC+2) by maheaaatom
Viiendas lauas on kolm meest pärast floppi all-in.
Peep Kivistik:
Joel Lindpere:
Peeter Talviste . Huuh!
Turn ja river midagi ei muuda, konkurentidest natuke suurema stäkiga all-in läinud kolmekordse Eesti meistri Peetri stäkk nüüd ka umbes 200 000.
Player
Chips
Progress
Peeter Talviste
200,000
112,000
Peep Kivistik
0
0
Joel Lindpere
0
0
Tempo on pisut langenud Posted Sunday 9th April, 2023 at 14:37(UTC+2) by maheaaatom
Endiselt on laudades 53 mängijat ning kuna keskmine stäkk on pea 40XBB, pole kellelgi ka väga kiiret. Võib-olla vaid Siim Silver Salumaal, kes alustas päeva 13200 punktiga ning on endiselt üsna samas seisus.
Mauri on heas seisus Posted Sunday 9th April, 2023 at 14:28(UTC+2) by maheaaatom
Mauri Dorbek on allesjäänud mängijatest kindlasti üks nimekamaid ning tänase päeva algus on kulgenud tema jaoks soodsas pärituules. Seejuures on Mauri ka parajalt agressiivne ning kasutab kõiki soodsaid kohti ära.
Omajagu lisa tuli just järgmisest jaotusest. Sten Rõngelep avas 4600 tõstega ning Mauri vastas 14K kolmpanusega.
Flopis avati
Sten checkis, Mauri pani 6500 ja sai calli.
Turn ja kordus sama. Seekord läks Mauri initsiatiivil keskele 9500.
Riverisse avati , mille mõlemad mängijad läbi checkisid. Sten näitas üheksaid, Mauril oli . Mauri stäkk nüüd umbes 190 000.
Player
Chips
Progress
Mauri Dorbek
190,000
103,500
Rain ja Ergo on pisut juurde saanud Posted Sunday 9th April, 2023 at 14:17(UTC+2) by maheaaatom
Päeva liidritena alustanud Rain Kandla ning Ergo Maruste on mõlemad natuke juurde saanud ning istuvad lauas ca. 200K stäkkidega.
Turniiril on alles 53 parimat ning mängijad on viidud kuute lauda. Ukse poole nägime aga liikumas Gert Laanemetsa ja Toivo Ojasood.
Player
Chips
Progress
Toivo Ojasoo
0
0
Gert Laanemets
0
0
Madise viimased nupud lähevad Raunole Posted Sunday 9th April, 2023 at 14:10(UTC+2) by maheaaatom
Madis Lepsi viimased nupud (6xBB) lähevad keskele ning Rauno Arras otsustab positsioonilt õnne proovida.
Madis:
Rauno:
Flopist Raunole kaks paari. Väljas ka Konstantin Gorbunov.
Player
Chips
Progress
Madis Leps
0
0
Konstantin Gorbunov
0
0
14:05 (UTC+2)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Kuidas naistel läheb? Posted Sunday 9th April, 2023 at 14:04(UTC+2) by maheaaatom
Meil on kolm tublit naisvõistlejat, kellest Evely on suutnud oma stäkki pisut kasvatada (tal hetkel 75K). Ka Christel on pigem natuke juurde saanud.
Airin on natuke ära andnud ning ootab oma hetke. Kõigil kolmel on suurepärane oskus mullimängudes ellu jääda, kuid hetkel on mullimäng kahjuks veel kaugel. Keskmine stäkk alles 53XBB.
Algas 10. tase, pisut enne seda suutis Kaidar Viikman oma ministäkki duublisse saada.
Player
Chips
Progress
Evely Pihela
75,000
16,700
Herli flippas end välja Posted Sunday 9th April, 2023 at 13:58(UTC+2) by maheaaatom
Päeva vaid 10XBB-ga alustanud Herli Olop leidis BB-l olles oma käest lõpuks mängitava kaardi , kuid kaotas nendega flipi pocket seitsmetele. "Kõik aus, flip ja mul oligi väike stäkk," võtab Herli asja stoilise rahuga.
Mõnda aega tagasi Kristjan Maasalule suure duubli andnud Oskar Ojaveer on samuti mängust väljas. Nagu ka Vladimir Iljunin ja Jaan Kõrgema.
Player
Chips
Progress
Oskar Ojaveer
0
0
Jaan Kõrgema
0
0
Vladimir Iljunin
0
0
Herli Olop
0
0
Vladimir Iljunin
0
0
Martin Häidberg kukutas Oliver Kullmani Posted Sunday 9th April, 2023 at 13:51(UTC+2) by maheaaatom
Pärast floppi panustas Martin ca. 70000 ning Oliver lükkas oma stäki keskele. Meestel oli üsna võrdselt punkte, Martinil pisut rohkem.
Martin mõtles pikalt. "No kui sul on, siis on," sõnas mees lõpuks ja callis ära.
Oliver:
Martin:
Masti maha ei tulnud ning Martin sai umbes 70K stäkilisa. Mehe rõõm oli suur!
Player
Chips
Progress
Martin Häidberg
155,000
44,900
Oliver Kullman
0
0
Ergo kugistab ühe pisikese stäki Posted Sunday 9th April, 2023 at 13:38(UTC+2) by maheaaatom
Ergo Maruste callib ära 10K peale kukkunud Viktor Mägi all-in panuse.
Viktor:
Ergo:
Lauast tuleb üks viis veel juurde. Väljas on ka Ragnar Linde.
Player
Chips
Progress
Viktor Mägi
0
0
Ragnar Linde
0
0
Richard langes klassikaliselt Posted Sunday 9th April, 2023 at 13:26(UTC+2) by maheaaatom
Richard Koppeli kuningad jooksid Sten Rõngelepa ässade otsa. Steni teise päeva algus on olnud üliedukas - mees on tõusnud lühikese ajaga 47800 pealt umbes 170K-le.
Player
Chips
Progress
Sten Rõngelep
170,000
122,200
Richard Koppel
0
0
Raha jagub 23 parimale Posted Sunday 9th April, 2023 at 13:18(UTC+2) by maheaaatom
EMV põhiturniiri võitja teenib 16799 eurot, kokku jagub auhinnaraha 23 parimale. Loomulikult on võimalikud ka erinevad diilid.
Korrigeerus ka auhinnafond, mis on 78199 eurot. Koht finaallauas toob sisse vähemalt 1700 eurot.
Player
Chips
Progress
Sten Rõngelep
170,000
122,200
Richard Koppel
0
0
Mäng on alanud Posted Sunday 9th April, 2023 at 13:09(UTC+2) by maheaaatom
Põhiturniiri teine päev on läinud käima ning kaardid on õhus.
Kohe esimeses jaotuses kaotasime Allan Arjuti, kes tõdes juba eile, et niivõrd väikese stäkiga polegi tegelikult mõtet päeva alustada.
Kuna turniiri ei jätka ka Roman R., siis on hetkel laudades 65 parimat.
Player
Chips
Progress
Allan Arjut
0
0
EMV põhiturniir jätkub kell 13:00 Posted Sunday 9th April, 2023 at 10:03(UTC+2) by maheaaatom
Avapäeva edukalt üle elanud 67 mängijat naasevad areenile pühapäeval kell 13:00. Turniiridirektor Meelis Ahman palus olla kohal 15 minutit varem, et varakult oma istekoht üles leida ning alustada mängu õigeaegselt.
Tänane mängupäev võib tulla võrdlemisi pikk, sest mängitakse kuni finalistide selgumiseni. Eeldatavalt võiks selleks kuluda 12-14 tundi, kuid kõik sõltub mängutempost ning mängijatest, kes rahadesse jõuavad. Heal juhul võib ka kiiremini minna. Liidrina alustab Rain Kandla, kuid vahed on väga väikesed. Tuleb põnev heitlus!
09:59 (UTC+2)
Day 2 of Estonian Poker Championship Started Level: 9 Blinds: 800/1,600 Ante: 1,600
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.
. Flopis on äss ning turn ja river ei muuda midagi. Nii Arko kui Peeter teenivad 1600 eurot.
ning Peeter lükkab esimesena kiirelt all-in.
!
-ga Arko Akenpärgi 
, Priit tõmbas laua abiga rea kokku). Tal jäi umbes 15K alles, mille võttis ära Kaarel Lepik.
-ga kiusama ning Christel callis 
vs. 
, mis checkiti külmavereliselt lõpuni. 
on pangas juba tubli 80K ning turni 
järel jätkab Igor 57K panusega. Kaido callib, riveril avatakse 
järel lükkab ka Taago oma stäki keskele ning Maikel looobub. "Huuh," hingab Taago sügavalt välja. On näha, et Maikeli calli ta küll ei soovinud.
, Kalevil on 
toob ka masti kohale. "Oota, sa pole veel kaotanud," rahustab Taago vastast. Paraku on river 
ja kordus sama. Seekord läks Mauri initsiatiivil keskele 9500. 
, mille mõlemad mängijad läbi checkisid. Sten näitas üheksaid, Mauril oli 
panustas Martin ca. 70000 ning Oliver lükkas oma stäki keskele. Meestel oli üsna võrdselt punkte, Martinil pisut rohkem.
£ GBP
$ USD
€ EUR
