0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0075 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/2/updates'
ORDER BY `views` DESC
0.0114 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2023_kot_championship_eng/2/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0036 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2023_kot_championship_eng'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '11'
0.0294 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '37'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '38'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '39'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '48'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '11'
AND `name` = '2'
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '48'
ORDER BY `busted` ASC, `current_chips` DESC
0.0070 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` = '48'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2773'
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` = '2137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2136'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2135'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2132'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2130'
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` = '2129'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2126'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2124'
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` = '2123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2117'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2110'
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` = '2108'
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` = '2106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2104'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2103'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2102'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2101'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2096'
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` = '2094'
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` = '2093'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2092'
ORDER BY `chip_change` DESC, `busted` ASC
0.0095 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2090'
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` = '2088'
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` = '2087'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2084'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2082'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2079'
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` = '2078'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2077'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2075'
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` = '2074'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2073'
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` = '2071'
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` = '2068'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2066'
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` = '2065'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2064'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2061'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2060'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2058'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2054'
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` = '2052'
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` = '2051'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2048'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2047'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2045'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2043'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2041'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2039'
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` = '2034'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2031'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2030'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2029'
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` = '2027'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2023'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2022'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2019'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2015'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2014'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2012'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2010'
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` = '2008'
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` = '2007'
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` = '2006'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2002'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2000'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1998'
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` = '1997'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1993'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1991'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1989'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1986'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1985'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1984'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1982'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1977'
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` = '1976'
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` = '1973'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1972'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1971'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1970'
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` = '1967'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1964'
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` = '1962'
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` = '1961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1958'
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` = '1955'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1954'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1951'
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` = '1949'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1947'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1943'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1940'
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` = '1939'
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` = '1938'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1930'
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` = '1928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1927'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '37'
ORDER BY `busted` ASC, `current_chips` DESC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '48'
ORDER BY `busted` ASC, `current_chips` DESC
0.0107 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` = '48'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2773'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2137'
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` = '2136'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2135'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2132'
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` = '2131'
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` = '2130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2129'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2126'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0294 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2117'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0269 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2109'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2108'
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` = '2106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2104'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2103'
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` = '2102'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2101'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2096'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2094'
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` = '2093'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2092'
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` = '2090'
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` = '2088'
ORDER BY `chip_change` DESC, `busted` ASC
0.0296 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2087'
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` = '2084'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2082'
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` = '2079'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2078'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2077'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2075'
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` = '2074'
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` = '2073'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2071'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2068'
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` = '2066'
ORDER BY `chip_change` DESC, `busted` ASC
0.0276 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2065'
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` = '2064'
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` = '2061'
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` = '2060'
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` = '2058'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2052'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2051'
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` = '2048'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2047'
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` = '2045'
ORDER BY `chip_change` DESC, `busted` ASC
0.0357 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2043'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2042'
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` = '2041'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2039'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2034'
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` = '2032'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2031'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2030'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2029'
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` = '2027'
ORDER BY `chip_change` DESC, `busted` ASC
0.0281 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2023'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2022'
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` = '2019'
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` = '2015'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2014'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '2012'
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` = '2010'
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` = '2008'
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` = '2007'
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` = '2006'
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` = '2002'
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` = '2000'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0278 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1997'
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` = '1995'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1994'
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` = '1993'
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` = '1991'
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` = '1989'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1986'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1985'
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` = '1984'
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` = '1982'
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` = '1977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1976'
ORDER BY `chip_change` DESC, `busted` ASC
0.0274 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1973'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1972'
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` = '1971'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1970'
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` = '1967'
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` = '1964'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1962'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1961'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1958'
ORDER BY `chip_change` DESC, `busted` ASC
0.0106 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1955'
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` = '1954'
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` = '1951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1949'
ORDER BY `chip_change` DESC, `busted` ASC
0.0114 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1948'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1947'
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` = '1943'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1939'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1938'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1936'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1934'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1931'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0109 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1928'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1927'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '1926'
ORDER BY `chip_change` DESC, `busted` ASC
0.0114 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '48'
ORDER BY `busted` ASC, `current_chips` DESC
0.0006 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.
Day 2 of King of Tallinn 2023 Ended Level: 31 Blinds: 75,000/150,000 Ante: 150,000
Full Payouts of the €555 Championship Posted Wednesday 1st March, 2023 at 05:16(UTC+2) by Jason Glatzer
Place
Player
Prize
1
Benjamin Gros
€ 55,500
2
Rokas Barzdzius
€ 37,500
3
Tarmo Tammel
€ 22,200
4
Paulius Vaitiekunas
€ 16,200
5
Zydrunas Karcemarskas
€ 12,700
6
Alger Pissarev
€ 9,540
7
Juuso Kauppi
€ 7,000
8
Janne Ojala
€ 4,790
9
Luigi Shehadeh
€ 3,420
10
Amin Asikainen
€ 3,420
11
Giovanni Nava
€ 3,420
12
Yanis Sahli
€ 3,420
13
Arkadiusz Liszewski
€ 2,210
14
Juuso Elsinen
€ 2,210
15
Giada Fang
€ 2,210
16
Yaniv Peretz
€ 2,210
17
Julien Fuchs
€ 1,910
18
Ranno Sootla
€ 1,910
19
Aleksi Naski
€ 1,910
20
Priit Vanem
€ 1,910
21
Joakim Brochard
€ 1,910
22
Eeti Loyttyniemi
€ 1,910
23
Hanno Kerem
€ 1,910
24
Igor Pihela Jr.
€ 1,910
25
Allesandro Giordano
€ 1,660
26
Raiki Reinsoo
€ 1,660
27
Ari Varonen
€ 1,660
28
Juris Hlibovs
€ 1,660
29
Renaldas Mankauskas
€ 1,660
30
Stefan Bittger
€ 1,660
31
Max Rotko
€ 1,660
32
Jevgenijs Kritinins
€ 1,660
33
Madis Muur
€ 1,460
34
Davide Muccini
€ 1,460
35
Sondre Lunde
€ 1,460
36
Tomi Arponen
€ 1,460
37
Matias Knaapinen
€ 1,460
38
Martin Piik
€ 1,460
39
Kimmo Matias Kurko
€ 1,460
40
Gytis Bernatavicius
€ 1,460
41
Timo Ruuska
€ 1,320
42
Iiro Kettunen
€ 1,320
43
Jaakko Tirkkonen
€ 1,320
44
Lasse Enojarvi
€ 1,320
45
Harald Redl
€ 1,320
46
Jari Karkkainen
€ 1,320
47
Maksim Petrov
€ 1,320
48
Anthony Jay Kauzloric
€ 1,320
49
Armin Abniki
€ 1,200
50
Kalle Saarinen
€ 1,200
51
Sergei Guljajev
€ 1,200
52
Matti Lasanen
€ 1,200
53
Jari Hurri
€ 1,200
54
Krzysztof Budka
€ 1,200
55
Kaspars Mallons
€ 1,200
56
Henri Pietari Wagner
€ 1,200
57
Indre Martoviciute
€ 1,100
58
Henri Mikael Schalin
€ 1,100
59
Mart Rinken
€ 1,100
60
Justas Semaska
€ 1,100
61
Laurynas Cerniauskas
€ 1,100
62
Kaupo Tenno
€ 1,100
63
Vygerdas Jonikas
€ 1,100
64
Kalle Aberg
€ 1,100
65
Johan Martinsen
€ 1,000
66
Reinis Reinbergs
€ 1,000
67
Michael Ibba
€ 1,000
68
Mathias H. M. Siljander
€ 1,000
69
Jose Larios Domene
€ 1,000
70
Stanislovas Vinicenka
€ 1,000
71
Michailas Miserkejevas
€ 1,000
Rokas Barzdzius Eliminated in 2nd Place (€37,500) Posted Wednesday 1st March, 2023 at 05:15(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 31: 75,000/150,000 (150,000) Entries: 1/559
The €555 Championship has crowned a winner after 17 hours of play. The final hand went as follows.
Benjamin Gros limped from the small blind. Rokas Barzdzius jammed for about 10 big blinds from the big blind and Gros snap-called.
Rokas Barzdzius: Benjamin Gros:
It was a fitting way to end a dominating performance by Gros. The board held no surprise and Barzdzius was ousted one player shy of a victory in second place for €37,500.
Meanwhile, congrats to Benjamin Gros for shipping the €555 Championship for €55,500.
We will post the final payouts shortly. However, the recap will come tomorrow due to the late hour in the evening. Thank you for tuning in and see you tomorrow for Day 1a of the €500,000 guaranteed Kings of Tallinn €1,100 Main Event.
Player
Chips
Progress
Benjamin Gros
16,770,000
3,245,000
Rokas Barzdzius
0
0
Tarmo Tammel Eliminated in 3rd Place (€22,200) Posted Wednesday 1st March, 2023 at 04:50(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 31: 75,000/150,000 (150,000) Entries: 2/559
Tarmo Tammel open-jammed for about a dozen big blinds from the small blind and was called by Benjamin Gros from the big blind.
Tarmo Tammel: Benjamin Gros:
Tammel asked his large rail to yell out for cards he need but this didn't give him the luck he needed to win the flip as he got nowhere on the board.
Player
Chips
Progress
Benjamin Gros
13,525,000
2,725,000
Rokas Barzdzius
3,250,000
250,000
Tarmo Tammel
0
0
Barzdzius Gets There With Ace-Nine Posted Wednesday 1st March, 2023 at 04:47(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 31: 75,000/150,000 (150,000) Entries: 3/559
Benjamin Gros opened for a min-raise on the button before Rokas Barzdzius three-bet jammed for about 10 big blinds from the small blind. Gros quickly called and the cards were turned over.
Rokas Barzdzius: Benjamin Gros:
Barzdzius doubled up after his nine found a friend on the for a better two pair than Gros.
Player
Chips
Progress
Benjamin Gros
10,800,000
3,000,000
Rokas Barzdzius
3,000,000
975,000
Posted Wednesday 1st March, 2023 at 04:34(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 31: 75,000/150,000 (150,000) Entries: 3/559
Rokas Barzdzius jammed from the cutoff for 900,000. Paulius Vaitiekunas called off his stack of 775,000 from the button and the rest of the table folded.
Paulius Vaitiekunas: Rokas Barzdzius:
Vaitiekunas had a reason for some hope on the flop with both his overcards live as well as holding an open-ended straight draw. He bricked the turn and the river and the action was down to just three players.
Player
Chips
Progress
Rokas Barzdzius
2,025,000
800,000
Paulius Vaitiekunas
0
0
04:26 (UTC+2)
Start of Level 31 Blinds: 75,000/150,000 Ante: 150,000
Posted Wednesday 1st March, 2023 at 04:26(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 30: 50,000/125,000 (125,000) Entries: 4/559
Benjamin Gros jammed from the small blind. Rokas Barzdzius called off his short stack of 550,000 from the big blind.
Rokas Barzdzius: Benjamin Gros:
Barzdzius doubled after Gros bricked the board.
Player
Chips
Progress
Benjamin Gros
7,800,000
500,000
Rokas Barzdzius
1,225,000
1,275,000
Zydrunas Karcemarskas Eliminated in 5th Place (€12,700) Posted Wednesday 1st March, 2023 at 04:11(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 30: 50,000/125,000 (125,000) Entries: 4/559
Benjamin Gros jammed from the cutoff. Zydrunas Karcemarskas had one single 25,000 chip behind after posting the big blind ante and the big blind and made the call.
Zydrunas Karcemarskas: Benjamin Gros:
Karcemarskas was unable to get ahead on the board and there were just four players remaining after he hit the rail.
Player
Chips
Progress
Benjamin Gros
8,300,000
2,400,000
Zydrunas Karcemarskas
0
0
Alger Pissarev Eliminated in 6th Place (€9,540) Posted Wednesday 1st March, 2023 at 04:06(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 30: 50,000/125,000 (125,000) Entries: 5/559
Alger Pissarev opened for 250,000 with about the same behind from under the gun. Paulius Vaitiekunas three-bet shoved to put Pissarev in for the rest. Pissarev snap-called and the hands were turned over.
Alger Pissarev: Paulius Vaitiekunas:
Pissarev pulled out ahead on the flop and was still ahead on the turn. However, the river counterfeited his two pair with both players now having aces over queens. Vaitiekunas's king came into play as the best kicker and Pissarev wished the table a good game on his way out of the room.
Player
Chips
Progress
Paulius Vaitiekunas
1,900,000
475,000
Alger Pissarev
0
0
Unscheduled Break Posted Wednesday 1st March, 2023 at 03:54(UTC+2) by Jason Glatzer
The action went on a short break with a few of the players asking to stop the clock.
Vaitiekunas Back in Business Posted Wednesday 1st March, 2023 at 03:44(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 30: 50,000/125,000 (125,000) Entries: 6/559
Paulius Vaitiekunas just got the breathing room he was looking for. Moments ago he was down to just 200,000 in chips and now has more than 1.4 million.
Benjamin Gros jammed the button with and was called by Vaitiekunas with .
Vaitiekunas began singing as the ran out on the board to earn his third double up in the last 20 minutes.
Player
Chips
Progress
Benjamin Gros
5,900,000
100,000
Paulius Vaitiekunas
1,425,000
675,000
03:40 (UTC+2)
Start of Level 30 Blinds: 50,000/125,000 Ante: 125,000
Another Short Stack Double for Vaitiekunas Posted Wednesday 1st March, 2023 at 03:40(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 29: 50,000/100,000 (100,000) Entries: 6/559
Paulius Vaitiekunas jammed the cutoff for 3 big blinds and was called by Tarmo Tammel from the big blind.
Paulius Vaitiekunas: Tarmo Tammel:
It wasn't until the river did Vaitiekunas won the flip with the running out on the board.
Player
Chips
Progress
Tarmo Tammel
5,700,000
300,000
Paulius Vaitiekunas
750,000
200,000
"Let's Go!" Posted Wednesday 1st March, 2023 at 03:32(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 29: 50,000/100,000 (100,000) Entries: 6/559
Paulius Vaitiekunas was down to just two big blinds when he shoved from the cutoff with . Tarmo Tammel called from the big blind with .
Neither player held a premium hand but Vaitekunas's queen-high held on the runout to double his short stack.
Player
Chips
Progress
Tarmo Tammel
6,000,000
200,000
Paulius Vaitiekunas
550,000
100,000
Posted Wednesday 1st March, 2023 at 03:24(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 29: 50,000/100,000 (100,000) Entries: 6/559
Juuso Kauppi jammed for 1,050,000 from the cutoff and was called by Benjamin Gros from the button.
Juuso Kauppi: Benjamin Gros:
It was looking good for Kauppi to double after his ace paired on the flop. However, the turn improved Gros to a set of ladies. The river completed the board and Kauppi was ousted in seventh place.
Player
Chips
Progress
Benjamin Gros
6,000,000
900,000
Juuso Kauppi
0
0
Janne Ojala Eliminated in 8th Place (€4,790) Posted Wednesday 1st March, 2023 at 03:22(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 29: 50,000/100,000 (100,000) Entries: 7/559
Rokas Barzdzius opened for 200,000 from middle position. Janne Ojala called off his stack of 200,000 from two seats over and Juuso Kauppi called as well from the big blind.
Kauppi checked the flop. Barzdzius bet 175,000 and Kauppi folded.
Janne Ojala: Rokas Barzdzius:
Ojala was behind but had some hope with a flush draw. Neither the turn nor the river was of any help and he was eliminated to Barzdzius's full house in eighth place.
Player
Chips
Progress
Rokas Barzdzius
2,500,000
575,000
Janne Ojala
0
0
Full House for Tammel Posted Wednesday 1st March, 2023 at 03:18(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 29: 50,000/100,000 (100,000) Entries: 8/559
Zydrunas Karcemarskas limped from the small blind before Tarmo Tammel checked back his option from the big blind.
Karcemarskas bet 100,000 on the flop. Tammel called before both players checked the turn. The river completed the board. Karcemarskas fired out for 225,000. Tammel raised to 675,000. Karcemarskas called before he mucked his hand after seeing Tammel turn over for a full house.
Player
Chips
Progress
Tarmo Tammel
5,800,000
1,250,000
Zydrunas Karcemarskas
1,100,000
325,000
Updated Chip Counts Posted Wednesday 1st March, 2023 at 03:01(UTC+2) by Jason Glatzer
Player
Chips
Progress
Benjamin Gros
5,100,000
1,600,000
Tarmo Tammel
4,550,000
50,000
Rokas Barzdzius
1,925,000
345,000
Alger Pissarev
1,525,000
240,000
Juuso Kauppi
1,500,000
470,000
Zydrunas Karcemarskas
1,425,000
125,000
Janne Ojala
450,000
140,000
Paulius Vaitiekunas
450,000
1,050,000
02:59 (UTC+2)
Start of Level 29 Blinds: 50,000/100,000 Ante: 100,000
Posted Wednesday 1st March, 2023 at 02:50(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 28: 40,000/80,000 (80,000) Entries: 8/559
Zydrunas Karcemarskas three-bet jammed 600,000 and was called by Benjamin Gros.
Zydrunas Karcemarskas: Benjamin Gros:
Gros improved to trips on the runout. But Karcemarskas doubled anyway as he nailed a full house.
Players went on a quick break after the hand.
Player
Chips
Progress
Zydrunas Karcemarskas
1,300,000
90,000
Benjamin Gros
0
600,000
Luigi Shehadeh Eliminated in 9th Place (€3,420) Posted Wednesday 1st March, 2023 at 02:33(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 28: 40,000/80,000 (80,000) Entries: 8/559
Luigi Shehadeh was the first elimination at the final table. The Italian opened for 400,000 with about 200,000 behind from middle position and was cold-called by Tarmo Tammel from the button.
Shehadeh jammed the rest of his stack on the flop and Tammel called.
Luigi Shehadeh: Tarmo Tammel:
Shehadeh needed some help to stay alive. Unfortunately, the turn and the river didn't help and Shehadeh collected the ninth-place prize of €3,420.
A special thank you to the Giada Fang and the entire Italian rail for the much-needed pizza for the blogging team.
Player
Chips
Progress
Tarmo Tammel
4,500,000
560,000
Luigi Shehadeh
0
0
No Flops Posted Wednesday 1st March, 2023 at 02:21(UTC+2) by Jason Glatzer
There hasn't been a flop seen in at least an orbit. Players are playing a bit on the tighter side with the significant pay jumps on the line.
02:09 (UTC+2)
Start of Level 28 Blinds: 40,000/80,000 Ante: 80,000
Cowboys for Gros Posted Wednesday 1st March, 2023 at 01:58(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 27: 30,000/60,000 (60,000) Entries: 9/559
Paulius Vaitiekunas opened for 120,000 from under the gun. Benjamin Gros three-bet to 320,000 from the cutoff. Vaitiekunas four-bet to 585,000 and Gros called.
Vaitiekunas continued for 175,000 on the flop and Gros called. Both players checked down the turn and river.
Vaitiekunas turned over for a pair of fours. This was no match to the held by Gros, who was awarded the pot.
Player
Chips
Progress
Benjamin Gros
4,100,000
325,000
Paulius Vaitiekunas
1,500,000
715,000
Full Payouts Leading Into the FInal Table Posted Wednesday 1st March, 2023 at 01:32(UTC+2) by Jason Glatzer
Place
Player
Prize
10
Amin Asikainen
€ 3,420
11
Giovanni Nava
€ 3,420
12
Yanis Sahli
€ 3,420
13
Arkadiusz Liszewski
€ 2,210
14
Juuso Elsinen
€ 2,210
15
Giada Fang
€ 2,210
16
Yaniv Peretz
€ 2,210
17
Julien Fuchs
€ 1,910
18
Ranno Sootla
€ 1,910
19
Aleksi Naski
€ 1,910
20
Priit Vanem
€ 1,910
21
Joakim Brochard
€ 1,910
22
Eeti Loyttyniemi
€ 1,910
23
Hanno Kerem
€ 1,910
24
Igor Pihela Jr.
€ 1,910
25
Allesandro Giordano
€ 1,660
26
Raiki Reinsoo
€ 1,660
27
Ari Varonen
€ 1,660
28
Juris Hlibovs
€ 1,660
29
Renaldas Mankauskas
€ 1,660
30
Stefan Bittger
€ 1,660
31
Max Rotko
€ 1,660
32
Jevgenijs Kritinins
€ 1,660
33
Madis Muur
€ 1,460
34
Davide Muccini
€ 1,460
35
Sondre Lunde
€ 1,460
36
Tomi Arponen
€ 1,460
37
Matias Knaapinen
€ 1,460
38
Martin Piik
€ 1,460
39
Kimmo Matias Kurko
€ 1,460
40
Gytis Bernatavicius
€ 1,460
41
Timo Ruuska
€ 1,320
42
Iiro Kettunen
€ 1,320
43
Jaakko Tirkkonen
€ 1,320
44
Lasse Enojarvi
€ 1,320
45
Harald Redl
€ 1,320
46
Jari Karkkainen
€ 1,320
47
Maksim Petrov
€ 1,320
48
Anthony Jay Kauzloric
€ 1,320
49
Armin Abniki
€ 1,200
50
Kalle Saarinen
€ 1,200
51
Sergei Guljajev
€ 1,200
52
Matti Lasanen
€ 1,200
53
Jari Hurri
€ 1,200
54
Krzysztof Budka
€ 1,200
55
Kaspars Mallons
€ 1,200
56
Henri Pietari Wagner
€ 1,200
57
Indre Martoviciute
€ 1,100
58
Henri Mikael Schalin
€ 1,100
59
Mart Rinken
€ 1,100
60
Justas Semaska
€ 1,100
61
Laurynas Cerniauskas
€ 1,100
62
Kaupo Tenno
€ 1,100
63
Vygerdas Jonikas
€ 1,100
64
Kalle Aberg
€ 1,100
65
Johan Martinsen
€ 1,000
66
Reinis Reinbergs
€ 1,000
67
Michael Ibba
€ 1,000
68
Mathias H. M. Siljander
€ 1,000
69
Jose Larios Domene
€ 1,000
70
Stanislovas Vinicenka
€ 1,000
71
Michailas Miserkejevas
€ 1,000
Final Table Seat Draw Posted Wednesday 1st March, 2023 at 01:31(UTC+2) by Jason Glatzer
Place
Player
Chips
Big Blinds
1
Luigi Andrea Shehadeh
360,000
6
2
Paulius Vaitiekunas
2,215,000
37
3
Alger Pissarev
1,285,000
21
4
Zydrunas Karcemarskas
1,210,000
20
5
Tarmo Tammel
3,940,000
66
6
Juuso Kauppi
1,030,000
17
7
Benjamin Gros
3,775,000
63
8
Rokas Barzdzius
2,270,000
38
9
Janne Ojala
590,000
10
Player
Chips
Progress
Tarmo Tammel
3,940,000
260,000
Benjamin Gros
3,775,000
575,000
Rokas Barzdzius
2,270,000
270,000
Paulius Vaitiekunas
2,215,000
665,000
Alger Pissarev
1,285,000
60,000
Zydrunas Karcemarskas
1,210,000
510,000
Juuso Kauppi
1,030,000
270,000
Janne Ojala
590,000
910,000
Luigi Shehadeh
360,000
160,000
Posted Wednesday 1st March, 2023 at 01:17(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 27: 30,000/60,000 (60,000) Entries: 9/559
Players are on a short break before the final table begins. Amin Asikainen three-bet jammed for about six big blinds and was called by Benjamin Gros who opened from the cutoff.
Amin Asikainen: Benjamin Gros:
Asaikainen lost the flip and his stack after failing to connect with the board.
Player
Chips
Progress
Benjamin Gros
3,200,000
400,000
Amin Asikainen
0
0
01:13 (UTC+2)
Start of Level 27 Blinds: 30,000/60,000 Ante: 60,000
Cowboys for Tammel Posted Wednesday 1st March, 2023 at 01:05(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 26: 25,000/50,000 (50,000) Entries: 10/559
Luigi Shehadeh opened for 100,000 from the hijack before Tarmo Tammel three-bet to 315,000 from the button. Shehadeh jammed for more than 2 million. Tammel tanked for a moment before he called off his stack of 2,060,000.
Tarmo Tammel: Luigi Shehadeh:
Tammel celebrated after not only his kings held but improved to a set after the ran out on the board.
Player
Chips
Progress
Tarmo Tammel
4,200,000
2,255,000
Luigi Shehadeh
200,000
1,230,000
Posted Wednesday 1st March, 2023 at 00:57(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 26: 25,000/50,000 (50,000) Entries: 10/559
Amin Asikainen jammed from the button for 200,000 and was called by Benjamin Gros from the big blind.
Amin Asikainen: Benjamin Gros:
Asikainen was miles ahead and doubled his short stack after the ran out on the board.
Player
Chips
Progress
Benjamin Gros
2,800,000
350,000
Amin Asikainen
475,000
240,000
Posted Wednesday 1st March, 2023 at 00:55(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 26: 25,000/50,000 (50,000) Entries: 10/559
Rokas Barzdzius effectively jammed from the small blind. Giovanni Nava called off for about a dozen big blinds from the big blind.
Giovanni Nava: Rokas Barzdzius:
Barzdzius nailed the better pair on the board to eliminate Nava in 11th place.
Player
Chips
Progress
Rokas Barzdzius
2,000,000
500,000
Giovanni Nava
0
0
Straight for Gros to Oust Sahli Posted Wednesday 1st March, 2023 at 00:35(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 26: 25,000/50,000 (50,000) Entries: 11/559
The pot wasn't yet big when Benjamin Gros fired out for 100,000 on the board after the turn. Yanis Sahli shoved for about 500,000 and Gros called and Sahli was drawing dead.
Yanis Sahli: Benjamin Gros:
The river completed the board to give Gros the chip lead while sending Sahli to the cashier.
Player
Chips
Progress
Benjamin Gros
2,450,000
500,000
Yanis Mehdi Sahli
0
0
00:33 (UTC+2)
Start of Level 26 Blinds: 25,000/50,000 Ante: 50,000
Payouts for €2,210 Posted Wednesday 1st March, 2023 at 00:23(UTC+2) by Jason Glatzer
The following players cashed for €2,210. The final dozen have each locked up at least a €2,710 payout.
Place
Player
Prize
13
Arkadiusz Liszewski
€ 2,210
14
Juuso Elsinen
€ 2,210
15
Giada Fang
€ 2,210
16
Yaniv Peretz
€ 2,210
Posted Wednesday 1st March, 2023 at 00:20(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 25: 20,000/40,000 (40,000) Entries: 12/559
Janne Ojala opened for 80,000 from the button. Arkadiusz Liszewski three-bet shoved for around 400,000 from the small blind and Ojala quickly called.
Arkadiusz Liszewski: Janne Ojala:
Ojala's big slick held on the board to eliminate Lidzewski in 13th place.
Player
Chips
Progress
Janne Ojala
1,500,000
400,000
Arkadiusz Liszewski
0
0
Players Cashing for €1,910 Posted Wednesday 1st March, 2023 at 00:10(UTC+2) by Jason Glatzer
Place
Player
Prize
17
Julien Fuchs
€ 1,910
18
Ranno Sootla
€ 1,910
19
Aleksi Naski
€ 1,910
20
Priit Vanem
€ 1,910
21
Joakim Brochard
€ 1,910
22
Eeti Loyttyniemi
€ 1,910
23
Hanno Kerem
€ 1,910
24
Igor Pihela Jr.
€ 1,910
Posted Wednesday 1st March, 2023 at 00:08(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 25: 20,000/40,000 (40,000) Entries: 13/559
Alger Pissarev opened from the button before Benjamin Gros three-bet from the small blind. Juuso Elsinen four-bet jammed for about 10 big blinds. Pissarev folded and Gros called.
Juuso Elsinen: Benjamin Gros:
Elsinen headed to the cashier after not pulling ahead of cowboys on the runout.
Yaniv Peretz also recently hit the rail to leave just 13 hopefuls remaining for the title.
Player
Chips
Progress
Benjamin Gros
1,950,000
600,000
Yaniv Peretz
0
0
Juuso Elsinen
0
0
Fang Out on a Flip Posted Wednesday 1st March, 2023 at 00:06(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 25: 20,000/40,000 (40,000) Entries: 15/559
All the ladies are now out of the €555 Championship after Giada Fang hit the rail. She got her stack in with big slick and didn't win a flip against the sevens held by Juuso Kauppi.
Player
Chips
Progress
Juuso Kauppi
1,300,000
625,000
Giada Fang
0
0
Pause in the Action Posted Tuesday 28th February, 2023 at 23:55(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 25: 20,000/40,000 (40,000) Entries: 16/559
It has been quite a ride since the break with two more players hitting the rail in Aleksi Naski and Julien Fuchs. This makes it four eliminations in just under eight minutes of play.
The action is paused while players take new seats for the final two tables.
Player
Chips
Progress
Julien Fuchs
0
0
Aleksi Naski
0
0
Posted Tuesday 28th February, 2023 at 23:52(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 25: 20,000/40,000 (40,000) Entries: 18/559
Ranno Sootla jammed the river with a bit in the pot and the on the board and was called by Benjamin Gros. Sootla bricked his draws and didn't get away with stealing it away with . Gros didn't need much and his did the job to win the pot and eliminate Sootla.
Around the same time, Priit Vanem also lost his short stack.
Player
Chips
Progress
Benjamin Gros
1,350,000
690,000
Ranno Sootla
0
0
Priit Vanem
0
0
23:48 (UTC+2)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Updated Chip Counts of the Final 20 Posted Tuesday 28th February, 2023 at 23:40(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 25: 20,000/40,000 (40,000) Entries: 20/559
Here is a look at the chip counts of the final 20 players at the break.
Player
Chips
Progress
Tarmo Tammel
1,945,000
645,000
Paulius Vaitiekunas
1,550,000
1,170,000
Rokas Barzdzius
1,500,000
175,000
Luigi Shehadeh
1,430,000
180,000
Alger Pissarev
1,225,000
125,000
Yanis Mehdi Sahli
1,125,000
115,000
Janne Ojala
1,100,000
565,000
Zydrunas Karcemarskas
700,000
200,000
Juuso Kauppi
675,000
195,000
Benjamin Gros
660,000
445,000
Ranno Sootla
660,000
390,000
Giovanni Nava
660,000
160,000
Giada Fang
550,000
170,000
Arkadiusz Liszewski
445,000
185,000
Juuso Elsinen
390,000
270,000
Julien Fuchs
360,000
430,000
Aleksi Naski
350,000
110,000
Priit Vanem
300,000
200,000
Yaniv Peretz
250,000
140,000
Amin Asikainen
235,000
185,000
Joakim Brochard
0
0
Break Time! Posted Tuesday 28th February, 2023 at 23:19(UTC+2) by Jason Glatzer
Players are on a break. Blinds will increase to 20,000/40,000 with a big blind ante of 40,000 when the action resumes.
Lucky Ladies for Barzdzius to Oust Two Posted Tuesday 28th February, 2023 at 23:18(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 24: 15,000/30,000 (30,000) Entries: 21/559
Hanno Kerem got his last 400,000 chips in the pot before Eeti Loyttyniemi came along for the ride with his last 450,000. Rokas Barzdzius had both players covered and found a call.
Eeti Loyttyniemi: Hanno Kerem: Rokas Barzdzius:
It was looking like Loyttyniemi was going to be among the chip leaders and even more so after both players not getting anywhere on either the flop or the turn.
However, the table gasped in shock after the river completed the board to improve Barzdzius to a set of ladies to eliminate two players.
Player
Chips
Progress
Rokas Barzdzius
1,325,000
675,000
Hanno Kerem
0
0
Eeti Loyttyniemi
0
0
Posted Tuesday 28th February, 2023 at 23:07(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 24: 15,000/30,000 (30,000) Entries: 23/559
Luigi Shehadeh opened to 60,000 from the hijack. Rokas Barzdzius three-bet to 170,000 from the cutoff before Priit Vanem four-bet jammed a big stack. Shehadeh called off for 505,000 and Barzdzius folded.
Luigi Shehadeh: Priit Vanem:
Shehadeh's cowboys proved to be more than enough against Vanem's big slick after the ran out on the board.
Player
Chips
Progress
Luigi Shehadeh
1,250,000
580,000
Rokas Barzdzius
650,000
0
Priit Vanem
500,000
35,000
Perhaps the Beginning of a Comeback for Gros? Posted Tuesday 28th February, 2023 at 23:00(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 24: 15,000/30,000 (30,000) Entries: 23/559
Benjamin Gros was at one point a few hours ago the chip leader. He was the shortest stack when he got his final 85,000 in chips in from the big blind and was up against Rokas Barzdzius from the button.
Benjamin Gros: Rokas Barzdzius:
It was looking like the end of the line for Gros after bricking both the flop and the turn. However, his eight connected on the river to double his stack instead of hitting the rail.
Meanwhile, Igor Pihela Jr. was the latest casualty leaving just 23 hopefuls in the hunt for the title.
Player
Chips
Progress
Benjamin Gros
215,000
680,000
Rokas Barzdzius
0
470,000
Igor Pihela Jr.
0
190,000
Payouts for €1,660 Posted Tuesday 28th February, 2023 at 22:50(UTC+2) by Jason Glatzer
Place
Player
Prize
25
Allesandro Giordano
€ 1,660
26
Raiki Reinsoo
€ 1,660
27
Ari Varonen
€ 1,660
28
Juris Hlibovs
€ 1,660
29
Renaldas Mankauskas
€ 1,660
30
Stefan Bittger
€ 1,660
31
Max Rotko
€ 1,660
32
Jevgenijs Kritinins
€ 1,660
Small Pause in the Action Posted Tuesday 28th February, 2023 at 22:48(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 24: 15,000/30,000 (30,000) Entries: 24/559
The action is paused for a three-table redraw.
Player
Chips
Progress
Juris Hlibovs
0
0
Ari Varonen
0
0
Raiki Reinsoo
0
0
Allesandro Giordano
0
0
22:37 (UTC+2)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Tammel Propels With Rockets Posted Tuesday 28th February, 2023 at 22:32(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 23: 10,000/25,000 (25,000) Entries: 28/559
Julien Fuchs opened from under the gun for 50,000. Tarmo Tammel three-bet to 160,000 from the cutoff and Fuchs called to see the flop.
Barzdzius checked before Tammel led out for 175,000. Fuchs jammed and Tammel called off for 455,000 in total.
Tarmo Tammel: Julien Fuchs:
Tammel called over his friend Igor Pihela Jr., who is seated at another table to watch the sweat.
Not only did Tammel's rockets hold, but he improved to a flush after the turn and the river completed the board.
Player
Chips
Progress
Tarmo Tammel
1,300,000
600,000
Rokas Barzdzius
730,000
130,000
Julien Fuchs
190,000
600,000
Tens Not as Lucky as Earlier for Mankauskas Posted Tuesday 28th February, 2023 at 22:21(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 23: 10,000/25,000 (25,000) Entries: 28/559
Renaldas Mankauskas doubled up earlier with tens but the second time around didn't do the job.
Mankauskas shared with the media that he got it in with tens against ace-queen. He flopped a set but lost anyway.
Stefan Bittger also hit the rail to leave just 28 players remaining in the field.
Player
Chips
Progress
Renaldas Mankauskas
0
0
Stefan Bittger
0
0
"You Basically Have no Bluffs" Posted Tuesday 28th February, 2023 at 22:10(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 23: 10,000/25,000 (25,000) Entries: 30/559
Rokas Barzdzius checked the flop. Ranno Sootla bet 35,000 into a pot of more than double that and Barzdzius called.
Barzdzius check-called a bet of 75,000 on the turn before jamming for 250,000 on the river.
Sootla went into the tank for more than five minutes. He was talking most of the time but not getting any response from Barzdzius.
"You basically have no bluffs," was one comment Sootla repeated several times. "I should have jammed the turn."
Sootla eventually folded and mucked his cards. Meanwhile, Barzdzius decided to show the mysterious as the dealer shipped him the pot.
Shortly after this hand, Max Rotko hit the rail to leave 30 players remaining.
Player
Chips
Progress
Rokas Barzdzius
600,000
280,000
Ranno Sootla
270,000
270,000
Max Rotko
0
0
22:07 (UTC+2)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Karcemarskas Ousts Kritinins Posted Tuesday 28th February, 2023 at 21:52(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 22: 10,000/20,000 (20,000) Entries: 31/559
Jevgenijs Kritinins three-bet jammed for about 7 big blinds from the button and was called by Zydrunkas Karcemarskas.
Jevgenijs Kritinins: Zydrunkas Karcemarskas:
Kritinins improved to a set on the river after the ran out on the board. Unfortunately, the river was not a good one for Kritinins as he was ahead until then and that same card improved Karcemarskas to a straight to send Kritinins to the rail.
Meanwhile, Madis Muur was also off to the showers after losing his short stack a short while ago.
Player
Chips
Progress
Zydrunas Karcemarskas
900,000
150,000
Madis Muur
0
0
Jevgenijs Kritinins
0
0
Monday Recap With Laura Cornelius Posted Tuesday 28th February, 2023 at 21:41(UTC+2) by Jason Glatzer
Payouts for €1,460 Posted Tuesday 28th February, 2023 at 21:35(UTC+2) by Jason Glatzer
Place
Player
Prize
33
Madis Muur
€ 1,460
34
Davide Muccini
€ 1,460
35
Sondre Lunde
€ 1,460
36
Tomi Arponen
€ 1,460
37
Matias Knaapinen
€ 1,460
38
Martin Piik
€ 1,460
39
Kimmo Matias Kurko
€ 1,460
40
Gytis Bernatavicius
€ 1,460
Mankauskas Doubles Through Muur with Tens Posted Tuesday 28th February, 2023 at 21:32(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 22: 10,000/20,000 (20,000) Entries: 33/559
Renaldas Mankauskas opened for 100,000 with just 80,000 behind from the button. Madis Muur tanked from the big blind before he opted to put in Mankauskas for the rest. Mankauskas snap-called and the cards were turned over.
Renaldas Mankauskas: Madis Muur:
Mankauskas remained ahead the entire way and doubled up after the ran out on the board.
Player
Chips
Progress
Renaldas Mankauskas
410,000
0
Madis Muur
50,000
0
Davide Muccini
0
0
Posted Tuesday 28th February, 2023 at 21:20(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 22: 10,000/20,000 (20,000) Entries: 34/559
Sondre Lunde jammed for 150,000 straight off the break from the hijack and was called by Yaniv Peretz from the big blind.
Sondre Lunde: Yaniv Peretz:
Lunde got no love from the runout to hit the rail while Peretz earned some breathing room.
Player
Chips
Progress
Yaniv Peretz
390,000
185,000
Sondre Lunde
0
0
21:17 (UTC+2)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Full Chip Counts at Break Posted Tuesday 28th February, 2023 at 21:10(UTC+2) by Jason Glatzer
Player
Chips
Progress
Alger Pissarev
1,350,000
1,295,500
Yanis Mehdi Sahli
1,010,000
700,000
Benjamin Gros
895,000
764,500
Julien Fuchs
790,000
390,000
Zydrunas Karcemarskas
750,000
650,500
Giada Fang
720,000
624,500
Tarmo Tammel
700,000
656,500
Luigi Shehadeh
670,000
420,000
Juuso Elsinen
660,000
615,500
Arkadiusz Liszewski
630,000
567,500
Ranno Sootla
540,000
150,000
Priit Vanem
535,000
395,000
Janne Ojala
535,000
255,000
Giovanni Nava
500,000
180,000
Juuso Kauppi
480,000
309,500
Igor Pihela Jr.
460,000
438,500
Aleksi Naski
460,000
420,500
Amin Asikainen
420,000
390,000
Juris Hlibovs
420,000
234,500
Hanno Kerem
410,000
366,000
Paulius Vaitiekunas
380,000
259,000
Max Rotko
365,000
205,000
Eeti Loyttyniemi
355,000
298,500
Joakim Brochard
330,000
30,000
Rokas Barzdzius
320,000
20,000
Raiki Reinsoo
240,000
45,000
Madis Muur
235,000
104,000
Stefan Bittger
225,000
98,500
Renaldas Mankauskas
225,000
60,000
Yaniv Peretz
205,000
115,000
Allesandro Giordano
195,000
205,000
Ari Varonen
185,000
155,000
Sondre Lunde
150,000
90,000
Jevgenijs Kritinins
105,000
74,000
Davide Muccini
29,000
32,500
Winna, Winna, Chicken Dinna Posted Tuesday 28th February, 2023 at 20:14(UTC+2) by Jason Glatzer
Players are on a 60-minute dinner break. We will update all of the chip counts of the remaining players during the break.
Posted Tuesday 28th February, 2023 at 20:08(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 21: 8,000/16,000 (16,000) Entries: 37/559
Giada Fang jammed with the on the board after the turn with more than this in the pot. Eeti Loyttyniemi had 155,000 left in his stack and called it off.
Eeti Loyttyniemi: Giada Fang:
Loyttyniemi was far ahead and only needed to fade five outs on the river. The blank paired the board and Fang began counting out the chips to pay her opponent.
Player
Chips
Progress
Giada Fang
550,000
200,000
Eeti Loyttyniemi
500,000
443,500
€150 Celebrity Event Begins Posted Tuesday 28th February, 2023 at 20:00(UTC+2) by Jason Glatzer
The tournament area has been rocking with introductions and applause after Kings of Tallinn tournament director Teresa Nousiainen introduced the celebrities playing the €150 Celebrity Special.
The field is already at 200 entries for this event with more to come. This event provides tons of fun and value. The value not only comes from people that aren't normally playing poker but also from the fact that players collect bounties every time they eliminate a designated celebrity.
Good luck and have fun to all that are playing!
Fang Last Lady Standing Posted Tuesday 28th February, 2023 at 19:54(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 21: 8,000/16,000 (16,000) Entries: 40/559
Shiyan Fang is always a pleasure to watch in action whenever we happen to be at the same events. While it is a little surprising that there is only one woman left in the field, it isn't that shocking that Fang is the last female player left in the €555 Championship. Fang just snagged a decent pot to pad her stack as follows.
Fang opened from the cutoff before she called a three-bet by Julien Fuchs from the small blind for 110,000. Fuchs continued for 70,000 on the flop before both players checked the turn.
The action slowed down a bit after the river. It took a few minutes for Fuchs to check. Fang then took her time before jamming for more than 300,000. Fuchs paused for a moment before he laid down his hand.
Player
Chips
Progress
Giada Fang
750,000
654,500
Julien Fuchs
500,000
38,000
Players Cashing for €1,320 Posted Tuesday 28th February, 2023 at 19:43(UTC+2) by Jason Glatzer
Place
Player
Prize
41
Timo Ruuska
€ 1,320
42
Iiro Kettunen
€ 1,320
43
Jaakko Tirkkonen
€ 1,320
44
Lasse Enojarvi
€ 1,320
45
Harald Redl
€ 1,320
46
Jari Karkkainen
€ 1,320
47
Maksim Petrov
€ 1,320
48
Anthony Jay Kauzloric
€ 1,320
Player
Chips
Progress
Anthony Kauzloric
0
0
Maksim Petrov
0
0
Jari Karkkainen
0
0
Harald Redl
0
0
Lasse Enojarvi
0
0
Jaakko Tirkkonen
0
0
Iiro Kettunen
0
0
Timo Ruuska
0
0
19:38 (UTC+2)
Start of Level 21 Blinds: 8,000/16,000 Ante: 16,000
Players Cashing for €1,200 Posted Tuesday 28th February, 2023 at 19:12(UTC+2) by Jason Glatzer
Place
Player
Prize
49
Armin Abniki
€ 1,200
50
Kalle Saarinen
€ 1,200
51
Sergei Guljajev
€ 1,200
52
Matti Lasanen
€ 1,200
53
Jari Hurri
€ 1,200
54
Krzysztof Budka
€ 1,200
55
Kaspars Mallons
€ 1,200
56
Henri Pietari Wagner
€ 1,200
Player
Chips
Progress
Henri Wagner
115,500
0
Kaspars Mallons
0
0
Krzysztof Budka
0
0
Jari Hurri
0
0
Matti Lasanen
0
0
Sergei Guljajev
0
0
Posted Tuesday 28th February, 2023 at 19:09(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 20: 6,000/12,000 (12,000) Entries: 48/559
Benjamin Gros was the first player to amass over 1 million in chips.
"I got a gift," Gros said to us about his stack.
It sounds like it was not only a gift but an epic hand as well. Kalle Saarinen three-bet most of his stack with eight-seven suited. Gros put him in for the rest for a 700,000 chip pot with his cowboys.
Any chance of a bad beat went away on the flop as the other two kings came to improve Gros to quads.
Player
Chips
Progress
Benjamin Gros
1,200,000
630,000
Kalle Saarinen
0
0
19:04 (UTC+2)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Big Double for Tammel Posted Tuesday 28th February, 2023 at 18:54(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 19: 5,000/10,000 (10,000) Entries: 50/559
Tarmo Tammel four-bet jammed for 264,000 and was called by Yanis Sahli.
Tarmo Tammel: Yanis Sahli:
Tammel won the flip after the ran out on the board.
Player
Chips
Progress
Tarmo Tammel
535,000
491,500
Yanis Mehdi Sahli
200,000
240,000
Posted Tuesday 28th February, 2023 at 18:46(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 19: 5,000/10,000 (10,000) Entries: 52/559
Krzysztof Budka jammed a short stack of a handful of big blinds and was called by Jari Karkkainen, who also didn't have a mad amount of chips.
Krzysztof Budka: Jari Karkkainen:
Budka wasn't able to get ahead on the board and was on the rail after the hand.
Player
Chips
Progress
Jari Karkkainen
180,000
114,000
Krzysztof Budka
73,000
0
Players That Cashed for €1,100 Posted Tuesday 28th February, 2023 at 18:36(UTC+2) by Jason Glatzer
Place
Player
Prize
57
Indre Martoviciute
€ 1,100
58
Henri Schalin
€ 1,100
59
Mart Rinken
€ 1,100
60
Justas Semaska
€ 1,100
61
Laurynas Cerniauskas
€ 1,100
62
Kaupo Tenno
€ 1,100
63
Vygerdas Jonikas
€ 1,100
64
Kalle Aberg
€ 1,100
Player
Chips
Progress
Vygerdas Jonikas
0
0
Kaupo Tenno
0
0
Laurynas Cerniauskas
0
0
Justas Semaska
0
0
Mart Rinken
0
0
Henri Schalin
0
0
Martoviciute Loses Her Short Stack Posted Tuesday 28th February, 2023 at 18:32(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 19: 5,000/10,000 (10,000) Entries: 55/559
Indre Martoviciute jammed less than three big blinds from the button and was called by Kaspars Mallons from the big blind.
Indre Martoviciute: Kaspars Mallons:
It wasn't a premium hand but Martoviciute got it in good. Unfortunately, she was unable to hold with Mallons pairing his jack on the board.
Player
Chips
Progress
Aleksi Naski
490,000
450,500
Kaspars Mallons
400,000
289,500
Indre Martoviciute
0
0
Min-Cash Players Posted Tuesday 28th February, 2023 at 18:22(UTC+2) by Jason Glatzer
The following players min-cashed for their choice of €1,000 in cash or a Kings of Tallinn €1,100 Main Event Ticket.
Place
Player
Prize
65
Johan Mikael Martinsen
€ 1,000
66
Reinis Reinbergs
€ 1,000
67
Michael Ibba
€ 1,000
68
Mathias H. M. Siljander
€ 1,000
69
Jose Larios Domene
€ 1,000
70
Stanislovas Vinicenka
€ 1,000
71
Michailas Miserkejevas
€ 1,000
Player
Chips
Progress
Michailas Miserkejevas
0
0
Stanislovas Vinicenka
0
0
Jose Larios Domene
0
0
Mathias Siljander
0
0
Michael Ibba
0
0
Reinis Reinbergs
0
0
Johan Martinsen
0
0
Various Big Stacks at Break Posted Tuesday 28th February, 2023 at 18:19(UTC+2) by Jason Glatzer
Player
Chips
Progress
Alger Pissarev
740,000
685,500
Juuso Elsinen
600,000
555,500
Rokas Barzdzius
591,000
291,000
Benjamin Gros
570,000
439,500
Ranno Sootla
545,000
155,000
Julien Fuchs
538,000
138,000
Martin Piik
500,000
170,000
Sondre Lunde
465,000
225,000
Kalle Saarinen
450,000
190,000
Igor Pihela Jr.
440,000
418,500
Yanis Mehdi Sahli
440,000
130,000
Allesandro Giordano
420,000
20,000
Janne Ojala
410,000
130,000
Raiki Reinsoo
340,000
55,000
Anthony Kauzloric
320,000
176,500
18:12 (UTC+2)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Break Time Posted Tuesday 28th February, 2023 at 17:54(UTC+2) by Jason Glatzer
Players are on a break. We will catch up with all the in-the-money eliminations along with updated chip counts of some of the bigger stacks shortly after the break.
Posted Tuesday 28th February, 2023 at 17:46(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 18: 4,000/8,000 (8,000) Entries: 71/559
Gediminas Dirmantas opened half his eight big blind stack and got the rest in when facing a raise by Rokas Barzdzius.
Gediminas Dirmantas: Rokas Barzdzius:
Dirmantas was behind and things got worse after the flop. He was drawing dead after the turn and officially bubbled the €555 Championship after the river completed the board to Bardzdzius' full house.
It is possible that Dirmantas, who started the day in second place, will collect something. If he bought in through Luxon Pay, he automatically got bubble protection.
Player
Chips
Progress
Rokas Barzdzius
600,000
573,500
Gediminas Dirmantas
0
0
Money Bubble Time! Posted Tuesday 28th February, 2023 at 17:39(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 18: 4,000/8,000 (8,000) Entries: 72/559
The action is down to the stone-cold bubble after Masse Mirza hit the rail. Mirza three-bet jammed for about 120,000 from the big blind and was called by Allesandro Giordano who opened from late position.
Masse Mirza: Allesandro Giordano:
Giordano's nines held and Mirza finished short of the money.
Player
Chips
Progress
Allesandro Giordano
400,000
282,500
Kasparas Klezys
94,000
0
Masse Mirza
0
0
Fortune Teller Nava Takes Out Two Posted Tuesday 28th February, 2023 at 17:28(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 18: 4,000/8,000 (8,000) Entries: 75/559
Viktors Caikins with a short stack and Stanislav Smeljov with about 100,000 each had their stacks in the middle. Giovanni Nava was also involved and had both players covered.
Viktors Caikins: Stanislav Smeljov: Giovanni Nava:
Nava was behind but that all changed after his ace connected on the flop. The followed on the turn.
"Jack, please!" said Nava.
Nava might be a fortune teller as the river completed the board and Nava took out two players near the bubble.
Player
Chips
Progress
Giovanni Nava
320,000
157,000
Vita Veidemane
0
0
Brandon Mifsud
0
0
Stanislav Smeljov
0
0
Viktors Caikins
0
0
Money Bubble Approaching Posted Tuesday 28th February, 2023 at 17:18(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 18: 4,000/8,000 (8,000) Entries: 79/559
The action is now just eight players away from the money bubble with the top 71 players guaranteed at least a €1,000 min-cash or a Kings of Tallinn €1,100 Main Event ticket instead if they choose.
Here is a look at some of the recent eliminations:
Player
Chips
Progress
Martynas Vitkauskas
0
0
Mario Colavita
0
0
Denis Kockinas
0
0
Priit Brikker
0
0
17:16 (UTC+2)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Posted Tuesday 28th February, 2023 at 17:00(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 17: 3,000/6,000 (6,000) Entries: 84/559
Martynas Vitkauskas jammed from the small blind. Erno Suominen went into the tank for about a minute before he opted to call off his stack of 67,000.
Erno Suominen: Martynas Vitkauskas:
The board ran dry for both players and Suominen managed to double up with his king-kicker.
Player
Chips
Progress
Erno Suominen
140,000
67,500
Martynas Vitkauskas
80,000
50,000
"You Said You Were Going to Leave... It's the Opposite" Posted Tuesday 28th February, 2023 at 16:53(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 17: 3,000/6,000 (6,000) Entries: 85/559
Timo Ruuska jammed for 46,000 from under the gun. Julien Fuchs three-bet shoved for heaps more from late position and the rest of the table folded.
Timo Ruuska: Julien Fuchs:
"Two aces, please!" Ruuska said.
He got half his wish which was good enough to double his stack after the ran out on the board.
After the hand, Madis Muur, who was also at the table said with a smile: "You said you were going to leave... It's the opposite."
Player
Chips
Progress
Julien Fuchs
270,000
513,500
Timo Ruuska
100,000
73,500
Aleksandr Kuperman
0
0
Richard Bauer
0
0
Erki Leedmaa
0
0
Urmo Einard
0
0
Firaldo Update Posted Tuesday 28th February, 2023 at 16:47(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 17: 3,000/6,000 (6,000) Entries: 89/559
We tried to find Niall "Firaldo" Farrell at the bar to find out how he lost his once decent stack. But it was a quick trip to the bar as soon after he late-registered the €150 6-Max along with Kyle Maguire who also arrived with Firaldo.
"I shockingly got it in good twice for most of my stack," shared Firaldo. "First I lost a 300,000 pot when my ace-king didn't hold against ace-jack. Shortly after I lost another big pot when my ace-queen didn't hold against ace-nine. The crumbs left were gone when my king-seven didn't get there against ace-seven."
Meanwhile, Maguire came to say hello as we were chatting with Firaldo.
"I arrived last night and fired two bullets unsuccessfully in the €555 Championship," Maguire said. "I am already a winner though as I have a drink and now get to play the 6-max."
Meanwhile, the start of the day chip leader Juri Vassin also recently hit the rail short of the money.
Player
Chips
Progress
Arto Lehtonen
0
0
Kyle Maguire
0
0
Totti Arosuo
0
0
Juri Vassin
0
0
Roope Tarmi
0
0
Sebastian Wahl
0
0
Bartosz Mielczarek
0
0
Joonas Kulli
0
0
Raiko Laane
0
0
Peep Kivistik
0
0
Ronald Randma
0
0
Matti Salminen
0
0
Kalle Persson
0
0
Martynas Racinskas
0
0
Mairo Tori
0
0
Niall Farrell
0
0
16:30 (UTC+2)
Start of Level 17 Blinds: 3,000/6,000 Ante: 6,000
Let the Flips Begin! Posted Tuesday 28th February, 2023 at 16:29(UTC+2) by Jason Glatzer
The €150 GGPoker Flip&Go Mystery Bounty will kick off its Day 1c flight shortly. The rules are similar but not identical to the online Flip&Go games at GGPoker and OlyBet Poker with a few small changes and one big one in the mystery bounty component.
Here is how it works:
1) Players enter for a GGPoker Flip&Go opening flight at the cash desk. 2) A game begins when there are nine available players who sit together at one table. 3) Players are dealt three cards facedown. 4) A flop is dealt and players then discard one card and turn the other two over. 5) A turn and a river are dealt and the best hand at the table advances to Day 2 on Friday March 3 already in the money.
A few other notes:
Players on Day 2 will not only be in the money but also collect a mystery bounty prize. The event guarantees at least a €5,000 top mystery bounty prize.
Players that advance to Day 2 may not re-enter other opening flights. Those that haven't advanced to Day 2 can re-enter as many times as they wish until they advance.
Thus far WSOP bracelet winner Espen Sandvik, Sondre Stormyr, Dainius Antanaitis, and Paulius Vaitiekunas have already locked in their seats into Friday's Day 2 after winning flips on Monday.
Best of luck to all of the players. The Kings of Tallinn staff will be around the action in case players have any questions.
Rotko Wins a Flip Posted Tuesday 28th February, 2023 at 16:18(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 16: 2,000/5,000 (5,000) Entries: 102/559
Max Rotko jammed for 15 big blinds from under the gun. Indre Martoviciute three-bet shoved for double that from two seats over and the rest of the table folded.
Max Rotko: Indre Martoviciute:
Martoviciute didn't connect with the runout to double Rotko's stack instead of sending him to the showers.
Meanwhile, GGPoker Ambassador Niall "Firaldo" Farrell also hit the rail. We will try to drop by the bar shortly to find out what transpired.
Player
Chips
Progress
Max Rotko
160,000
130,000
Indre Martoviciute
80,000
1,000
Kristian Kostiander
0
0
Algirdas Saveikis
0
0
Niall Farrell
0
0
Posted Tuesday 28th February, 2023 at 16:07(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 16: 2,000/5,000 (4,000) Entries: 106/559
Janne Ojala opened the button before he called a three-bet jam by Ville Laasanen for more than 15 big blinds.
Ville Laasanen: Janne Ojala:
The board ran clean for Ojala's tens to eliminate Laasanen.
Player
Chips
Progress
Janne Ojala
280,000
207,500
Pavels Spirins
0
0
Lukas Soucek
0
0
Andrej Michailov
0
0
Mohammed Halafi
0
0
Ville Laasanen
0
0
Various Stacks at Break Posted Tuesday 28th February, 2023 at 15:55(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 16: 2,000/5,000 (4,000) Entries: 112/559
Here is a look at some of the bigger stacks around the room at the break.
Player
Chips
Progress
Ranno Sootla
390,000
198,000
Lasse Enojarvi
360,000
225,000
Martin Piik
330,000
186,000
Yaniv Peretz
320,000
255,500
Yanis Mehdi Sahli
310,000
258,500
Joakim Brochard
300,000
199,000
Matias Knaapinen
300,000
133,500
Iiro Kettunen
290,000
95,000
Renaldas Mankauskas
285,000
261,500
Raiki Reinsoo
285,000
117,000
Kalle Saarinen
260,000
230,000
Luigi Shehadeh
250,000
220,500
Matti Lasanen
250,000
145,000
Sondre Lunde
240,000
210,000
Vadim Guk
0
0
Marten Rimmel
0
0
Eero Lehtinen
0
0
Elias Suhonen
0
0
Risto Pärnat
0
0
Risto Parnat
0
0
Sami Starck
0
0
Nijat Rustamov
0
0
15:48 (UTC+2)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Break Time! Posted Tuesday 28th February, 2023 at 15:32(UTC+2) by Jason Glatzer
Players are on a short break. Blinds will increase to 2,000/5,000 with a big blind ante of 5,000 when the action resumes.
Posted Tuesday 28th February, 2023 at 15:26(UTC+2) by Jason Glatzer
The Kings of Tallinn €555 Championship will pay out a whopping €55,500 to the winner with the top 71 players earning at least a €1,000 min-cash.
Players that min-cash will have the option to snag the €1,000 in cash or alternatively instead get a ticket to the €500,000 guaranteed Kings of Tallinn Main Event valued at €1,100. Here is a look at all of the payouts:
Place
Prize
1
€ 55,500
2
€ 37,500
3
€ 22,200
4
€ 16,200
5
€ 12,700
6
€ 9,540
7
€ 7,000
8
€ 4,790
9-10
€ 3,420
11-12
€ 2,710
13-16
€ 2,210
17-24
€ 1,910
25-32
€ 1,660
33-40
€ 1,460
41-48
€ 1,320
49-56
€ 1,200
57-64
€ 1,100
65-71
€ 1,000
Posted Tuesday 28th February, 2023 at 15:22(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 15: 2,000/4,000 (4,000) Entries: 123/559
Andrei Melnikov jammed for about eight big blinds from the small blind. Priit Vanem went into the tank for about a minute before he called from the big blind.
Andrei Melnikov: Priit Vanem:
Melnikov appeared to be in good shape after the flop was his five paired and he also had one of Vanem's outs blocked with an eight improving him to a straight. He was still ahead after the turn. However, the river changed everything and Vanem eliminated Melnikov with a better pair.
Player
Chips
Progress
Priit Vanem
140,000
15,000
Leonardo Romeo
0
0
Kent Wulff
0
0
Helina Tamm
0
0
Andrei Melnikov
0
0
Good Day for Firaldo Despite Doubling De Ramon Posted Tuesday 28th February, 2023 at 15:12(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 15: 2,000/4,000 (4,000) Entries: 127/559
GGPoker Ambassador Niall "Firaldo" Farrell arrived last night to the Kings of Tallinn. Farrell hopped into the €555 Championship on Day 2 and already built up his stack. It hasn't been all smooth sailing for Farrell despite his early success as he just doubled Kaupo Tenno as follows.
Tenno open-jammed for 44,000 from the cutoff. Farrell came over the top for more than triple that from the small blind and the player in the big blind folded.
Kaupo Tenno: Niall Farrell:
Farrell was ahead but that all changed on the flop with Tenno improving to a pair. Blanks came for Farrell on both the turn and the river to double Tenno.
Player
Chips
Progress
Niall Farrell
115,000
85,000
Kaupo Tenno
100,000
20,000
Josep Pastor De Ramon
0
0
Vesa Leikos
0
0
Luca Sebastiani
0
0
Julius Seskevicius
0
0
Todd Belsick
0
0
Federico Cirillo
0
0
Keimo Suominen
0
0
Aleksei Smirnov
0
0
Mohamed Barre Mohamud
0
0
Recent Eliminations Posted Tuesday 28th February, 2023 at 15:00(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 15: 2,000/4,000 (4,000) Entries: 137/559
The following players hit the rail during the latter part of Level 13 including Aki Pyysing whose ace-queen was no good against ace-eight. He shared that he got it in on the turn with just ace-high after his opponent already paired his eight.
Player
Chips
Progress
Artjom Kovalevski
0
0
Bartosz Mielczarek
0
0
Ville Jantunen
0
0
Andrey Koks
0
0
Victor Prior Fernandez Amat
0
0
Victor Amat
0
0
Peder Behr
0
0
Marko Vest
0
0
Marco Regonaschi
0
0
Arturs Baskinovs
0
0
Andrius Bielskis
0
0
Juho Suutari
0
0
Aki Pyysing
0
0
Adria Comas I Roura
0
0
14:53 (UTC+2)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Min Cash Boost! Posted Tuesday 28th February, 2023 at 14:37(UTC+2) by Jason Glatzer
While we do not know the exact payouts yet, we do know that the top 71 players will be rewarded with at least a min-cash valued at €1,000.
However, those interested in the Main Event can snag even more value as players that min-cash will have the option to choose between taking the €1,000 in cash or instead snag a ticket to the €500,000 guaranteed Kings of Tallinn Main Event valued at €1,100 which kicks off tomorrow.
In addition, there will be a dinner break after the conclusion of Level 21 at around 8 p.m.
Posted Tuesday 28th February, 2023 at 14:29(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 14: 1,500/3,000 (3,000) Entries: 149/559
Bartosz Mielczarek opened for 7,000 from the button. Reinis Reinbergs three-bet jammed for 73,500 from the small blind and Melinkov called.
Reinis Reinbergs: Bartosz Mielczarek:
The flop flop provided a sweat for both players with Mielczarek improving to a set of nines and Reinbergs holding out for some hope with a flush draw. The turn paired up Reinbergs's hand but in reality, it was a blank card. However, the river improved Reinbergs to a flush to not only survive but to double his stack.
Player
Chips
Progress
Reinis Reinbergs
155,000
96,500
Bartosz Mielczarek
150,000
35,500
Priit Vanem
120,000
0
Andrei Melnikov
100,000
7,000
Bartosz Mielczarek
0
0
Artjom Kovalevski
0
0
Sebastian Gotthardt
0
0
Oleh Bohdanov
0
0
Christian Hoffmann
0
0
Ville Jantunen
0
0
More Level 13 Eliminations Posted Tuesday 28th February, 2023 at 14:23(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 14: 1,500/3,000 (3,000) Entries: 157/559
We have learned that 71 players will make the money today with payouts to be announced shortly.
Meanwhile, the following players recently hit the rail in the €555 Championship:
Player
Chips
Progress
Rimvydas Svedas
0
0
Touko Berndtson
0
0
Toni Ylitervo
0
0
Andres Aro
0
0
Matiss Celmins
0
0
Dmitri Dudakov
0
0
Arminas Nemeika
0
0
Arto Mansner
0
0
Priit Oja
0
0
Romain Gravisse
0
0
Jevgeni Voitovits
0
0
Lari Pukkila
0
0
Keito Kaljulaid
0
0
Artiom Goncarenko
0
0
Julius Tiihonen
0
0
Mantas Bagocius
0
0
Dominik Ostrowski
0
0
Andrei Silencov
0
0
Rain Molderkivi
0
0
Hans Erlandsson
0
0
14:16 (UTC+2)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Posted Tuesday 28th February, 2023 at 14:16(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 13: 1,000/2,500 (2,500) Entries: 160/559
Kristian Kostiander made a standard open from early position before things got wild. Kaupo Tenno jammed for about 20 big blinds from the button. Julien Fuchs called off for 10 big blinds from the big blind and Kostiander, who had both players covered, called for a three-way showdown.
Julien Fuchs: Kaupo Tenno: Kristian Kostiander:
Tenno improved to a flush on the runout to eliminate Fuchs and double through Kostiander.
Player
Chips
Progress
Kristian Kostiander
200,000
149,500
Kaupo Tenno
120,000
34,500
Julien Fuchs
0
0
Posted Tuesday 28th February, 2023 at 14:01(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 13: 1,000/2,500 (2,500) Entries: 183/559
Players are dropping like flies after late registration closed. One player still in their seats was Federico Cirillo, who re-entered at least twice on Day 2. The third time seems to be a charm.
Benjamin Gros opened from middle position before Lari Pukkila three-bet jammed for about 50,000 from the small blind. Cirillo called off his stack of 33,000 from the big blind and Gros folded.
Federico Cirillo: Lari Pukkila:
Pukkila was marginally ahead and pulled even further ahead after the flop. The turn changed everything as Cirillo improved to two pair on the paired board. The river didn't change the outcome and Cirillo doubled through Pukkila.
Here is also a look at the many other players have busted out at other tables around the room.
Player
Chips
Progress
Federico Cirillo
75,000
45,000
Markku Koplimaa
0
0
Tommi Lankinen
0
0
Herli Olop
0
0
Mark Metsla
0
0
Antti Vetelainen
0
0
Viktor Eriksson
0
0
Onni Huttunen
0
0
Viktor Smyrnov
0
0
Joel Lindpere
0
0
Niko Sivunen
0
0
Dainius Antanaitis
0
0
Victor Fernandez Garcia
0
0
Vasilij Barna
0
0
Siim Pindis
0
0
Lari Pukkila
0
63,000
Schalin Ousts Tse Posted Tuesday 28th February, 2023 at 13:50(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 13: 1,000/2,500 (2,500) Entries: 204/559
Jia Juen Tse jammed for 10,500 from early position. He immediately began to record a video knowing it was likely his short stack would be called and was commentating the action quietly into his phone while his cool panda chip holder was watching along.
The action folded around to Henri Schalin who jammed for about 20 big blinds from the small blind. The player in the big blind folded and Tse seemed pleased that his cards were live.
Jia Juen Tse: Henri Schalin:
Tse pulled out in front after his queen connected with the flop. However, the spiked the turn to improve Schalin to a better pair. The blank river completed the board and Tse wished all the players at the table good luck before heading out of the tournament arena.
We will be cleaning out some of the recent eliminations in this post as well for players that hit the rail before late registration closed and didn't re-enter.
Player
Chips
Progress
Henri Schalin
65,000
16,500
Sven Reimaa
0
0
Tuomo Turunen
0
0
Marek Liiva
0
0
Joni Rantamaki
0
0
Irmantas Bzeskis
0
0
Kalle Parkkinen
0
0
Renato Messina
0
0
Jari Porkka
0
0
Osku Karttunen
0
0
Juha-Pekka Rissanen
0
0
Uri Gilboa
0
0
Theophile Tristan George
0
0
Juri Vinkel
0
0
Arvydas Vilcinskas
0
0
Girts Fridrihsons
0
0
Marijus Vaiginas
0
0
Linus Lauermann
0
0
Mario Munoz Martin
0
0
Eirimas Tomkevicius
0
0
Jia Juen Tse
0
0
Posted Tuesday 28th February, 2023 at 13:35(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 207/559
Players are back from break and now is when everything starts to count as players can no longer late-enter or re-enter the €555 Championship.
The field blossomed to 559 entries including 77 entries on Day 2 to generate a €262,730. This could be off by a player or two as the staff will spend a bit of time checking and double-checking figures before announcing the payouts.
The event has smashed the previous record for this event at the Kings of Tallinn. The previous record took place just before the pandemic in 2020 when Tomas Sujeta outlasted a field of 435 entries to win the €36,700 top prize.
Here is a look at the €555 Championship by the numbers:
Flight
Entries
Day 1a
105
Day 1b
107
Day 1c
199
Day 1d
71
Day 2
77
Total
559
13:31 (UTC+2)
Start of Level 13 Blinds: 1,000/2,500 Ante: 2,500
Late Registration About to Close Posted Tuesday 28th February, 2023 at 13:01(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 208/549
Players are on a short break. Late registration will be closed shortly after the break.
Shortly after that, we should know the total number of entrants and the prize pool. It will be slightly longer before the payouts are announced but this should also be before the second break.
While players are on break, why not enjoy a tasty beverage or snack at the OlyBet Bar & Grill with the ever-helpful and smiling staff.
Jacks Win a Flip for Enojarvi Posted Tuesday 28th February, 2023 at 12:51(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 209/538
Luca Beretta four-bet jammed from middle position. Lasse Enojarvi, who three-bet to 18,000 from the button, called off his stack of 66,500.
Lasse Enojarvi: Luca Beretta:
The flip was on with Enojarvi at risk. Beretta got no love with his big slick after the hit the board and he doubled up his opponent while leaving himself short on chips.
Player
Chips
Progress
Lasse Enojarvi
135,000
65,000
Luca Beretta
20,000
62,000
"He Needs the Chips" Posted Tuesday 28th February, 2023 at 12:41(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 218/526
Finland's Roope Tarmi is at most major events here in Tallinn. The Finnish poker player just arrived today and immediately hopped into the €555 Championship with a 15 big blind stack.
Tarmi bled away some chips early and was down to 23,000 when he jammed from the hijack. Finnish journalist and the poker father of many in the Finnish poker community Aki Pyysing tanked for about 30 seconds before he opted to call from the button. The rest of the table folded and the cards were turned over.
Roope Tarmi: Aki Pyysing:
Tarmi won the flip to double his stack after Pyysing bricked the board.
"That's OK," Pyysing said after the hand. "He needs the chips more than me."
Player
Chips
Progress
Aki Pyysing
75,000
19,000
Roope Tarmi
51,000
21,000
Big Slick Loses a Race for Isberg Posted Tuesday 28th February, 2023 at 12:31(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 222/522
Ville Laasanen three-bet jammed from the small blind and was called off by Kyosti Isberg who had less than 20 big blinds from the button.
Kyosti Isberg: Ville Laasanen:
Isberg lost the flip and his stack after his big slick got nowhere on the runout.
Player
Chips
Progress
Ville Laasanen
100,000
40,000
Kyosti Isberg
0
0
Bad Beat to Start the Day for Lankinen Posted Tuesday 28th February, 2023 at 12:26(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 221/512
Ronald Randma opened for 6,000 from the small blind. Tommi Lankinen three-bet jammed for 28,000. Randma paused for about 10 seconds before he found a call.
Tommi Lankinen: Ronald Randma:
Lankinen was ahead and favored to double his stack. But that all changed on the flop with Randma connecting with his ace. Neither the turn nor the river was able to save the day and Lankinen was one of the day's first casualties.
Player
Chips
Progress
Ronald Randma
110,000
30,000
Tommi Lankinen
0
0
Cards in the Air Posted Tuesday 28th February, 2023 at 12:20(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 221/512
Cards are now in the air for Day 2 of the €555 Championship. The field has grown to 512 entries and will continue to rise.
More Than 500 Entries! Posted Tuesday 28th February, 2023 at 12:01(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 212/503
The Kings of Tallinn €555 Championship continues to grow with the field now already past 500 entries! Now it is just a matter of how big this epic event will grow.
Short Delay Posted Tuesday 28th February, 2023 at 11:58(UTC+2) by Jason Glatzer
€555 Championship Final Day Level 12: 1,000/2,000 (2,000) Entries: 206/497
The staff announced a small delay to the start of the day while players are still getting registered. The field has nearly grown to 500 entries.
Late registration will close after the first blind level of the day. Shortly after, we will know the final prize pool and payouts of this record-breaking event.
Final Day Begins at Noon Posted Tuesday 28th February, 2023 at 10:58(UTC+2) by Jason Glatzer
Welcome to the second and final day of the Kings of Tallinn €555 Championship at Olympic Park Casino and the Hilton Tallinn Park.
The four starting days attracted a banner field of 482 entries with more still to come with late registration open until the end of the first blind level of Day 2. This has already established a new record for this event with the previous record coming in 2020 with 435 entries. That event was won by Lithuania's Tomas Sujeta for €36,700 with a bigger top prize to come this time around.
A total of 191 players have bagged chips into Day 2 led by Day 1a chip leader Juri Vassin with 211,500 in chips. Gediminas Dirmantas (209,000) was the only other player to bag more than 200,000 with Day 1c chip leader Iiro Kettunen (195,000), Day 1b chip leader and 2015 Kings of Tallinn Main Event champion Ranno Sootla (191,000), and Juris Hlibovs (185,500) rounding out the top five to start the day.
Blinds will begin at 1,000/2,000 with a big blind ante of 2,000 and will increase every 40 minutes until a winner is crowned.
We will be on the floor reporting the action when cards kick off at noon. Stay tuned to see who will win the 2023 Kings of Tallinn €555 Championship!
Tuesday's Schedule
Time
Event
12 p.m.
€555 Kings Of Tallinn 2023 Championship FINAL DAY
12 p.m.
Free Satellite to The €150 NLH Celebrity Event, Unlimited €10 Rebuys & Add On, 3x €150 seats guaranteed!
1 p.m.
The Short-Handed €250 NLH, 6 Handed
4 p.m.
Free Satellite to The €1,100 Kings Of Tallinn Main Event, Unlimited €50 Rebuys & Add On, 2x €1,100 SEATS GUARANTEED!!!
4:30 p.m.
NEW! €150 GG Poker Flip&Go Mystery Bounty Day 1C - One hand flips Day 1, in the money Day 2 with regular play, €5,000 Top Bounty guaranteed!!!
5 p.m.
NEW! €150 GG Poker Flip&Go Mystery Bounty Day 1D - One hand flips Day 1, in the money Day 2 with regular play, €5,000 Top Bounty guaranteed!!!
7:30 p.m.
€150 Celebrity Special, NLH with fun bounties on celebrity players
9 p.m.
NEW! €440 PL Omaha 4&5 Cards Mystery Bounty, Button Round Each, 6 Handed, Final 3 play PLO5 only, Day 2 - next day at 21:00
10 p.m.
€120 Mega-Satellite to The Kings Of Tallinn €1,100 Main Event, 8x €1,100 SEATS GUARANTEED!!!
Day 2 Seat Draw Posted Tuesday 28th February, 2023 at 10:34(UTC+2) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Lasse Olavi Enojärvi
70,000
35
1
2
Eeti Tapani Löyttyniemi
56,500
28
1
4
Kyösti Allan Isberg
38,000
19
1
5
Ville P. A. Laasanen
60,000
30
1
6
Joakim Deva Brochard
101,000
51
1
7
Luca Beretta
82,000
41
1
8
Sami T.P Starck
105,500
53
1
9
Arto E. S. Mansner
66,500
33
2
1
Onni Ensio Huttunen
41,500
21
2
2
Irmantas Bzeskis
32,000
16
2
3
Igor Pihela Jun.
21,500
11
2
5
Viktor E. P. Eriksson
31,500
16
2
6
Rokas Barzdzius
26,500
13
2
7
Romain P. A. H. Gravisse
24,500
12
2
8
Peep Kivistik
105,000
53
2
9
Ranno Sootla
192,000
96
3
1
Luca Sebastiani
123,500
62
3
2
Mantas Bagocius
50,000
25
3
3
Kaupo Tenno
85,500
43
3
4
Richard F. H. Bauer
33,500
17
3
5
Andres Aro
17,500
9
3
6
Siim Pindis
50,000
25
3
7
Kalle J. A. Aberg
90,000
45
3
9
Oleh Bohdanov
47,000
24
4
1
Alger Pissarev
54,500
27
4
3
Touko Teivonpoika Berndtson
37,000
19
4
4
Indre Martoviciute
81,000
41
4
5
Zydrunas Karcemarskas
99,500
50
4
6
Lukas Soucek
64,500
32
4
7
Krzysztof Kazimierz Budka
73,000
37
4
8
Victor Fernandez Garcia
28,000
14
5
1
Tarmo Tammel
43,500
22
5
2
Matias Manuel Knaapinen
166,500
83
5
3
Kasparas Klezys
94,000
47
5
4
Arminas Nemeika
136,000
68
5
5
Vasilij Barna
105,000
53
5
6
Anthony Jay Kauzloric
143,500
72
5
7
Stefan Bittger
126,500
63
5
8
Gisle Guldbrandsen
55,500
28
5
9
Joni S.J Rantamäki
72,000
36
6
1
Eirimas Tomkevicius
30,000
15
6
2
Reinis Reinbergs
58,500
29
6
4
Juri Vassin
211,500
106
6
5
Mathias H. M. Siljander
98,000
49
6
6
Kimmo Matias Kurko
106,000
53
6
7
Stanislav Smeljov
54,500
27
6
8
Dominik Ostrowski
162,000
81
6
9
Marijus Vaiginas
41,000
21
7
1
Urmo Einard
75,000
38
7
2
Markku Koplimaa
90,500
45
7
4
Juha-Pekka Rissanen
31,500
16
7
5
Davide Muccini
61,500
31
7
6
Mohammed H. S. Halafi
130,500
65
7
7
Priit Brikker
81,500
41
7
8
Joel Lindpere
43,700
22
7
9
Iiro Mikael Kettunen
195,000
98
8
1
Kalle Pontus Persson
144,500
72
8
2
Raiki Reinsoo
168,000
84
8
3
Yanis Mehdi Sahli
51,500
26
8
4
Keito Kaljulaid
7,000
4
8
5
Shiyan Fang
95,500
48
8
7
Andrey Koks
47,500
24
8
8
Aki Taisto Olavi Pyysing
94,000
47
8
9
Juuso R. P. Elsinen
44,500
22
9
1
Kent Mikael Wulff
85,000
43
9
2
Dmitri Dudakov
55,000
28
9
4
Michailas Miserkejevas
80,000
40
9
5
Aleksi Mikael Naski
39,500
20
9
6
Raiko Laane
43,000
22
9
7
Victor Prior Fernandez Amat
88,000
44
9
8
Sebastian Wahl
118,500
59
9
9
Aleksei Smirnov
66,500
33
10
1
Johan Mikael Martinsen
160,000
80
10
2
Andrius Bielskis
38,000
19
10
3
Hanno Kerem
44,000
22
10
5
Stanislovas Vinicenka
78,000
39
10
6
Erki Leedmaa
82,000
41
10
7
Paulius Vaitiekunas
121,000
61
10
8
Andrei Silencov
37,000
19
10
9
Marek Liiva
13,500
7
11
1
Niko Winai Sivunen
73,500
37
11
3
Luigi Andrea Shehadeh
29,500
15
11
4
Jaakko Petteri Tirkkonen
18,500
9
11
5
Leonardo Romeo
178,000
89
11
6
Jari Pekka Hurri
171,500
86
11
7
Viktors Caikins
39,500
20
11
8
Henri Pietari Wagner
115,500
58
11
9
Artjom Kovalevski
50,000
25
12
1
Sergei Guljajev
111,000
56
12
3
Sebastian Gotthardt
116,500
58
12
4
Mairo Tori
60,000
30
12
5
Allesandro Giordano
117,500
59
12
6
Juris Hlibovs
185,500
93
12
7
Peder Behr
124,500
62
12
9
Tomi Tapani Arponen
43,000
22
12
Maksim Petrov
97,000
49
13
1
Joonas Kulli
34,500
17
13
2
Juuso Artturi Kauppi
170,500
85
13
3
Kalle Elmeri Parkkinen
21,500
11
13
4
Gediminas Dirmantas
209,000
105
13
5
Toni Valtteri Ylitervo
59,500
30
13
6
Antti E. E. Veteläinen
33,000
17
13
7
Kristian E. V. Kostiander
50,500
25
13
8
Marko Vest
98,000
49
14
1
Aleksandr Kuperman
143,500
72
14
2
Linus Hans Ludwig Lauermann
58,000
29
14
3
Priit Oja
52,000
26
14
4
Andrej Michailov
64,500
32
14
5
Vadim Guk
103,000
52
14
6
Renaldas Mankauskas
23,500
12
14
8
Giovanni Nava
163,000
82
14
9
Rimvydas Svedas
30,500
15
15
1
Ronald Randma
80,000
40
15
2
Julien Lauren Fuchs
70,500
35
15
4
Erno Tapani Suominen
72,500
36
15
5
Arto Antero Lehtonen
60,000
30
15
6
Algirdas Saveikis
34,000
17
15
7
Girts Fridrihsons
179,500
90
15
8
Jari Juhani Porkka
27,500
14
15
9
Michael Ibba
34,500
17
16
1
Jia Juen Tse
14,000
7
16
2
Mohamed Barre Mohamud
22,500
11
16
3
Ville Olavi Jantunen
62,000
31
16
4
Matti Johannes Salminen
88,500
44
16
5
Mario Antonio Colavita De La Grana
100,500
50
16
6
Janne Antero Ojala
72,500
36
16
7
Henri Mikael Schalin
48,500
24
16
8
Viktor Smyrnov
91,500
46
17
1
Julius Jesperi Tiihonen
33,500
17
17
2
Jevgenijs Kritinins
31,000
16
17
3
Justas Semaška
80,500
40
17
4
Tuomo J.M. Turunen
34,000
17
17
5
Todd William Belsick
52,500
26
17
6
Juri Vinkel
116,500
58
17
8
Marten Rimmel
89,500
45
17
9
Arkadiusz Liszewski
62,500
31
18
1
Vita Veidemane
32,500
16
18
2
James Noonan
30,000
15
18
3
Vygerdas Jonikas
67,000
34
18
5
Christian Hoffmann
37,000
19
18
6
Igor Pihela
66,500
33
18
7
Jari Tapio Kärkkäinen
66,000
33
18
8
Elias L. B. Suhonen
25,000
13
18
9
Arturs Baskinovs
57,000
29
19
1
Bartosz Mielczarek
114,500
57
19
2
Risto Pärnat
69,000
35
19
3
Theophile Tristan George
53,000
27
19
4
Yaniv Peretz
64,500
32
19
5
Timo Johannes Ruuska
26,500
13
19
6
Jevgeni Voitovits
93,500
47
19
7
Rain Mölderkivi
37,500
19
19
8
Julius Seskevicius
51,500
26
20
1
Andrei Melnikov
93,000
47
20
2
Priit Vanem
120,000
60
20
4
Denis Kockinas
96,500
48
20
5
Artiom Goncarenko
76,000
38
20
6
Vesa Oskari Leikos
74,500
37
20
7
Josep Pastor De Ramon
72,000
36
20
8
Arvydas Vilcinskas
27,000
14
20
9
Dainius Antanaitis
50,000
25
21
1
Hans Göran Erlandsson
53,500
27
21
2
Benjamin Arthur Victor Gros
130,500
65
21
4
Jose Larios Domene
87,000
44
21
5
Mark Metsla
47,500
24
21
6
Lari Anttoni Pukkila
80,000
40
21
7
Osku Kalle Karttunen
27,500
14
21
8
Matti Tapani Lasanen
105,000
53
21
9
Sven Reimaa
6,500
3
22
1
Nijat Rustamov
75,500
38
22
2
Uri Gilboa
41,000
21
22
3
Brandon Charles Mifsud
88,500
44
22
4
Helina Tamm
55,000
28
22
5
Martynas Racinskas
98,500
49
22
6
Martin Piik
144,000
72
22
8
Herli Olop
43,500
22
22
9
Keimo I. T. Suominen
78,500
39
29
1
Juho Joonas V Suutari
14,500
7
29
2
Pavels Spirins
71,500
36
29
4
Eero Ilari Lehtinen
61,500
31
29
5
Marco Regonaschi
58,000
29
29
6
Laurynas Cerniauskas
135,500
68
29
7
Harald Redl
101,500
51
29
8
Mario Munoz Martin
63,500
32
29
9
Matiss Celmins
35,000
18
30
1
Madis Müür
131,000
66
30
2
Adria Comas I Roura
87,500
44
30
3
Masoud Mirza Mohammadi
79,000
40
30
4
Mart Rinken
183,500
92
30
6
Kaspars Mallons
110,500
55
30
7
Totti Matias Arosuo
26,000
13
30
9
Renato Messina
49,000
25
10:34 (UTC+2)
Day 2 of King of Tallinn 2023 Started Level: 12 Blinds: 1,000/2,000 Ante: 2,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.