0.0004 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0112 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event9_est/1/updates' ORDER BY `views` DESC

0.2842 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-07-27' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event9_est/1/updates'

0.0041 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

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

0.0001 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

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

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

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

0.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.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.0063 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0005 SECONDS:
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image FROM `tour_stop_blogs` LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id` LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id` LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id` LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id` WHERE `friendly_url` = '2024_wsop_tallinn_event9_est'

0.0002 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '145'

0.2767 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` = '368' AND `published` = 1

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '145' AND `name` = '1'

0.0134 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '368' ORDER BY `busted` ASC, `current_chips` DESC

0.0042 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` = '368' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0062 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '368' ORDER BY `busted` ASC, `current_chips` DESC

0.0049 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` = '368' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0707 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15708' 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` = '15704' 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` = '15702' 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` = '15699' 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` = '15697' 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` = '15695' ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0105 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '368' ORDER BY `busted` ASC, `current_chips` DESC

0.0072 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2553

English
Olympic Park Casino Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Live Reporting - Day 1
1 New Update - Click to refresh
Live Updates - Day 1
Roope annab viimase hoobi Posted Saturday 27th July, 2024 at 22:09(UTC+3) by Mariliis Joras

Roope Tarmi on Tarmo Tammelile juba korduvalt pinnuks silmas olnud. Flip, mis seab Tarmo turniirielu ohtu, läheb nüüdki Roopele.

Tarmol

Roopel

Kohe flopis on veel üks üheksa ja turnis Tarmo käsi drawing dead.

Player Chips Progress
Tarmo Tammel 0 0
Duubel Tarmolt Posted Saturday 27th July, 2024 at 22:04(UTC+3) by Mariliis Joras

Tarmo Tammelil on BB-l istudes käes .

Tom Arovaara on ees shovenud 45 000 ja Tarmo callib maha.

Vastas aga nõksake parem

Paraku lauast abi ei tule.

21:58 (UTC+3)
Start of Level 15
Blinds: 2,000/5,000     Ante: 5,000
Meie poiste stäkid Posted Saturday 27th July, 2024 at 21:36(UTC+3) by Mariliis Joras

Eestlasi järel kolm ja nende hinge taga on enam vähem võrdses koguses žetoone. Vaata lähemalt Chipcounti alt.

Suurim stäkk näikse olevat 500 000 kandis ja see kuulub Paulius Vaitiekunasele.

Tund dinner breaki Posted Saturday 27th July, 2024 at 21:06(UTC+3) by Mariliis Joras

Selle aja jooksul loeme üle eestlaste stäkid ja sisestame ka auhinnarahade suurused.

Ja meelitabki välja Posted Saturday 27th July, 2024 at 21:05(UTC+3) by Mariliis Joras

Tarmo Tammel ja Roope Tarmi on käes. 

Flop tuleb vaid 8000 eest.

Roope jätkab 7500-ga ja saab Tarmo kaasa.

Turn , Roopelt nüüd juba 28 000 ja sellegi callib Tarmo maha.

River ja Roope liigub pika mõttepausi järel all-ini. Tarmo kord tankida. Mõttetöö tulemusel jõuab ta järeldusele, et Roopel ei saa midagi tugevat olla, nii et 101 500 saab calli.

Aga seekord on soomlane Tarmo üle mänginud. Ta avab mis on vägagi hea. Tarmo muckib, aga diiler avab .

Nüüd pääsevad mängijad õhtusöögile, et korra mõttetööst puhata ja end tunnikeseks lõdvaks lasta. 

Olukord, millele rohi puudub Posted Saturday 27th July, 2024 at 20:44(UTC+3) by Mariliis Joras

Board on Igor Pihela Juuniorile semi-hea. Tal on käes seitsmete pocket, seega keskmine paar täiesti olemas. Tema beti 25 000 callib vastane Paulius Vaitiekunas maha.

Aga Igor veel ei tea, kui halvas olukorras ta tegelikult on. 

River on hukatuslik, kuna jätab Igorile mulje, et seis läks just kõvasti paremaks. Nii on tal väga hea meel, et Paulius betib 15 000 ja selle peale ta shoveb. Aga Pauliuse rõõm on suurem - mees avab kolmede pocketi. 

Igori maja purustatud.

Markkos lõpetab Posted Saturday 27th July, 2024 at 20:36(UTC+3) by Mariliis Joras

Kahjuks ei õnnestu Markkos Ladevil kaugemale jõuda. Pidurit vajutab üks turniiri tõenäolistest chipliidritest, rootslane Erik Lindqwist. 

20:28 (UTC+3)
Start of Level 14
Blinds: 2,000/4,000     Ante: 4,000
Rahakohad teada Posted Saturday 27th July, 2024 at 20:28(UTC+3) by Mariliis Joras

Esimesel võimalusel sisestame summad ka siia.

Hetkel aga nii palju, et raha saavad 14 parimat. 

Esikoht lahkub 64 000 eurot rikkamana.

Polnud Ilya päev Posted Saturday 27th July, 2024 at 20:28(UTC+3) by Mariliis Joras

Ainus hea asi Ilya Nikiforovi väljakukkumise juures on see, et nupud jäid Eestisse. 

Igor Pihela Jun katkestab unistuse võidust -ga.

Ilyal

Lauda kumbki ei taba, aga kicker mängib.

Player Chips Progress
Ilya Nikiforov 0 0
Ilya ebaõnn Posted Saturday 27th July, 2024 at 20:21(UTC+3) by Mariliis Joras

Kui raske on -ga jagu saada -st?

Selgub, et väga raske. Mõnikord ei õnnestugi. Lauast saab väiksema stäki ja kehvema kaardiga mees kaks paari, Ilya ei midagi. 

Duubli välja maksmise järel ei jää endalegi õieti...

Igor out Posted Saturday 27th July, 2024 at 20:10(UTC+3) by Mariliis Joras

Igor Pihela Sen on tänaseks lõplikult lõpetanud. Pihelate perre saab võidu tuua veel ainult Juunior.

Player Chips Progress
Igor Pihela Sen 0 0
Ümmargune kokkuvõte Posted Saturday 27th July, 2024 at 20:01(UTC+3) by Mariliis Joras

Late reg on nüüdseks lõppenud ja lõplikuks sisseostude arvuks jäi 100. Ilus ümmargune number. 

Auhinnafondi kogunes 268 800 eurot. Küllap varsti selgub, kuidas see jaguneb.

20:00 (UTC+3)
Start of Level 13
Blinds: 1,500/3,000     Ante: 3,000
Markkos ei leia asu Posted Saturday 27th July, 2024 at 19:46(UTC+3) by Mariliis Joras

Markkos Ladev on Roope Tarmiga pangas. Kuigi suurem osa tänavaid panuseid ei panda, üritab riveris Markkos potti betiga 13 500 endale saada. Aga Roope teda ei usu ja callib äss kõrgega maha. Markkosel tabamusi pole ja soldat kõrge kaardina jääb nõrgaks. Mis seal ikka, pausile tuleb minna ebakindlust tekitavalt õhukeselt.

Neljandas lauas panevad kaks Eesti mängijat stäkid kokku. All-ini minnakse pre-flopist.

Steven Toolil on

Ilya Nikiforovil

Kuningas flopis. Ilya õnneks välja ei kuku.

Nüüd aga 15 minutit pausi. Siis tunnike mängu ja algab tunniajane dinner break.

Player Chips Progress
Steven Tool 237,000 152,000
Phil ei ole teiega veel lõpetanud Posted Saturday 27th July, 2024 at 19:36(UTC+3) by Mariliis Joras

Arva ära, kes jälle lauas on?

Oma viienda sisseostu tegi just Phil Gross.

Viimased 3 re-entry kätt Posted Saturday 27th July, 2024 at 19:35(UTC+3) by Mariliis Joras

Level on nulli tiksunud ja kuulutatakse välja kolm viimast re-entry kätt. 

Kui nendega valmis, liigutakse 15- minutilisele pausile.

Ameerika mäed Posted Saturday 27th July, 2024 at 19:32(UTC+3) by Mariliis Joras

Jon Kyte avab 5500, mille tõstab 15 000 peale Steven Tool. Jon kaasa.

Flop ja Steveni soovil kummaltki veel 12 000.

Turn checkitakse läbi.

River ja Jon kärutab beti 75 000. Steven liigub all-ini ja kui diiler tema nupud üle loeb, siis seal on vähem. Järelikult oleme showdownis.

Jonil ette näidata vaid kolmed. Stevenil seevastu -ga tabatud rida. 

Kohe järgmises jaotuses kütab Jon kõik oma nupud pre sisse ja jätab tildise mulje. Call tuleb jälle Stevenilt. Seekord ollakse vastakuti ja -ga.

Lauakaardid midagi ei muuda ja Jon saab suurema osa eelmises jaotuses ära antust tagasi.

Kui ei ole surmatõbi, küll siis leiab õllest abi Posted Saturday 27th July, 2024 at 19:16(UTC+3) by Mariliis Joras

Markkos Ladevil on halvast õnnest kopp ees. Oma järgmisele katsele suundub ta juba, õlleklaas käes. Õluga üritab ta enda sõnul õiget energiat channeldada.

Südamesoov Posted Saturday 27th July, 2024 at 19:11(UTC+3) by Mariliis Joras

Ritwik Khanna tahab laual olevat 10k lihtsalt niiiiiii hullult palju, et on nõus kogu oma 110 000 pre sisse shovema. Nimelt on üks mängija teinud tõste 5000 ja saanud Ilya Nikiforovilt calli. 

Mis siis ikka. Teised foldivad, sest ei näe põhjust selliselt uisa-päisa all-ini tormata.

19:07 (UTC+3)
Start of Level 12
Blinds: 1,000/2,500     Ante: 2,500
Free hugs Posted Saturday 27th July, 2024 at 19:07(UTC+3) by Mariliis Joras

Ranno Sootla ja Markkos Ladev embavad, kui Ranno Markkose välja võtab.

Rannol on , Markkosel

Boardil juhtis enne riverit Markkos, aga saatusesõrm mängis jämeda otsa Ranno kätte.

"Ma tulen veel tagasi," teatab Markkos keset karukallit. See ainult rõõmustab Rannot. Omadega ju ikka toredam jõudu katsuda.

Mida sa küll sööd, et nii hästi mängid? Posted Saturday 27th July, 2024 at 19:01(UTC+3) by Mariliis Joras

Ranno Sootlal on praegu eestlastest üks suurimaid stäkke.

Kui teid huvitab, et mida nii hästi mängimiseks küll sööma peaks, siis vastus on Martsipani batoon. Just selle tellis Ranno endale baarist. Jooma peaks mullita vett (tuli sama tellimusega).

Player Chips Progress
Ranno Sootla 230,000 180,000
Alla ei anna Posted Saturday 27th July, 2024 at 18:59(UTC+3) by Mariliis Joras

Kert Hallik võitleb.

Pre all-in -ga toob sisse 18 500.

Player Chips Progress
Kert Hallik 37,000 167,000
Kerdi seis on sant Posted Saturday 27th July, 2024 at 18:56(UTC+3) by Mariliis Joras

Paraku kõik all-inid Kert Halliku võiduga ei lõpe.

Kerdi jäi äsja alla Paulius Vaitiekunase kümnete pocketile. Pärast väljamakset on Kert crippled.

Kyte tunneb tõstest rõõmu Posted Saturday 27th July, 2024 at 18:50(UTC+3) by Mariliis Joras

Jon Kyte ja Steven Tool vaatavad floppi.

ja 4000 kummaltki potti.

Turn checkitakse läbi.

River ja Jon fishib miinimumpanusega. Steven teeb tõste 10 000 ja saab insta-calli.

Steveni on riveris pihta saanud. Joni on aga algusest peale parem tabamus.

"Mulle meeldis su tõste," teeb Jon vastasele komplimendi.

Kasseerib sisse Posted Saturday 27th July, 2024 at 18:43(UTC+3) by Mariliis Joras

Kert Hallik saab Ekrem Esker Atushi käest tagasi kõik, mis ta talle vahepeal ära on andnud. Võib-olla isegi intressidega. 

vs

Kerdil kõrgem pocket. 

Lauale Ekremile sobivaid kaarte ei jagata ja Kerdi 102 000 on nüüd kahekordne. 

Player Chips Progress
Kert Hallik 204,000 154,000
Säästulevel Posted Saturday 27th July, 2024 at 18:40(UTC+3) by Mariliis Joras

Käima läks uus mängutase, aga blindid jäävad sama suureks nagu eelmisel tasemel. 

See võimaldab kõigil mängijatel blindidelt kokku hoida.

Olgu veel üle korratud, et re-entry tegemise võimalus ja hiline registreeriumine jäävad avatuks 13. taseme alguseni, see on kuni kl 18.45.

Keskmine stäkk on hetkel 100 000. Praegu end sisse ostes on stäkk 50 BB suurune. Ruumi mängida maa ja ilm.

18:37 (UTC+3)
Start of Level 11
Blinds: 1,000/2,000     Ante: 2,000
Kuidas maitseb? Posted Saturday 27th July, 2024 at 18:37(UTC+3) by Mariliis Joras

Lauakaardid tõmbavad Ekrem Esker Atushi mõnusalt lõksu. 

lauas, kui Kert Hallik riveris oma viimase varanduse shoveb. Ekrem teeb kiire calli ja avab . Aga Kerdil on

"Sick river," kommenteerib Ekrem ise. Aga just samasugused sickid riverid on talle endale ju mitmeid kordi edu toonud!

Tagasi äris Posted Saturday 27th July, 2024 at 18:29(UTC+3) by Mariliis Joras

Phil Gross on meiega neljandat korda. Igor Pihela Sen laadis rauda kolmanda põraka. 

Let' gamble! Posted Saturday 27th July, 2024 at 18:26(UTC+3) by Mariliis Joras

Selliste sõnadega callib vastase all-ini maha Igor Pihela Sen, kellel ette näidata tavapärasest kõrgem "Doyle Brunson"

Vastase veidi kehakam.

Flopis ainult üks ruutu, aga ka üks kümme. Paraku turn ja river abi ei too. Igori stäkk on väiksem.

Kõigi eelduste kohaselt teeb Igor comebacki, nii nagu alati. Aga võib-olla ka mitte. Kes seda teab.

Lisa-Igor on meiega liitunud Posted Saturday 27th July, 2024 at 18:25(UTC+3) by Mariliis Joras

Isa-Igor Pihela on meiega juba ammu, aga noorem Igor on hilisem lisandus. Igas mõttes. Põhiturniirilt saak käes, võib nüüd kõrgematele panustele keskenduda. 

Auhinnafondis hetkeseisuga üle 225 000 euro - on, mille peale mängida. 

Kert saab närvikõdi Posted Saturday 27th July, 2024 at 18:13(UTC+3) by Mariliis Joras

Kümnete pocket vs vastasseis paneb Kert Halliku turniirielu kaalule, sest tal stäkk 32 000 - vastase Mateusz Wozniaki omast väiksem.

Lauakaardid Kerti ei ohusta ja nüüd võib rääkida hoopis duublist.

18:08 (UTC+3)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
Igor uuel katsel Posted Saturday 27th July, 2024 at 18:08(UTC+3) by Mariliis Joras

Igor Pihela Sen on samuti ette võtnud järgmise ringi. Markkos Ladev startis kolmandat korda.

See on pokker Posted Saturday 27th July, 2024 at 18:05(UTC+3) by Mariliis Joras

Nagu juba öeldud, on Tarmo Tammel uuel ringil. Ja see ring on osutunud väga võimsaks, kui vaadata stäkki, mis Tarmo ees kõrgub! 

"Pokker," ütleb ta ise kommentaariks. 

Player Chips Progress
Tarmo Tammel 210,000 160,000
Tõstest piisab Posted Saturday 27th July, 2024 at 17:57(UTC+3) by Mariliis Joras

Ritwik Khanna on huvitatud pangast, mida Ilya Nikiforov peab juba praktiliselt enda omaks. 

Flop ja Ilya beti 6000 callib Ritwik maha.

Turn ja Ilya checkib. Ritwiki ürituse 7000-ga rünnata lõpetab ületõste 21 000, millele järgneb kiire fold.

Eestlastest on vahepeal teisele katsele läinud nii Tarmo Tammel kui Markkos Ladev. 

17:48 (UTC+3)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Mängijad pausil Posted Saturday 27th July, 2024 at 17:19(UTC+3) by Mariliis Joras

15 minutit puhkust.

Uus eestlane lõugade vahel Posted Saturday 27th July, 2024 at 17:18(UTC+3) by Mariliis Joras

Kui lauaga number 2 liitus uus mängija ja lasi pärast Ekrem Esker Atushi enda vastas nägemist välja sügava ohke, siis ei saanudki täpselt aru, miks. Aga pärast viimaseid jaotusi hakkab pilt selginema. Tegemist on raske vastasega.

Lauakaardid on kõik avatud ja pangas on hulk erivärvilise žetoone:

Ekrem betib 36 000. Lätlane foldib, aga Kert Hallikul on veel võimalus kaasa rääkida. Ta callib selle suure beti maha.

Ekrem avab ja Kert on tige. Tal vaid

Markkos saab süüdistuse Posted Saturday 27th July, 2024 at 17:12(UTC+3) by Mariliis Joras

Markkos Ladev on buttonil ja teeb tõste 7500. CO-l istuv Ekrem Esker Atush ei kavatse seda jama enam taluda. "Kogu aeg mängid positsiooni," ütleb ta Markkosele ja callib ära.

Flop ja Ekrem checkib. Markkos betib 5500 ja saab calli.

Turn , Ekrem checkib taas, aga Markkose uue beti 6500 maksab.

River ja kordub sarnane muster, kuid kui Markkos on bettinud 31 500, siis läheb Ekrem all-ini ja paneb Markkose elu üle järele mõtlema. Lõpuks näeme calli ja sellele plaksutab Ekrem mõttes käsi.

Ta avab ja saab sellega panga. Markkos soovib oma küll muckida, kuid diiler järgib reegleid ja näitab ette. 

Kohe Markkos uut sisseostu ei tee. 

Player Chips Progress
Markkos Ladev 0 0
Ema, anna padruneid Posted Saturday 27th July, 2024 at 17:01(UTC+3) by Mariliis Joras

Phil Grossil on padrunitega kõik hästi. Kolmas on rauas ja nüüd on ta istuma pandud Ranno Sootla kõrvale.

Kaotasime Priidu Posted Saturday 27th July, 2024 at 16:51(UTC+3) by Mariliis Joras

Action jäi nägemata, kuid Priit Parmasto iste on esialgu tühjaks jäänud. Kas ta tuleb veel tagasi, pole veel selge.

Player Chips Progress
Priit Parmasto 0 0
16:50 (UTC+3)
Start of Level 8
Blinds: 600/1,200     Ante: 1,200
Raske loobumine Posted Saturday 27th July, 2024 at 16:44(UTC+3) by Mariliis Joras

Müts maha Markkos Ladevi ees, kes suudab raskeid folde teha. 

Laual ja kumbki mängija lisab panka 8500.

River ja Markkos vajutab 28 500, mida pole just vähe. Vastane läheb all-ini ja counti palve peale tuvastab diiler 48 100 suuruse stäki. Markkosel on vajalik summa välja maksta ja rohkemgi veel, aga hinnates oma kaarte, vastast ja kogu situatsiooni annab ta seekord alla. Loodame, et see oli õige otsus.

Phil suundub teisele katsele Posted Saturday 27th July, 2024 at 16:34(UTC+3) by Mariliis Joras

Mis valesti, see uuesti. Phil Gross kukub välja ja suundub kohe re-entryt tegema.

Auhinnafondis juba üle 155 000 euro.

Markkosel hakkab ülesmäge minema Posted Saturday 27th July, 2024 at 16:33(UTC+3) by Mariliis Joras

Tuli lihtsalt õige hetk ära oodata. 

Floppi vaadatakse kolmekesi 2000 eest. 

sobib ideaalselt Markkos Ladevile ja mängijale istekohal nr 1. Turni vaatavad nad 8000 eest.

laekumisel liigub Markkos all-ini ja saab kiire calli.

Showdown selgitab, miks. Markkose on tabanud kõrge masti, vastase märksa madalama. Markkos saab kena lisa, sest river enam mitte midagi ei muuda.

16:23 (UTC+3)
Start of Level 7
Blinds: 500/1,000     Ante: 1,000
Ilya käib all-inis Posted Saturday 27th July, 2024 at 16:23(UTC+3) by Mariliis Joras

Ilya Nikiforovi stäkk on langenud 28 200 peale. Kogu kupatuse paneb ta mängu pre-flopist, kus üks vastastest on teinud tõste 2900. Aga seda kärbest ta seekord liimile ei meelita. 

Turniirialal näeme jalutamas ja vestlemas ka Henri Käsperit, kes taolistel festivalidel jõuab reeglina ka highrollerite lauda. Aga täna mitte, sest nädalavahetuseks on muud plaanid. 

Tarmole lisa Posted Saturday 27th July, 2024 at 16:04(UTC+3) by Mariliis Joras

Tarmo Tammeli stardikäsi toob chipilisa. Tom Arovaara pihta ei saa, aga Tarmo betid 1700 flopis ja 5100 turnis maksab kohusetundlikult välja. 

Player Chips Progress
Tarmo Tammel 50,000 0
Talisman on kaasas Posted Saturday 27th July, 2024 at 15:59(UTC+3) by Mariliis Joras

Phil Gross on oma kaunilt särava sõrmuse ka lauda kaasa võtnud. Ise ütleb, et 80% vastaste hirmutamiseks ja 20% endale tõestamiseks, et võiduvõimalused on reaalsed. 

Phili käest õnnestus väike chipilisa välja meelitada Priit Parmastol, kes temaga ühes lauas istub. 

Aga nüüd on sagimist juba rohkem. Sisseostude arv on kerkinud 53 peale. 

15:57 (UTC+3)
Start of Level 6
Blinds: 400/800     Ante: 800
Sõrmusemees platsis Posted Saturday 27th July, 2024 at 15:53(UTC+3) by Mariliis Joras

Phil Gross on käesolevalt festivalilt ühe sõrmuse juba võitnud, aga ega ta ei peatu. Mystery Bountyl vormistas ta hetk tagasi ära 11. koha (saagiks 3150 €) ja nüüd on ta meie turniiril sees. 

Hiiterist tuleb võtta, mis hiiter annab. 

Player Chips Progress
Phil Gross 50,000 0
Ei anta asu Posted Saturday 27th July, 2024 at 15:47(UTC+3) by Mariliis Joras

Markkos Ladevit kimbutab ebaõnn. Just äsja saanuks ta ühe väikse panga maha võtta, kuna tal oli viite pocket, aga ikka maandus riverisse äss, mis andis -ga vastasele parema paari. 

Loodame, et õige hoog on peagi üles võtmas.

Väljakukkujaid on ka Posted Saturday 27th July, 2024 at 15:39(UTC+3) by Mariliis Joras

Väljakukkumistest pole eriti juttu teinud põhjusel, et ükski neist pole olnud Eesti mängija. Positiivne ju!

Aga neli seat openit on juba kõlanud. Kaks neist soomlastele, üks rootslasele ja üks norrakale. Jääb üle loota, et nii jätkub ka edaspidi.

Raske otsus Posted Saturday 27th July, 2024 at 15:30(UTC+3) by Mariliis Joras

Markkos Ladev tuleb pausilt ja leiab kohe käe. Ta avaks hea meelega 1500 eest, kuid Jan-Mikael Kesänen tõstab veelgi. Tõste on vist 6000, sest Markkos vastab nüüd omalt poolt ületõstega 13 000 ja see jääb ka flopi lõpphinnaks. 

paneb Jan-Mikaeli checkima, kuid Markkose beti 7000 ta maksab.

Turnis proovib Markkos läbi ajada betiga 12 000, kuid ette checkinud Jan-Mikael tõstab nüüd lauda 50 000 jagu punaseid žetoone. Seda on rohkem kui Markkosel hinge taga ning ees ootab raske otsus. Viimaks leiab Markkos endas jõu maha panna, sest ilmselt ei ole ta tabanud nii hästi kui lootis. 

15:18 (UTC+3)
Start of Level 5
Blinds: 300/600     Ante: 600
Hea pausile minna Posted Saturday 27th July, 2024 at 15:07(UTC+3) by Mariliis Joras

Ranno Sootla kostitab end enne pausi chipilisaga. 

Lauakaardid ja pangas on umbes 39 000. Ranno checkib ja annab ohjad Jon Kytele, aga too otsustab checkida. Ranno näitab ja saab sõjasaagi endale. 

Nüüd on aeg liikuda 15-minutilisele pausile. 

Valehäire. Võtab tagasi Posted Saturday 27th July, 2024 at 15:01(UTC+3) by Mariliis Joras

Kert Halliku madalseis kestab väga lühikest aega. Õnneks!

Boardil kui Rolandas Aglinskas betib 15 000. Kert callib.

River ja kordub sama - Rolandaselt 15 000. Temale Kert äsja duubli andiski ja nüüd on Kerdi stäkk Rolandase omast väiksem. Samas jagub siiski nuppe piisavalt, et veel tõste teha - Kert shoveb. Rolandas callib ja nüüd saame kaarte näha.

Kerdil -ga flopatud rida.

Rolandasel -ga kaks paari.

Kert teeb endale väikse aplausi ja on back in the game.

Kert kannab kaotusi Posted Saturday 27th July, 2024 at 14:54(UTC+3) by Mariliis Joras

"Massive pot!" teatab Kert Hallik teistele, kes actionit oma silmaga ei näinud. Tal tuleb kõrval istuvale Rolandas Aglinskasele duubel välja maksta, kui viimane hitib -ga ässa. Paistab, et Kerdil endal olid kuued. Siiski läks tal paremini kui Jae Han Kimil, kes samas jaotuses suisa välja kukkus. 

Veel üks laud avatud Posted Saturday 27th July, 2024 at 14:50(UTC+3) by Mariliis Joras

Mängijaid on vaikselt juurde voogamas. Juba on sisseostude arv tõusnud 36-ni. 

Üks soomlane on jõudnud ka re-entry teha.

Tõeliselt mitmekülgne board Posted Saturday 27th July, 2024 at 14:49(UTC+3) by Mariliis Joras

Laual avatud

See annab nii palju erinevaid võimalusi, et ei jõua kokkugi lugeda. Kaks meest ongi nende võimaluste kütkeis. Pangas on juba 44 000 chippi, kuid panustamine pole lõppenud!

Mykola Kostyrko betib 10 600, aga Igor Pihela Sen jaoks on sellest vähe. Ta kahekordistab Mykola beti ja jääb ootama. Näkkabki!

Igor avab ja selle peale lendavad Mykola kaardid mucki. Meie mehele aga väga hea pank.

Millal süüa saab? Posted Saturday 27th July, 2024 at 14:43(UTC+3) by Mariliis Joras

Ja kas üldse. See küsimus tekib Kert Hallikul. 

Turniiridirektor Teresa kinnitab, et saab. Dinner break on planeeritud pärast 14. taset. Tunniks ajaks liigutakse siis kogu koosseisuga restorani.

14:41 (UTC+3)
Start of Level 4
Blinds: 200/500     Ante: 500
Tasa ja targu Posted Saturday 27th July, 2024 at 14:40(UTC+3) by Mariliis Joras

Markkos Ladev kohe paugutama ei hakka. Kolmekesi vaadatakse floppi ja -le saab Markkos pihta. Ta ei beti ja seda ei tee ka teised vastased.

Turn toob Jae Han Kimilt 1500, mille callivad mõlemad vastased.

River ja taas vaikus.

Markkos avab , mis on kaugelt parem kui vastaste ja .

Alati ei peagi ju hulluks minema.

Pöidlad nüüd pihku ka Ranno Sootla edu nimel, sest temagi on lõpuks lauda jõudnud.

 

Player Chips Progress
Ranno Sootla 50,000 0
Mütsiline uustulnuk Posted Saturday 27th July, 2024 at 14:30(UTC+3) by Mariliis Joras

Kolmanda lauaga on liitunud Eesti mängija Steven Tool ja kohe esimeste kätega valmistab ta vastastele peavalu. Õigemini paneb vähemalt ühe neist tõsiselt kukalt kratsima. 

Boardil on ja panka lisandub kummaltki mehelt 2500. Nüüd on keskel u 28 000.

River ja leedulane Ricardas Bartasius checkib. 

Stevenilt nüüd rasvane 20 000. Miks selline käik, nuputab Ricardas teiselpool lauda. Üritatakse siin jõujooni paika panna või on tal tõesti käsi? 

Pika mõttepausi järel näeme calli ja see on kõigile tõeline maiuspala.

Steven avab , Ricardas

Oma algstäkile võtab Steven võimsa lisa. 

Player Chips Progress
Steven Tool 85,000 35,000
Hea taju! Posted Saturday 27th July, 2024 at 14:22(UTC+3) by Mariliis Joras

Kert Hallik tunnetab ära, et kuigi ta lauale pihta pole saanud, võib tal vastasest kõrgem "mitte miski" olla. 

Riveris tuleb ära callida 1500 ja siis saabki näha. on board, mida kumbki ei tabanud. 

Bettinud mehel käes , callijal Kerdil aga .

"Just a little bit better," naerab Kert ka ise nuppe enda ette kraapides.

Ei saa me läbi Igorita Posted Saturday 27th July, 2024 at 14:19(UTC+3) by Mariliis Joras

"Ma kavatsen maini ära võita. Aitab juba küll nendest highrolleritest," ütles Igor Pihela Junior mõni minut tagasi. Tema loodab, et highrollerile tal seekord asja pole, sest põhiturniiril läheb lihtsalt nii hästi. 

Aga Igor Pihelateta me ei jää, sest "vanem" ostis end just äsja sisse. 

Player Chips Progress
Igor Pihela Sen 50,000 0
Veel üks laud lahti Posted Saturday 27th July, 2024 at 14:11(UTC+3) by Mariliis Joras

Üks pöidlaid keerutavatest diileritest saab lõpuks kaardipakki segama asuda, sest järsku ostis ennast sisse mitu uut mängijat ja avada tuli uus laud. 

Muide, ka eestlaste koguarv suurenes. Tere tulemast seltskonda, Markkos Ladev!

Player Chips Progress
Markkos Ladev 50,000 0
14:08 (UTC+3)
Start of Level 3
Blinds: 200/400     Ante: 400
Priit in da house Posted Saturday 27th July, 2024 at 13:50(UTC+3) by Mariliis Joras

Veel oma poisse. Mänguga liitus Priit Parmasto. 

Player Chips Progress
Priit Parmasto 50,000 0
Nüüd alles läks mänguks Posted Saturday 27th July, 2024 at 13:49(UTC+3) by Mariliis Joras

Nii suuri panuseid ei ole veel näinudki!

Floppi vaadatakse 700 eest, selle hinna määrab Kert Hallik.

lauda ja kõik mängijad checkivad.

Turn ja ees kaks checki, kui Kert betib 800. Alexander Norden tuleb kaasa, aga mitte callides, vaist tõstega 3500. Kert callib.

River on koht, kus aga tõeliselt põnevaks läheb. Alexander betib 6200, millele Kert paneb veelgi otsa. Showdowni hinnaks saab 15 200. Alexander mõtleb vaid hetke ja callib!

Kert avab kiirelt ja tõestab, et ta on seda chipikuhja väärt. Norraka taskukaardid jäävad nägemata.

Player Chips Progress
Kert Hallik 82,500 32,500
Priit Parmasto 50,000 0
13:38 (UTC+3)
Start of Level 2
Blinds: 100/300     Ante: 300
Kolm Eesti lippu Posted Saturday 27th July, 2024 at 13:37(UTC+3) by Mariliis Joras

18-st alustajast on Eesti lipp kolme mängija nime taga. Lisaks juba nimetatutele on turniiriga liitunud Eesti lipu all mängiv pokkeriproff Ilya Nikiforov.

Välismaistest mängijatest on vahest eestlasele tuttavamad soomlased Kai Lehto ja Casper Schantz. Mõlemad on siin suurturniiridel varemgi osalenud.

Player Chips Progress
Ilya Nikiforov 50,000 0
Kert valmistab halva üllatuse Posted Saturday 27th July, 2024 at 13:28(UTC+3) by Mariliis Joras

Flop ja mängus on kolm meest. Turni vaatamiseks käiakse välja 500.

Turn ja veel üks bet 500 tuleb Leedu mängijalt Rolandas Aglinskas. Kert Hallik callib ning norrakas Jae Han Kim samuti. 

River ja nii leedukas kui Kert sooviks checkida. Norrakalt siiski 4000 ja kui leeduka saab ta sellega pangast välja, siis Kerti mitte.

"Kuidas sa said selle callida?" on Jae õnnetu, sest oma blufiga jäi ta nüüd vahele.

Kert võtab panga -ga.

Suur sisseost, suur algstäkk Posted Saturday 27th July, 2024 at 13:20(UTC+3) by Mariliis Joras

Igaks juhuks tasub üle korrata ka turniiri põhiandmed. 

Sisseost 3000 € tagab 50 000 nupu suuruse algstäki. 

Tasemed kestavad 30 minutit ja täna on plaanis mängida kuni finaallaua selgumiseni, nii et saab olema pikk päev. 

Hiline registreerumine jääb avatuks 12 tasemeks, seega on uusi nägusid liitumas kuni umbes õhtul 19ni.  Sama kaua on võimalik sooritada ka re-entryt. Elu on näidanud, et kallima otsa turniiridel kasutatakse sedagi võimalust pigem usinalt.

Suured poisid on valmis! Posted Saturday 27th July, 2024 at 13:02(UTC+3) by Mariliis Joras

Kallid pokkerisõbrad! 

Festival on täies hoos ja jätkub täna "suurte poiste" mänguga. Highrollerid on kotid raha täis pakkinud ja kohe lauda istumas, et alustada 3000-eurose sisseostuga 6max ring event'i. 

Meie eestikeelne blogi hoiab silma peal eelkõige kodumaistel mängijatel. Esialgu on end üles andnud kõigest 11 mängijat, kuid late reg kestab ja võib 100% kindel olla, et mänguhuvilisi lisandub juurde ja juurde. 

Praegu on Eesti lippe registreerunute nimistus kaks - Vladimir Korzinin ja Kert Hallik. Kivi kotti, mehed. 

Player Chips Progress
Vladimir Korzinin 50,000 0
Kert Hallik 50,000 0
12:57 (UTC+3)
Day 1 of Olympic Park Casino Started
Level: 1     Blinds: 100/200     Ante: 200

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.