0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/2/updates'
ORDER BY `views` DESC

0.0086 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event/2/updates'

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

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

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

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

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

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

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

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

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

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

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

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

0.0001 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.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.0066 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_1100_Main_Event'

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

0.0210 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '241'
AND `published` = 1

0.0206 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0040 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '245'
AND `published` = 1

0.0206 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0040 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '250'
AND `published` = 1

0.0209 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '251'
AND `published` = 1

0.0208 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0042 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '256'
AND `published` = 1

0.0204 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0139 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '263'
AND `published` = 1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

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

• £   GBP
• $   USD
• €   EUR

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

Login / Register

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

English

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

• £   GBP
• $   USD
• €   EUR

Kings of Tallinn 2024 Event #29: €1,100 Main Event (English) Live Reporting - Day 4

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 4

---

Blinds 200,000/400,000 Ante 400000

Entries 914 Remaining 1

---

Prize Pool (EUR) €859,160 First Prize (EUR) €120,910

Chip Leaders Day 4

1

Edgaras Kausinis

27,000,000

Day 1a Day 1b Day 1c Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 2

08:36 (UTC+0)

Day 2 of Kings of Tallinn 2024 Ended
Level: 17     Blinds: 3,000/6,000     Ante: 6,000

Jani Vilmunen Leads Final 118 in Main Event Posted Friday 1st March, 2024 at 23:05(UTC+0) by Jason Glatzer

The 2024 Kings of Tallinn €1,100 Main Event more than lived up to its billing at Olympic Park Casino and the Hilton Tallinn Park. The €500,000 guarantee was a mere placeholder and players participated in record numbers with 914 total entries getting into the mix by the time late registration closed midway through Day 2 for a monumental prize pool of €859,160.

While all eyes are on the €151,860 top prize announced shortly after late registration was closed, today players primarily focused on getting into the money with the hopes of having a good stack for Day 3 and beyond.

Finland's Jani Vilmunen (pictured above) was on top at the end of the day to lead the 118 survivors after bagging up a huge stack of 968,000. Vilmunen has been in this spot before as he is a well-experienced pro with nearly $900,000 in cashes tracked at The Hendon Mob. The Finn also won a WSOP Europe in the £5,250 Pot Limit Omaha back in 2009.

Meanwhile, Lithuania's Mantas Tamulevicius fired his very first bullet on Day 2 and waited to the very last second to start the day with 12 big blinds. He made the most of his decision as he catapulted his 30,000 stack to 777,000 to finish just behind Vilmunen.

Kasper Mellanen (757,000), Osku Karttunen (654,000), and 2024 Kings of Tallinn €555 Championship runner-up Andrius Bielskis (600,000) round out the top five.

Other players finding bags into Day 3 were former Olympic poker manager Herli Olop (530,000), Maximilian Sanders (502,000), Steven Tool (400,000), OG online poker legend Ilari "Ziigmund" Sahamies (381,000), Josep Pastor (373,000), 2023 WSOP Circuit Tallinn Main Event champ Ignacio Garrido (357,000), Dominik Ostrowski (313,000), Tarmo Tammel (291,000), 2023 Kings of Tallinn €555 Championship winner Benjamin Gros (235,000), super high roller Paul Newey (219,000), 2024 Kings of Tallinn €555 PLO Mystery Bounty champ Paul Koppe (213,000), and Roope Tarmi (167,000).

Our new hero Christian Rysgaard began the day with the chip lead but now may have a new nickname from Sleeping Beauty that he earned during the €555 Championship to Cinderella if he can pull off some magic as he ended the day with exactly one chip worth 1,000.

Meanwhile, Day 2 ended when two Finnish players Henri Wagner and Sampo Ryyanen went out on the same hand at different tables through a long bubble lasting about a full blind level. Both players didn't go home empty-handed as they split a min-cash of €2,100 resulting in a €1,050 prize for each player.

Others on the rail earlier include 2023 Kings of Tallinn champ Priit Parmasto, 2007 Kings of Tallinn champ Matias Knaapinen, 2023 WSOP Circuit Tallinn Main Event runner-up Petteri Laiho, Jussi "PottiJussi" Mattila, Igor Pihela Sr., 2022 Battle of Malta champ Giuseppe Rosa, Queens of Tallinn host and FLIP women's poker community founder Daiva Byrne were among the players battling on Day 2 to fall short of the money.

Cards are back in the air for Day 3 on Saturday at Noon. We recommend all players get their bracelets as early as possible and be back in the tournament arena no later than 11:45 a.m. Best of luck to all of the players on Day 3 and beyond.

* Link to Day 3 Seat Draw

Final Day 2 Chip Counts Posted Friday 1st March, 2024 at 22:30(UTC+0) by Jason Glatzer

