0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0067 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/21/82/updates'
ORDER BY `views` DESC
0.0099 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/tour_stop_blogs/view_blog_iframe/21/82/updates'
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` = '21'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '21'
0.0280 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0058 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '82'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '84'
AND `published` = 1
0.0278 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '87'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '91'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '93'
AND `published` = 1
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '82'
ORDER BY `busted` ASC, `current_chips` DESC
0.0069 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` = '82'
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` = '3785'
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` = '3784'
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` = '3783'
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` = '3782'
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` = '3781'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3780'
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` = '3779'
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` = '3778'
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` = '3777'
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` = '3774'
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` = '3773'
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` = '3772'
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` = '3770'
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` = '3768'
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` = '3767'
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` = '3765'
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` = '3764'
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` = '3762'
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` = '3759'
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` = '3757'
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` = '3755'
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` = '3754'
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` = '3753'
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` = '3752'
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` = '3748'
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` = '3746'
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` = '3744'
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` = '3743'
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` = '3742'
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` = '3740'
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` = '3738'
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` = '3737'
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` = '3735'
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` = '3733'
ORDER BY `chip_change` DESC, `busted` ASC
0.0113 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3732'
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` = '3730'
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` = '3726'
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` = '3722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3719'
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` = '3718'
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` = '3715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3714'
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` = '3713'
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` = '3712'
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` = '3709'
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` = '3708'
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` = '3706'
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` = '3704'
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` = '3703'
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` = '3701'
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` = '3699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3698'
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` = '3696'
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` = '3695'
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` = '3693'
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` = '3687'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3684'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3683'
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` = '82'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 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` = '82'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '3785'
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` = '3784'
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` = '3783'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3782'
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` = '3781'
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` = '3780'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3779'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3778'
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` = '3777'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3774'
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` = '3773'
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` = '3772'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3768'
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` = '3767'
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` = '3765'
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` = '3764'
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` = '3762'
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` = '3759'
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` = '3757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3754'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3753'
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` = '3752'
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` = '3748'
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` = '3746'
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` = '3744'
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` = '3743'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3742'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3740'
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` = '3738'
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` = '3737'
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` = '3735'
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` = '3733'
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` = '3732'
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` = '3730'
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` = '3726'
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` = '3722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3719'
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` = '3718'
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` = '3715'
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` = '3714'
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` = '3713'
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` = '3712'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3709'
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` = '3708'
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` = '3706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3704'
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` = '3703'
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` = '3701'
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` = '3699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3698'
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` = '3696'
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` = '3695'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3693'
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` = '3687'
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` = '3684'
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` = '3683'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '93'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
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
Ελληνικά
Русский
Kings of Tallinn Summer Showdown 2023
2023 Tallinn Summer Showdown €1,100 Main Event (Estonian)
Live Reporting - Day 4
Kings of Tallinn Summer Showdown 2023 - Live Reporting
Chipid kottidesse! Posted Wednesday 26th July, 2023 at 18:45(UTC+0) by maheaaatom
Põhiturniiri päev 1A on lõppenud ning mängijad ajavad chippe kottidesse. Alles on 76 mängijat, nende seas ka 18 eestlast. Meie mängijate täpsed punktiseisud on järgmised:
Jargo Alaväli, 213 000 Magnus Pukk, 171 400 Mark Metsla, 105 500 Ermo Kosk, 105 200 Ivar Rühka, 94 800 Georgi Abuladze, 92 700 Igor Pihela, 79 200 Urmo Velvelt, 75 300 Siim Suviste, 74 000 Martin Piik, 65 300 Ivar Vendelin, 58 100 Karlo Kivi, 56 800 Andres Aro, 43 500 Kaido Mikk, 36 800 Tõnis Viik, 34 600 Oskar Ojaveer, 29 300 Stanislav Smeljov, 28 900 Silver Simulask, 25 200 Andrey Koks, 21 200
Homme keskpäeval jätkame aga juba päevaga 1B!
Veel suuri stäkke Posted Wednesday 26th July, 2023 at 18:42(UTC+0) by maheaaatom
Ivar Rühkal ja Magnus Pukil on umbes 150K, pea 100K stäkiga on endiselt ka Mark Metsla, Georgi Abuladze ja Siim Suviste, päris kenasti on oma punktisummast kasvatanud Ermo Kosk. Ülejäänute stäkid jäävad alla keskmise, kokku peaks olema mängust 15-20 meie mängijat.
Mängualal on suhteliselt vaikne, küll üritavad väiksed stäkid duubleid saada. Äsja õnnestus see näiteks Tõnis Viigil, kuid kahjuks pole Tõnise stäkk kuigi suur ka pärast duublit.
Diileris asusid jagama kolme viimast kätt.
Jargol endiselt kõik hästi Posted Wednesday 26th July, 2023 at 18:28(UTC+0) by maheaaatom
Jargo Alavälja stäkk põhiturniiril on umbes 210K, mis peaks olema eestlastest suurim. Tuntud tegijatest paistab üsna hea seis olevat ka Georgi Abuladzel ning Urmo Velveltil, mõlemal pisut üle 100K.
Aga viimane tase on nõudnud ka ohvreid. Näiteks Aleksandr Kuperman flippas oma -ga vastu ning juhtis kenasti kuni riverini, mis oli mõistagi äss. Egas midagi, re-entry laud ootab.
Kuigi Ermo lubas esialgu täna enam mitte mängida, võttis ta siiski uue katse ette ning istub hetkel lauas täpselt Jargo Alavälja kõrval. Päeva lõpuni jääb veel umbes 20 minutit.
Mauri kaks bulletit lendasid tuulde Posted Wednesday 26th July, 2023 at 18:13(UTC+0) by maheaaatom
Eesti parimate live-mängijate sekka kuuluv Mauri Dorbek kulutas täna kaks bulletit.
"Esimesel korral langesin kümnetega kolmede vastu, nüüd oli blindide lahing. Tal kunn-üheksa, mull äss-kaheksa. Ja sain muidugi kuninga," räägib Mauri.
Eeldatavalt proovib ta homme uuesti. Auhinnafond on liiga suur, et mitte üritada sellest osa saada.
Algas põhiturniiri päeva 1A viimane tase Posted Wednesday 26th July, 2023 at 18:02(UTC+0) by maheaaatom
Põhiturniir on jõudnud avapäeva viimase mängutasemeni ning hetkel on laudades 87 mängijat. Sisseoste on tehtud 187 ning suure tõenäosusega neid täna enam kuigivõrd ei lisandu. Võidufondis 177 600 eurot.
Üsna populaarseks on osutunud ka 8-Game seni tehtud 67 sisseostuga. 250 € NLH/PLO/PLO5 turniiril on sisseoste 111, samuti käivad siiani kaks satelliiti.
Hilistel ärkajatel tasub pidada meeles ka seda, et kell 21:30 antakse stardipauk 555 € 6-Max Holdemile.
17:53 (UTC+0)
Start of Level 8 Blinds: 500/1,000 Ante: 1,000
Ermo naerab oma väljalangemise üle Posted Wednesday 26th July, 2023 at 17:45(UTC+0) by maheaaatom
Pisut pärast Maikeli võitu langes põhiturniirilt välja Ermo Kosk, kes isegi veel viimase käe üle naeris. "Mul oli ässad ja lendasin viie-seitsme vastu", räägib Ermo mõnuga.
Täna ta rohkem mängida ei plaani, kuid homme on mehel kindel kavatsus lauda naasta. Ja katsuda ikka võiduka lõpuni mängida.
Pisut aasivad Ermot küll tema sõbrad, kes soovitavad kuuekordsel Eesti meistril oma pere-eelarvega edaspidi pisut hoolikamalt ümber käia...
Kes on Maikel Homin? Posted Wednesday 26th July, 2023 at 17:40(UTC+0) by maheaaatom
Championship'ile oli palju kaasaelajaid ning Maikeli võit vallandas korraliku aplausi.
"Loomulikult tunnen ma end suurepäraselt," rõõmustas päevakangelane pärast elu suurimat turniirivõitu. "Need oli rasked kolm päeva. Finaali alustasid chiplooserite seas ning võtsin seetõttu ühe käigu korraga. Esmalt oli eesmärgiks lihtsalt duubeldada ning siis oma stäkki edasi kasvatada." Mõnevõrra küsitavaks peab ta soomlase light-calli, mille järel viimase mängustiil Maikeli sõnum pisut muutus.
Maikel Homin peab end hobimängijaks, kes mängib pokkerit peamiselt internetis. "Keskmiselt korda nädalas, enamasti pühapäeviti. Ühtegi nii suurt hitti ma kunagi varem saanud ei ole, kuid viiekohalisi võite mul siiski," kommenteeris Maikel.
Live'is mängib ta pisut vähem, kuid suurematel kohalikel üritustel katsub ikka kohal olla. Kindlasti võtab ta käimasoleval Summer Showdownil osa ka põhiturniirist ja võib-olla ka high-rollerist.
Aga mis auhinarahaga teed? "Noh, mul on natuke juba kogutud ka, vast õnnestub koguni maja osta," muheleb Maikel.
Veelkord palju õnne ning nüüd põhiturniiri juurde!
Maikel Homin võitis Championship turniiri ning teenis 56 900 eurot! Posted Wednesday 26th July, 2023 at 17:28(UTC+0) by maheaaatom
Palju õnne Eestile ja Maikelile, me saime äsja tõeliselt võimsa turniirivõidu!
573 sisseostuga 555 € Championship turniiri tšempion on Maikel Homin! Viimane jaotus oli klassikaline all-in, Maikelil ja Henri Antikainenil . Kui kõikides eelnevates sarnastes jaotustes oli õnn soosinud soomlast, siis sel korral oli õnneks fortuuna meie poolt.
Lauas avati ning Maikel võitis kuningate paariga!
Soomlane taas mängus tagasi Posted Wednesday 26th July, 2023 at 17:07(UTC+0) by maheaaatom
Soomlane suudab oma shortstäki kaks korda järjest kehvemate kaartidega duubeldada (esimene näiteks vs. ) ning on taas mängus tagasi. Maikel küll veel juhib, kuid vaid umbes 3:2.
Henri crippled, Maikel turniirivõidule väga lähedal! Posted Wednesday 26th July, 2023 at 17:03(UTC+0) by maheaaatom
Pärast floppi checkib soomlane ette, Maikel paneb 600K ning põhjanaaber vastab all-in'iga. Maikelilt call!
Maikel:
Henri:
Turnis avatakse veel üks kuningas ning Henri Antikainen on drawing dead. Nupud loetakse üle, soomlasel jääb umbes 3XBB alles.
Henri Antikainen duubeldab Posted Wednesday 26th July, 2023 at 16:55(UTC+0) by maheaaatom
Lõpp veel ei saabu, hoopis soomlane tuleb mängu tagasi. Aga võimalus Championshipi lõppemiseks muidugi oli.
PFAI: Henril , Maikelil . Laud on tühi. Stakid enam-vähem võrdsed.
Mäng jätkub mõlemal võtmeturniiril Posted Wednesday 26th July, 2023 at 16:53(UTC+0) by maheaaatom
Põhiturniiril algas seitsmes tase (siiani 102 mängijat, 178 sisseostu), samuti taaskäivitus Championshipi heads-up lahing.
Laudade arv suures saalis hakkab tasapidi taas vähenema, kuna uusi mängijaid lisandub vähem kui põhiturniirilt välja langeb. Ning enamasti ei kipu väljalangejad ka ülearu kergelt re-entryt tegema, lihtsam juba päeva 1B või 1C otsast alustada.
16:49 (UTC+0)
Start of Level 7 Blinds: 400/800 Ante: 800
Heads-up pausile Posted Wednesday 26th July, 2023 at 16:42(UTC+0) by maheaaatom
Lisaks põhiturniirile läks nüüd 15-minutilisele pausile ka Championshipi heads-up.
Maikel Homin on umbes 4:1 ees, soomlase stäkk pole suurem kui 10XBB.
Maikel on saanud 3:1 eduseisu Posted Wednesday 26th July, 2023 at 16:30(UTC+0) by maheaaatom
555 € Championshipi finaalis on Maikel võitnud rida väiksemaid ning kaks keskmise suurega panka (viimases pressis ta soomlase suure tõste peale all-in, millele viimane ei calliga ei vastanud), mis on viinud ta selgelt juhtima.
Tal on ligikaudu 13 miljonit Antikaineni 4,2 miljoni vastu, mis on juba päris võimas avaldus. Heads-up'i jälgib lives ligi paarkümmend inimest ning mäng on väga pinev.
Põhiturniir saadeti pausile ning vaheajal saab mõistagi end "tuulutada" lõbusate flippidega.
Mida Markku teeb? Posted Wednesday 26th July, 2023 at 16:19(UTC+0) by maheaaatom
Eesti läbi aegade edukaim pokkerimängija Markku Koplimaa on tänagi mängusaalis, kuid mitte põhiturniiril.
Nimelt leidsime mehe väikesest saalist, kus ta ametis 8-Game'iga. "See siin on kõige ägedam turniir," kommenteeris Markku, kes kunagi paotas, et üheks tema pokkerialaseks unistuseks on EMV 8-Game'i võitmine. Noh, siis ongi ta kahtlemata õiges kohas.
Põhiturniiril juhib eestlastest Jargo Alaväli Posted Wednesday 26th July, 2023 at 16:08(UTC+0) by maheaaatom
Põhiturniiri liider paistab olevat (Eesti?) hispaanlane Juan Duenos, kellel on julgelt 250K stäkk.
"Puhtaverelistest eestlastest" on edukaim Jargo Alaväli, kes umbes 130K peal. Tunamullusel EMV põhiturniiri tšempionil Magnus Pukil ja live-turniiride ässal Mark Metslal on kummalgi umbes 100K.
Maikel saab raske duubli Posted Wednesday 26th July, 2023 at 15:56(UTC+0) by maheaaatom
Lauas on avatud ning viimasena sõnaõigust omav Maikel pressib oma nupud keskele. Eelnevatel tänavatel "kohusetundlikult" callinud soomlane peab pika-pika mõttepausi, palub Maikelil nupud kokku lugeda ja mõtleb siis veel. Viimaks tuleb call.
Maikel avab üsna vastumeelselt , kuid Henri Antikainenil pole ka sellele midagi vastu panna. Ta avab , küllap läks lihtsalt selget bluffi püüdma.
Mehed on nüüd umbes viigis, soomlasel on nuppe vast õige pisut enam.
"Miks nad diili ei tee?" tunneb korraks reilima tulnud Igor Pihela noorem huvi. "Ta pole nõus, mängus on tiimipunktid," vastab Maikel. Juhul kui Henri Antikaninen diiliga nõustuks, saaks ta teise koha punktid hoolimata sellest, kas võidab turniiri või mitte.
Olgu täpsustatud, et tiimide fondi läheb 2% iga turniiri auhinnarahast ning see jaguneb viie parima võistkonna vahel. Igas tiimis on neli liiget ning paljude mängijate jaoks on edu tiimide võistlusel erakordselt tähtis.
Soomlane hakkab eest ära minema Posted Wednesday 26th July, 2023 at 15:44(UTC+0) by maheaaatom
Hoolimata suurest saalist toimuvast põhiturniirist on kõikide pilgud suunatud pigem sellele ühele lauale, kus toimub 555 € Championshipi heads-up.
Henri Antikainen on oma eduseisu vaikselt suurendanud ning hetkel juhib juba umbes 4:1. Siiski peaks Maikelil olema ca. 20xBB mänguruumi. Mõlemad mehed on väga keskendunud ning jaotused vältavad pikka aega.
Muide, ka Henri Antikainen on tegemas oma elu parimat live-tulemust, seega on igal juhul kaalul väga palju.
Põhiturniiri auhinnafond paisub Posted Wednesday 26th July, 2023 at 15:36(UTC+0) by maheaaatom
Hetkeseisuga on põhiturniiril 108 mängijat ning sisseoste on kogenunud juba 166. See tähendab 156 980 € auhinnafondi, kuid ilmselgelt see vähemalt kahe- või kolmekordistub.
Tuntud tegijatest on lisandunud nii kuuekordne Eesti meister Ermo Kosk kui Eesti üks parimaid netimängijaid ning suure jälgijaskonnaga striimer Jargo Alaväli. Live-turniiride arvestuses asub mees Eesti läbi aegade edetabelis 27. kohal.
15:34 (UTC+0)
Start of Level 6 Blinds: 300/600 Ante: 600
Herli räägib oma turniiridest Posted Wednesday 26th July, 2023 at 15:21(UTC+0) by maheaaatom
Endine OlyBeti pokkerimänedžer, oma tööd suure armastusega teinud ning ka ohtralt erinevaid pälvinud Herli Olop on üle pikkade aastate Summer Showdownil taas mängija rollis.
Ta on mänginud eelnevalt aktiivselt OlyBetis toimunud satelliitidel ning hankinud ka portsu turniiripileteid, kuid siiani mehel hästi läinud ei ole. "Turniirid on kindlasti mängitavad, kuid jooksnud pole need siiani kohe kuidagi. Igast 2- ja 3-outerid," kurdab Herli.
Siiani cashe veel pole, kuid Herlil on veel kasutada põhiturniiri pilet, mis läheb käiku homsel päeval 1B. Täna kavatseb mees mängida hoopis 8-Game'i. Soovime edu!
Maikel Homin Championshipil heads-up'is! Posted Wednesday 26th July, 2023 at 15:14(UTC+0) by maheaaatom
Maikel Hominil õnnestus õnnega pooleks Simon Forendal mängust välja võtta.
Nupud läksid sisse küll tema jaoks ebasoodsas olukorras ( vs. ), kuid nagu sellistel puhkusel ikka, tuleb osata ka õnnele toetuda - flopis nii seitse kui emand.
Seega on Championship'il käimas heads-up ning soomlasel umbes 3:2 eduseis. Võitja saab 56 900, kaotaja aga 38 450 eurot. Esialgu veel (tõsisemalt) diilist räägitud ei ole.
Maikel tõusis Championshipi liidriks! Posted Wednesday 26th July, 2023 at 14:43(UTC+0) by maheaaatom
Nupud läksid sisse pärast floppi . Soomlane näitas , Maikelil olid pocket emandad.
Viimased pidasid ka kenasti vastu ning umbes 8,5M panga võitnud Maikel tõusis ka uueks liidriks.
"Nii, nüüd võtame selle soomlase välja ning teeme omavahel diili," vihjab Maikel kõrval istuvale chiplooserist rootslasele.
Championship turniiri punktiseis Posted Wednesday 26th July, 2023 at 14:36(UTC+0) by maheaaatom
Blindid on 100 000/200 000, seega mänguruumi kõigil nagu on.
14:30 (UTC+0)
Start of Level 5 Blinds: 200/500 Ante: 500
Infoks kõigile, kes armastavad segamänge Posted Wednesday 26th July, 2023 at 14:30(UTC+0) by maheaaatom
Kell 17:00 algab 350-eurose sisseostuga 8-Game, mis mängitakse 30-minutiliste tasemetega.
Ootame osalema ka kõiki häid ning universaalsete mänguoskustega eestlasi!
Põhiturniir pausile Posted Wednesday 26th July, 2023 at 14:20(UTC+0) by maheaaatom
Põhiturniiri 107 mängus olevat pokkerisportlast läksid päeva teisele pausile ning väike breik on ka Championshipi finaalis, kus endiselt kolm parimat sees.
Põhiturniiril õnnestus kinni püüda Mark Metsla, kes on teinud head tööd ning upitanud oma stäki umbes 90K-le. Uutest liitujatest on kahtlemata nimekaim WSOP käevõru omanik ning ülitugev turniirimängija Ranno Sootla.
Noorem Pihela kasutas esimese bulleti Posted Wednesday 26th July, 2023 at 14:01(UTC+0) by maheaaatom
Noorem Pihela kasutas põhiturniiril ära oma esimese bulleti ära ning viimane jaotus pani ta omajagu muigama.
Igor kaitses blindi -ga ning pärast floppi ja turni oli ta üsna all-in'is mitmete erinevate tõmmetega soomlase vastu. River tõigi konkurendile kaks kõrgemat paari - kuningad ja kahed. "Ta ei saanud algusest arugi, et võitis" naeris Igor.
Tõenäoliselt läheb mees peagi uuesti mängija, kuid esialgu suunas ta oma tähelepanu Championship finaalile. "Nii, mis siin siis toimub? Eesti, Eesti," avaldas ta Maikelile oma poolehoidu.
Dmitri Dudakovile 16 620 eurot Posted Wednesday 26th July, 2023 at 13:56(UTC+0) by maheaaatom
Championship'il läksid preflopis vastamisi meie mehed Dmitri Dudakov ja Maikel Homin.
Dmitri avas , seevastu Maikel näitas .
Flopis avati ning Dmitrile paistis juba selge duubel. Turn ebaoluline , kuid river...!
Kolm parimat järgi, Maikel on teeninud juba vähemalt 22 760 eurot.
Dmitri annab valusa duubli Posted Wednesday 26th July, 2023 at 13:50(UTC+0) by maheaaatom
Chiplooserist rootslane lükkab pocket neljadega ning saab calli Dmitri -lt. Puhas flip.
Lauda ..., mis jätsid Dmitrile vaid kaks outi panga poolitamiseks. River ebaoluline .
Endiselt neljakesi Posted Wednesday 26th July, 2023 at 13:38(UTC+0) by maheaaatom
Championshipil on mängus neli parimat ning seis umbes selline - Henri Antikainen on chipliider, kuid Maikel pole kaugel. Ka Dmitril on mänguruumi küllaga. Selge chiplooser on rootslane Simon Forendal, kes juba selgelt push-fold staadiumis.
Põhiturniiril hetkel 132 sisseostu ning auhinnafond jätkab paisumist. Kell 16:00 on algamas järjekordne 20-eurone reigivaba satikas, seekord on auhindadeks vähemalt 3 piletit tänaõhtusele 555 € 6-max turniirile.
13:34 (UTC+0)
Start of Level 4 Blinds: 200/400 Ante: 400
Saal hakkab täis saama Posted Wednesday 26th July, 2023 at 13:27(UTC+0) by maheaaatom
Kuna põhiturniiri sisseostude arv on juba kerkinud 129-le, hakkab Hiltoni konverentsikeskuse suur saal vaikselt täis saama. Vabad on veel vaid mõned lauad.
Kuna mängu on jätkuvalt algfaasis, siis ei hakka silma, et ükski mängija oleks suutnud koguda eriti suure punktisumma. Piget kombatakse oma vastaseid ning otsitakse kohti.
Mixed turniir on samuti alanud ning hetkel laudades umbes 30 mängijat.
Eestlased kukutavad leeduka Posted Wednesday 26th July, 2023 at 13:16(UTC+0) by maheaaatom
Michailas Miserkejevas on sisuliselt sund all-in'is ning saab calli mõlemalt Eesti mängijalt.
Lauda jookseb , mis checkitakse läbi. Dmitri avab , Maikelil on ...kas tõesti triple up? Ei, leedulasel seekord vaid .
Dmitri võtab üliolulise duubli Posted Wednesday 26th July, 2023 at 13:02(UTC+0) by maheaaatom
Championship turniiri viis allesjäänud mängijat läksid WC ja suitsupausile. Aga mitte see pole oluline, vaid asjaolu, et viimases pausieelses käes õnnestus Dmitri Dudakovil saada ülivajalik duubel -ga Michailas Miserkejevase vastu. Lauda nii üheksa kui seitse, kuid meie mehe kõrgem paar võitis.
Nii Dmitri kui tema Michailase stäkid olid enam-vähem võrdsed, leedukal jäid kribalad (umbes 2XBB) järgi. Väga suure tõenäosusega on nelja parima sees kaks Eesti mängijat ning auhinnad järgmised - 56 900, 38 450, 22 760 ja 16 620 eurot. Vinge!
Maikel võidab suure käe! Posted Wednesday 26th July, 2023 at 12:51(UTC+0) by maheaaatom
555 € Championship turniiril läheb hästi Maikel Hominil.
Ta on preflopist all-in kahe soomlase vastu ning selgelt parimas seisus.
Maikel:
Juho Heiska:
Janne Ojala:
Flop on pahaendeline , kuid meie mehe õnneks turn ja river masti ega emandat ei too. Vähemalt 9770 eurot on kotis ning ka stäkk üks suurimaid.
100 mängija tähis täitus kiirelt Posted Wednesday 26th July, 2023 at 12:33(UTC+0) by maheaaatom
Põhiturniiril oleme jõudnud juba 110 sisseostuni ning mängijaid tuleb aina juurde. Äsja on lisandunud näiteks Martin Piik, Georgi Abuladze ja Mark Metsla. Richard Koppel on "suutnud" juba ka ühe re-entry teha.
Maikel ja Dmitri on võitnud juba vähemalt 3950 eurot Posted Wednesday 26th July, 2023 at 12:26(UTC+0) by maheaaatom
Jutt käib siis taas 555 € Championship turniirist. Eesti läbi aegade edetabelis 59. kohal olev Dmitri on suutnud enamat kahel korral: äsja lõppenud WSOP põhiturniiril ning 2019. aasta Kings of Tallinn kuulsuste turniiril (toona Dmitri võitis).
Maikel Homin on endale aga juba praegu kindlustanud karjääri suurima live-cashi.
Järgmine turniir algab kell 15:00 Posted Wednesday 26th July, 2023 at 12:22(UTC+0) by maheaaatom
Täna on kavas kolm ühepäevast turniiri, millest esimene algab juba kell 15:00 ehk vaid 40 minuti pärast.
Kavas opn 250 € sisseostuga NLH/PLO4/PLO5 Mix, kus button vahetub iga ringi järel. Mängitakse 8-handed laudades 20-minutiliste tasemete ning 20 000 punktilise algstäkiga. Tuleb tempokas action!
12:16 (UTC+0)
Start of Level 3 Blinds: 100/300 Ante: 300
Championshipi finaallaua mullimeheks jääb kahjuks Raivo Posted Wednesday 26th July, 2023 at 12:14(UTC+0) by maheaaatom
555 € Championship turniiril on käimas finaallaua pildistamine. Keda üheksa kange seas pole, on Raivo Pinsel. Mees oli sunnitud lükkama -ga, mis juhtis küll enne floppi vastu, kuid paraku suutis vastane (Michailas Miserkevicius) lauast rea saada.
Seega on suures saalis hetkeline vaikus, kuid fuajeest kostab kõva lärmi. Nimelt on läinud käima Flip & Go eelvoorud. Mis muud, kui viska 150 eurot lauale ning kui läheb õnneks, on "Hendoni-cash" kindel. Ja kui ei lähe, siis võib alati asuda uuele katsele.
555 € Championship jätkub, eestlaste stäkid Posted Wednesday 26th July, 2023 at 12:01(UTC+0) by maheaaatom
Championship ligineb finaallauale, konkurentsis on veel 10 parimat. Keskmine stäkk on 1,7M ning eestlaste punktisummad järgmised:
Dmitri Dudakov 2 200 000, Maikel Homik 2 025 000 ja Raivo Pinsel 850 000.
Ühtlasi läks just pausile põhiturniir, hetkel 91 sisseostu.
Jaana mäng saab kiire lõpu Posted Wednesday 26th July, 2023 at 11:57(UTC+0) by maheaaatom
Põhiturniiri teise taseme lõpus langes konkurentsist ainus Eesti naismängija Jaana Kindsigo. Muidugi pole välistatud, et ta kasutab re-entry võimalust ning on peagi lauas tagasi.
Lisaks temale on veel neli langejat. Eestlaste raskekahurvägi on aga kenasti täienenud. Mängimas on näiteks Urmo Velvelt, Igor Pihela vanem, Oskar Ojaveer, Kaido Mikk, Kert Hallik, Mauri Dorbek ja Silver Simulask.
Huuh! Maikel pääseb Raivo käest Posted Wednesday 26th July, 2023 at 11:45(UTC+0) by maheaaatom
Raivo on all-in Maikel vastu ning mõlemad mehed avavad ässa ja emanda. Aga see ei tähenda kaugeltki lihtsat splitti.
Flopis on kaks ristit ja Raivol käes . No vaata sa mul ette, viibutab Raivo sõrmega.
Turn ja river on Maikel õnneks plangud ning meest tabab silmnähtav pingelangus. Koha pärast seda kätt pääsesid 555 € Championshipi mängijad ka väikese puhkusele.
Raivo purjetab vastu- Maikel ja Dmitri aga pärituules Posted Wednesday 26th July, 2023 at 11:38(UTC+0) by maheaaatom
555 € Championship turniiri finaalpäeva kolmanda stäkiga alustanud Raivo Pinsel on tublisti ära andnud ning tal on hetkel juba selgelt alla keskmise stäkk.
Seevastu Maikel Homin ning Dmitri Dudakov purjetavad selgelt pärituules ning mõlema stäkk on üle keskmise. Mehed istuvad muide ka kõrvuti ning mängisid äsja omavahel ühe üsna kopsaka panga, mille sai kätte Maikel.
Tuletame meelde, et Dmitri Dudakov osales sel aastal ka WSOP põhiturniiril ning suutis seal ka cashida. Ka Summer Showdown on talle juba alanud võrdlemisi edukalt.
Teel high-rollerile Posted Wednesday 26th July, 2023 at 11:25(UTC+0) by maheaaatom
Fuajees on läinud käima järjekordne 5000 € High-Roller turniiri reigivaba sub-satikas.
Festivali suurima sisseostuga turniirile võib pääseda seejuures kõige 20 euroga! Subsatika 10 parimat teenivad koha 150 € finaalsatikale, millelt võib juba otse High-Rollerile peale saada.
Subsatikaid ei tasu sugugi alavääristada, on ju neilt alustades lausa WSOP põhiturniir võidetud.
Sihikul on pool miljonit Posted Wednesday 26th July, 2023 at 11:21(UTC+0) by maheaaatom
Kõik märgid viitavad, et põhiturniiri auhinnafond võib tänavu kerkida poole miljoni euroseks või isegi üle selle. Juba praegu on saalis 74 varajast alustajat ning mängitud on alles 100 minutit. Ees on aga veel kuus ja pool tundi puhast mängu + avapäevad 1B ja 1C.
Väärib meenutamist, et viimaste aastate rekord püstitati sel talvel toimunud Kings of Tallinn põhiturniiril, mil auhinnafondi kogunes 673 040 eurot. Ja mis peamine, tollal jäi ka võit Eestisse!
Stevenile 2320 eurot Posted Wednesday 26th July, 2023 at 11:12(UTC+0) by maheaaatom
Steven Seller lõpetab 555 € Championship turniiri 13. kohaga ning teenib 2320 eurot.
Mehe stäkk oli suhteliselt pisike ning viimaseks käeks jäi vs. . Lauda kaks kolme.
Championshipi jätkab tosin parimat, nende seas kolm eestlast, kes kõik istuvad ka ühes lauas.
11:10 (UTC+0)
Start of Level 1 Blinds: 100/100 Ante: 100
Tarmo Tammel varakult kohal Posted Wednesday 26th July, 2023 at 10:54(UTC+0) by maheaaatom
Põhiturniiril on juba lauas 62 pokkerisportlast ning nende seas hakkab silma ka mitmeid eestlasi.
Näiteks on juba kohal Tarmo Tammel, kes ütles, et oli vaja nagunii linna sõita ning mis rohkem ikka oodata. "Stäkid on jah 300XBB, aga swingid sellegipoolest väga suured," kommenteerib Tarmo ise.
Loodame, et sel festivalil õnnestub Tarmo Tammelil võita oma elu suurim cash. Hetkel kehtiva rekordi tegi mees muide veebruaris toimunud Kings of Tallinn Championship turniiril, teenides kolmanda koha eest 22 tuhat eurot.
Maikel duubeldab läbi Dmitri Posted Wednesday 26th July, 2023 at 10:45(UTC+0) by maheaaatom
Üks uuendus ka 555 € Championship turniirilt : Maikel Homin suutis hankida duubli läbi Dmitri Dudakovi.
Nupud läksid sisse enne floppi ning Maikel oli kohe ees (vs. ). Flop andis Maikelile kohe rea ning tema stäkk on nüüd 1,1M. Dmitril jäi 1,3M järgi.
Meelisest õhkub rahulolu Posted Wednesday 26th July, 2023 at 10:39(UTC+0) by maheaaatom
Olympic Park Casinos (alumisel korrusel) õnnestus äsja trehvata ka ettevõtte pokkerimänedžeri Meelis Ahmanit, kes oli küll pisut väsinud ilmega, kuid rahulolev.
"Rekordid aina purunevad, mängijad on väga palju ja kõik üritusega rahul," kiitis Meelis. Ühtlasi tegi mees juttu ka septembris siinsamas toimuvast WSOP Circuit'ist, mis saab olema Eesti viimase 12 aasta suurim pokkerifestival. "Tõenäoliselt saab turniiriala olema senisest veelgi suurem," vihjas Meelis.
Eestlaste stäkid 555 € Championship turniiril Posted Wednesday 26th July, 2023 at 10:19(UTC+0) by maheaaatom
Raivo Pinsel (2 330 000) ja Dmitri Dudakov (1 485 000) on suurepärases vastavalt suuruselt kolmanda ja neljanda stäkiga.
Steven Seller (654 000) ja Maikel Homin (535 000) on seevastu chiplooserid vastavalt 12. ja 14. kohal. Mõlemal on hetkel pisut üle 10xBB.
Tere tulemast Summer Showdown põhiturniirile! Posted Wednesday 26th July, 2023 at 10:05(UTC+0) by maheaaatom
Kauaoodatud Summer Showdown põhiturniir on alanud! Päeval 1A (nagu ka 1B) mängitakse 8x60 min, päeval 1C 8x30 min. Lubatud on re-entry kuni teise päeva teise mängutaseme lõpuni (reedel umbes kell 14:15).
Hetkel on laudades umbes 30 mängijat, kuid ilmselgelt lisandub neid iga hetkega. Kuna põhiturniir on veel väga noor, pöörame peamise tähelepanu 555 € Championship finaalpäevale, kus on võistlustules ka neli eestlast. Järel on 14 parimat, turniiri auhinnafond üle VEERAND MILJONI euro!
10:02 (UTC+0)
Day 1A of Kings of Tallinn Summer Showdown 2023 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.
vastu ning juhtis kenasti kuni riverini, mis oli mõistagi äss. Egas midagi, re-entry laud ootab.
ja Henri Antikainenil 
. Kui kõikides eelnevates sarnastes jaotustes oli õnn soosinud soomlast, siis sel korral oli õnneks fortuuna meie poolt. 
ning Maikel võitis kuningate paariga!
vs. 
checkib soomlane ette, Maikel paneb 600K ning põhjanaaber vastab all-in'iga. Maikelilt call!
. Laud on tühi. Stakid enam-vähem võrdsed.
ning viimasena sõnaõigust omav Maikel pressib oma nupud keskele. Eelnevatel tänavatel "kohusetundlikult" callinud soomlane peab pika-pika mõttepausi, palub Maikelil nupud kokku lugeda ja mõtleb siis veel. Viimaks tuleb call.
, küllap läks lihtsalt selget bluffi püüdma.
-lt. Puhas flip.
, mis checkitakse läbi. Dmitri avab 
.
, kuid meie mehe õnneks turn ja river masti ega emandat ei too. Vähemalt 9770 eurot on kotis ning ka stäkk üks suurimaid.
-ga, mis juhtis küll enne floppi 
vastu, kuid paraku suutis vastane (Michailas Miserkevicius) lauast rea saada.
vs. 
