0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0110 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-26' AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event-fi/2/updates' ORDER BY `views` DESC

0.0021 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event-fi/2/updates', 1, '2024-04-26')

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.0003 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.0006 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0005 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.0003 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.0010 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.0118 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` = 'kings-of-tallinn-2023-main-event-fi'

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

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

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

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

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

0.0309 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0047 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '58' AND `published` = 1

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

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

0.0099 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '56' 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` = '56' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '2450' 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` = '2449' 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` = '2446' 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` = '2445' 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` = '2442' 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` = '2441' 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` = '2437' 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` = '2435' 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` = '2434' 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` = '2433' 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` = '2431' 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` = '2427' 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` = '2426' 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` = '2425' 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` = '2421' 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` = '2420' 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` = '2418' 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` = '2415' 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` = '2411' 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` = '2407' 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` = '2406' 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` = '2403' 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` = '2402' 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` = '2398' 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` = '2397' 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` = '2396' 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` = '2394' 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` = '2389' 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` = '2388' 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` = '2387' 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` = '2385' 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` = '2384' 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` = '2382' 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` = '2380' 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` = '2379' 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` = '2375' 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` = '2374' 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` = '2372' 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` = '2370' 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` = '2369' 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` = '2368' 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` = '2366' 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` = '2364' 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` = '2359' 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` = '2357' 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` = '2356' 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` = '2355' 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` = '2353' 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` = '2352' 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` = '2348' 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` = '2346' 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` = '2345' 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` = '2343' 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` = '2342' 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` = '2341' 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` = '2340' 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` = '2339' 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` = '2335' 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` = '2334' 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` = '53' 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` = '56' ORDER BY `busted` ASC, `current_chips` DESC

