0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0062 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-09-01' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsopc_tallinn_me_EST/2/updates' ORDER BY `views` DESC

0.0006 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2024_wsopc_tallinn_me_EST/2/updates', 1, '2024-09-01')

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

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

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

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

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

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

0.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.0003 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.0004 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

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

0.0061 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_wsopc_tallinn_me_EST'

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

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

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

0.0246 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0045 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '375' AND `published` = 1

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '141' AND `name` = '2'

0.0055 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '347' 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_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '347' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '15543' 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` = '15534' 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` = '15529' 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` = '15525' 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` = '15523' 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` = '15522' 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` = '15518' 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` = '15516' 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` = '15512' 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` = '15510' 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` = '15506' 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` = '15504' 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` = '15502' 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` = '15498' 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` = '15496' 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` = '15493' 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` = '15490' 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` = '15486' 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` = '15484' 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` = '15480' ORDER BY `chip_change` DESC, `busted` ASC

0.0091 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15479' 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` = '15477' 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` = '15475' 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` = '15471' 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` = '15469' 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` = '15462' 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` = '15461' 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` = '15458' 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` = '15455' ORDER BY `chip_change` DESC, `busted` ASC

0.0384 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15441' 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` = '15437' 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` = '15435' 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` = '15433' 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` = '15431' 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` = '15430' 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` = '15429' 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` = '15427' 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` = '15420' 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` = '15414' ORDER BY `chip_change` DESC, `busted` ASC

0.0457 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15412' 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` = '15409' 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` = '15408' 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` = '15404' 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` = '15396' 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` = '15394' 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` = '15392' 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` = '15390' 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` = '15386' 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` = '15382' 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` = '15377' ORDER BY `chip_change` DESC, `busted` ASC

0.0467 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15374' 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` = '15366' 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` = '15362' 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` = '15354' 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` = '15352' 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` = '15350' 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` = '15346' 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` = '15340' 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` = '15332' 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` = '15325' 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` = '15324' ORDER BY `chip_change` DESC, `busted` ASC

0.0466 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15316' 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` = '15312' 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` = '15309' 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` = '15305' 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` = '15304' 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` = '15301' 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` = '15300' 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` = '15051' ORDER BY `chip_change` DESC, `busted` ASC

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

0.0050 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_id` = '347' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

0.0459 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15543' 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` = '15534' 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` = '15529' 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` = '15525' 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` = '15523' 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` = '15522' 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` = '15518' 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` = '15516' 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` = '15512' 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` = '15510' ORDER BY `chip_change` DESC, `busted` ASC

0.0482 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15506' 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` = '15504' 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` = '15502' 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` = '15498' 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` = '15496' 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` = '15493' 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` = '15490' 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` = '15486' 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` = '15484' 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` = '15480' 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` = '15479' 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` = '15477' 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` = '15475' 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` = '15471' 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` = '15469' 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` = '15462' 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` = '15461' 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` = '15458' 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` = '15455' 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` = '15441' 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` = '15437' 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` = '15435' 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` = '15433' 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` = '15431' 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` = '15430' 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` = '15429' 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` = '15427' 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` = '15420' 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` = '15414' 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` = '15412' 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` = '15409' 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` = '15408' 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` = '15404' 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` = '15396' 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` = '15394' 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` = '15392' 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` = '15390' 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` = '15386' 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` = '15382' 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` = '15377' 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` = '15374' 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` = '15366' 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` = '15362' 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` = '15354' 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` = '15352' 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` = '15350' 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` = '15346' 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` = '15340' 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` = '15332' 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` = '15325' 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` = '15324' 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` = '15316' 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` = '15312' 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` = '15309' 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` = '15305' 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` = '15304' 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` = '15301' 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` = '15300' 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` = '15051' ORDER BY `chip_change` DESC, `busted` ASC

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

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

English
Olympic Park Casino Event #6: €1M GTD €1,500 Main Event (Estonian) Live Reporting - Day 4
1 New Update - Click to refresh
Live Updates - Day 2
Turniiri jätkab 17 Eesti mängijat Posted Saturday 27th July, 2024 at 01:37(UTC+2) by maheaaatom

Põhiturniiri teise päeva järel püsib mängus 68 parimat, kelle seas 17 Eesti mängijat. Paul Koppe on turniiri chipliider, üle miljoni stäkid on ka Kaspar Kaiselil ja Marius Morelil.

Action jätkub laupäeval kell 12:00, mil mängitakse kuni finaallauani. Head ööd! 

Player Chips Progress
Paul Koppe 1,660,000 240,000
Kaspar Kaisel 1,465,000 235,000
Marius Morel 1,105,000 105,000
Evgeny Vyal 790,000 513,500
Aleksei Vandyshev 690,000 0
Andre Villandberg 585,000 265,000
Mairo Tori 500,000 200,000
Mauri Dorbek 475,000 55,000
Ermo Kosk 445,000 155,000
Risto Pärnat 325,000 55,000
Sergei Aleksejev 280,000 51,500
Markku Koplimaa 265,000 5,000
Igor Pihela noorem 245,000 55,000
Andre Grigorjev 230,000 99,000
Martin Piik 220,000 40,000
Artur Külanurk 60,000 170,000
Steven Tool 50,000 170,000
Andre kaotab ässadega megapanga Posted Saturday 27th July, 2024 at 00:51(UTC+2) by maheaaatom

Floppi vaatab kolm mängijat. 

Checkitakse kuni Andre Grigorijevini, kes panustab 100K ning saab mõlemalt vastaselt calli.

Turn on , checkitakse taas kuni Andreni, kes lükkab nüüd keskele juba 200K. Vastu tuleb aga all-in (550K) kreeklaselt Enea Subashilt. Andre mõtleb pisut, leides viimaks siiski calli.

"Kas sul on nuts?" pärib Andre ning kreeklane avabki . Andrel .

Kahju, tegemist oli tõenäoliselt suurima pangaga, kus ükski eestlane täna osalenud. Andre jääb ellu, kuid kahjuks mitte kuigi suure stäkiga.

