0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0058 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/1A/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0001 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.0001 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.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0002 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.0003 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.0005 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.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '122'
AND `published` = 1
0.0245 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '126'
AND `published` = 1
0.0247 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0048 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '128'
AND `published` = 1
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0049 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '131'
AND `published` = 1
0.0250 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '133'
AND `published` = 1
0.0247 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` = '137'
AND `published` = 1
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0047 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` = '1A'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '122'
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` = '122'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5318'
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` = '5317'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5315'
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` = '5311'
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` = '5308'
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` = '5306'
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` = '5304'
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` = '5302'
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` = '5301'
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` = '5294'
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` = '5292'
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` = '5289'
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` = '5288'
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` = '5287'
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` = '5284'
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` = '5283'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5282'
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` = '5280'
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` = '5279'
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` = '5278'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5275'
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` = '5271'
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` = '5270'
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` = '5269'
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` = '5264'
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` = '5262'
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` = '5261'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5258'
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` = '5256'
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` = '5254'
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` = '5252'
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` = '5251'
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` = '5249'
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` = '5246'
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` = '5244'
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` = '5242'
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` = '5240'
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` = '5235'
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` = '5227'
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` = '5226'
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` = '5225'
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` = '5224'
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` = '5221'
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` = '5219'
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` = '5217'
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` = '5216'
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` = '5214'
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` = '5209'
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` = '5207'
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` = '5202'
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` = '5198'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5196'
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` = '5193'
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` = '5190'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5186'
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` = '5179'
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` = '5178'
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` = '5177'
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` = '5175'
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` = '5174'
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` = '5172'
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` = '5167'
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` = '5164'
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` = '5162'
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` = '5161'
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` = '5156'
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` = '5152'
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` = '5149'
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` = '5144'
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` = '5143'
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` = '5141'
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` = '5140'
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` = '5139'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '122'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 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` = '122'
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` = '5318'
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` = '5317'
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` = '5315'
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` = '5311'
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` = '5308'
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` = '5306'
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` = '5304'
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` = '5302'
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` = '5301'
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` = '5294'
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` = '5292'
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` = '5289'
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` = '5288'
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` = '5287'
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` = '5284'
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` = '5283'
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` = '5282'
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` = '5280'
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` = '5279'
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` = '5278'
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` = '5275'
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` = '5271'
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` = '5270'
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` = '5269'
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` = '5264'
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` = '5262'
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` = '5261'
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` = '5258'
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` = '5256'
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` = '5254'
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` = '5252'
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` = '5251'
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` = '5249'
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` = '5246'
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` = '5244'
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` = '5242'
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` = '5240'
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` = '5235'
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` = '5227'
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` = '5226'
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` = '5225'
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` = '5224'
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` = '5221'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5219'
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` = '5217'
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` = '5216'
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` = '5214'
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` = '5209'
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` = '5207'
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` = '5202'
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` = '5198'
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` = '5197'
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` = '5196'
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` = '5193'
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` = '5190'
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` = '5188'
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` = '5186'
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` = '5179'
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` = '5178'
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` = '5177'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5175'
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` = '5174'
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` = '5172'
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` = '5167'
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` = '5164'
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` = '5162'
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` = '5161'
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` = '5156'
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` = '5152'
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` = '5149'
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` = '5144'
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` = '5143'
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` = '5141'
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` = '5140'
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` = '5139'
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.0003 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 1A lõplik chippide seis Posted Tuesday 19th September, 2023 at 20:21(UTC+2) by maheaaatom
Väga hea päev oli nii mõlemal Pihelal kui Aleksei Smirnovil, kes lõpetavad kuue parima seas. Jätkab 63 parimat, liidriks soomlane Joni Rantamäki. kena õhtut ning oleme tagasi kolmapäeval kell 12:00.
Player
Chips
Progress
Joni Rantamäki
272,000
0
Igor Pihela vanem
257,000
107,000
Yi-Zhan Peng
215,000
165,000
Gilles Rene Simon
211,500
161,500
Igor Pihela noorem
210,000
160,000
Aleksei Smirnov
204,500
24,500
Artur Külanurk
189,000
0
Ermo Kosk
152,500
0
Hendrik Uibo
149,000
19,000
Hendry Kullamäe
126,500
76,500
Arko Akenpärg
104,500
54,500
Ilya Nikiforov
101,000
51,000
Mario Linno
97,000
47,000
Alger Pissarev
71,500
21,500
Hanna Heinlo
68,500
18,500
Kaupo Tenno
54,000
4,000
Kristo Erala
51,000
1,000
Kris Tikka
50,000
0
Aleksander Lammas
47,500
2,500
Maikel Homin
44,000
6,000
Sergei Aleksejev
40,500
9,500
Rasmus Sepping
34,500
15,500
Rauno Remmel
30,000
20,000
Sten Talviste
30,000
20,000
Marko Vest
28,500
21,500
Raido Tsmir
19,000
31,000
Päev 1A on lõppenud Posted Tuesday 19th September, 2023 at 19:53(UTC+2) by maheaaatom
Nüüd on põhiturniiri päeva 1A ka lõplikult läbi ning mängijad ajavad chippe kottidesse, et (jah, alles!) reedel tagasi tulla.
Avaldame umbes poole tunni pärast ka TOP3 + kõikide allesjäänud eestlaste täpsed punktisummad. Põhiturniiri teine vaatus (1B) algab homme keskpäeval. "Las Vegase" ruumis on veel käimas ka 8-Game. Kas see mängitakse lõpuni täna või lükkub finaal homsesse, on hetkel veel teadmata.
Viimased käed põhiturniiril Posted Tuesday 19th September, 2023 at 19:50(UTC+2) by maheaaatom
Diilerid on jagamas päeva 1A viimaseid kaarte ning see tähendab, et kuskil kaheksaks on üritus purgis.
Täna on tulemas veel kaks turniiri - kell 21:00 algab 555 € NLH kõrvalturniir, kell 23:00 aga 60-eurone satikas 1100 € PLO-le (3 piletit garanteeritud).
Algas tänane esimene kõrvalturniir Posted Tuesday 19th September, 2023 at 19:40(UTC+2) by maheaaatom
Algas esimene tänane kõrvalturniir (€150 NLH / PLO4/ PLO 5 Mix, Button Round Each, 8 Handed). Esialgu 44 mängijat.
Põhiturniiri avapäeva lõpuni on jäänud vaid umbes veerand tundi ning me vabandame, et oleme sellele täna niivõrd tähelepanu pööranud. Samas ei toimu esimesel päeval õnneks ka teab-midagi-erilist ning Ranno ja Urmo pakutud elamus oli kindlasti väärt seda, et tänane tähelepanu 660 € Bountyle läks.
Ranno Sootla teeb ajalugu Posted Tuesday 19th September, 2023 at 19:22(UTC+2) by maheaaatom
660 € BOUNTY: Kohe esimese pausijärgse käega saab läbi ka sadade eestlaste tähelepanu püüdnud bounty-turniir. Mõlemad mehed on enne floppi sees:
Ranno:
Tanaka:
Lauda
Ranno Sootlast saab viies eestlane, kes võitnud WSOP Circuit meistrisõrmuse. Kuid tal on ka "suure WSOP" bracelet, mida pole ühelgi teisel. Müstiline mees!
19:15 (UTC+2)
Start of Level 10 Blinds: 1,000/2,000 Ante: 2,000
Urmo Velvelt tõmbas kastist 16 500 eurot Posted Tuesday 19th September, 2023 at 19:06(UTC+2) by maheaaatom
660 € BOUNTY: Turniir saadeti pausile, kuid põnevam osa oli alles ees. Urmo Velvelt asus bounty-kasti kallala ning lunastama oma kogutud VIITE (!) pearaha.
Õnne oli tal omajagu, sest juba esimese tõmbega tuli kastist 10K peavõit! Järgmised tšekid tõid sisse vastavalt 500 + 4000 + 1500 + 500 eurot ehk kokku 16 500 eurot. Väga vinge palgapäev!
Jaapanlane võtab järgi Posted Tuesday 19th September, 2023 at 18:59(UTC+2) by maheaaatom
660 € BOUNTY: Jaapanlasel kaart jookseb ning Tanaka on üldseisu tasakaalustanud. Meeste stäkid 2,6M-2,3M.
5 suuremat eestlaste stäkki põhiturniiril Posted Tuesday 19th September, 2023 at 18:55(UTC+2) by maheaaatom
Player
Chips
Progress
Aleksei Smirnov
180,000
130,000
Igor Pihela vanem
150,000
100,000
Tarmo Tammel
130,000
80,000
Hendrik Uibo
130,000
80,000
Maikel Homin
120,000
70,000
Leedulane väljas, Ranno Sootla heads-up'is! Posted Tuesday 19th September, 2023 at 18:45(UTC+2) by maheaaatom
660 € BOUNTY: Zabarauskas leidis viimaks väga hea käe () , kuid korralik kaart oli ka Rannol - .
Ühesõnaga puhas flip. Flopis veel üks poiss ning leedukas drawing dead juba päras turni.
Heads-up algab Ranno 2: eduseisus.
Bounty-turniiri stäkkide seis Posted Tuesday 19th September, 2023 at 18:42(UTC+2) by maheaaatom
660 € BOUNTY: Rannol on 2,6M, Tanakal 2,6M ning Zabarauskasel kõigest 500K. Seda on siis täpselt 10XBB.
Põhiturniir jätkub Posted Tuesday 19th September, 2023 at 18:38(UTC+2) by maheaaatom
Kuigi fuajeest tuleb veel kerget tümakat, on põhiturniiril osalejad taas laudadesse istunud ning mäng läheb edasi.
Hetkel 82/138, täna mängida veel täpselt 80 minutit.
18:36 (UTC+2)
Start of Level 9 Blinds: 1,000/1,500 Ante: 1,500
Urmo saab neljanda koha Posted Tuesday 19th September, 2023 at 18:35(UTC+2) by maheaaatom
660 € BOUNTY: Urmo viimast panust (ja eelkõige bountyt) lähevad callima nii leedulane kui jaapanlane, kuid Ranno leiab ning tõrjub oma 375K panusega konkurendid pangast välja.
Urmol on , kuid Ranno poiste vastu nad ei saa.
Vennaarmu ei tunta Posted Tuesday 19th September, 2023 at 18:30(UTC+2) by maheaaatom
660 € BOUNTY: Ranno callib SB-lt, Urmo tõstab BB-lt 175K-le ning Ranno lükkab mõningase mõtlemise järel all-in. Urmolt snap-call.
Ranno:
Urmo:
Flop on Urmole ohutu, kuid turn on ja river veel üks !
Rannol on pisut vähem, Urmol jääb 2XBB järgi.
Laval on Teele Viira Posted Tuesday 19th September, 2023 at 18:18(UTC+2) by maheaaatom
Tervituskõned on peetud, mängijad on saanud joogiklaasid ning lavale on asunud vahepeal otsekui võluväel 10 cm pikemaks kasvanud Teele Viira.
Seis üsna võrdne Posted Tuesday 19th September, 2023 at 18:12(UTC+2) by maheaaatom
660 € BOUNTY: Tanakal ja mõlemad eestlasel on üsna võrdsed stäkid, kõigil vahemikus 1,3-1,4M. Leedulasel on natuke alla miljoni.
Blindid 20/40/40.
Urmole ülivajalik duubel Posted Tuesday 19th September, 2023 at 18:09(UTC+2) by maheaaatom
660 € BOUNTY: Leedulane () avab tõstega, Urmo Velvelt lükkab tema järel oma shortstäki all-in ning kõige lõpuks leiab täna üldse head lehejooksu nautinud Tanaka !
Leedulane all-in'idega kaasa ei lähe. Flop on tühi mis tühi, kuid turni avatakse kuningas.
Urmol nüüd juba kena 1,3M.
Paus ongi käes Posted Tuesday 19th September, 2023 at 18:05(UTC+2) by maheaaatom
Hiltoni konverentsikeskuse suur saal hakkab tühjaks valguma - mängijad lähevad tänasele viimasele pausile, mis peaks kestma umbes 30-40 minutit.
Meie saame aga nautida edasi 660 € bounty-turnat, kus suures mängus ka kaks eestlast - Ranno Sootla ja Urmo Velvelt.
"Kaheksajalgade" arv kasvab Posted Tuesday 19th September, 2023 at 18:02(UTC+2) by maheaaatom
8-GAME: Oleme jõudnud 73 sisseostuni, Kairit Leibold on mängus tagasi ning oma avastarti on tegemas ka nimekas pokkeripersoon ning mitmekordne Eesti meister Herli Olop.
See turniir mängitakse muide täna lõpuni ning võib arvata, et tuleb päris pikk mäng. Hiline registeerumine saab muide ka kohe läbi.
Peo ootuses Posted Tuesday 19th September, 2023 at 17:55(UTC+2) by maheaaatom
Põhiturniiril on pausini veel 10 minutit, misjärel peaks algama väike tervituspidu koos kõnede, snäkilaua ja drinkidega. Ja Teele Viira laulab ka väheke. Esialgse info kohaselt kestab "ametlik osa" 40 minutit ning see ei toimu mitte kasiinos, vaid fuajees.
Peo ajaks pannakse kogu action seisma, kuid kuna TV-laud on viivitusega, siis ülekanne läheb muidugi edasi.
Põhiturniiril hetkel 138 osalejat, 87 mängijat on järgi. Mänguruumi on siiski piisavalt, umbes 70XBB. Ka "suurel WSOP-l" on üldiselt nii, et üsna lihtne on esimeset päeva üle elada, kuid mida edasi, seda karmimaks olelusvõitlus läheb.
Tanaka kamikaze-liigutus töötas Posted Tuesday 19th September, 2023 at 17:38(UTC+2) by maheaaatom
660 € BOUNTY: Jaapanlane näitas veelkord, et mune tal on ning julgusest juba puudust ei tule.
Viimases jaotuses haistis mees hästi ära Zabarauskase nõrkuse ning lükkas pärast lauas avatud kaarte (pank oli juba päris pirakas) toorelt all-in.
Vaist ei petnud teda, leedulane oma -ga callida ei julgenud. Nii sai -ga bluffinud Tanaka panga kätte ning suurendas oma vahepeal üsna õhukeseks jäänud liidriseisu.
Stäkid:
Tanaka 1,9M
Zabarauskas 1,3M
Ranno 1,3M
Urmo 480K
Urmol on 16XBB, ruumi hakkab väheks jääma.
17:32 (UTC+2)
Start of Level 8 Blinds: 600/1,200 Ante: 1,200
Aleksei alla kolmiku ei mängi Posted Tuesday 19th September, 2023 at 17:32(UTC+2) by maheaaatom
Vastne sõrmuseomanik Aleksei Smirnov on põhiturniiril väga hästi edenenud. Lauas öeldakse, et ega ta alla kolmiku mängigi ning Airin tõdeb, et ju siis õnn ikka tugevamaid soosib.
Aleksei stäkk umbes 200K.
Player
Chips
Progress
Aleksei Smirnov
200,000
150,000
Närvikõdi mõlemale Posted Tuesday 19th September, 2023 at 17:25(UTC+2) by maheaaatom
660 € BOUNTY: Tanakal on hästi jooksma hakanud ning viimane jaotus suurendas tema eduseisu veelgi. Nimelt kukkus Baglioni -ga PFAI tema otsa.
Flop oli muidugi saapakujuline - .
Turn oli aga selgelt vesi jaapanlase veskile ning river ei muuda enam midagi.
Jätkame neljakesi - Eesti vs. Jaapan vs. Leedu.
Unustage overlay! Posted Tuesday 19th September, 2023 at 17:17(UTC+2) by maheaaatom
Tänane põhiturniiri satelliit on ajalooline - esmakordselt EI TEKKINUD overlayd! Kirjas juba 113 sisseostu.
8-Game turniiril on 64 sisseostu. Kahjuks on mängust väljas Kairit Leibold ja Priit Brikker, kumbki pole ka re-entryt teinud.
Tanaka võtab Urmolt raha Posted Tuesday 19th September, 2023 at 17:13(UTC+2) by maheaaatom
Turn on , seekord Tanaka checkib, Urmo paneb 100K ning Tanaka läheb seejärel all-in 400K (Urmol 645K järgi). Eestlane ei calli.
Mis lehed siis meestel olid?
Tanak:
Urmo:
Mänguruumi nagu on? Posted Tuesday 19th September, 2023 at 17:02(UTC+2) by maheaaatom
660 € BOUNTY: Tiitli jahtiva viie mängija stäkid on järgmised:
Ranno 1,3M
Zabarauskas 1,3M
Urmo 1,1M
Baglioni 710K
Tanaka 630K
Blindid 10/25/25.
Urmo elimineerib rootslase Posted Tuesday 19th September, 2023 at 16:58(UTC+2) by maheaaatom
660 € BOUNTY: Üliväikesks jäänud rootslasel Lindbergil pole erilist tagasiteed. Ja vastas on Urmo Velvelt.
Lindberg:
Urmo:
Laud midagi ei muuda, Urmol nüüd 940K.
Eestlased võidule veelgi lähemal Posted Tuesday 19th September, 2023 at 16:55(UTC+2) by maheaaatom
660 € BOUNTY: Finaalist langeb veel üks mängija: sakslane Sedlak kaotab oma nupud meie heale sõbrale Baglionile.
Kõik aus: vs.
16:50 (UTC+2)
Start of Level 7 Blinds: 500/1,000 Ante: 1,000
Urmo annab duubli Posted Tuesday 19th September, 2023 at 16:47(UTC+2) by maheaaatom
660 € BOUNTY: Urmo üritab shortstäkki Baglionit välja võtta. Miks mitte proovida, bounty-chip on väärt vähemalt 500 € ning eksimisruumi on küllaga.
Baglioni:
Urmo:
Turni äss ja eestlane on drawing dead. Urmol nüüd 720K.
Ranno on liider Posted Tuesday 19th September, 2023 at 16:44(UTC+2) by maheaaatom
660 € BOUNTY: Ranno on natuke juurde hankinud ning ühes käes ka senise liidri Zabarauskase elegantselt välja bluffinud. Mõlema stäkid on pisut üle 1,3M.
Jaapani lipp lehvib Posted Tuesday 19th September, 2023 at 16:35(UTC+2) by maheaaatom
Jaapanlane saab emanda pihta ning parandab võimsalt oma seisu. Zabarauskasel väga midagi hullu ei juhtu, prantslane Sahli on aga paraku mängust väljas.
Kolm selget liidrit Posted Tuesday 19th September, 2023 at 16:30(UTC+2) by maheaaatom
660 € BOUNTY: Lõviosa nuppudest on kolme mehe käes - Zabrauskasel 1,5M, Rannol 1,2M ja Urmol 945K.
Ülejäänute stäkid jäävad alla 345K vahemikku 10-17XBB. Blindid 10/20/20, 8 mängijat.
Algs bounty-turniiri finaallaua ülekanne Posted Tuesday 19th September, 2023 at 16:27(UTC+2) by maheaaatom
660 € BOUNTY: 30 minutit tagasi alanud finaal on nüüd jõudnud ka TV-pilti ning meil on harukordselt hea võimalus nautida tipp-proffide Urmo Velvelti ja Ranno Sootla mängu avatud kaartidega.
Põhiturniiril on algamas teine paus. Kuus taset on mängitud, neli taset täna veel ees.
Põhiturniir kerib hoogu Posted Tuesday 19th September, 2023 at 16:17(UTC+2) by maheaaatom
Sisseoste on juba 137 ning mängijad järgi 108.
Artur Külanurk võib uhkustada umbes 125K stäkiga, Peeter Talvistel on ligi 80K. Üldiselt on aga action veel väga noor, et stäkkide põhjal suuremaid järeldusi teha.
Hapus seisus on aga Heiki Laja, alles vaid mõned nupud. Suurem osa läinud rida vs. mastirida, seejuures suutis Heiki veel viimasel hetkel foldida.
Leiboldid rõhuvad segamängudele, Abakanov ootab Hi-Lo'd Posted Tuesday 19th September, 2023 at 15:49(UTC+2) by maheaaatom
8-GAME: Esimese ning seni teadaolevalt ainsa eestlasena WSOP meistrite turniiril osalenud Imre Leibold (see juhtus siis 2005. aastal) ütles, et lisaks 8-Game'ile kavatseb ta osaleda võib-olla veel vaid H.O.R.S.E.-il ning äkki ka Pot Limit Omaha Hi-Lo'l (viimane on Ring Event, "hobune" kahjuks ei ole). Kairitil täiendavaid mänguplaane pole, kuid mine tea...
Kui kõlas "Pot Limit Omaha Hi-Lo peale", läksid kohe põlema samas lauas istuva Andres Abakanovi silmad. Seda põhjusega, tegemist on väga tugeva Omaha-mehega, kes on ka avalikult öelnud, et selles mänguformaadis ta endale Eestis vastaseid väga ei näe. Iseenesest mõistetavalt on Andres sellel turniiril (reedel) 100% kohal.
Varuge veel kannatust Posted Tuesday 19th September, 2023 at 15:44(UTC+2) by maheaaatom
660 € BOUNTY: Finaallaua set-up võttis natuke rohkem aega kui planeeritud, lisaks tõmmati korra ka bountyt. Umbes 25 minuti pärast peaksime nägema juba finaaliactionit.
Bounty jagunes kahe mängija vahel, sest juhtus olukord, mil üks mängija võeti välja kahe mängija poolt korraga. Õnneks meestel vedas, omavahel jagati igati korralik 2000 eurot. Suurema bounty-loosini on veel umbes 40 minutit aega.
15:41 (UTC+2)
Start of Level 6 Blinds: 400/800 Ante: 800
Markku "Las Vegasesse", Smirnov suurde saali Posted Tuesday 19th September, 2023 at 15:36(UTC+2) by maheaaatom
Just marssisid trepist üles üleeile meistrisõrmuse võitnud Aleksei Smirnov ning Eesti läbi aegade edukaim turniirimängija Markku Koplimaa.
Kui alguses paistis, et mõlemad mehed tulevad põhiturniirile, siis keeras Markku ikkagi varem ära ja sammus "Las Vegasesse". See, et Markkule segamängud meeldivad, teame me juba ammu.
Kaheksajalgu on 51 Posted Tuesday 19th September, 2023 at 15:32(UTC+2) by maheaaatom
8-GAME: Sellel turniiril, mille võitja saab samuti sõrmuse, on hetkel 50 mängijat, kellest üks - Andres Abakanov - on juba ka re-entry kirja saanud.
Eestlasi on sellest hoolimata hämmastavalt vähe, hetkel vaid kaheksa. "Tööpäev ja ikkagi suhteliselt kallis," arvab meie lippu kaitsev Revo Kink. Samuti teab Revo rääkida, et mängus on mitmeid nüansse, mis erinevad sellest, millega Eesti mängijad siiani kokku puutunud on. Kasutatakse WSOP reegeleid, näiteks on PLO-s mängus big blind ante ning erinev on ka nii mängude järjekord kui struktuur.
Põhiturniiri juhib britt Richards Posted Tuesday 19th September, 2023 at 15:20(UTC+2) by maheaaatom
Samuel Richardsil on ligi 200K stäkk, mis on 4x enam kui alguses anti. Eestlastest on oma punktisumma kahekordistanud nii Alger Pissarev kui Kaupo Tenno.
Ka Soome pokkerilegend Juha Helppi on suutnud enda stäki umbes 125K peale upitada ning naudib hetkel pikemat massaažisessiooni.
Käimas ka põhiturniiri megasatikas Posted Tuesday 19th September, 2023 at 15:16(UTC+2) by maheaaatom
Kell 15:00 algas põhiturniiri megasatelliit, kus antakse välja traditsiooniliselt 10 x 1500 € piletit. Sel turniiril on kõikidel eelnevatel päevadel tekkinud suurem või väiksem overlay ning küllap loodavad seda ka tänased mängijad. Hetkel igatahes 45 sisseostu tehtud.
15:11 (UTC+2)
Start of Level 5 Blinds: 300/600 Ante: 600
Bounty-turnal finaallaud koos Posted Tuesday 19th September, 2023 at 15:11(UTC+2) by maheaaatom
660 € BOUNTY: Telelauas toimus korralik action ning ühtäkki ongi järel 8 parimat, "kõrvallauas" mängivad Urmo ja Ranno mõistagi nende seas.
Seega peame tegema selle turniiri blogis umbes 40 minutilise pausi, et jälgida toimuvat sünkroonis teleülekandega (30 minutit viivitus ning vähemalt 10 minutit telelaua set-up'iks).
Bounty-turnat juhib Zabalauskas Posted Tuesday 19th September, 2023 at 15:05(UTC+2) by maheaaatom
660 BOUNTY €: Nn. "suures telelauas" hoiab ohje selles festivalil hästi silma psiatnud Vilius Zabalauskas. Tema on ka ainus, kelle stäkk eestlastest veel suurem.
Ülejäänud nupud on jagunenud pigem võrdselt, Urmole ja Rannole jäävad need selgelt alla. Finaallaua mull on pikk, eks kõik ju tahavad pildile pääseda.
Bounty-kastist on juba välja õngitsetud 7K ja 3K, kuid peavõit 10K on seal veel alles.
Ranno ja Urmo hoiavad oma lauda kontrolli all Posted Tuesday 19th September, 2023 at 14:56(UTC+2) by maheaaatom
660 € BOUNTY: Rannol ja Urmol on oma laua suurimad stäkid, neil jääbki üle vaid domineerida. Baglionil on enam-vähem keskmine stäkk, Lindberg ja jaapanlane Tanaka on aga suht shordid ja peavad all-in'e proovima. Viimastes jaotustes on nad seda ka teinud, kuid calle pole veel saanud.
Blindid 10/20/20, keskmine 492K.
Miljonimehed Posted Tuesday 19th September, 2023 at 14:50(UTC+2) by maheaaatom
660 € BOUNTY: Eestlastel on mõlemal umbes 1M stäkid, mis on 2x keskmisest suuremad.
Sünnipäevalaps Rannole (31) tuli võimas pank -ga ja vastu, floppi ülivajalik äss.
10 parimat järgi, peagi on finaallaud koos.
Bounty-turnal 14 parimat Posted Tuesday 19th September, 2023 at 14:36(UTC+2) by maheaaatom
660 € BOUNTY: Mängus on 14 parimat, kellest Marco Baglioni on väga short (umbes 5XBB). Põhjus selles, et lõviosa tema stäkist läks just PFAI-s Stefan Lindbergile ( vs. ). Eestlaste seis väga muutunud ei ole.
Nännihuvilistele Posted Tuesday 19th September, 2023 at 14:31(UTC+2) by maheaaatom
Hiltoni alumisel korrusel müüakse erinevat WSOP sümboolikat, mida võivad osta kõik (ka need, kes kasiinoalasse ei sisene).
Hinnad on vöga mõistlikud ja taskukohased kõikidele pokkerifännidele.
Põhiturniiril juba üle 100 sisseostu Posted Tuesday 19th September, 2023 at 14:29(UTC+2) by maheaaatom
Põhiturniiril ületati juba pausiga 100 mängija tähis, hetkel on sisseoste 107. Lisandunud on muuhulgas mõlemad Pihelad, Tarmo Tammel, Andrey Koks, Koit Kann, Ilya Nikiforov jpt.
14:27 (UTC+2)
Start of Level 4 Blinds: 200/500 Ante: 500
Ranno läheb gamblema Posted Tuesday 19th September, 2023 at 14:23(UTC+2) by maheaaatom
Marco Baglioni lükkab LP-lt oma umbes 100K stäki keskele ning BB-l olev Ranno vaatab, et üksjagu raha juba sees...miks mitte gamblema minna.
Baglioni:
Ranno:
Flops on emand, kõik hästi. Paraku avatakse turni äss.
Liiga palju bountysid - liiga vähe motti Posted Tuesday 19th September, 2023 at 14:18(UTC+2) by maheaaatom
660 € Bounty: Urmo naljatleb, et liiga palju bountysid pole mõtet alguses koguda, sest kui peaks suurimad (10K ja 7K) kätte saama, siis polegi nagu väga motti võidule mängida. Ja meistrisõrmus on Urmol ju nagunii varasemast olemas...
Urmo stäkk hetkel 750K, Rannol 450K. Blindid 6/12/12, keskmine stäkk 328K, 15 mängijat järgi.
Põhiturniiril esimene paus Posted Tuesday 19th September, 2023 at 14:04(UTC+2) by maheaaatom
Põhiturniiril algas esimene paus ning mängijad lähevad jalgu sirutama.
Esimese 2 tunniga on langenud välja koguni 8 mängijat, kelles suurem osa küll taas lauda tagasitee leidnud.
Kuna fuajees on jätkumas eestlastele märksa olulisem 660 € Mystery Bounty, siis jätkame kaasaelamist Urmole ja Rannole. Mehed on ühes lauas (mis pole telelaud), seega saame nende tegevust reaalajast kajastada.
Urmo teeb tööd Posted Tuesday 19th September, 2023 at 13:35(UTC+2) by maheaaatom
660 € BOUNTY: Urmo tõstab 25K ning saab vastu meie vana sõbra poolaka Ostrowski all-in'i (umbes 130K). Blindid, sh. Ranno Sootla foldivad.
Urmo:
Ostrowski:
Flop toob ühe kümne juurde ning Urmo tõuseb 750K peale. Rannol on 450K.
Bountydest ka: Urmol on juba kolm skalpi, Rannol pole veel ühtegi. Kuna jõudsime 16 parimani, siis toimub re-draw ning minnakse telealale.
660 € turniiril lõhkes mull Posted Tuesday 19th September, 2023 at 13:27(UTC+2) by maheaaatom
Üheainsa käe jooksul langes mängust kaks võistlejat, neist ühe elimineeris Urmo Velvelt.
Nupud läksid sisse pärast floppi ning Urmo näitas mastitõmmet () üsna pisikese stäkiga konkurendi vastu. Turn andis soovitud masti, river vastast ei päästnud.
13:24 (UTC+2)
Start of Level 3 Blinds: 200/400 Ante: 400
Sõrmus juba kolmes sõrmes Posted Tuesday 19th September, 2023 at 13:23(UTC+2) by maheaaatom
Eile püüdis Teele Viira kaamerate ette ameeriklase Albert Gorelik'i, kes on võitnud juba kolm WSOP Circuit meistrisõrmust, neist kaks tänavu augustis kõigest kuue päeva sees. Milliste mõtetega Albert Eestisse sõitis, saate näha siin.
Kahekordne meister Juha Helppi Posted Tuesday 19th September, 2023 at 13:20(UTC+2) by maheaaatom
Soome pokkerilegend Juha Helppi on kahekordne WSOP turniirivõitja, seejuures käib jutt "suurest WSOP-st" ehk käevõrudest. Kui Eesti profid on andnud mõista, et ta pole enam päris paremate päevade tasemel, siis tuleb ometi tunnistada, et võidud on saadud vastavalt 2019. ja 2020. aastal, viimane neist online'is.
Helppi turnateenistus on 8,2 miljonit dollarit, millega ta mahub maailma edetabelis 200 parima sekka (Soomes on ta teine).
WSOP Circuit Tallinn 2023 põhiturniiril istub mees hetkel umbes 60K stäkiga, natuke on õnnestunud esimeste tasemetega juurde saada.
Urmo näitab jõudu Posted Tuesday 19th September, 2023 at 13:14(UTC+2) by maheaaatom
Mull pole endislel lõhkenud, viimase panga võtab maha Urmo Velvelt.
Pärast turni on lauas ning initsiatiivi hoidnud Urmo vajutab positsioonilt all-in. Leedulane Bielskis peaks riskima kogu oma stäkiga ning seda huvi tal pole.
Urmol umbes 500K.
Heiki loodab heale karmale Posted Tuesday 19th September, 2023 at 13:01(UTC+2) by maheaaatom
Heiki Laja pole enda sõnul pokkerit küll mitu aastat mänginud (ühe erandiga), kuid karmat olevat tal nende aastatega piisaval kogunenud ning selle toel loodab ta ka turniiril kaugele jõuda. Siia sattumine olevat olnud lihtsalt juhuste kokkulangemine.
Põhiturniirilt on muide juba kaks mängijat välja langenud, üks neist Hendry Kullamäe, kes küll kohe ka re-entry tegi. Eestlasi on mängus juba üle 20.
Bounty-turnal käib mullimäng, raha saab 20 parimat.
12:46 (UTC+2)
Start of Level 2 Blinds: 100/300 Ante: 300
Põhiturniiril 73 sisseostu Posted Tuesday 19th September, 2023 at 12:46(UTC+2) by maheaaatom
Esimese mängitasemega kogunes põhiturniirile 73 sisseostu, mida on päris kenasti. Eestlastest on muuhulgas juures Andreas Kaju, Kristo Erala, Artur Külanurk, Taago Tamm ning üle pikkade aastate ka Heiki Laja.
Mark Bountylt väljas, Urmo on kõvasti tõusnud Posted Tuesday 19th September, 2023 at 12:44(UTC+2) by maheaaatom
Mark Metsla on kahjuks mängust väljas (24. koht, ei cashi), kuid Urmo Velvelt on saanud kõvasti lisa. Mees alustas päeva 119K stäkiga, kuid nüüd on tal juba 400K.
Rannol umbes 370K, on hästi natuke juurde saanud. Mehed mängivad muide ka ühes lauas.
Bounty-turnal hetkel blindid 4000/8000/8000, keskmine stäkk 234K ning alles 21 mängijat. Turniir toimub suures saalis kuni 16 parima selgumiseni, seejärel liigutakse juba telealale.
Airin loodab korrata Kings of Tallinn põhiturniiri saavutust Posted Tuesday 19th September, 2023 at 12:32(UTC+2) by maheaaatom
Airin Pindis on küll üks Eesti läbi aegade parimaid naismängijaid, kuid pokkerit mängib ta siiski selgelt meelelahutuslikel eesmärkidel ning eelistab ikka väiksemaid turniire.
Siiski on Airin vahel osalenud ka suurturniiridel, kui on õnnestunud satelliitidel, loosimistel või see pilet lisaauhinnana saada. Just loosimisega sai ta ka WSOP Circuit'i põhiturniiri pileti.
Kings of Tallinn põhiturniir lõppes Airinile cashiga, mis oli kindlasti tubli saavutus. Ja seda sooviks ta (vähemalt) korrata ka nüüd. Mis sellest, et enda sõnul pole ta pärast aprilli väga pokkerit mänginud.
Bountyd vahemikus 500-10000 eurot Posted Tuesday 19th September, 2023 at 12:29(UTC+2) by maheaaatom
Bountysid on 25 ning neid hakatakse välja loosima esimesel pausil. Iga pearaha on vähemalt 500 eurot, kuid suurim võit on 10 000!
Bounty-turniiride eesmärk on motiveerida mängijaid mitte venitama ega betoonist tagumikku kasvatama, vaid agressiivsust näitama. Turniiri võitja saab muide samuti 10 000 eurot.
Keda on põhiturniiril? Posted Tuesday 19th September, 2023 at 12:14(UTC+2) by maheaaatom
Varajaste alustajate seas on kümmekond Eesti mängijat, nende seas ka koguni kaks naist - Airin Pindis ja Hanna Heinlo (igaks juhuks vihjeks, et tegemist on nime vahetanud Jaanaga).
Lauas on ka Soome super-highroller Juha Helppi ning Eesti vutistaar Joel Lindpere.
Eestlastele üliedukalt lõppenud 5. päeva kokkuvõte Posted Tuesday 19th September, 2023 at 12:06(UTC+2) by maheaaatom
Põhiturniir on alanud! Posted Tuesday 19th September, 2023 at 12:04(UTC+2) by maheaaatom
Esimesed 40 mängijat on laudades ning turniiridirektor on kuulutanud põhiturniiri alanuks.
Alustatakse 50K stäkkidega, täna mängitakse 10 x 40 min. ja lubatud on piiramatu re-entry. Avapäevi on neli, seega võivad rikkamad sportlased võtta ette päris palju katseid.
Samuti läks käima 660 € Mystery Bounty.
12:02 (UTC+2)
Start of Level 1 Blinds: 100/200 Ante: 200
Main Event algab kell 12:00 - mängus on vähemalt miljon eurot Posted Tuesday 19th September, 2023 at 10:36(UTC+2) by maheaaatom
Tere taas!
Täna kell 12:00 saab alguse Eesti viimase 12 aasta suurim pokkeriturniir, mille auhinnafond on vähemalt MILJON eurot! Niisamuti algab kell 12:00 meie live-ülekanne.
Kuna põhiturniiri esimestel tasemetel tõenäolisel midagi väga olulist ei toimu, siis suuname päeva alguses peamise tähelepanu hoopis 660 € Mystery Bountyle, kus on algamas otsustavad sündmused. Mängus on 25 parimat, nende seas ka Eesti superässad Ranno Sootla, Urmo Velvelt ja Mark Metsla.
Luurame ka 14:00 algavat 8-Game'i (samuti sõrmuseturniir), kõrval- ja satelliitturniire ning oleme kohal mängijate peol, mis algab kell 18:00. Saab olema põnev päev!
10:30 (UTC+2)
Day 1A of WSOPC Tallinn 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.