0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event3/2/updates', 1, '2024-12-22')

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.0004 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.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0007 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.0005 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.0040 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.0313 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0067 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '98'
AND `published` = 1

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

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

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

0.0064 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.0064 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.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5134'
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` = '5133'
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` = '5132'
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` = '5130'
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` = '5127'
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` = '5123'
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` = '5121'
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` = '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.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` = '5113'
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` = '5106'
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` = '5105'
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` = '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.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` = '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.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` = '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.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` = '5074'
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` = '5071'
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` = '5067'
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` = '5064'
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` = '5063'
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` = '5061'
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` = '5062'
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` = '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.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` = '5050'
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` = '5049'
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` = '5040'
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` = '5036'
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` = '5033'
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` = '5029'
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` = '5028'
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` = '5026'
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` = '5022'
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` = '5018'
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` = '5014'
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` = '5004'
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` = '5001'
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` = '4998'
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` = '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.0081 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0105 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4979'
ORDER BY `chip_change` DESC, `busted` ASC

0.0126 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0123 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0104 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_id` = '119'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5134'
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` = '5133'
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` = '5132'
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` = '5130'
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` = '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.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.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` = '5119'
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` = '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.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.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` = '5103'
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` = '5099'
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` = '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.0070 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '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.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` = '5077'
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` = '5074'
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` = '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.0077 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5061'
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` = '5062'
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` = '5056'
ORDER BY `chip_change` DESC, `busted` ASC

0.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5055'
ORDER BY `chip_change` DESC, `busted` ASC

0.0083 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0073 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5049'
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` = '5040'
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` = '5036'
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` = '5033'
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` = '5029'
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` = '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.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` = '5022'
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` = '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.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` = '5010'
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` = '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.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` = '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.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.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` = '4979'
ORDER BY `chip_change` DESC, `busted` ASC

0.0105 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4975'
ORDER BY `chip_change` DESC, `busted` ASC

0.0070 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4974'
ORDER BY `chip_change` DESC, `busted` ASC

0.0076 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.0005 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143

    

Open Modal

Hi,

We'd like to send you push notifications so you never miss out on:

• Exclusive Offers
• Upcoming Events
• Exciting Promotions
• Poker Travel News

Don’t worry; we won’t bombard you with messages, and you can-opt out anytime by logging into your account and changing your settings.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(6)
  • APAT(1)
  • APPT(0)
  • Aria Resort & Casino(1)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(11)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(1)
  • EPT(2)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(70)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(0)
  • GUKPT Grosvenor(9)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • Kings of Tallinn(1)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Open(5)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(2)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

WSOPC Tallinn Event #3: €350 No-Limit Hold'em Live Reporting - Day 2

WSOPC Tallinn - Live Reporting

Event #3: €350 No-Limit Hold'em See other events

Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

WSOPC Tallinn - Live Reporting Event #1: €555 No-Limit Hold'em (Estonian) Event #3: €350 WSOPC Tallinn Ring Event (Estonian) Event #1: €555 No-Limit Hold'em Event #2: €1,100 No-Limit Hold'em Event #3: €350 No-Limit Hold'em Event #4: €555 Pot-Limit 2-7 Triple Draw Event #5: €660 No-Limit Hold'em Mystery Bounty Event #6: €1,500 WSOPC Tallinn Main Event Event #8: €1,100 PLO / PLO5 Event #9: €660 Pot-Limit Omaha Hi/Lo Event #11: €3,000 No-Limit Hold'em 6 Handed Event #12: €660 No-Limit Hold'em Progressive Bounty Event #6: €1,500 WSOPC Tallinn Main Event (Estonian)

---

Current Level 18 Current Day 2

---

Blinds - Ante -

Entries 383 Remaining 1

---

Prize Pool (EUR) €115,819 First Prize (EUR) €24,150

Chip Leaders Day 2

1

Kaur Ajamaa

7,600,000

Day 1A Day 1B Day 2

Live Updates Chip Counts Structure Gallery Payouts

SHARE

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

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter