0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0083 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-23'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event1_est/2/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.0002 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.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` = 'page'
0.0041 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` = 'wsopctallinn_2023_event1_est'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '95'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '105'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0065 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '107'
AND `published` = 1
0.0279 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0066 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '110'
AND `published` = 1
0.0284 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '114'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '26'
AND `name` = '2'
0.0063 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '114'
ORDER BY `busted` ASC, `current_chips` DESC
0.0069 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '114'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4839'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4825'
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` = '4793'
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` = '4787'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4782'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4780'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4778'
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` = '4774'
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` = '4772'
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` = '4765'
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` = '4763'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4755'
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` = '4746'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4744'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4741'
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` = '4740'
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` = '4737'
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` = '4735'
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` = '4733'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4730'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4728'
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` = '4726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0099 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4721'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4718'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4716'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4710'
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` = '4708'
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` = '4699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4698'
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` = '4695'
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` = '4687'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4685'
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` = '4679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4677'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4676'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4675'
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` = '4670'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4666'
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` = '4662'
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` = '4657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4656'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4653'
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` = '4652'
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` = '4649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4648'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4646'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4644'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4638'
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` = '4637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4632'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4631'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4630'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4623'
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` = '4621'
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` = '4620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4619'
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` = '4615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4611'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4605'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4602'
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` = '4598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4597'
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` = '4596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4593'
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` = '4589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4585'
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` = '4583'
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` = '4582'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4581'
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` = '4578'
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` = '4577'
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` = '4576'
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` = '4574'
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` = '4571'
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` = '4569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '114'
ORDER BY `busted` ASC, `current_chips` DESC
0.0063 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` = '114'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4839'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4825'
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` = '4793'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4787'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4782'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4780'
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` = '4778'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4774'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4772'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4765'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4763'
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` = '4757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4746'
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` = '4744'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4741'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4740'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4737'
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` = '4735'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4733'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4730'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4728'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4726'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4722'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4721'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4718'
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` = '4716'
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` = '4710'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4708'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4699'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4698'
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` = '4695'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4687'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4685'
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` = '4679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4677'
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` = '4676'
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` = '4675'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4670'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4666'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4662'
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` = '4657'
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` = '4656'
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` = '4653'
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` = '4652'
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` = '4649'
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` = '4648'
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` = '4646'
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` = '4644'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4638'
ORDER BY `chip_change` DESC, `busted` ASC
0.0089 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4637'
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` = '4632'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4631'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4630'
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` = '4629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4623'
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` = '4621'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4620'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4619'
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` = '4615'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4614'
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` = '4611'
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` = '4608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4605'
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` = '4602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4597'
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` = '4596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4583'
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` = '4582'
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` = '4581'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4578'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4576'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4574'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4571'
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` = '4569'
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` = '4568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0061 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '114'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 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.
555 € NLH Ring Event #1 võitis ukrainlane Viacheslav Sultanov Posted Sunday 17th September, 2023 at 17:15(UTC+3) by maheaaatom
Esimese WSOP Ring Eventi finaallaud vältas vaid neli tundi ning võit läks Ukrainasse.
Hinnalise WSOP meistrisõrmuse ning 34435 € auhinnaraha teenis Ukraina pokkerimängija Viacheslav Sultanov. Palju edu ka WSOP Tournament of Championsil Las Vegases!
TV-stream Posted Sunday 17th September, 2023 at 13:58(UTC+3) by maheaaatom
Finaallaud on koos Posted Sunday 17th September, 2023 at 00:04(UTC+3) by maheaaatom
Finaallaua mullimeheks jääb leedulane Dominykas Ruskys ning kõik allesjäänud jätkavad mängu homme keskpäeval. Finaali läheb liidrina norralane Torbjörn Larsen.
Toimuvale saab kaasa elada läbi TV-laua otseülekande, mille lingid lisame ka siia ülekandesse. Meie programm jätkub samuti homme keskpäeval, mil võtame peamise vaatluse alla WSOP #3 350 Ring Event'i, kuid hoiame silma peal ka 555 € ja 1100 € finaallaudadel ning muul põneval.
Head ööd!
Player
Chips
Progress
Torbjörn Larsen
2,445,000
2,415,000
Pawel Fraczek
1,640,000
1,610,000
Charles Benoit
1,400,000
110,000
Viacheslav Sultanov
1,115,000
50,000
Mikael Naski
995,000
175,000
Mikael Lundström
555,000
525,000
Petras Boguzas
555,000
525,000
Georgios Skarparis
550,000
265,000
Jonathan Mandara
210,000
180,000
11. koht Martin Piik 3000 € Posted Saturday 16th September, 2023 at 23:36(UTC+3) by maheaaatom
Martin pidi lükkama ning -ga võis selles olukorras kindlasti rahul olla (3XBB). Paraku oli Petras Boguzasel ning selle vastu jäi Martin võimetuks.
Vahetult enne Martinit langes välja ka vahepeal turnat juhtinud leedukas Jonas Ruginis. Seega on hetkel käimas finaallaua mullimäng.
Player
Chips
Progress
Martin Piik
0
0
Jonas Ruginis
0
0
13. koht - Viktor Blinov 2450 € Posted Saturday 16th September, 2023 at 23:27(UTC+3) by maheaaatom
Eesti mängijad on tõelises kriisis - nagu oleks vähe Tõnise ja Andrese kaotusest, langes kohe nende järel ka Viktor.
Viktor Blinovil on kirjas ainult üks pisike Hendoni cash. Mais sai ta viimasel Olympic Casinos toimunud Win TV Live'il üheksanda koha ning võitis 220 eurot. Nüüd lisandub sellele juba märksa suurem summa - 2450 €.
Eestlaste au jääb ainsana kaitsma Martin Piik, kellel on imepisike umbes 4XBB stäkk. Aga miski pole võimatu.
Player
Chips
Progress
Viktor Blinov
0
0
23:22 (UTC+3)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
14. koht - Andres Leppik 2450 € Posted Saturday 16th September, 2023 at 23:16(UTC+3) by maheaaatom
15XBB-le langenud Andres Leppik läks SB-lt shovema ning kukkus otseteed BB pocket ässade otsa. Midagi polnud teha, kuid tulemus siiski väga hea. 14. koht tõi sisse 2450 eurot.
Player
Chips
Progress
Andres Leppik
0
0
15. koht - Tõnis Viik 2450 € Posted Saturday 16th September, 2023 at 23:12(UTC+3) by maheaaatom
Üsna uniseks muutunud mängu lõpetas korralik pauk 18. lauas, kus preflopis läksid all-in kolm mängijat.
Viacheslav Sultanov:
Mikael Lundström:
Tõnis Viik:
Lauda jooksis kuningas. Kuna Tõnise stäkk oli kõige väiksem ning ta kaotas ka mõlemale vastasele, on meie mees kahjuks mängust väljas. Ukrainlasel oli Lindströmist enne saatuslikku jaotust küll palju suurem stäkk, kuid valus kaotus viis sellest umbes poole minema.
Näete, kui palju võivad seisud muutuda. Polnud ammu, kui Lindström ägises oma 5XBB-ga...aga kõik all-in'is on ta kenasti pihta saanud ning nüüd koguni turniiri liider. 14 mängijat jätkab.
Player
Chips
Progress
Tõnis Viik
0
0
Põhiturniiri satelliidil tuligi taas overlay Posted Saturday 16th September, 2023 at 23:01(UTC+3) by maheaaatom
Seekord maksid korraldajad mängijatele peale 2700 €, jäi 82 sisseostu (100 olnuks vaja garantii täitumiseks). NB! Sama turniir on kavas ka pühapäeval ja esmaspäeval, soovitame silma peal hoida.
"Hiinakal" on alles viis parimat, eestlased jäid esikümne piirimaile ehk rahadest kaugele.
1100 € NLH Ring Event #2 on jõudnud 24 parimani. Eestlasi on mängus viis: Ermo Kosk, Kaspar Valk, Aleksei Smirnov, Andrey Koks ja Tanel Evert.
2-7 Triple Draw satikas on osutunud isegi ootamatult populaarseks (paistab, et on neid segamängude huvilisi küll) - tehtud on 26 sisseostu.
TOP3 + Eesti mängijate stäkid Posted Saturday 16th September, 2023 at 22:46(UTC+3) by maheaaatom
Liidrid vahetuvad pidevalt, vahepeal suuurelt juhtinud norrakas Jon Kyte on üldse 16. kohaga mängust väljas.
Hetkel on esikolmikus hoopis Kanada, Soome ja Ukraina mängija. Eesti hobimängija Viktor Blinovi leiame kohe nende järelt neljandalt kohalt.
Player
Chips
Progress
Charles Benoit
1,290,000
1,260,000
Mikael Naski
1,170,000
1,140,000
Viacheslav Sultanov
1,065,000
1,035,000
Viktor Blinov
975,000
355,000
Andres Leppik
755,000
95,000
Tõnis Viik
570,000
80,000
Martin Piik
195,000
225,000
22:42 (UTC+3)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Tänane viimane paus? Posted Saturday 16th September, 2023 at 22:30(UTC+3) by maheaaatom
Mängijad lubati 20 minutiks puhkama, endiselt on 16 parimat järgi.
On suur tõenäosus, et järgmise 4 x 30 min. tsükliga saab finaallaua koosseis selgeks. Viimase tsükli alguses on blindid 40K/80K, mis tähendab, et BB on 146x kõikide nuppude kogusumma.
Tõnis annab väikese duubli Posted Saturday 16th September, 2023 at 22:17(UTC+3) by maheaaatom
Blindidel on Tõnis Viik ning rootslane Mikael Lundström. Ilmselgelt läheb Tõnis suruma, kuid paraku leiab Mikael käest pocket poisid. Ja Tõnisel kõigest
Turni järel on vastasel pulss üleval, sest maas on mastitõmme. Rootslane õnneks ning Tõnise kahjuks siiski river midagi ei muuda.
Re-draw Posted Saturday 16th September, 2023 at 21:56(UTC+3) by maheaaatom
Pärast Johan Grave langemist on turniiril on lühike tehniline paus, mille jooksul viiakse läbi re-draw.
Edasi jätkame kahel laual, alles on 16 parimat. Nende seas nii Tõnis, Andres, Viktor kui Martin. Tõenäosus, et eestlane WSOP Circuit'i võidab, on seega täpselt...25%.
18. koht - Maksim Solodilov 1550 € Posted Saturday 16th September, 2023 at 21:49(UTC+3) by maheaaatom
Maksim jättis endast turniirist väga tagasihoidliku mulje. Samas mängis kannatlikult, ootas omi kohti ning tõusis vahepeal ka liidrite sekka.
Enne väljalangemist oli tal umbes 5-6BB stäkk, seega mänguruum lihtsalt puudus.
Player
Chips
Progress
Maksim Solodilov
0
0
Põhiturniiri satelliit kisub jälle overlay suunas Posted Saturday 16th September, 2023 at 21:47(UTC+3) by maheaaatom
Pausini on jäänud 20 minutit ning tehtud 68 sisseostu. Vaevalt küll, et sajani jõutakse.
Kell 21:00 algab tänane viimane satelliit, 60-eurone 2-7 Triple Draw. Parimale viiele on nähtud ette 555 € pilet homme algavale sõrmseturniirile nr. 4, mis viiakse samuti läbi 2-7 Triple Draw formaadis. Segamängude austajad - lennake peale!
21:43 (UTC+3)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Martin jaksab oodata Posted Saturday 16th September, 2023 at 21:40(UTC+3) by maheaaatom
Shortstackiga virelevast Martin Piigist käis üle blindiring, lisaks üritas mees ka ühel korral ise blinde "varastada", kuid sai ületõste vastu. Kolmandik stäkist läinud nagu niuhti...
Aga viimaks leidis ta ikkagi õige koha, kust oma -ga lükata ning saada sellele ka poolt call.
Lauast kumbki midagi ei saanud, kicker mängis. Martinil nüüd 420K. Ja finaallaud tuleb järjest lähemale, sest saime vahepeal lahti ka kahest soomlasest.
Player
Chips
Progress
Martin Piik
420,000
210,000
Viie meie mehe stäkid Posted Saturday 16th September, 2023 at 21:32(UTC+3) by maheaaatom
Väga hästi on edenenud Andres Leppik, kelle stäkk on juba selgelt üle keskmise. Ka Tõnis Viik purjetab pärituules.
Player
Chips
Progress
Andres Leppik
850,000
500,000
Tõnis Viik
650,000
70,000
Viktor Blinov
620,000
120,000
Martin Piik
210,000
10,000
Maksim Solodilov
200,000
70,000
22. koht - Anatoly Filatov, 21. koht - Ranno Sootla - 1550 € Posted Saturday 16th September, 2023 at 21:25(UTC+3) by maheaaatom
Mõlemad mehed olid väga shordid (stäkk alla 10XBB), mistõttu tuleb väljalangemist pidada asjade loomulikuks käiguks.
Kahju on sellest muidugi küll. Tegemist ikkagi ülimalt kõvade mängumeestega, kes eeskujuks paljudele.
Player
Chips
Progress
Ranno Sootla
0
0
Anatoly Filatov
0
0
Kiita see seis just pole Posted Saturday 16th September, 2023 at 21:09(UTC+3) by maheaaatom
Vaid Tõnis Viigil on pisut üle keskmise stäkk ning Viktor Blinovil umbes keskmisega võrdne. Kõik teised jäävad sellele juba alla.
Hetkel on blindid 10K/20K ning keskmine stäkk seega 25XBB. Ei ole just väga palju mänguruumi...
Player
Chips
Progress
Tõnis Viik
580,000
400,000
Viktor Blinov
500,000
380,000
Andres Leppik
350,000
30,000
Maksim Solodilov
270,000
25,000
Anatoly Filatov
250,000
340,000
Ranno Sootla
220,000
250,000
Martin Piik
200,000
100,000
Telepurgis on Taago Tamm! Posted Saturday 16th September, 2023 at 21:01(UTC+3) by maheaaatom
24. koht - Risto Pärnat 1550 € Posted Saturday 16th September, 2023 at 20:56(UTC+3) by maheaaatom
Lõviosa Risti Pärnati nööpidest läheb Charles Benoit'le. Flopis on avatud , turn on .
Charles checkib ette, Risto paneb 40K ning vastane lükkab all-in. Ristolt call.
Mõlemad said kolmikult pihta, kuid Risto kicker oli Charles'i vastu. Kuna river oli blank, siis sellest piisas.
Ristol jäi paarkümmend tuhat järgi, millega ta oli järgmises jaotuses sisuliselt sund all-in. Ei tulnud sealt ka midagi.
Seega olema jõudnud 23 parimani ning tehti ka re-draw, et mägnida edasi kolmel laual. Igaks juhuks võime veel mainida, et 26. koha sai näiteks Tallinnas korduvalt hästi mänginud WSOPC sõrmuseomanik Glen Gaines.
Player
Chips
Progress
Risto Pärnat
0
0
20:44 (UTC+3)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Kuidas läheb tonnine turniir? Posted Saturday 16th September, 2023 at 20:41(UTC+3) by maheaaatom
Kell 14:00 alanud 1100 € Ring Eventiga on veel võimalik liituda, juba on kirjas tervelt 102 sisseostu.
Järel on 42 mängijat, nende hulgas ka näiteks Ermo Kosk, Markku Koplimaa, mõlemad Pihelad ja Aleksei Smirnov. Seegi turniir mängitakse täna kuni finaallauani ning homne finaal viiakse läbi juba telelauas.
Jätkuvad ka hiinakas (27 sisseostu, Mati Pirn ja Eha Pinsel endiselt sees) ning kulminatsioonile on üsna lähedal ka rahvaturniiri satikas (17 järgi, välja antakse vähemalt 10 piletit).
Alanud on ka põhiturniiri megasatikas Posted Saturday 16th September, 2023 at 20:37(UTC+3) by maheaaatom
Nii neljapäeval kui reedel korralikku overlayd pakkunud 10 x 1500 € põhiturniiri megasatikas on samuti alanud.
Süsteem sama, sisseost 150 eurot ning 10 parimat saavad põhiturniiri pilet. Hetkel on 42 sisseostu tehtud, "piirid" saavutatakse saja sisseostuga. Aega veel liituda kuni kella 21:00-ni.
Anatoly annab soomlasele duubli Posted Saturday 16th September, 2023 at 20:33(UTC+3) by maheaaatom
555 € turniir on jõudnud 26 parimani, meie kaheksane tiim on endiselt sees.
Anatoly Filatovil õnnestus korraks jälle üle 700K tõusta, nüüd tuli küll üks umbes 150K duubel anda. Nupud läksid soomlase Mikael Naski vastu pärast floppi , mis mõlemale hästi sobis.
Anatoly:
Mikael:
River tõi lauda rea ning põhjanaabrile vajaliku duubli.
Kõrvallauas madistavad omavahel Ranno Sootla ja Tõnis Viik. Kahel korral on Ranno enne floppi tõstnud, kuid mõlemal korral on positsioonil olnud Tõnis all-in'iga vastanud. Ranno stäkk on langenud juba natuke alla keskmise, nii 400K peale.
Mäng jätkub, TOP3+ eestlaste täpsed stäkid Posted Saturday 16th September, 2023 at 20:15(UTC+3) by maheaaatom
Turniiri juhib norralane Jon Kristian Kyte, teine koht kuulub kreeklasele ja kolmas leedukale, kuid mäng on niivõrd kiire, et kõik võib kiirelt muutuda.
Nagu manitud, mängus on kaheksa Eesti esindajat, kellest kolmel on TOP10 stäkid.
Player
Chips
Progress
Kristian Kyte
990,000
420,000
Georgios Skarparis
815,000
265,000
Jonas Ruginis
655,000
15,000
Anatoly Filatov
590,000
190,000
Risto Pärnat
470,000
30,000
Ranno Sootla
470,000
80,000
Andres Leppik
320,000
12,000
Martin Piik
300,000
80,000
Maksim Solodilov
245,000
120,000
Tõnis Viik
180,000
70,000
Viktor Blinov
120,000
30,500
20:09 (UTC+3)
Start of Level 21 Blinds: 10,000/15,000 Ante: 15,000
35. koht - Hanno Kerem, 34. koht - Sami-Sander Kivi, 32. koht - Roland Luik - kõik 1100 € Posted Saturday 16th September, 2023 at 19:15(UTC+3) by maheaaatom
Turniirilt pudeneb mängijaid niivõrd kiiresti, et käsi jälgida on suhteliselt võimatu ning kassas on lausa väike järjekord moodustunud.
Oleme jäänud ilma veel kolmest eestlasest. Vähemalt on nad kõik rahades - nagu ka suhteliselt tundmatu Sami-Sander Kivi, kolmekordne Eesti meister Hanno Kerem kui paljude lemmik Roland Luik. Mängu jätkab kaheksa Eesti värvide kaistjat.
Konkurentsis püsib 31 mängijat ning küllap on finaallaud juba märksa varem kui südaööks teada. Pisut pidurdab suurt tempot vaid õhtusöögipaus. Me oleme tagasi 60 minuti pärast ehk umbes kell 19:10.
Player
Chips
Progress
Sami-Sander Kivi
0
0
Hanno Kerem
0
0
Roland Luik
0
0
43. koht Dmitri Dudakov, 42. koht Rauno Remmel - mõlemad 1000 € Posted Saturday 16th September, 2023 at 19:05(UTC+3) by maheaaatom
Dmitri alustas turniiri viienda stäkiga ning sihid olid kindlasti kõrgemad, kuid vähemalt rahadesse ta jõudis.
Rauno Remmelil on väga lühike "Hendoni-ajalugu", siit tuleb vähemalt üks cash juurde.
Player
Chips
Progress
Rauno Remmel
0
0
Dmitri Dudakov
0
0
Endalegi ootamatu võit? Posted Saturday 16th September, 2023 at 19:02(UTC+3) by maheaaatom
Pangas on norrakas Kjetil Hanstvedt ning meie Ranno Sootla. Esimene üritab survet avaldada, teine konkurenti üle mängida.
Flopi järel panustab norralane 23K ning saab Rannolt calli.
Turn on , kas ühel või mõlemal mängijal majad? Kumbki ei panusta.
River on ning nüüd teeb juba Ranno 35K panuse. Kjetil callib hirmsa ägina järel, tema ainuke lootus on see, et Ranno mängib ässa-kickerile.
Norralasel on , Rannol ! Rida ja pank talle.
12 eestlast Posted Saturday 16th September, 2023 at 18:48(UTC+3) by maheaaatom
Meie andmetel on mängus tosin eestlast. Tõsi, Dmitri Dudakovi nende seas enam pole.
Tegelikult pole ju üldse paha seis. Mäng on muiudgi väga kiire ning juhtuda võib kõike - nii positiivses kui negatiivses võtmes. All-in kostub endiselt pea igal minutil ning mis seal imestada - keskmine stäkk on umbes 25 X BB.
Player
Chips
Progress
Dmitri Dudakov
0
0
Mull on lõhkenud, palju õnne allesjäänutele Posted Saturday 16th September, 2023 at 18:43(UTC+3) by maheaaatom
All-in ja call oli samaaegselt koguni kolmes lauas.
Esimeses duubeldas vastu.
Teises flipati: vs. , lauda veel üks poiss ning poiste omanikul väga napilt suurem stäkk.
Kolmandas lauas oli all-in'is olev mängija selgelt eest ( vs. ) ning ka võitis.
Seega jääb mullimeheks lätlane Matiss Celmins.
13 hiinlast Posted Saturday 16th September, 2023 at 18:28(UTC+3) by maheaaatom
"Las Vegase" nime kandvas toas on juba mõnda aega käimas nn. "kallis hiinakas". Mäng sama (OFC Pineapple), kuid sisseost suurem kui neljapäeval ehk 350 eurot.
Osaleb ka kaks eestlast, Mati Pirn ja Eha Pinsel. Istuvad muide ka ühes lauas.
Unlimited re-entry kestab 180 minutit.
Risto Pärnat pääses napilt mullist Posted Saturday 16th September, 2023 at 18:19(UTC+3) by maheaaatom
Risto Pärnat avastas end väga ebamugavas seisus all-in'is - pocket kuningatega pocket ässade vastu.
Aga seekord oli pokkerujumal eestlane. Turni kuningas ning mäng jätkub. Ristol nüüd väga korralik 440K stäkk!
Player
Chips
Progress
Risto Pärnat
440,000
193,000
18:15 (UTC+3)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Algas mullimäng Posted Saturday 16th September, 2023 at 18:15(UTC+3) by maheaaatom
Iirlane James Noonan lükkab oma pisikese, ca 50K stäki keskele ning saab calli buttonil istuvalt Tõnis Viigilt.
James:
Tõnis:
Lauda veel üks kuus ja iirlane mängust väljas. Sellega koos algas ka mullimäng, sest alles on vaid 48 parimat. Mängitakse hand-by-hand.
Player
Chips
Progress
Alexander Nemchin
0
0
Kas "milliseid" stäkke ka on? Posted Saturday 16th September, 2023 at 18:03(UTC+3) by maheaaatom
Seda uurib Roland Luik, kuid peame talle vastama, et veel ei ole. Turniiri juhib Jonas Ruginis, kel on natuke üle 700K.
Filatov on oluliselt ära andnud, paistab et kreeklasele Skarparisele. Viimasel on tubli 550K, Filatovil vaid pisut üle 400K.
Rannol sama seis, ikka umbes 550K. Ranno on aktiivne ja agressiivne, mis on talle taganud ka piisava respekti.
Avapäeval välismaalastest floorile usinalt Eesti numbreid ning nende moodustamist õpetanud Rauno Remmel püsib samuti visalt mängus, tal ligikaudu keskmine stäkk. Dmitri Dudakov on veel natuke ära andnud (140K), Martin Piik istub aga stabiilselt 220K peal.
Player
Chips
Progress
Georgios Skarparis
550,000
520,000
Anatoly Filatov
400,000
260,000
Martin Piik
220,000
188,500
Rauno Remmel
200,000
152,000
Dmitri Dudakov
140,000
40,000
17:56 (UTC+3)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Roland saab olulist lisa Posted Saturday 16th September, 2023 at 17:49(UTC+3) by maheaaatom
Sergei Guljajev pushib keskelt oma ca. 60K stäki keskele ning blindi kaitsev Roland Luik instacallib.
Sergei:
Roland: . Kuigi river on kaheksa, peavad poisid ilusti. Rolandil nüüd 200K, mis pole küll hirmsuur, kuid pisut üle keskmise ja annab mänguruumi juurde.
Oleme jõudnud viie koha kaugusele mullist.
Player
Chips
Progress
Roland Luik
200,000
110,000
Päevad pole vennad Posted Saturday 16th September, 2023 at 17:38(UTC+3) by maheaaatom
Väljas on ka teist päeva chipliidrina alustanud Raivo Pinsel.
Raivol oli megahea esimene päev, kuid teisel ei sujunud õieti midagi. Stäkk aina langes ja langes, kuniks vastased selle täielikult ära õgisid.
54 parimat järgi, veel vaid seitse kohta mullini.
Player
Chips
Progress
Raivo Pinsel
0
0
Jõujooned endised Posted Saturday 16th September, 2023 at 17:36(UTC+3) by maheaaatom
Kahju on Martin Vennost, kes siiski ei suutnud rahadesse jõuda. Eks laud oli ka suhteliselt keeruline. Viimased nööbid läksid -ga Ranno Sootla vastu, kuid see oli juba ebaoluline jaotus, sest Martinil oli selleks hetkels tõesti vaid paar BB-d järgi.
Ranno peaks aga olema turniiril suuruselt neljas stäkk ning vahed on õige väikesed. Filatov endiselt juhib, tal ca. 660K.
Player
Chips
Progress
Anatoly Filatov
660,000
263,000
Jonas Ruginis
640,000
610,000
Kristian Kyte
570,000
540,000
Ranno Sootla
550,000
521,000
Arko Akenpärg
0
0
Martin Venno
0
0
17:27 (UTC+3)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Mull läheneb hirmuäratava kiirusega Posted Saturday 16th September, 2023 at 17:27(UTC+3) by maheaaatom
Oleme jõudnud juba 59 parimani. Kümne parima seas paistab olevat neli Eesti mängijat, Filatov on neist endiselt suurim stäkk, kuid üsna napilt.
Jätkajate seas on meie arvestuse kohaselt 18 eestlast.
"Suures saalis" on nüüd ka märksa rohkem suminat kui varem, sest siia toodi ka 1100 € turniir. Seal hetkel 62 sisseostu.
Player
Chips
Progress
Ilya Nikiforov
0
0
Jätkame naisteta Posted Saturday 16th September, 2023 at 17:06(UTC+3) by maheaaatom
Soomlanna Anna-Mari Hursti langes just mängust välja ning nii jätkavad 555 € turniiri eranditult mehed. Meie kaotasime veel ka Andrei Mjagkovi.
Player
Chips
Progress
Andrei Mjagkov
0
0
Turniiri juhib Anatoly Filatov Posted Saturday 16th September, 2023 at 17:02(UTC+3) by maheaaatom
Pausile läks suurima stäkiga Anatoly Filatov, ka teine koht on meie mehe Maksim Solodilovi käes. Seejuures on viimane teinud lausa metsiku tõusu, sest kogu eelmise päeva vaevles ta mägnus väga pisikese stäkiga.
Aga väga hea meel on ka Andres Leppiku üle, kes alustas mängu täna sarnaselt Rannole 30K-ga, kuid on suutnud selle samuti kümnekordistada.
Player
Chips
Progress
Anatoly Filatov
397,000
97,000
Maksim Solodilov
365,000
336,000
Andres Leppik
308,000
266,000
Ranno Sootla
29,000
271,000
Algas järgmine mängutsükkel Posted Saturday 16th September, 2023 at 16:58(UTC+3) by maheaaatom
70 mängijat on laudades ning lähme edasi. Tulemas järjekordne tsükkel 4 x 30 min, mille lõpus on BB juba alla 1000x turniiril kokku mängus olevatest nuppudest. Kas selle jooksul ka mull lõhkeb, on aga pisut kahtlane, sest vahetult mulli lõhkemise eel läheb tavaliselt ikka korralikuks "kabetamiseks".
16:55 (UTC+3)
Start of Level 17 Blinds: 3,000/6,000 Ante: 6,000
70 mängijat pausile Posted Saturday 16th September, 2023 at 16:35(UTC+3) by maheaaatom
70 mängijat läheb 20 minutiks puhkama. Kui tempo püsib endine, siis hiljemalt õhtusöögiks on mull juba lõhkenud.
Paha uudis on see, et väljas on alles hiljuti väga head stäkki omanud Igor Pihela noorem. Aga mäng ongi väga kiire, keskmine stäkk ju alla 30XBB.
Player
Chips
Progress
Vladislav Topilskiy
0
0
Maksim Petrov
0
0
Janar Kokk
0
0
Martin Venno loodab algaja õnnele Posted Saturday 16th September, 2023 at 16:31(UTC+3) by maheaaatom
Eile väga tempokalt mängu sisenenud Martin Venno mängib enda sõnul oma ESIMEST live-turniiri. Mitte esimest suurfestivali, vaid üldse esimest turniiri.
"Online'is olen muidugi mänginud ja vahel sõpradega ka. Aga kui kuulsin, et Tallinnas toimub selline üritus, tulin isegi kohale."
Martinil on umbes 220K stäkk, mis on üle keskmise ja igati korralik. "Algaja õnn," muigab Martin ise. Soovime talle edu ning loodame, et esimene katsetud toob kohe ka vähemalt cashimise!
Player
Chips
Progress
Martin Venno
220,000
169,000
Pilk teistesse tubadesse Posted Saturday 16th September, 2023 at 16:18(UTC+3) by maheaaatom
Fuajees toimuval satikal on juba 50 sisseostu ning nagu arvata võis, osaleb turniiril ka mitmeid hobimängijaid.
1100 € Ringe Event'il on kirjas 46 sisseostu ning osalejate seas päris arvukalt eestlasi. Üldiselt tundub olevat nii, et kõik vähe asisemad mängijad, kes 555-selt välja langevad, leiavad end juba loetud minutite pärast kõrvalsaalis "Las Vegas" toimuvalt kaks korda kallimalt turniirilt.
80 parimat Posted Saturday 16th September, 2023 at 16:14(UTC+3) by maheaaatom
Action on tõesti megakiire. Umbes poole tunniga oleme kaotanud veel tubli 15 mängijat, kelle seas kahjuks ka agressiivne Eesti pokkeriproff Taago Tamm.
Lisaks temale on väljas Marko Vest, meie õnneks on aga ülejäänud langejad väliskülalised.
Player
Chips
Progress
Marko Vest
0
0
Taago Tamm
0
0
16:11 (UTC+3)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Skill ikkagi määrab Posted Saturday 16th September, 2023 at 16:11(UTC+3) by maheaaatom
Ranno Sootla alustas tänast päeva 30K-ga, nüüd on tal aga umbes kümme korda rohkem.
Sama heas seisus on Anatoly Filatov, kes on küll rahvuselt venelane ja sündinud Moskvas, kuid elanud viimased aastad Euroopas, sh. Eestis. Tal on ka Eesti ID-kaart taskus, seega peaaegu nagu oma mees. Filatovi live-teenistus on Hendoni andmetel üle 5,3 miljoni dollari, kuid erinevalt Rannost tal WSOP käevõru pole.
Ranno on tituleeritud mängija ka WSOP mastaabis. Tal on ikkagi olemas käevõru (see saadud küll online'is) ning ette näidata kõrge teine koht "päris WSOP-lt" Las Vegases. Loodame, et mees jõuab Tallinnas ka sõrmuseni!
Player
Chips
Progress
Ranno Sootla
300,000
270,000
Anatoly Filatov
300,000
270,000
Eestlaste read hõrenevad Posted Saturday 16th September, 2023 at 15:57(UTC+3) by maheaaatom
Tänavuse Summer Showdown põhiturniiri kolmas mees, kuulus High-Roller Urmo Velvelt on kahjuks mängust väljas. Ning jällegi, ta pole ainuke. Oma mängu ei saanud kuidagi käima ka näiteks Tarmo Tammel.
Tuntud tegijatest peame ütlema head-aega ameeriklasele James Little'ile, kes on "suurel WSOP-l" ka korra teiseks tulnud.
Player
Chips
Progress
Tarmo Tammel
0
0
Janek Tammsaar
0
0
Alari Kadanik
0
0
Urmo Velvelt
0
0
Algamas tõeliselt soodne satelliit Posted Saturday 16th September, 2023 at 15:52(UTC+3) by maheaaatom
Kell 15:00 algab (eeldavalt) fuajees kõigest 40-eurose sisseostuga satelliit homsele 350 € WSOPC "rahvaturniirile". Tegemist muide samuti Ring Eventiga.
Satelliidi võimalikud re-entryd maksavad kõigest 20 € ning on reigivabad. Garanteeritud on 10 x 350 € piletit.
Viimane sada Posted Saturday 16th September, 2023 at 15:47(UTC+3) by maheaaatom
Oleme juba jõudnud 100 mängijani, turniir edeneb tõesti väga kiirelt.
Meie arvestuse kohaselt jätkab mängu 27 Eesti mängijat ning rikkaimad paistavad olevat Dmitri Dudakov ja Igor Pihela noorem.
Päeva liidrina alustanud Raivo Pinsel on veel pisut kaotanud ning tema stäkk nüüd veel napilt üle keskmise.
Player
Chips
Progress
Raivo Pinsel
125,000
35,000
Kes üles, kes alla, kes üldse väljas Posted Saturday 16th September, 2023 at 15:44(UTC+3) by maheaaatom
Igor Pihela noorem on kenasti edenenud ning tõusnud umbes 180K peale. Äsja vastase pangast välja surunud Dmitri Dudakovil on umbes sama suur stäkk, seega temaga ka kõik okei. Ja tõusnud on ka Taago Tamm (umbes 140K)
Olulisel on ära andnud Urmo Velvelt ja Roland Luik. Väljas teiste seas ka Ermo Kosk ja Markku Koplimaa.
Player
Chips
Progress
Igor Pihela noorem
180,000
71,000
Dmitri Dudakov
180,000
42,000
Taago Tamm
140,000
73,000
Tõnis Viik
110,000
59,500
Roland Luik
90,000
55,000
Urmo Velvelt
60,000
97,000
Markku Koplimaa
0
0
Andrey Koks
0
0
Martti Keel
0
0
Ermo Kosk
0
0
Tanel Koht
0
0
Mairo Tori
0
0
15:38 (UTC+3)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Ranno on kenasti edenenud Posted Saturday 16th September, 2023 at 15:28(UTC+3) by maheaaatom
Ranno Sootla istuski alles täna esimest korda pokkerilauda 30K stäkiga, kuid on selle juba enam kui kolmekordistanud.
Ranno enda sõnul on tema fookus hetkel WSOP Circuit'il, kuid ta hoiab silma peal ka OlyBetis toimuval WSOP Online'il. Aga live-pokker on siiski netimängudest tähtsam, sest ega WSOP Circuit'i toimumine Tallinnas pole ju midagi igapäevast.
Alles on 113 mängijat, kahjuks on päris palju langejaid taas ka eestlaste seast. Nende seas on paraku ka tänavune komeet Martti Keel.
Player
Chips
Progress
Ranno Sootla
97,000
67,000
Kert Hallik
0
0
Vladimir Iljunin
0
0
Artur Külanurk
0
0
Aleksei Smirnov
0
0
Oskar Ojaveer
0
0
Mark Metsla
0
0
Maikel Homin
0
0
Eilne videokokkuvõte Posted Saturday 16th September, 2023 at 15:17(UTC+3) by maheaaatom
Algas teine tänane suurturniir Posted Saturday 16th September, 2023 at 15:08(UTC+3) by maheaaatom
Äsja läks kõrvalsaalis käima ka Ring Event #2 1100 € No Limit Holdem. See turniir on kahepäevane ning esimese 5 tunni jooksul (10 taset) võib teha tagasioste (re-entry) nii palju süda lustib või rahakott kannatab.
Turniir algas 18 mängijaga, laudades ka neli eestlast. Eesotsas äsja 555-selt välja langenud Igor Pihela vanema ning Rasmus Seppinguga.
Janarile kiire duubel Posted Saturday 16th September, 2023 at 15:03(UTC+3) by maheaaatom
Alles teisel päeval mänguga liitunud Janar Kokk saab kiire duubli Tallinnas sageli mängiva soomlase Juho Heiska vastu.
Janar juhib enne floppi vs. ) ning jääb ka peale. Nagu nipsti peaaegu keskmine stäkk käes!
Kahjuks on ka langejaid eesotsas vanema Pihelaga. Ja Rasmus Sepping, kes kulutas enda sõnul kolm bulletit ei saanud kahjuks oma mängu samuti käima.
Player
Chips
Progress
Janar Kokk
67,000
26,500
Magnus Pukk
0
0
Siim Suviste
0
0
Danel Kunman
0
0
Igor Pihela vanem
0
0
Rasmus Sepping
0
0
15:01 (UTC+3)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Raja jagub 47 parimale Posted Saturday 16th September, 2023 at 14:47(UTC+3) by maheaaatom
Turniiridirektori sõnutsi saab 183 360 € auhinnarahast osa 47 parimat mängijat.
Võitja saab 38510 €, viimane rahakoht täpselt tonni. Ja mõistagi ootab võitjat ka WSOP Circuit kuldne sõrmus ning pääse 2024. aasta juunis toimuvale WSOP Tournament of Champions'ile Las Vegases.
Suurte stäkkidega eestlased pausi ajal Posted Saturday 16th September, 2023 at 14:42(UTC+3) by maheaaatom
Risto Pärnat peaks olema väga napilt ka turniiri chipliider. Korraliku tõusu on teinud ka high-roller Urmo Velvelt.
Player
Chips
Progress
Risto Pärnat
247,000
107,000
Raivo Pinsel
160,000
59,000
Alexander Nemchin
159,000
102,500
Urmo Velvelt
157,000
67,500
Roland Luik
145,000
7,000
Dmitri Dudakov
138,000
14,000
Sami-Sander Kivi
113,000
83,000
Lõplikult väljalangenud Eesti mängijad Posted Saturday 16th September, 2023 at 14:38(UTC+3) by maheaaatom
Player
Chips
Progress
Tanel Merida
0
0
Kaur Ajamaa
0
0
Mart Rinken
0
0
Kaupo Tenno
0
0
Erki Evert
0
0
Tanel Evert
0
0
Raimo Reimann
0
0
Marten Oks
0
0
Mario Jürgens
0
0
Late reg. läbi, mäng jätkub Posted Saturday 16th September, 2023 at 14:34(UTC+3) by maheaaatom
Hiline registeerumine on lõppenud, lauas on 159 mängijat. Hetkeseisuga mängime 183 360 eurole, kuid see pole veel lõplik info.
Ülihiliste registeerujate hulgas on ka Ranno Sootla - ainus mees Eestis, kel ka WSOP käevõru kodus šeifis olemas.
14:32 (UTC+3)
Start of Level 13 Blinds: 1,000/2,500 Ante: 2,500
Mängijad asuvad end pausile sättima Posted Saturday 16th September, 2023 at 14:08(UTC+3) by maheaaatom
Mõnes lauas on 3 viimast kätt juba lõppenud, mõnes aga veel käimas.
Fakt on see, et pärast seda kui kõikides laudades on mäng lõppenud, läheme 20-minutilisele pausile. Seega peaks turniir jätkuma umbes kell 13:30.
Raivo ei olegi enam liider Posted Saturday 16th September, 2023 at 13:58(UTC+3) by maheaaatom
Raivo Pinsel on teise päeva alguses umbes 50K ära andnud, enda sõnul mehel kahel korral paarid ei pidanud.
Aga kui selles midagi head näha, siis vähemalt on Raivo nupud läinud omadele meestele. Veel viis minutit 12. taseme lõpuni, mis tähendab seda, et mängitakse veel kolm viimast kätt.
Juba 35 langejat Posted Saturday 16th September, 2023 at 13:54(UTC+3) by maheaaatom
Tänane päev on juba (!) lõppenud 35 mängijale. Tõsi, osad neist on siiski teinud re-entry.
Langenud on ka mitmeid eestlasi, kuid me ei hakka nende nimesid veel eraldi kirja panema. Juba umbes poole tunni pärast peaks olema selge, kes jätkab ja kes mitte.
Maikel veel ootab oma kohta Posted Saturday 16th September, 2023 at 13:49(UTC+3) by maheaaatom
"Tiitlikaitsja" Maikel Homin on nagu mainitud, mängus üsna väikese stäkiga. Sisuliselt on tal push-fold mäng, sest lauas ei juhtu vist ühtegi jaotust, kus keegi teine ei lükkaks.
Samas lauas andis just duubli turniiri ainsana Venemaa lipu all võistlev Aleksander Klochkov. Mees istus BB-l ning callis oma ässadega suurima heameelega laua keskelt tulnud lüket -ga. Flop oli aga juba üsna kurjakuulutav ning riveriga sai duublit jahtinud mees küll mitte rea, aga võiduks piisava poiste kolmiku.
Risto sai korraliku chiplisa Posted Saturday 16th September, 2023 at 13:42(UTC+3) by maheaaatom
Risto Pärnati ning Eestis elava "Mirza" stäkid läksid sisse pärast lauas avatud .
"Mirza"-l olid poisid, Ristol emandad. Ja emandad jäid peale ka pärast riverit.
Player
Chips
Progress
Risto Pärnat
140,000
85,500
Täna mängitakse kuni finaallauani Posted Saturday 16th September, 2023 at 13:38(UTC+3) by maheaaatom
Esialgse plaani kohaselt peaks tänane mäng kestma kuni finaallauani. Kuigi saalis on ligi 200 mängijat, tuleb siiski arvestada sellega, et mäng on suhteliselt kiire.
Suvel alustas teist päeva 259 mängijat ning 13 tunniga jõuti 14 parimani. Praegu on aga mängijaid siiski vähem ning mängutasemed vältavad Summer Showdown'i 40 minuti asemel 30 minutit. Seega julgeks küll prognoosida, et südaööks on meil finalistide nimed teada.
13:32 (UTC+3)
Start of Level 12 Blinds: 1,000/2,000 Ante: 2,000
WSOP Circuit või Summer Showdown? Posted Saturday 16th September, 2023 at 13:32(UTC+3) by maheaaatom
Hoolimata teise päeva aktiivsest algusest on selge, et juulikuise Summer Showdown'i rekordit see turniir ei purusta. Hetkel on sisseoste 349, suvel saadi aga kokku koguni 573.
Suvine 555 € NLH Championship oli ka selles mõttes meeldejääv, et võitjaks tituleeriti meie oma mees Maikel Homin. Maikel on ka täna mängus ning alustas teist päeva 38 500 punktiga.
Tanel Evert kaotas kuulsale jaapanlasele Posted Saturday 16th September, 2023 at 13:30(UTC+3) by maheaaatom
Haapsalu pokkerihai Tanel Evert kaotas lõviosa oma 30K+ stäkist nimekale jaapanlasele Ken Okadale -ga vastu. Allesjäänud väheste nuppudega ei õnnestunud mängu tagasi tulla. Noh, re-entry on siiski veel võimalik...
Ka Roland on vahepeal natuke ära andnud, kuid selle ka samas peagi tagasi saanud. "Raske laud, siin on mitmeid suuri stäkke," kommenteerib Roland.
Aga milleks üldse see esimene päev? Posted Saturday 16th September, 2023 at 13:23(UTC+3) by maheaaatom
Turniirialale saabus just Eesti läbi aegade edukaim pokkerimängija Markku Koplimaa, kes avapäevade peale aega ei kulutanud. 20XBB on täpselt see, millega täna alustada.
Uute lisandujate seas on ka näiteks tuntud Eesti naismängija Monika L., Erki Evert, EMV põhiturniiri teine Taago Tamm ja teisigi.
Mängija on laudades ja action alanud Posted Saturday 16th September, 2023 at 13:09(UTC+3) by maheaaatom
170 allesjäänud mängijat ning 12 uut tulijat on kohad laudades sisse võtnud ning kaardid õhus.
Meid ootab 60 minutit toorest nupulükkamist, mis väga midagi ei muuda. Kell 13:15 on re-entry periood läbi ning enam sihitult gämmelda ei saa.
555 € Ring Event #1 teine päev algab kell 12:00 Posted Saturday 16th September, 2023 at 11:19(UTC+3) by maheaaatom
WSOP Circuit Tallinn 2023 avaturniiri, 555 € No Limit Holdem Ring Event #1, teine päev algab laupäeval kell 12:00. Täna peate leppima veel live-blogiga, kuid alates homsest saab jälgida turniiri ka läbi TV-ülekande.
Mängu avapäevadel tehti kokku 320 sisseostu, edasi pääses 170 mängijat. Nende seas on ka 49 eestlast, kogu turniiri liidriohje hoiab Raivo Pinsel 219 000 punktiga. Korralikus seisus on ka viiendat kohta jagavad Dmitri Dudakov ja Roland Luik.
Turniiriga saab liituda kuni 12. mängutaseme lõpuni ehk umbes kuni kell 13:15-ni.
11:15 (UTC+3)
Day 2 of WSOPC Tallinn Started Level: 11 Blinds: 1,000/1,500 Ante: 1,500
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.