Kings of Tallinn - Kings of Tallinn 2024 - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0076 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/1A/updates'
ORDER BY `views` DESC

0.0113 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ/1A/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.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

0.0004 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0005 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

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

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

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

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

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

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

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

0.0007 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_555_Champ'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'

0.0288 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '224'
AND `published` = 1

0.0268 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` = '230'
AND `published` = 1

0.0267 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '231'
AND `published` = 1

0.0269 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0055 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '236'
AND `published` = 1

0.0270 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '237'
AND `published` = 1

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

0.0006 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '90'
AND `name` = '1A'

0.0063 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.0063 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '224'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9855'
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` = '9780'
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` = '9773'
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` = '9771'
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` = '9767'
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` = '9765'
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` = '9762'
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` = '9760'
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` = '9758'
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` = '9755'
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` = '9753'
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` = '9750'
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` = '9748'
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` = '9746'
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` = '9743'
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` = '9741'
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` = '9738'
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` = '9734'
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` = '9735'
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` = '9731'
ORDER BY `chip_change` DESC, `busted` ASC

0.0377 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9728'
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` = '9725'
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` = '9724'
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` = '9723'
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` = '9721'
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` = '9718'
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` = '9716'
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` = '9714'
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` = '9713'
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` = '9710'
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` = '9707'
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` = '9700'
ORDER BY `chip_change` DESC, `busted` ASC

0.0266 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9699'
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` = '9696'
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` = '9695'
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` = '9692'
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` = '9688'
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` = '9687'
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` = '9686'
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` = '9678'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0268 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9773'
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` = '9771'
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` = '9769'
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` = '9767'
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` = '9765'
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` = '9762'
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` = '9760'
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` = '9758'
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` = '9755'
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` = '9753'
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` = '9750'
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` = '9748'
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` = '9746'
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` = '9743'
ORDER BY `chip_change` DESC, `busted` ASC

0.0173 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9741'
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` = '9738'
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` = '9734'
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` = '9735'
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` = '9731'
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` = '9728'
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` = '9725'
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` = '9724'
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` = '9723'
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` = '9721'
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` = '9718'
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` = '9716'
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` = '9714'
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` = '9713'
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` = '9710'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '9707'
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` = '9700'
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` = '9699'
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` = '9696'
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` = '9695'
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` = '9692'
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` = '9688'
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` = '9687'
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` = '9686'
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` = '9678'
ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '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.0059 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.0059 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.0060 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.0058 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.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351

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

English

Kings of Tallinn 2024 Event #12: €555 Championship (English) Live Reporting - Day 3

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Current Level 35 Current Day 3

Blinds 200,000/400,000 Ante 400000

Entries 700 Remaining 1

Prize Pool (EUR) €329,000 First Prize (EUR) €58,835

Chip Leaders Day 3

1	Mikko Ylamaki		21,000,000

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

1 New Update - Click to refresh

Live Updates - Day 1A

01:58 (UTC+2)

Day 1 of Kings of Tallinn 2024 Ended
Level: 9 Blinds: 600/1,200 Ante: 1,200

Magnus Pukk Bags Day 1a Chip Lead Posted Sunday 25th February, 2024 at 19:21(UTC+2) by Jason Glatzer

Estonia's Magnus Pukk (pictured above) won a four-way all-in near the end of Day 1a to take the overall chip lead on Day 1a of the €555 Kings of Tallinn Championship.

Cyprus's Georgios Tsouloftas, who was near the top of the chip counts throughout the opening flight, wasn't too far behind with 170,100, while Estonia's Mauri Dorbek, who had the chip lead heading into the final break in the day impressively bagged 151,000.

Day 1a attracted 133 entries to add €63,480 to the prize pool. Check out all of the 57 survivors below:

