0.0004 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0069 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/2/updates'
ORDER BY `views` DESC
0.0102 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-11-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/2/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0004 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.0006 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.0003 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0033 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'WSOPCTallinn2023-MainEvent-Est'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
0.0280 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` = '122'
AND `published` = 1
0.0276 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0057 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '126'
AND `published` = 1
0.0366 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0073 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '128'
AND `published` = 1
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0059 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '131'
AND `published` = 1
0.0288 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` = '133'
AND `published` = 1
0.0288 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0061 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '137'
AND `published` = 1
0.0286 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0060 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '140'
AND `published` = 1
0.0005 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '40'
AND `name` = '2'
0.0071 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '133'
ORDER BY `busted` ASC, `current_chips` DESC
0.0072 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` = '133'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5798'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5796'
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` = '5795'
ORDER BY `chip_change` DESC, `busted` ASC
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` = '5794'
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` = '5790'
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` = '5785'
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` = '5782'
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` = '5781'
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` = '5780'
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` = '5777'
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` = '5776'
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` = '5774'
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` = '5771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5770'
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` = '5769'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5768'
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` = '5766'
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` = '5761'
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` = '5759'
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` = '5757'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5756'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5755'
ORDER BY `chip_change` DESC, `busted` ASC
0.0080 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5751'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5750'
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` = '5748'
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` = '5745'
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` = '5744'
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` = '5740'
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` = '5737'
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` = '5736'
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` = '5734'
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` = '5732'
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` = '5729'
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` = '5727'
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` = '5721'
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` = '5718'
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` = '5716'
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` = '5715'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5713'
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` = '5709'
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` = '5707'
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` = '5706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0115 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5705'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5702'
ORDER BY `chip_change` DESC, `busted` ASC
0.0130 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5700'
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` = '5708'
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` = '5698'
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` = '5697'
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` = '5694'
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` = '5692'
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` = '5690'
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` = '5686'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5683'
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` = '5682'
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` = '5681'
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` = '5679'
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` = '5678'
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` = '5674'
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` = '5673'
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` = '5672'
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` = '5669'
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` = '5667'
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` = '5666'
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` = '5665'
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` = '5663'
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` = '5662'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5660'
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` = '5659'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '133'
ORDER BY `busted` ASC, `current_chips` DESC
0.0057 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` = '133'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '5798'
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` = '5796'
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` = '5795'
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` = '5794'
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` = '5790'
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` = '5785'
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` = '5782'
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` = '5781'
ORDER BY `chip_change` DESC, `busted` ASC
0.0126 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5780'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5777'
ORDER BY `chip_change` DESC, `busted` ASC
0.0104 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5776'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5774'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5769'
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` = '5768'
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` = '5766'
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` = '5761'
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` = '5759'
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` = '5757'
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` = '5756'
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` = '5755'
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` = '5751'
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` = '5750'
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` = '5748'
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` = '5745'
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` = '5744'
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` = '5740'
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` = '5737'
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` = '5736'
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` = '5734'
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` = '5732'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5727'
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` = '5721'
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` = '5718'
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` = '5716'
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` = '5715'
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` = '5713'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5709'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5707'
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` = '5706'
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` = '5705'
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` = '5702'
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` = '5700'
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` = '5708'
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` = '5698'
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` = '5697'
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` = '5694'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5692'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5690'
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` = '5686'
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` = '5683'
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` = '5682'
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` = '5681'
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` = '5679'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5678'
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` = '5674'
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` = '5673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5672'
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` = '5669'
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` = '5667'
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` = '5666'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5665'
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` = '5663'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5662'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5660'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5659'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '140'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2143
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Teise päeva lõplik chipcount (kohad 1-30) Posted Friday 22nd September, 2023 at 21:10(UTC+2) by maheaaatom
Teise päeva lõpp oli eestlastele lausa uskumatult halb, sest 25-st rahadesse tulnud mängijast 13 langes pärast mulli mängust välja ning piirdus min-cashiga.
Samas pole muretsemiseks väga põhjust. 60 parima seas on endiselt 12 meie meest, seejuures on Hendrik Uibo veel võimas chipliider.
Sellega meie ülekanne tänaseks lõppeb, läbi TV-ülekande saate veel elada kaasa 660 € PLO Hi-Lo sõrmuseturniirile, kus tehtud 127 sisseostu (hetkel mängus 47 parimat). Ja kindlasti ärge unustage OlyBetis toimuvat 350 € NLH sõrmuseturniiri, mille hiline regamine kestab kuni kell 23:00-ni.
Player
Chips
Progress
Hendrik Uibo
1,765,000
500,000
Akseli Paalanen
1,300,000
1,250,000
Marko Härkonen
1,205,000
1,155,000
Luca Beretta
1,155,000
1,105,000
Vu Vuong
1,135,000
1,085,000
Jesus Martinez
1,100,000
1,050,000
Artur Külanurk
1,085,000
896,000
Seppo Parkkinen
1,015,000
0
Mario Linno
980,000
710,000
Jon Martinez
915,000
865,000
Bartlomiej Kijak
910,000
860,000
Skommar Hansson
885,000
835,000
Allan Isberg
880,000
830,000
Maruen Zormati
865,000
815,000
Emanuele Mari
795,000
0
Pekka Ikonen
780,000
730,000
Atush Esker
780,000
730,000
Jari Juhola
655,000
605,000
Garrido Gonzalez
650,000
600,000
Andzej Zinkevic
640,000
590,000
Tomasz Mroz
605,000
555,000
Stanislavas Macugins
595,000
545,000
Maciej Komorowski
595,000
545,000
David Asqino
585,000
535,000
Aleksandr Arutjunov
565,000
35,000
Emil Hovmark
555,000
505,000
Urmo Velvelt
535,000
15,000
Andrius Bielskis
505,000
455,000
Henri Antikainen
505,000
340,000
Alger Pissarev
490,000
418,500
Teise päeva lõplik chipcount (kohad 31-60) Posted Friday 22nd September, 2023 at 20:54(UTC+2) by maheaaatom
Edit: Üks parandus - Karl Relander väitis, et tema stäkk polnud mitte 135 000, vaid 735 000. Ju paistis "7" koti peal rohkem "1" moodi välja.
Player
Chips
Progress
Karl Relander
735,000
600,000
Jimi Kopnen
480,000
430,000
Deividas Butnoras
470,000
420,000
Adrians Imsa
465,000
415,000
Tornike Tchitadze
455,000
405,000
Mairo Tori
450,000
110,000
Jun Chun
445,000
395,000
Ermo Kosk
430,000
230,000
Remigijus Dzerva
410,000
360,000
Rudolf Rotko
405,000
355,000
Gilles Rene Simon
405,000
193,500
Hannes Praks
400,000
0
Anna-Mari Hursti
395,000
345,000
Aigars Taukacs
385,000
335,000
Kris Tikka
380,000
330,000
Joni Rantamäki
375,000
103,000
Jose Larios
355,000
305,000
Steponas Venckus
350,000
300,000
Samuel Richards
340,000
290,000
Toms Civcs
330,000
280,000
Juho Suutari
320,000
270,000
Kasper Mellanen
315,000
265,000
Igor Yaroshevskyy
315,000
265,000
Sebastian Wahl
305,000
255,000
Kevin Karenius
280,000
230,000
Youngseo Yoon
220,000
170,000
Martin Piik
215,000
45,000
Adria Comas
210,000
160,000
Amanullah Tahiri
175,000
125,000
Antti Eeva
140,000
90,000
Karl Relander
135,000
165,000
65. koht Andrey Koks, 64. koht Tarmo Tammel, 62. koht Rasmus Sepping, 61. koht Mauri Dorbek - kõik 3300 € Posted Friday 22nd September, 2023 at 20:31(UTC+2) by maheaaatom
Andreyl oli vahepeal väga hea seis, kuid teise päev lõpp läks kehvasti. Rasmus Sepping võib aga cashiga täiesti rahul olla, sest mullimängu eel polnud tema seis kaugeltki kiita.
Koos sellega on tänane mängupäev ka läbi ning mängijad pakivad chippe. Peagi avaldame kõikide allesjäänute täpsed stäkid.
Player
Chips
Progress
Andrey Koks
0
0
Tarmo Tammel
0
0
Rasmus Sepping
0
0
Kellelgi läheb ikka hästi ka! Posted Friday 22nd September, 2023 at 20:25(UTC+2) by maheaaatom
Mario Linna hõõrub käsi ja ütleb, et viimane tase on olnud hullumeelne. Ja hullumeelselt hea.
Esmalt duubel -ga pärast floppi , vastas mastitõmbega
Teisel läks natuke hõlpsamalt - vs.
71. koht Mark Metsla, 67. koht Priit Vallap, 66. koht Kert Hallik - kõik 3300 € Posted Friday 22nd September, 2023 at 20:19(UTC+2) by maheaaatom
Kerdil, Priidul ja ja Margil õnnestub esimene money-jump üle elada ning teenida 250 eurot ekstrat.
Kui esimesel kahel olidki väiksed stäkid, siis Kerdil kiskus lõpp lihtsalt täiesti viltu. Kogu 770K stäkk läks paari käega ning Kert oli väga nukra olemisega.
Player
Chips
Progress
Priit Hallap
0
0
Kert Hallik
0
0
Mark Metsla
0
0
80. koht Sergei Aleksejev, 79. koht Herli Olop, 77. koht Steven Seller, 74. koht Priit Parmasto, 73. koht Keito Kaljulaid, 72. koht Egon Kaljulaid - kõik 3050 € Posted Friday 22nd September, 2023 at 20:04(UTC+2) by maheaaatom
Nagu arvata oli, hakkas kohe ka juhtuma.
Shortstackiga Herli näiteks langes blindide lahingus -ga BB vastu.
Juba 19 langejat umbes 20 minutiga. Crazy. Aga raha on raha!
Player
Chips
Progress
Priit Parmasto
0
0
Keito Kaljulaid
0
0
Herli Olop
0
0
Steven Seller
0
0
Sergei Aleksejev
0
0
Egon Kaljulaid
0
0
Tähelepanu TV-lauale Posted Friday 22nd September, 2023 at 19:50(UTC+2) by maheaaatom
Telelauas toimuv peaks eestlastele palju huvi pakkuma, sest seal on nii turniiri üldliider Hendrik Uibo kui tuntud ässad Mauri Dorbek ja Martin Piik.
Mull on lõhkenud, algas viimane tase Posted Friday 22nd September, 2023 at 19:48(UTC+2) by maheaaatom
Mullimeheks jäi Läti pokkerihai Kaspars Renga ning kõik allesjäänud 87 mängijat on endale juba taganud vähemalt 3050-eurose cashi.
Ühtlasi algas päeva viimane tase (algselt pidi olema 11 taset, kuid selleks, et mängijad jõuaksid kell 20:00 algavale OlyBeti online-sõrmuseturniirile, otsustati üks tase maha võtta).
Eeldatavalt langeb järgmise 40 minuti jooksul mängust vähemalt 15 osalejat. Shortstäkke on palju ning mingit mõtet enam tiksuda pole.
19:45 (UTC+2)
Start of Level 20 Blinds: 10,000/20,000 Ante: 20,000
Kolm katset - mull pole veel lõhkenud Posted Friday 22nd September, 2023 at 19:30(UTC+2) by maheaaatom
Kolmel korral on mäng peatatud (all-in and call), kuid kõikidel kordadel on väiksem stäkk duublisse saanud. On olnud kaks flippi, ühel korral oli all-in mängija selgelt ees.
Kas WSOP-C naaseb Tallinnasse? Mida arvab Olympic Casino CEO Corey Plummer? Posted Friday 22nd September, 2023 at 19:26(UTC+2) by maheaaatom
Väikeste stäkkidega eestlasi Posted Friday 22nd September, 2023 at 19:19(UTC+2) by maheaaatom
Kõik nad peavad palvetama, et mull võimalikult kiirelt läbi saaks ning just nemad tule alla ei jääks.
Player
Chips
Progress
Hannes Praks
400,000
200,500
Mairo Tori
340,000
10,000
Karl Relander
300,000
185,000
Mario Linno
270,000
173,000
Rasmus Sepping
220,000
185,500
Priit Parmasto
205,000
145,000
Mark Metsla
180,000
20,000
Sergei Aleksejev
150,000
109,500
Priit Vallap
130,000
20,500
Eestlaste stäkke mullimängu ajal Posted Friday 22nd September, 2023 at 19:09(UTC+2) by maheaaatom
Player
Chips
Progress
Kert Hallik
740,000
270,000
Andrey Koks
600,000
50,000
Aleksandr Arutjunov
600,000
50,000
Urmo Velvelt
550,000
200,000
Steven Seller
200,000
160,000
Ermo Kosk
200,000
220,000
Keito Kaljulaid
50,000
200,000
Keito on ohutsoonis Posted Friday 22nd September, 2023 at 19:07(UTC+2) by maheaaatom
Keitol on umbes 50K stäkk (natuke üle 3XBB), kuid tema õnneks on blindid temast kohe üle minemas (Keito on järgmises jaotuses buttonil). Aga suure saali mängijatest on see siiski kõige väiksem.
Mullimäng on alanud Posted Friday 22nd September, 2023 at 18:56(UTC+2) by maheaaatom
Veel mõned langejad, kelle seas ka nimekas Soome superäss Juha Helppi ning me olemegi jõudnud hand-by-hand mängu ehk mullini.
Kes langes, on kõigest ilma. Kõik, kes mulli üle elavad, teenivad vähemalt 3050 eurot.
Player
Chips
Progress
Juha Helppi
0
0
Algas viimane teise päeva mängutsükkel Posted Friday 22nd September, 2023 at 18:55(UTC+2) by maheaaatom
Laudades on 90 mängijat ning me oleme mullist kõigest kolme koha kaugusel. On üsna kindel, et päeva lõpuks on see ka lõhkenud.
Hiiglasik 1,265M stäkiga on turniiri liider Hendrik Uibo. Välja on aga langenud Mauro-Mark Musting ning juba mõnda aega tagasi said telelauas otsa ka Igor Pihela vanema kannatused (suurema osa oma stäkist - nagu juba mainitud sai - kaotas ka kuningatega ässadele).
Herli on natuke hingamisruumi juurde saanud - tal hetkel 370K.
Player
Chips
Progress
Hendrik Uibo
1,265,000
1,116,000
Mauro-Mark Musting
0
0
Igor Pihela vanem
0
0
18:50 (UTC+2)
Start of Level 19 Blinds: 10,000/15,000 Ante: 15,000
Mauril saab äss-kõrgega suure panga Posted Friday 22nd September, 2023 at 18:29(UTC+2) by maheaaatom
Mauri Dorbek ja Urmo Velvelt vaatavad 30K-ga floppi . Urmo panustab ette 55K ja saab Maurilt calli.
Turn on , Urmo jätkab 75K-ga ja Mauri callib taas.
Riveri järel Urmo enam panust ei tee. Ja ka Mauri ei julge panustama minna, vaid checkib riveri läbi.
Mauri avab esimesena - - ebaõnnestunud reatõmme, äss-kõrge. Aga Mauri õnneks pole Urmol sedagi (kaarte ta ei näita).
Selle käe järel algas ka tänane viimane 20-minutiline paus.
Bounty-turniir on hästi vastu võetud Posted Friday 22nd September, 2023 at 18:17(UTC+2) by maheaaatom
Kell 17:00 alanud 1100 € NLH Bounty on juba köitnud pea 50 mängija tähelepanu, 3000 € turniiri satelliidi osalejate arv on aga juba üle saja. Ka Hi-Lo sõrmuseturniiril saadakse tõenäoliselt juba lühiajal 100 sisseostu kokku.
Põhiturniiril sees 95 mängijat, neist 25 eestlast.
Tähelepanu online-mängijatele: Kell 18:00 algas OlyBetis õhtuse Ring Event #10 megasatelliit, 25 piletit GTD. Hetkel tehtud kõigest 41 sisseostu (75 €), siit võib tulla overlay. WCOOP Tallinn online-turniir ise algab kell 20:00 ning auhinnagarantii on korralik 50K$.
Martin hoiab oma stäkist küünte ja hammastega kinni Posted Friday 22nd September, 2023 at 18:09(UTC+2) by maheaaatom
Martin Piik langes vahepeal juba 7XBB peale (86 000), kuid suutis siiski vajalikul hetkel nupud sisse saada ning duubeldada.
Martin:
Vastas:
Kumbki lauale pihta ei saanud, kicker mängis.
Player
Chips
Progress
Martin Piik
170,000
30,000
Telelaud õnne ei toonud Posted Friday 22nd September, 2023 at 18:03(UTC+2) by maheaaatom
Telelauda saate jälgida 30-minutilise viivitusega, kuid neile, kes seda ei tee, paneme kiirelt kirja ka vahepealsed sündmused.
Kahjuks midagi head kirjutada ei ole. Igor Pihela vanem jooksis kuningatega ässade otsa, sinna läks väga suur osa stäkist (Igor siiski veel mängus).
Ranno Sootlale ei sujunud ka asjad kohe kuidagi, viimased stäkiriismed (6XBB) läksid -ga soomlase Salmela vastu. Flopis kohe kaks kümmet...
Player
Chips
Progress
Ranno Sootla
0
0
Urmol 750K! Posted Friday 22nd September, 2023 at 17:59(UTC+2) by maheaaatom
Urmo on eestlastest selgelt suurim, kuid häid stäkke on teistelgi. Võrdluseks - keskmine on hetkel 366K.
Player
Chips
Progress
Urmo Velvelt
750,000
350,000
Aleksandr Arutjunov
550,000
320,000
Andrey Koks
550,000
150,000
Kert Hallik
470,000
400,000
Ermo Kosk
420,000
190,000
Mauri Dorbek
400,000
50,000
Priit Parmasto
350,000
240,000
Mairo Tori
350,000
230,000
Keito Kaljulaid
250,000
209,500
Mark Metsla
200,000
100,000
17:47 (UTC+2)
Start of Level 18 Blinds: 6,000/12,000 Ante: 12,000
Tempo on langenud Posted Friday 22nd September, 2023 at 17:47(UTC+2) by maheaaatom
Päris pisikesi stäkk (alla 100K ehk alla 10xBB) väga ei ole, seetõttu on ka mäng muutunud märksa aeglasemaks.
Meie arvestuse järgi peaks turniiri jätkama 26 eestlast ehk iga umbes neljas mängija.
Läheneme sajale Posted Friday 22nd September, 2023 at 17:29(UTC+2) by maheaaatom
Laudades on veel 103 mängijat ning kõik märgid viitavad sellele, et mull pole enam üldse kaugel. Vaid 17 õnnetut jäävad tühjade kätega.
Nende nimistu, kes sellele rahale enam ei pretendeeri, on täienenud kahjuks veel mitmete nimedega.
Player
Chips
Progress
Madis Ormisson
0
0
Richard Koppel
0
0
Maikel Homin
0
0
Gert Laanemets
0
0
Maksim Petrov
0
0
Põnevat statistikat Posted Friday 22nd September, 2023 at 17:15(UTC+2) by maheaaatom
Täname taas Olympic Casino floori põneva statistika eest.
Turniirile tehti 719 sisseostu, unikaalseid mängijaid oli 539. Leidus kolm mängijat, kes ei pidanud paljuks koguni kuute sisseostu!
Erinevaid eestlasi on 126, soomlasi 141. Re-entry'sid tegid aga põhjanaabrid märksa enam. Keskmiselt kulutas üks eestlane turniirile 1,43 sisseostu, keskmine soomlane aga 1,61 sisseostu.
Ühesõnaga - ärge öelge, et eestlastel raha pole. Kes oleks võinud 10 aasta tagasi eeldada, et 1500 € sisseostuga turniiril osaleb 126 eestlast!
17:10 (UTC+2)
Start of Level 17 Blinds: 5,000/10,000 Ante: 10,000
Turniiri võitja saab 211 500 eurot Posted Friday 22nd September, 2023 at 16:59(UTC+2) by maheaaatom
Äsja avaldati turniiri auhinnarahade jagunemine.
Kui jõuad rahadesse, siis saad vähemalt 3050 eurot, koht finaallauas (9 parima hulgas) tagab juba vähemalt 17 700 eurot. Kui tuled aga võitjaks, ootab sind 211 500 eurot, WSOP Circuit kuldsõrmus ning mõistagi ka pääse WSOP Tournament of Champions'ile Las Vegases.
Veel langejaid Posted Friday 22nd September, 2023 at 16:57(UTC+2) by maheaaatom
Meie omadest on väljas ka Eedi Kirves, Hendry Kullamäe ning mullune EMV põhiturniiri tšempion Magnus Pukk.
Player
Chips
Progress
Hendry Kullamäe
0
0
Magnus Pukk
0
0
Eedi Kirves
0
0
Noorema Igori mäng lõppeb riveril Posted Friday 22nd September, 2023 at 16:55(UTC+2) by maheaaatom
Igor Pihela nooremal polnud küll teab mis suur stäkk, kuid ikkagi jäi ta sellest üsna inetult ilma - vs. , river äss.
Martin Piik ja Andrey Koks mängisid vahepeal suure panga, mille võitis viimane. Andreyl nüüd 400K, Martinil 200K.
Jätkab 120 parimat.
Player
Chips
Progress
Andrey Koks
400,000
250,000
Martin Piik
200,000
130,000
Igor Pihela noorem
0
0
Valik eestlaste stäkke Posted Friday 22nd September, 2023 at 16:46(UTC+2) by maheaaatom
Tublisti on kaotanud Igor Pihela noorem, seevastu on täna väga hästi (ja pidevalt) tõusnud Steven Seller ja Maikel Homin. Niisamuti ka Mauri Dorbek, Martin Piigist rääkimata.
Player
Chips
Progress
Urmo Velvelt
400,000
135,000
Maikel Homin
400,000
100,000
Steven Seller
360,000
342,500
Mauri Dorbek
350,000
100,000
Martin Piik
330,000
70,000
Aleksandr Arutjunov
230,000
108,000
Ermo Kosk
230,000
30,000
Tarmo Tammel
220,000
104,000
Igor Pihela noorem
140,000
210,000
Oskar tõmbab koti selga Posted Friday 22nd September, 2023 at 16:40(UTC+2) by maheaaatom
Täna ei olnud selgelt tema päev - sisuliselt läks kõik allamäge. Samuti on väljas Ruslan Stserbjuk ning kahjuks ka Aleksei Smirnov.
Player
Chips
Progress
Aleksei Smirnov
0
0
Oskar Ojaveer
0
0
Ruslan Stserbjuk
0
0
Mis mujal teoksil? Posted Friday 22nd September, 2023 at 16:33(UTC+2) by maheaaatom
PLO Hi-Lo sõrmuseturniiril on tehtud 65 sisseostu ning auhinnafond jätkab paisumist. Aega liitumiseks on umbes kuni kella seitsmeni õhtul.
3K satelliit kulgeb ka edukalt, juba 78 sisseostu kirjas.
Peagi (kell 17:00) on algamas veel üks väga põnev turniir : 1 100 € NLH, kus mängus 400-eurosed progressiivsed pearahad.
16:27 (UTC+2)
Start of Level 16 Blinds: 4,000/8,000 Ante: 8,000
Raha saab 87 parimat Posted Friday 22nd September, 2023 at 16:05(UTC+2) by maheaaatom
Just anti teada, et põhiturniiril saab raha 87 parimat. Kuna hetkel on mängus 144 pokkerisportlast, siis see tähendab, et väga suure tõenäosusega lõhkeb mull täna (pärast kohe algavat pausi on veel mängida kuus taset ehk 240 minutit puhast mänguaega). Kuidas auhinnaraha täpselt jaguneb, saame teada lühikese aja pärast.
Mõned eestlased on ka vahepeal välja langenud, sh. viimane mängus olnud Eesti naine Hanna Heinlo.
Player
Chips
Progress
Arko Akenpärg
0
0
Hanna Heinlo
0
0
Andreas Kaju
0
0
Priit Oja
0
0
Madis siin blufib ainult! Posted Friday 22nd September, 2023 at 15:56(UTC+2) by maheaaatom
Nii ütleb Mauri Dorbek (ja täpsustab, et blufib küll hästi, kuid vahel pingutab ka üle), kes jagab lauda vanameister Madis Ormissoniga ning sai läbi Madise ka duubli.
Mõlemad mehed alustasid täna algstäkiga ning mõlemal on umbes 250K ehk viis korda rohkem. Hetkel võrdub see keskmise punktisummaga.
Player
Chips
Progress
Maikel Homin
300,000
150,000
Gert Laanemets
250,000
159,000
Mauri Dorbek
250,000
140,500
Madis Ormisson
250,000
125,000
Martin on lõpuks õige rütmi leidnud Posted Friday 22nd September, 2023 at 15:46(UTC+2) by maheaaatom
Martin Piik on lõpuks oma mängu käima saanud ning tõusnud juba umbes 400K peale. Urmo on natuke ära andnud, kuid endiselt heas seisus.
151 parimat on alles, fuajee on laudadest puhas. Hetkel keskmine stäkk 238 079.
Player
Chips
Progress
Martin Piik
400,000
160,000
Igor Pihela vanem
300,000
40,000
Urmo Velvelt
265,000
105,000
Ermo Kosk
260,000
107,500
Aleksei Smirnov
230,000
50,000
Magnus Pukk
160,000
66,500
Andrey Koks
150,000
23,000
Mairo Tori
120,000
62,500
Mark Metsla
100,000
81,500
Herli ootab paremat võimalust Posted Friday 22nd September, 2023 at 15:39(UTC+2) by maheaaatom
Flopis on , pangas umbes 100K ning heads-up'is Herli ja Andrius Bielskis.
Herli checkib, leedulane paneb 30K ning saab calli.
Turn checkitakse läbi, riveri järel checkib Herli taas ette. Bielskis teatab seejärel, et on all-in.
Herli mõtleb 3-4 minutit, veeretab oma stäkki (umbes 160K järgi, leedulasele jääb see alla) ning otsustab siis, et ei hakka ikka oma turniirieluga riskima. Loodetavasti pakuvad järgmised jaotused paremaid kohti.
Risto ja Marek mängust väljas Posted Friday 22nd September, 2023 at 15:26(UTC+2) by maheaaatom
Marekit võis näha juba mõned minutid tagasi saalist välja jalutamas. Kahjuks polnud ta ainus eestlane, ka Risto Pärnati mäng on saanud läbi. Jätkab 165 parimat.
Player
Chips
Progress
Marek Selgeveer
0
0
Risto Pärnat
0
0
15:20 (UTC+2)
Start of Level 15 Blinds: 3,000/6,000 Ante: 6,000
Algas 3000 € turniiri satelliit Posted Friday 22nd September, 2023 at 15:20(UTC+2) by maheaaatom
Kell 15:00 alanud tänane 3000 € 6-max'i satelliit on väga edukalt käima läinud, sest põhiturniirilt on langenud välja hulk mängijaid ning neil, keda PLO Hi-Lo või rahamängud ei huvita, polegi nagu midagi muud teha.
Hetkel tehtud juba 33 sisseostu kirjas. 3000-eurose pileti saab vähemalt kolm mängijat.
Fuajee tühjeneb Posted Friday 22nd September, 2023 at 15:17(UTC+2) by maheaaatom
Oleme jõudnud 177 parimani ning peagi toimub kogu põhiturniir täielikult suures saalis.
Oleme kaotanud vahepeal Janek Tammsaare ning ka Markku Koplimaa. Soomlased jäid ilma veel ühest väga nimekast vanameistrist, Aki Pyysingust.
Player
Chips
Progress
Janek Tammsaar
0
0
Markku Koplimaa
0
0
Turn päästab Arutjunovi Posted Friday 22nd September, 2023 at 15:05(UTC+2) by maheaaatom
Pokkeriveteran Aleksandr Arutjunov suudab oma ca. 60K stäki duublisse saada. Nupud lähevad sisse küll äärmiselt ebasoodsas olukorras ( vs. ), kuid kolmekordse Eesti meistri õnneks on turnis kuningas.
Arutjunov on samas lauas Ranno Sootlaga, kohe nende taga istub Oskar Ojaveer. Oskar on umbes poole oma stäkist "maha gämmelnud" ning saab kohe Rannolt pahandada, et "ise veel pereinimene ja gämbleb".
Oskaril umbes 100K järgi.
Player
Chips
Progress
Aleksandr Arutjunov
122,000
23,000
Oskar Ojaveer
100,000
127,500
Juba alla 200 Posted Friday 22nd September, 2023 at 14:55(UTC+2) by maheaaatom
Mängijaid kukub robinal ning paistab, et varsti saamegi fuajee tühjaks. Eestlaste read on hõrenenud viie mängija võrra, kelle seas ka alles täna põhiturniiriga liitunud Eesti Pokkeri Kuulsuste Halli liige Henri Käsper, kelle me leiame aga juba PLO Hi-Lo osalejate nimekirjast.
Välismängijatest on väljas on värvikas Kanada pokkerisportlane Kelly Kellner. Viimane suutis vahepeal tõusta üle poole miljoni, kuid kinkis siis oma hiidstäki Emil Hovmarkile, kes on hetkel ka turniiri kindel liider umbes miljoni punktiga. Jaotus oli muiudgi karm - riveriks lauas ning juba väga palju raha keskel. Kelly () all-in panus calliti ära mastiga ().
Player
Chips
Progress
Emil Hovmark
1,000,000
950,000
Oliver Kullman
0
0
Henri Käsper
0
0
Pavel Solodovnikov
0
0
Rikard Relander
0
0
Silver Simulask
0
0
Kelly Kellner
0
0
Sahamiehe skalp läks Herlile Posted Friday 22nd September, 2023 at 14:43(UTC+2) by maheaaatom
Herli kiitleb, et just temal õnnestus 13. taseme alguses hirmkuulus Soome pokkeriäss Ilari Sahamies välja võtta.
Sahamies oli SB-lt shovenud -ga, Herli callis BB-lt -ga.
Ideaalne olukord, kuid soomlasel õnnestus siiski Herlile natuke närvikõdi põhjustada. Flopis on kaheksa, turn annab ka reatõmbe. Õnneks Herli suurem käsi siiski peab ning tal 170K.
Player
Chips
Progress
Herli Olop
170,000
40,000
14:40 (UTC+2)
Start of Level 14 Blinds: 2,000/5,000 Ante: 5,000
Algas teleülekanne Posted Friday 22nd September, 2023 at 14:39(UTC+2) by maheaaatom
"Peamises" telelauas on eestlastest Eedi Kirves , n.ö. "teises telelauas" aga Tarmo Tammel. Viimane alustas seda muide väga korraliku 324K stäkiga (oli väga hea punktisummaga ka avapäeva järel).
Player
Chips
Progress
Tarmo Tammel
324,000
34,000
Valik eestlaste stäkke Posted Friday 22nd September, 2023 at 14:32(UTC+2) by maheaaatom
Kõige paremini paistab olevat Urmo Velveltil ja Igor Pihela nooremal, mõlemal üle 350K. Igor sai kätte ka suure osa Raivo Pinseli stäkist. Nii tema kui Priit arvasid, et Raivo mängis natuke võib-olla liiga uljalt ning see sai ka talle lõpus saatuslikuks.
Player
Chips
Progress
Urmo Velvelt
370,000
77,000
Igor Pihela noorem
350,000
140,000
Igor Pihela vanem
260,000
3,000
Martin Piik
240,000
158,000
Egon Kaljulaid
200,000
124,500
Aleksei Smirnov
180,000
24,500
Hanna Heinlo
160,000
91,500
Maikel Homin
150,000
106,000
Ranno Sootla
150,000
66,000
Herli Olop
130,000
20,000
Madis Ormisson
125,000
75,000
Marek Selgeveer
120,000
36,000
Priit Parmasto
110,000
6,000
28 mängijat Omaha Hi-Lo'l Posted Friday 22nd September, 2023 at 14:19(UTC+2) by maheaaatom
PLO Omaha Hi-Lo sõrmuseturniir läks käima, veerand tundi pärast algust on osalejaid 27. Eestlastest on sõrmusejahil Andres Abakanov, Ilya Nikiforov, Henrik Puija, Jaan Vaabel ning selle mängu tunnustatud ekspert Georgi Voomets.
Mäng jätkub, langejaid igal sekundil Posted Friday 22nd September, 2023 at 14:16(UTC+2) by maheaaatom
Algas 12. tase ning enam eksimisruumi ei ole. Kirjas on 719 sisseostu ning 257 mängijat on laudades.
"Seat Open!" kõlab päris sageli. Mõned minutid tagasi jalutas turniirialalt välja Raivo Pinsel, oli teine päris muserdatud olemisega, sest päeva alustas ta ju liidrite seas. Kahjuks tabas sama saatus Raivot ka 555 € avaturniiril.
Väljas on muide ka Soome pokkerikuulsus Sahamies.
Player
Chips
Progress
Antti Veerberk
0
0
Virgo Laansoo
0
0
Aleksandr Jelpidiforov
0
0
Dmitri Dudakov
0
0
Marko Vest
0
0
Steven Tool
0
0
Raido Tsmir
0
0
Kaupo Tenno
0
0
Rasmus Eino
0
0
Rauno Remmel
0
0
Aleksander Lammas
0
0
Ilya Nikiforov
0
0
Kristo Erala
0
0
Sten Talviste
0
0
Kalju Kratovitš
0
0
Danel Kunman
0
0
Baavo Pohlak
0
0
Kaido Kuusemäe
0
0
Kaido Mikk
0
0
Raivo Pinsel
0
0
14:04 (UTC+2)
Start of Level 13 Blinds: 2,000/4,000 Ante: 4,000
Mängijad hakkavad pausile suunduma Posted Friday 22nd September, 2023 at 13:37(UTC+2) by maheaaatom
Kui kõik jaotused on lõppenud, siis algab 20-minutiline paus. Neil, kel eriti väike stäkk, on lubatud soovi korral sellest loobuda ning alustada 50 000 punktiga (muidugi tuleb arvestada 1500 € lisakuluga).
Mäng jätkub umbes kell 14:00.
3 viimast kätt Posted Friday 22nd September, 2023 at 13:32(UTC+2) by maheaaatom
Diileritel palutakse välja jagada kolm viimast kätt. Kuna see on kõige viimane võimalus oma stäkile lisa saada, siis pole midagi imestada, et hõikeid "all-in" kostub üle saali.
Kings of Tallinn rekord on käeulatuses Posted Friday 22nd September, 2023 at 13:24(UTC+2) by maheaaatom
Kui Kings of Tallinn 2023 põhiturniiril tehti rekordilised 716 sisseostu, siis see tulemus on nüüd juba vägagi käeulatuses. Hetkeseisuga on sisseoste 708 ning veel seitse minutit on jäänud late reg. lõpuni.
Ülimalt suure tõenäosusega saab see rekord ületatud. Senine ajalugu on näidanud, et omajagu sisseoste tehakse päris viimadel hetkel ehk viimasel pausil.
Ranno Sootla võitis Bad beat Jackpoti väärilise käe! Posted Friday 22nd September, 2023 at 13:21(UTC+2) by maheaaatom
Blindide vaheline heitlus: Emanuele Mari tõstis SB-lt ning sai calli BB-lt istuvalt istuvalt Ranno Sootlalt.
Flopis avati , mille järel Emanuele checkis, Ranno tegi väikese panuse, Emanuele tõstis ta üle ja Ranno läks all-in.
Emanuele näitas flopanud mastirida (), Rannol oli lihtsalt mast ().
Turn on !!!
Alumisel korrusel oleks selle käe eest saanud suure osa juba 67 674 euroseks paisunud hiiglaslikust Bad Beat Jackpotist. Ülemisel korrusel tuleb leppida lihtsalt olulise stäkilisaga. Pank oli ligikaudu 200K.
OLULINE: Õhtune sõrmuseturniir OlyBetis kell 20:00 Posted Friday 22nd September, 2023 at 13:16(UTC+2) by maheaaatom
Täna kell 20:00 toimub selle festivali ainus online-turniir, kus on võimalik samuti saada nii meistrisõrmus kui pääse Las Vegases toimuvale tšempionite turniirile.
Turniir toimub OlyBetis (maailma suurim pokkerivõrgustik GGNetwork) ning sellel osalemine maksab 350 €. Alustatakse 10 000 punktiga (200xBB) ning mängutasemed vältavad 12 minutit. Need, kes registeeruvad enne viienda mängutaseme lõppu, saavad boonuschippe.
Täna saab sellele kvalifitseeruda ka läbi kolme online-satelliidi:
350-eurose pileti võitmiseks on kavas ka kaks flippi, vastavalt kell 19:57 ja 20:57. Flippamine maksab 55 eurot ning iga flopi võitja pääseb samuti sõrmuseturniirile.
Kas teate, kui palju inimesi tegeleb kaartide jagamisega? Posted Friday 22nd September, 2023 at 13:06(UTC+2) by maheaaatom
WSOP Circuit Tallinnal on ametis 174 kasiinotöötajat, kelle ülesandeks on turniiri ja rahamängude läbiviimine. Sinna kuuluvad nii kõik diilerid kui juhtkond (floor, turniiridirektorid).
On nii Olympic Casino enda töötajaid kui hulgaliselt mujalt appi palgatud töötajaid.
12:49 (UTC+2)
Start of Level 12 Blinds: 1,500/3,000 Ante: 3,000
PLO Hi-Lo sõbrad - olge valmis! Posted Friday 22nd September, 2023 at 12:49(UTC+2) by maheaaatom
Täna kell 14:00 algab 660 € PLO Hi/Lo, mis viiakse läbi ühe päevaga. Turniiri võitja saab WSOP Circuit meistrisõrmuse ning pileti Las Vegases toimuvale 1M$ tšempionite freerollile. Kes tahab koos Aleksei, Ranno ja Kauriga Ameerika-imedemaale sõita, hüpake paati. Kes ei mängi, see ei võida ;)
Herlile juba kaks kiiret duublit Posted Friday 22nd September, 2023 at 12:45(UTC+2) by maheaaatom
Herli Olop on saanud kaks kiiret duublit ning upitanud kõigest poole tunniga oma stäki juba 150K peale.
Herli mainis juba eile, et esimese päeva väike stäkk ei tähenda midagi, sest mängijaid on palju, teine päev algab arutu lahmimisega ning piisab ühest-kahest õnnestumisest, et vägagi mängus olla. Täpselt nii läks tal ka Summer Showdown põhiturniiril - mittemidagiütlev algus, kuid seejärel üsna korralik jooks ning lõpuks igati hea 23. koht.
Player
Chips
Progress
Herli Olop
150,000
113,500
Eilne videokokkuvõte Posted Friday 22nd September, 2023 at 12:35(UTC+2) by maheaaatom
Aina juurde ja juurde Posted Friday 22nd September, 2023 at 12:33(UTC+2) by maheaaatom
Kirjas on juba 671 sisseostu, mis tähendab, et mängijate vaatevinklist turniirile overlayd ei tule. Selleks, et auhinnafond üle miljoni paisuks, on aga veel pisut lisa vaja. Välistatud pole midagi, sest mängijaid ja re-entrysid lisandub tõesti iga hetkega. Nii suur saal kui fuajee kubisevad pokkerihulludest.
Täna on mängu tulnud näiteks Andres Kaju, Mauri Dorbek ja Rasmus Sepping. 20xBB pole sugugi halb seis, piisab ühest duublist ning oled keskmise stäkiga kenasti mängus.
Oskar karmis lauas Posted Friday 22nd September, 2023 at 12:26(UTC+2) by maheaaatom
Esimese päeva suuruselt 15. stäkiga lõpetanud pokkeriproff Oskar Ojaveer on loositud üsna karmi lauda, kus on lisaks temale ka turniiri chipliider, 8. ja 19. stäkk.
Herli ja Co teenisid lisaelu Posted Friday 22nd September, 2023 at 12:24(UTC+2) by maheaaatom
Eilsel kesköisel turbosatikal mängiti välja 15 piletit (tekkis ka overlay, seega kordame veelkord üle, et SATELLIITIDEL TASUB SILMA PEAL HOIDA!) ning neid said ka kolm eesti mängijat - Herli, Virgo ja Janek Tammsaar.
Satelliit lõppes kell 5 öösel, seega palju uneaega mängijatel just ei jäänud. Kuid hea on see, et neil on põhiturniiriks üks elu lisaks. Herli stäkk on näiteks selgelt alla keskmise, palju lihtsam mängida kui tead, et ebaõnnestumisel ootab sind ka lisakatse.
Kiidusõnad Keitole Posted Friday 22nd September, 2023 at 12:16(UTC+2) by maheaaatom
Neljapäeval toimunud kolmel kõrvalturniiril tegi head tööd Keito Kaljulaid, kes saavutas 250 € deep-stack turniiril kolmanda ning 555 € PLO bounty-turniiril neljanda koha.
Nende kõrvalturniiride esikohad läksid sel korral Soome ja Leedu pokkerimängijatele, H.O.R.S.E. oli ainuke, kus ükski eestlane midagi ei võitnud.
Teine päev algas Posted Friday 22nd September, 2023 at 12:12(UTC+2) by maheaaatom
Kell 12:00 lookles ukse taga veel kenake järjekord, mistõttu venis turniiri algus kümmekond minutit. Aga nüüd on gong kõlanud.
Juba on lisandunud 33 mängijat. Osad neist said peale turbosatikalt, osad on end otse sisse ostnud. Ning küllap tuleb esimese kahe tasemege juurdeoste veel terve ports juurde.
Põhiturniiri teine päev algab kell 12:00 Posted Friday 22nd September, 2023 at 11:18(UTC+2) by maheaaatom
Põhiturniiri teist päeva alustab 282 mängijat, nende seas 69 eestlast. Kokku tehti nelja avapäeva peale kokku 617 sisseostu.
Kui midagi peaks päeva alguses nihu minema või on veel soov mänguga liituda, siis võimaluseks selleks on kuni kella 13:40-ni (12. mängutaseme lõpp). Seejärel on re-entry periood läbi ning eksimisruumi enam ei ole.
Täna mängitakse 11 x 40 min. Edu kõikidele osalejatele ning põnevat jälgimist kaasaelajatele.
11:15 (UTC+2)
Day 2 of WSOPC Tallinn Started Level: 11 Blinds: 1,000/2,500 Ante: 2,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.