0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0064 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-10-05'
AND `url` = 'https://www.maineventtravel.com/live-reporting/888pokerTallinn'
ORDER BY `views` DESC
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.0001 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.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0003 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0064 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` = '888pokerTallinn'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '5'
0.0257 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '13'
AND `published` = 1
0.0257 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '14'
AND `published` = 1
0.0258 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0054 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '15'
AND `published` = 1
0.0259 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '16'
AND `published` = 1
0.0256 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0053 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '17'
AND `published` = 1
0.0054 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '17'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '5'
AND `name` = '3'
0.0057 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '17'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 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` = '17'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '830'
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` = '829'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '828'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '827'
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` = '826'
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` = '825'
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` = '824'
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` = '823'
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` = '822'
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` = '821'
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` = '820'
ORDER BY `chip_change` DESC, `busted` ASC
0.0105 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '819'
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` = '818'
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` = '817'
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` = '815'
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` = '814'
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` = '813'
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` = '812'
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` = '811'
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` = '810'
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` = '809'
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` = '808'
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` = '807'
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` = '806'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '805'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '804'
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` = '803'
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` = '802'
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` = '801'
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` = '800'
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` = '799'
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` = '798'
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` = '797'
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` = '796'
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` = '795'
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` = '794'
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` = '793'
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` = '792'
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` = '791'
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` = '790'
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` = '789'
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` = '788'
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` = '787'
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` = '786'
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` = '785'
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` = '784'
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` = '783'
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` = '782'
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` = '781'
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` = '780'
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` = '779'
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` = '778'
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` = '777'
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` = '776'
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` = '775'
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` = '774'
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` = '773'
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` = '772'
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` = '771'
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` = '770'
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` = '769'
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` = '768'
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` = '767'
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` = '766'
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` = '765'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '13'
ORDER BY `busted` ASC, `current_chips` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '14'
ORDER BY `busted` ASC, `current_chips` DESC
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '16'
ORDER BY `busted` ASC, `current_chips` DESC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '17'
ORDER BY `busted` ASC, `current_chips` DESC
0.0051 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` = '17'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '830'
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` = '829'
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` = '828'
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` = '827'
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` = '826'
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` = '825'
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` = '824'
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` = '823'
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` = '822'
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` = '821'
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` = '820'
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` = '819'
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` = '818'
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` = '817'
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` = '816'
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` = '815'
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` = '814'
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` = '813'
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` = '812'
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` = '811'
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` = '810'
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` = '809'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '808'
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` = '807'
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` = '806'
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` = '805'
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` = '804'
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` = '803'
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` = '802'
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` = '801'
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` = '800'
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` = '799'
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` = '798'
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` = '797'
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` = '796'
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` = '795'
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` = '794'
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` = '793'
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` = '792'
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` = '791'
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` = '790'
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` = '789'
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` = '788'
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` = '787'
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` = '786'
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` = '785'
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` = '784'
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` = '783'
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` = '782'
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` = '781'
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` = '780'
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` = '779'
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` = '778'
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` = '777'
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` = '776'
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` = '775'
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` = '774'
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` = '773'
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` = '772'
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` = '771'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '770'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '769'
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` = '768'
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` = '767'
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` = '766'
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` = '765'
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` = '17'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 1508
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
Day 3 of 888poker LIVE Tallinn Festival 2020 Ended Level: 25 Blinds: 20,000/40,000 Ante:
Edijs Laugals Wins the 888poker LIVE Tallinn Main Event Posted Sunday 6th September, 2020 at 20:14(UTC+3) by Jason Glatzer
After three days of play, Latvia's Edijs Laugals bested a field of 91 entrants to win the 888poker LIVE Tallinn €888 Main Event for €19,982.
Laugals is an experienced pro with a few previous victories to his name including at an EPT side event and faced a tough field on his way to victory in this week's Main Event.
"I am very happy with the win," Laugals said after the event.
Place
Player
Country
Prize
1
Edijs Laugals
Latvia
€19,982
2
Mark Metsla
Estonia
€13,550
3
Mikael Demirors
Sweden
€10,340
4
Neeme Org
Estonia
€7,130
5
Aleksandr Arutjunov
Estonia
€5,350
6
Ricardo De La Rosa Moran
Spain
€3,740
7
Youssef Issa Ward
Estonia
€3,030
8
Siim Sooaar
Estonia
€2,500
9
Guillaume Diaz
France
€2,140
The final day began with nine hopefuls in search of winning the coveted 888poker LIVE trophy. Sweden's Mikael Demirors entered the final table with the chip lead with Laugals, who bagged the Day 1b chip lead, entering today's action as one of the shorter stacks.
It seemed early on that this would be Demirors' day as he was steamrolling over the competition early on at the final table including elimination French pro Guilliame Diaz in ninth place for €2,140 and Estonia's Siim Sooaar in eighth place for €2,500.
Laugals was almost eliminated in eighth place instead of Sooaar but his pocket fives got their against the eights held by Youssef Issa Ward.
The lead bounced over to Mark Metsla, the first of many lead changes during the final table.
It appeared likely that Estonia's Neeme Org would exit in seventh place as he lost a hand that brought him down to less than two big blinds. But he got there with ace-nine against the ace-jack suited held by Demirors to avoid elimination. Ward was also in this hand with ace-deuce and he hit the door in seventh instead of Org to collect €3,030.
Org hung around as two more players got eliminated with Spain's Ricardo De La Rosa Moran taking sixth place for €3,740 and Aleksandr Arutjunov, who entered the final table with the shortest stack, exiting in fifth place for €5,050.
Org continued to build up his stack but subsequently bleeded some chips before he was eliminated by Demirors (fourth - €7,130) when his queen-jack didn't get there against his opponent's king-trey suited.
At this point, Demirors had more than half the chips in play but Metsla managed to get the lead back from the Swede.
Metsla extended his lead further after his big slick held against the eight-five by Demirors to eliminated his opponent in third place for €10,340.
Metsla began heads-up play with a more than 4:1 chip advantage against Laugals. Laugals chipped away and eventually had the chip lead before gaining a more than 4:1 chip advantage himself.
The final hand was a bit of a cooler for Metsla as he held premium hand in heads-up play in pocket tens. He three-bet jammed over the king-queen held by Laugals and got a call. Laugals nailed two kings on a flop and improved even further to a full house to eliminated Metsla in second place for €13,550.
Congrats to Edijs Laugals for winning the 888poker LIVE Tallinn Main Event, which comes with a trophy along with the €19,982 top prize.
There are still a handful of side events running but this is a wrap of our coverage at Main Event Travel.
Final Table Payouts Posted Sunday 6th September, 2020 at 19:44(UTC+3) by Jason Glatzer
Place
Player
Country
Prize
1
Edijs Laugals
Latvia
€19,982
2
Mark Metsla
Estonia
€13,550
3
Mikael Demirors
Sweden
€10,340
4
Neeme Org
Estonia
€7,130
5
Aleksandr Arutjunov
Estonia
€5,350
6
Ricardo De La Rosa Moran
Spain
€3,740
7
Youssef Issa Ward
Estonia
€3,030
8
Siim Sooaar
Estonia
€2,500
9
Guillaume Diaz
France
€2,140
Mark Metsla Eliminated in 2nd Place (€13,550) Posted Sunday 6th September, 2020 at 19:43(UTC+3) by Jason Glatzer
The 888poker LIVE Tallinn Main Event is in the books after Metsla was unable to win one last flip.
Edijs Laugals opened to 90,000 with from the button before he called a three-bet jam to 868,000 by Metsla with .
Metsla's small edge in the hand disappeared after his opponent hit trips on the flop. The on the turn was of no help to Metsla and he was eliminated in second place for €13,550 after the double paired the board to give Laugals a full house.
Meanwhile, congrats to Edijs Laugals for winning the 888poker LIVE Tallinn Main Event for €19,982.
Stay tuned for a recap of the 888poker Tallinn LIVE Main Event.
Player
Chips
Progress
Edijs Laugals
2,730,000
930,000
Mark Metsla
0
0
Metsla Winning Small Pots Posted Sunday 6th September, 2020 at 19:38(UTC+3) by Jason Glatzer
Mark Metsla has won a few smaller pots and has cut into the chip lead of Edijs Laugals.
Player
Chips
Progress
Edijs Laugals
1,800,000
300,000
Mark Metsla
900,000
300,000
19:36 (UTC+3)
Start of Level 25 Blinds: 20,000/40,000 Ante:
Small Ball Pots for Laugals Posted Sunday 6th September, 2020 at 19:14(UTC+3) by Jason Glatzer
Edijs Laugals won a few smaller pots and has extended his chip lead.
Player
Chips
Progress
Edijs Laugals
2,100,000
300,000
Mark Metsla
600,000
300,000
Metsla Folds Big Slick on the River Posted Sunday 6th September, 2020 at 19:08(UTC+3) by Jason Glatzer
Mark Metsla opened to 70,000 from the button with and got a call from Edijs Laugals.
Both players checked the flop before Laugals fired out for 100,000 after the came on the turn.
Laugals then fired out for 250,000 after the paired the board on the river and Metsla snap-folded.
Player
Chips
Progress
Edijs Laugals
1,800,000
100,000
Mark Metsla
900,000
100,000
Top Pair Good for Laugals Posted Sunday 6th September, 2020 at 19:03(UTC+3) by Jason Glatzer
Mark Metsla opened for 70,000 with on the button and was called by Edijs Laugals with .
Both players flopped a pair after the came on the flop but Laugals flopped a better pair. Laugals check-called a bet of 75,000 from Metsla.
Laugals then check-called a larger bet of 205,000 after the came on the turn.
The completed the board on the river. Both players checked and Laugals had the chip lead after the hand.
Player
Chips
Progress
Edijs Laugals
1,700,000
300,000
Mark Metsla
1,000,000
400,000
Stacks Even Up Posted Sunday 6th September, 2020 at 18:59(UTC+3) by Jason Glatzer
Edijs Laugals opened the button for 65,000 with and was called by Mark Metsla with .
Metsla check-called a bet of 70,000 after the came on the flop. Both players checked after the came on the turn.
The completed the board on the river. Metsla checked again before Laugals fired out big for 170,000. Metsla went into the tank before he made the call.
Both players had a pair but Laugals rivered top pair to win the hand.
Player
Chips
Progress
Edijs Laugals
1,400,000
300,000
Mark Metsla
1,400,000
300,000
18:51 (UTC+3)
Start of Level 24 Blinds: 15,000/30,000 Ante:
Third Break Posted Sunday 6th September, 2020 at 18:37(UTC+3) by Jason Glatzer
Players are on their third 15-minute break of the final table.
Laugals Doubles Posted Sunday 6th September, 2020 at 18:36(UTC+3) by Jason Glatzer
The stacks are close to even after Edijs Laugals doubled.
Mark Metsla opened to 62,000 from the button with . Laugals three-bet jammed for 536,000 with and Metsla called.
Laugals was ahead and improved to a straight with the running out on the board to win the hand.
Player
Chips
Progress
Mark Metsla
1,700,000
500,000
Edijs Laugals
1,100,000
600,000
No More Ante Posted Sunday 6th September, 2020 at 18:32(UTC+3) by Jason Glatzer
Players no longer need to ante with the action now at heads-up play.
Mikael Demirors Eliminated in 3rd Place (€10,340) Posted Sunday 6th September, 2020 at 18:29(UTC+3) by Jason Glatzer
Mikael Demirors entered the final day with the chip lead and had the lead a good part of the day.
He just showed a lot of heart but it didn't work out for him.
Mark Metsla opened the button to 55,000 with before he called a three-bet jam by Laugals to 817,000 with .
Metsla stayed ahead the entire way with the running out on the board and headed to the cashier to collect the third place prize of €10,340.
Meanwhile, Metsla began heads-up play with more than a 4:1 chip advantage against Day 1b chip leader Edijs Laugals.
Player
Chips
Progress
Mark Metsla
2,200,000
800,000
Edijs Laugals
500,000
48,000
Mikael Demirors
0
0
Another Pot for Metsla Posted Sunday 6th September, 2020 at 18:24(UTC+3) by Jason Glatzer
Edijs Laugals opened to 55,000 from the button with and was called by Mark Metsla with .
Metsla check-called a bet of 63,000 after the came on the flop. Both players checked after the came on the turn.
The completed the board on the river. Metsla fired out for 100,000 and Laugals called. Metsla's pair was higher and he won the pot.
Player
Chips
Progress
Mark Metsla
1,400,000
300,000
Edijs Laugals
548,000
230,000
Metsla Takes the Lead Posted Sunday 6th September, 2020 at 18:21(UTC+3) by Jason Glatzer
Mark Metsla opened to 55,000 from the button with and was called by Mikael Demirors with in the big blind.
Demirors check-raised the flop from 65,000 to 160,000 and Metsla called.
Both players checked after the came on the turn and again after the completed the board on the river.
Metsla won the hand by connecting his four and was the chip leader after the dealer shipped him the pot.
Player
Chips
Progress
Mark Metsla
1,100,000
215,000
Mikael Demirors
841,000
259,000
Laugals Chips Up Posted Sunday 6th September, 2020 at 18:16(UTC+3) by Jason Glatzer
Mark Metsla limped from the small blind with and Edijs Laugals checked back from the big blind with .
Metsla check-called a bet of 40,000 after the came on the flop and check-called a bigger bet of 115,000 after the landed on the turn.
The completed the board on the river. Both players checked and Laugals won the hand with a pair to chip up.
Player
Chips
Progress
Mark Metsla
885,000
215,000
Edijs Laugals
778,000
94,000
Metsla Doubles Posted Sunday 6th September, 2020 at 18:11(UTC+3) by Jason Glatzer
Mikael Demirors limped from the small blind with before he called a jam by Mark Metsla to 526,000 with from the big blind.
Metsla paired up on the board to win the hand and to even up stacks with Demirors.
Player
Chips
Progress
Mark Metsla
1,100,000
562,000
Mikael Demirors
1,100,000
400,000
Laugals Takes One from Metsla Posted Sunday 6th September, 2020 at 18:04(UTC+3) by Jason Glatzer
Mark Metsla limped from the small blind with and Edijs Laugals checked from the small blind with .
Both players checked after the came on the flop before Metsla fired out for 40,000 after the paired the board on the turn. Laugals called and the came on the river.
Metsla bet 130,000 and lost the hand after Laugals snap-called.
Player
Chips
Progress
Edijs Laugals
684,000
194,000
Mark Metsla
538,000
194,000
Updated Chip Counts Posted Sunday 6th September, 2020 at 18:01(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mikael Demirors
1,500,000
0
Mark Metsla
732,000
36,000
Edijs Laugals
490,000
48,000
Neeme Org Eliminated in 4th Place (€7,130) Posted Sunday 6th September, 2020 at 17:58(UTC+3) by Jason Glatzer
It was a good run for Neeme Org who was down to one big blind at the final table with seven players remaining. He ran it up and had the chip lead but eventually lost some chips and was eliminated in fourth place for €7,130.
Org limped from the small blind with and called off for 347,000 after Mikael Demirors jammed from the big blind with .
King-high was good for Demirors as the fell on the board and the Swede extended his chip lead while sending Org to the rail.
Player
Chips
Progress
Mikael Demirors
1,500,000
300,000
Neeme Org
0
0
Updated Chip Counts Posted Sunday 6th September, 2020 at 17:54(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mikael Demirors
1,200,000
100,000
Mark Metsla
768,000
116,000
Edijs Laugals
442,000
88,000
Neeme Org
347,000
62,000
Neeme Org
0
62,000
17:51 (UTC+3)
Start of Level 23 Blinds: 12,000/24,000 Ante: 12,000
Smaller Ante in Play Posted Sunday 6th September, 2020 at 17:47(UTC+3) by Jason Glatzer
During short-handed play, the player in the big blind only needs to ante the size of the small blind for the rest of the event.
Updated Chip Counts Posted Sunday 6th September, 2020 at 17:35(UTC+3) by Jason Glatzer
Mikael Demirors became the first player in the Main Event to surpass the 1 million chip barrier.
Player
Chips
Progress
Mikael Demirors
1,100,000
150,000
Mark Metsla
652,000
170,000
Edijs Laugals
530,000
85,000
Neeme Org
409,000
145,000
Trips for Demirors Posted Sunday 6th September, 2020 at 17:26(UTC+3) by Jason Glatzer
Neeme Org limped the button for 20,000 with before he called a raise by Mikael Demirors to 110,000 from the small blind with .
Org bet 100,000 after the came on the flop and got a call.
Both players checked after the came on the turn and again after the completed the board on the river.
Demirors won the pot with trips and had nearly 1 million in chips after the hand.
Player
Chips
Progress
Mikael Demirors
950,000
186,000
Neeme Org
554,000
156,000
Org Takes One Off Demirors Posted Sunday 6th September, 2020 at 17:20(UTC+3) by Jason Glatzer
Neeme Org opened to 45,000 from the small blind with and was called by Mikael Demirors in the big blind with .
Org led out for 45,000 after the came on the flop and got a call.
The came on the turn. Org checked. Demirors fired out for 75,000 and gave up on the hand facing a check-jam to 499,000 from Demirors.
Player
Chips
Progress
Neeme Org
764,000
54,000
Mikael Demirors
764,000
121,000
Mikael Demirors
735,000
29,000
Neeme Org
710,000
121,000
Metsla Regains the Chip Lead Posted Sunday 6th September, 2020 at 17:17(UTC+3) by Jason Glatzer
Mark Metsla just won a small pot against Neeme Org to regain the chip lead.
Player
Chips
Progress
Mark Metsla
822,000
73,000
Neeme Org
589,000
63,000
Metsla Picks Off Laugal's Bluff Posted Sunday 6th September, 2020 at 17:15(UTC+3) by Jason Glatzer
Mark Metsla opened to 60,000 from the small blind with and got a call from Edijs Laugals in the big blind with .
Both players checked after the came on the flop and checked again after the came on the turn.
Metsla opted to bet 50,000 after the completed the board on the river. Laugals jacked it up to 150,000. Metsla went into the tank for about a minute before he made the correct call with ace-high to pick off his opponent's bluff.
Player
Chips
Progress
Mark Metsla
749,000
230,000
Edijs Laugals
445,000
185,000
No Fear for Demirors Posted Sunday 6th September, 2020 at 17:10(UTC+3) by Jason Glatzer
Neeme Org opened to for 40,000 from the button. Mikael Demirors three-bet to 115,000 with from the big blind and Org called.
Demirors fired out for 115,000 after both players whiffed on the flop and Org opted to call.
Demirors then jammed for 395,000 after the came on the turn. Org tanked for a minute before he folded to give the chip lead back to Demirors.
Player
Chips
Progress
Mikael Demirors
885,000
195,000
Neeme Org
652,000
240,000
17:05 (UTC+3)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Aleksandr Arutjunov Eliminated in 5th Place (€5,350) Posted Sunday 6th September, 2020 at 16:51(UTC+3) by Jason Glatzer
Aleksandr Arutjunov opened to 55,000 from the cutoff with and was called by Mark Metsla on the button with . Neeme Org made it 125,000 from the big blind with . Arutjunov jammed for 442,000. Metsla folded and Org called.
Org hit a pair on the board and Arutjunov hit the rail in fifth palce for €5,350.
Meanwhile, Org went from less than two big blinds earlier during the blind level all the way to the chip lead.
Players went on break after this hand.
Player
Chips
Progress
Neeme Org
892,000
450,000
Mark Metsla
519,000
63,000
Aleksandr Arutjunov
0
0
Laugals Takes the Chip Lead Posted Sunday 6th September, 2020 at 16:47(UTC+3) by Jason Glatzer
Edijs Laugals has taken the chip lead for the first time at the final table.
Mikael Demirors opened to 35,000 from the cutoff with before he folded to a three-bet by Laugals to 90,000 from the big blind with .
Updated Chip Counts Posted Sunday 6th September, 2020 at 16:44(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mikael Demirors
690,000
40,000
Edijs Laugals
630,000
199,000
Mark Metsla
582,000
57,000
Neeme Org
442,000
0
Aleksandr Arutjunov
387,000
94,000
Ricardo De La Rosa Moran Eliminated in 6th Place (€3,740) Posted Sunday 6th September, 2020 at 16:42(UTC+3) by Jason Glatzer
Neeme Org open-jammed the button for 264,000 with and Ricardo De La Rosa Moran called off from the big blind with .
Org's hand held up as Moran whiffed on the board. Moran didn't walk away empty-handed as his sixth-place finish was worth a healthy prize of €3,740.
Player
Chips
Progress
Neeme Org
442,000
170,000
Ricardo De La Rosa Moran
0
0
Updated Chip Counts Posted Sunday 6th September, 2020 at 16:35(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mikael Demirors
730,000
32,000
Mark Metsla
639,000
38,000
Aleksandr Arutjunov
481,000
78,000
Edijs Laugals
431,000
17,000
Neeme Org
272,000
40,000
Ricardo De La Rosa Moran
178,000
17,000
Demirors Regains the Chip Lead Posted Sunday 6th September, 2020 at 16:29(UTC+3) by Jason Glatzer
Mikael Demirors is back in the chip lead after taking a pot off Mark Metsla.
Metsla opened to 33,000 from the hijack with before he called a three-bet by Demirors with from the big blind to 90,000.
Demirors jammed his big stack after hitting a double gutter on the flop and won the pot after Metsla folded.
Player
Chips
Progress
Mikael Demirors
698,000
98,000
Mark Metsla
601,000
1,000
Org Triples Up Posted Sunday 6th September, 2020 at 16:24(UTC+3) by Jason Glatzer
It was just a few minutes ago that Neeme Org was down to less than two big blinds. It was so small he almost left the table before he realized he still had chips.
That has all changed and Org is in the middle of the pack. Ricardo De La Rosa Moran opened to 32,000 from under the gun with . Mark Metsla called from the button with before Org three-bet jammed for 96,000 with .
Both players called and the came on the flop. Moran checked before he folded to a jam by Metsla.
The came on the turn followed by the on the river and Org is back in business after winning the hand.
Player
Chips
Progress
Mark Metsla
600,000
130,000
Neeme Org
312,000
200,000
Ricardo De La Rosa Moran
195,000
126,000
Posted Sunday 6th September, 2020 at 16:18(UTC+3) by Jason Glatzer
Neeme Org got his last 24,000 into the pot from under the gun with . Mikael Demirors three-bet to 56,000 with from the hijack before he called a jam by Youssef Issa Ward with from the button.
It looked possible for two players to hit the rail. Instead Org tripled up after pairing the board and it was Ward that hit the rail in seventh place for €3,030.
Player
Chips
Progress
Mikael Demirors
600,000
89,000
Neeme Org
112,000
88,000
Youssef Issa Ward
0
0
Posted Sunday 6th September, 2020 at 16:14(UTC+3) by Jason Glatzer
Edijs Laugals opened to 33,000 from under the gun with and was called by Neeme Org with . Aleksandr Arutjunov woke up with and jammed for 243,000.
Laugals folded and Org called with just 24,000 left behind.
The ran out on the board and Arutjunov won the hand with his ladies.
Player
Chips
Progress
Aleksandr Arutjunov
559,000
276,000
Edijs Laugals
414,000
78,000
Neeme Org
24,000
200,000
16:05 (UTC+3)
Start of Level 21 Blinds: 8,000/16,000 Ante: 16,000
Updated Chip Counts Posted Sunday 6th September, 2020 at 16:01(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mark Metsla
730,000
61,000
Mikael Demirors
511,000
0
Edijs Laugals
492,000
170,000
Ricardo De La Rosa Moran
321,000
144,000
Aleksandr Arutjunov
283,000
6,000
Neeme Org
224,000
1,000
Youssef Issa Ward
170,000
119,000
Metsla Extends His Chip Lead Posted Sunday 6th September, 2020 at 15:54(UTC+3) by Jason Glatzer
Mark Metsla opened to 28,000 with from early position and was called by Neeme Org in the cutoff with and by Aleksandr Arutjunov in the big blind with .
The came on the flop to give Metsla middle pair and Arutjunov an open-ended straight draw.
Metsla c-bet 25,000. Org folded and Arutjunov called.
Arutjunov then checked after the came on the turn and eventually folded to a big bet of 87,000 from Metsla.
Player
Chips
Progress
Mark Metsla
791,000
99,000
Aleksandr Arutjunov
289,000
45,000
Neeme Org
223,000
35,000
Metsla Takes the Chip Lead Posted Sunday 6th September, 2020 at 15:46(UTC+3) by Jason Glatzer
There is a new chip leader for the first time at the final table with Mark Metsla winning a hand against former chip leader Mikael Demirors.
Demirors opened to 27,000 from early position with and got calls from Metsla on the button with and by Neeme Org in the big blind with .
Metsla checked after the came on the flop. Demirors bet 33,000 and both players called.
Metsla checked again after the came on the turn. Demirors fired out big for 112,000. Org folded and Metsla with top pair and a king-high flush draw called.
The completed the board on the river. Both players checked and Metsla won the hand with top pair.
Player
Chips
Progress
Mark Metsla
692,000
270,000
Mikael Demirors
511,000
202,000
Neeme Org
258,000
42,000
Metsla Chips Up Posted Sunday 6th September, 2020 at 15:36(UTC+3) by Jason Glatzer
Mark Metsla opened to 27,000 from under the gun with and was called by Neeme Org in the hijack with .
Both players checked after the flop before Metsla fired out for 35,000 after the came on the turn. Org raised to 90,000 and Metsla called.
Both players checked after the completed the board on the river and Metsla chipped up with the winning hand.
Player
Chips
Progress
Mark Metsla
422,000
152,000
Neeme Org
300,000
72,000
Two Pair for Moran Posted Sunday 6th September, 2020 at 15:27(UTC+3) by Jason Glatzer
Mikael Demirors opened to 28,000 from under the gun with and was called by Ricardo De La Rosa Moran with from the big blind.
Moran check-raised a bet of 28,000 from Demirors to 103,000 after he hit two pair on the flop and won the pot after his opponent folded.
Player
Chips
Progress
Mikael Demirors
713,000
65,000
Ricardo De La Rosa Moran
465,000
74,000
15:24 (UTC+3)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Siim Sooaar Eliminated in 8th Place (€2,500) Posted Sunday 6th September, 2020 at 15:10(UTC+3) by Jason Glatzer
Siim Sooaar open-jammed for 183,000 from early position with . Mikael Demirors three-bet jammed for heaps from the hijack with and the rest of the table folded.
Sooaar had hope with the coming on the flop as it gave him a flush draw and a gutshot straight draw.
His hopes for a double-up were dashed as neither the on the turn nor the on the river were cards he needed, and he was eliminated in eighth place for €2,500.
The remaining seven players went on break, each with the knowledge they just got a payjump guaranteeing them at least a payout of €3,030.
Player
Chips
Progress
Mikael Demirors
778,000
208,000
Siim Sooaar
0
0
Metsla Doubles His Short Stack Posted Sunday 6th September, 2020 at 15:05(UTC+3) by Jason Glatzer
Youssef Issa Ward opened to 30,000 with from the small blind. Mark Metsla woke up with in the big blind. Metsla jammed for 130,000 and Ward quickly called.
The ran out on the board and Metsla doubled his short stack with two pair.
Player
Chips
Progress
Youssef Issa Ward
289,000
130,000
Mark Metsla
270,000
130,000
Updated Chip Counts Posted Sunday 6th September, 2020 at 15:01(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mikael Demirors
570,000
25,000
Youssef Issa Ward
419,000
15,000
Ricardo De La Rosa Moran
391,000
15,000
Neeme Org
372,000
9,000
Aleksandr Arutjunov
334,000
40,000
Edijs Laugals
322,000
40,000
Siim Sooaar
183,000
30,000
Mark Metsla
140,000
10,000
Another Pot for Arutjunov Posted Sunday 6th September, 2020 at 14:57(UTC+3) by Jason Glatzer
After not playing a hand to start the day, Arutjunov got involved in two hands in a very short period of time.
Most recently, a hand was limped six ways to the flop. Mikael Demirors led out for 25,000 with . Arutjunov jammed for 199,000 with and every player including Demirors folded.
Player
Chips
Progress
Mikael Demirors
595,000
45,000
Aleksandr Arutjunov
294,000
85,000
Arutjunov Wins a Flip on First Hand Played Posted Sunday 6th September, 2020 at 14:52(UTC+3) by Jason Glatzer
Aleksandr Arutjunov entered the final table with the shortest stack and it got even shorter as time went on as he didn't play a hand for more than an hour.
That all changed as Arutjunov open-jammed for 92,000 from the cutoff with . Mark Metsla went into the tank before he three-bet jammed for 242,000 from the button with .
The ran out on the board and Arutjunov doubled his short stack after Metsla was unable to connect his hand to the board. Meanwhile, Metsla now became the shortest stacked player for the first time during the final table.
Player
Chips
Progress
Aleksandr Arutjunov
209,000
92,000
Mark Metsla
150,000
92,000
Lucky Double for Laugals Posted Sunday 6th September, 2020 at 14:48(UTC+3) by Jason Glatzer
Siim Sooaar opened to 22,000 from early position with and got calls by Youssef Issa Ward on the button with and by Mark Metsla in the small blind with .
Edijs Laugals three-bet jammed for 154,000 from the big blind with and got a single call by Ward.
Ward was ahead after the came on the flop and turned a set after the appeared on the board.
However, the completed the board on the river and Laugals won the hand with a flush.
Player
Chips
Progress
Youssef Issa Ward
434,000
154,000
Edijs Laugals
362,000
198,000
Mark Metsla
242,000
42,000
Siim Sooaar
213,000
38,000
Big Flush for Ward Posted Sunday 6th September, 2020 at 14:42(UTC+3) by Jason Glatzer
Mikael Demirors opened to 22,000 from the cutoff with and was called by Youssef Issa Ward in the small blind with .
Ward fired out for 22,000 after the gave him a flush draw and Demirors called.
The came on the turn to give Ward a flush and Demirors a pair and the nut-flush draw. Ward fired out big for 95,000 and got a call.
A third barrel was fired out by Ward, this time for 105,000 with 80,000 behind after the paired the board on the river. Demirors called and Ward pushed his stack to near the chip lead.
Player
Chips
Progress
Mikael Demirors
640,000
135,000
Youssef Issa Ward
588,000
201,000
Ward Steals it on the Flop Posted Sunday 6th September, 2020 at 14:34(UTC+3) by Jason Glatzer
Youssef Issa Ward limped from under the gun with .
Mark Metsla raised to 33,000 with and was called by Ricardo De La Rosa Moran with from the cutoff and also by Ward.
The flop whiffed everyone. Ward opted to lead out for 50,000. Metsla went into the tank for more than a minute with the best hand before he folded. Moran also folded and Ward stole the pot with the worst of the three hands.
Player
Chips
Progress
Ricardo De La Rosa Moran
406,000
21,000
Youssef Issa Ward
387,000
91,000
Mark Metsla
284,000
54,000
14:20 (UTC+3)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Updated Chip Counts Posted Sunday 6th September, 2020 at 14:20(UTC+3) by Jason Glatzer
Player
Chips
Progress
Mikael Demirors
775,000
36,000
Ricardo De La Rosa Moran
427,000
119,000
Neeme Org
363,000
16,000
Mark Metsla
338,000
14,000
Youssef Issa Ward
296,000
28,000
Siim Sooaar
251,000
0
Edijs Laugals
164,000
41,000
Aleksandr Arutjunov
117,000
40,000
Big Slick for Org Posted Sunday 6th September, 2020 at 14:11(UTC+3) by Jason Glatzer
Youssef Issa Ward limped from under the gun with before he called a raise to 25,000 by Neeme Org with in the hijack.
Ward hit a pair on the flop and led out for 25,000. Org called and wound up with a better pair after the came on the turn.
Ward checked before he quickly called a bet of 36,000 from Org.
The completed the board on the river. Ward checked again and folded to a small value-bet of 25,000 by Org.
Player
Chips
Progress
Neeme Org
379,000
86,000
Youssef Issa Ward
324,000
55,000
Guillaume Diaz Eliminated in 9th Place (€2,140) Posted Sunday 6th September, 2020 at 14:00(UTC+3) by Jason Glatzer
Guillaume Diaz opened jammed for less than 10 big blinds from early position with and was in big trouble after Mikael Demirors called with .
Diaz wasn't able to get there with the running out on the board and he was eliminated in ninth place for €2,140.
Player
Chips
Progress
Mikael Demirors
739,000
99,000
Guillaume Diaz
0
0
Metsla Gets Paid With a Flush Posted Sunday 6th September, 2020 at 13:56(UTC+3) by Jason Glatzer
Mark Metsla opened the cutoff to 18,000 with and got calls by Mikael Demirors in the small blind with in the small blind and by Youssef Issa Ward with .
All three players checked after the came on the flop.
The came on the turn to give Metsla a flush. Ward fired out for 33,000. Demirors folded and Metsla called.
The completed the board on the river. Ward check-called a bet of 35,000 from Metsla with two-pair and Metsla won the pot after players turned over their cards.
Player
Chips
Progress
Mikael Demirors
640,000
22,000
Mark Metsla
324,000
87,000
Youssef Issa Ward
269,000
32,000
Action Begins on Stream Posted Sunday 6th September, 2020 at 13:48(UTC+3) by Jason Glatzer
Cards are in the air on the stream. Stay tuned as we provide coverage throughout the final day.
Posted Sunday 6th September, 2020 at 13:15(UTC+3) by Jason Glatzer
The final table has just begun. Our coverage will begin in 30 minutes so we don't give away any spoilers for those also following along on the stream.
Mikael Demirors Enters Final Table with the Chip Lead in the 888poker LIVE Tallinn Main Event Posted Sunday 6th September, 2020 at 11:44(UTC+3) by Jason Glatzer
Welcome to the final day of the 888poker LIVE €888 Main Event at Olympic Park Casino.
The event attracted a total of 91 entrants during the three opening flights. The field was trimmed down to 39 players to start Day 2 and is now down to just a nine-max final table.
Sweden's Mikael Demirors enters the final table with a chip leading stack of 662,000 after running it up during the final stages of Day 2.
Closest on Demirors' tail are Ricardo De La Rosa Moran (546,000), Day 1c chip leader Youssef Issa Ward (301,000), Neeme Org (293,000), and Siim Sooaar (251,000).
Other players in the mix at the final table include Mark Metsla (237,000), Day 1b chip leader Edijs Laugals (205,000), Aleksandr Arutjunov (157,000), and Guillaume Diaz (79,000).
All returned players are guaranteed at least a ninth place payout of €2,140 with all players having their eyes on the €19,982 top prize.
The action will start at 1 p.m. EEST with 38 minutes remaining in Level 18 with blinds at 4,000/8,000 along with a big blind ante of 8,000.
Coverage at Main Event Travel of the final day will begin at around 1:30 p.m. EEST as to not give away any spoilers for those watching the stream.
Stay tuned at Main Event Travel to see who wins the 888poker LIVE Tallinn Main Event.
11:36 (UTC+3)
Day 3 of 888poker LIVE Tallinn Festival 2020 Started Level: 18 Blinds: 4,000/8,000 Ante: 8,000
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.