Player	Chips	Big Blinds
Magnus Pukk	177,800	119
Georgios Tsouloftas	170,100	113
Mauri Dorbek	151,000	101
Hendry Kullamäe	145,600	97
Morten Norland	137,400	92
Gundars Zelcs	132,200	88
Van Akram Marcus	129,300	86
Maikel Homin	114,600	76
Tanel Evert	110,500	74
Modestas Kryzanauskas	108,700	72
Kevin Didvig	95,700	64
Erikas Gordejevas	94,200	63
Jon Gurrutxaga	93,700	62
Per Halmrast	88,800	59
Jimi Koponen	88,800	59
Vidar Assersen	87,400	58
Jyrki Lampinen	86,800	58
Rytis Pranarauskas	81,900	55
Mikael Haapaniemi	81,400	54
Jose Larios Domene	80,500	54
Luca Beretta	77,700	52
Kriss Riekstins	74,700	50
Tanel Merida	73,600	49
Aleksandr Gamonovits	73,000	49
Matiss Kirsfelds	73,000	49
Kalle Parkkinen	71,600	48
Martin Kõiv	71,400	48
Vladislav Han	71,000	47
Erik Põlluveer	66,500	44
Juuso Kauppi	62,300	42
Stefan Jansson	61,500	41
Rain Kandla	59,000	39
Osku Karttunen	49,800	33
Mathias Christensen	49,300	33
Kennie Eriksson Hermansson	49,200	33
Mart Rinken	49,200	33
Eduard Kruglov-Arutiunian	46,500	31
Paul-Richard Argus	45,000	30
Sergejs Kacapovs	43,300	29
Ivo Rohula	43,300	29
Matte Karjalainen	41,800	28
Vadim Guk	40,000	27
Marko Vest	38,000	25
Stein Naerland	37,700	25
Tarmo Tammel	37,000	25
Mark Metsla	35,200	23
Eriksson Stahl	33,600	22
Johan Alen	33,600	22
Tadas Pranckevicius	32,200	21
Siim Suviste	29,700	20
Paulius Jucys	29,400	20
Oleh Bohdanov	28,400	19
Rait Kaimer	27,100	18
Raimo Reimann	27,100	18
Pasi Trollhjärta	20,100	13
Toomas Nurme	19,900	13
Martin Piik	19,800	13

Final Five Hands for Day 1a Posted Sunday 25th February, 2024 at 18:25(UTC+2) by Jason Glatzer

The floor announced that each table should stop the hand they are on and play five more. Surviving players will bag and tag their stacks.

Those not as fortunate can give it another go tonight with Day 1b of the €555 Championship kicking off at 7 p.m.

Stay tuned for the final chip counts of Day 1a. While we won't be directly reporting Day 1b, we will also provide the vital statistics including the number of entries and the final chip counts before the morning.

Kovalevski Doubles Short Stack Posted Sunday 25th February, 2024 at 18:16(UTC+2) by Jason Glatzer

Level 9: 600/1,200 (1,200)
Entries: 71/133

Artjom Kovalevski got his last 14,400 in the middle from the big blind and was up against the under-the-gun opener Alba Gurrutxaga.

Artjom Kovalevski:
Alba Gurrutxaga:

Kovalevski pulled ahead on the flip after his queen found a partner on the flop. Neither the turn nor the river changed the outcome of the hand for Kovalevski to double his short stack through Gurrutxaga.

Player		Chips	Progress
Jon Gurrutxaga		55,000	25,000
Artjom Kovalevski		30,000	0

Final Day 1a Blind Level Begins Posted Sunday 25th February, 2024 at 18:00(UTC+2) by Jason Glatzer

Level 9: 600/1,200 (1,200)
Entries: 71/133

The final blind level of Day 1a kicked off. The clock will be stopped near the end of the blind level when each table will be asked to finish their hand before playing a predetermined amount of hands before surviving players can bag their stacks into Tuesday's Day 2.

Those that missed out on the fun of bagging and tagging stacks on Day 1a, will still have three more opening flights to get the job done, including Day 1b kicking off in about an hour at 7 p.m.

Players can also enter and re-enter during the first three blind levels of Day 2 providing players plenty of opportunity to forge ahead with a deep stack.

17:56 (UTC+2)

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

Dudakov's Ducks Decimated Posted Sunday 25th February, 2024 at 17:43(UTC+2) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 76/133

Dmitri Dudakov (pictured below) had his last 10,000 in the middle and was flipping against Martin Koiv.

Dmitri Dudakov:
Martin Koiv:

Dudakov was ahead on the flip after both the flop and the turn. However, the river double-paired the board while also counterfeiting Dudakov's pocket ducks.

