0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event-fi/2/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0065 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.0004 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.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '14'
0.0249 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '51'
AND `published` = 1
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0044 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '53'
AND `published` = 1
0.0249 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0040 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '55'
AND `published` = 1
0.0246 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '56'
AND `published` = 1
0.0249 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '58'
AND `published` = 1
0.0247 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0035 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '60'
AND `published` = 1
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '14'
AND `name` = '2'
0.0054 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.0040 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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2450'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2449'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2446'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2442'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2441'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2437'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2434'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2433'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2431'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2418'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2406'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2394'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2389'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2387'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2385'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2382'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2380'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2379'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2375'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2370'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2369'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2368'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2364'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2359'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2356'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2355'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2348'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2346'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2345'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2343'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2342'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2341'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2340'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2335'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2334'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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.0055 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.0049 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.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2446'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2442'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2437'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2435'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2433'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2427'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2425'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2421'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2407'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2406'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2398'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2387'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2385'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0265 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2380'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2379'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2370'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2369'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2356'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2339'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2335'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2334'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '60'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1912
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
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ä.
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
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 .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.