0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0100 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-24' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ' ORDER BY `views` DESC

0.0015 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ', 1, '2024-04-24')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '90' AND `name` = '3'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

English
Kings of Tallinn 2024 Event #12: €555 Championship (English) Live Reporting - Day 3
1 New Update - Click to refresh
Live Updates - Day 3
21:57 (UTC+2)
Day 3 of Kings of Tallinn 2024 Ended
Level: 35     Blinds: 200,000/400,000     Ante: 400,000
Reigning Finnish Champion Mikko Ylämäki Conquers Enormous Field to Win the €555 Kings of Tallinn Championship Posted Wednesday 28th February, 2024 at 21:56(UTC+2) by Frank Visser

The €555 Kings of Tallinn Championship brought a huge crowd of 700 entries to Olympic Park Casino in Tallinn, creating a massive prize pool of €329,000, a new record for this tournament. After three days of battle, Mikko Ylämäki from Finland was victorious over all of them, winning €58,835 after a heads-up deal with Andrius Bielskis. Bielskis had to console himself with the €49,875 he received as runner-up but had to see the trophy be awarded to Ylämäki after a nearly two-hour heads-up.

Ylämäki, who was crowned Finnish champion after winning the €560 Main Event in Helsinki back in October, secured his largest-ever recorded cash with the victory, with his previous largest being set in Tallinn as well. The Finnish player is a regularly seen guest in the Estonian capital, most recently finishing in fifth place in the €3,000 High Roller at Kings of Tallinn 2023.

Ylämäki defeated some tough competition on his way to victory, not only beating the very accomplished Bielskis heads-up but also defeating the likes of long-time Finnish crusher Joonas Helin and Kings of Tallinn trophy owner Touko Berndtson at the final table.

€555 Championship Final Table Results

Place Player Country Prize
1 Mikko Ylämäki Finland €58,835*
2 Andrius Bielskis Lithuania €49,875*
3 Joonas Helin Finland €27,900
4 Oscar Peleg Sweden €20,100
5 Jordi Baixas Spain €15,200
6 Aleksandrs Krumins Latvia €11,250
7 Touko Berndtson Finland €8,700
8 Matte Karjalainen Finland €7,200
9 Knut Trulsen Norway €5,890

* = Denotes heads-up deal

Day 3 Action

After an elongated Day 2 left 13 players returning to Day 3, four eliminations had to take place before the streamed final table of nine could begin. The short-stacked Adrians Imsa was the first to fall, after which Jan-Mikael Kesanen quickly followed. The tournament then went on for another hour without anyone leaving, but ultimately Svetozar Marinov and Konsta Heikkila fell in quick succession to leave a final table of nine.

After a few minutes of play, Knut Trulsen became the shortest stack when two other players doubled up. He got his final blinds in with pocket fives and could not win against the tens of Helin. The war of attrition then began as several players doubled up their short stacks before Matte Karjalainen fell victim to then-chipleader Andrius Bielskis in a blind-on-blind confrontation.

Berndtson soon followed when Helin’s ace-queen beat his pocket queens for a sour exit, and Aleksandrs Krumins, who started the final table with the most chips but had gotten short, was eliminated in sixth place soon thereafter, marking Ylämäki’s first knock-out of the final table. Spain’s Jordi Baixas also fell after a mistimed three-bet shove against the same Ylämäki not long after that.

Meanwhile, short-stack ninja Oscar Peleg suddenly found himself among the final four, but that is where his story ended as he could not win a flip against Ylämäki. The Finn scored his third elimination in a row and would add a fourth to that just one orbit later when he ousted Helin with the better hand blind-on-blind.

Heads-Up

It was looking like Ylämäki’s day when he started heads-up play with a three-to-one chip advantage. He even had Bielskis all in with top pair against ace-high on a flop mere moments after restarting the tournament, but Bielskis made runner-runner trips to secure his double-up and take a small lead.

Ylämäki then got lucky of his own when his flopped second pair won against the top pair of Bielskis to stay alive in an all-in situation, and was at risk a second time not much later but won two flips in quick succession to secure a huge chip lead. 

Bielskis was granted one comeback by winning a flip of his own, but the back-and-forth heads-up battle finally ended when Ylämäki’s king-jack held against the king-nine of Bielskis, securing him the title, the trophy, and the €1,855 the players left in the middle after striking a deal.

That concludes the story of the record-breaking €555 Kings of Tallinn Championship, but be sure to check out the live reports of the other events in the Estonian capital as well, among which the flagship €1,100 Main Event.

