0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-10-28'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/2/updates'
ORDER BY `views` DESC

0.0095 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-10-28'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_event/2/updates'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'

0.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.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0004 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0062 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.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` = 'kings_of_tallinn_autumn_2024_main_event'

0.0015 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'

0.0302 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0069 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '455'
AND `published` = 1

0.0295 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0062 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '457'
AND `published` = 1

0.0285 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '460'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '212'
AND `name` = '2'

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `busted` ASC, `current_chips` DESC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '455'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.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` = '19277'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19276'
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` = '19275'
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` = '19272'
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` = '19270'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19269'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19271'
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` = '19267'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19266'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19265'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19263'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19261'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19260'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19257'
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` = '19256'
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` = '19255'
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` = '19252'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19251'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19250'
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` = '19248'
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` = '19246'
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` = '19244'
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` = '19243'
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` = '19242'
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` = '19239'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19237'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19235'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19234'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19232'
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` = '19228'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19226'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19225'
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` = '19224'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19223'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19222'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19218'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19217'
ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19215'
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` = '19212'
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` = '19209'
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` = '19208'
ORDER BY `chip_change` DESC, `busted` ASC

0.0093 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19207'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19204'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19203'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19201'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19200'
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` = '19198'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19195'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19193'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19190'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19187'
ORDER BY `chip_change` DESC, `busted` ASC

0.0091 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19185'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19184'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19182'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19180'
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` = '19179'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19173'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19172'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19171'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19170'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19167'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19166'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19163'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19162'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19161'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19160'
ORDER BY `chip_change` DESC, `busted` ASC

0.0087 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19156'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19155'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19154'
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` = '19153'
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` = '19150'
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` = '19149'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19148'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19146'
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` = '19145'
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` = '19142'
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` = '19140'
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` = '19137'
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` = '19135'
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` = '19133'
ORDER BY `chip_change` DESC, `busted` ASC

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19131'
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` = '19130'
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` = '19127'
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` = '19125'
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` = '19124'
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` = '19122'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19121'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19113'
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` = '455'
ORDER BY `busted` ASC, `current_chips` DESC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.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` = '19277'
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` = '19276'
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` = '19275'
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` = '19272'
ORDER BY `chip_change` DESC, `busted` ASC

0.0131 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19270'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19269'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19271'
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` = '19267'
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` = '19266'
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` = '19265'
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` = '19263'
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` = '19261'
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` = '19260'
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` = '19257'
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` = '19256'
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` = '19255'
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` = '19252'
ORDER BY `chip_change` DESC, `busted` ASC

0.0096 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19251'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19250'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19248'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19246'
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` = '19244'
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` = '19243'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19242'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19239'
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` = '19237'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19235'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19234'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19232'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19228'
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` = '19226'
ORDER BY `chip_change` DESC, `busted` ASC

0.0090 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19225'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19224'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19223'
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` = '19222'
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` = '19218'
ORDER BY `chip_change` DESC, `busted` ASC

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19217'
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` = '19215'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19212'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19209'
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` = '19208'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19207'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19204'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19203'
ORDER BY `chip_change` DESC, `busted` ASC

0.0140 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19201'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19200'
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` = '19198'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19195'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19193'
ORDER BY `chip_change` DESC, `busted` ASC

0.0074 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19190'
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` = '19187'
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` = '19185'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19184'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19182'
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` = '19180'
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` = '19179'
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` = '19173'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19172'
ORDER BY `chip_change` DESC, `busted` ASC

0.0090 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19171'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19170'
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` = '19167'
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` = '19166'
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` = '19163'
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` = '19162'
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` = '19161'
ORDER BY `chip_change` DESC, `busted` ASC

0.0081 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19160'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19156'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19155'
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` = '19154'
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` = '19153'
ORDER BY `chip_change` DESC, `busted` ASC

0.0066 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19150'
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` = '19149'
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` = '19148'
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` = '19146'
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` = '19145'
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` = '19142'
ORDER BY `chip_change` DESC, `busted` ASC

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19140'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19137'
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` = '19135'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19133'
ORDER BY `chip_change` DESC, `busted` ASC

0.0060 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19131'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19130'
ORDER BY `chip_change` DESC, `busted` ASC

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19127'
ORDER BY `chip_change` DESC, `busted` ASC

0.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` = '19125'
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` = '19124'
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` = '19122'
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` = '19121'
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` = '19113'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '455'
ORDER BY `busted` ASC, `current_chips` DESC

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '457'
ORDER BY `busted` ASC, `current_chips` DESC

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '460'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(0)
  • 888poker UK Poker League(0)
  • APAT(3)
  • APPT(1)
  • Aria Resort & Casino(0)
  • Asian Poker Tour(2)
  • Aspers Casino Westfield Stratford City(2)
  • Battle Of Malta(1)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(6)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(2)
  • EPT(1)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(0)
  • Grosvenor Poker 25/50(10)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(2)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(2)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(0)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(9)
  • Moneymaker Tour(1)
  • North American Poker Tour(1)
  • OlyBet Showdown(0)
  • Olympic Park Casino(1)
  • Orleans Summer Open(0)
  • Poker GO Tour(0)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • RDS (Royal Dublin Society)(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Casino at Portomaso(3)
  • The Festival(1)
  • The Poker Room(0)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(1)
  • Unibet DeepStack Open(4)
  • Venetian Deepstack Extravaganza(3)
  • Women's Winter Festival(1)
  • WPT(5)
  • WPT Alpha 8(0)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(7)
  • WSOP International Circuit(2)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(0)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF
  • Main Event Travel Gift Vouchers
  • Malta Poker Festival FinalTableFreeroll

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

Kings of Tallinn Autumn Edition 2024 Event #31: Kings of Tallinn €1,100 Main Event Live Reporting - Day 4

Kings of Tallinn Autumn Edition 2024 - Live Reporting

Event #31: Kings of Tallinn €1,100 Main Event See other events

Event #20 €555 NLH Kings of Tallinn Championship Event #27 €5,000 NLH Progressive Bounty Event #31: Kings of Tallinn €1,100 Main Event Event #52: €3,000 NLH Event #20 €555 NLH Kings of Tallinn Championship (Finnish) Event #31: Kings of Tallinn €1,100 Main Event (Finnish) Event #52: €3,000 NLH (Finnish)

Kings of Tallinn Autumn Edition 2024 - Live Reporting Event #20 €555 NLH Kings of Tallinn Championship Event #27 €5,000 NLH Progressive Bounty Event #31: Kings of Tallinn €1,100 Main Event Event #52: €3,000 NLH Event #20 €555 NLH Kings of Tallinn Championship (Finnish) Event #31: Kings of Tallinn €1,100 Main Event (Finnish) Event #52: €3,000 NLH (Finnish)

---

Current Level 34 Current Day 4

---

Blinds 125,000/250,000 Ante 250000

Entries 701 Remaining 1

---

Prize Pool (EUR) €658,940 First Prize (EUR) €130,300

Chip Leaders Day 4

1

Mathias Siljander

21,025,000

Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

00:51 (UTC+0)

Day 2 of Kings of Tallinn Autumn Edition 2024 Ended
Level: 19     Blinds: 4,000/8,000     Ante: 8,000

Rolandas Aglinskas Ends Extended Day 2 of €1,100 Main Event as Bubble Boy; 87 Progress Posted Saturday 26th October, 2024 at 00:51(UTC+0) by Frank Visser

It was a long day at Olympic Park Casino today. After 13 hours of play, the bubble in the Kings of Tallinn: Autumn Edition €1,100 Main Event had burst, securing the 87 surviving players a share of the €658,940 prize pool. But one man's gain is another man's loss, and this time it was Rolandas Aglinskas who was on the losing side. The Lithuanian player spent 13 hours playing his heart out only to end up in 88th place as the stone bubble after he was a big favorite preflop.

Immediately after Aglinskas' departure, the remaining 87 bagged up for Day 3. Serhii Leonov from Ukraine profited the most from the bubble, being the only player to bag a seven-figure stack. He grabbed the chip lead with 1,052,000, more than four times the average stacks, and a whopping 132 big blinds at the start of Day 3.

Leonov already had a respectable stack throughout the later part of the day, but he really started climbing the ranks when he picked off an overbet bluff by fellow top ten stack Angel Alonso on the soft bubble. He then spent the next 80 minutes exerting bubble pressure to end up with his massive pile of chips.

Meanwhile, Finnish regular Elias Suhonen was the only other player to end up with more than 100 big blinds as he ended the day with 896,000. Greek player Enea Subashi completes the top three with a stack of 712,000 while Luka Sorainen, Estonia's biggest stack Ranno Sootla, and Mitchell Hynam also secured a spot in the top ten.

End of Day 2 Top Ten Chip Counts

Rank	Player	Country	Chip Count	Big Blinds
1	Serhii Leonov	Ukraine	1,052,00	132
2	Elias Suhonen	Finland	896,000	112
3	Enea Subashi	Greece	712,000	89
4	Angel Alonso	Spain	665,000	83
5	Tommy Piiroinen	Finland	653,000	82
6	Luka Sorainen	Finland	573,000	72
7	Ranno Sootla	Estonia	562,000	70
8	Mitchell Hynam	United Kingdom	552,000	69
9	Vu Vuong	Finland	550,000	69
10	Dmitrijs Petrenko	Latvia	536,000	67

Among the other survivors are Max Sanders (310,000), Gytis Lazauninkas (246,000), Sebastian Wahl (238,000), Jari Mahonen (80,000), Roope Tarmi (79,000), Henri Ojala (53,000), and Tarmo Tammel (19,000).

Day 2 Action

Day 2 started with four levels of late registration still to go. After it had closed, the clock read 701 entries, of which 214 still remained. Quick goodbyes were said to €555 Championship runner-up Rasmus Lundstrom, Norwegian mixed game crusher Espen Sandvik, and Estonian poker mainstays Igor Pihela Sr. and Igor Pihela Jr.

Joshua Stewart, Juha Helppi, Aleksi Naski, and Markku Koplimaa also fell outside the top 100. The pace of play then slowed down significantly as the bubble kept creeping closer. Ermo Kosk was among the chipleaders with 105 left but was eliminated in 92nd about 90 minutes later. Gediminas Zimaitis fell in 90th and hand-for-hand play began shortly after, with two eliminations to go before the money.

It only took around 15 minutes to lose the first player when Ignas Navickas shoved his last chips into Subashi. However, the stone bubble lasted for no less than 45 minutes. In fact, Day 2 was supposed to end after Level 18 had been completed, but the tournament directors decided to play out the bubble, and Level 19 was reached.

Ultimately, it was in that level that Aglinskas became the bubble boy. His king-jack lost against the jack-seven of Samuli Segerman as a wave of relief and celebration went through the tournament room. The 87 remaining players had secured a min-cash of €2,200, but the big stacks will be more concerned with the massive €130,300 reserved for the eventual champion.

€1,100 Main Event Payouts

Place	Prize
1	€130,300
2	€83,400
3	€55,200
4	€40,250
5	€30,450
6	€22,540
7	€17,400
8	€14,400
9	€11,800
10-11	€9,400
12-13	€7,200
14-15	€5,600
16-23	€4,300
24-31	€3,600
32-39	€3,200
40-55	€2,800
56-71	€2,500
72-87	€2,200

Day 3 will commence tomorrow, October 26, at noon local time. Play will resume in Level 19: 4,000/8,000 with an 8,000 big blind ante. There are 52 minutes and 58 seconds remaining in said level, after which each subsequent level will last for 60 minutes.

The exact plan for Day 3 is not yet known, so be sure to check back in tomorrow as an exciting post-bubble bust-out bonanza is awaiting the prestigious Main Event.

End of Day 2 Chip Counts Posted Friday 25th October, 2024 at 23:58(UTC+0) by Frank Visser

Player		Chips	Progress
Serhii Leonov		1,052,000	272,000
Elias Suhonen		896,000	296,000
Enea Subashi		712,000	47,000
Angel Alonso		665,000	25,000
Tommy Piiroinen		653,000	333,000
Luka Sorainen		573,000	32,000
Ranno Sootla		562,000	0
Mitchell Hynam		552,000	0
Vu Vuong		550,000	51,000
Dmitrijs Petrenko		536,000	271,000
Josep Pastor		497,000	375,500
Julius Kettunen		481,000	46,000
Kalle Parkkinen		481,000	22,000
Borge Dypvik		420,000	5,000
Krisjanis Lauks		416,000	1,000
Egidijus Digrys		412,000	78,000
Jae Han Kim		409,000	199,000
Jose Domene		404,000	59,000
David Bright		385,000	93,000
Aivaras Kerusauskas		383,000	33,000
Eero Abbey		379,000	44,000
Daniel Clifford		371,000	0
Kristiana Stauere		349,000	209,000
Simon Hassan		329,000	129,000
Kristaps Sipols		318,000	272,000
Kasper Mellanen		317,000	57,000
Max Sanders		310,000	110,000
Albert Ostrovskij		287,000	18,000
Vadim Guk		285,000	200,000
Bahadir Hatipoglu		280,000	152,500
Artur Kulanurk		276,000	46,000
Jawad Habib		268,000	156,000
Edas Cimbolas		265,000	80,000
Pekka Ikonen		257,000	150,200
Kaius Kiidli		256,000	24,000
Jarkko Suokas		252,000	22,000
Gytis Lazauninkas		246,000	166,000
Edward Quinn		245,000	0
Sebastian Wahl		238,000	80,000
Jenny Westerlund		210,000	35,000
Martynas Saltis		209,000	39,000
Dmitri Dudakov		193,000	92,000
Vasy Laba		190,000	23,000
Adrian Luezas		183,000	102,000
Aku-Oskari Uotila		160,000	140,000
Samuli Segerman		150,000	2,000
Andrius Janca		147,000	133,000
Roman Jezov		130,000	30,000
Gert Laanemets		125,000	125,000
Rolands Norietis		120,000	13,000
Aleksandr Januskevic		120,000	0
Ruslan Stserbjuk		114,000	0
Andrejs Perederejevs		109,000	71,000
Stanislovas Vinicenka		106,000	51,000
Kaspars Renga		105,000	20,000
Klaudijus Bajoras		105,000	95,000
Mantas Stikelis		105,000	145,000
Gintaras Naglius		88,000	53,700
Jussi Hietalahti		85,000	30,000
Mikael Haapaniemi		81,000	84,000
Jari Mahonen		80,000	0
Stanislav Smeljov		80,000	67,000
Mathias Siljander		79,000	1,000
Roope Tarmi		79,000	101,000
Kim Rasmussen		77,000	22,000
Taago Tamm		77,000	38,000
Joonas Helin		74,000	116,000
Mark Metsla		68,000	3,000
Koray Korkmaz		67,000	8,000
Robert Kallikorm		66,000	134,000
Roberts Rumba		63,000	12,000
Miki Vea		62,000	0
Gonzalo Salinas		60,000	0
Mindaugas Kriaciunas		59,000	47,000
Johan Alen		56,000	0
Henri Ojala		53,000	172,000
Irmantas Rulis		50,000	0
Andzej Bilat		45,000	0
Bartosz Mielczarek		36,000	329,000
Edikas Jurgutis		34,000	56,000
Frederik Brink		32,000	37,000
Aleksei Gontsar		21,000	69,000
Tarmo Tammel		19,000	41,000
Oskar Silins		19,000	117,000
Hai Hoang		12,000	68,000

Day 2 Concludes Posted Friday 25th October, 2024 at 23:09(UTC+0) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 87/701

After an extended Day 2, the bubble of the Main Even has burst and the 87 remaining players have bagged their chips up.

Stay tuned for full chip counts and a recap of the day.

Rolandas Aglinskas Eliminated as Bubble Boy Posted Friday 25th October, 2024 at 23:04(UTC+0) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 88/701

Rolandas Aglinskas put his last 26,000 in from early position. The table then folded to Samuli Segerman in the big blind, who called.

Rolandas Aglinskas:
Samuli Segerman:

Aglinskas was in the best position he could be, dominating his opponent. The flop brought him no trouble, but the room fell dead silent as the turn gave Segerman a flush draw.

Aglinskas slammed his chair as the river arrived. Segerman had made a flush and the room exploded in cheers and applause. Aglinskas was the last to leave the room empty-handed as 87 players bagged up for Day 3.

Player		Chips	Progress
Samuli Segerman		152,000	22,000
Rolandas Aglinskas		0	0

Dypvik Shoves on Siljander Posted Friday 25th October, 2024 at 22:51(UTC+0) by Frank Visser

Level 19: 4,000/8,000 (8,000)
Entries: 88/701

Borge Dypvik in the hijack and Mathias Siljander in the cutoff had created a pot of 90,000 when they both checked through the flop.

The emerged from the deck on the turn and saw Dypvik put Siljander all-in for 80,000. Siljander made a quick fold as the bubble continued.

Player		Chips	Progress
Borge Dypvik		425,000	85,000
Mathias Siljander		80,000	50,000

22:50 (UTC+0)

Start of Level 19
Blinds: 4,000/8,000     Ante: 8,000

Bubble Trouble? No, Bubble Triple! Posted Friday 25th October, 2024 at 22:38(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 88/701

Roberts Rumba had pushed his final chips in on a flop of . Aivaras Kerusauskas called in middle position and Julius Kettunen did so in the small blind, creating a pot of 75,000

The pair then checked through the turn and river for the side pot, and a showdown was had. Kerusauskas tabled for a pair of sixes while Kettunen showed for a pair of nines.

Rumba had the best hand with , however, and he let out a maniacal laugh while tripling up with his flush.

Player		Chips	Progress
Julius Kettunen		435,000	130,000
Aivaras Kerusauskas		350,000	200,500
Roberts Rumba		75,000	11,000

Kiidli Gets Some Value Posted Friday 25th October, 2024 at 22:30(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 88/701

Samuli Segerman checked from the big blind to Kaius Kiidli in the hijack on a turn of . He then bet 16,000 and Segerman put in a call.

The river was checked down. Segerman tabled for bottom pair and lost some chips to the of Kiidli, who won the pot with top pair.

Player		Chips	Progress
Kaius Kiidli		280,000	10,000
Samuli Segerman		130,000	20,000

Nada for Navickas Posted Friday 25th October, 2024 at 22:15(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Ignas Navickas had shoved all in for 25,000 in the hijack. Enea Subashi called in the cutoff and the cards went open once all other tables had finished.

Ignas Navickas:
Enea Subashi:

Navickas was slightly ahead and gained a bigger lead once the flop missed Subashi. The turn paired the Greek up, however, and the river could not save Navickas from being eliminated.

The field was left with 88 players, which means it had arrived on the stone bubble.

Player		Chips	Progress
Enea Subashi		665,000	150,000
Ignas Navickas		0	0

First All-In and Call Sees Brink Bink Posted Friday 25th October, 2024 at 22:08(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Frederik Brink open-jammed his last 27,000 under the gun. It folded to Kim Rasmussen in the big blind, who called off.

Frederik Brink:
Kim Rasmussen:

Brink needed to fade a nine to stay in contention for a cash, and he did so when the board brought him no trouble.

Player		Chips	Progress
Frederik Brink		69,000	70,600
Kim Rasmussen		55,000	103,800

Sorainen Puts Max-Imum Bubble Pressure Posted Friday 25th October, 2024 at 21:58(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Small blind Max Sanders checked on a completed board of . Big blind Luka Sorainen then put Sanders all-in for 200,000, a bet worth twice the pot.

Sanders spent some minutes as he agonizingly went over the hand but he ultimately decided to fold and the next hand was dealt.

Player		Chips	Progress
Luka Sorainen		605,000	80,000
Max Sanders		200,000	25,000

Tamm Doubles as Hand-for-Hand Begins Posted Friday 25th October, 2024 at 21:52(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 89/701

Taago Tamm open-shoved his button for 53,000. Ignas Navickas slowly peeled his cards in the big blind, thought for some time, and then called.

Taago Tamm:
Ignas Navickas:

It was looking like Tamm would be eliminated as the penultimate player without cash, especially when the flop brought no help.

However, he made a runner-runner flush on the runout, doubling up and leaving Navickas with less than five big blinds.

After the hand, the floor announced that the tournament would go hand-for-hand with 89 players remaining. The day will not finish before the money is reached, even if that means an extra level is needed.

Player		Chips	Progress
Taago Tamm		115,000	65,000
Ignas Navickas		23,000	82,000

Zimaitis Falls to Leonov's Surge Posted Friday 25th October, 2024 at 21:43(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 90/701

Gediminas Zimaitis got his final 37,000 in from the big blind against Serhii Leonov in the hijack.

Gediminas Zimaitis:
Serhii Leonov:

Leonov was the only player to pair his hole cards on the board and eliminated Zimaitis three spots from the money.

Player		Chips	Progress
Serhii Leonov		780,000	30,000
Gediminas Zimaitis		0	0

Leonov and Alonso Play for Piles Posted Friday 25th October, 2024 at 21:39(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 90/701

Serhii Leonov (pictured) in the big blind and Angel Alonso under the gun had already inflated the pot to 100,000 by the time the turn was dealt. Leonov then checked and Alonso put in an overbet of 150,000.

Undeterred, Leonov called to the river, which went check-check. Leonov showed for second pair and took down the pot when Alonso's cards hit the muck.

Player		Chips	Progress
Serhii Leonov		750,000	250,000
Angel Alonso		690,000	188,000

Ostrovskij Hero Calls Westerlund at Crucial Stage Posted Friday 25th October, 2024 at 21:29(UTC+0) by Frank Visser

Level 18: 3,000/6,000 (6,000)
Entries: 91/701

Arriving on a completed board of , Albert Ostrovskij checked form the small blind to Jenny Westerlund in the hijack.

Westerlund fired 50,000 into the pot of 80,000, sending Ostrovskij into the tank. After five minutes or so, he slammed in a call.

"Good call," Westerlund said as she sheepishly showed . Ostrovskij tabled for third pair and raked in the important pot.

Player		Chips	Progress
Albert Ostrovskij		305,000	253,000
Jenny Westerlund		175,000	212,000

21:16 (UTC+0)

Start of Level 18
Blinds: 3,000/6,000     Ante: 6,000

Getting Tantalizingly Close to the Money Posted Friday 25th October, 2024 at 21:14(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 91/701

Player		Chips	Progress
Ermo Kosk		0	0
Vasilijus Piskunovas		0	0
Danel Kunman		0	0

Nobody Expects the Spanish Inquisition, Not Even the Spanish Posted Friday 25th October, 2024 at 21:10(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 93/701

Adria Comas jammed all in for 53,000 in early position. The action folded to his fellow countryman Jose Domene, who called off after some thinking time.

Adria Comas:
Jose Larios:

Comas could not pair up on the board, sending him out six away from the money.

Player		Chips	Progress
Jose Domene		345,000	55,000
Adria Comas		0	0

Tamm Left Short on Soft Bubble as Wahl Doubles Posted Friday 25th October, 2024 at 21:02(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 93/701

Sebastian Wahl got his 74,000 in preflop from the hijack against Taago Tamm (pictured) in the small blind.

Sebastian Wahl:
Taago Tamm:

Wahl faded the ace on the runout, doubling him up. Tamm, meanwhile, was left with exactly ten big blinds.

Player		Chips	Progress
Sebastian Wahl		158,000	31,000
Taago Tamm		50,000	50,000

Asking Nicely Not Enough for Ajamaa Posted Friday 25th October, 2024 at 20:54(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 95/701

Krisjanis Lauks raised to 10,000 in the hijack. Kaur Ajamaa then committed his stack of 40,000 from the cutoff and Lauks called after some thinking time.

Kaur Ajamaa:
Krisjanis Lauks:

Ajamaa was a big favorite to double up, but the flop left him shaking his head. The offered him no improvement.

"Ace, please," he asked calmly before the river completed the board. No ace fell, and Ajamaa was eliminated just a few spots from the money.

Player		Chips	Progress
Krisjanis Lauks		415,000	85,000
Kaur Ajaama		0	0

Departures Since Break Posted Friday 25th October, 2024 at 20:47(UTC+0) by Frank Visser

Player		Chips	Progress
Mykhailo Mikhalov		0	0
Karolis Kutkauskas		0	0

Rasins Picks Wrong Time to Hero Posted Friday 25th October, 2024 at 20:45(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 99/701

Andris Rasins checked in early position on a completed board of . With a modest pot of 65,000 in the middle, Luka Sorainen over-bet all in.

Rasins snap-called for his stack of 80,000 and showed . However, Sorainen tabled for a set of eights and knocked Rasins out a dozen spots from the money.

Player		Chips	Progress
Luka Sorainen		525,000	35,000
Andris Rasins		0	0

Kettunen Takes It on Turn Posted Friday 25th October, 2024 at 20:32(UTC+0) by Frank Visser

Level 17: 2,000/5,000 (5,000)
Entries: 101/701

Rolands Norietis raised to 12,000 in middle position. Julius Kettunen three-bet to 45,000 in the small blind and Norietis called.

Kettunen continued for 30,000 on the board, which Norietis called. The fell on the turn and saw Kettunen size up to 55,000.

Norietis had seen enough and quickly let go of his hand as he forfeited the pot.

Player		Chips	Progress
Julius Kettunen		305,000	160,000
Jose Domene		290,000	247,000
Klaudijus Bajoras		200,000	157,700
Rolands Norietis		107,000	98,000
Aleksei Gontsar		90,000	27,500
Edikas Jurgutis		90,000	195,000
Koray Korkmaz		75,000	41,000
Adria Comas		60,000	32,600

20:16 (UTC+0)

Start of Level 17
Blinds: 2,000/5,000     Ante: 5,000

Late-Night Leaders Posted Friday 25th October, 2024 at 20:10(UTC+0) by Frank Visser

Player		Chips	Progress
Vu Vuong		601,000	181,000
Elias Suhonen		600,000	328,000
Kristaps Sipols		590,000	90,000
Enea Subashi		515,000	105,000
Angel Alonso		502,000	28,000
Serhii Leonov		500,000	290,000
Egidijus Digrys		490,000	150,000
Kalle Parkkinen		459,000	324,000

Final Break of Day 2 Posted Friday 25th October, 2024 at 19:57(UTC+0) by Frank Visser

The 103 remaining players have been sent on their last 20-minute break of the night.

When they return, two more 60-minute levels will be played before the survivors bag up for Day 3.

Pre-Break Bust-Outs Posted Friday 25th October, 2024 at 19:55(UTC+0) by Frank Visser

Player		Chips	Progress
Zahid Bhuiyan		0	0
Kris Tikka		0	0

Kosk Wins Massive Three-Way Three-Bet Pot Posted Friday 25th October, 2024 at 19:44(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 105/701

Serhii Leonov had open-raised from early position and Ermo Kosk had called in the hijack. Aku-Oskari Uotila then put in a three-bet from the big blind, which both Leonov and Kosk called.

Once the flop graced the table, the pot had already grown to 90,000. Uotila continued for 18,000 and saw two calls once again. He then sized up to 40,000 on the turn, but again neither opponent got out of the way.

The river completed a flush draw, and it checked to Kosk, who bet 100,000. Uotila quickly mucked while Leonov took about 30 seconds to put his opponent on exactly jack-ten of spades. He consequently folded, showing the as he did so.

Player		Chips	Progress
Angel Alonso		530,000	165,000
Ermo Kosk		474,000	329,000
Aku-Oskari Uotila		300,000	15,000
Serhii Leonov		210,000	35,000
Joonas Helin		190,000	40,000
Roope Tarmi		180,000	105,000
Stanislav Smeljov		147,000	0
Gediminas Zimaitis		77,000	133,000
Tarmo Tammel		60,000	53,000

Berggren Starts Trek Home Posted Friday 25th October, 2024 at 19:29(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 110/701

In a three-bet pot worth around 50,000, David Berggren checked from middle position to preflop aggressor Adrian Luezas in the cutoff.

The flop read , and Luezas made a bet of 19,000. Berggren then quickly raised all in for 75,000 and was snapped off.

David Berggren:
Adrian Luezas:

Berggren was pipped. The turn provided some hope with a flush draw, but the river changed nothing. Berggren saw his chips being added to Luezas' stack and headed to the exit.

Player		Chips	Progress
Adrian Luezas		285,000	125,000
David Berggren		0	0

Rumba Hoovers Up Double-Up Posted Friday 25th October, 2024 at 19:16(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 113/701

Roberts Rumba open-jammed his 27,000 chips and was called by his neighbor Sauli Haapaniemi. 

Roberts Rumba:
Sauli Haapaniemi:

"Good luck, but to be honest, I hope you don't win," Haapaniemi said.

However, Rumba would win when the flop paired him up and the runout bricked out, doubling him up

Player		Chips	Progress
Sauli Haapaniemi		130,000	8,000
Roberts Rumba		64,000	51,000

Further Bust-Outs Posted Friday 25th October, 2024 at 19:09(UTC+0) by Frank Visser

Player		Chips	Progress
Jarmo Salonen		0	0
Aleksi Naski		0	0
Jonatan Fors		0	0
Justina Andriukeviciute		0	0
Ismo Barlund		0	0
Michael Engstrom		0	0
Risto Parnat		0	0
Rytis Pranarauskas		0	0
Daniel Smith		0	0

Iodis Falls into Lauks' Trap Posted Friday 25th October, 2024 at 19:03(UTC+0) by Frank Visser

Level 16: 2,000/4,000 (4,000)
Entries: 123/701

Max Sanders had raised in early position and Krijanis Lauks (pictured) called in the small blind. Kanstantsin Iodis then jammed all in for 29,000. Sanders called but Lauks had other plans and back-raised to 89,000.

Sanders was baffled and thought for a while before mucking his hand.

Kanstantsin Iodis:
Krijanis Lauks:

"Wow, you did trap me!" Sanders exclaimed surprised. Meanwhile, the runout could not crack Lauks' kings and Iodis hit the rail.

Player		Chips	Progress
Krisjanis Lauks		330,000	40,000
Max Sanders		225,000	25,000
Kanstantsin Iodis		0	0

18:58 (UTC+0)

Start of Level 16
Blinds: 2,000/4,000     Ante: 4,000

Start-of-Day Leader Koistinen Bluffs Final Chips Off Posted Friday 25th October, 2024 at 18:58(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 125/701

Big blind Mikael Koistinen was checked to on a turn of by Dmitrijs Petrenko. He decided to bet 18,000 into the 33,000 pot, which Petrenko called.

The river brought the . Petrenko checked again, after which Koistinen jammed all in for 37,000. Petrenko mulled it over for 30 seconds or so but ultimately made the call.

Koistinen stood up and showed for king-high. Petrenko showed for top pair and knocked the start-of-day chipleader out before the money.

Player		Chips	Progress
Dmitrijs Petrenko		265,000	60,000
Mikael Koistinen		0	0

Saviaho Surrenders Final Chips Posted Friday 25th October, 2024 at 18:42(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 131/701

Jari Saviaho jammed his last 25,000 on the button and was looked up by Jussi Hietalahti in the big blind.

Jari Saviaho:
Jussi Hietalahti:

The runout did not bring a king, sendeing Saviaho to the rail.

Player		Chips	Progress
Jussi Hietalahti		115,000	94,800
Jari Saviaho		0	0

Juha Helppi Among Recent Eliminations Posted Friday 25th October, 2024 at 18:36(UTC+0) by Frank Visser

Player		Chips	Progress
Elias Vaaraniemi		0	0
Juha Helppi		0	0
Martin Keskkula		0	0
Sergei Kuznetsov		0	0
Erik Byhlin		0	0
Joonas Lyttinen		0	0
Jamie Dwan		0	0

Petrenko and Haapaniemi Play Friendly Three-Bet Pot Posted Friday 25th October, 2024 at 18:32(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 137/701

Dimitijs Petrenko in early position checked to three-better Mikael Haapaniemi (pictured) in the cutoff. He bet a measly 5,000 into a pot of 45,000 with a flop of on the table.

Petrenko called before the turn and river were checked through. Haapaniemi showed for top pair, but Petrenko had the better kicker and won the pot with .

Player		Chips	Progress
Dmitrijs Petrenko		205,000	175,000
Mikael Haapaniemi		165,000	42,300

Kerusauskas Holds to Double Posted Friday 25th October, 2024 at 18:25(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 140/701

Aivaras Kerusauskas in the hijack had three-bet Sauli Haapaniemi in early position preflop. Haapaniemi had called and checked the flop to Kerusauskas.

Kerusauskas then added 15,000 to the pot of 41,500, after which Haapaniemi quickly moved all in. Kerusauskas sighed but made a quick call for his stack of 54,000 regardless.

Aivaras Kerusauskas:
Sauli Haapaniemi:

Kerusauskas had the superior pair, and while the turn brought Haapaniemi a gutshot, the river gave him a set to double up.

Player		Chips	Progress
Aivaras Kerusauskas		149,500	49,500
Sauli Haapaniemi		122,000	68,000

Tarmi's Chips Get Flushed to Uotila Posted Friday 25th October, 2024 at 18:11(UTC+0) by Frank Visser

Level 15: 1,500/3,000 (3,000)
Entries: 146/701

The action was picked up on a completed board of . Aku-Oskari Uotila (pictured) checked from the big blind to Roope Tarmi under the gun. Tarmi bet 35,000 into a pot of 30,000, which Uotila raised to 95,000.

Tarmi spent some time in the tank but ultimately called off. Uotila tabled for a flush and Tarmi's cards flew into the muck in defeat.

Player		Chips	Progress
Aku-Oskari Uotila		315,000	209,200
Roope Tarmi		75,000	1,000

17:56 (UTC+0)

Start of Level 15
Blinds: 1,500/3,000     Ante: 3,000

Assorted Dinner Counts Posted Friday 25th October, 2024 at 17:56(UTC+0) by Frank Visser

Player		Chips	Progress
Kristaps Sipols		500,000	437,000
Luka Sorainen		490,000	10,000
Vu Vuong		420,000	240,000
Enea Subashi		410,000	160,000
Jenny Westerlund		387,000	290,000
Bartosz Mielczarek		365,000	329,700
Angel Alonso		365,000	85,000
Borge Dypvik		340,000	200,000
Eero Abbey		335,000	70,000
Tommy Piiroinen		320,000	219,000
Kaius Kiidli		290,000	141,900
Krisjanis Lauks		290,000	15,000
Dmitri Dudakov		285,000	75,000
Edikas Jurgutis		285,000	61,000
Andrius Janca		280,000	230,000
Rytis Strigunas		275,000	86,300
Elias Suhonen		272,000	175,300
Kasper Mellanen		260,000	168,000
Gert Laanemets		250,000	0
Mantas Stikelis		250,000	20,000
Jarkko Suokas		230,000	200,000
Ismo Barlund		225,000	185,500
Henri Ojala		225,000	150,000
Jae Han Kim		210,000	180,000
Simon Hassan		200,000	152,600
Robert Kallikorm		200,000	90,200
Sauli Haapaniemi		190,000	136,500
Vasilijus Piskunovas		190,000	15,000
Edas Cimbolas		185,000	64,900
David Berggren		180,000	83,300
Martynas Saltis		170,000	12,500
Adrian Luezas		160,000	27,000
Aleksi Naski		160,000	20,000
Stanislav Smeljov		147,000	43,700
Julius Kettunen		145,000	115,000
Ermo Kosk		145,000	107,200
Daniel Smith		140,000	110,000
Martin Keskkula		135,000	25,200
Kalle Parkkinen		135,000	20,500
Zahid Bhuiyan		130,000	100,000
Sebastian Wahl		127,000	89,000
Kaspars Renga		125,000	85,000
Roberts Rumba		115,000	85,000
Ignas Navickas		105,000	50,000
Risto Parnat		105,000	12,300
Taago Tamm		100,000	70,000
Roman Jezov		100,000	64,400
Aivaras Kerusauskas		100,000	63,900
Vadim Guk		85,000	1,200
Hai Hoang		80,000	2,500
Michael Engstrom		65,000	35,000
Gonzalo Salinas		60,000	1,600
Stanislovas Vinicenka		55,000	25,000
Andrej Koriakin		55,000	49,200
Joonas Lyttinen		53,000	66,000
Mathias Siljander		30,000	12,800

Dinner Bell Rings Posted Friday 25th October, 2024 at 16:58(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 149/701

The remaining players have been sent on a 60-minute dinner break.

The tournament is expected to resume at 7:55 p.m. local time.

Alonso Jams River in Four-Bet Pot Posted Friday 25th October, 2024 at 16:57(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 151/701

Serhii Leonov had open-raised from the cutoff when Angel Alonso three-bet to 14,000 on the button. Leonov then made it 35,000 to go, which Alonso called.

Leonov fired 27,000 on the flop, receiving a call from Alonso. The turn was checked through before Leonov made a bet of 45,000 on the river.

Alonso pondered momentarily and then shoved all in for 150,000. Leonov took one last look at his cards before sending them to the muck, giving up on the pot.

Player		Chips	Progress
Angel Alonso		280,000	167,800
Serhii Leonov		175,000	75,000

Recent Eliminations Posted Friday 25th October, 2024 at 16:45(UTC+0) by Frank Visser

Player		Chips	Progress
Igor Pihela Sr.		0	0
Andre Magi		0	0
Joona Tuomi		0	0
Justas Vaiciulionis		0	0
Vismands Menjoks		0	0
Nils Linden		0	0
Juho Harkonen		0	0

Lauks Knocks Out Two Posted Friday 25th October, 2024 at 16:36(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 159/701

Audrius Navickas had raised preflop, after which Marius Morel jammed for about 25,000. Krisjanis Lauks (pictured) called cold, after which Navickas four-bet all in for 115,000.

Lauks snap-called with the covering stack, tabling all three holdings.

Marius Morel:
Audrius Navickas:
Krisjanis Lauks: 

The runout gave all players a full house, but Lauks' aces remained best as he eliminated both opponents.

"Man, I wish I got aces against kings," monster stack Luka Sorainen jokingly quipped.

Player		Chips	Progress
Luka Sorainen		500,000	157,000
Krisjanis Lauks		275,000	245,000
Audrius Navickas		0	0
Marius Morel		0	0

Numbers Confirmed; Payout Information Posted Friday 25th October, 2024 at 16:19(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 164/701

The 701 entries have created a prize pool of €658,940. 87 players will see a payday of at least €2,200, while the eventual champion walks away with €130,300.

Place	Prize
1	€130,300
2	€83,400
3	€55,200
4	€40,250
5	€30,450
6	€22,540
7	€17,400
8	€14,400
9	€11,800
10-11	€9,400
12-13	€7,200
14-15	€5,600
16-23	€4,300
24-31	€3,600
32-39	€3,200
40-55	€2,800
56-71	€2,500
72-87	€2,200

Parkkinen Flips to Double-Up Posted Friday 25th October, 2024 at 16:10(UTC+0) by Frank Visser

Level 14: 1,000/2,500 (2,500)
Entries: 170/701

Jamie Dwan raised to 5,000 under the gun. Vasilijus Piskunovas then three-bet to 14,000 in the seat next over before the action folded to Kalle Parkkinen in the big blind.

He counted his 53,000 chips before committing them to the middle. Dwan quickly got out of the way before Piskunovas snap-called.

Kalle Parkkinen:
Vasilijus Piskunovas:

Piskunovas remained ahead on the flopn but the turn gave Parkkinen a pair. The river did not bring a queen, doubling up Parkkinen.

Player		Chips	Progress
Vasilijus Piskunovas		175,000	25,000
Kalle Parkkinen		114,500	84,500
Jamie Dwan		70,000	60,000

15:56 (UTC+0)

Start of Level 14
Blinds: 1,000/2,500     Ante: 2,500

Saltis Seeks Double Posted Friday 25th October, 2024 at 15:55(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 181/701

Martynas Saltis had raised to 4,500 under the gun when Aleksi Naski called in the cutoff. Ignas Navickas then three-bet to 20,000 on the button.

With the action back on him, Saltis jammed all in for 74,000. Naski quickly got out of the way while Navickas stuck in a quick call.

Martynas Saltis:
Ignas Navickas:

Navickas needed a jack to knock out Saltis, but none came on the board and he doubled him up instead.

Player		Chips	Progress
Aleksi Naski		180,000	30,000
Martynas Saltis		157,500	127,500
Ignas Navickas		55,000	36,900

Assorted Eliminations Posted Friday 25th October, 2024 at 15:44(UTC+0) by Frank Visser

Player		Chips	Progress
Fritz Nygren		0	0
Ari Soini		0	0
Gianluca Trebbi		0	0
Johan Martinsen		0	0
Mario Munoz		0	0
Artjom Petskurov		0	0
Viktors Kurovs		0	0
Sven Omland		0	0
Victor Prior		0	0
Raimo Reimann		0	0
Jari-Pekka Juhola		0	0
Ville-Tappio Mesiranta		0	0
Rasmus Lundstrom		0	0
Michel Karim		0	0
Tommi Hakala		0	0
Kerem Hanno		0	0

Jauring Runs Into Aces Posted Friday 25th October, 2024 at 15:34(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 187/701

Joonas Helin had raised to 4,000 and Justas Vaiciulionis had called. Gediminas Zimaitis then three-bet to 15,000, which Rolf Jauring four-bet to 34,500.

The action folded back to Zimaitis, who put Jauring all-in for 65,000 in total. Jauring snap-called and the cards went on their backs.

Rolf Jauring:
Gediminas Zimaitis:

With one king reportedly folded by another player, Zimaitis flopped Jauring dead on . The runout was of little importance as Jauring knuckled the table and took his leave.

Player		Chips	Progress
Joonas Helin		230,000	200,000
Gediminas Zimaitis		210,000	177,300
Justas Vaiciulionis		55,000	25,000
Rolf Jauring		0	0

Vihervuori Experiences Death by Quads from Tarmi Posted Friday 25th October, 2024 at 15:16(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 200/701

Miska Vihervuori open-jammed for 38,000 in early position. It folded to Roope Tarmi in the big blind, who called off for 36,500.

Roope Tarmi:
Miska Vihervuori:

Tarmi took a massive lead on the flop and left his opponent drawing dead on the turn. The river gave him quads as the cherry on top. He doubled up and left Vihervuori with 1,500, which he would lose not much later.

Player		Chips	Progress
Roope Tarmi		76,000	43,900
Miska Vihervuori		0	0

Andriukevicute Doubles Fresh Stack Posted Friday 25th October, 2024 at 15:08(UTC+0) by Frank Visser

Level 13: 1,000/2,000 (2,000)
Entries: 211/701

Justina Andriukevicute was one of the last entries, and she raised to 4,000 under the gun. Albert Ostrovskij defended his big blind, after which a flop of was spread.

Andriukevicute made a bet, which Ostrovskij check-raised to 8,000. Andriukevicute then three-bet all in for 26,000. Ostrovskij spent a few minutes playing with his chips and exhaling air before finally tossing in a call.

Justina Andriukeviciute:
Albert Ostrovskij:

Both players had an open-ender, but only Andriukeviciute's came in on the runout to double her up.

Player		Chips	Progress
Justina Andriukeviciute		63,000	33,000
Albert Ostrovskij		52,000	22,000

14:56 (UTC+0)

Start of Level 13
Blinds: 1,000/2,000     Ante: 2,000

Big Stacks on Break Posted Friday 25th October, 2024 at 14:48(UTC+0) by Frank Visser

Player		Chips	Progress
Karolis Kutkauskas		345,000	228,300
Luka Sorainen		343,000	93,000
Egidijus Digrys		340,000	167,100
Mantas Stikelis		270,000	30,000
Eero Abbey		265,000	60,000
Enea Subashi		250,000	130,000

Last Three Re-Entry Hands, Break After Posted Friday 25th October, 2024 at 14:25(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 207/687

The last three hands for re-entry are being dealt, after which the players will be sent on a 20-minute break.

After the break, late registraion will be closed and the numbers will be finalized.

Vuong Makes Adventurous Call to Chip Up Further Posted Friday 25th October, 2024 at 14:22(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 200/676

Sten Talviste tossed in his last 30,000 chips from the big blind and was looked up by Vo Vuang (pictured) on the button.

Sten Talviste:
Vo Vuang:

The flop made Talviste top pair, and the turn helped neither player. The made Vuang a flush, however, knocking out Talviste just before the break.

Player		Chips	Progress
Vu Vuong		180,000	109,200
Sten Talviste		0	0

Perederejevs Rebuilds by Knocking Out Kilkanen Posted Friday 25th October, 2024 at 14:13(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 199/674

Fritz Nygren made a raise to 3,000 in early position. Andrejs Perederejevs made it 8,500 to go in the cutoff, after which Tero Kilkanen called all-in for less.

Nygren also tossed in a call, after which he check-called 5,000 on the flop. Perederejevs sized up to 16,000 on the turn, which forced a check-fold from Nygren.

Tero Kilkanen:
Andrejs Perederejevs:

Kilkanen was still live, but the river did not improve his hand, meaning the end of this bullet.

Player		Chips	Progress
Andrejs Perederejevs		180,000	40,000
Fritz Nygren		165,000	15,000
Tero Kilkanen		0	0

Renga Makes Munoz Bluff Posted Friday 25th October, 2024 at 14:03(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 203/671

Kaspars Renga raised to 3,000 under the gun before Mario Munoz (pictured) made it 9,000 to go in the hijack. It folded back to Renga, who called to the flop. 

There, he check-called the 7,000 bet of Munoz before the turn went check-check. Renga also checked the river, prompting Munoz to bet 18,500.

Renga instantly called. Munoz sheepishly tabled for jack-high while Renga had the winning wheel with .

Player		Chips	Progress
Kaspars Renga		210,000	77,300
Mario Munoz		60,000	43,000

Dobre Departs Posted Friday 25th October, 2024 at 13:49(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 201/661

Marcel Dobre got his last 23,700 in against Borge Dypvik.

Marcel Dobre:
Borge Dypvik:

The runout did not contain a seven, sending Dobre out.

Player		Chips	Progress
Borge Dypvik		140,000	12,000
Marcel Dobre		0	0

Lazauninkas Loses to Linden Posted Friday 25th October, 2024 at 13:37(UTC+0) by Frank Visser

Level 12: 1,000/1,500 (1,500)
Entries: 203/656

Erik Linden had pushed his stack of 23,700 in against Gytis Lazauninkas, who covered him.

Erik Linden:
Gytis Lazauninkas:

Linden had his ticket ready to hand to the dealer, but the board made him a pair of aces to win the pot and double up.

Player		Chips	Progress
Gytis Lazauninkas		80,000	20,000
Erik Linden		64,400	34,400

13:25 (UTC+0)

Start of Level 12
Blinds: 1,000/1,500     Ante: 1,500

Right Read, Wrong Call Posted Friday 25th October, 2024 at 13:25(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 211/654

47,000 chips were in the middle when big blind Edikas Jurgutis (pictured) bet 38,500 on a completed board of .

His opponent was Jawad Habib in middle position, who spent a few minutes in the tank. "Do you have a set?" Habib asked moments before slamming in a call.

Jurgutis indeed tabled for bottom set. Habib nodded his head and mucked his cards as the massive pot headed to Jurgutis.

Player		Chips	Progress
Edikas Jurgutis		224,000	124,000
Mindaugas Kriaciunas		138,000	32,000
Elias Vaaraniemi		114,000	2,000
Jawad Habib		112,000	44,400
Juho Harkonen		65,000	5,700
Jarmo Salonen		33,200	10,200
Albert Ostrovskij		30,000	0
Martynas Saltis		26,000	4,000

Tool Bluffs Big Slick, Lundstrom Calls Posted Friday 25th October, 2024 at 13:15(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 214/651

The completed board read when Steven Tool made an all-in bet into a pot of 70,000 from the big blind.

His opponent was Rasmus Lundstrom (pictured), who was at risk for 20,200 and made the call.

"Good call," Tool said as he turned over for top pair. Lundstrom had called with two pair, , and doubled up in the big pot.

Player		Chips	Progress
Rasmus Lundstrom		110,400	32,600
Steven Tool		35,000	26,900

Byhlin Building a Stack Posted Friday 25th October, 2024 at 13:03(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 217/649

Bjorge Dypvik was first to act and raised to 2,500. It folded to Erik Byhlin in the small blind, who three-bet to 11,000. Dypvik complied with a call and saw a flop of .

Byhlin fired 12,000 and received a quick call from Dypvik. He then sized up to 30,000 on the turn, which was enough to let Dypvik fold his hand.

Player		Chips	Progress
Erik Byhlin		166,000	136,000
Borge Dypvik		128,000	22,000

Hatipoglu Cracks Pihela Sr.'s Kings Posted Friday 25th October, 2024 at 12:49(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 219/645

Bahadir Hatipoglu had gone all in for 62,900 before the flop and was looked up by Igor Pihela Sr. (pictured).

Bahadir Hatipoglu:
Igor Pihela Sr.:

Hatipoglu stood up after the flop, but "Barry" came looking on the river. Hatipoglu cheered loudly and sat back down with double the number of chips.

Player		Chips	Progress
Bahadir Hatipoglu		127,500	97,500
Igor Pihela Sr.		85,000	15,000

Linden Back to Start After Paying Laba's Overbet Posted Friday 25th October, 2024 at 12:44(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 221/643

There were 34,000 chips in the pot when the board was completed. Vasyl Laba (pictured) sat in middle position and pondered for a bit before making a bet of 50,000.

His opponent was Nils Linden in the hijack, who quickly called. Laba turned over for a set of eights, causing Linden to add his cards to the muck.

Player		Chips	Progress
Vasy Laba		167,000	77,100
Nils Linden		30,000	0

Naglius Returns With Double-Up Posted Friday 25th October, 2024 at 12:32(UTC+0) by Frank Visser

Level 11: 600/1,200 (1,200)
Entries: 231/643

Gintaras Naglius tossed in 15,000 from the big blind and was called by Hanno Kerem in early position.

Gintaras Naglius:
Hanno Kerem:

Naglius had Kerem pipped. That remained the case on the runout to double Naglius up.

Player		Chips	Progress
Gintaras Naglius		34,300	4,300
Kerem Hanno		17,500	12,500

12:24 (UTC+0)

Start of Level 11
Blinds: 600/1,200     Ante: 1,200

Biggest Stacks in the Room Posted Friday 25th October, 2024 at 12:19(UTC+0) by Frank Visser

Player		Chips	Progress
Mantas Stikelis		300,000	188,900
David Bright		292,000	88,900
Luka Sorainen		250,000	22,000
Patrik Zidek		230,000	158,400
Artur Kulanurk		230,000	149,600
Andrejs Perederejevs		220,000	2,500
Aleksi Naski		210,000	88,000
Dmitri Dudakov		210,000	8,700
Rolands Norietis		205,000	175,000
Mikael Koistinen		192,000	61,400

First Break Posted Friday 25th October, 2024 at 12:05(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 225/635

The players have been sent on a 20-minute break.

Soini Doubles Through Sorainen Posted Friday 25th October, 2024 at 12:00(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 229/634

Ari Soini got his 20,000 chips in the middle against Luka Sorainen, who had accumulated an even bigger stack than he started the day with.

Ari Soini:
Luka Sorainen:

Soini locked up the pot on the turn, leaving the river meaningless. Sorainen tossed Soini a few of his chips and play continued.

Player		Chips	Progress
Luka Sorainen		272,000	71,200
Ari Soini		43,000	13,000

Three-Way All-In Sees Two Worst Hands Win Posted Friday 25th October, 2024 at 11:52(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 228/630

Andre Magi was all-in for 18,400, Kristaps Sipols was so for 49,900, and Tarmo Tammel (pictured) had them both covered.

Andre Magi:
Kristaps Sipols:
Tarmo Tammel:

The flop gave Magi a flush draw, and it came in on the turn. Meanwhile, Sipols had turned his set, and nothing changed on the river.

Magi tripled up while Sipols also made a profit by raking in the big side pot. "Nice hands," Tammel said as he cut out the chips he owed.

Player		Chips	Progress
Tarmo Tammel		113,000	2,900
Kristaps Sipols		63,000	29,500
Andre Magi		58,200	28,200

Why? Posted Friday 25th October, 2024 at 11:44(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 232/627

Johan Martinsen had gone all in from the cutoff for 23,400 and had been called by Kaur Ajamaa (pictured) in the small blind.

Johan Martinsen:
Kaur Ajamaa:

Ajamaa flopped great on , leaving his opponent with two direct outs. The turn delivered some more, and the river was a brutal one, giving Martinsen top pair to take the pot.

"Why?" Ajamaa asked rhetorically before he paid his dues.

Player		Chips	Progress
Johan Martinsen		51,700	24,300
Kaur Ajaama		27,500	12,500

Westerlund Down to Five Figures After Encounter With Mikhalov Posted Friday 25th October, 2024 at 11:33(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 240/625

Mykhailo Mikhalov had raised his button when Jenny Westerlund made it 6,300 to go in the big blind. Mikhalov called before both players checked through the flop.

Westerlund checked again on the turn, after which Mikhalov bet 7,000. Westerlund called to the river, where she check-called Mikhalov's final bet of 22,000.

Mikhalov showed for a turned flush. Westerlund sighed and tossed her cards into the muck as she dove under 100 big blinds.

Player		Chips	Progress
Mykhailo Mikhalov		175,000	9,600
Jenny Westerlund		97,000	70,900

Kriaciunas Keeps Building Posted Friday 25th October, 2024 at 11:18(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 242/624

Not long after eliminating Niclas Mjelstad, Mindaugas Kriaciunas was seen playing a big pot of 58,000 from the small blind against Jarmo Salonen in the cutoff.

Kriaciunas fired 11,000 on a completed board of and received a sigh-call from his opponent. He turned over for a rivered straight and Salonen sent his cards to the muck in defeat.

Player		Chips	Progress
Mindaugas Kriaciunas		106,000	40,000
Jarmo Salonen		23,000	7,000

Mjelstad Made Quick Work Of Posted Friday 25th October, 2024 at 11:10(UTC+0) by Frank Visser

Level 10: 600/1,200 (1,200)
Entries: 244/618

Niclas Mjelstad had just sat down with a fresh stack of 30,000 when he got his chips in against Mindaugas Kriaciunas.

Niclas Mjelstad:
Mindaugas Kriaciunas:

Kriaciunas made top pair on the flop while the turn gave him the better flush draw. Mjelstad did not hit a straight on the river and was eliminated.

Mjelstad has already won the €250 H.O.R.S.E. earlier this week but will have to re-enter the Main Event to add another trophy to his collection.

Player		Chips	Progress
Mindaugas Kriaciunas		66,000	25,000
Niclas Mjelstad		0	0

11:05 (UTC+0)

Start of Level 10
Blinds: 600/1,200     Ante: 1,200

Metsla Gives Trebbi Trouble Posted Friday 25th October, 2024 at 10:59(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 251/618

The action was picked up on a turn of . Mark Metsla bet 7,000 into a pot of 16,000 and was called almost instantly by Gianluca Trebbi on the button. 

Metsla then moved in for 17,500 on the river and was once again quickly called. He turned over for the nuts, beating the of Trebbi, who had called down with two pair.

Player		Chips	Progress
Mark Metsla		65,000	35,000
Gianluca Trebbi		46,200	28,800

Sandvik Sent Out After Calling Time on Self Posted Friday 25th October, 2024 at 10:48(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 249/607

Espen Sandvik was staring at Edikas Jurgutis' half-pot bet of 5,500 on a turn of for around two minutes when he called time on himself.

During his countdown, he made the call before the turn completed the board. He then led out for 2,000, which Jurgutis raised to 16,500.

Sandvik tossed in a quick call but mucked his cards once Jurgutis tabled for a full house. He was left with 5,000 chips, which he lost not much later as he was seen leaving the tournament area.

Player		Chips	Progress
Edikas Jurgutis		100,000	30,000
Espen Sandvik		0	0

Wahl Builds Further With Two Pair Posted Friday 25th October, 2024 at 10:41(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 250/601

Sebastian Wahl checked from the big blind on a turn of . Artjom Petskurov sat under the gun and tossed in a bet of 12,000 into the pot of 17,000, which Wahl called.

The river was checked down and Wahl tabled for two pair. Petskurov added his hand to the muck, seeing the pot shipped to Wahl.

Player		Chips	Progress
Sebastian Wahl		216,000	4,600
Artjom Petskurov		86,000	28,100

Vaaraniemi Veers Into Six-Figure Domain Posted Friday 25th October, 2024 at 10:28(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 251/595

Gisle Olsen had gone all in for 23,000 from the small blind and had been looked up by Elias Vaaraniemi in the cutoff.

Gisle Olsen:
Elias Vaaraniemi:

Olsen failed to pair his hole cards on the runout and was consequently eliminated.

Player		Chips	Progress
Elias Vaaraniemi		112,000	17,100
Gisle Olsen		0	0

Parts No Longer Plays Part Posted Friday 25th October, 2024 at 10:22(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 249/588

Rasmus Parts had gotten his stack of 34,800 in the middle from early position against Viktors Kurovs in middle position.

Rasmus Parts:
Viktos Kurovs:

The classic flip ended in Kurovs' favor when the flop did not help out Parts, and the latter took his exit from the tournament room.

Player		Chips	Progress
Viktors Kurovs		100,000	40,300
Rasmus Parts		0	0

Losing Start for Helppi Posted Friday 25th October, 2024 at 10:18(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 245/580

Kris Tikka and Juha Helppi were battling over a pot of 10,200 when Helppi checked from the small blind on a turn of .

Tikka bet 6,500 and Helppi called, causing the turn to appear. Helppi checked again, this time being met with a hefty bet of 17,500 from Tikka.

Helppi spent a minute or so in the tank before letting his hand go and forfeiting an early pot.

Player		Chips	Progress
Juha Helppi		136,700	11,000
Kris Tikka		87,700	7,500

Day 2 Underway Posted Friday 25th October, 2024 at 10:06(UTC+0) by Frank Visser

Level 9: 500/1,000 (1,000)
Entries: 246/578

The button has been drawn, the players have taken their seats, and the cards are in the air for Day 2 of the Kings of Tallinn: Autumn Edition Main Event.

10:04 (UTC+0)

Day 2 of Kings of Tallinn Autumn Edition 2024 Started
Level: 9     Blinds: 500/1,000     Ante: 1,000

How Big Will The Prize Pool Get? Find Out on Day 2 of Kings of Tallinn: Autumn Edition Main Event Posted Friday 25th October, 2024 at 08:45(UTC+0) by Frank Visser

After four starting flights, 554 entries are on the clock for the €1,100 Kings of Tallinn: Autumn Edition Main Event. The €500,000 guarantee has already been surpassed, but with four more levels of late registration and unlimited re-entries, there is no telling how big the event will actually get.

Every player who registers today will receive 30,000 in chips for 25 big blinds, a far cry away from chipleader's Mikael Koistinen's 253,400. Since the pandemic, Koistinen has been playing live poker only sporadically, but he has returned with a bang, already having won the €350 8-Game earlier this week and now hunting his second trophy. Meanwhile, Dmitri Dudakov is the best Estonian, sitting in second with a stack of 218,700, while Sebastian Wahl and Luka Sorainen also secured a spot in the top ten.

Mikael Koistinen

Top Ten Chip Counts

Rank	Player	Country	Chip Count	Big Blinds
1	Mikael Koistinen	Finland	254,400	254
2	Dmitri Dudakov	Estonia	218,700	219
3	Andrejs Perederejevs	Latvia	217,500	218
4	Sebastian Wahl	Finland	211,400	211
5	David Bright	United Kingdom	203,100	203
6	Luka Sorainen	Finland	200,800	201
7	Rytis Strigunas	Lithuania	188,700	188
8	Maykhailo Mykhaloc	Ukraine	184,600	185
9	Vismands Menjoks	Latvia	176,200	176
10	Egidijus Digrys	Lithuania	172,900	173

Other notable names making an appearance on Day 2 include Finnish legend and €5,000 Progressive Bounty winner Juha Helppi (147.800), Aleksi Naski (122,000), Estonian Powerhouse Tarmo Tammel (110,100), and runner-up in yesterday's €555 Championship Rasmus Lundstrom (77,800).

Along with all other returning players, they will return to Olympic Park Casino at noon local time to play ten levels of 60 minutes each. Blinds will start in Level 9: 500/1,000 (1,000), and a break will be held after every two levels. Late registration closes at the start of Level 13, 4:40 p.m., where players can buy in for 15 big blinds. The last level will be 3,000/6,000 (6,000), after which the remaining players will bag up for Day 3.

Stay tuned as the thrilling Day 2 of the Kings of Tallinn Main Event will be reported live from start to finish.

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter