0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0168 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event5/2/updates'
ORDER BY `views` DESC

0.0217 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event5/2/updates'

0.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0004 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0039 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event5'

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

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

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

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

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.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.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` = '5323'
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` = '5309'
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` = '5305'
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` = '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.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` = '5297'
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` = '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.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` = '5276'
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` = '5274'
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` = '5266'
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` = '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.0167 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5257'
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` = '5250'
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` = '5245'
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` = '5241'
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` = '5233'
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` = '5232'
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` = '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.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` = '5210'
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` = '5223'
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` = '5206'
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` = '5199'
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` = '5218'
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` = '5215'
ORDER BY `chip_change` DESC, `busted` ASC

0.0175 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5189'
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` = '5183'
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` = '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.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` = '5170'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0185 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5147'
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` = '5154'
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` = '5146'
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` = '5153'
ORDER BY `chip_change` DESC, `busted` ASC

0.0121 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.0119 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.0102 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5309'
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` = '5305'
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` = '5300'
ORDER BY `chip_change` DESC, `busted` ASC

0.0201 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5297'
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` = '5293'
ORDER BY `chip_change` DESC, `busted` ASC

0.0078 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5285'
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` = '5276'
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` = '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.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` = '5263'
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` = '5260'
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` = '5257'
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` = '5250'
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` = '5245'
ORDER BY `chip_change` DESC, `busted` ASC

0.0164 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5233'
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` = '5232'
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` = '5237'
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` = '5213'
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` = '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.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` = '5199'
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` = '5218'
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` = '5215'
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` = '5208'
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` = '5203'
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` = '5189'
ORDER BY `chip_change` DESC, `busted` ASC

0.0163 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5182'
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` = '5180'
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` = '5170'
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` = '5165'
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` = '5163'
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` = '5158'
ORDER BY `chip_change` DESC, `busted` ASC

0.0125 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5151'
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` = '5147'
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` = '5154'
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` = '5146'
ORDER BY `chip_change` DESC, `busted` ASC

0.0173 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0060 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

    

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

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(6)
  • APAT(1)
  • APPT(0)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(11)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(1)
  • EPT(2)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(70)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(0)
  • GUKPT Grosvenor(9)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • Kings of Tallinn(1)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Open(5)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(2)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

WSOPC Tallinn Event #5: €660 No-Limit Hold'em Mystery Bounty Live Reporting - Day 2

WSOPC Tallinn - Live Reporting

Event #5: €660 No-Limit Hold'em Mystery Bounty See other events

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)

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 10000

Entries 164 Remaining 1

---

Prize Pool (EUR) €94,464 First Prize (EUR) €10,000

Chip Leaders Day 2

1

Ranno Sootla

4,920,000

Day 1 Day 2

Live Updates Chip Counts Structure Gallery Payouts

SHARE

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

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter