0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0055 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-04-30'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_350_Tallinn_Cup_Est'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0003 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.0064 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0004 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_350_Tallinn_Cup_Est'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'
0.0193 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '220'
AND `published` = 1
0.0192 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0042 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '223'
AND `published` = 1
0.0034 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '223'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '94'
AND `name` = '2'
0.0046 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '223'
ORDER BY `busted` ASC, `current_chips` DESC
0.0031 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '223'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9933'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9680'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9640'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9639'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9636'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9633'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '9631'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9628'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9625'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9623'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9622'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9621'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9610'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9606'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9603'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9594'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0147 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0318 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9556'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0149 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '223'
ORDER BY `busted` ASC, `current_chips` DESC
0.0042 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '223'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9933'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9680'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9640'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9639'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9636'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9634'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9633'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9631'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9628'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9625'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9623'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9622'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9621'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9618'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '9617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9613'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9610'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9606'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9603'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9601'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9600'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9594'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9573'
ORDER BY `chip_change` DESC, `busted` ASC
0.0144 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9563'
ORDER BY `chip_change` DESC, `busted` ASC
0.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` = '9562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9556'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9555'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0165 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '223'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
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 Kings of Tallinn 2024 Ended Level: 28 Blinds: 50,000/100,000 Ante: 100,000
Turniiri võitis norralane Sven Otto Omland Posted Sunday 25th February, 2024 at 10:14(UTC+2) by maheaaatom
Kings of Tallinn 2024 350 € CUP-il osutus parimaks norralane Sven Otto Omland, kes teenis 19 200 eurot. Talle järgnesid neli soomlast, neist esimesena WSOP Circuit Tallinn suurim võidumees Akseli Paalanen. Nagu arvata võis, ei kulunud võitja selgitamiseks kaua aega - pärast Dmitri Dudakovi langemist kuuendalt kohalt vaid natuke üle tunni.
Sellega võime 350 € CUP-ile lõplikult joone alla tõmmata ning jätkata juba 555 € Championshipiga.
6. koht Dmitri Dudakov 4120 € Posted Saturday 24th February, 2024 at 23:39(UTC+2) by maheaaatom
Kui sul on 6XBB stäkk ja buttonil pocket neljad, siis mis seal ikka mõelda.
Call tuleb SB-l istuvalt Juhana Konttinenilt, kellel on .
Lauda
Seekord läks siis nii. Aga Dmitri tegi sisuka mängu ning kindlasti näeme teda sel festivalil veel.
Sellega lõpetame ka tänase ülekande, alles on neli soomlast ja üks norralane. Tõsi - üks soomlane on Eestis alati väga hästi mänginud Akseli Paalanen, kes sai ka WSOP Circuit põhiturniiril kõige suurema auhinnaraha. Aga kes neist täpselt võitis, saate lugeda juba homsest päevakokkuvõttest.
Kohtume homme kell 12:00, mil hakkame elama kaasa juba 555 € Championship turniirile.
Player
Chips
Progress
Dmitri Dudakov
0
0
Kuus parimat Posted Saturday 24th February, 2024 at 23:31(UTC+2) by maheaaatom
Saime veel ühe langeja - vahepeal turniiri kindlalt juhtinud Heikki Juhani Piira on mängust väljas. Tema hiigelstäkk läks suuresti juba pool tundi tagasi pocket üheksatega pocket poiste vastu.
Keskmine stäkk on 15XBB, Dmitril on kindlasti duublit vaja.
See hirmus blindiring Posted Saturday 24th February, 2024 at 23:25(UTC+2) by maheaaatom
BB peab nüüd välja panema juba 100K + 100K ehk umbes kuuendiku keskmisest stäkist.
Just "sõitis" see vanker üle Dmitrist, kes on nüüd umbes 700K peal. Seda on täpselt 7XBB, kuid tema õnneks pole ka konkurentide seis palju lihtsam.
23:24 (UTC+2)
Start of Level 28 Blinds: 50,000/100,000 Ante: 100,000
Karjed fuajees Posted Saturday 24th February, 2024 at 23:19(UTC+2) by maheaaatom
Fuajees käib kohtutav karjumine ja möll, kaugelt võis jääda mulje justkui oleks WSOP põhiturniiri viimases jaotuses kuningate nelik ässade neliku vastu jooksnud.
Tegelikult polnud asi kaugeltki nii hull, lihtsalt alkohol oli lauas oma töö teinud ning "rahvaturniiril" sattusid vastamisi ja . Lauda tuli kaks poissi ning ühtlasi ka neli potit.
"Peaks tegema nii, et see mast ei loe!" prahvatas Madis Müür, kes ise samuti sellele jaotusele vahetult kaasa elas.
Omaha satelliidil hoog sees Posted Saturday 24th February, 2024 at 23:06(UTC+2) by maheaaatom
Kui alguses paistis, et Omaha satelliidil tuleb kindel overlay, siis nüüd see päris nii enam ei tundu. Juba on 37 sisseostu tehtud ja mäng väga lahtine.
Ühes kuue mängija lauas oli äsja 5 mängijat all-in ning kui üks õnnelik oli kogu panga endale saanud, jäigi järgi täpselt kaks mängijat. "Kas me hakkame nüüd omavahel heads-up mängima," viskab üks neist nalja. Ei, laud lüüakse mõistagi laiali.
22:53 (UTC+2)
Start of Level 27 Blinds: 40,000/80,000 Ante: 80,000
Kaardipaki vahetus ja paus Posted Saturday 24th February, 2024 at 22:39(UTC+2) by maheaaatom
Dmitri Dudakov osutab kaardipakis olevale ruutu kaheksale, mis olevat tema mõistes äratuntav. Floor uurib pakki, midagi erilist neile silma ei hakka. Aga selles olukorras kasiino mängijatele muidugi vastu vaidlema ei hakka.
Lauda tuuakse kiirelt uus pakk, millega jõutakse mängida täpselt kaks jaotust, sest turniiri katkestab 15-minutiline paus. Viimase jaotusega korjab veel pisut lisa Dmitri, sundides vastased pangast loobuma. Tal nüüd 1,2M.
Player
Chips
Progress
Dmitri Dudakov
1,200,000
200,000
Iseseisuvuspäevaturniiril 345 sisseostu Posted Saturday 24th February, 2024 at 22:29(UTC+2) by maheaaatom
Kinnitatud numbrid - esimesel Kings of Tallinn 2024 "rahvaturniiril" tehti 345 sisseostu ning mängitakse 42 159 eurole.
7 vaprat Posted Saturday 24th February, 2024 at 22:26(UTC+2) by maheaaatom
Lõpuks toimub üks PFAI all-in coinflip, kus jooksevad vastamisi
ja vastas pocket üheksad. Arto Lehtonen saab küll flopis ässale pihta, kuid turn on saatuslik üheksa ning tuleb lauast püsti tõusta.
Kuidas läheb aga Dmitril? Õnneks hästi! Ta on natuke juurde kogunud ning praegu umbes miljoni peal.
Player
Chips
Progress
Dmitri Dudakov
1,000,000
100,000
Täna tuleb veel üks turniir Posted Saturday 24th February, 2024 at 22:14(UTC+2) by maheaaatom
Täna kell 23:00 algab veel üks õige kaval turniir. Selleks on 80-eurone 555 € Championship megasatikas, kus on väga korralik garantii - koguni 10 piletit.
Esimesed 8 taset on 15-minutilised, järgmised vältavad 10 minutit (ühesõnaga megaturbo). Hiline registeerumine vältab täpselt kaks tundi ehk umbes kell üheni öösel.
Lõpuks ka esimene finaallaua bust-out Posted Saturday 24th February, 2024 at 22:10(UTC+2) by maheaaatom
Eelmise jaotusega vastasele duubli andnud Marko Mikael Hynynenile jäi üsna vähe järgi ning sellega ta mängu tagasi tulla ei suutnud.
Seega jätkame kaheksakesi ning igaüks on endale juba taganud vähemalt 2450 eurot.
22:08 (UTC+2)
Start of Level 26 Blinds: 30,000/60,000 Ante: 60,000
Teresa loosib tasuta turniiripileti Posted Saturday 24th February, 2024 at 22:08(UTC+2) by maheaaatom
Vahepeal toimus 555 € loosimine kõikide mängijate vahel, kes osalesid Iseseisvuspäeva turniiril.
"Võitja on....Stanislav!" kuulutab turniiridirektor Teresa välja. Kui palju meid neid Stanislave on? Eks ta ikka Smeljovile läheb.
Dmitri saab natuke juurde Posted Saturday 24th February, 2024 at 22:02(UTC+2) by maheaaatom
Heikki Piira callib buttonilt, SB foldib ja Dmitri checkib BB-lt.
Flop on , Dmitri checkib ette, soomlane paneb uuesti 50K ja saab calli.
Turn on ning nüüd on soomlase check-panus juba 125K. Dmitril on umbes 400K järgi, kuid ta callib jälle.
RIver checkitakse läbi. Dmitri avab ning Piira muckib kinniselt.
See oli oluline lisa, muidu oleks Dmitril juba väga-väga raskeks läinud. Nüüd on tal umbes 700K ehk 14XBB.
Melu kasiinos Posted Saturday 24th February, 2024 at 21:51(UTC+2) by maheaaatom
Kasiinos on käimas cashgame kaheksal laual, kuid õhtu on veel noor, sest möllu on omajagu, kuid mitte veel päris nii palju kui eile.
Igatahes võis juba näha ka maailmakuulsat Soome highrollerit Ilari Sahamiest, kes tänavugi Tallinnasse lõbutsema on tulnud. Mida Ilari täpselt mängida plaanib, me muiudgi veel ei tea.
21:42 (UTC+2)
Start of Level 25 Blinds: 25,000/50,000 Ante: 50,000
Dmitril 700K Posted Saturday 24th February, 2024 at 21:37(UTC+2) by maheaaatom
Dmitri stäkk on umbes 700K (keskmine miljoni kandis) ning viimasel levelil ta erilist actionit pakkunud pole. Korra käis küll all-in'is, kuid ühtegi calli ei järgnenud. Endiselt üheksa parimat järgi.
Player
Chips
Progress
Dmitri Dudakov
700,000
200,000
Tänavune rekord on juba ületatud Posted Saturday 24th February, 2024 at 21:34(UTC+2) by maheaaatom
Iseseisvuspäevaturniiril on tehtud juba 316 sisseostu ning ületatud sellega nii avaturniiri kui käimasoleva 350 CUP-i tulemus. Tõsi - re-entry periood saab kohe ka läbi (veel kolm kätt) kuid juba on turniiri auhinnfondi kogunenud pea 40 tuhat eurot.
Suures saalis on mõnda aega käimas ka PLO 60-eurone satelliit, mille auhinnagarantii on 5 x 555 € piletit. Kuna hetkel on laudades vaid 12 mängijat, võib siit isegi pisikest overlayd haista.
21:15 (UTC+2)
Start of Level 24 Blinds: 20,000/40,000 Ante: 40,000
Läänerindel muutusteta Posted Saturday 24th February, 2024 at 21:14(UTC+2) by maheaaatom
Kui enne finaali käis korralik rabistamine, siis nüüd mängitakse väga tasakaalukalt ning keegi välja langenud ei ole. Dmitri stäkk paistab olevat finaali väikseim, kuid seda on siiski tubli 20XBB ning Dmitri senine mäng on olnud väga arukas. Ehk rumalaid ja läbimõtlema otsuseid ta vaevalt teeb. Loodame parimat!
Finaallaud koos Posted Saturday 24th February, 2024 at 20:51(UTC+2) by maheaaatom
Ka finaallaua mullikoht selgus väga kiirelt ning allesjäänud 9 mängijat viidi kokku. Mis peamine, Dmitri on nende hulgas!
Käib finaallaua mullimäng Posted Saturday 24th February, 2024 at 20:47(UTC+2) by maheaaatom
Oleme kaotanud üsna lühikese ajaga kolm shortstacki ning jätkame hetkel kümnekesi.
Mõlemas lauas on viis mängijat, Dmitri lauas on kolm mängijat üsna võrdset ning üks väga suur (umbes 2,5M). Dmitril umbes 850K.
Mäng jätkub Posted Saturday 24th February, 2024 at 20:36(UTC+2) by maheaaatom
Võistlejad on laudades tagasi ning me jätkame tasemel 15K/30K, keskmine stäkk 722K.
Iseseisvuspäevaturniiril käib oodatult kõva möll, diilima on aetud isegi need inimesed, kes tavaelus teiste diilerite tööd juhivad. Hetkel 268 sisseostu ja 225 unikaalset mängijat laudades.
"Hiinakal" on alles 21 parimat, nende seas ka 3 eestlast: Siim Suviste, Mati Pirn ja Kristjan Abakanov. PLO turniiril on tehtud 88 sisseostu, hetkel laudades 48 mängijat.
20:34 (UTC+2)
Start of Level 23 Blinds: 15,000/30,000 Ante: 30,000
Õhtusöögipaus Posted Saturday 24th February, 2024 at 19:36(UTC+2) by maheaaatom
350 € CUP-il algas õhtusöögipaus (60 minutit), alles on endiselt kuraditosin parimat.
Iseseisvuspäevaturniir on alanud, Dmitrile stäkilisa Posted Saturday 24th February, 2024 at 19:29(UTC+2) by maheaaatom
Iseseisvuspäeva turniir on läinud käima, laudades 182 mängijat. Aga neid tuleb kindlasti juurde, sest IKKA veel on kassas järjekord! Ja võimalik, et laudade arvu ka suurendatakse.
CUP-ilt langes just välja lakkamatu jutuvadaga Eestis elab soomlane Tapio Aaltonen, kelle unistus olla turniiri "parim eestlane" seekord ei täitunud. Dmitri Dudakov on kenasti sees ning ka omajagu stäkki juurde hankinud. Tal umbes 900K.
Player
Chips
Progress
Dmitri Dudakov
900,000
150,000
Iseseisuvuspäevaturniiri algus venib Posted Saturday 24th February, 2024 at 19:12(UTC+2) by maheaaatom
Järjekorrad on pikad nii kassasse, pileti järele kui ka garderoobi (küll puudub täielikult baarisaba), et turniiri algusega tuleb natuke oodata, kuniks kõik mängijad oma koha leiavad.
Hetkel on kirjas 143 mängijat, kuid see number suureneb pea iga sekundiga.
Ahvikiirusel kulgev 350 € CUP Posted Saturday 24th February, 2024 at 19:06(UTC+2) by maheaaatom
Meie peamise vaatluse all oleval karikaturniiril on gaas totaalselt põhja lükatud ning oleme jõudnud juba 15 parimani. Mänguruumi on endiselt vaid umbes 25xBB jagu. Dudakov ongi mängus täpselt keskmise stäkiga.
Elegantne järjekord treppidel Posted Saturday 24th February, 2024 at 19:02(UTC+2) by maheaaatom
150-eurost turniiri ründavad tõelised hordid, sest kassa järjekord ulatub treppideni ning kulgeb treppidest alla.
Aga on ka nutikamaid mängijaid, kes on pileti varem soetanud ning pääsevad kohe lauakaarti välja võtma. Näiteks perekond Leiboldid.
"Me oleme WSOP-l käinud, me teame seda värki," ei varja Kairit oma teadmisi.
19:00 (UTC+2)
Start of Level 22 Blinds: 10,000/25,000 Ante: 25,000
18. koht Oskar Ojaveer 890 € Posted Saturday 24th February, 2024 at 18:52(UTC+2) by maheaaatom
10BB stäkiga Oskar läheb kaitsma oma BB-d -ga, vastas on . Laud Oskarit ei päästa.
Kui Oskar läheb tšeki järele, uurib ka floor, et mis kaardiga sa siis välja langesid. "Kas sellest oleneb, kui suur tšekk mulle antakse," naljatleb Oskar vastu.
20. koht Maksim Han 890 € Posted Saturday 24th February, 2024 at 18:43(UTC+2) by maheaaatom
Kahjuks jäime ilma ka Maksim Hanist, kelle kaart viimase tunni-kahe jooksul lihtsalt ei jooksnud.
Ida-Virumaalt pärit Maksimi seni parim saavutus on kümnes koht Kings of Tallinn 2022 Championship turniirilt.
Õnneks on hea uudis ka - Dmitri Dudakov on tõusnud 750K peale! Oskaril endiselt umbes 200K.
Player
Chips
Progress
Dmitri Dudakov
750,000
350,000
Oskar Ojaveer
200,000
120,000
Maksim Han
0
0
22. koht Peep Kivistik 890 € Posted Saturday 24th February, 2024 at 18:34(UTC+2) by maheaaatom
Peep hängis nii mulli eel kui järel üsna pisikese stäkiga ning seda oluliselt suurendada ta ei suutnud. Tasuks 22. koht ning 890 eurot.
Peame nüüd lootma vaid kolmele Eesti mängijale - Dmitri Dudakovile, Maksim Hanile ja Oskar Ojaveerile. Ja miks mitte ka lakkamatult rääkivale Tapio Aaltonenile :)
Player
Chips
Progress
Peep Kivistik
0
0
18:32 (UTC+2)
Start of Level 21 Blinds: 10,000/20,000 Ante: 20,000
VIDEO: Kings of Tallinn 2024 Kick Off podcast Posted Saturday 24th February, 2024 at 18:25(UTC+2) by maheaaatom
Teiste turniiride hetkeseis Posted Saturday 24th February, 2024 at 18:23(UTC+2) by maheaaatom
PLO-le on tehtud 60 sisseoste ning üks suurfavoriite Andres Abakanov on oma bulleti juba ära kasutanud. Muidugi, tal on veel võimalus mängu naasta.
Hiinakale tehti 67 sisseostu, mis on selle mänguformaadi kohta väga tubli näitaja. PLO satelliit on ka lõppenud, planeeritud 5 pileti asemel anti neid ära koguni 10.
Oskar elimineerib viimase naismängija Posted Saturday 24th February, 2024 at 18:16(UTC+2) by maheaaatom
Oskar Ojaveer kaotas (enda sõnul open-enderiga gämmeldes) umbes poole oma stäkist ning callis seejärel allesjäänud 175K-ga Karita Koppineni all-in'i. Naisel võis olla umbes 100 000 punkti.
Oskar:
Karita:
Jaotus laheneb Oskarile soodsalt, kuigi kaugeltki mitte viisakalt. Lauda kümme. Alles kaks tosinat mängijat, naisi kahjuks nende seas enam pole.
Oskaril 320K.
Player
Chips
Progress
Oskar Ojaveer
320,000
20,000
Dudakovile oluline skalp Posted Saturday 24th February, 2024 at 18:07(UTC+2) by maheaaatom
Dmitri Dudakov callib ära ühe 130K stäkiga mängija all-in'i ning leiab end üsna soodsast seisust - vs. .
Okei, vastane saab turnil küll mastitõmbe, kuid kohale seda ei tule. Dmitril nüüd taas umbes 400K.
Player
Chips
Progress
Dmitri Dudakov
400,000
120,000
Omade stäkid Posted Saturday 24th February, 2024 at 18:01(UTC+2) by maheaaatom
Kahjuks on kõik meie mängijad nuppe loovutanud, napilt üle keskmise stäkiga on vaid Oskar Ojaveer.
Player
Chips
Progress
Oskar Ojaveer
340,000
60,000
Dmitri Dudakov
280,000
220,000
Maksim Han
200,000
120,000
Peep Kivistik
120,000
30,000
17:59 (UTC+2)
Start of Level 20 Blinds: 10,000/15,000 Ante: 15,000
32. koht Tatjana Valujeva 700 € Posted Saturday 24th February, 2024 at 17:47(UTC+2) by maheaaatom
Turniiri selgelt parimal Eesti naismängijal Tatjanal on alles imevähe nööpe ning ta on nendega sisuliselt sund all-in'is.
Tatjana avab , vastas . Kuna flopis avatakse kaks ruutut, pole seis esteks üldsegi halb. Paraku turn ega river midagi ei muuda.
Ühtlasi algas paus, alles 30 parimat.
Player
Chips
Progress
Tatjana Valujeva
0
0
Laulupeo ootel Posted Saturday 24th February, 2024 at 17:39(UTC+2) by maheaaatom
Vähem kui poolteist tundi on jäänud tänase Iseseisvuspäeva eriturniiri alguseni, kuhu mahub korraga kuni 200 mängijat. Kuna turniiri sisseost on mõnusalt madal (150 eurot), siis on osalejate seas kindlasti ka palju hobimängijaid.
Turniiril on kasulik osaleda ka põhjusel, et sellel osalejate vahel loositakse välja pileteid homsele 555 € Championshipile.
37. koht Marten Rimmel 700 € Posted Saturday 24th February, 2024 at 17:36(UTC+2) by maheaaatom
Marten Rimmel, kes cashis ka ühel Tallinnas toimunud WSOP Circuit turniiril ning mullusuvisel Summer Showdown'il, saab tasuks 37. koha eest 700 eurot.
34 parimat järgi, eestlasi on neist viis.
Mull lõhkes üheainsa käega Posted Saturday 24th February, 2024 at 17:18(UTC+2) by maheaaatom
Pikka kabetamist on ei tule, juba järgmise käega on mull lõhkenud ning allesjäänud 39 mängijat on teeninud vähemalt 700 eurot. Mullimeheks jääb põhjanaaber Matti Salminen.
Rahades on kuus Eesti mängijat. Suurimad stäkid on Dmitri Dudakovil ning Oskar Ojaveeril, mõlemad mängivad ka aktiivselt ning agressiivselt.
Player
Chips
Progress
Dmitri Dudakov
500,000
220,000
Oskar Ojaveer
400,000
100,000
17:10 (UTC+2)
Start of Level 19 Blinds: 6,000/12,000 Ante: 12,000
Virgo väljas, algas mullimäng Posted Saturday 24th February, 2024 at 17:10(UTC+2) by maheaaatom
Action toimub pärast floppi . Vastane checkib ette, Virgo panustab umbes poole oma stäkist ning saab all-in panuse vastu. Enam pole mingit pääsu, Virgo peab callima ning avab . Vastane on kahjuks ideaalselt floppi tabanud () ning turn ja river on plangud.
Sellega oleme jõudnud 40 parimani ning mäng jätkub hand-by-hand.
Player
Chips
Progress
Virgo Laansoo
0
0
Algas PLO 4/5 Cards Posted Saturday 24th February, 2024 at 17:03(UTC+2) by maheaaatom
Suures saalis on mängijad võtmas istet 555 € Omaha turniiril. Kirjas on 22 mängijat, kuid nende arv kasvab tõenäoliselt kiiresti. Eestlastest on kohal Omaha-mängude superässad Georgi Voomets ja Andres Abakanov, kes mõlemad nii PLO-d kui PLO Hi-Lo'd tõesti harukordselt hästi valdavad.
"Hiinlased" vahetavad muljeid Posted Saturday 24th February, 2024 at 17:00(UTC+2) by maheaaatom
Fuejeest õnnestus kinni püüda Mati Pirn ja Kristjan Abakanov, kes on ühed nendest, kes OFC Pineapple võitu jahivad.
Miks siis ikkagi tasub mängida Hiina pokkerit? Mõlemad sõnavad, et esiteks hoiab see mängijaid pidevalt tegevuses ning tänase turniiri reeglid on ka hästi mängijasõbralikud, kuna puudub piiramatu Fantasy Landi võimalus, millega on võimalik teisi mängijaid kiirelt bustoks tõmmata.
"Hobimängijatele on Hiina pokker suurepärane mäng," kiidab Kristjan.
Kaks privaatturniiri külalistele Posted Saturday 24th February, 2024 at 16:41(UTC+2) by maheaaatom
Suures saalis on lisaks KOT Cup-ile käimas ka kaks privaatturniiri, üks suurem ja teine väiksem.
Suuremal on külalisteks paarkümmend sädelevat Soome prouat, kellele turniiridirektor Teresa julgelt pokkerit ning mängureegleid tutvustab. Midagi sarnast võisime näha ka kolm kuud tagasi toimunud Queens of Tallinnal.
16:38 (UTC+2)
Start of Level 18 Blinds: 5,000/10,000 Ante: 10,000
Omade stäkke Posted Saturday 24th February, 2024 at 16:35(UTC+2) by maheaaatom
Oleme jõudnud 45 parimani ning Eesti mängijaid on sees 7. Olgu siis lisaks Tatjanale loetud üle ka kõikide teiste stäkid.
Player
Chips
Progress
Maksim Han
320,000
50,000
Oskar Ojaveer
300,000
160,000
Dmitri Dudakov
280,000
150,000
Virgo Laansoo
210,000
0
Marten Rimmel
140,000
110,000
Peep Kivistik
100,000
50,000
Tatjana püsib mängus Posted Saturday 24th February, 2024 at 16:29(UTC+2) by maheaaatom
Preflopis läheb sisse kolm väikest stäkki, üks neist meie Tatjana Valujeva.
Tatjana avab , vastas on ning . Päris hea seis.
Tatjana õnnetuseks on flop tõeliselt halb, ka turn midagi ei muuda. Tema õnneks toob river siiski päästva rea.
Tatjanal nüüd umbes 160K. Meie mängijatest väljas seni hüva stäkki omanud Anton Konnov.
Player
Chips
Progress
Tatjana Valujeva
160,000
5,000
Anton Konnov
0
0
16:12 (UTC+2)
Start of Level 17 Blinds: 4,000/8,000 Ante: 8,000
Pausile läheb 61 mängijat Posted Saturday 24th February, 2024 at 15:55(UTC+2) by maheaaatom
350 € CUP teise päeva teisele pausile läheb 61 parimat. Mullini on veel aega, kuigi mänguruumi pole kellelgi just ülearu palju (keskmine umbes 25XBB). Kõigi eelduste kohaselt võiks võitja selguda umbes südaööks.
Eestlasi on mängus kaheksa.
Turniiri võitjale 19 200 eurot Posted Saturday 24th February, 2024 at 15:39(UTC+2) by maheaaatom
Sarnaselt Kings of Tallinn avaturniirile jagub auhinnaraha nüüdki 39 parimale. Kuna sisseost on aga törts suurem (350 vs. 250), on ka auhinnarahad summaarselt pisud suuremad.
Võitjale seega 19200 eurot, viimane rahakoht saab 700 €. Kahjuks ei pretendeeri sellele ei Ranno Sootla ega Aleksei Smirnov, kes mõlemad just äsja välja langesid. Küllap näeme neid mõlemaid aga aktiivselt teistel turniiridel osalemas.
Player
Chips
Progress
Ranno Sootla
0
0
Aleksei Smirnov
0
0
Virgo edeneb Posted Saturday 24th February, 2024 at 15:35(UTC+2) by maheaaatom
Virgo Laansoo on tõusnud umbes 210K peale ning sellega ilusti konkurentsis.
Äsja sai tubli lisa ka Maksim Han, kel niigi väga suur stäkk. Lauas avati ning Maksim panustas ette kõik tänavad, vastavalt 25K, 35K ja 45K. Riveril andis seni kohusetundlikult callinud soomlane alla.
Player
Chips
Progress
Virgo Laansoo
210,000
180,000
Dmitri annab natuke ära Posted Saturday 24th February, 2024 at 15:27(UTC+2) by maheaaatom
Dmitri avab MP-lt 12K-ga, saab calli buttonilt ning all-in panuse (umbes 22K) BB-l istuvalt Frederico Alvesilt.
Dmitri vastab 50K ületõstega, et BB isoloeerida ning saab sellega ka hakkama. Paraku ei suuda tema Alvesi -t üllatada.
Dmitri sellest hoolimata umbes keskmine stäkk, 135K. Oluliselt on kosunud Ranno Sootla (150K) ning juurde on saanud ka Oskar Ojaveer (umbes 140K).
Player
Chips
Progress
Ranno Sootla
150,000
100,000
Oskar Ojaveer
140,000
35,000
Dmitri Dudakov
130,000
55,000
15:23 (UTC+2)
Start of Level 16 Blinds: 3,000/6,000 Ante: 6,000
Maksimile võimas duubel Posted Saturday 24th February, 2024 at 15:17(UTC+2) by maheaaatom
Maksim Han suudab oma -ga kümnete vastu kena duubli võtta (PFAI). Tema stäkk nüüd muljetavaldav 270K.
Paraku on omade seast ka neli langejat ning eestlasi nüüd alles veel 11. Pluss mõistagi Eestis elav soomlane Tapio Aaltonen, kes soovib rõhutada, et vähemalt iseseisvuspäeval on temagi eestlane.
Player
Chips
Progress
Maksim Han
270,000
130,000
Stanislav Smeljov
0
0
Silver Simulask
0
0
Maksim Petrov
0
0
Kristjan Maasalu
0
0
Teele on luurel Posted Saturday 24th February, 2024 at 15:10(UTC+2) by maheaaatom
Kings of Tallinn 2024 hostess on tuntud laulja ning pokkerimängija, alati särav ning lõbus Teele Viira.
Keda Teele täna intervjueerima hakkab, pole hetkel veel teada. Igatahes on ta laudade vahel ringi liikumas ning vaikselt "ohvreid" otsimas.
Hiinlased alustasid Posted Saturday 24th February, 2024 at 15:08(UTC+2) by maheaaatom
Kaardid läksid liikvele ka OFC Pineapple turniiril ning 23 osaleja seas on 6 eestlast. Meeldiv on näha, et seda äärmiselt põnevat mängu, mis muide on leiutatud Soomes, harrastab aina enam ka eestlasi. Ja mõistagi on kohal Mati Pirn!
14:54 (UTC+2)
Start of Level 15 Blinds: 2,000/5,000 Ante: 5,000
Põnev külaline Inglismaalt Posted Saturday 24th February, 2024 at 14:53(UTC+2) by maheaaatom
Turniirilt küll kahjuks juba välja langenud ning täna kahte bulletit kasutanud inglane Paul Newey on mängija, kes väärib erilist tähelepanu.
Tegemist on tuntud ärimehega, kelle varandus ulatub sadadesse miljonitesse eurodesse. Muuhulgas on ta osalenud 1M$ sisseostuga WSOP Big One for One Drop turniiridel, kus suutnud ka rahadesse jõuda. Ühtekokku on mees teeninud live-turniiridel üle 5 miljoni euro.
Newey on pälvinud tähelepanu ka high-stakes kasiinomängijana, kes suutnud ka kasiino kassa tühjaks mängida. Ja selle raha siis mõni aeg hiljem taas kaotada... Küllap saab teda näha ka Olympic Casino VIP-toas.
Eesti mängija stäkke Posted Saturday 24th February, 2024 at 14:43(UTC+2) by maheaaatom
Hästi on edenenud Anton Konnov, Tatjana Valujeva, Peep Kivistik ning Maksim Han. Ranno on omajagu ära andnud ning otsib 50K stäkiga omi võimalusi.
Player
Chips
Progress
Anton Konnov
190,000
100,500
Tatjana Valujeva
155,000
125,000
Peep Kivistik
150,000
87,500
Maksim Han
140,000
110,000
Aleksei Smirnov
115,000
35,500
Oskar Ojaveer
105,000
24,500
Maksim Petrov
100,000
4,000
Dmitri Dudakov
75,000
0
Kristjan Maasalu
60,000
30,000
Stanislav Smeljov
60,000
12,000
Ranno Sootla
50,000
65,000
Urmo välkvisiit Posted Saturday 24th February, 2024 at 14:30(UTC+2) by maheaaatom
Päris viimasel hetkel jõudis mänguga liituda ka kuulus highroller Urmo Velvelt, kelle välkvisiit jäi kahjuks küll suhteliselt lühikeseks.
Mees suutis alguses päris kenasti oma stäki üles saada, kaotas seejärel suurema sellest 70%-ga favoriit olles ning sai oma viimasele PFAI lükkele kaks calli.
Maha jooksis ning Urmo () ei tabanud kahjuks midagi. Vastased checkisid boardi läbi ning pank võideti pocket seitsmetega.
14:27 (UTC+2)
Start of Level 14 Blinds: 2,000/4,000 Ante: 4,000
Eestlased langevad Posted Saturday 24th February, 2024 at 14:17(UTC+2) by maheaaatom
Väljas on nii ambitsioonikas noormängija Hendrik Uibo, nimekad ässad Mark Metsla ja Martin Piik, alles täna mängu alustanud highroller Taago Tamm kui ka aastaid tagasi Ida-Virumaa pokkeriturniiridel säranud Vladislav Han. Jätkab 108 parimat.
Player
Chips
Progress
Vladislav Han
0
0
Hendrik Uibo
0
0
Andres Lõiv
0
0
Nüüd läheb mänguks Posted Saturday 24th February, 2024 at 13:58(UTC+2) by maheaaatom
Mängijad on taas laudades, enam eksida ei saa.
Esialgsetel andmetel kogunes sisseoste 313 ning auhinnafondi 92 679 eurot. Selle nimel jätkab heitlust 126 pokkerisportlast.
13:57 (UTC+2)
Start of Level 13 Blinds: 1,500/3,000 Ante: 3,000
Eelmäng sai läbi Posted Saturday 24th February, 2024 at 13:38(UTC+2) by maheaaatom
Mängijad lubati 15 minutiks puhkama ning selle jooksul on veel võimalik mänguga liituda, alustades actionit 10XBB-ga.
Mängus peaks olema umbes 20 Eesti mängijat, ühe viimasena on sellega liitunud ka mulluse EMV põhiturniiri teine mees ning tuntud high-roller Taago Tamm.
"Täna on vähe rahulikum mäng kui eile," nendib Silver Simulask, kes alustas 28K-ga, kuid on nüüd juba 76K peal, mis on täpselt keskmine stäkk.
Kolm viimast kätt Posted Saturday 24th February, 2024 at 13:34(UTC+2) by maheaaatom
Alustati kolme viimase "re-entry käe" jagamist, misjärel läheb turniir lühikeseks ajaks pausile.
Ihaldatud 300 sisseostu piir saadi just täis, kuid auhinnafond päris kuuekohaliseks ikka ei tõuse. Sellest hoolimata on juba praegu auhinnapotis vägevad 89 422 eurot.
Rannol 115K Posted Saturday 24th February, 2024 at 13:23(UTC+2) by maheaaatom
Ranno, kelle stäkk oli päeva alguses 36500, on teinud head tööd ning tõusnud juba 115K peale.
Veel kümmekond minutit re-entry tegemiseks, sisseostude arv on liginemas 300-le.
Player
Chips
Progress
Ranno Sootla
115,000
250,000
Allan suundus Omahatama Posted Saturday 24th February, 2024 at 13:16(UTC+2) by maheaaatom
Eile hüva mängu näidanud Allan Arjut on kahjuks 350 € Championship'ilt välja langenud. Et mees mängu naasta ei kavatse, näitab see, et hetkel võib teda näha juba PLO satelliidil.
Viimane algas küll vaid 15 minutit tagasi, kuid juba on mängimas 45 pokkerisõpra. Jagamisele läheb vähemalt viis 555 € PLO 4/5 Cards Mystery Bounty piletit.
13:09 (UTC+2)
Start of Level 12 Blinds: 1,000/2,500 Ante: 2,500
Teised tänased turniirid Posted Saturday 24th February, 2024 at 13:09(UTC+2) by maheaaatom
Lisaks käimasolevale 350 € CUP teisele päevale on täna veel kavas kolm turniiri, mille võitja teenib koha Kings of Tallinn võitjate auväärses nimekirjas:
Kell 15:00 algab 150 € OFC Pineapple (Hiina pokker)
Kell 17:00 algab PLO 4/5 Cards (555 €) Mystery Bounty
Kell 19:00 algab Iseseisvuspäeva eriturniiri (NLH, sisseost kõigest 150 €)
Lisaks viiakse täna läbi ka kolm satelliiti:
Kell 13:00 algab 60 € sisseostuga PLO 5 satelliit tänasele 555 € PLO Omaha 4 & 5 Cards Mystery Bountyle, 5 x 555 € piletit GTD
Kell 21:00 algab teine satelliit samale PLO turniirile (sama sisseost ja samad tingimused)
Kell 23:00 algab 80 € Megasatelliit homme algavale 555 € Championship turniirile, 10 x 555 € piletit GTD.
Kas 10XBB on piisav? Posted Saturday 24th February, 2024 at 13:01(UTC+2) by maheaaatom
Peagi on algamas viimane tase, mille jooksul saab veel re-entry õlekõrre järgi haarata.
Kui sa peaksid liituma mänguga viimase pausi ajal, siis saad alustada täpselt 10XBB stäkiga. Aga ajalugu on näidanud, et ka niimoodi liitudes on vägagi kaugele jõutud.
12:35 (UTC+2)
Start of Level 11 Blinds: 1,000/2,000 Ante: 2,000
35 uut tulijat! Posted Saturday 24th February, 2024 at 12:31(UTC+2) by maheaaatom
Esimese poole tunni jooksul on mänguga liitunud juba umbes 35 uut pokkerisõpra.
Hetkel laudades 141 mängijat ning auhinnafond on paisunud 75 tuhande euroni.
Anna Astahhova avaturniiril kaheksas Posted Saturday 24th February, 2024 at 12:25(UTC+2) by maheaaatom
Täna öösel sai läbi ka 250 € sisseostuga Kings of Tallinn avaturniir, millel tehti koguni 305 sisseostu.
Kaks parimat tegid diili, võitis Daniel Lakka Soomest. Meie parimana sai Anna Astahhova kaheksanda koha ning teenis 1700 eurot auhinnaraha.
Keskmisest suuremad eestlaste stäkid Posted Saturday 24th February, 2024 at 12:20(UTC+2) by maheaaatom
Mängus on üle 20 eestlase, kuid eeldatavalt tuleb neid tänase esimese kolme mängutaseme jooksul veel juurde. Üheksal neist on keskmisest suurem stäkk.
P.S. Kui keegi märkas K-Holdem keskkonnas Ranno Sootlal 365K stäkki, siis igaks juhuks mainime, et tegemist oli veaga ning tegelikult on Rannol 36 500 punkti.
Player
Chips
Progress
Kevin Didvig
111,000
81,000
Maksim Petrov
96,000
204,000
Anton Konnov
89,500
59,500
Oskar Ojaveer
80,500
30,500
Aleksei Smirnov
79,500
15,500
Stanislav Smeljov
72,000
7,000
Vladislav Han
71,000
41,000
Andres Lõiv
62,500
32,500
Peep Kivistik
62,500
12,500
Teine päev on alanud Posted Saturday 24th February, 2024 at 12:13(UTC+2) by maheaaatom
Head lugejad, soovime teile kõigile head Eesti Vabariigi aastapäeva!
Mängijad on laudades taas istet võtnud ning teine päev on alanud. Täna mängime veel 3 x 30 minutit, mille jooksul on lubatud teha re-entry. Seejärel lüüakse auhinnafond lukku ning mängitakse kuni võitja selgumiseni.
12:10 (UTC+2)
Day 2 of Kings of Tallinn 2024 Started Level: 10 Blinds: 1,000/1,500 Ante: 1,500
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.
.
ja 
. Lauda tuli kaks poissi ning ühtlasi ka neli potit. 
, Dmitri checkib ette, soomlane paneb uuesti 50K ja saab calli.
ning nüüd on soomlase check-panus juba 125K. Dmitril on umbes 400K järgi, kuid ta callib jälle. 
ning Piira muckib kinniselt. 
, vastas 
. Kuna flopis avatakse kaks ruutut, pole seis esteks üldsegi halb. Paraku turn ega river midagi ei muuda. 
ning Maksim panustas ette kõik tänavad, vastavalt 25K, 35K ja 45K. Riveril andis seni kohusetundlikult callinud soomlane alla. 
Alvesi 
ning Urmo (
) ei tabanud kahjuks midagi. Vastased checkisid boardi läbi ning pank võideti pocket seitsmetega.
£ GBP
$ USD
€ EUR
