0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0094 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/32/123/updates'
ORDER BY `views` DESC

0.0009 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/32/123/updates', 1, '2024-11-22')

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

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

0.0431 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0089 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '101'
AND `published` = 1

0.0303 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '123'
AND `published` = 1

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

0.0065 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` = '123'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '5323'
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` = '5309'
ORDER BY `chip_change` DESC, `busted` ASC

0.0100 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5305'
ORDER BY `chip_change` DESC, `busted` ASC

0.0126 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5300'
ORDER BY `chip_change` DESC, `busted` ASC

0.0095 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5299'
ORDER BY `chip_change` DESC, `busted` ASC

0.0118 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5297'
ORDER BY `chip_change` DESC, `busted` ASC

0.0119 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5293'
ORDER BY `chip_change` DESC, `busted` ASC

0.0118 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5285'
ORDER BY `chip_change` DESC, `busted` ASC

0.0083 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5276'
ORDER BY `chip_change` DESC, `busted` ASC

0.0076 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5274'
ORDER BY `chip_change` DESC, `busted` ASC

0.0119 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5266'
ORDER BY `chip_change` DESC, `busted` ASC

0.0124 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5263'
ORDER BY `chip_change` DESC, `busted` ASC

0.0123 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5260'
ORDER BY `chip_change` DESC, `busted` ASC

0.0120 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5257'
ORDER BY `chip_change` DESC, `busted` ASC

0.0120 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5250'
ORDER BY `chip_change` DESC, `busted` ASC

0.0120 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5245'
ORDER BY `chip_change` DESC, `busted` ASC

0.0086 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5241'
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` = '5233'
ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5232'
ORDER BY `chip_change` DESC, `busted` ASC

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5237'
ORDER BY `chip_change` DESC, `busted` ASC

0.0120 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5213'
ORDER BY `chip_change` DESC, `busted` ASC

0.0121 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5210'
ORDER BY `chip_change` DESC, `busted` ASC

0.0124 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5223'
ORDER BY `chip_change` DESC, `busted` ASC

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5206'
ORDER BY `chip_change` DESC, `busted` ASC

0.0126 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5199'
ORDER BY `chip_change` DESC, `busted` ASC

0.0123 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5218'
ORDER BY `chip_change` DESC, `busted` ASC

0.0098 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5215'
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` = '5208'
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` = '5203'
ORDER BY `chip_change` DESC, `busted` ASC

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5189'
ORDER BY `chip_change` DESC, `busted` ASC

0.0118 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5183'
ORDER BY `chip_change` DESC, `busted` ASC

0.0121 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5182'
ORDER BY `chip_change` DESC, `busted` ASC

0.0126 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5180'
ORDER BY `chip_change` DESC, `busted` ASC

0.0131 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5170'
ORDER BY `chip_change` DESC, `busted` ASC

0.0124 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5165'
ORDER BY `chip_change` DESC, `busted` ASC

0.0122 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5163'
ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5158'
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` = '5157'
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` = '5155'
ORDER BY `chip_change` DESC, `busted` ASC

0.0095 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5151'
ORDER BY `chip_change` DESC, `busted` ASC

0.0111 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5147'
ORDER BY `chip_change` DESC, `busted` ASC

0.0095 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5154'
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` = '5146'
ORDER BY `chip_change` DESC, `busted` ASC

0.0095 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5153'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0109 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` = '123'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0131 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5323'
ORDER BY `chip_change` DESC, `busted` ASC

