0.0005 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0127 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/tallinn_summer_showdown_555championship_2023/2/updates'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/tallinn_summer_showdown_555championship_2023/2/updates', 1, '2024-11-25')

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.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

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

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

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

0.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.0002 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.0039 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` = 'tallinn_summer_showdown_555championship_2023'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'

0.0285 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` = '76'
AND `published` = 1

0.0290 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '77'
AND `published` = 1

0.0291 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0065 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '78'
AND `published` = 1

0.0293 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` = '79'
AND `published` = 1

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

0.0287 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0064 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '81'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '24'
AND `name` = '2'

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

0.0073 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` = '80'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '3678'
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` = '3666'
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` = '3658'
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` = '3641'
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` = '3637'
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` = '3634'
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` = '3632'
ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3630'
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` = '3629'
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` = '3626'
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` = '3622'
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` = '3620'
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` = '3618'
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` = '3612'
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` = '3609'
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` = '3605'
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` = '3604'
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` = '3602'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

0.0076 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3570'
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` = '3569'
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` = '3568'
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` = '3567'
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` = '3566'
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` = '3565'
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` = '3564'
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` = '3563'
ORDER BY `chip_change` DESC, `busted` ASC

0.0080 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3562'
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` = '3561'
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` = '3560'
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` = '3559'
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` = '3558'
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` = '3557'
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` = '3556'
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` = '3555'
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` = '3554'
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` = '3553'
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` = '3552'
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` = '3551'
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` = '3550'
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` = '3549'
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` = '3548'
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` = '3547'
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` = '3546'
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` = '3545'
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` = '3544'
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` = '3543'
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` = '3542'
ORDER BY `chip_change` DESC, `busted` ASC

0.0068 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3541'
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` = '3540'
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` = '3539'
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` = '3538'
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` = '3537'
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` = '3536'
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` = '3535'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0072 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` = '80'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3678'
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` = '3666'
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` = '3658'
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` = '3641'
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` = '3637'
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` = '3634'
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` = '3632'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0114 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3618'
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` = '3612'
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` = '3609'
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` = '3605'
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` = '3604'
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` = '3602'
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` = '3597'
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` = '3595'
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` = '3591'
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` = '3599'
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` = '3584'
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` = '3583'
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` = '3582'
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` = '3581'
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` = '3579'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3570'
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` = '3569'
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` = '3568'
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` = '3567'
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` = '3566'
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` = '3565'
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` = '3564'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0285 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3556'
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` = '3555'
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` = '3554'
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` = '3553'
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` = '3552'
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` = '3551'
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` = '3550'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

    

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(3)
  • 888poker UK Poker League(0)
  • APAT(2)
  • APPT(0)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(0)
  • Aspers Casino Westfield Stratford City(3)
  • Battle Of Malta(0)
  • Borgata Poker(0)
  • Bratislava Poker Festival(0)
  • British Poker Series(5)
  • BSOP(1)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(2)
  • EPT(4)
  • Estrellas Poker Tour(0)
  • Eureka Poker Tour(1)
  • France Poker Series(0)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(5)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(1)
  • GUKPT Grosvenor(10)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(8)
  • Kings of Tallinn(0)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(12)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(1)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(1)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(4)
  • WPT Prime(2)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(16)
  • WSOP International Circuit(4)
  • 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

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 Summer Showdown 2023 2023 Tallinn Summer Showdown €555 Championship Live Reporting - Day 3

Kings of Tallinn Summer Showdown 2023 - Live Reporting

2023 Tallinn Summer Showdown €555 Championship See other events

2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

---

Current Level 37 Current Day 3

---

Blinds 200,000/400,000 Ante 400000

Entries 573 Remaining 1

---

Prize Pool (EUR) €269,310 First Prize (EUR) €56,900

Chip Leaders Day 3

1

Maikel Homin

17,200,000

Day 1A Day 1B Day 1C Day 1D Day 2 Day 3

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

10:26 (UTC+2)

Day 2 of Kings of Tallinn Summer Showdown 2023 Ended
Level: 27     Blinds: 20,000/40,000     Ante: 40,000

Final Day Seat Draw and Chip Counts Posted Wednesday 26th July, 2023 at 03:35(UTC+2) by Jason Glatzer

"Did I end the day with the chip lead?" asked Juho Heiska (pictured below) as he was bagging chips. 

Indeed he was with 2,390,000, but not by much with two players nipping at his heels in Henri Antikainen (2,365,000) and Raivo Pinsel (2,330,000). 

While both Heiska and Antikainen both were sitting comfortably on more than 2 million for a while, Pinsel was nearly a short stack if not for a miracle river to eliminate Roope Tarmi.

Good night, and see you again when the cards are in the air for the final day on Wednesday at 12 p.m. Time will tell who will win the largest €555 Championship in Kings of Tallinn history and the huge €56,900 top prize.

Table	Seat	Player	Country	Chips	Big Blinds
11	2	Hendrik Diegenant	Belgium	975,000	20
11	3	Henri Antikainen	Finland	2,365,000	47
11	4	Raivo Pinsel	Estonia	2,330,000	47
11	5	Juho Heiska	Finland	2,390,000	48
11	6	Jevgenijs Sapronenko	Latvia	1,305,000	26
11	7	Dmitri Dudakov	Estonia	1,485,000	30
11	8	Maikel Homin	Estonia	535,000	11
12	1	Steven Seller	Estonia	654,000	13
12	2	Jonatan Fors	Finland	1,270,000	25
12	3	Janne Ojala	Finland	698,000	14
12	4	Philip Berggren	Sweden	655,000	13
12	5	Michailas Miserkejevas	Lithuania	1,405,000	28
12	6	Simon Forendal	Sweden	1,035,000	21
12	7	Kim Lindstrom	Finland	585,000	12

Pinsel Delivers Tarmi a Bad Beat to End Day 2 Posted Wednesday 26th July, 2023 at 01:23(UTC+2) by Jason Glatzer

Level 27: 20,000/50,000 (50,000)
Entries: 14/573

Fireworks erupted at Table 12 with Roope Tarmi taking a bad beat after play was announced for the end of the night after the hand in play was concluded. Edvinas Tarasevicius got his short stack in with , with Tarmi happy to commit his stack with . Meanwhile, Raivo Pinsel had them both covered with .

Tarmi would have had an amazing end of the night if his cowboys could hold. Instead, he will be free to play another event tomorrow even though things seemed safe after the flop and the turn. However, the Pinsel celebrated after the spiked the river to give him a set of nines to eliminate both Tarasevicius and Tarmi to leave 14 players remaining when Day 3 begins on Wednesday at 12 p.m.

We will post the chip counts and seat draw for the final 14 players as soon as it is available.

Player		Chips	Progress
Raivo Pinsel		2,335,000	1,911,000
Edvinas Tarasevicius		0	0
Roope Tarmi		0	0

Play Paused After Napel Hit the Rail Posted Wednesday 26th July, 2023 at 01:08(UTC+2) by Jason Glatzer

Level 27: 20,000/40,000 (40,000)
Entries: 16/573

Start of Day 2 chip leader Tobias Napel went deep in the €555 Championship only to lose his short stack near the end of the evening when his was no good against the held by Phillip Berggren.

The floor asked the other tables to stop after the hand they were as the day will end after one more hand at the two other tables.

Player		Chips	Progress
Phillip Berggren		655,000	526,500
Tobias Napel		0	0

Final Day 2 Blind Level Posted Wednesday 26th July, 2023 at 00:49(UTC+2) by Jason Glatzer

Day 2 has reached its final blind level of the evening. If two more players hit the rail, the day will end before the blind level is completed. Otherwise, the action will continue until the clock reads zero.

We will then come back fresh with a blow-by-blow account of every elimination and as many key hands as possible. More importantly, the players will be fresh thanks to this being a three-day event as opposed to a two-day event in the past.  Great job by the management at Olympic Park Casino and our esteemed tournament director Teresa Nousiainen and it is easy to see why many players call the venue the most player-friendly casino in Europe.

00:45 (UTC+2)

Start of Level 27
Blinds: 20,000/40,000     Ante: 40,000

Event Info Posted Wednesday 26th July, 2023 at 00:26(UTC+2) by Jason Glatzer

We just learned that Day 2 will end the sooner of when the action is down to 16 players or the next break which is less than one hour. Surviving players will then resume their battle at 12 p.m. on Wednesday until a champion is crowned in this prestigious record-breaking event.

Arajs Doubles Through Tarmi Posted Wednesday 26th July, 2023 at 00:13(UTC+2) by Jason Glatzer

Level 26: 15,000/30,000 (30,000)
Entries: 23/573

Roope Tarmi min-raised the button. Ingus Arajs (pictured below) three-bet jammed his short stack of 125,000 from the small blind and Tarmi quickly called.

Ingus Arajs:
Roope Tarmi:

Arajs had a small equity advance and won the hand with top pair after the ran out on the board.

Player		Chips	Progress
Roope Tarmi		760,000	346,000
Ingus Arajs		310,000	140,000

00:02 (UTC+2)

Start of Level 26
Blinds: 15,000/30,000     Ante: 30,000

Two Pair for Smeljov Posted Tuesday 25th July, 2023 at 23:42(UTC+2) by Jason Glatzer

Level 25: 10,000/25,000 (25,000)
Entries: 23/573

There wasn't much in the pot when Stanislav Smeljov check-jammed the for 160,000 for 160,000 over the continuation bet by Ingus Arajs from early position.

Stanislav Smeljov:
Ingus Arajs:

It wasn't the worst of flops for Smeljov as he had two pair when the chips went in. Meanwhile, Arajs, despite being far behind, gained some additional equity on the turn with an open-ended straight draw. The river was no good for Arajs and Smeljov earned a double.

Player		Chips	Progress
Stanislav Smeljov		450,000	341,500
Ingus Arajs		450,000	90,000

23:23 (UTC+2)

Start of Level 25
Blinds: 10,000/25,000     Ante: 25,000

Break Time Posted Tuesday 25th July, 2023 at 23:08(UTC+2) by Jason Glatzer

Players are on a 15-minute break. Blinds will increase to 10,000/25,000 with a 25,000 big blind ante when the action resumes.

Players Cashing for €1,710 Posted Tuesday 25th July, 2023 at 23:05(UTC+2) by Jason Glatzer

The following players cashed for €1,710 in the €555 Championship. The final 24 players locked up at least a €2,010 payday.

Place	Player	Prize
25	Juan Carlos Vecino Duenas	€1,710
26	Anna-Mari Hursti	€1,710
27	Ermo Kosk	€1,710
28	Martins Sulte	€1,710
29	Mihhail Skola	€1,710
30	Johannes Tobbe	€1,710
31	Erikas Gordejevas	€1,710
32	Sondre Stormyr	€1,710

Player		Chips	Progress
Sondre Stormyr		0	0
Erikas Gordejevas		0	0
Johannes Hermann Tobbe		0	0
Mihhail Skola		0	0
Martins Sulte		0	0
Ermo Kosk		0	0
Anna-Mari Hursti		0	0
Juan Carlos Vecino Duenas		0	0

Parkkinen Applauds Homin's Bluff Posted Tuesday 25th July, 2023 at 22:29(UTC+2) by Jason Glatzer

Level 24: 10,000/20,000 (20,000)
Entries: 25/573

Kalle Parkkinen checked the flop with about 100,000 in the pot. Maikel Homin bet 35,000 and Parkkinen raised to 125,000. Homin paused for a few moments before he called.

Homin checked the turn. Parkkinen fired out for 130,000 about 20 seconds later and Homin folded.

Parkkinen turned over the to show his bluff. Parkkinen responded with a small applause before the next hand was dealt.

Meanwhile, Juho Heiska keeps piling on chips and became the first player above 2 million. Anne-Mari Hursti shared earlier that she lost her decent stack of chips trying to pull a bluff on Heiska.

Player		Chips	Progress
Juho Heiska		2,100,000	1,150,000
Kalle Parkkinen		950,000	301,000
Maikel Homin		680,000	170,000
Anna-Mari Hursti		0	0

22:16 (UTC+2)

Start of Level 24
Blinds: 10,000/20,000     Ante: 20,000

Eliminated for €1,510 Posted Tuesday 25th July, 2023 at 21:39(UTC+2) by Jason Glatzer

The following players recently hit the rail. They all nearly tripled their €555 buy-in to bank a healthy €1,510 prize with the remaining 32 players guaranteed at least a €1,710 payout.

Place	Player	Prize
33	Erik Int	€1,510
34	Ignacio Garrido	€1,510
35	Romas Bassus	€1,510
36	Henri Schalin	€1,510
37	Tomi Arponen	€1,510
38	Kristjan Maasalu	€1,510
39	Nick Penning	€1,510
40	Ivar Simmer	€1,510

21:34 (UTC+2)

Start of Level 23
Blinds: 10,000/15,000     Ante: 15,000

Heiska Ousts Garrido Posted Tuesday 25th July, 2023 at 21:29(UTC+2) by Jason Glatzer

Level 22: 7,000/14,000 (12,000)
Entries: 33/573

Ignacio Garrido jammed for about 6 big blinds from the small blind. Juho Heiska asked for a stack breakdown before he called from the big blind.

Juho Heiska:
Ignacio Garrido:

Heiska pulled ahead after his ten connected with the flop. The turn added a few more outs for Garrido with now a queen that would improve Heiska to two more would improve Garrido to a straight. THe river completed the board and Garrido collected his payouts slip before leaving the tournament arena.

Player		Chips	Progress
Juho Heiska		950,000	41,000
Nick Penning		0	0
Tomi Arponen		0	0
Henri Schalin		0	0
Romas Bassus		0	0
Ignacio Garrido		0	0

WSOP Circuit Satellite at Midnight Posted Tuesday 25th July, 2023 at 21:14(UTC+2) by Jason Glatzer

The WSOP Circuit is heading to Olympic Park Casino where 12 coveted WSOP gold rings will be awarded across 11 days from Sept. 14-24.

With this in mind, Olympic Park Casino will celebrate alongside you with an added €120 satellite to the schedule tonight at midnight that was just announced that guarantees at least five seats to the WSOP Circuit Tallinn €1,500 Main Event.tel

We imagine there might be some added value here as it wasn't originally on the schedule and many players are busy playing other tournaments or cash games. That being said, keep this in mind if you bust out of an event as late registration is open for eight blind levels and won't close until after 2 a.m.

The first eight levels will boast 15-minute blind levels before things get even quicker from there with high-octane 10-minute blind levels. Best of luck to all the WSOP Circuit satellite players. Who knows, you can be among the first to punch your ticket to the most prestigious event in the history of Olympic Park Casino.

Action Resumes Posted Tuesday 25th July, 2023 at 21:07(UTC+2) by Jason Glatzer

The €555 Championship has resumed its action for Day 2 with blinds at 7,000/14,000 along with a 14,000 big blind ante.

Top Chip Stacks at Break Posted Tuesday 25th July, 2023 at 20:52(UTC+2) by Jason Glatzer

Place	Player	Chips
1	Henri Antikainen	1,335,000
2	Juho Heiska	991,000
3	Maikel Homin	850,000
4	Anna-Mari Hursti	847,000
5	Steven Seller	815,000
6	Dmitri Dudakov	791,000
7	Jonatan Fors	777,000
8	Tobias Napel	703,000
9	Kalle Parkkinen	649,000
10	Romas Bassus	581,000
11	Aleksi Lindholm	575,000
12	Espen Sandvik	522,000
13	Raivo Pinsel	424,000
14	Roope Tarmi	414,000

Player		Chips	Progress
Henri Antikainen		1,335,000	135,000
Juho Heiska		991,000	961,000
Maikel Homin		850,000	470,000
Anna-Mari Hursti		847,000	773,000
Steven Seller		815,000	520,000
Dmitri Dudakov		791,000	9,000
Jonatan Fors		777,000	427,000
Tobias Napel		703,000	353,000
Kalle Parkkinen		649,000	199,000
Romas Bassus		581,000	543,500
Aleksi Lindholm		575,000	315,000
Espen Sandvik		522,000	297,000
Raivo Pinsel		424,000	14,000
Roope Tarmi		414,000	114,000

20:52 (UTC+2)

Start of Level 22
Blinds: 7,000/14,000     Ante: 14,000

Cashed for €1,345 & Dinner Break Posted Tuesday 25th July, 2023 at 19:54(UTC+2) by Jason Glatzer

The following players cashed for €1,345 with Ivar Simmar becoming the first player to ladder up to €1,510 with his 40th place finish. The 39 remaining players just headed off to a one-hour dinner break. We will update some of the bigger stacks from around the room during the break.

Place	Player	Prize
41	Lawend Himmo	€1,345
42	Inigo Robles	€1,345
43	Markku Koplimaa	€1,345
44	Janne Nevalainen	€1,345
45	Jarno Salonen	€1,345
46	Dainius Kudarauskas	€1,345
47	James Noonan	€1,345
48	Marius Morel	€1,345

Player		Chips	Progress
Ivar Simmer		0	0
Marius Morel		0	0
James Noonan		0	0
Dainius Kudarauskas		0	0
Jarno Salonen		0	0
Janne Nevalainen		0	0
Markku Koplimaa		0	0
Inigo Robles		0	0
Lawend Himmo		0	0

Celebrity Event Introductions Posted Tuesday 25th July, 2023 at 19:48(UTC+2) by Jason Glatzer

Kings of Tallinn Summer Showdown Tournament Director Teresa Nousiainen and our festival's host Evely Pihela are introducing the celebrities for the €150 Celebrity Event.

This event always produces tons of energy and excitement. While we are focusing on the €555 Championship, there is a blog in Estonian that you can translate into English on this event. 

Good luck to all the celebrities and players!

One Outer to a Royal for Antikainen to Oust Koplimaa Posted Tuesday 25th July, 2023 at 19:38(UTC+2) by Jason Glatzer

Level 21: 6,000/12,000 (12,000)
Entries: 42/573

It's not every day you see a royal flush. It is even less likely to see the cooler that Markku Koplimaa (pictured above) just took in a hand against Henri Antikainen where he had a full house against his opponent's royal flush.

There were more than 600,000 in the pot preflop with Koplimaa at risk with his against Antikainen's .

Both players were alive and well after the flop before Koplimaa improved to what appeared to be an unbeatable hand after the turn improved his hand to a full house.

The was the only card in the deck that would send Koplimaa packing. Unfortunately, for the Estonian legend that is exactly what spiked the river and the table was in shock.

It was another incredible run for Koplimaa, who began the day with less than a starting stack. Koplimaa took it well and at least he will have a story to tell that he will unlikely forget for a while.

Meanwhile, Antikainen appeared to be in the chip lead after the hand with a huge stack of approximately 1,200,000 for around 100 big blinds.

Player		Chips	Progress
Henri Antikainen		1,200,000	1,143,500
Markku Koplimaa		0	0

Homin's Hand Caught in the Cookie Jar Posted Tuesday 25th July, 2023 at 19:29(UTC+2) by Jason Glatzer

Level 21: 6,000/12,000 (12,000)
Entries: 44/573

Maikel Homen checked with the on the board after the river before Martins Sulte bet 39,000 into a pot of nearly 100,000. Homen raised to 130,000 and Sulte went into the tank before he jammed for not too much more.

We can only assume that Homen was bluffing as he didn't ask for a count. Neither player showed their hand and Sulte caught Homen's hand in the cookie jar to significantly increase his stack.

Player		Chips	Progress
Maikel Homin		380,000	240,000
Martins Sulte		330,000	279,500

Cashed for €1,210 Posted Tuesday 25th July, 2023 at 19:22(UTC+2) by Jason Glatzer

The following players cashed for €1,210 in the €555 Main Event. The remaining field each locked up. The final 48 players each locked up €1,345 after Vaclovas Galune hit the rail in 49th place.

Place	Player	Prize
49	Vaclovas Galaune	€1,210
50	Uku Valner	€1,210
51	Joel Lehtinen	€1,210
52	Miko Ylikoski	€1,210
53	Kristaps Renga	€1,210
54	Tanel Tammela	€1,210
55	Bartosz Wesolek	€1,210
56	Priit Vanem	€1,210

Player		Chips	Progress
Priit Vanem		0	0
Bartosz Wesolek		0	0
Tanel Tammela		0	0
Kristaps Renga		0	0
Miko Ylikoski		0	0
Joel Lehtinen		0	0
Uku Valner		0	0
Vaclovas Galaune		0	0

19:17 (UTC+2)

Start of Level 21
Blinds: 6,000/12,000     Ante: 12,000

Sandvik Doubles Duenas Posted Tuesday 25th July, 2023 at 19:05(UTC+2) by Jason Glatzer

Level 19: 5,000/10,000 (10,000)
Entries: 50/573

Espen Sandvik three-bet squeezed the button over an opener and a caller before Juan Carlos Vecino Duenas four-bet shoved for 155,000 from the small blind. Everyone folded but Sandvik and the cards were turned over with Duenas at risk.

Juan Carlos Vecino Duenas:
Espen Sandvik:

Sandvik had live cards to potentially eliminate Duenas but none of those cards came on the board for Duenas to stay alive and double his stack.

Player		Chips	Progress
Juan Carlos Vecino Duenas		330,000	145,000
Espen Sandvik		225,000	35,000

Cashing for €1,100 Posted Tuesday 25th July, 2023 at 18:55(UTC+2) by Jason Glatzer

The following players cashed for €1,100 in the €555 Championship.