Player		Chips	Progress
Jani Vilmunen		968,000	623,000
Mantas Tamulevicius		777,000	747,000
Kasper Mellanen		757,000	487,000
Osku Karttunen		654,000	613,500
Andrius Bielskis		600,000	180,000
Frederik Brink		569,000	539,000
Edgaras Kausinis		552,000	531,600
Albert Gil		544,000	462,700
Herli Olop		530,000	230,000
Thomas Larsen		523,000	127,000
Maximilian Sanders		502,000	82,000
Mattias Hansen		457,000	3,000
Jani Tuovinen		448,000	274,600
Patrikas Aglinskas		427,000	122,000
Svein Mathiassen		425,000	357,800
Audrius Skucas		423,000	309,900
Sauli Haapaniemi		420,000	302,100
Jonatan Fors		417,000	388,700
Bengt-Anders Johnsson		404,000	321,400
Steven Tool		400,000	278,200
Niclas Mjelstad		390,000	141,000
Aleksi Naski		388,000	128,000
Ilari Sahamies		381,000	351,000
Josep Pastor		373,000	16,000
Ignacio Garrido		357,000	234,000
Trond Aanestad		346,000	271,000
Morten Norland		338,000	26,000
Miska Vihervuori		334,000	240,500
Johan Karlsson		333,000	53,000
Benny Hagberg		326,000	86,000
Even Rislov		316,000	287,700
Dominik Ostrowski		313,000	290,100
Greger Aktell		308,000	19,000
Tarmo Tammel		291,000	161,000
Sven Omland		286,000	14,000
Adrians Imsa		280,000	10,000
Aleksei Smirnov		268,000	8,000
Alexander Sokolovsky		249,000	211,200
Nikita Zarovs		247,000	155,300
Kaido Mikk		246,000	74,300
Marius Morel		246,000	84,000
Wissam Polus		244,000	49,000
Klavs Garselis		237,000	182,100
Tomi Arponen		236,000	130,600
Benjamin Gros		235,000	117,000
Rolandas Aglinskas		235,000	10,000
Jon Martinez		228,000	90,600
Paul Newey		219,000	78,000
Mihkel Vitsur		214,000	110,000
Paul Koppe		213,000	217,000
Jyrki Lampinen		209,000	150,500
Jimi Koponen		207,000	152,200
Enea Subashi		205,000	100,000
Viktor Eriksson		201,000	173,400
Sandis Blums		198,000	143,000
Ranel Kasi		198,000	17,500
Tarjei Forus		196,000	30,900
Kalle Parkkinen		194,000	114,500
Mykolas Guiga		193,000	148,000
Vytautas Laurinaitis		185,000	10,000
Per Engstrom		184,000	140,900
Gatis Maisins		182,000	105,800
Petteri Miettinen		180,000	112,500
Antti Perttula		180,000	77,300
Mark Metsla		177,000	112,400
Paulius Jucys		168,000	156,000
Mindaugas Kriauciunas		167,000	76,000
Roope Tarmi		167,000	10,500
Mikko Ylamaki		162,000	188,000
Tomi Rissanen		155,000	97,800
Jari-Pekka Juhola		154,000	92,800
Rytis Pranarauskas		153,000	67,000
Gediminas Dirmantas		153,000	17,000
Kenneth Svendsen		151,000	76,300
Henning Andre		150,000	10,000
Arto Lehtonen		145,000	63,300
Fritz Nygren		145,000	27,200
Sebastian Wahl		139,000	35,000
Kaius Kiidli		137,000	80,800
Kaur-Silver Koha		135,000	37,000
Henri Kasper		135,000	33,400
Peer Zahl		131,000	78,400
Stein Naerland		124,000	80,900
Anne Bezdek		117,000	89,700
Aurelijus Sipavicius		117,000	35,800
Rolf Jauring		112,000	32,000
Joonas Helin		108,000	42,000
Luca Beretta		107,000	272,000
Thomas Haverstad		106,000	55,300
Mairo Tori		98,000	39,600
Kris Tikka		96,000	9,000
Martynas Mockevicius		92,000	34,100
Van Akram Marcus		89,000	56,500
Sascha Manns		87,000	40,000
Matias Kesanen		86,000	56,000
Adria Comas I Roura		85,000	55,400
Shachar Haran		80,000	19,700
Peter Jaksland		73,000	10,600
Lauri Laast		72,000	13,800
Jesper Hansen		70,000	3,200
Mindaugas Jonaitis		66,000	4,300
Karl Linder		63,000	25,400
Jari Saviaho		62,000	32,000
Vasilijus Piskunovas		54,000	17,500
Jari Hurri		48,000	4,700
Matias Knaapinen		45,000	15,300
Oscar Peleg		43,000	11,500
Ignas Vaitulionis		43,000	27,000
Jari Mahonen		38,000	2,000
Vidar Furu Oie		37,000	278,000
Silver Simulask		30,000	100,000
Ignas Navickas		26,000	88,400
Andrei Silencov		25,000	40,000
Olegs Petrovskis		24,000	49,800
Ignas Jasinevicius		10,000	3,000
Richard Koppel		10,000	65,000
Javier Moya		5,000	16,000
Christian Rysgaard		1,000	0

Henri Wagner & Sampo Ryyanen Split a Min-Cash on Bubble Posted Friday 1st March, 2024 at 20:57(UTC+0) by Jason Glatzer

Level 17: 3,000/6,000 (5,000)
Entries: 120/914

It took just two hands after the break for the bubble to burst with two players hitting the rail at separate tables splitting the min-cash of €2,100 for €1,050 each.

Henri Wagner was the first to go. He had 6,000 in chips and was all-in before cards were dealt from the big blind and was up against Aurelijus Sipavicius who opened from the cutoff.

Wagner didn't look at his cards yet and flipped over the .

"Let the other card be a seven," one of Wagner's friends on the rail shouted.

Wagner took a peak and announced: "It's much better before turning over the .

Wagner's didn't get there against Sipavicius's after the ran out on the board.

Meanwhile, Sampo Ryyanen was also already committed from the big blind and also didn't look at his cards facing the shove by Mindaugas Jonitis from the small blind.

Sampo Ryyanen:
Mindaugas Jonitis:

Ryyanen was ahead until the river on the board.

A round of applause took place after the hand as players were in the money heading into tomorrow. At least two players had some "bag issues."

Sascha Manns already entered the €250 Sviten Special event and was out the door quickly. Meanwhile, newly anointed Kings of Tallinn legend Christian "Sleeping Beauty" Rysgaard may have a new nickname coming. He had one chip worth 1,000 heading into tomorrow's Day 3.

Check out the amazing photos by Kings of Tallinn Photographer Elena Kask below:

Player		Chips	Progress
Christian Rysgaard		1,000	20,000
Henri Wagner		0	0
Sampo Ryyanen		0	0

Jasinevicius Survives Posted Friday 1st March, 2024 at 20:34(UTC+0) by Jason Glatzer

Level 17: 3,000/6,000 (5,000)
Entries: 120/914

Ignas Jasinevicius had 6,000 chips and was all in in the big blind. Morten Norland three-bet Mattias Hansen to 40,000 preflop. Hansen called before both players checked the entire board.

Jasinevicius didn't look at his cards and had a beauty with . Norland had and his hand was mucked while Hansen held to chop the pot with Jasinevicius.

High fives went over to Jasinevicius from the rail as he survived the money bubble.

Player		Chips	Progress
Ignas Jasinevicius		13,000	42,000

20:21 (UTC+0)

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

Final Break Posted Friday 1st March, 2024 at 20:08(UTC+0) by Jason Glatzer

Players are on a 15-minute break. Day 2 will conclude after the money bubble breaks.

