0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0062 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-03'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings-of-tallinn-2023-main-event/3/updates'
ORDER BY `views` DESC
0.0003 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0005 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0003 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0006 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0004 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.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.0007 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.0101 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.0006 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'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '13'
0.0507 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '50'
AND `published` = 1
0.0276 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` = '52'
AND `published` = 1
0.0722 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0036 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '54'
AND `published` = 1
0.0193 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '57'
AND `published` = 1
0.0715 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '59'
AND `published` = 1
0.0894 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0103 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '61'
AND `published` = 1
0.0008 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '13'
AND `name` = '3'
0.0106 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '59'
ORDER BY `busted` ASC, `current_chips` DESC
0.0088 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` = '59'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0596 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0081 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2626'
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` = '2624'
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` = '2620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0656 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2617'
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` = '2616'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2601'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2594'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2591'
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` = '2590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0263 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0205 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2544'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2538'
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` = '2537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2533'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0145 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2504'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2497'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2495'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2492'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2489'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2488'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2485'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2483'
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` = '2481'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2480'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2477'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2476'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2474'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2470'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2466'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2465'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2462'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2461'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2459'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2456'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2453'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2452'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2451'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '59'
ORDER BY `busted` ASC, `current_chips` DESC
0.0044 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` = '59'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2624'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2616'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0150 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2609'
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` = '2607'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2601'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2594'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2591'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2576'
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` = '2575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2571'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2567'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2562'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2559'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2553'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2552'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2550'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2549'
ORDER BY `chip_change` DESC, `busted` ASC
0.0040 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2544'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2538'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2533'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2528'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2524'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2523'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2517'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2516'
ORDER BY `chip_change` DESC, `busted` ASC
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` = '2512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2504'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2497'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2495'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2494'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2492'
ORDER BY `chip_change` DESC, `busted` ASC
0.0167 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2489'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2488'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2485'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2483'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2481'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2480'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2477'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2476'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2474'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2470'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2466'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2465'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2464'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2462'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2461'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2459'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2456'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2453'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2452'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2451'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '61'
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.
Final Table Seat Draw Posted Sunday 5th March, 2023 at 02:19(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Dainius Antanaitis
1,840,000
31
1
2
Ignas Vaitulionis
5,655,000
94
1
3
Aleksi Naski
2,435,000
41
1
4
Petteri Laiho
1,570,000
26
1
5
Priit Parmasto
2,235,000
37
1
6
Sergejs Korobovs
1,630,000
27
1
7
Antti Veteläinen
1,180,000
20
1
8
Davide Muccini
4,200,000
70
1
9
Albert Ostrovskij
730,000
12
Player
Chips
Progress
Ignas Vaitulionis
5,655,000
30,000
Davide Muccini
4,200,000
1,335,000
Aleksi Naski
2,435,000
130,000
Priit Parmasto
2,235,000
290,000
Dainius Antanaitis
1,840,000
65,000
Sergejs Korobovs
1,630,000
930,000
Timo Laiho
1,570,000
640,000
Antti Vetelainen
1,180,000
5,000
Albert Ostrovskij
730,000
485,000
Vaitulionis Ousts Nurmisto to End the Day Posted Sunday 5th March, 2023 at 02:00(UTC+2) by Jason Glatzer
Main Event Day 3 Level 27: 30,000/60,000 (60,000) Entries: 9/716
Niki Nurmisto jammed the cutoff for 680,000. Ignas Vaitulionis tanked for about a minute before he called from the big blind.
Niki Nurmisto: Ignas Vaitulionis:
Vaitulionis continued his crush mode to end the day by also eliminating the final player after the board was no good for Nurmisto.
The action is down to a final table of nine players to be played out on the live-streamed TV table starting tomorrow at noon with 37:07 remaining on the clock in Level 27. We will post the seat draw shortly and in the meantime, have an amazing rest of your evening.
Player
Chips
Progress
Ignas Vaitulionis
5,685,000
1,485,000
Niki Nurmisto
0
0
Set of Ducks for Vaitulionis to Oust Vuong Posted Sunday 5th March, 2023 at 01:50(UTC+2) by Jason Glatzer
Main Event Day 3 Level 27: 30,000/60,000 (60,000) Entries: 10/716
Vu Vuong opened for 125,000 from the cutoff and Ignas Vaitulionis defended his big blind.
Vuong fired out for 150,000 on the flop and Vaitulionis check-called. Vaitulionis checked again on the turn. Vuong jammed for about 450,000 and Vaitulionis wasted no time in finding a call.
Vu Vuong: Ignas Vaitulionis:
Vuong was miles ahead preflop but was drawing to just two outs to a better set by the time all the chips went in. The didn't save Vuong on the river and the action was down to just 10 players.
Player
Chips
Progress
Ignas Vaitulionis
4,200,000
670,000
Vu Vuong
0
0
Nevalainen & Romeo Ousted in Back-to-Back Hands at Feature Table Posted Sunday 5th March, 2023 at 01:42(UTC+2) by Jason Glatzer
Main Event Day 3 Level 27: 30,000/60,000 (60,000) Entries: 11/716
Janne Nevalainen and Leonardo Romeo were ousted in back-to-back hands at the feature table. You can check it out by clicking on the Live Streaming section on the website.
Player
Chips
Progress
Leonardo Romeo
0
0
Janne Nevalainen
0
0
Final 30 Minutes Posted Sunday 5th March, 2023 at 01:32(UTC+2) by Jason Glatzer
Main Event Day 3 Level 27: 30,000/60,000 (60,000) Entries: 13/716
Kings of Tallinn Tournament Director Teresa Nousianen announced to the remaining players that they will play half of Level 27 before bagging chips for the evening.
01:30 (UTC+2)
Start of Level 27 Blinds: 30,000/60,000 Ante: 60,000
Updated Chip Counts on Break Posted Sunday 5th March, 2023 at 01:30(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
7
1
Timo Laiho
930,000
16
7
2
Dainius Antanaitis
1,775,000
30
7
3
Davide Muccini
2,865,000
48
7
4
Albert Ostrovskij
1,215,000
20
7
5
Aleksi Naski
2,305,000
38
7
6
Leonardo Romeo
905,000
15
7
7
Janne Nevalainen
690,000
12
11
1
Antti Veteläinen
1,175,000
20
11
2
Vu Vuong
550,000
9
11
3
Niki Nurmisto
1,115,000
19
11
5
Sergejs Korobovs
700,000
12
11
6
Priit Parmasto
2,525,000
42
11
7
Ignas Vaitulionis
3,530,000
59
Player
Chips
Progress
Ignas Vaitulionis
3,530,000
280,000
Davide Muccini
2,865,000
1,075,000
Priit Parmasto
2,525,000
850,000
Aleksi Naski
2,305,000
435,000
Dainius Antanaitis
1,775,000
955,000
Albert Ostrovskij
1,215,000
570,000
Antti Vetelainen
1,175,000
1,225,000
Niki Nurmisto
1,115,000
485,000
Timo Laiho
930,000
260,000
Leonardo Romeo
905,000
305,000
Sergejs Korobovs
700,000
1,040,000
Janne Nevalainen
690,000
480,000
Vu Vuong
550,000
975,000
Final Break Posted Sunday 5th March, 2023 at 01:25(UTC+2) by Jason Glatzer
Players are on what should be the final break of Day 3. The action will resume in a few minutes.
Posted Sunday 5th March, 2023 at 01:09(UTC+2) by Jason Glatzer
Main Event Day 3 Level 26: 25,000/50,000 (50,000) Entries: 13/716
Ignas Vaitulionis jammed the small blind and Anna-Mari Hursti called off for about six big blinds from the big blind.
Anna-Mari Hursti: Ignas Vaitulionis:
Vaitulionis connected with his nine on the flop and never looked back with the turn and river completing the board to win the hand.
It was a heck of a ride for Hursti. Her stack was decimated not so long ago with kings vs. aces but before that was cruising along. Unfortunately, good things must come to an end sometimes, and we wish the best for Hursti the next year for an even better result.
Player
Chips
Progress
Ignas Vaitulionis
3,250,000
850,000
Anna-Mari Hursti
0
0
Rockets Again for Vetelainen Posted Sunday 5th March, 2023 at 00:52(UTC+2) by Jason Glatzer
Main Event Day 3 Level 26: 25,000/50,000 (50,000) Entries: 14/716
It was a different dealer but the same result for Antti Vetelainen. The Finnish player got aces once again and got it in against a premium hand as follows.
Ignas Vaitulionis min-raised the button. Vetelainen three-bet to 275,000 from the big blind. Vaitulionis four-bet jammed and Vetelainen snap-called for 1,095,000.
Antti Vetelainen: Ignas Vaitulionis:
The board didn't provide Vaitulionis any magic to beat pocket rockets and for the second time this blind level he doubled his stack.
Player
Chips
Progress
Antti Vetelainen
2,400,000
1,255,000
Ignas Vaitulionis
2,400,000
50,000
Big Set-Up with Aces Vs. Kings to Decimate Hursti's Stack Posted Sunday 5th March, 2023 at 00:39(UTC+2) by Jason Glatzer
Main Event Day 3 Level 26: 25,000/50,000 (50,000) Entries: 14/716
Anna-Mari Hursti opened for 100,000 from the button. Antti Vetelainen three-bet to 300,000 from the button. Hursti jammed for more than 700,000 and Vetelainen called off for 560,000.
Antti Vetelainen: Anna-Mari Hursti:
The table gasped in shock at the set-up with aces vs. kings. Hursti paid off Vetelainen after she was unable to get the second-best hand in poker ahead of the very best hand with the running out on the board.
Player
Chips
Progress
Antti Vetelainen
1,145,000
660,000
Anna-Mari Hursti
250,000
615,000
Oskars Gailums Eliminated at the TV Table Posted Sunday 5th March, 2023 at 00:32(UTC+2) by Jason Glatzer
Main Event Day 3 Level 26: 25,000/50,000 (50,000) Entries: 14/716
Oskars Gailums was eliminated at the TV table. Check out the stream in about 25 minutes to see how.
Player
Chips
Progress
Oskars Gailums
0
0
Posted Sunday 5th March, 2023 at 00:30(UTC+2) by Jason Glatzer
Main Event Day 3 Level 26: 25,000/50,000 (50,000) Entries: 15/716
Vu Vuong 100,000 from middle position. Algirdas Saveikis three-bet jammed for 375,000 from the hijack. Ignas Vaitulionis four-bet shoved for close to 2 million from the small blind and Vuong folded leading to a heads-up showdown with Saveikis behind and at risk.
Algirdas Saveikis: Ignas Vaitulionis:
"I want to use my one-time," said Saveikis.
Unfortunately, Saveikis didn't get his one time and was eliminated in 16th place after the ran out on the board.
Player
Chips
Progress
Ignas Vaitulionis
2,450,000
490,000
Algirdas Saveikis
0
0
00:19 (UTC+2)
Start of Level 26 Blinds: 25,000/50,000 Ante: 50,000
Two Table Redraw Posted Saturday 4th March, 2023 at 23:43(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
7
1
Timo Laiho
670,000
17
7
2
Dainius Antanaitis
2,730,000
68
7
3
Davide Muccini
1,790,000
45
7
4
Albert Ostrovskij
645,000
16
7
5
Aleksi Naski
2,740,000
69
7
6
Leonardo Romeo
600,000
15
7
7
Janne Nevalainen
1,170,000
29
7
8
Oskars Gailums
440,000
11
11
1
Antti Veteläinen
485,000
12
11
2
Vu Vuong
1,525,000
38
11
3
Niki Nurmisto
1,600,000
40
11
4
Algirdas Saveikis
885,000
22
11
5
Sergejs Korobovs
1,740,000
44
11
6
Priit Parmasto
1,675,000
42
11
7
Ignas Vaitulionis
1,960,000
49
11
8
Anna-Mari Hursti
865,000
22
Player
Chips
Progress
Aleksi Naski
2,740,000
240,000
Dainius Antanaitis
2,730,000
20,000
Ignas Vaitulionis
1,960,000
1,025,000
Davide Muccini
1,790,000
90,000
Sergejs Korobovs
1,740,000
40,000
Priit Parmasto
1,675,000
75,000
Niki Nurmisto
1,600,000
1,300,000
Vu Vuong
1,525,000
670,000
Janne Nevalainen
1,170,000
50,000
Algirdas Saveikis
885,000
15,000
Anna-Mari Hursti
865,000
210,000
Timo Laiho
670,000
270,000
Albert Ostrovskij
645,000
95,000
Leonardo Romeo
600,000
150,000
Antti Vetelainen
485,000
115,000
Oskars Gailums
440,000
755,000
Payouts for €4,200 Posted Saturday 4th March, 2023 at 23:32(UTC+2) by Jason Glatzer
Place
Player
Prize
17
Yanis Mehdi Sahli
€4,200
18
Jari-Pekka Juhola
€4,200
19
Martynas Racinskas
€4,200
20
Nemo Vilpponen
€4,200
21
Pavel Spirins
€4,200
22
Francisco Racionero
€4,200
23
Lari Pukkila
€4,200
Saveikis Out-Flips Sahli Posted Saturday 4th March, 2023 at 23:30(UTC+2) by Jason Glatzer
Main Event Day 3 Level 25: 20,000/40,000 (40,000) Entries: 16/716
Algirdas Saveikis jammed for 455,000 from the cutoff. Timo Laiho tanked for over a minute from the button before he folded. However, Yanis Mehdi Sahli did find a call for a little less from the big blind.
Yanis Mehdi Sahli: Algirdas Saveikis:
Saveikis connected with his jack right away on the board to eliminate Sahli with two pair. There will be a short delay in the action while the redraw is taking place.
Player
Chips
Progress
Algirdas Saveikis
900,000
495,000
Yanis Mehdi Sahli
0
0
Juhola Gone at the TV Table Posted Saturday 4th March, 2023 at 23:18(UTC+2) by Jason Glatzer
Main Event Day 3 Level 25: 20,000/40,000 (40,000) Entries: 17/716
Jari-Pekka Juhola was recently eliminated at the TV table. You can watch it shortly by heading to the stream either at the Kings of Tallinn website or at Main Event Travel where it is also being hosted.
Player
Chips
Progress
Jari-Pekka Juhola
0
0
23:01 (UTC+2)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Interview With Local Legend Henri Kasper Posted Saturday 4th March, 2023 at 23:01(UTC+2) by Jason Glatzer
Full Payouts of the Main Event Posted Saturday 4th March, 2023 at 22:59(UTC+2) by Jason Glatzer
Place
Prize
Prize
1
€140,100
2
€89,800
3
€60,000
4
€40,040
5
€29,800
6
€22,500
7
€17,600
8
€14,200
9
€11,900
10
€9,800
11
€7,850
12
€7,850
13
€6,350
14
€6,350
15
€5,100
16
€5,100
17
€4,200
18
€4,200
19
Martynas Racinskas
€4,200
20
Nemo Vilpponen
€4,200
21
Pavel Spirins
€4,200
22
Francisco Racionero
€4,200
23
Lari Pukkila
€4,200
24
Ranno Sootla
€3,600
25
Gintaras Naglius
€3,600
26
Adria Comas I Roura
€3,600
27
Vladimir Iljunin
€3,600
28
Hanno Kerem
€3,600
29
Linus Lauermann
€3,600
30
Mikael Niemela
€3,600
31
Taago Tamm
€3,600
32
Eirik Kristiansen
€3,600
33
Magnus Pukk
€3,200
34
Ignacio Garrido
€3,200
35
Anthony Kauzloric
€3,200
36
Paul Koppe
€3,200
37
Sebastian Wahl
€3,200
38
Javier Moya
€3,200
39
Mart Kalju
€3,200
40
Artiom Goncarenko
€3,200
41
Victor Fernandez Garcia
€2,800
42
Roope Holma
€2,800
43
Jani Tuovinen
€2,800
44
Roberts Rumba
€2,800
45
Miko Miettinen
€2,800
46
Mohammed Al-Khazraji
€2,800
47
Kai Lehto
€2,800
48
Richard Koppel
€2,800
49
Giada Fang
€2,500
50
Toni Ylitervo
€2,500
51
Steven Tool
€2,500
52
Federico Cirillo
€2,500
53
Jari Mahonen
€2,500
54
Kasparas Klezys
€2,500
55
Mika Levaniemi
€2,500
56
Juri Vassin
€2,500
57
Michailas Miserkejevas
€2,300
58
Adomas Juozapavicius
€2,300
59
Verneri Hakkinen
€2,300
60
Anatoly Filatov
€2,300
61
Gints Ozols
€2,300
62
Julius Tiihonen
€2,300
63
Marco Regonaschi
€2,300
64
Walter Treccarichi
€2,300
65
Rokas Barzdzius
€2,300
66
Arminas Nemeika
€2,300
67
Carl Gustafsson
€2,300
68
Saulius Tumosa
€2,300
69
Gytis Bernatavicius
€2,300
70
Paulius Vaitiekunas
€2,300
71
Grigorijus Vasilavicius
€2,300
72
Tomas Kirchovas
€2,300
73
Dmitrijs Arsuns
€2,100
74
Aleksandr Kuperman
€2,100
75
Irmantas Bzeskis
€2,100
76
Luca Sebastiani
€2,100
77
Deniss Davodov
€2,100
78
Martin Piik
€2,100
79
Mairo Tori
€2,100
80
Keito Kaljulaid
€2,100
81
Airin Pindis
€2,100
82
Daragh Davey
€2,100
83
Albert Jonsson
€2,100
84
Jon Ander Martinez
€2,100
85
Arto Mansner
€2,100
86
Theophile George
€2,100
87
Tomas Pinkevicius
€2,100
Get Up and Stretch Posted Saturday 4th March, 2023 at 22:44(UTC+2) by Jason Glatzer
Players are on another short break. Blinds will increase to 20,000/40,000 with a big blind ante of 40,000 when the action resumes.
Racinskas Hits the Rail at the TV Table Posted Saturday 4th March, 2023 at 22:37(UTC+2) by Jason Glatzer
Main Event Day 3 Level 24: 15,000/30,000 (30,000) Entries: 18/716
After a few eliminations on the outer tables, Martynas Racinskas hit the rail at the TV table. You will need to watch the stream to see how in about 25 minutes.
Player
Chips
Progress
Martynas Racinskas
0
0
Vilpponen Runs Sixes Into Sevens Posted Saturday 4th March, 2023 at 22:19(UTC+2) by Jason Glatzer
Main Event Day 3 Level 24: 15,000/30,000 (30,000) Entries: 19/716
Nemo Vilpponen jammed for 545,000 from the small blind and was called by Dainius Antanaitis from the big blind.
Nemo Vilpponen: Dainius Antanaitis:
Vilpponen needed some help but none was on its way. The came on the flop before Antanaitis tapped on the table designating "good game" on the turn as Vilpponen was drawing dead. The river completed the board and Antanaitis stood up to shake Vilpponen's hand showing good sportsmanship as the dealer shipped him the pot.
Player
Chips
Progress
Dainius Antanaitis
2,750,000
200,000
Nemo Vilpponen
0
0
The Naski Show Continues Posted Saturday 4th March, 2023 at 22:12(UTC+2) by Jason Glatzer
Main Event Day 3 Level 24: 15,000/30,000 (30,000) Entries: 20/716
It has been all Aleksi Naski as of late as he just took out another player and continues to grow his stack.
Start-of-the-day chip leader Pavels Sprins jammed the button for 370,000 and Naski called from the small blind.
Pavel Spirins: Aleksi Naski:
Naski's ace jack held to eliminate Spirins after the ran out on the board.
Player
Chips
Progress
Aleksi Naski
2,500,000
500,000
Pavels Spirins
0
0
Naski Ousts Racionero Posted Saturday 4th March, 2023 at 22:05(UTC+2) by Jason Glatzer
Main Event Day 3 Level 24: 15,000/30,000 (30,000) Entries: 21/716
Pavels Spirins min-raised from early position and was called by Francisco Racionero from one seat over. Aleksi Naski three-bet to 190,000 from middle position. Spirins folded before Racionero jammed for 435,000. Naski asked for a count before he called.
Francisco Racionero: Aleksi Naski:
Naski won the flip with trips to eliminate Racionero after the came out on the board.
Player
Chips
Progress
Aleksi Naski
1,900,000
400,000
Francisco Racionero
0
0
Set of Ladies for Naski Posted Saturday 4th March, 2023 at 21:56(UTC+2) by Jason Glatzer
Main Event Day 3 Level 24: 15,000/30,000 (30,000) Entries: 22/716
It was a three-bet pot preflop between Aleksi Naski in middle position and Timo Laiho from the small blind.
Laiho continued for 125,000 on the flop and Naski called. Laiho then check-called bets of 160,000 on the turn and for 215,000 on the river.
Laiho turned over for two pair but this didn't get the job done with Naski holding for a set of queens.
Player
Chips
Progress
Aleksi Naski
1,500,000
890,000
Timo Laiho
400,000
750,000
21:52 (UTC+2)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Pukkila Runs Into Rockets Posted Saturday 4th March, 2023 at 21:46(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 22/716
Lari Pukkila jammed his short stack with sevens and ran into the aces of Aleksi Naski. The ran out on the board and Pukkil was eliminated in 23rd place.
Player
Chips
Progress
Aleksi Naski
610,000
160,000
Lari Pukkila
0
0
Ostrovskij "Booms" His Stack with a Flush Posted Saturday 4th March, 2023 at 21:41(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 23/716
Albert Ostrovskij jammed for 340,000 from the cutoff and was called by Davide Muccini from the big blind.
Albert Ostrovskij: Davide Muccini:
"I guess the time has come," said Ostrovskij.
Ostrovskij spoked to soon as the board improved him to a flush.
"Boom!" the excited Ostrovskij said after the hand.
Player
Chips
Progress
Davide Muccini
1,700,000
300,000
Albert Ostrovskij
740,000
310,000
Sootla Out at the TV Table Posted Saturday 4th March, 2023 at 21:26(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 23/716
There will not be a two-time champion at this year's Kings of Tallinn Main Event as 2015 Kings of Tallinn championship and WSOP bracelet winner Ranno Sootla was eliminated at the TV table just before the redraw to leave 23 players remaining. You can check it out on the stream in about 25 minutes.
Player
Chips
Progress
Vu Vuong
500,000
500,000
Ranno Sootla
0
0
Payouts for €3,600 Posted Saturday 4th March, 2023 at 21:17(UTC+2) by Jason Glatzer
Place
Player
Prize
25
Gintaras Naglius
€3,600
26
Adria Comas I Roura
€3,600
27
Vladimir Iljunin
€3,600
28
Hanno Kerem
€3,600
29
Linus Lauermann
€3,600
30
Mikael Niemela
€3,600
31
Taago Tamm
€3,600
32
Eirik Kristiansen
€3,600
Three-Table Redraw After Juhola Ousts Naglius Posted Saturday 4th March, 2023 at 21:16(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 24/716
It was a limped three-way pot between a player in late position. Gintaras Naglius bet 75,000 on the flop. Jari-Pekka Juhola jammed for 360,000. The other player in the hand got out of the way before Naglius called off his stack of around 300,000.
Gintaras Naglius: Jari-Pekka Juhola:
Juhola had Naglius drawing thin when the chips went in and Naglius was drawing dead after the turn. The river completed the board and a three-table draw took place just after Naglius hit the rail in 25th place.
Player
Chips
Progress
Jari-Pekka Juhola
900,000
50,000
Gintaras Naglius
0
0
Ladies Beat Jacks for Vilpponen Posted Saturday 4th March, 2023 at 21:06(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 25/716
Timo Laiho was all in with against the Nemo Vilpponen for a pot north of 1.1 million.
Both players had an overpair to the board and Vilpponen's queens were good against jacks.
Player
Chips
Progress
Timo Laiho
1,150,000
750,000
Nemo Vilpponen
550,000
550,000
Set of Cowboys for Korobovs Posted Saturday 4th March, 2023 at 20:59(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 25/716
Sergejs Korobovs opened for 55,000 from middle position before Adria Comas I Roura defended his big blind.
Comas I Roura jammed for about 400,000 on the flop and was snap-called by Korobovs.
Adria Comas I Roura: Sergejs Korobovs:
Korobovs was far ahead and had Comas I Roura drawing dead after the turn. The river completed the board and we are getting closer to the three-table redraw.
Player
Chips
Progress
Sergejs Korobovs
1,700,000
585,000
Adria Comas I Roura
0
0
Bad Beat with Big Slick for Muccini Posted Saturday 4th March, 2023 at 20:54(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 26/716
Davide Muccini four-bet jammed for 960,000 and was called by Vladimir Iljunin for about 900,000.
Vladimir Iljunin: Davide Muccini:
It was a bad beat for Iljunin after Muccini nailed two pair on the board.
Player
Chips
Progress
Davide Muccini
2,000,000
1,150,000
Vladimir Iljunin
0
0
Vilpponen Doubles Through Romeo Posted Saturday 4th March, 2023 at 20:50(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 27/716
Nemo Vilpponen jammed for 340,000 over the bet of Leonardo Romeo on the flop with already about 350,000 in the pot. Romeo called and the cards were turned over.
Nemo Vilpponen: Leonardo Romeo:
Vilpponen was ahead and won the hand to double his stack with two pair after the turn and river completed the board.
Player
Chips
Progress
Nemo Vilpponen
1,100,000
715,000
Leonardo Romeo
750,000
425,000
Kerem Out at the TV Table Posted Saturday 4th March, 2023 at 20:36(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 27/716
Hanno Kerem just lost his short stack at the TV table. You can check it out by watching the stream either at the Kings of Tallinn website or at Main Event Travel depending on what's best for you.
Player
Chips
Progress
Hanno Kerem
0
0
Parmasto Ousts Two With Ladies Posted Saturday 4th March, 2023 at 20:33(UTC+2) by Jason Glatzer
Main Event Day 3 Level 23: 10,000/25,000 (25,000) Entries: 28/716
The players are back from their dinner break and there was fireworks straight off the bat.
Dainius Antanaitis opened from early position for 55,000. Mikael Niemela jammed for 185,000 before Linus Lauermann four-bet shoved for 225,000. Priit Parmasto came over the top 1,110,000 and Antanaitis folded for a three-way showdown with two players behind at risk.
Mikael Niemela: Linus Lauermann: Priit Parmasto:
The ran out on the board for Parmasto to eliminate both Niemela and Lauermann.
Player
Chips
Progress
Priit Parmasto
1,600,000
490,000
Linus Lauermann
0
0
Mikael Niemela
0
0
20:27 (UTC+2)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Full Chip Counts at Dinner Break Posted Saturday 4th March, 2023 at 19:54(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
7
1
Vu Vuong
355,000
14
7
2
Ranno Sootla
380,000
15
7
3
Janne Nevalainen
1,220,000
49
7
4
Ignas Vaitulionis
935,000
37
7
6
Antti Veteläinen
600,000
24
7
7
Oskars Gailums
1,195,000
48
7
8
Hanno Kerem
230,000
9
11
1
Nemo Vilpponen
385,000
15
11
2
Adria Comas I Roura
755,000
30
11
3
Martynas Racinskas
510,000
20
11
4
Leonardo Romeo
1,175,000
47
11
5
Sergejs Korobovs
1,115,000
45
11
7
Albert Ostrovskij
430,000
17
11
8
Timo Laiho
400,000
16
12
1
Lari Pukkila
535,000
21
12
2
Algirdas Saveikis
405,000
16
12
3
Priit Parmasto
1,110,000
44
12
4
Aleksi Naski
450,000
18
12
5
Dainius Antanaitis
2,550,000
102
12
6
Mikael Niemelä
185,000
7
12
7
Yanis Mehdi Sahli
1,310,000
52
12
8
Linus Lauermann
225,000
9
13
1
Jari-Pekka Juhola
850,000
34
13
2
Francisco Racionero
275,000
11
13
3
Davide Muccini
850,000
34
13
4
Niki Nurmisto
300,000
12
13
5
Anna-Mari Hursti
655,000
26
13
6
Vladimir Iljunin
980,000
39
13
7
Gintaras Naglius
610,000
24
13
8
Pavels Spirins
500,000
20
Player
Chips
Progress
Dainius Antanaitis
2,550,000
800,000
Yanis Mehdi Sahli
1,310,000
858,000
Janne Nevalainen
1,220,000
920,000
Oskars Gailums
1,195,000
178,000
Leonardo Romeo
1,175,000
175,000
Sergejs Korobovs
1,115,000
15,000
Priit Parmasto
1,110,000
210,000
Vladimir Iljunin
980,000
210,000
Ignas Vaitulionis
935,000
177,000
Jari-Pekka Juhola
850,000
330,000
Davide Muccini
850,000
293,000
Adria Comas I Roura
755,000
655,000
Anna-Mari Hursti
655,000
517,000
Gintaras Naglius
610,000
5,000
Antti Vetelainen
600,000
470,000
Lari Pukkila
535,000
175,000
Martynas Racinskas
510,000
310,000
Pavels Spirins
500,000
25,000
Aleksi Naski
450,000
84,000
Albert Ostrovskij
430,000
15,000
Algirdas Saveikis
405,000
5,000
Timo Laiho
400,000
5,000
Nemo Vilpponen
385,000
135,000
Ranno Sootla
380,000
25,000
Vu Vuong
355,000
69,000
Niki Nurmisto
300,000
200,000
Francisco Racionero
275,000
103,000
Hanno Kerem
230,000
20,000
Linus Lauermann
225,000
41,000
Mikael Niemela
135,000
336,000
Dinner Break Posted Saturday 4th March, 2023 at 19:28(UTC+2) by Jason Glatzer
Players are on a one-hour dinner break. We will update the chip counts during the break. In the meantime, check out this video by Laura Cornelius about how the Kings of Tallinn has been breaking records left and right.
Saveikis Doubles Through Pukkila Posted Saturday 4th March, 2023 at 19:24(UTC+2) by Jason Glatzer
Main Event Day 3 Level 22: 10,000/20,000 (20,000) Entries: 30/716
Lari Pukkila opened to 40,000 from under the gun. Algirdas Saveikis three-bet to 100,000 with just 83,000 left behind and Pukilla called.
Pukkila jammed the flop. Saveikis called off the remainder of his stack and Saveikis was in good shape.
Algirdas Saveikis: Lari Pukkila:
The turn and river kept Saveikis ahead and he doubled just before the dinner break. Meanwhile, Taago Tamm was eliminated at a different table before this hand.
Player
Chips
Progress
Algirdas Saveikis
400,000
268,000
Lari Pukkila
360,000
12,000
Taago Tamm
0
0
Payouts for €3,200 Posted Saturday 4th March, 2023 at 19:08(UTC+2) by Jason Glatzer
Place
Player
Prize
33
Magnus Pukk
€3,200
34
Ignacio Garrido
€3,200
35
Anthony Kauzloric
€3,200
36
Paul Koppe
€3,200
37
Sebastian Wahl
€3,200
38
Javier Moya
€3,200
39
Mart Kalju
€3,200
40
Artiom Goncarenko
€3,200
Ladies for Romeo to Oust Kristiansen Posted Saturday 4th March, 2023 at 19:03(UTC+2) by Jason Glatzer
Main Event Day 3 Level 22: 10,000/20,000 (20,000) Entries: 31/716
Eirik Kristiansen three-bet jammed for around 20 big blinds from the big blind and was called by Leonardo Romeo, who recently just lost a bit of his stack to Martynas Racinskas.
Eirik Kristiansen: Leonardo Romeo:
The board didn't help Kristiansen and he was eliminated in 32nd place.
Player
Chips
Progress
Leonardo Romeo
1,000,000
470,000
Eirik Kristiansen
0
0
Tens Good for Racinskas Posted Saturday 4th March, 2023 at 19:01(UTC+2) by Jason Glatzer
Main Event Day 3 Level 22: 10,000/20,000 (20,000) Entries: 32/716
Martynas Racinskas opened for 40,000 from the button. Leonardo Romeo jammed for near 1 million chips from the small blind and Racinskas called off his stack of 390,000.
Martynas Racinskas: Leonardo Romeo:
The flop opened up a few more outs for Romeo as he had a gutshot straight draw. However, the turn and river were safe for Racinskas and he doubled through Romeo.
Meanwhile, Magnus Pukk, Ignacio Garrido, and Anthony Kauzloric all recently hit the rail during Level 22.
Player
Chips
Progress
Martynas Racinskas
820,000
751,000
Leonardo Romeo
530,000
210,000
Anthony Kauzloric
0
0
Ignacio Garrido
0
0
Magnus Pukk
0
0
Recent Eliminations Posted Saturday 4th March, 2023 at 18:31(UTC+2) by Jason Glatzer
Main Event Day 3 Level 22: 10,000/20,000 (20,000) Entries: 35/716
Paul Koppe began the day as the chip leader, but he just hit the rail in 36th place. Also recently on the rail were Sebastian Wahl, Javier Moya, Mart Kalju, and Artiom Goncarenko.
Player
Chips
Progress
Artiom Goncarenko
0
0
Mart Kalju
0
0
Javier Guinot Moya
0
0
Sebastian Wahl
0
0
Paul Koppe
0
0
18:28 (UTC+2)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
New Record for the Queens of Tallinn Posted Saturday 4th March, 2023 at 18:28(UTC+2) by Jason Glatzer
The €120 buy-in Queens of Tallinn set a new record for the event with 95 entries generating a €9,120 prize pool.
We wanted to be sure to wish Evy Albrigtsen as happy birthday and wish her the best of luck in this event that still has 62 players remaining.
Payouts for €2,800 Posted Saturday 4th March, 2023 at 18:10(UTC+2) by Jason Glatzer
Place
Player
Prize
41
Victor Fernandez Garcia
€2,800
42
Roope Holma
€2,800
43
Jani Tuovinen
€2,800
44
Roberts Rumba
€2,800
45
Miko Miettinen
€2,800
46
Mohammed Al-Khazraji
€2,800
47
Kai Lehto
€2,800
48
Richard Koppel
€2,800
Antanaitis Scores Big with Ace-Queen vs Ace-Queen Posted Saturday 4th March, 2023 at 18:08(UTC+2) by Jason Glatzer
Main Event Day 3 Level 21: 8,000/16,000 (16,000) Entries: 40/716
Roope Halma got it in good with his small stack with but was unable to hold against Niki Nurmisto's ace-jack.
Shortly after, Dainius Antanaitis wound up winning what was perhaps the biggest pot thus far in the tournament.
Antanaitis had his 630,000 chip pot committed with a little less already in the pot on the flop and previous chip leader Priit Parmasto had him well covered.
Dainius Antanaitis: Priit Parmasto:
Antanaitis was freerolling Parmasto but needed a pair of running clubs. The Lithuanian screamed in joy after the turn and river completed the board to win the hand with a flush.
Victor Fernandez Garcia also recently hit the rail to leave just 40 players remaining.
Player
Chips
Progress
Dainius Antanaitis
2,000,000
1,371,000
Priit Parmasto
900,000
700,000
Niki Nurmisto
500,000
190,000
Victor Fernandez Garcia
0
0
Roope Holma
0
0
Tuovinen Runs Into Kauzloric's Big Slick Posted Saturday 4th March, 2023 at 17:56(UTC+2) by Jason Glatzer
Main Event Day 3 Level 21: 8,000/16,000 (16,000) Entries: 42/716
Jani Tuovinen jammed for under 10 big blinds from the cutoff. Anthony Kauzloric three-bet jammed for a bit more from the button and it was a heads-up showdown with Tuovinen at risk after the players in the blinds folded.
Jani Tuovinen: Anthony Kauzloric:
The board didn't save Tuovinen and he was out the door along with the recently eliminated Miko Miettinen and Roberts Rumba.
Player
Chips
Progress
Anthony Kauzloric
485,000
204,000
Miko Miettinen
0
0
Roberts Rumba
0
0
Jani Tuovinen
0
0
"Good Call" (Or Was It?) Posted Saturday 4th March, 2023 at 17:46(UTC+2) by Jason Glatzer
Main Event Day 3 Level 21: 8,000/16,000 (16,000) Entries: 45/716
Nemo Vilpponen jammed for 110,000 from middle position.
"How much?" asked Janne Nevalainen from the big blind.
Nevalainen called soon after being informed the amount.
"Nice call," said Vilpponen to Nevalainen.
Nemo Vilpponen: Janne Nevalainen:
The flop kept Nevalainen ahead but Vilpponen took a heavy lead in the hand after improving to trips on the turn.
"What the f*&k," said Nevalainen.
The river completed the board.
"I was going for a flush," Vilpponen said as a joke.
Meanwhile, Mohammed Al-Khazraji was eliminated recently at another table to leave just 44 players remaining.
Player
Chips
Progress
Janne Nevalainen
300,000
30,000
Nemo Vilpponen
250,000
900,000
Mohammed Al-Khazraji
0
0
Garrido Saved on the RIver Posted Saturday 4th March, 2023 at 17:34(UTC+2) by Jason Glatzer
Main Event Day 3 Level 21: 8,000/16,000 (16,000) Entries: 46/716
Ignacio Garrido jammed from middle position for 144,000. Mart Kalju three-bet jammed for about twice as much from the button and the rest of the table folded.
Ignacio Garrido: Mart Kalju:
It looked like Garrido would be heading out the door after Kalju's king paired up on the flop. The turn changed the entire hand as Garrido improved to a set of ladies.
Garrido wasn't safe yet as he needed to fade a ten on the river as this would have improved Kalju to Broadway. No ten came. Instead the river completed the board for Garrido to double through Kalju.
Meanwhile, Kai Lehto hit the rail at a different table at around the same time to leave just 46 players remaining.
Player
Chips
Progress
Ignacio Garrido
328,000
28,000
Mart Kalju
145,000
57,000
Kai Lehto
0
0
17:23 (UTC+2)
Start of Level 21 Blinds: 8,000/16,000 Ante: 16,000
Various Big Stacks at Break Posted Saturday 4th March, 2023 at 17:23(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
7
1
Vu Vuong
355,000
14
7
2
Ranno Sootla
380,000
15
7
3
Janne Nevalainen
1,220,000
49
7
4
Ignas Vaitulionis
935,000
37
7
6
Antti Veteläinen
600,000
24
7
7
Oskars Gailums
1,195,000
48
7
8
Hanno Kerem
230,000
9
11
1
Nemo Vilpponen
385,000
15
11
2
Adria Comas I Roura
755,000
30
11
3
Martynas Racinskas
510,000
20
11
4
Leonardo Romeo
1,175,000
47
11
5
Sergejs Korobovs
1,115,000
45
11
7
Albert Ostrovskij
430,000
17
11
8
Timo Laiho
400,000
16
12
1
Lari Pukkila
535,000
21
12
2
Algirdas Saveikis
405,000
16
12
3
Priit Parmasto
1,110,000
44
12
4
Aleksi Naski
450,000
18
12
5
Dainius Antanaitis
2,550,000
102
12
6
Mikael Niemelä
185,000
7
12
7
Yanis Mehdi Sahli
1,310,000
52
12
8
Linus Lauermann
225,000
9
13
1
Jari-Pekka Juhola
850,000
34
13
2
Francisco Racionero
275,000
11
13
3
Davide Muccini
850,000
34
13
4
Niki Nurmisto
300,000
12
13
5
Anna-Mari Hursti
655,000
26
13
6
Vladimir Iljunin
980,000
39
13
7
Gintaras Naglius
610,000
24
13
8
Pavels Spirins
500,000
20
Player
Chips
Progress
Priit Parmasto
1,600,000
1,053,000
Yanis Mehdi Sahli
1,150,000
698,000
Sergejs Korobovs
1,100,000
595,000
Oskars Gailums
1,017,000
183,000
Vladimir Iljunin
770,000
718,000
Eirik Kristiansen
760,000
568,000
Ignas Vaitulionis
758,000
133,000
Victor Fernandez Garcia
750,000
527,000
Dainius Antanaitis
629,000
429,000
Gintaras Naglius
615,000
480,000
Davide Muccini
557,000
244,000
Jari-Pekka Juhola
520,000
41,000
Paul Koppe
490,000
685,000
Pavels Spirins
475,000
355,000
Mikael Niemela
471,000
51,000
Timo Laiho
405,000
223,000
Ranno Sootla
405,000
45,000
Taago Tamm
395,000
104,000
Nemo Vilpponen
115,000
106,000
Richard Koppel
0
0
Break Time Posted Saturday 4th March, 2023 at 17:02(UTC+2) by Jason Glatzer
Players are now on a short break. Blinds will increase to 8,000/16,000 with a big blind ante of 16,000 when the action resumes. We will update some of the bigger stacks around the room during the break.
Free VIP Dinner for High Rollers Posted Saturday 4th March, 2023 at 16:46(UTC+2) by Jason Glatzer
The €3,000 High Roller is already up to 41 entries with late registration open for around 3 more hours.
Teresa Nousiainen just reminded players that the High Rollers will be treated to a special VIP dinner during the dinner break.
So far, just two players have hit the rail in the High Roller including Igor Pihela Sr. and Juho Suutari. Suutari has thus far not re-entered, while Pihela Sr. is already back in action. His son, Igor Pihela Jr. is also in the mix as is GGPoker Ambassador Niall Farrell.
Meanwhile, the action has slowed down some after a fury of eliminations in the Main Event after the bubble broke and there are still 48 players remaining.
Players Cashing for €2,500 Posted Saturday 4th March, 2023 at 16:23(UTC+2) by Jason Glatzer
Giada Fang was among the players to recently hit the rail. This means that Anna-Mari Hursti is the last lady standing in the Main Event. Here is a look at everyone that cashed in the Main Event for €2,500.
Place
Player
Prize
49
Giada Fang
€ 2,500
50
Toni Ylitervo
€ 2,500
51
Steven Tool
€ 2,500
52
Federico Cirillo
€ 2,500
53
Jari Mahonen
€ 2,500
54
Kasparas Klezys
€ 2,500
55
Mika Levaniemi
€ 2,500
56
Juri Vassin
€ 2,500
Player
Chips
Progress
Steven Tool
0
0
Toni Ylitervo
0
0
Giada Fang
0
0
End of the Line for Mahonen Posted Saturday 4th March, 2023 at 16:14(UTC+2) by Jason Glatzer
Main Event Day 3 Level 20: 6,000/12,000 (12,000) Entries: 50/716
Jari Mahonen was short all day despite getting a few jams through. Unfortunately, time ran out for Mahonen after he jammed his short stack with only to run into the help by Roope.
Meanwhile, Federico Cirillo lost his short stack at around the same time.
Player
Chips
Progress
Roope Holma
450,000
92,000
Juri Vassin
0
0
Mika Levaniemi
0
0
Kasparas Klezys
0
0
Federico Cirillo
0
0
Jari Mahonen
0
0
Gailums Heard Around the Room Posted Saturday 4th March, 2023 at 16:10(UTC+2) by Jason Glatzer
Main Event Day 3 Level 20: 6,000/12,000 (12,000) Entries: 56/716
We didn't see the exact amounts but here is the gist of the action of a massive hand. Ranno Sootla opened, Federico Cirillo three-bet, Oskars Gailums four-bet, and Sootla cold-called. Cirillo five-bet jammed for more than 600,000. Gailums called for about 550,000 and Sootla folded.
Oskar Gailums: Federico Cirillo:
Gailums was screaming as he won the flip after the runout improved him to a set to beat Cirillo's top pair. He screamed for about a minute after the hand was over including being verbally aggressive toward Sootla. Apparently, he didn't like folding big hands to Sootla earlier today and shouted that loud enough for the entire room to hear. Sootla took it all well.
Player
Chips
Progress
Oskars Gailums
1,200,000
698,000
Ranno Sootla
360,000
254,000
Federico Cirillo
85,000
427,000
16:00 (UTC+2)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Players Cashing for €2,300 Posted Saturday 4th March, 2023 at 16:00(UTC+2) by Jason Glatzer
Place
Player
Prize
57
Michailas Miserkejevas
€ 2,300
58
Adomas Juozapavicius
€ 2,300
59
Verneri Hakkinen
€ 2,300
60
Anatoly Filatov
€ 2,300
61
Gints Ozols
€ 2,300
62
Julius Tiihonen
€ 2,300
63
Marco Regonaschi
€ 2,300
64
Walter Treccarichi
€ 2,300
65
Rokas Barzdzius
€ 2,300
66
Arminas Nemeika
€ 2,300
67
Carl Gustafsson
€ 2,300
68
Saulius Tumosa
€ 2,300
69
Gytis Bernatavicius
€ 2,300
70
Paulius Vaitiekunas
€ 2,300
71
Grigorijus Vasilavicius
€ 2,300
72
Tomas Kirchovas
€ 2,300
Player
Chips
Progress
Michailas Miserkejevas
0
0
Filatov Sent Packing at the TV Table Posted Saturday 4th March, 2023 at 15:41(UTC+2) by Jason Glatzer
Main Event Day 3 Level 19: 5,000/10,000 (10,000) Entries: 57/716
We just learned the GGPoker Ambassador and all-around poker boss Anatoly Filatov hit the rail at the TV table.
This is as far as the spoiler will go as you will need to check out the stream in about 20 minutes to see how he hit the rail. You can find the stream at the Kings of Tallinn website via Live Stream in the menu or at Main Event Travel.
Player
Chips
Progress
Gints Ozols
0
0
Adomas Juozapavicius
0
0
Anatoly Filatov
0
0
Posted Saturday 4th March, 2023 at 15:37(UTC+2) by Jason Glatzer
Main Event Day 3 Level 19: 5,000/10,000 (10,000) Entries: 58/716
Ignas Vaitulionis opened the button for 22,000 before he called a three-bet shove for about seven big blinds by Verneri Hakkinen.
Verneri Hakkinen: Ignas Vaitulionis:
Hakkinen got out of his chair after Vaitulionis improved to trips on the flop. He was still alive after the turn but needed a six on the river. No six came. Instead the river sealed the deal for Vaitulionis to eliminate Hakkinen.
Player
Chips
Progress
Ignas Vaitulionis
625,000
369,000
Verneri Hakkinen
0
0
€3K High Roller Begins Posted Saturday 4th March, 2023 at 15:23(UTC+2) by Jason Glatzer
The six-max €3,000 High Roller has kicked off with a tidy field of 12 entries. This will grow throughout the day by a bit with more players saying they would come but will join late to the media yesterday.
Aki Pyysing, Jaana Kindsigo, Uri Gilboa, Sondre Stormyr, and Justas Brazlauskis are among the early participants in the High Roller.
Good luck to all of the High Rollers!
Recent Eliminations Posted Saturday 4th March, 2023 at 15:20(UTC+2) by Jason Glatzer
Main Event Day 3 Level 19: 5,000/10,000 (10,000) Entries: 61/716
Players are hitting the rail at a fast and furious pace since the money bubble broke. Here is a look at the latest casualties:
Player
Chips
Progress
Arminas Nemeika
0
0
Rokas Barzdzius
0
0
Walter Treccarichi
0
0
Marco Regonaschi
0
0
Julius Tiihonen
0
0
Ostrovskij Ousts Barzdzius Posted Saturday 4th March, 2023 at 15:17(UTC+2) by Jason Glatzer
Main Event Day 3 Level 19: 5,000/10,000 (10,000) Entries: 66/716
Albert Ostrovskij min-raised the button before Rokas Barzdzius three-bet jammed for about 125,000 from the big blind. Ostrovskij tanked for less than a minute before he called.
Rokas Barzdzius: Albert Ostrovskij:
Both players improved to the same two-pair on the board. Ostrovskij's ace-kicker got the job done and he eliminated Barzdzius.
Player
Chips
Progress
Albert Ostrovskij
415,000
223,000
Antti Vetelainen
130,000
130,000
Tomas Kirchovas
0
0
Grigorijus Vasilavicius
0
0
Paulius Vaitiekunas
0
0
Gytis Bernatavicius
0
0
Saulius Tumosa
0
0
Queens of Tallinn Begins Posted Saturday 4th March, 2023 at 15:05(UTC+2) by Jason Glatzer
The Queens of Tallinn featuring a €120 buy-in has kicked off with 37 ladies in their seats including our host Laura Cornelius. Also in action are Kairit Leibold, Catlin Müür, Siiri Saar, Giedre Stapulioniene, Kelly Limonova, Evely Pihela, Christel Piller, and Airin Pindis, who recently busted the Main Event in the money.
Best of luck to all the ladies!
15:02 (UTC+2)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Break Time Posted Saturday 4th March, 2023 at 14:41(UTC+2) by Jason Glatzer
Players are on a short break. The blinds will increase to 5,000/10,000 with a 10,000 big blind ante when the action resumes.
Min Cashes Posted Saturday 4th March, 2023 at 14:33(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 72/716
The following players min-cashed the Main Event for €2,100.
Place
Player
Prize
73
Dmitrijs Arsuns
€ 2,100
74
Aleksandr Kuperman
€ 2,100
75
Irmantas Bzeskis
€ 2,100
76
Luca Sebastiani
€ 2,100
77
Deniss Davodov
€ 2,100
78
Martin Piik
€ 2,100
79
Mairo Tori
€ 2,100
80
Keito Kaljulaid
€ 2,100
81
Airin Pindis
€ 2,100
82
Daragh Davey
€ 2,100
83
Albert Jonsson
€ 2,100
84
Jon Ander Martinez
€ 2,100
85
Arto Mansner
€ 2,100
86
Theophile George
€ 2,100
87
Tomas Pinkevicius
€ 2,100
Player
Chips
Progress
Tomas Pinkevicius
0
0
Aleksandr Kuperman
0
0
Irmantas Bzeskis
0
0
Luca Sebastiani
0
0
Deniss Davodov
0
0
Martin Piik
0
0
Mairo Tori
0
0
Keito Kaljulaid
0
0
Airin Pindis
0
0
Daragh Davey
0
0
Albert Jonsson
0
0
Jon Ander Martinez
0
0
Arto Mansner
0
0
Theophile George
0
0
Dmitrijs Arsuns
0
0
Davodov Survives Bubble With Cowboys Posted Saturday 4th March, 2023 at 14:10(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 87/716 Bubble Hand #14- Showdown #9
Deniss Davodov got his short stack in with a three-bet from the big blind with on the same hand that Juhana Konttinen bubbled on and was called by the start of the day chip leader Pavels Spirins with .
The action was paused while the other hand was played out but Davodov celebrated soon after when his cowboys not only held but improved to a flush on the board.
Congrats to all players for being in the money.
Player
Chips
Progress
Pavels Spirins
830,000
38,000
Deniss Davodov
65,000
16,000
Juhana Konttinen Bubbles Main Event Posted Saturday 4th March, 2023 at 14:06(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 87/716 Bubble Hand #14 - Showdown #8
Juhana Konttinen jammed from under the gun for 14,000 and was called by Kai Lehto from the big blind.
Juhana Konttinen: Kai Lehto:
We will give away a spoiler as there were two all-ins and calls at two different tables but this is the one that led to players being in the money.
Konttinen lost to Lehto's trips after the runout to bubble the Main Event. He did not use Luxon Pay to enter. If he did, he would have had bubble protection.
Player
Chips
Progress
Pavels Spirins
830,000
38,000
Deniss Davodov
65,000
16,000
Posted Saturday 4th March, 2023 at 14:02(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 88/716 Bubble Hand #13 - Showdown #6
Toni Ylitervo had his last 121,000 committed with and was up against the by Tomas Kirchovas.
The board was safe for Ylitervo to stay alive and double.
Player
Chips
Progress
Toni Ylitervo
250,000
31,000
Tomas Kirchovas
100,000
80,000
Posted Saturday 4th March, 2023 at 14:00(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 88/716 Bubble Hand #13 - Showdown #5
Lari Pukkila limped the button before Paul Koppe raised from the small blind. Tomas Pinkevicius already had his stack committed when posting the big blind and Pukkila folded.
Tomas Pinkevicius: Paul Koppe:
The runout allowed Pinkevicius to stay alive and double his short stack.
Player
Chips
Progress
Paul Koppe
1,175,000
75,000
Tomas Pinkevicius
32,000
7,000
Posted Saturday 4th March, 2023 at 13:48(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 88/716 Bubble Hand #12 - Showdown #4
Steven Tool jammed without looking at his cards from the button for 160,000. Anna-Mari Hursti actually looked at her cards before she opted to call off her stack of 61,000.
Anna-Mari Hursti: Steven Tool:
The board was safe for Hursti's big slick to double her stack instead of hitting the rail short of the money.
Player
Chips
Progress
Anna-Mari Hursti
138,000
9,000
Steven Tool
100,000
7,000
Full House for Nurmisto Posted Saturday 4th March, 2023 at 13:33(UTC+2) by Jason Glatzer
Main Event Day 3 Level 18: 4,000/8,000 (8,000) Entries: 88/716 Bubble Hand #9 - Showdown #3
Niki Nurmisto four-bet jammed from the hijack and was called by Adria Comas I Roura from the small blind.
Niki Nurmisto: Adria Comas I Roura:
Nurmisto won the flip after improving to a full house on the board.
Player
Chips
Progress
Niki Nurmisto
690,000
257,000
Adria Comas I Roura
100,000
231,000
13:23 (UTC+2)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Turn Saves Garrido Posted Saturday 4th March, 2023 at 13:18(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 88/716 Bubble Hand #7 - Showdown #2
Arminas Nemeika jammed for nearly 300,000 from the button before Ignacio Garrido called off his stack of 146,000 from the small blind.
Ignacio Garrido: Arminas Nemeika:
It was looking like showers for Garrido after Nemeika paired the flop. However the Spanish rail went crazy after Garrido had his opponent drawing dead on the turn. The river further improved Garrido to a full house to double on the bubble.
Player
Chips
Progress
Ignacio Garrido
300,000
92,000
Arminas Nemeika
115,000
100,000
"I Have Two Flush Draws" Posted Saturday 4th March, 2023 at 13:10(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 88/716
On the fifth bubble hand, Jani Tuovinen min-raised the hijack before Anatoly Filatov jammed the button for 270,000. Tuovinen called off for 110,000 and it took a few minutes for the other tables to play out their hands before we saw the first all-in and call.
Jani Tuovinen: Anatoly Filatov:
"I have two flush draws," joked Filatov.
"That is bad," responded Tuovinen with a smile.
The came on the flop before Tuovinen improved to a set on the turn.
"That is boring," Filatov said while filming the hand after he was drawing dead.
The river completed the board for Tuovinen to survive the bubble and double his stack.
Player
Chips
Progress
Jani Tuovinen
240,000
22,000
Anatoly Filatov
150,000
78,000
Hand-For-Hand Posted Saturday 4th March, 2023 at 12:42(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 88/716
Seppo Parkkinen just hit the rail leaving 88 players remaining in the field. The action has gone hand-for-hand on the money bubble with the top 87 players collecting at least a €2,100 min-cash.
Player
Chips
Progress
Seppo Parkkinen
0
0
Koppe Sends Bytautas Packing Posted Saturday 4th March, 2023 at 12:38(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 89/716
Paul Koppe opened from early position and was called by Dainius Antanaitis from late position. Lukas Bytautas three-bet from the big blind and got called by both players.
Bytautas fired out for 26,000 on the flop and both players called. He then jammed for 55,000 on the turn and once again both players called.
The river was checked down. Bytautas turned over but this didn't get the job done with Koppe winning the hand with for a straight. Antanaitis held which also would have sent Bytautas package with two pair had Koppe not been in the hand.
Player
Chips
Progress
Paul Koppe
1,100,000
255,000
Dainius Antanaitis
200,000
6,000
Lukas Bytautas
0
0
Niemela Gets His Queen Posted Saturday 4th March, 2023 at 12:28(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 89/716
Justas Vaiciulionis jammed for less than 10 big blinds from early position and was called by Mikael Niemela from the big blind.
Justas Vaiciulionis: Mikael Niemela:
The flop was safe for Vaiciulonis. The turn paired the board.
"Queen!" Niemela said.
Niemela was perhaps a fortune teller as the river paired the board for Niemela to win the hand with his ten kicker against his opponent's seven kicker and Vaiciulionis was on the rail before the money.
Player
Chips
Progress
Mikael Niemela
420,000
41,000
Justas Vaiciulionis
0
0
Shehadeh Free for the High Roller Posted Saturday 4th March, 2023 at 12:22(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 91/716
Miko Miettinen opened to 12,000 from the button. Luigi Shehadeh three-bet jammed to 114,000 from the big blind and Miettinen called.
Luigi Shehadeh: Miko Miettinen:
Shehadeh bricked the board and was eliminated before the money.
"Good game," Shehadeh told the table before leaving.
Shehadeh shared with the media that he plans to play the €3,000 High Roller later today. We have really enjoyed the company of all the Italian players that have made it to Tallinn and wish Shehadeh the best of luck.
Player
Chips
Progress
Miko Miettinen
370,000
109,000
Luigi Shehadeh
0
0
Posted Saturday 4th March, 2023 at 12:13(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 92/716
Hanno Kerem called a three-bet jam from the button by Joni Rantamaki from the big blind for about 15 big blinds.
Joni Rantamaki: Hanno Kerem:
The double-paired board didn't help Rantamaki's jacks get ahead of aces and he was out before the bubble.
Player
Chips
Progress
Hanno Kerem
250,000
94,000
Joni Rantamaki
0
0
Cards in the Air Posted Saturday 4th March, 2023 at 12:02(UTC+2) by Jason Glatzer
Main Event Day 3 Level 17: 3,000/6,000 (6,000) Entries: 93/716
Cards are in the air for Day 3 with the action six off the money bubble.
Pavel Spirins Leads Final 93 in the Record-Breaking 2023 Kings of Tallinn Main Event Posted Saturday 4th March, 2023 at 10:42(UTC+2) by Jason Glatzer
The 2023 Kings of Tallinn €1,100 Main Event is the new gold standard for the festival and perhaps for poker festivals around the Baltics. The event attracted a banner field of 716 entries to generate a whopping €673,040 prize pool.
This not only smashed the lofty €500,000 guarantee but also set a new record for the Kings of Tallinn, previously beating the 674 entries in 2020 when Johan Karlsson won the event for €120,100 after agreeing to a heads-up deal with Ermo Kosk. This is also the third largest poker tournament in Estonian history with just the two EPT Tallinn events that took place more than a decade ago creating bigger prize pools with the assistance of bigger buy-ins.
The field is down to just 93 hopefuls in the hunt for the title with the money bubble looming early on Day 3 thanks to the event paying the top 87 players at least a €2,100 min-cash. The eventual winner on Sunday will take home much more with a €140,100 top prize on the line.
Latvia’s Pavel Spirins is in the driver’s seat to start the day with a chip-leading stack of 868,000 with Paul Koppe (845,000) as the only other player above 800,000 to start the day.
However, there are many other players to keep your eyes peeled on including WSOP bracelet winner Ranno Sootla, who resides in third place. Sootla is already in the Kings of Tallinn history books after winning the inaugural Kings of Tallinn Main Event in 2015 and is looking to become the first two-time champion.
Another player to watch out for is GGPoker Ambassador Anatoly Filatov, who has called Tallinn his home in recent times and lives not too far from the casino. Filatov, who normally plays events with much bigger buy-ins and is well-known as one of the best players in the world, is in the middle of the pack with 228,000.
Today will play down to an official final table. So expect a longer day than yesterday. This is subject to change depending on how the tournament flows.
See you at noon when cards are in the air and check out the seat draw in the post below.
Day 3 Seat Draw Posted Saturday 4th March, 2023 at 10:37(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Kasparas Klezys
534,000
89
1
2
Gints Ozols
130,000
22
1
3
Tomas Kirchovas
180,000
30
1
4
Antti Veteläinen
320,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 Juozapavicius
174,000
29
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
149,000
25
3
4
Davide Muccini
313,000
52
3
5
Linus Lauermann
184,000
31
3
6
Michailas Miserkejevas
242,000
40
3
7
Sergejs Korobovs
505,000
84
3
8
Juhana Konttinen
96,000
16
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
Timo Petteri Laiho
182,000
30
6
8
Francisco Racionero
172,000
29
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
19
8
4
Adria Comas I 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
11
1
Jon Ander Martinez
92,000
15
11
2
Javier Moya
427,000
71
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
479,000
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-Khazraji
362,000
60
12
8
Paulius Vaitiekunas
269,000
45
13
1
Jari Mähönen
98,000
16
13
2
Gytis Bernatavicius
142,000
24
13
3
Steven Tool
93,000
16
13
4
Aleksandr Kuperman
89,000
15
13
5
Anna-Mari Hursti
129,000
22
13
6
Vladimir Iljunin
52,000
9
13
7
Gintaras Naglius
135,000
23
13
8
Saulius Tumosa
73,000
12
14
1
Juri Vassin
185,000
31
14
2
Seppo Parkkinen
72,000
12
14
3
Shiyan Fang
153,000
26
14
4
Roope Holma
358,000
60
14
5
Albert Jonsson
122,000
20
14
6
Marco Regonaschi
96,000
16
14
7
Vu Vuong
286,000
48
14
8
Keito Kaljulaid
114,000
19
18
1
Airin Pindis
71,000
12
18
2
Ranno Sootla
614,000
102
18
3
Federico Cirillo
512,000
85
18
4
Ignas Vaitulionis
256,000
43
18
5
Verneri Häkkinen
197,000
33
18
6
Martin Piik
175,000
29
18
7
Magnus Pukk
290,000
48
18
8
Taago Tamm
291,000
49
19
1
Victor Fernandez Garcia
223,000
37
19
2
Arminas Nemeika
215,000
36
19
3
Ignacio Garrido
208,000
35
19
4
Deniss Davõdov
81,000
14
19
5
Yanis Mehdi Sahli
452,000
75
19
6
Mart Kalju
88,000
15
19
7
Irmantas Bzeskis
149,000
25
19
8
Pavels Spirins
868,000
145
10:36 (UTC+2)
Day 3 of King of Tallinn 2023 Started Level: 17 Blinds: 3,000/6,000 Ante: 6,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.
board was no good for Nurmisto.
flop and Vaitulionis check-called. Vaitulionis checked again on the 
turn. Vuong jammed for about 450,000 and Vaitulionis wasted no time in finding a call.
didn't save Vuong on the river and the action was down to just 10 players.
flop and never looked back with the 
turn and 
board didn't provide Vaitulionis any magic to beat pocket rockets and for the second time this blind level he doubled his stack.
board to eliminate Sahli with two pair. There will be a short delay in the action while the redraw is taking place.
came on the flop before Antanaitis tapped on the table designating "good game" on the 
river completed the board and Antanaitis stood up to shake Vilpponen's hand showing good sportsmanship as the dealer shipped him the pot.
ran out on the board and Pukkil was eliminated in 23rd place.
turn and 
ran out on the board for Parmasto to eliminate both Niemela and Lauermann.
turn and 
£ GBP
$ USD
€ EUR