0.0066 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` = '56' 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` = '2450' 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` = '2449' 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` = '2446' 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` = '2445' 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` = '2442' 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` = '2441' 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` = '2437' 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` = '2435' 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` = '2434' 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` = '2433' 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` = '2431' 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` = '2427' 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` = '2426' 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` = '2425' 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` = '2421' 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` = '2420' 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` = '2418' 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` = '2415' 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` = '2411' 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` = '2407' 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` = '2406' 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` = '2403' 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` = '2402' 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` = '2398' 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` = '2397' 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` = '2396' 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` = '2394' 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` = '2389' 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` = '2388' 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` = '2387' 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` = '2385' 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` = '2384' 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` = '2382' 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` = '2380' 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` = '2379' 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` = '2375' 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` = '2374' 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` = '2372' 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` = '2370' 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` = '2369' 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` = '2368' 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` = '2366' 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` = '2364' 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` = '2359' 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` = '2357' 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` = '2356' 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` = '2355' 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` = '2353' 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` = '2352' 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` = '2348' 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` = '2346' 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` = '2345' 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` = '2343' 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` = '2342' 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` = '2341' 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` = '2340' 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` = '2339' 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` = '2335' 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` = '2334' 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` = '60' ORDER BY `busted` ASC, `current_chips` DESC

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

English
King of Tallinn 2023 2023 Kings Of Tallinn €1,100 Main Event (Finnish) Live Reporting - Day 4

Current Level 35 Current Day 4
Blinds 175,000/350,000 Ante 350000
Entries 716 Remaining 1
Prize Pool (EUR) €673,040 First Prize (EUR) €140,100
1 New Update - Click to refresh
Live Updates - Day 2
Huomisen istumajärjestys Posted Saturday 4th March, 2023 at 00:42(UTC+2) by Juhani Tyriseva

              1                1    Kasparas Klezys    534,000    89
                 1                     2    Gints Ozols    130,000    22
                 1                     3    Tomas Kirchovas    180,000    
                 1                     4    Antti Veteläinen 20,000    53
                 1                     5    Rokas Barzdzius    148,000    25
                 1                     6    Aleksi Naski    366,000    61
                 1                     7    Martynas Racinskas 69,000 12
                 1                     8    Toni Ylitervo    219,000    37
                  
                 2                     1    Miko Miettinen    261,000    44
                 2                     2    Priit Parmasto    547,000    91
                 2                     3    Adomas Juozapavicius174,000
                 2                     4    Luigi Shehadeh    118,000    20
                 2                     5    Theophile George 260,000 43
                 2                     6    Nemo Vilpponen    221,000   37
                 2                     7    Richard Koppel    76,000    13
                  
                 3                     1    Albert Ostrovskij 192,000 32
                 3                     2    Grigorijus Vasilavicius   49,000                  3                     4    Davide Muccini    313,000    52
                 3                     5    Linus Lauermann    184,000  31
                 3                     6   MichailasMiserkejevas242,000
                 3                     7    Sergejs Korobovs 505,000 84
                 3                     8    Juhana Konttinen 96,000    16
                  
                 4                     1    Jari Mähönen 98,000    16
                 4                     2    Gytis Bernatavicius 142,000
                 4                     3    Steven Tool    93,000    16
                 4                     4    Aleksandr Kuperman 89,000
                 4                     5    Anna-Mari Hursti 129,000 22
                 4                     6    Vladimir Iljunin 52,000    9
                 4                     7    Gintaras Naglius 135,000 23
                 4                     8    Saulius Tumosa    73,000    12
                  
                 5                     1    Juri Vassin    185,000    31
                 5                     2    Seppo Parkkinen    72,000    12
                 5                     3    Giada Fang    153,000    26
                 5                     4    Roope Holma    358,000    60
                 5                     5    Albert Jonsson    122,000    20
                 5                     6    Marco Regonaschi 96,000    16
                 5                     7    Vu Vuong    286,000    48
                 5                     8    Keito Kaljulaid    114,000    19
                  
                 6                     1    Kai Lehto    116,000    19
                 6                     2    Anatoly Filatov    228,000    38
                 6                     3    Anthony Kauzloric 281,000 47
                 6                     4    Julius Tiihonen    241,000    40
                 6                     5    Daragh Davey    60,000    10
                 6                     6    Dmitrijs Arsuns    146,000    24
                 6                     7    Petteri Laiho    182,000    30
                 6                     8    Francisco  Racionero 172,000
                  
                 7                     1    Mikael  Niemelä    379,000    63
                 7                     2    Jani Tuovinen    262,000    44
                 7                     3    Carl Gustafsson    70,000    12
                 7                     4    Justas Vaiciulionis 46,000 8
                 7                     5    Hanno Kerem    156,000    26
                 7                     6    Mika Levaniemi    591,000    99
                 7                     7    Joni Rantamäki    91,000    15
                 7                     8    Algirdas Saveikis 132,000 22
                  
                 8                     1    Niki Nurmisto    433,000    72
                 8                     2    Arto Mansner 136,000    23
                 8                     3    Artiom Goncarenko 115,000
                 8                     4    Adria  Roura 331,000    55
                 8                     5    Luca Sebastiani    142,000    24
                 8                     7    Janne Nevalainen 270,000 45
                 8                     8    Oskars Gailums    502,000    84
                  
                 9                     1    Airin Pindis 71,000 12
                 9                     2    Ranno Sootla 614,000    102
                 9                     3    Federico Cirillo 512,000 85
                 9                     4    Ignas Vaitulionis 256,000 43
                 9                     5    Verneri Häkkinen 197,000 33
                 9                     6    Martin Piik    175,000    29
                 9                     7    Magnus Pukk    290,000    48
                 9                     8    Taago Tamm    291,000    49
                  
               10                     1    Victor  Garcia    23,000    37
               10                     2    Arminas Nemeika    215,000
               10                     3    Ignacio Garrido 208,000    35
               10                     4    Deniss Davõdov    81,000    14
               10                     5    Yanis Mehdi Sahli 452,000 75
               10                     6    Mart Kalju    88,000    15
               10                     7    Irmantas Bzeskis 149,000 25
               10                     8    Pavels Spirins    868,000    145
                  
               11                     1    Jon Ander Martinez 92,000 15
               11                     2    Javier Guinot Moya 427,000
               11                     3    Mairo Tori    103,000    17
               11                     4    Leonardo Romeo    320,000 53
               11                     5    Sebastian Wahl    181,000    30
               11                     6    Eirik Kristiansen 192,000 32
               11                     7    Jari-Pekka Juhola 47,900 8
               11                     8    Walter Treccarichi 122,000 20
                  
               12                     1    Lari Pukkila    372,000    62
               12                     2    Paul Koppe    845,000    141
               12                     3    Tomas Pinkevicius 25,000 4
               12                     4    Roberts Rumba    136,000    23
               12                     5    Dainius Antanaitis 206,000 34
               12                     6    Lukas Bytautas    178,000    30
               12                     7    Mohammed Al-Khaz. 362,000 
               12                     8    Paulius Vaitiekunas 269,000

Chip count päivän päättyessä Posted Saturday 4th March, 2023 at 00:17(UTC+2) by Juhani Tyriseva

Pelaaja Chipit Isot blindit: 


Pavels Spirins    868,000    145
Paul Koppe    845,000    141
Ranno Sootla    614,000    102
Mika  Levaniemi    591,000    99
Priit Parmasto    547,000    91
Kasparas Klezys    534,000    89
Federico Luciano Cirillo    512,000    85
Sergejs Korobovs    505,000    84
Oskars Gailums    502,000    84
Yanis Mehdi Sahli    452,000    75
Niki  Nurmisto    433,000    72
Javier Guinot Moya    427,000    71
Mikael Niemelä    379,000    63
Lari  Pukkila    372,000    62
Aleksi Naski    366,000    61
Mohammed  Al-Khazraji    362,000    60
Roope Holma    358,000    60
Adria Comas I Roura    331,000    55
Leonardo Romeo    320,000    53
Antti  Veteläinen    320,000    53
Davide Muccini    313,000    52
Taago Tamm    291,000    49
Magnus Pukk    290,000    48
Vu Hoang Vuong    286,000    48
Anthony Jay Kauzloric    281,000    47
Janne Nevalainen    270,000    45
Paulius Vaitiekunas    269,000    45
Jani  Tuovinen    262,000    44
Miko  Miettinen    261,000    44
Theophile Tristan George    260,000    43
Ignas Vaitulionis    256,000    43
Michailas Miserkejevas    242,000    40
Julius  Tiihonen    241,000    40
Anatoly Filatov    228,000    38
Victor Fernandez Garcia    223,000    37
Nemo  Vilpponen    221,000    37
Toni  Ylitervo    219,000    37
Arminas Nemeika    215,000    36
Ignacio Gonzalez Garrido    208,000    35
Dainius Antanaitis    206,000    34
Verneri  Häkkinen    197,000    33
Eirik Kristiansen    192,000    32
Albert Ostrovskij    192,000    32
Juri Vassin    185,000    31
Linus Hans Ludwig Lauermann    184,000    31
Petteri Laiho    182,000    30
Sebastian Wahl    181,000    30
Tomas Kirchovas    180,000    30
Lukas Bytautas    178,000    30
Martin Piik    175,000    29
Adomas Juozapavicius    174,000    29
Francisco Jose Blanco Racionero    172,000    29
Hanno Kerem    156,000    26
Giada Fang    153,000    26
Irmantas Bzeskis    149,000    25
Grigorijus Vasilavicius    149,000    25
Rokas Barzdzius    148,000    25
Dmitrijs Arsuns    146,000    24
Gytis Bernatavicius    142,000    24
Luca Sebastiani    142,000    24
Arto Mansner    136,000    23
Roberts Rumba    136,000    23
Gintaras Naglius    135,000    23
Algirdas Saveikis    132,000    22
Gints Ozols    130,000    22
Anna-Mari Hursti    129,000    22
Albert L. E. Jonsson    122,000    20
Walter Treccarichi    122,000    20
Luigi Andrea Shehadeh    118,000    20
Kai  Lehto    116,000    19
Artiom Goncarenko    115,000    19
Keito Kaljulaid    114,000    19
Mairo Tori    103,000    17
Jari  Mähönen    98,000    16
Juhana Konttinen    96,000    16
Marco Regonaschi    96,000    16
Steven Tool    93,000    16
Jon Ander Martinez    92,000    15
Joni Rantamäki    91,000    15
Aleksandr Kuperman    89,000    15
Mart Kalju    88,000    15
Deniss Davõdov    81,000    14
Richard Koppel    76,000    13
Saulius Tumosa    73,000    12
Seppo Parkkinen    72,000    12
Airin Pindis    71,000    12
Carl Henrik Gustafsson    70,000    12
Martynas Racinskas    69,000    12
Daragh Davey    60,000    10
Vladimir Iljunin    52,000    9
Jari-Pekka Juhola    47,900    8
Justas Vaiciulionis    46,000    8
Tomas Pinkevicius    25,000    4

Merkit menivät pussiin Posted Friday 3rd March, 2023 at 21:21(UTC+2) by Juhani Tyriseva

93 pelaajaa jatkaa huomiseen. 

Chip count toimituksen illallistauon jälkeen noin klo 23.00. 

Illan viimeiset käyntiin Posted Friday 3rd March, 2023 at 21:12(UTC+2) by Juhani Tyriseva

Kello on pysäytetty, ja nyt pelataan illan viimeiset hitaat. Seppo Parkkinen sai kunnian vetää kortin ja vetäisi kolmosen, kolme kättä siis. 

Koska ollaan erittäin lähellä bubble turnausjohto päätti että nämä kädet pelataan hand by hand. Harvinaista, mutta tällä kertaa perusteltua, mahdolliset putoamiset  tapahtuvat reilussa järjestyksessä ja kenenkään ei kannata stallata. 

Alle sadan on päästy Posted Friday 3rd March, 2023 at 20:47(UTC+2) by Juhani Tyriseva

Päivän viimeiselle tasolle on päästy. Nyt pelaajia on jäljellä 99 kappaletta. 

Kun rahaa on tarjolla 87 parhaalle, näyttää siltä, että bubble puhkeaa vasta huomenna. 

Pudonneita suomalaisia:

  • Osku Karttunen
  • Pasi Sormunen
20:43 (UTC+2)
Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000
Oskun flippi päättyi tappioon Posted Friday 3rd March, 2023 at 20:23(UTC+2) by Juhani Tyriseva

Osku Karttunen ja vihu menivät all in ennen floppia. 

Osku

Vihu

Floppi

Turn

River ja vihun floppaama ässäpari oli vahva, joten Oskun pelit päättyivät. 

Rivit harvenevat Posted Friday 3rd March, 2023 at 20:15(UTC+2) by Juhani Tyriseva

Pudonneita suomalaisia: 

  • Max Rotko
  • Ville Jantunen
  • Tommi Lankinen
  • Mikko Ylämäki 
  • Matias Knaapinen
  • Timo Lämsä
  • Pekka Ikonen
Meni sentään suomalaiselle Posted Friday 3rd March, 2023 at 20:13(UTC+2) by Juhani Tyriseva

"Ei ole paljoa kerrottavaa. Pienellä pinolla sinnittelin, ja loput merkit menivät Pasi Sormuselle kun mun ei päässyt ohi Pasin kädestä", kertoi Mikko Ylämäki. 

Täyskäsi voittaa värin Posted Friday 3rd March, 2023 at 20:11(UTC+2) by Juhani Tyriseva

Mohammed Al-Khazraji ja vihu. 

Turnissa pöydässä oli: 

sököteltiin. 

River

Vihu meni all in etupositiosta, Mohammed miettimään. Pitkä mietintä ja maksu. 

Vihu näytti värin. 

Mohammed käänsi näkyviin täyskäden. Mohammedilla nyt noin 450K. 

Blindien väliset ovat mielenkiintoisia Posted Friday 3rd March, 2023 at 20:00(UTC+2) by Juhani Tyriseva

Julius Tiihonen (sb) ja Ranno Sootla (bb) ottivat blindien välisen ottelun. 

Riverissä pöydässä oli: 

Julius löi 50K, Ranno miettimään, maksu. 

Julius näytti

Ranno huokasi ja kippasi. Aika selvää on, että Rannolla oli tässä jaossa ässä kiinni. 

19:07 (UTC+2)
Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000
Tauolle mars, mars! Posted Friday 3rd March, 2023 at 19:07(UTC+2) by Juhani Tyriseva

Kuusi tasoa on nyt pelattu, ja pidetään pikku tauko. 

Tauon jälkeen uusi taso bb ante 4K, blindit 2K/4K. 

129/716 pelaajaa vielä mukana. 

Suomalaisia pudonneita: 

  • Mathias Siljander
  • Jari Kärkkäinen
  • Joni Lankinen
  • Pekka Virtanen
  • Aki Pyysing
  • Raimo Ahola
  • Kasper Mellanen
Akin kunkut eivät riittäneet Posted Friday 3rd March, 2023 at 19:02(UTC+2) by Juhani Tyriseva

Reissatussa potissa Aki Pyysing ja Marco Regonaschi (positiossa). 

Floppi Aki löi, maksu.

Turn Aki löi, maksu. 

River Aki meni all in, maksu. 

Aki näytti

Marco näytti ässäparin ja vei Akin merkit. 

Tämähän meni siinä mielessä jännästi, että päivällä Akin naulat voittivat Teemu Toikkasen kunkut. Nyt kävi Akin kannalta päinvastoin; hänellä oli kunkut ja vihulla naulat. Lopputulos oli molemmilla kerroilla sama, naulat olivat kunkkuja paremmat. 

Väki vähenee tasaisesti Posted Friday 3rd March, 2023 at 18:26(UTC+2) by Juhani Tyriseva

Pudonneita suomalaisia: 

  • Ilari Sahamies
  • Miko Ylikoski
  • Eero Lehtinen
  • Lasse Enojärvi
  • Toivo Rinne
  • Elias Vääräniemi
  • Niklas Vakkuri 
  • Lasse Aarninsalo 
  • Tuomo Niemelä 

146/716 pelaajaa juuri nyt.

18:23 (UTC+2)
Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000
Nyt paljon suomalaisia streamissa, Henri Kasper myös mukana Posted Friday 3rd March, 2023 at 18:16(UTC+2) by Juhani Tyriseva

Tällä hetkellä live streamissa pelaa peräti viisi suomalaista: 

  • Anna-Mari Hursti 
  • Marko Levaniemi
  • Ilari Sahamies
  • Toivo Rinne 
  • Tuomo Niemelä

Vastassa on tuore EPT-viitonen Henri Kasper, jonka suosio Viron pokeripiireissä ei ainakaan pienentynyt tuon Pariisista tuodun 317.000€ voiton myötä. 

Linkki streamiin: 

(83) Kings of Tallinn 2023 ME Day 2 - YouTube

Chip countit päivitetty, lisää pudonneita Posted Friday 3rd March, 2023 at 17:57(UTC+2) by Juhani Tyriseva

Suomalaisten chip count on hetki sitten päivitetty. Joku saattaa vielä puuttuakin, mutta koetetaan täydentää. 

Pudonneita suomalaisia: 

  • Jyrki Lampinen
  • Kristian Kostiander
  • Teemu Toikkanen
  • Touko Berndtson 
  • Tapio Aaltonen
  • Markus Ylänne
  • Frans Rytkönen
  • Teemu Kailasvuo 
  • Erno Suominen
  • Henri Schalin 
  • Petri Pääkkönen

17:10 (UTC+2)
Start of Level 13
Blinds: 1,000/2,500     Ante: 2,500
Päivä puolivälissä Posted Friday 3rd March, 2023 at 16:57(UTC+2) by Juhani Tyriseva

Neljä tasoa on nyt pelattu, ja neljä siis vielä jäljellä. 

Nyt tauolla tehdään chip race 100:n merkeistä, saadaan pöydille tilaa. Toimituskin ryhtyy pikku hiljaa suunnittelemaan päivän ensimmäistä chip countia, vaikka urakka vieläkin vähän hirvittää. 

Lisää pettyneitä Posted Friday 3rd March, 2023 at 16:43(UTC+2) by Juhani Tyriseva

Pudonneita suomalaisia: 

  • Miika Töyräs
  • Elias Suhonen
  • Jyrki Lampinen

187 pelaajaa juuri nyt. 

Kaikki vedot tuli täyteen Posted Friday 3rd March, 2023 at 16:41(UTC+2) by Juhani Tyriseva

Gert Laanemets avasi 4500, Jani Tuovinen maksoi takaa ja Andrey Koks maksoi blindistä. 

Floppi Gert löi 6K, Jani reissasi 14K total, Andrey maksoi, Gert kippasi. 

Turn sököteltiin. 

River Andrey sökötti, ja Jani sökötti nopeasti perästä. 

Andrey näytti kolmospari ja missatun suoran vedon. 

Jani käänsi näkyviin kymppiparin ja vei mukavan potin. 

Ei se väri tullut Posted Friday 3rd March, 2023 at 16:30(UTC+2) by Juhani Tyriseva

"Kasparas Klezys avasi, minä maksoin kädellä.  Yksi vihu maksoi mun takaa ja iso blindi maksoi myös. 

Floppi Kasparas löi, minä ainoana maksoin. 

Turn Kaspars löi 20K, minä päätin mennä all in 45K, Kaspars maksoi kädellään joten perässä olin. Riverin ei minua auttanut";  kertoi Anne. 

16:03 (UTC+2)
Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000
Haaveet kaatuu Posted Friday 3rd March, 2023 at 16:03(UTC+2) by Juhani Tyriseva

Vauhti on edelleen hurjaa. 

Pudonneita suomalaisia: 

  • Carl Lockmer
  • Kasperi Ilkka
  • Annie Chen 
  • Miska Vihervuori
  • Visa Kiviharju
  • Erkki Kaira 
  • Antti Tuomi
  • Juuso Lepistö 

215/716 pelaajaa juuri nyt.

Pillin koppaus kävi kalliiksi Carlille Posted Friday 3rd March, 2023 at 16:00(UTC+2) by Juhani Tyriseva

"Nyt kävi kylmät. Putosin kun flopilta vihu puski kädellään pelkillä takaovivedoilla. Minulla oli kunkku kiinni, ja maksoin. Kuinka ollakaan ässä tulla tupsahti riveriin ja minä lauluun", harmitteli Carl Lockmer. 

Pari uutta suomalaiskasvoa Posted Friday 3rd March, 2023 at 15:57(UTC+2) by Juhani Tyriseva

Mohammed Al-Khazraji. 

Lasse Aarninsalo. 

Lisää pudonneita meikäläisiä Posted Friday 3rd March, 2023 at 15:42(UTC+2) by Juhani Tyriseva

Vauhdilla edelleen mennään. 

Suomalaisia pudonneita: 

  • Julius Kettunen
  • Tomi Arponen
  • Juho Suutari
  • Juho Heiska
  • Heikki Piira 
  • Leevi Laiho
  • Santtu Leinonen 
  • Okku Granlund
  • Johan Martinsen

236/716 pelaajaa juuri nyt. 

Live stream käynnissä Posted Friday 3rd March, 2023 at 15:31(UTC+2) by Juhani Tyriseva

Alakerrassa aloitettiin live stream hetki sitten. 

Linkki: 

(83) Kings of Tallinn 2023 ME Day 2 - YouTube

Suomalaisia ei pöydässä juuri nyt ole, mutta muuten varmaan mukavaa seurattavaa on tarjolla. 

Pelaan vain ässät Posted Friday 3rd March, 2023 at 15:25(UTC+2) by Juhani Tyriseva

Julius Tiihonen oli päivän alkaessa chipleader, ja edelleen tuntuu kulkevan. 

Hetki sitten Julius avasi, Michael Ibba meni all in 25K pienestä, Julius maksoi empimättä. 

Michael

Julius

"Ässät taas", ihmetteli Michael. "Niin, ässät. En minä muita kortteja pelaakaan", virnuili Julius. "Kiitos tiedosta", vastasi Michael. 

Floppi

Turn

River ja Michaelin pelit päättyivät. 

87 pelaajaa rahoille Posted Friday 3rd March, 2023 at 15:07(UTC+2) by Juhani Tyriseva

"Prize poolia laaditaan, siinä jonkin aikaa menee", kertoi TD Teresa Nousiainen. "Se on nyt jo selvää, että 87 pelaajaa saa rahaa. Bubblessa on siis 11 kappaletta kahdeksan pelaajan pöytiä", informoi Teresa. 

Nopeita lähtöjä Posted Friday 3rd March, 2023 at 15:04(UTC+2) by Juhani Tyriseva

Kuten aina re-entryajan päätyttyä, vauhti on nyt hurjaa. Olemme menettäneet 20 pelaajaa 20 minuutissa. 

Suomalaisista ovat pudonneet: 

  • Jussi Mattila
  • Matias Arosuo
  • Jari Saviaho

255/716 pelaajaa juuri nyt. 

Muutama suomalaiskuva Posted Friday 3rd March, 2023 at 15:01(UTC+2) by Juhani Tyriseva

Roope Holma. 

Ilari Sahamies. 

Heikki Piira. 

Henri Schalin. 

Raimo Ahola. 

Lari Pukkila. 

Frans Rytkönen. 

14:49 (UTC+2)
Start of Level 11
Blinds: 800/1,600     Ante: 1,600
Nyt peli oikeasti käynnistyy Posted Friday 3rd March, 2023 at 14:48(UTC+2) by Juhani Tyriseva

Rekisteröityminen on nyt suljettu. Alustava sisäänostojen määrä on 716 kappaletta, virallista vahvistusta odotellaan.

Tunnelma salissa muuttui tauon jälkeen selvästi keskittyneemmäksi, nyt pelaajamäärä huomioiden salissa on varsin hiljaista. 

Tauolle päästiin Posted Friday 3rd March, 2023 at 14:24(UTC+2) by Juhani Tyriseva

Re-entrykädet on nyt pelattu ja tauko alkanut. 

Tällä hetkellä taululla ovat ennätyslukemat, 711 sisäänostoa. Lopulliset luvut varmistuvat kun kaikki ostot on tsekattu, uusi sisäänostojen ennätys on joka tapauksessa syntynyt. 

Jussi joutui kassalle Posted Friday 3rd March, 2023 at 14:20(UTC+2) by Juhani Tyriseva

Toiseksi viimeinen re-entrykäsi. Jussi Mattila avasi 3K cutoffista, Taago Tamm maksoi buttonista ja Juho Suutari isosta. 

Floppi Jussi löi 3K, Taago maksoi, Juho kippasi. 

Turn Jussi löi 10K, Taago meni all in, Jussi maksoi all in. 

Taago

Jussi

River ja Taagon täyskäsi lähetti Jussin kassalle re-entryn tekoon. 

Viimeiset re-entrykädet Posted Friday 3rd March, 2023 at 14:10(UTC+2) by Juhani Tyriseva

Ja nyt lähtevät käyntiin viimeiset 3 re-entrykättä. Ne pelataan, sitten pidetään tauko. Tauolla voit vielä käydä ostamassa uuden pinon, tason 11 alkaessa turnauksen rekisteröinti sulkeutuu. 

JP lähetti Svenin muihin puuhiin Posted Friday 3rd March, 2023 at 14:07(UTC+2) by Juhani Tyriseva

Reissatussa potissa JP Juhola ja Sven Reimaa. 

Turnissa pöydässä oli: 

ja merkit menivät sisään. 

JP

Sven

River ja JP:n kunkkuhai Svenin muihin hommiin. 

Tomi sai ässäparin Posted Friday 3rd March, 2023 at 13:57(UTC+2) by Juhani Tyriseva

Reissatussa potissa Tomi Lehtinen ja vihu. 

Turnissa pöydässä oli: 

Tomi ja vihu menivät all in. 

Tomi

Vihu

River ja Tomin pelit päättyivät. 

"Nämä ässät olivat ainoat mitkä koko kisassa sain", harmitteli Tomi. 

Aki oli taitava Posted Friday 3rd March, 2023 at 13:55(UTC+2) by Juhani Tyriseva

"Sain tuplat, kun olen hirveän taitava", virnuili Aki Pyysing. "Sain jaosta itselleni ässät ja Toikkasen Teemulle kallet, ja ässät kestivät", kertoi Aki. 

Teemulla ei ole oikein ollut onnea kalleparien kanssa, eilen tuli tappio, kun hän floppasi kolme kallea, ja vihu värin. Nyt siis kallet jäivät Akin ässien alle. Toivotaan Teemulle myötäisempää tuulta lopputurnaukseen. 

Uusi ennätys on syntynyt Posted Friday 3rd March, 2023 at 13:41(UTC+2) by Juhani Tyriseva

Kings of Tallinnin pääturnauksen aikaisempi ennätys sisäänostojen määrässä oli 674 sisäänostoa. Nyt kun 30 minuuttia re-entryaikaa on vielä jäljellä, turnauksessa on tehty 686 sisäänostoa. Joudutaan siis lähinnä jännittämään, tuleeko 700 sisäänostoa täyteen. Toimitus veikkaa, että tulee. 

Jussi ei saanut suoraa Posted Friday 3rd March, 2023 at 13:39(UTC+2) by Juhani Tyriseva

Jussi Mattila ja vihu reissatussa potissa. 

Floppi ja merkit menivät sisään. 

Vihu

Jussi

Turn

River ja vihun floppaama rouvapari lähetti Jussin suunnittelemaan uutta sisäänostoa. 

Terolla vaihtoehtoisia suunnitelmia Posted Friday 3rd March, 2023 at 13:18(UTC+2) by Juhani Tyriseva

"En osaa vielä sanoa mitä teen. Tämän päivän laukaus meni ensin pienellä valumisella, ja sitten kaksi puskua suittareilla takaa, ja eivät tuoneet palautusta", kertoi Tero Kilkanen. 

"Tässä on monta mahdollisuutta; pääturnaukseenkin voi vielä hypätä takaisin, tai sitten se Deepstack NLH tai 1100€ PLO, vaikea päättää", pohti Tero tulevia kuvioitaan. 

13:14 (UTC+2)
Start of Level 10
Blinds: 600/1,200     Ante: 1,200
Checkraise parifloppiin, hyvä vai paha? Posted Friday 3rd March, 2023 at 13:03(UTC+2) by Juhani Tyriseva

Max Avela ja Taago Tamm kahdestaan potissa. 

Floppi

Taago löi 1200, Max checkreissasi 5500 total, maksu. 

Turn sököteltiin. 

River sököteltiin. 

Taago näytti kuutosparin, ja Max kippasi. 

Maksunappi pohjaan Posted Friday 3rd March, 2023 at 12:56(UTC+2) by Juhani Tyriseva

"Avasin ja lämpimänä käynyt vihu 3-bettasi, maksoin. 

Floppi ja sitten aloinkin nojaamaan rauhallisesti maksunappiin. Vihu löi flopin, turnin ja all in riveriin. Maalissa kävi ilmi, että oli hänellä sentään mutta ei siinä kyllä flopin jälkeen ollut yhtään outtia voittoon (tasoihin olisi voinut päästä jos turn river olisivat olleet pakassa olleet kahdeksikot). ", kertoi Sebastian Wahl. 

Sebastianin pinossa nyt noin 150K. 

Kuvakausi alkaa hitaasti Posted Friday 3rd March, 2023 at 12:52(UTC+2) by Juhani Tyriseva

Pasi Sormunen harjoitteli jo voittajan tuolissa istumista ennen päivän alkua. 

Timo Lämsä. 

Pasilla vuoristorataa Posted Friday 3rd March, 2023 at 12:45(UTC+2) by Juhani Tyriseva

Edestä tuli avaus Oskars Gallumsilta, 3-bettasin takaa kädellä, Oskars maksoi. 

Floppi Löin 10K, maksu.

Turn löin 15K, Oskars checkreissasi 40K total, menin all in, hän maksoi all in. Oskarsilla oli joten ilman outteja katsoin riverin ja mulle jäi reilu 20K"kertoi Pasi Sormunen. 

"No sen jälkeen mun voitti vihun käden ja pääsin tähän noin 60K pinoon", kertoi Pasi. 

Shuffle Up and Deal! Posted Friday 3rd March, 2023 at 12:10(UTC+2) by Juhani Tyriseva

"Shuffle Up and Deal", ilmoitti Teresa hetki sitten. Nyt on edessä kahden tunnin reipas meno, kun pikkupinot hakevat tuplia. Jos tuplan saanti epäonnistuu, kassalta saa halutessaan lisää ammuksia. 

Päivän muut pelit Posted Friday 3rd March, 2023 at 12:08(UTC+2) by Juhani Tyriseva

Klo 13.00 NLH 220€+30€ Deepstack, Level 8

Klo 15.00 PLO 4&5 Championship, 1000€+100€, Level 8

Klo 16.30 Flip&Go yhden käden satelliitti 130€+20€ Finaali tänään klo 21.00. 

Klo 17.00 NLH Progressive Bounty 400€+40€, Level 8

Klo 19.00 PLO 4&5&6 130€+20€, Level 7

Klo 21.00 Deuce to Seven PL Triple Draw 220€+30€, Level 7 , 

Klo 21.00 Flip&Go Mystery Bounty Final Day, CLOSED

Klo 22.00 NLH Satellite to KoT Highroller 100€+20€, Level 8 

Huomenta! Posted Friday 3rd March, 2023 at 12:00(UTC+2) by Juhani Tyriseva

Huomenta! 

Salissa käy kova kuhina, pusseja availlaan. Kuten oletimmekin, ihan aikataulun mukaan ei päästä alkamaan. Toivottavasti jono respassa saadaan selvitettyä nopeasti ja aloitetaan kohta. 

Pysykää kanavalla!

Seat draw, viimeinen pöytä Posted Friday 3rd March, 2023 at 02:31(UTC+2) by Juhani Tyriseva
               39 1 Mario Jürgens 52,300 52
               39 2 Sebastian Wahl 101,100 101
               39 3 Jussi P. K. Mattila 42,000 42
               39 4 Armend Sahiti 173,700 174
               39 5 Vasilij Barna 106,000 106
               39 7 Vu Hoang Vuong 46,700 47
               39 9 Kristo Kadastik 40,000 40
Seat draw, osa 4 Posted Friday 3rd March, 2023 at 02:29(UTC+2) by Juhani Tyriseva
        31 1 Kai E. J. Lehto 95,200 95
               31 2 Ryhor Karapanau 51,200 51
               31 3 Aki Taisto Olavi Pyysing 37,300 37
               31 4 Carl H.R. Lockmer 63,200 63
               31 5 Yanis Mehdi Sahli 106,800 107
               31 7 Teemu Aukusti Toikkanen 95,200 95
               31 8 Egon Kaljulaid 105,000 105
               31 9 Ignacio Gonzalez Garrido 15,000 15
 
               32 1 Andrei Mjagkov 54,400 54
               32 3 Karl Johan Karlsson 44,000 44
               32 4 Vllaznin Dida 24,200 24
               32 5 Albert Ostrovskij 29,500 30
               32 6 Stanislovas Vinicenka 88,000 88
               32 7 Martin Piik 36,900 37
               32 8 Petri Eero Sakari Pääkkönen 73,600 74
               32 9 Erkki Kristian Kaira 19,200 19
 
               33 3 Vadim Kiseliov 69,600 70
               33 4 Gintaras Naglius 132,100 132
               33 5 Van Tuan Phung 50,300 50
               33 6 Anne Bezdek 80,300 80
               33 7 Priit Parmasto 148,000 148
               33 8 Lasse Olavi Enojärvi 71,500 72
               33 9 Victor Prior Fernandez Amat 23,000 23
 
               34 1 Ville Olavi Jantunen 84,800 85
               34 2 Juri Vassin 55,900 56
               34 3 Kaius Kiidli 14,000 14
               34 4 Martynas Racinskas 67,200 67
               34 5 Peter Hanko 52,300 52
               34 8 Linus Hans Ludwig Lauermann 142,200 142
               34 9 Raimo Tapio Ahola 57,700 58
 
               35 1 Tomi Seppo Arvid Hietala 14,000 14
               35 3 Kristaps Renga 35,200 35
               35 5 Sten Talviste 52,800 53
               35 6 Tomi Peter Lehtinen 42,200 42
               35 7 Egle Geniene 15,300 15
               35 8 Donatas Pilinkus 42,700 43
               35 9 Anatoly Filatov 175,600 176
 
               36 1 Artjoms Skvarkovskis 52,700 53
               36 4 Augustas Masaitis 106,000 106
               36 5 Dainius Balynas 69,200 69
               36 6 Justas Semaška 57,800 58
               36 7 Romans Krasins 134,000 134
               36 8 Jan Kristian Granlund 65,500 66
               36 9 Luigi Andrea Shehadeh 68,900 69
 
               37 1 Mikk Sibrits 42,300 42
               37 3 Elias Oskari Vääräniemi 80,700 81
               37 4 Thore-Fabian Kunze 19,800 20
               37 5 Yuzhou Yin 35,800 36
               37 7 Osku Kalle Karttunen 55,400 55
               37 8 Arkadiusz Liszewski 23,600 24
               37 9 Dainius Antanaitis 149,100 149
 
               38 1 Timo Tuomas Lämsä 128,300 128
               38 2 Anttu H.O Hurnanen 29,800 30
               38 3 Marius Verikas 30,800 31
               38 4 Davis Modans 76,600 77
               38 5 Niklas Mikael Vakkuri 63,100 63
               38 6 Gints Ozols 60,000 60
               38 7 Eero Ilari Lehtinen 63,500 64
Seat draw, osa 3 Posted Friday 3rd March, 2023 at 02:24(UTC+2) by Juhani Tyriseva
           21 1 Visa V. V. Kiviharju 55,300 55
               21 2 Oskars Gailums 141,700 142
               21 3 Niall Farrell 56,200 56
               21 4 Uri Gilboa 112,100 112
               21 5 Dagys Julius 65,000 65
               21 6 Niki Juhani Nurmisto 75,400 75
               21 7 Tapio Ilmari Aaltonen 71,200 71
               21 8 Pasi Tapani Sormunen 123,800 124
 
               22 1 Jari Tapio Kärkkäinen 27,900 28
               22 2 Lassi Kolari 36,700 37
               22 3 Irmantas Bzeskis 60,600 61
               22 4 Vladimir Iljunin 22,900 23
               22 5 Teemu Tuomas Kailasvuo 19,400 19
               22 6 Mohammed T. M. Al-Khazraji 106,300 106
               22 8 Tommi Petteri Lankinen 174,800 175
               22 9 Madis Ormisson 41,900 42
 
               23 1 Virgo Laansoo 63,000 63
               23 2 Inigo Naveiro Martin 20,800 21
               23 3 Gytis Bernatavicius 70,900 71
               23 5 Mark Metsla 43,400 43
               23 6 Taniel Sõõrumaa 28,000 28
               23 7 Ilja-Ülo Nukka 23,400 23
               23 8 Greger B. E. Aktell 143,000 143
               23 9 Tuomas Antero Röppänen 19,900 20
 
               24 1 Anna-Mari Hursti 44,800 45
               24 2 Johan Stig Arne Creutz 50,500 51
               24 3 Dmitrijs Arsuns 64,900 65
               24 5 Francisco Jose Blanco Racionero 144,300 144
               24 6 Kent Mikael Wulff 96,700 97
               24 7 Tomas Pinkevicius 30,000 30
               24 8 Arturs Martinsons 45,500 46
               24 9 Ricardas Zygis 57,300 57
 
               25 2 Leevi Olavi Lindstedt 26,800 27
               25 3 Jon Ander Martinez 91,500 92
               25 4 Verneri Janne Aaron Häkkinen 29,700 30
               25 5 Alf Sebastian Hjärtberg 43,600 44
               25 6 Joonas Juhani Lyttinen 26,500 27
               25 7 Priit Vallap 15,300 15
               25 8 Gediminas Dirmantas 73,300 73
               25 9 Matiss Celmins 35,500 36
 
               26 2 Krzysztof Grzegorz Romanow 54,200 54
               26 3 Max Rudolf Rotko 42,600 43
               26 4 Daniel Feirer 53,600 54
               26 5 Dennis Berglin 192,000 192
               26 6 Tomas Kirchovas 157,400 157
               26 7 Eirik Kristiansen 59,300 59
               26 8 Roope O. O. Tarmi 20,100 20
               26 9 Allan Arjut 87,200 87
 
               27 1 Marko Keskel 47,900 48
               27 2 Dmitri Dudakov 17,700 18
               27 4 Luca Beretta 68,700 69
               27 5 Toni Valtteri Ylitervo 68,200 68
               27 6 Yaniv Peretz 20,900 21
               27 7 Igor Pihela Jun. 68,800 69
               27 8 Ranno Sootla 30,000 30
               27 9 Rokas Barzdzius 101,000 101
 
               28 1 Jaakko Petteri Tirkkonen 19,800 20
               28 2 Totti Matias Arosuo 41,100 41
               28 3 Mark Paul Berman 21,700 22
               28 4 Matti Tapani Lasanen 31,800 32
               28 5 Mairo Toom 117,100 117
               28 6 Jari Pekka Rättyä 7,200 7
               28 8 Keimo I. T. Suominen 27,100 27
               28 9 Paul Koppe 157,000 157
 
               29 1 Antti E. E. Veteläinen 43,100 43
               29 2 Nikita Staroverov 60,600 61
               29 3 Paulius Vaitiekunas 42,500 43
               29 4 Peep Kivistik 27,900 28
               29 5 Andrey Koks 43,400 43
               29 6 Arto E. S. Mansner 30,000 30
               29 7 Janne M. T. Nevalainen 125,400 125
               29 9 Oskaras Valteris 13,600 14
 
               30 1 Allesandro Giordano 28,500 29
               30 2 Matias Manuel Knaapinen 60,900 61
               30 3 Arturs Barkevics 49,600 50
               30 4 Julius Kasperi Kettunen 23,500 24
               30 5 Viktors Caikins 62,400 62
               30 6 Daragh Davey 47,400 47
               30 8 Jari Juhani Porkka 43,300 43
               30 9 Kasperi Kasimir Ilkka 37,000 37
 
Seat draw, osa 2 Posted Friday 3rd March, 2023 at 02:24(UTC+2) by Juhani Tyriseva
             11 1 Alari Kadanik 66,000 66
               11 2 Aleksei Smirnov 95,800 96
               11 3 Adria Comas I Roura 93,500 94
               11 4 Antti Tapani Tuomi 79,200 79
               11 5 Vytautas Kacerauskas 88,500 89
               11 6 Mikael A.I Niemelä 38,600 39
               11 7 Mantas Bagocius 55,500 56
               11 8 Marco Regonaschi 56,900 57
 
               12 1 Rain Mölderkivi 29,000 29
               12 2 Jimmy Philippe Dewerdt 37,300 37
               12 3 Audrius Laimelis 27,700 28
               12 4 Miko Sakari Ylikoski 105,300 105
               12 5 Keito Kaljulaid 17,600 18
               12 7 Federico Luciano Cirillo 71,600 72
               12 8 Raini Lelle 39,100 39
               12 9 Marita Mägi 51,500 52
 
               13 1 Tarmo Tammel 15,000 15
               13 3 Mika Antero Levaniemi 60,000 60
               13 4 Tuomo Kalervo Niemelä 75,000 75
               13 5 Marek Selgeveer 63,200 63
               13 6 Toivo O. T. Rinne 93,900 94
               13 7 Mart Kalju 158,000 158
               13 8 Ilari Aaretti Sahamies 35,400 35
               13 9 James Noonan 23,100 23
 
               14 1 Juho Joonas V Suutari 54,200 54
               14 2 Juuso Samuel Tiitus Lepistö 58,700 59
               14 3 Mikko Tapani Ylämäki 56,400 56
               14 5 Samuel Thomas Richards 50,100 50
               14 6 Pavels Spirins 48,400 48
               14 7 Viktor E. P. Eriksson 21,500 22
               14 8 Vitalii Shcherba 11,000 11
               14 9 Jose Antoni Gonzalez Zaragoza 15,200 15
 
               15 2 Joni H.C Lankinen 67,400 67
               15 3 Gert Laanemets 124,300 124
               15 4 Laurynas Cerniauskas 21,000 21
               15 5 Pekka Aulis Kristian Virtanen 49,000 49
               15 6 Benjamin Arthur Victor Gros 83,900 84
               15 7 Miika Samuli Töyräs 42,000 42
               15 8 Taavi Tamm 16,000 16
               15 9 Ermo Kosk 37,500 38
 
               16 1 Jukka T. J. Perälä 49,700 50
               16 2 Hannes Keskküla 46,200 46
               16 3 Dan Erik Sebastian Larsson 58,100 58
               16 4 Mauri Kristjan Dorbek 69,200 69
               16 5 Maksim Petrov 6,000 6
               16 7 Julien Lauren Fuchs 68,500 69
               16 8 Elias L. B. Suhonen 40,000 40
               16 9 Hanno Kerem 77,500 78
 
               17 1 Andrejs Stenickins 21,000 21
               17 2 Henri Mikael Schalin 49,100 49
               17 3 Hanli Xiong 26,700 27
               17 4 Kasso Laasik 110,000 110
               17 5 Michael Ibba 41,200 41
               17 6 Josep Pastor De Ramon 97,800 98
               17 8 Victor Fernandez Garcia 20,300 20
               17 9 Mati Pirn 18,000 18
 
               18 1 Luca Sebastiani 54,300 54
               18 2 Timo Petteri Laiho 44,800 45
               18 3 Algirdas Saveikis 50,200 50
               18 4 Markku Koplimaa 80,700 81
               18 5 Renato Messina 47,900 48
               18 6 Andrius Bielskis 43,900 44
               18 7 Roberts Rumba 168,700 169
               18 9 Annie Chen 25,800 26
 
               19 1 Arminas Nemeika 87,000 87
               19 2 Miska Kasperi Vihervuori 72,300 72
               19 3 Jari Juhani Lahtinen 63,400 63
               19 5 Hamizs Jaralijevs 66,600 67
               19 6 Henri Käsper 39,600 40
               19 7 Mohamed Barre Mohamud 17,400 17
               19 8 Jani Alexanteri Tuovinen 72,000 72
               19 9 Donatas Kiauleikis 20,600 21
 
               20 1 Leevi Petteri Laiho 26,400 26
               20 2 Anthony Jay Kauzloric 137,100 137
               20 3 Marius Morel 24,500 25
               20 4 Sandris Mukans 27,400 27
               20 5 Erki Andressoo 30,700 31
               20 6 Robertas Smolskis 16,500 17
               20 7 Benas Jakusevas 36,900 37
               20 8 Heikki Juhani Piira 45,000 45
 
Seat draw, osa 1 Posted Friday 3rd March, 2023 at 02:22(UTC+2) by Juhani Tyriseva
     1 1 Sven Reimaa 93,900 94
                 1 2 Herli Olop 43,300 43
                 1 3 Kyle Hugh Maguire 24,800 25
                 1 5 Magnus Pukk 52,800 53
                 1 6 Kaspars Renga 112,600 113
                 1 7 Jari-Pekka Juhola 69,600 70
                 1 8 Adomas Juozapavicius 54,400 54
                 1 9 Johan Mikael Martinsen 23,700 24
 
                 2 1 Nemo Rafael Vilpponen 62,600 63
                 2 2 Miko Hermanni Miettinen 99,200 99
                 2 3 Margus Tuvikene 11,600 12
                 2 4 Joni S.J Rantamäki 85,000 85
                 2 6 Mairo Tori 118,400 118
                 2 7 Artiom Goncarenko 80,800 81
                 2 8 Siim Pindis 12,600 13
                 2 9 Lukas Bytautas 19,000 19
 
                 3 1 Jevgeni Voitovits 62,800 63
                 3 2 Grantas Naujokas 123,400 123
                 3 4 Mathias H. M. Siljander 87,200 87
                 3 5 Hans Stefan Bergström 36,900 37
                 3 6 Javier Guinot Moya 61,000 61
                 3 7 Julius Jesperi Tiihonen 244,000 244
                 3 8 Nico Sauerland 43,800 44
                 3 9 Kaspar Valk 47,200 47
 
                 4 1 Ignas Vaitulionis 92,700 93
                 4 2 Lari Anttoni Pukkila 113,600 114
                 4 3 Giovanni Nava 61,800 62
                 4 4 Martin Häidberg 30,100 30
                 4 5 Zydrunas Karcemarskas 83,700 84
                 4 6 Michailas Miserkejevas 116,400 116
                 4 7 Andrei Silencov 11,500 12
                 4 8 Santtu Kalevi Leinonen 135,600 136
 
                 5 1 Henri Sebastian Piironen 17,000 17
                 5 2 Carl Henrik Gustafsson 80,700 81
                 5 3 Evert J. A. Andersson 32,200 32
                 5 4 Albert L. E. Jonsson 116,200 116
                 5 5 Airin Pindis 42,600 43
                 5 6 Donatas Simas 92,300 92
                 5 8 Sergejs Korobovs 109,900 110
                 5 9 Giada Fang 41,500 42
 
                 6 1 Ville Heikki Juhana Konttinen 115,800 116
                 6 2 Roope N.A Holma 20,500 21
                 6 3 Kristian E. V. Kostiander 36,900 37
                 6 4 Samuli Tero Hietala 65,800 66
                 6 5 Ivar Simmer 29,700 30
                 6 6 Kasper J. O. Mellanen 101,400 101
                 6 7 Max August Avela 96,000 96
                 6 9 Hannes Praks 10,000 10
 
                 7 1 Seppo Paavo Parkkinen 51,300 51
                 7 2 Dominik Ostrowski 34,000 34
                 7 3 Jyrki Olavi Lampinen 32,900 33
                 7 4 Jaana Kindsigo 79,600 80
                 7 5 Bartosz Mielczarek 43,800 44
                 7 6 Aleksi Mikael Naski 50,400 50
                 7 7 Pekka Samuli Ikonen 75,000 75
                 7 8 Markus Tapio Ylänne 26,300 26
 
                 8 1 Touko Teivonpoika Berndtson 96,800 97
                 8 2 Mykola Shapovalov 52,400 52
                 8 3 Eirimas Tomkevicius 108,600 109
                 8 4 Davide Muccini 18,500 19
                 8 5 Martynas Vitkauskas 18,000 18
                 8 6 Iiro Mikael Kettunen 49,500 50
                 8 7 Andzej Bilat 69,000 69
                 8 9 Grigorijus Vasilavicius 21,400 21
 
                 9 1 Kasparas Klezys 30,600 31
                 9 2 Peeter Talviste 54,800 55
                 9 3 Kaupo Tenno 53,100 53
                 9 4 Sondre Stormyr 69,000 69
                 9 5 Annika Anni 54,400 54
                 9 7 Jari M.J. Mähönen 136,300 136
                 9 8 Raimo Kaljulaid 40,700 41
                 9 9 Richard Koppel 45,800 46
 
               10 2 Theophile Tristan George 62,300 62
               10 3 Vadim Guk 21,700 22
               10 4 Leonardo Romeo 86,000 86
               10 5 Tomi Tapani Arponen 26,400 26
               10 6 Deniss Davõdov 20,600 21
               10 7 Rauno Arras 14,600 15
               10 8 Stanislav Smeljov 84,900 85
               10 9 Aleksandr Kuperman 60,900 61
 
Päivä 2 alkaa klo 12.00, muistakaa rannekkeet! Posted Friday 3rd March, 2023 at 01:57(UTC+2) by Juhani Tyriseva

Tervehdys! 

Päivä 2 alkaa huomenna klo 12.00. 

Tärkeää: Jos haluat itse avata chippipussisi, sinun tulee olla paikalla jo klo 11.45. Jos asut hotellissa, käy hakemassa rannekkeesi jo heti aamiaisen jälkeen. Huomenna klo 12.00 kasinon respassa on aivan varmasti jono, joten jos jonossa seisominen ei nappaa, tule reilusti aikaisemmin (mieluusti jo klo 11.30 tai aiemmin) selviät vähällä jonotuksella. Ja kaikki voittavat kun isolta jonolta vältytään, saadaan peli oikeasti käyntiin ajallaan (tämä vaikuttaa myös illan turnausten aikatauluihin). 

01:53 (UTC+2)
Day 2 of King of Tallinn 2023 Started
Level: 9     Blinds: 500/1,000     Ante: 1,000

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.