0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0061 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/WSOPCTallinn2023-MainEvent-Est/2/updates' ORDER BY `views` DESC

0.0166 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-27' 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.0002 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.0006 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0004 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.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.0006 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.0105 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.0074 SECONDS:
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `friendly_url` = 'WSOPCTallinn2023-MainEvent-Est'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '40'

0.0667 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0044 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '122' AND `published` = 1

0.0871 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0046 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '126' AND `published` = 1

0.0234 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0033 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '128' AND `published` = 1

0.0869 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0062 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '131' AND `published` = 1

0.1819 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0109 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '133' AND `published` = 1

0.1877 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0114 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '137' AND `published` = 1

0.0850 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0116 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '140' AND `published` = 1

0.0050 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '40' AND `name` = '2'

0.0056 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.0054 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '133' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0113 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5798' ORDER BY `chip_change` DESC, `busted` ASC

0.0619 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5795' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5794' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5790' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5785' 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` = '5782' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5781' ORDER BY `chip_change` DESC, `busted` ASC

0.0641 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0053 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5777' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5776' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5774' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5771' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5770' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5769' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5768' ORDER BY `chip_change` DESC, `busted` ASC

0.0607 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5761' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5759' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5757' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5756' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5755' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5751' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5750' ORDER BY `chip_change` DESC, `busted` ASC

0.0568 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0058 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5745' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5744' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5740' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5737' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5736' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5734' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5732' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5729' ORDER BY `chip_change` DESC, `busted` ASC

0.0567 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5721' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5718' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5716' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5715' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '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.0728 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0119 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0114 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0111 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0590 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5698' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5697' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5694' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5692' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5690' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5686' ORDER BY `chip_change` DESC, `busted` ASC

0.0582 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5681' ORDER BY `chip_change` DESC, `busted` ASC

0.0053 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5679' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5678' 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` = '5674' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5673' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5672' ORDER BY `chip_change` DESC, `busted` ASC

0.0599 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5667' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5666' ORDER BY `chip_change` DESC, `busted` ASC

0.0074 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0058 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5663' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5662' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5660' ORDER BY `chip_change` DESC, `busted` ASC

0.0620 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0132 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.0052 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.0147 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5796' ORDER BY `chip_change` DESC, `busted` ASC

0.0564 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5794' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5790' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5785' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5782' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5781' ORDER BY `chip_change` DESC, `busted` ASC

0.0054 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5780' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5777' ORDER BY `chip_change` DESC, `busted` ASC

0.0658 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0244 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5771' 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` = '5770' ORDER BY `chip_change` DESC, `busted` ASC

0.0720 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0133 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0108 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0649 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5759' ORDER BY `chip_change` DESC, `busted` ASC

0.0116 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0680 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0254 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0162 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0593 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0226 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5745' ORDER BY `chip_change` DESC, `busted` ASC

0.0101 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0051 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5740' ORDER BY `chip_change` DESC, `busted` ASC

0.0563 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0058 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5736' ORDER BY `chip_change` DESC, `busted` ASC

0.0110 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5732' ORDER BY `chip_change` DESC, `busted` ASC

0.0162 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0593 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5721' 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` = '5718' ORDER BY `chip_change` DESC, `busted` ASC

0.0052 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5716' ORDER BY `chip_change` DESC, `busted` ASC

0.0052 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5715' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5713' ORDER BY `chip_change` DESC, `busted` ASC

0.0052 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5709' 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` = '5707' ORDER BY `chip_change` DESC, `busted` ASC

0.1028 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0614 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5702' ORDER BY `chip_change` DESC, `busted` ASC

0.0056 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5700' ORDER BY `chip_change` DESC, `busted` ASC

0.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5708' 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` = '5698' 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` = '5697' ORDER BY `chip_change` DESC, `busted` ASC

0.0074 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1622 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0162 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0162 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1673 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0162 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0163 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5681' ORDER BY `chip_change` DESC, `busted` ASC

0.1676 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0166 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0175 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.1823 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5672' ORDER BY `chip_change` DESC, `busted` ASC

0.0121 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0055 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5667' ORDER BY `chip_change` DESC, `busted` ASC

0.0578 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0058 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '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.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` = '5662' 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` = '5660' ORDER BY `chip_change` DESC, `busted` ASC

0.0117 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0750 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.0004 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2143

English
WSOPC Tallinn Event #6: €1,500 WSOPC Tallinn Main Event (Estonian) Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 2
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.

Telelaua vaatamiseks (30-minutiline viivitus) klikka siia.

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

Kõik huvilised on oodatud jälgima ka TV-ülekannet, mille leiab sellelt aadressilt.

"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:

- Kell 18:00 75 € megasatelliit (20 piletit GTD)

- Kell 18:30 11 € Overlay Hunt satikas (3 piletit GTD)

- Kell 19:30 33 € turbo-satikas (3 piletit GTD)

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 . More 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.