Ühtlasi hakkab päev lõppema ning mängijad pakivad chippe. Poole tunni jooksul katsume avaldada ka eestlaste täpse puntkiseisu.

Andre näitab Pauli vastu jõulist mängu Posted Saturday 27th July, 2024 at 00:40(UTC+2) by maheaaatom

Eestlane Andre Grigorjev avab 30K tõstega ning Paul Koppe vastab traditsioonilise 3-panusega 75K. Andrelt call.

Flopis avatakse ning Andre avab 50K-ga. Paul vastab 125K-ga ning Andre taas callib.

Turn on ning taas jätkab Andre panustamist, seekord 100K-ga. Paul hakkab naerma ja viskab kiirelt maha.

Ega jõumängu vastu muud moodi saagi kui peab ka ise jõudu näitama. Käib viie viimase käe jagamine. Vahepeal on langenud kolm soomlast, 69 parimat mängus.

73. koht Martin Keskküla, 79. koht Sergei Krementsukov - mõlemad 3250 € Posted Saturday 27th July, 2024 at 00:31(UTC+2) by maheaaatom

Sisuja mängu teinud Martin Keskküla, kes alustas päeva korralikku 160 000 punktiga, lõppkohaks jääb 73. Sergei jääb temast kuus kohta tahapoole.

Mängus 72 parimat. 

Player Chips Progress
Sergei Krementsukov 0 0
Martin Keskküla 0 0
Lõppes €250 NLH & PLO 4 & 5 Mix Posted Saturday 27th July, 2024 at 00:27(UTC+2) by maheaaatom

Turniiri võitis Hollandi mängija, kellele järgnes kolm soomlast. Eestlasi kahjuks finaallauda ei jõudnud.

Kahjuks tuleb tõdeda, et Eesti pokkerimängijatel pole siiani just kõige paremini läinud, võidetud on vaid üks kõrvalturniir. Samas on tähtsaimad turniirid alles käimas või ees ning põhiturniiril on meie meeste seis päris hea. Loodame, et me ilma sõrmuseta ei jää, kuigi eelmise aasta õnnestumist (4 sõrmust) ületada on juba sisuliselt võimatu.

Paul hoiab survet Posted Saturday 27th July, 2024 at 00:24(UTC+2) by maheaaatom

Paul Koppe hoiab omas lauas (kus istuvad ka Igor Pihela ja Andre Villandberg) survet ning ründab järjest panku. Eks seda peabki tegema, lisaks on Paulil selgelt ka kõige suurem stäkk.

Paljude mängijate mõtted tunduvad olevat juba homses päevas. Täna on mängida veel umbes pool tundi ning laudades 74 parimat.

Kuidas Arturil läheb? Posted Saturday 27th July, 2024 at 00:12(UTC+2) by maheaaatom

Mullu selsamal turniiril kolmanda koha saavutanud ning oma elu tulemuse teinud Artur Külanurk on selgi aastal rahades ning istub hetkel lauas umbes 240K stäkiga, mis on 20XBB. Otseselt veel kiiret pole.

Steven Toolil on umbes samapalju, mõni aeg tagasi kaotas mees enam kui miljonilise panga -ga -le. 

Martin Piigil on ligikaudu 260K. Mairo Tori on oluliselt juurde saanud ning hetkel 700K stäkiga. Kaspar Kaisel istub endiselt miljoni peal.

Player Chips Progress
Mairo Tori 700,000 250,000
Martin Piik 260,000 105,000
Artur Külanurk 230,000 20,000
Steven Tool 220,000 80,000
Maja neliku vastu, Paul ligineb kahele miljonile Posted Saturday 27th July, 2024 at 00:02(UTC+2) by maheaaatom

Igor Pihela ja Paul Koppe mängisid omavahel 800K panga, kus sattusid vastamisi Igori ja Pauli i

Tähelepanu väärib aga board - !

Niisiis - maja neliku vastu. Igoril on umbes 300K järgi, kuid Paulil peaks olema hetke suurim stäkk - umbes 1,9M.

Player Chips Progress
Paul Koppe 1,900,000 800,000
Igor Pihela noorem 300,000 300,000
84. koht Sten Liivand 3250 € Posted Friday 26th July, 2024 at 23:51(UTC+2) by maheaaatom

Sten Liivandile jääb WSOP Circuit põhiturniiri lõppkohaks 84. ning auhinnaraha kaasneb sellega 3250 eurot.

Jätkab 81 parimat ning äsja alanud tänase viimase mängutaseme pimepanused on 6000/12000/12000.

Vabandame veelkord lugejate ees, kuna programmis esineb ajutusi tehnilisi tõrkeid, mis võivad muuta keskkonna kohati väga aeglaseks nii lugejate kui blogijate jaoks. Katsume anda endast parima ning loodame, et probleem kiiremas korras laheneb.

Player Chips Progress
Sten Liivand 0 0
Eestlaste stäkke Posted Friday 26th July, 2024 at 23:41(UTC+2) by maheaaatom
Player Chips Progress
Paul Koppe 1,100,000 150,000
Igor Pihela noorem 600,000 150,000
Mairo Tori 450,000 70,000
Mauri Dorbek 420,000 40,000
Martin Piik 365,000 5,000
Andre Villandberg 320,000 280,000
Steven Tool 300,000 200,000
Risto Pärnat 270,000 50,000
86. koht Jaanus Kippel 3250 € Posted Friday 26th July, 2024 at 23:34(UTC+2) by maheaaatom

Jaanus Kippel on omamoodi online-pokkeri Eesti meistrivõistluste fenomen. 2022. aastal tuli ta OPEM põhiturniiril teiseks, järgmine aasta aga juba võitjaks. 

Live-pokkeris on Jaanus mänginud pigem väikseid turniire ning seetõttu on täna saavutatud 86. koht koos 3250-eurose auhinnarahaga mehe karjääri teadaolevalt suurim live-turniirivõit.