Place	Player	Prize
57	Sami Saamanen	€1,100
58	Ville-Oskari Turja	€1,100
59	Tomas Mickus	€1,100
60	Elias Vaaraniemi	€1,100
61	Riku Koivurinne	€1,100
62	Yvonne Stiedl	€1,100
63	Thomas Haverstad	€1,100
64	Taago Tamm	€1,100

Player		Chips	Progress
Taago Tamm		0	0
Thomas Haverstad		0	0
Yvonne Stiedl		0	0
Riku Koivurinne		0	0
Elias Vaaraniemi		0	0
Tomas Mickus		0	0
Ville-Oskari Turja		0	0
Sami Saamanen		0	0

Min-Cashers Posted Tuesday 25th July, 2023 at 18:45(UTC+2) by Jason Glatzer

Players are enjoying themselves at the welcome drinks. The atmosphere is through the roof and players are enjoying chatting along with each other and the celebrities in attendance.

Meanwhile, the following players min-cashed the €555 Championship for €1,000 with Maksim Petrov (pictured below) the first player out for a full min-cash.

Place	Player	Prize
65	Julian Herold	€1,000
66	Risto Parnat	€1,000
67	Lucas Miguel Cravero	€1,000
68	Dino Dinler	€1,000
69	Alexander Aaneland	€1,000
70	Maksim Petrov	€1,000

Player		Chips	Progress
Maksim Petrov		0	0
Alexander Aaneland		0	0
Dino Dinler		0	0
Lucas Miguel Cravero		0	0
Risto Parnat		0	0
Julian Herold		0	0

18:35 (UTC+2)

Start of Level 20
Blinds: 5,000/10,000     Ante: 10,000

Two Players Out on the Bubble Posted Tuesday 25th July, 2023 at 18:26(UTC+2) by Jason Glatzer

Level 19: 4,000/8,000 (8,000)
Entries: 70/573

Two players just hit the rail on the same hand during the money bubble and will split the €1,000 min-cash.

Paul Koppe was the first to go. He opened for three big blinds before calling off for around 20 big blinds in total facing a jam by Dmitri Dudakov.

Paul Koppe:
Dmitri Dudakov:

Dudakov not only won the flip but also nailed a set of ducks on the .

The action then moved to one table over when this time big slick wasn't facing a flip but took a bad beat instead.

Most of the chips were in preflop before Jaarko Tirkkonen got the rest in on the flop. Kalle Parkkinen called and it was looking good for Tirkkonen to double his stack.

Jaarko Tirkkonen:
Kalle Parkkinen:

Tirkkonen needed to fade a queen along with some backdoors. The spiked the turn and a couple of the players on the rail were calling for a king to get Tirkkonen back ahead. Instead, he hit the rail after the river completed the board.

We will take a short break from the coverage to run downstairs to check out the vibe from the welcome drinks but won't miss too much of the action. 

Player		Chips	Progress
Dmitri Dudakov		800,000	290,000
Kalle Parkkinen		450,000	376,500
Paul Koppe		0	0
Jaarko Tirkkonen		0	0

Petrov Doubles on the Bubble Posted Tuesday 25th July, 2023 at 18:13(UTC+2) by Jason Glatzer

Level 19: 4,000/8,000 (8,000)
Entries: 72/573

Maksim Petrov jammed for 27,000 from early position and was called by Amin Asikainen from the big blind.

Maksim Petrov:
Amin Asikainen:

A crowd gathered before the ran out on the board to improve both players to a pair of kings. The ace-kicker did the job for Petrov for him to double his stack on the bubble.

Player		Chips	Progress
Amin Asikainen		330,000	270,000
Maksim Petrov		74,000	91,000

Bad Beat Near Bubble for Laurila Posted Tuesday 25th July, 2023 at 17:56(UTC+2) by Jason Glatzer

Level 19: 4,000/8,000 (8,000)
Entries: 72/573

Tomi Arponen (pictured below) just hit the rail and the action is now hand-for-hand on the money bubble. Here is how it went down.

A player opened before Arponen three-bet jammed for 129,000. Tero Laurila asked for a count. He then tanked for ages before he called off his stack for a little less. The other player in the hand folded and it was a heads-up showdown with Laurila at risk.

Tero Laurila:
Tomi Arponen:

Unfortunately for Laurila, his cowboys were unable to hold with Arponen connecting with his ace on the board.

Player		Chips	Progress
Tomi Arponen		240,000	174,000
Tero Laurila		0	0
Vygerdas Jonikas		0	0
Mario Colavita		0	0

17:44 (UTC+2)

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

Break Time & Welcome Drinks Soon Posted Tuesday 25th July, 2023 at 17:30(UTC+2) by Jason Glatzer

Players are on a one-hour dinner break just two players away from the money with 73 players remaining and 71 players walking away with at least a €1,000 min-cash. As we explained earlier, players can upgrade their min-cash to a €1,100 Kings of Tallinn Main Event ticket if they so choose and gain an extra €100 in value for free.

Welcome drinks will also take place at 6 p.m. on the casino floor. 

Sandvik Ousts Pfeiffer Near the Bubble Posted Tuesday 25th July, 2023 at 17:18(UTC+2) by Jason Glatzer

Level 18: 3,000/6,000 (6,000)
Entries: 76/573

Espen Sandvik min-raised under the gun before Patrick Pfeiffer three-bet jammed his short stack of 28,000. Dmitri Dudakov cold-called from the small blind before Sandvik called as well.

Dudakov and Sandvik both checked the flop before Dudakov check-folded a bet of 27,000 by Sandvik on the turn. Immediately after this, Sandvik and Pfeiffer turned over their cards.

Patrick Pfeiffer:
Espen Sandvik:

A blank came on the river and Pheiffer was eliminated shortly before the bubble.

Player		Chips	Progress
Dmitri Dudakov		510,000	50,000
Espen Sandvik		260,000	212,500
Ramunas Mika		0	0
Raffael Wadl		0	0
Patrick Pfeiffer		0	0

Tarmi Wins Big With Sevens Posted Tuesday 25th July, 2023 at 17:02(UTC+2) by Jason Glatzer

Level 18: 3,000/6,000 (6,000)
Entries: 79/573

Roope Tarmi opened for a min-raise from under the gun before his opponent three-bet shoved from middle position. It folded around to Tarmi who snap-called and his opponent was flipping for his tournament life.

Opponent:
Roope Tarmi:

His opponent tapped the table to represent "good game" after the flop improved to a set. All eyes were on the board after the turn gave him some life with a flush draw. However, Tarmi's opponent tapped the table again after he bricked the river and Tarmi won the hand with a full house.

Player		Chips	Progress
Roope Tarmi		300,000	43,000
Joshua Dittmann		0	0
Hyunsil Park		0	0
Igor Pihela Jr.		0	0
Christian Steinbo		0	0
Martin Piik		0	0
Indre Martoviciute		0	0
Jarkko Suokas		0	0
Yevhen Roshchebak		0	0
Steponas Venckus		0	0
Anders Auset		0	0
Paul Koppe		0	0

Dinner Break After This Blind Level Posted Tuesday 25th July, 2023 at 16:53(UTC+2) by Jason Glatzer

The blinds have just increased to 3,000/6,000 with a 6,000 big blind ante. After this level, players will go on a 60-minute dinner break. This also gives players enough time for the meet-and-greet welcome drinks at 6 p.m. 

This reporter will be downstairs with his wife (and his notepad). Feel free to drop by with any stories about your experience we can share in the blog.

In other news, we are now just 10 players away from the money. It is possible the money bubble breaks before the dinner break but it might also be after.

16:51 (UTC+2)

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

"I Bet Too Much on the Turn" Posted Tuesday 25th July, 2023 at 16:43(UTC+2) by Jason Glatzer

Level 17: 2,000/5,000 (5,000)
Entries: 90/573

There were about 135,000 in the pot with the on the board after the turn when Paul Koppe checked. Dmitri Dudakov bet 65,000 and Koppe thought it over for a moment before he folded.

Koppe flashed the . Dudakov returned the favor and showed he flopped the nuts with .

"I bet too much on the turn," Dudakov said after the hand.

Player		Chips	Progress
Dmitri Dudakov		460,000	70,000
Paul Koppe		235,000	164,000
Orjan Skommo		0	0
Jani Tuovinen		0	0
Rene Krause		0	0
Tapio Vihakas		0	0

Rough River Card for Mellanen Posted Tuesday 25th July, 2023 at 16:31(UTC+2) by Jason Glatzer

Level 17: 2,000/5,000 (5,000)
Entries: 94/573

Bartosz Wesolek opened for 10,000 from the hijack and was called by Tobias Napel before Kasper Mellanen three-bet jammed for 71,000. Wesolek four-bet shoved for about 185,000 and Napel folded.

Kasper Mellanen:
Bartosz Wesolek:

Wesolek was ahead after the but began to count out his chips ready to pay off his opponent after Mellanen connected his jack on the turn. However, the river completed a gutshot straight draw for Wesolek to win the hand and eliminate Mellanen.

"Good game," Mellanen said politely with some sportsmanship before leaving the table.

Player		Chips	Progress
Bartosz Wesolek		270,000	182,500
Kasper Mellanen		0	0
Tonis Viik		0	0
Marko Vest		0	0
Xiaolei Chen		0	0
Henrik Veldhoen		0	0
Joacim Blom		0	0
Fabian Bartuschk		0	0
Enea Subashi		0	0
Tapio Aaltonen		0	0

16:15 (UTC+2)

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

Record €56,900 Top Prize! Posted Tuesday 25th July, 2023 at 16:01(UTC+2) by Jason Glatzer

The payouts have been announced with tomorrow's winner going home with a €56,900 top prize, which is a new record for this event. Players that min-cash for €1,000 can opt to exchange their min-cash for something better as instead they can claim a Kings of Tallinn Summer Showdown Main Event seat valued at €1,100.

A total of 71 players will win at least a piece of the €269,310 prize pool. Check out all of the payouts below.

Place	Payout
1	€56,900
2	€38,450
3	€22,760
4	€16,620
5	€13,010
6	€9,770
7	€6,700
8	€4,930
9	€3,950
10	€3,300
11-12	€2,780
13-16	€2,320
17-24	€2,010
25-32	€1,710
33-40	€1,510
41-48	€1,345
49-56	€1,210
57-64	€1,100
65-71	€1,000

Ighanoussene Runs Into Nevalainen's Cowboys Posted Tuesday 25th July, 2023 at 15:54(UTC+2) by Jason Glatzer

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

Reda Ighanoussene three-bet jammed from the big blind and was called by Janne Nevalainen who opened from middle position.

Reda Ighanoussene:
Janne Nevalainen:

Ighanoussene was unable to get ahead of Nevalainen's cowboys and hit the rail after the hit the board.

Meanwhile, the payouts were just announced. We will post the full payouts in five to ten minutes but in the meantime we will give a couple of spoilers. The top prize will be a record €56,900 with the top 71 players going home with at least a €1,000 min-cash. Min-cashers can also get even more value as they can choose to instead snag a Kings of Tallinn Summer Showdown €1,100 Main Event ticket instead of the min-cash for an extra €100 in value.

Player		Chips	Progress
Janne Nevalainen		240,000	140,000
Sander Leigri		0	0
Tarjei Forus		0	0
Nikita Padisaar		0	0
Jari Karkkainen		0	0
Reda Ighanoussene		0	0

15:34 (UTC+2)

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

Big Stacks at Break Posted Tuesday 25th July, 2023 at 15:34(UTC+2) by Jason Glatzer

Here is a look at some of the bigger stacks from around the room. Also on the list below are the handful of players that hit the rail just before the break.

Player		Chips	Progress
Raffael Wadl		425,000	169,500
Raivo Pinsel		410,000	183,500
Dmitri Dudakov		390,000	298,000
Priit Vanem		375,000	290,000
Ingus Arajs		360,000	262,500
Jonatan Fors		350,000	287,500
Tobias Napel		350,000	12,000
Jaakko Tirkkonen		330,000	303,500
Simon Forendal		310,000	46,000
Steven Seller		295,000	134,500
Aleksi Lindholm		260,000	230,000
Leo Colin		0	0
Gytis Bernatavicius		0	0
David Lopez De Miguel		0	0
Joonas Siren		0	0
Alenas Pelegrimas		0	0
Siim Suviste		0	0
Marko Harkonen		0	0
Patrick Schratz		0	0

Second Break Posted Tuesday 25th July, 2023 at 15:09(UTC+2) by Jason Glatzer

Players are about to go on their second break. We will update some of the bigger stacks in the blog around the room during the break. 

Expect some excitement outside the tournament area with more pineapple GGPoker Flip&Go Mystery Bounty flips taking place as they will all week long.

"Good Flip" Posted Tuesday 25th July, 2023 at 15:02(UTC+2) by Jason Glatzer

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

Janne Nevalainen min-raised the button. Alberto Gonzalez three-bet jammed for 10 big blinds from the small blind. Nevalainen went into the tank for more than a minute before he called.

Alberto Gonzalez:
Janne Nevalainen:

Gonzalez was ahead but pulled even further in front after his ace connected on the flop. Nevalainen was drawing dead on the turn and the hand was made official after the river completed the board.

"Nice flip," Nevalainen said with a smile to Gonzalez.

Player		Chips	Progress
Janne Nevalainen		100,000	31,000
Alberto Gonzalez		65,000	20,000
Johannes Cleven		0	0
Totti Arosuo		0	0
Marko Vartinen		0	0
Karlis Kreilis		0	0
Mikko Ylamaki		0	0
Allan Pukk		0	0
Keito Kaljulaid		0	0

Venckus Hits His Deuce Posted Tuesday 25th July, 2023 at 14:49(UTC+2) by Jason Glatzer

Level 15: 1,500/3,000 (3,000)
Entries: 135/573

Steponas Venckus jammed for seven big blinds from the cutoff.  Doroslav Rasiukevitc asked for a count before he called.

Steponas Venckus:
Doroslav Rasiukevic:

Rasiukevitc seemed less than thrilled to double his opponent after Venckus connected with his deuce on the board.

Meanwhile, the popular Herli Olop won't create a massive rail at the final table as he was one of the recent players to lose their stacks and head to the locker room.

Player		Chips	Progress
Doroslav Rasiukevitc		80,000	1,000
Steponas Venckus		50,000	22,000
Jussi Karpanen		0	0
Adria Comas I Roura		0	0
Georgi Abuladze		0	0
Herli Olop		0	0
Jordi Baixas		0	0
Aleksandr Kuperman		0	0
Rikard Relander		0	0
Martin Kalmus		0	0
Thor Dahlbeck		0	0