Dudakov tapped the table to Koiv and then left the tournament arena after losing his stack.

Player		Chips	Progress
Martin Koiv		60,000	30,000
Dmitri Dudakov		0	0

Porkka Forks Over Stack to Tsouloftas Posted Sunday 25th February, 2024 at 17:40(UTC+2) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 86/133

Eetu Porkka jammed for about 34,000 into a pot of around double that with the on the board after the river.

Georgios Tsouloftas went into the tank for more than a minute before he called.

Neither player had Broadway with a but both Tsouloftas found the correct call. Porkka tabled the for the top pair and tapped the table after Tsouloftas turned over the for two pair to win the hand.

Player		Chips	Progress
Georgios Tsouloftas		170,000	70,000
Eetu Porkka		0	0

Ace-High Enough for Kauppi Posted Sunday 25th February, 2024 at 17:27(UTC+2) by Jason Glatzer

Level 8: 500/1,000 (1,000)
Entries: 86/133

It hasn't been a start to brag about for Lithuania's Kestutis Jungevicius as he has a sub-starting stack on his third bullet of Day 1a. This hand didn't help his situation.

We caught up to the action after Jungevicius checked with the on the board on the turn. Jusso Kauppi fired out a 10,000 bet into a pot of around 30,000 and Jungevicius called.

Both players checked the river. Kauppi turned over the and apparently, this was good enough despite bricking the board as he took down the pot after Jungevicius opted to toss his hand face down into the muck.

Player		Chips	Progress
Jusso Kauppi		75,000	45,000
Kestutis Jungevicius		18,000	12,000

17:11 (UTC+2)

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

Reimann Wins Blind vs. Blind Battle Against Halmrast Posted Sunday 25th February, 2024 at 17:08(UTC+2) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 90/132

Raimo Reimann jammed for 25,400 from the small blind before Per Halmrast (pictured below) went into the tank from the big blind. Halmrast opted to eventually call and likely wishes he could have seen into the future to choose otherwise.

Raimo Reimann:
Per Halmrast:

Reimann's big slick was more than enough on the board to double his stack with trips through Halmrast.

Player		Chips	Progress
Raimo Reimann		55,000	25,000
Per Halmrast		12,000	33,000

"It's Going In" Posted Sunday 25th February, 2024 at 16:51(UTC+2) by Jason Glatzer

Level 7: 400/800 (800)
Entries: 91/129

"It's going in," we heard Tapio Aaltonen say from a table away. "It is probably going in."

Aaltonen was true to his word as we caught up with the hand when he jammed for 2,900 from under the gun. Per Halmrast then announced he was all-in as well for about a starting stack from the button and it was a heads-up showdown after the other players folded.

"I only looked at one card and it was a king," Aaltonen admitted.

Tapio Aaltonen:
Per Halmrast:

Aaltonen appeared to be over the moon about actually having a live flip instead of just one over card. It didn't matter either way as he bricked the board.

"I won't re-enter today," shared Aaltonen. "I am going to have a look at the rest of the schedule before I decide what to play next."

Aaltonen hung around for more than a minute and shared with us while we were watching a hand play out at another table that he took more than one cooler recently.

"My neighbor accidentally spilled my beer," Aaltonen said while pointing over to Joni Salo. "He offered to buy me a drink and I am just waiting for it before I figure out what to play next."

Salo was a gentleman of his word and gladly paid for Aaltonen's drink. Shortly after, a grateful Aaltonen made his exit but this is far from the last we will hear from the popular Finnish player this week.

Player		Chips	Progress
Per Halmrast		45,000	15,000
Tapio Aaltonen		0	0

Big Stacks at Break Posted Sunday 25th February, 2024 at 16:36(UTC+2) by Jason Glatzer

Mauri Dorbek held the chip lead at the break with 115,000. Cypriot Georgios Tsouloftas was not too far behind with 100,000.

Check out the biggest stacks from around the room during the final break of Day 1a of the €555 Championship.

Player	Chips	Progress
Mauri Dorbek	115,000	85,000
Georgios Tsouloftas	100,000	25,000
Van Akram Marcus	95,000	65,000
Tanel Evert	90,000	60,000
Stefan Jansson	90,000	60,000
Vladislav Han	90,000	25,000
Jyrki Lampinen	85,000	55,000
Feras Abid	85,000	15,000
Aleksandr Gamonovits	80,000	50,000
Mikael Homin	80,000	50,000
Modestas Kryzanauskas	70,000	40,000

16:30 (UTC+2)

Start of Level 7
Blinds: 400/800 Ante: 800

Second and Final Day 1b Break Posted Sunday 25th February, 2024 at 16:16(UTC+2) by Jason Glatzer

Players are on their final break of Day 1a. We will update the bigger stacks from around the room around when the action resumes.

Players will play three more blind levels as follows before bagging stacks for the day:

Level 7: 400/800 (800)
Level 8: 500/1,000 (1,000)
Level 9: 600/1,200 (1,200)

Meanwhile, Day 1b, which boasts the same deep structure as Day 1a will provide more players a chance at advancing with the action kicking off at 7 p.m. In addition, there will be two more opening flights on Monday with players still permitted to enter and re-enter during the first three blind levels of Tuesday's Day 2.

Assersen's Queens Hold Against Jacks Posted Sunday 25th February, 2024 at 16:13(UTC+2) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 94/124

Norway's Vidar Assersen (pictured below) already amassed a decent stack and just added the chips from the stack of Estonia's Marko Vist from the following hand.

Assersen opened from early position to 1,300. Sergejs Kacapovs called from one seat over before Veikka Keto-Tokoi three-bet to 4,000 from the cutoff. Marko Vist five-bet shoved for 12,300 from the blinds before Assersen six-bet shoved for around double a starting stack. Both Kacapovs and Keto-Tokoi found folds and Vist got up from the table when he saw he was dominated.

Marko Vist:
Vidar Assersen:

Vist got no love on the board and was on the rail while Assersen was among the early chip leaders on Day 1a.

Player		Chips	Progress
Vidar Assersen		80,000	50,000
Marko Vist		0	0

€350 Kings of Tallinn Cup Champion Omland Runs Into Tsouloftas's Full House Posted Sunday 25th February, 2024 at 16:00(UTC+2) by Jason Glatzer

Level 6: 300/600 (600)
Entries: 100/124

Norway's Sven Omland was the biggest winner thus far at the 2024 Kings of Tallinn after shipping the two-day €350 Kings of Tallinn Cup for €19,200. He will need to re-enter if he wants a chance at winning an even bigger event in the €555 Kings of Tallinn Championship after losing his stack in the following hand.

Georgios Tsouloftas and Tadas Pranckevicius both checked the flop before Omland bet 2,500 into a pot of around 6,000. Both Tsouloftas and Pranckevicius called before both checking the turn.

Omland bet 8,000. Tsouloftas quickly called, while Pranckevicius opted to get out of the way. Tsouloftas checked one last time after the river paired the board. Omland jammed for about 11,000 and Tsouloftas snap-called.

It was a bit of a cooler for Omland as he had a strong hand with trip aces after tabling the . Tousloftas turned a set before further improving to a full house and eliminated Omland after turning over the .

Player	Chips	Progress
Georgios Tsouloftas	75,000	45,000
Tadas Pranckevicius	35,000	5,000
Sven Omland	0	0

Royal Flush Helps Paul Koppe Ship PLO Mystery Bounty (€6,020 + €13,500 Bounties) Posted Sunday 25th February, 2024 at 15:41(UTC+2) by Jason Glatzer

The heads-up battle didn't last long between Janne Nevalainen and Paul Koppe.

Nevalainen had his stack committed postflop with the eventually running out on the board. Nevalainen had a strong hand with a full house with but it was Koppe winning the tournament in style after showing the for a royal flush! This will surely be sure a hand that will be talked about throughout the day as it isn't often a player gets a royal flush in any form of poker, let alone win a trophy.

Meanwhile, shortly after, the duo discussed how they wanted to approach selecting the six mystery bounty envelopes with Nevalainen holding one bounty token and Koppe, who already won €3,000 in bounties, in possession of five tokens.

Nevalainen asked for Koppe to select first. Koppe collected the big €5,000 bounty on his third pull and snagged up €10,500 of the total €11,000 in bounties to bring his total up to €13,500 on top of the €6,020 winner's prize for a €19,520 prize for the biggest thus far at the 2024 Kings of Tallinn.

Meanwhile, Nevalainen was left to collect the remaining €500 bounty prize to bring his total bounties up to €2,000. Although it was a bit of a cooler to get the lower bounty prizes with three bounties, he did go home with a handsome total prize of €6,330 when taking into account the €4,330 runner-up prize from the prize pool.

15:41 (UTC+2)

Start of Level 6
Blinds: 300/600 Ante: 600

Berzinskas Doubled Payout in the €550 PLO Mystery Bounty Posted Sunday 25th February, 2024 at 15:19(UTC+2) by Jason Glatzer

Right after we posted an update on the side events, the action went heads-up in the €555 PLO Mystery Bounty with Tomas Berzinskas hitting the rail.

Berzinskas immediately headed to the tombola to collect his envelope for an elimination earlier in the day. He picked the second-highest envelope in a €3,000 bounty to add to his €2,970 third place prize for a €5,970 payout.

Meanwhile, either Janne Nevalainen or Paul Koppe will be crowned the champ and also one of these players will also collect the top €5,000 mystery bounty prize. We will update who won this event soon after the final hand was dealt.

Side Event Update Posted Sunday 25th February, 2024 at 15:07(UTC+2) by Jason Glatzer

There are currently three other events outside of the €555 and one satellite running in the tournament arena. One is about to award a winner!

The €555 Pot-Limit Omaha 4 & 5 Card Mystery Bounty is down to just three hopefuls for the title with Estonia's Paul Koppe, Finland's Janne Nevalainen, and Lithuania's Tomas Berzinskas all still in the mix for the trophy.

The €350 8-Game kicked off at 1 p.m. with Bulgaria's Stanislav Parkhomenko the only player to hit the rail thus far among the 41 entries.

Some of the usual mixed-game players are in the mix including Scott "PokerBrahs" Kenyon, Allan Arjut, Juhana Konttinen, Kairit Leibold (pictured below), and Tarjei Forus in the mix.

Meanwhile, the €150 NLH Bounty already had 58 players in their seats in the opening moments with the action kicking off in that event at 3 p.m. Jorg Bru, Lucas Cravero, Jimmy Dewerdt, Sami Korpela, Jari Pekka Rattya, and Maili Tannbaum were among the faces noticed in the field.

Best of luck to all players on Sunday in both the €555 Championship and the other events as well. We will provide a daily recap in the late morning of all the action of the day at OlyBet.tv as we have had thus far this festival.

14:56 (UTC+2)

Start of Level 5
Blinds: 200/500 Ante: 500

Video Highlights From Yesterday's Day 2 of the 2024 OlyBet Kings of Tallinn Posted Sunday 25th February, 2024 at 14:47(UTC+2) by Jason Glatzer

Ace-Queen Does the Job for Kovalevski Posted Sunday 25th February, 2024 at 14:45(UTC+2) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 96/107

Laur Sibold opened for 1,100 from the button before Artjom Kovalevski jacked it up to 2,500 from the small blind. Elias Vaaraniemi four-bet to 7,600. Sibold snap-folded before Kovalevski opted to call to see the flop.

Kovalevski checked before he called a small bet of 3,000 by Vaaraniemi. Both players checked the turn before Kovalevski led out for 5,000 on the river. Vaaraniemi quickly called and won the pot when his won a flip against Kovalevski's .

Player	Chips	Progress
Elias Vaaraniemi	60,000	30,000
Laur Sibold	42,000	12,000
Artjom Kovalevski	30,000	0

Big Slick Good for Antonenko to Oust Lubnin Posted Sunday 25th February, 2024 at 14:34(UTC+2) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 96/107

Oleksii Lubnin opened the button before he three-bet jammed for around 30 big blinds from the button. Andrei Antonenko called from the small blind and Lubnin needed help after the cards were turned over.

Oleksii Lubnin:
Andrei Antonenko:

No save came for Lubnin on the board and the Ukrainian will need to re-enter if he continues to wish to play.

Player		Chips	Progress
Andrei Antonenko		35,000	5,000
Oleksii Lubnin		0	0