Player Chips Progress
Jaanus Kippel 0 0
Ermo kaotas miljonipanga Posted Friday 26th July, 2024 at 23:30(UTC+2) by maheaaatom

Kahjuks üks halb uudis lauast nr. 12.

Ermo Kosk callis Ignotas Tamasauskase all-in panust pärast lauas avatud kaarte

Ermo:

Ignotas:

River midagi ei muutnud, kõrgemad kaks paari pidasid. Ermo õnneks oli leedulasel kaks korda väiksem stäkk, kuid hiigelpank (1,1M) läks viimasele ning nüüd osad vahetusid. Ermol umbes 600K järgi.

Player Chips Progress
Ermo Kosk 600,000 550,000
Mariusele pisike stäkilisa Posted Friday 26th July, 2024 at 23:22(UTC+2) by maheaaatom

Marius Morel kugistas just alla ühe väikese stäki, kes kaitses oma blindi -ga. Mariuse tegi oodatult puhta töö.

97. koht Urmo Velvelt 3000 € Posted Friday 26th July, 2024 at 23:13(UTC+2) by maheaaatom

Maailmakuulsal netiässal Urmol oli alles ainult 5XBB ning sellega pidi ta loomulikult pressima. Kahjuks sattus Urmo 3-way panka, kus temale jäi vaid statisti osa. 

Tasuks 3000 € eurot, tema kohta tavaline buyin online-turniiridel. Aga küllap näeme Urmot juba homsel highrolleril.

Player Chips Progress
Urmo Velvelt 0 0
Miljonärid Posted Friday 26th July, 2024 at 23:07(UTC+2) by maheaaatom

Kaspar Kaisel ja Ermo Kosk on veel tõusnud ning hetkel tõenäoliselt eestlastest rikkaimad vastavalt 1,23M ja 1,15M stäkkidega. Mariusel on endiselt umbes miljoni kanti.

Player Chips Progress
Kaspar Kaisel 1,230,000 350,000
Ermo Kosk 1,150,000 500,000
Marius Morel 1,000,000 10,000
Igor lõhkab mulli Posted Friday 26th July, 2024 at 22:57(UTC+2) by maheaaatom

Lauas on ning all-in nii Igor Pihela noorem kui Nemo T. O. A. Israel.

Nemo:

Igor:

Seega - poisid ja potid. Ja poiss riverisse ka tuleb! Igoril nüüd 750K stäkk, tema lauas on aga Paul Koppel veel enam - 950K.

Palju õnne allesjäänud mängijatele - kõik on teeninud vähemalt 3000 eurot!

Player Chips Progress
Paul Koppe 950,000 770,000
Igor Pihela noorem 750,000 410,000
Mäng jätkub, täna veel kaks taset Posted Friday 26th July, 2024 at 22:47(UTC+2) by maheaaatom

Mullimäng läheb edasi, blindid on 5000/10000/10000.

Täna mängitakse veel kaks taset (2x60 min) või kuni mulli lõhkemiseni. Oleks muidugi täielik ime, kui mull varem ei lõhkeks, tõenäoliselt juhtub see õige pea.

Algas tänane viimane paus Posted Friday 26th July, 2024 at 22:25(UTC+2) by maheaaatom

Mängijad lubati 15 minutiks puhkama. Mull pole veel lõhkenud ning bubble-play jätkub pärast pausi.

Algas mullimäng Posted Friday 26th July, 2024 at 21:56(UTC+2) by maheaaatom

Mäng jätkub hand-by-hand, laudades on 104 mängijat. Kahjuks kaotasime enne mõned eestlased, nende seas päeva keskel ülihead stäkki omanud Kristjan Maasalu, ainsa konkurentsis püsinud Eesti naismängija Katariina Ingerma ning WSOP Circuit sõrmusekandja Aleksei Smirnovi.

On vähemalt üks 30K ja üks 50K stäkk. Nemad on ka esimesena sihikul.

P.S. Ülekandes võib esineda tõrkeid, kuna meil on tehnilisi probleeme. 

Player Chips Progress
Kristjan Maasalu 0 0
Andre Mägi 0 0
Aleksei Smirnov 0 0
Katariina Ingerma 0 0
Eestisse kaks cashi €250 NLH & PLO 4 & 5 Mix'ilt Posted Friday 26th July, 2024 at 21:52(UTC+2) by maheaaatom

Sellel kõrvalturniiril on selgunud 10 parimat ning eestlasi kahjuks nende seas pole.

12. koha sai Egon Kaljulaid ja 11. Erik Põlluveer (vastavalt 570 ja 650 eurot). Väike "Hendoni-cash" ikka :)

Viis kohta mullini Posted Friday 26th July, 2024 at 21:43(UTC+2) by maheaaatom

Mullimäng on suhteliselt lähedal ning pole kahtlust, et see täna ka lõhkeb. Veel viis mängijat ning kõikidele allesjäänutele on tagatud vähemalt 3000 eurot.

Lühike tehniline paus Posted Friday 26th July, 2024 at 21:27(UTC+2) by maheaaatom

Toimub telelaua vahetus ning turniirikell pandi korraks kinni.

Mariusel miljon koos Posted Friday 26th July, 2024 at 21:21(UTC+2) by maheaaatom

Marius Morel on tõusnud taas liidriks stäkiga, mis on tema väitel "üle miljoni". Noh, kui siis õige natuke.

Kaspar Kaisel on samuti miljonile lähenemas, tal ca. 880K. Kes on aga ära andnud, on Urmo Velvelt, kes peab saama hetkel hakkama vaid pisut enama kui 10XBB stäkiga.

112 mängijat järgi, blindid 4000/8000/8000.

Player Chips Progress
Marius Morel 1,010,000 330,000
Kaspar Kaisel 880,000 250,000
Steven Tool 630,000 130,000
Andre Villandberg 600,000 70,000
Mauri Dorbek 460,000 80,000
Mairo Tori 380,000 60,000
Markku Koplimaa 260,000 80,000
Urmo Velvelt 100,000 260,000
Pavel Solodovnikov 0 0
Steven Seller 0 0
Algas 250 € NLH turbo Posted Friday 26th July, 2024 at 21:08(UTC+2) by maheaaatom

Alanud on ka 250 € NLH ning laudades 43 mängijat. Eestlastest on võistlemas näiteks Priit Vanem ja tuntud naismängija Annemar Neiland.

Ermole kõva lisa Posted Friday 26th July, 2024 at 21:05(UTC+2) by maheaaatom

Ermo võitis oma lauas suure panga, callides pika mõtlemise järel ära Pasi Sormuneni 200K all-in panust kui lauas oli avatud 

Vastas polnud õnneks midagi enamat -st, Ermo võttis panga ilusti maha.

"Eks ma masti kartsin küll," tunnistab seitsmekordne Eesti pokkerimeister ka ise, kuid lisab, et panus ei vastanud tema hinnangul siiski mastile. Kogemused...

Ermol nüüd 650K. Üks eestlane kahjuks ka vähem - Steven Selleril ei õnnestunud oma shortstäkiga vajalikku duublit saada.

Player Chips Progress
Ermo Kosk 650,000 250,000
Andre annab valusa, kui õnneks väikse duubli Posted Friday 26th July, 2024 at 20:48(UTC+2) by maheaaatom

15. lauas on Andres Villandberg callimas Ali Kabiri Fari (80K) all-in'i.

Andre:

Ali:

Lauda brutaalne

Õnneks on Andrel niivõrd suur stäkk, et tema jaoks jätkub mäng endises taktis.

Tempo on all Posted Friday 26th July, 2024 at 20:36(UTC+2) by maheaaatom

Mullini on 20 kohta ning kuna keskmine stäkk on 55XBB, on tempo suhteliselt all - mängitakse väikseid panku ning midagi olulist juhtunud pole. Kõik eelnevalt mainitud eestlased on endiselt kenasti sees.

Kõrvalactionit Posted Friday 26th July, 2024 at 20:24(UTC+2) by maheaaatom

1 100 € NLH Mystery Bounty'l on tehtud juba 179 sisseostu, kuid action veel võrdlemisi noor.

SVITEN on juba üle tunni kestnud ning tehtud on 63 sisseostu. Mängijaid on kõikjalt, ka viis-kuus eestlast.

250 € NLH & PLO 4 & 5 Mix turniiri lõplikuks sisseostude arvuks jääb 119 ning hetkel on mängus 23 parimat, nende seas ka kaks eestlast.

Kes tahavad mängida "tavalist" ja võrdlemisi odavat pokkerit, on oodatud kell 21:00 algavale 250 € NLH Turbo, 8-handed turniirile, mis on ka tänane viimane kõrvalturniir.

Stäkkide seis Posted Friday 26th July, 2024 at 20:18(UTC+2) by maheaaatom

Tuntud ässadest on väljas Norra pokkerimiljonär Jon Kristian Kyte, eestlasi õnneks vahepeal langenud ei ole. Suurima stäkiga peaks meie omadest olema Kaspar Kaisel umbes 850K-ga.

Jätkab 127 parimat, seega on mullini veel 24 kohta. Hetkel 18. tase ja blindid 3000/6000/6000

Player Chips Progress
Kaspar Kaisel 850,000 220,000
Marius Morel 680,000 120,000
Andre Villandberg 530,000 40,000
Steven Tool 500,000 250,000
Mairo Tori 440,000 50,000
Jaanus Kippel 400,000 90,000
Ermo Kosk 400,000 80,000
Mauri Dorbek 380,000 90,000
Martin Piik 370,000 10,000
Urmo Velvelt 360,000 40,000
Igor Pihela noorem 340,000 120,000
Markku Koplimaa 340,000 10,000
Risto Pärnat 320,000 20,000
Ermo kaotab väikese panga, Igor võtab duubli Posted Friday 26th July, 2024 at 19:05(UTC+2) by maheaaatom

Edoardo Mancinelli avab 10K tõstega, Ermo Kosk tõstab positsioonilt üle 32K ning saab calli.

Flop: .

Itaallane checkib ning callib Ermo 11K panust.

Turn on ning Edoardo check-callib taas meie mehe 16K panust.

River checkitakse läbi, itaallane abav ning Ermo muckib koheselt.

Paar lauda eemal õnnestub Igor Pihela nooremal oma stäkk -ga vastu duublisse saada. Seda hitti oli kindlasti vaja.

Ühtlasi on käes aeg õhtusöögipausiks ning me oleme tagasi kell 20:00. 

Player Chips Progress
Tauno Pajula 0 0
Mairo ja Andre sõdivad blindidel Posted Friday 26th July, 2024 at 18:52(UTC+2) by maheaaatom

Mairo Tori ja Andre Villandberg vaatavad blindidel floppi

Mairo checkib ette, Andre paneb 30K ning saab Mairolt 80K ületõste. Andrelt call.

Turn ning river checkitakse läbi. 

Piisab Andrel oma avada, kui Mairol lehed lendavad kiirelt mucki. 

Mairol 390K järgi, kuid Andrel juba 570K.

Player Chips Progress
Andre Villandberg 570,000 477,000
Mairo Tori 390,000 236,000
Naxeri stäkk sulas kokku Posted Friday 26th July, 2024 at 18:39(UTC+2) by maheaaatom

Marko Keskel ei suutnud oma stäkiga siiski imesid teha ning on paraku mängust väljast. Aga 22 euro eest oli mängurõõmu kindlasti piisavalt. Muidugi - mulli oleks ju võinud ka ikkagi üle elada...

Jätkab 143 parimat, keskmine stäkk on kerkinud 57XBB peale. Paarkümmend eestlast on veel mängus ning õnneks on nii mõnelgi neist üsna pirakad stäkid.

Player Chips Progress
Marko Keskel 0 0
Sergei Kuznetsov 0 0
Martin Zobel 0 0
Veel eestlaste stäkke Posted Friday 26th July, 2024 at 18:26(UTC+2) by maheaaatom

Väga korraliku stäki on ajanud kokku Kaspar Kaisel, kes ka alustas tänast päeva heast seisust.

Jätkab 151 parimat, mullini on 48 kohta. Täna see kindlasti ka lõhkeb, kuid aega veel on.

Player Chips Progress
Kaspar Kaisel 630,000 362,500
Risto Pärnat 340,000 169,000
Jaanus Kippel 310,000 79,500
Aleksei Smirnov 260,000 10,000
Steven Tool 250,000 0
Igor Pihela noorem 220,000 20,000
Artur Külanurk 210,000 93,000
Paul Koppe 180,000 88,500
Martin Keskküla 160,000 83,500
Katariina Ingerma 130,000 49,000
Alari Arnover 0 0
Rene Peterkopf 0 0
Marius juhib turniiri Posted Friday 26th July, 2024 at 18:12(UTC+2) by maheaaatom

Suurima stäkiga mängija peaks praeguse seisuga olema meie oma Marius Morel, kel umbes 800K punkti. 

Mairo Tori on suuruselt neljas (626K), Kristjan Maasalu kuues (610K) ning Mauri Dorbek kümnes (470K).

Player Chips Progress
Marius Morel 800,000 0
Mairo Tori 626,000 14,000
Kristjan Maasalu 610,000 10,000
Mauri Dorbek 470,000 50,000
VIDEO: Kuidas mängida Svitenit? Posted Friday 26th July, 2024 at 18:09(UTC+2) by maheaaatom

Kell 19:00 algab järgmine kõrvalturniir, 250 € sisseostuga SVITEN (Five Card PLO & Draw). Tegemist on (nagu nimigi ütleb) rootslaste mänguga ning kes sobiks seda mängu veel paremini selgitama kui Rootsi meister Peter La Terra.

Tarmo Tammelil on olnud paremaid päevi Posted Friday 26th July, 2024 at 18:06(UTC+2) by maheaaatom

Eesti GPI edetabeli liider, tuntud turniirihai Tarmo Tammel on kahjuks mängust väljas. 

Tarmol (alustas päeva 89 500 punktiga) ei olnud väga stäkki ega ka erilisi võimalusi selle suurendamiseks.

Player Chips Progress
Tarmo Tammel 0 0
Kaardid taas õhus Posted Friday 26th July, 2024 at 18:03(UTC+2) by maheaaatom

Paus venis tehnilistel põhjustel natuke pikemaks, kuid nüüd mäng jätkub ning laudades on 166 pokkerisportlast. Välja on langenud Anton Markachev ja Timmo Kaha.

17. tase vältab juba tunni ning selle järel algab tund aega kestev õhtusöögipaus.

Blindid 2000/5000/5000, kesmine stäkk ligi 50XBB.

Player Chips Progress
Timmo Kaha 0 0
Anton Markachev 0 0
Urmo edeneb, "Naxer" paraku mitte Posted Friday 26th July, 2024 at 17:38(UTC+2) by maheaaatom

Urmo Velvelt on tõusnud 400K peale, Mairo Tori natuke ära andnud (640K). 

Marko "Naxer" Keskel, kes lubas, et alla 30XBB ta ei lange, on hetkel mängus umbes 15XBB stäkiga. Ju siis pole mees kogenud sobivat kaardijooksu või siis leidnud ühtegi head kohta, kust lükkama minna.

Kahjuks on väljas nii Marita Mägi kui Eesti rahalisti nr. 1 Ilya Nikiforov.

Põhiturniir saadeti järjekordsele pausile, mis on seekord 15 minutit.

Player Chips Progress
Mairo Tori 640,000 60,000
Urmo Velvelt 400,000 100,000
Martin Piik 380,000 20,000
Markku Koplimaa 330,000 10,000
Marita Mägi 0 0
Ilya Nikiforov 0 0
Marita ja Tarmo üritavad ellu jääda Posted Friday 26th July, 2024 at 17:20(UTC+2) by maheaaatom

Kiita pole ei Marita Mägi ega Tarmo Tammeli stäkk. Marita on siiski püsinud üsna pikalt 100K peal, mis on 25XBB ja annab siiski teatavat mänguruumi. "Kaarte pole aga üldse, tavaline on ," naeratab Marita mõrumagusalt.

Tarmo Tammelil on umbes 60K alles ning sellega pole samuti pikka pidu. Aga Tarmo on väga kannatlik ja ootab õiget kohta, lugedes tähelepanelikult igat jaotust.

175 mängijat alles, blindid 2000/4000/4000 (tase 16).

Player Chips Progress
Marita Mägi 100,000 0
Tarmo Tammel 60,000 20,000
Vladislav Ogorodnik 0 0
400K pank Mariusele Posted Friday 26th July, 2024 at 17:07(UTC+2) by maheaaatom

12. lauas oli pärast lauas avatud all-in Soome lipu all võistlev Mihn Thang Ngo.

Pangas oli juba tubli 170K ning Ngo all-in panus pisut üle saja tuhande. Mariuselt call.

Ngo:

Marius:

Umbes 400K pank meie mehele, kel nüüd ca. 800K. See on juba kõva väljakutse. 

Eestlastest väljas noor kahur Hendrik Uibo, kelle tähelend algaski suuresti just mullusel WSOP Circuit põhiturniiril.

Player Chips Progress
Marius Morel 800,000 450,000
Hendrik Uibo 0 0
Kohe algab 1100-eurone sõrmuseturniir Posted Friday 26th July, 2024 at 16:57(UTC+2) by maheaaatom

Loetud minutite pärast läheb käima 1 100 € NLH Mystery Bounty, mis on arvult kaheksas sõrmuseturniir. See turniir on kahepäevane ning täna mängitakse kuni rahakohtadeni.

Kristjanil käis jõuluvana külas Posted Friday 26th July, 2024 at 16:53(UTC+2) by maheaaatom

