0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0085 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/137/330/updates'
ORDER BY `views` DESC

0.0006 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/137/330/updates', 1, '2024-12-23')

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` = '137'

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '137'

0.0281 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` = '330'
AND `published` = 1

0.0276 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` = '339'
AND `published` = 1

0.0062 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '330'
ORDER BY `busted` ASC, `current_chips` DESC

0.0060 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` = '330'
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` = '14820'
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` = '14689'
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` = '14691'
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` = '14688'
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` = '14686'
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` = '14683'
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` = '14682'
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` = '14680'
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` = '14679'
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` = '14678'
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` = '14677'
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` = '14669'
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` = '14670'
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` = '14664'
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` = '14661'
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` = '14658'
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` = '14655'
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` = '14646'
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` = '14638'
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` = '14634'
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` = '14632'
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` = '14627'
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` = '14623'
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` = '14622'
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` = '14616'
ORDER BY `chip_change` DESC, `busted` ASC

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14613'
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` = '14611'
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` = '14609'
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` = '14605'
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` = '14601'
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` = '14600'
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` = '14594'
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` = '14581'
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` = '14576'
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` = '14574'
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` = '14571'
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` = '14564'
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` = '14555'
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` = '14554'
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` = '14552'
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` = '14546'
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` = '14545'
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` = '14542'
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` = '14533'
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` = '14530'
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` = '14528'
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` = '14523'
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` = '14524'
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` = '14522'
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` = '14514'
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` = '14516'
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` = '14513'
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` = '14512'
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` = '14511'
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` = '14510'
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` = '14509'
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` = '14504'
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` = '14506'
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` = '14503'
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` = '14499'
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` = '14501'
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` = '14498'
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` = '14496'
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` = '14500'
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` = '14495'
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` = '14493'
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` = '14492'
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` = '14491'
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` = '14490'
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` = '14489'
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` = '14486'
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` = '14484'
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` = '14483'
ORDER BY `chip_change` DESC, `busted` ASC

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

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` = '14820'
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` = '14689'
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` = '14691'
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` = '14688'
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` = '14686'
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` = '14683'
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` = '14682'
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` = '14680'
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` = '14679'
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` = '14678'
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` = '14677'
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` = '14669'
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` = '14670'
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` = '14664'
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` = '14661'
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` = '14658'
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` = '14655'
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` = '14646'
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` = '14638'
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` = '14634'
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` = '14632'
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` = '14627'
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` = '14623'
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` = '14622'
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` = '14616'
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` = '14613'
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` = '14611'
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` = '14609'
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` = '14605'
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` = '14601'
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` = '14600'
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` = '14594'
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` = '14581'
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` = '14576'
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` = '14574'
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` = '14571'
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` = '14564'
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` = '14555'
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` = '14554'
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` = '14552'
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` = '14546'
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` = '14545'
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` = '14542'
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` = '14533'
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` = '14530'
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` = '14528'
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` = '14523'
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` = '14524'
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` = '14522'
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` = '14514'
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` = '14516'
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` = '14513'
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` = '14512'
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` = '14511'
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` = '14510'
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` = '14509'
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` = '14504'
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` = '14506'
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` = '14503'
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` = '14499'
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` = '14501'
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` = '14498'
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` = '14496'
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` = '14500'
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` = '14495'
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` = '14493'
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` = '14492'
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` = '14491'
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` = '14490'
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` = '14489'
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` = '14486'
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` = '14484'
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` = '14483'
ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '339'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553

    

Open Modal

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

Allow Notifications Close

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 #3: €555 No-Limit Hold'em Live Reporting - Day 3

Olympic Park Casino - Live Reporting

Event #3: €555 No-Limit Hold'em See other events

Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

Olympic Park Casino - Live Reporting Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

---

Current Level 38 Current Day 3

---

Blinds 250,000/500,000 Ante 500,000

Entries 617 Remaining 1

---

Prize Pool (EUR) €296,160 First Prize (EUR) €55,210

Chip Leaders Day 3

1

Phil Gross

18,500,000

Day 2 Day 3

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 2

11:46 (UTC+2)

Day 2 of Olympic Park Casino Ended
Level: 30     Blinds: 40,000/80,000     Ante: 80,000

Ridas Bitauskas Bubbles The Final Table in 10th (€4,250) Posted Wednesday 24th July, 2024 at 00:19(UTC+2) by Alaxandar Georgiev

Level 30: 40,000/80,000 (60,000)
Entries: 10/617

Ridas Bitauskas was left with under a blind from his last hand and was all-in on the first hand after the break. 

David Bright raised 165,000 from the small blind and Roope Tarmi called from the big.

The flop was - Bright check-folded to Tarmi's bet and both players revealed their cards.

Ridas Bitauskas:
Roope Tarmi:

Bitauskas was only hoping for an ace or a backdoor draw. There was some hope on the turn which gave him a gutshot. The river was another four which made him bust the tournament in 10th place for €4,250

Player		Chips	Progress
Roope Tarmi		2,690,000	390,000
Ridas Bitauskas		0	0

00:16 (UTC+2)

Start of Level 30
Blinds: 40,000/80,000     Ante: 80,000

Huge Hand On The FT Bubble Posted Wednesday 24th July, 2024 at 00:08(UTC+2) by Alaxandar Georgiev

Level 29: 30,000/60,000 (60,000)
Entries: 10/617

Roope Tarmi opened the hand from under the gun and Ridas Bitauskas called 120,000 from the button.

Tarmi bet the flop and Bitauskas just called. The turn paired the board and completed the flush draw and Tarmi slowed down a bit. He checked and Bitauskas put him all in after some thinking. 

Roope Tarmi snap-called and showed his flush against Bitauskas . The Lithuanian was drawing dead and they both had very similar stacks.

After a count, Tarmi had 830,000 and Bitauskas covered him only by 65,000 chips and is left with less than a blind on the final table bubble.

The players will now take their 15-minute break and after that,  everyone will know if the "chip and a chair" stories can come true in the WSOPC Ring Event #3

Player		Chips	Progress
Roope Tarmi		2,300,000	2,264,500
Ridas Bitauskas		65,000	1,335,000

Final Table Bubble Play Posted Tuesday 23rd July, 2024 at 23:53(UTC+2) by Alaxandar Georgiev

Level 29: 30,000/60,000 (60,000)
Entries: 10/617


Only 10 players are left at almost midnight here in Olympic Casino Tallinn and only one of them will win the €55,210 first-place prize and the golden WSOPC ring.

The average stack is 1,850,000 and the blinds will be going up in just a few minutes. The Day will finish after just one bust out. Good luck to all of the remaining players.

Ruslans Levockins Is Eliminated in 11th place (€4,250) Posted Tuesday 23rd July, 2024 at 23:48(UTC+2) by Alaxandar Georgiev

Level 29: 30,000/60,000 (60,000)
Entries: 11/617


Oleksii Natoptanyi raised the first to 120,000 and got a flat call from one of the chip leaders - Phil Gross sitting on the button. 

Action folded to Latvia's Ruslans Levockins who ripped his remaining 550,000 in the middle. A snap all-in followed by Natoptanyi and Gross said he couldn't call and mucked his cards.

Ruslans Levockins:
Oleksii Natoptanyi:

Levockins was in trouble, his Ukrainian opponent had the better of it, and the flop changed nothing. The turn was another and bricked Levockins hopes of winning a golden ring.


Ruslans Levockin's good play through Day 2 managed to get him in the top 11 and secured a payout of €4,250 for him.

Player		Chips	Progress
Oleksii Natoptanyi		2,000,000	400,000
Ruslans Levockins		0	0

Boris Smolianskii is Eliminated in 12th place (€4,250) Posted Tuesday 23rd July, 2024 at 23:40(UTC+2) by Alaxandar Georgiev

Level 29: 30,000/60,000 (60,000)
Entries: 12/617

Boris Smolianskii was left a bit short and had around 8 blinds when he open-jammed from the hi-jack. Phil Gross looked like he had an easy decision on his left and just called. Everyone else folded.

Boris Smolianskii:
Phil Gross:

With just 8 blinds left Smolianskii managed to run into Aces, even tho he had one in his hand. 

The flop was quite interesting , the two clubs gave Smolianskii a decent chance to double-up, while his opponent hit the one-outer top set of Aces.

The turn wasn't the color Smolianskii needed and the river was a black card, but not the suit he wished for.

Boris Smolianskii finished just 3 positions shy of the final table and will take home €4,250.

Player		Chips	Progress
Phil Gross		2,600,000	700,000
Boris Smolianskii		0	0

23:30 (UTC+2)

Start of Level 29
Blinds: 40,000/80,000     Ante: 60,000

Jan Holte Busts In 13th place (€3,650) Posted Tuesday 23rd July, 2024 at 23:30(UTC+2) by Alaxandar Georgiev

Level 28: 25,000/50,000 (50,000)
Entries: 13/617


Rasmus Sihvonen raised from the button to 100,000 and Jan Holte quickly jammed his remaining 11 blind in the middle.

Dmitri Damaskin went a bit into the tank and eventually also announced that he was all in. Sihvonen snap folded and we had another player at risk.

Jan Holte:
Dmitri Damaskin:

Holte couldn't hit any pair on the board and had to get up off his chair. 

Jan Holte's run ended in 13th place for €3,650.

Player		Chips	Progress
Dmitri Damaskin		1,800,000	1,735,500
Rasmus Sihvonen		1,600,000	100,000
Jan Holte		0	0

Dowling goes out in 14th place (€3,250) Posted Tuesday 23rd July, 2024 at 23:24(UTC+2) by Alaxandar Georgiev

Level 28: 25,000/50,000 (50,000)
Entries: 14/617

Christopher Dowling had a decision to make on the button as his stack was getting shorter and shorter. His decision ended up being all-in. 

Rasmus Sihvonen made the call from the small blind and both went on to showdown.


Christopher Dowling:
Rasmus Sihvonen:

Dowling really hoped to hit something on the flop, as he was behind. The flop king high flop didn't help his cause and he was drawing dead on the turn.

Dowling is eliminated just 13 players away from the golden ring and will take €3,250.

 

Player		Chips	Progress
Rasmus Sihvonen		1,700,000	1,491,500
Jan Holte		520,000	780,000
Christopher Dowling		0	0

Keränen is Eliminated in 15th place (€3,250) Posted Tuesday 23rd July, 2024 at 23:14(UTC+2) by Alaxandar Georgiev

Level 28: 25,000/50,000 (50,000)
Entries: 15/617

Ville-Matti Keränen jammed around 14 blinds from the hi-jack with his  and got called by David Bright's .

The flop came which gave Keranen some backdoor outs. Another spade hit on the turn and yet another one which completed Bright's flush draw.

sm:text- md:text- font-bold leading-none">Ville-Matti Keränen is eliminated in 15th place and will take home €3,250.

 

Player		Chips	Progress
David Bright		2,700,000	1,700,000
Ville-Matti Keranen		0	0

Holte Scoops A Big One Posted Tuesday 23rd July, 2024 at 23:07(UTC+2) by Alaxandar Georgiev

Level 27: 20,000/40,000 (40,000)
Entries: 16/617

Jan Holte and Kaido Mikk were heads-up on the river. The board was and they were playing blind on blind. 

There were already 500,000 chips in the middle and Mikk was the first to act, he bet another 300,000 and his opponent announced that he was all-in.

Kaido Mikk had only 430,000 behind and did muck his cards after a while.


Jan Roger Holte wins a nice pot of over 1,100,000 chips right before the eventual final table.

Kaido Mikk busted in one of the next few hands with jc] against Ridas Bitauskas's  and gets paid €2,900 for 16th place.

Player		Chips	Progress
Ridas Bitauskas		1,400,000	1,356,500
Jan Holte		1,300,000	100,000
Kaido Mikk		0	0

23:00 (UTC+2)

Start of Level 28
Blinds: 25,000/50,000     Ante: 50,000

Final Two Tables Draw Posted Tuesday 23rd July, 2024 at 22:43(UTC+2) by Alaxandar Georgiev

Level 27: 20,000/40,000 (40,000)
Entries: 17/617

The WSOPC Ring Event #3 is down to its last 16 players and they have been re-drawn to the last 2 tables. 

The day will be played till our final 9 players and the action will continue tomorrow at 13:00.

Jungevicius Eliminated in 18th place (€2,550) Posted Tuesday 23rd July, 2024 at 22:41(UTC+2) by Alaxandar Georgiev

Level 27: 20,000/40,000 (40,000)
Entries: 17/617

Another all-in took place at table number two. Raise from Ignotas Tamasauskas to 80,000 and Kestutis Jungevicius shoved his last 350,000 chips with his pocket tens . The table folded around to the original raiser and he snap-called with his {jc].

Nothing worked for Jungevicius on the board and his hopes for a ring are over in 17th place which guarantees him a payout of €2,900. He made the pay jump because another player - Aurimas Stanevicius busted before him on the other table in 18th place.

Player		Chips	Progress
Ignotas Tamasauskas		940,000	887,000
Kestutis Jungevicius		0	0
Aurimas Stanevicius		0	0

Maikel Homin Eliminated in 20th place (€2,550) Posted Tuesday 23rd July, 2024 at 22:32(UTC+2) by Alaxandar Georgiev

Level 27: 20,000/40,000 (40,000)
Entries: 20/617

Maikel Homin shoved his remaining 4 blinds from the small blind and got instantly called by Phil Gross in the big blind.

Maikel Homin:
Phil Gross:

Behind and at risk Estonian's Homin needed help from the dealer. The had not even one diamond on it, the turn was which gave Homin some additional outs.

The river ended Homin's performance in 20th place and he got €2,550 for it. 

Marios Mansour busted the next hand on the same table and will take home the same prize.

Player		Chips	Progress
Phil Gross		1,900,000	1,685,000
Maikel Homin		0	0
Marios Mansour		0	0

22:28 (UTC+2)

Start of Level 27
Blinds: 20,000/40,000     Ante: 40,000

Five Is Not A Good Number For Mancinelli Posted Tuesday 23rd July, 2024 at 22:06(UTC+2) by Alaxandar Georgiev

Level 25: 15,000/30,000 (30,000)
Entries: 24/617

Edoardo Mancinelli opened from the cutoff to 60,000 and action folded around to Oleksii Natoptanyi who was sitting in the big. He jammed it all in and put his opponent all in to call for his 21 blinds. Mancinelli called.

Edoardo Mancinelli:

Oleksii Natoptanyi:

Mancinelli was in good shape to double up after a safe flop of , Natoptanyi needed to hit a five or a seven for the chop. The dealer turned exactly what he wished for and Mancinelli's tournament life was hanging by a thread. 

No luck for the Italian, river drilled another five to finish a full house for the Ukrainian. He finished in 24th place right before a €250 ladder to €2,250

Player		Chips	Progress
Oleksii Natoptanyi		1,600,000	1,526,000
Edoardo Mancinelli		0	0

Last Three Tables Re-Draw Posted Tuesday 23rd July, 2024 at 21:38(UTC+2) by Alaxandar Georgiev

Level 25: 15,000/30,000 (30,000)
Entries: 24/617

The WSOPC Ring Event #3 €555 NLH is now down to the last 24 players out of 617 total entries. This means we do have our last three tables and it's time for a seat redraw.

All players, but the 24th are guaranteed at least €2,250 cash, and only one of them will take home the golden jewelry.

Ranno Sootla who won the €660 Mystery Bounty Ring Event last year busted in 25th place.


Here are the last players who busted before the redraw:

Player		Chips	Progress
Ranno Sootla		0	0
Markku Ihamaki		0	0
Sauli Haapaniemi		0	0
Timo Ruuska		0	0
Roman Jezov		0	0
Erik Lindqwist		0	0
Timmy Anker		0	0
Ritvars Cekalins		0	0

21:29 (UTC+2)

Start of Level 26
Blinds: 15,000/30,000     Ante: 30,000

Sick Cooler For Roman Jezov Posted Tuesday 23rd July, 2024 at 21:28(UTC+2) by Alaxandar Georgiev

Level 24: 10,000/25,000 (25,000)
Entries: 29/617


Tommy Piiroinen raised first in and got shoved for 270,000 from Roman Jezov. After the other players folded Piiroinen didn't think much and threw in a chip for the call.

Roman Jezov:
Tommy Piroinen:

Monster hand for Jezov - pocket kings, bu his opponent wasn't in such a bad shape with the three aces still in the deck. 

The flop was crazy - Jezov had a full-house on the flop, while his opponent was drawing to such himself.. 

The turn didn't change much, but oh the river .. it was the which completed a bigger full-house for Piroinen.



Unlucky spot for Roman Jezov saw him bust in 29th place for €1,750

Player		Chips	Progress
Tommy Piiroinen		1,200,000	1,007,500
Roman Jezov		0	0

Last 20 Busted Players in The Money Posted Tuesday 23rd July, 2024 at 21:08(UTC+2) by Alaxandar Georgiev

Here is the list of players who busted within the range of 33rd to 53rd place in the WSOPC Ring Event #3.

Players from 32nd to 39th will get €1,550 and  from 40th to 55th will get €1,350.

Player		Chips	Progress
Victor Prior Fernandez Amat		0	0
Pavel Solodovnikov		0	0
Modestas Kryzanauskas		0	0
Mykhailo Mikhalov		0	0
Jorn Martinsen		0	0
Lorenzo Arduini		0	0
Paul Koppe		0	0
Jaakko Tirkkonen		0	0
Tuomas Tervonen		0	0
Audrius Laimelis		0	0
Rolandas Aglinskas		0	0
Joshua Stewart		0	0
Antti Vetelainen		0	0
Jari-Pekka Juhola		0	0
Xi Tran		0	0
Jani Tuovinen		0	0
Ben Slack		0	0
Mikael Haapaniemi		0	0
Marius Hakonsen		0	0
Hans Fernkvist		0	0
Frederico Alves Dos Santos		0	0

21:02 (UTC+2)

Start of Level 25
Blinds: 10,000/25,000     Ante: 25,000

Juhola Shoves Ahead Posted Tuesday 23rd July, 2024 at 21:02(UTC+2) by Alaxandar Georgiev

Level 24: 10,000/20,000 (20,000)
Entries: 36/617

David Bright opened the pot from the button and Jari Juhola jammed it all in for about 430,000 and got quickly called by Bright. 

Jari Juhola:
David Bright:

Bright's Jack didn't have a buddy like Juhola's Jack and that meant he needed to find at least an Ace somewhere along the board. Both had very similar stack and it was basically two tournament lives at stake.

Great flop for Bright, his opponent was now drawing to a backdoor chop or a one outer jack. The turn was and the river . Jari Juhola finished in 36th position and will take €1,550.

Player		Chips	Progress
David Bright		1,000,000	590,000
Jari-Pekka Juhola		0	0

Almost A Million Chips Pot Posted Tuesday 23rd July, 2024 at 20:47(UTC+2) by Alaxandar Georgiev

Level 24: 10,000/20,000 (20,000)
Entries: 38/617

Jani Tuovinen's tournament life was on the line after he ripped it all in from the small blind after a button raise from Edoardo Mancinelli. He didn't get called by the  Italian, because Jan Holte also went all-in from the big blind. 

Jani Tuovinen: 
Jan Holte:

Two hearts on the gave Tuovinen some chance of a backdoor, that ended fast on the brick turn. His tournament life also ended after the dealer put the on the river. He busts the tournament in 38th place and will cash out €1,550.

Player		Chips	Progress
Jan Holte		1,200,000	500,000
Jani Tuovinen		0	0

20:32 (UTC+2)

Start of Level 24
Blinds: 10,000/20,000     Ante: 20,000

Meet The Big Chip Leader - Phil Gross Posted Tuesday 23rd July, 2024 at 20:32(UTC+2) by Alaxandar Georgiev

Level 23: 10,000/15,000 (15,000)
Entries: 41/617

Phil Gross is on a hot roll as he busts players left and right. He has a staggering amount of 2,200,000 chips which amounts to 110 big blinds on the current level. He is almost a million off the second-biggest stack at the moment. The average stack right now is 475,000.

Four Blinds And A Dream Posted Tuesday 23rd July, 2024 at 20:24(UTC+2) by Alaxandar Georgiev

Level 23: 10,000/15,000 (15,000)
Entries: 46/617

Mykhailo Mikhalov Jammed his last 4 blinds after an early raise from Edoardo Mancinelli, followed by an all-in from  Northern Ireland's David Bright. Everyone folded and both got their cards face up.

Mykhailo Mikhalov:
David Bright:

No luck for Mikhalov on the board. He busts the Day 2 in 46th place and will take home €1,350.

Player		Chips	Progress
David Bright		410,000	170,000
Mykhailo Mikhalov		0	0

Chip Lead Pot ALERT! Posted Tuesday 23rd July, 2024 at 20:14(UTC+2) by Alaxandar Georgiev

Level 23: 10,000/15,000 (15,000)
Entries: 50/617

Ben Slack was heads-up with Kaido Mikk on a scary board of and there was already 300,000 chips in the middle. Slack checked and after a while Mikk bet 160,000.

With both flush draws missing and maybe a straight draw too Slack made the call and was shown the bad news quickly. Kaido Mikk turned his cards around and he had for a full-house.

Kaido Mikk scoops the huge 620,000 pot and with his 300,000 behind he is now the chipleader of Day 2.

Player		Chips	Progress
Kaido Mikk		920,000	795,000
Ben Slack		200,000	115,500

20:00 (UTC+2)

Start of Level 23
Blinds: 10,000/15,000     Ante: 15,000

Players Who Busted In The Money Posted Tuesday 23rd July, 2024 at 19:59(UTC+2) by Alaxandar Georgiev

26 players have already busted in just one level after they got into the money, some notable names that left the fight for the ring are Jon Kyte who won the Pot-Limit Omaha Ring Event at WSOPC Tallinn 2023, and Linda Nguyen who played the Day 2, and the final table of the ladies event at the same time.

You can also check out the payouts in our payouts section. 
40th - 55th - €1,350
56th - 71th - €1,200
71th - 79th - €1,100

Here is a list of all the players who busted after they got into the money:

Player		Chips	Progress
Richard Koppel		0	0
Mykola Kostyrko		0	0
Robert Kallikorm		0	0
Vitalijus Kuzmicius		0	0
Andrius Dubietis		0	0
Kevin Karenius		0	0
Vasyl Tkachenko		0	0
Christel Haller		0	0
Franco Spichtig		0	0
Knut Turk		0	0
Jari Mahonen		0	0
Artjoms Hromovs		0	0
Enrique Martinez		0	0
Mario Fenaroli		0	0
Totti Arosuo		0	0
Jon Kyte		0	0
Kaido Koorits		0	0
Linda Nguyen		0	0
Tapio Aaltonen		0	0
Nikodemas Staniukaitis		0	0
Maksym Klopotok		0	0
Laurynas Vaitkevicius		0	0
Kaspars Butans		0	0
Nicolas Bokowski		0	0
Kristjan Maasalu		0	0
Klaudijus Bajoras		0	0

Players Are Now On A One Hour Break Posted Tuesday 23rd July, 2024 at 19:04(UTC+2) by Alaxandar Georgiev

Things went very quickly from 79 down to 53 players before the bigger dinner break which is exactly one-hour long. Players will return to level 23 and blinds 10,000/15,000 - Ante 15,000. They have all now locked up 1,350 and the next ladder is at top 39.

#FinalTableFreeroll Posted Tuesday 23rd July, 2024 at 19:03(UTC+2) by Matthew Summers

MainEventTravel.com's Exclusive Added Value Promotion!

Win back up to 100% of Tournament Travel booked with MET in Eligible Events!

Head to MainEventTravel.com > Promotions for full details.

#FinalTableFreeroll

Busted Players near the money. Posted Tuesday 23rd July, 2024 at 18:37(UTC+2) by Alaxandar Georgiev

These are the players who nearly made the money, but won't be taking any from Event #3: €555 No-Limit Hold'em. Good luck to everyone in the other events!

Player		Chips	Progress
Teppo Joentausta		0	0
Tadas Simas		0	0
Jeffrey Cormier		0	0
Meelis Ahman		0	0
Ekrem Esker Atush		0	0
Timo Malo		0	0
Tero Laurila		0	0
Jorden Verbraeken		0	0
Dominik Ostrowski		0	0
Nohad Teliani		0	0
Igor Aleksandrov		0	0

18:30 (UTC+2)

Start of Level 22
Blinds: 6,000/12,000     Ante: 12,000

Gross Makes A Huge Call On The Bubble Posted Tuesday 23rd July, 2024 at 18:28(UTC+2) by Alaxandar Georgiev

Level 21: 5,000/10,000 (10,000)
Entries: 80/617

Phil Gross from Germany min-raised from under the gun and got shoved on by Totti  Arosuo who was sitting on the button.  Gross had to call off his remaining 215,000 chips without knowing two shorter stacks already bubbled on the other tables, yet he made the call and revealed their cards.

Phil Gross:
Totti Arosuo:

Arosuo clearly wanted to push him off a hand on the stone bubble, but Gross had a pretty strong hand. He made a set on the flop and put a big smile on his face as his opponent was already drawing dead on the turn.  Gross will now continue the fight with a healthy stack of 460,000.

Player		Chips	Progress
Phil Gross		460,000	245,000
Totti Arosuo		210,000	215,000

Stone Bubble For Teppo Joentausta Posted Tuesday 23rd July, 2024 at 18:21(UTC+2) by Alaxandar Georgiev

Level 21: 5,000/10,000 (10,000)
Entries: 80/617

Teppo Joentausta was all-in on the same hand as the previous player busted out and it was him from the small blind and his 74,000 chips against the call of Aurimas Stanevicius on the big blind.

Teppo Joentausta:
Aurimas Stanevicius:

Joentausta had a premium one, but unfortunately for him, his opponent hit a ten on the flop and needed help from the next two cards. Jack or an Ace would've probably meant at least €1,100 min-cash for him, but none of these cards came.

Congratulations all of the remaining 79 players are now in the money and still fighting for the golden ring.

Player		Chips	Progress
Aurimas Stanevicius		600,000	260,000
Teppo Joentausta		0	0

Hand For Hand On The Stone Bubble Posted Tuesday 23rd July, 2024 at 18:08(UTC+2) by Alaxandar Georgiev

Level 21: 5,000/10,000 (10,000)
Entries: 81/617

Nohad Teliani just busted with her against Henri  Schalin's pocket only two away from the money and €1,100 min-cash.

Now the play is hand for hand as we are waiting for the final bust out before everyone is in the money.

Player		Chips	Progress
Nohad Teliani		0	0

18:05 (UTC+2)

Start of Level 21
Blinds: 5,000/10,000     Ante: 10,000

Laurila Busts In 85th Place Posted Tuesday 23rd July, 2024 at 18:01(UTC+2) by Alaxandar Georgiev

Level 20: 4,000/8,000 (8,000)
Entries: 85/617


Kestutis Jungevicius once again opened to 20,000 on table eight and got jammed on by Tero Laurila for 137,000. Just a few players off the money, this all-in looked quite strong. Jungevicius took some time and threw a chip in.

Tero Laurila:
Kestutis Jungevicius:

A flip at first sight, Laurila needed to fade some kings and queens as he was ahead preflop. The window card rolled up and it sure was not good news for Laurila - was the first one and then to complete the flop.

Laurila needed an ace or jack to stay alive but didn't get any on the turn and brick . 

Just minutes later the tournament is already hand for hand and 2 away from the money.

Player		Chips	Progress
Kestutis Jungevicius		410,000	240,000
Tero Laurila		0	0

Important Hand For Martinez Near The Money Posted Tuesday 23rd July, 2024 at 17:45(UTC+2) by Alaxandar Georgiev

Level 20: 4,000/8,000 (8,000)
Entries: 89/617

Just 10 players off the money Enrique Martinez shoved for 9 big blinds from an early position and everyone folded except for Lithuania's Nikodemas Staniukaitis who tanked a bit and made the call.

Enrique Martinez:
Nikodemas Staniukaitis:

Bad news for Staniukaitis who saw he was dominated by a better hand.  The gave hopes for Staniukaitis only on the turn, but they quickly faded by the fifth card and he was forced to give Spain's Martinez 72,000 chips.

Player		Chips	Progress
Nikodemas Staniukaitis		170,000	70,000
Enrique Martinez		150,000	93,000

Who's Got The Jack? Posted Tuesday 23rd July, 2024 at 17:36(UTC+2) by Alaxandar Georgiev

Level 20: 4,000/8,000 (8,000)
Entries: 91/617

A big pot was played between Audrius Laimelis and Kestutis Jungevicius. Laimelis defended an utg open from his opponent and the action was already four cards in after both checked the flop. The turn was led by Laimelis for 26,000 and called by his Lithuanian fellow. 

The river was the and Laimelis pushed his remaining 72,000 in the middle and got a call fairly quickly. 

Audrius Laimelis: - two pair
Kestutis Jungevicius: - top pair

Both got a pair of Jacks on the turn, but Laimelis scooped the pot with his second card, which he had paired already on the flop.

Player		Chips	Progress
Audrius Laimelis		240,000	110,000
Kestutis Jungevicius		170,000	34,000

17:25 (UTC+2)

Start of Level 20
Blinds: 4,000/8,000     Ante: 8,000

More Eliminations in Day 2 Posted Tuesday 23rd July, 2024 at 17:24(UTC+2) by Alaxandar Georgiev

Check out some more of the eliminated players before the money down below:

Player		Chips	Progress
Malkari Sohrab		0	0
Ralf Mikk		0	0
Donatas Pilinkus		0	0
David Tennback		0	0
Morten Bremseth		0	0
Miika Toyras		0	0
Kimmo Kurko		0	0
Aleksi Naski		0	0
Andrius Mazeika		0	0
Marius Morel		0	0
Petteri Miettinen		0	0
Tarmo Tammel		0	0
Fredric Eriksson		0	0
Andre Magi		0	0
Touko Berndtson		0	0
Maksim Petrov		0	0
Sander Leigri		0	0
Bjorn Tore Tvedt		0	0
Anders Beckman		0	0
Peteris Balodis		0	0
Sondre Lunde		0	0
Konsta Heikkila		0	0
Kasper Mellanen		0	0
Taago Tamm		0	0
Priit Vanem		0	0
Johannes Cleven		0	0
Espen Sandvik		0	0
Athanasios Kostouros		0	0
Aleksandr Naumov		0	0
Arturs Putnins		0	0
Helina Tamm		0	0
Otto Kiiskinen		0	0
Raphael Godard		0	0
Vidar Assersen		0	0
Jonatan Fors		0	0
Theis Nielsen		0	0
Georgi Abuladze		0	0
Victor Fernandez Garcia		0	0
Tomi Arponen		0	0
Marcus Carlsen		0	0
Morten Bremseth		0	0
David Tennback		0	0
Donatas Pilinkus		0	0
Ralf Mikk		0	0
Malkari Sohrab		0	0
Natalia Manuyko		0	0
Kazimieras Ramaska		0	0
Nebojsa Musulin		0	0
Vadims Milovs		0	0
Mika Hautakangas		0	0
Luca Sebastiani		0	0
Kelly Limonova		0	0
Tanel Merida		0	0
Lasse Aarninsalo		0	0
Aleksandr Jelpidiforov		0	0
Konstantin Farber		0	0
Jargo Alavali		0	0
Tal Herzog		0	0
Jordi Conejos Baixas		0	0
Christian Steinbo		0	0
Siim Suviste		0	0
Zanas Lubys		0	0
Sakari Setala		0	0
Ville Pohjalainen		0	0
Andrius Bielskis		0	0
Kristo Klaassen		0	0
Sebastian Wahl		0	0
Luka Sorainen		0	0
Mohammed Al-Khazraji		0	0
Sargon Esfendiyari		0	0
Jarmo Salonen		0	0
Liutauras Armanavicius		0	0

30 Player Off The Money Posted Tuesday 23rd July, 2024 at 16:56(UTC+2) by Alaxandar Georgiev

The day is going fast and we are closing in on the paid place. There are 109 players left out of the 617 entries.  The competitors just finished their 15-minute break and will return to Level 19 on blinds 3,000/6,000 and 6,000 Ante.

Check out some of the bigger stacked players:

Player		Chips	Progress
Marcus Carlsen		435,000	65,000
Aurimas Stanevicius		340,000	180,000
Tuomas Tervonen		300,000	269,500
Mykhailo Mikhalov		300,000	207,000
Maikel Homin		280,000	135,500
Ekrem Esker Atush		240,000	210,000
Nikodemas Staniukaitis		240,000	172,500

16:49 (UTC+2)

Start of Level 19
Blinds: 4,000/8,000     Ante: 6,000

Bad Runout for Jon Kyte Posted Tuesday 23rd July, 2024 at 16:26(UTC+2) by Alaxandar Georgiev

Level 18: 2,500/5,000 (5,000)
Entries: 115/617

2023 Pot-Limit Omaha Ring Event champion Jon Kyte opened to 10,000 from the cutoff and got re-raised to 22,000 from Antti Veteläinen who had a big stack on the button.

Kyte paid and they saw a flop of on which Kyte checked and his opponent bet 12,000. The Norwegian called and the turn was . this time they both checked.

The river was a which completed a potential one-card straight. Kyte led for 18,000 and Vetelainen put him all-in. Kyte had to decide for his remaining 6 blinds and did make the fold eventually. He managed to double-up after a few hands and is still in the game for the gold.

Player		Chips	Progress
Antti Vetelainen		290,000	90,000
Jon Kyte		31,000	49,000

16:06 (UTC+2)

Start of Level 18
Blinds: 2,000/5,000     Ante: 5,000

Laimelis Doubles Up Posted Tuesday 23rd July, 2024 at 16:04(UTC+2) by Alaxandar Georgiev

Level 17: 2,000/4,000 (4,000)
Entries: 125/617

Tommi Lankinen put his tournament life on the line by shoving his last 14 blinds from an early position and got called by Audrius Laimelis from the cutoff.  Both had similar stacks, but Lankinen was at risk.

Tommi Lankinen:
Audrius Laimelis:

Jack in the window for Lankinen had him probably feel good for a second, right before the third card turned out to be another eight . With the turn Lankinen was already drawing dead and busted out of the tournament.

Player		Chips	Progress
Audrius Laimelis		130,000	57,000
Tommi Lankinen		0	0

The Ladies Like Martinsen Posted Tuesday 23rd July, 2024 at 15:51(UTC+2) by Alaxandar Georgiev

Level 17: 2,000/4,000 (4,000)
Entries: 143/617

Roger Odden jammed his last 17 blinds under the gun and action folded around to Ville-Matti Keränen on the button who also went all-in for a bit more than 180,000. On his left Jorn Martinsen called swiftly after checking the stacks for his remaining 144,000.

Roger Odden:
Ville-Matti Keranen:
Jorn Martinsen:

Martinsen had the best hand preflop with his pocket ladies, while Odden was in bad shape against both players. The gave Odden some hope, since he was given 4 more outs for a straight. The turn was another seven and the river changed nothing.

A big scoop of 350,000 chips for Martinsen, a bust out for Odden, and a small stack left for Keranen was the result of the three-way all-in.

Player		Chips	Progress
Jorn Martinsen		350,000	233,500
Ville-Matti Keranen		38,000	167,000
Roger Odden		0	0

15:46 (UTC+2)

Start of Level 17
Blinds: 2,000/4,000     Ante: 4,000

Sick Three Way All-In Posted Tuesday 23rd July, 2024 at 15:31(UTC+2) by Alaxandar Georgiev

Level 16: 1,500/3,000 (3,000)
Entries: 168/617

Janne Rusanen opened the pot from an early position and got one call right behind him, then Jarri-Pekka Juhola made a 3-bet to 20,000 and an all-in for 32,500 chips followed by Ralf Mikk that had the small blind posted. 

Rusanen didn't think much and shoved it all in as well for about 55,000, Juhola also didn't think twice and snap-called both.

Janne Rusanen:
Jarri-Pekka Juhola:
Ralf Mikk:

All of them had monster stacks, Rusanen had the pocket rockets and Juhola had the second-best starting hand. 

The flop came which was not good at all for both players at risk - Rusanen and Mikk. A very interesting popped on the turn giving Mikk some flush-draw outs, he needed a spade to win the pot and stay alive and that is exactly what he got on the river.

Crazy pot between the 3 players and as usual the underdog won the hand.
Ralf Mikk will continue with 100,000 stack which is just below the average for the level and Juhola won a small side pot worth 40,000.

Player		Chips	Progress
Jari-Pekka Juhola		112,000	82,000
Ralf Mikk		109,500	43,000
Janne Rusanen		0	0

15:08 (UTC+2)

Start of Level 16
Blinds: 1,500/3,000     Ante: 3,000

Payouts Announced - 79 Players Will Be Paid Posted Tuesday 23rd July, 2024 at 15:00(UTC+2) by Alaxandar Georgiev

Ring Event #3: €555 No-Limit Hold'em got a total of 617 entries, and only 189 remain at the time of writing. Payouts for the players have just been announced and a total prize pool of €296,160 will be divided amongst the top 79 of them.

First place is the staggering amount of €55,210, and one lucky person will take the prize home, followed by the third WSOPC golden ring.

All 79 will be guaranteed a min-cash payout of at least €1,100. The full payouts are in the Payouts tab in our coverage.

14:50 (UTC+2)

Start of Level 15
Blinds: 1,000/2,500     Ante: 2,500

Eliminations After End Of Late Registration Posted Tuesday 23rd July, 2024 at 14:50(UTC+2) by Alaxandar Georgiev

Here are the next batch of players who busted Day 2 and can no longer re-enter:

Player		Chips	Progress
Aleksander Lattikas		0	0
Alexey Cherkasov		0	0
Rashad Iskandarov		0	0
Oskar Ojaveer		0	0
Johannes Cleven		0	0
Kimmo Kurko		0	0
Summer Westerbur		0	0
Jevgenijs Sapronenko		0	0
Jeffrey Cormier		0	0
Marten Oks		0	0
Erwan Pirotais		0	0
Eriks Krumins		0	0
Joshua Stewart		0	0
Ekrem Esker Atush		0	0
Gatis Popovs		0	0
Mario Fenaroli		0	0
Igor Pihela Jr		0	0
Algirdas Sukys		0	0
Jaanus Veste		0	0
Radoslaw Hordynski		0	0
Aleksandr Januskevic		0	0
Marius Morel		0	0
Arturs Pless		0	0
Priit Vanem		0	0
Ignotas Tamasauskas		0	0
Jeffrey Cormier		0	0
Jevgenijs Sapronenko		0	0
Johannes Cleven		0	0
Roope Holma		0	0
Jari Mahonen		0	0
Ignotas Tamasauskas		0	0
Mairo Tori		0	0
Deniss Levinskis		0	0
Vitalijus Kuzmicius		0	0
Roman Petelytskyi		0	0
Nils Butevics		0	0
Sauli Haapaniemi		0	0
Edvinas Tarasevicius		0	0
Hok Lai		0	0
Espen Sandvik		0	0
Enrique Martinez		0	0
Jari Porkka		0	0
Enea Subashi		0	0
Jeffrey Cormier		0	0
Herli Olop		0	0
Daniel Tankel		0	0
Dmitri Dudakov		0	0
Artjoms Sutjagins		0	0
Algirdas Sukys		0	0
Tobias Napel		0	77,000
Tobias Napel		0	77,000

Bigger Stacks In Day 2 Posted Tuesday 23rd July, 2024 at 14:29(UTC+2) by Alaxandar Georgiev

Here are some of the bigger stacks on Day 2 after the first four levels were completed.

Marcus Carlsen continues to chip the lead on Day 2 with 212 players left. The average stack is at 87,583 and players will continue at Level 15 - blinds 1,000/2,500 and Ante 2,500.

Player		Chips	Progress
Marcus Carlsen		370,000	40,000
Tero Laurila		245,000	169,000
Andrei Mjagkov		215,000	74,500
Ville-Matti Keranen		205,000	143,000
Antti Vetelainen		200,000	108,000
Tomi Arponen		190,000	60,500
Artjoms Hromovs		180,000	74,000
Aurimas Stanevicius		160,000	101,500

Offers & Promos Posted Tuesday 23rd July, 2024 at 14:26(UTC+2) by Matthew Summers

Main Event Travel is dedicated to providing the number one Poker Travel booking platform for players heading to tournaments around the world.

 

Join our Facebook Group, your gateway to offers and promotions created specifically for Poker Travellers looking for convenience, value, info, and expert customer service.

 

Join today  https://www.facebook.com/groups/maineventtraveloffersandpromotions/

 

Last 20 Minutes of Late Registration Posted Tuesday 23rd July, 2024 at 14:04(UTC+2) by Alaxandar Georgiev

The players just finished with Level 14 and this means all 200 of them get to go on a 20-minute break. Late registration for Day 2 will be open until the break ends.

 

The Rich Get Richer Posted Tuesday 23rd July, 2024 at 13:51(UTC+2) by Alaxandar Georgiev

Level 14: 1,000/2,000 (2,000)
Entries: 203/584

Norway's Marcus Carlsen was the top stack heading into Day 2 with an impressive 218,500 chip stack. He got involved in a pot after he raised under the gun to 4,000 and Christopher Dowling shoved his remaining 35,000 chips. Everyone else folded and Carlsen made the call.

Marcus Carlsen:
Christopher Dowling: 

Carlsen was in the lead with the better pocket pair and even managed to hit a set on the flop. The other two cards were not seven and seven which meant only one thing for Dowling - a last chance to re-enter or leave the fight for the third golden ring.

Player		Chips	Progress
Marcus Carlsen		330,000	111,500
Christopher Dowling		0	0

13:50 (UTC+2)

Start of Level 14
Blinds: 1,000/2,000     Ante: 2,000

Ladies Against Rockets For Subashi Posted Tuesday 23rd July, 2024 at 13:40(UTC+2) by Alaxandar Georgiev

Level 13: 1,000/2,000 (2,000)
Entries: 198/568


Both Artjoms Hromovs and Greece's Enea Subashi found themselves all-in preflop and they had monster hands. 

Artjoms Hromovs:
Enea Subashi:

Hromovs had his opponent quite dominated and it looked like it was over for Subashi on the
flop with Hromovs hitting top set.  Subashi was already packing his things when the hit the turn and brought some hope for him.

BANG .. what a river - the dealer drills the giving Subashi the straight he needs. Devastating river for Hromovs as he loses a big 94,000 pot, but still has a healthy stack of over a hundred thousand.

Player		Chips	Progress
Artjoms Hromovs		106,000	44,000
Enea Subashi		94,000	64,000

Forus Needs A Greenstein Posted Tuesday 23rd July, 2024 at 13:27(UTC+2) by Alaxandar Georgiev

Level 13: 1,000/2,000 (2,000)
Entries: 206/556

Tarjei Forus (pictured below) who managed to get to the 8-Game Ring Event yesterday opened shoved for a little less than 10 big blinds and got called by Kristo Klaassen who was sitting on the big blind.

Tarjei Forus:
Kristo Klaassen:

Forus needed to hit his ace since his opponent had a very strong pocket pair. No help for him on the flop, neither on the turn or river, which meant this bullet in Day 2 is finished for Tarjei Forus.

Player		Chips	Progress
Kristo Klaassen		78,000	9,500
Tarjei Forus		0	0

13:24 (UTC+2)

Start of Level 13
Blinds: 1,000/2,000     Ante: 2,000

Early Eliminations In Day 2 Posted Tuesday 23rd July, 2024 at 13:17(UTC+2) by Alaxandar Georgiev

Here are some of the players who already busted in the Day 2. Hopefully, most of them return and keep battling for the ring as late registration is open for 2 more levels.

Player		Chips	Progress
Mikael Haapaniemi		0	0
Arturs Pless		0	0
Hans Hagberg		0	0
Hans Abrahamsson		0	0
Laurynas Vaitkevicius		0	0
Jan Holte		0	0
Sondre Lunde		0	0
Richard Koppel		0	0
Joel Haapio		0	0
Alvils Bijons		0	0
Eriks Krumins		0	0
Kim Granneman		0	0
Anton Makejev		0	0
Sondre Lunde		0	0
Matts Jakobsson		0	0
Sondre Lunde		0	0
Jon Kyte		0	0
Egidijus Digrys		0	0
Artur Kulanurk		0	0
Pavel Solodovnikov		0	0
Daniel Daw		0	0
Taago Tamm		0	0
David Bright		0	0
Dzianis Dubina		0	0
Stanislav Smeljov		0	0
Gatis Popovs		0	0
Daniel Stacey		0	0
Jussi Julkunen		0	0
Ricardas Bartasius		0	0
Paul Koppe		0	0
Ekrem Esker Atush		0	0
Chris-Mikael Hansen		0	0
Ville-Tapio Mesiranta		0	0
Janis Vasiljevs		0	0
Uladzimir Luchkou		0	0
Zechariah Montoya		0	0
Enea Subashi		0	0
Kimmo Mertala		0	0
Rolandas Aglinskas		0	0
Nils Veipans		0	0
Christopher Dowling		0	0
Sander Einlo		0	0
Sergei Kuznetsov		0	0
Jari-Pekka Juhola		0	0
Dalius Ulevicius		0	0

Hromovs Extends His Good Stack Posted Tuesday 23rd July, 2024 at 12:58(UTC+2) by Alaxandar Georgiev

Level 12: 1,000/1,500 (1,500)
Entries: 235/535

Artjoms Hromovs was heads-up on the river against France's Erwan Pirotais and there were already 40,000 chips in the middle on the board. Hromovs jammed his four chips in each worth 25,000 and got his opponent into the tank. 

After a while, Pirotais ended up folding and Hromovs is up to 150,000 with the average stack being 70,000 at the moment.

Player		Chips	Progress
Artjoms Hromovs		150,000	91,000
Erwan Pirotais		37,000	39,000

12:43 (UTC+2)

Start of Level 12
Blinds: 1,000/1,500     Ante: 1,500

Stewart Gets A Good One Posted Tuesday 23rd July, 2024 at 12:40(UTC+2) by Alaxandar Georgiev

Level 11: 1,000/1,500 (1,500)
Entries: 237/519

Once again Joshua Stewart was in play as he put all of his remaining 13,500 chips all-in after a 3,000 raise from Ville-Matti Keränen.  Jarmo Salonen called from the big blind and Keränen put another 10,500 for the call. 

Just like one of the earlier pots it checked around till the river on  board and everyone turned their cards up.

Joshua Stewart:
Jarmo Salonen:
Ville-Matti Keränen:

Salonen had a pair of Kings, which was good against Keränen's pocket fives, but it was no bueno against Stewert's set of nines. A nice triple-up for him and he is up to a bit over 40,000.

Player		Chips	Progress
Jarmo Salonen		164,000	41,500
Ville-Matti Keranen		48,500	13,500
Joshua Stewart		41,500	23,500

Can Häkkinen Find A Triple-Up ? Posted Tuesday 23rd July, 2024 at 12:22(UTC+2) by Alaxandar Georgiev

Level 11: 1,000/1,500 (1,500)
Entries: 235/497

Joshua Stewart opened up the action on table number 3 with a raise to 3,000 and an all-in followed by Verneri  Häkkinen from the cutoff. It folded around to Sargon Esfendiyari on the big who made the call for 11,500 - Stewert also completed with a call. 

Three-way to the flop no action was made by both still involved. Checks from both on the turn and river got them all to show their cards.

Joshua James Stewart:
Verneri Häkkinen:
Sargon Esfendiyari:

Esfendiyari was likely to win the pot even without the river, but it certainly helped his cause.  Häkkinen busts Day 2, but he still has 4 more levels to re-enter and fight for the golden ring.

Player		Chips	Progress
Sargon Esfendiyari		50,000	25,500
Joshua Stewart		18,000	7,000
Verneri Hakkinen		0	0

Shuffle Up And Deal - Day 2 of Ring Event #3: €555 No-Limit Hold'em Starts Posted Tuesday 23rd July, 2024 at 12:12(UTC+2) by Alaxandar Georgiev

Action at Olympic Park Casino starts once again with Day 2 of Ring Event #3: €555 No-Limit Hold'em.

235 players managed to continue from the four starting days and 8 we already have 8 new entries so far. Late registration is open for the first 4 levels and then it's game on for the third golden ring in the WSOP Circuit here in Tallinn.

11:57 (UTC+2)

Day 2 of Olympic Park Casino Started
Level: 11     Blinds: 1,000/1,500     Ante: 1,500

Marcus Carlsen Leads €555 NLH Heading Into Day 2 Posted Tuesday 23rd July, 2024 at 11:04(UTC+2) by Jason Glatzer

The three-day Event #3: €555 No-Limit Hold'em ring event completed its four opening flights with the field already attracting 461 entries for a €221,280 prize pool.

These figures will continue to grow as late registration remains open for the first four blind levels of Tuesday's Day 2, which begins at 12 p.m. The first two blind levels of the day will be 1,000/1,500 (1,500) before two levels repeat again with 1,000/2,000 (2,000) blinds. This means players buying in on Day 2 or re-entering if things don't start well will have 20 big blinds at the start with a 30,000 starting stack.

After that, late registration will close, the prizes will be announced, and blinds will continue to increase every 30 minutes until a final table of nine players is reached.

Norway's Marcus Carlssen leads the way heading into Day 2 with an impressive 218,500 chip stack. Finland's Rasmus Sihvonen (208,500) and Jarmo Salonen (205,500) were the only two players to begin the day with at least 200,000 in chips.

We will be live reporting Event #5: €555 No-Limit Hold'em from Day 2 onwards.

Day 2 Seat Draw Posted Tuesday 23rd July, 2024 at 10:48(UTC+2) by Jason Glatzer

Table	Seat	Name	Country	Chips	Big Blinds
1	1	Mikael Haapaniemi	Finland	15,000	10
1	2	Aleksandr Januskevic	Lithuania	69,000	46
1	3	Tarjei Forus	Norway	30,000	20
1	5	Georgi Abuladze	Estonia	68,000	45
1	6	David Tennback	Sweden	18,000	12
1	7	Summer Westerbur	United States	39,500	26
1	8	Kristo Klaassen	Estonia	68,500	46
2	1	Marius Morel	Estonia	66,500	44
2	2	Ralf Mikk	Estonia	66,500	44
2	3	Marten Oks	Estonia	67,000	45
2	4	Pavel Solodovnikov	Estonia	26,500	18
2	5	Edoardo Mancinelli	Italy	80,000	53
2	6	Jani Tuovinen	Finland	34,500	23
2	7	Tobias Napel	Norway	77,000	51
3	2	Stanislav Smeljov	Estonia	61,500	41
3	3	Hok Lai	United Kingdom	96,500	64
3	4	Joshua Stewart	Northern Ireland	25,000	17
3	5	Verneri Hakkinen	Finland	11,500	8
3	6	Nikodemas Staniukaitis	Lithuania	67,500	45
3	7	Jarmo Salonen	Finland	205,500	137
3	8	Sargon Esfendiyari	Finland	24,500	16
4	2	Igor Aleksandrov	Estonia	38,000	25
4	3	Modestas Kryzanauskas	Lithuania	32,500	22
4	4	Liutauras Armanavicius	Lithuania	47,000	31
4	5	Konsta Heikkila	Finland	50,000	33
4	6	Tapio Aaltonen	Finland	73,500	49
4	7	Aleksander Lattikas	Estonia	85,000	57
4	8	Mika Hautakangas	Finland	26,500	18
5	1	Timo Ruuska	Finland	55,000	37
5	2	Aurimas Stanevicius	Lithuania	58,500	39
5	3	Anton Makejev	Estonia	22,000	15
5	4	Maksym Klopotok	Ukraine	111,000	74
5	5	Linda Nguyen	Norway	125,500	84
5	6	Tomi Arponen	Finland	129,500	86
5	7	Dalius Ulevicius	Lithuania	26,000	17
6	1	Mario Fenaroli	Switzerland	58,500	39
6	2	Xi Tran	Norway	62,500	42
6	3	Erik Lindqwist	Sweden	151,000	101
6	4	Dmitri Dudakov	Estonia	54,000	36
6	5	Arturs Pless	Latvia	19,500	13
6	7	Andrius Dubietis	Lithuania	106,500	71
6	8	Klaudijus Bajoras	Lithuania	23,500	16
7	1	Dmitri Damaskin	Estonia	64,500	43
7	2	Tommy Piiroinen	Finland	192,500	128
7	4	Vadims Milovs	Latvia	49,500	33
7	5	Zanas Lubys	Lithuania	54,000	36
7	6	Johannes Cleven	Norway	29,000	19
7	7	Eriks Krumins	Latvia	36,000	24
7	8	Kim Granneman	Norway	30,500	20
8	1	Marius Hakonsen	Norway	75,500	50
8	3	Tero Laurila	Finland	76,000	51
8	4	Morten Bremseth	Norway	70,000	47
8	5	Oskar Ojaveer	Estonia	48,500	32
8	6	Tuomas Tervonen	Finland	30,500	20
8	7	Ekrem Esker Atush	Finland	77,500	52
8	8	Kestutis Jungevicius	Lithuania	136,000	91
9	1	Algirdas Sukys	Lithuania	22,000	15
9	2	Vasyl Tkachenko	Ukraine	80,000	53
9	3	Jussi Julkunen	Finland	35,000	23
9	4	Roope Tarmi	Finland	35,500	24
9	6	Artjoms Hromovs	Latvia	59,000	39
9	7	Taago Tamm	Estonia	23,000	15
9	8	Erwan Pirotais	France	76,000	51
10	1	Bjorn Tore Tvedt	Norway	22,000	15
10	2	Antti Vetelainen	Finland	92,000	61
10	3	Marcus Carlsen	Norway	218,500	146
10	4	Petteri Miettinen	Finland	20,500	14
10	5	Laurynas Vaitkevicius	Lithuania	79,500	53
10	6	Richard Koppel	Estonia	14,000	9
10	8	Christopher Dowling	Ireland	59,500	40
11	1	Igor Pihela Jr	Estonia	78,500	52
11	2	Jaakko Tirkkonen	Finland	31,000	21
11	3	Artur Kulanurk	Estonia	19,000	13
11	4	Ville Pohjalainen	Finland	96,000	64
11	6	Dzianis Dubina	Poland	28,500	19
11	7	Jonatan Fors	Finland	15,000	10
11	8	Sebastian Wahl	Finland	42,000	28
16	1	Vidar Assersen	Norway	75,500	50
16	3	Kevin Karenius	Finland	56,500	38
16	4	Andrei Mjagkov	Estonia	140,500	94
16	5	Siim Suviste	Estonia	115,000	77
16	6	Herli Olop	Estonia	44,500	30
16	7	Roope Holma	Finland	43,000	29
16	8	Ignotas Tamasauskas	Lithuania	53,000	35
17	1	Aleksandr Jelpidiforov	Estonia	142,000	95
17	2	Boris Smolianskii	Israel	59,000	39
17	3	Luka Sorainen	Finland	92,500	62
17	4	Nicolas Bokowski	Germany	111,000	74
17	6	Sander Leigri	Estonia	80,500	54
17	7	David Bright	Northern Ireland	43,000	29
17	8	Ranno Sootla	Estonia	37,000	25
18	1	Frederico Alves Dos Santos	Brazil	50,000	33
18	2	Andre Magi	Estonia	61,500	41
18	4	Franco Spichtig	Switzerland	37,000	25
18	5	Deniss Levinskis	Latvia	29,000	19
18	6	Janis Vasiljevs	Latvia	24,000	16
18	7	Jordi Conejos Baixas	Spain	60,000	40
18	8	Aleksi Naski	Finland	119,000	79
23	1	Arturs Putnins	Latvia	64,000	43
23	2	Hans Hagberg	Sweden	29,000	19
23	3	Andrius Bielskis	Lithuania	50,500	34
23	5	Nebojsa Musulin	Germany	183,000	122
23	6	Victor Prior Fernandez Amat	Spain	78,500	52
23	7	Aleksandr Naumov	Lithuania	59,500	40
23	8	Chris-Mikael Hansen	Norway	74,500	50
24	1	Markku Ihamaki	Finland	41,000	27
24	3	Nils Veipans	Latvia	96,500	64
24	4	Christian Steinbo	Norway	74,000	49
24	5	Ridas Bitauskas	Lithuania	43,500	29
24	6	Roman Jezov	Estonia	121,000	81
24	7	Daniel Daw	United Kingdom	23,000	15
24	8	Timo Malo	Finland	150,000	100
25	1	Edvinas Tarasevicius	Lithuania	82,500	55
25	3	Kazimieras Ramaska	Lithuania	91,500	61
25	4	Kaspars Butans	Latvia	55,000	37
25	5	Athanasios Kostouros	Greece	24,000	16
25	6	Ritvars Cekalins	Latvia	17,500	12
25	7	Matts Jakobsson	Sweden	35,000	23
25	8	Victor Fernandez Garcia	Spain	49,500	33
26	1	Jari Mahonen	Finland	70,500	47
26	2	Jeffrey Cormier	Canada	85,500	57
26	3	Nils Butevics	Latvia	27,000	18
26	5	Natalia Manuyko	Estonia	92,000	61
26	6	Jevgenijs Sapronenko	Latvia	70,500	47
26	7	Lorenzo Arduini	Italy	44,000	29
26	8	Kristjan Maasalu	Estonia	129,500	86
27	1	Tigrans Vilums	Latvia	99,000	66
27	2	Ben Slack	United Kingdom	84,500	56
27	3	Mairo Tori	Estonia	60,500	40
27	4	Theis Nielsen	Norway	63,500	42
27	5	Radoslaw Hordynski	Poland	29,500	20
27	6	Enea Subashi	Greece	28,500	19
27	8	Andrius Mazeika	Lithuania	68,500	46
28	1	Tarmo Tammel	Estonia	29,500	20
28	2	Kaido Koorits	Estonia	60,000	40
28	3	Vitalijus Kuzmicius	Lithuania	88,500	59
28	4	Kimmo Kurko	Finland	115,000	77
28	5	Daniel Stacey	United Kingdom	64,500	43
28	7	Meelis Ahman	Estonia	104,000	69
29	1	Oleksii Natoptanyi	Ukraine	74,000	49
29	2	Sergei Kuznetsov	Estonia	27,000	18
29	3	Jan Holte	Norway	32,500	22
29	4	Sondre Lunde	Norway	9,000	6
29	7	Tanel Evert	Estonia	101,500	68
29	8	Otto Kiiskinen	Finland	85,000	57
30	2	Hans Fernkvist	Sweden	125,000	83
30	3	Jari-Pekka Juhola	Finland	92,000	61
30	4	Dominik Ostrowski	Poland	71,000	47
30	6	Fredric Eriksson	Sweden	91,000	61
30	7	Tal Herzog	Israel	38,500	26
30	8	Roman Petelytskyi	Ukraine	38,000	25
31	1	Mohammed Al-Khazraji	Finland	96,000	64
31	2	Mykola Kostyrko	Ukraine	90,500	60
31	3	Raphael Godard	France	60,500	40
31	4	Donatas Pilinkus	Lithuania	106,500	71
31	5	Alexey Cherkasov	Estonia	32,500	22
31	8	Sauli Haapaniemi	Finland	29,500	20
32	1	Hans Abrahamsson	Sweden	48,500	32
32	3	Rolandas Aglinskas	Lithuania	47,500	32
32	4	Nohad Teliani	Canada	34,000	23
32	5	Paul Koppe	Estonia	21,000	14
32	6	Timmy Anker	Denmark	170,500	114
32	7	Marios Mansour	Cyprus	125,000	83
32	8	Teppo Joentausta	Finland	97,500	65
33	1	Mykhailo Mikhalov	Ukraine	93,000	62
33	2	Joel Haapio	Finland	28,500	19
33	4	Jorn Martinsen	Norway	116,500	78
33	5	Luca Sebastiani	Italy	43,500	29
33	6	Jari Porkka	Sweden	37,000	25
33	7	Kasper Mellanen	Finland	157,500	105
33	8	Knut Turk	Estonia	70,000	47
34	1	Egidijus Digrys	Lithuania	17,000	11
34	2	Konstantin Farber	Germany	107,000	71
34	3	Kimmo Mertala	Finland	37,000	25
34	4	Artjoms Sutjagins	Latvia	18,000	12
34	5	Miika Toyras	Finland	10,900	7
34	6	Jargo Alavali	Estonia	61,500	41
34	8	Roger Odden	Norway	127,000	85
35	1	Christel Haller	Estonia	62,500	42
35	2	Maikel Homin	Estonia	144,500	96
35	3	Anders Beckman	Sweden	18,500	12
35	4	Daniel Tankel	United Kingdom	77,500	52
35	6	Priit Vanem	Estonia	25,000	17
35	7	Ricardas Bartasius	Lithuania	16,500	11
35	8	Ville-Tapio Mesiranta	Finland	58,000	39
36	1	Ruslans Levockins	Latvia	69,000	46
36	2	Jorden Verbraeken	Belgium	44,000	29
36	3	Rasmus Sihvonen	Finland	208,500	139
36	4	Sakari Setala	Finland	72,000	48
36	5	Peteris Balodis	Latvia	42,000	28
36	7	Henri Schalin	Finland	130,000	87
36	8	Uladzimir Luchkou	Belarus	23,000	15
37	1	Sander Einlo	Estonia	91,500	61
37	2	Jon Kyte	Norway	32,500	22
37	3	Maksim Petrov	Estonia	67,000	45
37	5	Lasse Aarninsalo	Finland	46,000	31
37	6	Sohrab Malkari	Norway	70,500	47
37	7	Tadas Simas	Lithuania	35,000	23
37	8	Helina Tamm	Estonia	50,500	34
38	1	Kaido Mikk	Estonia	125,000	83
38	2	Masse Mirza	Estonia	22,500	15
38	3	Alvils Bijons	Latvia	42,000	28
38	5	Rashad Iskandarov	Estonia	58,000	39
38	6	Jaanus Veste	Estonia	52,500	35
38	7	Robert Kallikorm	Estonia	58,500	39
38	8	Audrius Laimelis	Lithuania	73,000	49
39	2	Touko Berndtson	Finland	21,000	14
39	3	Espen Sandvik	Norway	24,000	16
39	4	Tanel Merida	Estonia	50,000	33
39	5	Enrique Martinez	Spain	57,000	38
39	6	Zechariah Montoya	United States	28,500	19
39	7	Gatis Popovs	Latvia	42,500	28
39	8	Kelly Limonova	Estonia	46,500	31