WSOP Circuit Events - WSOPC Tallinn - Live Coverage

        
0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0064 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est/1C/updates'
ORDER BY `views` DESC

0.0090 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est/1C/updates'

0.0002 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'

0.0001 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.0001 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.0003 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0004 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

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

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

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

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.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.0126 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.0008 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_event1_est'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'

0.0236 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0080 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '95'
AND `published` = 1

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

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

0.0430 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0077 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '110'
AND `published` = 1

0.0253 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0052 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '114'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
AND `name` = '1C'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0050 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4470'
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` = '4469'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0052 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '114'
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 #1: €555 No-Limit Hold'em (Estonian) Live Reporting - Day 2

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 25 Current Day 2

Blinds 20,000/40,000 Ante 40000

Entries 382 Remaining 1

Prize Pool (EUR) €183,360 First Prize (EUR) €34,435

Chip Leaders Day 2

1	Viacheslav Sultanov		11,460,000

Day 1A Day 1B Day 1C Day 1D Day 2

1 New Update - Click to refresh

Live Updates - Day 1C

Eestlaste stäkid päeva 1C järel Posted Friday 15th September, 2023 at 19:03(UTC+3) by maheaaatom

Päeval 1C tehti 123 sisseostu ning üles elas selle koguni 76 mängijat. Nii kõrget "ellujäämise protsenti" pole olnud ei päeval 1A ega 1B. Eestlasi jätkab 23, koos päevadega 1A ja 1B on neid seega kokku 39.

Päevade 1A, 1B ja 1C peale kokku on tehtud meie arvestuse kohaselt 224 sisseostu ning edasipääsejaid on kokku 125. Lisa on aga oodata päevast 1D ning ka homsest, sest esimese kahe taseme jooksul on samuti sisseostud lubatud.

Oleme tagasi kell 19:00 ning jätkame siis juba Ring Event #1 neljanda ehk viimase alagrupiga (1D).

Player	Chips	Progress
Igor Pihela noorem	109,000	79,000
Arko Akenpärg	100,500	70,500
Mario Jürgens	90,500	60,500
Viktor Blinov	89,500	59,500
Urmo Velvelt	89,500	59,500
Janek Tammsaar	78,500	48,500
Tanel Evert	52,000	22,000
Martin Venno	51,000	21,000
Janar Kokk	40,500	0
Maksim Petrov	40,000	500
Maikel Homin	38,500	8,500
Danel Kunman	35,500	5,500
Marko Vest	35,000	5,000
Tanel Koht	34,000	4,000
Marten Oks	33,000	3,000
Aleksei Smirnov	29,000	1,000
Siim Suviste	28,500	1,500
Tarmo Tammel	27,000	3,000
Andrei Mjagkov	26,000	4,000
Hanno Kerem	25,000	5,000
Ermo Kosk	25,000	5,000
Kaur Ajamaa	24,000	36,000
Oskar Ojaveer	22,500	7,500

Iga käsi võib võita Posted Friday 15th September, 2023 at 18:42(UTC+3) by maheaaatom

Üsna paljudel mängijatel on kombeks viimaste kätega suruma minna, sest lõppude lõpuks, mis mõte on ministäkiga teist päeva alustada?

Mario Jürgensil oli enne viimast jaotust 28K, mis üsna võrdne algstäkiga. Aga proovima ta ometi läks - -ga.

Vastas veel kolm all-in'i: , ja . Aga lauda kenasti rida ja Mario saigi ühtäkki mäele.

Nüüd on päev 1C läbi ning ootame lõplikku stäkkide seisu.

3 viimast kätt Posted Friday 15th September, 2023 at 18:34(UTC+3) by maheaaatom

Päev 1C läheneb lõpule, turniiridirektor palus jagada välja kolm viimast kätt. Vahepeal on oma stäkist saanud lahti ka Ermo Kosk, kuid loomulikult tegi kuuekordne Eesti meister ka kohese re-entry. Küllap üritab ta viimaste kätega lisa saada.

Tarmole ikkagi re-entry. Aga õnnetult. Posted Friday 15th September, 2023 at 18:22(UTC+3) by maheaaatom

Tarmo Tammel läheb esimese duubli järele ning saab vägagi soodsa olukorra: seitsmed kolmede vastu.

Ja mis peamine, riverisse tuleb seitse ka. Kena punane ärtu seitse. Aga häda selles, et tegemist on neljanda ärtuga ning vastasel on ärtu kolm...

Midagi pole teha, tuleb re-entry ikkagi ära teha.

Käes on Omaha-aeg! Posted Friday 15th September, 2023 at 18:13(UTC+3) by maheaaatom

Fuajees pandi käima PLO 4/5 Cards, mida alustas 14 mängijat. Nende seas on ka kaks Eesti esindajat, Olympicu pokkeriklubi all-time regular nr. 1 nende seas. Kellega tegemist? Mõistagi vanameister Aleksandr Klepatšiga!

18:11 (UTC+3)

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

Tammel vajab kolme duublit Posted Friday 15th September, 2023 at 18:09(UTC+3) by maheaaatom

Tarmo Tammel on jäänud 1C-l üsna märkamatuks ning põhjus on lihtne - ega tal pole ka väga nuppe, millega mängida. Hetkel vireleb Tarmo umbes 5K stäkiga ning vajab enda sõnul kolme duublit, et keskmise peale saada.

Teisalt on Tarmo jälle see mängija, kes isegi väikese stäki ja re-entry võimaluse olemasolul oma nuppe niisama tuulde ei pillu ega asjatult gämblema ei lähe. Hoiab üsna visalt igast oma nööbist kinni.

Dmitri kaotas oma nupud Igorile, Jesuse ebaõnn jätkus Posted Friday 15th September, 2023 at 17:58(UTC+3) by maheaaatom

Dmitri Dudakov lükkas oma viimased 10K sisse -ga ning sai calli Igor Pihela -lt.

Lauda veel üks kuningas. "Sa said ühe-oudise," naerdi lauast.

Kõrvallauas jätkus Jesus Martineze tragöögia. Ta sai küll sisse kuningatega Kazimieras Ramaska vastu, kuid viimasel õnnestus turni äss tõmmata. Meeste stäkid olid üsna võrdsed, leedukal küll pisut enam. Eesti hispaanlane tänas konkurente viisakalt mängu eest ning suundus tuniirialalt välja. Kas re-entry järele?

Igoril on hea seis, Ermo naudib massaaži, Martin Venno duubeldas Posted Friday 15th September, 2023 at 17:51(UTC+3) by maheaaatom

Põgus pilguheit eestlaste stäkkidele näitab, et igati heas seisus on Igor Pihela noorem, kel umbes 100K. Nurgatagune "eestlaste laud" on laiali löödud, selle rikkaim mees Kaur Ajamaa istub nüüd uues lauas 75K stäkiga. Ermo on ka natuke tõusnud (50K) ning on teadaolevalt esimene mees, kes massööridele tööd annab.

Ka Martin Vennol õnnestus just duubel saada läbi Eesti hispaanlase Jesus Martinezi. Nupud läksid enne floppi, Martin oli ees (ässad versus emandad) ning ette ta ka jäi.

Player		Chips	Progress
Igor Pihela noorem		110,000	80,000

17:41 (UTC+3)

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

Aeg valmistuda Omahaks Posted Friday 15th September, 2023 at 17:41(UTC+3) by maheaaatom

Tänane kõrvalturniir, 350 € PLO 4/5 Cards algab kell 17:00 ehk umbes 20 minuti pärast. Alustatakse 30 000 punktiga, tasemed vältavad 20 minutit ning re-entry periood kestab kuni kaheksanda taseme lõpuni.

Kuna tegemist on kõrvalturniiriga, siis olgu igaks juhuks öeldud, et võitjale WSOP sõrmust ei anta.

Kas teadsite, kes võitis esimese WSOP Circuit'i? Posted Friday 15th September, 2023 at 17:36(UTC+3) by maheaaatom

WSOP Circuit algas 2005. aastal jaanuaris Atlantic Citys ning sarja esimese põhiturniiri võitis Kanada esindaja Nghi Tran, kes saigi seal oma karjääri suurima võidu.

Kokku on see mees teeninud live-pokkeriga ligi 1,93 miljonit dollarit. Hoopis tuntumad tegijad jäid tollal aga tema selja taha - kahekordne maailmameister ja kahe WPT põhiturniiri tšempion Erick Lindgren oli teine, Chad Brown seitsmes ning kuue WSOP käevõru omanik Chris Ferguson kaheksas. Ferguson krooniti muide juba järgmise WSOP Circuit põhiturniiri võitjaks.

WSOP Circuit esimesel hooajal viidigi läbi vaid viis turniiri. Neist viimasel, New Orleansis, osales ka Imre Leibold, kus saavutas mälestusväärse seitsmenda koha. Selle turniiri võitis Walter Chambers, hilisem maailma esinumber Antonio Esfaniari oli kolmas.

1C viimane mängutsükkel Posted Friday 15th September, 2023 at 17:16(UTC+3) by maheaaatom

Kolm viimast taset on veel mängida ning kuna keskmine stäkk on nüüd 50xBB, siis võime oodata pisut teravamat actionit.

Laudades 84 mängijat, alustajaid oli 113.

17:14 (UTC+3)

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

Teine paus Posted Friday 15th September, 2023 at 16:53(UTC+3) by maheaaatom

Mängijad lubati teist korda puhkama. See on hea võimalus ka einestamiseks, sest OlyBet Bar and Grill pakub alates kell 16:00-st sooje toite. Eine maksab kõigest 10 eurot.

Mõned langejad ka: Janar Kokk, Alar Neemsalu, Hanno Kerem ja Arvo-Mart Elvisto. Lisandunud on aga netihai Aleksei Smirnov.

Sõna on Ermol Posted Friday 15th September, 2023 at 16:49(UTC+3) by maheaaatom

Äsja liitus turniiriga ka kuuekordne Eesti meister ning nii live- kui online-turniiridel erakordselt tugev harrastusmängija Ermo Kosk.

Ermo lööb aktiivselt kaasa ka hetkel OlyBetis toimuval megafestivalil WSOP Online 2023, kus saavutas eelmisel nädalal juba ühe kolmanda koha. Ega WSOP käevõru seega kuigi kaugele jäänud.

Aga Ermole võib WSOP Online'il terendada peagi veelgi suurem palgapäev. Nimelt jõudis ta MILLIONAIRE MAKER turniiril 100 parima hulka, kes asuvad võitjat selgitama luksuslikus Atlantis Resortis Bahamal. Mäng käib kolmele miljonile dollarile ning võitja saab täpselt miljoni. Mis aga peamine - Ermo alustab mängu suuruselt teise stäkiga.

"Positsioon peaks olema igati hea," lisab Ermo. "Lisaks on palju mängijaid, kes pääsesid Bahamale vaid mõne BB-ga." Ta pole ainuke eestlane, kes sinna sõidab, kindlasti on kambas ka Igor Pihela vanem.

WSOP Circuit'il on mehe fookus põhiturniiril, tänast turnat võtabki ta pigem soojendusena. Aga eks sõrmuse tahaks temagi sõrme saada.

Mängijaid aina lisandub Posted Friday 15th September, 2023 at 16:32(UTC+3) by maheaaatom

Oleme jõudnud juba 106 mängijani, meie omadest liitusid äsja Siim Suviste ning "betoonmees" Andrei Mjagkov.

Tähelepanuks neile, kes tahavad samuti mängida, kuid täna kohe kuidagi ei jõua - hiline regamine kestab kuni 12. taseme lõpuni, mis on kõigi eelduste kohaselt homme umbes kell 13:00-13:15. Siis tuleb muidugi arvestada üsna push-fold mänguga.

16:28 (UTC+3)

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

Eestlaste laud Posted Friday 15th September, 2023 at 16:16(UTC+3) by maheaaatom

Mäng käib tosinal laual, kuhu ühele on sattunud hämmastaval kombel kõik eestlased. Tõsi - ühe väikese erandina. Jesus Martinez elab samuti Eestis, kuid tegemist on ikkagi Hispaania pokkeriprofiga.

Laua chipliider on äsja sinna suunatud Kaur Ajamaa.

Väike struktuurimuudatus Posted Friday 15th September, 2023 at 16:04(UTC+3) by maheaaatom

Sarnaselt päevadele 1A ja 1B on tänagi kaks pausi, kuid kui eile olid teised pausid pärast 8-ndat mängutaset, siis nüüd pärast seitsmendat. Tundub mõistlik otsus.

Päevad on aga endiselt sama pikkusega, väldates koos pausidega 5 tundi ja 50 minutit. See tähendab, et ülekanne lõppeb tänagi pisut enne kella ühte ning pikem paus tuleb 6-7 vahel.

Saabusid norralased Posted Friday 15th September, 2023 at 16:01(UTC+3) by maheaaatom

Norrakatel on ikka meeldinud Eestis mängida ning nii ei saa imestada, et mitmeid neist on meelitanud kohale võimalus WSOP Circuit meistrisõrmus saada. Esimesed kolm 1C-l osalevat trollidemaa poega on igatahes lauas!

Esimese eestlane on nüüd ka mängust väljas, tegemist Martin Piigiga. Aga küllap Martin tuleb tagasi.

15:52 (UTC+3)

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

Pea täiesti meeste värk Posted Friday 15th September, 2023 at 15:52(UTC+3) by maheaaatom

Nüüdseks juba 101 1C-l osaleva mängija seas on vaid üks naine - soomlanne Anna-Mari Hursti. Tegemist on samas üsna tubli tegijaga, kes suutnud jõuda auhinnarahadesse nii tänavusel Kings of Tallinn kui Kings of Tallinn Summer Showdown põhiturniiril.

Eile proovis teatavasti kätt Jaana Kindsigo, võimalik et näeme teda ka uuel katsel.

WSOP Circuit naistepäev on järgmisel laupäeval, mil viiakse läbi 150 € Queens of Tallinn. Sellele saab kvalifitseeruda ka läbi samal päeval toimuva freezeout satika, millel osalemine on kõigile tasuta!

100 mängijat täis Posted Friday 15th September, 2023 at 15:46(UTC+3) by maheaaatom

Päeva 1C osalejate arv on jõudnud sajani ning väga lähedal oleme ka saja tuhandese auhinnafondi tähiseni.

"Ei tea palju õhtul (1D) mängima tuleb?" uurib Igor Pihela. Aga võib eeldada, et huvilisi saab siiski omajagu olema. Soome keelt on mängualal endiselt vähe kuulda, kuigi umbes kümmekond põhjanaabrit peaks juba laudades olema.

Taas Martin vs. Marten Posted Friday 15th September, 2023 at 15:37(UTC+3) by maheaaatom

Martin Venno ja Marten Oks omavahel madalaid panku ei mängi, kui juba - siis pannakse ikka täiega. Viimane jaotus oli üsna intrigeeriv.

Floppi vaadati 2200-ga.

Martin checkis ette, Marten pani 3000 ja sai calli.

Turni avati ning kordus sama, panused küll juba 5500 kummaltki.

River tegi asja juba eriti põnevaks. Lauas neli ristit, mida teha?

Martin checkis taas ning Marten ei leidnud pärast mõningast mõttepausi samuti jõudu panustamiseks. Kui Martin avas , rehmas Marten pahaselt käega. Tal nimelt

15:21 (UTC+3)

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

Esimene paus Posted Friday 15th September, 2023 at 15:02(UTC+3) by maheaaatom

Mängijad lubati 20 minutiks puhkama ning kuna samal ajal siin midagi muud ei toimu, siis puhkame meiegi.

Auhinnafond läheneb sajale tuhandele Posted Friday 15th September, 2023 at 14:55(UTC+3) by maheaaatom

Turniiri auhinnafond on juba 96 000 eurot ning jätkub paisumist, 100 tuhande tähis saab küllap juba õige pea ületatud.

Eestlastest veel juures Maikel Homin, Martin Piik ja Marko Vest. Väljalangejaid (re-entry tegijaid) on hetkel viis ning kuni keskmine stäkk on veel üle 100XBB, siis enamasti mängitakse suhteliselt rahulikult.

Kaur on väga agressiivne Posted Friday 15th September, 2023 at 14:39(UTC+3) by maheaaatom

Neljadas lauas on selgelt kõige agressiivsem mängija Kaur Ajamaa. Kauri mängitud pangad on suured, on ta käinud ta all-in'is ning võitnud mõned õige kõrgete pottidega jaotused. Eks midagi on ära ka andnud, kuid mehe stäkk on umbes kaks korda suurem kui mängu alguses.

Player		Chips	Progress
Kaur Ajamaa		60,000	30,000

14:36 (UTC+3)

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

Tervitame Tõusva Päikese Maa mängijaid! Posted Friday 15th September, 2023 at 14:36(UTC+3) by maheaaatom

Turniirile on saabunud ka väike jaapanlaste delegatsioon.

Kolmest mängijast tuntuim on Ken "King" Okada, kes võitnud live-turniiridelt üle 400 tuhande dollari, peamiselt Aasias toimunud turniiridelt. WSOP käevõru ega sõrmust tal aga veel ei ole.

Hirmkuulsaid pokkerimängijaid Jaapanis ei ole. Rahalist tipus on Tsugunari Toma 2,8 miljoni dollariga, pokkerimiljonäre on selles Eestist pea sada korda suuremas riigis 14.

Kohe paugutama Posted Friday 15th September, 2023 at 14:28(UTC+3) by maheaaatom

Turniirile saabunud Martin Venno alustab kohe esimest kätt 1000 tõstega (5XBB), kuid BB-l istuv Marten Oks re-raise'ib 3000-le.

Flop on . Martin ei kõhkle, vaid viskab kohe lauda 5000. Marten vastab suhteliselt kiire all-in'iga ning kuigi Martinil on rohkem, ta callima ei kipu.

Kiire mäng, suured panused, just seda me ootame!

Veel nimekaid Eesti mängijaid Posted Friday 15th September, 2023 at 14:16(UTC+3) by maheaaatom

Oleme jõudnud juba 75 sisseostuni ning mängijatega on lisandunud live-turniirdel alati ohtlik Dmitri Dudakov, EMV 2022 põhiturniiri teine Arvo-Mart Elvisto, kolmakordne Eesti meister Hanno Kerem ja pokkeriproff Oskar Ojaveer. Action käib üheksal laual.

Osalejate geograafia on lai Posted Friday 15th September, 2023 at 14:14(UTC+3) by maheaaatom

Lisaks eestlastele, lätlastele, leedulastele, soomlastele ning mõistagi ka HISPAANLASTE on turniiril väga erinevate riikide esindajaid. Näiteks Hong Kong, Gambia, Kreeka, Iisrael, USA, Kanada. On ka ukrainlasi.

14:02 (UTC+3)

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

Veel suuri meistreid Posted Friday 15th September, 2023 at 14:02(UTC+3) by maheaaatom

Turniirile on saabunud ka Eesti rahalistis vastavalt 14. ja 17. kohta hoidvad Igor Pihela noorem ja Tarmo Tammel, kelle nimed tuttavad kõikidele Eesti pokkerimängijatele. Kuna mõlemad on väga aktiivsed mängijad, näeme neid küllap kogu festivali vältel sõrmuseid jahtimas.

Igor Pihela vanem jõudis muide teise päeva üsna viisaka 81K stäkiga, saame näha, kas poeg on seekord kõvem kui isa või mitte.

Hetkel turniiril juba 66 sisseostu. Kaks mängijat on juba pidanud ka re-entry tegema, kumbki pole eestlane.

Urmole sobivad nii käevõrud kui sõrmused Posted Friday 15th September, 2023 at 13:44(UTC+3) by maheaaatom

Lauas on ka esimene tõeline Eesti pokkerikuulsus Urmo Velvelt. Eeskätt on tegemist high-stakes online-mängijaga, kel ka üks WSOP finaallaud. 2020. aastal sai ta 5000 $ 6-max turniiril neljanda koha ning teenis üle 200 tuhande dollari.

Tuletagem aga meelde, et just Urmo oli parim eestlane juulis lõppenud Kings of Tallinn Summer Showdown põhiturniiril, kus ta saavutas kolmanda koha. Suurematest turniiridest on ta võitnud ka Unibet DeepStack Open ning 888poker Live põhiturniirid Tallinnas. Seega pole vähimatki kahtlust, et tegemist on ka väga tugeva live-mängijaga.

Uksed on valla Posted Friday 15th September, 2023 at 13:36(UTC+3) by maheaaatom

Tänane päev erineb ikka märkimisväärselt eilsest. Uksed on valla ning pea iga minut siseneb sealt uus pokkerimängija. Lisandunud on ka omajagu eestlasi nagu Tanel Evert, Janar Kokk, Danel Kunman, Alar Neemsalu, Marten Oks jt.

13:31 (UTC+3)

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

Mis on täna kavas? Posted Friday 15th September, 2023 at 13:31(UTC+3) by maheaaatom

Täna mängime siis kaks 555 € turniiri avapäeva, 1C ja 1D (viimane algab kell 19:00). Levelid ikka 30 minutit, algstäkk 30 000 punkti ning piiramatu re-entry.

Täna kell 17:00 algab päeva ainus kõrvalturniir - 350 € PLO 4/5 Cards. Sel turniiril sõrmust ei saa!

Ka satelliite on kaks nagu eilegi, neil mõlemal on eriti magusad auhinnad:

- Kell 21:00 algab 150 € mega-satikas põhiturniirile, 10 kohta GTD!

- Kell 23:00 algab 60 € satikas homsele 1100 € NLH Ring Eventile, 5 kohta GTD

Tagasivaade eilsele päevale Posted Friday 15th September, 2023 at 13:25(UTC+3) by maheaaatom

Nagu eeldada võis, polnud festivali esimene päev just kuigi osalejaterohke, sest eestlastel on töönädal ning väliskülalised alles hakkavad Tallinnasse saabuma. 555 € Ring Event päevadel 1A ja 1B tehti ühtekokku 101 sisseostu ning umbes pooled (49 mängijat) suutsid avapäeva ka üle elada. Turniiri kindel liider on Eesti mees Raivo Pinsel.

Kõrvalturniire oli vaid üks - 150 € "hiinaka" esikoht läks Saksamaale, kuid pjedestaalile jõudis ka üks eestlane, endine Olympic Park Casino boss Jaan Vaabel sai kolmanda koha.

10 garanteeritud piletiga põhiturniiril satelliidil tekkis korralik 4200-eurone overlay (sisseost 150 €). Teiste seas sai pileti ka neljakordne Eesti meister Kristo Erala, kes oli ettenägelik ning tuligi overlay ootuses mängima.

Hilisõhtusel 66 € satelliidil hetkel käimasolevale turniirile overlayd ei tekkinud, välja jagati seitse piletit. Üks tuli ka Eestisse - selle sai Peeter Nooni.

Eestlased laudades Posted Friday 15th September, 2023 at 13:15(UTC+3) by maheaaatom

Kohe reporterite eest istub viimasel kahel EMV põhiturniiril finaallauda jõudnud Kaur Ajamaa, kes on tugev live-turnade mängija.

Lisaks temale hakkavad Eesti mängijatest silma ka Maksim Petrov ja Mario Jürgens Suhteliselt palju on leedukaid meie vana sõbra Vytautas Kacerauskesega eesotsas.

Tere tulemast päevale 1C Posted Friday 15th September, 2023 at 13:13(UTC+3) by maheaaatom

Oleme tagasi Olympic Casinos ning päev 555 € Ring Event päev 1C on alanud. Täna algas kõik õigeaegselt ning põhjus selles, et Tallinnasse hakkavad vaikselt jõudma välismaalaste hordid.

Hetkel juba 43 mängijat.

13:10 (UTC+3)

Day 1C of WSOPC Tallinn Started
Level: 1 Blinds: 100/100 Ante: 0

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