Vahetult enne pausi oli üks 300K stäkk Kristan Maasalu lauas lammutama kukkunud ning kõik meie mehele maha mänginud. Kristjanil on ka hetkel alles 600K stäkk, mis on kolmekordne keskmine ning väga kõva sõna.

Eriti hästi edeneb mulluse põhiturniiri viies mees Mairo Tori, kel lausa 700 000 punkti. Aga kurta pole ka Martin Piigi ka Mauri Dorbeku stäkid.

Player Chips Progress
Mairo Tori 700,000 421,500
Kristjan Maasalu 600,000 440,500
Mauri Dorbek 420,000 34,000
Martin Piik 400,000 127,000
Ermo Kosk 320,000 143,500
Aleksei Smirnov 250,000 120,000
Herli üheksatega väljas Posted Friday 26th July, 2024 at 16:43(UTC+2) by maheaaatom

Herli Olopi tänane kaardijooks oli kõike muud kui kiita, oma väikese 30K stäkiga oli ka raske tühjalt kohalt duubleid otsida. Viimaks õnnestus see siiski saada.

Kohe järgmises käes jagati Herlile üheksad ja neile tuli call -lt. 

Flopis numbripuru ja Herli juba mõtles, et siit hakkab võib-olla uus tähelend. Riveris paraku äss.

"Tase on ikka üsna tugev. Tõsi-satelliitidel käib täiesti suvaline lammutamine," muljetas Herli.

Väljas ka Richard Koppel ja Hanna Heinlo. Alles 200 parimat.

Player Chips Progress
Hanna Heinlo 0 0
Richard Koppel 0 0
Herli Olop 0 0
Turniiri võitja teenib 193 750 eurot Posted Friday 26th July, 2024 at 16:19(UTC+2) by maheaaatom

Lõplik auhinnafond on 1 052 352 eurot, sisseoste kogunes 812. Tegemist on seega suurima turniiriga, mis toimunud Olympic Park Casinos, kuigi mitte päris suurima auhinnafondiga turniiriga Eestis. 

Turniiri võitjat premeeritakse 193 750 euroga, kuigi ei saa välistada, et parimad sõlmivad omavahel diili nagu ka juhtus möödunud aastal. Min-cash on täna 3000 eurot ehk kahte bulletit kasutanud mängijad saavad täpselt oma raha tagasi.

Veel kolm eestlast out, nende seas ka high-roller Igor Pihela vanem.

Player Chips Progress
Riho Sagor 0 0
Egon Norden 0 0
Igor Pihela vanem 0 0
VIDEO: 7. päeva kokkuvõte Posted Friday 26th July, 2024 at 16:09(UTC+2) by maheaaatom

Algas tänane esimene kõrvalturniir Posted Friday 26th July, 2024 at 16:08(UTC+2) by maheaaatom

Just läks käima €250 NLH & PLO 4 & 5 Mix, esialgu 31 mängijaga. Liituda saab kuni kella 18:30-ni.

NB! Kohe saab hakata jälgima ka põhiturniiri TV-ülekannet. Telelauas Eesti rahalisti esinumber Ilya Nikiforov ning meie naismängija Kateriina Ingerma.

Telelaua vaatamiseks kliki siia!

Ermo ampsas ühe väiksema stäki Posted Friday 26th July, 2024 at 16:03(UTC+2) by maheaaatom

Vilius Maniusis avas UTG-lt tõstega, misjärel läks väikese stäkiga Ritvars Cekalins keskelt all-in ning sama tegi ka tema järel istuv Ermo Kosk, kelle stäkk polnud samuti kuigi suur. Kõik teised mängijad foldisid.

Ritvars:

Ermo:

Laud pidas ning Ermole vajalik lisa.

Eestlastest kahjuks väljas kaks väga nimekat ässa: Ranno Sootla ja Taago Tamm.

Player Chips Progress
Ranno Sootla 0 0
Taago Tamm 0 0
Lõplikult langenud eestlased Posted Friday 26th July, 2024 at 15:48(UTC+2) by maheaaatom
Player Chips Progress
Priit Oja 0 0
Meelis Ahman 0 0
Priit Parmasto 0 0
Aleksandr Geller 0 0
Ranel Käsi 0 0
Rasmus Sepping 0 0
Madis Ormisson 0 0
Nadezda Guk 0 0
Vadim Guk 0 0
Stanislav Smeljov 0 0
Kaido Mikk 0 0
Dmitri Damaskin 0 0
Kris Tikka 0 0
Hanno Kerem 0 0
Jako Kuusik 0 0
Jargo Alaväli 0 0
Tanel Evert 0 0
Tanel Merida 0 0
Georgi Abuladze 0 0
Magnus Pukk 0 0
Anton Konnov 0 0
Andrei Mjagkov 0 0
Eestlaste jutunurgast Posted Friday 26th July, 2024 at 15:39(UTC+2) by maheaaatom

Steven Seller on tõusnud 230K peale, Mauri Dorbekul korralik 386K. Alles täna mänguga liitunud Urmo Velvelt on leidnud kiire hiiteri ning temal ka juba 300K. 

Väike tänukõne OlyBeti ja Olympic Casino pokkerimänedžerilt ning turniir jätkub. Esialgse info põhjal on auhinnafondis 1049760 eurot ning tehti 810 sisseostu. Alles on 249 parimat, jätkame blindidega 1500/3000/3000.

Player Chips Progress
Mauri Dorbek 386,000 334,000
Urmo Velvelt 300,000 0
Steven Seller 230,000 196,500
"Naxer" ei kavatse tiksuma hakata Posted Friday 26th July, 2024 at 15:09(UTC+2) by maheaaatom

Marko Keskel on omajagu ära andnud ning tal kuskil 120K alles, mis on 40XBB.

"Ma ei kavatse alla 30XBB kukkuda, nii pole mängida mõtet," avaldab "Naxer" ning kurdab seejärel, et premium käsi pole täna üldse olnud. Aga loodetavasti toob edu julge ning kartmatu mäng, mis on "Naxeril" varemgi tulu toonud.

