0.0005 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0009 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/summer_showdown_celebrity_2023/1/updates', 1, '2024-12-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.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

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

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

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

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

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

0.0045 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.0006 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` = 'summer_showdown_celebrity_2023'

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '20'

0.0319 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0071 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '74'
AND `published` = 1

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

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

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

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` = '3677'
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` = '3676'
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` = '3675'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3669'
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` = '3668'
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` = '3667'
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` = '3665'
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` = '3664'
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` = '3663'
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` = '3662'
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` = '3661'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0080 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3628'
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` = '3627'
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` = '3625'
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` = '3624'
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` = '3623'
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` = '3621'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0107 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3617'
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` = '3616'
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` = '3615'
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` = '3614'
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` = '3613'
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` = '3611'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3607'
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` = '3606'
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` = '3603'
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` = '3601'
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` = '3600'
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` = '3598'
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` = '3596'
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` = '3594'
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` = '3592'
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` = '3590'
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` = '3589'
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` = '3588'
ORDER BY `chip_change` DESC, `busted` ASC

0.0171 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3587'
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` = '3586'
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` = '3585'
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` = '3580'
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` = '3577'
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` = '3494'
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` = '3493'
ORDER BY `chip_change` DESC, `busted` ASC

0.0063 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '74'
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` = '74'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

0.0169 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3672'
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` = '3671'
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` = '3670'
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` = '3669'
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` = '3668'
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` = '3667'
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` = '3665'
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` = '3664'
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` = '3663'
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` = '3662'
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` = '3661'
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` = '3660'
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` = '3659'
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` = '3657'
ORDER BY `chip_change` DESC, `busted` ASC

0.0172 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3656'
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` = '3655'
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` = '3654'
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` = '3653'
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` = '3652'
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` = '3651'
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` = '3650'
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` = '3649'
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` = '3648'
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` = '3647'
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` = '3646'
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` = '3645'
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` = '3644'
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` = '3643'
ORDER BY `chip_change` DESC, `busted` ASC

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

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` = '3640'
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` = '3639'
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` = '3638'
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` = '3636'
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` = '3635'
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` = '3633'
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` = '3631'
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` = '3628'
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` = '3627'
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` = '3625'
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` = '3624'
ORDER BY `chip_change` DESC, `busted` ASC

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

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` = '3621'
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` = '3619'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0090 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3614'
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` = '3613'
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` = '3611'
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` = '3610'
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` = '3608'
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` = '3607'
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` = '3606'
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` = '3603'
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` = '3601'
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` = '3600'
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` = '3598'
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` = '3596'
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` = '3594'
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` = '3592'
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` = '3590'
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` = '3589'
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` = '3588'
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` = '3587'
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` = '3586'
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` = '3585'
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` = '3580'
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` = '3577'
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` = '3494'
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` = '3493'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084

    

Open Modal

Hi,

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

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

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

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

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

• £   GBP
• $   USD
• €   EUR

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

Login / Register

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

English

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

• £   GBP
• $   USD
• €   EUR

Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) Live Reporting - Day 1

Kings of Tallinn Summer Showdown 2023 - Live Reporting

2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) See other events

2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event

---

Current Level 0 Current Day 1

---

Blinds - Ante -

Entries 352 Remaining 1

---

Prize Pool (EUR) €43,014 First Prize (EUR) €8,700

Chip Leaders Day 1

Day 1

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 1

Mehed sõlmivad diili Posted Wednesday 26th July, 2023 at 02:42(UTC+0) by Mariliis Joras

Järel on kaks soomlast, kes soovivad omavahel rahakokkulepet sõlmida.

Algne plaan näeb ette, et Miko Miettinen võtab 8000 € ja Jari Kärkkäinenile jääb 7000 €, kuid mängu jätkatakse 200 € peale. Sellele plaanile tõmmatakse kriips peale, sest nii väikese vahe pärast pole mõtet diilerit kinni hoida. 

Floor pakub välja lahenduse, mis meestele sobib. 

Mikole läheb 7500 €, Jari võtab 6500 € ja mäng jätkub 1200 € peale. Nii on õiglane ja asjal ka mõte sees. 

Selle infoga tänaseks lõpetamegi. Lõplikud auhinnasummad saavad uuendatud homme. 

Suur tänu lugejatele, kes leidsid aega blogist läbi tulla. Ootame kõiki tagasi juba homme, mil stardib põhiturniiri esimene mängupäev. 

3. koht Tarjei Forus 4350 € Posted Wednesday 26th July, 2023 at 02:35(UTC+0) by Mariliis Joras

Kulub mitu katset, aga lõpuks saadakse Tarjei Forusest jagu. 

Mees peaks oma tulemusega igati rahule olema, arvestades fakti, et ta alles mõni minut tagasi avastas, et on top 3 sekka jõudnud.

4. koht Pierre Stefan Sven-Erik Bryhagen 3470 € Posted Wednesday 26th July, 2023 at 02:13(UTC+0) by Mariliis Joras

Aga ei, pole surematu ka Sven-Erik Bryhagen. Temast saab lõpuks jagu Tarjei Forus.

Kuidas kogu aeg välja imeda? Posted Wednesday 26th July, 2023 at 02:12(UTC+0) by Mariliis Joras

Tuleb küsida Sven-Erik Bryhageni käest, sest temal tuleb see välja lausa imeliselt. 

Stiilinäide:

Sven-Erik sunnitud all-inis -ga. 

Vastas

Boardile

5. koht Casimir Lucas M. Seire 2504 € Posted Wednesday 26th July, 2023 at 02:05(UTC+0) by Mariliis Joras

Ka Casimir Lucas M. Seire langeb ässade saagiks. Seekord on need Tarjei Foruse käes.

6. koht Lawend Mardini Himmo 1960 € Posted Wednesday 26th July, 2023 at 02:04(UTC+0) by Mariliis Joras

Lawend Mardini Himmo liigub all-ini ja saab calli. 

Jari Käskkäinen tõmbab varrukast järjekordse ässade pocketi ja teeb rootslase pihuks ja põrmuks.

7. koht Patrick Pfeiffer 1490 € Posted Wednesday 26th July, 2023 at 02:00(UTC+0) by Mariliis Joras

Patrick Pfeiffer läheb võimsa pauguga. 

All-ini callib BB-l istuv Miko Miettinen, kellel .

Mikole jookseb maha straight flush, nii et Patricku kaardid ei ole siin mitte vähimalgi määral olulised.

8. koht Jonas Lapinskas 1145 € Posted Wednesday 26th July, 2023 at 01:56(UTC+0) by Mariliis Joras

Paigast kangutatakse Jonas Lapinskas, kelle võtab ette Miko Miettinen. 

on parem kui ja seda ei muuda ka lauakaardid.

9. koht Aleksi Matti Juhana Halme 885 € Posted Wednesday 26th July, 2023 at 01:48(UTC+0) by Mariliis Joras

Selleks, et Aleksi Halme 9. kohale jääks, tuli jaotuses osaleda neljal mängijal.

Kõige pisema stäkiga oli muide hoopis Sven-Erik Bryhagen, kes on rongi all käinud ja sealt välja tulnud täna kordi ja kordi. Ja teeb seda nüüdki. 

saab ässale pihta ja stäkk neljakordistub. 

Aleksi midagi ei taba.

Ära ootab Posted Wednesday 26th July, 2023 at 01:44(UTC+0) by Mariliis Joras

Jari Kärkkäinen paneb oma 395 000 sisse, kui Tarjei Forus ees 125 000 tõstab. BB loobub. 

Saamegi sõitma.

Tarjeil , kuid Järi on ära oodanud ässade pocketi. See teenib duubli.

Vabandust, ma olen purjus Posted Wednesday 26th July, 2023 at 01:38(UTC+0) by Mariliis Joras

Niimoodi vabandab chipliider. 

Ja ta tõesti on. 

Kuigi norrakeelsest jutust aru ei saa, räägivad hääletoon ja intonatsioon enda eest.

Teistel on nuppe oluliselt vähem, mistõttu all-inid mõeldakse eriti pingsalt läbi ja ega neid tegelikult ei näe ka.

Keskmine stäkk on kukkunud alla 10 BB.

Üks kutsub padelit mängima Posted Wednesday 26th July, 2023 at 01:21(UTC+0) by Mariliis Joras

Mitte mind, vaid teid, head lugejad. 

Homme Viru Keskuses. Pokkerile on see hea vaheldus, et mõistust tuulutada.

Kolivad ühte lauda Posted Wednesday 26th July, 2023 at 01:18(UTC+0) by Mariliis Joras

Väike paus, et kõik jõuaks ümber kolida. Finaallaud on koos.

10. koht Aleksi Mikael Naski 690 € Posted Wednesday 26th July, 2023 at 01:17(UTC+0) by Mariliis Joras

Miko Miettinen on oma mängu leidnud. 

Tema saab flopist kaks paari ja Aleksi Naski, kellel väiksem stäkk, peab lauast tõusma. 

Viimane, kes veel 690 €-ga leppima peab, nüüd hakkavad rahad tõusma.,

Välja võlub Posted Wednesday 26th July, 2023 at 01:12(UTC+0) by Mariliis Joras

Üle pika aja on korraga kolm inimest all-inis. 

Väikseima stäkiga on Niclas Mjelstad, kes näitas terve turniiri tugevat mängu. Võimalik, et teda toetas ka kaardijooks, sest ühel hetkel hakkas kõik justkui allamäge vedama ja stäkk kuivas kokku. Kuid seni oli ta pikalt turniiri liider. Niclase kaardid on ja chippe väga vähe. 

Vastas Miko Miettinen -ga ning kolmas mees -ga. 

"Miks sa pead alati domineerima," küsib Miko retooriliselt ja hakkab endale siis kuningat välja võluma. Loits töötab. 

Niclas out, teiselt mehelt duubel.

Teeme siis niisama kokkuvõtteid Posted Wednesday 26th July, 2023 at 01:07(UTC+0) by Mariliis Joras

Eestlastele enam kaasa elada ei saa. See erineb kardinaalselt eelmisest Celebrity turniirist, mille võitis just Eesti mängija, Mark Metsla. 

Seekordne võitja võib olla potentsiaalselt neljast rahvusest. Meil on järel kaks norrakat, viis soomlast, kaks rootslast ja üks taanlane. 

Kahe mängija rahvus on märkimata, kuid nime järgi võib üks olla soomlane ja teine võib-olla et isegi lätlane. 

Nii inetut lõppu ei ole Martin ära teeninud Posted Wednesday 26th July, 2023 at 01:03(UTC+0) by Mariliis Joras

Martin Taska ootab kannatlikult ja võiks ju arvata, et see saab väärikalt tasutud... Ent juhtub täiesti vastupidine. 

Martini all-ini callib ära vastane -ga. Martinil endal .

Flop ja vastasel rida. 

Selliselt jääme ilma oma viimasest eestlasest ja see on väga kurb.

Player		Chips	Progress
Martin Taska		0	0

Keskmine stäkk vaid 10BB-d Posted Wednesday 26th July, 2023 at 00:59(UTC+0) by Mariliis Joras

Lars Nydegger kukub välja. Kui suure osa stäkist kaotab vs , mil vastasele mast, siis viimased kaardid lähevad suvalise kribuga. 

Nüüd on keskmine stäkk napilt üle 400 000, kuid BB juba 40 000. 

Üles ja alla Posted Wednesday 26th July, 2023 at 00:55(UTC+0) by Mariliis Joras

Täna läheb veel pikalt, sest kipub olema nii, et väiksed duubeldavad ja mäng ei lõpegi. 

Väga enesekindlalt callis üks mees teise all-ini ära kahtede pocketiga ja ütles veel juurde: "Deuces never lose."

Vastas olid soldatid. 

Floppi kohe kaks ja tundus, et nii ongi. Aga river soldat ja paneme edasi.

Vaid üks eestlane järel Posted Wednesday 26th July, 2023 at 00:47(UTC+0) by Mariliis Joras

Ian-Erik Valge callib ees tehtud tõste 60 000, mis on antud hetkel miinimumtõste. 

Nüüd liigub üks mängija all-ini, seejärel teine talle järele. Esialgne tõstja loobub, aga Ian-Erik tunneb, et on committed. Või siis meeldib see kaart talle väga. Oma -ga on nüüd temagi all-inis. 

Vastas emandad ja kolmed. 

Laud imesid ei tee ja emandate omanik vabaneb korraga kahest vastasest. 

Player		Chips	Progress
Ian-Erik Valge		0	0

Tapio out Posted Wednesday 26th July, 2023 at 00:32(UTC+0) by Mariliis Joras

Tapio Aaltonen loodab duubeldada kümnete taskuga. Vastasel , mis saab kokku kõrgema paari. 

Seekord siis sedapsi.

On käes järjekordne money jump. Järgmine väljakukkuja lahkub 450 €-ga. 

Kaks totakat duublit Posted Wednesday 26th July, 2023 at 00:26(UTC+0) by Mariliis Joras

Martin Taska maksab kaks korda samale mehele välja duubli seisust, kus tal endal on palju parem kaart kui vastasel. Lihtsalt õnne on pinginaabril rohkem. 

Martini stäkk on piisavalt kena, nii et katastroofi ei kaasne, aga rohkem taolisi lööke küll vastu võtta ei saa. 

Aitab heategevusest, on aeg tagasi võtta.

Mast ei tule kokku Posted Wednesday 26th July, 2023 at 00:20(UTC+0) by Mariliis Joras

Vladislav Topilskiy -l on lootust risti masti tabada. 

Vastane -ga on pihta saanud kümnele. 

Paraku viimast vajalikku ristit boardil ei avata. 

Vladislavi saagiks jääb 390 € auhinnaraha.

Player		Chips	Progress
Vladislav Topilskiy		0	0

Nii on hea pausilt tulla Posted Wednesday 26th July, 2023 at 00:13(UTC+0) by Mariliis Joras

Kui kohe käest kunnide pocketi leiad ja ka actioniks läheb, ei saa ju väga kurta.

Ian-Erik Valge all-ini callib maha kahtede pocketiga mängiv vastane. 

Laud seisu ei muuda. 

Asja ainus miinus on see, et Ian-Eriku stäkk ei ole just teab mis suur.

18 parimat pausil Posted Tuesday 25th July, 2023 at 23:55(UTC+0) by Mariliis Joras

15 minutit lubatakse mängijatel puhata. 

Nüüd mahutakse ära kahte lauda. 

Täname Tapiot Posted Tuesday 25th July, 2023 at 23:54(UTC+0) by Mariliis Joras

Tapio Aaltonen ei ole küll verelt eestlane, aga kodustatud soomlane on ta küll. Seetõttu elame kaasa ka tema edule. 

Äsja võttis ta ühe vastase välja ja seegi teeb rõõmsaks. 

sai pihta kolmikule. Vastase jõuetu.

Häid uudiseid ka vahele Posted Tuesday 25th July, 2023 at 23:51(UTC+0) by Mariliis Joras

Martin Taska toob meile häid uudiseid. 

Emandate pocket peab vastase -le vastu. 

Selle tulemusena üks mängija jälle vähem ja Martini stäkk suurem.

Player		Chips	Progress
Martin Taska		244,000	75,000

Keegi ei taha minna Posted Tuesday 25th July, 2023 at 23:45(UTC+0) by Mariliis Joras

Ja see on ka arusaadav, sest rahad on tõusmas alles 390 € peale. 

Just selle summaga peab aga üks Soome mängija leppima, kui shoveb -ga ja saab calli -lt. 

Kõrgem kaart seekord mängib.

Kaks eestlast korraga Posted Tuesday 25th July, 2023 at 23:32(UTC+0) by Mariliis Joras

3-way all-inis osaleb kaks eestlast ja üks soomlane. 

on Marius Morelil.

Marko Keskel mängib -ga. 

Soomlasel märksa kangem pocket - .

Kunnidest saab flopis set ja meie mehed ajavad end toolidelt püsti.

Player		Chips	Progress
Marius Morel		0	0
Marko Keskel		0	0

Geir-Kristjani auks Posted Tuesday 25th July, 2023 at 23:27(UTC+0) by Mariliis Joras

Vladislav Topilskiyl tekib võimalus Geir-Kristjan Suurpere stäki laastanud soomlasele kätte maksta. 

Tema ministäkki tahaks callida ka Ian-Erik Valge, kuid Vladislavi tõste kupatab teise jaotusest välja. 

Vladislavil -ga eduseis, sest vastas .

Flop on korraks kahtlane, kuid riverisse ja õiglus võidutseb.

Tõnis saab osa money jumpist Posted Tuesday 25th July, 2023 at 23:21(UTC+0) by Mariliis Joras

Tõnis Viik lõpetab 32. kohal ja teenib selle eest 340 €. 

Ta on küll esimene, kes saab miinimumist veidi rohkem raha, kuid ma võin kihla vedada, et ta eelistanuks pigem edasi mängida.

Player		Chips	Progress
Tõnis Viik		0	0

Hanno out Posted Tuesday 25th July, 2023 at 23:19(UTC+0) by Mariliis Joras

34. positsioonilt leiame Hanno Liiva. 

Juba pikemat aega vireles ta väikse stäki otsas. Kahjuks õnn ei pöördunud. Hanno peab samuti miinimumiga leppima.

Player		Chips	Progress
Hanno Liiva		0	0

Järjekordne traagika Posted Tuesday 25th July, 2023 at 23:17(UTC+0) by Mariliis Joras

Elades kaasa Geir-Kristjan Suurpere draamale jääb nägemata Mairold Millerti viimane käsi. Kahjuks on tema nimigi nüüd min cashi saanute nimekirjas...

Sellegipoolest oli ta kõige kaugemale jõudnud Eesti kuulsus ja selle üle saab ta vaid uhkust tunda.

Player		Chips	Progress
Mairold Millert		0	0

Vaja raudseid närve Posted Tuesday 25th July, 2023 at 23:15(UTC+0) by Mariliis Joras

Geir-Kristjan Suurperel on pocket, mis näib kenasti vastu pidavat, kuniks lahti tehakse river. Seal on kuningas, täpselt sobiv -ga mängivale vastasele. 

Duubli välja maksnud Geir-Kristjanile jääb järele 8000 žetooni, mis on väiksem kui BB. 

Kohe järgmise käega on ta all-inis ja leiab käest emandate pocketi - jumala hea koht tagasi tulemiseks, kas pole?

Vastas on Ian-Erik Valge -ga (ta on BB). 

Ja flop, palun väga, annab Ian-Erikule kaks paari. 

Geir-Kristjan peab leppima min cashiga.

Player		Chips	Progress
Geir-Kristjan Suurpere		0	0

Vähemalt pole mull eestlane Posted Tuesday 25th July, 2023 at 23:06(UTC+0) by Mariliis Joras

Mullimäng saab läbi sama kiirelt nagu algas. Selle positsiooniga ei pea vähemasti ükski eestlane leppima. 

Algas mullimäng Posted Tuesday 25th July, 2023 at 23:04(UTC+0) by Mariliis Joras

Kahjuks käivitab selle meie mängija. 

Maksim Petrov liigub all-ini -ga ja saab calli kolmedelt. 

Flop ei too oute mitte juurde, vaid võtab neid hoopis vähemaks. 

Päästvat kuningat ei tulegi.

Player		Chips	Progress
Maksim Petrov		0	0

Standard... Posted Tuesday 25th July, 2023 at 22:54(UTC+0) by Mariliis Joras

Herli Olopi lõpp on küll traagiline. 

Laua ja ilmselt terve turniiri suurim stäkk pigistab Herli pihtide vahele ja kuna Herlil käes , siis ei ole mingit foldimist. 

Vastas .

Lauda

"Standard minu jooks," kommenteerib Herli ise. Nii vähe jäi puudu!

Player		Chips	Progress
Herli Olop		0	0

Mull läheneb mühinal Posted Tuesday 25th July, 2023 at 22:48(UTC+0) by Mariliis Joras

Veel kuus mängijat jäävad täna tühjade kätega, kõik ülejäänud saavad kompensatsiooni. Kas suurt või väikest, on juba nende endi kätes.

Naxerile vajalik duubel Posted Tuesday 25th July, 2023 at 22:47(UTC+0) by Mariliis Joras

Kaks pocketit lähevad tantsule. 

Marko Keskeli on ees, vastas kolmed.

Laud täiesti ebaoluline ja suurem pocket peab. 

Player		Chips	Progress
Marko Keskel		107,000	46,000

Kellele kaasa elame? Posted Tuesday 25th July, 2023 at 22:41(UTC+0) by Mariliis Joras

Õnneks mõned tuttavad näod on, kelle edule kaasa elada. 

Player		Chips	Progress
Marius Morel		175,000	160,000
Martin Taska		169,000	154,000
Mairold Millert		114,000	60,000
Vladislav Topilskiy		87,000	72,000
Tõnis Viik		74,000	59,000
Maksim Petrov		73,000	58,000
Geir-Kristjan Suurpere		69,000	54,000
Herli Olop		67,000	52,000
Marko Keskel		61,000	46,000
Hanno Liiva		47,000	32,000
Ian-Erik Valge		46,000	31,000
Madis Ormisson		0	0
Kaidar Viikman		0	0
Ralf Rogov		0	0

Veel eestlasi läinud Posted Tuesday 25th July, 2023 at 22:24(UTC+0) by Mariliis Joras

Artur Külanurk on nüüdseks out. 

Hans Aare stäkk oli paarkümmend minutit tagasi just selline, et ellu jäämiseks tuli tegusid teha. -ga ta korra all-inis ka käis, kuid actionit ei saanud. Saagiks vaid blindid. 

Nüüdseks on paraku ka Hansu turniir läbi.

Veel halbu uudiseid Eestisse Posted Tuesday 25th July, 2023 at 21:51(UTC+0) by Mariliis Joras

Pärast pausi ei ole meiega enam jätkamas ei Kristi Kirsi, Gert Laanemetsa, Ander Heidmetsa ega Erio Ermanni.

Liigume pausile ilma Priiduta Posted Tuesday 25th July, 2023 at 21:48(UTC+0) by Mariliis Joras

Priit Pajusaar läheb all-ini kahe mehe vastu. 

Kaardiks , mis pole küll teab mis monster, aga ka mitte päris lootusetu. 

Ühel vastasel emandate pocket ja Priidul on šanssi isegi pärast floppi, kus on emand, nimelt võib ta veel tabada masti. Kuid riverisse potit ei tule. 

Eestlastest parim kuulsus on seega Mairold Millert! 

Mängijad nüüd 20 minutiks pausil.

Väljamaksed teada Posted Tuesday 25th July, 2023 at 21:41(UTC+0) by Mariliis Joras

Õige pea toome teieni ka väljamaksete suurused. 

Nii palju oskame kohe öelda, et rahaga lahkub 39 parimat ja esikohale on ette nähtud ei vähem ega rohkem kui 9100 eurot.

Herli teab, kuidas lohutada Posted Tuesday 25th July, 2023 at 21:38(UTC+0) by Mariliis Joras

Johanna Randmannil veab, et ta on ühes lauas just Herli Olopiga. Kuigi Johanna kukub välja, saab ta Herlilt kaasa lohutava kommentaari.

Floppi vaadati miinimumtõste 6000 eest. 

Boardile ja ees üks check. 

Johanna betib 5000, mille peale vastane shoveb. Johanna uurib diilerilt, mis võimalused tal on ja läheb siis ise ka all-ini. 

Johannal , vastasel .

Kohe turnis on kardetud poti ja sellest mülkast Johanna enam välja ei rabele. 

"Sa tegid kõik õigesti, sa olid ees," lohutab Herli. 

"Nii tore mäng!" õhkab aga Johanna, nii et võib-olla oleme ühe pokkerisõbra juurde saanud. 

Kaasas toeks olnud Jaanus Saks, kes ise juba mõnda aega tagasi välja kukkus, lahkutakse saalist hea emotsiooniga.

Ralf saab noosi Posted Tuesday 25th July, 2023 at 21:27(UTC+0) by Mariliis Joras

Boardil ja algab närvide mäng. 

Ralf Rogov ja Siim Siimson koos all-inis. 

Siimul . Üheksa õmbleks aukliku rea tervikuks. 

Ralfil .

Üheksat lauas ei avata, kuid kuningas tuleb. Ralfi eduseis kindel ja stäkk ka suurem.

Suurelt ei tooda, aga raisku ka ei lähe Posted Tuesday 25th July, 2023 at 21:19(UTC+0) by Mariliis Joras

Mairold Millert särab jälle ässade pocketiga. 

Seekord on tal vastas ministäkiga mees, kellel käes .

Flopis on küll kohe neli, aga ka äss. Nii et Mairoldil täiesti higistamisvaba jaotus. 

Paul andis nupud ise ära Posted Tuesday 25th July, 2023 at 21:07(UTC+0) by Mariliis Joras

Paul Koppe võttis enne Kristi Kirsilt duubli, aga andis intressidega tagasi. 

"Ise andis. Ajas minuga juttu ja arvas, et ma ei näe, mis ta teeb," kõkutab Kristi rõõmsalt tagantjärele. 

Marek Selgeveer on samuti sunnitud lõpetama. Tema viimsed riismed lähevad keskele -ga, kuid lauas ainult Broadway kaardid ja vastasel rida koos.

Mairoldi laastamistöö jätkub Posted Tuesday 25th July, 2023 at 20:59(UTC+0) by Mariliis Joras

Ei, Mairold Millerti hiiter pole lõppenud. 

Allan Pukk saab esimest korda täna pocketi. Need on kuningad ja see on just sobiv kaart, millega Mairoldi all-in ära callida. 

Viied on üsna nirus seisus. Aga seda vaid kuni flopini. Seal see vajalik viis ongi. 

Mairold vabandab Allani ees liiga tegemise pärast, lüüakse nukke ja Allan seab end lahkuma.

Seekord on Peeter parem Posted Tuesday 25th July, 2023 at 20:53(UTC+0) by Mariliis Joras

Rivaliteet Erkki Sarapuu ja Peeter Antsovi vahel on läbi. Seekord osutus paremaks Peeter. Õnneks nägi ta Erkki viimast jaotust pealt ja saab sellest meilegi rääkida. 

"A9o-ga läks all-ini. Pre. Vastas ässad," kõlas Peetri kokkuvõte. 

Boardilt polnud erilist abi oota, seda enam, et seal avati ka paki viimane äss.

Paul külvab segadust Posted Tuesday 25th July, 2023 at 20:49(UTC+0) by Mariliis Joras

Kus võimalus end ilmutab, seal Paul Koppe selle ka ära kasutab.

Ta saadetakse lauda nr 10 ja palutakse istuda kohale nr 2. Aga Pauli pea töötab teisiti. Kui tema näeb, et samas lauas kohal nr 8 on koht vaba Kristi Kirsi kõrval, siis sinna tema ka istuma potsatab. 

Floor on õnneks armuline ja teeb süsteemis vajalikud muudatused. 

Kristi on seltskonna üle rõõmus, aga sooviks Paulile vähem duubleid anda. Siis oleks asjal rohkem jumet.

Robi võtab suuna koju Posted Tuesday 25th July, 2023 at 20:34(UTC+0) by Mariliis Joras

Robert Rool lõpetab täna 200 parima hulgas. 

Kui mõnda aega tagasi tema laua juurest möödusime, ütles üks lauakaaslastest, et Robi on vaikne ja ettevaatlik, liiga palju jaotusi kaasa ei mängi. Aga paistab, et õnnest tuli seekord puudu, sest nüüd näeme meest saalist väljumas.

Vanad sõbrad jälle koos Posted Tuesday 25th July, 2023 at 20:31(UTC+0) by Mariliis Joras

Peeter Antsov ja Erkki Sarapuu ei ole veel välja selgitanud, kumb on laua kõvem mees. Vaeva selleks igatahes nähakse. 

Floppi vaadatakse 5000 eest (BB on hetkel 1000) ja selle summa eest on kaasas ka kolmas mees. 

Lauda ja kui Peeter checkib, siis Erkkilt 12 000.

Üks fold, Peetri kord. "No millele sa nüüd pihta said?" küsib ta Erkkilt, kes selget vastust ei anna. 

"All-in," põrutab nüüd Peeter. Erkkilt insta call. 

Peeter avab , Erkkil on . 

Lõpplahendus on split, sest boardile juurde ja .

Rekord löödud? Posted Tuesday 25th July, 2023 at 20:25(UTC+0) by Mariliis Joras

Paistab, et oleme löönud Celebrity Eventi rekordi. Veel kunagi pole sisseostude arv ulatunud üle 350, aga paistab, et täna see just nii on.

Lõplikud numbrid on veel kinnitamisel, kuid esialgsete andmete kohaselt tehti 352 sisseostu.

Auhinnafondi suuruseks näidatakse 43 014 eurot ja loomulikult on ka see rekordiline.

Kaardid jälle õhus Posted Tuesday 25th July, 2023 at 20:22(UTC+0) by Mariliis Joras

Paus sai läbi ja mängijad on tagasi laudades. 

Mairold Millertil oli vahepeal huvitav lugu rääkida. Tal on päris kobe stäkk, mis ulatub kahekordse keskmise kanti. 

Mõnusa lisa sai Mairold kahe keskmisest erilisema jaotusega. Kui ühel korral hittis ta -ga poissi ja võttis maha panga -lt, siis teisel korral hittis tema riveris setti, samal ajal kui vastase oli paari tabanud juba flopis. 

"Loodetavasti jätkub sellist õnne ka hilisemaks," avaldas ta lootust. 

Player		Chips	Progress
Mairold Millert		54,000	39,000

Korea kaotab parema kaardiga Posted Tuesday 25th July, 2023 at 19:57(UTC+0) by Mariliis Joras

Korea ehk Karl Kivastik mängib oma viimase käe kahe vastase vastu. 

Teda on püüdma tuldud nii kui -ga. 

Koreal endal

Võiks ju loota, et ehk seekord parem kaart ka peab, kuid kahjuks avatakse lauas kuus ja see kustutab Korea lootused. 

"Ma tulen ka kohe järgi," surub Jaanus Saks kaasvõitleja kätt ja viskab õhku kurjaendelise ennustuse. 

Viimased kolm kätt ja siis liigume pausile. Järgmisest levelist alates re-entryt enam teha ei saa.

Kristi saab oma revanši Posted Tuesday 25th July, 2023 at 19:51(UTC+0) by Mariliis Joras

Kristi Kirs pidi mõnda aega tagasi Maarja-Liis Ilusa kavalusele alluma, aga nüüd on aeg revanšiks. 

Kristi tõstab o-ga. 

Maarja on buttonil ja uurib, palju Kristil veel taga. 

"Okou," mõtleb Kristi samal ajal. Kuid shove asemel tuleb lihtsalt call. 

Flopis kohe kaks soldatit. Sündmusteni jõutakse alles riveris. Kristi teeb väikse beti, Maarja liigub all-ini ja nüüd on callida juba lihtne. 

Maarja avab kümnete pocketi ja ulatab lisaks chippidele Kristile ka oma nännikoti. Turniir tema jaoks läbi. Põnevusega ootame teda aga järgmistele üritustele - Maarjas on pokkerimängijale omast kuraasi.

Kui ässad ei toida.. Posted Tuesday 25th July, 2023 at 19:42(UTC+0) by Mariliis Joras

Andrei Mjagkov saab suure saagi. Ta mängib -ga, mis saab flopis mastiostu. Riveris tuleb see kohale. 

Teisel mehel meel kurb, sest tal olid ässad... Aga stäkk väiksem ja nüüd tuleb lauast tõusta.

Laura out Posted Tuesday 25th July, 2023 at 19:34(UTC+0) by Mariliis Joras

Laura Pritsi nupud on kahjuks otsa lõppenud. Viimased libisesid Allan Puki ette, kui viimane tabas masti.

Tegelikult ütleb Allan, et mängis Laura vastu veel teisigi värvikaid jaotusi ja kui Laura isegi hittis kenasti, siis Allanil õnnestus kohe pärast seda veelgi paremini hittida. Ju ei olnud Laura õhtu.

Aga loodetavasti oli kogemus tulemist väärt. 

Erkkil on missioon Posted Tuesday 25th July, 2023 at 19:27(UTC+0) by Mariliis Joras

Erkki Sarapuu on olnud kuulsuste turniiril kõige kaugemale jõudnud kuulsus ja on täiesti selge, et väiksemaid ambitsioone ei ole tal ka täna. 

Stäkk on jõudsalt paisunud ja sama hoogsalt paneb ta edasi. Samal ajal käib muidugi ka suu, sest kui mehel poleks nii head suuvärki nagu tal on, ei teakski me tast võib-olla mitte midagi. 

Floppi vaadatakse min-raise'i eest. Tuhat tuleb lauda kolmelt mehelt. 

flopis. 

Ees checkid ja Erkki betib 2400. Talle tuleb üks call. 

Turn ja taas ees check. Erkki soovib nüüd 3000 ja ei jää seegi call tulemata.

River ja Peeter Antsovilt uuesti check. "Ega sa võid ka checkida," juhendab ta Erkkit. Aga nii lihtsalt see ei lähe. Erkki kõmmutab nüüd lauda 18 000 ega ole isegi all-inis. Küll aga peaks kõik sisse panema Peeter, juhul kui ta callida sooviks. Kuid ta ei soovi.

Erkki näitab üht kaarti, milleks on . Tehtagu sellest omad järeldused.

Jaan andis näole Posted Tuesday 25th July, 2023 at 19:18(UTC+0) by Mariliis Joras

Meie pokkerit mängivate kuulsuste hulka pidi täna kuuluma ka Jaan Pehk, aga ei olnud 100% kindel, kas ta ikka siia jõuab.

Jaan jõudis. Aga jõudis ka juba bustida. 

Kell 12 üllatussatikas Posted Tuesday 25th July, 2023 at 19:16(UTC+0) by Mariliis Joras

Head uudised kõigile neile, kellel täna südaööl midagi teha pole. 

Nimelt algab kl 00.00 120-eurose sisseostuga satelliitturniir, kus on garanteeritud viis 1500-eurost WSOP Circuit in Tallinn turniiripääset. 

Esimesed 8 levelit vältavad 15 minutit ja selle aja jooksul on avatud ka late reg. Pärast seda lühenevad tasemed 10-minutilisteks. Algstäkk on 10 000 žetooni. 

Maarjal on riukalik külg Posted Tuesday 25th July, 2023 at 19:08(UTC+0) by Mariliis Joras

Kristi Kirs teatab, et sellest, kuidas Maarja blufib, võiks rohkem kirjutada. 

Kelle vastu, uurime.

"Kõigi!" kinnitavad Kristi ja Andres Puusepp kui ühest suust. Andrese arvates võiks lausa Kroonika sellesse täpsemini süveneda. 

Kristi sai oma koosa kätte, kui boardil oli neli ruutut. Maarja bettis ja Kristi kartis, et tema ruutust on Maarjal kindlasti kõrgem ruutu. Aga võta näpust, ruutusid Maarjal polnud. Nii tõestas ta, et "diamonds are a girl's best friend" isegi siis, kui endal neid pole.  

Näeme ka Evelyt, ainult et mitte lauas Posted Tuesday 25th July, 2023 at 18:58(UTC+0) by Mariliis Joras

Modell ja pokkerikaunitar Evely Pihela oli veel talvisel kuulsuste üritusel ise lauas, üks bountydest. Sel festivalil on ta aga haaranud mikrofoni, millega käia teistelt küsimas: "Mis tunne on?"

Hetk tagasi püüdis ta punase mikrofoni taha Jarek Kasari, kes chippidest valla sai.

Jarek on alati positiivne ja võtab ka täna sõltumata tulemusest kaasa ainult head elamused.

Auhinnafond paisub Posted Tuesday 25th July, 2023 at 18:52(UTC+0) by Mariliis Joras

Auhinnafondis on juba peaaegu 30 000 eurot, mida pole üldse vähe. Veel 4 taseme jagu on aega liituda hilise registreerujana või teha re-entry. Seega teame juba praegu, et auhinnafond veel kasvab. 

Aga kui palju?

Näiteks talvisel Kings of Tallinna festivalil kogunes samasuguse struktuuri ja ülesehitusega turniiril auhinnafondi napilt üle 40 000 euro. Tookord oli unikaalsete mängijate arv 257, re-entreyd tehti 74. 

Täna ja praegu on sisseostude arv 244. Nii et tulemuse kordamiseks on veel minna.

Koridori kuulsusi ei jagunud Posted Tuesday 25th July, 2023 at 18:44(UTC+0) by Mariliis Joras

Marius Morel on oma laua kuulsaim mängija. Ta on nimelt sattunud koridori istuma, kuid kõik kuulsused näikse olevat paigutatud konverentsisaali. 

See muidugi Mariust mitte kuidagi ei takista. Stäkki on ta juba kõvasti kasvatanud.

Käimas on meil parasjagu neljas level ja blindid 100/300/300. Praktiliselt 30 mängijat on nuppudest lahti saanud. Kuulsatest on väljas Henrik Raave, kes esmapilgul ennast tagasi sisse ostnud pole. Sama ei saa öelda aga näiteks Toomas Marrandi ja Mihkel Kesa kohta - mõlemad on pärast esimest katset mängus tagasi.

Kuidas kõigil läheb? Posted Tuesday 25th July, 2023 at 18:33(UTC+0) by Mariliis Joras

Laura Prits võitis suure käe ilma, et ta väga täpselt läbi oleks hammustanud, mis toimus. Õnneks abistab teda brošüür, kus on laias laastus kirjas, millega üldse mängida ja milline kaardikombinatsioon võidu annab. 

Hoopis kogenum on Maarja, kes alles kogub hoogu. Ilusa stardikäega võtab ta nõuks callida Masse Mirzoudi pre-flopi tõste 500. 

Flopis lisavad mõlemad veel 500 ja sama juhtub turnis. Riveris hoog raugeb. 

Maarja on pihta saanud üheksale, kuid midagi enamat ta laualt välja ei pigista. Seekord jääb Masse peale, sest oma o-ga on ta hittinud ässa.

Andres Puusepp alles jälgib olukorda. Kohe kui kaarti antakse, on teda igatahes mängu oodata, sest näpud juba sügelevad.

Laura põikab kuuli eest Posted Tuesday 25th July, 2023 at 18:14(UTC+0) by Mariliis Joras

Laura Pritsil veab, sest kuigi tal oli kindel plaan jaotuses osaleda, otsustab ta pärast Mairold Millerti suurt tõstet 1700 foldida. 

Marita Mägi ei heitu. Kahekesi vaadataksegi floppi. 

Kumbki paneb panka veel ca 1500.

Turn on

Mairold nüüd checkib, kuid Marita beti 3500 maksab. 

Riverisse

Mairoldi check siin enam lisasaaki ei tooda, sest Marita on ilmselt oma olukorra läbi  hammustanud. 

Kaardid tehakse lahti ja ongi nii nagu võis arvata - Mairoldil ässade pocket. Marita oma kaarte ei näita.

Esimeses lauas aega ei raisata Posted Tuesday 25th July, 2023 at 18:03(UTC+0) by Mariliis Joras

Lauas nr 1 istuvad koos Erkki Sarapuu ja Jarek Kasar. 

Neist esimene on lennuka mänguga, nagu alati. UTG-lt teeb ta tõste ja saab 4 calli. C-bet flopis on piisav, et kõik foldima saada. 

Järgmises jaotuses on innukaim pool Ardo Kiirkivi. Floppi hinnaga 600 vaadatakse kolmekesi, aga kui see on äss kõrge ja Ardo c-betib 1200, lähevad kõik maha, sh BB Erkki.

Üks minut, üks tool Posted Tuesday 25th July, 2023 at 17:59(UTC+0) by Mariliis Joras

Mäng pole õieti alanudki, kui juba on meil üks "tool" lahti.

See mees on kuulus küll, aga mitte Kroonika veergudel, vaid pokkerimängijate seas. Mr Kaidar Viikman isiklikult on kellegi üles duubeldanud. Kuna see juhtus teises toas, siis jäi nägemata, kes chipid endale sai. 

Fännidel pole kurvastamiseks siiski põhjust, sest Kaidar tegi re-entry.

Ja olemegi startimas Posted Tuesday 25th July, 2023 at 17:54(UTC+0) by Mariliis Joras

Stiilne hilinemine on kuulsustele ju lubatud. 

15 minutit akadeemilist möödas, hakkavadki kuulsused kaamerate sähvides uksest sisenema. 

Naisstaaridest on esindatud lauljannad Laura Prits, Maarja-Liis Ilus ja Johanna Randmann. 

Ülejäänud on mehed. Kohal on raadiohääl Erkki Sarapuu, 5Miinuse Korea, helilooja Priit Pajusaar, multitalent Mairold Millert, saatejuht Robert Rool, raadiohääl Andres Puusepp, räppar Jaanus Saks, muusik Chalice ehk Jarek Kasar ja laulja Henrik Raave. 

Muidugi on meil ka terve rida Soome kuulsusi ja isegi üks kaugema kandi mees, kes on muuhulgas seltskonnamängu Pictionary autor. 

Kuulsustega tasub igal juhul jaotusi mängida, sest kui õnnestub mõni välja võtta, ootab elimineerijat nännikott. Ja kellele siis nänn ei meeldiks!

Mängijaid aina koguneb Posted Tuesday 25th July, 2023 at 17:23(UTC+0) by Mariliis Joras

Veel mõni tund tagasi oli osalejate arv 30 ringis, kuid see on jõudsalt kasvama hakanud. Hetkeseisuga stardib umbes 100 mängijat. 

Tervelt 8 taset on aega vaikselt juurde tiksuda, nii et kes õiges ajaks ei jõua, ei pea muretsema.

Tegemist on tõsise turboturniiriga, kus tasemed kestavad ainult 15 minutit. Algstäkk 15 000 annab küll veidi mänguruumi, aga mitte kauaks. Seega on oodata agressiivset andmist!

Tore on tõdeda, et mängijate nimekirjast leiame ka mitmeid tuttavaid "pokkerikuulsusi", kes pole pidanud paljuks oma teisipäeva õhtu pokkerile ohverdada. Hoiame silma peal nii paljudel eestlastel, kui vähegi võimalik.

Fotol olevad noormehed on puhtalt illustreerivad. Päris fotosid tuleb täna tegema võimas profifotograafide tandem - Elena Kask ja Tambet Kask.

Tere, kuulsad ja kummalised Posted Tuesday 25th July, 2023 at 17:11(UTC+0) by Mariliis Joras

Head pokkerisõbrad!

Lõpuks saab avapaugu ka Summer Showdowni eestikeelne bloginädal. Alustame suurejooneliselt, jälgides kõrvalt, kui hästi või halvasti kuulsused pokkerit mängida oskavad. 

Mõned toredad ja kõlavad nimed on juba kirjas, aga kes täpselt lauda istub, sellest lähemalt turniiri algusajal, mil teame, kes kutsututest läbi vihma ja tuule ka päriselt kohale on jõudnud. 

Turniiri kanname live-blogis üle otsast lõpuni, nii et haarakem kohv ja küpsised ligi.

Welcome to the Kings of Tallinn Summer Showdown! Posted Thursday 20th July, 2023 at 10:57(UTC+0) by Jason Glatzer

Welcome to the 2023 Kings of Tallinn Summer Showdown at the plush surroundings at Olympic Park Casino and the adjacent Hilton Tallinn Park for an exciting 10 days of poker from July 21-30.

The festival boasts 53 numbered events along with cash games running 24 hours a day in a variety of poker variants and stakes.

Our coverage will begin July 25 with the €150 Celebrity Special with many local celebrities competing with a bounty on their head.

Stay tuned to see who will win the Celebrity Special and other events at the 2023 Kings of Tallinn Summer Showdown.

10:44 (UTC+0)

Day 1 of Kings of Tallinn Summer Showdown 2023 Started
Level:      Blinds: 0/0     Ante: 0

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

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter