0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0071 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/56/166/updates'
ORDER BY `views` DESC
0.0003 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` = '56'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '56'
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '166'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '167'
AND `published` = 1
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0055 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '168'
AND `published` = 1
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '166'
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` = '166'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7214'
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` = '7213'
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` = '7212'
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` = '7211'
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` = '7210'
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` = '7209'
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` = '7208'
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` = '7207'
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` = '7206'
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` = '7205'
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` = '7204'
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` = '7203'
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` = '7202'
ORDER BY `chip_change` DESC, `busted` ASC
0.0171 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7201'
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` = '7200'
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` = '7199'
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` = '7198'
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` = '7197'
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` = '7196'
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` = '7195'
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` = '7194'
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` = '7193'
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` = '7192'
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` = '7191'
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` = '7190'
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` = '7189'
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` = '7188'
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` = '7187'
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` = '7186'
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` = '7185'
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` = '7184'
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` = '7183'
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` = '7182'
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` = '7181'
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` = '7180'
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` = '7179'
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` = '7178'
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` = '7177'
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` = '7176'
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` = '7175'
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` = '7174'
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` = '7173'
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` = '7172'
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` = '7171'
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` = '7170'
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` = '7169'
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` = '7167'
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` = '7168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '166'
ORDER BY `busted` ASC, `current_chips` DESC
0.0055 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` = '166'
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` = '7214'
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` = '7213'
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` = '7212'
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` = '7211'
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` = '7210'
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` = '7209'
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` = '7208'
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` = '7207'
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` = '7206'
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` = '7205'
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` = '7204'
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` = '7203'
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` = '7202'
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` = '7201'
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` = '7200'
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` = '7199'
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` = '7198'
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` = '7197'
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` = '7196'
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` = '7195'
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` = '7194'
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` = '7193'
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` = '7192'
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` = '7191'
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` = '7190'
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` = '7189'
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` = '7188'
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` = '7187'
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` = '7186'
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` = '7185'
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` = '7184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7183'
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` = '7182'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7180'
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` = '7179'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '7178'
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` = '7177'
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` = '7176'
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` = '7175'
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` = '7174'
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` = '7173'
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` = '7172'
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` = '7171'
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` = '7170'
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` = '7169'
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` = '7167'
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` = '7168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '168'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2358
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
Ελληνικά
Русский
Olybet Christmas Cracker
2023 OlyBet Christmas Cracker €350 Main Event
Live Reporting - Day 2
Current Level
25 Current Day
2 Blinds
20,000/40,000 Ante
40,000
Entries
119 Remaining
1 Prize Pool (EUR)
€35,986 First Prize (EUR)
€0
1A liidrina lõpetab Tarmo Tammel Posted Friday 29th December, 2023 at 20:33(UTC+2) by maheaaatom
Tarmo Tammelil õnnestus ajada kokku 213 700 punkti, mis teeb temast turniiri suurima stäki. Et Igor Pihelal on vaid 25 200, siis peaks nagu Aasta Mängija tiitel otsustatud olema aga mine tea. Homme on mäng veel ees ning päevast 1A pääses edasi 30 mängijat.
Kohe siirdume päeva 1B juurde.
Player
Chips
Progress
Tarmo Tammel
213,700
113,700
Rasmus Lundström
175,000
145,000
Glen Kolmer
134,000
104,000
Andrey Koks
122,400
12,600
Ranno Sootla
111,500
81,500
Igor Pihela vanem
100,500
24,500
Vladislav Topilskiy
99,800
69,800
Henrik Pellinen
92,300
62,300
Aleksandr Kizel
88,900
58,900
Martin Peek
86,300
56,300
Hendrik Uibo
76,400
46,400
Urmo Velvelt
68,000
38,000
Kaius Kiidli
62,600
32,600
Talis Tooming
62,200
32,200
Kaur Ajamaa
61,400
31,400
Ville-Matti Keränen
59,700
29,700
Vadim Guk
50,100
20,100
Mauri Dorbek
38,800
111,200
Rain Kandla
37,100
7,100
Sergei Aleksejev
37,000
7,000
Raido Tsmir
37,000
7,000
Anne Bedzek
31,000
1,000
Igor Pihela noorem
25,200
4,800
Yevhen Roshchebak
24,100
5,900
Mark Metsla
21,800
8,200
Nico Segersven
19,100
10,900
Richard Koppel
17,900
12,100
Martin Piik
17,500
12,500
Ralf Mikk
16,800
13,200
Kaspar Laursoo
11,500
18,500
1A on lõppenud Posted Friday 29th December, 2023 at 20:11(UTC+2) by maheaaatom
Päev 1A on lõppenud ning mängijad pakivad nuppe kottidesse. Hetkeseisuga peaks jätkama 30 parimat, kelle stäkid avaldame kohe kui info nende kohta on lõplik. Ja siis suundume juba vaatama seda, mis toimub päeva 1B.
Mölamaffia tegutseb Posted Friday 29th December, 2023 at 20:05(UTC+2) by maheaaatom
Jutupaunikud Tapio Aaltonen ning Ranno Sootla peavad maha korraliku "mölalahingu", enne kui mõlemad lõpuks 3,5K-ga floppi vaatavad.
Tapio lennutab keskele 3K ning Ranno tõstab 6,5K, vihjates, et tal on ikka päris hea käsi. Tapio vastab 16,5K all-in'iga ning Ranno ei jäta seda callimata.
Mõlemad avavad ülepaari, Tapiol on ja Rannol . Ässad peavad lõpuni.
Päev 1A on kohe läbi, mängitakse kolme viimast jaotust.
Mauri kaotab hiigelpanga Posted Friday 29th December, 2023 at 19:57(UTC+2) by maheaaatom
Actioniks läheb pärast flopi ja turni . Pangas on umbes 12K ning Rasmus Lundströmi pisut enam kui pangasuurusele panusele vastab Mauri all-in'iga. Rasmuselt call.
Mauri avab ilma mastitõmbeta , Rasmusel on . River on ebaoluline .
"Lauas oli liiga palju tõmbeid, ma pidin midagi tegema," põhjendab Rasmus on suurt avapanust. Mauril tuleb maksta välja koguni 68 200 punkti, mis on suur löök ka tema stäki suurust arvestades.
Urmo näitab taset Posted Friday 29th December, 2023 at 19:48(UTC+2) by maheaaatom
Urmo ja Oleg mängivad omavahel suure panga, pärast floppi ja turni panustab Urmo 5500 ja saab Olegilt calli.
River on , Urmo (järgi umbes 11K) checkib ette ja Oleg lükkab oma 21K stäki kiirelt keskele. Urmo callib.
Oleg:
Urmo:
Kicker mängib, pank Urmole. "See oli obv call, mul oli juba nii palju sees ja nii vähe järgi," põhjendab nimekas highroller, kelle rohkete saavutuste hulka kuulub ka näiteks 2019. aasta WCOOP põhiturniiri neljas koht, mis tõi talle sisse üle poole miljoni euro.
Õnnestunud flip suurendab Kauri stäkki Posted Friday 29th December, 2023 at 19:39(UTC+2) by maheaaatom
Kaur Ajamaa flippab õnnestunult Türgi alama Murat Yilmazi vastu ning saab viimase umbes 25K stäki enda omandusse.
Muratil , Kauril ning laud esimesele abi ei too.
19:33 (UTC+2)
Start of Level 9 Blinds: 500/1,000 Ante: 1,000
Kangete meeste konkurents Posted Friday 29th December, 2023 at 19:33(UTC+2) by maheaaatom
Duellis Tarmo Tammel vs. Igor Pihela noorem on kindlalt peal esimene, kel umbes 100K stäkk. Igoril on alla algstäki ning võimalusi selle suurendamiseks veel umbes pool tundi.
Tarmo õnnestus just kätte saada ka Georgi järjekordne skalp. "Nüüd vist aitab küll," kommenteerib Georgi ja Tarmo lisab omalt poolt, et ta vähemalt andis Georgile märku, et viimane võiks loobuda.
Player
Chips
Progress
Tarmo Tammel
100,000
70,000
Kolm suurimat stäkki Posted Friday 29th December, 2023 at 19:24(UTC+2) by maheaaatom
Suurim punktisumma paistab olevat Mauri Dorbekul. "Kas see on nüüd üllatus, et mul nii palju on," tögab Mauri ise.
Väga korralikus seisus on ka turniiril esimese re-entry teinud Andrey Koks ning tavapäraselt lahtise mänguga alustanud Igor Pihela vanem.
Player
Chips
Progress
Mauri Dorbek
150,000
120,000
Andrey Koks
135,000
105,000
Igor Pihela vanem
125,000
95,000
Tanel Evert kaotab ausalt Posted Friday 29th December, 2023 at 19:16(UTC+2) by maheaaatom
Eelmise jaotusega samaaegselt jääb Haapsalu pokkerituus Tanel Evert ilma oma stäkist, kaotades selle Ville-Matti Keränenile.
Kõik aus, Tanelil , vastas aga pocket kuningad. Ning see viimane pakis olev kuningas veel lauda ka.
Rain võidab 3-way panga Posted Friday 29th December, 2023 at 19:13(UTC+2) by maheaaatom
"Pihelate-lauas" on preflopist sees kolm meest, kellest Georgil on kõigest 8K stäkk, Rainil üle 20K ning Oleg Tuomanenil mitu rohkem kui kahel eelmisel kokku.
Rain Kandla:
Goergi Abuladze:
Oleg:
Lauda kuus ning Rainile kena stäkilisa. Georgi marsib aga otseteed re-entry laua juurde. "No ma võtaks veel ühe. Või on teil siin mingid piirangud?" naljatleb mees. 1B-le ta ei lähe, ikka 1A-le tagasi!
19:05 (UTC+2)
Start of Level 8 Blinds: 400/800 Ante: 800
Mäng jätkub, algas ka 1B Posted Friday 29th December, 2023 at 19:05(UTC+2) by maheaaatom
43 mängijat päeval 1A on laudades tagasi ning me jätkame eeskätt nende tegemiste jälgimist.
Päeva 1B alustas 16 mängijat, kes on hetkel kolmes lauas.
Teine paus Posted Friday 29th December, 2023 at 18:51(UTC+2) by maheaaatom
43 allesjäänut mängijat lubati jalgu sirutama ning action jätkub umbes kell 19:00. Siis peaks algama ka päev 1B.
Viimases pausieelses käes andis natuke nööpe ära Anne Bezdek, kes duubeldas üles ühe kaasmaalase. Aus flip vs. , riveriga äss-kunni mehele rida.
Urmol teine bullet ning samad sõbrad Posted Friday 29th December, 2023 at 18:42(UTC+2) by maheaaatom
Highroller Urmo Velvelt kaotas äsja oma esimese bulleti. Nupud läksid Maurile, oli cooler olnud. "Suht aus kaotus," märkis ka Urmo ise. Mis siis muud kui re-entry järele minna.
"Nii, meil on kaks võimalust, kas kuuendasse või üheksandasse lauda," vaatas vägesid juhtiv Viivian oma arvutisse ning Urmo märkis kiirelt, et ta tahaks väga minna just üheksandasse lauda, kus tal juba sõbrad ees.
Nii juhtuski ning kättemaksu ihkav Urmo saadetigi samassse seltskonda tagasi.
Hetkel männgus 43 parimat, re-entrysid on kogunenud 20.
"Ega tal ei meeldinudki siin" Posted Friday 29th December, 2023 at 18:30(UTC+2) by maheaaatom
Nii viskab nalja Ranno Sootla pärast seda, kui tema lauast langes äsja välja Hanna Heinlo, kes oma viimased nupud Mark Metslale loovutas. "Noh, põhitöö tegi ära muidugi Tapio," veeretavad mehed "süü" soomlase kaela.
44 mängijat on veel alles, neist ainsa naisena Anne Bezdek. Loodame mõningaid neist siiski näha veel päeval 1B, mis on algamas juba poole tunni pärast.
18:24 (UTC+2)
Start of Level 7 Blinds: 300/600 Ante: 600
Tarmo püsib elus Posted Friday 29th December, 2023 at 18:23(UTC+2) by maheaaatom
Flopi järel on Tarmo Tammel oma viimase 12K-ga all-in ning saab ka ühe calli.
Tarmo avab , mis paistab vastase vastu ka kenas seisus olevat. Turn ja river ei muuda midagi, kuigi keegi mängija viskab lauas nalja, et see on ju rida.
Diiler hämmeldub ning lauas on lühike vaikus. "Jack-ten võtab," täpsustab Tarmo ning nupud lükataksegi peagi tema ette.
Glen tabab nelikut Posted Friday 29th December, 2023 at 18:14(UTC+2) by maheaaatom
Rasmus Lundström läheb oma kribalatega all-in ning saab kolm calli.
Flopi järel panustab Igor Pihela vanem 3000 ning saab calli tema järelt istuvalt Glen Kolmerilt.
Turn on ning Igor lisab oma eelmisele panusele veel ühe täistuhande. Glenilt taas kiire call.
Riveri järel paneb Igor järjekindlalt veel ühe täistuhande juurde (panus 5000), kuid Glen vastab 15000-ga. Igorilt call.
Glen avab ideaalselt tabatud flopi , mis turni järel nelikuks täieneks. Igori jääb üle oma foldida ning Rasmus peab üldse re-entry järele minema.
"Mõnikord võidavad ka banaanid!" Posted Friday 29th December, 2023 at 18:04(UTC+2) by maheaaatom
Nii kilkab Tapio Aaltonen, kes just Hannale "koti pähe tõmbas".
Nupud olla sisse läinud pärast floppi X, kus Hanna () selgelt juhtis.
Tapiol olid emandad ning 2-outer riverisse ka tuli. Hanna küll sõitleb Tapiot, kuid endal tal silmad naeravad. Oligi lihtsalt nii tobe jaotus.
Oleg ampsab suure osa Kauri stäkist Posted Friday 29th December, 2023 at 17:58(UTC+2) by maheaaatom
Oleg Tuomanen ja Kaur Ajamaa vaatavad floppi . Kaur betib 1800, Oleg tõstab kiirelt 5000-le ja saab calli.
Turn on , Kauril check, vastaselt 10K ja Kauril call.
River on ning kordub täpselt sama, mis pärast turni.
Oleg avab - maja - ja korjab panga ära. Kaur vangutab pahaselt pead, see oli tema stäkile ikka korralik laks...
17:50 (UTC+2)
Start of Level 6 Blinds: 200/500 Ante: 500
Enam juurde ei tule? Posted Friday 29th December, 2023 at 17:50(UTC+2) by maheaaatom
Hetkel on laudades 45 mängijat ning sisseoste on kogunenud 60. Paistab, et uusi liitujaid enam ei tule, pigem võib neid näha juba päeval 1B, mis algab täpselt kell 19:00.
1A peaks lõppema umbes kell kaheksa õhtul, 1B umbes kell keskööl.
Igor kukutab Tre Kronori Posted Friday 29th December, 2023 at 17:47(UTC+2) by maheaaatom
"Isa ja poja lauas" avab Oleg Tuomanen 1200-ga, mida callib Igor Pihela vanem. Rootslane Mikael Grönvik leiab, et seda on vähe ning kolmpanustab 3500-le, saades Olegilt calli.
Igor vastab aga nüüd omakorda 4-panusega 12700. Rootslane tuleb kaasa, Oleg aga mitte.
Flopis avatakse ning Grönvik on hoobilt all-in. Ka Igor tuleb rõõmuga kaasa.
Grönvik:
Igor:
Kõrgem paar peab lõpuni vastu, meie mehel on nööpe rohkem.
Naised omavahel Posted Friday 29th December, 2023 at 17:33(UTC+2) by maheaaatom
Marianna Bastamow-Sinkko lükkab oma viimased 7500 keskele ning saab calli Hanna Heinlolt. Nemad kaks on muide siiani ainsad turniiril osalevad naised.
Marianna:
Hanna:
Laud jookseb tühja ning Marianna on mängust väljas.
Ma ei oskagi nõrkade vastastega mängida! Posted Friday 29th December, 2023 at 17:24(UTC+2) by maheaaatom
Nii räägib tänavuse WSOP Circuit Tallinn põhiturniiri komeet, noor mängumees Hendrik Uibo, kes istub samas lauas Urmo, Mauri, Martini ning pausi järel selle kambaga liitunud Georgi Abuladzega.
Hendrik lisab, et laud on karm, kuid talle see sobib. Tegemist siis mehega, kes mõnda aega koguni juhtis Eesti selle aasta suurimat pokkeriturniiri, lõpus pidi aga leppima (sugugi mitte halva) 14. kohaga. juhtis mõnda aega WSOP Circuit'it.
17:20 (UTC+2)
Start of Level 5 Blinds: 200/400 Ante: 400
Mäng on suhteliselt aktiivne Posted Friday 29th December, 2023 at 17:04(UTC+2) by maheaaatom
Esimesed neli mängutaset tõid meile 9 re-entryt, paistab et see 350 eurot on paljudele mängijatele ikka päris kommiraha...
Edasist mängu käiku toimunud küll kuigivõrd ei mõjuta, sest massiivseks chipliidriks pole tõusnud veel keegi. Sellest hoolimata näitavad esimesed tasemed, et turniiri tase saab olema tugev ning mängijatel on pärast jõulupühi lusti laialt.
Naaseme 15 minutise pausi järel.
Igoril on kõik välja arvestatud Posted Friday 29th December, 2023 at 16:58(UTC+2) by maheaaatom
Igor Pihela noorema sõnul on tema ja Tarmo Tammeli vahe GPI edetabelis niivõrd väike, et Aasta Mängija tiitel võib vabalt selguda veel selle festivali jooksul.
"Tammel võib teiseks ka tulla, kuid kui mina selle turniiri võidan, siis olen just mina Aasta Mängija," märgib Igor ise. Võiduni on mõlemal muidugi veel pikk tee, selleks tuleb pidada vastu pühapäeva varaste hommikutundideni.
Mänguga liitus ka Urmo Velvelt Posted Friday 29th December, 2023 at 16:49(UTC+2) by maheaaatom
Urmo Velvelt on üks Eesti nimekamaid online-mängijaid, tõeline highroller, kes hoiab küll suhteliselt madalat profiili. Tema suurim tänane kordaminek on Summer Showdown põhiturniiri kolmas koht, mis tõi sisse ligikaudu 50 tuhat euro. Üks viiekohaline cash tuli ka alles detsembris Bahamal toimunud WSOP Paradise Islandilt.
"Megakirves koht oli," hindab unistuste mängukohta Urmo ise. Lisaks temale on mänguga liitunud ka Urmo hea sõber Martin Piik.
16:32 (UTC+2)
Start of Level 4 Blinds: 100/300 Ante: 300
Jõulud on andmise aeg! Posted Friday 29th December, 2023 at 16:32(UTC+2) by maheaaatom
Nii palub öelda Ranno Sootla, kes on enda sõnul poole oma stäkist lahkelt konkurentidele "ära andnud".
"Esimene bullet ongi andmiseks," lisab Ranno, kuid lubab teisega juba tõsiselt mängima hakata. Aga hetkel pole ta veel pidanud selle järele haarama.
Kaur avaldab survet Posted Friday 29th December, 2023 at 16:30(UTC+2) by maheaaatom
WSOP Circuit meistrisõrmuse omanik Kaur Ajamaa läheb keskpositsioonilt "röövima" ning saab kaasa mõlemad blindid - Igor Pihela vanema ja Rain Kandla.
Flopi järel panustab Rain ette 1200, Igor foldib ning Kaur callib.
Turni järel lükkab Rain 1600, kuid Kaur ei kao kuskile.
River toob lauda mastivõimaluse, kuid Rain jätkab panustamist, seekord 2200-ga. Kaurilt kiire call.
Rain:
Kaur:
Tähelepanuks Omaha-sõpradele! Posted Friday 29th December, 2023 at 16:20(UTC+2) by maheaaatom
Kell 22:00 algab Olympic Park Casinos tänane kõrvalturniir, 100-eurose sisseostuga PLO 4/5. Turniir mängitakse 8-handed laudades, võimalus on piiramatuks re-entryks, late reg. kestab 8x15 minutit ning mäng on võrdlemisi kiire tempoga. Võitjale lisaks ka kena karikas!
Eilsed tulemused Posted Friday 29th December, 2023 at 16:17(UTC+2) by maheaaatom
Neljapäeva õhtul toimus Christmas Crackeril 150 € osalustasuga Progressive Bounty, millest võttis osa 81 unikaalset mängijat (lisaks tehti ka 41 re-entryt).
Poodiumi hõivasid soomlane Robert H. C. Montell, ukrainlane Yevhen Roshchebak ning Soome naismängija Anne Bezdek. Parima eestlasena oli Allan Lahi viies. Kõikide osalejate vahel loositi välja ka kaks 150 € Kings of Tallinn 2024 iseseisuvuspäevaturniiri piletit.
Hilisõhtusel satelliidil oli mängijaid 33, kellest viis parimat pääsesid tänasele 350 € põhiturniirile.
16:10 (UTC+2)
Start of Level 3 Blinds: 100/200 Ante: 200
"Ristikesi" aina koguneb Posted Friday 29th December, 2023 at 16:10(UTC+2) by maheaaatom
Kuigi mängitud on alles üks tund ja kaks esimest levelit imepisikeste blindidega, siis on juba kuus mängijat pidanud re-entry õlekõrrest haarama.
Hetkel 42 mängijat, 48 sisseostu. Turniir on veel noor ning kindlasti pole me enamust tänaseid osalejaid veel näinudki.
Mida suudab Ranno Sootla? Posted Friday 29th December, 2023 at 16:08(UTC+2) by maheaaatom
Kui Ranno Sootla on lauas, siis vaevalt leidub konkurente, kes talle ning tema käikudele tähelepanu ei pööra. suudab ükski konkurent
Tänavune aasta on toonud Rannole (vaid!) kaks viiekohalist cashi. Ühega neist kaasnes WSOP Circuit meistrisõrmus, teine - 21050 € cash - tuli aga Summer Showdown High-Rollerilt.
Eesti rahalistis on Ranno viies, järgmise kohani (Ottomar Ladva) aga minna veel päris pikk tee. Aga miljonäride klubi pole tegelikult kummalgi kaugel ;)
Hetkel kaks naist Posted Friday 29th December, 2023 at 15:55(UTC+2) by maheaaatom
Nüüdseks juba 41 mängija seas on kaks naist, kellest üks mõistagi suurturniiride regular, äsjase Queens of Tallinn põhiturniiri neljas Hanna Heinlo.
Aga oma oskusi on näitamas ka tõeline pokkeriveteran, Tallinnas elav soomlanna Marianna Bastamow-Sinkko.
Superässad laudades Posted Friday 29th December, 2023 at 15:40(UTC+2) by maheaaatom
Olympic Casino aastalõpu-minifestival on toonud laudadesse rea väga kõrge kaliibriga pokkeristaare.
Lisaks eelpool mainitud Igorile ja Tarmole on kohal ka sügisesel WSOP Circutil meistrisõrmuse võitnud Kaur Ajamaa ja Ranno Sootla. Eriti tasuks silma peal hoida ka vanemal Igor Pihelal, Mauri Dorbekul, Mark Metslal ja teistel.
15:36 (UTC+2)
Start of Level 2 Blinds: 100/100 Ante: 100
Esimene langeja Posted Friday 29th December, 2023 at 15:36(UTC+2) by maheaaatom
Tänavuse EMV põhiturniiri neljas mees Andrey Koks on esimene mees, kes esimese leveli lõpus "ristikese" kätte sai. Mis muud, kui kassasse re-entry järele, sest ega Andrey pole ju mingi allaandja.
Re-entry on avatud kuni teise päeva esimese mängutaseme lõpuni, seega on veel küll ja küll aega uuesti mänguga liituda.
Hetkel 38 mängijat laudades.
Kas GPI edetabel (2023) on lõplik? Posted Friday 29th December, 2023 at 15:32(UTC+2) by maheaaatom
GPI 2023. aasta edetabeli põhjal on hetkel aasta edukaim Eesti pokkerimängija Tarmo Tammel, kes paikneb maailma edetabelis 631. kohal. Aga lähimad jälitajad pole üldse kaugel - Igor Pihela nooremale kuulub 643. ja Henri Käsperile saatanlik 666. koht. On võimalik, et Christmas Crackeri tulemused võivad seda tabelit veel muuta.
Tarmo ja Igor on muide juba laudades ka...
"Me oleme Igoriga seda tabelit aasta läbi nillinud ning rebinud seal," naeris Tarmo ise ning lubas festivalil endast parima anda.
15:23 (UTC+2)
Start of Level 1 Blinds: 100/100 Ante: 0
Christmas Cracker põhiturniir on alanud! Posted Friday 29th December, 2023 at 15:20(UTC+2) by maheaaatom
Esimesed neli lauatäit mängijaid on Christmas Crackeril laudades istet võtnud ning kaardid on õhus.
Täna mängitakse päevad 1A ja 1B, mõlemad 9x30 minutit. 1B algab kell 19:00. Head kaasaelamist!
Festivali avaturniirist võttis osa 97 unikaalset mängijat Posted Thursday 28th December, 2023 at 11:42(UTC+2) by maheaaatom
Christmas Cracker avaturniir, 80 € NLH Warm-Up meelitas Olympic Casinosse 97 unikaalset mängijat, kes tegid ühtekokku 143 sisseostu. Kaksikvõit läks Soome, auhinnarahast sai osa 17 parimat.
27. detsembri hilisõhtul toimunud põhiturniiri 40 € satelliidil osales 28 huvilist ning nagu lubatud, jagati nende vahel ära 5 x 350 € piletit. Sama on kavas ka 28. detsembril kell 22:00.
Neljapäev õhtul kell 19:00 algab 150 € NLH Progressive Bounty, põhiturniir aga reedel kell 15:00. Viimasest viime läbi ka live-ülekande!
Olympic Casino aastalõpuüritus algab 27. detsembril Posted Friday 22nd December, 2023 at 14:35(UTC+2) by maheaaatom
27.-30. detsembril toimub Olympic Park Casinos neljapäevane aastalõpufestival Christmas Cracker. Reedel, 29. detsembril kell 15:00 algavast põhiturniirist valmib ka live-ülekanne, mida saab jälgida siinsamas lehel.
14:30 (UTC+2)
Day 1A of Olybet Christmas Cracker Started Level:Blinds: 0/0 Ante: 0
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.
vaatavad. 
ja turni 
. Pangas on umbes 12K ning Rasmus Lundströmi pisut enam kui pangasuurusele panusele vastab Mauri all-in'iga. Rasmuselt call.
. 
ja turni 
panustab Urmo 5500 ja saab Olegilt calli.
, mis paistab vastase 
vastu ka kenas seisus olevat. Turn 
ja river 
, Kauril check, vastaselt 10K ja Kauril call.
ning Grönvik on hoobilt all-in. Ka Igor tuleb rõõmuga kaasa.
järel panustab Rain ette 1200, Igor foldib ning Kaur callib.
järel lükkab Rain 1600, kuid Kaur ei kao kuskile.
toob lauda mastivõimaluse, kuid Rain jätkab panustamist, seekord 2200-ga. Kaurilt kiire call.