14:37 (UTC+2)

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

A Lucky Trey Saves Kaljulaid Posted Tuesday 25th July, 2023 at 14:28(UTC+2) by Jason Glatzer

Level 14: 1,000/2,500 (2,500)
Entries: 147/573

Keito Kaljulaid jammed for 23,500 from the hijack. Patrick Schratz fired out an isolation three-bet from the cutoff and the rest of the table folded.

Keito Kaljulaid:
Patrick Schratz:

It was looking like Kaljulaid was about to head to the showers but instead, he delivered a bad beat to Schratz and doubled his stack after his trey found a friend on the board.

Meanwhile, local hero and WSOP bracelet winner Ranno Sootla hit the rail along with a handful of others.

Player		Chips	Progress
Keito Kaljulaid		65,000	26,000
Patrick Schratz		50,000	4,000
Knut Trulsen		0	0
Aurimas Stanevicius		0	0
Vlads Dolgilevics		0	0
Ranno Sootla		0	0
Kasparas Drazdauskas		0	0

Asikainen Wins a Flip Against Sootla Posted Tuesday 25th July, 2023 at 14:16(UTC+2) by Jason Glatzer

Level 14: 1,000/2,500 (2,500)
Entries: 152/573

Amin Asikainen three-bet jammed for less than 10 big blinds over the open by Ranno Sootla. Sootla called and Asikainen was flipping for his tournament life.

Amin Asikainen:
Ranno Sootla:

"Yes!" Asikainen said with a fist pump in the air after he won the hand with a better two pair on the runout to stay alive and double his stack.

Player		Chips	Progress
Amin Asikainen		60,000	43,000
Ranno Sootla		50,000	29,500
Priit Oja		0	0
Kent Roed		0	0
Miika Toyras		0	0
Aleksi Mikael Naski		0	0
Guillermo Cifuentes		0	0

14:03 (UTC+2)

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

Galaune Felts Isosalo Posted Tuesday 25th July, 2023 at 14:00(UTC+2) by Jason Glatzer

Level 13: 1,000/2,000 (2,000)
Entries: 163/573

Vaclovas Galaune opened for 4,000 from under the gun before Markus Isosalo jammed for 23,000 from the hijack. Maksim Petrov tanked for about a minute before he called from the small blind and Galune called as well.

Both Petrov and Galune checked the flop and checked again on the turn. Petrov checked again on the river and folded to a bet of 25,000 by Galune.

Isosalo turned over the for the top pair but he lost his stack to Galune who turned over the for the same top pair but a better kicker.

Meanwhile, we won't have a returning champion. Benjamin Gros won this event for €55,500 in February and late registered during Day 2. He just hit the rail meaning we will have a new trophy winner in this event.

Player		Chips	Progress
Maksim Petrov		165,000	4,500
Vaclovas Galaune		125,000	59,500
Rauno Remmel		0	0
Janne Nevalainen		0	0
Jukka Moisio		0	0
Peter Wieczorek		0	0
Benjamin Gros		0	0
Daragh Davey		0	0
Ranel Kasi		0	0
Elvinas Vitkevi_ius		0	0
Robert Rohr		0	0
Andrius Bielskis		0	0
Mikael Haapaniemi		0	0
Nils Linden		0	0
Mark Metsla		0	0
Ari Varonen		0	0

71 Players Paid Posted Tuesday 25th July, 2023 at 13:39(UTC+2) by Jason Glatzer

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

The payouts will be finalized shortly, but in the meantime, Tournament Director Teresa Nousiainen announced to the crowd that the €555 Championship will payout the top 71 players with hand-for-hand taking place during a table-balanced bubble.

Kindsigo Ousts Nikkels Posted Tuesday 25th July, 2023 at 13:36(UTC+2) by Jason Glatzer

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

Many of the short-stacked players are losing their stacks including Sjoerd Nikkels to Jaana Kindsigo as follows:

Kindsigo opened from early position for 4,500. Nikkels jammed for 7,500 from the button before Stanislav Smeljov went into the tank for about a minute from the big blind. Smeljov had one last look at Kindsigo's stack before he folded.

Sjoerd Nikkels:
Jaana Kindsigo:

Neither player improved on the paired board. Kindsigo's jack-kicker came into play and Nikkels was on the rail.

Player		Chips	Progress
Jaana Kindsigo		135,000	35,000
Per Kasten		0	0
Maria Heilala		0	0
Carl Lockmer		0	0
Jonas Lapinskas		0	0
Pertti Salakari		0	0
Sjoerd Nikkels		0	0

Sandvik Runs Into Suviste's Full House Posted Tuesday 25th July, 2023 at 13:25(UTC+2) by Jason Glatzer

Level 13: 1,000/2,000 (2,000)
Entries: 201/573

Espen Sandvik bet 15,000 into a pot of 30,000 with the on the board after the turn and was quickly called by Siim Suviste. Sandvik effectively jammed the river and Suviste's chips were in the pot a micro-second later for his entire stack of 39,500.

Sandvik tabled a strong two-pair with but lost a huge chunk of his stack with Suviste showing the for a flopped set before improving to a full house on the turn.

Player		Chips	Progress
Siim Suviste		140,000	84,500
Espen Sandvik		47,500	106,500
Saulius Tumosa		0	0
Eimantas Venckus		0	0
Rait Kaimer		0	0

New Kings of Tallinn Record! Posted Tuesday 25th July, 2023 at 13:16(UTC+2) by Jason Glatzer

Level 13: 1,000/2,000 (2,000)
Entries: 204/573

Not only was the summer record set in the Kings of Tallinn Summer Showdown €555 Championship, but a new overall Kings of Tallinn record was established in this event with 573 entries creating a €269,310 prize pool.

This beat the previous record set in February with 559 entries getting into the mix before Benjamin Gros won the title for €55,500. 

The payouts for this event will be announced soon.

13:15 (UTC+2)

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

More Eliminations Before Break Posted Tuesday 25th July, 2023 at 13:02(UTC+2) by Jason Glatzer

Player		Chips	Progress
Sarosh Mir		0	0
Samuli Hietala		0	0
Jonas PedersenÊ		0	0
Markus Isosalo		0	0
Henri Antikainen		0	0
Igor Pihela		0	0
Ville Pohjalainen		0	0
Endre Oren		0	0

Break Time Posted Tuesday 25th July, 2023 at 12:46(UTC+2) by Jason Glatzer

Players are on a quick break with late registration closing as soon as the action resumes. The field was at 547 entries at the break and could break the overall Kings of Tallinn record set in February with just 13 more entries. Either way, this is a new summer record. Amazing job to the players!

Chen Propels Stack With Rockets Posted Tuesday 25th July, 2023 at 12:45(UTC+2) by Jason Glatzer

Level 12: 1,000/1,500 (1,500)
Entries: 198/545

Romans Krasins open jammed for around 10 big blinds from early position. Xiaolei Chen, who began the day with just 11,500, three-bet shoved for a little less than 40,000 from one seat over and the rest of the table folded.

Roman Krasins:
Xiaolei Chen:

Krasins got out of his seat on the flop and was drawing dead after Chen improved to a set on the turn. The river inconsequentially further improved Chen to a full house to win the hand for a great start of Day 2 for the Finn.

