0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0083 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/2/updates'
ORDER BY `views` DESC
0.0124 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/2/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0035 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` = '2024_KOT_555_Champ'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'
0.0302 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '224'
AND `published` = 1
0.0306 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '230'
AND `published` = 1
0.0290 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '231'
AND `published` = 1
0.0304 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` = '236'
AND `published` = 1
0.0305 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0070 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '237'
AND `published` = 1
0.0291 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '240'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'
AND `name` = '2'
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '237'
ORDER BY `busted` ASC, `current_chips` DESC
0.0068 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '237'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '10473'
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` = '10471'
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` = '10461'
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` = '10450'
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` = '10441'
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` = '10430'
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` = '10428'
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` = '10422'
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` = '10417'
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` = '10413'
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` = '10407'
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` = '10406'
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` = '10401'
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` = '10394'
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` = '10393'
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` = '10383'
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` = '10380'
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` = '10375'
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` = '10368'
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` = '10365'
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` = '10358'
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` = '10354'
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` = '10351'
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` = '10344'
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` = '10335'
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` = '10330'
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` = '10313'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10306'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10302'
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` = '10296'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10295'
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` = '10293'
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` = '10287'
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` = '10284'
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` = '10280'
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` = '10277'
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` = '10273'
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` = '10270'
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` = '10268'
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` = '10264'
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` = '10263'
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` = '10259'
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` = '10253'
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` = '10252'
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` = '10249'
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` = '10244'
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` = '10240'
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` = '10239'
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` = '10230'
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` = '10229'
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` = '10221'
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` = '10222'
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` = '10219'
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` = '10218'
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` = '10217'
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` = '10209'
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` = '10206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10201'
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` = '10199'
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` = '10194'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10187'
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` = '10183'
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` = '10180'
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` = '10175'
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` = '10171'
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` = '10169'
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` = '10165'
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` = '10160'
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` = '10157'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10156'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10149'
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` = '10147'
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` = '10142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10135'
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` = '10134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10132'
ORDER BY `chip_change` DESC, `busted` ASC
0.0136 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0136 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0136 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10120'
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` = '10119'
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` = '10118'
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` = '10114'
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` = '10110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '224'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '230'
ORDER BY `busted` ASC, `current_chips` DESC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '231'
ORDER BY `busted` ASC, `current_chips` DESC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '236'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '237'
ORDER BY `busted` ASC, `current_chips` DESC
0.0060 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` = '237'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '10473'
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` = '10471'
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` = '10461'
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` = '10450'
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` = '10441'
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` = '10430'
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` = '10428'
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` = '10422'
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` = '10417'
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` = '10414'
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` = '10413'
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` = '10407'
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` = '10406'
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` = '10401'
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` = '10394'
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` = '10393'
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` = '10383'
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` = '10380'
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` = '10375'
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` = '10368'
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` = '10365'
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` = '10358'
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` = '10354'
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` = '10351'
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` = '10344'
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` = '10335'
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` = '10330'
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` = '10313'
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` = '10306'
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` = '10302'
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` = '10296'
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` = '10295'
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` = '10293'
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` = '10287'
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` = '10284'
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` = '10280'
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` = '10277'
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` = '10273'
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` = '10270'
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` = '10268'
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` = '10264'
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` = '10263'
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` = '10259'
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` = '10253'
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` = '10252'
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` = '10249'
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` = '10244'
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` = '10240'
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` = '10239'
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` = '10230'
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` = '10229'
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` = '10221'
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` = '10222'
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` = '10219'
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` = '10218'
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` = '10217'
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` = '10209'
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` = '10206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10201'
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` = '10199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10194'
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` = '10189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10187'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10183'
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` = '10180'
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` = '10175'
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` = '10171'
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` = '10169'
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` = '10165'
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` = '10160'
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` = '10157'
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` = '10156'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10147'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10142'
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` = '10135'
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` = '10134'
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` = '10132'
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` = '10127'
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` = '10122'
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` = '10120'
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` = '10119'
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` = '10118'
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` = '10114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0093 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '237'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '240'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Day 2 of Kings of Tallinn 2024 Ended Level: 26 Blinds: 25,000/50,000 Ante: 50,000
Final Day 2 Chip Counts Posted Wednesday 28th February, 2024 at 02:48(UTC+2) by Jason Glatzer
Player
Chips
Progress
Andrius Bielskis
3,300,000
50,000
Oscar Peleg
3,280,000
880,000
Mikko Ylamaki
2,540,000
1,605,000
Svetozar Marinov
1,740,000
230,000
Aleksandrs Krumins
1,735,000
455,000
Touko Berndtson
1,540,000
560,000
Knut Trulsen
1,505,000
335,000
Matte Karjalainen
1,220,000
890,000
Jordi Baixas
1,190,000
350,000
Konsta Heikkil?
925,000
375,000
Adrians Imsa
710,000
140,000
Jan-Mikael Kesanen
665,000
165,000
Joonas Helin
655,000
95,000
Final 13 Players Bagging Up Posted Wednesday 28th February, 2024 at 02:27(UTC+2) by Jason Glatzer
Day 2 just concluded with 13 players in their seats. Andrius Bielskis had about 3.3 million chips and held the chip lead at the end of the evening.
We will update the final chip counts and the seat draw for the final day.
Tomorrow's restart time has been pushed back 30 minutes to 12:30 p.m.
Benislovas Cracks Sleeping Beauty's Cowboys Posted Wednesday 28th February, 2024 at 02:05(UTC+2) by Jason Glatzer
Level 26: 25,000/50,000 (50,000) Entries: 13/700
There was some Lithuanian crime vs. crime between Christian "Sleeping Beauty" Rygaard and Andrius "Benislovas" Bielskis (pictured below). Rygaard earned his nickname tonight after missing nearly four hours after taking a nap during the dinner break. We learned later, that Rygaard thought the day was over despite not bagging his chips.
Bielskis jammed over a pair of short stacks and Rygaard woke up with a good enough hand to call of his stack of around a dozen big blinds.
Rygaard tabled kings but this proved to be no good against ace-five with two aces landing on the flop. No love came on the turn or river and Rygaard was eliminated in 14th place.
Just before that, the event lost its final female with Lithuania's Viktorija Ignataviciene losing her short stack.
Player
Chips
Progress
Andrius Bielskis
3,250,000
630,000
Viktorija Ignataviciene
0
0
Christian Rysgaard
0
0
01:50 (UTC+2)
Start of Level 26 Blinds: 25,000/50,000 Ante: 50,000
Berndtson Ousts Morstal Posted Wednesday 28th February, 2024 at 01:39(UTC+2) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 16/700
The action is down to two tables after Thor Morstal got his stack in with and didn't improve against the held by Touko Berndtson.
There was a quick redraw with just minutes left in Level 25. Unless the final table is reached before then, Level 26 will be the final blind level of Day 2.
Player
Chips
Progress
Touko Berndtson
2,100,000
900,000
Thor Morstol
0
0
Trips for Peleg Posted Wednesday 28th February, 2024 at 01:36(UTC+2) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 17/700
Matteo Cappelletti and Serhii Leonev both hit the rail before Konsta Heikklia check-called a bet of 400,000 by Oscar Peleg into a spread pot of around double that with the on the board after the turn.
Heikklia checked the river.
"How much you on?" asked Peleg.
Heikklia made a clearer view to his stack and moments later Peleg checked the action back.
Peleg turned over the for trips and won the pot after Heikklia mucked.
Player
Chips
Progress
Oscar Peleg
2,400,000
1,530,000
Konsta Heikkil?
1,300,000
170,000
Only Card in the Deck on River Sends Ertinhajevs to the rail Posted Wednesday 28th February, 2024 at 01:16(UTC+2) by Jason Glatzer
Level 25: 20,000/40,000 (40,000) Entries: 19/700
Sultans Ertinhajevs got a three-bet jam through from the big blind before open-jamming the small blind the following hand for 660,000.
Aleksandrs Krumins asked for a count before he called from the big blind.
Sultans Ertinhajevs: Aleksandrs Krumins:
Ertinhajevs pulled out ahead after his ace connected on the flop. The turn opened up some chop outs to Broadway but it was the case ten that sent Ertinhajevs to the showers with the river completing the board to improve Krumins to a set.
Updated Chip Counts at Break Posted Wednesday 28th February, 2024 at 01:06(UTC+2) by Jason Glatzer
Player
Chips
Progress
Andrius Bielskis
2,620,000
420,000
Matte Karjalainen
2,110,000
260,000
Svetozar Marinov
1,970,000
960,000
Jordi Baixas
1,540,000
660,000
Aleksandrs Krumins
1,280,000
670,000
Touko Berndtson
1,200,000
510,000
Knut Trulsen
1,170,000
870,000
Konsta Heikkil?
1,130,000
475,000
Mikko Ylamaki
935,000
195,000
Thor Morstol
920,000
180,000
Oscar Peleg
870,000
330,000
Jan-Mikael Kesanen
830,000
210,000
Javier Moya
755,000
525,000
Joonas Helin
750,000
150,000
Matteo Cappelletti
735,000
240,000
Serhii Leonov
640,000
305,000
Adrians Imsa
570,000
150,000
Christian Rysgaard
565,000
15,000
Viktorija Ignataviciene
415,000
250,000
Sultans Ertinhajevs
190,000
100,000
00:54 (UTC+2)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Final Break Posted Wednesday 28th February, 2024 at 00:39(UTC+2) by Jason Glatzer
Players are on their final break and will play two more blind levels when the action resumes. Of course, it is possible that the final table will be reached before then, in which case the action when end then instead.
We will update the chip counts of the remaining 20 players when the action resumes.
A Good Nap for Rysgaard Posted Wednesday 28th February, 2024 at 00:38(UTC+2) by Jason Glatzer
Level 24: 10,000/30,000 (30,000) Entries: 20/700
Christian Rysgaard was the chip leader at the dinner break but was missing in action for nearly four blind levels after.
Several people tried to call Rysgaard, some worrying if he was OK, and others worried about him missing some action.
The good news is that Rysgaard is OK, although his stack has seen better days.
"Ah, that was a good nap," Rysgaard said.
Nearly the entire field got a good laugh and despite losing some chips at least Rysgaard is OK and in good spirits.
Player
Chips
Progress
Christian Rysgaard
550,000
615,000
Jucys Loses His Chip Posted Wednesday 28th February, 2024 at 00:19(UTC+2) by Jason Glatzer
Level 24: 10,000/30,000 (30,000) Entries: 21/700
Paulius Jucys (pictured below) was down to one chip after tangling up with fellow Lithuanian Andrius Bielskis. This got it and it seemed he might have a chance in the following hand.
Matteo Cappelletti opened for 60,000 from middle position. Jucys got his single 5,000 chip in from one seat over before Oscar Peleg defended his big blind.
Peleg check-called a bet of 30,000 on the flop. Cappelletti mucked before Peleg got a chance to act on the turn.
Paulius Jucys: Oscar Peleg:
"I have two pair," said Peleg.
"I also have two pair," replied Jucys.
"It looks like its going to be a chop," said Peleg.
Jucys took a bad beat to end any potential Cinderella story after the improved Peleg to a better two pair to win both the main pot and side pot.
Player
Chips
Progress
Andrius Bielskis
2,200,000
1,130,000
Oscar Peleg
1,200,000
885,000
Paulius Jucys
0
0
23:59 (UTC+2)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Tsvetanov Runs Jacks Into Baixas's Cowboys Posted Tuesday 27th February, 2024 at 23:59(UTC+2) by Jason Glatzer
Level 24: 10,000/30,000 (30,000) Entries: 22/700
Presiyan Tsvetanov opened for 60,000 from the cutoff before Jordi Baixas (pictured below) three-bet to 150,000 from the button. Tsvetanov four-bet shoved for 760,000 and Baixas wasted no time in finding a call.
Presiyan Tsvetanov: Jordi Baixas:
Cowboys held on the board for Baixas to win a massive pot while also sending Tsvetanov to the rail.
Meanwhile, Joel Ylismaki, who lost most of his once impressive stack to Matte Karjalainen earlier this blind level, lost the rest of his stack to leave 22 players remaining.
Player
Chips
Progress
Jordi Baixas
2,200,000
1,950,000
Presiyan Tsvetanov
0
0
Joel Ylismaki
0
0
"It's Never Easy" Posted Tuesday 27th February, 2024 at 23:40(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 24/700
Knut Trulsen (pictured below) jammed his short stack of around eight big blinds from the hijack. Mykhailo Mikhalov had even less in his stack when he called off from the cutoff.
"Turn over an ace," Trulsen said and both players showed an ace before showing their other card to the delight of Aleksandrs Krumins also at the table.
Mykhailo Mikhalov: Knut Trulsen:
"It's never easy," Krumins said on the flop.
"It's never easy," Krumins said on the turn giving both players a flush draw.
The river completed a flush for Trulsen.
"That's why I said it is never easy," Krumins said to Trulsen.
Meanwhile, just before this Dmitrijs Arsuns hit the rail to leave just 24 players remaining.
Player
Chips
Progress
Knut Trulsen
300,000
20,000
Dmitrijs Arsuns
0
0
Mykhailo Mikhalov
0
0
Massive Double for Karjalainen Posted Tuesday 27th February, 2024 at 23:29(UTC+2) by Jason Glatzer
Level 23: 10,000/25,000 (25,000) Entries: 26/700
It was a three-bet pot preflop that build up to more than 700,000 in chips by the time the turn came around on the board.
Joel Ylismaki jammed for more than the 565,000 his opponent had in his stack and Matte Karjalainen called.
Matte Karjalainen: Joel Ylismaki:
The blank river completed the board for Karjalainen to win a pot of near 2 million in chips.
Meanwhile, Vytautas Laurinaitis, Edgaras Kausinis, Mats Forss, Kevin Karenius, Jani Vilmunen, and Jonatan Fors (pictured below) all hit the rail to leave just 26 players remaining.
Player
Chips
Progress
Matte Karjalainen
1,850,000
1,090,000
Joel Ylismaki
375,000
660,000
Jonatan Fors
0
0
Jani Vilmunen
0
0
Kevin Karenius
0
0
Mats Forss
0
0
Edgaras Kausinis
0
0
Vytautas Laurinaitis
0
0
23:22 (UTC+2)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Krumins Gets Penalty After Cracking Tarmi's Aces Posted Tuesday 27th February, 2024 at 23:04(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 33/700
Cracked aces and a penalty you ask? While Aleksandrs Krumins didn't receive a penalty for cracking aces, he had to sit out two hands for conduct after acting out of turn in the same hand.
"45,000," Krumins said from the button while the action still stood with the last lady standing in the event in Viktorija Ignataviciene.
The dealer didn't hear Krumins, and Roope Tarmi (pictured below), who was in the big blind, asked the dealer to call the floor.
Krumins and others at the table agreed with Tarmi and the floor explained that Krumins bet stands if the action doesn't change.
Ignataviciene eventually folded and Tarmi defended from the big blind off a stack of around 10 big blinds.
Tarmi check-jammed the rest of his chips on the flop and Krumins wasted no time in finding a call.
Roope Tarmi: Aleksandrs Krumins:
"Sorry, but not sorry," Krumins said.
Krumins repeated the same statement to Tarmi after the turn and river completed the board.
While Tarmi hit the rail alongside Juuso Oksanen, Angel Rodriguez, Luka Sorensen, and Mathias Christensen, Krumins was informed about his penalty.
"That's fair," said Krumins.
"If it happens again, the next penalty will be more severe," the floor told Krumins.
Krumins respectfully acknowledged his situation. He stacked up his chips and stepped away from the table before allowed to jump back into the action.
Player
Chips
Progress
Aleksandrs Krumins
1,950,000
1,220,000
Roope Tarmi
0
0
Juuso Oksanen
0
0
Angel Rodriguez
0
0
Luka Sorainen
0
0
Mathias Christensen
0
0
Colossal Failure for Estonia in the €555 Championship Posted Tuesday 27th February, 2024 at 22:56(UTC+2) by Jason Glatzer
Level 22: 10,000/20,000 (20,000) Entries: 34/700
It doesn't make me proud to say this as the Estonian poker community has taken me in and made me feel at home over the past decade of reporting, commentating, and playing.
That being said, it was an absolute colossal failure for Estonians in the €555 Championship as after Dmitri Zatsik hit the rail in 35th place for €1,600 there were no players from the home country still in the event despite around 100 entries coming from Estonian players.
Zatsik got his short stack in good with king-ten against jack-deuce suited but hit the rail anyway after an unfavorable board.
The Estonian media agreed that this might be a bigger failure for the home country than the time when no Estonians came close to the final table at the 2022 Kings of Tallinn €1,100 Main Event after Mark Metsla took 12th place.
"This is a warm-up," Tanel Evert (pictured below) said in Estonian. "In the main tournament, we will show a completely different game!"
22:31 (UTC+2)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Players Eliminated for €1,400 Posted Tuesday 27th February, 2024 at 22:23(UTC+2) by Jason Glatzer
The following players including Tomi Arponen pictured below cashed in the €555 Championship for €1,400. The remaining field of 39 players each locked up a €1,600 payout.
Place
Player
Country
Prize
40
Mathias Christensen
SWE
€1,400
41
Akseli Paalanen
FIN
€1,400
42
Ville Turja
FIN
€1,400
43
Niklas Gjersvold
NOR
€1,400
44
Dangiras Kuzulis
LTU
€1,400
45
Aleksandr Kuperman
EST
€1,400
46
Kasper Mellanen
FIN
€1,400
47
Gundars Zelcs
LVA
€1,400
48
Hans Erlandsson
SWE
€1,400
49
Erik Pulluveer
EST
€1,400
50
Aleksei Smirnov
EST
€1,400
51
Arto Loikkanen
FIN
€1,400
52
Adrian Espinosa
ESP
€1,400
53
Tomi Arponen
FIN
€1,400
54
Eldars Sadih-Zade
LVA
€1,400
55
Bengt-Anders Johnsson
SWE
€1,400
Gjersvold Runs Into Helin's Set Posted Tuesday 27th February, 2024 at 22:18(UTC+2) by Jason Glatzer
Level 21: 10,000/15,000 (15,000) Entries: 40/700
Five players have hit the rail since dinner break including Akseli Paalanen, Ville Turja, Niklas Gjersvold, Dangiras Kuzulis, and Aleksandr Kuperman.
Gjersvold didn't come back from dinner break with one of the bigger stacks, but his stack took a hit after doubling up the tiny stack of Edgaras Kausinis once while ahead and again while it was a flip.
His bad fortunes continued after losing another flip. Gjersvold jammed for around 100,000 and was called by Joonas Helin from the big blind.
Niklas Gjersvold: Joonas Helin:
Gjersvold let out a small laugh after Helin nailed a set on the flop and was eliminated after not hitting a runner-runner miracle on the turn and river.
Player
Chips
Progress
Joonas Helin
600,000
240,000
Ville Turja
0
0
Akseli Paalanen
0
0
Dangiras Kuzulis
0
0
Niklas Gjersvold
0
0
Aleksandr Kuperman
0
0
Cinderella Story Starting for Vilnius Ace Breaker High Roller Champ Kausinis? Posted Tuesday 27th February, 2024 at 22:04(UTC+2) by Jason Glatzer
Level 21: 10,000/25,000 (25,000) Entries: 45/700
2024 OlyBet Showdown Vilnius Ace Breaker €1,100 High Roller champion Edgaras Kausinis had some work to do coming off dinner break with just a hair above a big blind in his stack. He gained some breathing room short after with a pair of double-ups against Niklas Gjersvold.
He first "doubled" through Gjersvold when he was committed from the blinds with and got there for a flopped straight vs. after the ran out on the board. He had 80,000 in his stack after this hand and then soon after jammed his stack from late position and was called by Gjersvold from the blinds.
Edgaras Kausinis: Niklas Gjersvold:
Kausinis improved to a straight on the board to beat a flopped two pair.
"Now you have more chips than me," Gjersvold said to Kausinis with a smirk.
Player
Chips
Progress
Edgaras Kausinis
200,000
180,000
Niklas Gjersvold
130,000
110,000
21:52 (UTC+2)
Start of Level 21 Blinds: 10,000/15,000 Ante: 16,000
Christian Rysgaard Leads at Break Posted Tuesday 27th February, 2024 at 21:30(UTC+2) by Jason Glatzer
Lithuania's Christian Rysgaard led at the dinner break with 1,165,000. Five other players were over 1 million in chips including Mikko Ylamaki (pictured above), Andrius Bielskis, Jan-Mikael Kesanen, Joel Ylismaki, and Svetozar Marinov.
Check out the full chip counts of the final 45 players below:
Player
Chips
Progress
Christian Rysgaard
1,165,000
665,000
Mikko Ylamaki
1,130,000
280,000
Andrius Bielskis
1,070,000
270,000
Jan-Mikael Kesanen
1,040,000
1,010,000
Joel Ylismaki
1,035,000
986,300
Svetozar Marinov
1,010,000
688,000
Serhii Leonov
945,000
799,300
Matte Karjalainen
760,000
685,000
Thor Morstol
740,000
20,000
Aleksandrs Krumins
730,000
30,000
Touko Berndtson
690,000
583,300
Konsta Heikkil?
655,000
623,000
Peder Behr
645,000
55,000
Angel Rodriguez
635,000
135,000
Audrius Skucas
625,000
595,000
Presiyan Tsvetanov
575,000
395,800
Matteo Cappelletti
495,000
105,000
Mykhailo Mikhalov
480,000
299,400
Jonatan Fors
450,000
379,300
Adrians Imsa
420,000
9,000
Dmitrijs Arsuns
375,000
220,000
Paulius Jucys
365,000
335,600
Joonas Helin
360,000
305,700
Ville Turja
320,000
135,000
Oscar Peleg
315,000
184,200
Sultans Ertinhajevs
290,000
30,000
Knut Trulsen
280,000
253,400
Roope Tarmi
275,000
325,000
Jani Vilmunen
270,000
191,400
Jordi Baixas
250,000
138,000
Niklas Gjersvold
240,000
194,000
Javier Moya
230,000
157,700
Dmitri Zatsik
225,000
195,000
Vytautas Laurinaitis
215,000
159,000
Mathias Christensen
205,000
70,000
Juuso Oksanen
190,000
160,000
Mats Forss
190,000
152,400
Tanel Evert
190,000
79,500
Luka Sorainen
185,000
25,700
Dangiras Kuzulis
185,000
89,000
Viktorija Ignataviciene
165,000
82,000
Aleksandr Kuperman
150,000
112,000
Akseli Paalanen
145,000
37,600
Kevin Karenius
85,000
43,200
Edgaras Kausinis
20,000
80,000
Dinner Break Posted Tuesday 27th February, 2024 at 20:49(UTC+2) by Jason Glatzer
Players are about to head on a one-hour dinner break. We will update the full chip counts and update the results after we have also had a bite to eat.
Players Cashing for €1,200 Posted Tuesday 27th February, 2024 at 20:34(UTC+2) by Jason Glatzer
The following players including Finland's Ilari "Ziigmund" Sahamies hit the rail for €1,200 in the €555 Championship. The remaining field locked up a €200 pay raise and are guaranteed at least €1,400 with the 60-minute dinner break looming.
Place
Player
Country
Prize
56
Viacheslav Sultanov
UKR
€1,200
57
Ilari Sahamies
FIN
€1,200
58
Magnus Pukk
EST
€1,200
59
Viktor Chaikin
LVA
€1,200
60
Meelis Meliste
EST
€1,200
61
Mattias Hansen
DNK
€1,200
62
Toni Sarkama
FIN
€1,200
63
Daniel Smith
GBR
€1,200
64
Kevin Didvig
EST
€1,200
65
Pyry Kekalainen
FIN
€1,200
66
Juho Suutari
FIN
€1,200
67
Henri Tanskanen
FIN
€1,200
68
Modestas Kryzanauskas
LTU
€1,200
69
Dmitrij Bogdanov
LTU
€1,200
70
Igor Pihela Sr.
EST
€1,200
71
Ville Jantunen
FIN
€1,200
Full House for Krumins Posted Tuesday 27th February, 2024 at 20:28(UTC+2) by Jason Glatzer
Level 20: 6,000/12,000 (12,000) Entries: 56/700
There was a big pot of 400,000 with the on the board when Aleksandrs Krumins bet 100,000. Viacheslav Sultanov (pictured below winning the WSOP Circuit Tallinn ring in the €555 NLH last year) found a call.
Krumins turned over the and his fives-full of threes won the hand after Sultanov mucked his cards.
Meanwhile, Finnish poker legend Ilari Sahamies, who late registered today, ended his impressive run around the same time.
Player
Chips
Progress
Aleksandrs Krumins
700,000
50,000
Viacheslav Sultanov
140,000
80,100
Ilari Sahamies
0
0
20:14 (UTC+2)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Celebrity Special Begins Posted Tuesday 27th February, 2024 at 20:14(UTC+2) by Jason Glatzer
The much anticipated €150 Celebrity Special kicked off after all the local Estonian and Finnish celebrities were introduced by Teresa Nousiainen.
The field is already big with 260 entries. While we won't be providing English coverage of this event, we recommend you check out the Estonian coverage as they will be tracking this until a winner is crowned.
Hansen Wins Flip to Bust Oksanen Posted Tuesday 27th February, 2024 at 20:12(UTC+2) by Jason Glatzer
Level 17: 5,000/10,000 (10,000) Entries: 59/700
Mattias Hansen min-raised for 20,000 before Juuso Oksanen three-bet shoved for about a dozen big blinds from one seat over. Hansen checked out Oksanen's stack and felt comfortable calling without a count.
Juuso Oksanen: Mattias Hansen:
Oksanen fell behind on the flip after Hansen connected with his queen on the flop. Neither the turn nor the river saved the day for Oksanen and he was one of the latest players on the rail.
Player
Chips
Progress
Mattias Hansen
370,000
322,000
Pyry Kekalainen
0
0
Kevin Didvig
0
0
Daniel Smith
0
0
Toni Sarkama
0
0
Meelis Meliste
0
0
Viktor Chaikin
0
0
Juuso Oksanen
0
0
Min-Cashers Posted Tuesday 27th February, 2024 at 19:58(UTC+2) by Jason Glatzer
The following players min-cashed the €555 Championship for €1,100. The remaining 71 players earned a pay jump to €1,200.
Place
Player
Country
Prize
72
Rik Van Etten
NLD
€1,100
73
Thomas Haverstad
NOR
€1,100
74
Dominik Ostrowski
POL
€1,100
75
Markus Ylanne
FIN
€1,100
76
Kaarel Vohandu
EST
€1,100
77
Natalia Manuyko
EST
€1,100
78
Jani Tuovinen
FIN
€1,100
79
Tobias Napel
NOR
€1,100
80
Christopher Ekvall
SWE
€1,100
81
Van Akram Marcus
SWE
€1,100
82
Rain Kandla
EST
€1,100
83
Federico Dos Santos
BRA
€1,100
84
Nils Butevics
LVA
€1,100
85
Tanel Merida
EST
€1,100
86
Per Halmrast
NOR
€1,100
87
Glen Kolmer
EST
€1,100
Player
Chips
Progress
Nils Butevics
0
0
Markus Ylanne
0
0
Kaarel Vohandu
0
0
Natalia Manuyko
0
0
Jani Tuovinen
0
0
Tobias Napel
0
0
Christopher Ekvall
0
0
Van Akram Marcus
0
0
Rain Kandla
0
0
Federico Dos Santos
0
0
Thomas Haverstad
0
0
Various Big Stacks From Around the Room Posted Tuesday 27th February, 2024 at 19:47(UTC+2) by Jason Glatzer
Mikko Ylamaki held the chip lead with 76 players remaining. Check out some of the bigger stacks from around the room below:
Player
Chips
Progress
Mikko Ylamaki
850,000
725,000
Andrius Bielskis
800,000
457,000
Thor Morstol
760,000
486,000
Peder Behr
700,000
611,500
Aleksandrs Krumins
650,000
0
Matteo Cappelletti
600,000
544,900
Roope Tarmi
600,000
319,000
Christian Rysgaard
500,000
341,600
"I Got Caught" Posted Tuesday 27th February, 2024 at 19:40(UTC+2) by Jason Glatzer
Level 17: 5,000/10,000 (10,000) Entries: 84/700
Aleksandr Krumins was neck-in-neck with Mikko Ylamaki, Andrius Bielskis, Matteo Cappelletti, and Roope Tarmi at the break for the chip lead. He just pulled ahead of Tarmi after sending Tanel Merida (pictured below) to the rail.
Merida jammed for less than 10 big blinds from middle position before Krumins jammed his massive stack over the top from a few seats over. The rest of the table snap-folded and both players tabled their hands.
"I got caught," Merida admitted as he was turning over his cards.
Tanel Merida: Aleksandr Krumins:
Merida still had a chance to win the hand but despite asking for a variety of cards on the board, he didn't get what he needed and was on the rail.
Player
Chips
Progress
Aleksandrs Krumins
650,000
230,000
Tanel Merida
0
0
19:32 (UTC+2)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Third Break Posted Tuesday 27th February, 2024 at 19:13(UTC+2) by Jason Glatzer
Players are on a short 20-minute break. We will update some of the bigger stacks from around the room during the break.
Kivekas Loses Big Stack Before Bubbling €555 Championship Posted Tuesday 27th February, 2024 at 19:09(UTC+2) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 87/700
Players are in the money after Jussi Kivekas, who was on around 350,000 at the last break, lost some chips before got his stack of around 200,000 in the middle with ace-king and getting nowhere after Angel Rodriguez called with cowboys.
The remaining 87 players are in the money for at least a €1,100 min-cash just before the third break of the day.
Player
Chips
Progress
Angel Rodriguez
500,000
439,000
Jussi Kivekas
0
0
Queens Good for Arponen Posted Tuesday 27th February, 2024 at 19:03(UTC+2) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 88/700
There may have been some dynamic we missed between Tomi Arponen (pictured below) and Aleksandr Krumins.
Arponen jammed from under the gun for 90,000 and was called by Krumins from the small blind.
Tomi Arponen: Aleksandr Krumins:
"Queens again?" Krumins said with a smile. "You deserve a ten on the river."
Krumins was asking in a friendly fashion for a ten after the flop and again after the turn before he stopped himself.
"Oh, it doesn't matter anymore," Krumins said before the river completed the board.
Meanwhile, the action is hand-for-hand on the money bubble after Ridas Bitauskas hit the rail at another table.
Player
Chips
Progress
Aleksandrs Krumins
420,000
390,000
Tomi Arponen
192,000
154,100
Ridas Bitauskas
0
0
Meet and Greet on Casino Floor Posted Tuesday 27th February, 2024 at 18:50(UTC+2) by Jason Glatzer
The Kings of Tallinn is hosting a Meet & Greet with some surprises on the casino floor. This is a great mood setter before the fun €150 Celebrity Event takes place.
In other news, the time of the Celebrity Event has been officially pushed back 30 minutes and is expected to commence at 8 p.m. this evening.
Ignataviciene Doubles Through Napel With Cowboys Posted Tuesday 27th February, 2024 at 18:48(UTC+2) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 89/700
Two-time Kings of Tallinn 8-Game champion Tobias Napel opened for 20,000 from middle position. Viktorija Ignataviciene (pictured below) three-bet shoved the button for 34,000. It took some time for the action to get back around to Napel with players acting slower on the money bubble or maybe with a decision to make. However, as soon as that happened, Napel snap-called for a few chips more.
Viktorija Ignataviciene: Tobias Napel:
Ignataviciene's friends at neighboring tables and a small rail cheered for her after she doubled her stack on the board.
"Nice hand," the friend Napel said to Ignataviciene after the hand.
Ignataviciene said "thank you" to Napel as she was stacking her chips.
Meanwhile, Oleh Bohdanov and Adria Comas I Roura hit the rail to leave 89 players remaining with 87 earning at least a €1,100 min-cash.
Player
Chips
Progress
Tobias Napel
145,000
115,000
Viktorija Ignataviciene
83,000
14,700
Adria Comas I Roura
0
0
Oleh Bohdanov
0
0
Money Bubble Approaching Posted Tuesday 27th February, 2024 at 18:40(UTC+2) by Jason Glatzer
Level 16: 4,000/8,000 (8,000) Entries: 91/700
The clock recently showed the loss of five players, but we didn't notice on first glance players hitting the rail. With such a large field is it common that a handful of players don't get busted in the clock system until later, so the below players may or may not have been eliminated during Level 16.
Player
Chips
Progress
Martin Koiv
0
0
Mauri Dorbek
0
0
Luca Beretta
0
0
Kaspars Butans
0
0
Jon Gurrutxaga
0
0
18:27 (UTC+2)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Cowboys Good for Arsuns Against Kolmer Posted Tuesday 27th February, 2024 at 18:27(UTC+2) by Jason Glatzer
Level 16: 3,000/6,000 (6,000) Entries: 96/700
Glen Kolmer (pictured below) opened for a min-raise from early position. Dmitrijs Arsuns jammed for 69,000 from one seat over. The action folded around to Kolmer who tanked for around a minute before he called.
Dmitrijs Arsuns: Glen Kolmer:
Kolmer improved to a straight on the board. This wasn't a big enough improvement as Arsuns managed to stay alive and double his stack with a flush.
Meanwhile, Andrius Bielskis started Day 2 with a fresh stack and the Lithuanian poker legend, podcaster, and instructor was sitting pretty near the money bubble.
The same can't be said for the Estonian duo of Sander Leigri and Joonas Kulli who recently hit the rail to leave 96 players remaining with 87 players getting in the money for at least a €1,100 min-cash.
Player
Chips
Progress
Andrius Bielskis
343,000
313,000
Dmitrijs Arsuns
155,000
30,400
Glen Kolmer
150,000
76,100
Joonas Kulli
0
0
Sander Leigri
0
0
€1,100 PLO Championship in Action Posted Tuesday 27th February, 2024 at 18:13(UTC+2) by Jason Glatzer
The €1,100 Pot-Limit Omaha Championship, which rotates between PLO4 and PLO5, kicked off about an hour ago and was up to 45 entries during Level 3 with 42 players remaining.
Former Kings of Tallinn Main Event champion Matias Knaapinen, Estonian poker star Markku Koplimaa, Finnish journalist and poker legend Aki Pyysing, and Norway's Vidar Assersen (pictured below), who recently busted from the €555 Championship, are all among the players in action.
There is still plenty of time to hop in with late registration open for nine 30-minute levels and not closing until just before 10 p.m.
Konttinen Runs Nines Into Turja's Cowboys Posted Tuesday 27th February, 2024 at 18:06(UTC+2) by Jason Glatzer
Level 16: 3,000/6,000 (6,000) Entries: 98/700
Juhana Konttinen three-bet jammed from the blinds for about 15 big blinds and was called by Ville Turja.
Juhana Konttinen: Ville Turja:
Kings held for Turja on the board to eliminate Konttinen with the money bubble quickly approaching.
Player
Chips
Progress
Ville Turja
185,000
127,400
Stefan Jansson
0
0
Martins Priede
0
0
Max Rotko
0
0
Elias Suhonen
0
0
Artur Kulanurk
0
0
Simon Persson
0
0
Jarkko Suokas
0
0
Mathias Siljander
0
0
Stanislav Smeljov
0
0
Dmitrijs Rizovs
0
0
Juhana Konttinen
0
0
17:56 (UTC+2)
Start of Level 17 Blinds: 3,000/6,000 Ante: 6,000
Lucky Double for Kausinis Posted Tuesday 27th February, 2024 at 17:56(UTC+2) by Jason Glatzer
Level 15: 2,000/5,000 (5,000) Entries: 108/700
Edgaras Kausinis recently won the Vilnius Ace Breaker €1,100 High Roller for more than €22,000 and is hoping to add a bigger score in the €555 Championship at the Kings of Tallinn.
Kausinis had a short stack of 42,000 when he jammed under the gun. Natalia Manuyko jammed for a little more from the small blind and was ahead after the cards were turned over.
Edgaras Kausinis: Natalia Manuyko:
Kausinis improved to a full house on the board to double through Manuyko.
Player
Chips
Progress
Edgaras Kausinis
100,000
70,000
Natalia Manuyko
10,000
79,000
Andres Allsalu
0
0
Mihn Thang Ngo
0
0
Vidar Assersen
0
0
Kriss Riekstins
0
0
Michael Ibba
0
0
Mirco De Martini
0
0
Roi Gibstein
0
0
Per Engstrom
0
0
Riku Hanninen
0
0
Eduards Rakuss
0
0
Tarmo Tammel
0
0
Meet Joni Liimatta at the 2024 Kings of Tallinn Posted Tuesday 27th February, 2024 at 17:32(UTC+2) by Jason Glatzer
Ertinhajevs Eliminates Lampinen Posted Tuesday 27th February, 2024 at 17:30(UTC+2) by Jason Glatzer
Level 15: 2,000/5,000 (5,000) Entries: 126/700
Sultans Ertinhajevs opened for 10,000 from the button. Jyrki Lampinen (pictured below) three-bet shoved for around 70,000. Ertinhajevs paused for a few moments before he called.
Jyrki Lampinen: Sultans Ertinhajevs:
A moan of what appeared to be pain came out of Lampinen after the call and again after the flop. He lost a few outs with his opponent holding a flush draw on the turn and was already out of his chair by the time he bricked the river to hit the rail to Ertinhajevs's pair of aces.
Player
Chips
Progress
Sultans Ertinhajevs
320,000
232,000
Jyrki Lampinen
0
0
Maciej Komorowski
0
0
Paul-Richard Argus
0
0
Martynas Kaulakis
0
0
Urmo Velvelt
0
0
Jonathan Walker
0
0
Doroslav Rasiukevic
0
0
Algirdas Saveikis
0
0
Johan Alen
0
0
Germans Grigorjevs
0
0
Jimi Koponen
0
0
Sakari Setala
0
0
Big Stacks at Break Posted Tuesday 27th February, 2024 at 17:11(UTC+2) by Jason Glatzer
Level 15: 2,000/5,000 (5,000) Entries: 139/700
Niklas Gjersvold and Adrians Imsa (pictured below from the 2023 WSOP Circuit Tallinn) were both above 400,000 at the break with 139 players remaining. Check out some of the bigger stacks from around the room.
Player
Chips
Progress
Niklas Gjersvold
434,000
350,700
Adrians Imsa
429,000
354,400
Jordi Baixas
388,000
340,300
Jussi Kivekas
348,000
223,900
Svetozar Marinov
322,000
293,300
Roope Tarmi
281,000
191,000
Thor Morstol
274,000
244,000
Dangiras Kuzulis
274,000
165,400
Anna-Mari Hursti
0
0
Neil Godfrey
0
0
Hendry Kullamae
0
0
17:10 (UTC+2)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Break Time Posted Tuesday 27th February, 2024 at 16:48(UTC+2) by Jason Glatzer
Players are on a 20-minute break. We will update with some of the bigger stacks from around the room shortly after the break.
Player
Chips
Progress
Morten Norland
0
0
Mindaugas Kriauciunas
0
0
Ville Lonngren
0
0
Heikki Piira
0
0
Payouts Announced - 87 Paid & €65K to the Winner Posted Tuesday 27th February, 2024 at 16:42(UTC+2) by Jason Glatzer
A small adjustment was made and the official field was 700 entries for the record-breaking 2024 Kings of Tallinn €555 Championship.
The top 87 players will go home with at least a €1,100 payout with tomorrow's winner taking home €65,360 for a new record top prize for this event.
The field is down to 146 players with a break approaching. The full payouts will be in the "Payouts" tab embedded in our coverage shortly.
Best of luck to all of the players!
Player
Chips
Progress
Thomas Larsen
0
0
Kent Wulff
0
0
Georgios Tsouloftas
0
0
Sjoerd Nikkels
0
0
"White Chocolate" Runs Into Trips Posted Tuesday 27th February, 2024 at 16:36(UTC+2) by Jason Glatzer
Level 15: 2,000/4,000 (4,000) Entries: 168/701
Heikki Piira opened from the button before Irmantas Bzeskis, always dressed in NBA jerseys whenever playing in Tallinn with today's choice being Jason "White Chocolate" Williams, defended his big blind. Both players checked the flop before Bzeskis got his stack in the middle after the paired the board on the turn. Piira with more than a dozen big blinds in his stack was covered.
Heikki Piira: Irmantas Bzeskis:
Bzeskis was ahead until the turn with his two pair but needed the board to double-pair with a queen. Instead, the river completed the board for Piira to double through Bzeskis.
Bzeskis dusted off his two big blinds he had left shortly after to end his run. He was joined by 2023 Kings of Tallinn Summer Showdown €555 Championship trophy winner Maikel Homin on the rail.
Player
Chips
Progress
Heikki Piira
130,000
100,000
Kaupo Tenno
0
0
Maikel Homin
0
0
Mati Pirn
0
0
Masse Mirza
0
0
Jari Saviaho
0
0
Tuomas Jalonen
0
0
Lukas Kviecinskas
0
0
Mikael Haapaniemi
0
0
Ignas Navickas
0
0
Juan Carlos Vecino Deunas
0
0
Irmantas Bzeskis
0
0
Straight Flush for Smith Posted Tuesday 27th February, 2024 at 16:19(UTC+2) by Jason Glatzer
Level 15: 2,000/4,000 (4,000) Entries: 168/701
We have seen two players win tournaments this week with royal flushes as their final hand. While this might be one hand shy of a royal flush in hand rankings, a straight flush in hold'em doesn't happen every day either.
Matiss Celmins jammed a relatively short stack on the board and was instantly called by Daniel Smith.
Celmins turned over the for a queen-high straight. Smith tabled the for the flopped straight flush to eliminate Celmins.
Meanwhile, local fan favorite Jari Hurri was on the rail and shared it was a bad beat with ace-queen against ace-jack. Meanwhile, fellow Finn Tero Kirkanen shared he hit the rail as well after his king-ten proved to be no good against ace-nine.
Player
Chips
Progress
Daniel Smith
160,000
10,500
Christian Hoffmann
0
0
Tero Kilkanen
0
0
Jose Koistinen
0
0
Ivo Rohula
0
0
Jari Hurri
0
0
Ari Soini
0
0
Thomas Syversen
0
0
Oleksii Lubnin
0
0
Rasmus Lundstrom
0
0
Allan Arjut
0
0
Jari Porkka
0
0
Matiss Celmins
0
0
16:12 (UTC+2)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Players Filing Into the €250 NLH Posted Tuesday 27th February, 2024 at 16:01(UTC+2) by Jason Glatzer
Event #25: €250 NLH began less than an hour ago and is up to 77 entries near the end of Level 3. Players start with 20,000 in chips with blinds increasing every 20 minutes.
Many players eliminated from the €555 Championship are beginning to file into the €250 NLH including Haukur Bodvarsson, Dmitri Dudakov (pictured below), Erikas Gordejevas, Maksim Han, Richard Koppel, and James Noonan.
Best of luck to all of the €250 NLH players. The €1,100 Pot Limit Omaha Championship will be the next event to kick off starting at 9 p.m.
Parkkinen Runs Into Two Pair; Inaugural KoT Main Event Champ Sootla on the Rail Posted Tuesday 27th February, 2024 at 15:56(UTC+2) by Jason Glatzer
Level 14: 1,500/3,000 (3,000) Entries: 184/701
Mathias Christensen jammed for 46,000 into a pot of slightly more with the already on the board after the turn and was called by Kalle Parkkinen for his stack of less than 40,000.
Mathias Christensen: Kalle Parkkinen:
Parkkinen was already out of his chair and began walking away even before he was officially eliminated after the river delivered the .
"I had him covered, right?" Christensen said.
"Let's do a count," said the dealer.
The count confirmed that Christensen had his opponent covered by about three big blinds for Parkkinen to officially hit the rail.
Meanwhile, inaugural Kings of Tallinn Main Event champion and WSOP Circuit Tallinn ring winner Ranno Sootla (pictured below) and many others hit the rail during Level 14.
Player
Chips
Progress
Mathias Christensen
135,000
85,700
Kalle Parkkinen
0
0
Paul Newey
0
0
Aurelijus Sipavicius
0
0
Rait Kaimer
0
0
Ranno Sootla
0
0
Daniel Palsson
0
0
Oleksandr Tarashevskyi
0
0
Nils Burman
0
0
Sven Omland
0
0
Priit Vanem
0
0
Andrei Silencov
0
0
Juha Kaitanen
0
0
Kris Tikka
0
0
Juuso Kauppi
0
0
Eliminations at the End of Level 13 Posted Tuesday 27th February, 2024 at 15:37(UTC+2) by Jason Glatzer
Player
Chips
Progress
Pekka Ikonen
0
0
Roberts Rumba
0
0
Karri Uusi-Aijo
0
0
Mark Metsla
0
0
Erikas Gordejevas
0
0
Matias Knaapinen
0
0
Rytis Pranarauskas
0
0
Tonis Viik
0
0
Laurynas Cerniauskas
0
0
Markku Koplimaa
0
0
Jon Martinez
0
0
Svjatoslav Plohhotnitsenko
0
0
15:30 (UTC+2)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Saviaho Ousts Koppe Posted Tuesday 27th February, 2024 at 15:27(UTC+2) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 213/701
2024 Kings of Tallinn €555 PL Omaha 4 & 5 Cards Mystery Bounty champion Paul Koppe jammed for 25,000 from the cutoff.
Jari Saviaho (pictured below), who later entered on Day 2, asked for a count and appeared deep in thought for more than a minute before finding a call.
Paul Koppe: Jari Saviaho:
Koppe connected with his eight on the runout but tapped the table while getting ready to leave with Saviaho trumping him after flopping the top pair with his king.
Player
Chips
Progress
Jari Saviaho
120,000
90,000
Paul Koppe
0
0
Tanel Tammela
0
0
Boris Smolianskii
0
0
Semir Natzi
0
0
Audrius Navickas
0
0
Tarmo Anton
0
0
Rain Heeringas
0
0
Henri Antikainen
0
0
Oskar Ojaveer
0
0
Antonios Onoufriou
0
0
Day 4 Video Highlights Posted Tuesday 27th February, 2024 at 15:20(UTC+2) by Jason Glatzer
Check out the video highlights below from yesterday's Day 4 of the 2024 Kings of Tallinn at Olympic Park Casino and the Hilton Tallinn Park.
Ace-Ten is Running Hot Posted Tuesday 27th February, 2024 at 15:13(UTC+2) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 232/701
We recently reported how Martin Piik lost most of his stack against Juha Kaitanen with kings against ace-ten. Piik unfortunately hit the rail soon after but ace-ten just after that was hot on another table in a hand between Oleksandr Tarashevskyi and Sjoerd Nikkels.
We caught up with the action with Nikkels having his 30,000 chip stack in the middle and Tarashevskyi having his bigger stack of 76,500 also committed. Thor Morstal had a 10,000 chip already committed from the previous betting and went into the tank before opting to fold.
Sjoerd Nikkels: Oleksandr Tarashevskyi:
Things weren't looking rosy for Nikkels after Tarashevskyi improved to a set of cowboys on the flop.
However, it was de ja vu on the turn pushing Karjalainen ahead with Broadway.
"Oh, wow!" Karjalainen said softly with pure delight in his voice.
Tarashevskyi had outs to a full house or quads but the blank river didn't deliver either for Nikkels to double his stack instead of hitting the rail.
Player
Chips
Progress
Matte Karjalainen
75,000
55,000
Sjoerd Nikkels
55,000
7,300
Viktor Eriksson
0
0
Rasmus Aavisto
0
0
Eduard Kruglov-Arutiunian
0
0
Richard Koppel
0
0
Christian Fuglholt
0
0
Santtu Leinonen
0
0
Jimmy Dewerdt
0
0
Martti Keel
0
0
Joel Haapio
0
0
George Sandford
0
0
Alberto Gonzalez
0
0
Martin Piik
0
0
Gun-Britt Stahl Eriksson
0
0
Unlucky Cowboys for Piik Posted Tuesday 27th February, 2024 at 15:00(UTC+2) by Jason Glatzer
Level 13: 1,000/2,500 (2,500) Entries: 248/701
Martin Piik (pictured below) and Juha Kaitanen both came in for fresh stacks during Day 2 of the €555 Championship.
Piik min-raised from under the gun before Kaitanen jammed for 29,000 from one seat over. Piik quickly called when the action folded to him and barely had Kaitanen covered.
Juha Kaitanen: Martin Piik:
Piik was ahead when the chips went in but fell far behind after Kaitanen improved to two pair on the flop. Things got worse for Piik and better for Kaitanen after the followed on the turn as Piik was now drawing dead to Kaitanen's full house.
The river made the hand official and Piik was short on chips after doubling Kaitanen.
Player
Chips
Progress
Juha Kaitanen
65,000
35,000
Martin Piik
10,000
20,000
Teemu Kailasvuo
0
0
701 Entries for a €322,460 Prize Pool Posted Tuesday 27th February, 2024 at 14:50(UTC+2) by Jason Glatzer
Level 12: 1,000/2,000 (2,000) Entries: 248/701
Late registration just closed and the field squeaked past 700 entries with 701 entries generating a record-breaking €322,460 prize pool for a €555 event in Estonia.
The tournament staff will be double and triple checking the prize pool information and shortly after will be sharing the prize pool payouts.
Best of luck to the remaining 248 players in advancing to the money and beyond in the 2024 Kings of Tallinn €555 Championship.
14:48 (UTC+2)
Start of Level 13 Blinds: 1,000/2,500 Ante: 2,500
Late Registration Closes After Break Posted Tuesday 27th February, 2024 at 14:20(UTC+2) by Jason Glatzer
Players are playing their final three hands at each table before heading on their first break of Day 2. There are a gaggle of players waiting near the registration desk to late enter at the very last moment, so expect the field of 686 entries to grow before late registration is closed after the break.
We will start updating the biggest stacks from around the room on the second break but we will share the payouts before then as soon as they are available.
Flip on Break for Mystery Bounty Flip & Go Glory Posted Tuesday 27th February, 2024 at 14:06(UTC+2) by Jason Glatzer
The second and final day of the €150 OlyBet Flip & Go Mystery Bounty takes place on the final day of the Kings of Tallinn on Sunday, March 3 when at least a €10,000 top mystery bounty prize is guaranteed.
This isn't like any other mystery bounty event as players will need to flip their way into the money in one-hand flips. The flips will run all week long starting on the first break after Level 3.
It is worth dropping by the flips table whether you plan to flip or not as they always provide tons of excitement and drama. Best of luck if you decide to flip away in advancing to Day 2.
Player
Chips
Progress
Maksim Petrov
0
0
Bengt Blad
0
0
Vladislav Han
0
0
Serguei Palomera
0
0
Audrius Navickas
0
0
Haukur Bodvarsson
0
0
Anton Pereyaslov
0
0
Juha Kinnunen
0
0
Robert Schiffbauer
0
0
€300K+ Prize Pool Achieves New Event Milestone Posted Tuesday 27th February, 2024 at 14:01(UTC+2) by Jason Glatzer
Level 12: 1,000/2,000 (2,000) Entries: 260/666
The milestones keep coming in the Kings of Tallinn €555 Championship. For the first time in festival history, the prize pool has grown beyond €300,000 with its currently standing at €306,360 with a devilish 666 entries.
"I Only Saw One Card" Posted Tuesday 27th February, 2024 at 13:58(UTC+2) by Jason Glatzer
Level 12: 1,000/2,000 (2,000) Entries: 265/649
The field keeps on getting bigger and bigger but Israel's Dror Amiram will need to re-enter if he wants a chance a snagging a piece of the nearly €300,000 prize pool and growing.
Amiram jammed his short stack of 8,200 and was looked up by Mikko Ylamaki (pictured below).
"I only saw one card," Amiram admitted. "It's just about a flip."
It wasn't exactly a flip with Amiram eventually turning over the and Ylamaki tabling the
Amiram was out of his seat as he fell further behind on the flop. But then was teased by pulling ahead with his three outer after connecting with the turn.
The tables were turned as Ylamaki improved to a set of sixes to win the hand after the spiked the river.
Player
Chips
Progress
Mikko Ylamaki
125,000
47,700
Paul Newey
30,000
0
Gustaf Soderholm
0
0
Jukka Moisio
0
0
Jose Larios Domene
0
0
Aleksi Naski
0
0
Karri Uusi-Aijo
0
0
Toomas Nurme
0
0
Stein Naerland
0
0
Dror Amiram
0
0
Torsti Kettula
0
0
Benjamin Gros
0
0
Matte Karjalainen
0
0
Markus Pohjola
0
0
Mattias Hansen
0
0
Jethro Rostedt
0
0
Heiko Hinkelmann
0
0
Dennis Zetterman
0
0
Tomas Karvall
0
0
Arto Loikkanen
0
0
Marius Morel
0
0
Pasi Trollhjarta
0
0
13:40 (UTC+2)
Start of Level 12 Blinds: 1,000/2,000 Ante: 2,000
Set of Ladies for Komorowski Posted Tuesday 27th February, 2024 at 13:32(UTC+2) by Jason Glatzer
Level 11: 1,000/1,500 (1,500) Entries: 283/627
Maciej Komorowski bet 7,500 into a pot of approximately 27,000 with already spread on the flop. Matte Karjalainen called before both players checked the turn.
Komorowski bet 22,000 after the river completed the board and Karjalainen went into the tank for several minutes. He counted his chips, began shaking his head, then asked the dealer to spread the pot before repeating shaking his head and recounting his chips. Karjalainen eventually opted to call only to muck his hand after Komorowski tabled the for a set of ladies.
Player
Chips
Progress
Maciej Komorowski
145,000
38,100
Matte Karjalainen
20,000
21,800
Herli Olop
0
0
Ari Varonen
0
0
Sergejs Kacapovs
0
0
Sjoerd Nikkels
0
0
Evgeny Kerimov
0
0
Juho Heiska
0
0
Aleksandr Gamonovits
0
0
Mairo Tori
0
0
Petteri Miettinen
0
0
Elias Vaaraniemi
0
0
Marko Vest
0
0
Palsson Wins Three-Way Pot With Rockets Posted Tuesday 27th February, 2024 at 13:13(UTC+2) by Jason Glatzer
Level 11: 1,000/1,500 (1,500) Entries: 293/609
Iceland's Daniel Paulsson had his near starting stack in the middle and was up against two players with Roope Holma holding a much shorter stack and Grigory Zima involved with a bigger stack.
Roope Holma: Daniel Palsson: Grigory Zima:
Rockets were more than enough on the runout for Paulsson to eliminate Holma while doubling through Zima.
Player
Chips
Progress
Daniel Palsson
80,000
50,000
Grigory Zima
70,000
9,700
Roope Holma
0
0
Joel Haapio
0
0
Jevgenijs Kritinins
0
0
Steponas Venckus
0
0
Viktor Blinov
0
0
Gustavs Svinka
0
0
Robert Kontkanen
0
0
Raimo Reimann
0
0
Maher Mahmoud
0
0
12:57 (UTC+2)
Start of Level 11 Blinds: 1,000/1,500 Ante: 1,600
600 Entries in the €555 Championship! Posted Tuesday 27th February, 2024 at 12:57(UTC+2) by Jason Glatzer
The 2024 Kings of Tallinn €555 Championship has just reached 600 entries for the first time in history.
At the time, half the field was left with 300 entries bringing alot of clean figures to the table.
Ace-High Enough for Rostedt Posted Tuesday 27th February, 2024 at 12:38(UTC+2) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 303/594
Elias Vaaraniemi opened for a min-raise from middle position before Jethro Rostedt called from the button. Heiko Hinkelmann three-bet to 8,000 from the button. Vaaraniemi quickly folded before Rostedt jammed for 19,900. Hinkelmann snap-called with Rostedt at risk.
Jethro Rostedt: Heiko Hinkelmann:
Rostedt's ace-high is all it took to double through Hinkelmann after the board bricked both players.
Player
Chips
Progress
Wissam Polus
0
0
Kaspars Burka
0
0
Trips for Pohjola to Double Through Beretta Posted Tuesday 27th February, 2024 at 12:36(UTC+2) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 302/585
Luca Beretta (pictured below) opened for 2,500 from middle position. Markus Pohjola jammed for 19,900 from the big blind. Beretta paused for a few seconds before he called.
Markus Pohjola: Luca Beretta:
Pohjola doubled his stack after winning the flip with trips with the running out on the board.
Player
Chips
Progress
Luca Beretta
57,000
20,700
Markus Pohjola
43,000
6,600
Reese Smith
0
0
New Kings of Tallinn Record! Posted Tuesday 27th February, 2024 at 12:26(UTC+2) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 299/579
Tournament Director Teresa Nousiainen announced that the €555 Championship has already established a new record at the Kings of Tallinn previously shattering the 573 entries attracted during the 2023 Kings of Tallinn Summer Showdown €555 Championship.
Now it is just a matter of how big it will get with nearly two hours of late registration.
Player
Chips
Progress
Martin Piik
30,000
10,200
Juho Suutari
0
0
Andre Al-Khabbaz
0
0
New Entries to Start Day 2 Posted Tuesday 27th February, 2024 at 12:22(UTC+2) by Jason Glatzer
Below are some of the players to enter or re-enter thus far on Day 2.
Player
Chips
Progress
Audrius Skucas
30,000
0
Robert Kontkanen
30,000
0
Torsti Kettula
30,000
0
Evgeny Kerimov
30,000
0
Martynas Kaulakis
30,000
0
Juha Kaitanen
30,000
0
Germans Grigorjevs
30,000
0
Neil Godfrey
30,000
0
Jimmy Dewerdt
30,000
0
Matiss Celmins
30,000
0
Aleksandrs Krumins
30,000
0
Igor Pihela Sr.
30,000
0
Roberts Rumba
30,000
0
Tonis Viik
30,000
0
Mairo Tori
30,000
0
Kaupo Tenno
30,000
0
Henri Tanskanen
30,000
0
Thomas Syversen
30,000
0
Gustavs Svinka
30,000
0
Ari Soini
30,000
0
Aurelijus Sipavicius
30,000
0
Mati Pirn
30,000
0
Andrius Bielskis
30,000
0
Day 2 Begins With 42 New Entries Posted Tuesday 27th February, 2024 at 12:20(UTC+2) by Jason Glatzer
Level 10: 600/1,200 (1,200) Entries: 292/570
The field has already grown by 42 entries to 570 entries and counting before the start of play for a prize pool north of a quarter of a million euros.
The field will continue to grow until after the first break with late registration still open. Meanwhile, cards are now in the air for Day 2. Best of luck to all players in reaching the money and beyond.
12:04 (UTC+2)
Day 2 of Kings of Tallinn 2024 Started Level: 10 Blinds: 600/1,200 Ante: 1,200
Welcome to Day 2 of the €555 Championship Posted Tuesday 27th February, 2024 at 10:09(UTC+2) by Jason Glatzer
The past two days the Kings of Tallinn have witnessed 528 entries battle it out during the four opening flights of the €555 Championship leaving just 250 players with chips on Day 2 with the prize pool currently standing at €242,880.
These figures will increase and there is a good chance a new record will be established for this event at the Kings of Tallinn with late registration open for the first three 40-minute blind levels of Day 2 along with the 15-minute break that follows. The previous record of 573 entries was recently established at the 2023 Kings of Tallinn Summer Showdown won by Estonia's Maikel Homin for €56,900.
The event has an international feel as one can see by just taking a look at the top ten chip counts heading into the second day with seven different nationalities represented. Sweden's Bengt-Anders Johnsson was the only player to advance with more than 200,000 in chips after bagging up 212,600 on Day 1c. Estonian's Martti Keel (183,700), Ukraine's Mykhailo Mikhalov (180,600), Bulgaria's Presiyan Tsvetanov (179,200), and Estonia's Magnus Pukk (177,800) round out the top five heading into Day 2.
Place
Player
Country
Chips
Big Blinds
1
Bengt-Anders Johnsson
Sweden
212,600
177
2
Martti Keel
Estonian
183,700
153
3
Mykhailo Mikhalov
Ukraine
180,600
151
4
Presiyan Tsvetanov
Bulgaria
179,200
149
5
Magnus Pukk
Estonian
177,800
148
6
Georgios Tsouloftas
Cyprus
170,100
142
7
Juhana Konttinen
Finland
166,600
139
8
Luka Sorainen
Finland
159,300
133
9
Christian Rysgaard
Lithuania
158,400
132
10
Mauri Dorbek
Estonian
151,000
126
The plan for the second day is to play down to a final table, which will then be broadcasted on a 30-minute delay with hole cards exposed on Wednesday at OlyBet.tv.
In the meantime, our coverage on Tuesday commences as soon as cards are in the air for Day 2 at noon. Follow along the action here in English, or if you prefer you can head on over with easy access via this blog to the Estonian and Finnish language blogs focusing mostly on players from these countries.
Day 2 Seat Draw Posted Tuesday 27th February, 2024 at 02:45(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Heiko Hinkelmann
15,400
13
1
2
Audrius Navickas
23,600
20
1
4
Peder Behr
88,500
74
1
5
Elias Vääräniemi
18,600
16
1
6
Rodriguez Alonso
61,000
51
1
7
Magnus Pukk
177,800
148
1
8
Jethro Rostedt
75,300
63
2
1
Masse Mirza
25,000
21
2
2
Algirdas Saveikis
35,600
30
2
3
Kris Tikka
42,500
35
2
4
Ignas Navickas
75,100
63
2
5
Tomi Arponen
37,900
32
2
6
Meelis Meliste
86,300
72
2
8
Viktor Eriksson
69,600
58
3
1
Nils Burman
29,700
25
3
2
Federico Dos Santos
57,800
48
3
3
Vytautas Laurinaitis
56,000
47
3
4
Mindaugas Kriauciunas
55,700
46
3
5
Jukka Moisio
53,400
45
3
6
Anna-Mari Hursti
109,000
91
3
8
Sakari Setälä
58,200
49
4
1
Petteri Miettinen
18,200
15
4
2
Mykhailo Mikhalov
180,600
151
4
3
Glen Kolmer
73,900
62
4
5
Laurynas Cerniauskas
37,300
31
4
6
Viktor Blinov
11,600
10
4
7
Mark Metsla
35,200
29
4
8
Emil Hovmark
74,200
62
5
1
Matteo Cappelletti
55,100
46
5
2
Maikel Homin
114,600
96
5
3
Dmitrijs Arsuns
124,600
104
5
6
Grigory Zima
60,300
50
5
7
Andrii Momot
37,800
32
5
8
Roope Holma
21,100
18
6
1
Riku Hänninen
62,200
52
6
2
Daniel Smith
149,500
125
6
3
Kaarel Võhandu
41,400
35
6
4
Sebastian Wahl
116,600
97
6
5
Paulius Jucys
29,400
25
6
6
Juho Heiska
39,800
33
6
7
Mart Tammoja
59,200
49
7
1
Tanel Tammela
56,500
47
7
2
Pyry Kekäläinen
36,600
31
7
3
Michael Ibba
77,900
65
7
4
Toni Sarkama
60,500
50
7
5
Konsta Heikkilä
32,000
27
7
6
Thomas Haverstad
55,500
46
7
8
Vidar Assersen
87,400
73
8
1
Johan Palokangas
23,400
20
8
2
Jimi Koponen
88,800
74
8
3
Nicolas Courbin
22,400
19
8
5
Kaspars Mamons
26,500
22
8
6
Christopher Ekvall
82,200
69
8
7
Ridas Bitauskas
76,700
64
8
8
Kevin Karenius
41,800
35
9
1
Eli Malca
4,400
4
9
2
Juuso Kauppi
62,300
52
9
3
Dmitri Dudakov
19,000
16
9
4
Eduards Rakuss
51,100
43
9
5
Svetozar Marinov
28,700
24
9
6
Risto Pärnat
90,500
75
9
8
Viktorija Ignataviciene
68,300
57
10
1
Akseli Paalanen
107,400
90
10
2
Oleksii Lubnin
73,900
62
10
3
Juho Suutari
10,300
9
10
4
Pekka Ikonen
22,300
19
10
6
Martti Keel
183,700
153
10
7
Dror Amiram
91,200
76
10
8
Mikko Ylämäki
77,300
64
11
1
Rasmus Aavisto
62,100
52
11
2
Niklas Gjersvold
83,300
69
11
3
Oscar Peleg
130,800
109
11
4
Denis Rebouh
28,100
23
11
6
Georgios Tsouloftas
170,100
142
11
7
Santtu Leinonen
110,300
92
11
8
Matias Knaapinen
47,000
39
12
1
Gundars Zelcs
132,200
110
12
2
Kaspars Mallons
55,900
47
12
3
Anton Pereyaslov
47,200
39
12
5
Artjoms Skvarkovskis
42,000
35
12
6
Mirco De Martini
62,700
52
12
7
Dmitrij Bogdanov
147,400
123
12
8
Wissam Polus
77,500
65
13
1
Steponas Venckus
43,500
36
13
2
Andrejs Perederejevs
33,900
28
13
3
Henri Antikainen
106,800
89
13
4
Aleksandr Kuperman
38,000
32
13
5
Vladislav Han
71,000
59
13
6
Tarmo Tammel
37,000
31
13
8
Kevin Didvig
95,700
80
14
1
Eldars Sadih-Zade
78,000
65
14
2
Sergejs Kacapovs
43,300
36
14
3
Markus Pohjola
49,600
41
14
4
Tero Kilkanen
27,300
23
14
5
Luca Beretta
77,700
65
14
6
Nils Butevics
26,700
22
14
7
Maher Mahmoud
90,000
75
15
1
Artur Külanurk
42,700
36
15
3
Reese Smith
6,300
5
15
4
Joel Ylismäki
48,700
41
15
5
Sander Leigri
107,700
90
15
6
Vadim Guk
40,000
33
15
7
Priit Vanem
71,000
59
15
8
Per Halmrast
88,800
74
16
1
Lucas Cravero
38,500
32
16
2
Tanel Merida
73,600
61
16
3
Joonas Helin
54,300
45
16
4
Juhana Konttinen
166,600
139
16
6
Markus Ylänne
59,000
49
16
7
Per Engström
37,900
32
16
8
Ville-Oskari Turja
57,600
48
17
1
Martin Piik
19,800
17
17
2
Viktor Chaikin
85,600
71
17
4
Richard Koppel
57,800
48
17
5
Ari Varonen
34,300
29
17
6
Jevgenijs Kritinins
39,300
33
17
7
Dangiras Kuzulis
108,600
91
17
8
Rait Kaimer
27,100
23
18
1
Rytis Pranarauskas
81,900
68
18
2
Arto Loikkanen
25,200
21
18
3
Stanislav Smeljov
32,200
27
18
4
Morten Norland
137,400
115
18
5
Jussi Kivekäs
124,100
103
18
7
Jose Koistinen
101,000
84
18
8
Gustaf Söderholm
53,900
45
19
2
Svjatoslav Plohhotnitsenko
62,600
52
19
3
Oleksandr Tarashevskyi
48,400
40
19
5
Kent Wulff
16,500
14
19
6
Domene Larios
80,500
67
19
7
Serguei Palomera
65,100
54
19
8
Hans Erlandsson
80,500
67
20
1
Ville Lönngren
63,500
53
20
2
Baixas Conejos
47,700
40
20
4
Hans Bergström
25,800
22
20
5
Rain Kandla
59,000
49
20
6
Jonatan Fors
70,700
59
20
7
Haukur Bodvarsson
148,300
124
20
8
Lukas Kviecinskas
67,500
56
21
1
Gonzalez Martinez
38,600
32
21
2
Mathias Christensen
49,300
41
21
3
Moya Guinot
72,300
60
21
4
Kalle Parkkinen
71,600
60
21
5
Presiyan Tsvetanov
179,200
149
21
6
Hendry Kullamäe
145,600
121
21
7
Gun-Britt Stahl Eriksson
33,600
28
22
1
Roi Gibstein
41,900
35
22
2
Kriss Riekstins
74,700
62
22
4
Andres Allsalu
51,900
43
22
5
Oleksandr Shokur
16,400
14
22
6
Natalia Manuyko
89,000
74
22
7
Irmantas Bzeskis
39,100
33
22
8
Andre Al-Khabbaz
19,200
16
23
1
Kristian Kostiander
35,500
30
23
2
Touko Berndtson
106,700
89
23
3
Sjoerd Nikkels
47,700
40
23
4
Aleksandr Gamonovits
73,000
61
23
5
Martins Priede
78,800
66
23
7
Modestas Kryzanauskas
108,700
91
23
8
Adrian Espinosa
19,100
16
26
1
Bengt-Anders Johnsson
212,600
177
26
2
Christian Fuglholt
123,700
103
26
3
Maciej Komorowski
106,900
89
26
4
Pasi Trollhjärta
20,100
17
26
5
Jonathan Walker
26,800
22
26
7
Matte Karjalainen
41,800
35
26
8
Boris Smolianskii
51,100
43
27
1
Sven Omland
68,800
57
27
2
Jari Porkka
45,400
38
27
3
Tadas Pranckevicius
32,200
27
27
5
Joel Haapio
62,200
52
27
6
Max Rotko
26,600
22
27
7
Christian Hoffman
52,900
44
27
8
Maksim Petrov
31,800
27
28
2
Mikael Haapaniemi
81,400
68
28
3
Dennis Zetterman
21,000
18
28
4
Christian Rysgaard
158,400
132
28
5
Herli Olop
47,300
39
28
6
Thomas Larsen
42,900
36
28
7
Benjamin Gros
35,200
29
28
8
Rain Heeringas
37,200
31
29
1
Paul-Richard Argus
45,000
38
29
3
Allan Arjut
9,200
8
29
4
Johan Alen
33,600
28
29
5
Tarmo Anton
93,700
78
29
6
Elias Suhonen
96,000
80
29
7
Kaspars Burka
64,300
54
29
8
Stefan Jansson
61,500
51
30
1
Juha Kinnunen
33,800
28
30
2
Robert Schiffbauer
37,600
31
30
3
Adrians Imsa
74,600
62
30
4
Sultans Ertinhajevs
88,000
73
30
5
Kasper Mellanen
52,300
44
30
7
Rasmus Lundström
105,400
88
30
8
Arto Lehtonen
23,500
20
31
1
Tuomas Jalonen
59,200
49
31
2
Erikas Gordejevas
94,200
79
31
3
Viacheslav Sultanov
59,900
50
31
4
Robles Serrano
58,900
49
31
6
Mazen Shaba
78,200
65
31
7
Oleh Bohdanov
28,400
24
31
8
Matiss Kirsfelds
73,000
61
32
1
Mart Rinken
49,200
41
32
2
Mats Forss
37,600
31
32
3
Alba Gurrutxaga
93,700
78
32
4
Marko Vest
38,000
32
32
5
Jari Hurri
62,200
52
32
7
Jon Martinez
54,500
45
32
8
Joonas Kulli
52,800
44
33
1
Adria Comas I Roura
50,300
42
33
2
Jyrki Lampinen
86,800
72
33
4
George Sandford
35,100
29
33
5
Luka Sorainen
159,300
133
33
6
Karri Uusi-Äijö
32,400
27
33
7
Mihn Ngo
62,800
52
33
8
Tomas Karvall
24,600
21
34
1
Simon Persson
125,000
104
34
2
Eduard Kruglov-Arutiunian
46,500
39
34
4
Semir Natzi
33,800
28
34
5
Ivo Rohula
43,300
36
34
6
Serhii Leonov
145,700
121
34
7
Roope Tarmi
90,000
75
34
8
Andrei Silencov
31,100
26
35
1
Jani Vilmunen
78,600
66
35
2
Marcin Niedzwiecki
74,800
62
35
3
Aleksi Naski
55,500
46
35
4
Antonios Onoufriou
16,000
13
35
5
Vasilijus Piskunovas
49,400
41
35
6
Dmitrijs Rizovs
35,600
30
35
8
Martin Kõiv
71,400
60
36
2
Jani Tuovinen
34,300
29
36
3
Stein Naerland
37,700
31
36
4
Erik Põlluveer
66,500
55
36
5
Van Akram Marcus
129,300
108
36
6
Osku Karttunen
49,800
42
36
7
Hermansson Eriksson
49,200
41
36
8
Tanel Evert
110,500
92
37
1
Toomas Nurme
19,900
17
37
2
Bengt Blad
24,300
20
37
3
Mattias Hansen
48,000
40
37
4
Doroslav Rasiukevic
68,900
57
37
5
Jarkko Suokas
28,700
24
37
6
Siim Suviste
29,700
25
37
7
Marius Morel
25,200
21
38
2
Juan Duenas
105,300
88
38
3
Aaron Kulomaa
45,800
38
38
4
Mauri Dorbek
151,000
126
38
5
Raimo Reimann
27,100
23
38
6
Oskar Ojaveer
48,500
40
38
7
Klavs Garselis
27,400
23
38
8
Knut Trulsen
26,600
22
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.