0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0076 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/141/369/updates'
ORDER BY `views` DESC
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` = '141'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '141'
0.0285 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0069 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '347'
AND `published` = 1
0.0287 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` = '369'
AND `published` = 1
0.0287 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0081 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '375'
AND `published` = 1
0.0069 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '369'
ORDER BY `busted` ASC, `current_chips` DESC
0.0094 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` = '369'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15977'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15965'
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` = '15960'
ORDER BY `chip_change` DESC, `busted` ASC
0.0099 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15954'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15951'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15942'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0099 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15930'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15915'
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` = '15912'
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` = '15910'
ORDER BY `chip_change` DESC, `busted` ASC
0.0098 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15904'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15902'
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` = '15899'
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` = '15896'
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` = '15895'
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` = '15893'
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` = '15888'
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` = '15887'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15885'
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` = '15873'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15868'
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` = '15865'
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` = '15860'
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` = '15858'
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` = '15854'
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` = '15851'
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` = '15849'
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` = '15844'
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` = '15841'
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` = '15834'
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` = '15830'
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` = '15827'
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` = '15812'
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` = '15809'
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` = '15808'
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` = '15807'
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` = '15795'
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` = '15790'
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` = '15789'
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` = '15784'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15779'
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` = '15774'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15768'
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` = '15756'
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` = '15750'
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` = '15745'
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` = '15744'
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` = '15737'
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` = '15729'
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` = '15725'
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` = '15721'
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` = '15717'
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` = '15716'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15710'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15707'
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` = '15700'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15692'
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` = '15690'
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` = '15684'
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` = '15682'
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` = '15672'
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` = '15666'
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` = '15664'
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` = '15658'
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` = '15652'
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` = '15646'
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` = '15644'
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` = '15643'
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` = '369'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '369'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '15977'
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` = '15965'
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` = '15960'
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` = '15954'
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` = '15953'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15951'
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` = '15942'
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` = '15940'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15930'
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` = '15915'
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` = '15912'
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` = '15910'
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` = '15904'
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` = '15902'
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` = '15899'
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` = '15896'
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` = '15895'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15893'
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` = '15888'
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` = '15887'
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` = '15885'
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` = '15873'
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` = '15868'
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` = '15865'
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` = '15860'
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` = '15858'
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` = '15854'
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` = '15851'
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` = '15849'
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` = '15844'
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` = '15841'
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` = '15834'
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` = '15830'
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` = '15827'
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` = '15812'
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` = '15809'
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` = '15808'
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` = '15807'
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` = '15795'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15790'
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` = '15789'
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` = '15784'
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` = '15779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0101 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15774'
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` = '15768'
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` = '15756'
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` = '15750'
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` = '15745'
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` = '15744'
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` = '15737'
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` = '15729'
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` = '15725'
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` = '15721'
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` = '15717'
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` = '15716'
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` = '15710'
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` = '15707'
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` = '15700'
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` = '15692'
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` = '15690'
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` = '15684'
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` = '15682'
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` = '15672'
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` = '15666'
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` = '15664'
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` = '15658'
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` = '15652'
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` = '15646'
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` = '15644'
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` = '15643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '375'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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
Translate
English
Deutsch
Français
Italiano
Español
Português
Čeština
Dansk
Polski
Română
Svenska
Norsk
Suomi
Eesti
Malti
עברית
العربية
Lietuvių
Български
Nederlands
Ελληνικά
Русский
Olympic Park Casino
Event #6: €1M GTD €1,500 Main Event (Estonian)
Live Reporting - Day 4
14. koht Marius Morel 9200 € Posted Saturday 27th July, 2024 at 23:35(UTC+2) by maheaaatom
Juba järgmises jaotuses kordub sama, mis eelmises, seekord on aga kahjuks ohvriks meie Marius Morel.
Jeffrey Cormier avab 225K-ga ja Marius vajutab oma 745K stäki keskele. Enea Subashi jõuab veel foldida , kuid Jeffreylt tuleb mõistagi call.
Marius:
Jeffrey:
Lauda
Sellega lõpetame ka põhiturniiri eestikeelse blogi. Turniiri jätkab kuraditosin mängijat, kellest üheksa jõuab finaallauda ning 4 ei jõua. Sergeile, Evgenyle ja teistele lemmikutele saate elada kaasa läbi TV-streami ning ingliskeelse blogi. Samuti soovitame jälgida highrolleri live-blogi, mis valmib hetkel ka eestikeelsena.
Finaallauast valmib TV-ülekanne ning värsked päevakokkuvõtted leiate ka nii pühapäeval kui esmaspäeval Olybet.TV keskkonnast.
Player
Chips
Progress
Marius Morel
0
0
Kaotasime viimase naismängija Posted Saturday 27th July, 2024 at 23:27(UTC+2) by maheaaatom
Värvikas Kanada pokkeriäss Jeffrey Cormier avab 160K-ga ning norralanna Vilde Bystol Fagerbakke lükkab oma 1,2M stäki keskele. Jeff mõtleb, kuid call siiski tuleb.
Jeffrey:
Vilde:
Lauda ebaoluline numbripuru, mis midagi ei muuda. Neljade paar peab.
Parim naine teenib 9200 eurot. Marius on selgelt telelaua väiksem stäkk 745 000 punktiga.
423 sisseostu deep-stackil Posted Saturday 27th July, 2024 at 23:15(UTC+2) by maheaaatom
350 € NLH DeepStack turniiril tehti koguni 423 sisseostu ning nagu arvata võis, osutus turniir erakordselt menukaks. Deep-stack küll, kuid küllaga on neidki, kes tegid kolm või enam re-entryt.
Online-turniiril on hetkeseisuga väike overlay, osalejaid peaks olema 147. 250 € NLH Bountyl on käimas heads-up kahe lätlase vahel, naisteka ning kokku 2660 eurot auhinnaraha võitis soomlanna Tiina Maria Rantamäki.
22:59 (UTC+2)
Start of Level 30 Blinds: 50,000/100,000 Ante: 100,000
Sergei on ära andnud Posted Saturday 27th July, 2024 at 22:59(UTC+2) by maheaaatom
Sergei on kaotanud mitu panka, igaühega on midagi läinud. Tal hetkel 2,2M järgi ning liidrite sekka Sergei sellega kahjuks enam ei kuulu.
Evgenyl on rohkem - umbes 2,8M. See on peaaegu sama palju kui keskmine stäkk.
Player
Chips
Progress
Evgeny Vyal
2,800,000
1,100,000
Sergei Aleksejev
2,200,000
1,800,000
Liisile naistekalt neljas koht Posted Saturday 27th July, 2024 at 22:55(UTC+2) by maheaaatom
Liisi Voltri oli paraku ainus Eesti naine, kes Queens Mystery Bounty'l cashis. Tasuks 360 eurot ning neljas koht. Abiks ikka!
Jätkame 15-kesi Posted Saturday 27th July, 2024 at 22:44(UTC+2) by maheaaatom
Mitte-telelauast langes Norra pokkerimängija Sohrab Malkari, kes jäi oma keskmisest stäkist ilma kahe jaotusega. Neist esimene oli bad beat, teine aga "aus kaotus". Eesti mängijad kummaski jaotuses ei osalenud.
Liisi jätkab võitlust Posted Saturday 27th July, 2024 at 22:36(UTC+2) by maheaaatom
Põhiturniir läks just uuesti käima ning heitsime pilgu ka naistekale, kus on alles neli mängijat.
Nende seas on meie Liisi Voltri. Turniiril on üks väga suur stäkk, ülejäänud kolm on üsna võrdsed.
Table break Posted Saturday 27th July, 2024 at 22:08(UTC+2) by maheaaatom
16 mängijat on järgi ning me jätkame kahel laual. Marius jääb telelauda, ülejäänud kaks Eesti mängijat kolivad "reaalaega". Oleme 20-minutilisel tehnilisel vaheajal.
Evgeny julge call kukutab kanadalanna Posted Saturday 27th July, 2024 at 21:35(UTC+2) by maheaaatom
Evgeny avab 125K tõstega ning Kanada naismängija Nohad Teliani lükkab all-in (1,1M). Evgeny mõtleb pikalt, otsustades siiski viimaks callida.
Nohad:
Evgeny:
Lauda
Seega on turniiri parim naine Vilde Bystol Fagerbakke. Oleks väga uhke, kui tal õnnestuks ka finaali jõuda. Hetkel on naisel natuke alla keskmise stäkk.
Player
Chips
Progress
Sergei Aleksejev
4,000,000
400,000
Evgeny Vyal
3,900,000
1,100,000
Marius Morel
1,900,000
200,000
21:24 (UTC+2)
Start of Level 29 Blinds: 40,000/80,000 Ante: 80,000
Stäkkide seis Posted Saturday 27th July, 2024 at 21:23(UTC+2) by maheaaatom
Player
Chips
Progress
Sergei Aleksejev
3,600,000
125,000
Evgeny Vyal
2,800,000
215,000
Marius Morel
2,100,000
100,000
Algas tänane viimane kõrvalturniir Posted Saturday 27th July, 2024 at 21:12(UTC+2) by maheaaatom
250 € PLO 4&5 Progressive Bounty on läinud käima ning laudades 40 mängijat. Nende seas oli näha ka kõva Omaha-ässa Kristjan Abakanovit, keda pole siiani sel festivalil veel näha olnud.
Lisaks on täna kavas ka üks 80-eurone satelliit homme toimuvale viimasele sõrmuseturniirile (Ring Event #12 WSOPC 555 € NLH Progressive Bounty). Garanteeritud on 5 kohta, kuid senine praktika näitab, et neid läheb mängu kindlasti rohkem.
Mariusel on soomlase vastu õnne Posted Saturday 27th July, 2024 at 21:07(UTC+2) by maheaaatom
Alles oli juttu viimasest soomlasest, nüüd võite siis ka lugeda, kuidas ta välja kukkus.
Marius Morel avab 120K tõstega, Matte Karjalainen vastab 520K all-in'iga ning Marius teeb pika tankimise järel calli.
Matte:
Marius:
Flop annab Mariusele open-enderi ja turn toob selle ka kohale. River soomlast ei päästa. Mariusel nüüd 2,2M.
Player
Chips
Progress
Marius Morel
2,200,000
650,000
Naistekal on kõik lootused Liisil Posted Saturday 27th July, 2024 at 21:01(UTC+2) by maheaaatom
Naisteturniiril on selgunud 11 parimat, kelle seas ka kolm Eesti mängijat. Neist on suurima stäkiga Liisi Voltri, kellel on natuke üle keskmise. Tiitlikaitsja Ave on kahjuks väljas.
Algas internetis toimub sõrmuseturniir Posted Saturday 27th July, 2024 at 20:56(UTC+2) by maheaaatom
Kõik, kes ei viitsi kasiinosse kohapeale tulla, saavad sellegipoolest WSOP kuldsõrmuse võita.
Tuleb vaid osaleda OlyBetis toimuval 350 € sisseostuga WSOP Circuit Tallinn Ring Event'il, millel on muide korralik 50 000-eurone garantii. Hiline registeerumine vältab kuni kella 23:30-ni.
Kas jõuame südaööks finaallauda? Posted Saturday 27th July, 2024 at 20:53(UTC+2) by maheaaatom
Hetkeseisuga olema eelmise aasta tempost umbes viis tundi maas, mis võiks tähendada, et kuskil südaööks peaks finaallaud koos olema. Samas mängiti mullu ka ebanormaalselt kõrge tempoga.
Must päev soomlastele Posted Saturday 27th July, 2024 at 20:49(UTC+2) by maheaaatom
Küünikud kipuvad ütlema, et kui endal läheb halvasti, aga naabritel veel halvenini, siis on kõik ju hästi.
Fakt on see, et soomlastel läks tõesti põhiturniiril kehvasti, sest nende parimaks jäi Matte B.P. Karjalaineni 20. koht. Ka lätlasi on sees vaid üks ning temagi üsna väikese stäkiga.
20:34 (UTC+2)
Start of Level 28 Blinds: 30,000/60,000 Ante: 60,000
Eesti mängijad jätkavad telelauas Posted Saturday 27th July, 2024 at 20:33(UTC+2) by maheaaatom
Kõik kolm Eesti mängijat jätkavad telelauas, seepärast on ka meie blogi 30-minutilise viivitusega ning liigub telelaua sünkroonis.
Vahepeal katsume hoida silma peal ka teistel turniiridel.
Player
Chips
Progress
Sergei Aleksejev
3,725,000
875,000
Evgeny Vyal
3,015,000
1,415,000
Marius Morel
1,550,000
450,000
Kes on Sergei Aleksejev ja Evgeny Vyal? Posted Saturday 27th July, 2024 at 20:30(UTC+2) by maheaaatom
Paljud huvilised on küsinud, et kes on Eesti mängijad Sergei Aleksejev ning Evgeny Vyal? Uurisime siis järgi.
Evgeny oli üsna napisõnaline - enda väitel elab Tallinnas, kuid Eestis sündinud ei ole. Pokkerit ei mängi just kuigi sageli.
Sergei Aleksejev on aga põline Maardu mees, kes varemgi Eestis toimuvatel suurfestivalidel osalenud. "Ma mängingi ainult suurematel üritustel, väikeste sisseostudega turniiridel ma tõesti ei osale. Võib-olla seepärast mind eestlased siiani väga ei tunnegi," selgitas Sergei.
Nüüd on aga Sergeil aga hea võimalus ka Eesti kommuunis tuntuks saada, kui mäng jätkub sama edukalt kui siiani. Lõpuni on muidugi veel pikk tee minna.
Lähme sööma! Posted Saturday 27th July, 2024 at 19:23(UTC+2) by maheaaatom
Kõik põhiturniiril jätkajad lubatakse 60 minutiks puhkama ning otsustavaks lahinguks jõudu koguma, teeme seda meiegi.
Kolme Eesti mängija käekäigule saate veel elada kaasa 30 minuti jooksul TV-lauas, kus nad kõik ka viibivad.
23. koht Aleksei Vandyshev 6100 € Posted Saturday 27th July, 2024 at 19:14(UTC+2) by maheaaatom
Väga lühikeseks jäänud Aleksei lükkas oma nupud sisse pärast floppi
Huvilisi oli aga teisigi, kes jätkasid panustamist ka pärast turni. Paistis, et tõmmatakse masti.
Kuna river masti ei toonud, checkiti see läbi ning täpselt nii oligi. vs. vs. Aleksei ! Pank korjati seega maha üheksate paariga ning Aleksei on mängust väljas.
Aleksei Vandyshev elab Austrias kuigi ta mängis turniiri Eesti lipu all, pole mehel enda väitel Eestiga muud seost kui see, et ta on hetkel siin aega veetmas. "Ma isegi ei tea, miks mind Eesti mängijaks liigitati," naerab Aleksei ise. Aga see selleks - mees tegi siiski toreda mängu ning tasuks kenad 6100 eurot.
Player
Chips
Progress
Aleksei Vandyshev
0
0
Telelauas suuremate muutusteta Posted Saturday 27th July, 2024 at 19:02(UTC+2) by maheaaatom
Marius on natuke juurde saanud ning hetkel 1,1M stäkiga. Turniiri liider on endiselt Sergei Aleksejev.
Endiselt 23 mängijat alles ning sellist tempot nagu eelmisel aastal, kindlasti ei ole. Septembris olid selleks ajaks juba finalistid teada.
Player
Chips
Progress
Marius Morel
1,100,000
340,000
Eesti mängijate stäkid Posted Saturday 27th July, 2024 at 18:52(UTC+2) by maheaaatom
Player
Chips
Progress
Sergei Aleksejev
4,600,000
130,000
Evgeny Vyal
1,600,000
50,000
Aleksei Vandyshev
1,250,000
150,000
Marius Morel
760,000
100,000
Kuidas meie naistel läheb? Posted Saturday 27th July, 2024 at 18:47(UTC+2) by maheaaatom
Naisteturniir käib kolmel laual ning eestlannasid on sees täpselt seitse (kokku tehti 46 sisseostu). "Huvitav, et naisi nii vähe on," imestas naiste sõrmuseturniiril viiendaks tulnud Kristiina, kes sai ise pileti freerollilt.
Meie parimatena on Liisi Voltril ja Ave Lepikul napilt üle keskmise stäkk, kuid mänguruumi on veel kõigil.
24. koht Kaspar Kaisel 5400 € Posted Saturday 27th July, 2024 at 18:34(UTC+2) by maheaaatom
Kaspar Kaiselil oli enne viimast kätt vaid 270K järgi ning saatus andis talle hea võimaluse oma stäkk vähemalt duublisse saada.
Kahjuks läks aga teisiti. All-in mingi -ga Aleksei Vandyshevi vastu. Turnis avati neli. No ei vea eestlastel täna ikka kohe kuidagi...
Player
Chips
Progress
Kaspar Kaisel
0
0
18:28 (UTC+2)
Start of Level 27 Blinds: 25,000/50,000 Ante: 50,000
Aleksei annab ära Posted Saturday 27th July, 2024 at 18:26(UTC+2) by maheaaatom
Roberto Ahane Olsen avab 80K tõstega ning Aleksei Vandyshev kaitseb BB-d.
Flop on . Aleksei checkib ette, Rootsi mängija paneb 60K ning Aleksei teeb ületõste 235K-le. Järgneb vastase all-in (tema stäkk on meie mehest selgelt väiksem) ning Aleksei instafold.
1100 € NLH Mystery Bounty meistrisõrmus läks Soome Posted Saturday 27th July, 2024 at 18:17(UTC+2) by maheaaatom
Kell 13:00 alanud 1100 € NLH Mystery Bounty finaal on nüüdseks lõppenud soomlaste kaksikvõiduga. Rasmus J. M. Lundström sai meistrisõrmuse ning 19 850 eurot, teiseks tulnud Akseli Timonpoika Paalanen teenis aga tänu pearahadele enamgi - 29 380 eurot. Järgnesid kaks itaallast, ainsa eestlasena teise päeva jõudnud Anti Reinthal lõpetas mäletatavasti 12. kohaga.
Põhiturniiril on muide sees vaid kaks soomlast ehk nagu Soome reporter Juhani juba naljatles: "Tegemist on väga kurva päevaga Soome pokkerile." Aga võrreldes eestlastega on põhjanaabritel ikka väga hästi läinud. Eestlased pole saanud tänavu WSOP Circuit meistrisõrmust isegi mitte nuusutada.
Mäng on rahulik Posted Saturday 27th July, 2024 at 18:11(UTC+2) by maheaaatom
Põhiturniiril on laudades endiselt 24 mängijat ning kiiret ei paista kellelegi olevat.
Päeval alanud 250 € NLH on lähenemas mullimängule, kuid eestlasi on kahjuks sees ainult üks - Priit Vanem.
Naisteturniiri populaarsus jääb selgelt alla nädala alguses toimunud sõrmuseturniirile, sest tehtud on vaid 45 sisseostu (käimas re-entry paus, mil võib veel turniiriga liituda). Eestlasi on osalejate seas natuke alla poole.
350 € NLH deepstack ligineb juba 200 sisseostule, kuid see mäng on veel väga noor.
Kaspar annab valusa duubli Posted Saturday 27th July, 2024 at 17:55(UTC+2) by maheaaatom
Ignotas Tamasauskas avab 80K tõstega, Kaspar Kaisel lükkab BB-lt all-in. Ignotas praeb mitu minutit, otsustades viimaks siiski callida (tema stäkk ca. 835K).
Ignotas:
Kaspar:
Flop on meie mehele väga soodne ning Ignotas tõuseb juba istmelt püsti.
Turn on juba ohtlik.
Ja riverisse sajabki ehk backdoor mast!
Kasparil jääb umbes 500K järgi.
Player
Chips
Progress
Kaspar Kaisel
500,000
875,000
Eesti mängijate täpsed stäkid Posted Saturday 27th July, 2024 at 17:49(UTC+2) by maheaaatom
Player
Chips
Progress
Sergei Aleksejev
4,470,000
970,000
Evgeny Vyal
1,550,000
150,000
Kaspar Kaisel
1,375,000
75,000
Aleksei Vandyshev
1,100,000
300,000
Marius Morel
860,000
370,000
Jätkame Posted Saturday 27th July, 2024 at 17:41(UTC+2) by maheaaatom
Eestlasi on mängus viis, neist telelauas kolm: Evgeny Vyal, Marius Morel ning Sergei Aleksejev. TV-ülekanne on 30-minutilise viivitusega, seega peaks seda saama näha alates kella 18:07-st.
Aleksei Vandyshev ning Kaspar Kaisel on teises lauas, kolmandas omasid pole.
25. koht Igor Pihela noorem 5400 € Posted Saturday 27th July, 2024 at 17:17(UTC+2) by maheaaatom
Kahjuks on välja langenud ka Igor Pihela noorem. Viimased 17XBB läksid sisse -ga Sergei Aleksejevi vastu, turn äss.
Jätkatakse kolmel laual, mis kõik kolitakse fuajeesse. Tõenäoliselt saame varsti siiski jätkata ka telelauas.
15-minutiline tehniline paus.
Player
Chips
Progress
Sergei Aleksejev
4,300,000
800,000
Igor Pihela noorem
0
0
17:10 (UTC+2)
Start of Level 26 Blinds: 20,000/40,000 Ante: 40,000
VIDEO: Põhiturniiri teise päeva kõrghetked Posted Saturday 27th July, 2024 at 17:09(UTC+2) by maheaaatom
27. koht Mairo Tori 5400 € Posted Saturday 27th July, 2024 at 17:08(UTC+2) by maheaaatom
2023. aasta WSOP Circuit Tallinn põhiturniiril kõrge viienda koha saanud Mairo Tori lõpetab sel korral 27-ndana. Ka üldsegi mitte paha tulemus, tasuks 5400 eurot.
Mairo vaevles täna kehva kaardijooksu küüsis ning tema stäkk oli viimasel tunnil-kahel väga väike. Oleks läinud vaja kahte õnnetunud duublit, kuid paraku ei seda ei juhtunud.
Jätkab 25 parimat, eestlasi on sees kuus.
Player
Chips
Progress
Mairo Tori
0
0
Sergei elimineerib vastase ja teenib kõvasti lisa Posted Saturday 27th July, 2024 at 16:51(UTC+2) by maheaaatom
Lauas on ning pangas umbes 500K.
Sergei Aleksejev lükkab oma nupud keskele ning saab viimaks calli Eriks Kruminsilt.
Sergei:
Eriks:
Turn ega river midagi ei muuda. Konkurent väljas ning Sergei stäkk nüüd umbes 3,5M.
Player
Chips
Progress
Sergei Aleksejev
3,500,000
1,400,000
VIDEO: Kaheksanda päeva kokkuvõte Posted Saturday 27th July, 2024 at 16:39(UTC+2) by maheaaatom
Igor kaotas poole oma stäkist Posted Saturday 27th July, 2024 at 16:32(UTC+2) by maheaaatom
PFAI olid umbes 500K stäkiga norralane Gunnar Wedde ning meie Igor Pihela noorem.
Gunnar:
Igor:
Lauast abi ei tulnud, Igoril jäi umbes 500K alles.
Player
Chips
Progress
Igor Pihela noorem
500,000
850,000
Järgmine sõrmusejaht algab kell 17:00 Posted Saturday 27th July, 2024 at 16:19(UTC+2) by maheaaatom
Täna kell 17:00 algab kümnes sõrmuseturniir, 350 € NLH Deepstack, kus hiline registeerumine on lubatud kuni kella 23:00-ni. Tegemist on festivali mõttes suhteliselt "odava sisseostuga" turniiriga, lisaks on ka struktuur sügav ning võimalusi mängida küllaga. Seega peaks see sobima hästi ka paljudele hobimängijale ning mängima oodatakse väga palju inimesi.
NB! Tegemist on kahepäevase turniiriga, mis leiab oma lõpplahenduse homme.
Eestlaste stäkid suurest saalist Posted Saturday 27th July, 2024 at 16:15(UTC+2) by maheaaatom
Player
Chips
Progress
Aleksei Vandyshev
2,600,000
2,090,000
Sergei Aleksejev
2,600,000
500,000
Aleksei Vandyshev
1,400,000
890,000
Igor Pihela noorem
1,350,000
250,000
Kaspar Kaisel
1,300,000
600,000
Marius Morel
1,230,000
10,000
Mairo Tori
310,000
70,000
Jätkame Posted Saturday 27th July, 2024 at 16:02(UTC+2) by maheaaatom
Telelaua ülekanne on ajutiselt peatatud, seetõttu jätkavad neli lauda suures saalis ning viies fuajees. Põhjus on proosaline - telelaua kohal olev vahelagi laseb vett läbi ning äsja käis Tallinnast üle ka vihmahoog.
Millal TV-ülekanne jätkub, pole hetkel veel teada, kuid blogi kajastab endiselt kõike, mis puudutab Eesti mängijaid.
Endiselt 33 mängijat ja 7 eestlast. Kõige hapumas seisus on Mairo Tori, kes kaebas pausi ajal kehva kaardijooksu üle. "Aga mul oleks vaja kaks duublit ja oleksin täiesti mängus tagasi," jäi Mairo optimistlikuks.
15:55 (UTC+2)
Start of Level 25 Blinds: 15,000/30,000 Ante: 30,000
Suure saali stäkid Posted Saturday 27th July, 2024 at 15:28(UTC+2) by maheaaatom
Algas tänane teine paus, kuhu läheb 33 mängijat. Eestlasi on sees seitse, neist viis "suures saalis" ja kaks telelauas.
Player
Chips
Progress
Sergei Aleksejev
2,100,000
900,000
Evgeny Vyal
1,700,000
400,000
Igor Pihela noorem
1,600,000
100,000
Marius Morel
1,240,000
10,000
Mairo Tori
240,000
230,000
Algas 150 € naisteturniir Posted Saturday 27th July, 2024 at 15:21(UTC+2) by maheaaatom
Äsja alanud 150 € Queens Mystery Bounty't alustas 17 mängijat, teiste seas tiitlikaitsja Ave Lepik.
Naisi tuleb aga kindlasti juurde, sest ainuüksi freerollil antakse välja veel viis kohta (hetkel sees 7 mängijat, kellest 5 Eestist). Hiline registeerumine kestab kuni 18:10-ni.
Kaspar duubeldas läbi Aleksei Posted Saturday 27th July, 2024 at 15:14(UTC+2) by maheaaatom
Veel üks vinge jaotus telelauast. Aleksei Vandyshev'i 250K kolmpanusega vaatasid nii tema kui Kaspar Kaisel floppi .
Aleksei panustas 125K ning sai Kasparilt calli.
Turnis avati , Alekseilt check, Kasparilt 160K ning Alekseilt call.
Riveri järel checkis Aleksei taas ning instacallis seejärel Kaspari 395K all-in panust.
Aleksei:
Kaspar:
Pank oli tubli 1,9M, Alekseil jäi 510K alles.
Player
Chips
Progress
Kaspar Kaisel
1,900,000
930,000
Aleksei Vandyshev
510,000
990,000
40. koht Paul Koppe 3850 € Posted Saturday 27th July, 2024 at 15:11(UTC+2) by maheaaatom
Telelauas avab Jarkko Juhani Suokas 50K tõstega ning Paul Koppe läheb all-in (335K). Soomlaselt call.
Jarkko:
Paul:
Lauast abi ei tule.
Kolmandat päeva liidrina alustanud Paulile sai eelkõige saatuslikuks ülimalt valus kaotus 2-outerile, mis jättis talle alles vaid 300 000 punkti.
Player
Chips
Progress
Paul Koppe
0
0
Evgeny flippas leeduka välja Posted Saturday 27th July, 2024 at 14:55(UTC+2) by maheaaatom
Kasparas Klezys jammis buttonilt 530K ning Eesti mängija Evgeny Vyal mõtles SB-l pikalt, kas soovib enam kui poole oma stäkiga riskida või mitte. Aga call viimaks siiski ikkagi tuli.
Kasparas: Evgeny:
Kasparas jäi ette kuni riverini, mis oli äss. Evgenyl nüüd umbes 1,3M.
Player
Chips
Progress
Evgeny Vyal
1,300,000
200,000
Igor on sõiduvees Posted Saturday 27th July, 2024 at 14:45(UTC+2) by maheaaatom
Igor Pihela noorem hoiab oma lauas tugevat joont ega lase vastastel naljalt floppe vaadata. Kui vaja, teeb enne floppi tugeva kolmpanuse ja korjab nii vähehaaval nööpe.
Igori stäkk hetkel juba 1,5M.
Kahjuks pole häid uudiseid 1100 € Mystery Bounty'lt. Anti Reinthal langes välja 12. kohaga (1900 €) ning enam mängus ühtegi eestlast ei ole.
Player
Chips
Progress
Igor Pihela noorem
1,500,000
300,000
Kui kaua võiks täna minna? Posted Saturday 27th July, 2024 at 14:36(UTC+2) by maheaaatom
Meenutame, et eelmisel aastal käis kolmas päev tõelises turboformaadis - 60 mängija pealt jõuti üheksani kõigest kuue ja poole tunniga! Jah, te lugesite õieti.
Tänavu on mängijaid siiski natuke rohkem (kolmandat päeva alustas 68) ning struktuur aeglasem. Ja eelmine aasta mängiti tõesti ahvikiirusel. Hinnanguliselt jõuame seega finaallauni ikkagi pigem alles hilisõhtul.
Kaks naist Posted Saturday 27th July, 2024 at 14:31(UTC+2) by maheaaatom
Põhiturniiril on lisaks 39 mehele endiselt mängus ka kaks naist - Nohad Teliani Kanadast ning Vilde Bystol Fagerbakke Norrast. Mõlemal on täiesti korralik stäkk - Vildel umbes keskmine ja Nohadil umbes 75% keskmisest.
Mullu sai Eestis korduvalt hästi mänginud soomlanna Anna-Mari Hursti parima naisena 20. koha, kas sel korral suudetakse see tulemus ületada?
14:26 (UTC+2)
Start of Level 24 Blinds: 10,000/25,000 Ante: 25,000
Kõikide mängus olevate eestlaste stäkid Posted Saturday 27th July, 2024 at 14:25(UTC+2) by maheaaatom
Põhiturniiril on sees 8 Eesti mängijat, neist kolm telelauas ning viis suures saalis.
Keskmine stäkk on kerkinud juba üle miljoni (umbes 50XBB), kuid mänguruumi on veel kõigil.
Player
Chips
Progress
Aleksei Vandyshev
1,500,000
810,000
Marius Morel
1,250,000
0
Sergei Aleksejev
1,200,000
920,000
Igor Pihela noorem
1,200,000
0
Evgeny Vyal
1,100,000
400,000
Kaspar Kaisel
970,000
580,000
Paul Koppe
510,000
60,000
Mairo Tori
470,000
280,000
Igoril 1,2M, kuid võinuks olla rohkem... Posted Saturday 27th July, 2024 at 14:17(UTC+2) by maheaaatom
Igor Pihela on veel oma stäkki kasvatanud ning 1,2M punkti tundub nagu hea.
Aga...äsja mängiti võimas pank, kus Igor avas 40K, SB tõstis 175K, BB läks all-in 850K ning ka Igor tegi sama (950K) stäkiga. SB foldis seejärel .
Igor avas , vastas .
Meie mees sai veel lauast mastitõmbe, kuid tulemuseks siiski vaid panga poolitamine. Jah, Igoril võinuks ju kõikide loogika reeglite kohaselt olla juba 2,2 miljonit...
Endiselt 41 mängijat järgi.
Player
Chips
Progress
Igor Pihela noorem
1,200,000
700,000
46. koht Risto Pärnat, 42. koht Andre Villandberg - mõlemad 3850 Posted Saturday 27th July, 2024 at 14:03(UTC+2) by maheaaatom
Ristol oli üliväike stäkk ning see läks sisse -ga vastu. Flopis avati nii äss kui kuningas, kuid päästvat rida turn ega river Ristole ei toonud. Samuti on kahjuks väljas Andre Villandberg.
Jätkab 41 parimat.
Player
Chips
Progress
Andre Villandberg
0
0
Risto Pärnat
0
0
Anti võitleb Mystery Bounty'l Posted Saturday 27th July, 2024 at 13:52(UTC+2) by maheaaatom
Blogivälistest ülekannetest on 1100 € NLH Mystery Bountyl mängus 17 parimat, ainsa eestlasena Anti Reinthal. Kuigi suur Anti stäkk just ei ole, kuid Anti on teada-tuntud vana võitleja.
Suurim bounty on sel turniiril koguni 20 000 eurot, seega läheb varsti põnevaks sikutamiseks.
Käimas on ka naiste freeroll kell 15:00 algavale 150 € naistekale (38 osalejat) ning alanud on 250 € NLH Bounty (hetkel 91 sisseostu).
Mairole väike skalp Posted Saturday 27th July, 2024 at 13:41(UTC+2) by maheaaatom
Mairo Tori avas CO-lt 45K, Christoffer Berggren aga jammis oma 5XBB stäki keskele ning see oli mõistagi Mairolt kindel call.
Christopher: Mairo:
Laud tõi Mairole rea. Tema stäkk nüüd 750K.
Player
Chips
Progress
Mairo Tori
750,000
50,000
Igor hävitas vastase ässad Posted Saturday 27th July, 2024 at 13:36(UTC+2) by maheaaatom
Igor Pihelal on kena miljon koos ning stäkk sellega üle keskmise. Kuidas tal õnnestus see saada?
Väga heas seisus on ka Eesti pokkerimängijad Evgeny Vyal ja Sergei Aleksejev, mõlemal tublisti üle miljoni punkti.
Player
Chips
Progress
Evgeny Vyal
1,500,000
0
Sergei Aleksejev
1,300,000
1,020,000
Igor Pihela noorem
1,000,000
500,000
Alustab telelaud Posted Saturday 27th July, 2024 at 13:26(UTC+2) by maheaaatom
Paul Koppe ja Co viidi telelauda, mis alustab väikse hilinemise järel. Seega saab TV-ülekannet vaadata umbes alates kella 13:55-st ning nähtav on see ikka siit.
Põhiturniir läheb edasi, algas 23. tase. Alles 49 parimat.
13:24 (UTC+2)
Start of Level 23 Blinds: 10,000/20,000 Ante: 20,000
Täna on hea päev võitmiseks! Posted Saturday 27th July, 2024 at 13:04(UTC+2) by maheaaatom
Nii arvab Igor Pihela noorem, kes just duubli sai ning täpselt poole miljoni peale tõusis.
Ka Paul Koppe on paar blufiga lisa saanud ning hetkel on mehe stäkk 580K. Väga hästi on edenenud nii Kaspar Kaisel kui Marius Morel.
Algas tänane esimene paus 20 minutit.
Player
Chips
Progress
Kaspar Kaisel
1,550,000
85,000
Marius Morel
1,250,000
145,000
Mairo Tori
700,000
200,000
Paul Koppe
570,000
270,000
Igor Pihela noorem
500,000
255,000
Andre Villandberg
450,000
130,000
Risto Pärnat
150,000
175,000
51. koht Ermo Kosk 3850 € Posted Saturday 27th July, 2024 at 12:56(UTC+2) by maheaaatom
Üldises möllus oleme kaotanud ka seitsmekordse Eesti meistri Ermo Kose, kes alustas tänast päeva mängitava, kuid siiski selgelt alla keskmise stäkiga (umbes 30xBB).
Viimaseks käeks jäiJarkko Suokase pocket ässade vastu.
Player
Chips
Progress
Ermo Kosk
0
0
Paul saab ülivalusa kaotuse Posted Saturday 27th July, 2024 at 12:51(UTC+2) by maheaaatom
Yurii Zabrodotskyi (B) ja Paul Koppe (SB) vaatavad viimase 150K kolmpanuse peale floppi .
Paul paneb 225K ning ukrainlane teeb calli (hiljem väidab, et misclick).
Turn on , Paulilt jätkupanus ning lõpuks on mõlemad mehed all-in.
Paul:
Yurii: ja eestlane drawing dead.
Paulil jääb umbes 300K järgi. Suht karm algus Eesti mängijatele...
Player
Chips
Progress
Paul Koppe
300,000
1,360,000
58. koht Andre Grigorijev, 56. koht Mauri Dorbek - mõlemad 3550 € Posted Saturday 27th July, 2024 at 12:39(UTC+2) by maheaaatom
Mauri käsi käis kohe erakordselt kehvast - nupud läksid sisse pärast 3-betitud floppi Sohrab Malkari vastu.
Sohrab:
Mauri:
Turn ... No mis sa hing oskad teha...
Väljas ka eile väga heas seisus olnud, kuid oma suurest stäkist samuti ässade paariga ilma jäänud Andre Grigorijev. Tema viimaseks käeks jäi flip -ga Jarkko Suokase vastu. Soomlasele flopist maja.
Player
Chips
Progress
Mauri Dorbek
0
0
Andre Grigorjev
0
0
60. koht Artur Külanurk, 63. koht Markku Koplimaa, 64. koht Steven Tool - kõik 3550 € Posted Saturday 27th July, 2024 at 12:27(UTC+2) by maheaaatom
Päeva algus on kiire, lühikese ajaga kaotasime veel kolm lühikese stäkiga eestlast, neist Steven Tool oli lausa ekstra-short.
Aga out on ka Markku Koplimaa ning mullu sel turniiril kolmandaks tulnud Artur Külanurk.
Jätkab 58 parimat, blindid 10000/15000/15000 (tase 22).
Player
Chips
Progress
Steven Tool
0
0
Markku Koplimaa
0
0
Artur Külanurk
0
0
68. koht Martin Piik Posted Saturday 27th July, 2024 at 12:15(UTC+2) by maheaaatom
Martin näitas ülihead mängu avapäeval, kuid teisel jäi umbes samale tasemele ning kuigi heaks oma stäkki just ei saanud. Tema on kahjuks ka tänane esimene langeja.
Mängijad on taas laudades Posted Saturday 27th July, 2024 at 12:13(UTC+2) by maheaaatom
Action on alanud ning täna ootab meid ees pikk mängupäev kuni finaallauni. Kõik 68 mängijat paistavad ka laudades istuvat.
Alanud on ka high-roller, millest valmib samuti live-blogi Mariliisi tegemisel. Hoidke sellelgi silma peal!
12:11 (UTC+2)
Day 3 of Olympic Park Casino Started Level: 22 Blinds: 10,000/15,000 Ante: 15,000
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
, kuid Jeffreylt tuleb mõistagi call.
annab Mariusele open-enderi ja turn 
toob selle ka kohale. River 
vs. Aleksei 
. Aleksei checkib ette, Rootsi mängija paneb 60K ning Aleksei teeb ületõste 235K-le. Järgneb vastase all-in (tema stäkk on meie mehest selgelt väiksem) ning Aleksei instafold.
on meie mehele väga soodne ning Ignotas tõuseb juba istmelt püsti. 
.
järel checkis Aleksei taas ning instacallis seejärel Kaspari 395K all-in panust.
-ga, flopis 
. Läksime sisse, vastas ässad. Turn õnneks ruutu," kõlab Igori lühikirjeldus.