Mikko Ylämäki Overcomes Huge Field to Become the €555 Kings of Tallinn Championship Champion (€58,835) Posted Wednesday 28th February, 2024 at 20:31(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 1/700

Mikko Ylämäki from Finland won the €555 Kings of Tallinn Championship after a long and swingy heads-up battle with Andrius Bielskis.

The victory saw him win €58,835 after a heads-up deal, and of course the glorious Kings of Tallinn trophy.

Stay tuned for a full recap of the finale.

Player Chips Progress
Mikko Ylamaki 21,000,000 6,000,000
Andrius Bielskis 0 0
Andrius Bielskis Eliminated in 2nd Place (€49,875) Posted Wednesday 28th February, 2024 at 20:26(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 1/700

Andrius Bielskis looked down at on the button and limped in. Mikko Ylämäki then raised to 1,200,000 in the big blind with before Bielskis quickly jammed all in for 8,000,000.

Ylämäki spent some time in the tank before putting in the call to put Bielskis at risk.

Andrius Bielskis:
Mikko Ylämäki:

Bielskis found a gutshot on the turn on , but neither that nor his nine came in on the river and he had to console himself with becoming the runner-up and cashing for the €49,875 he secured himself in the heads-up deal.

Player Chips Progress
Mikko Ylamaki 21,000,000 6,000,000
Andrius Bielskis 0 0
Ylämäki Wins Big Pot With Nines Posted Wednesday 28th February, 2024 at 20:18(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Mikko Ylämäki limped in from the button with and Andrius Bielskis checked his option in the big blind with . Bielskis checked on the flop, after which Ylämäki made a bet of 400,000.

Bielskis raised to 1,200,000 with his top pair, but Ylämäki three-bet to 2,500,000. Bielskis put in the chips for a call and the turn was dealt.

Bielskis checked to Ylämäki, who opted for a bet of 1,500,000. Bielskis once again obliged with a call and the river rolled off.

Bielskis checked once again and Ylämäki thought for a while before checking behind. His pocket nines won at showdown, once again creating a large gap between the two players.

Player Chips Progress
Mikko Ylamaki 15,000,000 5,200,000
Andrius Bielskis 6,400,000 4,600,000
Bielskis Regains Lead as Heads Up Continues Posted Wednesday 28th February, 2024 at 20:12(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Andrius Bielskis jammed his 5,400,000 chips in from the button and Mikko Ylämäki snap called from the big blind.

Andrius Bielskis:
Mikko Ylämäki:

Another flip for the tournament win, but it was yet again the at-risk player who won when Bielskis fours held on the runout to secure him his double-up and even a small chip lead.

Player Chips Progress
Andrius Bielskis 11,000,000 7,000,000
Mikko Ylamaki 9,800,000 7,200,000
Bielskis Still In the Game Posted Wednesday 28th February, 2024 at 20:06(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Andrius Bielskis jammed all in from the button for 1,800,000 and Mikko Ylämäki called in the big blind.

Andrius Bielskis:
Mikko Ylämäki:

Bielskis' queen-high remained the best hand on and he doubled up to a stack of ten big blinds.

Player Chips Progress
Mikko Ylamaki 17,000,000 0
Andrius Bielskis 4,000,000 400,000
Ylämäki Grabs Massive Chip Lead in Huge Flip Posted Wednesday 28th February, 2024 at 20:01(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Andrius Bielskis limped in from the button and Mikko Ylämäki jammed all in for 8,500,000 from the big blind. Bielskis thought it over for a while before slamming in the call to put his opponent at risk once more.

Mikko Ylämäki:
Andrius Bielskis:

Ylämäki remained ahead throughout the runout, securing his double-up and a massive chip lead as Bielskis was left with only nine big blinds.

Player Chips Progress
Mikko Ylamaki 17,000,000 7,900,000
Andrius Bielskis 3,600,000 8,400,000
Ylämäki Finds the Fold Posted Wednesday 28th February, 2024 at 19:57(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Andrius Bielskis limped in with on the button and Mikko Ylämäki checked his in the big blind. Ylämäki then checked on the flop and called the subsequent 600,000 bet of Bielskis. The turn was checked through before the river completed the board.

Ylämäki checked his ace-high once more, but Bielskis made a bet of 2,000,000 with his turned full house. Ylämäki spent some time in the tank before finding a fold, saving him some chips.

Player Chips Progress
Andrius Bielskis 12,000,000 0
Mikko Ylamaki 9,100,000 200,000
Ylämäki Wins Flip to Stay Alive Posted Wednesday 28th February, 2024 at 19:52(UTC+2) by Frank Visser

Level 35: 200,000/400,000 (400,000)
Entries: 2/700

Mikko Ylämäki limped in from the button before Andrius  Bielskus jammed all in from the big blind. Ylämäki quickly called his 4,500,000 stack off, and the cards were tabled.

Mikko Ylämäki:
Andrius Bielskis:

Ylämäki hit top pair on the flop, and did not look back on the runout. He secured a double-up and the stacks were once again close to even.

Player Chips Progress
Andrius Bielskis 12,000,000 5,000,000
Mikko Ylamaki 9,300,000 4,800,000
19:49 (UTC+2)
Start of Level 35
Blinds: 200,000/400,000     Ante: 400,000
Ylämäki Loses With Big Slick Posted Wednesday 28th February, 2024 at 19:48(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Andrius Bielskis limped in from the button with before Mikko Ylämäki raised his big blind to 800,000 with and received a call from his opponent.

Ylämäki continued for 400,000 on the flop, which Bielskis raised to 1,200,000 with his flopped two pair.

Ylämäki put in the extra chips and both players checked on the subsequent turn. The river then completed the board , which was also checked down.

Bielskis' two pair won at showdown and Ylämäki was once again left with a stack of 15 big blinds.

Player Chips Progress
Andrius Bielskis 17,000,000 2,000,000
Mikko Ylamaki 4,500,000 1,700,000
Bielskis Widens Gap With "The Robbi" Posted Wednesday 28th February, 2024 at 19:44(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Andrius Bielskis raised to 650,000 on the button with and Mikko Ylämäki made the call with in the big blind.

Bielskis fired 400,000 chips on the flop and Ylämäki quickly check-folded to forfeit the pot.

Player Chips Progress
Andrius Bielskis 15,000,000 2,000,000
Mikko Ylamaki 6,200,000 2,000,000
Bielskis Hits Two Pair Posted Wednesday 28th February, 2024 at 19:40(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Andrius Bielskis limped in with on the button and Mikko Ylämäki checked in the big blind. Ylämäki then check-called Bielskis' bet of 300,000 on the board before both players checked the  turn.

The river was also knuckled down, and Bielskis' two pair took down the pot at showdown.

Player Chips Progress
Andrius Bielskis 13,000,000 1,000,000
Mikko Ylamaki 8,200,000 1,100,000
Bielskis Picks Bad Time to Bluff Posted Wednesday 28th February, 2024 at 19:30(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Andrius Bielskis limped in with from the button and Mikko Ylämäki checked his in the big blind. Bielskis then made a bet of 300,000 on the flop after a check from Ylämäki.

Ylämäki made the call and the turn hit the felt. Ylämäki checked once more but Bielskis did not relent and put forth 900,000 chips. Ylämäki called again with his top pair, leading to the river completing the board.

Bielskis decided to give up his bluff as two quick checks followed each other, and Ylämäki took down the pot at showdown to even the stacks even more.

Player Chips Progress
Andrius Bielskis 12,000,000 1,000,000
Mikko Ylamaki 9,300,000 1,500,000
Ylämäki On the Rise Posted Wednesday 28th February, 2024 at 19:26(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Mikko Ylämäki limped in from the button with and Andrius Bielskis checked his in the big blind.

The flop was checked through before Ylämäki made a bet of 400,000 on the turn. Bielskis check-called, and did so too when Ylämäki bet 500,000 on the river. 

Ylämäki's second pair won him a sizable pot as the chip difference between the two players lessened.

Player Chips Progress
Andrius Bielskis 13,000,000 3,000,000
Mikko Ylamaki 7,800,000 3,100,000
Ylämäki Folds a Pair Posted Wednesday 28th February, 2024 at 19:20(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Mikko Ylämäki raised to 600,000 on the button with and Andrius Bielskis defended his big blind with . The flop was checked by both players before Bielskis made a bet of 1,000,000 on the turn.

Ylämäki thought it over but ultimately folded his third pair, leaving him with just over 15 big blinds.

Player Chips Progress
Andrius Bielskis 16,000,000 1,000,000
Mikko Ylamaki 4,700,000 1,200,000
Ylämäki's Set Gains Little Posted Wednesday 28th February, 2024 at 19:17(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Mikko Ylämäki looked down at on the button and limped in, after which Andrius Bielskis checked the big blind with .

Bielskis quickly check-folded as Ylämäki flopped a set on the board, seeing a small pot go to Ylämäki.

Player Chips Progress
Andrius Bielskis 15,000,000 0
Mikko Ylamaki 5,900,000 500,000
Ylämäki Hits Trips for Survival Posted Wednesday 28th February, 2024 at 19:11(UTC+2) by Frank Visser

Level 34: 150,000/300,000 (300,000)
Entries: 2/700

Mikko Ylämäki shoved in his 3,000,000 chips from the button and Andrius Bielskis made the call in the big blind.

Mikko Ylämäki:
Andrius Bielskis:

The flop paired up both players, but increased Bielskis' lead. It was looking like he might win the tournament in this hand, but the turn spelled disaster for him as Ylämäki upgraded to trips.

The river put some salt in Bielskis' wound as his two pair was not good enough to beat Ylämäki, who doubled up to just over 20 big blinds.

Player Chips Progress
Andrius Bielskis 15,000,000 2,000,000
Mikko Ylamaki 6,400,000 2,700,000
19:07 (UTC+2)
Start of Level 34
Blinds: 150,000/300,000     Ante: 300,000
Bielskis Extends Lead Posted Wednesday 28th February, 2024 at 19:05(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Andrius Bielskis limped in with on the button and Mikko Ylämäki made it 800,000 to go on the button with .

The flop fell and Ylämäki made a bet of 700,000. Bielskis then jammed all in with his flush draw, forcing a quick fold from his opponent and widening the gap between the two remaining contestants.

Player Chips Progress
Andrius Bielskis 17,000,000 2,000,000
Mikko Ylamaki 3,700,000 2,500,000
Heads-Up Deal Posted Wednesday 28th February, 2024 at 18:58(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikko Ylämäki and Andrius Bielskis have agreed to a deal, with Ylämäki taking home €56,980 and Bielskis being awarded €49,875.

The players are still playing for the trophy and €1,855 which will be awarded to the eventual champion.

Bielskis Five-Bet Jams Posted Wednesday 28th February, 2024 at 18:54(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikko Ylämäki raised to 500,000 on the button with and Andrius Bielskis three-bet to 1,500,000 with in the big blind.

Ylämäki furthered the raising war with a four-bet to 3,600,000, after which Bielskis shoved all in to put Ylämäki at risk for 9,800,000 chips.

Ylämäki, however, decided to fold and save his remaining chips for another time.

Player Chips Progress
Andrius Bielskis 15,000,000 4,000,000
Mikko Ylamaki 6,200,000 3,600,000
Bielskis Takes the Lead With Lucky Double-Up Posted Wednesday 28th February, 2024 at 18:49(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Andrius Bielskis raised to 525,000 on the button which Mikko Ylämäki called in the big blind.

The flop was checked by Ylämäki, after which Bielskis put forth a bet of 400,000. Ylämäki then raised to 800,000 and Bielskis pushed all in for 5,000,000 chips. 

Ylämäki made the call and both holdings were tabled for the cameras.

Andrius Bielskis:
Mikko Ylämäki:

Ylämäki had a solid lead with his top pair, but it was obliterated by the turn. The river upgraded Bielskis to trips, and his chips were counted as he doubled up and grabbed the chip lead from his opponent.

Player Chips Progress
Andrius Bielskis 11,000,000 5,500,000
Mikko Ylamaki 9,800,000 6,200,000
Bielskis Makes a Move Posted Wednesday 28th February, 2024 at 18:45(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikko Ylämäki raised to 500,000 on the button with and Andrius Bielskis called in the big blind with .

Bielskis then check-called Ylämäki's 450,000 bet on the flop before Ylämäki fired 500,000 more on the turn, after another check from Bielskis.

Bielskis then raised to 1,300,000 and Ylämäki stuck around with his middle pair as he tossed in a call.

The river gave Ylämäki two pair, but Bielskis quickly surrendered as he check-folded to a 2,000,000 bet from his opponent, surrendering the pot to Ylämäki.

Player Chips Progress
Mikko Ylamaki 16,000,000 2,000,000
Andrius Bielskis 5,500,000 1,900,000
Joonas Helin Eliminated in 3rd Place (€27,900) Posted Wednesday 28th February, 2024 at 18:37(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 2/700

Mikka Ylämäki pushed all in from the small blind and Joonas Helin made the call in the big blind to put his 2,000,000 chips at risk.

Joonas Helin:
Mikka Ylämäki:

Neither player upgraded their hand on the runout, and Ylämäki's queen-high secured him a spot in the heads-up, sending Helin home in third place.

Player Chips Progress
Mikko Ylamaki 14,000,000 3,000,000
Andrius Bielskis 7,400,000 100,000
Joonas Helin 0 0
Oscar Peleg Eliminated in 4th Place (€20,100) Posted Wednesday 28th February, 2024 at 18:32(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 3/700

Oscar Peleg jammed all in from the small blind for 1,900,000 chips, and he received an instant call from chipleader Mikko Ylämäki in the big blind.

Oscar Peleg:
Mikko Ylämäki:

The flop and turn gave Peleg a plethora of outs, but he bricked them all on the river. Peleg gave some fist bumps before leaving the table to collect his fourth-place winnings.

Player Chips Progress
Mikko Ylamaki 11,000,000 1,500,000
Oscar Peleg 0 0
Bielskis Gets Paid Posted Wednesday 28th February, 2024 at 18:29(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 4/700

Joonas Helin limped in from the small blind with and Andrius Bielskis checked his in the big blind.

Both players flopped pairs on the flop, on which Helin bet 250,000 chips and Bielskis called. The turn then saw Helin slow down with a check, resulting in a 350,000 bet from Bielskis.

Helin called to see the river, on which he faced a 1,800,000 bet from his opponent. He immediately flicked in a calling chip to pay off the big bet, but saw his bottom two pair was no good against the trips of Bielskis.

Helin was left with about six big blinds, while Bielskis secured a second place on the leaderboard.

Player Chips Progress
Andrius Bielskis 7,500,000 3,400,000
Joonas Helin 1,600,000 2,600,000
Ylämäki Wins First Pot Post-Break Posted Wednesday 28th February, 2024 at 18:24(UTC+2) by Frank Visser

Level 33: 125,000/250,000 (250,000)
Entries: 4/700

Mikko Ylämäki raised to 800,000 from the small blind with and Joonas Helin called from the big blind with

Ylämäki then continued for 500,000 on the flop and received a quick fold from his opponent, awarding him the pot

Player Chips Progress
Mikko Ylamaki 9,500,000 300,000
Joonas Helin 4,200,000 1,100,000
18:21 (UTC+2)
Start of Level 33
Blinds: 125,000/250,000     Ante: 250,000
Another Break Posted Wednesday 28th February, 2024 at 18:02(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 4/700

Four players remain, and they have been sent on a 20-minute break before play resumes.

Player Chips Progress
Mikko Ylamaki 9,200,000 400,000
Joonas Helin 5,300,000 600,000
Andrius Bielskis 4,100,000 400,000
Oscar Peleg 2,400,000 200,000
Bielskis Attempts Check-Raise Posted Wednesday 28th February, 2024 at 17:57(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 4/700

Mikko Ylämäki raised to 400,000 from the cutoff with and Andrius Bielskis made the call in the big blind with .

Bielskis then checked to Ylämäki on the flop, after which the latter bet 250,000. Bielskis then made it 650,000 to go and Ylämäki put in a call.

The turn was then checked by both players before Bielskis checked again on the river. Ylämäki, on the other hand, made a bet of 700,000 with his pair of queens, forcing Bielskis to fold his bottom pair and surrender the pot.

Player Chips Progress
Mikko Ylamaki 9,600,000 600,000
Andrius Bielskis 4,500,000 1,300,000
Jordi Baixas Eliminated in 5th Place (€15,200) Posted Wednesday 28th February, 2024 at 17:51(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 4/700

Mikko Ylämäki jammed all in from the small blind and Jordi Baixas called in the big blind, being at risk with 3,100,000 chips.

Jordi Baixas:
Mikko Ylämäki:

This time, the cards were reversed, but the winning hand would remain the same as the board saw Ylämäki make trips to lock the pot up on the turn.

Baixas was sent home in 5th place and headed to the payout desk as play continued four-handed.

Player Chips Progress
Mikko Ylamaki 9,000,000 3,200,000
Jordi Baixas 0 0
Meet Queens of Tallinn Host & FLIP Founder Daiva "Baltic Blonde" Byrne Posted Wednesday 28th February, 2024 at 17:49(UTC+2) by Jason Glatzer

Ylämäki Loses Chip Lead, Doubles Up Baixas Posted Wednesday 28th February, 2024 at 17:45(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 5/700

Mikko Ylämäki raised to 400,000 from the cutoff and Jordi Baixas jammed all in from the button for 1,400,000 chips. Ylämäki made the call and the cards went on their backs.

Jordi Baixas:
Mikko Ylämäki:

The board helped neither player and Baixas thus doubled up with the better preflop hand.

Player Chips Progress
Mikko Ylamaki 5,800,000 1,000,000
Jordi Baixas 3,300,000 500,000
Ylämäki Claims Chip Lead Posted Wednesday 28th February, 2024 at 17:40(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 5/700

Andrius Bielskis pushed his large stack in from the button and was called by Mikko Ylämäki in the big blind, who was risking 3,400,000 chips by doing so.

Andrius Bielskis:
Mikko Ylämäki:

The flop saw Bielskis flop a gutshot for some extra outs, but the turn and river remained clean for Ylämäki, who doubled up and took over the chip lead.

Player Chips Progress
Mikko Ylamaki 6,800,000 2,900,000
Andrius Bielskis 5,800,000 3,300,000
Peleg's Ace Remains In Play Posted Wednesday 28th February, 2024 at 17:29(UTC+2) by Frank Visser

Level 32: 100,000/200,000 (200,000)
Entries: 5/700

Andrius Bielskis shipped it in from the small blind and Oscar Peleg made the call in the big blind to put his 1,200,000 chips at risk.

Oscar Peleg:
Andrius Bielskis:

The board brought two pair with , resulting in Peleg's ace kicker taking down the pot and doubling him up.

Player Chips Progress
Andrius Bielskis 9,100,000 100,000
Oscar Peleg 2,600,000 1,200,000
17:26 (UTC+2)
Start of Level 32
Blinds: 100,000/200,000     Ante: 200,000
Aleksandrs Krumins Eliminated in 6th Place (€11,250) Posted Wednesday 28th February, 2024 at 17:25(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 5/700

Mikko Ylämäki raised to 300,000 on the button and called the subsequent all-in for 1,300,000 from former chipleader Aleksandrs Krumins in the small blind.

Aleksandrs Krumins:
Mikko Ylämäki:

Ylämäki paired up on the flop to take a commanding lead, but the turn gave Krumins some hope. The river did not bring his straight, however, and he said his goodbyes before leaving the table in fifth place.

Player Chips Progress
Mikko Ylamaki 3,900,000 1,300,000
Aleksandrs Krumins 0 0
Peleg Gets It In Good Posted Wednesday 28th February, 2024 at 17:20(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 6/700

Joonas Helin raised to 300,000 from the cutoff before Oscar Peleg went all in for 550,000 in the small blind.

Helin put in the extra chips for a call and the cards were shown down.

Oscar Peleg:
Joonas Helin:

Peleg flopped two pair on and had Helin drawing dead on the turn. The river was meaningless and Peleg stacked up his newly acquired chips to stay in contention.

Player Chips Progress
Joonas Helin 4,700,000 500,000
Oscar Peleg 1,400,000 200,000
Ylämäki's Queens Do the Trick Posted Wednesday 28th February, 2024 at 17:16(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 6/700

Mikko Ylämäki jammed all in for 1,100,000 chips in the hijack and Jordi Baixas made the call on the button with the covering stack.

Mikko Ylämäki:
Jordi Baixas:

This time, the ladies faced no troubles on the runout and Ylämäki booked another double-up.

Player Chips Progress
Jordi Baixas 2,800,000 1,100,000
Mikko Ylamaki 2,600,000 1,100,000
Touko Berndtson Eliminated in 7th Place (€8,700) Posted Wednesday 28th February, 2024 at 17:12(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 6/700

Joonas Helin sat in middle position and raised to 300,000. Touko Berndtson then put in 2,400,000 chips from the button for an all-in and it folded back to Helin.

After asking for a count and tanking for a while, he slammed in the chips for a call to put his opponent at risk.

Touko Berndtson:
Joonas Helin:

It was looking like Berntson was set for a double-up, but the flop saw Helin hit an ace to take a dominant lead. The turn left Berndtson with one out to hit, and it did not arrive on the river, resulting in his elimination in seventh place.

Player Chips Progress
Joonas Helin 5,200,000 1,900,000
Touko Berndtson 0 0
Baixas Wins Flip for Tournament Life Posted Wednesday 28th February, 2024 at 17:07(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 7/700

Jordi Baixas opened to 1,000,000 from middle position, his usual half-stack sizing, and the action folded to Andrius Bielskis in the cutoff, who put Baixas all in for 1,750,000.

Baixas made the call and was at risk against the chipleader as the cards went on their backs.

Jordi Baixas:
Andrius Bielskis:

Baixas flopped some extra outs on the flop, but the turn took some away as it gave Bielskis a flush draw. 

However, the river saw Baixas make second pair for the best hand and he raked in an important double-up as he shot up the ranks.

Player Chips Progress
Andrius Bielskis 9,000,000 1,000,000
Jordi Baixas 3,900,000 2,200,000
Video Highlights From Day 5 Posted Wednesday 28th February, 2024 at 16:50(UTC+2) by Jason Glatzer

Check out the video highlights below from Day 5 of the 2024 Kings of Tallinn powered by OlyBet at Olympic Park Casino and the Hilton Tallinn Park:

Matte Karjalainen Eliminated in 8th Place (€7,200) Posted Wednesday 28th February, 2024 at 16:50(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 7/700

Matte Karjalainen shipped his 1,100,000 stack in from the small blind and was quickly called by Andrius Bielskis in the big blind.

Matte Karjalainen:
Andrius Bielskis:

Karjalainen took the lead on the flop, but it turned out to be a deception as the turn saw Bielskis hit a better pair.

The river did nothing for either player and Karjalainen took his exit in 8th place after a rollercoaster of a final table, while Bielskis extended his chip lead to an eight-figure stack.

Player Chips Progress
Andrius Bielskis 10,000,000 1,300,000
Matte Karjalainen 0 0
Ylämäki Doubles Right Back Posted Wednesday 28th February, 2024 at 16:46(UTC+2) by Frank Visser

Level 31: 75,000/150,000 (150,000)
Entries: 8/700

Mikko Ylämäki pushed his final 550,000 chips in from the cutoff and was looked up by Aleksandrs Krumins on the button.

Mikko Ylämäki:
Aleksandrs Krumins:

Ylämäki would not lose two flips in a row as the board saw his tens hold up for the win. He raked in a double-up of his own as the short stacks ended up very close in the counts.

Player Chips Progress
Aleksandrs Krumins 1,700,000 800,000
Mikko Ylamaki 1,500,000 950,000
16:42 (UTC+2)
Start of Level 31
Blinds: 75,000/150,000     Ante: 150,000
Baixas' Turn to Double Up Posted Wednesday 28th February, 2024 at 16:41(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Jordi Baixas raised to 500,000 as first to act and the action folded to Mikko Ylämäki in the small blind, who pushed all in for 1,200,000.

Baixas made the call with a smaller stack of 725,000 and the cards were turned over.

Jordi Baixas:
Mikko Ylämäki:

The paired up Baixas to take the lead in the flop, while the turn upgraded him to trips. Ylämäki could not hit a full house on the river and Baixas doubled up, leaving Ylämäki as the shortest stack on the table.

Player Chips Progress
Jordi Baixas 1,700,000 975,000
Mikko Ylamaki 550,000 2,050,000
Berndtson Chips Up Posted Wednesday 28th February, 2024 at 16:37(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Alekandrs Krumins made a raise to 250,000 from early position with . Chipleader Andrius Bielskis thought for a while on the button before flicking in a call with , and big blind Touko Berndtson came along in the big blind as well, with .

The flop saw Berndtson check before Krumins continued for 175,000, which got Bielskis to fold quickly. Berndtson, however, shipped all of his 1,400,000 chips in the middle.

Krumins weighed his options for a bit before electing to make the correct fold, and Berndtson was awarded some much-valued chips.

Player Chips Progress
Andrius Bielskis 8,700,000 1,000,000
Touko Berndtson 2,500,000 290,000
Aleksandrs Krumins 2,500,000 700,000
Karjalainen Doubles Versus Baixas Posted Wednesday 28th February, 2024 at 16:30(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Jordi Baixas raised to 500,000 from the cutoff before Matte Karjalainen went all in for 575,000 in the small blind. The action folded back to Baixas, who put in the few extra chips for a call.

Matte Karjalainen:
Jordi Baixas:

Karjalainen was the only one to pair his kicker on the board, resulting in his double-up and leaving Baixas with just a few big blinds.

Player Chips Progress
Matte Karjalainen 1,400,000 0
Jordi Baixas 725,000 575,000
Helin Gets to Squeeze Posted Wednesday 28th February, 2024 at 16:25(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Andrius Bielskis looked down at in early position and raised to 250,000. Aleksandrs Krumins made the call on the button with before Joonas Helin jammed all in for 2,600,000 from the big blind with .

Bielskis pondered his options for a while before letting his cards go, while Krumins was quicker with his decision and snap folded to forfeit the pot to Helin.

Player Chips Progress
Andrius Bielskis 7,700,000 200,000
Joonas Helin 3,300,000 600,000
Aleksandrs Krumins 3,200,000 200,000
Bielskis Puts New-Found Chips to Use Posted Wednesday 28th February, 2024 at 16:21(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Andrius Bielskis open-jammed his big stack from the cutoff with and Oscar Peleg was on the button with .

He thought about it for a bit before eventually folding, and the blinds quickly followed suit to add some more chips to Bielskis' stack.

Player Chips Progress
Andrius Bielskis 7,900,000 200,000
Oscar Peleg 1,200,000 300,000
Bielskis Grabs Chip Lead in Huge Cooler Posted Wednesday 28th February, 2024 at 16:13(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Aleksandrs Krumins made it 275,000 to go from the hijack with , after which the action folded to Andrius Bielskis in the big blind, who found .

Bielskis made it 900,000 to go and Krumins just made the call, whereafter the flop was dealt. Bielskis continued for 525,000 and once again Krumins just flatted.

The turn was checked by both players before Bielskis jammed all in for 2,300,000 on the river.  Krumins asked for a count and sat in the tank for a bit before making the call.

Bielskis tabled his full house for the win, while Krumins' Big Slick disappeared into the muck. Bielskis doubled up to just under eight million chips and nabbed the chip lead by doing so.

Player Chips Progress
Andrius Bielskis 7,700,000 3,600,000
Aleksandrs Krumins 3,400,000 2,500,000
Baixas Tries to Steal Posted Wednesday 28th February, 2024 at 16:08(UTC+2) by Frank Visser

Level 30: 50,000/125,000 (125,000)
Entries: 8/700

Jordi Baixas raised to 300,000 on the button with . Joonas Helin was in the small blind with and put Baixas all in for his stack of 1,600,000.

Baixas quickly mucked his cards and surrendered some of his precious chips to Helin.

Player Chips Progress
Joonas Helin 2,700,000 0
Jordi Baixas 1,300,000 300,000
16:00 (UTC+2)
Start of Level 30
Blinds: 50,000/125,000     Ante: 120,000
A Small Break Posted Wednesday 28th February, 2024 at 15:39(UTC+2) by Frank Visser

Level 29: 50,000/100,000 (100,000)
Entries: 8/700

The eight remaining players have been sent on a 20-minute break after the first few hands of the final table.

Knut Trulsen Eliminated in 9th Place (€5,890) Posted Wednesday 28th February, 2024 at 15:29(UTC+2) by Frank Visser

Level 29: 50,000/100,000 (100,000)
Entries: 8/700

Joonas Helin raised to 200,000 under the gun before the action folded to Knut Trulsen on the button. He went all in for 945,000 chips, which Helin covered as he made the call.

Knut Trulsen:
Joonas Helin:

Helin's superior pocket pair faced no resistance on the runout and Trulsen was the first player eliminated from the final table.

Player Chips Progress
Joonas Helin 2,700,000 1,200,000
Knut Trulsen 0 0
Krumins Goes For It All Posted Wednesday 28th February, 2024 at 15:27(UTC+2) by Frank Visser

Level 29: 50,000/100,000 (100,000)
Entries: 9/700

Mikko Ylämäki raised to 200,000 from the cutoff with  and Aleksandrs Krumins made the call on the button with . Both of the blinds got out of the way and a flop of was spread.

Ylämäki checked to Kumins, who made a bet of 225,000 with his full house. Ylämäki called with his pair of sixes and did so too when Krumins sized up to 450,000 on the turn.

The river then completed the board and Krumins announced "all-in" after another check from Ylämäki. Ylämäki thought about it for a bit but ultimately folded, saving his 1,800,000 chips for another pot.

Player Chips Progress
Aleksandrs Krumins 7,000,000 1,100,000
Mikko Ylamaki 1,800,000 800,000
Aces for Krumins Posted Wednesday 28th February, 2024 at 15:25(UTC+2) by Frank Visser

Level 29: 50,000/100,000 (100,000)
Entries: 9/700

Joonas Helin raised to 200,000 from early position with  and Mikko Ylamaki came along from the button with

Aleksandrs Krumins then put in a three-bet to 650,000 from the big blind with , which caused the other two players to fold their holdings.

Player Chips Progress
Aleksandrs Krumins 5,900,000 985,000
Mikko Ylamaki 2,600,000 45,000
Joonas Helin 1,500,000 200,000
Peleg Also Books Double-Up Posted Wednesday 28th February, 2024 at 15:21(UTC+2) by Frank Visser

Level 29: 50,000/100,000 (100,000)
Entries: 9/700

Jordi Baixas raised to 200,000 from early position before Oscar Peleg shoved 610,000 chips in from the button. Baixas asked for a count before putting in the extra chips for a call.

Oscar Peleg:
Jordi Baixas:

Peleg flopped top pair on , but it also saw Baixas flop an open-ended straight draw.

However, the runout bricked out for Baixas, seeing his opponent double up.

Player Chips Progress
Oscar Peleg 1,500,000 365,000
Jordi Baixas 1,000,000 640,000
Karjalianen Doubles Up First Hand Posted Wednesday 28th February, 2024 at 15:14(UTC+2) by Frank Visser

Level 29: 50,000/100,000 (100,000)
Entries: 9/700

Matte Karjalainen jammed all in from the small blind for 645,000 and was called by Andrius Bielskis in the big blind.

Matte Karjalainen:
Andrius Bielskis:

The board ran out and Karjalainen's better hand made a pair to secure the double-up.

Player Chips Progress
Andrius Bielskis 4,100,000 770,000
Matte Karjalainen 1,400,000 755,000
Final Table Underway Posted Wednesday 28th February, 2024 at 15:08(UTC+2) by Frank Visser

The nine remaining players have taken their seats and the cards are in the air.

Stay tuned for all the action of the final table of the €555 Kings of Tallinn Championship.

Final Table Seat Draw and Chip Counts Posted Wednesday 28th February, 2024 at 14:24(UTC+2) by Jason Glatzer
Seat Player Country Chips Big Blinds
1 Aleksandrs Krumins Latvia 4,915,000 49
2 Jordi Baixas Spain 1,640,000 16
3 Joonas Helin Finland 1,700,000 17
4 Matte Karjalainen Finland 645,000 6
5 Andrius Bielskis Lithuania 4,870,000 49
6 Oscar Peleg Sweden  1,135,000 11
7 Touko Berndtson FInland 2,210,000 22
8 Mikko Ylämäki Finland 2,645,000 26
9 Knut Trulsen Norway 1,195,000 12
Player Chips Progress
Aleksandrs Krumins 4,915,000 15,000
Andrius Bielskis 4,870,000 430,000
Mikko Ylamaki 2,645,000 105,000
Touko Berndtson 2,210,000 90,000
Joonas Helin 1,700,000 600,000
Jordi Baixas 1,640,000 40,000
Knut Trulsen 1,195,000 310,000
Oscar Peleg 1,135,000 2,145,000
Matte Karjalainen 645,000 575,000
Konsta Heikkila Eliminated in 10th Place (€4,700) Posted Wednesday 28th February, 2024 at 14:17(UTC+2) by Jason Glatzer

Level 29: 50,000/100,000 (100,000)
Entries: 9/700

Konsta Heikkila four-bet jammed around a dozen big blinds from middle position and was called by Aleksandrs Krumins.

Konsta Heikkila:
Aleksandrs Krumins:

It was a bit of a cooler to run jacks into queens during five-handed play but poker can be cruel. Heikkila bubbled the final table while earning the 10th place prize of €4,700 after the board didn't save him.

We will post the final table seat draw in a few minutes. Players are on a short break before they will hit the lights and cameras for the live-streamed final table at OlyBet.tv. Our coverage will be on the same 30-minute delay as the stream but we will be with you until a winner is crowned.

Player Chips Progress
Aleksandrs Krumins 4,900,000 3,165,000
Konsta Heikkil? 0 0
Svetozar Marinov Eliminated in 11th Place (€4,700) Posted Wednesday 28th February, 2024 at 14:14(UTC+2) by Jason Glatzer

Level 29: 50,000/100,000 (100,000)
Entries: 10/700

It was a heck of a run and almost a true comeback for Bulgaria's Svetozar Marinov. But sometimes good things come to an end.

Andrius Bielskis jammed from the small blind before Marinov called off his stack of around 10 big blinds from the big blind.

Svetozar Marinov:
Andrius Bielskis:

Bielskis connected with his jack straight off the bat and never looked back to eliminate Marinov in 11th place for €4,700 after the ran out on the board.

There was another pot brewing at the same time at the other table. Spoiler alert! We reached a final table moments after this hand.

Player Chips Progress
Andrius Bielskis 4,900,000 2,300,000
Svetozar Marinov 0 0
Cinderella Story for Marinov? Posted Wednesday 28th February, 2024 at 14:04(UTC+2) by Jason Glatzer

Level 29: 50,000/100,000 (100,000)
Entries: 11/700

Svetozar Marinov was down to just 40,000 in chips and now has a seven-figure stack. He doubled again, this time against Touko Berndtson when his king-four held against jack-trey.

Is this a Cinderella story in the making? Time will tell with the final table to begin quite soon with a few players short on chips.

Player Chips Progress
Touko Berndtson 2,300,000 760,000
Svetozar Marinov 1,000,000 720,000
14:00 (UTC+2)
Start of Level 29
Blinds: 50,000/100,000     Ante: 100,000
Baixas Leaves Marinov on Fumes Posted Wednesday 28th February, 2024 at 14:00(UTC+2) by Jason Glatzer

Level 28: 40,000/80,000 (80,000)
Entries: 11/700

Andrius Bielskis min-raised from under the gun before Svetozar Marinov jammed for 750,000 from the button. Jordi Baixas (pictured below) called off his stack of 710,000 before Bielskis folded.

Jordi Baixas:
Svetozar Marinov:

Baixas's jacks held and even improved to a full house on the board to leave Marinov with just 40,000 in the stack.

Marinov got his 40,000 in from the cutoff. Marinov raised to 200,000 from the button and the players in the blinds folded.

Svetozar Marinov:
Jordi Baixas:

Marinov won the flop after Baixas failed to connect with the runout.

Player Chips Progress
Jordi Baixas 1,600,000 410,000
Svetozar Marinov 280,000 1,720,000
Action Slowed Down Posted Wednesday 28th February, 2024 at 13:46(UTC+2) by Jason Glatzer

Level 28: 40,000/80,000 (80,000)
Entries: 11/700

There have been nearly no flops during Level 28 as players tighten up with the final table just two players. 

13:18 (UTC+2)
Start of Level 28
Blinds: 40,000/80,000     Ante: 80,000
Jan-Mikael Kesanen Eliminated in 12th Place (€3,600) Posted Wednesday 28th February, 2024 at 13:18(UTC+2) by Jason Glatzer

Level 27: 30,000/60,000 (60,000)
Entries: 11/700

Finland's Jan-Mikael Kesanen bet 360,000 from under the gun leaving just 5,000 in chips in his stack. He was called by Svetozar Marinov before the remaining 5,000 went in on the flop.

Jan-Mikael Kesanen:
Svetozar Marinov:

Kesanen was understandably not thrilled about falling far behind in what was a flip situation and was eliminated in 12th place for €3,600 after the turn and river completed the board.

Player Chips Progress
Svetozar Marinov 2,000,000 260,000
Jan-Mikael Kesanen 0 0
Adrians Imsa Eliminated in 13th Place (€3,600) Posted Wednesday 28th February, 2024 at 12:57(UTC+2) by Jason Glatzer

Level 27: 30,000/60,000 (60,000)
Entries: 12/700

Adrians Imsa was the first player to hit the rail on the final day. He jammed his short stack of approximately 10 big blinds from late position and was called by the red-hot Joonas Helin from the big blind.

Adrians Imsa:
Joonas Helin:

The snowmen held on the runout to send Imsa to the rail in 13th place for €3,600. Meanwhile, Helin, who began the day as a short stack, now has one of the bigger stacks in the field.

Player Chips Progress
Joonas Helin 2,300,000 1,000,000
Adrians Imsa 0 0
Helin Doubles Through Bielskis Posted Wednesday 28th February, 2024 at 12:41(UTC+2) by Jason Glatzer

Level 27: 30,000/60,000 (60,000)
Entries: 13/700

Andrius Bielskis min-raised from under the gun before Joonas Helin three-bet jammed for about 10 big blinds from the big blind. Bielskis snap-called and Helin wished his opponent good luck.

Joonas Helin:
Andrius Bielskis:

It was Helin who had the good luck as he connected with his queen on the runout to double through Bielskis instead of hitting the rail.

Player Chips Progress
Andrius Bielskis 2,600,000 700,000
Joonas Helin 1,300,000 645,000
Cards in the AIr Posted Wednesday 28th February, 2024 at 12:29(UTC+2) by Jason Glatzer

Level 27: 30,000/60,000 (60,000)
Entries: 13/700

Cards are in the air to start the final day of the €555 Championship. We will report the action in real-time until the live-streamed final table is reached.

12:26 (UTC+2)
Day 3 of Kings of Tallinn 2024 Started
Level: 27     Blinds: 30,000/60,000     Ante: 60,000
Record-Breaking Field Sees 13 Return for Final Day of €555 Championship Posted Wednesday 28th February, 2024 at 11:35(UTC+2) by Frank Visser

Throughout four starting flights, and some additional entries on Day 2, a whopping 700 entries have been made in the Kings of Tallinn €555 Championship. This number absolutely shattered the previous record of 573 entries and created an eye-watering prize pool of €329,000.

The field was set to play down to a final table, but after an arduous battle on Day 2, 13 players were still standing as they bagged up for the finale. Lithuania's Andrius Bielskis leads them with 3,300,000 chips, although he is virtually tied with his nearest contender Oscar Peleg from Sweden, who will start today with 3,280,000 chips.  

Both players will bring roughly 55 big blinds into Day 3, a big lead over Bulgaria's Svetozar Marinov, who sits in third with almost half of that with 1,740,000 chips. Meanwhile, Finnish players Joonas Helin and Jan-Mikael Kesänen find themselves at risk of missing the final table, sitting down with 655,000 and 665,000 chips respectively, just 11 big blinds.

Start of Day 3 Chip Counts

Rank Player Country Chip Count Big Blinds
1 Andrius Bielskis Lithuania 3,300,000 55
2 Oscar Peleg Sweden 3,280,000 55
3 Svetozar Marinov Bulgaria 1,740,000 29
4 Aleksandrs Krumins Latvia 1,735,000 29
5 Touko Berndtson Finland 1,540,000 26
6 Knut Trulsen Norway 1,505,000 25
7 Matte Karjalainen Finalnd 1,220,000 20
8 Jordi Baixas Spain 1,190,000 20
9 Mikko Ylämäki Finland 935,000 16
10 Konsta Heikkilä Finland 925,000 15
11 Adrians Imsa Latvia 710,000 12
12 Jan-Mikael Kesänen Finland 665,000 11
13 Joonas Helin Finland 655,000 11

All returning players are guaranteed €3,600, but everyone will be hunting the €65,360 that comes with winning the tournament. When they return, they will start with blinds at 30,000/60,000 with a 60,000 big blind ante. Blind levels will be 40 minutes in length throughout the remainder of the tournament, and enough of them will be played for a champion to be crowned.

With the late finish of Day 2, Day 3 will start at 12:30 p.m. local time, with OlyBet.tv providing cards-up coverage from 1 p.m. onwards, on half an hour delay. The live reporting will commence at the same time to not spoil anything from the live stream, so check back in at that time to not miss any of the poker action from the Estonian capital.

Final Day Seating Assignments Posted Wednesday 28th February, 2024 at 02:59(UTC+2) by Jason Glatzer
Table Seat Player Chips Big Blinds
1 1 Jan-Mikael Kesänen 665,000 11
1 3 Adrians Imsa 710,000 12
1 4 Svetozar Marinov 1,740,000 29
1 5 Jordi Baixas 1,190,000 20
1 6 Joonas Helin 655,000 11
1 8 Andrius Bielskis 3,300,000 55
2 1 Konsta Heikkilä 925,000 15
2 2 Touko Berndtson 1,540,000 26
2 3 Knut Trulsen 1,505,000 25
2 4 Aleksandrs Krumins 1,735,000 29
2 5 Matte Karjalainen 1,220,000 20
2 6 Itai Peleg 3,280,000 55
2 8 Mikko Ylämäki 935,000 16

Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.