Mängijad hakkavad pausile minema, oleme tagasi 20 minuti pärast.

Viimase kolm re-entry kätt Posted Friday 26th July, 2024 at 15:03(UTC+2) by maheaaatom

Kuulutati välja viimased kolm re-entry kätt, mille jooksul on veel lubatud "paugutada). Siis on "pidu" läbi ning pärast pausi algab tõsine mäng.

Rahabosse pidavat kuuldavasti päris palju mängima, seega võime veel oodata auhinnafondi olulist paisumist.

Ilyal 130K Posted Friday 26th July, 2024 at 14:43(UTC+2) by maheaaatom

Põhiturniirist võtab osa ka Eesti rahalisti liider, nimekas high-roller Ilya Nikiforov. 

Mees alustas päeva vaid 47K stäkiga, kuid on oluliselt juurde saanud ning hetkel on tal 130K.

Käimas on viimane re-entry eelne mängutase (20 minutit pausini), blindid 1500/3000/3000. Kui peaks nihu minema, on veel võimalus end 1500 euroga mängu osta ning saada selle eest 50 000 punkti.

Player Chips Progress
Ilya Nikiforov 130,000 83,000
Marita mustad kuningad Posted Friday 26th July, 2024 at 14:32(UTC+2) by maheaaatom

Marita sai väga lubava pocket käe ning tema 15K tõstega läks kaasa laua chipliider.

Lauas avati punased numbrid ning Marita panuse peale läks vastane all-in, mida Marita callima ei hakanud. Sinna läks omajagu stäkk, Marital nüüd umbes 100K järgi.

Samas lauas ka Paul Koppe umbes 180K punktiga.

Player Chips Progress
Marita Mägi 100,000 38,500
Auhinnagarantii on ületatud! Posted Friday 26th July, 2024 at 14:20(UTC+2) by maheaaatom

Hea sõnum kõikidele allesjäänud mängijatele: turniiri auhinnagarantii miljon eurot on ületatud! Prognoositakse, et see võib tõusta kuni 1,05 miljonini.

Täna mängitakse 11 taset Posted Friday 26th July, 2024 at 14:16(UTC+2) by maheaaatom

Täna on plaanis mängida 11 taset, mille vahele mahub ka tunnine õhtusöögipaus. Seega peaks mäng kestma umbes kella 23:30-ni.

Marius Morel tõusulainel Posted Friday 26th July, 2024 at 14:15(UTC+2) by maheaaatom

Mariuse käsi on käinud täna väga kenasti, tal hetkel juba ca. 350K. Ja Marius näitab aktiivset ning agressiivset pokkerit.

Markku Koplimaa on samuti lisa saanud, tal umbes 320K. Rahul on ka põhiturniirile vaid 22-eurosele satelliidilt kvalifitseerunud Marko "Naxer" Keskel, kellel umbes 230K. Selgetes raskustes on Tarmo Tammel, kes langenud vaid 40K peale.

Eesti naistest ka. Martinast me juba rääkisime. Hanno Heinlol on umbes 100K (on seega juurde saanud), Katariina Ingermal on 40K, Ave Lepik on kahjuks väljas.

Player Chips Progress
Marius Morel 350,000 207,500
Markku Koplimaa 320,000 70,000
Marko Keskel 230,000 50,000
Aleksei Smirnov 130,000 3,000
Hanna Heinlo 100,000 32,000
Tarmo Tammel 40,000 49,500
Ave Lepik 0 0
Käimas ka 1100 € NLH satelliit Posted Friday 26th July, 2024 at 14:00(UTC+2) by maheaaatom

Fuajees on juba tund aega käinud 80-eurose sisseostuga 1100 € sõrmuseturniiri satelliit (algab kell 17:00). Auhinnagarantiiks on 3 piletit, kuid tõenäoliselt see selgelt ületatakse, sest hetkel on tehtud juba 126 sisseostu. 

Osalejate seas on ka rida eestlasi eesotsas Priit Ojaga, kes kohe mängu alguses põhiturniirilt bad beadiga välja langes.

 

Ermo: Eile oli väga mängitav, täna nats raskem Posted Friday 26th July, 2024 at 13:48(UTC+2) by maheaaatom

Seitsmekordne Eesti meister Ermo Kosk kiitis avapäeva, mille tase oli olnud vägagi "mängitav", kuid täna olevat juba raskem. Nuppe on siiski piisavalt järgi.

Päeva vaid 26K pealt alustanud Meelis Ahman on "ohutsoonist" väljas, tal hetkel 104K.

Algas 13. tase (1000/2500/2500) ning meil on veel mängida tund ja 20 minutit kuni re-entry perioodi lõpuni.

Player Chips Progress
Meelis Ahman 104,000 78,000
Uudiseid rindelt Posted Friday 26th July, 2024 at 13:24(UTC+2) by maheaaatom

Päeva suuruselt kolmanda stäkiga alustanud Martin Piik on natuke ära andnud, tal 273K järgi.

Mõlemal Igor Pihelal on ca. 200K (seega on noorem Igor päris korralikult juurde saanud). Marko "Naxer" Keskelil on pisut vähem. 

Mairo Tori alustas päeva seitsmendalt kohalt (278 500) ning umbes sama palju on tal ka praegu.

Kehvasti on läinud Herlil, kes on langenud 121K pealt vaid 30K peale, mis on 12XBB. "Kaart lihtsalt ei jookse. Muidu makstakse siin lauas küll kõik asjad välja," mainib Herli.

Algas ka tänane esimene paus 20 minutit.

Player Chips Progress
Martin Piik 273,000 43,500
Igor Pihela vanem 210,000 22,500
Igor Pihela noorem 200,000 66,000
Marko Keskel 180,000 9,000
Herli Olop 30,000 91,000
Kas garantii ületatakse? Posted Friday 26th July, 2024 at 13:10(UTC+2) by maheaaatom

