0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0063 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-05-07'
AND `url` = 'https://www.maineventtravel.com/live-reporting/888pokerTallinn/2/updates'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/888pokerTallinn/2/updates', 1, '2024-05-07')

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

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

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

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

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

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

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

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

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

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

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

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

0.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0003 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

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

0.0061 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0004 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.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '5'

0.0191 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0037 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '13'
AND `published` = 1

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

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

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

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

0.0002 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '5'
AND `name` = '2'

0.0049 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.0038 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` = '16'
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` = '764'
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` = '763'
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` = '762'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0052 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '758'
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` = '757'
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` = '756'
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` = '755'
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` = '754'
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` = '753'
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` = '752'
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` = '751'
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` = '750'
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` = '749'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '732'
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` = '731'
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` = '730'
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` = '729'
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` = '728'
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` = '727'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

0.0096 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.0063 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.0047 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.0056 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` = '16'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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

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

0.0051 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '761'
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` = '760'
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` = '759'
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` = '758'
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` = '757'
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` = '756'
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` = '755'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '737'
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` = '736'
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` = '735'
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` = '734'
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` = '733'
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` = '732'
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` = '731'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0047 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '722'
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` = '721'
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` = '720'
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` = '719'
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` = '718'
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` = '717'
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` = '716'
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` = '715'
ORDER BY `chip_change` DESC, `busted` ASC

0.0047 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '714'
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` = '713'
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` = '712'
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` = '711'
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` = '710'
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` = '709'
ORDER BY `chip_change` DESC, `busted` ASC

0.0045 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '708'
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` = '707'
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` = '706'
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` = '705'
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` = '704'
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` = '703'
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` = '702'
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` = '699'
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` = '16'
ORDER BY `busted` ASC, `current_chips` DESC

0.0047 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(8)
  • APPT(2)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(1)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(1)
  • British Poker Series(8)
  • BSOP(4)
  • Caesars Palace(1)
  • Dublin Poker Festival(0)
  • Dusk Till Dawn(10)
  • EAPT(2)
  • EPT(3)
  • Estrellas Poker Tour(2)
  • Eureka Poker Tour(3)
  • France Poker Series(2)
  • 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(5)
  • Hippodrome Casino(1)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(0)
  • Irish Poker Tour(11)
  • Kings of Tallinn(0)
  • LAPT(3)
  • London Poker Festival(1)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(1)
  • Mid States Poker Tour(10)
  • North American Poker Tour(0)
  • Olympic Park Casino(0)
  • Orleans Summer Open(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)
  • Resorts World Las Vegas(1)
  • Sky Poker Tour(2)
  • The Casino at Portomaso(3)
  • The Festival(3)
  • The Poker Room(1)
  • Triton Super High Roller Series(1)
  • UK Poker Championships(1)
  • UKIPT(3)
  • Unibet DeepStack Open(7)
  • Unibet Open(0)
  • Venetian Deepstack Extravaganza(2)
  • WPT(6)
  • WPT Alpha 8(3)
  • WPT Prime(6)
  • WPT Special Events(2)
  • WPT500(1)
  • WSOP(1)
  • WSOP Circuit Events(3)
  • 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

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 2

23:57 (UTC+3)

Day 2 of 888poker LIVE Tallinn Festival 2020 Ended
Level: 18     Blinds: 4,000/8,000     Ante: 8,000

Mikael Demirors Heads Into Final Table of the 888poker LIVE Tallinn Main Event with the Chip Lead Posted Saturday 5th September, 2020 at 23:55(UTC+3) by Jason Glatzer

Day 2 of the 888poker LIVE Tallinn €888 Main Event lived up to its billing at Olympic Park Casino.

The day began with 39 hopefuls looking to make tomorrow's nine-max final table or at least finish in the final 11 players to be in the money.

Sweden's Mikael Demirors (pictured) will head into the final table with a chip leading stack of 662,000 with Spain's Ricardo De La Rosa Moran closest on his tail with a stack of 546,000.

The action was hot and heavy early on with many of the shorter stacks getting eliminated fast with others doubling up including final tablist Neeme Org who began Day 2 with a starting stack and ended the day with nearly an average stack for tomorrow's final table.

The money was reached after Day 1a chip leader Andres Rebane jammed his top pair on the flop against the two pair held by Aleksandr Arutjunov. The remaining 11 players were then each guaranteed a min-cash of at least €1,780.

At this point Arutjunov held the chip lead but wound up bagging a below average stacks after losing several pots to different opponents.

Igor Pihela Jr hit the rail in 11th place shortly after the bubble broke. His father was also in Day 2 but was among the early casualties on the day.

Play resumed for two more blind levels before the final table broke. Local players Ranno Sootla and Mark Metsla both found double-ups during this time.

However, eventually Sootla's time ran out. He three-bet jammed for about 14 big blinds with king-nine suited and didn't get there against the nines held by De La Rosa Moran.

The final nine players are each guaranteed to take home €2,140 with all players having their eyes on the €19,982 top prize.

The final table will begin on Sunday, Sept. 6 at 1 p.m. EEST with 38 minutes remaining in level 18 with blinds at 4,000/8,000 and a big blind ante of 8,000. Main Event Travel will provide updates starting 30 minutes later to align our coverage with the stream.

Stay tuned at Main Event Travel to see who wins the 888poker Live Tallinn Main Event.

Mikael Demirors Bags Chip Lead Into Tomorrow's Final Table Posted Saturday 5th September, 2020 at 23:40(UTC+3) by Jason Glatzer

Player		Chips	Progress
Mikael Demirors		662,000	378,000
Ricardo De La Rosa Moran		546,000	46,000
Youssef Issa Ward		301,000	31,000
Neeme Org		293,000	57,000
Siim Sooaar		251,000	176,000
Mark Metsla		237,000	117,000
Edijs Laugals		205,000	60,000
Aleksandr Arutjunov		157,000	193,000
Guillaume Diaz		79,000	365,000

Day 2 in the Books After Sootla Bubbles Final Table Posted Saturday 5th September, 2020 at 23:31(UTC+3) by Jason Glatzer

Ranno Sootla has just bubbled the final table but will collect the 10th place prize of €1,780.

Ricardo De La Rosa Moran opened the button for 17,000 before he called a three-bet jam from Ranno Sootla in the small blind for 113,000.

Ranno Sootla:

Ricardo De La Rosa Moran:

Sootla was behind but had a flush draw after the came on the flop.

The paired the board on the turn and the followed on the river to give Moran a full house and to send Sootla to the rail.

The final nine players are bagging up their chips. Stay tuned for full chips counts and a recap of Day 2 of the 888poker LIVE Tallinn Main Event.

Player		Chips	Progress
Ricardo De La Rosa Moran		500,000	250,000
Ranno Sootla		0	0

Action Resumes Posted Saturday 5th September, 2020 at 23:18(UTC+3) by Jason Glatzer

The 10 remaining players are back in their seats. Blinds have gone up to 4,000/8,000 with a big blind ante of 8,000.

23:18 (UTC+3)

Start of Level 18
Blinds: 4,000/8,000     Ante: 8,000

Fourth Break Posted Saturday 5th September, 2020 at 23:04(UTC+3) by Jason Glatzer

Players are on their fourth 15-minute break of the day.

Ward Chips Up Posted Saturday 5th September, 2020 at 22:55(UTC+3) by Jason Glatzer

Ranno Sootla opened from the cutoff to 12,500. Youssef Issa Ward called from the button before Aleksandr Arutjunov made it 61,000 from the big blind.

Sootla snap-folded and Ward called.

Ward checked the flop. Arutjunov tanked for a minute before he bet 35,000.

Ward tried to make it 61,000 but was told he had to raise to at least 70,000. Arutjunov went back into the tank, this time for about three minutes before he folded.

Player		Chips	Progress
Aleksandr Arutjunov		350,000	150,000
Youssef Issa Ward		270,000	110,000

Sootla Doubles His Short Stack Posted Saturday 5th September, 2020 at 22:32(UTC+3) by Jason Glatzer

Ranno Sootla bet 55,000 with about 3,000 behind from the hijack and called off for the rest after a three-bet by Aleksandr Arutjunov in the big blind.

Ranno Sootla:

Aleksandr Arutjunov:

It wasn't looking great for the WSOP champ Sootla after the flop.

Sootla began to pack up his things after the was of no help on the turn.

As fate would have it, the spiked the river. Instead of bubbling the final table, Sootla earned himself a double-up and is back in business.

Player		Chips	Progress
Aleksandr Arutjunov		500,000	70,000
Ranno Sootla		130,000	65,000

22:18 (UTC+3)

Start of Level 17
Blinds: 3,000/6,000     Ante: 6,000

Pihela Jr. First to Cash Posted Saturday 5th September, 2020 at 22:08(UTC+3) by Jason Glatzer

The very next hand after players made their money, Igor Pihela Jr. lost his stack at the feature table to leave just 10 players remaining.

Player		Chips	Progress
Igor Pihela Jr		0	0

Andres Rebane Bubbles Posted Saturday 5th September, 2020 at 22:07(UTC+3) by Jason Glatzer

Aleksandr Arutjunov checked the flop before Day 1a chip leader Andres Rebane jammed for around 70,000. Arutjunov snap-called and players turned over their cards after the other table finished their hand.

Andres Rebane:

Aleksandr Arutjunov:

Rebane had top pair but needed alot of help with Arutjunov having two pair.

No help came with the coming on the turn followed by the on the river and Rebane bubbled the Main Event in 12th place.

The remaining 11 players are each guaranteed a payout of €1,780 and the action will end today when the field is further trimmed to a nine-max final table.

Player		Chips	Progress
Aleksandr Arutjunov		570,000	70,000
Andres Rebane		0	0

Arutjunov Ousts Conan with Rockets Posted Saturday 5th September, 2020 at 21:53(UTC+3) by Jason Glatzer

Arthur Conan was low on chips and jammed for 46,500 from early position. Aleksandr Arutjunov called from the cutoff as did Youssef Issa Ward in the big blind.

Ward checked the flop before he folded to a bet of 40,000 by Arutjunov.

Aleksandr Arutjunov:

Arthur Conan:

Conan was ousted after the came on the turn followed by the on the river and the action is now hand for hand on the money bubbble.

Player		Chips	Progress
Aleksandr Arutjunov		500,000	110,000
Ricardo De La Rosa Moran		250,000	100,000
Youssef Issa Ward		160,000	10,000
Arthur Conan		0	0

Ward Afraid of a Seven Posted Saturday 5th September, 2020 at 21:41(UTC+3) by Jason Glatzer

Arthur Conan checked the flop before Youssef Issa Ward bet 15,000 into a pot of nearly double this amount. Conan check-raised it to 35,000 and Ward called.

Conan fired out for 32,000 after the came on the turn and Ward called.

Both players checked after the completed the board on the river.

Ward turned over and won the hand after Conan mucked.

"I was afraid you had a seven," Ward said to Conan after the hand.

Player		Chips	Progress
Youssef Issa Ward		150,000	70,000
Arthur Conan		80,000	190,000

Action Resumes Posted Saturday 5th September, 2020 at 21:33(UTC+3) by Jason Glatzer

The 13 players are back in their seats with blinds at 2,500/5,000 and a big blind ante of 5,000.

21:33 (UTC+3)

Start of Level 16
Blinds: 2,500/5,000     Ante: 5,000

Third Break Posted Saturday 5th September, 2020 at 21:20(UTC+3) by Jason Glatzer

The remaining 13 players are on their third 15-minute break.

Set of Cowboys for Arutjunov Posted Saturday 5th September, 2020 at 21:19(UTC+3) by Jason Glatzer

Igor Pihela Jr. opened to 10,000 from the hijack before he called a raise by Aleksandr Arutjunov on the button to 21,000.

Both players checked the flop. Pihela Jr. then fired out for 30,000 after the came on the turn and Arutjunov called.

Pihela Jr. then bet 55,000 once the completed the board on the river. Arutjunov tanked for three minutes before he called.

Pihela Jr. turned over and the pot went over to Arutjunov who turned a set with .

Player		Chips	Progress
Aleksandr Arutjunov		390,000	90,000
Igor Pihela Jr		210,000	104,000

Four-Bet Jam Gets Through for Sootla Posted Saturday 5th September, 2020 at 21:11(UTC+3) by Jason Glatzer

Ranno Sootla opened from early position to 9,000. Arthur Conan called from the button before Aleksandr Arutjunov made it 29,000 from the big blind.

Sootla tanked for a minute before he four-bet jammed for 125,000. Conan quickly folded and Arutjunov asked for a count.

Two minutes later, Arutjunov folded and Sootla chipped up without seeing a flop.

Player		Chips	Progress
Aleksandr Arutjunov		300,000	40,000
Ranno Sootla		195,000	20,000

Armanavicius Loses His Short Stack Posted Saturday 5th September, 2020 at 20:53(UTC+3) by Jason Glatzer

Liutauras Armanavicius was down to a handful of big blinds when Mark Metsla jammed from the small blind. Armanavicius called from the big blind and players turned over their cards.

Liutauras Armanavicius:

Mark Metsla:

Metsla's nine-high wound up being good with the running out on the board and Armanavicius was eliminated in 14th place.

Shortly before that hand, Ilvars Gudrimovics was also eliminated in 15th place.

Player		Chips	Progress
Mark Metsla		120,000	27,000
Ilvars Gudrimovics		0	0
Liutauras Armanavicius		0	0

Arutjunov Picks Off Ward's Bluff Posted Saturday 5th September, 2020 at 20:42(UTC+3) by Jason Glatzer

Aleksandr Arutjunov opened to 11,000 from the cutoff and was called by Youssef Issa Ward in the big blind.

Both players checked after the came on the flop before Ward check-called a bet of about 10,000 after the came on the turn.

The completed the board on the river and Ward donk-bet 25,000. Arutjunov went into the tank for nearly two minutes before he made the call.

Ward slammed down onto the table and Arutjunov won the hand after he turned over .

Player		Chips	Progress
Aleksandr Arutjunov		340,000	58,000
Youssef Issa Ward		80,000	10,000

20:32 (UTC+3)

Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000

Moran Doubles with Two Pair Posted Saturday 5th September, 2020 at 20:11(UTC+3) by Jason Glatzer

Ricardo De La Rosa Moran jammed for about 30,000 with about triple that in the pot with the on the board and got called by Youssef Issa Ward.

Moran turned over and Ward attempted to toss his hand into the muck.

Since it was an all-in and call situation, the tournament director instructed Ward to show his hand and he eventually turned over .

Player		Chips	Progress
Ricardo De La Rosa Moran		150,000	99,300
Youssef Issa Ward		70,000	70,000

Posted Saturday 5th September, 2020 at 20:02(UTC+3) by Jason Glatzer

Youssef Issa Ward opened to 6,500 from early position before he called a three-bet jam for under 30,000 by Vita Veidemane on the button.

Vita Veidemane:

Youssef Issa Ward:

Ward was ahead the entire way and Veidemane hit the rail in 16th place after the rolled out on the board to leave 15 players remaining.

Player		Chips	Progress
Youssef Issa Ward		140,000	35,000
Vita Veidemane		0	0

Action Resumes Posted Saturday 5th September, 2020 at 19:53(UTC+3) by Jason Glatzer

The action has resumed. 

Here are the updated stacks of the new TV table.

Player		Chips	Progress
Guillaume Diaz		444,000	72,000
Neeme Org		350,000	90,000
Mikael Demirors		284,000	210,400
Aleksandr Arutjunov		282,000	32,000
Edijs Laugals		145,000	30,400
Mark Metsla		93,000	13,000
Siim Sooaar		75,000	1,500
Liutauras Armanavicius		37,000	4,400

Redraw Break Posted Saturday 5th September, 2020 at 19:44(UTC+3) by Jason Glatzer

The action is down to 16 players after Spain's Jon Ander Martinez hit the rail in 17th place at the TV table.

The tournament is now on another break with a redraw taking place for the final two tables.

Player		Chips	Progress
Jon Ander Martinez		0	0

Action Resumes Posted Saturday 5th September, 2020 at 19:37(UTC+3) by Jason Glatzer

The 17 players are back from break. Blinds have gone up to 1,500/3,000 with a big blind ante of 3,000.

There will be another break for a redraw when there are 16 players remaining.

19:36 (UTC+3)

Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000

TV Table Chip Counts Posted Saturday 5th September, 2020 at 19:36(UTC+3) by Jason Glatzer

Here are the chip counts of the new TV table to start the break.

Player		Chips	Progress
Guillaume Diaz		372,000	102,000
Igor Pihela Jr		314,000	44,000
Andres Rebane		97,500	7,500
Ilvars Gudrimovics		84,000	4,000
Siim Sooaar		76,500	28,800
Jon Ander Martinez		63,000	10,000

Second Break Posted Saturday 5th September, 2020 at 19:21(UTC+3) by Jason Glatzer

The 17 players are on their second break of the day. It is likely there will be another break soon thereafter with a redraw taking place when the action is down to 16 players.

Nut Flush for Org Posted Saturday 5th September, 2020 at 19:10(UTC+3) by Jason Glatzer

Neeme Org began today with a starting stack of 30,000 but has gone on a run and is near the top of the leaderboard.

In a recent hand, Arthur Conan bet 27,000 into a pot of around 70,000 with the on the board.

Org raised to 55,000 and got a quick call from Conan.

Org turned over for the nut-flush and the dealer pushed him the pot after Conan mucked his cards.

Player		Chips	Progress
Arthur Conan		270,000	80,000
Neeme Org		260,000	60,000

Six Away from the Money Posted Saturday 5th September, 2020 at 18:54(UTC+3) by Jason Glatzer

The money bubble is getting closer and closer with the field down to 17 players after the elimination of Martin Zobel in 18th place.

Player		Chips	Progress
Martin Zobel		0	0

Metsla's Bluff Gets Called Posted Saturday 5th September, 2020 at 18:52(UTC+3) by Jason Glatzer

Aleksandr Arutjunov just won a big pot against Mark Metsla.

Arutjunov checked with more than 80,000 in the pot and the on the board. Metsla fired out for around 40,000 and Arutjunov quickly called.

Metsla was bluffing and turned over and lost the pot to Arutjunov who turned over for two pair.

Player		Chips	Progress
Aleksandr Arutjunov		250,000	105,000
Mark Metsla		80,000	70,000

18 Remain Posted Saturday 5th September, 2020 at 18:47(UTC+3) by Jason Glatzer

Teemu Salminen, who began today with one of the shorter stacks in play, made it more than some but was unable to make the money after bowing out in 19th place.

Player		Chips	Progress
Teemu Salminen		0	0

Two Pair Good for Diaz Posted Saturday 5th September, 2020 at 18:43(UTC+3) by Jason Glatzer

Andres Rebane limped from the hijack before he called a raise by Guillaume Diaz to 14,000 from the big blind.

Rebane called a bet of 14,000 by Diaz after the came on the flop.

Both players checked after the appeared on the turn.

The completed the board on the river. Diaz fired out for 29,000 and Rebane tanked for a minute before he called.

Diaz turned over for pair and won the hand after Rebane mucked his cards.

Player		Chips	Progress
Guillaume Diaz		270,000	70,000
Andres Rebane		90,000	105,000

18:35 (UTC+3)

Start of Level 13
Blinds: 1,200/2,400     Ante: 2,400

19 Left - Conan Chipping Up Posted Saturday 5th September, 2020 at 18:34(UTC+3) by Jason Glatzer

David Carrasco just hit the rail in 20th place leaving just 19 players remaining.

Meanwhile, Arthur Conan keeps building his stack and is up to around 350,000 in chips.

Player		Chips	Progress
Arthur Conan		350,000	200,000
David Carrasco		0	0

Artjoms Hromovs Hits the Rail Posted Saturday 5th September, 2020 at 18:25(UTC+3) by Jason Glatzer

Artjoms Hromovs was noticed leaving the tournament area and was eliminated in 21st place.

The action is down to just 20 players with 11 getting paid at least a min-cash of €1,780 and the day ending when the action is down to a nine player final table.

Player		Chips	Progress
Artjoms Hromovs		0	0

Sootla Wins the Battle Against Metsla Posted Saturday 5th September, 2020 at 18:23(UTC+3) by Jason Glatzer

Artjoms Hromovs opened to 4,500 from the cutoff and got a call from Mark Metsla in the small blind.

Ranno Sootla made it 21,000 from the big blind. Hromovs folded and Metsla called.

Metsla checked after the all-hearts flop was dealt on the board. Sootla bet 9,000 and Metsla called.

Both players then checked after the came on the turn.

Metsla then fired out for 33,000 after the came on the river to put four hearts on the board. Sootla tanked for nearly a minute before he jammed for more than twice this amount. Metsla snap-folded and Sootla won the pot.

Player		Chips	Progress
Ranno Sootla		175,000	57,000
Mark Metsla		150,000	35,700

Diaz Ousts Penttinen Posted Saturday 5th September, 2020 at 18:17(UTC+3) by Jason Glatzer

Veli-Pekka Tapani Penttinen three-bet jammed for less than 20 big blinds with and was called by Guillaume Diaz with .

The flip was over before it began was Diaz nailing a set on the flop. The came on the turn and Penttinen got up as he was drawing dead at this point.

The Finn was officially eliminated after the came on the river.

Madis Muur, who held the shortest stack in the room, was eliminated just before Penttinen to leave 21 players remaining.

Player		Chips	Progress
Guillaume Diaz		200,000	26,600
Madis Muur		0	0
Veli-Pekka Tapani Penttinen		0	0

Org Takes Out Three with Cowboys Posted Saturday 5th September, 2020 at 18:07(UTC+3) by Jason Glatzer

Neeme Org opened from the cutoff to 4,000. Sander Laprik jammed for 15,300 from the button before Alari Kunnapuu called off for about 3,000 from the small blind and Urmo Einard called off for about 14,000 from the big blind.

Org had all three players well covered and made the call.

Neeme Org:

Sander Laprik:

Urmo Einard:

Alari Kunnapuu:

Org stayed ahead the entire time with the running out on the board to eliminate three players and add some chips to his stack.

Player		Chips	Progress
Neeme Org		200,000	170,000
Urmo Einard		0	0
Alari Kunnapuu		0	0
Sander Laprik		0	0

Ward with Cowboys Posted Saturday 5th September, 2020 at 18:00(UTC+3) by Jason Glatzer

Youssef Issa Ward opened to 4,000 on the button. Rimantas Petras Boguzas jammed for about 38,000 from the small blind.

Ward asked for a count but called before the count even started.

Youssef Issa Ward:

Rimantas Petras Boguzas:

It was looking grim for Boguzas to stay alive and the coming on the flop made things even worse for the Lithuanian.

Boguzas stood up to leave after he noticed he was drawing dead once the was dealt on the turn.

Ward officially won the pot after the came on the river to chip up and send an opponent to the rail.

Shortly after, Serhii Kozyriev and Tauri Taimre were eliminated to leave 26 players remaining.

Player		Chips	Progress
Youssef Issa Ward		105,000	45,000
Tauri Taimre		0	0
Rimantas Petras Boguzas		0	0
Serhii Kozyriev		0	0

Action Resumes Posted Saturday 5th September, 2020 at 17:52(UTC+3) by Jason Glatzer

The 29 players are back in action to start Level 12 with blinds at 1,000/2,000 with a big blind ante of 2,000.

17:52 (UTC+3)

Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000

TV Table Chip Counts Posted Saturday 5th September, 2020 at 17:47(UTC+3) by Jason Glatzer

Here is a look at the TV table chip counts to start the break. In addition, Luca Beretta was eliminated just before the break to leave 29 players remaining in the field.

Player		Chips	Progress
Edijs Laugals		175,400	34,600
Guillaume Diaz		173,400	94,600
Martin Zobel		104,600	36,900
Mikael Demirors		73,600	96,400
Ricardo De La Rosa Moran		50,700	14,700
Liutauras Armanavicius		41,400	12,600
Vita Veidemane		28,600	1,400
Madis Muur		15,100	12,600
Luca Beretta		0	0

First Break of the Day Posted Saturday 5th September, 2020 at 17:34(UTC+3) by Jason Glatzer

Players are on their first break of the day. The break might be more than the scheduled 15 minutes with the TV table changing to a new table during the break.

Meanwhile, Raffaello Locatelli, who began the day with below a starting stack, was eliminated just before the break to bring the field down to just 30 players.

Player		Chips	Progress
Raffaello Locatelli		0	0

Tens for Hromovs Posted Saturday 5th September, 2020 at 17:32(UTC+3) by Jason Glatzer

Arthur Conan checked from the big blind after the came on the flop and about 12,000 in the pot. David Carrasco fired out for 7,500. Arjoms Hromovs called and Conan folded.

Carrasco fired out for 21,000 after the came on the turn and got a snap-call from Hromovs.

Both players quickly checked after the completed the board on the river.

Carrasco turned over for two pair but the pot went to his opponent with Hromovs turning over for an over pair.

Player		Chips	Progress
Artjoms Hromovs		145,000	35,000
David Carrasco		85,000	30,000

Arutjunov Gives Up on the Pot Posted Saturday 5th September, 2020 at 17:24(UTC+3) by Jason Glatzer

Aleksandr Arutjunov bet 6,000 into a pot of around 9,000 with the on the board on the turn.

Artjoms Hromovs raised it to 16,000 and Arutjunov went into the tank for more than a minute before he opted to give up on the pot.

Meanwhile, South Korea's Sangguk Im hit the rail for the first elimination during the new blind level.

Player		Chips	Progress
Aleksandr Arutjunov		145,000	1,600
Artjoms Hromovs		110,000	38,900
Sangguk Im		0	0

Monster Pot for Pihela Jr Posted Saturday 5th September, 2020 at 17:08(UTC+3) by Jason Glatzer

While Igor Pihela hit the rail early today his son Igor Pihela Jr is off to a hot start and just won a monster pot.

Pihela Jr opened to 3,600 from middle position and was called by Youssef Issa Ward in the cutoff. Ilvars Gudrimovics jacked it up to 12,000 from the small blind and both players called.

Gudrimovics checked after the came on the flop. Pihela Jr fired out for 15,000 and got a single call from Ward.

Pihela Jr then fired out for 25,000 after the came on the turn and Ward snap-called.

The appeared on the river and Pihela Jr jammed more than the 60,000 the chip leader to start the day had remaining in his stack. Ward snap-folded and Pihela Jr won a monster pot without a showdown.

Player		Chips	Progress
Igor Pihela Jr		270,000	207,200
Youssef Issa Ward		60,000	109,700

Slots Streamer Jari Lahtinen Loses a Flip Posted Saturday 5th September, 2020 at 16:55(UTC+3) by Jason Glatzer

Jari Lahtinen (pictured to the left in the lead image next to Ott-Kaarli Toome) is used to having luck either for him or against him as a popular Twitch slots streamer where he is known as Jarttu.

The Finn living in Estonia attempted a bluff but was picked off to leave him under 20,000 in chips.

Shortly after, Lahtinen three-bet shoved this stack with and was called by Day 1a chip leader Andres Rebane with .

The all diamond flop gave Rebane a small advantage in the hand. The advantage became bigger after the came on the turn. 

Rebane had the higher flush but Lahtinen still had a chance to get a straight flush. Yahtzee didn't come as the completed the board on the river to send Lahtinen to the rail.

Player		Chips	Progress
Andres Rebane		195,000	37,400
Jari Lahtinen		0	0

16:48 (UTC+3)

Start of Level 11
Blinds: 800/1,600     Ante: 1,600

Demirors Takes One Off Moran Posted Saturday 5th September, 2020 at 16:48(UTC+3) by Jason Glatzer

Mikael Demirors fired out for about 25,000 with more than this sprinkled into the pot with the on the board.

Ricardo De La Rosa Moran had about 36,000 behind and opted to fold after a minute in the tank.

Meanwhile, two Estonians just hit the rail in Ott-Kaarli Toome and Taago Tamm to bring the field down to 33 players.

Player		Chips	Progress
Mikael Demirors		170,000	73,800
Ricardo De La Rosa Moran		36,000	17,800
Ott-Kaarli Toome		0	0
Taago Tamm		0	0

Live Stream Begins Posted Saturday 5th September, 2020 at 16:36(UTC+3) by Jason Glatzer

The feature table began at the start of play but due to the 30-minute delay so hole cards can be exposed, it went live just now.

You can check out the action commentated by Estonia's Kristjan Laas via this link.

Laugals Chipping Up Posted Saturday 5th September, 2020 at 16:33(UTC+3) by Jason Glatzer

Day 1b chip leader Edijs Laugals has been chipping up during the first blind level of the day.

In a recent hand he check-called a bet of 4,200 from David Carrasco with about 8,000 in the pot after the came on the flop.

Laugals then fired out for 15,000 after the came on the turn. Carrasco went into the tank for at least two minutes before he folded.

Meanwhile, the Main Event is over for Igor Pihela, who hit the rail in 36th place around the same time this hand was going on.

Player		Chips	Progress
Edijs Laugals		210,000	45,100
David Carrasco		55,000	4,100
Igor Pihela		0	0

Two Brits Hit the Rail Posted Saturday 5th September, 2020 at 16:27(UTC+3) by Jason Glatzer

The action is down to just 36 players with two British players hitting the rail in Glyn Coxon and Samuel Richards.

Player		Chips	Progress
Samuel Richards		0	0
Glyn Coxon		0	0

Martinez Wins a Flip Posted Saturday 5th September, 2020 at 16:25(UTC+3) by Jason Glatzer

Jari Lahtinen made a standard open from the cutoff before he called a three-bet jam by Jon Ander Martinez to 25,000 from the small blind.

Jon Ander Martinez:

Jari Lahtinen:

Martinez was on the winning side of the flip with his opponent whiffing the board to double up his short stack.

"The hand played itself," Martinez said to his opponent after the hand.

"I guess I could have folded," responded Lahtinen.

Player		Chips	Progress
Jon Ander Martinez		53,000	21,000
Jari Lahtinen		40,000	21,200

Conan Chips Up Against Taimre Posted Saturday 5th September, 2020 at 16:20(UTC+3) by Jason Glatzer

Arthur Conan led out for 8,500 with the putting a straight on the board.

Tauri Taimre appeared to go into deep thought for around a minute before he opted to call.

Taimre shook his head and muck his cards after Conan turned over to give him a better straight than that on the board.

Player		Chips	Progress
Arthur Conan		150,000	30,000
Tauri Taimre		55,000	19,100

Nearly €20K to the Winner! Posted Saturday 5th September, 2020 at 16:10(UTC+3) by Jason Glatzer

Payouts have just been announced. The top 11 players will walk away with at least a min-cash of €1,780 with tomorrow's winner going home with a huge €19,982 payday.

Pavels Spirins Eliminated First Hand Posted Saturday 5th September, 2020 at 16:08(UTC+3) by Jason Glatzer

Pavels Spirins bagged a short starting stack from the turbo Day 1c field. He didn't last long as he was eliminated during the first hand of play to bring the field down to 38 players

Player		Chips	Progress
Pavels Spirins		0	0

Cards in the Air Posted Saturday 5th September, 2020 at 16:05(UTC+3) by Jason Glatzer

Cards are now in the air for Day 2 of the Main Event.

The tournament director made some announcements including that Day 2 would most likely conclude when a final table has been reached.

Welcome to Day 2 of the 888poker Tallinn Main Event Posted Saturday 5th September, 2020 at 15:51(UTC+3) by Jason Glatzer

The three opening flights have now been completed for the 888poker LIVE Tallinn €888 Main Event at Olympic Park Casino.

Late registration is officially closed and the event attracted a total of 91 entrants to generate a healthy €71,322 prize pool. Official payouts will be released early today.

Day 1C chip leader Youssef Issa Ward heads into Day 2 with a chip leading stack of 169,700. He is followed by Day 1B chip leader Edijs Laugals (lead image) with 164,900 and Day 1A chip leader Andres Rebane with 157,600.

A total of 39 entrants have advanced to Day 2. The action will begin with blinds at 600/1,200 along with a big blind ante of 1,200 and increase every 45 minutes.

The tournament director will announce later today how many levels or if play will conclude with a certain amount of players remaining.

Cards will be in the air around 4 p.m. EEST. Stay tuned at Main Event travel to see who advances from Day 2 of the 888poker Tallinn Main Event.

15:46 (UTC+3)

Day 2 of 888poker LIVE Tallinn Festival 2020 Started
Level: 10     Blinds: 600/1,200     Ante: 1,200

15:15 (UTC+3)

Day 2 of 888poker LIVE Tallinn Festival 2020 Started
Level: 10     Blinds: 600/1,200     Ante: 1,200

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