0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0061 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event3/2/updates'
ORDER BY `views` DESC
0.0099 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event3/2/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0064 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0004 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event3'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '30'
0.0244 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0050 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '98'
AND `published` = 1
0.0245 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '118'
AND `published` = 1
0.0244 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0044 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '119'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '30'
AND `name` = '2'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '119'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '119'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5132'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5121'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5105'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5103'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5099'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5095'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5089'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5083'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5081'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5077'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5074'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5071'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5067'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5064'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5063'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5061'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5062'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5055'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5050'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5049'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5036'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5033'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5029'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5028'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5026'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5022'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5018'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5014'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5004'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5001'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4988'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4980'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4979'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4975'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4974'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '119'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '119'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5132'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5121'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5105'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5103'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5099'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5095'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5089'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5083'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5081'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5077'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5074'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5071'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5067'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5064'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5063'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5061'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5062'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5056'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5055'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5050'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5049'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5040'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5036'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5033'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5029'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5028'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5026'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5022'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5018'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5014'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5010'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5004'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5001'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4998'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4994'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4988'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4980'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4979'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4975'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4974'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '119'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Kaur Ajamaa Wins 2023 WSOPC Tallinn Event #3 €350 NLHE (€17,050) Posted Monday 18th September, 2023 at 18:57(UTC+0) by Lina Olofsson
Over the period of 11 days Olympic Park Casino will award 12 rings in the prestigious and inaugural 2023 WSOPC here in the Estonian capital and today it was time for the third and fourth of them to be handed out to one lucky winner.
Yesterday we had two flights combining an astonishing 383 entries in Event #3: €350 No-Limit Hold'em, with 49 players battling it out to Monday's final day already in the money and guaranteed at least €650.
Event #3: €350 No-Limit Hold'em Final Table Results
Place
Player
Country
Prize
1
Kaur Ajamaa
Estonia
€17,050*
2
Igor Pihela Sr.
Estonia
€16,050*
3
Michele Tocci
Italy
€16,050*
4
Tanel Merida
Estonia
€7,400
5
Joshua Stewart
United Kingdom
€5,700
6
Vilius Zabarauskas
Lithuania
€4,349
7
Nils Kollandsrud
Norway
€3,600
8
Dominik Ostrowski
Poland
€2,900
9
Evely Pihela
Estonia
€2,400
*Reflects three-way deal.
Final Day Action
Going into today we had a lot of interesting players still in the field but the most notable must be that three family members made it and it wasn't just any family. It was a family affair with Evely Pihela, her husband Igor Pihela Jr., and her father-in-law Igor Pihela Sr. all advancing to Day 2 and when they were down to the final nine both Evely and Igor Senior were still competing for that coveted golden ring, and the first prize of €24,150.
But with a small stack and no cards worthy of their name Evely soon had to push with any two and when looking down at queen-five she decided to go for it. Sadly one of her opponents Joshua Stewart had found a decent hand in the big blind calling with ace-ten and caught an ace on the flop sending Evely to the rail in ninth place for €2,400.
But Evely and the rest of the Pihela family weren’t the only notable players in the field and in particular at the final table. Three of the finalists in yesterday's €1,100 had made it all the way to yet another final which is an amazing track record with only three circuit events held so far. Dominik Ostrowski, Tanel Merida, and James Stewart were all three in yesterday's final too. Dominik who took fourth place yesterday was the next one to bust after Evely. First, he lost a big coinflip against Vilius Zabarauskas and then the rest of his chips went into the middle with king-queen getting called by Kaur Ajamaa with ace-jack. An open-ended straight draw on the flop uppered the odds but he couldn’t catch it and the Polish was eliminated in eight and cashed €2,900 in addition to the €4,900 he made yesterday when finishing seventh.
Another one who didn’t seem to get much going at the final table was our Norwegian Nils Kollandsrud who couldn’t win his coinflip against Michele Tocci with ace-ten versus nines and he was out in seventh place for a €3,900 payday.
Vilius Zabarauskas was soon after sent to the rail in the most classic coinflips of them all (ace-king versus queens) against Michele Tocci. The board didn’t come in his favor and he left the tournament as sixth which was worth €4,349.
Another one of our finalists from yesterday - Joshua Stewart - was eliminated by our gentleman Pihela Senior after they got in a massive pot where both had flopped the same pair but Pihela also had the flushdraw which hit on the turn leaving Stewart down to only one big blind which Tocci took from him the next hand and the Brit was out as fifth for €5,700.
Neither did Estonian Tanel Merida get his second chance on the golden ring in this event after he busted out as fourth for €7,400 in a battle between the blinds against Kaur Ajamaa where he was caught with his hand in the honey jar trying to steal the blinds with king-seven but his opponent actually picked up a hand and called with ace-nine.
With three players remaining our live-streamed 2-7 Triple Draw Pot Limit event #4 was done and dusted so in the first break they were all moved onto the featured table to proceed with their fight over the golden ring. During the break, they decided to split the money threeway cashing €16,050 each and leaving €1,000 up for grabs.
For a while there it looked like the Italian Michele Tocci would be our next champion since he was a huge chip leader but after doubling up Estonian Kaur Ajamaa he was the one at risk and couldn’t get his ace-seven to hold up against king-jack (even though one of his opponent's outs had been folded by Pihela) when a jack hit the flop.
Kaur Ajamaa came into the heads-up as a huge chip lead and never looked back. It didn’t take many hands until it was all over and in the final hand he decided to call Pihela Senior’s all-in with deuces it’s like they say: “deuces never lose” and they didn’t this time either as they held all the way to the winners circle against jack-ten.
A big congratulations to our latest winner here in WSOPC Tallinn Kaur Ajamaa who walked away with a big check under his arm, a very exclusive golden ring, and €17,050 in first prize.
Author: Lina Oloffsson Photographer: Elena Kask
Player
Chips
Progress
Kaur Ajamaa
7,600,000
1,800,000
Igor Pihela Sr.
0
0
Igor Pihela Sr Eliminated in 2nd place (€16,050) Posted Monday 18th September, 2023 at 16:52(UTC+0) by Lina Olofsson
Just two hands into heads-up our two Estonians was in for a classic coinflip for either a double up or to crowning our champion here in the third circuit event.
Pihela: Ajamaa:
"Deuces never loses", they say and so was the case this time too after the board ran out and the gentleman Igor Pihela Senior was eliminated and walked away with €16,050 for his efforts.
Player
Chips
Progress
Kaur Ajamaa
7,600,000
1,800,000
Igor Pihela Sr.
0
0
Estonian Heads-Up Posted Monday 18th September, 2023 at 16:45(UTC+0) by Lina Olofsson
There will be a second Estonian champion here in the 2023 WSOPC Tallinn and it surely looks like that might be Kaur Ajamaa since he now goes into the heads-up with a three-to-one lead against his fellow countrymen Igor Pihela Senior.
Player
Chips
Progress
Kaur Ajamaa
5,800,000
0
Igor Pihela Sr.
1,800,000
100,000
Michele Tocci Eliminated in 3rd place (€16,050) Posted Monday 18th September, 2023 at 16:42(UTC+0) by Lina Olofsson
After losing half of his stack to Kaur Ajamaa Michele Tocci needed a double up and pushed all-in for several executive rounds before getting a call picking up valuable chips from the pot without showdown. And eventually he was called and looked like he was in a good shape since Pihela had folded one of his outs.
Tocci: Ajamaa:
But already in the window as the dealer opened the flop we saw a jack and suddenly he desperately needed an ace to survive. After the board running out his adventure was over and he was rewarded the €16,050 secured in the deal made previously.
Player
Chips
Progress
Kaur Ajamaa
5,800,000
2,200,000
Michele Tocci
0
0
Looking Good for Estonia Posted Monday 18th September, 2023 at 16:32(UTC+0) by Lina Olofsson
After the double up it surely looks good for our two home players Igor Pihela Sr and Kaur Ajamaa at the top of the leaderboard while Italy's Michele Tocci now finds himself at the bottom even though he and Pihela are almost even in chips.
Player
Chips
Progress
Kaur Ajamaa
3,600,000
100,000
Igor Pihela Sr.
1,900,000
700,000
Michele Tocci
1,700,000
300,000
Ajamaa Doubles Through Tocci Posted Monday 18th September, 2023 at 16:23(UTC+0) by Lina Olofsson
We guess Kaur Ajamaa was just tired of our chip leader Michele Tocci raising every time the two of them were in the blinds and after yet another reraise all-in from Tocci he decided to call it off all of his stack with . Tocci actually had a hand with his and we had a coinflip ahead of us.
Flop was the hit our Estonian needed. Turn gave him a bit of a sweat but the on the river didn't change anything and he doubled up and took over the lead from the Italian.
Player
Chips
Progress
Kaur Ajamaa
4,000,000
1,500,000
Michele Tocci
1,600,000
1,600,000
Senior Pihela Loves To See A Flop Posted Monday 18th September, 2023 at 16:16(UTC+0) by Lina Olofsson
Level 29: 60,000/120,000 (120,000) Entries: 3/383
The good old Igor Pihela Senior has been involved in the majority of the hands so far and really seems to love all hole cards in the same suit.
As the commentators just said, if he wins it might be a very interesting winners interview since our former finalist Evely Pihela who busted in ninth place is also the one doing it afterward and our guess is that she would love to do it with her father in law Igor.
Can Estonia Take Another One Down? Posted Monday 18th September, 2023 at 16:11(UTC+0) by Lina Olofsson
Level 29: 60,000/120,000 (120,000) Entries: 3/383
Of the three remaining players, we have two Estonians competing with the Italian Michele Tucci. But they will have to do something about the situation with the chip lead he has right now to be able to beat him but so far it's been a very pending game and a lot of small-ball poker going on for the first level.
Player
Chips
Progress
Michele Tocci
3,200,000
0
Kaur Ajamaa
2,500,000
0
Igor Pihela Sr.
1,600,000
0
€16,050 Guaranteed Posted Monday 18th September, 2023 at 16:02(UTC+0) by Lina Olofsson
The three players have decided to do a deal to even the numbers but are still playing for €1,000 in first and the desirable golden WSOP Circuit ring to go along with it.
A big congratulation to the players who all has banked €16,050 each in prize money.
Talking about winning. We found our previous circuit winner Aleksei Smirnov yesterday as he tried to fit his massive prize check into a Bolt taxi outside the hotel.
We Are Live! Posted Monday 18th September, 2023 at 15:42(UTC+0) by Lina Olofsson
The final is now live on our LIVE STREAM with our three competitors left on the final table in the 2023 WSOPC Tallinn €350 event #3 where the winner will walk away with €24,150.
All three players are guaranteed at least €10,100 for third place and second place will pay €14,900.
Moving to the Feature Table Posted Monday 18th September, 2023 at 14:52(UTC+0) by Lina Olofsson
The three remaining players are now on a scheduled 20-minute break and in the meanwhile the tournament staff has moved them to the feature table which you can watch on our LIVE STREAM with a 30-minute delay which means we will also do the posts with a delay to not give you guys any spoilers.
Tune in to the stream and watch as this tournament crowns the third circuit winner later on.
Player
Chips
Progress
Michele Tocci
2,995,000
895,000
Kaur Ajamaa
2,375,000
695,000
Igor Pihela Sr.
2,290,000
1,230,000
Tanel Merida Eliminated in 4th Place (€7,400) Posted Monday 18th September, 2023 at 14:50(UTC+0) by Alaxandar Georgiev
Level 28: 40,000/80,000 (80,000) Entries: 4/383
After Tanel Merida (pictured below) jammed it all in for 600,000 from the small blind Kaur Ajamaa had a decision and made the call.
Tanel Merida: Kaur Ajamaa:
With Merida at risk, he needed some help on the flop but got none, the turn was even worse for him as he was now drawing only to a King. The river wasn't what he needed and he finished in 4th place claiming the prize of €7,400.
Joshua Stewart Loses Big to Pihela and Busts in 5th Place (€5,700) Posted Monday 18th September, 2023 at 14:40(UTC+0) by Lina Olofsson
Level 27: 30,000/60,000 (60,000) Entries: 6/383
On the flop reading Igor Pihela Senior and Joshua Stewart get their money in.
Pihela: Stewart:
Both players had hit middle pair with a possible straight draw but Pihela also had a flush draw on the side. On the turn he gets his flush and the river is unnecessary and Josh is left with just 50,000 left in his stack which is less than one big blind at this point. The last chips went to Michele Tocci as he exited the final table in fifth place for €5,700.
Player
Chips
Progress
Joshua Stewart
0
0
Vilius Zabarauskas Eliminated in 6th Place (€4,349) Posted Monday 18th September, 2023 at 14:30(UTC+0) by Lina Olofsson
Level 28: 40,000/80,000 (80,000) Entries: 6/383
And then they were down to only five after yet another player ran into the unstoppable Michele Tocci who just seems to get it all the time right now. It was pre flop Vilius Zabarauskas pushed all-in and was called by our chip leader Tocci.
Zabarauskas: Tocci:
We had a classic flip and the board ran out which was no good to Zabarauskas queens and he finished in sixth place for €4,349.
Player
Chips
Progress
Michele Tocci
2,100,000
500,000
Viliu Zabarauskas
0
0
Nils Kollandsrud Eliminated in 7th Place (€3,900) Posted Monday 18th September, 2023 at 14:19(UTC+0) by Lina Olofsson
Level 27: 30,000/60,000 (60,000) Entries: 7/383
Nils Kollandsrud pushed the remains of his chips from UTG. Action was folded around to Michele Tocci in the big blind who made the 550,000 call.
Kollandsrud: Tocci:
The board ran out and that was it for our Norwegian player here at the final table. For a seventh-place finish Kollandsrud is awarded €3,900.
Player
Chips
Progress
Michele Tocci
1,600,000
1,599,022
Nils Kollandsrud
0
0
Dominik Ostrowski Eliminated in Eight Place (€2,900) Posted Monday 18th September, 2023 at 14:03(UTC+0) by Lina Olofsson
Level 27: 30,000/60,000 (60,000) Entries: 8/383
After losing almost half his stack Dominik Ostrowski was down to 400,000 in chips which he pushed over the line announcing he was all-in. Kaur Ajamaa made the call and we had a showdown.
Ostrowski: Ajamaa:
The flop gave Ajamaa a pair but Ostrowski had an open-ended straight draw. Turn or didn't get him anywhere as his opponent got a full house as he gave away a huge sigh as he raked the pot.
For finishing eight Dominik Ostrowski now adds another €2,900 to his winnings here in Tallinn and we must say he's had quite a track record with two final tables in the first three events.
Player
Chips
Progress
Kaur Ajamaa
1,680,000
400,000
Dominik Ostrowski
0
0
Evely Pihela Eliminated in 9th Place (€2,400) Posted Monday 18th September, 2023 at 13:47(UTC+0) by Lina Olofsson
Level 26: 25,000/50,000 (50,000) Entries: 9/383
Evely Pihela who's been doing a lot of our interviews here in Tallinn showed her skills in the game of poker when making it into today's final table. Sadly though her journey just ended as she lost all her chips to Joshua Stewart.
Down to only five big blinds Evely pushed all her chips over the line with and was called by Joshua Stewart with . The board ran out and that was it. Stewart raked the pot and we had our first player eliminated at the final table in the 2023 WSOPC Tallinn Event #3.
Player
Chips
Progress
Joshua Stewart
1,321,000
250,000
Evely Pihela
0
0
Zabarauskas Doubles Through Ostrowski Posted Monday 18th September, 2023 at 13:41(UTC+0) by Lina Olofsson
Level 26: 25,000/50,000 (50,000) Entries: 9/383
Vilius Zabarauskas was the first player to have his life at stake since we moved to the feature table. He went all-in with his 360,000 in chips and was called by Dominik Ostrowski in the big blind with approximately 400,000 behind.
Zabarauskas: Ostrowski:
Flop gave our player at risk a flush draw and the fulfilled that draw and as the hit the river the dealer could start counting his chips and we had our first double up at the final table.
Player
Chips
Progress
Viliu Zabarauskas
750,000
190,000
Dominik Ostrowski
400,000
360,000
Meet Ant Gokcek at the WSOPC Tallinn Posted Monday 18th September, 2023 at 13:33(UTC+0) by Jason Glatzer
€24,150 To The Winner Posted Monday 18th September, 2023 at 13:32(UTC+0) by Lina Olofsson
As we've moved to the secondary feature table the game has slowed down drastically since it didn't take us more than a little bit over three hours to play down from the 39 who started today to the final table.
Everyone is now guaranteed €2,400 for their efforts in this tournament where the winner will receive a check of €24,150. Below you can find the payouts for the final table and if you go to 'Payouts' above you will find all players who cashed in this event so far.
1
€24,150
2
€14,900
3
€10,100
4
€7,400
5
€5,700
6
€4,349
7
€3,600
8
€2,900
9
€2,400
Our Finalists Posted Monday 18th September, 2023 at 13:25(UTC+0) by Lina Olofsson
Here are our nine finalists in the €350 Event #3 where the winner will receive €24,710 alongside the WSOPC golden ring.
Top row: Joshua Stewart - Igor Pihela (Sr) - Dominik Ostrowski - Nils Kollandsrud
Hey, You Look Familiar! Posted Monday 18th September, 2023 at 13:18(UTC+0) by Lina Olofsson
Level 24: 20,000/40,000 (40,000) Entries: 9/383
Have you caught up with the action from our blog since the past couple of days or watched the live stream from yesterday you're probably going to think: "Wait, are they doing a rerun on the secondary feature table from yesterday's tournament?"
No we aren't. It's a matter of fact that three of yesterdays finalists in the €1,100 event #2 actually made it all the way to this final table too. Josh Stewart from the UK who finished in fourth place, Dominik Ostrovski (pictured below) from Poland finished seventh and Estonian Tanel Evert finished in eight place yesterday and now has their second chance on that golden ring here in event #3.
Player
Chips
Progress
Joshua Stewart
1,071,000
0
Tanel Merida
920,000
0
Dominik Ostrowski
760,000
0
Seat Draw on the Final Table Posted Monday 18th September, 2023 at 13:09(UTC+0) by Lina Olofsson
Seat
Name
Country
Chips
1
Igor Pihela Sr
Estonia
1,110,000
2
Joshua Stewart
UK
1,065,000
3
Evely Pihela
Estonia
475,000
4
Kaur Ajamaa
Estonia
1,005,000
5
Vilius Zabarauskas
Lithuania
435,000
6
Tanel Merida
Estonia
875,000
7
Michele Tocci
Italy
1,400,020
8
Dominik Ostrowski
Poland
865,000
9
Nils Kollandsrud
Norway
410,000
Family Pot on the Final Table? Posted Monday 18th September, 2023 at 13:01(UTC+0) by Lina Olofsson
Going into todays game we had both Igor Pihela Senior and Junior in the field alongside with Evely Pihela whos married to the latter one. Evely and Senior Pihela started off at the same table and now with nine players remaining and our official final table two of them are still in it to win it.
As Tournamen Director Teresa Nousianen announces the final table we're about to start on the secondary feature table which you can see some parts of on our fabulous LIVE STREAM.
There's 13 minutes left on the clock of level 24 with the blinds on 15,000/30,000 and BBA 30,000.
Evely Pihela
Igor Pihela Senior
Player
Chips
Progress
Michele Tocci
1,400,000
1,399,022
Igor Pihela Sr.
1,110,000
50,000
Joshua Stewart
1,065,000
6,000
Kaur Ajamaa
1,005,000
275,000
Tanel Merida
875,000
45,000
Dominik Ostrowski
865,000
105,000
Evely Pihela
475,000
0
Viliu Zabarauskas
435,000
125,000
Nils Kollandsrud
410,000
64,000
Martin Piik Eliminated in 10th Posted Monday 18th September, 2023 at 12:51(UTC+0) by Alaxandar Georgiev
Level 23: 15,000/30,000 (30,000) Entries: 9/383
Martin Piik (pictured below) jammed his last 14 big blinds under the gun and Joshua Stewert quickly asked for a chip count from the small blind and announced he was calling.
Martin Piik: Joshua Stewert:
The flop gave Piik some additional outs for a straight and even some more on the turn, but no luck on the river for Piik.
The final 9 players will now be seated at our feature table and battle it down for the first prize and the ring.
Player
Chips
Progress
Joshua Stewart
1,071,000
415,000
Martin Piik
0
0
Evely Doubles Before The FT Posted Monday 18th September, 2023 at 12:45(UTC+0) by Alaxandar Georgiev
Level 23: 15,000/30,000 (30,000) Entries: 10/383
After a raise to 65,000 from Dominik Ostrowski, Evely Pihela jammed the button for 200,000 chips followed by a call from Ostrowski.
Evely Pihela: Dominik Ostrowski:
Both players made a pair on the flop which changed nothing as Pihela was still a favorite. Good turn and river made sure that our last girl in the tournament won the pot.
Player
Chips
Progress
Dominik Ostrowski
760,000
200,000
Evely Pihela
475,000
245,000
Meet Veikka Keto-Tokoi at the WSOPC Tallinn Posted Monday 18th September, 2023 at 12:41(UTC+0) by Jason Glatzer
Pictures from the tournament Posted Monday 18th September, 2023 at 12:39(UTC+0) by Lina Olofsson
Here's some pictures from todays field and the rest of the pictures you'll be able to find in the gallery. Enjoy!
Tanel Merida
Igor Pihela Senior
Vilius Zabarauskas
Nils Kollandsrud
Joshua Stewart
Kaur Ajamaa
Jonas Ruginis
Players Have Returned After The Break Posted Monday 18th September, 2023 at 12:36(UTC+0) by Lina Olofsson
Players just returned to their seats after the first break of the day. Under the tab chip counts above you will find the updated chip counts.
The blind level is now up to 15,000/30,000 with a BBA of 30,000 as we started on the 24th level.
Ruginis Eliminated in 12th Posted Monday 18th September, 2023 at 12:33(UTC+0) by Alaxandar Georgiev
Level 23: 10,000/25,000 (25,000) Entries: 11/383
Tocci Michele open-shoved from the button and a snap called by Jonas Ruginis on the small blind.
Tocci Michele: Jonas Ruginis:
Ruginis was the player at risk with his 650,000 stack while Michele had just a bit more than that.
The flop wasn't what Ruginis was looking for as he was drawing to a better full-house. Turn and river didn't give him that and he left the tournament in 12th winning €1,850.
Video Highlights From Day 4 Posted Monday 18th September, 2023 at 12:07(UTC+0) by Jason Glatzer
Tanel Doubles Through Vilius Posted Monday 18th September, 2023 at 12:03(UTC+0) by Lina Olofsson
Level 23: 10,000/25,000 (25,000) Entries: 14/383
It was before the flop all the money went in between Tanel Merida with and Vilius Zabarauskas with .
The board ran out and Merida gets to a million in chips.
Player
Chips
Progress
Tanel Merida
1,000,000
466,000
Viliu Zabarauskas
472,000
500,000
Ostrowski takes Krumins out in 15th Posted Monday 18th September, 2023 at 11:56(UTC+0) by Lina Olofsson
Level 23: 10,000/25,000 (25,000) Entries: 14/383
Eriks Krumins and Dominik Ostrowski saw the flop . Krumins went all-in and was called. Showdown:
Krumins: Ostrowski:
So far, so good for our player at risk but it all changed on the turn when the hit. The river wasn't helping and we had another player done and dusted in this event and we are one step closer to the final nine players.
Player
Chips
Progress
Albert Ostrovskij
1,000,000
150,000
Eriks Krumins
0
0
New Re-Draw Posted Monday 18th September, 2023 at 11:42(UTC+0) by Lina Olofsson
Level 22: 10,000/20,000 (20,000) Entries: 17/383
As we just lost one of our favorite Swede Bjorne Lindberg and Finn Tapio Aaltonen it was time for yet another re-draw as the players are now down to the final two tables in this €350 WSOP Circuit event.
Head over to the chip count page and you will see what the last 16-man standing chip counts are.
Player
Chips
Progress
Bjorn Lindberg
0
0
Tapio Aaltonen
0
0
Saveikis Doubles and Leaves Korsunskyy Short Posted Monday 18th September, 2023 at 11:38(UTC+0) by Lina Olofsson
Level 22: 10,000/20,000 (20,000) Entries: 17/383
Dan Korsunskyy goes all-in and Algirdas Saveikis calls off his 209,000. Showdown:
Korsunskyy: Saveikis:
Board gave Algirdas Saveikis a nice double up while leaving Korsunskyy with roughly 100,000 left of his stack.
Player
Chips
Progress
Algirdas Saveikis
440,000
126,000
Dan Korsunskyy
100,000
214,000
Viktor and Aaltonen to the Rail Posted Monday 18th September, 2023 at 11:29(UTC+0) by Lina Olofsson
Level 22: 10,000/20,000 (20,000) Entries: 17/383
As we predicted this was going to be a "speedy Gonzales" kind of day and so it has. We are already down to 17 players as we just lost Estonian player Viktor Magi and Tapio Aaltonen from Finland.
Player
Chips
Progress
Tapio Aaltonen
0
0
Viktor Magi
0
0
Five More Eliminations Posted Monday 18th September, 2023 at 11:24(UTC+0) by Lina Olofsson
Level 22: 10,000/20,000 (20,000) Entries: 19/383
It goes so quickly now we're almost arent able to catch up with all the action but another five players have been sent to the rail earning €1,100 each for their efforts in this two-day event.
Player
Chips
Progress
Maksim Piipponen
0
0
Stanislovas Norkus
0
0
Andres Leppik
0
0
Veikka Keto-Tokoi
0
0
Glen Gaines
0
0
Lindberg is Holding On to a Thread Posted Monday 18th September, 2023 at 11:20(UTC+0) by Lina Olofsson
Level 21: 10,000/15,000 (15,000) Entries: 24/383
Bjorne Lindberg was one of the players going into day two with a comfortable stack but the day hasn't started very good for the Swede as he's down to 100,000 and need a double up or two to be able to survive on these high blinds as we are up to at this point.
Player
Chips
Progress
Bjorn Lindberg
105,000
5,000
Re-Draw! Posted Monday 18th September, 2023 at 11:09(UTC+0) by Lina Olofsson
Level 21: 10,000/15,000 (15,000) Entries: 24/383
Players have been dropping out like flies here today during the first levels of play and we are now down to the last three tables since just busting Joonas Kulli in 25th place.
It's time for a re-draw and the players get a quick leg stretcher as the tournament staff helps them to move around their chips to the new tables.
Player
Chips
Progress
Jarmo Salonen
0
0
Joonas Kulli
0
114,000
Down to Four Tables Posted Monday 18th September, 2023 at 10:49(UTC+0) by Lina Olofsson
It's been a quick start to the day for sure. We are already down to the last 26 players spread over four tables. Two more eliminations and we are down to only three tables where we presume they will do a re-draw.
Player
Chips
Progress
Martin Sedlak
0
0
Marius Morel
0
0
Lukasz Fraczek
0
0
Albert Gorelik
0
0
Matti Lasanen
0
0
Sebastian Wahl
0
0
Mairo Tori
0
0
Priit Brikker
0
0
Kjetil Hanstvedt
0
0
Lukas Kviecinskas
0
0
Jarkko Suokas
0
0
Celso Luiz De Almeida Rolim Junior
0
0
Vladislav Topilskiy
0
0
Igor Pihela Jr.
0
0
Sedlak Sends Zamzickas to the Rail Posted Monday 18th September, 2023 at 10:39(UTC+0) by Lina Olofsson
Level: 20: 6,000(12,000 (12,000) Entries: 36/383
Vilius Zamzickas was just eliminated as he ran straight into Martin Sedlak with against Martin Sedlaks .
The board didn't bring any of the outs needed for Zamzickas who busted the tournament and we just had our first table broken here today as he walked his way to the cashier to pick his €650 up.
Player
Chips
Progress
Martin Sedlak
190,000
72,000
Vilius Zamzickas
0
0
Ostrovskij Takes the Lead after busting Ajamaa and Alen Posted Monday 18th September, 2023 at 10:34(UTC+0) by Lina Olofsson
Level 19: 5,000/10,000 (10,000) Entries: 37/383
Albert Ostrovskij just caught two birds with one stone in a massive pot which puts him in the lead of the remaining 37 players.
Albert Ostrovskij made a minimum raise to 20,000 from UTG and Johan Alen pushed all-in for approximately 40,000. Albert Ostrovskij tried to isolate and popped it up even further when Kaur Ajamaa decided to go all-in for 118,000. Albert Ostrovskij didn't need long to make the call and his against Osttrovskij's and Alen's looked in pretty good shape.
The board ran out and the best hand held up as two more players exited the door.
Player
Chips
Progress
Albert Ostrovskij
450,000
450,000
Kaur Ajamaa
0
154,000
Johan Alen
0
0
First Elimination of the Day Posted Monday 18th September, 2023 at 10:19(UTC+0) by Lina Olofsson
Level 18: 4,000/8,000 (8,000) Entries: 46/383
We just had our first bust out here in today's field and that was yesterday's finalist in the €555 event Rasmus Lundstrom. He didn't spend much time licking his wounds after busting the featured final table in fourth for €12,650 and jumped into this event.
The action started with Sebastian Wahl going all-in for 62,000 from middle position and Rasmus Lundstrom decided to get along for the ride and pushed his chips over the line. The blinds got our of the way and we had a showdown:
Wahl: Lundstrom:
The board ran out and the Finn Lundstrom was out flopped by Wahl who paired his hand which held all the way to the bank while Lundstrom hit the cashier desk to claim his €650 for his efforts.
Family Reunion of the Pihela's Posted Monday 18th September, 2023 at 10:09(UTC+0) by Lina Olofsson
If you followed the reports from event #2 (€1,100) you probably remember we had both son and father Igor Pihela in the field and had a bit of confusion about it in the beginning.
Well both of them decided to play in this event too and actually they are both still in. And so is Igor Juniors wife Evely Pihela who's at the same table as her father-in-law Igor Pihela Senior (pictured below). This could be interesting.
Shuffle Up and Deal! Posted Monday 18th September, 2023 at 10:05(UTC+0) by Lina Olofsson
Level: 18: 4,000/8,000 (8,000) Entries: 49/383
The cards are in the air! We start the day with ten minutes left on the clock on level 18 before we proceed to level 19. As we already mentioned all players are already in the money with 13% getting paid here and are at least guaranteed €650 for their efforts. The winner today will go home with a whole lot more. Or €24,150 to be exact.
Day Two Starts at Noon! Posted Monday 18th September, 2023 at 09:33(UTC+0) by Lina Olofsson
Yesterday's two starting fields gathered an astonishing 383 entries in total and we are now down to the last 49 players who are all in the money already.
Today we'll crown another champion here in the 2023 WSOPC Tallinn in this event and you'll be able to read all the latest updates from the tournament here in our coverage.
The play resumes at 12 pm local time which is in 30 minutes with the blinds going back a couple of steps from where they finished yesterday and will be on 4,000/8,000 with a big blind ante of 8,000.
Stay tuned!
Day 2 Seat Draw Posted Sunday 17th September, 2023 at 22:35(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
15
1
Tapio Aaltonen
55,000
7
15
2
Priit Brikker
34,000
4
15
3
Albert Gorelik
124,000
16
15
5
Michele Tocci
316,000
40
15
6
Eriks Krumins
63,000
8
15
7
Topi Palenius
126,000
16
15
8
Jarkko Suokas
106,000
13
16
1
Marek Selgeveer
65,000
8
16
2
Evely Pihela
196,000
25
16
3
Juho Harkonen
236,000
30
16
4
Igor Pihela Sr.
329,000
41
16
6
Mairo Tori
87,000
11
16
7
Stefan Bittger
60,000
8
16
8
Glen Gaines
85,000
11
17
1
Joshua Stewart
346,000
43
17
2
Igor Pihela Jr.
101,000
13
17
3
Stanislovas Norkus
352,000
44
17
4
Jarmo Salonen
144,000
18
17
6
Marius Morel
140,000
18
17
7
Artur Kulanurk
130,000
16
17
8
Jonas Ruginis
240,000
30
21
1
Sebastian Wahl
99,000
12
21
2
Veikka Keto-Tokoi
27,000
3
21
3
Rasmus Lundstrom
65,000
8
21
4
Maksim Piipponen
113,000
14
21
5
Celso Luiz De Almeida Rolim Junior
149,000
19
21
6
Vilius Zabarauskas
274,000
34
21
7
Lukas Kviecinskas
123,000
15
22
1
Albert Ostrovskij
118,000
15
22
2
Andres Leppik
241,000
30
22
3
Dominik Ostrowski
260,000
33
22
4
Johan Alen
30,000
4
22
5
Martin Sedlak
118,000
15
22
6
Vilius Zamzickas
62,000
8
22
7
Kaur Ajamaa
296,000
37
23
1
Viktor Magi
77,000
10
23
2
Vladislav Topilskiy
202,000
25
23
3
Nils Kollandsrud
176,000
22
23
4
Joonas Kulli
114,000
14
23
5
Matti Lasanen
117,000
15
23
7
Bjorn Lindberg
241,000
30
23
8
Dan Korsunskyy
314,000
39
24
1
Algirdas Saveikis
291,000
36
24
2
Kjetil Hanstvedt
306,000
38
24
3
Lukasz Fraczek
83,000
10
24
4
Martin Piik
175,000
22
24
5
Keito Kaljulaid
57,000
7
24
6
Tanel Merida
161,000
20
24
7
Ville Lonngren
68,000
9
22:35 (UTC+0)
Day 2 of WSOPC Tallinn Started Level: 18 Blinds: 4,000/8,000 Ante: 8,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.