0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0084 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/142/364/updates'
ORDER BY `views` DESC
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '142'
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '142'
0.0289 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '345'
AND `published` = 1
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '353'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '354'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '355'
AND `published` = 1
0.0288 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '356'
AND `published` = 1
0.0385 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0056 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '357'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0051 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '358'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '364'
AND `published` = 1
0.0382 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '372'
AND `published` = 1
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '364'
ORDER BY `busted` ASC, `current_chips` DESC
0.0053 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` = '364'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '16049'
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` = '16020'
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` = '16018'
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` = '16009'
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` = '16007'
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` = '16006'
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` = '15991'
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` = '15988'
ORDER BY `chip_change` DESC, `busted` ASC
0.0166 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15987'
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` = '15959'
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` = '15955'
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` = '15967'
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` = '15952'
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` = '15944'
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` = '15934'
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` = '15931'
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` = '15918'
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` = '15916'
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` = '15926'
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` = '15907'
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` = '15900'
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` = '15898'
ORDER BY `chip_change` DESC, `busted` ASC
0.0171 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15890'
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` = '15891'
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` = '15886'
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` = '15894'
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` = '15892'
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` = '15882'
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` = '15872'
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` = '15870'
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` = '15866'
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` = '15862'
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` = '15859'
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` = '15852'
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` = '15842'
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` = '15833'
ORDER BY `chip_change` DESC, `busted` ASC
0.0170 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15824'
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` = '15811'
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` = '15799'
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` = '15798'
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` = '15796'
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` = '15788'
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` = '15786'
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` = '15771'
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` = '15764'
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` = '15763'
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` = '15754'
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` = '15751'
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` = '15746'
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` = '15728'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15715'
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` = '15714'
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` = '15705'
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` = '15698'
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` = '15689'
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` = '15683'
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` = '15679'
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` = '15671'
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` = '15670'
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` = '15660'
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` = '15653'
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` = '15650'
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` = '15645'
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` = '15642'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15624'
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` = '15608'
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` = '15609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '345'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '353'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '357'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '358'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '364'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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` = '364'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '16049'
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` = '16020'
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` = '16018'
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` = '16009'
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` = '16007'
ORDER BY `chip_change` DESC, `busted` ASC
0.0170 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '16006'
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` = '15991'
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` = '15988'
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` = '15987'
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` = '15959'
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` = '15955'
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` = '15967'
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` = '15952'
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` = '15944'
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` = '15934'
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` = '15931'
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` = '15918'
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` = '15916'
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` = '15926'
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` = '15907'
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` = '15900'
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` = '15898'
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` = '15890'
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` = '15891'
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` = '15886'
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` = '15894'
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` = '15892'
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` = '15882'
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` = '15872'
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` = '15870'
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` = '15866'
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` = '15862'
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` = '15859'
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` = '15852'
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` = '15842'
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` = '15833'
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` = '15824'
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` = '15811'
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` = '15799'
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` = '15798'
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` = '15796'
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` = '15788'
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` = '15786'
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` = '15771'
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` = '15764'
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` = '15763'
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` = '15754'
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` = '15751'
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` = '15746'
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` = '15728'
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` = '15715'
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` = '15714'
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` = '15705'
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` = '15698'
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` = '15689'
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` = '15683'
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` = '15679'
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` = '15671'
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` = '15670'
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` = '15660'
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` = '15653'
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` = '15650'
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` = '15645'
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` = '15642'
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` = '15624'
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` = '15608'
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` = '15609'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '364'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '372'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Olympic Park Casino
Event #6: €1M GTD €1,500 NLH Main Event
Live Reporting - Day 4
Day 3 of Olympic Park Casino Ended Level: 32 Blinds: 75,000/100,000 Ante: 100,000
Final Table Seat Draw Posted Sunday 28th July, 2024 at 03:42(UTC+2) by Jason Glatzer
Seat
Name
Country
Chips
Big Blinds
1
Roberto Ahane Olsen
Sweden
6,925,000
46
2
Sergei Aleksejev
Estonia
3,500,000
23
3
Evgeny Vyal
Estonia
3,275,000
22
4
Kriss Riekstins
Latvia
2,000,000
13
5
Espen Smorholm Sandvik
Norway
1,900,000
13
6
Jeffrey Cormier
Canada
11,850,000
79
7
Yurii Zabrodotskyi
Ukraine
6,975,000
47
8
Mindaugas Kriauciunas
Lithuania
2,700,000
18
9
Aurimas Stanevicius
Lithuania
1,425,000
10
Enea Subashi Eliminated in 10th Place (€13,800) Posted Sunday 28th July, 2024 at 03:38(UTC+2) by Jason Glatzer
Level 29: 75,000/150,000 (150,000) Entries: 9/812
Roberto Olsen opened for 300,000 from under the gun before Enea Subashi three-bet jammed for 875,000. Jeffrey Cormier four-bet shoved for 5,400,000 and Olsen called.
Enea Subashi: Jeffrey Cormier: Roberto Olsen:
It appeared likely that we would restart tomorrow with a eight-player final table. However, Cormier remained hot and asked for a ten.
A ten was asked, and a ten was received on the runout as Cormier won the main pot and side pot to eliminate Olsen on the final table bubble and double through Subashi to take the chip lead away from Olsen near the end of the night.
The action will resume for the final table at noon on Sunday with our coverage beginning at 12:30 p.m. to sync with the live-stream of the final table at OlyBet.tv.
Player
Chips
Progress
Jeffrey Cormier
11,850,000
6,850,000
Yurii Zabrodotskyi
6,975,000
2,650,000
Roberto Olsen
6,925,000
200,000
Sergei Aleksejev
3,500,000
1,100,000
Evgeny Vyal
3,275,000
1,325,000
Mindaugas Kriauciunas
2,700,000
750,000
Kriss Riekstins
2,000,000
500,000
Espen Sandvik
1,900,000
600,000
Aurimas Stanevicius
1,425,000
1,600,000
Enea Subashi
0
0
Riekstins Doubles Through Sandvik Posted Sunday 28th July, 2024 at 02:58(UTC+2) by Jason Glatzer
Just about every elimination is taking place at the feature table. You will have to watch the action to get the hand breakdown, but Gunnar Wedde had his stack of around a dozen big blinds committed with and was up against the held by Roberto Olsen.
"Good game," said Wedde after the ran out on the board.
Player
Chips
Progress
Roberto Olsen
7,800,000
4,325,000
Gunnar Wedde
0
0
Ignotas Tamasauskas Eliminated in 12th Place (€11,200) Posted Sunday 28th July, 2024 at 00:34(UTC+2) by Jason Glatzer
Yet another elimination took place at the televised feature table. This time, it was Ignotas Tamasauskas who hit the rail in 12th place when his was no good for about 16 big blinds against the held by Aurimas Stanevicius after the ran out on the board.
Player
Chips
Progress
Aurimas Stanevicius
4,000,000
2,470,000
Ignotas Tamasauskas
0
0
00:10 (UTC+2)
Start of Level 31 Blinds: 50,000/125,000 Ante: 125,000
Vilius Zabarauskas Eliminated in 13th Place (€13,200) Posted Saturday 27th July, 2024 at 23:43(UTC+2) by Jason Glatzer
As of late, all the eliminations have occurred at the televised feature table. Vilius Zabarauskas was the latest to go. He jammed a short stack from the button and was called by Enea Subashi from the big blind.
Vilius Zabarauskas: Enea Subashi:
Zabarauskas was ahead but fell to Subashi's trips in 13th place for €13,200 after the ran out on the board.
Player
Chips
Progress
Enea Subashi
1,700,000
440,000
Vilius Zabarauskas
0
0
Marius Morel Eliminated in 14th Place (€9,200) Posted Saturday 27th July, 2024 at 23:29(UTC+2) by Jason Glatzer
Estonian hero Marius Morel just hit the rail, while Jeffrey Cormier continues to run red-hot at the final table. In this last hand, he even called the river card.
Morel got his short stack in at the feature table with and was up against the held by Jeffrey Cormier.
Cormier asked for a queen on the river and one came to keep his sixes safe on the runout for Morel to exit in 14th place.
Player
Chips
Progress
Jeffrey Cormier
5,500,000
2,535,000
Marius Morel
0
0
23:28 (UTC+2)
Start of Level 30 Blinds: 50,000/100,000 Ante: 100,000
Vilde Fagerbakke Eliminated in 15th Place (€9,200) Posted Saturday 27th July, 2024 at 23:28(UTC+2) by Jason Glatzer
Level 26: 40,000/80,000 (80,000) Entries: 14/812
Vilde Fagerbakke got her last million or so chips in against Jeffrey Cormier at the feature table. You can check out the action at OlyBet.tv.
Vilde Fagerbakke: Jeffrey Cormier:
Cormier celebrated after his fours held to oust Fagerbakke in 15th place for €9,200. The clock paused after this hand for a chip race of the 5,000 chips.
Player
Chips
Progress
Jeffrey Cormier
4,000,000
1,035,000
Vilde Fagerbakke
0
0
Sohrab Malkari Eliminated in 16th Place (€8,001) Posted Saturday 27th July, 2024 at 23:11(UTC+2) by Jason Glatzer
Level 26: 40,000/80,000 (80,000) Entries: 15/812
Sohrab Malkari lost most of his stack when his was unable to hold against Kriss Riekstins's on the runout.
The rest went shortly after when he jammed into the held by Yurii Zabrodotskyi. The ran out on the board for Malkari to hit the rail in 16th place for €8,001.
Player
Chips
Progress
Yurii Zabrodotskyi
3,000,000
605,000
Kriss Riekstins
2,300,000
1,260,000
Sohrab Malkari
0
0
Gunnar Wedde Leads Final Two Tables Posted Saturday 27th July, 2024 at 22:32(UTC+2) by Jason Glatzer
Player
Chips
Progress
Gunnar Wedde
4,545,000
1,735,000
Espen Sandvik
4,065,000
250,000
Ignotas Tamasauskas
3,855,000
45,000
Sergei Aleksejev
3,750,000
25,000
Evgeny Vyal
3,615,000
600,000
Roberto Olsen
3,475,000
405,000
Jeffrey Cormier
2,965,000
135,000
Mindaugas Kriauciunas
2,650,000
280,000
Yurii Zabrodotskyi
2,580,000
220,000
Sohrab Malkari
2,440,000
565,000
Aurimas Stanevicius
1,530,000
1,095,000
Enea Subashi
1,260,000
610,000
Vilde Fagerbakke
1,070,000
430,000
Kriss Riekstins
1,040,000
260,000
Marius Morel
945,000
1,155,000
Vilius Zabarauskas
815,000
2,405,000
Slack Elimination in 17th Place (€8,001) Posted Saturday 27th July, 2024 at 22:32(UTC+2) by Alaxandar Georgiev
Level 26: 40,000/80,000 (80,000) Entries: 17/812
Blind-on-blind action between Ben Slack and Espen Sandvik on the big blind. Slack jammed for 1,300,000 chips and Sandvik called him real quick.
Ben Slack: Espen Sandvik:
Slack needed to hit one of the other 3 aces or some other combination to stay in and fight for the big money. The flop came king high and there weren't any aces showing, the turn was another club and now Slack was also drawing to make a flush.
The river meant it was time to shake hands and say goodbyes for Slack. He finished the tournament in 17th place and took home €8,001.
Player
Chips
Progress
Espen Sandvik
4,400,000
585,000
Ben Slack
0
0
Wedde Gets Paid With Big Slick Posted Saturday 27th July, 2024 at 22:25(UTC+2) by Jason Glatzer
Level 26: 40,000/80,000 (80,000) Entries: 17/812
Gunnar Wedde fired a pot-sized bet of 900,000 with the on the board after the river. Yurii Zabrodotskyi went into the tank for a couple of minutes before he called.
Wedde turned over an unbeatable hand with to win the pot after Zabrodotskyi tossed his cards face down into the muck.
Player
Chips
Progress
Gunnar Wedde
4,000,000
1,190,000
Yurii Zabrodotskyi
2,000,000
185,000
Fagerbakke Doubles With Ace-Ten Posted Saturday 27th July, 2024 at 22:03(UTC+2) by Jason Glatzer
Level 26: 40,000/80,000 (80,000) Entries: 17/812
Yurii Zabrodotskyi mini-raised from the hijack before Vilde Fagerbakke three-bet jammed for 655,000 from the cutoff. Zabrodotskyi asked for a count before he found a call.
Vilde Fagerbakke: Yurii Zabrodotskyi:
Ace-ten was good on the runout for Fagerbakke to double her short stack.
Player
Chips
Progress
Yurii Zabrodotskyi
2,800,000
615,000
Vilde Fagerbakke
1,500,000
165,000
22:03 (UTC+2)
Start of Level 29 Blinds: 40,000/80,000 Ante: 80,000
Lucky Double for Olsen Posted Saturday 27th July, 2024 at 22:03(UTC+2) by Jason Glatzer
Level 25: 30,000/60,000 (60,000) Entries: 17/812
Roberto Olsen was nearly on the rail but instead now has a healthy stack. Olsen opened for 125,000 from under the gun. Ignotas Tamasauskas raised to 425,000 from the small blind. Olsen four-bet jammed for 1,650,000 and Tamasauskas called.
Roberto Olsen: Ignotas Tamasauskas:
"Oh no," said Olsen when the cards were tabled.
Olsen got there with two pair on the runout to stave off elimination.
Player
Chips
Progress
Ignotas Tamasauskas
3,900,000
100,000
Roberto Olsen
3,400,000
1,880,000
Nohad Teliani Eliminated in 18th Place (€6,900) Posted Saturday 27th July, 2024 at 21:29(UTC+2) by Jason Glatzer
Level 25: 30,000/60,000 (60,000) Entries: 17/812
Over at the feature table, Nohad Teliani lost her stack to Evgeny Vyal when her was unable to hold against . You can watch the hand on the stream at OlyBet.tv.
Meanwhile, this leaves Vilde Fagerbakke as the last lady standing in the Main Event.
Player
Chips
Progress
Nohad Teliani
0
0
Liutauras Armanavicius Eliminated in 19th Place (€6,900) Posted Saturday 27th July, 2024 at 21:21(UTC+2) by Jason Glatzer
Level 25: 30,000/60,000 (60,000) Entries: 18/812
Liutauras Armanavicius jammed his short stack of 295,000 from the hijack. Roberto Olsen asked for a count before he jammed for a bit more from the small blind.
Liutauras Armanavicius: Roberto Olsen:
The board was unable to save Armanavicius and he was eliminated in 19th place for €6,900.
Player
Chips
Progress
Roberto Olsen
2,000,000
480,000
Liutauras Armanavicius
0
0
Matte Karjalainen Eliminated in 20th Place (€6,900) Posted Saturday 27th July, 2024 at 21:08(UTC+2) by Jason Glatzer
Level 25: 30,000/60,000 (60,000) Entries: 19/812
Matte Karjalainen had his short stack in good at the televised feature table with and was up against the held by Marius Morel.
Morel got there for a straight on the board to eliminate Karjalainen in 20th place for €6,900.
Player
Chips
Progress
Marius Morel
2,100,000
550,000
Matte Karjalainen
0
0
Slack Doubles Through Armanavicius Posted Saturday 27th July, 2024 at 21:06(UTC+2) by Jason Glatzer
Level 25: 30,000/60,000 (60,000) Entries: 20/812
Ben Slack jammed for 885,000 from the cutoff. Liutauras Armanavicius asked for a count from the button before eventually jamming over the top for a bit more.
Ben Slack: Liutauras Armanavicius:
Slack doubled his stack after the safely ran out on the board.
Player
Chips
Progress
Ben Slack
1,850,000
815,000
Liutauras Armanavicius
650,000
875,000
Robert Rudolf Rohr Eliminated in 21st Place (€6,100) Posted Saturday 27th July, 2024 at 20:59(UTC+2) by Jason Glatzer
Level 25: 30,000/60,000 (60,000) Entries: 20/812
Ignotas Tamasauskas opened for 125,000 from the cutoff. Robert Rohr three-bet jammed the button for around 720,000, and Tamasauskas called.
Robert Rohr: Ignotas Tamasauskas:
Tamasauskas nailed a set on the runout to win the flip and eliminate Rohr in 20th place for €6,100.
Player
Chips
Progress
Ignotas Tamasauskas
4,000,000
695,000
Robert Rohr
0
0
WSCOPC €350 Online Ring Event Posted Saturday 27th July, 2024 at 20:51(UTC+2) by Lina Olofsson
For anyone who wants to be in on the action but couldn't make it here to Tallinn the Online Event started 45 minutes ago on Olybet. It's open to all players in Estonia, Lithuania, Finland, and Latvia and so far 88 players bought in and compete for the 11th golden ring.
Late registration is open until 11 pm for the ones who feel urged to play and has an account with Olybet.
20:44 (UTC+2)
Start of Level 28 Blinds: 30,000/60,000 Ante: 60,000
Sandvik Leads at Break Posted Saturday 27th July, 2024 at 20:01(UTC+2) by Jason Glatzer
Espen Sandvik leads the way at the dinner break over the 21 hopefuls remaining the 2024 WSOP Circuit Tallinn €1,500 Main Event.
Check out the full chip counts at the break:
Player
Chips
Progress
Espen Sandvik
3,815,000
185,000
Sergei Aleksejev
3,725,000
745,000
Ignotas Tamasauskas
3,305,000
2,325,000
Vilius Zabarauskas
3,220,000
780,000
Evgeny Vyal
3,015,000
1,460,000
Jeffrey Cormier
2,830,000
475,000
Gunnar Wedde
2,810,000
1,095,000
Mindaugas Kriauciunas
2,370,000
695,000
Yurii Zabrodotskyi
2,185,000
860,000
Sohrab Malkari
1,875,000
115,000
Vilde Fagerbakke
1,665,000
585,000
Marius Morel
1,550,000
690,000
Liutauras Armanavicius
1,525,000
240,000
Roberto Olsen
1,520,000
1,020,000
Ben Slack
1,035,000
365,000
Robert Rohr
895,000
755,000
Kriss Riekstins
780,000
720,000
Nohad Teliani
755,000
305,000
Enea Subashi
650,000
265,000
Matte Karjalainen
640,000
435,000
Aurimas Stanevicius
435,000
1,375,000
Dinner Time Posted Saturday 27th July, 2024 at 19:52(UTC+2) by Jason Glatzer
Players are on a one-hour dinner break. When the action resumes, blinds will increase to 30,000/60,000 (60,000).
Jaarko Soukas Eliminated in 22rd Place (€6,100) Posted Saturday 27th July, 2024 at 19:46(UTC+2) by Jason Glatzer
Level 24: 25,000/50,000 (50,000) Entries: 21/812
Jaarko Suokas jammed for 615,000 from late position and was called by Espen Sandvik from the small blind.
Jaarko Soukas: Espen Sandvik:
Aces held to oust Suokas in 23rd place for €6,100 after the ran out on the board.
Player
Chips
Progress
Espen Sandvik
4,000,000
500,000
Jarkko Suokas
0
0
Aleksei Vandyshev Eliminated in 23rd Place (€6,100) Posted Saturday 27th July, 2024 at 19:32(UTC+2) by Jason Glatzer
Level 24: 25,000/50,000 (50,000) Entries: 22/812
Aleksei Vandyshev had crumbs in his stack when his 35,000 in chips went in from middle position. Ignotas Tamasauskas raised to 100,000 and Roberto Olsen defended his big blind.
Olsen check-called bets of 50,000 on the flop and for 300,000 on the turn before both players checked the river. Vandyshev was out the door with , while Olsen held . Meanwhile, Tamasauskas won the hand with to take down the pot.
Player
Chips
Progress
Ignotas Tamasauskas
2,500,000
1,665,000
Roberto Olsen
600,000
100,000
Aleksei Vandyshev
0
0
Tamasauskas Doubles With Big Slick Posted Saturday 27th July, 2024 at 19:22(UTC+2) by Jason Glatzer
Level 24: 25,000/50,000 (50,000) Entries: 23/812
Ignotas Tamasauskas four-bet jammed for 1,050,000 and was called by Robert Rohr.
Ignotas Tamasauskas: Robert Rohr:
There was a bit of drama after the turn but the river put things back where they were preflop after the board results in Tamasauskas doubling through Rohr.
Player
Chips
Progress
Ignotas Tamasauskas
2,300,000
1,465,000
Robert Rohr
1,650,000
115,000
18:50 (UTC+2)
Start of Level 27 Blinds: 25,000/50,000 Ante: 50,000
Kaspar Kaisel Eliminated in 24th Place (€5,400) Posted Saturday 27th July, 2024 at 18:49(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 23/812
Kaspar Kaisel committed his seven big blind stack and got it in good against Aleksei Vandyshev.
Kaspar Kaisel: Aleksei Vandyshev:
Kaisel was far ahead after the flop. The turn improved to Vandyshev to a full house much to the dismay of Kaisel.
"Good game," Kaisel said after not getting back up front on the river.
Player
Chips
Progress
Aleksei Vandyshev
1,200,000
110,000
Kaspar Kaisel
0
0
Malkari Wins a Flip With Sevens Posted Saturday 27th July, 2024 at 18:46(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 24/812
Sohrab Malkari opened from under the gun before he called a three-bet jam by Roberto Olsen from the big blind for 850,000.
Sohrab Malkari: Roberto Olsen:
Malkari won the flip to stay alive and double his stack after the ran out on the board.
Player
Chips
Progress
Sohrab Malkari
1,760,000
855,000
Roberto Olsen
700,000
895,000
Big Slick for Sandvik Posted Saturday 27th July, 2024 at 18:21(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 24/812
Espen Sandvik opened for 80,000 from middle position. Vilius Zabarauskas three-bet to 230,000 from one seat over, and Sandvik called.
Sandvik check-called a bet of 160,000 by Zabarauskas on the flop before check-calling a bet of 225,000 on the turn. The river completed the board. Sandvik led out for a small sizing of 130,000. Zabarauskas went into the tank before he called.
Sandvik tabled the and won the hand after Zabarauskas mucked his cards.
Player
Chips
Progress
Vilius Zabarauskas
4,000,000
635,000
Espen Sandvik
3,500,000
605,000
Delay and Chip Counts Posted Saturday 27th July, 2024 at 17:39(UTC+2) by Jason Glatzer
Our reporting will now be on a 30-minute delay so as not to give away any spoilers from the stream.
Vilius Zabarauskas had the chip lead over the final 24 players. Check out the full chip counts below:
Player
Chips
Progress
Vilius Zabarauskas
4,635,000
2,800,000
Sergei Aleksejev
4,470,000
170,000
Jeffrey Cormier
3,305,000
255,000
Espen Sandvik
2,895,000
980,000
Aurimas Stanevicius
1,810,000
150,000
Gunnar Wedde
1,715,000
625,000
Mindaugas Kriauciunas
1,675,000
765,000
Roberto Olsen
1,595,000
405,000
Evgeny Vyal
1,555,000
170,000
Robert Rohr
1,535,000
165,000
Kriss Riekstins
1,500,000
1,200,000
Ben Slack
1,400,000
200,000
Kaspar Kaisel
1,375,000
90,000
Yurii Zabrodotskyi
1,325,000
1,245,000
Jarkko Suokas
1,315,000
5,000
Liutauras Armanavicius
1,285,000
215,000
Aleksei Vandyshev
1,090,000
400,000
Vilde Fagerbakke
1,080,000
30,000
Matte Karjalainen
1,075,000
925,000
Enea Subashi
915,000
880,000
Sohrab Malkari
905,000
75,000
Marius Morel
860,000
245,000
Ignotas Tamasauskas
835,000
370,000
Nohad Teliani
450,000
300,000
Pihela Jr. Loses Flip to Aleksejev Posted Saturday 27th July, 2024 at 17:13(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 24/812
Igor Pihela Jr three-bet jammed for more than 700,000 from the blinds and was called by Sergei Aleksejev, who originally opened from early position.
Igor Pihela Jr: Sergei Aleksejev:
Aleksejev's ace found a partner on the board to eliminate Pihela in 25th place. Robert Kaggerud also recently hit the rail in 26th place, shortly before Aleksejev.
Player
Chips
Progress
Sergei Aleksejev
4,300,000
500,000
Robert Kaggerud
0
0
Igor Pihela Jr
0
0
16:58 (UTC+2)
Start of Level 26 Blinds: 20,000/40,000 Ante: 40,000
Krumins Bricks Flush Draw Posted Saturday 27th July, 2024 at 16:58(UTC+2) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 26/812
Eriks Krumins was aiming to win his second WSOP Circuit Tallinn ring this festival in a huge way but just hit the rail in 29th place to Sergei Aleksejev.
Krumins committed his stack from the blinds with and was up against the of Aleksejev on the flop. Krumins bricked the turn and river to exit to Aleksejev's straight.
Player
Chips
Progress
Sergei Aleksejev
3,800,000
1,675,000
Mairo Tori
0
0
Juuso Koskela
0
0
Roope Tarmi
0
0
Eriks Krumins
0
0
Day 8 Video Recap Posted Saturday 27th July, 2024 at 16:53(UTC+2) by Jason Glatzer
Krumins Busts Petelytskyi Posted Saturday 27th July, 2024 at 16:30(UTC+2) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 30/812
Roman Petelytskyi jammed his short stack from late position and was called by Event #1: €250 NLH champion Eriks Krumins from the big blind.
Roman Petelytskyi: Eriks Krumins:
Krumins connected with his jack to finish with a better two pair to eliminate Petelytskyi in 31st place with Gregory Telman and Elias Suhonen also hitting the rail during Level 25.
Player
Chips
Progress
Eriks Krumins
1,100,000
805,000
Gregory Telman
0
0
Roman Petelytskyi
0
0
Elias Suhonen
0
0
Malkari Doubles With Sixes Posted Saturday 27th July, 2024 at 16:23(UTC+2) by Jason Glatzer
Level 25: 15,000/30,000 (30,000) Entries: 31/812
Sohrab Malkari jammed from early position and was called by Roberto Olsen from the blinds.
Sohrab Malkari: Roberto Olsen:
Malkari's sixes won the flip on the runout, but Malkari stood up, appearing to some, including Jeffrey Cormier, as ready to go.
"You won the hand," said Cormier.
"I know," said Malkari, now getting ready to sit back down after breathing a huge sigh of relief. "I am not stupid."
"Nice hand," Olsen said soon after before addressing the table. "He deserved it after the hand before."
Player
Chips
Progress
Roberto Olsen
2,000,000
1,435,000
Sohrab Malkari
980,000
525,000
New TV Table Line-Up and Chip Counts Posted Saturday 27th July, 2024 at 16:00(UTC+2) by Jason Glatzer
There will be a new TV table live on air soon at OlyBet.tv. Check out the line-up and chip counts below:
Player
Chips
Progress
Aurimas Stanevicius
1,960,000
10,000
Vilius Zabarauskas
1,835,000
725,000
Enea Subashi
1,795,000
780,000
Evgeny Vyal
1,385,000
85,000
Mindaugas Kriauciunas
910,000
655,000
Roope Tarmi
835,000
415,000
Gregory Telman
495,000
225,000
15:49 (UTC+2)
Start of Level 25 Blinds: 15,000/30,000 Ante: 30,000
Cormier Leads at Break Posted Saturday 27th July, 2024 at 15:44(UTC+2) by Jason Glatzer
Jeffrey Cormier took the chip lead at the TV table after a blind vs. blind cooler against Elias Suhonen.
Cormier flopped a set, while Suhonen flopped two pair. You won't have to rewind much to check it out on the stream at OlyBet.tv.
Player
Chips
Progress
Jeffrey Cormier
3,050,000
2,595,000
Sergei Aleksejev
2,125,000
1,897,000
Matte Karjalainen
2,000,000
1,520,000
Aurimas Stanevicius
1,950,000
50,000
Espen Sandvik
1,915,000
1,645,000
Eriks Krumins
1,905,000
595,000
Vilius Zabarauskas
1,835,000
765,000
Vilius Zabarauskas
1,795,000
725,000
Robert Rohr
1,700,000
1,447,000
Second Break Posted Saturday 27th July, 2024 at 15:23(UTC+2) by Jason Glatzer
Players are on their second break. Blinds will increase to 15,000/30,000 (30,000) when the action resumes in 20 minutes.
Haapaniemi Loses Short Stack Posted Saturday 27th July, 2024 at 15:21(UTC+2) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 33/812
Ignotas Tamasauskas jammed the button for 375,000. Sauli Haapaniemi (pictured below) called off his tiny stack of 55,000 from the small blind and was pleased to see he had two live cards.
Sauli Haapaniemi: Ignotas Tamasauskas:
Ace-ten held on the runout to eliminate Haapaniemi in 34th place.
Player
Chips
Progress
Ignotas Tamasauskas
465,000
750,000
Sauli Haapaniemi
0
0
Set of Ducks for Krumins Posted Saturday 27th July, 2024 at 15:16(UTC+2) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 34/812
Rubens Akopjancs opened from middle position to 50,000. Event #1: €250 NLH champion Eriks Krumins three-bet to 150,000 from the cutoff and Akopjancs called.
Akopjancs check-raised the flop from 150,000 to 300,000 and Krumins called. Akopjancs jammed for less than 800,000 on the turn. Krumins snap-called and had his opponent drawing to two outs for his tournament life.
Rubens Akopjancs: Eriks Krumins:
Bottom set held after the river completed the board to eliminate Akopjancs. Meanwhile, Henri Katila and Laurynas Vaitkevicius hit the rail to leave 34 players remaining with the break minutes away.
Player
Chips
Progress
Eriks Krumins
2,500,000
1,400,000
Laurynas Vaitkevicius
0
0
Henri Katila
0
0
Rubens Akopjancs
0
0
Klezys Loses Flip to Vyal Posted Saturday 27th July, 2024 at 14:40(UTC+2) by Jason Glatzer
Level 24: 10,000/25,000 (25,000) Entries: 37/812
Kasparas Klezys jammed the button for 530,000. Evgeny Vyal asked for a count before he called from the small blind for more than half his stack. Mindaugas Kriauciunas folded his short stack from the big blind and the cards were turned over.
Kasparas Klezys: Evgeny Vyal:
Klezys was ahead until the river. He said "good game" to the rest of the table after losing the flip and ending up in 38th place on the board.
Meanwhile, start-of-the-day chip leader Paul Koppe, Juuso Oksanen, and Niko Ilmonen also exited recently.
Player
Chips
Progress
Evgeny Vyal
1,300,000
510,000
Niko Ilmonen
0
0
Juuso Oksanen
0
0
Paul Koppe
0
0
Kasparas Klezys
0
0
14:24 (UTC+2)
Start of Level 24 Blinds: 10,000/25,000 Ante: 25,000
Fagerbakke and Teliani Final Two Women Posted Saturday 27th July, 2024 at 14:21(UTC+2) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 41/812
Vilde Fagerbakke and Nohad Teliani (both pictured below) were the final two women in the Main Event to start the day. They have witnessed more than a couple of dozen players hit the rail in their quest to make tomorrow's final table of nine players for a chance to win the Main Event.
We wish both ladies the best of luck. Along with the other players, we will keep you updated on their progress throughout the day.
Player
Chips
Progress
Vilde Fagerbakke
1,050,000
210,000
Nohad Teliani
750,000
95,000
Stanevicius Eliminates Stankevics Posted Saturday 27th July, 2024 at 14:02(UTC+2) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 43/812
Gunnar Wedde survived a scare with ace-queen against Igor Pihela Jr's ace-king on a double-paired board as another all-in and call was taking place at the table behind this action.
Krisjanis Stankevics jammed for approximately a dozen big blinds from early position. Aurimas Stanevicius (pictured below) paused for a few moments from a few seats over before he called while the rest of the table folded.
Krisjanis Stankevics: Aurimas Stanevicius:
Stanevicius ousted Stankevics after the ran out on the board, while Andre Villandberg, Jukka Moisio, and Daniel Clifford all hit the rail to leave just 41 players remaining.
Player
Chips
Progress
Aurimas Stanevicius
1,900,000
350,000
Krisjanis Stankevics
0
0
Daniel Clifford
0
0
Jukka Moisio
0
0
Andre Villandberg
0
0
Parnat Runs Into Slack's Cowboys Posted Saturday 27th July, 2024 at 13:48(UTC+2) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 45/812
Ben Slack opened from middle position for 45,000. Risto Parnat three-bet jammed for about a dozen big blinds from the button and Slack snap-called.
Risto Parnat: Ben Slack:
Slack nailed a set on the flop. Parnat had some thin hope and asked for his "one-time" after the followed on the turn.
A blank on the river ended Parnat's deep run in the Main Event in 46th place, with Joshua Stewart hitting the rail just before Parnat.
Player
Chips
Progress
Ben Slack
1,200,000
670,000
Joshua Stewart
0
0
Risto Parnat
0
0
Berggren Loses Short Stack to Tori Posted Saturday 27th July, 2024 at 13:32(UTC+2) by Jason Glatzer
Level 23: 10,000/20,000 (20,000) Entries: 47/812
Mairo Tori opened for 45,000 from the cutoff. Christoffer Berggren three-bet jammed for about five big blinds from the button, and Tori called.
Christopher Berggren: Mairo Tori:
Although Berggren had some draws on the turn, he lost to Tori's straight after the ran out on the board.
Player
Chips
Progress
Mairo Tori
750,000
250,000
Victor Fernandez Garcia
0
0
Christopher Berggren
0
0
13:25 (UTC+2)
Start of Level 23 Blinds: 10,000/20,000 Ante: 20,000
Big Stacks at Break Posted Saturday 27th July, 2024 at 13:21(UTC+2) by Jason Glatzer
Player
Chips
Progress
Enea Subashi
2,575,000
25,000
Yurii Zabrodotskyi
2,570,000
1,225,000
Rubens Akopjancs
2,300,000
810,000
Aurimas Stanevicius
1,550,000
400,000
Elias Suhonen
1,510,000
250,000
Jarkko Suokas
1,310,000
750,000
Vilde Fagerbakke
1,260,000
1,150,000
Eriks Krumins
1,100,000
495,000
First Break Posted Saturday 27th July, 2024 at 13:04(UTC+2) by Jason Glatzer
Players are on a 20-minute break. Blinds will increase to 10,000/20,000 with a 20,000 big blind ante when the action resumes.
Subashi Chipping Up Posted Saturday 27th July, 2024 at 13:03(UTC+2) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 49/812
Enea Subashi jammed for more than the 500,000 or so that Nicolai Ejstrud had in his stack with a four-five-six-seven on the board after the river.
Ejstrud eventually called and turned over the . Subashi turned over the for the straight to take Ejstrud's stack.
Player
Chips
Progress
Enea Subashi
2,600,000
945,000
Tero Kilkanen
0
0
Nicolai Ejstrud
0
0
Ermo Kosk
0
0
Recent Eliminations Posted Saturday 27th July, 2024 at 12:47(UTC+2) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 52/812
The following players recently were eliminated from the Main Event, leaving just 52 players remaining.
Player
Chips
Progress
Matias Kesanen
0
0
Andre Grigorjev
0
0
Mauri Dorbek
0
0
Sondre Lunde
0
0
Janis Leja
0
0
Nicklas Dehli
0
0
Lindberg Loses Flip to Armanavicius Posted Saturday 27th July, 2024 at 12:29(UTC+2) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 58/812
Bjorn Lindberg four-bet jammed for 365,000 and was called by Liutauras Armanavicius.
Bjorn Lindberg: Liutauras Armanavicius:
Lindberg got out of his chair and was ready to go despite improving to the top pair in the flop. Although this was normally good, in this case, Armanavicius improved to a set.
Lindberg had more hope on the turn but bricked the to end his Day 3 run early.
Player
Chips
Progress
Liutauras Armanavicius
1,500,000
345,000
Markku Koplimaa
0
0
Rustam Havryliuk
0
0
Tapio Aaltonen
0
0
Artur Kulanurk
0
0
Bjorn Lindberg
0
0
Jacks Good for Teliani Posted Saturday 27th July, 2024 at 12:20(UTC+2) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 63/812
Daniel Clifford opened for 30,000 from early position. Nohad Teliani three-bet to 110,000 from one seat over before Robert Kaggerud four-bet shoved for about 900,000. Clifford quickly folded, while Teliani needed about 20 seconds to call off her stack of 345,000.
Nohad Teliani: Robert Kaggerud:
Jacks beat tens on the runout for Teliani to earn an early double. Meanwhile, five players already hit the rail in the early moments including former OlyBet Poker manager Martin Piik.
Player
Chips
Progress
Nohad Teliani
845,000
345,000
Robert Kaggerud
540,000
360,000
Martin Piik
0
0
Andrei Silencov
0
0
Konstantin Farber
0
0
Jyri Merivirta
0
0
Steven Tool
0
0
Chip Leader Paul Koppe at TV Table Posted Saturday 27th July, 2024 at 12:14(UTC+2) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 68/812
The feature table has just kicked off with the action starting at OlyBet.tv at 12:30 p.m. with hole cards exposed.
Chip leader Paul Koppe, Estonian poker beast Markku Koplimaa, and Canada's Jeffrey Cormier are among the players at the table.
Cards in the Air Posted Saturday 27th July, 2024 at 12:03(UTC+2) by Jason Glatzer
Level 22: 10,000/15,000 (15,000) Entries: 68/812
Cards are in the air to start the penultimate day of the Main Event.
Paul Koppe Leads Final 68 Players in 2024 WSOP Circuit Tallinn Main Event Posted Saturday 27th July, 2024 at 10:41(UTC+2) by Jason Glatzer
Day 2 of the 2024 WSOP Circuit €1,500 Main Event made history at Olympic Park Casino and the Hilton Tallinn Park on Friday. 119 new entries came into the mix before late registration closed on Day 2, bringing the field up to 812 entries. The €1,052,352 prize pool crushed the €1,000,000 guarantee and set a new record for the largest event in Olympic Tallinn Park history.
The action played well past the money bubble, which paid the top 103 entries at least a €3,000 min-cash for double the €1,500 buy-in after Estonian poker hero Igor Pihela Jr. delivered a bad beat with ace-jack vs. ace-king on an ace-high board to eliminate Finland's Nemo Israel emptyhanded.
Estonia's Paul Koppe leads the way with 1,660,000, with Greece's Enea Subashi just a chip behind with 1,655,000. Meanwhile, Eriks Krumins, who already won a WSOP Circuit gold ring this festival in Event #1: €250 NLH, is looking for their most prestigious ring, ending Day 2 in third place with 1,595,000. Fellow Latvian Rubens Akopjancs (fourth - 1,490,000) and Estonia's Kaspar Kaisel (1,465,000)
Place
Name
Country
Chips
Big Blinds
1
Paul Koppe
Estonia
1,660,000
111
2
Enea Subashi
Greece
1,655,000
110
3
Eriks Krumins
Latvia
1,595,000
106
4
Rubens Akopjancs
Latvia
1,490,000
99
5
Kaspar Kaisel
Estonia
1,465,000
98
6
Yurii Zabrodotskyi
Ukraine
1,345,000
90
7
Elias Suhonen
Finland
1,260,000
84
8
Ignotas Tamasauskas
Lithuania
1,215,000
81
9
Liutauras Armanavicius
Lithuania
1,155,000
77
10
Aurimas Stanevicius
Lithuania
1,150,000
77
Cards will be back in the air at noon on Saturday, with Day 3 playing down to a final table of nine players with one-hour blind levels. We will update you on the side tables while WSOP Circuit commentator George Sandford will hold down the commentating booth with guests throughout the day on the live-streamed feature table. You can check both out at OlyBet.tv.
Day 3 Seat Draw Posted Saturday 27th July, 2024 at 09:36(UTC+2) by Jason Glatzer
Table
Seat
Name
Country
Chips
Big Blinds
12
1
Risto Parnat
Estonia
325,000
22
12
2
Robert Kaggerud
Norway
900,000
60
12
3
Roman Petelytskyi
Ukraine
305,000
20
12
4
Daniel Clifford
Sweden
505,000
34
12
5
Nohad Teliani
Canada
500,000
33
12
6
Artur Külanurk
Estonia
60,000
4
12
7
Robert Rohr
Germany
253,000
17
12
8
Ignotas Tamasauskas
Lithuania
1,215,000
81
13
1
Gunnar Wedde
Norway
1,090,000
73
13
2
Marius Morel
Estonia
1,105,000
74
13
3
Andre Villandberg
Estonia
585,000
39
13
4
Mairo Tori
Estonia
500,000
33
13
5
Christopher Berggren
Sweden
515,000
34
13
6
Konstantin Färber
Germany
100,000
7
13
7
Vilde Fagerbakke
Norway
110,000
7
13
8
Rustam Havryliuk
Ukraine
115,000
8
14
1
Sondre Lunde
Norway
260,000
17
14
2
Matias Kesanen
Finland
390,000
26
14
3
Mindaugas Kriauciunas
Lithuania
255,000
17
14
4
Juuso Oksanen
Finland
210,000
14
14
5
Henri Katila
Finland
325,000
22
14
6
Roberto Olsen
Sweden
565,000
38
14
7
Espen Sandvik
Norway
270,000
18
14
8
Matte Karjalainen
Finland
480,000
32
15
1
Andre Grigorjev
Estonia
230,000
15
15
2
Jeffrey Cormier
Canada
455,000
30
15
3
Markku Koplimaa
Estonia
265,000
18
15
4
Jarkko Suokas
Finland
560,000
37
15
6
Niko Ilmonen
Finland
440,000
29
15
7
Yurii Zabrodotskyi
Ukraine
1,345,000
90
15
8
Paul Koppe
Estonia
1,660,000
111
16
1
Gregory Telman
Israel
270,000
18
16
3
Nicklas Dehli
Denmark
465,000
31
16
4
Ben Slack
United Kingdom
530,000
35
16
5
Juuso Koskela
Finland
370,000
25
16
6
Ermo Kosk
Estonia
445,000
30
16
7
Vilius Zabarauskas
Lithuania
1,070,000
71
16
8
Nicolai Ejstrud
Denmark
500,000
33
19
1
Eriks Krumins
Latvia
1,595,000
106
19
2
Kriss Riekstins
Latvia
300,000
20
19
3
Igor Pihela Jr
Estonia
245,000
16
19
4
Liutauras Armanavicius
Lithuania
1,155,000
77
19
5
Laurynas Vaitkevicius
Lithuania
745,000
50
19
6
Tero Kilkanen
Finland
285,000
19
19
7
Rubens Akopjancs
Latvia
1,490,000
99
19
8
Bjorn Lindberg
Sweden
460,000
31
20
1
Evgeny Vyal
Estonia
790,000
53
20
2
Krisjanis Stankevics
Latvia
235,000
16
20
3
Janis Leja
Latvia
125,000
8
20
4
Victor Fernandez Garcia
Spain
165,000
11
20
5
Aurimas Stanevicius
Lithuania
1,150,000
77
20
6
Tapio Aaltonen
Finland
369,000
25
20
7
Jukka Moisio
Finland
360,000
24
20
8
Kasparas Klezys
Lithuania
162,500
11
21
1
Roope Tarmi
Finland
420,000
28
21
2
Kaspar Kaisel
Estonia
1,465,000
98
21
3
Sergei Aleksejev
Estonia
228,000
15
21
4
Joshua Stewart
United Kingdom
735,000
49
21
5
Jyri Merivirta
Finland
154,500
10
21
7
Sauli Haapaniemi
Finland
115,000
8
21
8
Enea Subashi
Greece
1,655,000
110
22
1
Mauri Dorbek
Estonia
475,000
32
22
2
Steven Tool
Estonia
50,000
3
22
3
Elias Suhonen
Finland
1,260,000
84
22
4
Aleksei Vandyshev
Estonia
690,000
46
22
5
Martin Piik
Estonia
220,000
15
22
7
Sohrab Malkari
Norway
455,000
30
22
8
Andrei Silencov
Moldova
290,000
19
09:36 (UTC+2)
Day 3 of Olympic Park Casino Started Level: 22 Blinds: 10,000/15,000 Ante: 15,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.