OlyBet Poker Podcast Guest Anne Bezdek in the Field Posted Sunday 25th February, 2024 at 14:21(UTC+2) by Jason Glatzer

Level 4: 200/400 (400)
Entries: 94/104

The action resumed with a few new players getting into the mix including popular Finnish player Anne Bezdek.

Bezdek joined OlyBet Poker Podcast host Jason Glatzer alongside Kings of Tallinn tournament director Teresa Nousiainen for the first episode with special guests in the first ladies event winner and 2023 Queens of Tallinn Mystery Bounty champ Kelly Limonova and Bezdek to chat about the Kings of Tallinn. Check out the podcast below:

Player		Chips	Progress
Anne Bezdek		30,000	0

14:15 (UTC+2)

Start of Level 4
Blinds: 200/400 Ante: 400

First Break Posted Sunday 25th February, 2024 at 14:03(UTC+2) by Jason Glatzer

Players are on their first 15-minute break. Blinds will increase to 200/400 with a 400 big blind ante when the action resumes.

Century Mark Achieved Posted Sunday 25th February, 2024 at 14:02(UTC+2) by Jason Glatzer

The Day 1a field reached 100 entries just before the first break of Day 1a with 98 entries. A total of 90 players remain with Jarmo Salonen, Per Halmrast, and Andrius Mazeika all hitting the rail during Level 3.

Pranarauskas Flops the Nuts Posted Sunday 25th February, 2024 at 13:43(UTC+2) by Jason Glatzer

Level 3: 100/300 (300)
Entries: 83/86

Vadim Guk checked the board after the turn before Rytis Pranarauskas fired out for 2,600 into a pot north of 4,000. Guk tanked for close to a minute before he called.

Guk checked again after the river. Pranarauskas bet 7,000. Guk paused for close to two minutes before he called. Pranarauskas immediately turned over the nuts with after his opponent's call. Guk had nothing that could possibly beat his opponent's ace-high flush and opted to muck his hand before the dealer awarded Pranarauskas the pot.

Meanwhile, Virgo Laansoo (pictured below) hit the rail around the same time for the third casualty of Day 1a.

Player	Chips	Progress
Rytis Pranarauskas	50,000	20,000
Vadim Guk	35,000	5,000
Virgo Laansoo	0	0

13:36 (UTC+2)

Start of Level 3
Blinds: 100/300 Ante: 300

Valk Runs Into Koorits's Full House Posted Sunday 25th February, 2024 at 13:00(UTC+2) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 70/72

A duo of local players tangled up in a pot on Table 3. Karl Valk bet 6,000 into a pot of slightly more with the on the board. Kaido Koorits (pictured below) paused for a short time before he raised to 15,000.

Valk tanked for around two minutes and seemed less than pleased with the outcome after he called. Koorits turned over the for a full house. This did the job to win the hand and decimate Valk's stack with his opponent shaking his head while tossing his hand into the muck.

Player		Chips	Progress
Kaido Koorits		55,000	25,000
Karl Valk		5,000	25,000

Aaltonen Avoids Potential Catastrophe After Folding Cowboys Posted Sunday 25th February, 2024 at 12:51(UTC+2) by Jason Glatzer

Level 2: 100/200 (200)
Entries: 66/68

Tapio Aaltonen opened before firing out a four-bet to 4,200 from early position. Oleksandr Taran four-bet shoved. Aaltonen tanked for close to a minute.

He eventually flashed the before he folded his hand.

You might be thinking the standard questions about whether you should ever fold hands like kings. In this case, Aaltonen won't be up all night wondering if he made the right decision as Taran turned over the as the dealer began to push the pot his way.

Player		Chips	Progress
Oleksandr Taran		45,000	15,000
Tapio Aaltonen		25,000	5,000

12:41 (UTC+2)

Start of Level 2
Blinds: 100/200 Ante: 200

Abid Rivers Wheel to Bust Liiva Posted Sunday 25th February, 2024 at 12:37(UTC+2) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 63/65

Hanno Liiva checked the river with the already on the board before Feras Abid (pictured below from the 2023 Olybet Kings of Tallinn Summer Showdown) opted to jam for more than the approximately 25,000 Liiva had in his stack into a pot of a bit less.

Liiva tanked for more than a minute before he called. Abid turned over the for a rivered wheel. Liiva was ahead until Abid completely his gutshot and hit the rail on a cooler after turning over the for a set of cowboys.

Player		Chips	Progress
Feras Abid		70,000	40,000
Hanno Liiva		0	0

Jungevicius Runs Into Han's Cowboys Posted Sunday 25th February, 2024 at 12:22(UTC+2) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 53/54

The €555 Championship is already one player down after Kestutis Jungevicius (pictured below recently playing in the Vilnius Ace Breaker) hit the rail in the opening moments of Day 1a.

Kestutis Jungevicius opened for 400 from early position before Vladislav Han three-bet to 2,100 from the small blind Feras Abid cold-called from the button before Jungevicius jacked it up to 6,400.

Han tanked for about 30 seconds before he jammed. Abid quickly folded. Jungevicius paused for about 20 seconds before he called off his stack of 29,400.

Kestutis Jungevicius:
Vladislav Han:

Han's cowboys held strong after Jungevicius bricked the board. Jungevicius stuck around for a short while after the hand to confirm he was covered before heading to the cashier to re-enter.

Player		Chips	Progress
Vladislav Han		65,000	35,000
Kestutis Jungevicius		30,000	0

Early Players in Action Posted Sunday 25th February, 2024 at 12:08(UTC+2) by Jason Glatzer

Tapio Aaltonen, Kevin Didvig, Hanna Heinlo, Vygerdas Jonikas, Jarmo Salonen, and Lithuanian poker couple Viktorija Ignataviciene and Rimantas Ignatavicius are among the early players in the field.

Player		Chips	Progress
Rimantas Ignatavicius		30,000	0
Viktorija Ignataviciene		30,000	0
Jarmo Salonen		30,000	0
Vygerdas Jonikas		30,000	0
Hanna Heinlo		30,000	0
Kevin Didvig		30,000	0
Tapio Aaltonen		30,000	0

Cards in the Air for Day 1a of the €555 Kings of Tallinn Championship Posted Sunday 25th February, 2024 at 12:03(UTC+2) by Jason Glatzer

Level 1: 100/100 (100)
Entries: 36/36

Cards are in the air for Day 1a of the €555 Championship after preliminary announcements by Kings of Tallinn Tournament Director Teresa Nousiainen (pictured below).

The field boasted 36 players in their seats from the start and will grow significantly throughout the day.

12:00 (UTC+2)

Day 1 of Kings of Tallinn 2024 Started
Level: 1 Blinds: 100/100 Ante: 100

€555 Championship Starts at Noon Posted Sunday 25th February, 2024 at 09:49(UTC+2) by Jason Glatzer

Welcome to the 2024 Kings of Tallinn at Olympic Park Casino from Feb. 23 to March 3. The first two days of the festival have proven that attendance records this festival will be smashed with a large vibrant crowd already in Tallinn during the first weekend of the 10-day festival.

Our live reporting coverage will be brought to you by Jason Glatzer in English while we will also be hosting local coverage in both Estonian and Finnish.

The coverage begins with the €555 Championship Event on Feb. 25-28 before continuing to the €1,100 Main Event (Feb. 28 to March 3), the €5,000 High Roller (final day coverage on March 2), and the €3,000 NLH (final day coverage on March 3).

The €555 Championship boasts four opening flights. Most of the tournament boasts 40-minute blind levels outside of tomorrow evening's Day 1d which features a faster structure with 25-minute levels. Each opening flight boasts nine blind levels with re-entries and late registrations allowed for the first three blind levels on Tuesday's Day 2 before closing at the start of Level 13.

Players start with 30,000 in chips with Sunday featuring two opening flights with Day 1a at 12 p.m. and Day 1b at 7 p.m. Our coverage will focus on Day 1a, however, we will be sure to provide the vital statistics along with who advanced to Day 2 on Day 1b.

Last year, France's Benjamin Gros dazzled the crowd at the 2023 Kings of Tallinn €555 Championship after defeating a banner crowd of 559 entries to win the €55,500 top prize.

Our coverage will begin when cards are in the air for Day 1a at noon. Stay tuned to follow along the action until a winner is crowned.

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Your search results are valid for . More 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.

Browse

Useful Links

Subscribe to our newsletter