0.0005 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0126 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/2/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0004 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0005 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 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.0004 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 `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0005 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.0004 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.0062 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.0007 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` = 'kings_of_tallinn_autumn_2024_main_event'
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'
0.0365 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0089 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '455'
AND `published` = 1
0.0309 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '457'
AND `published` = 1
0.0271 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '460'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'
AND `name` = '2'
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `busted` ASC, `current_chips` DESC
0.0063 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` = '455'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19277'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19276'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19275'
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` = '19272'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19270'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19269'
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` = '19271'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19267'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19266'
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` = '19265'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19263'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19261'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19260'
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` = '19257'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19256'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19255'
ORDER BY `chip_change` DESC, `busted` ASC
0.0107 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19252'
ORDER BY `chip_change` DESC, `busted` ASC
0.0099 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19251'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19250'
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` = '19248'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19246'
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` = '19244'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19239'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19237'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19235'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19232'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19226'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19225'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19224'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19222'
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` = '19218'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19217'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19215'
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` = '19212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19209'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19208'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19204'
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` = '19203'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19198'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19195'
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` = '19193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19187'
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` = '19185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19184'
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` = '19182'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19179'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19173'
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` = '19172'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19171'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19170'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19167'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19166'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19163'
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` = '19162'
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` = '19161'
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` = '19160'
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` = '19156'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19155'
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` = '19154'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19150'
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` = '19149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19148'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19142'
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` = '19140'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19137'
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` = '19135'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19127'
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` = '19125'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19122'
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` = '19121'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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` = '455'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19277'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19276'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19275'
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` = '19272'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19270'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19269'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19271'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19267'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19266'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19265'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19263'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19261'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19260'
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` = '19257'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19256'
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` = '19255'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19252'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19251'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19250'
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` = '19248'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19244'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19239'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19237'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19235'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19232'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19226'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19225'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19224'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19222'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19218'
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` = '19217'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19215'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19209'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19208'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19203'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19201'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19198'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19195'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19193'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19187'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19185'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19182'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19179'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19173'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19172'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19171'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19170'
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` = '19167'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19166'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19163'
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` = '19162'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19161'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19160'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19156'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19154'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19150'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19148'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19140'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19135'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19130'
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` = '19127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19125'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19121'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '457'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '460'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
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 Autumn Edition 2024 Ended Level: 19 Blinds: 4,000/8,000 Ante: 8,000
Rolandas Aglinskas Ends Extended Day 2 of €1,100 Main Event as Bubble Boy; 87 Progress Posted Saturday 26th October, 2024 at 00:51(UTC+0) by Frank Visser
It was a long day at Olympic Park Casino today. After 13 hours of play, the bubble in the Kings of Tallinn: Autumn Edition€1,100 Main Event had burst, securing the 87 surviving players a share of the €658,940 prize pool. But one man's gain is another man's loss, and this time it was Rolandas Aglinskas who was on the losing side. The Lithuanian player spent 13 hours playing his heart out only to end up in 88th place as the stone bubble after he was a big favorite preflop.
Immediately after Aglinskas' departure, the remaining 87 bagged up for Day 3. Serhii Leonov from Ukraine profited the most from the bubble, being the only player to bag a seven-figure stack. He grabbed the chip lead with 1,052,000, more than four times the average stacks, and a whopping 132 big blinds at the start of Day 3.
Leonov already had a respectable stack throughout the later part of the day, but he really started climbing the ranks when he picked off an overbet bluff by fellow top ten stack Angel Alonso on the soft bubble. He then spent the next 80 minutes exerting bubble pressure to end up with his massive pile of chips.
Meanwhile, Finnish regular Elias Suhonen was the only other player to end up with more than 100 big blinds as he ended the day with 896,000. Greek player Enea Subashi completes the top three with a stack of 712,000 while Luka Sorainen, Estonia's biggest stack Ranno Sootla, and Mitchell Hynam also secured a spot in the top ten.
End of Day 2 Top Ten Chip Counts
Rank
Player
Country
Chip Count
Big Blinds
1
Serhii Leonov
Ukraine
1,052,00
132
2
Elias Suhonen
Finland
896,000
112
3
Enea Subashi
Greece
712,000
89
4
Angel Alonso
Spain
665,000
83
5
Tommy Piiroinen
Finland
653,000
82
6
Luka Sorainen
Finland
573,000
72
7
Ranno Sootla
Estonia
562,000
70
8
Mitchell Hynam
United Kingdom
552,000
69
9
Vu Vuong
Finland
550,000
69
10
Dmitrijs Petrenko
Latvia
536,000
67
Among the other survivors are Max Sanders (310,000), Gytis Lazauninkas (246,000), Sebastian Wahl (238,000), Jari Mahonen (80,000), Roope Tarmi (79,000), Henri Ojala (53,000), and Tarmo Tammel (19,000).
Day 2 Action
Day 2 started with four levels of late registration still to go. After it had closed, the clock read 701 entries, of which 214 still remained. Quick goodbyes were said to €555 Championship runner-up Rasmus Lundstrom, Norwegian mixed game crusher Espen Sandvik, and Estonian poker mainstays Igor Pihela Sr. and Igor Pihela Jr.
Joshua Stewart, Juha Helppi, Aleksi Naski, and Markku Koplimaa also fell outside the top 100. The pace of play then slowed down significantly as the bubble kept creeping closer. Ermo Kosk was among the chipleaders with 105 left but was eliminated in 92nd about 90 minutes later. Gediminas Zimaitis fell in 90th and hand-for-hand play began shortly after, with two eliminations to go before the money.
It only took around 15 minutes to lose the first player when Ignas Navickas shoved his last chips into Subashi. However, the stone bubble lasted for no less than 45 minutes. In fact, Day 2 was supposed to end after Level 18 had been completed, but the tournament directors decided to play out the bubble, and Level 19 was reached.
Ultimately, it was in that level that Aglinskas became the bubble boy. His king-jack lost against the jack-seven of Samuli Segerman as a wave of relief and celebration went through the tournament room. The 87 remaining players had secured a min-cash of €2,200, but the big stacks will be more concerned with the massive €130,300reserved for the eventual champion.
€1,100 Main Event Payouts
Place
Prize
1
€130,300
2
€83,400
3
€55,200
4
€40,250
5
€30,450
6
€22,540
7
€17,400
8
€14,400
9
€11,800
10-11
€9,400
12-13
€7,200
14-15
€5,600
16-23
€4,300
24-31
€3,600
32-39
€3,200
40-55
€2,800
56-71
€2,500
72-87
€2,200
Day 3 will commence tomorrow, October 26, at noon local time. Play will resume in Level 19: 4,000/8,000 with an 8,000 big blind ante. There are 52 minutes and 58 seconds remaining in said level, after which each subsequent level will last for 60 minutes.
The exact plan for Day 3 is not yet known, so be sure to check back in tomorrow as an exciting post-bubble bust-out bonanza is awaiting the prestigious Main Event.
End of Day 2 Chip Counts Posted Friday 25th October, 2024 at 23:58(UTC+0) by Frank Visser
Player
Chips
Progress
Serhii Leonov
1,052,000
272,000
Elias Suhonen
896,000
296,000
Enea Subashi
712,000
47,000
Angel Alonso
665,000
25,000
Tommy Piiroinen
653,000
333,000
Luka Sorainen
573,000
32,000
Ranno Sootla
562,000
0
Mitchell Hynam
552,000
0
Vu Vuong
550,000
51,000
Dmitrijs Petrenko
536,000
271,000
Josep Pastor
497,000
375,500
Julius Kettunen
481,000
46,000
Kalle Parkkinen
481,000
22,000
Borge Dypvik
420,000
5,000
Krisjanis Lauks
416,000
1,000
Egidijus Digrys
412,000
78,000
Jae Han Kim
409,000
199,000
Jose Domene
404,000
59,000
David Bright
385,000
93,000
Aivaras Kerusauskas
383,000
33,000
Eero Abbey
379,000
44,000
Daniel Clifford
371,000
0
Kristiana Stauere
349,000
209,000
Simon Hassan
329,000
129,000
Kristaps Sipols
318,000
272,000
Kasper Mellanen
317,000
57,000
Max Sanders
310,000
110,000
Albert Ostrovskij
287,000
18,000
Vadim Guk
285,000
200,000
Bahadir Hatipoglu
280,000
152,500
Artur Kulanurk
276,000
46,000
Jawad Habib
268,000
156,000
Edas Cimbolas
265,000
80,000
Pekka Ikonen
257,000
150,200
Kaius Kiidli
256,000
24,000
Jarkko Suokas
252,000
22,000
Gytis Lazauninkas
246,000
166,000
Edward Quinn
245,000
0
Sebastian Wahl
238,000
80,000
Jenny Westerlund
210,000
35,000
Martynas Saltis
209,000
39,000
Dmitri Dudakov
193,000
92,000
Vasy Laba
190,000
23,000
Adrian Luezas
183,000
102,000
Aku-Oskari Uotila
160,000
140,000
Samuli Segerman
150,000
2,000
Andrius Janca
147,000
133,000
Roman Jezov
130,000
30,000
Gert Laanemets
125,000
125,000
Rolands Norietis
120,000
13,000
Aleksandr Januskevic
120,000
0
Ruslan Stserbjuk
114,000
0
Andrejs Perederejevs
109,000
71,000
Stanislovas Vinicenka
106,000
51,000
Kaspars Renga
105,000
20,000
Klaudijus Bajoras
105,000
95,000
Mantas Stikelis
105,000
145,000
Gintaras Naglius
88,000
53,700
Jussi Hietalahti
85,000
30,000
Mikael Haapaniemi
81,000
84,000
Jari Mahonen
80,000
0
Stanislav Smeljov
80,000
67,000
Mathias Siljander
79,000
1,000
Roope Tarmi
79,000
101,000
Kim Rasmussen
77,000
22,000
Taago Tamm
77,000
38,000
Joonas Helin
74,000
116,000
Mark Metsla
68,000
3,000
Koray Korkmaz
67,000
8,000
Robert Kallikorm
66,000
134,000
Roberts Rumba
63,000
12,000
Miki Vea
62,000
0
Gonzalo Salinas
60,000
0
Mindaugas Kriaciunas
59,000
47,000
Johan Alen
56,000
0
Henri Ojala
53,000
172,000
Irmantas Rulis
50,000
0
Andzej Bilat
45,000
0
Bartosz Mielczarek
36,000
329,000
Edikas Jurgutis
34,000
56,000
Frederik Brink
32,000
37,000
Aleksei Gontsar
21,000
69,000
Tarmo Tammel
19,000
41,000
Oskar Silins
19,000
117,000
Hai Hoang
12,000
68,000
Day 2 Concludes Posted Friday 25th October, 2024 at 23:09(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 87/701
After an extended Day 2, the bubble of the Main Even has burst and the 87 remaining players have bagged their chips up.
Stay tuned for full chip counts and a recap of the day.
Rolandas Aglinskas Eliminated as Bubble Boy Posted Friday 25th October, 2024 at 23:04(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 88/701
Rolandas Aglinskas put his last 26,000 in from early position. The table then folded to Samuli Segerman in the big blind, who called.
Rolandas Aglinskas: Samuli Segerman:
Aglinskas was in the best position he could be, dominating his opponent. The flop brought him no trouble, but the room fell dead silent as the turn gave Segerman a flush draw.
Aglinskas slammed his chair as the river arrived. Segerman had made a flush and the room exploded in cheers and applause. Aglinskas was the last to leave the room empty-handed as 87 players bagged up for Day 3.
Player
Chips
Progress
Samuli Segerman
152,000
22,000
Rolandas Aglinskas
0
0
Dypvik Shoves on Siljander Posted Friday 25th October, 2024 at 22:51(UTC+0) by Frank Visser
Level 19: 4,000/8,000 (8,000) Entries: 88/701
Borge Dypvik in the hijack and Mathias Siljander in the cutoff had created a pot of 90,000 when they both checked through the flop.
The emerged from the deck on the turn and saw Dypvik put Siljander all-in for 80,000. Siljander made a quick fold as the bubble continued.
Player
Chips
Progress
Borge Dypvik
425,000
85,000
Mathias Siljander
80,000
50,000
22:50 (UTC+0)
Start of Level 19 Blinds: 4,000/8,000 Ante: 8,000
Bubble Trouble? No, Bubble Triple! Posted Friday 25th October, 2024 at 22:38(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 88/701
Roberts Rumba had pushed his final chips in on a flop of . Aivaras Kerusauskas called in middle position and Julius Kettunen did so in the small blind, creating a pot of 75,000
The pair then checked through the turn and river for the side pot, and a showdown was had. Kerusauskas tabled for a pair of sixes while Kettunen showed for a pair of nines.
Rumba had the best hand with , however, and he let out a maniacal laugh while tripling up with his flush.
Player
Chips
Progress
Julius Kettunen
435,000
130,000
Aivaras Kerusauskas
350,000
200,500
Roberts Rumba
75,000
11,000
Kiidli Gets Some Value Posted Friday 25th October, 2024 at 22:30(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 88/701
Samuli Segerman checked from the big blind to Kaius Kiidli in the hijack on a turn of . He then bet 16,000 and Segerman put in a call.
The river was checked down. Segerman tabled for bottom pair and lost some chips to the of Kiidli, who won the pot with top pair.
Player
Chips
Progress
Kaius Kiidli
280,000
10,000
Samuli Segerman
130,000
20,000
Nada for Navickas Posted Friday 25th October, 2024 at 22:15(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 89/701
Ignas Navickas had shoved all in for 25,000 in the hijack. Enea Subashi called in the cutoff and the cards went open once all other tables had finished.
Ignas Navickas: Enea Subashi:
Navickas was slightly ahead and gained a bigger lead once the flop missed Subashi. The turn paired the Greek up, however, and the river could not save Navickas from being eliminated.
The field was left with 88 players, which means it had arrived on the stone bubble.
Player
Chips
Progress
Enea Subashi
665,000
150,000
Ignas Navickas
0
0
First All-In and Call Sees Brink Bink Posted Friday 25th October, 2024 at 22:08(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 89/701
Frederik Brink open-jammed his last 27,000 under the gun. It folded to Kim Rasmussen in the big blind, who called off.
Frederik Brink: Kim Rasmussen:
Brink needed to fade a nine to stay in contention for a cash, and he did so when the board brought him no trouble.
Player
Chips
Progress
Frederik Brink
69,000
70,600
Kim Rasmussen
55,000
103,800
Sorainen Puts Max-Imum Bubble Pressure Posted Friday 25th October, 2024 at 21:58(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 89/701
Small blind Max Sanders checked on a completed board of . Big blind Luka Sorainen then put Sanders all-in for 200,000, a bet worth twice the pot.
Sanders spent some minutes as he agonizingly went over the hand but he ultimately decided to fold and the next hand was dealt.
Player
Chips
Progress
Luka Sorainen
605,000
80,000
Max Sanders
200,000
25,000
Tamm Doubles as Hand-for-Hand Begins Posted Friday 25th October, 2024 at 21:52(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 89/701
Taago Tamm open-shoved his button for 53,000. Ignas Navickas slowly peeled his cards in the big blind, thought for some time, and then called.
Taago Tamm: Ignas Navickas:
It was looking like Tamm would be eliminated as the penultimate player without cash, especially when the flop brought no help.
However, he made a runner-runner flush on the runout, doubling up and leaving Navickas with less than five big blinds.
After the hand, the floor announced that the tournament would go hand-for-hand with 89 players remaining. The day will not finish before the money is reached, even if that means an extra level is needed.
Player
Chips
Progress
Taago Tamm
115,000
65,000
Ignas Navickas
23,000
82,000
Zimaitis Falls to Leonov's Surge Posted Friday 25th October, 2024 at 21:43(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 90/701
Gediminas Zimaitis got his final 37,000 in from the big blind against Serhii Leonov in the hijack.
Gediminas Zimaitis: Serhii Leonov:
Leonov was the only player to pair his hole cards on the board and eliminated Zimaitis three spots from the money.
Player
Chips
Progress
Serhii Leonov
780,000
30,000
Gediminas Zimaitis
0
0
Leonov and Alonso Play for Piles Posted Friday 25th October, 2024 at 21:39(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 90/701
Serhii Leonov (pictured) in the big blind and Angel Alonso under the gun had already inflated the pot to 100,000 by the time the turn was dealt. Leonov then checked and Alonso put in an overbet of 150,000.
Undeterred, Leonov called to the river, which went check-check. Leonov showed for second pair and took down the pot when Alonso's cards hit the muck.
Player
Chips
Progress
Serhii Leonov
750,000
250,000
Angel Alonso
690,000
188,000
Ostrovskij Hero Calls Westerlund at Crucial Stage Posted Friday 25th October, 2024 at 21:29(UTC+0) by Frank Visser
Level 18: 3,000/6,000 (6,000) Entries: 91/701
Arriving on a completed board of , Albert Ostrovskij checked form the small blind to Jenny Westerlund in the hijack.
Westerlund fired 50,000 into the pot of 80,000, sending Ostrovskij into the tank. After five minutes or so, he slammed in a call.
"Good call," Westerlund said as she sheepishly showed . Ostrovskij tabled for third pair and raked in the important pot.
Player
Chips
Progress
Albert Ostrovskij
305,000
253,000
Jenny Westerlund
175,000
212,000
21:16 (UTC+0)
Start of Level 18 Blinds: 3,000/6,000 Ante: 6,000
Getting Tantalizingly Close to the Money Posted Friday 25th October, 2024 at 21:14(UTC+0) by Frank Visser
Level 17: 2,000/5,000 (5,000) Entries: 91/701
Player
Chips
Progress
Ermo Kosk
0
0
Vasilijus Piskunovas
0
0
Danel Kunman
0
0
Nobody Expects the Spanish Inquisition, Not Even the Spanish Posted Friday 25th October, 2024 at 21:10(UTC+0) by Frank Visser
Level 17: 2,000/5,000 (5,000) Entries: 93/701
Adria Comas jammed all in for 53,000 in early position. The action folded to his fellow countryman Jose Domene, who called off after some thinking time.
Adria Comas: Jose Larios:
Comas could not pair up on the board, sending him out six away from the money.
Player
Chips
Progress
Jose Domene
345,000
55,000
Adria Comas
0
0
Tamm Left Short on Soft Bubble as Wahl Doubles Posted Friday 25th October, 2024 at 21:02(UTC+0) by Frank Visser
Level 17: 2,000/5,000 (5,000) Entries: 93/701
Sebastian Wahl got his 74,000 in preflop from the hijack against Taago Tamm (pictured) in the small blind.
Sebastian Wahl: Taago Tamm:
Wahl faded the ace on the runout, doubling him up. Tamm, meanwhile, was left with exactly ten big blinds.
Player
Chips
Progress
Sebastian Wahl
158,000
31,000
Taago Tamm
50,000
50,000
Asking Nicely Not Enough for Ajamaa Posted Friday 25th October, 2024 at 20:54(UTC+0) by Frank Visser
Level 17: 2,000/5,000 (5,000) Entries: 95/701
Krisjanis Lauks raised to 10,000 in the hijack. Kaur Ajamaa then committed his stack of 40,000 from the cutoff and Lauks called after some thinking time.
Kaur Ajamaa: Krisjanis Lauks:
Ajamaa was a big favorite to double up, but the flop left him shaking his head. The offered him no improvement.
"Ace, please," he asked calmly before the river completed the board. No ace fell, and Ajamaa was eliminated just a few spots from the money.
Player
Chips
Progress
Krisjanis Lauks
415,000
85,000
Kaur Ajaama
0
0
Departures Since Break Posted Friday 25th October, 2024 at 20:47(UTC+0) by Frank Visser
Player
Chips
Progress
Mykhailo Mikhalov
0
0
Karolis Kutkauskas
0
0
Rasins Picks Wrong Time to Hero Posted Friday 25th October, 2024 at 20:45(UTC+0) by Frank Visser
Level 17: 2,000/5,000 (5,000) Entries: 99/701
Andris Rasins checked in early position on a completed board of . With a modest pot of 65,000 in the middle, Luka Sorainen over-bet all in.
Rasins snap-called for his stack of 80,000 and showed . However, Sorainen tabled for a set of eights and knocked Rasins out a dozen spots from the money.
Player
Chips
Progress
Luka Sorainen
525,000
35,000
Andris Rasins
0
0
Kettunen Takes It on Turn Posted Friday 25th October, 2024 at 20:32(UTC+0) by Frank Visser
Level 17: 2,000/5,000 (5,000) Entries: 101/701
Rolands Norietis raised to 12,000 in middle position. Julius Kettunen three-bet to 45,000 in the small blind and Norietis called.
Kettunen continued for 30,000 on the board, which Norietis called. The fell on the turn and saw Kettunen size up to 55,000.
Norietis had seen enough and quickly let go of his hand as he forfeited the pot.
Player
Chips
Progress
Julius Kettunen
305,000
160,000
Jose Domene
290,000
247,000
Klaudijus Bajoras
200,000
157,700
Rolands Norietis
107,000
98,000
Aleksei Gontsar
90,000
27,500
Edikas Jurgutis
90,000
195,000
Koray Korkmaz
75,000
41,000
Adria Comas
60,000
32,600
20:16 (UTC+0)
Start of Level 17 Blinds: 2,000/5,000 Ante: 5,000
Late-Night Leaders Posted Friday 25th October, 2024 at 20:10(UTC+0) by Frank Visser
Player
Chips
Progress
Vu Vuong
601,000
181,000
Elias Suhonen
600,000
328,000
Kristaps Sipols
590,000
90,000
Enea Subashi
515,000
105,000
Angel Alonso
502,000
28,000
Serhii Leonov
500,000
290,000
Egidijus Digrys
490,000
150,000
Kalle Parkkinen
459,000
324,000
Final Break of Day 2 Posted Friday 25th October, 2024 at 19:57(UTC+0) by Frank Visser
The 103 remaining players have been sent on their last 20-minute break of the night.
When they return, two more 60-minute levels will be played before the survivors bag up for Day 3.
Pre-Break Bust-Outs Posted Friday 25th October, 2024 at 19:55(UTC+0) by Frank Visser
Player
Chips
Progress
Zahid Bhuiyan
0
0
Kris Tikka
0
0
Kosk Wins Massive Three-Way Three-Bet Pot Posted Friday 25th October, 2024 at 19:44(UTC+0) by Frank Visser
Level 16: 2,000/4,000 (4,000) Entries: 105/701
Serhii Leonov had open-raised from early position and Ermo Kosk had called in the hijack. Aku-Oskari Uotila then put in a three-bet from the big blind, which both Leonov and Kosk called.
Once the flop graced the table, the pot had already grown to 90,000. Uotila continued for 18,000 and saw two calls once again. He then sized up to 40,000 on the turn, but again neither opponent got out of the way.
The river completed a flush draw, and it checked to Kosk, who bet 100,000. Uotila quickly mucked while Leonov took about 30 seconds to put his opponent on exactly jack-ten of spades. He consequently folded, showing the as he did so.
Player
Chips
Progress
Angel Alonso
530,000
165,000
Ermo Kosk
474,000
329,000
Aku-Oskari Uotila
300,000
15,000
Serhii Leonov
210,000
35,000
Joonas Helin
190,000
40,000
Roope Tarmi
180,000
105,000
Stanislav Smeljov
147,000
0
Gediminas Zimaitis
77,000
133,000
Tarmo Tammel
60,000
53,000
Berggren Starts Trek Home Posted Friday 25th October, 2024 at 19:29(UTC+0) by Frank Visser
Level 16: 2,000/4,000 (4,000) Entries: 110/701
In a three-bet pot worth around 50,000, David Berggren checked from middle position to preflop aggressor Adrian Luezas in the cutoff.
The flop read , and Luezas made a bet of 19,000. Berggren then quickly raised all in for 75,000 and was snapped off.
David Berggren: Adrian Luezas:
Berggren was pipped. The turn provided some hope with a flush draw, but the river changed nothing. Berggren saw his chips being added to Luezas' stack and headed to the exit.
Player
Chips
Progress
Adrian Luezas
285,000
125,000
David Berggren
0
0
Rumba Hoovers Up Double-Up Posted Friday 25th October, 2024 at 19:16(UTC+0) by Frank Visser
Level 16: 2,000/4,000 (4,000) Entries: 113/701
Roberts Rumba open-jammed his 27,000 chips and was called by his neighbor Sauli Haapaniemi.
Roberts Rumba: Sauli Haapaniemi:
"Good luck, but to be honest, I hope you don't win," Haapaniemi said.
However, Rumba would win when the flop paired him up and the runout bricked out, doubling him up
Player
Chips
Progress
Sauli Haapaniemi
130,000
8,000
Roberts Rumba
64,000
51,000
Further Bust-Outs Posted Friday 25th October, 2024 at 19:09(UTC+0) by Frank Visser
Player
Chips
Progress
Jarmo Salonen
0
0
Aleksi Naski
0
0
Jonatan Fors
0
0
Justina Andriukeviciute
0
0
Ismo Barlund
0
0
Michael Engstrom
0
0
Risto Parnat
0
0
Rytis Pranarauskas
0
0
Daniel Smith
0
0
Iodis Falls into Lauks' Trap Posted Friday 25th October, 2024 at 19:03(UTC+0) by Frank Visser
Level 16: 2,000/4,000 (4,000) Entries: 123/701
Max Sanders had raised in early position and Krijanis Lauks (pictured) called in the small blind. Kanstantsin Iodis then jammed all in for 29,000. Sanders called but Lauks had other plans and back-raised to 89,000.
Sanders was baffled and thought for a while before mucking his hand.
Kanstantsin Iodis: Krijanis Lauks:
"Wow, you did trap me!" Sanders exclaimed surprised. Meanwhile, the runout could not crack Lauks' kings and Iodis hit the rail.
Player
Chips
Progress
Krisjanis Lauks
330,000
40,000
Max Sanders
225,000
25,000
Kanstantsin Iodis
0
0
18:58 (UTC+0)
Start of Level 16 Blinds: 2,000/4,000 Ante: 4,000
Start-of-Day Leader Koistinen Bluffs Final Chips Off Posted Friday 25th October, 2024 at 18:58(UTC+0) by Frank Visser
Level 15: 1,500/3,000 (3,000) Entries: 125/701
Big blind Mikael Koistinen was checked to on a turn of by Dmitrijs Petrenko. He decided to bet 18,000 into the 33,000 pot, which Petrenko called.
The river brought the . Petrenko checked again, after which Koistinen jammed all in for 37,000. Petrenko mulled it over for 30 seconds or so but ultimately made the call.
Koistinen stood up and showed for king-high. Petrenko showed for top pair and knocked the start-of-day chipleader out before the money.
Player
Chips
Progress
Dmitrijs Petrenko
265,000
60,000
Mikael Koistinen
0
0
Saviaho Surrenders Final Chips Posted Friday 25th October, 2024 at 18:42(UTC+0) by Frank Visser
Level 15: 1,500/3,000 (3,000) Entries: 131/701
Jari Saviaho jammed his last 25,000 on the button and was looked up by Jussi Hietalahti in the big blind.
Jari Saviaho: Jussi Hietalahti:
The runout did not bring a king, sendeing Saviaho to the rail.
Player
Chips
Progress
Jussi Hietalahti
115,000
94,800
Jari Saviaho
0
0
Juha Helppi Among Recent Eliminations Posted Friday 25th October, 2024 at 18:36(UTC+0) by Frank Visser
Player
Chips
Progress
Elias Vaaraniemi
0
0
Juha Helppi
0
0
Martin Keskkula
0
0
Sergei Kuznetsov
0
0
Erik Byhlin
0
0
Joonas Lyttinen
0
0
Jamie Dwan
0
0
Petrenko and Haapaniemi Play Friendly Three-Bet Pot Posted Friday 25th October, 2024 at 18:32(UTC+0) by Frank Visser
Level 15: 1,500/3,000 (3,000) Entries: 137/701
Dimitijs Petrenko in early position checked to three-better Mikael Haapaniemi (pictured) in the cutoff. He bet a measly 5,000 into a pot of 45,000 with a flop of on the table.
Petrenko called before the turn and river were checked through. Haapaniemi showed for top pair, but Petrenko had the better kicker and won the pot with .
Player
Chips
Progress
Dmitrijs Petrenko
205,000
175,000
Mikael Haapaniemi
165,000
42,300
Kerusauskas Holds to Double Posted Friday 25th October, 2024 at 18:25(UTC+0) by Frank Visser
Level 15: 1,500/3,000 (3,000) Entries: 140/701
Aivaras Kerusauskas in the hijack had three-bet Sauli Haapaniemi in early position preflop. Haapaniemi had called and checked the flop to Kerusauskas.
Kerusauskas then added 15,000 to the pot of 41,500, after which Haapaniemi quickly moved all in. Kerusauskas sighed but made a quick call for his stack of 54,000 regardless.
Aivaras Kerusauskas: Sauli Haapaniemi:
Kerusauskas had the superior pair, and while the turn brought Haapaniemi a gutshot, the river gave him a set to double up.
Player
Chips
Progress
Aivaras Kerusauskas
149,500
49,500
Sauli Haapaniemi
122,000
68,000
Tarmi's Chips Get Flushed to Uotila Posted Friday 25th October, 2024 at 18:11(UTC+0) by Frank Visser
Level 15: 1,500/3,000 (3,000) Entries: 146/701
The action was picked up on a completed board of . Aku-Oskari Uotila (pictured) checked from the big blind to Roope Tarmi under the gun. Tarmi bet 35,000 into a pot of 30,000, which Uotila raised to 95,000.
Tarmi spent some time in the tank but ultimately called off. Uotila tabled for a flush and Tarmi's cards flew into the muck in defeat.
Player
Chips
Progress
Aku-Oskari Uotila
315,000
209,200
Roope Tarmi
75,000
1,000
17:56 (UTC+0)
Start of Level 15 Blinds: 1,500/3,000 Ante: 3,000
Assorted Dinner Counts Posted Friday 25th October, 2024 at 17:56(UTC+0) by Frank Visser
Player
Chips
Progress
Kristaps Sipols
500,000
437,000
Luka Sorainen
490,000
10,000
Vu Vuong
420,000
240,000
Enea Subashi
410,000
160,000
Jenny Westerlund
387,000
290,000
Bartosz Mielczarek
365,000
329,700
Angel Alonso
365,000
85,000
Borge Dypvik
340,000
200,000
Eero Abbey
335,000
70,000
Tommy Piiroinen
320,000
219,000
Kaius Kiidli
290,000
141,900
Krisjanis Lauks
290,000
15,000
Dmitri Dudakov
285,000
75,000
Edikas Jurgutis
285,000
61,000
Andrius Janca
280,000
230,000
Rytis Strigunas
275,000
86,300
Elias Suhonen
272,000
175,300
Kasper Mellanen
260,000
168,000
Gert Laanemets
250,000
0
Mantas Stikelis
250,000
20,000
Jarkko Suokas
230,000
200,000
Ismo Barlund
225,000
185,500
Henri Ojala
225,000
150,000
Jae Han Kim
210,000
180,000
Simon Hassan
200,000
152,600
Robert Kallikorm
200,000
90,200
Sauli Haapaniemi
190,000
136,500
Vasilijus Piskunovas
190,000
15,000
Edas Cimbolas
185,000
64,900
David Berggren
180,000
83,300
Martynas Saltis
170,000
12,500
Adrian Luezas
160,000
27,000
Aleksi Naski
160,000
20,000
Stanislav Smeljov
147,000
43,700
Julius Kettunen
145,000
115,000
Ermo Kosk
145,000
107,200
Daniel Smith
140,000
110,000
Martin Keskkula
135,000
25,200
Kalle Parkkinen
135,000
20,500
Zahid Bhuiyan
130,000
100,000
Sebastian Wahl
127,000
89,000
Kaspars Renga
125,000
85,000
Roberts Rumba
115,000
85,000
Ignas Navickas
105,000
50,000
Risto Parnat
105,000
12,300
Taago Tamm
100,000
70,000
Roman Jezov
100,000
64,400
Aivaras Kerusauskas
100,000
63,900
Vadim Guk
85,000
1,200
Hai Hoang
80,000
2,500
Michael Engstrom
65,000
35,000
Gonzalo Salinas
60,000
1,600
Stanislovas Vinicenka
55,000
25,000
Andrej Koriakin
55,000
49,200
Joonas Lyttinen
53,000
66,000
Mathias Siljander
30,000
12,800
Dinner Bell Rings Posted Friday 25th October, 2024 at 16:58(UTC+0) by Frank Visser
Level 14: 1,000/2,500 (2,500) Entries: 149/701
The remaining players have been sent on a 60-minute dinner break.
The tournament is expected to resume at 7:55 p.m. local time.
Alonso Jams River in Four-Bet Pot Posted Friday 25th October, 2024 at 16:57(UTC+0) by Frank Visser
Level 14: 1,000/2,500 (2,500) Entries: 151/701
Serhii Leonov had open-raised from the cutoff when Angel Alonso three-bet to 14,000 on the button. Leonov then made it 35,000 to go, which Alonso called.
Leonov fired 27,000 on the flop, receiving a call from Alonso. The turn was checked through before Leonov made a bet of 45,000 on the river.
Alonso pondered momentarily and then shoved all in for 150,000. Leonov took one last look at his cards before sending them to the muck, giving up on the pot.
Player
Chips
Progress
Angel Alonso
280,000
167,800
Serhii Leonov
175,000
75,000
Recent Eliminations Posted Friday 25th October, 2024 at 16:45(UTC+0) by Frank Visser
Player
Chips
Progress
Igor Pihela Sr.
0
0
Andre Magi
0
0
Joona Tuomi
0
0
Justas Vaiciulionis
0
0
Vismands Menjoks
0
0
Nils Linden
0
0
Juho Harkonen
0
0
Lauks Knocks Out Two Posted Friday 25th October, 2024 at 16:36(UTC+0) by Frank Visser
Level 14: 1,000/2,500 (2,500) Entries: 159/701
Audrius Navickas had raised preflop, after which Marius Morel jammed for about 25,000. Krisjanis Lauks (pictured) called cold, after which Navickas four-bet all in for 115,000.
Lauks snap-called with the covering stack, tabling all three holdings.
Marius Morel: Audrius Navickas: Krisjanis Lauks:
The runout gave all players a full house, but Lauks' aces remained best as he eliminated both opponents.
"Man, I wish I got aces against kings," monster stack Luka Sorainen jokingly quipped.
Player
Chips
Progress
Luka Sorainen
500,000
157,000
Krisjanis Lauks
275,000
245,000
Audrius Navickas
0
0
Marius Morel
0
0
Numbers Confirmed; Payout Information Posted Friday 25th October, 2024 at 16:19(UTC+0) by Frank Visser
Level 14: 1,000/2,500 (2,500) Entries: 164/701
The 701 entries have created a prize pool of €658,940. 87 players will see a payday of at least €2,200, while the eventual champion walks away with €130,300.
Place
Prize
1
€130,300
2
€83,400
3
€55,200
4
€40,250
5
€30,450
6
€22,540
7
€17,400
8
€14,400
9
€11,800
10-11
€9,400
12-13
€7,200
14-15
€5,600
16-23
€4,300
24-31
€3,600
32-39
€3,200
40-55
€2,800
56-71
€2,500
72-87
€2,200
Parkkinen Flips to Double-Up Posted Friday 25th October, 2024 at 16:10(UTC+0) by Frank Visser
Level 14: 1,000/2,500 (2,500) Entries: 170/701
Jamie Dwan raised to 5,000 under the gun. Vasilijus Piskunovas then three-bet to 14,000 in the seat next over before the action folded to Kalle Parkkinen in the big blind.
He counted his 53,000 chips before committing them to the middle. Dwan quickly got out of the way before Piskunovas snap-called.
Kalle Parkkinen: Vasilijus Piskunovas:
Piskunovas remained ahead on the flopn but the turn gave Parkkinen a pair. The river did not bring a queen, doubling up Parkkinen.
Player
Chips
Progress
Vasilijus Piskunovas
175,000
25,000
Kalle Parkkinen
114,500
84,500
Jamie Dwan
70,000
60,000
15:56 (UTC+0)
Start of Level 14 Blinds: 1,000/2,500 Ante: 2,500
Saltis Seeks Double Posted Friday 25th October, 2024 at 15:55(UTC+0) by Frank Visser
Level 13: 1,000/2,000 (2,000) Entries: 181/701
Martynas Saltis had raised to 4,500 under the gun when Aleksi Naski called in the cutoff. Ignas Navickas then three-bet to 20,000 on the button.
With the action back on him, Saltis jammed all in for 74,000. Naski quickly got out of the way while Navickas stuck in a quick call.
Martynas Saltis: Ignas Navickas:
Navickas needed a jack to knock out Saltis, but none came on the board and he doubled him up instead.
Player
Chips
Progress
Aleksi Naski
180,000
30,000
Martynas Saltis
157,500
127,500
Ignas Navickas
55,000
36,900
Assorted Eliminations Posted Friday 25th October, 2024 at 15:44(UTC+0) by Frank Visser
Player
Chips
Progress
Fritz Nygren
0
0
Ari Soini
0
0
Gianluca Trebbi
0
0
Johan Martinsen
0
0
Mario Munoz
0
0
Artjom Petskurov
0
0
Viktors Kurovs
0
0
Sven Omland
0
0
Victor Prior
0
0
Raimo Reimann
0
0
Jari-Pekka Juhola
0
0
Ville-Tappio Mesiranta
0
0
Rasmus Lundstrom
0
0
Michel Karim
0
0
Tommi Hakala
0
0
Kerem Hanno
0
0
Jauring Runs Into Aces Posted Friday 25th October, 2024 at 15:34(UTC+0) by Frank Visser
Level 13: 1,000/2,000 (2,000) Entries: 187/701
Joonas Helin had raised to 4,000 and Justas Vaiciulionis had called. Gediminas Zimaitis then three-bet to 15,000, which Rolf Jauring four-bet to 34,500.
The action folded back to Zimaitis, who put Jauring all-in for 65,000 in total. Jauring snap-called and the cards went on their backs.
Rolf Jauring: Gediminas Zimaitis:
With one king reportedly folded by another player, Zimaitis flopped Jauring dead on . The runout was of little importance as Jauring knuckled the table and took his leave.
Player
Chips
Progress
Joonas Helin
230,000
200,000
Gediminas Zimaitis
210,000
177,300
Justas Vaiciulionis
55,000
25,000
Rolf Jauring
0
0
Vihervuori Experiences Death by Quads from Tarmi Posted Friday 25th October, 2024 at 15:16(UTC+0) by Frank Visser
Level 13: 1,000/2,000 (2,000) Entries: 200/701
Miska Vihervuori open-jammed for 38,000 in early position. It folded to Roope Tarmi in the big blind, who called off for 36,500.
Roope Tarmi: Miska Vihervuori:
Tarmi took a massive lead on the flop and left his opponent drawing dead on the turn. The river gave him quads as the cherry on top. He doubled up and left Vihervuori with 1,500, which he would lose not much later.
Player
Chips
Progress
Roope Tarmi
76,000
43,900
Miska Vihervuori
0
0
Andriukevicute Doubles Fresh Stack Posted Friday 25th October, 2024 at 15:08(UTC+0) by Frank Visser
Level 13: 1,000/2,000 (2,000) Entries: 211/701
Justina Andriukevicute was one of the last entries, and she raised to 4,000 under the gun. Albert Ostrovskij defended his big blind, after which a flop of was spread.
Andriukevicute made a bet, which Ostrovskij check-raised to 8,000. Andriukevicute then three-bet all in for 26,000. Ostrovskij spent a few minutes playing with his chips and exhaling air before finally tossing in a call.
Justina Andriukeviciute: Albert Ostrovskij:
Both players had an open-ender, but only Andriukeviciute's came in on the runout to double her up.
Player
Chips
Progress
Justina Andriukeviciute
63,000
33,000
Albert Ostrovskij
52,000
22,000
14:56 (UTC+0)
Start of Level 13 Blinds: 1,000/2,000 Ante: 2,000
Big Stacks on Break Posted Friday 25th October, 2024 at 14:48(UTC+0) by Frank Visser
Player
Chips
Progress
Karolis Kutkauskas
345,000
228,300
Luka Sorainen
343,000
93,000
Egidijus Digrys
340,000
167,100
Mantas Stikelis
270,000
30,000
Eero Abbey
265,000
60,000
Enea Subashi
250,000
130,000
Last Three Re-Entry Hands, Break After Posted Friday 25th October, 2024 at 14:25(UTC+0) by Frank Visser
Level 12: 1,000/1,500 (1,500) Entries: 207/687
The last three hands for re-entry are being dealt, after which the players will be sent on a 20-minute break.
After the break, late registraion will be closed and the numbers will be finalized.
Vuong Makes Adventurous Call to Chip Up Further Posted Friday 25th October, 2024 at 14:22(UTC+0) by Frank Visser
Level 12: 1,000/1,500 (1,500) Entries: 200/676
Sten Talviste tossed in his last 30,000 chips from the big blind and was looked up by Vo Vuang (pictured) on the button.
Sten Talviste: Vo Vuang:
The flop made Talviste top pair, and the turn helped neither player. The made Vuang a flush, however, knocking out Talviste just before the break.
Player
Chips
Progress
Vu Vuong
180,000
109,200
Sten Talviste
0
0
Perederejevs Rebuilds by Knocking Out Kilkanen Posted Friday 25th October, 2024 at 14:13(UTC+0) by Frank Visser
Level 12: 1,000/1,500 (1,500) Entries: 199/674
Fritz Nygren made a raise to 3,000 in early position. Andrejs Perederejevs made it 8,500 to go in the cutoff, after which Tero Kilkanen called all-in for less.
Nygren also tossed in a call, after which he check-called 5,000 on the flop. Perederejevs sized up to 16,000 on the turn, which forced a check-fold from Nygren.
Tero Kilkanen: Andrejs Perederejevs:
Kilkanen was still live, but the river did not improve his hand, meaning the end of this bullet.
Player
Chips
Progress
Andrejs Perederejevs
180,000
40,000
Fritz Nygren
165,000
15,000
Tero Kilkanen
0
0
Renga Makes Munoz Bluff Posted Friday 25th October, 2024 at 14:03(UTC+0) by Frank Visser
Level 12: 1,000/1,500 (1,500) Entries: 203/671
Kaspars Renga raised to 3,000 under the gun before Mario Munoz (pictured) made it 9,000 to go in the hijack. It folded back to Renga, who called to the flop.
There, he check-called the 7,000 bet of Munoz before the turn went check-check. Renga also checked the river, prompting Munoz to bet 18,500.
Renga instantly called. Munoz sheepishly tabled for jack-high while Renga had the winning wheel with .
Player
Chips
Progress
Kaspars Renga
210,000
77,300
Mario Munoz
60,000
43,000
Dobre Departs Posted Friday 25th October, 2024 at 13:49(UTC+0) by Frank Visser
Level 12: 1,000/1,500 (1,500) Entries: 201/661
Marcel Dobre got his last 23,700 in against Borge Dypvik.
Marcel Dobre: Borge Dypvik:
The runout did not contain a seven, sending Dobre out.
Player
Chips
Progress
Borge Dypvik
140,000
12,000
Marcel Dobre
0
0
Lazauninkas Loses to Linden Posted Friday 25th October, 2024 at 13:37(UTC+0) by Frank Visser
Level 12: 1,000/1,500 (1,500) Entries: 203/656
Erik Linden had pushed his stack of 23,700 in against Gytis Lazauninkas, who covered him.
Erik Linden: Gytis Lazauninkas:
Linden had his ticket ready to hand to the dealer, but the board made him a pair of aces to win the pot and double up.
Player
Chips
Progress
Gytis Lazauninkas
80,000
20,000
Erik Linden
64,400
34,400
13:25 (UTC+0)
Start of Level 12 Blinds: 1,000/1,500 Ante: 1,500
Right Read, Wrong Call Posted Friday 25th October, 2024 at 13:25(UTC+0) by Frank Visser
Level 11: 600/1,200 (1,200) Entries: 211/654
47,000 chips were in the middle when big blind Edikas Jurgutis (pictured) bet 38,500 on a completed board of .
His opponent was Jawad Habib in middle position, who spent a few minutes in the tank. "Do you have a set?" Habib asked moments before slamming in a call.
Jurgutis indeed tabled for bottom set. Habib nodded his head and mucked his cards as the massive pot headed to Jurgutis.
Player
Chips
Progress
Edikas Jurgutis
224,000
124,000
Mindaugas Kriaciunas
138,000
32,000
Elias Vaaraniemi
114,000
2,000
Jawad Habib
112,000
44,400
Juho Harkonen
65,000
5,700
Jarmo Salonen
33,200
10,200
Albert Ostrovskij
30,000
0
Martynas Saltis
26,000
4,000
Tool Bluffs Big Slick, Lundstrom Calls Posted Friday 25th October, 2024 at 13:15(UTC+0) by Frank Visser
Level 11: 600/1,200 (1,200) Entries: 214/651
The completed board read when Steven Tool made an all-in bet into a pot of 70,000 from the big blind.
His opponent was Rasmus Lundstrom (pictured), who was at risk for 20,200 and made the call.
"Good call," Tool said as he turned over for top pair. Lundstrom had called with two pair, , and doubled up in the big pot.
Player
Chips
Progress
Rasmus Lundstrom
110,400
32,600
Steven Tool
35,000
26,900
Byhlin Building a Stack Posted Friday 25th October, 2024 at 13:03(UTC+0) by Frank Visser
Level 11: 600/1,200 (1,200) Entries: 217/649
Bjorge Dypvik was first to act and raised to 2,500. It folded to Erik Byhlin in the small blind, who three-bet to 11,000. Dypvik complied with a call and saw a flop of .
Byhlin fired 12,000 and received a quick call from Dypvik. He then sized up to 30,000 on the turn, which was enough to let Dypvik fold his hand.
Player
Chips
Progress
Erik Byhlin
166,000
136,000
Borge Dypvik
128,000
22,000
Hatipoglu Cracks Pihela Sr.'s Kings Posted Friday 25th October, 2024 at 12:49(UTC+0) by Frank Visser
Level 11: 600/1,200 (1,200) Entries: 219/645
Bahadir Hatipoglu had gone all in for 62,900 before the flop and was looked up by Igor Pihela Sr. (pictured).
Bahadir Hatipoglu: Igor Pihela Sr.:
Hatipoglu stood up after the flop, but "Barry" came looking on the river. Hatipoglu cheered loudly and sat back down with double the number of chips.
Player
Chips
Progress
Bahadir Hatipoglu
127,500
97,500
Igor Pihela Sr.
85,000
15,000
Linden Back to Start After Paying Laba's Overbet Posted Friday 25th October, 2024 at 12:44(UTC+0) by Frank Visser
Level 11: 600/1,200 (1,200) Entries: 221/643
There were 34,000 chips in the pot when the board was completed. Vasyl Laba (pictured) sat in middle position and pondered for a bit before making a bet of 50,000.
His opponent was Nils Linden in the hijack, who quickly called. Laba turned over for a set of eights, causing Linden to add his cards to the muck.
Player
Chips
Progress
Vasy Laba
167,000
77,100
Nils Linden
30,000
0
Naglius Returns With Double-Up Posted Friday 25th October, 2024 at 12:32(UTC+0) by Frank Visser
Level 11: 600/1,200 (1,200) Entries: 231/643
Gintaras Naglius tossed in 15,000 from the big blind and was called by Hanno Kerem in early position.
Gintaras Naglius: Hanno Kerem:
Naglius had Kerem pipped. That remained the case on the runout to double Naglius up.
Player
Chips
Progress
Gintaras Naglius
34,300
4,300
Kerem Hanno
17,500
12,500
12:24 (UTC+0)
Start of Level 11 Blinds: 600/1,200 Ante: 1,200
Biggest Stacks in the Room Posted Friday 25th October, 2024 at 12:19(UTC+0) by Frank Visser
Player
Chips
Progress
Mantas Stikelis
300,000
188,900
David Bright
292,000
88,900
Luka Sorainen
250,000
22,000
Patrik Zidek
230,000
158,400
Artur Kulanurk
230,000
149,600
Andrejs Perederejevs
220,000
2,500
Aleksi Naski
210,000
88,000
Dmitri Dudakov
210,000
8,700
Rolands Norietis
205,000
175,000
Mikael Koistinen
192,000
61,400
First Break Posted Friday 25th October, 2024 at 12:05(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 225/635
The players have been sent on a 20-minute break.
Soini Doubles Through Sorainen Posted Friday 25th October, 2024 at 12:00(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 229/634
Ari Soini got his 20,000 chips in the middle against Luka Sorainen, who had accumulated an even bigger stack than he started the day with.
Ari Soini: Luka Sorainen:
Soini locked up the pot on the turn, leaving the river meaningless. Sorainen tossed Soini a few of his chips and play continued.
Player
Chips
Progress
Luka Sorainen
272,000
71,200
Ari Soini
43,000
13,000
Three-Way All-In Sees Two Worst Hands Win Posted Friday 25th October, 2024 at 11:52(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 228/630
Andre Magi was all-in for 18,400, Kristaps Sipols was so for 49,900, and Tarmo Tammel (pictured) had them both covered.
Andre Magi: Kristaps Sipols: Tarmo Tammel:
The flop gave Magi a flush draw, and it came in on the turn. Meanwhile, Sipols had turned his set, and nothing changed on the river.
Magi tripled up while Sipols also made a profit by raking in the big side pot. "Nice hands," Tammel said as he cut out the chips he owed.
Player
Chips
Progress
Tarmo Tammel
113,000
2,900
Kristaps Sipols
63,000
29,500
Andre Magi
58,200
28,200
Why? Posted Friday 25th October, 2024 at 11:44(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 232/627
Johan Martinsen had gone all in from the cutoff for 23,400 and had been called by Kaur Ajamaa (pictured) in the small blind.
Johan Martinsen: Kaur Ajamaa:
Ajamaa flopped great on , leaving his opponent with two direct outs. The turn delivered some more, and the river was a brutal one, giving Martinsen top pair to take the pot.
"Why?" Ajamaa asked rhetorically before he paid his dues.
Player
Chips
Progress
Johan Martinsen
51,700
24,300
Kaur Ajaama
27,500
12,500
Westerlund Down to Five Figures After Encounter With Mikhalov Posted Friday 25th October, 2024 at 11:33(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 240/625
Mykhailo Mikhalov had raised his button when Jenny Westerlund made it 6,300 to go in the big blind. Mikhalov called before both players checked through the flop.
Westerlund checked again on the turn, after which Mikhalov bet 7,000. Westerlund called to the river, where she check-called Mikhalov's final bet of 22,000.
Mikhalov showed for a turned flush. Westerlund sighed and tossed her cards into the muck as she dove under 100 big blinds.
Player
Chips
Progress
Mykhailo Mikhalov
175,000
9,600
Jenny Westerlund
97,000
70,900
Kriaciunas Keeps Building Posted Friday 25th October, 2024 at 11:18(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 242/624
Not long after eliminating Niclas Mjelstad, Mindaugas Kriaciunas was seen playing a big pot of 58,000 from the small blind against Jarmo Salonen in the cutoff.
Kriaciunas fired 11,000 on a completed board of and received a sigh-call from his opponent. He turned over for a rivered straight and Salonen sent his cards to the muck in defeat.
Player
Chips
Progress
Mindaugas Kriaciunas
106,000
40,000
Jarmo Salonen
23,000
7,000
Mjelstad Made Quick Work Of Posted Friday 25th October, 2024 at 11:10(UTC+0) by Frank Visser
Level 10: 600/1,200 (1,200) Entries: 244/618
Niclas Mjelstad had just sat down with a fresh stack of 30,000 when he got his chips in against Mindaugas Kriaciunas.
Niclas Mjelstad: Mindaugas Kriaciunas:
Kriaciunas made top pair on the flop while the turn gave him the better flush draw. Mjelstad did not hit a straight on the river and was eliminated.
Mjelstad has already won the €250 H.O.R.S.E. earlier this week but will have to re-enter the Main Event to add another trophy to his collection.
Player
Chips
Progress
Mindaugas Kriaciunas
66,000
25,000
Niclas Mjelstad
0
0
11:05 (UTC+0)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Metsla Gives Trebbi Trouble Posted Friday 25th October, 2024 at 10:59(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 251/618
The action was picked up on a turn of . Mark Metsla bet 7,000 into a pot of 16,000 and was called almost instantly by Gianluca Trebbi on the button.
Metsla then moved in for 17,500 on the river and was once again quickly called. He turned over for the nuts, beating the of Trebbi, who had called down with two pair.
Player
Chips
Progress
Mark Metsla
65,000
35,000
Gianluca Trebbi
46,200
28,800
Sandvik Sent Out After Calling Time on Self Posted Friday 25th October, 2024 at 10:48(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 249/607
Espen Sandvik was staring at Edikas Jurgutis' half-pot bet of 5,500 on a turn of for around two minutes when he called time on himself.
During his countdown, he made the call before the turn completed the board. He then led out for 2,000, which Jurgutis raised to 16,500.
Sandvik tossed in a quick call but mucked his cards once Jurgutis tabled for a full house. He was left with 5,000 chips, which he lost not much later as he was seen leaving the tournament area.
Player
Chips
Progress
Edikas Jurgutis
100,000
30,000
Espen Sandvik
0
0
Wahl Builds Further With Two Pair Posted Friday 25th October, 2024 at 10:41(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 250/601
Sebastian Wahl checked from the big blind on a turn of . Artjom Petskurov sat under the gun and tossed in a bet of 12,000 into the pot of 17,000, which Wahl called.
The river was checked down and Wahl tabled for two pair. Petskurov added his hand to the muck, seeing the pot shipped to Wahl.
Player
Chips
Progress
Sebastian Wahl
216,000
4,600
Artjom Petskurov
86,000
28,100
Vaaraniemi Veers Into Six-Figure Domain Posted Friday 25th October, 2024 at 10:28(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 251/595
Gisle Olsen had gone all in for 23,000 from the small blind and had been looked up by Elias Vaaraniemi in the cutoff.
Gisle Olsen: Elias Vaaraniemi:
Olsen failed to pair his hole cards on the runout and was consequently eliminated.
Player
Chips
Progress
Elias Vaaraniemi
112,000
17,100
Gisle Olsen
0
0
Parts No Longer Plays Part Posted Friday 25th October, 2024 at 10:22(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 249/588
Rasmus Parts had gotten his stack of 34,800 in the middle from early position against Viktors Kurovs in middle position.
Rasmus Parts: Viktos Kurovs:
The classic flip ended in Kurovs' favor when the flop did not help out Parts, and the latter took his exit from the tournament room.
Player
Chips
Progress
Viktors Kurovs
100,000
40,300
Rasmus Parts
0
0
Losing Start for Helppi Posted Friday 25th October, 2024 at 10:18(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 245/580
Kris Tikka and Juha Helppi were battling over a pot of 10,200 when Helppi checked from the small blind on a turn of .
Tikka bet 6,500 and Helppi called, causing the turn to appear. Helppi checked again, this time being met with a hefty bet of 17,500 from Tikka.
Helppi spent a minute or so in the tank before letting his hand go and forfeiting an early pot.
Player
Chips
Progress
Juha Helppi
136,700
11,000
Kris Tikka
87,700
7,500
Day 2 Underway Posted Friday 25th October, 2024 at 10:06(UTC+0) by Frank Visser
Level 9: 500/1,000 (1,000) Entries: 246/578
The button has been drawn, the players have taken their seats, and the cards are in the air for Day 2 of the Kings of Tallinn: Autumn Edition Main Event.
10:04 (UTC+0)
Day 2 of Kings of Tallinn Autumn Edition 2024 Started Level: 9 Blinds: 500/1,000 Ante: 1,000
How Big Will The Prize Pool Get? Find Out on Day 2 of Kings of Tallinn: Autumn Edition Main Event Posted Friday 25th October, 2024 at 08:45(UTC+0) by Frank Visser
After four starting flights, 554 entries are on the clock for the €1,100 Kings of Tallinn: Autumn Edition Main Event. The €500,000 guarantee has already been surpassed, but with four more levels of late registration and unlimited re-entries, there is no telling how big the event will actually get.
Every player who registers today will receive 30,000 in chips for 25 big blinds, a far cry away from chipleader's Mikael Koistinen's 253,400. Since the pandemic, Koistinen has been playing live poker only sporadically, but he has returned with a bang, already having won the €350 8-Game earlier this week and now hunting his second trophy. Meanwhile, Dmitri Dudakov is the best Estonian, sitting in second with a stack of 218,700, while Sebastian Wahl and Luka Sorainen also secured a spot in the top ten.
Mikael Koistinen
Top Ten Chip Counts
Rank
Player
Country
Chip Count
Big Blinds
1
Mikael Koistinen
Finland
254,400
254
2
Dmitri Dudakov
Estonia
218,700
219
3
Andrejs Perederejevs
Latvia
217,500
218
4
Sebastian Wahl
Finland
211,400
211
5
David Bright
United Kingdom
203,100
203
6
Luka Sorainen
Finland
200,800
201
7
Rytis Strigunas
Lithuania
188,700
188
8
Maykhailo Mykhaloc
Ukraine
184,600
185
9
Vismands Menjoks
Latvia
176,200
176
10
Egidijus Digrys
Lithuania
172,900
173
Other notable names making an appearance on Day 2 include Finnish legend and €5,000 Progressive Bounty winner Juha Helppi (147.800), Aleksi Naski (122,000), Estonian Powerhouse Tarmo Tammel (110,100), and runner-up in yesterday's €555 Championship Rasmus Lundstrom (77,800).
Along with all other returning players, they will return to Olympic Park Casino at noon local time to play ten levels of 60 minutes each. Blinds will start in Level 9: 500/1,000 (1,000), and a break will be held after every two levels. Late registration closes at the start of Level 13, 4:40 p.m., where players can buy in for 15 big blinds. The last level will be 3,000/6,000 (6,000), after which the remaining players will bag up for Day 3.
Stay tuned as the thrilling Day 2 of the Kings of Tallinn Main Event will be reported live from start to finish.
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.
flop brought him no trouble, but the room fell dead silent as the 
turn gave Segerman a flush draw.
river arrived. Segerman had made a flush and the room exploded in cheers and applause. Aglinskas was the last to leave the room empty-handed as 87 players bagged up for Day 3.
. Aivaras Kerusauskas called in middle position and Julius Kettunen did so in the small blind, creating a pot of 75,000
river for the side pot, and a showdown was had. Kerusauskas tabled 
for a pair of nines.
, however, and he let out a maniacal laugh while tripling up with his flush.
river was checked down. Segerman tabled 
for bottom pair and lost some chips to the 
turn paired the Greek up, however, and the 
river could not save Navickas from being eliminated.
board brought him no trouble.
flop brought no help.
, Albert Ostrovskij checked form the small blind to Jenny Westerlund in the hijack.
runout, doubling him up. Tamm, meanwhile, was left with exactly ten big blinds.
£ GBP
$ USD
€ EUR