On igati reaalne, et tänavu ületatakse 1M eurone auhinnagarantii (mullu tekkis väike overlay). 

Avapäevade osaleje arv oli järgmine: 1A (132 mängijat), 1B (25 mängijat), 1C (155 mängijat), 1D (30 mängijat), 1E (274 mängijat) ja 1F (77 mängijat). Mida see näitab? Mängu võetakse ikka päris tõsiselt ning valdav enamus mängijaid eelistab päevaseid "normaalpäevi" õhtustele turbodele. 

Markku ja Marita Posted Friday 26th July, 2024 at 13:06(UTC+2) by maheaaatom

Fuajeelauas istuvad kõrvuti Markku Koplimaa ning Marita Mägi. 

Markku on 195K pealt 250K peale tõusnud, kohe alguses õnnestus tal saada üks pank kätte just Marita vastu. 

Aga Marita seis pole ka kurta. Ta alustas päeva 183 500 punktiga ning kuigi alguses läks sellest pea neljandik Markkule, on Marita vaikselt nuppe tagasi korjanud ning hetkel samas seisus, mis päeva alguses.

Player Chips Progress
Markku Koplimaa 250,000 54,500
Infoks flipisõpradele Posted Friday 26th July, 2024 at 12:53(UTC+2) by maheaaatom

Turniiride pauside ajal käivad fuajees tavapärased flipid, millega on võimalik hea õnne korral erinevaid turniiripileteid (näiteks põhiturniiri omi) saada. 

See on juba õnnestunud 15 mängijal ning kõik need on võitnud koha ka laupäeval kell 11:30 toimuvale tasuta megaflipile, kus üks õnnelik mängija saab auhinnaks oktoobris toimuva Kings of Tallinn 2024 Autumn Edition põhiturniiri paketi.

Tanel bad beadiga väljas Posted Friday 26th July, 2024 at 12:41(UTC+2) by maheaaatom

Viiendast lauast tõusis just püsti Tanel Evert, kes alustas päeva 48 500 punktiga (suht võrdväärne algstäkiga), kuid langes juba esimesel tasemel pocket ässadega pocket kaheksate vastu. Kaheksa lauas, mis muud...

Tanel ei plaani mängu naaseda.

Mänguruumi nagu on? Posted Friday 26th July, 2024 at 12:37(UTC+2) by maheaaatom

Hetkel on keskmine stäkk 115 313 punkti, mis on pea 60XBB ning liiga palju tormamist seetõttu veel ei ole. 

Laudades on 320 mängijat ning nii suur saal kui fuajee on mängijaid paksult täis. Tõenäoliselt ei muuta väga midagi enne re-entry perioodi lõppu, sest kes juba mängima tulnud on, teeb seda hingega.

Ja mis on täna tulemas? Posted Friday 26th July, 2024 at 12:29(UTC+2) by maheaaatom

Põhifookus on mõistagi põhiturniiri teisel päeval, kuid lisaks saab reedel kell 17:00 alguse ka 1100 € NLH Mystery Bounty (Ring Event #8), mille avapäev mängitakse kuni rahadeni.

Lisaks on kavas kolm kõrvalturniiri

– 250 € NLH & PLO4&5 Mix (kell 16:00),

- 250 € PL Sviten (kell 19:00) ja

- 250 € NLH Turbo 8-max (kell 21:00).

Päeva lõpetab kell 23:00 algav 150-eurose sisseostuga high-rolleri satelliit, mille auhinnagarantiiks on kolm 3000-eurost piletit.  

Eilse päeva kokkuvõte Posted Friday 26th July, 2024 at 12:27(UTC+2) by maheaaatom

Neljapäeval leidis oma lõpplahenduse WSOP Circuit Tallinn 1100-eurose sisseostuga PLO 4&5 turniir, mille võitis soomlane Riku Matias Koivurinne. Järjekorras seitsmendale sõrmuseturniirile tehti 198 sisseostu ning selle auhinnafond oli tubli 190 800 eurot. 

Finaali kindla liidrina alustanud norralane Jan Roger Holte jäi teiseks ning Lars Myklegard Romundstad (mõlemad mehed siis  Norrast). Eestlased kahjuks keegi ei cashinud. 

Neljast kõrvalturniirist oli suurima auhinnafondiga 555 € NLH Deepstack (172 sisseostu), mille võitis leedulane Andrius Bielskis. 226 sisseostuga 150 € NLH DeepStacki võitis Soomet esindav Xuan Truc Tran, 148 sisseostuga 250 € PLO4&5 Hi-Lo rootslane Björn Stefan Lindberg ning 194 sisseostuga PLO 4&5 Norra pokkerimängija Tarjei Forus. Viimasel saavutas Marius Morel kolmanda koha, mis oli kahjuks ka eilne ainuke pjedestaalikoht eestlastele. 

Mäng on alanud Posted Friday 26th July, 2024 at 12:18(UTC+2) by maheaaatom

Kaardid ja mängijad on laudades ning teine päev alanud.

Kohal 328 pokkerisportlast, kokku on sisseoste kogunenud juba 720. On ka täna "nullist" alustajaid, nende seas näiteks mulluse Kings of Tallinn põhiturniiri tšempion Priit Parmasto.

Player Chips Progress
Priit Parmasto 50,000 0
12:13 (UTC+2)
Day 2 of Olympic Park Casino Started
Level:      Blinds: 0/0     Ante: 0
WSOP Circuit Tallinn põhiturniiri live-blogi alustab kell 12:00 Posted Thursday 25th July, 2024 at 11:51(UTC+2) by maheaaatom

Reedel kell 12:00 algab käimasoleva pokkerifestivali tähtsaima, 1M auhinnagarantiiga WSOP Circuit põhiturniiri teine päev. Meie live-blogi kestab kuni finaallauani (eeldusel, et konkurentsis on vähemalt üks eestlane). Hetkel on neid mängus 66, kokku on mängijaid 305.

Hiline registeerumine kestab kuni umbes 15:20-ni.


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.