0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0073 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/29/116/updates'
ORDER BY `views` DESC
0.0004 SECONDS: SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `tour_stop_blogs`.`id` = '29'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '29'
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '99'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '116'
AND `published` = 1
0.0066 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '116'
ORDER BY `busted` ASC, `current_chips` DESC
0.0072 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` = '116'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '4957'
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` = '4935'
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` = '4933'
ORDER BY `chip_change` DESC, `busted` ASC
0.0090 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4931'
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` = '4929'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4927'
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` = '4925'
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` = '4922'
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` = '4920'
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` = '4917'
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` = '4915'
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` = '4913'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4914'
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` = '4909'
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` = '4907'
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` = '4903'
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` = '4897'
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` = '4894'
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` = '4895'
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` = '4891'
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` = '4889'
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` = '4886'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4880'
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` = '4879'
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` = '4877'
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` = '4875'
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` = '4871'
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` = '4867'
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` = '4866'
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` = '4859'
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` = '4855'
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` = '4853'
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` = '4849'
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` = '4845'
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` = '4844'
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` = '4840'
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` = '4837'
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` = '4833'
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` = '4842'
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` = '4828'
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` = '4817'
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` = '4816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '116'
ORDER BY `busted` ASC, `current_chips` DESC
0.0058 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` = '116'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4957'
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` = '4935'
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` = '4933'
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` = '4931'
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` = '4929'
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` = '4927'
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` = '4925'
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` = '4922'
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` = '4920'
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` = '4917'
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` = '4915'
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` = '4913'
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` = '4914'
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` = '4909'
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` = '4907'
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` = '4903'
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` = '4897'
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` = '4894'
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` = '4895'
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` = '4891'
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` = '4889'
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` = '4886'
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` = '4880'
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` = '4879'
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` = '4877'
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` = '4875'
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` = '4871'
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` = '4867'
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` = '4866'
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` = '4859'
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` = '4855'
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` = '4853'
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` = '4849'
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` = '4845'
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` = '4844'
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` = '4840'
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` = '4837'
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` = '4833'
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` = '4842'
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` = '4828'
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` = '4817'
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` = '4816'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '116'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 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 #2: €1,100 No-Limit Hold'em
Live Reporting - Day 2
Aleksei Smirnov Wins Event #2: €1,100 No-Limit Hold'em (€25,430) Posted Sunday 17th September, 2023 at 19:19(UTC+0) by Lina Olofsson
The second WSOPC Tallinn ring stays at home with Estonia's Aleksei Smirnov winning the coveted gold ring along with the €25,430 top prize. Going into Sunday's final table, it surely looked like the possibility of having a Finn crowned as the champion in the second event of WSOPC Tallinn Event #1: €1,100 No-Limit Hold'em was in the air. "The Terminator" Aki Pyysing finished the first day of play with more than the double amount of chips as Josh Stewart from Northern Ireland in second place.
But in the game of poker, it’s always a chip and a chair as we’ve seen examples of plenty of times in this tournament already but it was safe to say that Pyysing was the most comfortable one to take his seat as the game began at 1 p.m. this afternoon.
The nine players didn’t waste any time to give us plenty of action on the table and not even half an hour into the final table we saw Brazilian Manoel Filho eliminated in ninth place for €3,050 after running into Pyysing’s pocket rockets (aces) with his king-jack as short stack.
In the blink of an eye, another one bites the dust, and this time it was Estonian player Tanel Evert whose king-eight was in good shape against Santtu Leinonen’s nine-eight but a flopped nine for the Finn, and Evert was sent to the rail picking up his winner check of €3,750 for finishing eight place.
Not many hands went by until Polish player Dominik Ostrowski had to join the other two at the rail as his king-five wasn’t good enough to stand up against Aleksei Smirnov’s queen-jack which paired on the flop for a seventh-place finish for Ostrowski worth €4,900.
With these remaining six, Pyysing was still holding the fort but Josh Stewart started climbing the ladder and was looking like a strong contestant to take down the title. Someone who wasn’t as lucky was Norwegian player Vidar Assersen who lost almost all of his chips to Steponas Venckus and the hand after pushing the remains of his stack in with seven-eight under the gun but couldn’t find any luck against Aleksei Smirnov’s ace-queen. For his sixth place, Assersen walks away with €5,950.
Going on their first break after two levels and the remaining nine minutes left on the clock from yesterday we had already lost three players and Steponas Venckus had to get something going as he had become the short stack on the table. He didn’t wait long until he looked down on ace-deuce from the big blind and decided to push them all in after a raise under the gun by Aki Pyysing. Pyysing holding pocket sevens was in good shape to terminate another player from the tournament and when the board ran out dry we sent off Steponas Venckus with €7,400 for his fifth-place finish.
It was just about after that hand the dynamic started to change on the table. Pyysing's massive advantage in chips started to change as some of the other players gained some chips. Later on, he lost a huge pot against Aleksei Smirnov when doubling him up in a classic coin flip and all of a sudden we had a new name at the top of the leaderboard.
The five players were then moved onto the main feature table after Event #1 €555 No-Limit Hold'em concluded. Sadly for United Kingdom's Josh Stewart, this experience didn’t last long as his king-jack didn’t hold up against Smirnov’s pocket fives and he was out on fourth place for €9,650.
Then, after losing a big part of his stack to his fellow countryman Santtu Leinonen, Aki Pyysing suddenly was the player at risk and urgently needed a double up or two to survive on the pretty high blinds at this point. Pyysing who never played a WSOP Circuit event before had already given us plenty of action and interesting stories during the tournament but after the hits on his stack he really needed to get back up on the horse to be able to play for the golden ring. Pyysing did get one of the double-ups needed but when it was time for the other coin flip for Pyysing against Smirnov he couldn’t hit the board and was out in third place worth €13,200.
As Aleksei Smirnov from Estonia and Finland’s Santtu Leinonen reached heads-up they discussed a deal and agreed on securing €25,430 for Smirnov and €21,710 for Leinonen and €1,000 to play for apart from that desirable golden Circuit ring. Smirnov had a two-to-one advantage in chips to start with and even though they got almost even in chips near the end this was Smirnov's day. When the two got their chips in the middle in a coin flip it was almost written in the stars that the Estonian would catch the longer straw as he just seemed to have one of these days where the coinflips were in his favor. And so it was. Leinonen was eliminated in second place for €21,710 while we had our second winner here in Tallinn as Aleksei Smirnov received the audience applause as he received the huge winner check, a golden ring, and €25,430.
A huge congratulations to all 13 players who cashed here in the second event of the 2023 World Series of Poker Circuit Tallinn and a big round of applause to our second champion so far Aleksei Smirnov.
Event #1: €555 No-Limit Hold'em Final Table Results
Event #2: €1,100 No-Limit Hold'em attracted 109 entries to create a €104,640 prize pool. Check out all of the final table results below:
Place
Player
Country
Prize
1
Aleksei Smirnov
Estonia
€25,430
2
Santtu Leinonen
Finland
€21,710
3
Aki Pyysing
Finland
€13,200
4
Josh Stewart
United Kingdom
€9,650
5
Steponas Venckus
Lithuania
€7,400
6
Vidar Assersen
Norway
€5,950
7
Dominik Ostrowski
Poland
€4,900
8
Tanel Evert
Estonia
€3,750
9
Manoel Filho
Brazil
€3,050
Stay tuned at OlyBet.tv as we will provide you with full coverage of the events for the rest of the week.
Article author: Lina Olofsson Photo credits: Elena Kask
Santtu Leinonen Eliminated in 2nd Place (€21,710) Posted Sunday 17th September, 2023 at 16:27(UTC+0) by Lina Olofsson
It's over! The last hand on the final table of the €1,100 Event #2 just played out busting Finland's Santtu Leinonen from the tournament.
The action started with Leinonen making almost a minimum raise to 130,000 from the button and after a bit of thought, Aleksei Smirnov announced he was all-in. With pretty equal stacks (1,7 vs. 1,4 in favor of Smirnov) the Finn took his time before deciding if he would call or not but eventually decided to throw in a red chip and we had a showdown:
Leinonen: Smirnov:
We had a classic 50/50 here. However the flop was in favor for our Estonian Smirnov. The on the turn didn't change anything and neither did the on the river and it was all over.
After the deal made when they were heads-up Santtu Leinonen gets €21,710 for his second place.
Player
Chips
Progress
Aleksei Smirnov
3,100,000
1,400,000
Santtu Leinonen
0
0
16:15 (UTC+0)
Start of Level 25 Blinds: 30,000/60,000 Ante: 60,000
Double Up for Leinonen Posted Sunday 17th September, 2023 at 16:14(UTC+0) by Lina Olofsson
Just a few hands later Finnish Santtu Leinonen found a double up after looking down on when Smirnov pushes him all-in from the small blind. He instantly calls and his opponent turns over .
The board ran out and Leinonen doubled his stack.
Player
Chips
Progress
Aleksei Smirnov
1,700,000
900,000
Santtu Leinonen
1,400,000
690,000
Smirnov Increase His Lead Further Posted Sunday 17th September, 2023 at 16:10(UTC+0) by Lina Olofsson
Smirnov has his sight on the win that's for sure and he just took a decent part of his opponent Santtu Leinonen's chips.
It was on the flop and 460,000 in the middle Leinonen took a chance with his and bet 150,000. Smirnov tanked for a while before he popped it up to 400,000. Leinonen didn't do much "Hollywood acting" before he threw his cards into the muck and Smirnov increased his stack further while Leinonen needs a double up to not be eaten by the blinds.
Player
Chips
Progress
Aleksei Smirnov
2,600,000
400,000
Santtu Leinonen
710,000
390,000
Interview With Event #1: €555 NLH Winner Viacheslav Sultanov Posted Sunday 17th September, 2023 at 15:54(UTC+0) by Jason Glatzer
Ukraine's Viacheslav Sultanov agreed to a heads-up deal with Poland's Lukasz Fraczek to win Event #1: €555 No-Limit Hold'em for €34,435 and the first coveted WSOP gold ring of the festival.
His friend in GGPoker Ambassador Anatoly Filatov was on his rail from the beginning until the end and assisted him with some of the English translation in the interview with WSOP Circuit Tallinn host Evely Pihela.
Deal! Posted Sunday 17th September, 2023 at 15:49(UTC+0) by Lina Olofsson
During the short break before we started the heads-up the two remaining players decided to even the score a little bit and made a deal on the remaining prize pool where our chip leader Aleksei Smirnov secured €25,430 and Santtu Leinonen locked up €21,710.
With that deal made we congratulate the players on their winnings. The duo are still going to battle it out for the golden WSOPC ring and the €1,000 extra going to the winner.
Make sure you tune into the LIVE STREAM and follow the disintegration of this raffling final.
Heads-up! Posted Sunday 17th September, 2023 at 15:37(UTC+0) by Lina Olofsson
As we are now heads-up the player is on a short leg stretcher.
When they come back to play for the golden WSOP Circuit ring and the €27,840 in first prize Aleksei had a 2 to 1 advantage in chips against Santtu Leinonen. Or if you prefer to count it in Big Blinds it's 43 bigs versus 22.
Player
Chips
Progress
Aleksei Smirnov
2,200,000
0
Santtu Leinonen
1,100,000
100,000
Aki Pyysing Eliminated in 3rd Place (€13,200) Posted Sunday 17th September, 2023 at 15:34(UTC+0) by Lina Olofsson
Aki Pyysing came into the final table as a massive chip leader but didn't have many things going his way unfortunately these past few hours.
Down to only 12 BB he looked down on on big blind when Aleksei Smirnov pushed him all-in from small blind. He thought for a few second and then moved his chips over the line announcing a call. His opponent Smirnov turned over and we had a classic coin flip to determinate "The Terminator's" future on this final table.
The board ran out which was no help to our veteran Pyysing from Finland who was eliminated in third place for €13,200.
Player
Chips
Progress
Aleksei Smirnov
2,200,000
700,000
Aki Pyysing
0
0
Pyysing Doubles through Smirnov Posted Sunday 17th September, 2023 at 15:25(UTC+0) by Lina Olofsson
And just one hand later Aki Pyysing found that double up he so well needed.
The money went in before the flop between him and Aleksei Smirnov and show down revealed:
Pyysing:
Smirnov:
The board ran out and Pyysing doubles up and gets some air to breathe again.
Player
Chips
Progress
Aleksei Smirnov
1,500,000
200,000
Aki Pyysing
615,000
15,000
Pyysing Needs a Double Up Posted Sunday 17th September, 2023 at 15:16(UTC+0) by Lina Olofsson
With the blind levels now up to 25,000/50,000 and a big blind ante of 50,000 our former chip leader going into today's play, Aki Pyysing, is down to only 380,000 and desperately needs a double up since every round costs 125,000 each.
Player
Chips
Progress
Aleksei Smirnov
1,800,000
100,000
Santtu Leinonen
1,000,000
200,000
Aki Pyysing
380,000
220,000
Finn's in a Collusion, Leinonen Doubles Posted Sunday 17th September, 2023 at 15:14(UTC+0) by Lina Olofsson
Santtu Leinonen went all-in pre flop from the button and was called by Aki Pyysing from the big blind after a few minutes of consideration.
Leinonen:
Pyysing:
The board ran out and Leinonen doubles to 1,2 million while our previous chip leader now finds himself as the short stack among the three players left.
Player
Chips
Progress
Santtu Leinonen
1,200,000
565,000
Aki Pyysing
600,000
205,000
15:09 (UTC+0)
Start of Level 24 Blinds: 25,000/50,000 Ante: 50,000
Josh Stewart Eliminated in 4th place (€9,650) Posted Sunday 17th September, 2023 at 14:57(UTC+0) by Lina Olofsson
We just had our first bust out on the final table since we moved on to the feature table.
It was pre flop the money went in between Aleksei Smirnov and Josh Stewart with the latter at risk.
Joshua Stewart:
Aleksei Smirnov:
With the flop it was only two outs for Stewart to leave his hope to. The turn or the river wasn't one of them and Stewart found himself eliminated from the final table on fourth place for €9,650.
Player
Chips
Progress
Aleksei Smirnov
1,700,000
450,000
Joshua Stewart
0
0
We Are Live! Pyysing Takes One from Smirnov Posted Sunday 17th September, 2023 at 14:50(UTC+0) by Lina Olofsson
We are live on the stream which you can watch if you tune in over HERE. Which is sent with a 30-minute delay just like this blog will be to not give you any spoilers.
In one of the first hands back, Aki Pyysing took a bit of our new chip leader Aleksei Smirnovs chips and they are almost "Even Steven" up there in the top now.
Meet Kelly Kellner Posted Sunday 17th September, 2023 at 14:15(UTC+0) by Jason Glatzer
Kelly Kellner traveled from Western Canada to attend the WSOP Circuit Tallinn. Check out what he had to say in the video below:
Picture Time Posted Sunday 17th September, 2023 at 13:59(UTC+0) by Lina Olofsson
While we wait for the live stream to go up let's have a look at the pictures from our amazing photographer from today's final table here in the €1,100 NLHE event #2.
Santtu Leinonen
Josh Stewart
Aleksei Smirnov
Vidar Assersen
Steponas Venckus
Aki Pyysing
Chip Count On the Feature Table Posted Sunday 17th September, 2023 at 13:53(UTC+0) by Lina Olofsson
As the players are now moving to the feature table we have a new player in the lead of the remaining four players and that's Aleksei Smirnov with 1,250,000 in his stack.
When the play resumes we will pop up the blinds to 20,000/40,000 (BBA 40,000).
Player
Chips
Progress
Aleksei Smirnov
1,250,000
250,000
Aki Pyysing
805,000
180,000
Santtu Leinonen
635,000
114,000
Joshua Stewart
580,000
340,000
13:53 (UTC+0)
Start of Level 23 Blinds: 20,000/40,000 Ante: 40,000
We Are Moving Posted Sunday 17th September, 2023 at 13:49(UTC+0) by Lina Olofsson
The 22nd level is about to end and the players will now move up to the feature table since the €555 event #1 is now finished and a winner has been announced.
This means you will be able to watch them play live with a 30-minute delay in approximately 40-50 minutes. This also means that the blog will also be on a 30-minute delay with all the updates to not spoil anything for our amazing views and followers.
Head over to The Live Stream to watch the resolution of this fantastic event where the winner will walk away with €27,840.
Smirnov Doubles Through Pyysing Posted Sunday 17th September, 2023 at 13:39(UTC+0) by Lina Olofsson
Aki Pyysing has been holding the fort steady since late last night but just took a huge hit after doubling up Aleksei Smirnov.
Aki raised to 65,000 and Aleksei Smirnov went all-in for 500k and Pyysing made the call for what we presume was the biggest pot of the day.
Pyysing:
Smirnov:
The flop gave Smirnov a set and not much hope for our Finnish champ and on turn a full house for Smirnov ended all possibilities for Pyysing. The river didn't change anything and Smirnov is up to a million in chips while the Terminator lost a big part of his stack.
Player
Chips
Progress
Aleksei Smirnov
1,000,000
610,000
Aki Pyysing
985,000
500,000
Video Highlights From Day 3 Posted Sunday 17th September, 2023 at 13:37(UTC+0) by Jason Glatzer
Check out the highlights of the 2023 WSOPC Tallinn at Olympic Park Casino and the Hilton Tallinn Park below:
Steponas Venckus eliminated in 5th place (€7,400) Posted Sunday 17th September, 2023 at 13:22(UTC+0) by Lina Olofsson
Aki Pyysing raised UTG and the action was folded to Steponas Venckus in the big blind who decided to put his 155,000 in. Aki called and we had a showdown:
Pyysing:
Venckus:
The flop gave Lithuanian Venckus a possible flush draw but no luck there and he was eliminated in 5th place for a €7,400 payout.
Player
Chips
Progress
Aki Pyysing
1,485,000
200,000
Steponas Venckus
0
0
We Are Back! Posted Sunday 17th September, 2023 at 13:15(UTC+0) by Lina Olofsson
The players just returned to their seats and we are now on the 22nd level of the tournament with 15,000/30,000 and BBA of another 30,000.
On the main feature table, they are down to three players in event #1 €550 NLHE and as soon as we have a winner there we will be moving our players onto there and have it livestreamed on air with a 30-minute delay.
13:12 (UTC+0)
Start of Level 22 Blinds: 15,000/30,000 Ante: 30,000
1st Break Chip Stack Update Posted Sunday 17th September, 2023 at 13:09(UTC+0) by Alaxandar Georgiev
Lots of action around the blinds, stealing, all-ins, and post-flop action make the chips go quickly from one player to another. But that doesn't seem to bother our chip-leader Aki Pyysing, who has been at the top since the day began.
Here's the stacks of our remaining six players:
1. Aki Pyysing - 1,280,500 2. Joshua Stewart - 920,000 3. Santtu Leinonen - 521,000 4. Aleksei Smirnov - 390,000 5. Steponas Venckus - 155,000
15 Minute Break Posted Sunday 17th September, 2023 at 12:53(UTC+0) by Lina Olofsson
The remaining five players are now off to their first break of the day. While they are away we take the chance to get their chip counts as they are also doing a color up and introducing the green chips into play which are worth 100,000 each.
Venckus Doubles Through Stewart Posted Sunday 17th September, 2023 at 12:43(UTC+0) by Lina Olofsson
Steponas Venckus went all-in UTG for 190,000 and the action was folded to Aleksei Smirnov in the small blind who thought for a while until he folded but Josh Stewart didn't thing for more than a second before putting some gray chips over the line announcing a call.
Steponas Venckus:
Josh Stewart:
The flop didn't look too nice to our player at risk but with the turn and river he managed to dodge the bullet and doubled up.
Player
Chips
Progress
Joshua Stewart
720,000
190,000
Steponas Venckus
390,000
200,000
Post-Flop Play On The FT Posted Sunday 17th September, 2023 at 12:38(UTC+0) by Alaxandar Georgiev
Santtu Leinonen opened the action by tossing 55,000 in the middle from the button and second in chips Joshua Stewert defended from the big blind.
The flop came - Stewert checked and Leinonen bet 40,000 and again Leinonen called. The turn didn't mean much to both players as they checked it down. But the river somehow made the Irish guy throw 200,000 from the big blind and Leinonen gave up the pot.
Player
Chips
Progress
Joshua Stewart
910,000
100,000
Santtu Leinonen
226,000
100,000
12:25 (UTC+0)
Start of Level 21 Blinds: 10,000/25,000 Ante: 25,000
Vidar Assersen Eliminated in 6th Place (€5,950) Posted Sunday 17th September, 2023 at 12:19(UTC+0) by Lina Olofsson
Finding himself with only 45,000 left after the hand against Steponas Venckus Norwegian Vidar Assersen goes all-in under the gun. Steponas Venckus raises to 100,000 and the action is folded to Aleksei Smirnov on the small blind who goes all-in for almost 400,000. Josh Stewart on big blind gets out of the way while Venckus tanks for a while until he eventually folds his hand.
Vidar Assersen: Aleksei Smirnov:
Steponas Venckus nods his head and says "It's a flip" which we presume means he had a middle pocket pair in his hand.
The flop came which potentially gave the Norwegian a straight draw but the on the turn and was none of the outs he would have needed and he finished the tournament in 6th place for €5,950.
Player
Chips
Progress
Aleksei Smirnov
530,000
180,000
Steponas Venckus
270,000
100,000
Vidar Assersen
0
0
Big Double Up for Venckus Posted Sunday 17th September, 2023 at 12:15(UTC+0) by Alaxandar Georgiev
Vidar Assersen jammed his remaining 215,000 stack from the cut-off and Steponas Venckus snap-called all-in for 159,000 chips from the button. The players opened their cards on the table.
Vidar Assersen: Steponas Venckus:
Vidar's hopes of hitting an ace were crushed on the flop as Venckus hit a set of Queens. The turn was and the river which lead to a nice double-up for Venckus.
Player
Chips
Progress
Steponas Venckus
370,000
169,000
Vidar Assersen
55,000
100,000
New Chip Counts Posted Sunday 17th September, 2023 at 12:06(UTC+0) by Lina Olofsson
Here's the stacks of our remaining six players:
1
Aki Pyysing
1,550,000
277,000
2
Joshua Stewart
810,000
237,000
3
Aleksei Smirnov
350,000
165,000
4
Santtu Leinonen
326,000
14,000
5
Steponas Venckus
201,000
122,000
6
Vidar Assersen
155,000
144,000
It's Time to Upper the Ante Posted Sunday 17th September, 2023 at 11:56(UTC+0) by Lina Olofsson
We've reached the 20th level in this tournament and the blinds of 10,000/15,000 with a BBA of 15,000.
We'll be back with a more accurate chip counts from the final table now as we're down to six.
11:52 (UTC+0)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
Dominik Ostrowski eliminated in 7th place (€4,900) Posted Sunday 17th September, 2023 at 11:45(UTC+0) by Lina Olofsson
It can surely go quickly in the game of poker and with a few short-stacked players in the lineup we all knew this could happen. Right after the first two eliminations it's in the battle of the blinds that Aleksei Smirnov and Dominik Ostrowski get their chips in and showdown:
Aleksei Smirnov: Dominik Ostrowski:
The board ran out and another one bites the dust here at the final table.
And just like that they were down to only six players. Congratulations to Dominik Ostrowski who's rewarded €4,900 for his efforts here in Tallinn and the €1,100 NLHE event number two.
Player
Chips
Progress
Aleksei Smirnov
356,000
171,000
Dominik Ostrowski
0
0
Tanel Evert eliminated in 8th place (€3,750) Posted Sunday 17th September, 2023 at 11:41(UTC+0) by Alaxandar Georgiev
Our shortest stack on the final table Tanel Evert was left even shorter after he had to forfeit his big blind and he was left with only 21,000 chips when action folded to him on the small blind and he put his remaining stack in the middle.
Santtu Leinonen had an easy call on the big blind for this price.
Tanel Evert: Santtu Leinonen:
Evert had the better hand but not for long as the flop already gave Leinonen what he needed and the , didn't change much for Evert.
Eliminated in 8th place he will take home the price of €3,750.
Player
Chips
Progress
Santtu Leinonen
333,000
21,000
Tanel Evert
0
0
Manoel Filho eliminated in 9th place (€3,050) Posted Sunday 17th September, 2023 at 11:33(UTC+0) by Lina Olofsson
Manoel Filho goes all-in pre flop from UTG+1 for 91,000 and gets called by Santtu Leinonen behind with 312,000 in his stack. It folds all the way to Aki Pyysing on the big blind who puts Leinonen all-in and the Finn decides to get out of the way.
Filho:
Pyysing:
Flop:
Turn:
River:
And just like that, we lost our first player on the final table. Manoel Filho pockets €3,050 for his 9th-place finish.
Player
Chips
Progress
Aki Pyysing
1,460,000
187,000
Manoel Filho
0
0
11:26 (UTC+0)
Start of Level 19 Blinds: 10,000/15,000 Ante: 15,000
Presentations Posted Sunday 17th September, 2023 at 11:11(UTC+0) by Lina Olofsson
Tournament director Teresa Nousiainen has just presented the nine final players on our secondary feature table and drawn for the button which will start on seat number six.
Ok, people let's do this! Shuffle up and deal!
Welcome to Day 2 of the €1,100 No-Limit Hold'em Posted Sunday 17th September, 2023 at 09:29(UTC+0) by Alaxandar Georgiev
The final 9 players remain in the battle for the ring in Event #2: €1,100 No-Limit Hold'em and only one player will take it home. Who is it going to be?
The action begins at 1:00 p.m. as players will be seated on one of the featured tables here in Tallinn.
The final table will begin at Level 18 with blinds at 6,000/12,000 along with a 12,000 big blind ante with nine minutes left on the clock.
Aki Pyysing (pictured below) sits comfortably in the chip lead with a whopping 1,273,000 stack (106 big blinds) followed by Joshua Stewert who also played in Event #1: €555 WSOPC event and starts the day in Event #2 in second place with about 48 big blinds with everyone else on the shorter side with 26 big blinds and under.
The player at the most risk is Tanel Evert who is at only 45,000 chips and will be looking to double his way through the final table.
Check out the final table seat draw and the final table payouts below:
Final Table Seat Draw
Seat
Player
Chips
1
Aki Pyysing
1,273,000
2
Joshua Stewart
573,000
3
Steponas Venckus
323,000
4
Santtu Leinonen
312,000
5
Vidar Assersen
299,000
6
Aleksei Smirnov
185,000
7
Dominik Ostrowski
171,000
8
Manoel Filho
91,000
9
Tanel Evert
45,000
Final Table Payouts
Place
Prize
1
€27,840
2
€19,300
3
€13,200
4
€9,650
5
€7,400
6
€5,950
7
€4.900
8
€3,750
9
€3,050
09:17 (UTC+0)
Day 2 of WSOPC Tallinn Started Level: 18 Blinds: 6,000/12,000 Ante: 12,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.
was in favor for our Estonian Smirnov. The 
on the turn didn't change anything and neither did the 
on the river and it was all over. 
when Smirnov pushes him all-in from the small blind. He instantly calls and his opponent turns over 
. 
and Leinonen doubled his stack. 
and we had a classic coin flip to determinate "The Terminator's" future on this final table. 
which was no help to our veteran Pyysing from Finland who was eliminated in third place for €13,200.
and Pyysing doubles up and gets some air to breathe again. 
and Leinonen doubles to 1,2 million while our previous chip leader now finds himself as the short stack among the three players left. 
or the river 
gave Smirnov a set and not much hope for our Finnish champ and on turn 
he managed to dodge the bullet and doubled up. 
and the river 
