0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event5'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0002 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.0062 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.0004 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.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '32'
0.0251 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '101'
AND `published` = 1
0.0251 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '123'
AND `published` = 1
0.0001 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '123'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '32'
AND `name` = '2'
0.0057 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.0051 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.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` = '5323'
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` = '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.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5203'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 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.0048 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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 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.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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.
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.
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 .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.