0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-21'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/97/257/updates'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/97/257/updates', 1, '2024-12-21')

0.0004 SECONDS: 
SELECT tour_stop_blogs.*, tour_stops.description as description, tour_stops.logo as tour_stop_logo, tour_stops.start_date as start_date, tour_stops.end_date as end_date, 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.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 `tour_stop_blogs`.`id` = '97'

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

0.0284 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0063 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '242'
AND `published` = 1

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

0.0277 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` = '249'
AND `published` = 1

0.0281 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '252'
AND `published` = 1

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

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

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

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

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` = '11628'
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` = '11616'
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` = '11611'
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` = '11607'
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` = '11605'
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` = '11603'
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` = '11597'
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` = '11592'
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` = '11590'
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` = '11587'
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` = '11586'
ORDER BY `chip_change` DESC, `busted` ASC

0.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11585'
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` = '11552'
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` = '11543'
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` = '11539'
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` = '11535'
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` = '11525'
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` = '11521'
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` = '11516'
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` = '11515'
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` = '11509'
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` = '11506'
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` = '11504'
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` = '11502'
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` = '11499'
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` = '11494'
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` = '11492'
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` = '11474'
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` = '11470'
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` = '11458'
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` = '11456'
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` = '11454'
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` = '11448'
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` = '11444'
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` = '11442'
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` = '11440'
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` = '11430'
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` = '11424'
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` = '11421'
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` = '11412'
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` = '11408'
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` = '11406'
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` = '11403'
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` = '11399'
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` = '11388'
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` = '11387'
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` = '11382'
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` = '11377'
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` = '11372'
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` = '11367'
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` = '11364'
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` = '11360'
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` = '11346'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0093 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11336'
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` = '11332'
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` = '11328'
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` = '11325'
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` = '11321'
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` = '11319'
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` = '11315'
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` = '11300'
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` = '11298'
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` = '11291'
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` = '11287'
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` = '11282'
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` = '11271'
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` = '11265'
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` = '11261'
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` = '11253'
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` = '11250'
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` = '11242'
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` = '11238'
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` = '11234'
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` = '11233'
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` = '11229'
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` = '11218'
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` = '11217'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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` = '11628'
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` = '11616'
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` = '11611'
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` = '11607'
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` = '11605'
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` = '11603'
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` = '11597'
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` = '11592'
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` = '11590'
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` = '11587'
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` = '11586'
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` = '11585'
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` = '11552'
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` = '11543'
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` = '11539'
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` = '11535'
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` = '11525'
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` = '11521'
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` = '11516'
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` = '11515'
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` = '11509'
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` = '11506'
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` = '11504'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

0.0121 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11458'
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` = '11456'
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` = '11454'
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` = '11448'
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` = '11444'
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` = '11442'
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` = '11440'
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` = '11430'
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` = '11424'
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` = '11421'
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` = '11412'
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` = '11408'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0112 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11403'
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` = '11399'
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` = '11388'
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` = '11387'
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` = '11382'
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` = '11377'
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` = '11372'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0111 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '11364'
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` = '11360'
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` = '11346'
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` = '11342'
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` = '11336'
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` = '11332'
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` = '11328'
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` = '11325'
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` = '11321'
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` = '11319'
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` = '11315'
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` = '11300'
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` = '11298'
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` = '11291'
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` = '11287'
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` = '11282'
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` = '11271'
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` = '11265'
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` = '11261'
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` = '11253'
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` = '11250'
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` = '11242'
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` = '11238'
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` = '11234'
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` = '11233'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

    

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

Translate

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

Kings of Tallinn 2024 Event #29: €1,100 Main Event (Estonian) Live Reporting - Day 4

Kings of Tallinn 2024 - Live Reporting

Event #29: €1,100 Main Event (Estonian) See other events

Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

---

Current Level 34 Current Day 4

---

Blinds 200,000/400,000 Ante 400,000

Entries 914 Remaining 1

---

Prize Pool (EUR) €859,160 First Prize (EUR) €120,910

Chip Leaders Day 4

1

Edgaras Kausinis

27,420,000

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

Live Updates Chip Counts Structure Gallery Payouts

1 New Update - Click to refresh

Live Updates - Day 3

Päev läbi Posted Sunday 3rd March, 2024 at 01:42(UTC+2) by maheaaatom

Turniiri viimasse päeva jõudis 11 parimat ning me jätkame homme kahel laual. 

Viimasel tasemel andis Herli natuke ära, sest mehe enda sõnul lihtsalt kaart ei jooksnud. Aga 2,12M on täiesti piisav, et homme esikoha nimel võidelda. Üldarvestus on see suuruselt kuues stäkk. Ja mis kõige veidram - Kings of Tallinn põhiturniiri ajaloos pole juhtunud kordagi, et finaalpäeva jõuab ainult ÜKS soomlane!

Soovime vaatajatele head ööd ning oleme tagasi pühapäeval kell 12:00, mil algab suurejooneliselt kulgenud pokkerifestivali Kings of Tallinn 2024 viimane võistluspäev. Blogime nii põhiturniiri kui ka 3K highrolleri finaali. Head ööd!

Player		Chips	Progress
Edgaras Kausinis		4,600,000	4,570,000
Aleksi Naski		4,230,000	4,200,000
Greger Aktel		3,725,000	3,695,000
Even Rislov		2,995,000	2,965,000
Wissam Polus		2,340,000	2,310,000
Herli Olop		2,120,000	780,000
Mantas Tamulevicius		1,895,000	1,118,000
Paul Newey		1,565,000	1,535,000
Benjamin Gros		1,365,000	1,335,000
Mindaugas Jonaitis		1,325,000	1,295,000
Rydahl Brink		1,240,000	1,210,000

12. koht Kaido Mikk Posted Sunday 3rd March, 2024 at 01:10(UTC+2) by maheaaatom

Greger Aktell tõstis 100K hijack'ilt ja Kaido Mikk lennutas oma viimased 455K buttonilt keskele. Aktell callis.

Kaido Mikk: 
Greger Aktell: 

Selge meie mehe eduseis, ka flop oli igati okei . Kahjuks avati turni saatuslik  ning river Kaidot ei päätnud. Sel korral siis tulemuseks 12. koht. 

Player		Chips	Progress
Kaido Mikk		0	0

Veel infot kõrvalturniiridelt Posted Sunday 3rd March, 2024 at 00:54(UTC+2) by maheaaatom

Kell 17:00 alanud 350 € Progressive Bountyl tehti 287 sisseostu, alles 24 parimat. Eestlasi on mängus kolm (Peep Kivistik, Pavel Solodovnikov ja Mäido Kuusik) ning nad kõik on ka rahades.

Kell 19:00 alanud 555 € Mystery Bountyl tehti 138 sisseostu, mängus 32 parimat, neist viis eestlast. Tegemist on kahepäevase turniiriga).

Kell 21:00 läks käima 150 € NLH turbo 223 sisseostuga. Kuna turniiri formaat on ülikiire, jätkab hetkel alla 50 mängija. 

Intervjuu 5K highrolleri võitnud Markkos Ladeviga Posted Sunday 3rd March, 2024 at 00:49(UTC+2) by maheaaatom

Mati Pirn Hiina pokkeris teine Posted Sunday 3rd March, 2024 at 00:48(UTC+2) by maheaaatom

Infoks neile, kes ootasid Mati tulemust hiinakal. Kahjuks tuli meie mehel leppida teise kohaga, võitis nimekas soomlane Henri Antikainen.

Naisteka esikoht läks Leetu, Karin teine ja Katre kolmas Posted Sunday 3rd March, 2024 at 00:47(UTC+2) by maheaaatom

Naisteturniiri võitis leedulanna Indre Martoviciute. Konkurentide sõnul oli  Indre võit teenitud, sest tegemist on hea mängijaga. Üldisest auhinnapotist pudened talle 1560 eurot, Karin Ehala sai teisena 1070 ning Katre Kokk kolmandana 727 eurot. 

Auhinnarahadele lisandusid bountyd ja olgu veelkord mainitud, et Katre sai kätte neist suurima väärtusega 1500 eurot.

Tagasi reaalsuses Posted Sunday 3rd March, 2024 at 00:26(UTC+2) by maheaaatom

Lühike kokkuvõte sellest, mis seis hetkel valitseb:

- Põhiturniiril on sees 12 parimat, Herlil 2,9M stäkk

- Kaido on telelauas, teda saate näha live-ülekandes

- Naistekal alles 3 parimat, eestlastest Katre Kokk ja Karin Ehala, chipliidriks on aga leedulanna Indre Martoviciute. Katrel on erilist põhjust rahul olla, sest just tema sai kätte  turniiri suurima bounty 1500 eurot.

Player		Chips	Progress
Herli Olop		2,900,000	200,000

17. koht Tarmo Tammel 6150 € Posted Sunday 3rd March, 2024 at 00:15(UTC+2) by maheaaatom

Tarmo Tammel on saanud Olympic Casinos toimuvatel suurturniiridel enim cashe ning üks tuleb siit veel juurde. Kahjuks mitte tipmine.

Tarmo shoves oma 13BB sisse ja sai calli Benjamin Grosilt.

Tarmo Tammel: 
Benjamin Gros: 

Lauda 

Player		Chips	Progress
Tarmo Tammel		0	0

20. koht Aleksei Smirnov 5400 € Posted Sunday 3rd March, 2024 at 00:12(UTC+2) by maheaaatom

Aleksei Smirnov tõstis SB-lt 100K, Greger Aktell kolmpanustas 300K BB-lt, Aleksei lükkas all-ini ja  Aktell instacallis.

Aleksei Smirnov: 
Greger Aktell: 

