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.0007 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/888pokerTallinn', 1, '2024-10-05')

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

English
888poker LIVE Tallinn Festival 2020 Main Event Live Reporting - Day 3
Current Level 25 Current Day 3
Blinds 20,000/40,000 Ante
Entries 91 Remaining 1
Prize Pool (EUR) €71,322 First Prize (EUR) €19,982
1 New Update - Click to refresh
Live Updates - Day 3
20:14 (UTC+3)
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 . 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.