Aglinskas Celebrates After Narrowly Missing Bubble Posted Friday 1st March, 2024 at 19:48(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 120/914

Rolandas Aglinskas had his last 76,000 committed on the board after the turn. Henning Andre called and a crowd submerged the table.

Rolandas Aglinskas:
Henning Andre:

It was looking like showers on the bubble for Aglinskas but the river saved the day and he celebrated loudly after hitting his flush.

"Nice hand," Andre said after the hand showing some sportsmanship despite the loud display right next to him.

Player		Chips	Progress
Rolandas Aglinskas		225,000	9,000
Henning Andre		160,000	47,900

Bubble Reached After Suutari Hits Rail Posted Friday 1st March, 2024 at 19:19(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 120/914

Juho Suutari just hit the rail after getting it in the against the held by Fritz Nygren. He got nowhere on the board and the action was just one player away from being in the month.

Player		Chips	Progress
Juho Suutari		0	0

Rockets Hold for Zarev Against Omlando Posted Friday 1st March, 2024 at 19:05(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 121/914

Sven Omland (pictured below) jammed his big stack from the small blind before Nikita Zarovs called off from the big blind for his stack of 121,000.

A crowd gathered around the table after the other hands were played out at other tables.

Nikita Zarovs:
Sven Omland:

Zarovs was nervous but it turned out he had no reason to be at the end with the safe running out on the board.

Player		Chips	Progress
Sven Omland		300,000	77,500
Nikita Zarev		247,000	217,000

Plan for Day 2 Posted Friday 1st March, 2024 at 18:58(UTC+0) by Jason Glatzer

The final plan for Day 2 was just announced. The day will end the later of the end of Level 16 or when the action reaches the money.

Chances are, it will be the end of the level which was the original schedule for the day.

Naski Doubles Vaitulionis Posted Friday 1st March, 2024 at 18:56(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 121/914

Aleksi Naski (pictured below) opened for 10,000 from the hijack before Ignas Vaitulionis three-bet shoved for 30,000 from the small blind. Naski looked down at his cards once more before he called.

Hands were being played out at other tables before a crowd gathered around the table.

Aleksi Naski:
Ignas Vaitulionis:

The crowd was amazing when Naski pulled ahead with two pair on the flop. But Vaitulionis had Naski drawing dead after improving to a set of cowboys on the turn and officially doubled his stack after the river completed the board.

Player		Chips	Progress
Aleksi Naski		260,000	158,000
Ignas Vaitulionis		70,000	30,000

Two Away From the Money Posted Friday 1st March, 2024 at 18:43(UTC+0) by Jason Glatzer

Level 16: 2,000/5,000 (5,000)
Entries: 121/914

The action is two players away from the money after Jazouli Idrissi, Mauri Dorbek, Robertas Smolskis, and Lars-Ove Johnsson lost their short stacks.

Johnsson got his short stack in on the turn with and was up against the held by Klavs Garselis with the board.

Johnsson had some kicker issues with both players holding the top pair. They weren't resolved on the river.

The action went hand-for-hand after the hand.

Player		Chips	Progress
Mauri Dorbek		0	0
Robertas Smolskis		0	0
Klavs Garselis		0	0
Jazouli Idrissi		0	0
Lars-Ove Johnsson		0	0

18:33 (UTC+0)

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

Dorbek With a Decision to Make Against Olop With Bubble Brewing Posted Friday 1st March, 2024 at 18:21(UTC+0) by Jason Glatzer

Level 15: 2,000/4,000 (4,000)
Entries: 124/914

Mauri Dorbek (pictured below) bet 18,000 into a pot of a bit more with the on the board after the turn. Herli Olop jammed for the more than 15 big blinds Dorbek still had behind. 

Dorbek went into the tank for more than five minutes during which time he was trying to get a reaction out of Olop. Eventually, the duo engaged in a discussion.

"What do you push all-in with?" Dorbek asked.

"Something like ace-jack," replied Olop.

"Do you have queens?" Dorbek followed up.

"I can't say," Olop said.

Dorbek apologized to the table for taking so long. However, the table didn't seem to mind.

"Will you show your cards?" asked Dorbek.

"You can choose one WHEN you fold," replied Olop predicting the future.

"Only one?" replied Dorbek.

"Only one, its better," said Olop.

Dorbek eventually folded and Olop invited him to choose a card to turn over. 

"So you had queens," said Dorbek after the was turned over.

"Maybe yes, maybe no," Olop replied.

Meanwhile, 2020 KoT Main Event champion Johan Karlsson is also at the table with a healthy stack.

Player		Chips	Progress
Herli Olop		300,000	70,000
Johan Karlsson		280,000	177,300
Mauri Dorbek		59,000	53,100
Kennie Hermansson		0	0
Rauno Tahvonen		0	0

Sleeping Beauty Needs to Wake Up Posted Friday 1st March, 2024 at 18:15(UTC+0) by Jason Glatzer

Level 15: 2,000/4,000 (4,000)
Entries: 130/914

Christian Rysgaard earned the nickname Sleeping Beauty in the €555 Championship when he took a nap during the dinner break with the chip lead with 45 players left thinking the day was over. He came back 3 hours later and battled out but fell short of the final day.

He had a good run on Day 1a of the Main Event and entered today with the chip lead. He lost a huge pot to Olop many hours ago and has since been hanging along. Now, someone needs to wake-up Sleeping Beauty at the tables as he is down to five big blinds.

However, there is a bubble looming and we hope to see him among the players to make the money, especially considering that Rysgaard has added to the tremendous atmosphere here at the Kings of Tallinn.

Player		Chips	Progress
Christian Rysgaard		21,000	129,000
Vygerdas Jonikas		0	0
Maher Mahmoud		0	0
Kaisa Suorsa		0	0
Allan Arjut		0	0

Day 7 Video Recap Posted Friday 1st March, 2024 at 17:53(UTC+0) by Jason Glatzer

Rockets For Hansen Posted Friday 1st March, 2024 at 17:50(UTC+0) by Jason Glatzer

Level 15: 2,000/4,000 (4,000)
Entries: 134/914

A massive pot of more than 500,000 was in the middle, including a massive side pot. Rolf Jauring had his last 26,000 in the middle, while Mattias Hansen had a much bigger amount in 243,000 committed. Ignas Jasinevicius had his stack in as well with both players covered.

Rolf Jauring:
Mattias Hansen:
Ignas Jasinevicius:

"I'm alive" said Jauring.

Jauring went from alive to having decent odds to win the pot after nailing both a flush draw and a gutshot straight draw on the flop.

The turn didn't help either Jasinevicius or Jauring but the river completed Jauring's flush to triple his stack.

Meanwhile, Hansen won the massive side pot with his set of aces to catapult to near the top of the Day 2 leaderboard.

Player		Chips	Progress
Mattias Hansen		460,000	384,400
Rolf Jauring		80,000	50,000
Ignas Jasinevicius		55,000	155,000
Mathias Siljander		0	0
Erkka Lepola		0	0
Thomas Syversen		0	0
Mikko Aro		0	0
Ulf Bredenberg		0	0
Tomas Pinkevicius		0	0
Alf Onnestam		0	0
Simon Persson		0	0
Arnoldas Kolesnikovas		0	0
Anatolij Kulabin		0	0
Radoslaw MatyjaszczykÊ		0	0
Gustaf Soderholm		0	0
Sten Talviste		0	0
Jukka Moisio		0	0

Meet the Legend of the Sleeping Beauty at the Kings of Tallinn Posted Friday 1st March, 2024 at 17:19(UTC+0) by Jason Glatzer

Christian "Sleeping Beauty" Rysgaard began the day with the chip lead and is still hanging along despite doubling up Herli Olop in a big hand earlier today.

Check out Rysgaard's story in the video below:

Larsen Still Leading at Break Posted Friday 1st March, 2024 at 17:18(UTC+0) by Jason Glatzer

Player		Chips	Progress
Thomas Larsen		650,000	240,000
Paul Koppe		430,000	71,000
Andrius Bielskis		420,000	260,600
Maximilian Sanders		420,000	216,100
Josep Pastor		389,000	129,000
Herli Olop		370,000	10,000
Morten Norland		364,000	267,000
Marius Morel		330,000	160,000
Vidar Furu Oie		315,000	183,900
Patrikas Aglinskas		305,000	250,300

17:17 (UTC+0)

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

Eliminations Before Break Posted Friday 1st March, 2024 at 17:08(UTC+0) by Jason Glatzer

Player		Chips	Progress
Emanuele Mari		0	0
Petteri Laiho		0	0
Oskar Ojaveer		0	0
Giedrius Karpavicius		0	0
Dror Amiram		0	0
Adrian Espinosa		0	0
Pasi Sormunen		0	0

Olop Earns Killing Cap Posted Friday 1st March, 2024 at 17:05(UTC+0) by Jason Glatzer

Players are now on break. We noticed Herli Olop (photo without cap below, photo with cap to come soon) wearing a new autographed cap and he explained to us he won it during the Celebrity Event.

Olop eliminated the short-stacked Estonian celebrity Karl Killing when he flopped trips with king-deuce and improved to a full house. The action went check-check on both the flop and turn until Killing attempted to make a move on the river with jack-seven.

This was likely one of the easier calls for Olop this week. Meanwhile, the "Killing Cap" is crushing as Olop had around 380,000 in chips in his stack for one of the bigger stacks in the room.

Player		Chips	Progress
Herli Olop		380,000	35,000

Tammel Doubles Through Helin With Cowboys Posted Friday 1st March, 2024 at 16:46(UTC+0) by Jason Glatzer

Level 14: 1,500/3,000 (3,000)
Entries: 157/914

Estonia's All-Time Cashes leader according to The Hendon Mob at international events at Olympic Park Casino three-bet jammed for 58,000 and was called by Joonas Helin, who originally opened one seat to his right.

Tarmo Tammel:
Joonas Helin:

Tammel calmly watched the peacefully run out on the board resulting in a double-up through Helin.

Player		Chips	Progress
Joonas Helin		150,000	102,300
Tarmo Tammel		130,000	26,000
Pekka Ikonen		0	0
Jarkko Suokas		0	0
Touko Berndtson		0	0
John Lundqvist		0	0
Jan-Mikael Kesanen		0	0
Daiva Byrne		0	0
Ivo Rohula		0	0
Laurynas Cerniauskas		0	0
Priit Vanem		0	0
Oleksii Lubnin		0	0
George Sandford		0	0
Roni Berg		0	0
Angel Rodriguez		0	0

€5,000 High Roller Begins Posted Friday 1st March, 2024 at 16:16(UTC+0) by Jason Glatzer

The two-day €5,000 High Roller just kicked off with seven players. This figure will grow with late registration open for nine blind levels.

Federico Cipollini, Anatoly Filatov, Markku Koplimaa (pictured below), Marius Kudzmanas, Ilya Nikiforov, Mihails Nikitins, and Virpi Ojanen were the troopers battling it out from the opening bell.

Best of luck to all of the High Rollers this evening at the 2024 Kings of Tallinn.

€159,860 Top Prize Posted Friday 1st March, 2024 at 16:08(UTC+0) by Jason Glatzer

The payouts were just announced with the top 119 players going home with at least a €2,100 min-cash.

It only goes up from there until Sunday's eventual winner who will be awarded €151,860 barring any deals. This will be a new record prize at the Kings of Tallinn throughout its 10-year illustrious history.

You can check out the full payouts soon in the "Payouts" tab in our coverage.

16:03 (UTC+0)

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

Koks Runs Into Mellanen's Cowboys Posted Friday 1st March, 2024 at 16:03(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 175/914

Andrey Koks committed his stack on the flop and was up against the active Kasper Mellanen.

Andrey Koks:
Kasper Mellanen:

Koks didn't seem thrilled about what he was up against, and who could blame him. Some new outs opened while others closed after the turn as a queen for two pair, now gives Mellanen a straight, and a king gives Koks the straight to beat trips.

However, the blank river completed for Mellanen to eliminate Koks.

Player		Chips	Progress
Kasper Mellanen		270,000	160,000
Algirdas Saveikis		0	0
Maksim Petrov		0	0
Algirgas Sukys		0	0
Samuli Hietala		0	0
Andrey Koks		0	0

Kuzulis Loses Short Stack to Dirmantas Posted Friday 1st March, 2024 at 15:55(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 183/914

Table 2 recently broke but not before two Lithuanians in Dangiris Kuzulis and Gedimnas Dirmantas clashed in a small pot that sent Kuzulis to the rail.

Kuzilis open-jammed for six big blinds from early position and was called by Dirmantas from the hijack.

Dangaris Kuzulis:
Gediminas Dirmantas:

Ace-jack was good enough to beat ace-seven on the runout for Dirmantas to take claim to Kuzulis's stack.

Player		Chips	Progress
Gediminas Dirmantas		170,000	67,800
Dangiras Kuzulis		0	0
Mikael Haapaniemi		0	0
Niklas Vakkuri		0	0
Kaspars Mallons		0	0
Justas Semaska		0	0
Jussi Mattila		0	0
Adomas Juozapavicius		0	0
Santtu Leinonen		0	0
Markku Koplimaa		0	0
Reinis Zageris		0	0

Good Luck to Pihela Sr. in the High Roller Posted Friday 1st March, 2024 at 15:38(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 198/914

Players are dropping fast during Level 13 with dozens of players hitting the rail including Igor Pihela Sr. We won't disclose exactly the amount of times Pihela tried to build a stack only to end up end and enter again, but we do appreciate his determination. Unfortunately, despite a last bid at the end he was among the players to hit the rail.

We wish the local poker veteran Pihela better luck in the €5,000 High Roller, which kicks off at 6 p.m.

Meanwhile, Finnish poker journalist and player Aki Pyysing was also among those not to make it past Level 13.

Player		Chips	Progress
Tommi Lankinen		0	0
Marks Sergins		0	0
Audrius Laimelis		0	0
Kestutis Jungevicius		0	0
Michel Leibgorin		0	0
Jussi Vanhanen		0	0
Sander Leigri		0	0
Modestas Kryzanauskas		0	0
Aki Pyysing		0	0
Igor Pihela Sr.		0	0

Daiva Byrne Headlines the TV Table Posted Friday 1st March, 2024 at 15:16(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 226/914

Women's poker group FLIP founder and Queens of Tallinn host Daiva Byrne will headline the first t.v. table of the Main Event. The action should be live shortly and you can watch it by clicking on the 'Livestream" tab within our coverage or by heading to OlyBet.tv.

Sebastian Wahl, 2023 Kings of Tallinn €555 Champion winner Benjamin Gros, Juho Suutari, Jari Mahonen, Aleksi Naski, Jan-Mikael Kesanen, and Justas Semaska round off what promises to be an exciting t.v. table.

Player		Chips	Progress
Sebastian Wahl		174,000	70,900
Benjamin Gros		118,000	54,800
Aleksi Naski		102,000	1,200
Juho Suutari		89,000	64,700
Jari Mahonen		40,000	15,800
Justas Semaska		35,000	2,300
Daiva Byrne		29,000	13,900
Jan-Mikael Kesanen		27,500	47,300
Max Rotko		0	0
Peder Behr		0	0
Yaniv Peretz		0	0
Igor Pihela Sr.		0	0
Eli Danielsson Malca		0	0
Fernando Yerro		0	0
Gundars Zelcs		0	0

914 Entries Create Record-Breaking €859,160 Prize Pool Posted Friday 1st March, 2024 at 15:02(UTC+0) by Jason Glatzer

Level 13: 1,000/2,500 (2,500)
Entries: 226/914

Late registration is officially closed. The clock is reading 914 entries with 226 players remaining but with all the action today the numbers will be checked, double-checked, and triple-checked before the official payouts are published. This created a record-breaking €859,160 prize pool for a €1,100 buy-in event in Estonia.

Best of luck to those still in action!

Eliminations Before Break Posted Friday 1st March, 2024 at 15:00(UTC+0) by Jason Glatzer

Player		Chips	Progress
Anatoly Filatov		0	0
Romans Krasins		0	0
Laur Sibold		0	0
Wissam Polus		0	0
Totti Arosuo		0	0

14:57 (UTC+0)

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

Larsen Leads at Break Posted Friday 1st March, 2024 at 14:57(UTC+0) by Jason Glatzer

Thomas Larsen held the chip lead at the break. There is still a few minutes left to go before the action resumes.

Player		Chips	Progress
Thomas Larsen		410,000	362,400
Luca Beretta		379,000	243,300
Sven Omland		377,500	59,500
Paul Koppe		359,000	259,500
Mikko Ylamaki		350,000	257,000
Jani Vilmunen		345,000	237,700
Herli Olop		345,000	5,000
Enea Subashi		305,000	272,700
Rolandas Aglinskas		305,000	200,000
Paul Newey		297,000	232,300

Break Time Posted Friday 1st March, 2024 at 14:32(UTC+0) by Jason Glatzer

Most of the players are now on break while a few tables are taking longer to play their final hands. Late registration will be closed as soon as the break is over. We will announce the final tally along with the total prize pool with the payouts to come a little later.

Silencov Having Fun With Bet Sizes Posted Friday 1st March, 2024 at 14:30(UTC+0) by Jason Glatzer

Level 12: 1,000/2,000 (2,000)
Entries: 222/894

Andrei Silencov bet 20,000 out of his stack of 24,500 from under the gun and was called by Ignas Jasinevicius from the cutoff.

Silencov min-bet 2,000 on the flop and another 2,000 on the turn and was called both times by Jasinevicius. A big jam of 500 in chips came on the river and Jasinevicius snap called.

Silencov's pulled ahead of Jasinevicius's to double his stack near the end of the late registration period.

Shortly after this hand, it was announced the final three hands of late registration.

Player		Chips	Progress
Ignas Jasinevicius		210,000	181,000
Andrei Silencov		65,000	500
Aleksander Lattikas		0	0
David Ozmen		0	0
Madis Muur		0	0
Henri Antikainen		0	0
Mihkel Vohla		0	0
Juuso Oksanen		0	0
Evaldas Kunickis		0	0
Ermo Kosk		0	0
Giuseppe Rosa		0	0
Eduards Rakuss		0	0

Recent Eliminations Posted Friday 1st March, 2024 at 14:12(UTC+0) by Jason Glatzer

Day 1c cihp leader Irmantas Bzeskis hit the rail recently along with all the players listed below.

Player		Chips	Progress
Michel Karim		0	0
Georgios Tsouloftas		0	0
Stanislav Agusevich		0	0
Martin Zobel		0	0
Joshua Stewart		0	0
Juha Kaitanen		0	0
Kristian Kostiander		0	0
Georgi Abuladze		0	0
Kaspars Butans		0	0
Martynas Kaulakys		0	0
Martin Heiberg		0	0
Irmantas Bzeskis		0	0
Tadas Pranckevicius		0	0
Andres Allsalu		0	0
Marten Rimmel		0	0
Jari Lahtinen		0	0
Kazimieras Ramaska		0	0
Jimmy Dewerdt		0	0
Martin Heiberg		0	0
Dmitrij Bogdanov		0	0

Olop Doubles Through Rysgaard Posted Friday 1st March, 2024 at 14:00(UTC+0) by Jason Glatzer

Level 12: 1,000/2,000 (2,000)
Entries: 238/877

Overall chip leader from Day 1a in Christian "Sleeping Beauty" Rysgaard and Day 1c chip leader Irmantas Bzeskis have been sitting side by side since the beginning of the day. The day hasn't started off great for either of them, but they both are still battling away.

However, it has worked out well for former Olympic Casino Poker Manager Herli Olop (pictured below) after winning a big pot against Rysgaard.

Mathias Siljander opened for a min-raise before Rysgaard three-bet. Olop shared he four-bet to 30,000 and Rysgaard was the only player to call. Olop bet big on the flop and smaller on the turn. Rysgaard called both times before jamming the river for more than the 70,000 Olop had in his stack.

Olop called and doubled his stack with against .

Player		Chips	Progress
Herli Olop		350,000	218,500
Mathias Siljander		160,000	80,100
Christian Rysgaard		150,000	160,000
Irmantas Bzeskis		70,000	65,200

Roller Coaster Ride for Kasper Mellanen Posted Friday 1st March, 2024 at 13:39(UTC+0) by Jason Glatzer

Level 12: 1,000/2,000 (2,000)
Entries: 257/856

It has been a roller coaster ride the last couple of hands for Kasper Mellanen during the closing moments of Level 11.

First Mellanen snagged the 25,000 in Egidijus Digrys's stack when his big slick was good against ace-seven. Next, Emanuele Mari got his stack of nearly 100,000 in and it was a 200,000 chip pot on the line with Mellanen ahead with kings against ace-king only to double his opponent after an ace hit the flop.

Last, but not least, he called a three-bet shove for about a starting stack by high-stakes stud Anatoly Filatov. 

Anatoly Filatov:
Kasper Mellanen:

Mellanen connected with the flop but was far behind the set Filatov improved to. Neither the turn nor the river was of any consequence for Filatov to officially double.

Meanwhile, the first-ever Kings of Tallinn Main Event champion Ranno Sootla hit the rail for the second time today.

Player		Chips	Progress
Emanuele Mari		205,000	157,400
Kasper Mellanen		110,000	104,000
Anatoly Filatov		65,000	35,000
Nikita Zarovs		0	0
Marko Olop		0	0
Juho Suutari		0	0
Viktor Chaikin		0	0
Peder Kjellen		0	0
Heikki Kinnunen		0	0
Elias Jalovaara		0	0
Egidijus Digrys		0	0
Mantas Bagocius		0	0
Ville-Tapio Mesirahta		0	0
Thomas Haverstad		0	0
Igor Pihela Sr.		0	0
Rytis Pranarauskas		0	0
Yuval Rosenberg		0	0
Henri Ojala		0	0
Lars Andersson		0	0
Kyosti Isberg		0	0
Jako Kuusik		0	0
Stanislav Smeljov		0	0
Laurynas Cerniauskas		0	0
Robertas Smolskis		0	0

13:27 (UTC+0)

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

Prize Pool Over €800K Posted Friday 1st March, 2024 at 13:19(UTC+0) by Jason Glatzer

The record-breaking Main Event prize pool keeps on growing with the field now at 852 entries for a "lucky" prize pool of €800,880.

Player		Chips	Progress
Anatoly Filatov		30,000	0
Juuso Wiksten		0	0
Mihkel Merekula		0	0
Nikolaos Ktenas		0	0
Romas Bassus		0	0
Juho Heiska		0	0
Maciej Komorowski		0	0
Bartlomiej Kijak		0	0
Richard Melby		0	0
Johan Palokangas		0	0
Tapio Aaltonen		0	0
Steponas Venckus		0	0
Nils Linden		0	0
Silja Kinnunen		0	0
Modestas Kryzanauskas		0	0
Kaspars Mamons		0	0

Cowboys for Kaitanen Posted Friday 1st March, 2024 at 13:11(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 270/846

Juha Kaitanen opened for 3,000 from under the gun and was called by Kristian Kostiander (pictured below) from middle position. Richard Koppel three-bet the button to 11,500. Mykolas Guiga cold-called from the bit blind before Kaitanen five-bet shoved for 46,700. Kostiander and Koppel folded, while Guiga tossed a chip in to call.

Juha Kaitanen:
Mykolas Guiga:

"I had ace-jack," said Koppel.

"I had fives," Kostiander added.

If Koppel had ace-jack he would have won after connecting with his ace on the runout. However, instead, Kaitanen's kings were good to double through Guiga.

Player		Chips	Progress
Juha Kaitanen		130,000	100,000
Richard Koppel		75,000	14,000
Kristian Kostiander		55,000	13,800
Mykolas Guiga		45,000	70,100

Big Slick No Good for Loikkanen Posted Friday 1st March, 2024 at 12:43(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 291/836

Michel Karim opened for 3,500 from middle position. Arto Loikkanen three-bet shoved for 18,500 from the hijack. Trond Aanestad went into the tank for about a minute before he four-bet jammed for 47,000 from the cutoff.

Karim, who chipped up a bit from the start of the day, asked for a count and then about 20 seconds later folded.

Arto Loikkanen:
Trond Aanestad:

Sevens won the flip and Loikkanen headed to the rail after the ran out on the board.

Player		Chips	Progress
Michel Karim		190,000	61,100
Trond Aanestad		75,000	20,900
Phil Gross		0	0
Juha Elo		0	0
Jose Larios		0	0
Arto Loikkanen		0	0

Atkell, Omland, and Rysgaard Lead Main Event Posted Friday 1st March, 2024 at 12:32(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 296/835

Greger Aktell appeared to have the chip lead at the break followed by Kings of Tallinn €350 Cup champion Sven Omland (pictured below) and start-of-the-day chip leader Christian "Sleeping Beauty" Rysgaard.

Check out some of the bigger stacks from around the room below. 

Player		Chips	Progress
Greger Aktell		327,000	185,800
Sven Omland		318,000	84,200
Christian Rysgaard		310,000	5,700
Adrians Imsa		290,000	84,400
Josep Pastor		260,000	63,600
Aleksei Smirnov		260,000	40,000
Henri Wagner		250,000	56,500
Niclas Mjelstad		249,000	144,700
Benny Hagberg		240,000	155,100
Kazimieras Ramaska		240,000	93,800
Kasper Mellanen		214,000	155,500

12:26 (UTC+0)

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

More Level 10 Eliminations Posted Friday 1st March, 2024 at 12:25(UTC+0) by Jason Glatzer

Player		Chips	Progress
Marko Vest		0	0
Christopher Barlow		0	0
Daniel Mccormack		0	0
Totti Arosuo		0	0
Eedi Kirves		0	0
Terje Finsveen		0	0
George Sandford		0	0
Ville Jantunen		0	0
Hans Erlandsson		0	0
Jon Gurrutxaga		0	0
Artur Kulanurk		0	0
Vetle Holum		0	0
Zydrunas Karcemarskas		0	0

First Break Posted Friday 1st March, 2024 at 12:05(UTC+0) by Jason Glatzer

Get up and stretch! Players are on a 20-minute break. We will update some of the biggest stacks from around the room shortly after the action resumes.

"Don't Write This" Posted Friday 1st March, 2024 at 12:04(UTC+0) by Jason Glatzer

Level 10: 600/1,200 (1,200)
Entries: 309/817

There is rarely a dull moment when Germany's Phil Gross (pictured below) is in Tallinn. He is a nice and funny guy that has a strong passion for poker.

"Don't write this," Gross said semi-seriously after we witnessed the following hand.

Gross three-bet jammed for about 16,000 and was looked up by Kaur-Silver Koha, who originally opened.

Phillip Gross:
Kaur-Silver Koha:

"Nice hand," Gross said as he stood up to watch the from a step away from the table. However, he sat back down after the turn improved him to a flush. Koha was drawing dead and officially paid off Gross after the river completed the board.

Meanwhile, local hero Marius Morel was the table caption with 170,000.

Player		Chips	Progress
Marius Morel		170,000	91,400
Kaur-Silver Koha		98,000	17,300
Phil Gross		35,000	36,100

Max Rotko Loses the Max Posted Friday 1st March, 2024 at 11:52(UTC+0) by Jason Glatzer

Level 10: 600/1,200 (1,200)
Entries: 309/817

We learned from Aki Pyysing that Max Rotko (pictured below) in Finnish translates to losing the max. Unfortunately, for Rotko he lived up to his name in a hand against Silver Simulask.

But before that hand happened, Allan Arjut shared that he paid off Rotko light with fives on a turn that improved Rotko to a flush to get back down to a starting stack.

Rotko and his improved stack then got it in on the flop against Simulask.

Max Rotko:
Silver Simulask:

Simulask was ahead but there were a few outs that could help Rotko not lose the max. However, the number of outs faded after the turn improved Simulask to a full house and the blank river sent Rotko to the rail for the third time today.

Player		Chips	Progress
Silver Simulask		130,000	64,800
Aki Pyysing		42,000	9,600
Allan Arjut		31,000	3,200
Hanna Heinlo		0	0
Max Rotko		0	0
Eleftherios Sinnos		0	0
Paulius Glosas		0	0
Michael Ibba		0	0
Christos Leantzis		0	0
Algirgas Sukys		0	0
Emil Heikkinen		0	0
Kaspars Butans		0	0
Siim Suviste		0	0
Sander Lithun		0	0
Hai Hoang		0	0
Viktor Chaikin		0	0
Simo Raikkonen		0	0
Jan-Mikael Kesanen		0	0

Recent Eliminations Posted Friday 1st March, 2024 at 11:39(UTC+0) by Jason Glatzer

The following players including Finland's Anne-Mari Hursti hit the rail during the first half of Level 10.

Player		Chips	Progress
Andrea Benelli		0	0
Anne Koskinen		0	0
Doroslav Rasiukevic		0	0
Neeme Org		0	0
Dominykas Skrinska		0	0
Anna-Mari Hursti		0	0
Justas Vaiciulionis		0	0
Yana Gorskaya		0	0
Kent Lindback		0	0
Kim Lindstrom		0	0
Jaanus Veste		0	0
Martynas Kaulakys		0	0
Gisle Olsen		0	0
Patriks Svinka		0	0
Tanel Evert		0	0
Rickard Rohani		0	0
Aleksandr Kuperman		0	0
Andreas Werner		0	0
Risto Parnat		0	0
Niklas Gjersvold		0	0

Smirnov Flops a Straight Posted Friday 1st March, 2024 at 11:31(UTC+0) by Jason Glatzer

Level 10: 600/1,200 (1,200)
Entries: 319/808

Aleksei Smirnov (pictured below) bet 31,000 into a pot of a little bit more with the on the board. Fernando Yerro tanked for about a minute before he called.

Smirnov turned over the . Yerro shook his head in frustration and mucked his hand after being unable to produce an equal or better straight.

Meanwhile, Vytautas Laurinaitis, who is sitting at the same table, chipped up a little as well since the start of the day.

Player		Chips	Progress
Aleksei Smirnov		220,000	50,000
Vytautas Laurinaitis		175,000	57,900
Fernando Yerro		35,000	35,400

800 Entries! Posted Friday 1st March, 2024 at 11:16(UTC+0) by Jason Glatzer

Level 10: 600/1,200 (1,200)
Entries: 338/800

The record for the Main Event keeps getting bigger and bigger as the field has reached 800 entries for a €752,000 prize pool and growing!

Thank you to all of the players for contributing to the success of the Kings of Tallinn and may the cards be with you today.

2023 Kings of Tallinn Main Event Champ Parmasto Among the Level 9 Eliminations Posted Friday 1st March, 2024 at 11:12(UTC+0) by Jason Glatzer

2023 Kings of Tallinn Main Event champion Priit Parmasto hit the rail on Level 9 and hasn't yet re-entered. He wasn't the only one as all of the above players hit the rail and thus far having headed back to the registration desk.

Player		Chips	Progress
Hengtao Zhu		0	0
Seppo Parkkinen		0	0
Daniyel Destici		0	0
Massimo Casabona		0	0
Vladimir Trojak		0	0
Fatih Kizilkaya		0	0
Simone Battaglia		0	0
Luigi Tasca		0	0
Priit Parmasto		0	0

11:06 (UTC+0)

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

Tikka Gives Up to Lattikas Posted Friday 1st March, 2024 at 11:06(UTC+0) by Jason Glatzer

Level 9: 500/1,000 (1,000)
Entries: 338/794

Kris Tikka (pictured below) bet 22,000 into a pot of at least 30,000 with the on the board. Aleksander Lattikas went into the tank for a couple of minutes before he jammed.

Tikka tanked for a minute before he asked for a count. Lattikas's jam of 72,800 was confirmed and Tikka tanked for around two more minutes before he folded.

Lattikas looked back down at his cards and updated to show his .

Several at the tables gasped or had their mouths open wide when he tabled with "nice play" being heard as well from a table away.

Player		Chips	Progress
Aleksander Lattikas		145,000	31,400
Kris Tikka		105,000	36,600

Day 2 Eliminations Posted Friday 1st March, 2024 at 10:54(UTC+0) by Jason Glatzer

The following players have hit the rail on Day 2. This list below represents players that haven't re-entered at the time of this post but might do so within the next four hours until late registration closes.

Player		Chips	Progress
Federico Cipollini		0	0
Darius Miklovas		0	0
Thor Morstol		0	0
Pasi Trollhjarta		0	0
Rytis Pranarauskas		0	0
Eetu Porkka		0	0
Ragnar Toompere		0	0
Joachim Gjerstad		0	0
Madis Ormisson		0	0
Adomas Juozapavicius		0	0
Ari Varonen		0	0
Andrei Harlanov-Voogla		0	0
Kiur Koster		0	0
Audrius Navickas		0	0
Meelis Suurorg		0	0
Tomas Kirchovas		0	0
Jesperi Jarvinen		0	0

Two Pair for Leibgorin Posted Friday 1st March, 2024 at 10:46(UTC+0) by Jason Glatzer

Level 9: 500/1,000 (1,000)
Entries: 346/781

Michel Leibgorin re-entered at the start of the day and thus far it has been all peaches and ice cream for the French poker veteran.

Leibgorin recently jammed 15,000 into a pot of 35,000 with the on the board after the turn. Rolandas Aglinskas, who chipped up from his start-of-the-day stack, asked for a count and called about a minute later.

"I only have a seven," Leibgorin said as he turned over the .

Leibgorin seemed surprised he was ahead as Aglinskas tabled the .

"I have two pair!" Leibgorin said with a smile after the river completed the board to double his stack.

Player		Chips	Progress
Rolandas Aglinskas		105,000	32,600
Michel Leibgorin		65,000	35,000

Rockets Hold for Vaitulionis Against Pihela Sr. Posted Friday 1st March, 2024 at 10:31(UTC+0) by Jason Glatzer

Level 9: 500/1,000 (1,000)
Entries: 344/775

Ignas Vaitulionis opened from middle position. Igor Pihela Sr. (pictured below) three-bet to 5,500 from the small blind. Vaitulionis called before Pihela Sr. jammed around a starting stack on the flop.

Igor Pihela Sr.:
Ignas Vaitulionis:

Pihela Sr. needed a miracle to survive but there was no chance of that happening after he was drawing dead on the turn. The river completed the board and Pihela Sr. was walking towards the registration desk to re-enter for another chance at winning a slice of the record-breaking Main Event prize pool.

Player		Chips	Progress
Ignas Vaitulionis		100,000	40,900
Igor Pihela Sr.		30,000	44,500

Salonen Calls AFTER a Count Posted Friday 1st March, 2024 at 10:17(UTC+0) by Jason Glatzer

Level 9: 500/1,000 (1,000)
Entries: 345/762

The action paused on Rytis Pranarauskas before he fired out a pot-sized jam into a pot of around 60,000 with the on the board.

"Count," said Jarmo Salonen.

"Call?" asked the dealer as Salonen's statement was unclear.

"Count," Salonon said a bit clearer.

Salonen opted to call a short while after the count was confirmed. Pranarauskas turned over the and was on the rail after Salonen tabled the for two pair.

Player		Chips	Progress
Jarmo Salonen		200,000	92,400
Rytis Pranarauskas		0	0

Prize Pool Over €700K Posted Friday 1st March, 2024 at 10:07(UTC+0) by Jason Glatzer

Level 9: 500/1,000 (1,000)
Entries: 346/754

Kings of Tallinn Founder and Tournament Director Teresa Nousiainen welcomed the crowd for Day 2 of the record-breaking Kings of Tallinn Main Event.

The prize pool soared past €700,000 already with 23 new players coming into the mix before the first cards were dealt including Monika Leek, Giuseppe Rosa, and Maciej Komorowski.

Expect tons of action while late registration remains open and for the prize pool to grow. Best of luck to all of the players.

Player		Chips	Progress
Giuseppe Rosa		30,000	0
Maciej Komorowski		30,000	0
Monika Leek		30,000	0

10:04 (UTC+0)

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

Day 2 of the Record-Breaking Kings of Tallinn Main Event Begins at Noon Posted Friday 1st March, 2024 at 08:33(UTC+0) by Jason Glatzer

The 2024 Kings of Tallinn has been truly magical with the festival witnessing records breaking left and right. History has been made once again as the latest attendance record was shattered early on Thursday with the Kings of Tallinn €1,100 Main Event guaranteed to be the largest in history. Not only was the lofty €500,000 guarantee smashed with 731 runners so far for a €687,140 prize pool and growing but this is already guaranteed to be the largest €1,100 Main Event in Estonian poker history.

Day 2 will kick off on Friday at Noon with more players getting into the mix thanks to late registration and re-entries available for the first four blind levels of one hour each. Players buying in at the start of the day will play off a decent stack of 30 big blinds with a 30,000 starting stack and the 500/1,000 (1,000) blind level repeating at the start of the day.

Lithuania's Christian Rysgaard not only earned the name of "Sleepy Beauty" in the €555 Championship but is in the driver's seat to further cement the new legend's status in the Kings of Tallinn history books as he will begin Day 2 with a chip-leading stack of 304,300.

No other player bagged anything else that was close. However, three other players in 2024 Kings of Tallinn €350 Cup champion Sven Omland (233,800), Latvia's Adrian Imsa (205,600), and United Kingdom's Maximillian Sanders (203,900).

Sanders (pictured below), had the day off after bagging his big stack on Wednesday's Day 1a and made the most of it as he won a trophy on Thursday evening in the €250 NLH to bank €7,280.

The plan for today is to play eight blind levels of one hour each. However, this is subject to change. The field is expected to grow even bigger today, so the day may be extended.

Our reporting will begin when cards are in the air at 12 p.m. for Day 2. Players bagging on Day 2 will battle for two more days until the record-breaking Kings of Tallinn Main Event has been crowned.

* Day 2 Seat Draw

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

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter