0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0091 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-04-26'
AND `url` = 'https://www.maineventtravel.com/live-reporting/888pokerTallinn'
ORDER BY `views` DESC

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/888pokerTallinn', 1, '2024-04-26')

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

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

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

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

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

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

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

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

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

0.0004 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.0004 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 `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0005 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.0004 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.0107 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.0227 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0046 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '13'
AND `published` = 1

0.0229 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0049 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '14'
AND `published` = 1

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

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

0.0188 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0028 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '17'
AND `published` = 1

0.0030 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.0045 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.0031 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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0049 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0046 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0146 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0150 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0045 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.0045 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.0045 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.0045 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.0037 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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0143 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0102 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '801'
ORDER BY `chip_change` DESC, `busted` ASC

0.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0075 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '779'
ORDER BY `chip_change` DESC, `busted` ASC

0.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0043 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0044 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0041 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0042 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0040 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0046 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

    

Open Modal

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.

Many Thanks,
The MainEventTravel team

Allow Notifications Close

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

• Home
• My Account
• Calendar
• Live Reporting
  •   Live Reporting
  •   Live Streams
• News & Blogs
• Offers & Packages
• Events
  • VIEW ALL >
  • 888poker LIVE(3)
  • 888poker UK Poker League(3)
  • APAT(10)
  • APPT(2)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(2)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(9)
  • BSOP(4)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(12)
  • EAPT(2)
  • EPT(4)
  • Estrellas Poker Tour(2)
  • Eureka Poker Tour(2)
  • France Poker Series(3)
  • Gift Voucher(1)
  • Golden Nugget Grand Poker Series(1)
  • Grosvenor Casino Coventry(4)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/25(1)
  • Grosvenor Poker 25/50(34)
  • Grosvenor UK Poker Open(0)
  • Grosvenor's Summer Fest(0)
  • GUKPT Grosvenor(6)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(0)
  • Irish Poker Tour(12)
  • Kings of Tallinn(0)
  • LAPT(3)
  • London Poker Festival(1)
  • Malta Poker Festival(2)
  • Master Classics of Poker(0)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • Olympic Park Casino(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Festival(0)
  • PokerStars Summer Series(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • RDS (Royal Dublin Society)(0)
  • Sky Poker Tour(2)
  • The Casino at Portomaso(6)
  • The Festival(3)
  • The Poker Room(1)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(3)
  • Unibet DeepStack Open(6)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(2)
  • WPT(7)
  • WPT Alpha 8(3)
  • WPT Prime(6)
  • WPT Special Events(2)
  • WPT500(1)
  • WSOP(1)
  • WSOP Circuit Events(4)
  • WSOP International Circuit(3)
  • WSOP Super Circuit Events(0)
  • Wynn Poker(1)
• Featured Venues
• Destination Guides
  • Las Vegas
  • Malta
  • London
  • Dublin
  • Coventry
• About Us
  • About Us
  • Partners
  • Contact Us
  • Privacy Policy
  • Terms & Conditions
  • The Management
  • Work With Us
  • Event Management
  • Flight FAQs
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll
  • IPT Portugal Adventure X Giveaway

Login / Register

UK: +44 (0) 1770 280000 | US: +1 (702) 500-1333 info@maineventtravel.com

English

• English
• Deutsch
• Français
• Italiano
• Español
• Português
• Čeština
• Dansk
• Polski
• Română
• Svenska
• Norsk
• Suomi
• Nederlands
• Malti
• עברית
• العربية
• Lietuvių
• Български
• Türk
• Ελληνικά
• Русский

• £   GBP
• $   USD
• €   EUR

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

Chip Leaders Day 3

1

Edijs Laugals

2,730,000

Day 1A Day 1B Day 1C Day 2 Day 3

Live Updates Chip Counts Structure Gallery Payouts

SHARE

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

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333 info@maineventtravel.com

Browse

News Tours Festivals Venues Offers & Packagess

Useful Links

My Account Terms & Conditions Privacy Policy About Us Enquiry Form

Subscribe to our newsletter