Lauda  

Player		Chips	Progress
Aleksei Smirnov		0	0

Vabandame katkestuse pärast Posted Sunday 3rd March, 2024 at 00:10(UTC+2) by maheaaatom

Kahjuks oli meil enam kui poolteist tundi probleeme serveriga, mistõttu ei saanud siia lisada ka ühtegi blogipostitust. Nüüd saame jätkata!

00:09 (UTC+2)

Start of Level 26
Blinds: 30,000/60,000     Ante: 60,000

Herli 3M Posted Sunday 3rd March, 2024 at 00:09(UTC+2) by maheaaatom

Luca Beretta tõstab BB-lt 60K ning Herli kaitseb.

Flop on ning Herli check-callib vastase 50K panust.

Turn on , mis checkitakse läbi.

Riveri järel panustab juba Herli 150K ning calli ei tule. Meie mehel nüüd 3M.

Christel juhib naistekat Posted Saturday 2nd March, 2024 at 21:58(UTC+2) by maheaaatom

Naisteturniiril on kindlaks liidriks Christel P., üsna head stäkid on ka Gerlyl ja Kellyl. Mull pole kaugel, alles 13 parimat ja raha saab 11. 

21:55 (UTC+2)

Start of Level 24
Blinds: 20,000/40,000     Ante: 40,000

Suur pank Herlile Posted Saturday 2nd March, 2024 at 21:50(UTC+2) by maheaaatom

Suured stäkid Herli ja Benjamin Gros sõdivad blindidel, enne floppi läheb sisse 230K. 

Lauda , Herli checkib, Benjamin panustab 150K ja saab calli.

Turn on , mis checkitakse läbi.

Riveri järel lükkab Herli lauda umbes 600K ning britt muckib koheselt.

Kaido kaotab suure panga Posted Saturday 2nd March, 2024 at 21:36(UTC+2) by maheaaatom

Flopis on , Edgaras Kausinis checkib ette, Kaido paneb 75K ja saab calli.

Turn on , leedulaselt taas check ning Kaidolt seekord juba 200K panus. Ikka call.

River checkitakse läbi. Edgaras avab ning Kaido muckib oma kaardid kinniselt.

Kaido võtab juurde Posted Saturday 2nd March, 2024 at 21:28(UTC+2) by maheaaatom

Umbes 400K pank Kaidole, riveriks on lauas ning Kaido check-callib Rolandas Aglinskase 75K panust.

Leedulasel on , mida Kaido kindlalt -ga domineerib.

Herli lauas üks langeja Posted Saturday 2nd March, 2024 at 21:12(UTC+2) by maheaaatom

De Ramon Josep Pastor pushib -ga ning kõvasti suurema stäkiga Dominik Ostrowski callib -ga. Lauda äss.

Herli hoiab initsiatiivi Posted Saturday 2nd March, 2024 at 21:06(UTC+2) by maheaaatom

Herli on omas lauas väga agressiivne ning katsub initsiatiivi hoida, seda eelkõige positsioonilt tõstes ja kolmpanustades. Tema stäkk on 2,7M, mis on kindlasti üks suurimaid. 

Tarmo Tammel ja Kaido Mikk on vastavalt 700K ja 1M peal, Alekseile saate aga peagi elada kaasa telelauas. 

Player		Chips	Progress
Herli Olop		2,700,000	740,000
Kaido Mikk		1,000,000	780,000
Tarmo Tammel		700,000	400,000

Inglise keele nõue tõmbab daamid vaikseks Posted Saturday 2nd March, 2024 at 20:44(UTC+2) by maheaaatom

Kuna tegemist on rahvusvahelise turniiriga, kehtib reegel - English only. See tähendab, et kui lauas on kasvõi üks eesti keelt mitteoskav mängija, tuleb rääkida inglise keeles. Välja arvatud juhul, kui diiler või mängijates sellele tähelepanu ei rõhuta.

Iseenesest on reegel muidugi õige. Sest kust pagan pihta peab näiteks Leedu mängija aru saama, kui üks naine ütleb teisele, et "ma foldisin ässa ja kuninga". 

Re-Draw Posted Saturday 2nd March, 2024 at 20:40(UTC+2) by maheaaatom

Kuna jätkab 24 parimat, toimub re-draw ning mängijad jätkavad fuajees kolmes lauas. Kuna meie blogi keskendub ainult suures saalis mängivatele eestlastele, siis jätkama selles osas reaalajas. TV-lauale me blogis tähelepanu ei pööra.

Mõistagi jälgime ka teisi turniire, iseäranis naistekat, mis hakkab peagi põnevaks minema.

Naistekat juhivad Gerly ja Christel P. Posted Saturday 2nd March, 2024 at 20:30(UTC+2) by maheaaatom

Naisteturniiril on alles 28 parimat ning umbes pooled neist on eestlannad. 

Hetkel suurimate stäkkidega on mulluse Eesti naiste pokkeriliiga kolmas Gerly Rüüberg (umbes 230K) ning EMV põhiturniiril koguni kolmandaks tulnud Christel P (180K). Mängida on muidugi veel kõvasti. 

Keda enam mängus pole? Catlin Müüri, Kristi Kirsi, Ave Lepikut, Kairit Leiboldi ega ammuilma ka lõbusat paatkonda - Kristi Lippu/Helena Karutoomi.

Mati heitleb hiinaka võidule Posted Saturday 2nd March, 2024 at 20:26(UTC+2) by maheaaatom

Teine turniir, mille võitja täna selgub (esimene oli 5K highroller) on hiinakas, kus hetkel 3 parimat alles, Mati Pirn nende seas. Sisseoste tehti 52, Mati on endale juba taganud vähemalt 2230 eurot.

 

Alekseile kiire stäkilisa Posted Saturday 2nd March, 2024 at 20:23(UTC+2) by maheaaatom

Kohe esimeses käes saab Aleksei korraliku stäkilisa, elimineerides Garrido Ignacio Gonzaleze.

Kokku jooksevad ja , meie mehel on ässad.

Player		Chips	Progress
Aleksei Smirnov		1,100,000	350,000

Turniiri juhib soomlane Posted Saturday 2nd March, 2024 at 20:14(UTC+2) by maheaaatom

Suurim stäkk on Aleksi Naskil, Herli on üldises edetabelis tugeval kolmandal ning kaido kaheksandal kohal. Siit on hea edasi minna!

20:11 (UTC+2)

Start of Level 23
Blinds: 15,000/30,000     Ante: 30,000

Õhtusöögipaus Posted Saturday 2nd March, 2024 at 19:09(UTC+2) by maheaaatom

Mängijad lubati 60 minutiks puhkama ning puhkame meiegi. "Suure saali meestest" on kerkinud edukaimaks eestlaseks Kaido Mikk, kel vingi 1,265M stäkk.

Player		Chips	Progress
Kaido Mikk		1,265,000	265,000
Tarmo Tammel		815,000	185,000
Aleksei Smirnov		715,000	85,000

Paul Newey on samuti veel mängus Posted Saturday 2nd March, 2024 at 19:03(UTC+2) by maheaaatom

Britist multimiljonär Paul Newey on üks neist 32 mängijast, kes siiani lauas istub. 

Äsja õnnestus tal oma stäkk Mantas Tamulevicius'e vastu edukalt duublisse saada: vs. , laud midagi ei muutnud. Paulil hetkel 390K.

Palju õnne Markkosele! Posted Saturday 2nd March, 2024 at 18:35(UTC+2) by maheaaatom

Nagu paljud meie ülekande jälgijad juba ammu teavad, on 5K highroller lõppenud ning Eesti pokkeriproff Markkos Ladev näitas seal kõigile koha kätte. Palju õnne!

Kõrvalturniiridest ka Posted Saturday 2nd March, 2024 at 18:33(UTC+2) by maheaaatom

Põhiturniirist, naistekast ja highrollerist oleme palju rääkinud, kuid nende kõrval on täna kavas ka teisi turniire:

Kell 17:00 algas 350 € NLH Progressive Bounty

Kell 19:00 algab 555 € NLH Mystery Bounty

Kell 22:00 pannakse käima 150 € NLH Turbo

Lisaks on täna kavas ka festivali ainus online-turniir, mis algab kell 20:00 OlyBeti pokkeritoas. Progressive Bounty formaadis mängitava turniiri sisseost on 150 eurot ning selle garanteeritud auhinnafond 5000 eurot. 

34. koht Ranel Käsi 3350 € Posted Saturday 2nd March, 2024 at 18:30(UTC+2) by maheaaatom

Raneli stäkk ei olnud ka enne väljalangemist kahjuks kuigi suur. Jätkab 33 parimat, eestlasi on mängus neli.

Player		Chips	Progress
Ranel Käsi		0	0

Herli telelauas Posted Saturday 2nd March, 2024 at 18:16(UTC+2) by maheaaatom

Üks põhiturniiri laudadest, kus on ka meie mees Herli Olop on viidud telekaamerate ette ning juba umbes 15 minuti pärast saate hakata talle kaasa elama. Telelauda me jooksvalt ei kajasta, keskendume neile kolmele lauale, mis on suures saalis.

TV-laua leiad siit.

Teiste meie poiste stäkid Posted Saturday 2nd March, 2024 at 18:11(UTC+2) by maheaaatom

Player		Chips	Progress
Kaido Mikk		1,000,000	780,000
Tarmo Tammel		1,000,000	700,000
Aleksei Smirnov		800,000	50,000

Naised pausil Posted Saturday 2nd March, 2024 at 18:08(UTC+2) by maheaaatom

Naistekal on tehtud 88 sisseostu ning re-entry saab äsja alanud pausiga läbi. Meie sünnipäevatüdrukul Kristil ei õnnestunud kahjuks mängu jääda, mõlemad tema premium käed crackiti vastaste poolt ära.

"Millal mulle see armastus küll lõpuks tuleb?" viskab Kristi nalja.

18:03 (UTC+2)

Start of Level 22
Blinds: 10,000/25,000     Ante: 25,000

Herlil 1,96M! Posted Saturday 2nd March, 2024 at 18:02(UTC+2) by maheaaatom

Viimase pausieelse käega sai Herli veel ühe väga suure panga.

Kui lauas oli avatud , panustas vastane 130K, Herli vastas all-in'iga ning pika mõtlemise järel tuli ka call.

Herli:

Vastane:

Kõrgem kaks paari pidas ning Herlil nüüd juba 1,96M!

 

Player		Chips	Progress
Herli Olop		1,700,000	600,000

Herli elimineeris pisikese stäki Posted Saturday 2nd March, 2024 at 17:33(UTC+2) by maheaaatom

Herli korjas veel natuke juurde, kukutades välja ühe pisikese stäki.

Kõik aus, meie mehel , vastas . Herlil nüüd 1,2M.

Player		Chips	Progress
Herli Olop		1,200,000	100,000

46. koht Kris Tikka 2950 € Posted Saturday 2nd March, 2024 at 17:30(UTC+2) by maheaaatom

Krisil oli õige pisike stäkk, seega pole tema väljalangemises midagi ootamatut. Oleme jõudnud juba 38 parimani.

Metsiku tõusu on teinud Kaido Mikk, kel oli alles mõnda aega tagasi napp 80K, nüüd aga juba umbes miljoni ringis.

Player		Chips	Progress
Herli Olop		1,100,000	30,000
Kaido Mikk		1,000,000	740,000
Aleksei Smirnov		660,000	40,000
Tarmo Tammel		620,000	230,000
Kris Tikka		180,000	0

Birthday Girl! Posted Saturday 2nd March, 2024 at 17:15(UTC+2) by maheaaatom

Täna on sünnipäev ilusa sädeleva kliendiga Kings of Tallinnale tulnud 2019. aasta Eesti pokkerimeistril Kristi Lipul.

Kristi üritas freerollilt piletit saada, kuid kahjuks see tal ei õnnestunud. Neiu oli natuke kurb ja valmistus juba lahkuma, kui Olympic Casino pokkerimänedžer talle isiklikult õnne soovis ning kinkis Olympic Casino poolt Kristile pileti Queens of Tallinn naisteturniirile. 

Kristi oli väga liigutatud ning võttis naisteturniiri lauas istet. Samuti liitus sellega Kristi ustav sõbranna Helena Karutoom. "Plaanid muudkui muutuvad," naeris alati heatujuline Helena.

Kuidas edeneb 3K highroller? Posted Saturday 2nd March, 2024 at 17:09(UTC+2) by maheaaatom

Samuti suures saalis toimuval 3000 € highrolleril on tehtud 33 sisseostu, mängus on sellised ässad nagu Igor Pihela vanem, Markku Koplimaa, Urmo Velvelt, Ermo Kosk ja Henri Käsper.

Turniirist tuleb eraldi live-ülekanne, mis algab kohe pärast 5K lõppu.  Viimasel on veel käimas ülipinev heads-up Eesti superässa Markkos Ladevi osavõtul.

Herlil on kõvasti õnne Posted Saturday 2nd March, 2024 at 17:05(UTC+2) by maheaaatom

Herli Olop avab 30K tõstega, tema järel paneb soomlane Tomi Rissanen 75K ning saab meie pokkeriässalt calli.

Flop: .

Herle checkib ette, Tomi paneb 53K ning Herli vastab all-in'iga. Soomlaselt võrdlemisi kiire call.

Herli:

Tomi: .

Seekord on pokkerijumal eestlane. Turnis avatakse (!), river on ebaoluline .

Soomlane on väga pettunud (kes ei oleks). Herlil nüüd 1,07M.

Player		Chips	Progress
Herli Olop		1,070,000	320,000

Naskil juba kaks miljonit Posted Saturday 2nd March, 2024 at 16:56(UTC+2) by maheaaatom

Pausi järel on turniiri liider soomlane Naski, kelle stäkk hiilgaslik 2 090 000. Eestlastest on parim Herli Olop 745K-ga, kes on üldarvestuses üheksas.

16:48 (UTC+2)

Start of Level 21
Blinds: 10,000/20,000     Ante: 20,000

Teine paus Posted Saturday 2nd March, 2024 at 16:28(UTC+2) by maheaaatom

Põhiturniiri mängijad lubati jalgu sirutama. Pausil on ka naistekas, kuhu on tehtud juba 68 sisseostu. Siitki paistab kena rekord!

Omade stäkid Posted Saturday 2nd March, 2024 at 16:26(UTC+2) by maheaaatom

Player		Chips	Progress
Herli Olop		750,000	50,000
Aleksei Smirnov		700,000	125,000
Tarmo Tammel		390,000	85,000
Kaido Mikk		260,000	0
Kris Tikka		180,000	20,000

Kaidol on õnne Posted Saturday 2nd March, 2024 at 16:19(UTC+2) by maheaaatom

Kaido Mikk jammis UTG-lt 81K ning Sandis Blums callis BB-lt.

Kaido Mikk: 
Sandis Blums: 

Peaks nagu olema split pot, millele vihjas ka flop .

Aga show polnud veel kaugeltki läbi. Turnja river !

Küll on aga väljas Soome highroller Ilari Sahamies, kelle killiti ära poolt.

Aleksei foldib vastase suurele panusele Posted Saturday 2nd March, 2024 at 16:12(UTC+2) by maheaaatom

Tarmo Tammel tõstab CO-lt ja mõlemad blindid callivad.

Pärast flopi ja turni panustab Aleksei 36K ning hiidstäkiga Aleksi Naski tõstab 78K-le. Aleksei callib.

River on ning seekord Aleksei checkib. Naskilt tuleb 270K panus ning Aleksei foldib sisuliselt koheselt.

58. koht Steven Tool Posted Saturday 2nd March, 2024 at 15:56(UTC+2) by maheaaatom

Vahepeal veel neli langejat, neist üks meie mees Steven Tool. Jätkab 52 parimat.

Player		Chips	Progress
Steven Tool		0	0

Mullist võitjaks? Posted Saturday 2nd March, 2024 at 15:49(UTC+2) by maheaaatom

Naiste freerolli viis parimat on selgunud ning väga napilt ei jõudnud nende sekka kahekordne Eesti meister Ave Lepik, kes jäi frerollil mulliks. 

WSOP Circuit'il Tallinnas läks Ave väga hästi - ta suutis freerollilt pileti saada ning hiljem ka naisteturniiri võita. Aga miks mitte ei võiks nüüd edu korrata?

Meie meeste stäkid Posted Saturday 2nd March, 2024 at 15:44(UTC+2) by maheaaatom

Meie meestest on suurim stäkk endiselt Aleksei Smirnovil , mis on pea kahekordne keskmine. Ja suure stäkiga oskab Aleksi väga hästi mängida!

57 parimat järgi.

Player		Chips	Progress
Aleksei Smirnov		825,000	75,000
Herli Olop		700,000	35,000
Ranel Käsi		550,000	30,000
Tarmo Tammel		475,000	415,000
Kaido Mikk		260,000	40,000
Kris Tikka		200,000	58,400
Steven Tool		200,000	30,000

15:42 (UTC+2)

Start of Level 20
Blinds: 10,000/15,000     Ante: 15,000

Tarmo duubeldab mastireaga Posted Saturday 2nd March, 2024 at 15:20(UTC+2) by maheaaatom

Thomas Larsen lükkab nuppe pärast floppi ning Tarmo Tammel callib.

Vastane näitab , Tarmol on . Ja turn toob meie mehele mastirea. Pihtas-põhjas!

Player		Chips	Progress
Tarmo Tammel		60,000	240,000

68. koht Kaius Kiidli, 67. koht Henri Käsper - mõlemad 2600 € Posted Saturday 2nd March, 2024 at 15:14(UTC+2) by maheaaatom

Kaiusel oli väga väike stäkk ning ka Henril vaid 13XBB.

Henri käsi oli omajagu cooler, nimelt läks ta 20K panusega "blinde sööma" ja sai calli Soome highrollerilt Ilari Sahamiehelt.

Flopis avati ning sealt läksid juba nupud sisse.

Henri:

Ilari:

Turn ja river midagi ei muutnud.

Player		Chips	Progress
Henri Käsper		0	0
Kaius Kiidli		0	0

72. koht Mihkel Vitsur, 71. koht Kaur-Silver Koha - mõlemad 2600 € Posted Saturday 2nd March, 2024 at 15:04(UTC+2) by maheaaatom

Veel kaks meie meest on kahjuks mängust väljas. Tõsi, vähemalt Kaur-Silver oli ka väga short.

Player		Chips	Progress
Kaur-Silver Koha		0	0
Mihkel Vitsur		0	0

Naisteturniir on kohe algamas Posted Saturday 2nd March, 2024 at 14:55(UTC+2) by maheaaatom

Põhiturniiri kõrval alustatakse kohe naisteturniiriga, kus osalevad kindlasti nii Catlin Müür kui Kairit Leibold, valitsev Eesti naistemeister Kristin Raudla kui paljud teised.

Naisteturniiri tarbeks lõhuti just ka üks põhiturniiri laud, kus istub Herli Olop. Herli suutis just viimase käega ühelt kolmpanustanud vastaselt 58K saada, surudes viimase enne floppi pangast välja. Vastase sõnul olla tal olnud, Herlil aga enda sõnul . 

"Ei hakanud ootama, muidu oleks veel pidanud Madis Müüri foldi tegema," kommenteerib Herli ise.

Meie meeste stäkke Posted Saturday 2nd March, 2024 at 14:50(UTC+2) by maheaaatom

Väga hästi on edenenud Aleksi Smirnov, kel juba 750K koos. "Ei saa kurta jah," ütleb ka mees ise. 

Kaius Kiidlil ja Kaur-Silver Kohal on vaid 10XBB, nemad vajavad hädasti duublit.

Player		Chips	Progress
Aleksei Smirnov		750,000	482,000
Ranel Käsi		520,000	322,000
Tarmo Tammel		300,000	9,000
Steven Tool		230,000	170,000
Kaido Mikk		220,000	26,000
Kaur-Silver Koha		100,000	35,000
Kaius Kiidli		100,000	37,000

74. koht Paul Koppe 2350 € Posted Saturday 2nd March, 2024 at 14:40(UTC+2) by maheaaatom

Paul üritab vastast boardil välja bluffida. 

Halb ajastus, vastas on . Jätkab 11 eestlast.

Player		Chips	Progress
Paul Koppe		0	0

Henri duubeldab emandatega Posted Saturday 2nd March, 2024 at 14:36(UTC+2) by maheaaatom

Action toimub blindidel, Gunnar Henningul , Henril . Emandad peavad, kuigi turnil saab vastane open-enderi. Meie pokkerimiljonäril nüüd umbes 230K.

Player		Chips	Progress
Henri Käsper		230,000	95,000

Parim eestlane on endiselt Herli Posted Saturday 2nd March, 2024 at 14:33(UTC+2) by maheaaatom

Kümne parima seas on hetkel vaid üks eestlane, seitsmenda stäkiga Herli Olop (700K). Turniiri on asunud juhtima leedulane Mantas Tamulevicius, kelle stäkk on ainsana ületanud juba miljoni piiri.

14:29 (UTC+2)

Start of Level 19
Blinds: 6,000/12,000     Ante: 12,000

77. koht Mark Metsla 2350 € Posted Saturday 2nd March, 2024 at 14:15(UTC+2) by maheaaatom

Mariusega sisuliselt samaaegselt kaotasime ka Mark Metsla. Ühtlasi algas ka turniiri esimene paus, alles on 74 pokkerisportlast ning eestlasi on mängus veel 12.

Player		Chips	Progress
Mark Metsla		0	0

78. koht Marius Morel 2350 € Posted Saturday 2nd March, 2024 at 14:13(UTC+2) by maheaaatom

Mariusel oli järgi 15XBB ning viimased nupud läksid sisse sisuliselt coinflipiga - vs. . Midagi vajalikku lauast ei tulnud. 

Player		Chips	Progress
Marius Morel		0	0

Tammel ei soovi riskida Posted Saturday 2nd March, 2024 at 14:06(UTC+2) by maheaaatom

Tarmo Tammel mängib olemuselt sarnase käe Marius Moreli eelmise jaotusega, callides ära positsioonil oleva vastase 63K panuse pärast floppi 

Turn on , Tarmo checkib taas ning vastane paneb nüüd juba 155K, mis on umbes pool Tarmo allesjäänud stäkist. Meie mees muckib pika mõtlemise järel. 

Mis kaartidega mängiti? Vastane väitis endal olevat , Tarmo ütles enda kaartideks . Kas ka tegelikult nii oli, seda me ei paraku teada ei saa, sest kumbki mees oma kaarte avalikult ei näidanud 

Marius annab ära Posted Saturday 2nd March, 2024 at 13:56(UTC+2) by maheaaatom

Gunnar Henning ründab blinde ja Mairus kaitseb BB-d.

Flopis on , check-12K-call.

Turni avatakse , Marius checkib taas ette ning vastane paneb juba 48K. Marius ei anna alla.

Riveri järel jätkab Marius checkimist ja Gunnar läheb oma 91K punktiga all-in. Mariusel on umbes 120K alles, kuid calli ei järgne.

Player		Chips	Progress
Marius Morel		120,000	126,000

89. koht Mairo Tori Posted Saturday 2nd March, 2024 at 13:46(UTC+2) by maheaaatom

Mairo suutis ühe duubliga küll oma stäki 80K peale saada, kuid ka seda oli vähe (10xBB). Aga cash on samuti saavutus. Jätkab 84 parimat.

Player		Chips	Progress
Mairo Tori		98,000	0

Tammel nokib naabrilt lisa Posted Saturday 2nd March, 2024 at 13:30(UTC+2) by maheaaatom

Tarmo Tammel ning tema kõrval istuv Nikita Zarovs vaatavad floppi .

Lätlane checkib ette, Tarmo paneb 15K ja saab calli.

Turn checkitakse läbi, riveri järel checkib Nikita taas ning Tarmo paneb 51K. Pike mõtlemise järel tuleb call.

Tarmo näitab , mis on panga võitmiseks piisav.

13:22 (UTC+2)

Start of Level 18
Blinds: 5,000/10,000     Ante: 10,000

Herli parandab seisu Posted Saturday 2nd March, 2024 at 13:18(UTC+2) by maheaaatom

Herli on vaikselt juurde kogunud ning hetkel juba 735K stäkiga, mis paistab olevat eestlastest suurim. Päeva lõikes seega +200K.

"Muidu on rigged värk, ma pole selle nädala jooksul veel kordagi pocket ässasid näinud," viskab mees ise nalja.

 

Player		Chips	Progress
Herli Olop		735,000	205,000

96. koht Lauri Laast 2100 € Posted Saturday 2nd March, 2024 at 13:09(UTC+2) by maheaaatom

Ka Lauri vireles ministäkiga (ca. 50K) ning pidi lükkama iga enam-vähem kaardiga.

Tegemist on muide kogenud pokkerihaiga, kes tulnud Eesti meistriks juba 2009. aastal. Viimastel aastatel pole Laurit küll suurturniiridel enam näha olnud.

Player		Chips	Progress
Lauri Laast		0	0

Põhiturniir jätkub ilma naisteta Posted Saturday 2nd March, 2024 at 12:58(UTC+2) by maheaaatom

Eestiski hästi tuntud soomlanna Anne Bezdek lõpetab põhiturniiri 100. kohaga ning kindlasti näeme me teda ka naisteturniiril, mis algab täna kell 15:00.

Anne viimased nupud läksid coinflipiga

-ga Soome highrolleri Roope Tarmo vastu, lauda kaks kuningat.

 

100 parimat Posted Saturday 2nd March, 2024 at 12:47(UTC+2) by maheaaatom

Põhiturniir on jõudnud 100 parimani, esimest money-jumpi pole veel toimunud. Esimene mees, kes esisajast välja jäi, oli "kodustatud hispaanlane" I Roura Adria Comas.

Duubli sai WSOP Circuit Tallinn põhiturniiri finalist Mairo Tori, kelle pocket kolmed laua toel majaks täienesid. Seejuures oli Mairol ka kõvasti õnne, sest vastas olid pocket emandad...

Player		Chips	Progress
Lauri Laast		0	0

Mäng läheb edasi Posted Saturday 2nd March, 2024 at 12:37(UTC+2) by maheaaatom

Tehniline paus vältas pea 15 minutit, nüüd saame edasi minna. 

"Naiste toast" on juba kuulda rõõmsat sädinat, olgugi et freeroll - aga populaarne sellegipoolest. Eestlased on siiani võitnud ainult ühe Kings of Tallinn 2024 turniiri, eks naised peavad kindlasti võtma teise. Enamasti on see meie kaunitaridel ju ka õnnestunud.

Naiste freerollil hetkel 38 mängijat Posted Saturday 2nd March, 2024 at 12:20(UTC+2) by maheaaatom

Fuajees on käimas naisteturniiri freeroll. Mängitakse freeroll-formaadis,  viis parimat saavad pilet. Umbes pooled osalejatest on eestlannad. 

Alanud on ka hiinakas, kus 18 mängijat, meie meestest mõistagi kohal Mati Pirn.

Põhiturniiril on väike tehniline paus.

109. koht Silver Simulask 2100 € Posted Saturday 2nd March, 2024 at 12:13(UTC+2) by maheaaatom

Silveri algseis oli 9xBB ning seis sama, mis paljudel - kas kiire duubel või bustout. Sel korral juhtus kahjuks viimane.

Player		Chips	Progress
Silver Simulask		0	0

116. koht Richard Koppel 2100 € Posted Saturday 2nd March, 2024 at 12:10(UTC+2) by maheaaatom

Richard alustas kolmandat päeva 10 000 punktiga, mis on alla 2XBB. Eilse päeva lõpus oli tema peamiseks eesmärgiks rahadesse jõuda ning see mehel ka õnnestus.

Esimese 5 minutiga on välja langenud juba 10 mikrostäkki.

Player		Chips	Progress
Richard Koppel		0	0

Algamas on festivali sisutihedaim päev Posted Saturday 2nd March, 2024 at 11:15(UTC+2) by maheaaatom

Tänane päev on Kings of Tallinn 2024 festivali sisutihedaim. Meie peamises fookuses on mõistagi põhiturniiri kolmas päev, mille lõppedes peaks finalistide nimekiri selge olema. 

Mõlemale high-roller turniirile on eraldi eestikeelne blogi, kuid põhiturniiri blogis hoiame silma peal ka naisteüritustel ning teistel tänastel kõrvalturniiridel.

11:11 (UTC+2)

Day 3 of Kings of Tallinn 2024 Started
Level: 17     Blinds: 4,000/8,000     Ante: 8,000