0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0081 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/135/updates'
ORDER BY `views` DESC
0.0209 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/33/135/updates'
0.0005 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '33'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1
0.0285 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1
0.0398 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1
0.0280 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` = '130'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '132'
AND `published` = 1
0.0278 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` = '135'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '138'
AND `published` = 1
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '135'
ORDER BY `busted` ASC, `current_chips` DESC
0.0071 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` = '135'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5975'
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` = '5955'
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` = '5952'
ORDER BY `chip_change` DESC, `busted` ASC
0.0118 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5941'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5946'
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` = '5932'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5943'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5929'
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` = '5940'
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` = '5923'
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` = '5921'
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` = '5925'
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` = '5914'
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` = '5915'
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` = '5909'
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` = '5903'
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` = '5910'
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` = '5907'
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` = '5906'
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` = '5894'
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` = '5892'
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` = '5897'
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` = '5887'
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` = '5884'
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` = '5879'
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` = '5878'
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` = '5875'
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` = '5873'
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` = '5871'
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` = '5870'
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` = '5867'
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` = '5863'
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` = '5860'
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` = '5857'
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` = '5854'
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` = '5849'
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` = '5846'
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` = '5844'
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` = '5843'
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` = '5839'
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` = '5835'
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` = '5833'
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` = '5832'
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` = '5829'
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` = '5828'
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` = '5827'
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` = '5826'
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` = '5825'
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` = '5822'
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` = '5819'
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` = '5818'
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` = '5814'
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` = '5812'
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` = '5804'
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` = '5802'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '135'
ORDER BY `busted` ASC, `current_chips` DESC
0.0056 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` = '135'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5975'
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` = '5955'
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` = '5952'
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` = '5941'
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` = '5946'
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` = '5932'
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` = '5943'
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` = '5929'
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` = '5940'
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` = '5923'
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` = '5921'
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` = '5925'
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` = '5914'
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` = '5915'
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` = '5909'
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` = '5903'
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` = '5910'
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` = '5907'
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` = '5906'
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` = '5894'
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` = '5892'
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` = '5897'
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` = '5887'
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` = '5884'
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` = '5879'
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` = '5878'
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` = '5875'
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` = '5873'
ORDER BY `chip_change` DESC, `busted` ASC
0.0110 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5871'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5870'
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` = '5867'
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` = '5863'
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` = '5860'
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` = '5857'
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` = '5854'
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` = '5849'
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` = '5846'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5844'
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` = '5843'
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` = '5839'
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` = '5835'
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` = '5833'
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` = '5832'
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` = '5829'
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` = '5828'
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` = '5827'
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` = '5826'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5825'
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` = '5824'
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` = '5822'
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` = '5819'
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` = '5818'
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` = '5814'
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` = '5812'
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` = '5805'
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` = '5804'
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` = '5802'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '138'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 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.
Many Thanks,
The MainEventTravel team
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
WSOPC Tallinn
Event #6: €1,500 WSOPC Tallinn Main Event
Live Reporting - Day 4
Akseli Paalanen Leads Final 9 in WSOPC Tallinn Main Event Posted Saturday 23rd September, 2023 at 19:51(UTC+0) by Jason Glatzer
The 2023 World Series of Poker Circuit (WSOPC) Tallinn Main Event has witnessed the field of 719 entries whittled down to just a final table of nine on the third and penultimate day at Olympic Park Casino and the Hilton Tallinn Park.
Finland's Akseli Paalanen (pictured above) was easily the star of the day by bagging more than double the average stack at the final table with 10,650,000 in chips good for a whopping 107 big blinds when the action resumes on Sunday at noon under the lights and cameras of the live stream at OlyBet.tv.
Paalanen began the day in second place with just 60 players remaining just behind Estonia's Hendrik Uibo and managed to stay at the top of the chip leaderboard throughout the day. With just 15 players left, Paalanen began to separate himself from the rest of the pack. He first doubled through another big stack at his table in Max Rotko.
"This is going to be a big pot," Rotko said after committing his tens against Paalanen's jacks.
Not only did Paalanen's jacks hold, but he won another big pot soon to send Pekka Ikonen out of the tournament in 10th place for €14,550 to end the day. Ikonen was in great shape after flopping the top set with jacks. However, Paalanen had ten-deuce suited and the chips went in on the turn after improving to a flush. Ikonen had outs to a full house or quads but he was instead out of chips after he bricked the river.
Final Table Seat Draw
Seat
Player
Country
Chips
Big Blinds
1
Emil Hovmark
Sweden
3,250,000
33
2
Artur Kulanurk
Estonia
4,550,000
46
3
Jesus Martinez Ucero
Spain
3,450,000
35
4
Jun Beum Chun
South Korea
6,875,000
69
5
Akseli Paalanen
Finland
10,650,000
107
6
Ignacio Gonzalez Garrido
Spain
2,200,000
22
7
Mario Linno
Estonia
1,175,000
12
8
Adria Comas I Roura
Spain
2,275,000
23
9
Mairo Tori
Estonia
1,500,000
15
While Paalanen is certainly in the captain's chair to commence the final table, he will still have plenty of other players equally eager to win the coveted WSOP gold ring, an invite to the $1 million guaranteed 2024 WSOP Tournament of Champions bracelet freeroll event, and the €211,500 top prize on tap for the last player standing.
Despite the gap, it is anyone's game with players from five different countries including one player from South Korea in Jun Beum Chun (6,875,000), and one player from Sweden in Emil Hovmark (3,250,000). The final table also boasts three players from the Spanish poker community living in Tallinn in Jesus Martinez Ucero (3,450,000), Adria Comas I Roura (2,275,000), and Ignacio Gonzalez Garrido (2,200,000).
Of course, the local community will have a chance to root on the home team. However, the two Estonians at the table have their work cut out for them coming in with the shortest stacks with Mairo Tomi ending Day 2 with 1,500,000 and Mario Linno with 1,175,000. Meanwhile, Estonia's Artur Kulanurk is in a bit of better shape as he will start in third place with 4,550,000.
Final Table Payouts
The final nine players each secured a minimum of a €17,700 payday on Sunday with the payouts going up quickly from there until the eventual winner collects a massive €211,500 top prize.
Check out all of the payouts below:
Place
Prize
1
€211,500
2
€137,250
3
€84,200
4
€64,100
5
€48,750
6
€34,150
7
€26,150
8
€21,550
9
€17,700
Cards will be in the air for the final table on Sunday at noon with our coverage beginning 30 minutes later to not give away spoilers for the stream. Be sure to tune back into OlyBet.tv for both the live stream hosted by Andreas Hoglund and George Sandford while also following along with our coverage of the biggest hands of the day.
Author: Jason Glatzer and Frank Visser Photos: Elena Kask and Tambet Kask
Final Table Seat Draw Posted Saturday 23rd September, 2023 at 16:44(UTC+0) by Jason Glatzer
1
Emil Hovmark
Sweden
3,250,000
33
2
Artur Kulanurk
Estonia
4,550,000
46
3
Jesus Martinez Ucero
Spain
3,450,000
35
4
Jun Beum Chun
South Korea
6,875,000
69
5
Akseli Paalanen
Finland
10,650,000
107
6
Ignacio Gonzalez Garrido
Spain
2,200,000
22
7
Mario Linno
Estonia
1,175,000
12
8
Adria Comas I Roura
Spain
2,275,000
23
9
Mairo Tori
Estonia
1,500,000
15
Player
Chips
Progress
Akseli Paalanen
10,650,000
150,000
Jun Beum Chun
6,875,000
75,000
Artur Kulanurk
4,550,000
1,875,000
Jesus Ucero
3,450,000
50,000
Emil Hovmark
3,250,000
50,000
Adria Comas I Roura
2,275,000
25,000
Ignacio Garrido
2,200,000
400,000
Mairo Tori
1,500,000
475,000
Mario Linno
1,175,000
250,000
Main Event Payouts Posted Saturday 23rd September, 2023 at 16:29(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€211,500
2
€137,250
3
€84,200
4
€64,100
5
€48,750
6
€34,150
7
€26,150
8
€21,550
9
€17,700
10
Pekka Ikonen
Finland
€14,550
11
Antti Eeva
Finland
€11,800
12
Max Rotko
Finland
€9,600
13
Jon Ander Martinez
Spain
€9,600
14
Hendrik Uibo
Estonia
€7,750
15
Anders Hansson
Sweden
€7,750
16
Martin Piik
Estonia
€6,000
17
Tomasz Mroz
Poland
€6,000
18
Andrius Bielskis
Lithuania
€6,000
19
Samuel Richards
United Kingdom
€6,000
20
Anna-Mari Hursti
Finland
€6,000
21
Henri Antkainen
Finland
€6,000
22
Maciej Komorowski
Poland
€6,000
23
Maruen Zormati
Finland
€6,000
24
Jimi Koponen
Finland
€5,250
25
Seppo Parkkinen
Finland
€5,250
26
Kevin Karinius
Finland
€5,250
27
David Asqino
Italy
€5,250
28
Vu Hoang Vuong
Finland
€5,250
29
Marko Harkonen
Finland
€5,250
30
Jari-Pekka Juhola
Finland
€5,250
31
Kyosti Isberg
Finland
€5,250
32
Kris Tikka
Finland
€4,750
33
Bartlomiej Kijak
Poland
€4,750
34
Hannes Praks
Estonia
€4,750
35
Deividas Butnoras
Lithuania
€4,750
36
Stanislavas Macugins
Latvia
€4,750
37
Ekrem Esker
Finland
€4,750
38
Steponas Venckus
Lithuania
€4,750
39
Karl Relander
Finland
€4,750
40
Aleksandr Arutjunov
Estonia
€4,250
41
Jose Larios Domene
Spain
€4,250
42
Remigijus Dzerva
Lithuania
€4,250
43
Luca Beretta
Italy
€4,250
44
Emanuele Mari
Italy
€4,250
45
Joni Rantamaki
Finland
€4,250
46
Adrians Imsa
Latvia
€4,250
47
Andzej Zinkevic
Lithuania
€4,250
48
Gilles Simon
Netherlands
€3,750
49
Amanullah Tahiri
Finland
€3,750
50
Juho Suutari
Finland
€3,750
51
Igor Yaroshevskyy
Ukraine
€3,750
52
Toms Civcs
Latvia
€3,750
53
Aigars Tuakacs
Latvia
€3,750
54
Alger Pissarev
Estonia
€3,750
55
Kasper Mellanen
Finland
€3,750
56
Youngseo Yoon
United Kingdom
€3,300
57
Urmo Velvelt
Estonia
€3,300
58
Sebastian Wahl
Finland
€3,300
59
Ermo Kosk
Estonia
€3,300
60
Tornike Tchitadze
Georgia
€3,300
61
Mauri Dorbek
Estonia
€3,300
62
Rasmus Sepping
Estonia
€3,300
63
Paulius Mikaliunas
Lithuania
€3,300
64
Tarmo Tammel
Estonia
€3,300
65
Andrey Koks
Estonia
€3,300
66
Kert Hallik
Estonia
€3,300
67
Priit Vallap
Estonia
€3,300
68
Tomi Hietala
Finland
€3,300
69
Jonatan Fors
Finland
€3,300
70
Karlis Kreslins
Latvia
€3,300
71
Mark Metsla
Estonia
€3,300
72
Egon Kaljulaid
Estonia
€3,050
73
Keito Kaljulaid
Estonia
€3,050
74
Priit Parmasto
Estonia
€3,050
75
Roope Holma
Finland
€3,050
76
Vidar Assersen
Norway
€3,050
77
Steven Seller
Estonia
€3,050
78
Peng Yi-Zhan
Taiwan
€3,050
79
Herli Olop
Estonia
€3,050
80
Sergei Aleksejev
Estonia
€3,050
81
Markuss Rukkalns
Latvia
€3,050
82
Mohammed Al-Khazraji
Finland
€3,050
83
Agnius Ismailovas
Lithuania
€3,050
84
Jon Kyte
Norway
€3,050
85
Kare Hallamaa
Finland
€3,050
86
Johan Martinsen
Finland
€3,050
87
Mikko Ylamaki
Finland
€3,050
Pekka Ikonen Eliminated in 10th Place (€14,550) Posted Saturday 23rd September, 2023 at 16:22(UTC+0) by Frank Visser
Level 27: 50,000/100,000 (100,000) Entries: 9/719
Akseli Paalanen open-raised from the cutoff and Pekka Ikonen defended his big blind.
The flop fanned out and Paalanen continuation-bet after a check from Ikonen. Ikonen flat-called and did so as well when another bet came from Paalanen on the turn.
The river then fell the and Ikonen checked again. This time, Paalanen went all-in covering his opponent by a significant margin. A quick call followed from Ikonen, and he tabled his when the other table finished their ongoing hand.
However, his flopped set of jacks was no good against the turned flush of Paalanen, who played . Ikonen disappeared from the table in disbelief, and play was then paused as only nine players remained, marking the end of Day 3 as the final table had been reached.
Player
Chips
Progress
Akseli Paalanen
10,800,000
3,850,000
Pekka Ikonen
0
0
Antti Eeva Eliminated in 11th Place (€11,800) Posted Saturday 23rd September, 2023 at 16:20(UTC+0) by Jason Glatzer
Emil Hovmark opened for 250,000 from the small blind. Antti Eeva jammed for 1.5 million from the big blind and Hovmark called.
Antti Eeva: Emil Hovmark:
Hovmark had Eeva covered by one chip and his king kicker came into play to eliminate Eeva in 11th place for €11,800 after the improved both players to the same two pair.
Player
Chips
Progress
Emil Hovmark
3,200,000
1,425,000
Antti Eeva
0
0
Max Rotko Eliminated in 12th Place (€9,600) Posted Saturday 23rd September, 2023 at 16:19(UTC+0) by Frank Visser
Jesus Ucero opened his button and Max Rotko put in his final three blinds from the big blind.
Max Rotko: Jesus Ucero:
Rotko sighed as he saw he was only drawing to three direct outs, and none of them came on the board. He took his exit in 12th place as the WSOPC Tallinn Main Event draws closer and closer to a final table.
Player
Chips
Progress
Jesus Ucero
3,500,000
825,000
Max Rotko
0
0
Martinez Correctly Folds Top Pair Posted Saturday 23rd September, 2023 at 16:11(UTC+0) by Jason Glatzer
The action folded to Anders Hansson (pictured) in the small blind, who raised to 300,000. Pekka Ikonen was in the big blind and thought his options over for a while before putting in calling chips.
The flop was then dealt and Hansson went all-in for an additional 900,000. Ikonen took a quick peek at his cards before calling and the two players tabled their hands
Anders Hansson: Pekka Ikonen:
Ikonen's top pair was in the lead but Hansson had plenty of outs with his open-ended straight draw. However, it would not arrive on the runout and Hansson would be the next player eliminated.
Player
Chips
Progress
Pekka Ikonen
3,600,000
1,660,000
Anders Hansson
0
0
Hendrik Uibo Eliminated in 15th Place (€7,750) Posted Saturday 23rd September, 2023 at 15:59(UTC+0) by Jason Glatzer
Ignacio Garrido opened for a min-raise before Hendrik Uibo three-bet jammed for 1.5 million. Jun Beum Chun four-bet shoved over the top for 5 million. Garrido went into the tank with before he folded.
Hendrik Uibo: Jun Beum Chun:
Uibo, who qualified for just €11 at OlyBet Poker had some hope on the as any club would improve him to a flush while a non-club deuce would give both players a wheel. However, he bricked both the turn and river to hit the rail in 13th place for €7,750.
Player
Chips
Progress
Jun Beum Chun
6,800,000
1,750,000
Hendrik Uibo
0
0
Break for Final 15 Posted Saturday 23rd September, 2023 at 15:35(UTC+0) by Frank Visser
The last 15 remaining players are sent on a 20-minute break while a chip race is undertaken by the tournament staff.
Player
Chips
Progress
Akseli Paalanen
6,930,000
3,705,000
Max Rotko
640,000
3,630,000
Paalanen Scores Huge Double-Up Posted Saturday 23rd September, 2023 at 15:24(UTC+0) by Frank Visser
Level 26: 40,000/80,000 (80,000) Entries: 15/719
The action folded to Akseli Paalanen in the cutoff, and he open-raised to 160,000. Max Rotko then responded with a three-bet to 640,000 from the small blind before Paalanen four-bet jammed his stack of 3,385,000 chips in the middle.
Rotko went into the tank for a bit before announcing a call, slightly covering his opponent.
Akseli Paalanen: Max Rotko:
"This is a big pot boys," Rotko exclaimed before the flop fell. Paalanen's higher pocket pair still had an overwhelming lead, and when no ten appeared on the runout, he scored a huge double-up.
Meanwhile, Rotko was left with only 640,000 chips, equating to eight big blinds.
Player
Chips
Progress
Akseli Paalanen
6,930,000
3,705,000
Max Rotko
640,000
3,630,000
Martin Piik Eliminated in 16th Place (€6,000) Posted Saturday 23rd September, 2023 at 15:22(UTC+0) by Jason Glatzer
Level 26: 40,000/80,000 (80,000) Entries: 15/719
In the past, Estonia's Martin Piik was one of the men behind the scenes at OlyBet Poker. He left this behind and has been crushing at the live and online tables ever since.
Unfortunately, we will not witness Piik win a Main Event ring this time around. He was the short-stack at the feature table when he jammed 530,000 from early position and was looked up by Ignacio Garrido.
Martin Piik: Ignacio Garrido:
Piik ran into the best preflop hand in poker. Piik had some hope after connecting with his queen on the flop but was on the rail in 16th place for €6,000 after the turn and river completed the board.
Player
Chips
Progress
Ignacio Garrido
1,850,000
665,000
Martin Piik
0
0
Hansson Can't Force a Fold Posted Saturday 23rd September, 2023 at 15:15(UTC+0) by Frank Visser
Level 26: 40,000/80,000 (80,000) Entries: 15/719
The action folded to Anders Hansson in the small blind, and he opted to limp in. Big blind Pekka Ikonen checked and the two saw a flop of .
Hansson fired a big bet of 200,000 chips, which was met with a call from Ikonen. The turn saw another bet from Hansson, this time for 400,000. Again, Ikonen did not have to think long before putting in a call.
The river then was quickly checked by both players, and Hansson shook his head before tabling for bottom pair.
Ikonen easily bested that with his for top pair and raked in the blind-on-blind pot.
Player
Chips
Progress
Pekka Ikonen
2,550,000
610,000
Anders Hansson
1,650,000
735,000
14:53 (UTC+0)
Start of Level 26 Blinds: 40,000/80,000 Ante: 80,000
Mroz Eliminated as Final Player before Two Table Redraw Posted Saturday 23rd September, 2023 at 14:40(UTC+0) by Frank Visser
Level 26: 40,000/80,000 (80,000) Entries: 16/719
Jon Ander Martinez opened the action with a raise from the hijack before Tomasz Mroz shipped in 900,000 chips from the small blind for an all-in bet.
Martinez quickly called to put Mroz at risk and a showdown was had.
Tomasz Mroz: Jon Ander Martinez:
Mroz already stood up when the flop fell , and his gut feeling turned out to be correct when the board completed with the turn and river.
He left the tournament area while the remaining 16 players are taking a small break as they will redraw for the final two tables.
Player
Chips
Progress
Jon Ander Martinez
2,050,000
1,150,000
Tomasz Mroz
0
0
Bielskis Bows Out Posted Saturday 23rd September, 2023 at 14:31(UTC+0) by Frank Visser
Level 26: 30,000/60,000 (60,000) Entries: 17/719
Max Rotko open-raised from the hijack and Andrius Bielskis (pictured) three-bet jammed his 550,000 stack from the button. The action folded back to Rotko, who called with the covering stack.
Andrius Bielskis: Max Rotko:
It was a classic flip, which would fall in Rotko's favor when only undercards appeared on the board, resulting in Bielskis' elimination from the tournament.
Player
Chips
Progress
Max Rotko
3,800,000
1,150,000
Andrius Bielskis
0
0
Linno Takes Out Richards Posted Saturday 23rd September, 2023 at 14:30(UTC+0) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 18/719
Samuel Richards jammed from early position and was called by Mario Linno from the blinds.
Samuel Richards: Mario Linno:
For the second time in a row at the feature table, Linno eliminated a player, this time Richards went out in 19th place after Linno improved to a better full house on the board.
Player
Chips
Progress
Mario Linno
2,300,000
700,000
Samuel Richards
0
0
Hursti Loses Flip to Linno Posted Saturday 23rd September, 2023 at 14:24(UTC+0) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 19/719
Mario Linno jammed the button for 765,000. Anna-Mari Hursti called off for slightly less and both players were more or less flipping for their tournament lives.
Anna-Mari Hursti: Mario Linno:
Hursti nailed top pair on the but despite that was far behind Linno's flopped set of sixes. There was thin hope for Hursti after improving to two pair on the turn with four outs to a boat. However, the blank river completed the board and Hurst was eliminated in 19th place.
Player
Chips
Progress
Mario Linno
1,600,000
905,000
Anna-Mari Hursti
0
0
Kicker Issues for Antikainen Posted Saturday 23rd September, 2023 at 14:18(UTC+0) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 20/719
Henri Antikainen jammed at the feature table for 790,000 from the button and was called by Pekka Ikonen.
Henri Antikainen: Pekka Ikonen:
Both players hit two pair on the flop. Antikainen had some kicker issues that weren't resolved on either the turn or river to hit the rail in 21st place.
Player
Chips
Progress
Pekka Ikonen
3,700,000
1,975,000
Henri Antikainen
0
0
Martinez Cracks Komorowski's Rockets Posted Saturday 23rd September, 2023 at 14:10(UTC+0) by Frank Visser
Level 26: 30,000/60,000 (60,000) Entries: 21/719
Maciej Komorowski was left short-stacked after a previous bluff attempt failed. He then got his remaining 300,000 or so chips in from the small blind, and Jon Ander Martinez made the call from the big blind.
Maciej Komorowski: Jon Ander Martinez:
Komorowski immediately saw his aces being cracked when Martinez flopped a straight on , bu the brought some outs. However, the river blanked and Komorowski was seen leaving the tournament area with a grimace on his face.
Player
Chips
Progress
Jon Ander Martinez
900,000
170,000
Maciej Komorowski
0
0
Zormati Flips to His Demise Posted Saturday 23rd September, 2023 at 14:09(UTC+0) by Frank Visser
Level 26: 30,000/60,000 (60,000) Entries: 22/719
Maruen Zormatti was all-in for his final 600,000 chips and he was looked up by Antti Eeva with the covering stack.
Maruen Zormatti: Anti Eeva:
Eeva flopped a set on and left his opponent drawing dead on the turn. Zormatti said his goodbyes as the river completed the board and left to collect his winnings.
Player
Chips
Progress
Antti Eeva
1,550,000
560,000
Maruen Zormati
0
0
13:56 (UTC+0)
Start of Level 25 Blinds: 30,000/60,000 Ante: 60,000
Koponen First to Leave Final Three Tables Posted Saturday 23rd September, 2023 at 13:55(UTC+0) by Frank Visser
Level 25: 25,000/50,000 (50,000) Entries: 23/719
Max Rotko raised from early position and the short-stacked Jimi Koponen three-bet all-in from the big blind. Rotko put in the extra chips and the cards were tabled.
Jimi Koponen: Max Rotko:
The board ran out and Rotko's pair of eights would win him the pot and eliminate Koponen in 24th place.
Player
Chips
Progress
Max Rotko
2,650,000
205,000
Jimi Koponen
0
0
Hovmark Flips and Doubles Posted Saturday 23rd September, 2023 at 13:51(UTC+0) by Frank Visser
Level 25: 25,000/50,000 (50,000) Entries: 24/719
Emil Hovmark and Andrius Bielskis had an all-in confrontation preflop, with Hovmark's 840,000 stack being at risk.
Emil Hovmark: Andrius Bielskis:
Hovmark would win the flip when the board gave him two aces on and he raked in a nice double-up
Player
Chips
Progress
Emil Hovmark
1,780,000
660,000
Andrius Bielskis
715,000
855,000
Reports on 30-Minute Delay Posted Saturday 23rd September, 2023 at 13:12(UTC+0) by Jason Glatzer
In order not to give away any spoilers for those watching the stream, our reporting will be on the same 30-minute delay until a winner is crowned tomorrow.
Bielskis Books a Three-Way Victory Posted Saturday 23rd September, 2023 at 13:11(UTC+0) by Frank Visser
Level 25: 25,000/50,000 (50,000) Entries: 24/719
Max Rotko raised to 100,000 from the hijack and received calls from Andrius Bielskis (pictured below) on the button and Jimi Koponen in the big blind.
The flop of checked through before the action checked to Bielskis once more on the turn. This time, he bet for 130,000 and that was enough to let both of his opponents forfeit their hands.
Player
Chips
Progress
Andrius Bielskis
1,580,000
340,000
Max Rotko
1,375,000
970,000
Jimi Koponen
800,000
220,000
Final Three Table Seat Draw Posted Saturday 23rd September, 2023 at 13:04(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
1
1
Samuel Richards
1,150,000
23
1
2
Henri Antikainen
1,160,000
23
1
3
Pekka Ikonen
1,725,000
35
1
4
Mario Linno
695,000
14
1
5
Anna-Mari Hursti
800,000
16
1
6
Hendrik Uibo
3,870,000
77
1
7
Adria Comas I Roura
1,135,000
23
1
8
Tori Mairo
1,790,000
36
2
1
Maruen Zormati
1,175,000
24
2
2
Emil Hovmark
1,120,000
22
2
3
Max Rotko
1,475,000
30
2
4
Jesus Ucero
2,415,000
48
2
5
Andrius Bielskis
1,230,000
25
2
6
Antti Eeva
990,000
20
2
7
Jimi Koponen
950,000
19
2
8
Akseli Paalanen
3,350,000
67
3
1
Artur Kulanurk
2,295,000
46
3
2
Anders Hansson
1,610,000
32
3
3
Tomasz Mroz
1,500,000
30
3
4
Martin Piik
590,000
12
3
5
Jun Beum Chun
1,200,000
24
3
6
Ignacio Garrido
2,220,000
44
3
7
Maciej Komorowski
435,000
9
3
8
Jon Ander Martinez
1,070,000
21
Action Resumed Posted Saturday 23rd September, 2023 at 13:03(UTC+0) by Frank Visser
All players have taken their seats and play is now back underway.
A Small Break; Live Report on Delay Posted Saturday 23rd September, 2023 at 12:53(UTC+0) by Frank Visser
The final 24 players are now enjoying a small break while everything is being made ready for the live stream.
In order to not spoil the stream, the live report will also operate with a 30-minute delay from now on.
Parkkinen Eliminated; Final Three Tables Reached Posted Saturday 23rd September, 2023 at 12:50(UTC+0) by Frank Visser
Level 25: 25,000/50,000 (50,000) Entries: 24/719
Jun Beum Chun raised to 100,000 from the cutoff and the short-stacked Seppo Parkkinen called all-in for less than that from the button. The blinds folded and the two players showed down.
Seppo Parkkinen: Jun Beum Chun:
Parkkinen flopped a set on and Chun was left to a runner-runner runout to still win the pot. Miraculously enough, it came in when the turn and river gave him a better full house than Parkkinen.
Parkkinen left the tournament area dejected while the 24 remaining players headed to the TV area to converge into three final tables.
Player
Chips
Progress
Jun Beum Chun
0
25,000
Seppo Parkkinen
0
0
Rapid-Fire Eliminations Continue Posted Saturday 23rd September, 2023 at 12:36(UTC+0) by Frank Visser
Level 25: 25,000/50,000 (50,000) Entries: 25/719
Vu Hoang Vuong (pictured below) open-jammed for 415,000 chips from the hijack and Andrius Bielskis asked for a count from the small blind. After receiving the correct amount, he made the call with the covering stack.
Vu Hoang Vuong: Andrius Bielskis:
Bielskis flopped a set on but Vuong still had hope with his flopped gutshot. However, the turn upgraded Bielskis to a full house and thus sealed Vuong's fate. He said his goodbyes as the meaningless river was dealt out.
On another table, Kevin Karenius had all of his chips in the middle and Ignacio Garrido was trying to score another knock-out. The board read , and Garrido's outkicked Karenius' for another elimination.
On yet another table, David Asqino was also eliminated in an unwitnessed hand.
Only 25 players now remain in contention for the WSOPC Tallinn Main Event title.
Player
Chips
Progress
Ignacio Garrido
1,825,000
425,000
Andrius Bielskis
1,240,000
430,000
Kevin Karenius
0
0
Vu Hoang Vuong
0
0
12:24 (UTC+0)
Start of Level 24 Blinds: 20,000/50,000 Ante: 50,000
First Break of the Day Posted Saturday 23rd September, 2023 at 12:04(UTC+0) by Frank Visser
The remaining 28 players are now sent on a 20-minute break. Just before the break, three more players were eliminated from the WSOPC Tallinn Main Event.
Player
Chips
Progress
Marko Harkonen
0
0
Jari-Pekka Juhola
0
0
Kyosti Isberg
0
0
Players Cashing for €4,750 Posted Saturday 23rd September, 2023 at 11:59(UTC+0) by Jason Glatzer
The following players cashed for €4,750 in the Main Event. The final 31 players each locked up at least a €5,250 payout.
Place
Player
Prize
32
Kris Tikka
€4,750
33
Bartlomiej Kijak
€4,750
34
Hannes Praks
€4,750
35
Deividas Butnoras
€4,750
36
Stanislavas Macugins
€4,750
37
Ekrem Esker
€4,750
38
Steponas Venckus (below)
€4,750
39
Karl Relander
€4,750
Kijak Last to Leave Before Final Four Tables Posted Saturday 23rd September, 2023 at 11:50(UTC+0) by Frank Visser
Level 24: 20,000/40,000 (40,000) Entries: 31/719
Akseli Paalanen raised to 80,000 from the cutoff and the action folded to Bartlomiej Kijak in the big blind. He then announced his all-in and Paalanen asked for a count.
The total amounted to 865,000 and after taking a quick glance at the clock, Paalanen made the call to put his opponent at risk.
Bartlomiej Kijak: Akseli Paalanen:
Paalanen held the superior pair and thus was in great shape to score an elimination. No six arrived on the board, and the final 31 players converged onto four tables while Kijak left to collect his payout.
Player
Chips
Progress
Akseli Paalanen
2,925,000
1,625,000
Bartlomiej Kijak
0
0
Garrido Gets More Chips by Eliminating Relander Posted Saturday 23rd September, 2023 at 11:36(UTC+0) by Frank Visser
Level 24: 20,000/40,000 (40,000) Entries: 35/719
When the action was caught, all of Karl Relander's 550,000 chips already went into the 250,000 chip pot in the middle on a board of . Ignacio Garrido was on the other end of the action with the covering stack and the two were ordered to show down.
Karl Relander: Ignacio Garrido:
Relander was already drawing dead and complimented his opponent's hand while the inconsequential river completed the board. He joined the many players who have been eliminated in the early levels of Day 3 so far.
Player
Chips
Progress
Ignacio Garrido
2,250,000
1,600,000
Karl Relander
0
0
Payouts for €4,250 Posted Saturday 23rd September, 2023 at 11:30(UTC+0) by Jason Glatzer
The following players cashed for €4,250 with the remaining 39 players locking up at least €4,750.
Place
Player
Prize
40
Aleksandr Arutjunov (below)
€4,250
41
Jose Larios Domene
€4,250
42
Remigijus Dzerva
€4,250
43
Luca Beretta
€4,250
44
Emanuele Mari
€4,250
45
Joni Rantamaki
€4,250
46
Adrians Imsa
€4,250
47
Andzej Zinkevic
€4,250
Player
Chips
Progress
Andzej Zinkevic
0
0
Adrians Imsa
0
0
Joni Rantamaki
0
0
Emanuele Mari
0
0
Luca Beretta
0
0
Jose Larios Domene
0
0
Aleksandr Arutjunov
0
0
11:22 (UTC+0)
Start of Level 23 Blinds: 20,000/40,000 Ante: 40,000
Dzerva Downed by Chun Posted Saturday 23rd September, 2023 at 11:22(UTC+0) by Frank Visser
Level 23: 15,000/30,000 (30,000) Entries: 41/719
Jun Beum Chun raised to 60,000 from the hijack and subsequently faced an all-in for 295,000 from Remigijus Dzerva. Chun mulled it over for a while before asking for a count and making the call not long thereafter, putting Dzerva at risk.
Remigijus Dzerva: Jun Beum Chun:
It was looking good for Dzerva, who was holding the superior ace, but the flop saw Chun shoot in the lead. Neither the turn or river did anything to change that, and Dzerva was eliminated just before the final five tables.
Player
Chips
Progress
Jun Beum Chun
1,025,000
425,000
Remigijus Dzerva
0
0
Zinkevic's Kings Cracked by Big Blind Special Posted Saturday 23rd September, 2023 at 11:07(UTC+0) by Frank Visser
Level 23: 15,000/30,000 (30,000) Entries: 45/719
Andzej Zinkevic was sitting on a stack of 275,000 chips when he raised to 75,000 from early position. The action folded to David Asqino in the big blind, who made the call.
The flop then fell and Zinkevic put in the rest of his chips after a check from Asqino. No time passed before the latter made the call and both players' cards were tabled.
Andzej Zinkevic: David Asqino:
Zinkevic could not believe his eyes when he saw that his opponent flopped two pair. The board brought him no help on the runout and Zinkevic had no other option than to leave the tournament area, while Asqino raked in the pot.
Player
Chips
Progress
David Asqino
715,000
130,000
Andzej Zinkevic
0
0
Players Cashing for €3,750 Posted Saturday 23rd September, 2023 at 10:59(UTC+0) by Jason Glatzer
The following players cashed for €3,750 in the Main Event. The final 47 players each locked up another €500 as they are now guaranteed at least a €4,250 payout.
Place
Player
Prize
48
Gilles Simon
€3,750
49
Amanullah Tahiri
€3,750
50
Juho Suutari
€3,750
51
Igor Yaroshevskyy
€3,750
52
Toms Civcs
€3,750
53
Aigars Tuakacs
€3,750
54
Alger Pissarev
€3,750
55
Kasper Mellanen
€3,750
Simon Bluffs It Off Posted Saturday 23rd September, 2023 at 10:56(UTC+0) by Frank Visser
Level 22: 10,000/25,000 (25,000) Entries: 47/719
On a completed board of , a pot of roughly 400,000 chips had gathered when Jesus Ucero checked from the big blind. Gilles Simon was sitting under the gun and decided to go all-in for 250,000.
An instantaneous call followed from the Spaniard and Simon knocked the table while he showed his for just ace-high. Ucero then showed his for two pair and sent the Dutchman home early on Day 3.
Player
Chips
Progress
Jesus Ucero
1,700,000
600,000
Gilles Simon
0
0
Koponen Doubles With Big Slick Posted Saturday 23rd September, 2023 at 10:54(UTC+0) by Jason Glatzer
Level 22: 15,000/30,000 (30,000) Entries: 48/719
Jun Beum Chun opened for a min-raise from middle position. Maruen Zormati called from the small blind before Jimi Koponen three-bet jammed for 230,000 from the big blind. Chun tanked for a few moments before he folded, while Zormati found a snap-call.
Jimi Koponen: Maruen Zormati:
Koponen's big slick remained ahead on the board to double his short stack through Zormati.
Player
Chips
Progress
Maruen Zormati
1,500,000
635,000
Jun Beum Chun
600,000
155,000
Jimi Koponen
580,000
100,000
Igor Yaroshevskyy
0
0
Juho Suutari
0
0
Amanullah Tahiri
0
0
10:43 (UTC+0)
Start of Level 22 Blinds: 15,000/30,000 Ante: 30,000
Eeva Doubles Up in Preflop Clash Posted Saturday 23rd September, 2023 at 10:43(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 50/719
Emil Hovmark and Antti Eeva got all of their chips in preflop from the hijack and button respectively. Eeva was the at-risk player with a stack of 250,000 chips.
Antti Eeva: Emil Hovmark:
It was a sweaty board for Eeva's aces as he saw his opponent turn a flush draw on . However, the river gave him a full house and he cheerfully wiped the sweat off his brow.
Hovmark, meanwhile, was left very short with only 80,000 chips left to play with.
Player
Chips
Progress
Antti Eeva
560,000
420,000
Emil Hovmark
80,000
475,000
Players Cashing for €3,300 Posted Saturday 23rd September, 2023 at 10:41(UTC+0) by Jason Glatzer
The following players banked €3,300 in the Main Event with the remaining field of 55 players locking up at least €3,750.
Place
Player
Prize
56
Youngseo Yoon (photo below)
€3,300
57
Urmo Velvelt
€3,300
58
Sebastian Wahl
€3,300
59
Ermo Kosk
€3,300
60
Tornike Tchitadze
€3,300
61
Mauri Dorbek
€3,300
62
Rasmus Sepping
€3,300
63
Paulius Mikaliunas
€3,300
64
Tarmo Tammel
€3,300
65
Andrey Koks
€3,300
66
Kert Hallik
€3,300
67
Priit Vallap
€3,300
68
Tomi Hietala
€3,300
69
Jonatan Fors
€3,300
70
Karlis Kreslins
€3,300
71
Mark Metsla
€3,300
Recent Eliminations Posted Saturday 23rd September, 2023 at 10:35(UTC+0) by Jason Glatzer
Player
Chips
Progress
Alger Pissarev
0
0
Sebastian Wahl
0
0
Youngseo Yoon
0
0
Kasper Mellanen
0
0
Aigars Taukacs
0
0
Toms Civcs
0
0
Mellanen Shoves Into Trips Posted Saturday 23rd September, 2023 at 10:34(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 54/719
Kasper Mellanen and Artur Kulanurk were heads up on a completed board of . Mellanen was seen shoving his last chips in the middle and received a quick call from his opponent.
Mellanen could only show for a bluff while Kulanurk tabled for a comfortable call with turned trips, resulting in the elimination of Mellanen.
Player
Chips
Progress
Artur Kulanurk
1,625,000
540,000
Kasper Mellanen
0
0
Esker Doubles Through Mari Posted Saturday 23rd September, 2023 at 10:27(UTC+0) by Jason Glatzer
Level 21: 10,000/25,000 (25,000) Entries: 55/719
Ekrem Esker just got some chips back from Emanuele Mari and gained some breathing room.
Mari opened for 55,000 from early position before Ekrem Esker three-bet shoved for 225,000 from the hijack. Mari called and Esker was flipping for his tournament life.
Ekrem Esker: Emanuele Mari:
Esker pulled ahead straight out of the gate after his queen connected on the flop. Neither the turn nor the river changed the outcome for Esker to double through Mari.
Player
Chips
Progress
Emanuele Mari
1,200,000
75,000
Ekrem Esker
610,000
295,000
Trip Jacks for Mari Posted Saturday 23rd September, 2023 at 10:16(UTC+0) by Jason Glatzer
Level 21: 10,000/25,000 (25,000) Entries: 58/719
Emanuele Mari fired out 225,000 into a pot of a bit more with the on the board when Ekrem Esker went into the tank.
"How much do you have?" asked Esker.
Rather than just showing the chips, Mari counted his stack and shared it was 350,000 left behind. Esker tanked for a couple more minutes before he called.
Mari turned over the for trip jacks and won the hand after Atush mucked his cards.
Meanwhile, local hero Ermo Kosk hit the rail around the same time in 59th place.
Player
Chips
Progress
Emanuele Mari
1,275,000
480,000
Ekrem Atush
315,000
465,000
Ermo Kosk
0
0
Tchitadze One of the First to Leave on Day 3 Posted Saturday 23rd September, 2023 at 10:13(UTC+0) by Frank Visser
Level 21: 10,000/25,000 (25,000) Entries: 59/719
The board read when small blind Andrius Bielskis checked to Tornike Tchitadze in the big blind. Tchitadze then bet out 75,000 into the pot of 225,000 and Bielskis made the call.
The river of completed the board and this time Tchitadze went all-in for his final 200,000 or so chips after another check from Bielskis. The latter then snap-called and Tchitadze tried to muck his cards but was forced to show his failed bluff with .
Meanwhile, Bielskis made the comfortable call with for turned trips, and increased his stack to an above-average one.
Player
Chips
Progress
Andrius Bielskis
810,000
305,000
Tornike Tchitadze
0
0
Cards in the Air Posted Saturday 23rd September, 2023 at 10:02(UTC+0) by Jason Glatzer
Level 21: 10,000/25,000 (25,000) Entries: 60/719
Cards are in the air to start Day 2. Best of luck to the final 60 players!
Day 3 Begins at Noon Posted Saturday 23rd September, 2023 at 08:36(UTC+0) by Jason Glatzer
Welcome back to what promises to be an exciting day with the €1 million guaranteed Event #6: WSOPC Tallinn €1,500 Main Event reaching its penultimate day.
The action kicks off at noon with 60 hopefuls from the original field of 719 entries, each locking up €3,300 for a slight increase over the €3,050 the top 87 players were guaranteed as a min-cash. They will be playing for much more today as the action will continue until a final table of nine players remains with €17,700 secured along with hopes alive for the gold ring, the invite to the $1 million guaranteed Tournament of Champions bracelet event freeroll, and the massive €211,500 top prize.
Estonia's Hendrik Uibo (pictured above) kicks off Day 3 with a chip-leading stack of 1,765,000, good for 71 big blinds with blinds starting off at 10,000/25,000 along with a 25,000 big blind ante. The Finnish duo of Akseli Paalanen and Marko Harkonen are just behind Uibo with Luca Beretta and Vu Hoang Vuong rounding out the top five.
Start of Day 3 Top 10 Leaderboard
Place
Name
Chips
Big Blinds
1
Hendrik Uibo
1,765,000
71
2
Akseli Paalanen
1,300,000
52
3
Marko Harkonen
1,205,000
48
4
Luca Beretta
1,155,000
46
5
Vu Hoang Vuong
1,135,000
45
6
Jesus Ucero
1,100,000
44
7
Artur Kulanurk
1,085,000
43
8
Seppo Parkkinen
1,015,000
41
9
Mario Linno
980,000
39
10
Jon Ander Martinez
915,000
37
Our coverage begins when cards are in the air at 12 p.m. with today also featuring a live stream at OlyBet.tv commentated by George Sandford and Andreas Hoglund. Stay tuned to see who the final nine players will be!
Day 3 Seat Draw Posted Friday 22nd September, 2023 at 20:07(UTC+0) by Jason Glatzer
Table
Seat
Name
Chips
Big Blinds
11
1
Marko Harkonen
1,205,000
48
11
2
Urmo Velvelt
535,000
21
11
3
Kyosti Isberg
880,000
35
11
4
Anders Hansson
855,000
34
11
5
Hendrik Uibo
1,765,000
71
11
6
Maciej Komorowski
595,000
24
11
7
Ermo Kosk
430,000
17
11
8
Max Rotko
405,000
16
12
1
Igor Yaroshevskyy
315,000
13
12
2
Emil Hovmark
555,000
22
12
3
Adria Comas I Roura
210,000
8
12
4
Aigars Taukacs
385,000
15
12
5
Kris Tikka
380,000
15
12
6
Juho Suutari
320,000
13
12
7
Deividas Butnoras
470,000
19
12
8
Luca Beretta
1,155,000
46
13
1
Jimi Koponen
480,000
19
13
2
Bartlomiej Kijak
910,000
36
13
3
Seppo Parkkinen
1,015,000
41
13
4
David Asqino
585,000
23
13
5
Hannes Praks
400,000
16
13
6
Andzej Zinkevic
640,000
26
13
7
Andrius Bielskis
505,000
20
13
8
Tornike Tchitadze
455,000
18
14
1
Remigijus Dzerva
410,000
16
14
2
Mairo Tori
450,000
18
14
3
Tomasz Mroz
605,000
24
14
4
Artur Kulanurk
1,085,000
43
14
5
Kevin Karenius
280,000
11
14
6
Henri Antikainen
505,000
20
14
7
Pekka Ikonen
780,000
31
14
8
Amanullah Tahiri
175,000
7
18
1
Ignacio Garrido
650,000
26
18
2
Adrians Imsa
465,000
19
18
3
Karl Relander
135,000
5
18
4
Jesus Ucero
1,100,000
44
18
5
Gilles Simon
405,000
16
18
6
Sebastian Wahl
305,000
12
18
8
Martin Piik
215,000
9
19
1
Ekrem Atush
780,000
31
19
2
Samuel Richards
340,000
14
19
3
Jose Larios Domene
355,000
14
19
4
Youngseo Yoon
220,000
9
19
5
Joni Rantamaki
375,000
15
19
6
Vu Hoang Vuong
1,135,000
45
19
7
Emanuele Mari
795,000
32
20
1
Stanislavas Macugins
595,000
24
20
2
Aleksandr Arutjunov
565,000
23
20
4
Antti Eeva
140,000
6
20
5
Mario Linno
980,000
39
20
6
Jun Beum Chun
445,000
18
20
7
Anna-Mari Hursti
395,000
16
20
8
Jari-Pekka Juhola
655,000
26
21
1
Toms Civcs
330,000
13
21
3
Steponas Venckus
350,000
14
21
4
Alger Pissarev
490,000
20
21
5
Kasper Mellanen
315,000
13
21
6
Jon Ander Martinez
915,000
37
21
7
Akseli Paalanen
1,300,000
52
21
8
Maruen Zormati
865,000
35
20:06 (UTC+0)
Day 3 of WSOPC Tallinn Started Level: 21 Blinds: 10,000/25,000 Ante: 25,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.
and Paalanen continuation-bet after a check from Ikonen. Ikonen flat-called and did so as well when another bet came from Paalanen on the 
turn. 
and Ikonen checked again. This time, Paalanen went all-in covering his opponent by a significant margin. A quick call followed from Ikonen, and he tabled his 
when the other table finished their ongoing hand.
. Ikonen disappeared from the table in disbelief, and play was then paused as only nine players remained, marking the end of Day 3 as the final table had been reached.
board. He took his exit in 12th place as the WSOPC Tallinn Main Event draws closer and closer to a final table.
defended his big blind.
flop paired up both players' queens with Martinez with some obvious kicker issues. Garrido continued for 150,000 and Martinez check-called.
as any club would improve him to a flush while a non-club deuce would give both players a wheel. However, he bricked both the 
turn and 
river to hit the rail in 13th place for €7,750.
runout, he scored a huge double-up.
flop but was on the rail in 16th place for €6,000 after the 
turn and 
river completed the board.
for bottom pair.
and Rotko's pair of eights would win him the pot and eliminate Koponen in 24th place.
for a bluff while Kulanurk tabled 
