WSOP Circuit Events - WSOPC Tallinn - Live Coverage

        
0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0072 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1B/updates'
ORDER BY `views` DESC

0.0009 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event6/1B/updates', 1, '2024-11-22')

0.0003 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.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0004 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0041 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_event6'

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

0.0299 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0055 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '102'
AND `published` = 1

0.0315 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0061 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '125'
AND `published` = 1

0.0279 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '129'
AND `published` = 1

0.0272 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` = '130'
AND `published` = 1

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

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

0.0271 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` = '138'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '33'
AND `name` = '1B'

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

0.0067 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` = '125'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0068 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5457'
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` = '5452'
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` = '5444'
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` = '5442'
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` = '5440'
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` = '5443'
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` = '5432'
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` = '5430'
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` = '5425'
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` = '5423'
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` = '5420'
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` = '5418'
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` = '5416'
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` = '5415'
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` = '5409'
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` = '5407'
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` = '5402'
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` = '5398'
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` = '5396'
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` = '5391'
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` = '5390'
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` = '5388'
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` = '5383'
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` = '5380'
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` = '5379'
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` = '5375'
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` = '5374'
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` = '5369'
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` = '5368'
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` = '5365'
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` = '5361'
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` = '5358'
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` = '5357'
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` = '5355'
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` = '5351'
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` = '5347'
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` = '5345'
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` = '5340'
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` = '5339'
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` = '5336'
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` = '5334'
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` = '5331'
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` = '5328'
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` = '5327'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0057 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` = '125'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0071 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5457'
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` = '5452'
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` = '5444'
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` = '5442'
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` = '5440'
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` = '5443'
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` = '5432'
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` = '5430'
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` = '5427'
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` = '5425'
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` = '5423'
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` = '5420'
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` = '5418'
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` = '5416'
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` = '5415'
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` = '5409'
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` = '5407'
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` = '5402'
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` = '5398'
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` = '5396'
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` = '5391'
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` = '5390'
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` = '5388'
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` = '5383'
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` = '5380'
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` = '5379'
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` = '5375'
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` = '5374'
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` = '5369'
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` = '5368'
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` = '5365'
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` = '5361'
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` = '5358'
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` = '5357'
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` = '5355'
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` = '5352'
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` = '5351'
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` = '5347'
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` = '5345'
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` = '5340'
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` = '5339'
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` = '5336'
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` = '5334'
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` = '5331'
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` = '5328'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

English

WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event Live Reporting - Day 4

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 35 Current Day 4

Blinds 300,000/600,000 Ante 600000

Entries 719 Remaining 1

Prize Pool (EUR) €1,000,000 First Prize (EUR) €211,500

Chip Leaders Day 4

1	Ignacio Garrido Gonzalez		35,900,000

Day 1A Day 1B Day 1C Day 1D Day 2 Day 3 Day 4

1 New Update - Click to refresh

Live Updates - Day 1B

Urmo Velvelt Continues Heater; Bags Overall Chip Lead on Day 1b Posted Wednesday 20th September, 2023 at 19:31(UTC+0) by Jason Glatzer

Estonia's Urmo Velvelt (pictured above) recently finished in third place in the Kings of Tallinn Summer Showdown €1,100 Main Event for his largest live poker tournament cash of €49,300 and is in a position to potentially break his personal record thanks to bagging the overall chip lead of 293,000 on Day 1b in the 2023 World Series of Poker Circuit (WSOPC) Tallinn €1,500 Main Event.

Most of Velvelt's chips came in a glorious fashion as he won a massive flip for a 200,000 pot when his sevens turned into quads on the flop to eliminate Lithuania's Vasilj Barna who was in the rare position of drawing dead with two cards to come with big slick.

Today was special, but Velvelt had a heck of a day yesterday as well as he won the big bounty of €10,000 in Event #6: €660 No-Limit Hold'em Mystery Bounty. His total haul was €20,560 including the €4,060 he won for finishing in fourth place. This was more than what the ring winner Ranno Sootla claimed as he won the €10,000 top prize along with €5,000 in bounties.

Velvelt not only topped the 42 players bagging chips on Day 1b out of the total field of 107 entries, but he also bested Day 1a chip leader Joni Rantamaki from Finland who parlayed his 50,000 opening stack into 272,000 to lead the 63 survivors out of the 139 entries in the field.

This brings the field already up to 246 entries with 105 players advancing with the two biggest opening flights to go tomorrow with Day 1c kicking off at noon and Day 1d commencing at 7 p.m. Players will also be allowed to re-enter or late-register during the first two blind levels of Friday's Day 2.

The Finnish duo of Juho Suutari (251,500) and Roope Tarmi (233,500) finished just behind Velvelt on Day 1b with Estonia's Raivo Pinsel (231,500) and Finland's Touko Berndtson (219,000) rounding out the top five.

Kare Hallamaa (218,500), Georgios Skarparis (210,500), Georgios Tsouloftas (207,000), and Jon Ander Martinez (205,000) were the other players on Day 1b to end with at least 200,000 in chips.

We will be back with more Main Event coverage for Day 1c at noon tomorrow. In the meantime, our live reporting team will provide plenty of updates in Event #8: €1,100 PLO 4 & 5 Cards, so be sure to check it out.

Final Day 1b Chip Counts Posted Wednesday 20th September, 2023 at 18:51(UTC+0) by Jason Glatzer

Player	Country	Chips	Big Blinds
Urmo Velvelt	Estonia	293,000	117
Juho Suutari	Finland	251,500	101
Roope Tarmi	Finland	233,500	93
Raivo Pinsel	Estonia	231,500	93
Touko Berndtson	Finland	219,000	88
Kare Hallamaa	Finland	218,500	87
Georgios Skarparis	Cyprus	210,500	84
Georgios Tsouloftas	Cyprus	207,000	83
Jon Ander Martinez	Spain	205,500	82
Adria Comas I Roura	Spain	181,500	73
Kyosti Isberg	Finland	180,500	72
Ruslan Stserbjuk	Estonia	169,500	68
Nedas Nanys	Lithuania	164,000	66
Josep Pastor De Ramon	Spain	162,000	65
Vygerdas Jonikas	Lithuania	147,000	59
Szymon Bujok	Poland	143,000	57
David Spysschaert	Belgium	141,000	56
Arthur Boatman	USA	128,000	51
Andrey Koks	Estonia	127,000	51
Andzej Zinkevic	Lithuania	125,000	50
Johan Martinsen	Finland	117,000	47
Kelly Kellner	Canada	113,500	45
Mauri Dorbek	Estonia	109,500	44
Martin Sedlak	Germany	109,000	44
Ronny Albrigtsen	Norway	103,000	41
Vadims Milovs	Latvia	102,000	41
Morten Bremseth	Norway	100,000	40
Gert Laanemets	Estonia	91,000	36
Risto Parnat	Finland	86,000	34
Stanislovas Norkus	Lithuania	81,500	33
Samuli Hietala	Finland	80,000	32
Ori Hasson	Israel	71,500	29
Kert Hallik	Estonia	70,000	28
Aleksandr Jelpidiforov	Estonia	65,000	26
Alius Riskevicius	Lithuania	60,000	24
Jevgenijs Sapronenko	Latvia	56,000	22
Stefan Bittger	Germany	41,000	16
Keito Kaljulaid	Estonia	40,500	16
Steponas Venckus	Lithuania	34,000	14
Johan Alen	Finland	33,500	13
Topi Palenius	Finland	20,500	8
Steven Seller	Estonia	17,500	7

Players Bagging Chips Posted Wednesday 20th September, 2023 at 17:46(UTC+0) by Jason Glatzer

Players have begun to bag chips at many of the tables with the final hand or two taking place at some of the slower ones.

We will update shortly with the final chip counts of Day 1b along with a short recap of the day. Stay tuned and in the meantime, check out our coverage of Event #8: €1,100 Pot-Limit Omaha.

Final Three Hands Posted Wednesday 20th September, 2023 at 17:40(UTC+0) by Jason Glatzer

The floor announced the final three hands for Day 1b.

Suutari Bluff-Catches Amat Posted Wednesday 20th September, 2023 at 17:38(UTC+0) by Jason Glatzer

Level 10: 1000/2,000 (2,000)
Entries: 44/108

The relentless aggression by Victor Amat didn't work in a hand against Juho Suutari. Suutari called a three bet preflop before calling bets on the flop, turn, and river leading up to a massive pot with the on the board.

Suutari called down the entire way and won a massive pot while also sending Amat to the rail when his proved to be good against .

Player		Chips	Progress
Juho Suutari		210,000	110,000
Victor Amat		0	0

Pinsel Rivers Wheel to Win Big Pot Posted Wednesday 20th September, 2023 at 17:38(UTC+0) by Alaxandar Georgiev

Level 10: 1000/2,000 (2,000)
Entries: 45/108

A big pot was played between Raivo Pinsel and Estonia's Vladislav Topilskiy. With both players re-raising each other on the flop Topilskiy called the final all-in for his remaining 90,000 chips.

Raivo Pinsel:
Vladislav Topilskiy:

Topilskiy was ahead, but he had to fade a lot of cards, the turn was good for him but he needed to fade the river as any heart would complete a flush for his opponent while a four would be equally damaging for Topliskiy as Pinsel would improve to a wheel.

The river wasn't a heart and Topilskiy began some early celebrations. However, his celebration was cut short after realizing he was out of chips since the four also completed a wheel for Pinsel.

Player		Chips	Progress
Raivo Pinsel		255,000	205,000
Vladislav Topilskiy		0	0

17:08 (UTC+0)

Start of Level 10
Blinds: 1,000/2,000 Ante: 2,000

The Kicker Is Good Posted Wednesday 20th September, 2023 at 17:08(UTC+0) by Alaxandar Georgiev

Level 9: 1000/1,500 (1,500)
Entries: 57/108

Mairo Tori Opened from the pot and was three-bet by Jon Ander from the button, Tori called and the action went to the flop.

The flop was on which Tori check-called a small bet from Ander. The same thing happened on the turn and all the chips went in from Ander on the river and Tori called.

Mairo Tori:
Jon Ander:

Ander scooped a pot for more than 140,00 chips with the better kicker.

Player		Chips	Progress
Jon Ander Martinez		230,000	60,000
Mairo Tori		0	0

Bujok Heads to Broadway Posted Wednesday 20th September, 2023 at 16:51(UTC+0) by Jason Glatzer

Level 9: 1,000/1,500 (1,500)
Entries: 59/107

Roberts Rumba jammed for about 10 big blinds from the hijack before Szymon Bujok three-bet shoved for 67,000 from the big blind.

The action paused on Urmo Velvelt from the big blind.

"Not sure," Velvelt said. "I have nines."

The dealer asked Velvelt to not speak as it wasn't a classic all-in situation and you aren't allowed to engage with others at the table when there are two players with their stacks committed.

Velvelt understood and tanked a little more before laying down his hand.

"Did you really have nines?" Bujok said before the cards were turned over. "I have tens."

"Lucky me," Velvelt said with a big smile.

Roberts Rumba:
Szymon Bujok:

Rumba's ace found a partner on the board and momentarily thought he won the hand before quickly realizing he was out of chips with this board also improving Bujok off tens and into Broadway.

Player		Chips	Progress
Szymon Bujok		85,000	35,000
Roberts Rumba		0	0

Jacks for Parnat Posted Wednesday 20th September, 2023 at 16:49(UTC+0) by Alaxandar Georgiev

Level 9: 1000/1,500 (1,500)
Entries: 61/108

Risto Parnat raised under the gun for 4,000. Ori Hasson called from the button and Tarmo Tammel did the same from the big blind.

Parnat bet 4,500 on the flop. Hasson raised to 13,500. Tammel folded and Parnat called.

The on the turn was checked by Parnat and Hasson quickly bet 15,000 chips. Parnat quickly called.

The river went check-check. Parnat opened to win the hand after Hasson mucked.

Player		Chips	Progress
Risto Parnat		100,000	50,000
Ori Hasson		90,000	100,000

At Least 25 Seats to the Main Event Guaranteed Tonight! Posted Wednesday 20th September, 2023 at 16:38(UTC+0) by Jason Glatzer

For those of you looking at the schedule, you likely noticed a €150 Mega Satellite guaranteeing 10 seats to the WSOPC Tallinn €1,500 Main Event at 9 p.m.

What you wouldn't have seen is a new satellite that popped up with some tremendous value for late-night players as at Midnight there will be an added €150 mega satellite with another 15 seats guaranteed!

Of course, Omaha lovers will still be able to enjoy Event #36: €150 PLO 4, 5, & 6 card event at 11 p.m.. This is a six-max affair, which makes perfect sense once incorporating the six-card Omaha.

16:33 (UTC+0)

Start of Level 9
Blinds: 1,000/1,500 Ante: 1,500

Various Big Stacks at Break Posted Wednesday 20th September, 2023 at 16:20(UTC+0) by Jason Glatzer

Player	Chips	Progress
Georgios Tsouloftas	230,000	130,000
Urmo Velvelt	195,000	5,000
Ori Hasson	190,000	5,000
Semjons Karuckis	180,000	50,000
Jon Martinez	170,000	120,000
Vygerdas Jonikas	170,000	120,000
David Spysschaert	170,000	110,000
Josep Pastor De Ramon	160,000	110,000

Final Break Posted Wednesday 20th September, 2023 at 16:08(UTC+0) by Jason Glatzer

Players are on their final 20-minute break and will play two more levels when the action resumes before bagging up for Day 1b.

Velvelt Doubles After Flopping Quads Posted Wednesday 20th September, 2023 at 15:49(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 65/108

A raising war resulting in a pot of nearly 200,000 between Urmo Velvelt (pictured below) and Vasilij Barna with Velvelt four-bet jammed and Barna, who was slightly covered, quickly calling.

Vasilij Barna:
Urmo Velvelt:

The flip was on but the table quickly erupted as Velvelt spiked not a set but quads on the flop. Barna, who was already drawing dead, took out his phone to snap photos with a smile in disbelief before eventually gathering his belongings after the turn and river completed the board.

Player		Chips	Progress
Urmo Velvelt		200,000	150,000
Vasilij Barna		0	0

Koks Doubles Through Bremseth Posted Wednesday 20th September, 2023 at 15:38(UTC+0) by Jason Glatzer

Level 8: 600/1,200 (1,200)
Entries: 68/105

Adria Comas I Roura opened for 2,500 from the button before Morten Bremseth three-bet to 8,600 from the small blind. The action paused for a couple of minutes on Andrey Koks (pictured below), who eventually cold called while Comas I Roura folded.

Bremseth continued for 6,500 on the . Koks jammed for 36,200 and Bremseth called with Koks at risk.

Andrey Koks:
Morton Bremseth:

Koks was miles ahead with his set against Bremseth's top pair and had his opponent drawing dead on the turn. The river completed the action and Koks doubled through Bremseth with a full house.

Player		Chips	Progress
Andrey Koks		90,000	72,000
Morten Bremseth		40,000	10,000

15:26 (UTC+0)

Start of Level 8
Blinds: 600/1,200 Ante: 1,200

Set of Fives for Hasson Posted Wednesday 20th September, 2023 at 15:11(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 74/104

Pavel Solodovnikov check-raised the turn with close to 20,000 in the pot already from 10,500 to 23,500. Ori Hasson tanked for a minute before he called.

Solodovnikov bet 25,000 on the river and Hasson called. Solodovnikov turned over the to win the hand against his opponent's .

Although Solodovnikov did have around 20,000 after the hand, this didn't last long as a couple of hands later he was noticed leaving the tournament arena.

Player		Chips	Progress
Ori Hasson		185,000	95,000
Pavel Solodovnikov		0	0

Big Slick No Good for Mika Posted Wednesday 20th September, 2023 at 15:07(UTC+0) by Jason Glatzer

Level 7: 500/1,000 (1,000)
Entries: 78/104

Ramunas Mika called off his stack of less than 15 big blinds after David Spysschaert three-bet jammed from the big blind.

Ramunas Mika:
David Spysschaert:

Spysschaert connected with his ten on the runout to send Mika to the rail.

Player	Chips	Progress
David Spysschaert	60,000	10,000
Dmitri Dudakov	0	0
Ramunas Mika	0	0

14:47 (UTC+0)

Start of Level 7
Blinds: 500/1,000 Ante: 1,000

Big Stacks Update Posted Wednesday 20th September, 2023 at 14:43(UTC+0) by Alaxandar Georgiev

Check some of the bigger stacks we have on Day 1b below.

Player	Chips	Progress
Mauri Dorbek	160,000	110,000
Kelly Kellner	130,000	3,000
Semjons Karuckis	130,000	10,000
Georgios Skarparis	125,000	75,000
Juho Suutari	100,000	50,000
Nedas Nanys	93,000	43,000
Ori Hasson	90,000	40,000

Second Break Posted Wednesday 20th September, 2023 at 14:28(UTC+0) by Jason Glatzer

Players are on their second break of the day. Big stack will be updated in the blog at the break.

Mis-Click Elimination Posted Wednesday 20th September, 2023 at 14:16(UTC+0) by Alaxandar Georgiev

Julian Selinger thought he opened to 1,700 and Mustafa Biz called from the lojack, shortly after the dealer saw that he put 15,200 instead and the raise was valid, so Mustafa had to decide if he wanted to call that or not and he made the call.

To the flop it was Selinger's decision and he put another 15,000 followed by a call by Mustafa.

Julian Selinger:
Biz Mustafa:

The turn was and the river changed nothing for Mustafa.

Selinger won over 25,000 chips by "miss-clicking" his way to victory.

Player		Chips	Progress
Julian Selinger		65,000	15,000
Mustafa Biz		0	0

100 Entries! Posted Wednesday 20th September, 2023 at 14:10(UTC+0) by Jason Glatzer

Level 6: 400/800 (800)
Entries: 86/100

Day 1b has reached 100 entries during Level 6. This is still a little shy of the 139 entries Day 1a ended with still more than four levels remaining in Day 1b.

14:02 (UTC+0)

Start of Level 6
Blinds: 400/800 Ante: 800

One Outer for Nurme Posted Wednesday 20th September, 2023 at 13:38(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 84/94

There was 50,000 in the pot including the entire stack of 25,000 held by Toomas Nurme committed on the flop in a hand against Ronny Albrigtsen.

Toomas Nurme:
Ronny Albrigtsen:

Albrigtsen pulled far ahead after improving to trips on the turn leaving his opponent to just one out. The one outer came with the case spiking the river for Nurme to double his stack instead of hitting the rail.

Player		Chips	Progress
Toomas Nurme		50,000	10,000
Ronny Albrigtsen		50,000	26,500

No "One-Time" for Koks Against Albrigtsen Posted Wednesday 20th September, 2023 at 13:30(UTC+0) by Jason Glatzer

Level 5: 300/600 (600)
Entries: 85/94

There was already 20,000 in the pot when Andrey Koks checked with the on the board. Ronny Albrigtsen bet 6,000. Koks tanked before he called.

"One time, one time," Koks pleaded.

Koks let out a loud sigh after the completed the board on the river and checked. Albrigtsen checked it back and won the hand after showing .

"You had a five?" Albrigtsen asked?

Koks shared he did but we will never know if that was the case as his cards went into the muck.

Player		Chips	Progress
Ronny Albrigtsen		76,500	26,500
Andrey Koks		18,000	42,000

13:03 (UTC+0)

Start of Level 5
Blinds: 300/600 Ante: 600

Kings Full Good for Tousloftas Posted Wednesday 20th September, 2023 at 13:01(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 82/89

The second Day 1b bullet for Georgios Tsouloftas (pictured below) has gone far better than the first bullet as he has around double the starting stack during Level 4.

Kare Hallamaa fired out for 4,200 into a pot of a bit more with the on the board. Tousloftas tanked for a short time before raising to 15,000. Hallamaa quickly called only to muck after Tousloftas turned over the to win the hand.

Player	Chips	Progress
Georgios Tsouloftas	100,000	55,000
Ronny Albrigtsen	50,000	0
Martin Lategui	50,000	0
Martin Piik	40,000	10,000
Kare Hallamaa	30,000	20,000

Two Pair for Martinsen Posted Wednesday 20th September, 2023 at 12:46(UTC+0) by Jason Glatzer

Level 4: 200/500 (500)
Entries: 78/85

Johan Martinsen (pictured below) checked with nearly 15,000 in the pot and the on the board. Victor Fernandez Garcia tanked for a couple of minutes before he bet 10,000.

Martinsen snap-called. Garcia turned over the which proved to be no match for the two-pair by Martinsen with .

Player		Chips	Progress
Johan Martinsen		75,000	25,000
Victor Fernandez Garcia		65,000	15,000

12:22 (UTC+0)

Start of Level 4
Blinds: 200/500 Ante: 500

First Break Posted Wednesday 20th September, 2023 at 12:03(UTC+0) by Jason Glatzer

Players are on their first 20-minute break. Blinds will increase to 200/500 with a 500 big blind ante when the action resumes.

Karuckis Ousts Two to Take Early Day 1b Chip Lead Posted Wednesday 20th September, 2023 at 12:03(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 70/76

Semjons Karuckis just won a couple of flips to take the chip lead off a sub-starting stack for nearly triple the starting stack.

The first flip came after he four-bet jammed with and was called by Rene Peterkopf with . The flop was looking good for Peterkopf but he wasn't able to come back after falling behind on the turn with the river completing the board.

Shortly after, Karuckis with took the 8,500 remaining in his stack held by Peterkopf with along with a bigger stack held by Vladimiras Meckovskis with . Both of Karuckis's opponents bricked board to send them packing while snagging the early Day 1b chip lead.

Meanwhile, Kelly Kellner also built up his stack further. He shared with us he flopped a set of jacks on a with two diamonds with the turn put a third diamond on the board. The stacks went in on the turn and his opponent turned over the with no diamond. No ten came on the river and Keller was up to 127,000 after the hand.

Player	Chips	Progress
Semjons Karuckis	140,000	90,000
Kelly Kellner	127,000	57,000
Vladimiras Meckovskis	0	0
Rene Peterkopf	0	0

Video Recap From Day 6 Posted Wednesday 20th September, 2023 at 11:53(UTC+0) by Jason Glatzer

Trips for Rasanen Posted Wednesday 20th September, 2023 at 11:43(UTC+0) by Jason Glatzer

Level 3: 200/400 (400)
Entries: 68/70

Two players checked before Georgios Tsouloftas, who re-entered after hitting the rail during Level 2, bet 1,500 into a pot of a bit more with the on the flop. Tomi Rasanen, Pavel Solodovnikov, and Dmitri Dudakov all called.

The action slowed down the rest of the way with all four players checking down the turn and the river.

Solodovnikov turned over the which led Dudakov and Tsouloftas to muck their cards. Meanwhile, Rasanen had something up his sleeve and turned over the for trip fours to scoop the pot.

Player	Chips	Progress
Tomi Rasanen	65,000	15,000
Dmitri Dudakov	60,000	10,000
Pavel Solodovnikov	50,000	0
Georgios Tsouloftas	45,000	5,000

11:27 (UTC+0)

Start of Level 3
Blinds: 200/400 Ante: 400

Arnhold Eliminates First Player of the Day in Tsouloftas Posted Wednesday 20th September, 2023 at 11:16(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 61/63

Cyprus's Georgios Tsouloftas was the first player on the rail for Day 1b.

Tsouloftas check-raised a bet of 2,300 into a pot of a bit more by Henry Arnhold to 10,000 with the on the board after the turn and Arnhold called to see the river.

Tsouloftas bet 15,000 and Arnhold went into the tank for nearly a minute before he opted to jam over the top more than covering the around 25,000 or so his opponent had behind. A few minutes went by before Tsouloftas tossed a chip in to call.

Arnhold immediately turned over the nuts with for a straight and eliminated Tsouloftas who still has plenty of time to re-enter who was good until the river with a set with .

Player	Chips	Progress
Henry Arnhold	100,000	50,000
Mustafa Biz	0	0
Georgios Tsouloftas	0	0

Nut Flush for Kellner Posted Wednesday 20th September, 2023 at 10:59(UTC+0) by Jason Glatzer

Level 2: 100/300 (300)
Entries: 54/54

While none of the Day 1b players has yet to hit the rail, Canada's Kelly Kellner has managed to chip up to 70,000 in chips.

Kellner shared that he had in a hand against Priit Parmasto. There were two diamonds on the flop and four on the board with more diamonds coming on the turn and river. Parmasto fired out for 10,000.

A rainbow raise, that Kellner is known for, meaning one chip of each color representing a raise to 31,600. Parmasto opted to fold and good for him he did as Kellner showed the table he had the goods by flashing the before the next hand began.

WSOPC Tallinn Host Evely Pihela interviewed Kellner earlier in the week. Check out the interview below:

Player		Chips	Progress
Kelly Kellner		70,000	20,000
Priit Parmasto		35,000	15,000

10:50 (UTC+0)

Start of Level 2
Blinds: 100/300 Ante: 300

"I Really Want to Raise..." Posted Wednesday 20th September, 2023 at 10:37(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 44/44

Toomas Nurme bet 800 into a spread pot of 100 chips of around 2,000 with the on the board after the turn. Andrey Koks raised to 2,000 and Nurme opted to call to see the river.

Nurme fired out for 4,200 and Koks tanked for about a minute before eventually attempting to begin a dialogue with Nurme.

"I really want to raise," Koks said. "But you might have fives or something."

Seconds later, Koks opted to just call and not raise.

Nurme turned over the for two pair. Koks then showed his to win the hand with trip deuces.

Player		Chips	Progress
Andrey Koks		60,000	10,000
Toomas Nurme		40,000	10,000

Helppi in the PLO Ring Event Posted Wednesday 20th September, 2023 at 10:22(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 39/39

Juha Helppi shared with the media last night that he planned to hop into Day 1b of the Main Event after losing his big stack on Day 1b thanks to bad beats and coolers to a pair of Estonian players.

Helppi was just spotted during the opening moments of Event #8: €1,100 Pot-Limit Omaha 4 & 5 Cards.

"I saw the PLO on the schedule and decided to hop into this instead," Helppi shared from the table. "I will get back into the Main Event tomorrow."

While we won't have the presence of Helppi today in the Main Event, many other players will get into the action. Below is a quick look at the early entries in the field.

Player		Chips	Progress
Kelly Kellner		50,000	0
Vilius Zabarauskas		50,000	0
Roberts Rumba		50,000	0
Vygerdas Jonikas		50,000	0
Priit Parmasto		50,000	0
Martin Sedlak		50,000	0
Raivo Pinsel		50,000	0
Steven Seller		50,000	0
Todd Jatras		50,000	0

Cards in the Air Posted Wednesday 20th September, 2023 at 10:06(UTC+0) by Jason Glatzer

Level 1: 100/200 (200)
Entries: 29/29

Day 1b of the Main Event kicked off after the preliminary announced by WSOPC Tallinn Tournament Director Teresa Nousiainen with 29 players in their seats when the first cards were dealt.

Best of luck to all of the Day 1b players.

Welcome to Day 1b of the WSOPC Tallinn Main Event Posted Wednesday 20th September, 2023 at 08:24(UTC+0) by Jason Glatzer

It is another big day for the inaugural World Series of Poker Circuit (WSOPC) Tallinn with the second of four opening flights of the 2023 WSOPC Tallinn €1,500 Main Event starting its action on Tuesday at noon. Not only will a player win a coveted WSOPC gold ring but also a lion's share of what promises to be a massive prize pool with a €1 million guarantee slapped on this event.

The four-day Main Event is a deep-stacked affair boasting four opening flights from Sept. 19-21 with players starting with 50,000 in opening chips. Blinds increase slowly at every 40 minutes during the first three opening flights with the final opening flight moving along a little quicker with 30-minute blind levels.

Players will have plenty of opportunities to accumulate chips with unlimited re-entries permitted throughout the four opening flights and during the first two blind levels of Day 2. The battle will continue on Sept. 22-24 until the first-ever WSOPC Tallinn Main Event winner is crowned.

We will see many big names, including Finnish poker legend and two-time WSOP bracelet winner Juha Helppi (pictured below), who built up a big stack yesterday only for bad beats and coolers to take it away, hunting for the Main Event gold ring awarded to the winner along with a healthy top prize and an invitation to a $1 million guaranteed 2023 WSOP Tournament of Champions freeroll where a WSOP bracelet is on the line.

Day 1a attracted 139 entries with 63 players advancing to Friday's Day 2. Finland's Joni Rantamaki currently sits on top of the leaderboard after bagging a Day 1a chip leading stack of 272,000.

Our coverage starts at noon with blinds at 100/200 and a 200 big blind ante. Follow the Main Event journey throughout the week while we report the biggest hands, bad beats, and stories until a winner is crowned.

08:19 (UTC+0)

Day 1B of WSOPC Tallinn Started
Level: 1 Blinds: 100/200 Ante: 200

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

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.

Browse

Useful Links

Subscribe to our newsletter