Player		Chips	Progress
Xiaolei Chen		60,000	48,500
Stefan Bittger		0	0
Peep Kivistik		0	0
Stefan Schrittwieser		0	0
Tarmo Tammel		0	0
Johan Ekdahl		0	0
Christian Arstad		0	0
Romans Krasins		0	0

Miserkejevas Felts Two Posted Tuesday 25th July, 2023 at 12:33(UTC+2) by Jason Glatzer

Level 12: 1,000/1,500 (1,500)
Entries: 204/533

Michailas Miserkejevas just won a monster pot and eliminated two players as follows.

Andzej Zinkevic bet 20,000 into a pot of around double that on the flop. Miserkejevas min-clicked to 40,000 before Erikas Gordejevas four-bet shoved for around 80,000. Zinkevic instantly called off for a little less and it was a three-way showdown after Miserkejevas snap-called as well.

Erikas Gordejevas:
Andzej Zinkevic:
Michailas Miserkejevas:

Miserkejevas got it in good with his bottom set but had to fade some cards if he wanted to eliminate two players and add tons of chips to his stack with Gordejevas holding an overpair and Zinkevic needing a spade to complete a flush. Blanks came for both of his opponents on the turn and the river to take down the pot.

A handful of other players lost their stacks as you can tell from the chip count update below. Some of these players may re-enter as they still have a bit of time to do so with the first blind level of the day about halfway through.

 

Player		Chips	Progress
Michailas Miserkejevas		390,000	205,500
Erikas Gordejevas		0	0
Rein Ingland		0	0
Anu Lilja		0	0
Ahmed Al-Naji		0	0
Erik Borkvik		0	0
Tommy Olavi Piironen		0	0
Andzej Zinkevic		0	0
Alberto Gonzalez		0	0
Erik Borkvik		0	0
Edvinas Tarasevicius		0	0
Vytautas Kacerauskas		0	0
Oskar Ojaveer		0	0
Edgars Beizaks		0	0
Saara Ylianttila		0	0
Jari Lahtinen		0	0
Kristjan Kuning		0	0
Andrey Koks		0	0
Donatas Pilinkus		0	0

Al-Naji Doubles With Sevens Posted Tuesday 25th July, 2023 at 12:14(UTC+2) by Jason Glatzer

Level 12: 1,000/1,500 (1,500)
Entries: 211/525

Alexander Aaneland opened for 2,500 from middle position before he called a three-bet jam by Ahmed Al-Naji to 27,000 from the cutoff.

Ahmed Al-Naji:
Alexander Aaneland:

Al-Naji was safe after the flop but the turn opened up a ton of draws with a ten completing Broadway and any club completing a flush. Aaneland's king and queen were both live as well but lost a chunk of his stack by doubling Al-Naji after a blank river completed the board.

Player		Chips	Progress
Ahmed Al-Naji		58,500	28,500
Alexander Aaneland		35,000	28,500

Cards in the Air Posted Tuesday 25th July, 2023 at 12:06(UTC+2) by Jason Glatzer

Level 12: 1,000/1,500 (1,500)
Entries: 208/522

Cards are in the air to start Day 2 with already 22 new entries getting into the mix. This figure will continue to grow throughout the opening blind level with late registration closing before the start of Level 13.

Welcome to Day 2 of the €555 Championship Posted Tuesday 25th July, 2023 at 08:55(UTC+2) by Jason Glatzer

Welcome to the second of the three-day €555 Championship at the Kings of Tallinn Summer Showdown at Olympic Park Casino and the adjoining Hilton Tallinn Park.

Today will be an action-packed day full of excitement as the action will play down to a final table of just nine hopefuls. Blinds will start at 800/1,600 with a 1,600 big blind ante and increase every 40 minutes throughout the day.

There were exactly 500 entries to get into the action during the four opening flights taking place over the past couple of days to add €235,000 to the prize pool. This is already shattered attendance records for the Kings of Tallinn Summer Showdown and is approaching the record for the Kings of Tallinn brand altogether that was set in February when 559 entries came out in full force before France's Benjamin Gros won the title for €55,500.

More players will still get involved with late registration and re-entries permitted until the start of the second blind level of the day. With plenty of short stacks in play, expect some mayhem to start off the day. The payouts will be announced shortly after late registration is closed.

Netherlands' Tobias Napel (pictured above) leads the way entering today's action over the 186 opening day survivors after parlaying his 30,000 opening stack into a massive pile of 338,000 in chips.

Top 10 Chip Counts

Place	Player	Country	Chips	Big Blinds
1	Tobias Napel	Netherlands	338,000	211
2	Simon Forendal	Sweden	264,000	165
3	Roope Tarmi	Finland	257,000	161
4	Raffael Wadl	Austria	255,500	160
5	Raivo Pinsel	Estonia	226,500	142
6	Taago Tamm	Estonia	212,000	133
7	Sami Saamanen	Finland	206,500	129
8	Ivar Simmer	Estonia	191,500	120
9	Tanel Tammela	Estonia	186,500	117
10	Juan Carlos Vecino Duenas	Spain	185,000	116

Cards are in the air at noon and we will be right alongside you reporting the action throughout the day.

 

Day 2 Seat Draw Posted Tuesday 25th July, 2023 at 08:21(UTC+2) by Jason Glatzer

Table	Seat	Player	Chips	Big Blinds
1	1	Raffael Wadl	255,500	160
1	2	Kim Lindstrom	67,500	42
1	3	Herli Olop	34,000	21
1	4	Christian Steinbo	35,000	22
1	6	Endre Vigdal Oren	118,000	74
1	7	Oskar Ojaveer	40,000	25
1	8	Mark Metsla	44,000	28
1	9	Per Kasten	62,500	39
2	1	Ingus Arajs	97,500	61
2	2	Rene Krause	64,000	40
2	3	Gytis Bernatavicius	97,000	61
2	5	Robert Rohr	34,500	22
2	6	Tanel Tammela	186,500	117
2	7	Aleksandr Kuperman	39,000	24
2	8	Miika Toyras	32,000	20
2	9	Mikko Ylamaki	55,000	34
3	1	Ari Varonen	83,500	52
3	2	Anu Lilja	14,500	9
3	4	Indre Martoviciute	87,500	55
3	5	Kristjan Kuning	46,500	29
3	6	Bartosz Wesolek	87,500	55
3	7	Paul Koppe	71,000	44
3	8	Rauno Remmel	70,000	44
4	2	Johan Ekdahl	43,500	27
4	3	Rein Ingland	22,000	14
4	4	Kalle Elmeri Parkkinen	73,500	46
4	5	Johannes Tobbe	52,500	33
4	6	Keito Kaljulaid	39,000	24
4	7	Aurimas Stanevicius	44,000	28
4	8	Allan Pukk	77,500	48
4	9	Igor Pihela	127,000	79
5	1	Rait Kaimer	61,500	38
5	3	Tomas Mickus	165,000	103
5	4	Igor Pihela Jun.	92,500	58
5	5	Thomas Haverstad	80,500	50
5	6	David Lopez De Miguel	84,000	53
5	7	Maksim Petrov	169,500	106
5	8	Ramunas Mika	131,000	82
5	9	Marko Vartinen	91,000	57
6	1	Jani Tuovinen	56,500	35
6	2	Markku Koplimaa	25,000	16
6	3	Romas Bassus	37,500	23
6	5	Vlads Dolgilevics	102,000	64
6	6	Joacim Blom	90,500	57
6	7	Julian Herold	111,000	69
6	8	Anders Christiansen	25,500	16
6	9	Thor Dahlbeck	97,000	61
7	1	Yevhen Roshchebak	104,500	65
7	2	Andzej Zinkevic	49,500	31
7	3	Michailas Miserkejevas	184,500	115
7	5	Jari Lahtinen	51,500	32
7	6	Tommy Piironen	87,000	54
7	7	Erikas Gordejevas	135,500	85
7	8	Simon Forendal	264,000	165
7	9	Mikael Haapaniemi	47,500	30
8	1	Priit Vanem	85,000	53
8	2	Miko Ylikoski	104,500	65
8	4	Xiaolei Chen	11,500	7
8	5	Yvonne Stiedl	148,000	93
8	6	Stefan Bittger	32,000	20
8	7	Kristaps Renga	43,000	27
8	8	Stanislav Smeljov	108,500	68
8	9	Henri Antikainen	56,500	35
9	1	Henrik Veldhoen	102,000	64
9	2	Kristjan Maasalu	68,000	43
9	3	Patrick Schratz	54,000	34
9	4	Marko Härkönen	59,000	37
9	5	Elias Oskari Vääräniemi	64,000	40
9	7	Sondre Stormyr	140,000	88
9	8	Erik Int	107,000	67
9	9	Sarosh Mir	75,000	47
10	2	Kent Roed	38,500	24
10	3	Bo Berggren	128,500	80
10	4	Hendrik Diegenant	73,000	46
10	5	Martin Muller	52,500	33
10	6	Tapio Aaltonen	69,000	43
10	7	Saulius Tumosa	144,000	90
10	8	Lawend Himmo	31,000	19
10	9	Andrius Bielskis	55,000	34
11	1	Johannes Cleven	77,500	48
11	2	Siim Suviste	55,500	35
11	3	Jordi Baixas	39,500	25
11	5	Jussi Karpanen	41,000	26
11	6	Espen Sandvik	154,000	96
11	7	Juan Carlos Vecino Duenas	185,000	116
11	8	Roope Tarmi	257,000	161
11	9	Patrick Pfeiffer	91,000	57
12	1	Marko Vest	29,000	18
12	2	Anton Pereyaslov	147,000	92
12	3	Ranno Sootla	20,500	13
12	5	Edgars Beizaks	18,500	12
12	7	Tonis Viik	82,000	51
12	8	Jari Karkkainen	62,500	39
12	9	Tapio Vihakas	37,000	23
13	2	Priit Oja	55,500	35
13	3	Henri Schalin	80,000	50
13	4	Steponas Venckus	28,000	18
13	5	Mihhail Skola	95,500	60
13	6	Ranel Kasi	48,500	30
13	7	Doroslav Rasiukevitc	79,000	49
13	8	Jonas Pedersen	31,500	20
13	9	Saara Ylianttila	55,000	34
14	2	Reda Ighanoussene	29,000	18
14	3	Vygerdas Jonikas	125,500	78
14	4	Maria Heilala	65,000	41
14	5	Lucas Cravero	92,500	58
14	6	Janne Nevalainen	69,000	43
14	7	Alexander Aaneland	63,500	40
14	8	Donatas Pilinkus	27,000	17
14	9	Ville Pohjalainen	34,000	21
15	1	Elvinas Vitkevi?ius	85,500	53
15	3	Nils Linden	36,500	23
15	4	Enea Subashi	67,500	42
15	5	Peter Wieczorek	19,000	12
15	6	Anna-Mari Hursti	74,000	46
15	7	Jonas Lapinskas	41,500	26
15	8	Jevgenijs Sapronenko	141,500	88
15	9	Rikard Relander	66,500	42
16	1	Tero Laurila	31,500	20
16	2	Joshua Dittmann	83,500	52
16	3	Ville-Oskari Sebastian Turja	120,000	75
16	4	Leo Colin	41,500	26
16	7	Christian Arstad	27,500	17
16	8	Jukka Moisio	10,500	7
16	9	Stefan Schrittwieser	31,000	19
17	1	Peep Kivistik	55,000	34
17	2	Guillermo Gordo Cifuentes	77,500	48
17	3	Hyunsil Park	60,500	38
17	4	Fabian Bartuschk	109,500	68
17	5	Martins Sulte	50,500	32
17	7	Steven Seller	160,500	100
17	8	Kaido Mikk	17,000	11
17	9	Jarkko Juhani Suokas	135,500	85
18	1	Tomi Arponen	66,000	41
18	2	Pertti Salakari	90,500	57
18	3	Taago Tamm	212,000	133
18	5	Markus Isosalo	39,000	24
18	6	Maikel Homin	140,000	88
18	7	Raivo Pinsel	226,500	142
18	9	Uku Valner	45,000	28
19	1	Jonatan Fors	62,500	39
19	2	Sami Saamanen	206,500	129
19	3	Joonas Siren	71,500	45
19	4	Carl Lockmer	90,000	56
19	5	Samuli Hietala	69,500	43
19	6	Knut Trulsen	57,000	36
19	8	Alberto Gonzalez	45,000	28
19	9	James Noonan	172,000	108
20	1	Alenas Pelegrimas	47,500	30
20	3	Tobias Napel	338,000	211
20	4	Georgi Abuladze	72,500	45
20	5	Riku Koivurinne	36,000	23
20	6	Edvinas Tarasevicius	24,500	15
20	7	Aleksi Mikael Naski	123,500	77
20	8	Ignacio Garrido	66,000	41
20	9	Ermo Kosk	71,500	45
21	1	Sander Leigri	46,500	29
21	2	Mario Colavita	171,500	107
21	3	Joel Lehtinen	78,500	49
21	4	Tarmo Tammel	25,000	16
21	5	Eimantas Venckus	24,000	15
21	6	Vytautas Kacerauskas	11,500	7
21	7	Marius Morel	56,500	35
21	9	Kasparas Drazdauskas	56,500	35
22	1	Ivar Simmer	191,500	120
22	3	Jaakko Tirkkonen	26,500	17
22	4	Nick Penning	172,500	108
22	5	Anders Auset	150,000	94
22	6	Adria Comas I Roura	78,500	49
22	8	Karlis Kreilis	53,000	33
22	9	Nikita Padisaar	102,500	64
34	1	Jaana Kindsigo	100,000	63
34	2	Martin Kalmus	23,500	15
34	5	Risto Parnat	75,000	47
34	6	Orjan Skommo	51,000	32
34	7	Vaclovas Galaune	65,500	41
34	8	Amin Asikainen	17,000	11
34	9	Kasper Mellanen	111,000	69
36	1	Martin Piik	83,000	52
36	3	Erik Borkvik	53,500	33
36	4	Dmitri Dudakov	92,000	58
36	5	Andrey Koks	39,500	25
36	6	Dainius Kudarauskas	110,000	69
36	7	Tarjei Forus	75,500	47
36	8	Inigo Robles	80,000	50
36	9	Vasilij Barna	131,500	82

08:21 (UTC+2)

Day 2 of Kings of Tallinn Summer Showdown 2023 Started
Level: 12     Blinds: 800/1,600     Ante: 1,600

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