0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

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

0.0109 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-11' 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.0002 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

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

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

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '30'

0.0274 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0059 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '98' AND `published` = 1

0.0276 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0079 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '118' AND `published` = 1

0.0275 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0057 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '119' AND `published` = 1

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '30' AND `name` = '2'

0.0059 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.0059 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.0084 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5134' 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` = '5133' 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` = '5132' 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` = '5130' 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` = '5127' 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` = '5123' 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` = '5121' 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` = '5119' 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` = '5118' 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` = '5113' 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` = '5106' 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` = '5105' 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` = '5103' 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` = '5099' 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` = '5095' 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` = '5089' 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` = '5083' 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` = '5081' 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` = '5077' 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` = '5074' 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` = '5071' 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` = '5067' 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` = '5064' 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` = '5063' 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` = '5061' 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` = '5062' 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` = '5056' 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` = '5055' 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` = '5050' 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` = '5049' 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` = '5040' 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` = '5036' 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` = '5033' 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` = '5029' 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` = '5028' 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` = '5026' 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` = '5022' 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` = '5018' 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` = '5014' 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` = '5004' 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` = '5001' 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` = '4998' ORDER BY `chip_change` DESC, `busted` ASC

0.0074 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '4994' 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` = '4988' 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` = '4980' 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` = '4979' 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` = '4975' 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` = '4974' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '119' ORDER BY `busted` ASC, `current_chips` DESC

0.0054 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.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` = '5134' ORDER BY `chip_change` DESC, `busted` ASC

0.0104 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5132' 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` = '5130' 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` = '5127' 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` = '5123' 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` = '5121' 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` = '5119' 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` = '5118' 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` = '5113' 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` = '5106' 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` = '5105' 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` = '5103' 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` = '5099' 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` = '5095' 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` = '5089' 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` = '5083' ORDER BY `chip_change` DESC, `busted` ASC

0.0080 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5081' 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` = '5077' 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` = '5074' 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` = '5071' 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` = '5067' 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` = '5064' 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` = '5063' 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` = '5061' 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` = '5062' 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` = '5056' 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` = '5055' 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` = '5050' 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` = '5049' 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` = '5040' 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` = '5036' 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` = '5033' 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` = '5029' 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` = '5028' 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` = '5026' 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` = '5022' 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` = '5018' 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` = '5014' 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` = '5010' 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` = '5004' 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` = '5001' 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` = '4998' 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` = '4994' 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` = '4988' 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` = '4980' 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` = '4979' 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` = '4975' 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` = '4974' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '119' ORDER BY `busted` ASC, `current_chips` DESC

0.0003 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2143

English
WSOPC Tallinn Event #3: €350 No-Limit Hold'em Live Reporting - Day 2
1 New Update - Click to refresh
Live Updates - Day 2
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

Level 30: 100,000/150,000 (150,000)
Entries: 2/383

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

Level 30: 100,000/150,000 (150,000)
Entries: 3/383

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

Level 30: 100,000/150,000 (150,000)
Entries: 3/383

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

Bottom row: Evely Pihela - Kaur Ajamaa - Vilius Zabarauskas - Tanel Merida - Michele Tocci 

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 . More 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.