0.0117 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5309'
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` = '5305'
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` = '5300'
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` = '5299'
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` = '5297'
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` = '5293'
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` = '5285'
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` = '5276'
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` = '5274'
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` = '5266'
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` = '5263'
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` = '5260'
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` = '5257'
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` = '5250'
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` = '5245'
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` = '5241'
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` = '5233'
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` = '5232'
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` = '5237'
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` = '5213'
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` = '5210'
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` = '5223'
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` = '5206'
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` = '5199'
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` = '5218'
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` = '5215'
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` = '5208'
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` = '5203'
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` = '5189'
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` = '5183'
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` = '5182'
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` = '5180'
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` = '5170'
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` = '5165'
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` = '5163'
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` = '5158'
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` = '5157'
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` = '5155'
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` = '5151'
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` = '5147'
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` = '5154'
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` = '5146'
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` = '5153'
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` = '123'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Translate
WSOPC Tallinn Event #5: €660 No-Limit Hold'em Mystery Bounty Live Reporting - Day 2
WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)
Current Level 19 Current Day 2
Blinds 5,000/10,000 Ante 10,000
Entries 164 Remaining 1
Prize Pool (EUR) €94,464 First Prize (EUR) €10,000
Day 1 Day 2
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Live Updates - Day 2
Ranno Sootla Takes Estonia's Third Victory in 2023 WSOPC Tallinn Event #5: €660 Mystery Bounty (€10,000) Posted Tuesday 19th September, 2023 at 20:36(UTC+0) by Lina Olofsson

Congrats to Ranno Sootla as not only did he become the thrid Estonian to win a gold ring after shipping Event #5: €660 No-Limit Hold'em Mystery Bounty but also perfectly complimented the WSOP bracelet he won with a ring.

Sootla is one of the more popular players in Estonia and has crushed events online and at Olympic Park Casino for years before recently moving into cash games.

Event #5: €660 Mystery Bounty Final Table Results

Place Name Country Prize Bounty Total
1 Ranno Sootla Estonia €10,000 €5,000 €15,000
2 Yusuke Tanaka Japan €7,020 €1,500 €8,520
3 Vilius Zabarauskas Lithuania €5,100 €5,600 €10,700
4 Urmo Velvelt Estonia €4,060 €16,500 €20,560
5 Marco Baglioni Italy €3,054 €6,100 €9,154
6 Bjorn Lindberg Sweden €2,500 €0 €2,500
7 Martin Sedlak Germany €2,040 €0 €2,040
8 Yanis Sahli France €1,670 €0 €1,670

Final Day Action

As Day 2 the 2023 WSOPC Tallinn Event #5: €660 No-Limit Hold'em Mystery Bounty started in the Estonian capital of Tallinn at noon today 25 players remained of the initial starting field of 164 to begin with. All 25 players were then able to pick up one of the mystery bounties available for each player you knocked out of the tournament. In one of these was an astonishing €10,000 up for grabs while in other envelopes it could be something in between €600 to €7,000.

A total of 21 players were paid in this event and it went pretty quickly down to the bubble where the tournament then went on hand-by-hand until we had two players all-in at the same time ending up splitting the prize money of €650 receiving €325 each.

From there it went in the blink of an eye down to the final 16 where a re-draw was made of the two tables before they were all moved to the two feature tables streamed on air until we had our last man standing.

A bounty tournament has a whole other aspect to take in before making any decisions since knocking someone out would earn you extra cash on top of the prize money. With this mystery bounty where there was such a huge difference between the amounts, it was even more tempting to make a loose call if you had the possibility to knock someone out since the more bounties you collected the more envelopes you were able to draw from the raffle and lay your hand on the big bucks.

That this affected the play became more and more obvious as we started the stream and several players were shortstacked. We would see so many three and four-way all-ins that it was almost hard to catch up with all the action. That’s not something you would see in a regular No-Limit Hold’em tournament if it wasn’t a huge cooler at showdown.

As a matter of fact, these factors made the final nine only become the final eight after Vilius Zabarauskas caught two birds with one stone down to the last ten players with his ace-queen which held all the way against Andrius Bielskis with king-nine and Sebastian Wahl’s king-queen sending them both to the rail on the final table bubble. This hand also gave him the chip lead going into the final table of eight.

The first player eliminated at the final table was in yet another three-way all-in when Zabarauskas, Yusuke Tanaka, and Yanis Sahli with two players at risk of elimination but it ended up with Tanaka taking down the pot as Sahli exited the tournament in eighth place for  €1,670.

Soon after that, it was time for another all-in. This time it was the German Martin Sedlak who couldn’t find any of his outs with pocket fours versus Tanaka who had pocket fives. Sedlaks seventh place paid him €2,040.

Sweden’s favorite mascot Bjorne Lindberg was the next man to leave as his stack went in with ace-five which had no chance of catching an ace against Urmo Velvelt with pocket sixes. For sixth place, Bjorne was awarded €2,500.

Marco Baglioni was the next player to hit the door when his ace-nine neither could get lucky against Tanaka with ace-queen. The Italian got €3,050 for finishing sixth. But he was one of the players who got lucky in the mystery bounty and could collect another 6,000 to that making it €9,050 for his efforts.

Down to four players, the previous aggressive play pre-flop slowed down drastically and it took over an hour before the next player was out. Velvelt ran straight into jacks with his ace-eight against Sootla and he was out for a €4,060 payout. But after busting out Velvelt soon could add a bunch more to that since he had an astonishing five bounties to collect and was very lucky in the drawing for mystery bounties and winning €20,560 in total in this tournament which actually made him cash the most money of all of the finalists.

Vilius Zabarauskas

The former chip leader Zabarauskas lost a lot of pots and found himself as the shortest stack when he was in for a coin flip against Sootla which didn’t go in his favor when he didn’t hit the board with ace-queen versus jacks. An €5,050 was the award for third place but with several of those wanted bounty chips he collected double that amount receiving €10,700 in total.

Going into heads-up we had the chance to crown one more Estonian player as Sootla started the match with a two-to-one lead over Tanaka. And he never let that lead slip away and in the last hand of the tournament, it was a huge cooler for Tanaka’s ace-queen as he was up against Sootla’s ace-king. No queen or anything else on the board that could help the underdog it was all over and it was time to say congratulations to yet another Estonian for getting one of the 12 circuit rings up for grabs here in Tallinn on top of the €10,000 he received for first. And not just that. He got another €5,000 for his bounty too. Second place paid Tanaka €7,020 but he had another €1,500 added to that after picking up his mystery bounty.

Congratulations to Ranno Sootla for becoming the latest ring winner at the 2023 World Series of Poker Circuit Tallinn. Stay tuned at OlyBet.tv as we cover all the ring events throughout the week.

Author: Lina Olofsson
Editor: Jason Glatzer
Photographers: Elena and Tambet Kask
Blog: Courtesy of OlyBet and Olympic Park Casino
Yusuke Tanaka Eliminated in 2nd Place (€7,020) Posted Tuesday 19th September, 2023 at 17:28(UTC+0) by Lina Olofsson

Level 27: 30,000/60,000 (60,000)
Entries: 1/164

Yusuke Tanaka had a good day at the final table today but didn't get much going in the end and with his opponent with a two-to-one lead he didn't need much consideration before putting his life at stake when looking down on . But that should be a real cooler since Ranno Sootla had an even better hand with his . 

The board ran out didn't help Japanese Tanaka who finished in second place for €7,020).

 
Player Chips Progress
Yusuke Tanaka 0 0
Pictures From Today Posted Tuesday 19th September, 2023 at 17:09(UTC+0) by Lina Olofsson

In the gallery above you will find all the pictures so far in this event if you want to have a look as the players are on a leg stretcher while the tournament organizers arranged a gathering to reveal the amazing WSOP ring that's up for grab to every winner in our circuit events here in Tallinn. 
Sootla In Big Favor As We Are Heads-up Posted Tuesday 19th September, 2023 at 16:59(UTC+0) by Lina Olofsson

Level 26: 25,000/50,000 (50,000)
Entries: 2/164

Ranno Sootla from Estonia goes into the heads-up as two-to-one chip leader as the play resumes for the very last bounty and of course the luxurious WSOP Circuit ring. We still have a couple of minutes left on the clock on this level and then they will go on a 20-minute long break. 
Player Chips Progress
Ranno Sootla 3,200,000 1,600,000
Yusuke Tanaka 1,700,000 400,000
Vilius Zabarauskas Eliminated in Third Place (€5,010) Posted Tuesday 19th September, 2023 at 16:53(UTC+0) by Lina Olofsson

Level 26: 25,000/50,000 (50,000)
Entries: 3/164

After two levels with just smaller pots the blinds started to catch up on our players and after looking down on our former chip leader going into the final table with a bunch of bounty chips to go with that Vilius Zabarauskas pushed his stack in the middle and was called by Ranno Sootla who had . 

The coinflip didn't land on the side for Zabarauskas as a his opponent flopped a third jack on the board , the on the turn and sealed the deal and yet another player was sent to the rail but this one with six bounty chips to collect and as a matter of fact he actually was the lucky one collecting the €10K bounty so we'd guess he wasn't too sad when eliminated. We will get back to you with how much he actually got away with in the raffle of mystery bounty envelopes as soon as we have all the details. One thing is certain and that's the fact he walked away with way more than the prize of €5,010 he collected for finishing third. 
Player Chips Progress
Vilius Zabarauskas 0 0
Meet GGPoker Ambassador Anatoly Filatov at the WSOPC Tallinn Posted Tuesday 19th September, 2023 at 16:47(UTC+0) by Jason Glatzer

Urmo Velvelt Eliminated in 4th Place (€4,060) Posted Tuesday 19th September, 2023 at 16:43(UTC+0) by Lina Olofsson

Level 26: 25,000/50,000 (50,000)
Entries: 4/164

After some pending play with four players left Urmo Velvelt decided to push his chips in pre flop after looking down on with ten big blinds. Action was folded to his fellow countrymen Ranno Sootla who had and made the call. 

Flop:
Turn:
River:

No luck for Urmo Velvelt who finished fourth for €4,060. 
Player Chips Progress
Ranno Sootla 1,600,000 500,000
Urmo Velvelt 0 0
Small Ball Poker Posted Tuesday 19th September, 2023 at 16:33(UTC+0) by Lina Olofsson

Level 26: 25,000/50,000 (50,000)
Entries: 4/164

The final four has gone from a very action loaded final table to one with a lot of small ball poker. Tune into our LIVE STREAM to see everything evolve here in the €660 Mystery Bounty event #5.
Break Time! Posted Tuesday 19th September, 2023 at 15:57(UTC+0) by Lina Olofsson

Our remaining four players went on a 20 minute break. Below you can see their chipcounts when play resumes and the battle for the bounty chips, the WSOPC golden ring and €10k in first prize. 
Player Chips Progress
Yusuke Tanaka 2,100,000 300,000
Ranno Sootla 1,100,000 100,000
Urmo Velvelt 550,000 5,000
Vilius Zabarauskas 0 0
Tanaka Just Got Away With a Three Barrel Bluff Posted Tuesday 19th September, 2023 at 15:53(UTC+0) by Lina Olofsson

Level 25: 15,000/30,000 (30,000)
Entries: 4/164

Yusuke Tanaka just got away with a huge bluff against Vilius Zabarauskas. 

The Japanese raised to 60k pre flop with and was called by Zabarauskas with . On the flop Tanaka bet 70k and was called by Zabarauskas. Turn is and Tanaka pops it again to 125k and gets another call. On the river he fires his third bullet and this time he goes all-in for over a million into the 500k pot. Zabarauskas probably regret slowplaying his hand as he folds his hand and the Japanese takes even a further lead with over two million in his stack now. 
Marco Baglioni Eliminated in 5th Place (€3,050) Posted Tuesday 19th September, 2023 at 15:27(UTC+0) by Lina Olofsson

Level 24: 15,000/30,000 (30,000)
Entries: 4/164

In the battle between the blinds Marco Baglioni didn't believe Japanese Yusuke Tanaka and made the call for all of his chips but Tanaka was good for that all-in and ahead with his against Baglionis

Flop:
Turn:
River:

The flop put our player at risk in the lead but Tanaka took it back on the turn and no shocker on the river eliminated Marco Baglioni in fifth for €3,050 added to whatever is in that mystery envelope he gets to open as soon as we go on a break since he also has another bounty chip and already opened one. 
Player Chips Progress
Yusuke Tanaka 1,800,000 500,000
Marco Baglioni 0 0
Tanaka Takes A Slight Lead Posted Tuesday 19th September, 2023 at 15:20(UTC+0) by Lina Olofsson

Level 24: 15,000/30,000 (30,000)
Entries: 5/164

With already 350K in the middle after some action pre Urmo Velvelt with and Yusuke Tanaka saw the flop  

Tanaka bet 80,000 after a check from his opponent. Velvelt made the call. Turn came which was checked-raised all-in by Tanaka who got Velevet to instantly fold his hand. That pot takes Tanaka up to the chip lead with our remaining five players still competing for the €10,000 in first prize plus all the mystery bounties up for grabs.
Player Chips Progress
Yusuke Tanaka 1,300,000 300,000
Ranno Sootla 1,200,000 15,000
Vilius Zabarauskas 1,200,000 50,000
Marco Baglioni 770,000 520,000
Urmo Velvelt 555,000 595,000
Bjorn Lindberg Eliminated in 6th Place (€2,500) Posted Tuesday 19th September, 2023 at 15:06(UTC+0) by Lina Olofsson

Level 23: 10,000/25,000 (25,000)
Entries: 5/164

Entering the final table as one of the short-stacked players Bjorn Lindberg needed a double-up with his 10 big blinds in front of him. Looking down on he pushed all-in and got one caller. That was Urmo Velvelt who sadly for the Swede had picked up a pocket pair with and Bjorne needed some magic to stay alive. 

The board ran out which wasn't any of the aces Bjorn so desperately needed and he was out in sixth for a €2,500 payday. 
Player Chips Progress
Urmo Velvelt 1,150,000 205,000
Bjorn Lindberg 0 0
Martin Sedlak Eliminated in 7th Place (€2,040) Posted Tuesday 19th September, 2023 at 14:59(UTC+0) by Lina Olofsson

Level 23: 10,000/25,000 (25,000)
Entries: 7/164

Martin Sedlak was just eliminated from the tournament getting his chips in with versus at Yusuke Tanaka. 

Flop:
Turn:
River:

No help on the board for our German on the final table who hits the cashier to pick up his €2,040 for seventh place finish.
Player Chips Progress
Yusuke Tanaka 1,000,000 300,000
Martin Sedlak 0 0
Yanis Sahli Eliminated in 8th Place (€1,670) Posted Tuesday 19th September, 2023 at 14:45(UTC+0) by Lina Olofsson

Level 23: 10,000/25,000 (25,000)
Entries: 7/164

The God of poker keeps on being very nice to our chip leader Vilius Zabarauskas who picked up yet another decent hand. He raised to 40,000 UTG and short stacked Yanis Sahli decided to push his chips all-in for 210,000. The action was folded to Yusuke Tanaka who did the same with 255,000 and Zabarauskas called had the chance to eliminate two more players in one hand even though he was behind this showdown: 

Zabarauskas:
Sahli:
Yusuke:

Board ran out and as Yusuke Tanaka raked the hand we had our first elimination on the final table as Yanis Sahli busted in eight for a €1,670 payday. 
Player Chips Progress
Vilius Zabarauskas 1,250,000 240,000
Yusuke Tanaka 700,000 425,000
Yanis Sahli 0 0
The Final Eight! Posted Tuesday 19th September, 2023 at 14:31(UTC+0) by Lina Olofsson

Level 22: 10,000/20,000 (20,000)
Entries: 8/164

After the presentation of our final eight players cards are back in the air in this fascinating Mystery Bounty tournament where we still haven't had anyone opening the mystery envelope with €10k.

Seat

Name

Country

Chips

1

Marco Baglioni

Italy

250,000

2

Yusuke Tanaka

Japan

275,000

3

Vilius Zabarauskas

Lithuania

1,490,000

4

Yanis Sahli

France

210,000

5

Bjorn Lindberg

Sweden

220,000

6

Ranno Sootla

Estonia

1,185,000

7

Urmo Velvelt

Estonia

945,000

8

Martin Sedlak

Germany

345,000

Player Chips Progress
Vilius Zabarauskas 1,490,000 0
Ranno Sootla 1,185,000 1,184,999
Urmo Velvelt 945,000 0
Martin Sedlak 339,000 0
Yusuke Tanaka 275,000 0
Marco Baglioni 250,000 0
Bjorn Lindberg 220,000 0
Yanis Sahli 210,000 0
The Bounty Hunter Zabarauskas Takes Out both Wahl and Bielskis Posted Tuesday 19th September, 2023 at 14:19(UTC+0) by Lina Olofsson

Level 22: 10,000/20,000 (20,000)
Entries: 8/164

It was UTG our terminator, or bounty hunter number one if you prefer, Vilius Zabarauskas looked down on and min-raised it up to 40k. The action was folded to Andrius Bielskis in the small blind with who decided it was time to push his chips in with 155,000 in his stack. Over at big blind Sebastian Wahl decided to do the same with . Zabarauskas instantly called of course and we had two players at risk on our final table bubble and they couldn't have been too happy when cards were revealed and they saw their odds. 

Flop was as dry as the desert in Africa. Neither the on the turn was good to any of our two players just relying on the last card to stay alive in the tournament. But as the river was revealed it was over and we will now start our final table with only eight players. 

The players went on a shorter break as the re-draw was made and the feature table was set up.
Player Chips Progress
Vilius Zabarauskas 1,490,000 403,000
Andrius Bielskis 0 0
Sebastian Wahl 0 0
Day 5 Video Recap Posted Tuesday 19th September, 2023 at 13:48(UTC+0) by Jason Glatzer

Play Resumes After the Break Posted Tuesday 19th September, 2023 at 13:48(UTC+0) by Lina Olofsson

Play resumed a couple of minutes ago after today's first leg stretcher. Two more eliminations to go before we have our final eight in this tournament. 
Jarkko Suokas Claims €10,000 In Bounties Posted Tuesday 19th September, 2023 at 13:39(UTC+0) by Alaxandar Georgiev

After Jarkko Suokas drew the €3,000 bounty on the first break, he had to pull another mystery bounty short after he busted the tournament, and to his surprise, he drew another big one worth €7,000.

Even though he was eliminated from the tournament he will go home happy with his €10,000 in bounties + €800 for 12th place.
Baglioni Eliminates Ikonen Posted Tuesday 19th September, 2023 at 13:08(UTC+0) by Alaxandar Georgiev

Level 21: 10,000/15,000 (15,000)
Entries: 10/164

Pekka Ikonen shoved from the small blind and he was quickly called by Marco Baglioni from the big blind. 

Pekka Ikonen:
Marco Baglioni:

Decent flop for Ikonen as the dealer put and gave him some outs for the straight, turn and river didn't help him as well and he went out in 11th place (€960).
Player Chips Progress
Marco Baglioni 370,000 182,000
Pekka Ikonen 0 0
Huge Upset for Lindberg Posted Tuesday 19th September, 2023 at 13:03(UTC+0) by Alaxandar Georgiev

Level 21: 10,000/15,000 (15,000)
Entries: 11/164

This time Jarkko Suokas announced he was all in with Ranno Sootla isolating from the big blind for 530,000 chips and a snap call from Bjorn Lindberg on the big blind.

Jarkko Suokas: 
Ranno Sootla:
Bjorn Lindberg:

The flop stunned Lindberg as both of the other two hit their top pair. No luck for the player at risk - Suokas as the turn and river didn't improve his hand.

Massive pot for Sootla as he scoops all the chips and collects the bounty for Suokas's head.

Jarkko Suokas 12th place finish was worth €800.
Player Chips Progress
Ranno Sootla 1,115,000 401,000
Bjorn Lindberg 170,000 470,000
Jarkko Suokas 0 0
Norkus Runs Into Monster and Busts in 13th Posted Tuesday 19th September, 2023 at 13:02(UTC+0) by Lina Olofsson

Level 21: 10,000/15,000 (15,000)
Entries: 12/164

Our chipleader Vilius Zabarauskas surely picking up hands in the right spot. The hand before he won a pot against Martin Sedlak with queens and the very next hand he picked up pocket rockets after Sebastian Wahl pushed all-in. Action was folded all the way to Stanislovas Norkus wanted to get along for the ride. 

Wahl: ?
Zabarauskas:
Norkus:

It surely looks like we would have a double elimination at the main feature table but the board gave Wahl a straight picking up the pot but Stanislovas Norkus queens didn't have a chance as he was eliminated in 13th place. 
Player Chips Progress
Stanislovas Norkus 0 0
Unlucky Pots For Suokas Posted Tuesday 19th September, 2023 at 13:02(UTC+0) by Alaxandar Georgiev

After just losing the last three-way all-in he lost another all-in blind vs. blind with vs. Marco Baglioni's   he called another all-in again from Bjorn Lindberg who shoved for 320,00 after Suokas re-raised him from the small blind.

Bjorn Lindberg:
Jarkko Suokas:

The gave Suokas some additional outs against the favorite hand of Lindberg, but the turn and river brick won the hand for the Swede.

Suokas is now left with only 80,000 chips after he started the final two tables with 640,000.
Player Chips Progress
Bjorn Lindberg 640,000 410,000
Jarkko Suokas 80,000 315,000
Three Way All-In Posted Tuesday 19th September, 2023 at 13:02(UTC+0) by Alaxandar Georgiev

Early all-in from Jun Beum Chun for 150,000 opened the action and right next to him, Bjorn Lindberg put his remaining 72,000 chips in the middle.

With the decision left in Jarkko Suokas's hands on the big blind, he made the call as well.

Jun Beum Chun:
Bjorn Lindberg:
Jarkko Suokas:

A great flop for Suokas made the other players a bit nervous. A followed on the turn and the on the river meant a sure triple-up for Lindberg and Chun managed to return what he lost as he won the side pot against Suokas.
Player Chips Progress
Jarkko Suokas 245,000 150,000
Bjorn Lindberg 230,000 147,000
Jun Beum Chun 80,000 73,000
Henri Vaisanen Eliminated in a Four Way All-in Posted Tuesday 19th September, 2023 at 13:00(UTC+0) by Lina Olofsson

Level 20: 6,000/12,000 (12,000)
Entries: 14/164

We just had a four-way all-in on the feature table eliminating Henri Vaisanen left short after that other hand from the feature table. 

Sebastian Wahl:
Stanislovas Norkus:
Vaisanen:
Vilius Zabarauskas:

The board ran out and Henri Vaisanen was out in 15th place. 
Player Chips Progress
Henri Vaisanen 0 0
Wahl Triples in a Three Way All-in Posted Tuesday 19th September, 2023 at 12:59(UTC+0) by Lina Olofsson

Level 20: 6,000/12,000 (12,000)
Entries: 15/164

As this is a Mystery Bounty tournament and half of the prize pool is in those mystery envelopes players might seem a bit looser in their game than they usually would be and we just saw a perfect example of that on the main feature table as three players got all their chips in the middle pre flop. 

Henri Vaisanen:
Sebastian Wahl:
Yanis Sahli:

Board ran out and Sebastian Wahl triples as the two others chop the pot even though it made Henri Vaisanen very short after the hand. 
Player Chips Progress
Sebastian Wahl 200,000 140,000
Yanis Sahli 65,000 20,000
Henri Vaisanen 44,000 73,000
First Elimination as Joel Holmberg exits the door Posted Tuesday 19th September, 2023 at 12:50(UTC+0) by Lina Olofsson

Level 20: 6,000/12,000 (12,000)
Entries: 16/164

Finn Joel Holmberg was the first player eliminated at our main feature table as he decided to push his chips in with UTG. Our chip leader Vilius Zabarauskas decided to go for the chance on a bounty making the call with . 

Flop was a real action flop since Zabarauskas got a pair while our player at risk Holmberg picked up a flush draw. Turn wasn't helpful for the Finn and neither was the and he was eliminated while Zabarauskas picked up one of those valuable bounty chips. 
Player Chips Progress
Vilius Zabarauskas 1,087,000 200,000
Joel Holmberg 0 0
We Are Live Posted Tuesday 19th September, 2023 at 12:43(UTC+0) by Lina Olofsson

Tournament director Teresa Nousianen just made a presentation of the two last tables and mystery envelopes were opened. Neither one of them had the €10k in them. 

Tune into our LIVE STREAM to watch it all evolves in this €660 Mystery Bounty NLHE tournament.
The Two Last Tables Posted Tuesday 19th September, 2023 at 12:15(UTC+0) by Lina Olofsson

Here's the re-draw for the last two tables which will now be streamed on air after the redraw with a 30 minute delay. 

Feature table (table #1)

Seat

Name

Chips

1

Stanislovas Norkus

146,000

2

Martin Sedlak

339,000

3

Yanis Sahli

85,000

4

Henri Vaisanen

117,000

5

Joel Holmberg

159,000

6

Sebastian Wahl

60,000

7

Vilius Zabarauskas

887,000

8

Yusuke Tanaka

159,000

Secondary feature table (table #2)

Seat

Name

Chips

1

Bjorn Lindberg

83,000

2

Urmo Velvelt

813,000

3

Pekka Ikonen

269,000

4

Marco Baglioni

188,000

5

Jarkko Suokas

639,000

6

Andrius Bielskis

111,000

7

Ranno Sootla

714,000

8

Jun Beum Chun

153,000
On Air! Posted Tuesday 19th September, 2023 at 11:40(UTC+0) by Lina Olofsson

As the clock has stopped at 12:49 on the 20th level the players are now on their way out to the two feature tables which will be aired in approximately 40-45 minutes with a 30-minute delay. 

Watch the LIVE STREAM here! 
Dominik Ostrowski Out! Posted Tuesday 19th September, 2023 at 11:38(UTC+0) by Lina Olofsson

Joel Holmberg raised and Dominik Ostrowski pushed all his chips in from cutoff. Button and blinds got out of the way but Holmberg instantly called. 

Ostrowski:
Holberg:

Board ran out and Ostrowski was out. 

The hand after Tarmi Roope also exited the tournament as they were down to the final 16 players and a re-draw for their new seats before everything moves onto the two feature tables outside where you can watch it on our live stream. 
Player Chips Progress
Dominik Ostrowski 0 0
Double Elimination On The Bubble Posted Tuesday 19th September, 2023 at 11:36(UTC+0) by Alaxandar Georgiev

Level 19: 5,000/10,000 (10,000)
Entries: 21/164

Joel Holmberg jammed from the cutoff for 130,000 and Kriss Riekstins called from the big blind with his remaining 37,000 after he paid the blinds.  

Joel Holmberg:
Kriss Riekstins:

Ahead, but at risk Riekstins didn't seem to enjoy the flop and his hopes ended on the turn as Holmberg made the 1-card flush. 

At the same time on the other table Jesus Ucero was also all in against  Urmo Velvelt  on the flop with his .

Urmo had and also made the flush on the turn taking another bounty chip to his collection.

 This meant both players busted at the same time on the bubble and they split the prize of €650 for 21st place each taking €325.

With 19 players left after three more eliminations, players will re-draw and go to the featured and main table.
Player Chips Progress
Urmo Velvelt 415,000 53,000
Joel Holmberg 200,000 1,000
Jesus Ucero 0 0
Kriss Riekstins 0 0
Two Double Up's on the Bubble Posted Tuesday 19th September, 2023 at 11:05(UTC+0) by Lina Olofsson

Level: 19:5,000/10,000 (10,000)
Entries: 21/164

We just had two double up's here on the bubble. In the first hand, Bjorne Lindberg doubled with tens against Martin Sedlak with eights. On the other table, aces held against eights too for our player at risk and we are still one man to go before the bubble bursts. 
Player Chips Progress
Martin Sedlak 170,000 80,000
Bjorn Lindberg 160,000 61,000
10:53 (UTC+0)
Start of Level 19
Blinds: 5,000/10,000     Ante: 10,000
We're on the Bubble Posted Tuesday 19th September, 2023 at 10:46(UTC+0) by Lina Olofsson

We have lost our first four players in the tournament which also means four bounties have been given out which in the break when we reach 16 players will turn into those mystery envelopes. 

They are now playing hand-by-hand in the tournament as there's only one more player left before we hit the money. 
Player Chips Progress
Vilius Zabarauskas 500,000 500,000
Mark Metsla 0 0
Roberts Rumba 0 0
Alius Riskevicius 0 0
Josep Pastor De Ramon 0 0
Bjorne Lindberg Finally Arrives! Posted Tuesday 19th September, 2023 at 10:40(UTC+0) by Lina Olofsson

When today's game started Bjorne Lindberg from Sweden was the only player who wasn't in his seat of the 25 remaining but after 20 phone calls and someone running up and knocking on his door, he finally arrived at the tournament. Looking a little bit tired but at least he's here now since every single hand is important since it might make you bust another player and receive one of those mystery bounty checks with one worth an astonishing €10k. 
Big Pot And A Bounty Posted Tuesday 19th September, 2023 at 10:40(UTC+0) by Alaxandar Georgiev

Mark Metsla open-shoved from under the gun for 72,000 chips and it was followed by a call from Urmo Velvelt and a snap call from the bigger stacked Andrius Bielskis from the big blind.

Mark Metsa:
Urmo Velvelt:
Andrius Bielskis:

Velvelt was a favorite for the bounty with the other players blocking their outs on the flop. The Turn was which changed nothing for the player at risk and the river locked up the pot for the Estonian who won 145,000 chips from Bielskis and claimed 72,000 chips and a bounty from Metsla.
Player Chips Progress
Urmo Velvelt 362,000 243,000
Andrius Bielskis 139,000 145,000
Mark Metsla 0 0
10:25 (UTC+0)
Start of Level 18
Blinds: 4,000/8,000     Ante: 8,000
Sedlak Doubles Through Ramon, Ramon Out in 25th Posted Tuesday 19th September, 2023 at 10:24(UTC+0) by Lina Olofsson

Martin Sedlak started the day good with a nice little double up through Josep Pastor De Ramon leaving the later short in chips which went over the line the hand after and he was eliminated from the tournament as his wasn't holding up against Jarkko Suokas with . 
Player Chips Progress
Jarkko Suokas 395,000 36,000
Martin Sedlak 250,000 126,000
Josep Pastor De Ramon 0 0
Shuffle Up and Deal! Posted Tuesday 19th September, 2023 at 10:01(UTC+0) by Lina Olofsson

We have ten minutes left on the clock on level 17 with the blinds on 3,000/6,000 (6,000) and the first goal of the day is for the remaining players to first get down to the money which is the last 20 man standing. Then, when we reach the last two tables of 16 players in total we're moving everything over to the feature and secondary feature table and will have it all streamed. 

By then the blog will also be on delay for obvious reasons but you can still read all the interesting hands and other updates here in the blog of course. 
10:00 (UTC+0)
Start of Level 17
Blinds: 3,000/6,000     Ante: 6,000
€10K Top Mystery Bounty on the Line From the Start of Day 2 Posted Tuesday 19th September, 2023 at 09:09(UTC+0) by Lina Olofsson

The €660 No-Limit Hold'em Mystery Bounty Event starts off at noon with 25 players left in the field with 20 of them making it into the money. However, all the remaining players will be able to get one of the mysterious bounty envelopes one of which contains €10,000. 

25 players, 25 envelopes. For each player you bust out of the tournament you will get one bounty (one envelope) to open in each break of the tournament where you at least could get €1,200 added to your prize money but there's a wide range of what these mysterious envelopes contain so it will be really exciting seeing the players opening them during the day.

As soon as we reach the last 16 players we will move to the feature table and the secondary feature table with this tournament and you'll be able to watch it all live with our amazing commentators on your side. But first goal is to hit the money which means 20 players. 

Play resumes at 12 p.m. Stay tuned! 
02:31 (UTC+0)
Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.