0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0062 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/1C/updates'
ORDER BY `views` DESC
0.0088 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-07-27'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/1C/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0063 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0006 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'WSOPCTallinn2023-MainEvent-Est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
0.0231 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '122'
AND `published` = 1
0.0226 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0032 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '126'
AND `published` = 1
0.0228 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '128'
AND `published` = 1
0.0228 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0036 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '131'
AND `published` = 1
0.0229 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0037 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '133'
AND `published` = 1
0.0331 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '137'
AND `published` = 1
0.0232 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '140'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
AND `name` = '1C'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '128'
ORDER BY `busted` ASC, `current_chips` DESC
0.0050 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` = '128'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5574'
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` = '5569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0096 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5566'
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` = '5564'
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` = '5563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5556'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5551'
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` = '5548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0221 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5545'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5533'
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` = '5532'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5531'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5519'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5513'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5507'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5505'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5504'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5503'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5497'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5495'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5492'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5491'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '128'
ORDER BY `busted` ASC, `current_chips` DESC
0.0045 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` = '128'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0098 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5590'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5564'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5557'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5556'
ORDER BY `chip_change` DESC, `busted` ASC
0.0163 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5554'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5551'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5548'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5546'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5545'
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` = '5543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5542'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5540'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5537'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5535'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5533'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5532'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5531'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5530'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5521'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5520'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5519'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5514'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5513'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5511'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5508'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5507'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5505'
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` = '5504'
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` = '5503'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5500'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5497'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0257 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5495'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5492'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5491'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '140'
ORDER BY `busted` ASC, `current_chips` DESC
0.0006 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
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.
Päeva 1C lõplik chippide seis Posted Thursday 21st September, 2023 at 20:23(UTC+2) by maheaaatom
Päeval 1C tehti kokkuvõttes 260 sisseostu ning päeva lõppedes pääses edasi 115 mängijat. Kaksikjuhtimine on soomlastel, kuid otse nende järel on meie turniirihai Tarmo Tammel. Meie arvestuse järgi elas päeva 1C üle 15 eestlast.
Nüüd jätkame ülekannet juba viimase stardipäevaga 1D.
Player
Chips
Progress
Joel Holmberg
318,000
268,000
Jonatan Fors
297,000
247,000
Tarmo Tammel
290,000
240,000
Mantas Bagocius
284,000
234,000
Oskar Ojaveer
227,500
177,500
Hannes Praks
199,500
149,500
Mark Metsla
181,500
21,500
Mauro-Mark Musting
175,000
125,000
Dmitri Dudakov
122,500
72,500
Priit Parmasto
116,000
66,000
Priit Oja
111,000
61,000
Priit Vallap
109,500
59,500
Rasmus Eino
108,500
0
Magnus Pukk
93,500
0
Pavel Solodovnikov
92,500
42,500
Silver Simulask
65,000
15,000
Aleksei Gontsar
65,000
15,000
Kaido Mikk
51,000
1,000
Päev 1C on läbi Posted Thursday 21st September, 2023 at 19:46(UTC+2) by maheaaatom
Päev 1C on nüüd lõplikult läbi ning peagi saame avaldada ka mängu jätkavate eestlaste stäkid + teiste mängijate TOP3. Seejärel lähme juba päeva 1D juurde.
Tarmo Tammel kasvatab stäkki Posted Thursday 21st September, 2023 at 19:34(UTC+2) by maheaaatom
Tarmo on tõusnud juba 250K peale ning on sellise näoga, et seda stäkki ta täna nüüd küll enam maha ei mängi.
Ka Oskar Ojaveer (220K) ning Dmitri Dudakov (140K) võivad end võrdlemisi kindlalt tunda.
Jagatakse päeva 1C viimast nelja kätt.
Player
Chips
Progress
Tarmo Tammel
250,000
200,000
Oskar Ojaveer
220,000
170,000
Dmitri Dudakov
140,000
90,000
Jaanuse stäkk kuivas kokku Posted Thursday 21st September, 2023 at 19:27(UTC+2) by maheaaatom
Jaanus Veste ei saanud täna oma mängu kuidagi käima ning on kahjuks turniirilt välja langenud. Vähemalt on Jaanusel WSOP Circuit meistrisõrmus olemas.
Ka Steven Tooli mäng oli viimastel tasemetel kõike muud kui tulus ning temalgi tuleb alalt lahkuda. Kas just lõplikult, see sõltub mehest endast. Niisamuti pole mängijate nimekirjas enam Tarvi Kristmani ja Taavi Veiderit.
1C lõpuni on veel 15 minutit, varsti peaks kõlama ka "3 last hands".
1D on samuti alanud Posted Thursday 21st September, 2023 at 19:20(UTC+2) by maheaaatom
Suures saalis on juba alanud ka mängupäev 1D, esialgu käib action neljal laual. Selle päeva juurde läheme siis kui hetkel käiv 1C on läbi.
1D- l on muide päris mitmeid põnevaid Eesti mängijaid nagu näiteks Keito Kaljulaid, Marek Selgeveer ja Hanno Kerem.
Milline on H.O.R.S.E.-i tase? Posted Thursday 21st September, 2023 at 19:14(UTC+2) by maheaaatom
Kairit Leibold arvas, et "hobune" on vägagi mängitav, kuid kui kaart ei jookse, pole midagi teha. Samas arvas ka Kaidar Viikman, kes siiski rõhutas, et mõne suht algaja kõrval on laudades ka väga häid mängijaid ning lihtne seda võita pole. H.O.R.S.E. on muidu ka pausil, seepärast me mängijatega rääkida saimegi.
Põhiturniiri päeval 1C on käimas juba viimane tase, kaua meil enam mängida ei ole.
19:05 (UTC+2)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Meedia- ja teletiimi tööst Posted Thursday 21st September, 2023 at 19:02(UTC+2) by maheaaatom
On tuntud huvi, et kui palju meedia- ja TV-inimesi turniir vahendamisega tegeleb. Mõeldud on siis inimesi, kes ei ole täiskohaga Olympic Casino töötajad, vaid festivali raames appi palgatud.
TV-tiimi pealiku Edgar Pravoni sõnul on tema meeskonnas 8-9 inimest, kes roteeruvad. Korraga on enamasti ametis 5 inimest.
Foto- ja videomaterjali eest kannab hoolt 5 inimest. Nende seas siis mõlemad "Klambrid" (Elena ja Tambet Kask), operaator Koit ning hostessid Evely ja Teele.
Tekstiosaga (blogi ja kokkuvõtted) tegeleb ühtekokku 7 inimest (viis tegelevad neist ülekandega, üks inimene vahendab toimuvat aga eesti ning üks soome keeles).
Ehk siis kokku on ametis umbes 20 inimest, mis näitab, et Olympic Casino võtab WSOP Circuit'i äärmiselt tõsiselt ning teeb kõik endast oleneva, et seda maksimaalselt hästi jäädvustada.
Kui palju tööd teha tuleb? Teiste eest rääkida ei taha, kuid eestikeelset blogi pidaval "Maheaatomil" peaks 11 päeva peale kokku kogunema umbes 120-130 töötundi. Teistel võib-olla, et rohkemki. Natuke küll (eelkõige vaimselt) väsitav, kuid samas väga põnev ning nauditav projekt, mille vastu valitseb ka piisav publikuhuvi.
Mark hangib lisa Posted Thursday 21st September, 2023 at 18:53(UTC+2) by maheaaatom
20. lauas on pangas umbes 35K ning mängus kaks meest - Mark Metsla ning soomlane Tomi Räsänen.
Lauas on avatud intrigeeriv (ilma masti võimaluseta) ning viimasena käiguõigust omav Mark Metsla teeb umbes pangasuuruse panuse. Räsänen ei suuda callimata jätta ning meie mees avab rea , millest piisab ainuvõiduks. Temal nüüd umbes 160K.
Player
Chips
Progress
Mark Metsla
160,000
110,000
Viimaks on mängus ka Ilari Sahamies Posted Thursday 21st September, 2023 at 18:42(UTC+2) by maheaaatom
Maailmakuulus high-roller Ilari Sahamies, kes on tegelikult juba ammu Tallinnas, on ka viimaks lauda istunud. Siiani on "ziigmund" mänginud peamiselt raha- ja segamänge.
Andres Leppik on jäänud väga shordiks pärast saatuslikku all-in kaotust -ga pocket ässadele.
Silver Simulask on 64K peal. Tal oli hea algus, kuid viimasel ajal on stäkk pigem kogu aeg langenud.
Fuajeepokker on ammu läbi, seal valmistutakse juba päevaks 1D. Päeval 1C hetkel 156 mängijat, sisseoste aga täpselt saja võrra enam.
Tarmo kardab ajaloo kordumist Posted Thursday 21st September, 2023 at 18:32(UTC+2) by maheaaatom
Tarmo Tammel istub lauas vägeva 190K stäkiga, kuid peab vajalikuks märkida, et esimesel päeval tal juba oli täpselt selline stäkk ning viimastel tasemetel läks see teadagi kuhu.
Veel üks väga suur stäkk on Oskar Ojaveeril (ca. 220K). Oskar istub aknaaluses lauas väga keskendunud ilmel, puhv näol ja nokats peaks. Küllap üritab lauas võimalikult märkamatuks jääda.
Player
Chips
Progress
Oskar Ojaveer
220,000
170,000
Tarmo Tammel
190,000
140,000
18:28 (UTC+2)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
Ratsavägi suureneb Posted Thursday 21st September, 2023 at 18:02(UTC+2) by maheaaatom
H.O.R.S.E.-il osalejate arv on vaikselt suurenenud, mänguga on liitunud ka mõlemad Leiboldid ja mõlemad Abakanovid. Kõik nad on kõvad segamängude asjatundjad ning mis peamine - ka armastavad neid mänge!
Põhiturniir (hetkel 171 mängijat ja 251 sisseostu) läheb kohe oma 1C viimasele pausile, pärast mida on veel 80 minutit mängida. Ühtlasi hakkame valmistuma ka päevaks 1D, millele antakse avapauk kell 19:00.
Langenud Martin Piik ja Tõnis Viik. Martin on siiani olnud väga heas hoos, kuid põhiturniir ei suju kuidagi. Võimalusi siiski veel on - õhtune 1D või siis homme lihtsalt gämblema tulla.
Sportlaste käekäigust Posted Thursday 21st September, 2023 at 17:42(UTC+2) by maheaaatom
va. . Teine kõva spordimees, maadleja ning jõusaalitreener Erik Int on umbes samas seisus, mis Martti enne väljalangemist - 25K stäkk ning kaart täna väga liikunud ka pole.
Ja lõpetuseks suurte pokkerisportlaste käekäigust ka. Ranno Sootla on natuke tõusnud, tal on hetkel umbes 40K. Priit Parmasto on netimängud lõpetanud (ju läks fish, kellele ta jahti pidas, lauast minema) ning keskendunud WSOPC-le. Tema stäkk endiselt umbes 110K.
Saab ka nii Posted Thursday 21st September, 2023 at 17:32(UTC+2) by maheaaatom
Laual on ning Paulius Vaitiekunas panustab üsna pirakasse panka 10K. Tarmo Tammel lükkab seejärel all-in ca 40K, mida on üsna sama palju kui ka leedulasel. Viimane mõtleb pikalt, otsustades siiski callida.
Tarmo:
Paulius:
Tarmo on enam kui rabatud. "Ma arvasin, et sul on äkki või midagi sellist!"
Kuigi leedukas juhib, et usu ta millegipärast, et jaotuse võidab. Ja vaist ei peta teada. River on, Tarmo saab kahe kõrgema paariga panga endale. Tal nüüd umbes 100K.
17:28 (UTC+2)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Kuidas edeneb? Posted Thursday 21st September, 2023 at 17:17(UTC+2) by maheaaatom
Põhiturniiril 185 mängijat (244 sisseostu kokku) ning kaks lauda on endiselt fuajees. Jaanus Veste on üsna samas seisus, Tõnis Viik on natuke ära andnud.
H.O.R.S.E. algas 13 mängijaga, eestlastest on (hetkel) osalemas Kaidar Viikman ja Priit Brikker.
250 € deepstackil 60 mängijat (110 sisseostu), tuntud eestlastest on mängus näiteks Airin Pindis, Marko Keskel ja Kristo Erala.
Käib ka 3000 €-se 6max'i satelliit ning on tehtud 26 sisseostu. Seega on overlay vägagi reaalne ning kõigil, kes soovivad nn. "High-roller turniiri" mängida, tasuks sammud satelliidile seada.
Hobust taltsutama! Posted Thursday 21st September, 2023 at 17:00(UTC+2) by maheaaatom
Nendel minutitel (kell 17:00) algavale H.O.R.S.E.-ile on reganud 6 mängijat, neist viis soomlast. Aga on vaid aja küsimus, kui mängijaid juurde tuleb ja action käima läheb.
Sisseost on selle festivali kohta suhteliselt madal (350 €) ning mängurõõmu jagub kauaks.
Põhiturniiril alles 187 mängijat, välja on langenud Kalju Kratovitš, Rauno Arras ning Kaspar Kaisel.
Priit Vallap ja Steven Tool 140K peal Posted Thursday 21st September, 2023 at 16:57(UTC+2) by maheaaatom
Pausiks olid nii Priit Vallap kui Steven Tool endale hankinud korraliku 140K stäki, mis teeb neist ühed turniiri liidrid.
Soovite ka teada, kuidas läheb ilmakuulsal Soome pokkerimiljonäril Juha Helppil, kes on muide 2023. aasta Eesti pokkerimeister? Mehel on hetkel 75K stäkk, mis on umbes 10K üle keskmise.
Veel üks põnev isa-poja duo Posted Thursday 21st September, 2023 at 16:53(UTC+2) by maheaaatom
Kui iga Eesti pokkerifänn teab nime Igor Pihela ning sedagi, et meil on ju tegelikult kaks kanget Igor Pihelat (isa ja poeg), siis sarnane duo on välja panna ka rootslastel: Hansson Skommar C. H. ehk Skommar Hansson Jr. ja Hansson Skommar Anders ehk Skommar Hansson Sr.
Mõlemad mehed on ka WSOP-C põhiturniiril ning senini on vanemal Hanssonil märksa paremini läinud - ta on 175K stäkiga üks liidritest.
16:49 (UTC+2)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Ranno raskustes, Martti ka langenud Posted Thursday 21st September, 2023 at 16:18(UTC+2) by maheaaatom
Põgus pilk mängusaali näitab, et Ranno on oma algstäkist tublisti ära andnud ning ka Martti Keel pole veel oma mängu õieti käima saanud. Teiseks tasemeks suutis ta küll 90K peale saada, kuid hiljem on Marttit vaevanud kaardisurm ning korra jäi ta ka vales kohas bluffimisega vahele.
Hetkel 235 sisseostu (kokku 481) ning laudades 191 allesjäänut päevalt 1C. Peagi olemas minema ka päeva teisele pausile. OlyBet Bar & Grill pakub kõikidele osalejatele tavapäraselt 10-eurost maitsvat lõunat.
Mark elimineerib leeduka Posted Thursday 21st September, 2023 at 16:10(UTC+2) by maheaaatom
Aurelijus Sipavicius avab 1600-ga, Soome esindaja Vuong väänab veel juurde 3200 ning Mark Metsla nelipanustab 11200.
Aurelius läheb seejärel all-in (umbes 30K), Vuong foldib ning Mark callib hetkega.
Aurelius:
Mark:
Lauda meie mehel igat turvaline
Marki stäkk ca. 120K.
Tähelepanuks segamängude fännidele! Posted Thursday 21st September, 2023 at 16:03(UTC+2) by maheaaatom
WSOP Circuit'il toimub kaks universaalset segamängude turniiri, millest esimene (kus anti välja ka sõrmus) lõppes teatavasti esmaspäeval.
Täna kell 17:00 algab aga 350 € H.O.R.S.E., mis peaks segamängude austajatele samuti meeldima. Turniir toimub selleks ette nähtud ruumi, suurest saalist päris kaugel eemal. Hea mõnus rahulikult (?) klõbistada...
Magnus korjab mastiga lisa Posted Thursday 21st September, 2023 at 15:58(UTC+2) by maheaaatom
Pangas on juba umbes 20K ning Edgars Beizaks checkib ette pärast lauast avatud .
Magnus mõtleb kaua ning viskab seejärel sisse 9000 punkti. Lätlane ei jäta jonni, callib ära. Magnus näitab ning korjab panga mastiga maha. Magnusel on umbes 80K, laua liider on aga leedulane Andrius Bielskis meie mehest umbes kaks korda suurems stäkiga.
Fuajee-uudiseid Posted Thursday 21st September, 2023 at 15:54(UTC+2) by maheaaatom
Tõnis Viik kurdab, et sattud vahepeal kole heasse lauda, kuid viidi sealt momentaalselt minema ning nii ta fuajeesse sattuski. Kuna üheaegsete mängijate arv väheneb, siis suure tõenäosusega jõuab ta varsti suurde saali tagasi. Tõnisel hetkel umbes 80K.
Samuti on fuajees WSOPC sõrmuse omanik Jaanus Veste, kes kurdab, et tal ei lasta üldse mängida. "Siin on üks närvihaige, kogu aeg paneb kuus tonni ja kuus tonni," kurdab Jaanus.
15:51 (UTC+2)
Start of Level 6 Blinds: 400/800 Ante: 800
Murdepunkt? Posted Thursday 21st September, 2023 at 15:38(UTC+2) by maheaaatom
Kas oleme ületanud murdepunkti?
See tähendab hetke, kui parajasti lauas istuvate mängijate arv enam ei suurene. (Tähendab, et uusi mängijaid, sh. re-entry tegijaid, tuleb juurde vähem, kui turniirilt välja langeb).
Rekordiks on täna jäänud 202 mängijat, hetkel juba 200.
Priit laseb kahel rindel Posted Thursday 21st September, 2023 at 15:33(UTC+2) by maheaaatom
Pokkeriprofil Priit Parmastol on aeg raha ning turniiri kõrval on tal avatud ka OlyBeti rahalaud (selline multitable'ing on igati lubatud tegevus, kuigi asjaarmastajal tekib küsimus, et kuidas ta küll suudab mõlema asjaga korraga väga heal tasemel tegutseda. Aga ega ta esimest korda ka sellega tegele...)
Täpsematesse detailidesse laskumata olgu öeldud, et 1500 € sisseost tundub selle online-mängu kõrval, kus Priit hetkel online'is osaleb, suht naljategemine...
Aga Priit on igati hästi edenenud ka WSOP-C põhiturniiril. Tema stäkk on umbes kahekordne keskmine ehk 110K.
Värkes numbrid Posted Thursday 21st September, 2023 at 15:22(UTC+2) by maheaaatom
Täna on tehtud juba 223 sisseostu ehk koos päevadega 1A ja 1B on neid kokku juba 469. Ka laudades istuvate mängijate arv on kerkinud üle 200.
Satikas ootab mängijaid Posted Thursday 21st September, 2023 at 15:19(UTC+2) by maheaaatom
Ruumi "Las Vegas" ootab neli lauda ja neli tublit diilerit, et 6-max'i satikas käima panna. Keda aga pole, on mängijad. Kolm inimest on küll kirjas, kuid seda on ilmselgelt vähe, et turna käima läheks. Aga aega veel on.
Seevastu 250 NLH € Deepstack on üsna populaarne, sest mängus juba sadakond huvilist. Nende seas on hulgaliselt inimesi, kes juba põhiturniiri päevadel 1A või 1B kätt proovinud ning edasipääsu teise päeva taganud. Miks siis mitte natuke lustida?
15:05 (UTC+2)
Start of Level 5 Blinds: 300/600 Ante: 600
Põhiturniir laienes fuajeesse Posted Thursday 21st September, 2023 at 15:05(UTC+2) by maheaaatom
Põhiturniir on juba jõudnud otsaga fuajeesse, kus on hetkel kaks mängulauda. Vajadusel saab liikuda edasi veel ühte konverentsiruumi, mida pole siiani veel Tallinna suurturniiridel kasutatud.
Eesti mängijatest on langenud Viktor Blinov ja Mart Rinken. Väheke loovutas just nööpe Martti Keel, kui callis pärast laual avatu vastase 7K panust. Rida vastasel polnud, kuid -st piisas, et pank kätte saada.
Dudakovil korralik algus Posted Thursday 21st September, 2023 at 14:35(UTC+2) by maheaaatom
Eesti mängijatest on üsna korraliku alguse teinud ka Dmitri Dudakov, kes samuti suutnud oma algstäki enam-vähem duublisse saada.
Nimekatest mängijatest hakkas silma ka soomlane Mathias Siljander, kes on Tallinna suurturniiride tõeline imemees ning olnud siin isegi Ranno Sootlast endast edukam. Siljanderil on umbes 720 tuhande dollari eest Hendoni cashe.
14:26 (UTC+2)
Start of Level 4 Blinds: 200/500 Ante: 500
200 sisseostu pole enam kaugel Posted Thursday 21st September, 2023 at 14:26(UTC+2) by maheaaatom
Pausi ajal lisandus turniirile veel hea ports mängijaid, hetkel on neid juba 182 (kokku 191 sisseostu).
Hiliste liitujate seas on ka näiteks Ranno Sootla, kes võitis muide pileti eilselt satelliidilt. Nagu näete, ei põlga ka kõvad mängumehed neid ära.
Esimene paus Posted Thursday 21st September, 2023 at 14:04(UTC+2) by maheaaatom
Mängijad lubati 20 minutiks jalgu sirutama. 166 inimest laudades/175 sisseostu. Hakkab looma!
Pause on 1C-l tavapäraselt kolm: pärast kolmandat, kuuendat ja kaheksandat taset.
Kellel on enim sõrmuseid? Posted Thursday 21st September, 2023 at 14:02(UTC+2) by maheaaatom
Tänase seisuga on WSOP Circuit meistrisõrmuse võitnud viis Eesti pokkerimängijat - Urmo Velvelt, Jaanus Veste (mõlemad online'is), Aleksei Smirnov, Kaur Ajamaa ja Ranno Sootla (kõik Tallinnas toimuvalt suurfestivalilt).
Maailma edukaimad mängijad on aga Ari Engel ja Maurice Hawkins, kel mõlemal juba 15 sõrmust. Seega - isegi kõige parema tahtmise juures jääb sõrmedest vähemast.
Nagu korduvalt öeldud, tagab sõrmus koha 2024. aastal Las Vegases toimuvale WSOP meistrite turniirile (mille võitja saab ka WSOP braceleti). Selle turniiri hinnanguline väärtus on 1000 € mängija kohta (tegemist on freerolliga), majutuse ja lennud peab mängija ise korraldama. Täpsemalt on seda selgitatud ka järgmises WSOP Circuit Tallinn artiklis.
Täna saab asuda 3000 € piletetite jahile Posted Thursday 21st September, 2023 at 13:54(UTC+2) by maheaaatom
WSOP Circuit Tallinn kõige suurema sisseostuga turniir - 6max NLH - algab laupäeval. Kuna sisseost on 3000 €, ei saa seda festivali kontekstis päris high-roller turniiriks nimetada (2x põhiturniiri sisseost), kuid kindlasti meelitab see kohale rea häid mängijaid.
Kell 15:00 saab aga juba asuda selle turniiri pileteid jahtima, satelliidi sisseost on 150 eurot ning vähemalt kolm piletit on garanteeritud.
Silver 110K Posted Thursday 21st September, 2023 at 13:46(UTC+2) by maheaaatom
Silver Simulask on oma alsgtäki juba duublisse saanud ning istub lauas rahuloleva näoga. vs. on Silverile hästi meeles.
Martin samuti uuel katsel Posted Thursday 21st September, 2023 at 13:44(UTC+2) by maheaaatom
Martin Piik on ka juba põhiturniiril kätt proovinud, kuid siiani mitte just õnnestunult. Samas on mees teinud kaks sügavat jooksu sõrmuseturniiridel ning ka ühe kõrvalturniiri võitnud - so far so good.
Samuti on uuesti lauas Mark Metsla ning me võime tervitada ka Andres Leppikut, Stevel Tooli, Oliver Kullmanit ning Rasmus Einot.
Hetkel 158 mängijat/166 sisseostu.
13:24 (UTC+2)
Start of Level 3 Blinds: 200/400 Ante: 400
Saal täitub Posted Thursday 21st September, 2023 at 13:21(UTC+2) by maheaaatom
Laudades on juba 147 erinevat mängijat, lisaks on neli õnnetut pidanud ka re-entry tegema. Seega päev kogub hoogu ning tõenäoliselt koguneb päeval 1C-l rohkem sisseoste kui päevadel 1A ja 1B kokku.
Eestlastest veel juures Urmo Einard, Hanno Liiva, Tanel Merida jt.
Algas 250 € NLH Deepstack Posted Thursday 21st September, 2023 at 13:18(UTC+2) by maheaaatom
Fuajees on alanud tänane esimene kõrvalturniir - 250 € NLH Deepstack.
Mängitakse 20 min. tasemetega, algstäkk 30 000 punkti. Liituda saab kaheksa esimese mängutaseme jooksul ehk umbes kella 16:20-ni.
Visadus viis sihile Posted Thursday 21st September, 2023 at 13:16(UTC+2) by maheaaatom
Veel üks põnev fakt eilsest - soomlane Olli Juhani Rummukainen tegi 1100 € PLO turniiril üheksa (!) sisseostu.
Aga asjast oli kasu ka. Olli Juhani lõpetas teisena ning teenis 23 250 eurot. Kui ta oleks jäänud viiendaks või kaugemale, siis tulnuks leppida juba kahjumiga...
Tänaseid Eesti tippmängijaid Posted Thursday 21st September, 2023 at 13:02(UTC+2) by maheaaatom
Lisaks eelnevalt mainitud Priit Parmastole ja Silver Simulaskile on täna lauas ka näiteks Magnus Pukk, Oskar Ojaveer, Kaspar Kaisel, Dmitri Dudakov, Martti Keel, Mark Metsla, Kaido Mikk, Mart Rinken...ning taaskord Tarmo Tammel.
Samuti on kohal alati värvikas Priit Oja.
Kas sommid veel magavad? Posted Thursday 21st September, 2023 at 12:58(UTC+2) by maheaaatom
Laudades on küll üksjagu soomlasi, kuid tavaliselt oleme neid harjunud ikka märksa rohkem nägema. Kuidas kommenteerib seda meie hea sõber, Soome reporter Juhani?
Eestlastele hästi tuttav blgoija on kindel, et täna näeme juba õige palju somme. "Eile mängisid väga paljud neist PLO-d ja muid turniire, küllap nad veel magavad ning tulevad peagi ka suurde saali. Aga võrreldes Kingsiga on neid tõesti vähem. Paljud puhkavad Barcelona EPT-st, profid mängivad muidugi ka WSOP Online'i ja WCOOPi," arvab Juhani. Ta prognoosib, et kõigest hoolimata tehakse päeval 1C vähemalt 200 sisseostu. Overlayd peab Juhani võimalikuks, kuid ta usub, et see ei saa just kuigi suur olema.
12:45 (UTC+2)
Start of Level 2 Blinds: 100/300 Ante: 300
Juba 114 mängijat Posted Thursday 21st September, 2023 at 12:36(UTC+2) by maheaaatom
Võrreldes päevadega 1A ja 1B täituvad täna lauad küll märksa kiiremini. Juba on laudades 114 mängijat ning ühel õnnetul ka re-entry kirjas.
Priit kolmandal katsel Posted Thursday 21st September, 2023 at 12:18(UTC+2) by maheaaatom
Kings of Tallinn 2023 põhiturniiri tšempion Priit Parmasto on täna uuesti lauas.
Eile läks tuulde kaks bulletit, kuid selle üle Priit ülearu ei muretse. "Mängisin samal ajal netis cashi, sain see 3K sealt tagasi," räägib pokkeriproff ise.
Veelkord tagasi eilsesse Posted Thursday 21st September, 2023 at 12:15(UTC+2) by maheaaatom
Eile oli meie fookuses põhiturniir (ja on ka täna), seega paneme väga lühidalt kirja info teiste eilsete turnade kohta.
- 1100 € PLO sõrmus läks Norrasse, meie parimana oli Igor Pihela noorem viies ja võitis 9000 eurot.
- 250 € NLH-l tehti 130 sisseostu, võitis soomlane. Parima eestlasena sai Virgo Laansoo kuuenda koha (1540 €)
- 250 € SVITEN-i (79 sisseostu) võitis taas norralane Erik Kristiansen, eestlasi osales turniiril vaid üksikuid ning keegi neist ka kaugele ei jõudnud.
- €150 PL Omaha 4, 5 & 6 Cards, Turbo võitis põhjanaabrite esindaja, tehti 49 sisseostu. Eestlased kaugele ei jõudnud.
Satikatel vastavalt 164 ja 144 sisseostu (viimasel anti välja 15 piletit). Seega tekkis uudsena kavasse lisatud kesköisel satikal ka pisike overlay, kuid kell 21:00 toimunud "tavaline satelliit" püstitas selge satelliidi osalejate arvu rekord.
Päev 1C on alanud Posted Thursday 21st September, 2023 at 12:06(UTC+2) by maheaaatom
Täpselt 66 mängijat on laudades istet võtnud ning diilerid on kaardid lauda pannud.
"Kus siin nüüd need järjekorrad on," imestas garderoobis staažikas pokkerihai Silver Simulask ning tõi võrdluseks Kings of Tallinna, mile järjekord uksest välja lookles.
Overlay (mängijate vaates) mittetekkimiseks peaks täna tehtama vähemalt 420 sisseostu, kuid Olympic Casino latt on veel pisut kõrgemal. Tahaks ju reiki ka saada ning igal juhul tuleb ju tasuda riigimaksud.
Põhiturniiri päev 1C algab kell 12:00 Posted Thursday 21st September, 2023 at 10:32(UTC+2) by maheaaatom
Neljapäeval on kavas kaks viimast WSOP Circuit põhiturniiri avapäeva. Neist esimene algab kell 12:00.
Päevadel 1A (teisipäev) ja 1B (kolmapäev) tehti ühtekokku 246 sisseostu ning tore on see, et võistlust juhib nimekas Eesti pokkeriproff Urmo Velvelt 293 000 punktiga.
Väga heas seisus on ka isa ja poeg Igor Pihelad, pühapäeval Eestisse meistrisõrmuse toonud Aleksei Smirnov ning vanameister Raivo Pinsel. Kokku pääses kahelt esimeselt avapäevalt edasi 105 mängijat, kuid tänase järel see number kindlasti enam kui kahekordistub.
10:28 (UTC+2)
Day 1C of WSOPC Tallinn Started Level: 1 Blinds: 100/200 Ante: 200
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.
(ilma masti võimaluseta) ning viimasena käiguõigust omav Mark Metsla teeb umbes pangasuuruse panuse. Räsänen ei suuda callimata jätta ning meie mees avab rea 
, millest piisab ainuvõiduks. Temal nüüd umbes 160K.
-ga pocket ässadele.
va. 
. Teine kõva spordimees, maadleja ning jõusaalitreener Erik Int on umbes samas seisus, mis Martti enne väljalangemist - 25K stäkk ning kaart täna väga liikunud ka pole. 
.
ning korjab panga mastiga maha. Magnusel on umbes 80K, laua liider on aga leedulane Andrius Bielskis meie mehest umbes kaks korda suurems stäkiga.
vastase 7K panust. Rida vastasel polnud, kuid 
-st piisas, et pank kätte saada.
on Silverile hästi meeles.
£ GBP
$ USD
€ EUR
