0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0071 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event12/1/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0033 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event12'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '39'
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '104'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '39'
AND `name` = '1'
0.0067 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '104'
ORDER BY `busted` ASC, `current_chips` DESC
0.0068 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` = '104'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '6259'
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` = '6258'
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` = '6257'
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` = '6256'
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` = '6255'
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` = '6254'
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` = '6253'
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` = '6252'
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` = '6251'
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` = '6250'
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` = '6249'
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` = '6248'
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` = '6247'
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` = '6246'
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` = '6245'
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` = '6244'
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` = '6243'
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` = '6240'
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` = '6242'
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` = '6239'
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` = '6238'
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` = '6237'
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` = '6241'
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` = '6236'
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` = '6235'
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` = '6234'
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` = '6233'
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` = '6231'
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` = '6230'
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` = '6229'
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` = '6228'
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` = '6227'
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` = '6226'
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` = '6225'
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` = '6224'
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` = '6223'
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` = '6221'
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` = '6220'
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` = '6219'
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` = '6218'
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` = '6217'
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` = '6216'
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` = '6214'
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` = '6213'
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` = '6212'
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` = '6211'
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` = '6210'
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` = '6208'
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` = '6207'
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` = '6206'
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` = '6205'
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` = '6204'
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` = '6203'
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` = '6201'
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` = '6200'
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` = '6202'
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` = '6199'
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` = '6198'
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` = '6196'
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` = '6195'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6189'
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` = '6187'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6180'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6176'
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` = '6171'
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` = '6168'
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` = '6166'
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` = '6155'
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` = '6150'
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` = '6145'
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` = '6141'
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` = '6136'
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` = '6133'
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` = '6131'
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` = '6125'
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` = '6116'
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` = '6114'
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` = '6108'
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` = '6096'
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` = '6090'
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` = '6088'
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` = '6080'
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` = '6076'
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` = '6074'
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` = '6071'
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` = '6069'
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` = '6059'
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` = '6052'
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` = '6051'
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` = '6038'
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` = '6026'
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` = '6022'
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` = '6027'
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` = '6010'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '104'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '104'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6259'
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` = '6258'
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` = '6257'
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` = '6256'
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` = '6255'
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` = '6254'
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` = '6253'
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` = '6252'
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` = '6251'
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` = '6250'
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` = '6249'
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` = '6248'
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` = '6247'
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` = '6246'
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` = '6245'
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` = '6244'
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` = '6243'
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` = '6240'
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` = '6242'
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` = '6239'
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` = '6238'
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` = '6237'
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` = '6241'
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` = '6236'
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` = '6235'
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` = '6234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6232'
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` = '6231'
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` = '6230'
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` = '6229'
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` = '6228'
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` = '6227'
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` = '6226'
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` = '6225'
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` = '6224'
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` = '6223'
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` = '6221'
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` = '6220'
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` = '6219'
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` = '6218'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6217'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6216'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '6214'
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` = '6213'
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` = '6212'
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` = '6211'
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` = '6210'
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` = '6208'
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` = '6207'
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` = '6206'
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` = '6205'
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` = '6204'
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` = '6203'
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` = '6201'
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` = '6200'
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` = '6202'
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` = '6199'
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` = '6198'
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` = '6196'
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` = '6195'
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` = '6189'
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` = '6187'
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` = '6181'
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` = '6180'
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` = '6176'
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` = '6171'
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` = '6168'
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` = '6166'
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` = '6155'
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` = '6154'
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` = '6150'
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` = '6145'
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` = '6144'
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` = '6141'
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` = '6136'
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` = '6133'
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` = '6131'
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` = '6125'
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` = '6116'
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` = '6114'
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` = '6108'
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` = '6096'
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` = '6090'
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` = '6088'
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` = '6080'
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` = '6076'
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` = '6074'
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` = '6071'
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` = '6069'
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` = '6059'
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` = '6052'
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` = '6051'
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` = '6038'
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` = '6033'
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` = '6026'
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` = '6022'
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` = '6027'
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` = '6010'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '104'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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.
Albert Gorelik Wins Fourth Ring in Event #12: €660 No-Limit Hold'em Progressive Bounty Posted Monday 25th September, 2023 at 02:08(UTC+0) by Frank Visser
The final event of WSOPC Tallinn has concluded, and it was Albert Gorelik who claimed the victory in Event #12: €660 No-Limit Hold'em Progressive Bounty. The American defeated Latvia's Jevgenijs Zotovs heads-up after a final table that lasted well into the later hours of the night. Both players received €7,900 as the cash prize, but it was Gorelik who had the bigger haul of bounties, totaling thousands of euros more.
This win marks Gorelik's fourth first place in a WSOPC Ring Event, and his third ring in just two months. Time will only tell if his hot run will continue onwards, but it will not be at WSOPC Tallinn as the festivities have now come to an end.
We hope you enjoyed all of the action live on the blogs and hopefully until the next poker festival.
Jevgenijs Zotovs Eliminated in 2nd Place (€7,900) Posted Monday 25th September, 2023 at 02:00(UTC+0) by Frank Visser
Jevgenijs Zotovs raised his button to 150,000 before Albert Gorelik made it 350,000 to go from the big blind. Zotovs obliged with a call and the flop was spread.
Gorelik added another 150,000 chips to the pot and Zotovs responded by going all-in for 652,000 chips. Gorelik instantly called and the final showdown of the tournament happened.
Jevgenijs Zotovs: Albert Gorelik:
Gorelik's aces were a big favorite, but the turn gave Zotovs a flush draw in addition to his pair of sixes. However, the river was a brick and Gorelik could celebrate his victory in Event #12.
Meanwhile, Jevgenijs Zotovs took home €7,900 for his efforts, as well as plenty of bounties gathered throughout the long tournament day.
Player
Chips
Progress
Albert Gorelik
4,800,000
1,100,000
Jevgenijs Zotovs
0
0
Zotovs Wins the First All-In of the Heads-Up Posted Monday 25th September, 2023 at 01:50(UTC+0) by Frank Visser
After a lot of folds, Jevgenijs Zotovs finally found a hand to jam on his button, and he did so for 516,000 chips. Albert Gorelik thought it over for a small while but eventually called the bet.
Jevgenijs Zotovs: Albert Gorelik:
Zotovs flopped a pair on and upgraded to a full house on the subsequent turn and river to secure his double-up.
Player
Chips
Progress
Albert Gorelik
3,700,000
400,000
Jevgenijs Zotovs
1,100,000
300,000
01:40 (UTC+0)
Start of Level 27 Blinds: 30,000/60,000 Ante: 60,000
Max Sanders Eliminated in 3rd Place (€5,400) Posted Monday 25th September, 2023 at 01:39(UTC+0) by Frank Visser
Albert Gorelik folded his button and Max Sanders subsequently shoved his 605,000 chips in from the small blind. Jevgenijs Zotovs called it off in the big blind and the players showed down.
Max Sanders: Jevgenijs Zotovs:
Zotovs was in the lead with his ace-high, and it would remain the best hand on the runout, resulting in Sanders' third-place elimination at his second final table appearance during WSOPC Tallinn.
Player
Chips
Progress
Jevgenijs Zotovs
1,400,000
604,000
Max Sanders
0
0
Zotovs Immediately Doubles Posted Monday 25th September, 2023 at 01:35(UTC+0) by Frank Visser
Jevgenijs Zotovs jammed his 605,000 stack in from the small blind and Albert Gorelik called from the big blind.
Jevgenijs Zotovs: Albert Gorelik:
It was Zotovs who had the best papers, and he would win the pot when neither player could pair their hand on the board.
Player
Chips
Progress
Albert Gorelik
3,300,000
400,000
Jevgenijs Zotovs
796,000
423,000
Gorelik Leaves Other Two On Fumes Posted Monday 25th September, 2023 at 01:32(UTC+0) by Frank Visser
Albert Gorelik raised to 100,000 from the button and Jevgenijs Zotovs called from the big blind. The flop fanned out and Zotovs check-called a 75,000 bet from his opponent. Gorelik then continued the pressure by betting another 150,000 on the turn, which Zotovs again check-called.
The river completed the board and Zotovs again checked to Gorelik. Gorelik then upped his sizing once more, to 575,000. Zotovs responded with a quick call, but saw that his for top pair was no good against the flopped set of Gorelik, who played .
Both Zotovs and Max Sanders are now short, with Gorelik having the majority of chips in play.
Player
Chips
Progress
Albert Gorelik
3,700,000
1,100,000
Jevgenijs Zotovs
373,000
1,527,000
Priit Vanem Eliminated in 4th Place (€4,070) Posted Monday 25th September, 2023 at 01:18(UTC+0) by Frank Visser
The action folded to Priit Vanem in the small blind, who limped in. Jevgenijs Zotovs then made it 150,000 to go from the big blind and Vanem made the call.
The flop of saw both players check before Vanem led out for 200,000 chips on the turn. Zotovs made the call and the river completed the board.
Vanem now shoved all-in for 255,000 and Zotovs followed with a swift call. Vanem showed for his slow-played rockets, but he was bested by Zotovs, who rivered trips with his .
A sour exit in fourth place for the last Estonian player remaining in the field, who left the table in fourth place.
Player
Chips
Progress
Jevgenijs Zotovs
1,900,000
977,000
Priit Vanem
0
0
01:07 (UTC+0)
Start of Level 26 Blinds: 20,000/50,000 Ante: 50,000
Mihails Morozovs Eliminated in 5th Place (€3,100) Posted Monday 25th September, 2023 at 01:07(UTC+0) by Frank Visser
Chip leader Albert Gorelik opened to 80,000 from the cutoff before Mihails Morozovs three-bet all-in from the big blind for 735,000. The action folded back to Gorelik, who snap called.
Mihails Morozovs: Albert Gorelik:
Bad timing for Morozovs, who ran into Gorelik's Big Slick. The board did not help him out either, as Gorelik was the only one to make a pair on the runout.
Morozovs said his goodbyes and left to collect his fifth-place winnings.
Player
Chips
Progress
Albert Gorelik
2,600,000
1,000,000
Mihails Morozovs
0
0
Jani Haarala Eliminated in 6th Place (€2,430) Posted Monday 25th September, 2023 at 00:51(UTC+0) by Frank Visser
Albert Gorelik raised his button to 80,000 chips and Jani Haarala went all-in from the big blind for the mere 180,000 chips he still had in his possession. Gorelik complied with the extra chips and the cards were revealed.
Jani Haarala: Albert Gorelik:
The window card was revealed to be an ace on , and Haarala did not hit a miracle runner-runner runout to win the pot on .
Thus, fate decided that he would take sixth place in the final tournament of WSOPC Tallinn, letting the other four players battle on.
Player
Chips
Progress
Albert Gorelik
1,600,000
500,000
Jani Haarala
0
0
Teemu Toikkanen Eliminated in 7th Place (€1,980) Posted Monday 25th September, 2023 at 00:42(UTC+0) by Frank Visser
Teemu Toikkanen jammed all-in for 310,000 chips from the hijack and Max Sanders asked for a count on the button. After some thinking time, he made the call, while the blinds quickly got out of the way.
Teemu Toikkanen: Max Sanders:
It was a close affair, but it would be Sanders who would be declared the victor when he paired his jack on the board the dealer put out.
Toikkanen left the tournament in seventh place and said his goodbyes in amicable spirits.
Player
Chips
Progress
Max Sanders
1,100,000
415,000
Teemu Toikkanen
0
0
00:31 (UTC+0)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Break Chip Counts Posted Monday 25th September, 2023 at 00:20(UTC+0) by Frank Visser
Player
Chips
Progress
Albert Gorelik
1,100,000
100,000
Jevgenijs Zotovs
923,000
77,000
Mihails Morozovs
835,000
205,000
Max Sanders
685,000
115,000
Priit Vanem
525,000
195,000
Jani Haarala
360,000
265,000
Teemu Toikkanen
330,000
75,000
A Nightly Break Posted Monday 25th September, 2023 at 00:18(UTC+0) by Frank Visser
The players are sent on a 15-minute break.
Nikolay Ponomarev Eliminated in 8th Place (€1,640) Posted Monday 25th September, 2023 at 00:03(UTC+0) by Frank Visser
Albert Gorelik raised to 60,000 from early position and the action folded to Nikolay Ponomarev in the big blind, who defended with a small stack.
The flop came down and Gorelik continued to bet another 35,000 after a check from Ponomarev. Ponomarev then jammed his 170,000 remaining chips in the middle and received an instant call from the American.
Nikolay Ponomarev: Albert Gorelik:
Gorelik was in the lead with his rockets, and he won the pot when Ponomarev did not improve with the turn or river. Ponomarev left the table in eight place and play continues seven-handed.
Player
Chips
Progress
Albert Gorelik
1,200,000
245,000
Nikolay Ponomarev
0
0
23:51 (UTC+0)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Joona Ranta-Nilkku Eliminated in 9th Place (€1,324) Posted Sunday 24th September, 2023 at 23:48(UTC+0) by Frank Visser
Joona Ranta-Nilkku went all-in from early position with 35,000 chips and Jevgenijs Zotovs three-bet to 175,000 from middle position. Albert Gorelik then put in the four-bet to 300,000 from the hijack, and folded everyone out, including Zotovs.
Joona Ranta-Nilkku: Albert Gorelik:
Gorelik would eliminate Rante-Nikku when the board ran out without a king with , and the first final table elimination was a fact.
Player
Chips
Progress
Jevgenijs Zotovs
1,000,000
160,000
Albert Gorelik
955,000
170,000
Joona Ranta-Nilkku
0
0
23:47 (UTC+0)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
The Final Nine of the Final Event Posted Sunday 24th September, 2023 at 23:07(UTC+0) by Frank Visser
Table
Seat
Player
Country
Chip Count
1
1
Max Sanders
United Kingdom
570,000
1
2
Jevgenijs Zotovs
Latvia
1,160,000
1
3
Joona Rante-Nilkku
Finland
55,000
1
4
Nikolay Ponomarev
United Kingdom
335,000
1
5
Priit Vanem
Estonia
396,000
1
6
Albert Gorelik
United States
785,000
1
7
Mihail Morozovs
Latvia
1,040,000
1
8
Teemu Toikkanen
Finland
405,000
1
9
Jani Haarala
Finland
95,000
Player
Chips
Progress
Jevgenijs Zotovs
1,160,000
185,000
Mihails Morozovs
1,040,000
85,000
Albert Gorelik
785,000
115,000
Max Sanders
570,000
540,000
Teemu Toikkanen
405,000
175,000
Nikolay Ponomarev
335,000
45,000
Priit Vanem
330,000
190,000
Jani Haarala
95,000
5,000
Joona Ranta-Nilkku
55,000
345,000
Live Report Will Operate On Delay Posted Sunday 24th September, 2023 at 22:55(UTC+0) by Frank Visser
To not spoil the live stream on olybet.tv, the live report will now be on a 30-minute delay.
Hersdal Bubbles the Final Table Posted Sunday 24th September, 2023 at 22:53(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 9/159
Albert Gorelik raised to 50,000 from under the gun and Jevgenijs Zotovs flat-called from the button. Big blind Einar Hersdal then went all-in for his final 90,000 chips, and both other players called.
The flop of saw Gorelik check to Zotovs, who made a bet of 80,000.
"You better have it buddy, I'm folding a big hand here," Gorelik claimed as he folded. He would soon find out as the two remaining players tabled their hands.
Einar Hersdal: Jevgenijs Zotovs:
Zotovs did, in fact, not have it, but he would end up getting there when he rivered his gutshot straight draw on the runout. He collected Hersdal's bounty and the nine remaining players converged onto one final table.
Player
Chips
Progress
Einar Hersdal
0
0
22:49 (UTC+0)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Zotovs Flops Nuts, Gets Jammed Into Posted Sunday 24th September, 2023 at 22:38(UTC+0) by Frank Visser
Level 20: 10,000/25,000 (25,000) Entries: 10/159
With in the middle of the table, Mihails Morozovs checked from the big blind to Jevgenijs Zotovs in the hijack. The latter then put out a bet of 50,000, which Morozovs raised to 300,000.
Zotovs asked for a count before jamming all-in for 470,000 total and Morozovs called it off.
Jevgenijs Zotovs: Mihails Morozovs:
Zotovs had flopped the nut flush while Morozovs needed a runner-runner straight flush to win the pot. The turn left him drawing dead, however, and the river gave him a meaningless straight.
Zotovs doubled to twice the average stack, while Morozovs still plays a seven-figure stack himself.
Player
Chips
Progress
Mihails Morozovs
1,125,000
225,000
Jevgenijs Zotovs
975,000
710,000
22:25 (UTC+0)
Start of Level 21 Blinds: 10,000/15,000 Ante: 15,000
Wild Four-Way All-In Situation Sees Ponomarev Quadruple, Morozovs Wins the Mother Of All Bounties Posted Sunday 24th September, 2023 at 22:24(UTC+0) by Frank Visser
Level 20: 10,000/20,000 (20,000) Entries: 10/159
Ilari Sahamies raised to 40,000 from under the gun and Mihails Morozovs flat-called from the hijack. Lourido Lategui then three-bet jammed for 325,000 and the short-stacked Nikolay Ponomarev called all-in for just 85,000 chips.
In response, Sahamies joined with an all-in of his own, and, with his eyes on the big bounties up for grabs, Morozovs threw in calling chips as well, creating a four-way preflop all-in situation.
Nikolay Ponomarev: Ilari Sahamies: Lourido Lategui: Mihails Morozovs:
The hand turned even more crazy when the case ace appeared on the flop, giving Ponomarev all but a guaranteed quadruple-up while Morozovs shot in the lead for the €1,750 in bounties that were up for grabs.
The turn left only Lategui drawing live to one jack for the side pot, but it did not arrive on the river.
Thus, Ponomarev quadrupled up, Morozovs won the chip lead and more than eight-place money in bounties, and Sahamies and Lategui were eliminated from the tournament.
Player
Chips
Progress
Mihails Morozovs
1,350,000
700,000
Nikolay Ponomarev
380,000
113,000
Lourido Lategui
0
0
Ilari Sahamies
0
0
Recent Eliminations Posted Sunday 24th September, 2023 at 22:03(UTC+0) by Frank Visser
Player
Chips
Progress
Giuseppe Rosa
0
0
Vu Hoang Vuong
0
0
Karin Ehala
0
0
Hersdal Holds for a Double Posted Sunday 24th September, 2023 at 22:00(UTC+0) by Frank Visser
Level 20: 10,000/20,000 (20,000) Entries: 13/159
The action folded to Einar Hersdal in the small blind and he jammed all-in for 145,000. Ilari Sahamies sat in the big blind, sighed, asked for an exact count, sighed again, and made the call.
Einar Hersdal: Ilari Sahamies:
Hersdal would make a flush on the board and secure the double-up.
Player
Chips
Progress
Ilari Sahamies
355,000
5,000
Einar Hersdal
310,000
205,000
21:54 (UTC+0)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
Limped Pot Leads to Huge Double-Up Posted Sunday 24th September, 2023 at 21:50(UTC+0) by Frank Visser
Level 19: 10,000/15,000 (15,000) Entries: 15/159
Ilari Sahamies limped from the small blind and Mihails Morozovs checked his big blind. The flop subsequently fell and Sahamies bet out huge with 100,000 chips after a check from Morozovs.
The latter then committed his entire stack of roughly 300,000 chips and Sahamies obliged with a call, covering his opponent.
Mihail Morozovs: Ilari Sahamies:
A big blind special for Morozovs, who flopped a hidden bottom two pair. However, he was not out of the woods yet against the flush draw of Sahamies. No heart appeared on the runout, however, and Morozovs received a huge double-up.
Player
Chips
Progress
Mihails Morozovs
650,000
200,000
Ilari Sahamies
350,000
250,000
Sahamies Scoops Big Bounty Posted Sunday 24th September, 2023 at 21:39(UTC+0) by Frank Visser
Level 19: 10,000/15,000 (15,000) Entries: 15/159
Ilari Sahamies opened to 30,000 from the hijack and Martyna Miliauskas went all-in from the cutoff for 90,000. With no other takers, Sahamies complied with the extra chips and the cards went on their backs.
Martyna Miliauskas: Ilari Sahamies:
Miliauskas stood up as the flop showed , and he did not need to sit back down when the turn and river rolled off. Sahamies scored the first knock-out of the final two tables and received a juicy €1,050 bounty in his pocket for doing so.
Player
Chips
Progress
Ilari Sahamies
600,000
305,000
Martynas Miliauskas
0
0
21:24 (UTC+0)
Start of Level 19 Blinds: 10,000/15,000 Ante: 15,000
Breakie-Breakie Posted Sunday 24th September, 2023 at 21:11(UTC+0) by Frank Visser
A 15-minute break has been bestowed upon the final 16 players still in contention for the final ring of WSOPC Tallinn.
Final Two Table Redraw Posted Sunday 24th September, 2023 at 21:07(UTC+0) by Frank Visser
Table
Seat
Player
Country
Chip Count
1
1
Joona Ranta-Nilkku
Finland
196,000
1
2
Vu Hoan Vuong
Finland
326,000
1
3
Giuseppe Rosa
Italy
297,000
1
4
Albert Gorelik
United States
570,000
1
5
Priit Vanem
Estonia
396,000
1
6
Teemu Toikkanen
Finland
550,000
1
7
Max Sanders
United Kingdom
145,000
1
8
Jani Haarala
Finland
96,000
2
1
Jevgenijs Zotovs
Latvia
274,000
2
2
Nikolay Ponomarev
United Kingdom
238,000
2
3
Karin Ehala
Estonia
89,000
2
4
Einar Hersdal
Norway
93,000
2
5
Ilari Sahamies
Finland
592,000
2
6
Martynas Miliauskas
Lithuania
188,000
2
7
Mihail Morozovs
Latvia
450,000
2
8
Lourido Lategui
Uruguay
368,000
Player
Chips
Progress
Albert Gorelik
570,000
100,000
Teemu Toikkanen
550,000
30,000
Mihails Morozovs
450,000
0
Priit Vanem
396,000
256,000
Lourido Lategui
368,000
191,000
Vu Hoang Vuong
326,000
29,000
Giuseppe Rosa
297,000
267,000
Jevgenijs Zotovs
274,000
9,000
Nikolay Ponomarev
238,000
29,000
Joona Ranta-Nilkku
196,000
204,000
Martynas Miliauskas
188,000
72,000
Max Sanders
145,000
115,000
Jani Haarala
96,000
4,000
Einar Hersdal
93,000
12,000
Karin Ehala
89,000
211,000
Eliminations to Reach Final Two Tables Posted Sunday 24th September, 2023 at 20:52(UTC+0) by Frank Visser
Player
Chips
Progress
James Noonan
0
0
Johan Alen
0
0
Jonas Neukirch
0
0
Ponomarev Triples Up Posted Sunday 24th September, 2023 at 20:50(UTC+0) by Frank Visser
Level 18: 6,000/12,000 (12,000) Entries: 18/159
Nikolay Ponomarev went all-in for 83,000 chips from under the gun. Jevgenijs Zotovs then called in the cutoff before the action folded to Teemu Toikkanen in the big blind, who eyed Zotovs' stack before pushing all in himself, covering Zotovs' 265,000 chips.
Zotovs frustratedly let his hand go and the other two players showed down.
Nikolay Ponomarev: Teemu Toikkanen:
Ponomarev sighed when he saw the door card, but his mood quickly changed when the full flop emerged: . The turn and river were also safe for him and he raked in a big triple-up.
Player
Chips
Progress
Teemu Toikkanen
580,000
550,000
Nikolay Ponomarev
267,000
71,000
Jevgenijs Zotovs
265,000
50,000
Smirnov Receives Mincash Posted Sunday 24th September, 2023 at 20:38(UTC+0) by Frank Visser
Level 18: 6,000/12,000 (12,000) Entries: 19/159
Aleksei Smirnov open-jammed for 90,000 chips from under the gun and the action folded to Mihail Morozovs in the big blind, who quickly called with the covering stack.
Aleksei Smirnov: Mihail Morozovs:
The flop brought some hope for Smirnov when the monotone rolled off, but neither the turn or river upgraded his hand to a flush, leaving him without chips and without a chance to win the final ring of WSOPC Tallinn.
Player
Chips
Progress
Mihails Morozovs
450,000
420,000
Aleksei Smirnov
0
0
20:27 (UTC+0)
Start of Level 18 Blinds: 6,000/12,000 Ante: 12,000
Big Stack Bully Gorelik Bursts Bubble; Jelpidiforov Last to Leave Without Money Posted Sunday 24th September, 2023 at 20:27(UTC+0) by Frank Visser
Level 17: 5,000/10,000 (10,000) Entries: 20/159
Albert Gorelik, who had raised almost every hand so far on the bubble with a high success-rate, raised to 25,000 from middle position.
Absolute short-stack Aleksandr Jelpidiforov (pictured) then went all-in for 40,000 from the hijack. The action folded back to Gorelik, who put in the extra chips.
Aleksandr Jelpidiforov: Albert Gorelik:
Gorelik had a big lead, and it turned into a massive one when he paired his king on the flop. The turn effectively ended the hand as Jelpidiforov had no chance at winning the hand anymore. He looked on as the river completed the board, and he would be the last one to leave the tournament money without a registered cash.
The 20 remaining players continue on as the field plays down to a winner today.
Player
Chips
Progress
Albert Gorelik
670,000
220,000
Aleksandr Jelpidiforov
0
0
Lategui Doubles Up During First All-In of the Bubble Posted Sunday 24th September, 2023 at 20:10(UTC+0) by Frank Visser
Level 17: 5,000/10,000 (10,000) Entries: 21/159
Lourido Lategui open-jammed for 81,000 from under the gun and the action folded to Jevgenijs Zotovs in the big blind, who made the call. with the covering stack.
Lourido Lategui: Jevgenijs Zotovs:
Lategui's superior jack held as he was the only one to make a pair on and thus the first all-in of the bubble resulted in a double-up for the Uruguayan.
Player
Chips
Progress
Jevgenijs Zotovs
215,000
100,000
Lourido Lategui
177,000
147,000
19:57 (UTC+0)
Start of Level 17 Blinds: 5,000/10,000 Ante: 10,000
Ranta-Nilkku's Kings Gets the Field Down to Hand-for-Hand Posted Sunday 24th September, 2023 at 19:46(UTC+0) by Frank Visser
Level 16: 4,000/8,000 (8,000) Entries: 21/159
Joona Ranta-Nilkku raised to 17,000 from the hijack before Sander Leigri jammed all-in from the cutoff. Ranta-Nilkku snap called with the covering stack and the players flipped over their cards.
Sander Leigri: Joona Ranta-Nilkku:
The board ran out and the river remained ace-free as well.
With Leigri's elimination, there are 21 players remaining, and with 20 paid that means that the hand-for-hand bubble phase has begun.
Player
Chips
Progress
Joona Ranta-Nilkku
400,000
220,000
Sander Leigri
0
0
Burneikis Bows Out Before the Money Posted Sunday 24th September, 2023 at 19:32(UTC+0) by Frank Visser
Level 16: 4,000/8,000 (8,000) Entries: 23/159
Vladas Burneikis open-jammed his 85,000 stack from the hijack before Nikolay Ponomarev went all-in for 96,000 from the button. The blinds folded and a showdown was had.
Vladas Burneikis: Nikolay Ponomarev:
Ponomarev immediately flopped a set on and Burneikis was drawing dead on the turn. He walked away as the river completed the board, while Ponomarev almost doubled up.
Player
Chips
Progress
Nikolay Ponomarev
196,000
166,000
Vladas Burneikis
0
0
19:23 (UTC+0)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
Kicker Problem for Jelpidiforov Posted Sunday 24th September, 2023 at 19:22(UTC+0) by Frank Visser
Level 15: 3,000/6,000 (6,000) Entries: 24/159
In a pot worth 40,000 chips Aleksandr Jelpidiforov bet out 10,000 from the big blind on a flop that read and received a call from Joona Ranta-Nilkku in early position. Both players subsequently checked the turn.
On the river, Jelpidiforov put another 20,000 chips in the pot, and again Ranta-Nilkku put in a quick call.
Jelpidiforov showed but was pipped by Ranta-Nilkku's and thus lost the small pot.
Player
Chips
Progress
Joona Ranta-Nilkku
180,000
150,000
Aleksandr Jelpidiforov
108,000
97,000
Welcome to Queens of Tallinn! Posted Sunday 24th September, 2023 at 19:05(UTC+0) by Lina Olofsson
After all of the successful festivals over the years with the Kings of Tallinn, it's now announced by the tournament organizers that we will have The Queens of Tallinn in late November. A festival series for only women with a €350 Main Event and several other events to go along with it.
Just like the Kings of Tallinn, the WSOP Circuit has been beyond anyone's expectations with stunning branding all over Hilton Park and Olympic Casino. The Queens of Tallinn will bring exact same feeling to the players who attend with a streamed final table from the Main Event and world-class tournament staff like it always is with this organization with the well-renowned Tournament Director Teresa Nousiainen in charge.
Together with Teresa, and Christer Larsson who's the Olympic Entertainment Group's Poker Director, they are just finishing all the details for this festival. We got to have a talk with Christer as the Festival was announced during the Ladies Event here in the WSOPC on Saturday.
Christer Larsson and Teresa Nousiainen
"It's about time someone does something like this. It feels nice to give something back to all the fantastic women in this industry and to create a festival for them," Christer said after receiving a big round of applause from everyone in the grand ballroom as the two made the announcement.
The Queens of Tallinn Festival will be held here at Olympic Casino and Hilton Park from November 30th to December 3rd and will be just as fantastic as all the festivals we've had here for a number of years now. There will be a €350 Main Event with a live-streamed final table alongside three or four side events. All Events will be for women only but for the gentlemen who want to come along there will be a €60 side event and also a cash game weekend down in the casino.
Ave Lepik who won the Queens of Tallinn here during the WSOPC
It's fair to say that we already know this will be a one-of-a-kind experience for everyone who decides to join as both Christer and Teresa are two of the best in the world when it comes to arranging festivals that give it's players that little bit of extra from the minute they enter the building until they leave.
Author: Lina Olofsson Photos: Elena & Tambert Kask
Gorelik Ousts Hallik to Reach Final Three Tables Posted Sunday 24th September, 2023 at 18:59(UTC+0) by Frank Visser
Level 15: 3,000/6,000 (6,000) Entries: 24/159
Albert Gorelik and Kert Hallik went into a raising war preflop, which ended in Hallik being all-in for over 200,000 chips and slightly covered by Gorellik.
Kert Hallik: Albert Gorelik:
The board did not help Hallik's dire situation and Gorelik's aces held on to make the tournament reach the final three tables, which is being held at the TV area. The tournament will have a small break while the 24 remaining players are taking a few minutes to move over there.
Player
Chips
Progress
Albert Gorelik
450,000
260,000
Kert Hallik
0
0
Metsla Meets His End Posted Sunday 24th September, 2023 at 18:46(UTC+0) by Frank Visser
Level 15: 3,000/6,000 (6,000) Entries: 25/159
Mark Metsla got the last of his 80,000 chips in from the button and big blind Albert Gorelik obliged with a call.
Mark Metsla: Albert Gorelik:
Gorlik's tens would not get trumped on the runout and he added some more bounty chips to the stack in front of him.
Player
Chips
Progress
Albert Gorelik
190,000
40,000
Mark Metsla
0
0
Madness Before The Break (€1525 Bounty) Posted Sunday 24th September, 2023 at 18:38(UTC+0) by Alaxandar Georgiev
Level 14: 2,500/5,000 (5,000) Entries: 26/159
Andrius Simonovicius went all-in for his last 500 chips and a big €500 bounty on his head Martynas Miliauskas raised the pot to 10,000, Einar Hersdal and Jose Koistinen both called.
Big three-bet to 50,000 followed by Mati Pirn, Miliauskas called and that also covered Koistinen who put his remaining stack forward.
The flop was and last 50,000 chips went all-in from Pirn, Miliauskas called and players revealed their hands.
Mati Pirn: Martynas Miliauskas: Jose Koistinen:
Pirn had a monster hand and needed to hold for two bounties, but Miliauskas had a pair of fours and some live cards.
The dealer banged the turn with the which made trips for Miliauskas and he held it on the river.
Massive win for him as he scooped the whole pot and knocked out 3 players for a total of €1525 in cashed-in bounties. The same amount will be added to his own hand.
Player
Chips
Progress
Martynas Miliauskas
260,000
175,000
Mati Pirn
0
0
Jose Koistinen
0
0
18:37 (UTC+0)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
A Small Break Posted Sunday 24th September, 2023 at 18:21(UTC+0) by Frank Visser
The 28 remaining players are enjoying a 15-minute break while a chip race is conducted.
Jelpidiforov Wins a "Weird" Hand Posted Sunday 24th September, 2023 at 18:20(UTC+0) by Frank Visser
Level 14: 2,500/5,000 (5,000) Entries: 29/159
Dominik Ostrowski raised to 10,000 from under the gun and received calls from Albert Gorelik on the button and Aleksandr Jelpidiforov (pictured) in the big blind.
Ostrowski put forth a continuation-bet of 12,500 on the flop of after a check from Jelpidiforov, and again both players called.
Jelpidiforov then led for 20,000 on the turn, which resulted in a quick fold from Ostrowski.
"This is so weird," commented Gorelik, "I don't think I've ever seen this before". He took off his sunglasses to take a good look at his opponent, who counteracted the attempt by putting on a set of sunglasses himself.
Eventually, Gorelik's cards joined the muck and Jelpidiforov raked in the pot, showing the in the process.
Player
Chips
Progress
Dominik Ostrowski
247,000
181,000
Aleksandr Jelpidiforov
205,000
175,000
Albert Gorelik
150,000
21,000
Gorelik Fades the World and Doubles Up Posted Sunday 24th September, 2023 at 18:00(UTC+0) by Frank Visser
Level 14: 2,500/5,000 (5,000) Entries: 33/159
Albert Gorelik and Priit Vanem had arrived on the turn on a board of . With around 35,000 in the pot, all of Gorelik's 68,000 remaining chips went in, looked up by Vanem.
Albert Gorelik: Priit Vanem:
Vanem had a pair and a flush draw, but when the river was dealt, Gorelik's pair of jacks remained the best hand and he secured the double-up.
Player
Chips
Progress
Albert Gorelik
171,000
141,000
Priit Vanem
140,000
110,000
17:49 (UTC+0)
Start of Level 14 Blinds: 2,500/5,000 Ante: 5,000
Sahamies Ships a Grand Posted Sunday 24th September, 2023 at 17:48(UTC+0) by Frank Visser
Level 13: 2,000/4,000 (4,000) Entries: 33/159
Jimmy Dewerdt jammed all in for roughly 75,000 chips from middle position. Ilari Sahamies was sitting in the cutoff and three-bet with the covering stack, forcing all other players to fold.
Jimmy Dewerdt: Ilari Sahamies:
Both players made a flush on , but Sahamies' ace of hearts secured him the better one. Dewerdt had over €1,000 in bounty chips in front of him, resulting in Sahamies pocketing a cool €525.
Player
Chips
Progress
Ilari Sahamies
295,000
265,000
Jimmy Philippe Dewerdt
0
0
Always A Sweat Posted Sunday 24th September, 2023 at 17:47(UTC+0) by Alaxandar Georgiev
Level 13: 2,000/4,000 (4,000) Entries: 34/159
Sander Leigri raised from the cutoff to hunt the bounty of Oskar Ojaveer on the big blind who did go all in indeed for 26,000 chips and got snap-called from his Estonian fellow.
Sander Leigri: Oskar Ojaveer:
The flop came and Leigri said "A ten is coming.. " with a smile on his face.
The turn made Ojaveer sweat even more as Leigri jokingly said "Bye byeee", luckily for Ojaveer the river bricked and he won the pot to double up.
Player
Chips
Progress
Sander Leigri
150,000
20,000
Oskar Ojaveer
58,000
27,000
Vuong Ships Wahl's Bounty Posted Sunday 24th September, 2023 at 17:32(UTC+0) by Frank Visser
Level 13: 2,000/4,000 (4,000) Entries: 34/159
Vu Hoang Vuong (pictured) in middle position and Sebastian Wahl on the button got all-in preflop, with Wahl's 75,000 stack at risk.
Vu Hoang Vuong: Sebastian Wahl:
Wahl flopped a set of jacks on , but Vuong rebinked a flush when the third heart arrived on the turn. The board did not pair on the river and Wahl took his exit, while Vuong was proclaimed by the table to be the "bounty daddy".
Player
Chips
Progress
Vu Hoang Vuong
355,000
135,000
Sebastian Wahl
0
0
Zotovs Collects A Nice Bounty Posted Sunday 24th September, 2023 at 17:28(UTC+0) by Alaxandar Georgiev
Level 12: 1,500/3,000 (3,000) Entries: 39/159
Jevgenijs Zotovs raised the button to 6,000 and Juho Heiska defended his big blind.
The flop revealed , Zotovs bet 7,000 on the flop after his opponent checked.
The turn was the and this time Heiska was the aggressive one as he lead-jammed his remaining 37,000 chips, not after long he got called.
Jevgenijs Zotovs: Juho Heiska:
Heiska was behind against Zotovs's pocket monster and he needed to hit a club or a three to win the pot on the river. No luck for the Finn as the river came .
The Latvian collected a bounty of €425 in cash and the same amount was added to his head.
Player
Chips
Progress
Jevgenijs Zotovs
115,000
85,000
Juho Heiska
0
0
17:23 (UTC+0)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
Three Players, Three Bets, One Victor Posted Sunday 24th September, 2023 at 17:23(UTC+0) by Frank Visser
Level 12: 1,500/3,000 (3,000) Entries: 40/159
Karin Ehala raised to 8,000 from under the gun and Van Tuan Phung called from middle position. Dominik Ostrowski also came along from the cutoff before button Jani Haarala made it 28,000 to go.
Ehala put in the extra chips, as did Phung, while Ostrowski was the only one who folded before the flop of was spread. Ehala then led with a bet of 25,000, which only Phung called. Haarala thought about it for a while but would eventually fold.
On the turn, Ehala went all-in, covering Phung's 40,000 remaining chips. Phung put in the call and the cards went on their backs.
Van Tuan Phung: Karin Ehala:
Ehala's jacks held on the river and she scooped a humongous pot, as well as Phung's bounty.
Player
Chips
Progress
Karin Ehala
300,000
270,000
Jani Haarala
100,000
100,000
Dominik Ostrowski
66,000
21,000
Van Tuan Phung
0
0
Payouts Are Announced Posted Sunday 24th September, 2023 at 17:06(UTC+0) by Alaxandar Georgiev
The payouts for the €660 No-Limit Hold'em Progressive Bounty have been announced. The final 20 players will split the prizes down below, they will also cash-in their bounties with the winner taking the bounty on his head and the last WSOPC ring.
#1st
€7,900
#2nd
€7,900
#3rd
€5,400
#4th
€4,070
#5th
€3,100
#6th
€2,430
#7th
€1,980
#8th
€1,640
#9th
€1,324
#10-11th
€1,080
#12-13th
€850
#14-15th
€700
#16-18th
€600
#19-20th
€540
Doan and Burneikis Flip for Stacks Posted Sunday 24th September, 2023 at 17:01(UTC+0) by Frank Visser
Level 12: 1,500/3,000 (3,000) Entries: 43/159
Quang Doan and Vladas Burneikis went all-in preflop, with Doan's 80,000 stack at risk.
Quang Doan: Vladas Burneikis:
No aces or kings appeared on , and Burneikis' full house shipped him a sizable pot and, of course, another bounty to add to his wallet.
Player
Chips
Progress
Vladas Burneikis
210,000
180,000
Quang Doan
0
0
16:51 (UTC+0)
Start of Level 12 Blinds: 1,000/2,500 Ante: 2,500
Three-Way All-in Sees Miliauskas Victorious Posted Sunday 24th September, 2023 at 16:51(UTC+0) by Frank Visser
Level 11: 1,000/2,500 (2,500) Entries: 49/159
Martynas Miliauskas shoved all-in for 28,500 from the hijack and Rauno Arras called for less. With two bounties up for grabs, Andrey Koks decided to also join the party and was the third person to put his entire stack in. The big blind then got out of the way and the other three players revealed their cards.
Rauno Arras: Martynas Miliauskas: Andrey Koks:
Miliauskas' ace-high remained in the lead on , but Koks turned a flush draw. Miliauskas paired his ace on the river, however, and tripled up, as well as collecting Arras' bounty.
Player
Chips
Progress
Martynas Miliauskas
85,000
55,000
Andrey Koks
60,000
50,000
Rauno Arras
0
0
Top 5 Bounty Daddies Posted Sunday 24th September, 2023 at 16:44(UTC+0) by Alaxandar Georgiev
Level 11: 1,000/2,500 (2,500) Entries: 49/159
Check out some of the biggest bounties on the tables. Each player started with €300 bounty on their head which means that our lead bounty hunter Igor Pihela (Sr.) has cashed in €1200 and added €1200 on top of his head.
Name
County
Stack
Bounty
#1
Igor Pihela (Sr.)
Estonia
180,000
€1,500
#2
Jose Koistinen
Finland
185,000
€1425
#3
Vu Hoang Vuong
Finland
220,000
€1300
#4
Kart Hallik
Estonia
245,000
€1300
#5
Sebastian Wahl
Finland
145,000
€1100
Vartinen Picks Up a Bounty Posted Sunday 24th September, 2023 at 16:35(UTC+0) by Frank Visser
Level 11: 1,000/2,500 (2,500) Entries: 52/159
Vili Vartinen open-jammed from under the gun for a total of 49,000 chips. Kalju Raap was sitting in the small blind with only 17,500 and was the only one who looked the Fin up.
Kalju Raap: Vili Vartinen:
Vartinen locked it up on the turn when the board gave him a full house with . He collected the bounty and of course Raap's chips.
Player
Chips
Progress
Vili Vartinen
71,500
41,500
Kalju Raap
0
0
Haarala Ships a Big One Posted Sunday 24th September, 2023 at 16:29(UTC+0) by Frank Visser
Level 11: 1,000/2,500 (2,500) Entries: 55/159
A huge sum of 95,000 chips, more than an average stack, had already been gathered in the middle in a heads-up pot between Andrey Koks in the big blind and Jani Haarala under the gun.
The board was already completed and read . Koks checked to Haarala, who made a bet of 26,500. Koks spent a few minutes in the tank before electing to let his hand go and surrendering the monster pot to his opponent.
Player
Chips
Progress
Jani Haarala
200,000
170,000
Andrey Koks
110,000
25,000
16:20 (UTC+0)
Start of Level 11 Blinds: 1,000/2,500 Ante: 2,500
Final Break Before Late Registration Closes Posted Sunday 24th September, 2023 at 15:45(UTC+0) by Alaxandar Georgiev
Players just got up from their seats and will take a 30-minute break. This is the last chance players can get into the action as late registration will be closed at the start of Level 11.
Player
Chips
Progress
Vu Hoang Vuong
180,000
150,000
Kaur Ajamaa
79,000
49,000
WSOPC Winner Kaur Ajamaa Doubles Posted Sunday 24th September, 2023 at 15:29(UTC+0) by Alaxandar Georgiev
Level 10: 1,000/2,000 (2,000) Entries: 62/146
Vu Hoang Vuong opened to 4,000 from the cutoff. Event #3: €350 WSOPC Tallinn NLH victor Kaur Ajamaa (pictured below) three-bet shoved 37,000 and Vuong called.
Vu Hoang Vuong: Kaur Ajamaa:
Ajamaa didn't connect on the board for Ajamaa to double with a flush.
Player
Chips
Progress
Vu Hoang Vuong
180,000
150,000
Kaur Ajamaa
79,000
49,000
15:17 (UTC+0)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Big Slick for Tammel Posted Sunday 24th September, 2023 at 15:04(UTC+0) by Alaxandar Georgiev
Level 9: 1,000/1,500 (1,500) Entries: 68/136
Jarkko Suokas jammed fom under the gun for 16,000. Tarmo Tammel (pictured below) three-bet jammed over the top for 63,000 followed by a call from Johnnie Sanders on the big blind.
Jarkko Suokas: Tarmo Tammel: Johnnie Sanders:
Tammel was dominating both of his opponents and also covered them for their bounties.
The flop wasn't what the Estonian legend wanted to see as Sanders paired the ladies. The turn and river completely bricked for Tammel and he lost a huge pot.
Johnnie Sanders managed to collect his bounty on the next hand with his pocket jacks.
Player
Chips
Progress
Johnnie Sanders
137,000
107,000
Tarmo Tammel
5,000
25,000
Jarkku Suokas
0
0
14:45 (UTC+0)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
The Bounty Hunters Posted Sunday 24th September, 2023 at 14:44(UTC+0) by Alaxandar Georgiev
Check out some of the biggest bounties on the tables. Each player started with €300 bounty on their head which means that our lead bounty hunter Georgios Skarparis collected €1,500 in bounties, €750 went to his pocket, and €750 on top of his head.
Name
County
Stack
Bounty
Georgios Skarparis
Cyprus
65,000
€1,050
Oskar Ojaveer
Estonia
85,000
€975
Kert Hallik
Estonia
132,000
€825
Jani Kalervo
Finland
133,000
€750
Vu Hoang Vuong
Finland
145,000
€675
Jimmy Dewerdt
France
160,000
€675
Various Big Stacks At The Second Break Posted Sunday 24th September, 2023 at 14:30(UTC+0) by Alaxandar Georgiev
Player
Chips
Progress
Jimmy Philippe Dewerdt
160,000
130,000
Vu Hoang Vuong
145,000
115,000
Sebastian Wahl
140,000
50,000
Andrey Koks
135,000
105,000
Jani Kalervo
133,000
48,000
Kert Hallik
132,000
69,000
Sander Leigri
130,000
100,000
Igor Pihela Sr.
127,000
97,000
Einar Hersdal
105,000
75,000
Kelly Kellner
85,500
55,500
Flush for Hallik Posted Sunday 24th September, 2023 at 14:19(UTC+0) by Alaxandar Georgiev
Level 8: 600/1,200 (1,200) Entries: 67/124
Martynas Miliauskas raised from under the gun. Double Estonian Championship winner Kert Hallik 2,500 called from one seat over. Yanis Mehdi Sahli three-bet 10,000, Miliauskas folded and Hallik called.
Hallik check-called for 6,000 the flop.
Hallik checked the turn and Sahli jammed for 13,300. Hallik called and the cards were turned over.
Yanis Mehdi Sahli: Kert Hallik:
The brave call from Hallik ended up winning him the pot worth over 60,000 chips as the river came . He ended up knocking out Sahli a few hands after with his flush.
Player
Chips
Progress
Kert Hallik
63,000
33,000
Yanis Mehdi Sahli
25,000
5,000
13:53 (UTC+0)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Ojaveer Collects Vanem's Bounty Posted Sunday 24th September, 2023 at 13:53(UTC+0) by Alaxandar Georgiev
Level 7: 500/1,000 (1,000) Entries: 72/119
Oskar Ojaveer opened for 2,500 and he was quickly shoved by Priit Vanem sitting next to him.
"Probably a bad call," Ojaveer said to the table as he threw 21,700 chips.
Oskar Ojaveer: Priit Vanem:
The flop gave Ojaveer a much-needed pair, the turn was and the river came which meant Ojaveer won the hand and the €450 bounty. He got €225 in cash and increased the bounty on his head.
After that, he mentioned that he is free-rolling the tournament and already €675 cashed in bounties and has almost a €1,000 bounty on his head.
Player
Chips
Progress
Oskar Ojaveer
85,000
24,000
Priit Vanem
0
0
Flush for Naeland Posted Sunday 24th September, 2023 at 13:44(UTC+0) by Alaxandar Georgiev
Level 7: 500/1,000 (1,000) Entries: 75/114
Yanis Mehdi Sahli raised from the cutoff to 2,200 followed by a call from Jani Kalervo and Stein Naerland.
The flop came and Kalervo and Naerland checked, Sahli bet 3,100 and got a call from Kalervo followed by a 21,000 all-in from Naerland. The French folded and Kalervo ended up calling.
Jani Kalervo: Stein Naerland:
Naerland already had a made flush and Kalervo needed help from the lady in black. The turn was and the binked on the river for Kalervo to complete his flush as well.
Kalervo took Naerland's bounty and a good 50,000 pot.
Player
Chips
Progress
Jani Kalervo
85,000
25,000
Stein Gabriel Naerland
0
0
13:17 (UTC+0)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Ranno Sootla Doubles Up Posted Sunday 24th September, 2023 at 13:11(UTC+0) by Alaxandar Georgiev
Level 6: 400/800 (800) Entries: 75/105
The €660 NLH Mystery Bounty Winner and WSOP Online Bracelet winner Ranno Sootla limped from the hijack and the player behind Khalid Dghaim raised to 50,000.
"Do you have a pair?" Sootla asked.
"Maybe," responded Dghaim while smiling.
Shortly after, Sootla called off his stack of 20,600.
Khalid Dghaim: Ranno Sootla:
Both faced the flop with a smile on their face and the dealer turned on the board, which was good so far for the bracelet winner.
The turn didn't help Dgaim, nor the brick on the river ending up in a good double up for the Estonian (pictured below).
Player
Chips
Progress
Ranno Sootla
43,200
29,800
Khalid Dghaim
38,000
8,000
Toomas "Stablecoinflip" Orm Wins OnlyBet Online Event #10 (€9,087) Posted Sunday 24th September, 2023 at 13:06(UTC+0) by Lina Olofsson
On Friday, Event #10: €350 NLH OlyBet Online Event was held here in WSOPC Tallinn but this time it wasn't at the Olympic Casino. It was actually online at OlyBet making it possible for players not to be able to attend this fantastic festival to compete and lay their hand on one of these beauties.
The €50,000 Guaranteed Online Event kicked off at 8 p.m. Friday night and attracted 124 entrants with 20 players cashing in this event. Up to this date, this is the single biggest prize in the OlyBet-exclusive tournament.
One hour into the tournament Toomas "Stablecoinflip" Orm decided to join the action and registered and this would turn out to be a very good decision as he ended up winning the whole thing. We got a chance to sit down and have a little chat with our latest Ring Event winner as he came into the Hilton Park and Olympic Casino to take his winning shot.
Great Start of Turning Pro - Again
Toomas Orm used to play professionally up until ten years ago but after a few hard years, he decided to stop and took a job as a salesman. It wasn't until the end of last year as he had a good run he decided it was time to give it another shot going pro again.
"I have two daughters and that makes you think differently at these things but as this year started I had built my bankroll up and felt comfortable to do this as a profession again," Orm explained.
This was the second €350 buy-in ring event he played during the WSOPC Tallinn as he also entered another event live here at the Olympic Casino. Even though Orm mostly plays no-limit hold'em tournaments online, he has $12,745 in live tournament winnings according to The Hendon Mob and one of his biggest tournament cash wasn't in a hold'em but instead in a pot-limit Omaha event in Malta earlier this year.
"I never play PLO but it was the very last day and I was bored so I took a shot in the very last tournament they had," Orm shared. "That was a Pot Limit Omaha and that was the first time I ever played it. When we were at the final table I started to feel a bit stressed though since it was really late and I had a flight to catch at seven in the morning."
Orm thought he'd have to book another flight back home to Estonian but eventually, they decided to make an ICM chop of the remaining prize money with five players left giving him the most money for €1,800, and as soon as he cashed out he ran off to the hotel, picked up his bag and took a cab to the airport where he came to the gate three minutes before the boarding closed.
But it's safe to say that playing on home soil is where he has his best track record with two big live cashes here from February earlier this year in the Main Event of the Estonian Championship finishing fifth for €3,600 and being runner up in the same championship in a Shootout tournament for another €2,278.
Five Bet Jam on Kosk Took Orm to the Lead
Back to the Online Ring Event the other night he started rocky and thought his days were counted but after first a double up and then a triple up he described the rest of the tournament as very smooth sailing. As he ended up at the table with his fellow Estonian countryman Ermo Kosk the latter tried to push him around but after a hand where Orm five-bet jammed against Kosk with only queen-jack suited and got away with it, he knew this was his tournament.
"I had some really nice rivers," shared Orm. "I was such an underdog and didn't even look at the screen as the board ran out several times but each time I looked up and magically survived. I screamed so many times so I was really happy my family wasn't home."
Loves to play Small Ball Poker
When half the field remained in the tournament Orm amassed a massive lead and as they entered the final table he still had a huge advantage. When the action whittled down to the last five players he had half the chips in play and then he was certain he would take it down as the others only had around ten big blinds each.
But when they started playing heads-up he was actually for the first time giving up his lead a few times but managed to get back up on the horse and when they were even in chips the two players decided to make a deal where they secured €9K each, left the ring and the WSOP Freeroll in Vegas up for grabs.
Even though the deal was made the Heads-up would last for an hour.
"I love playing small ball poker and that's exactly what we did," Orm shared.
At three o'clock in the morning his experience and his strategy with the small balling paid off as he was crowned as the winner.
It's safe to say that Orm has had a very nice return to the poker scene since he decided to take it up and make it a living again and now he has a trip to Vegas to look forward to next summer.
€350 WSOP Circuit Tallinn Online Ring Event top four:
Place
Name
Country
Prize
1
Toomas Orm
Estonia
€9,087 + WSOPC Ring
2
Stanislav S.
Estonia
€9,176
3
Kaspars Butans
Latvia
€6,020
4
Giedre Valgemae
Lithuania
€4,588
12:54 (UTC+0)
Start of Level 6 Blinds: 400/800 Ante: 800
Solidov Doubles Through Roshchebak Posted Sunday 24th September, 2023 at 12:36(UTC+0) by Alaxandar Georgiev
Level 5: 300/600 (600) Entries: 76/100
Maksim Solodilov jammed it all in from the button for 14,500 and Yevhen Roshchebak called from the small blind.
Maksim Solodilov: Yevhen Roshchebak:
The Estonian needed an ace or a seven against the pair of threes that Roshchebak had. He managed to hit on the flop and now the Ukrainian was the one behind.
No luck for Roshchebak on the turn and river, he couldn't take the bounty and is left with only 3,000 chips.
A few hands after the Ukrainen was knocked out.
Player
Chips
Progress
Maksim Solodilov
30,200
200
Yevhen Roshchebak
3,000
27,000
100 Players In The €660 NLH Progressive Bounty Posted Sunday 24th September, 2023 at 12:30(UTC+0) by Alaxandar Georgiev
The tournament has reached a hundred entries so far at the beginning of level 5. After this level, there are five more levels of late registration open. The average stack is 39,000 and the prize pool is up to €57,000.
The biggest stack is Einar Hersdal from Denmark with around 100,000 chips, he has claimed three bounties of €150 each adding up to €750 bounty on his own head. If someone knocks him out he will get €375 in cash and €375 added to their head.
12:20 (UTC+0)
Start of Level 5 Blinds: 300/600 Ante: 600
Bigger Stacks On The First Break Posted Sunday 24th September, 2023 at 12:17(UTC+0) by Alaxandar Georgiev
Players will return shortly from their first 20-minute break. Check out some of the bigger stacks down below.
Player
Chips
Progress
Einar Hersdal
100,000
70,000
Sebastian Wahl
90,000
60,000
Ranno Sootla
73,000
43,000
Martin Sedlak
61,000
31,000
Oskar Ojaveer
61,000
31,000
Jani Kalervo
60,000
30,000
Hendrick Uibo
52,000
22,000
Aleksei Smirnov
52,000
22,000
Klezys Loses Short Stack Posted Sunday 24th September, 2023 at 11:59(UTC+0) by Alaxandar Georgiev
Level 4: 200/500 (500) Entries: 69/86
We had six players called the 1,100 raise from Rasmus Lundstrom, one of them being Kasparas Klezys who just lost his stack to Martin Sedlak's flush and had exactly 1,100 left.
The flop was checked around by 3 players and action was on Dominik Ostrowski who quickly bet 7,000, everyone folded and Ostrowski was heads-up for Klezys's bounty.
Dominik Ostrowski: Kasparas Klezys:
Klezys looked amazed at how he was still ahead with so many players in the pot against Ostrowski's open-ended straight draw.
The turn came which paired the board. Klezys said "Please no eight" and the dealer put the on the river.
"Well, it wasn't an eight," Ostrowski said with a smile on his face while collecting his second bounty for €150.
Player
Chips
Progress
Dominik Ostrowski
45,000
15,000
Kasparas Klezys
0
0
11:35 (UTC+0)
Start of Level 4 Blinds: 200/500 Ante: 500
Flush for Tiri Posted Sunday 24th September, 2023 at 11:34(UTC+0) by Alaxandar Georgiev
Level 3: 200/400 (400) Entries: 66/79
Kelly Kellner, Raivo Pinsel (pictured below), and Andree Tiri were all involved after the first three cards were dealt , Kellner made a small bet, followed by a raise from Pinsel and an all-in from Tiri for 26,700 chips which Kellner folded to and Pinsel snap-called.
Raivo Pinsel: Andree Tiri:
Pinsel had a two-pair, while Tiri had the nut flush draw, he didn't manage to hit it on the turn but got additional out for a straight.
The river wasn't what Pinsel wanted to see as the dealer began to count the chips. No bounty for Tiri since he didn't cover Pinsel.
Player
Chips
Progress
Andree Tiri
58,000
28,000
Raivo Pinsel
4,300
25,700
11:06 (UTC+0)
Start of Level 3 Blinds: 200/400 Ante: 400
Koks Loses Short Stack to Sahli Posted Sunday 24th September, 2023 at 10:52(UTC+0) by Alaxandar Georgiev
Level 2: 100/300 (300) Entries: 60/63
Yanis Mehdi Sahli opened the pot and Andrey Koks was left with only 2,600 chips which he shoved all in followed by a call from Sebastian Wahl and the original raiser.
Sahli bet 2,000 on the flop and his opponent folded, the remaining two players went to a showdown.
Yanis Mehdi Sahli: Andrey Koks:
Koks was ahead and needed to hold it to the river. The turn looked promising, but the river completed Sahli's straight and he got one of the first bounties in the tournament.
Player
Chips
Progress
Yanis Mehdi Sahli
45,000
5,000
Andrey Koks
0
0
Early Entries in the Field Posted Sunday 24th September, 2023 at 10:33(UTC+0) by Alaxandar Georgiev
Check out some of the first players who registered for the €660 NLH Progressive Bounty event.
Player
Country
Dalius Ulevicius
Lithuania
Hanna Heinlo
Estonia
Jarmo Juhani Salonen
Finland
Klavs Garselis
Latvia
Johan Alen
Finland
Stanislovas Norkus
Lithuania
Mihails Morozovs
Latvia
Kelly Kellner
Canada
Oleh Bohdanov
Ukraine
Yi Zhan Peng
Taiwan
Martin Piik
Estonia
Oskar Ojaveer
Estonia
Dalius Ulevicius
Lithuania
Raivo Pinsel
Estonia
Egon Kaljulaid
Estonia
Eha Pinsel
Estonia
Einar Hersdal
Denmark
Vili Julius Vartinen
Finland
Taago Tamm
Estonia
Ville-Matti Keranen
Finland
Georgios Tsouloftas
Cyprus
Yevhen Roshchebak
Ukraine
Antonios Onoufriou
Cyprus
Hendrick Uibo
Estonia
Martin Sedlak
Germany
Igor Pihela (Sr.)
Estonia
Georgios Skarparis
Cyprus
Andres Abakanov
Estonia
Andrius Simonovicius
Lithuania
10:31 (UTC+0)
Start of Level 2 Blinds: 100/100 Ante: 100
Welcome to the €660 No-Limit Hold'em Progressive Bounty Posted Sunday 24th September, 2023 at 08:54(UTC+0) by Alaxandar Georgiev
The last ring event of our WSOP Circuit Tallinn will be given out to the winner of Event #12: €660 WSOPC Tallinn No-Limit Hold'em Progressive Bounty. Expect a lot of action and drama in the battle for the last ring.
Players start the tournament with 30,000 chips with blinds at 100/100 and increase every 30 minutes. Players will have 10 levels of late registration open to play for some bounties and take the glory of winning a ring event.
The tournament starts at noon and will have 20-minute breaks after each four levels. The OlyBet live reporting team will start live reporting this event shortly after it starts.
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 was spread. 
turn gave Zotovs a flush draw in addition to his pair of sixes. However, the 
river was a brick and Gorelik could celebrate his victory in Event #12.
and upgraded to a full house on the subsequent 
turn and 
river to secure his double-up.
runout, resulting in Sanders' third-place elimination at his second final table appearance during WSOPC Tallinn.
and Zotovs check-called a 75,000 bet from his opponent. Gorelik then continued the pressure by betting another 150,000 on the 
turn, which Zotovs again check-called.
.
.
, and the first final table elimination was a fact.
river gave him a meaningless straight. 
river were also safe for him and he raked in a big triple-up.
turn or 
and Burneikis was drawing dead on the 
runout and he added some more bounty chips to the stack in front of him.
£ GBP
$ USD
€ EUR
