0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0113 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-19'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsopc_tallinn_me_EST/3/updates'
ORDER BY `views` DESC

0.0140 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-19'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsopc_tallinn_me_EST/3/updates'

0.0003 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.0001 SECONDS: 
SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'

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

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

0.0001 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.0005 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

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

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

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

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

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

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

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

0.0005 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_wsopc_tallinn_me_EST'

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

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

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

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

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '141'
AND `name` = '3'

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

0.0097 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` = '369'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '15977'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    

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(6)
  • APAT(1)
  • APPT(0)
  • Aria Resort & Casino(2)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(1)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(4)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(4)
  • EAPT(2)
  • EPT(2)
  • Golden Nugget Grand Poker Series(0)
  • Grosvenor Goliath(1)
  • Grosvenor Poker 25/50(70)
  • Grosvenor UK Poker Open(1)
  • Grosvenor's National Poker League(0)
  • GUKPT Grosvenor(9)
  • Hippodrome Casino(0)
  • IPO(0)
  • Irish Poker Festival(1)
  • Irish Poker Open(1)
  • Irish Poker Tour(9)
  • Kings of Tallinn(0)
  • Kings of Vilnius(0)
  • LAPT(0)
  • London Poker Festival(0)
  • Malta Poker Festival(1)
  • Mediterranean Poker Party(1)
  • MGM Grand Poker(0)
  • Mid States Poker Tour(11)
  • North American Poker Tour(0)
  • OlyBet Showdown(0)
  • Orleans Summer Open(0)
  • Poker GO Tour(1)
  • Poker Skills Events(1)
  • PokerStars Caribbean Adventure(0)
  • PokerStars Open(0)
  • Pure Poker Tour(0)
  • Queens of Tallinn(0)
  • Resorts World Las Vegas(0)
  • Sky Poker Tour(0)
  • The Caribbean Poker Series(0)
  • The Festival(0)
  • Triton Super High Roller Series(0)
  • UK Poker Championships(1)
  • UKIPT(0)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(2)
  • Women's Winter Festival(0)
  • WPT(2)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(0)
  • WSOP Circuit Events(13)
  • WSOP International Circuit(5)
  • 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
  • Main Event Dealers Training Schools
  • Enquiry Form
• Promotions
  • Promotions
  • FinalTableFreeroll FTF

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

Olympic Park Casino Event #6: €1M GTD €1,500 Main Event (Estonian) Live Reporting - Day 4

Olympic Park Casino - Live Reporting

Event #6: €1M GTD €1,500 Main Event (Estonian) See other events

Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

Olympic Park Casino - Live Reporting Event #1: €250 No-Limit Hold'em (Estonian) Event #1: €250 No-Limit Hold'em Event #3: €555 No-Limit Hold'em Event #4: €350 PLO4&5 Progressive Bounty Event #5: €250 NLH Queens (Estonian) Event #5: €250 NLH Queens Event #6: €1M GTD €1,500 Main Event (Estonian) Event #6: €1M GTD €1,500 NLH Main Event Event #7: €1,100 PLO4&5 Event #8: €1,100 NLH Mystery Bounty Event #9: €3,000 No-Limit Hold'em Six-Max (Estonian) Event #9: €3,000 No-Limit Hold'em Six-Max Event #3: €555 No-Limit Hold'em (Finnish) Event #6: €1M GTD €1,500 NLH Main Event (Finnish) Event #7: €1,100 PLO4&5 (Finnish) Event #9: €3,000 No-Limit Hold'em Six-Max (Finnish)

---

Current Level 30 Current Day 4

---

Blinds 50,000/100,000 Ante 100000

Entries 812 Remaining 1

---

Prize Pool (EUR) €1,052,352 First Prize (EUR) €167,600

Chip Leaders Day 4

1

Aurimas Stanevicius

40,600,000

Day 2 Day 3 Day 4

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

14. koht Marius Morel 9200 € Posted Saturday 27th July, 2024 at 23:35(UTC+2) by maheaaatom

Juba järgmises jaotuses kordub sama, mis eelmises, seekord on aga kahjuks ohvriks meie Marius Morel.

Jeffrey Cormier avab 225K-ga ja Marius vajutab oma 745K stäki keskele. Enea Subashi jõuab veel foldida , kuid Jeffreylt tuleb mõistagi call.

Marius:

Jeffrey:

Lauda

Sellega lõpetame ka põhiturniiri eestikeelse blogi. Turniiri jätkab kuraditosin mängijat, kellest üheksa jõuab finaallauda ning 4 ei jõua. Sergeile, Evgenyle ja teistele lemmikutele saate elada kaasa läbi TV-streami ning ingliskeelse blogi. Samuti soovitame jälgida highrolleri live-blogi, mis valmib hetkel ka eestikeelsena.

Finaallauast valmib TV-ülekanne ning värsked päevakokkuvõtted leiate ka nii pühapäeval kui esmaspäeval Olybet.TV keskkonnast.

Player		Chips	Progress
Marius Morel		0	0

Kaotasime viimase naismängija Posted Saturday 27th July, 2024 at 23:27(UTC+2) by maheaaatom

Värvikas Kanada pokkeriäss Jeffrey Cormier avab 160K-ga ning norralanna Vilde Bystol Fagerbakke lükkab oma 1,2M stäki keskele. Jeff mõtleb, kuid call siiski tuleb.

Jeffrey:

Vilde:

Lauda ebaoluline numbripuru, mis midagi ei muuda. Neljade paar peab.

Parim naine teenib 9200 eurot. Marius on selgelt telelaua väiksem stäkk 745 000 punktiga.

423 sisseostu deep-stackil Posted Saturday 27th July, 2024 at 23:15(UTC+2) by maheaaatom

350 € NLH DeepStack turniiril tehti koguni 423 sisseostu ning nagu arvata võis, osutus turniir erakordselt menukaks. Deep-stack küll, kuid küllaga on neidki, kes tegid kolm või enam re-entryt.

Online-turniiril on hetkeseisuga väike overlay, osalejaid peaks olema 147. 250 € NLH Bountyl on käimas heads-up kahe lätlase vahel, naisteka ning kokku 2660 eurot auhinnaraha võitis soomlanna Tiina Maria Rantamäki.

22:59 (UTC+2)

Start of Level 30
Blinds: 50,000/100,000     Ante: 100,000

Sergei on ära andnud Posted Saturday 27th July, 2024 at 22:59(UTC+2) by maheaaatom

Sergei on kaotanud mitu panka, igaühega on midagi läinud. Tal hetkel 2,2M järgi ning liidrite sekka Sergei sellega kahjuks enam ei kuulu.

Evgenyl on rohkem - umbes 2,8M. See on peaaegu sama palju kui keskmine stäkk.

Player		Chips	Progress
Evgeny Vyal		2,800,000	1,100,000
Sergei Aleksejev		2,200,000	1,800,000

Liisile naistekalt neljas koht Posted Saturday 27th July, 2024 at 22:55(UTC+2) by maheaaatom

Liisi Voltri oli paraku ainus Eesti naine, kes Queens Mystery Bounty'l cashis. Tasuks 360 eurot ning neljas koht. Abiks ikka!

Jätkame 15-kesi Posted Saturday 27th July, 2024 at 22:44(UTC+2) by maheaaatom

Mitte-telelauast langes Norra pokkerimängija Sohrab Malkari, kes jäi oma keskmisest stäkist ilma kahe jaotusega. Neist esimene oli bad beat, teine aga "aus kaotus". Eesti mängijad kummaski jaotuses ei osalenud.

Liisi jätkab võitlust Posted Saturday 27th July, 2024 at 22:36(UTC+2) by maheaaatom

Põhiturniir läks just uuesti käima ning heitsime pilgu ka naistekale, kus on alles neli mängijat.

Nende seas on meie Liisi Voltri. Turniiril on üks väga suur stäkk, ülejäänud kolm on üsna võrdsed.

Table break Posted Saturday 27th July, 2024 at 22:08(UTC+2) by maheaaatom

16 mängijat on järgi ning me jätkame kahel laual. Marius jääb telelauda, ülejäänud kaks Eesti mängijat kolivad "reaalaega". Oleme 20-minutilisel tehnilisel vaheajal.

Evgeny julge call kukutab kanadalanna Posted Saturday 27th July, 2024 at 21:35(UTC+2) by maheaaatom

Evgeny avab 125K tõstega ning Kanada naismängija Nohad Teliani lükkab all-in (1,1M). Evgeny mõtleb pikalt, otsustades siiski viimaks callida.

Nohad:

Evgeny:

Lauda

Seega on turniiri parim naine Vilde Bystol Fagerbakke. Oleks väga uhke, kui tal õnnestuks ka finaali jõuda. Hetkel on naisel natuke alla keskmise stäkk.

Player		Chips	Progress
Sergei Aleksejev		4,000,000	400,000
Evgeny Vyal		3,900,000	1,100,000
Marius Morel		1,900,000	200,000

21:24 (UTC+2)

Start of Level 29
Blinds: 40,000/80,000     Ante: 80,000

Stäkkide seis Posted Saturday 27th July, 2024 at 21:23(UTC+2) by maheaaatom

Player		Chips	Progress
Sergei Aleksejev		3,600,000	125,000
Evgeny Vyal		2,800,000	215,000
Marius Morel		2,100,000	100,000

Algas tänane viimane kõrvalturniir Posted Saturday 27th July, 2024 at 21:12(UTC+2) by maheaaatom

250 € PLO 4&5 Progressive Bounty on läinud käima ning laudades 40 mängijat. Nende seas oli näha ka kõva Omaha-ässa Kristjan Abakanovit, keda pole siiani sel festivalil veel näha olnud.

Lisaks on täna kavas ka üks 80-eurone satelliit homme toimuvale viimasele sõrmuseturniirile (Ring Event #12 WSOPC 555 € NLH Progressive Bounty). Garanteeritud on 5 kohta, kuid senine praktika näitab, et neid läheb mängu kindlasti rohkem.

Mariusel on soomlase vastu õnne Posted Saturday 27th July, 2024 at 21:07(UTC+2) by maheaaatom

Alles oli juttu viimasest soomlasest, nüüd võite siis ka lugeda, kuidas ta välja kukkus.

Marius Morel avab 120K tõstega, Matte Karjalainen vastab 520K all-in'iga ning Marius teeb pika tankimise järel calli.

Matte:

Marius:

Flop annab Mariusele open-enderi ja turn toob selle ka kohale. River soomlast ei päästa. Mariusel nüüd 2,2M.

Player		Chips	Progress
Marius Morel		2,200,000	650,000

Naistekal on kõik lootused Liisil Posted Saturday 27th July, 2024 at 21:01(UTC+2) by maheaaatom

Naisteturniiril on selgunud 11 parimat, kelle seas ka kolm Eesti mängijat. Neist on suurima stäkiga Liisi Voltri, kellel on natuke üle keskmise. Tiitlikaitsja Ave on kahjuks väljas.

Algas internetis toimub sõrmuseturniir Posted Saturday 27th July, 2024 at 20:56(UTC+2) by maheaaatom

Kõik, kes ei viitsi kasiinosse kohapeale tulla, saavad sellegipoolest WSOP kuldsõrmuse võita.

Tuleb vaid osaleda OlyBetis toimuval 350 € sisseostuga WSOP Circuit Tallinn Ring Event'il, millel on muide korralik 50 000-eurone garantii. Hiline registeerumine vältab kuni kella 23:30-ni.

Kas jõuame südaööks finaallauda? Posted Saturday 27th July, 2024 at 20:53(UTC+2) by maheaaatom

Hetkeseisuga olema eelmise aasta tempost umbes viis tundi maas, mis võiks tähendada, et kuskil südaööks peaks finaallaud koos olema. Samas mängiti mullu ka ebanormaalselt kõrge tempoga.

Must päev soomlastele Posted Saturday 27th July, 2024 at 20:49(UTC+2) by maheaaatom

Küünikud kipuvad ütlema, et kui endal läheb halvasti, aga naabritel veel halvenini, siis on kõik ju hästi.

Fakt on see, et soomlastel läks tõesti põhiturniiril kehvasti, sest nende parimaks jäi Matte B.P. Karjalaineni 20. koht. Ka lätlasi on sees vaid üks ning temagi üsna väikese stäkiga. 

20:34 (UTC+2)

Start of Level 28
Blinds: 30,000/60,000     Ante: 60,000

Eesti mängijad jätkavad telelauas Posted Saturday 27th July, 2024 at 20:33(UTC+2) by maheaaatom

Kõik kolm Eesti mängijat jätkavad telelauas, seepärast on ka meie blogi 30-minutilise viivitusega ning liigub telelaua sünkroonis.

Vahepeal katsume hoida silma peal ka teistel turniiridel.

Player		Chips	Progress
Sergei Aleksejev		3,725,000	875,000
Evgeny Vyal		3,015,000	1,415,000
Marius Morel		1,550,000	450,000

Kes on Sergei Aleksejev ja Evgeny Vyal? Posted Saturday 27th July, 2024 at 20:30(UTC+2) by maheaaatom

Paljud huvilised on küsinud, et kes on Eesti mängijad Sergei Aleksejev ning Evgeny Vyal? Uurisime siis järgi. 

Evgeny oli üsna napisõnaline - enda väitel elab Tallinnas, kuid Eestis sündinud ei ole. Pokkerit ei mängi just kuigi sageli.

Sergei Aleksejev on aga põline Maardu mees, kes varemgi Eestis toimuvatel suurfestivalidel osalenud. "Ma mängingi ainult suurematel üritustel, väikeste sisseostudega turniiridel ma tõesti ei osale. Võib-olla seepärast mind eestlased siiani väga ei tunnegi," selgitas Sergei.

Nüüd on aga Sergeil aga hea võimalus ka Eesti kommuunis tuntuks saada, kui mäng jätkub sama edukalt kui siiani. Lõpuni on muidugi veel pikk tee minna.

Lähme sööma! Posted Saturday 27th July, 2024 at 19:23(UTC+2) by maheaaatom

Kõik põhiturniiril jätkajad lubatakse 60 minutiks puhkama ning otsustavaks lahinguks jõudu koguma, teeme seda meiegi.

Kolme Eesti mängija käekäigule saate veel elada kaasa 30 minuti jooksul TV-lauas, kus nad kõik ka viibivad.

23. koht Aleksei Vandyshev 6100 € Posted Saturday 27th July, 2024 at 19:14(UTC+2) by maheaaatom

Väga lühikeseks jäänud Aleksei lükkas oma nupud sisse pärast floppi

Huvilisi oli aga teisigi, kes jätkasid panustamist ka pärast turni. Paistis, et tõmmatakse masti.

Kuna river masti ei toonud, checkiti see läbi ning täpselt nii oligi. vs. vs. Aleksei ! Pank korjati seega maha üheksate paariga ning Aleksei on mängust väljas.

Aleksei Vandyshev elab Austrias kuigi ta mängis turniiri Eesti lipu all, pole mehel enda väitel Eestiga muud seost kui see, et ta on hetkel siin aega veetmas. "Ma isegi ei tea, miks mind Eesti mängijaks liigitati," naerab Aleksei ise. Aga see selleks - mees tegi siiski toreda mängu ning tasuks kenad 6100 eurot.

Player		Chips	Progress
Aleksei Vandyshev		0	0

Telelauas suuremate muutusteta Posted Saturday 27th July, 2024 at 19:02(UTC+2) by maheaaatom

Marius on natuke juurde saanud ning hetkel 1,1M stäkiga. Turniiri liider on endiselt Sergei Aleksejev.

Endiselt 23 mängijat alles ning sellist tempot nagu eelmisel aastal, kindlasti ei ole. Septembris olid selleks ajaks juba finalistid teada.

Player		Chips	Progress
Marius Morel		1,100,000	340,000

Eesti mängijate stäkid Posted Saturday 27th July, 2024 at 18:52(UTC+2) by maheaaatom

Player		Chips	Progress
Sergei Aleksejev		4,600,000	130,000
Evgeny Vyal		1,600,000	50,000
Aleksei Vandyshev		1,250,000	150,000
Marius Morel		760,000	100,000

Kuidas meie naistel läheb? Posted Saturday 27th July, 2024 at 18:47(UTC+2) by maheaaatom

Naisteturniir käib kolmel laual ning eestlannasid on sees täpselt seitse (kokku tehti 46 sisseostu). "Huvitav, et naisi nii vähe on," imestas naiste sõrmuseturniiril viiendaks tulnud Kristiina, kes sai ise pileti freerollilt.

Meie parimatena on Liisi Voltril ja Ave Lepikul napilt üle keskmise stäkk, kuid mänguruumi on veel kõigil.

24. koht Kaspar Kaisel 5400 € Posted Saturday 27th July, 2024 at 18:34(UTC+2) by maheaaatom

Kaspar Kaiselil oli enne viimast kätt vaid 270K järgi ning saatus andis talle hea võimaluse oma stäkk vähemalt duublisse saada. 

Kahjuks läks aga teisiti. All-in mingi -ga Aleksei Vandyshevi vastu. Turnis avati neli. No ei vea eestlastel täna ikka kohe kuidagi...

Player		Chips	Progress
Kaspar Kaisel		0	0

18:28 (UTC+2)

Start of Level 27
Blinds: 25,000/50,000     Ante: 50,000

Aleksei annab ära Posted Saturday 27th July, 2024 at 18:26(UTC+2) by maheaaatom

Roberto Ahane Olsen avab 80K tõstega ning Aleksei Vandyshev kaitseb BB-d.

Flop on . Aleksei checkib ette, Rootsi mängija paneb 60K ning Aleksei teeb ületõste 235K-le. Järgneb vastase all-in (tema stäkk on meie mehest selgelt väiksem) ning Aleksei instafold.

1100 € NLH Mystery Bounty meistrisõrmus läks Soome Posted Saturday 27th July, 2024 at 18:17(UTC+2) by maheaaatom

Kell 13:00 alanud 1100 € NLH Mystery Bounty finaal on nüüdseks lõppenud soomlaste kaksikvõiduga. Rasmus J. M. Lundström sai meistrisõrmuse ning 19 850 eurot, teiseks tulnud Akseli Timonpoika Paalanen teenis aga tänu pearahadele enamgi -  29 380 eurot. Järgnesid kaks itaallast, ainsa eestlasena teise päeva jõudnud Anti Reinthal lõpetas mäletatavasti 12. kohaga.

Põhiturniiril on muide sees vaid kaks soomlast ehk nagu Soome reporter Juhani juba naljatles: "Tegemist on väga kurva päevaga Soome pokkerile." Aga võrreldes eestlastega on põhjanaabritel ikka väga hästi läinud. Eestlased pole saanud tänavu WSOP Circuit meistrisõrmust isegi mitte nuusutada.

Mäng on rahulik Posted Saturday 27th July, 2024 at 18:11(UTC+2) by maheaaatom

Põhiturniiril on laudades endiselt 24 mängijat ning kiiret ei paista kellelegi olevat. 

Päeval alanud 250 € NLH on lähenemas mullimängule, kuid eestlasi on kahjuks sees ainult üks - Priit Vanem.

Naisteturniiri populaarsus jääb selgelt alla nädala alguses toimunud sõrmuseturniirile, sest tehtud on vaid 45 sisseostu (käimas re-entry paus, mil võib veel turniiriga liituda). Eestlasi on osalejate seas natuke alla poole. 

350 € NLH deepstack ligineb juba 200 sisseostule, kuid see mäng on veel väga noor.

Kaspar annab valusa duubli Posted Saturday 27th July, 2024 at 17:55(UTC+2) by maheaaatom

Ignotas Tamasauskas avab 80K tõstega, Kaspar Kaisel lükkab BB-lt all-in. Ignotas praeb mitu minutit, otsustades viimaks siiski callida (tema stäkk ca. 835K). 

Ignotas:

Kaspar:

Flop  on meie mehele väga soodne ning Ignotas tõuseb juba istmelt püsti. 

Turn on juba ohtlik.

Ja riverisse sajabki ehk backdoor mast!

Kasparil jääb umbes 500K järgi.

Player		Chips	Progress
Kaspar Kaisel		500,000	875,000

Eesti mängijate täpsed stäkid Posted Saturday 27th July, 2024 at 17:49(UTC+2) by maheaaatom

Player		Chips	Progress
Sergei Aleksejev		4,470,000	970,000
Evgeny Vyal		1,550,000	150,000
Kaspar Kaisel		1,375,000	75,000
Aleksei Vandyshev		1,100,000	300,000
Marius Morel		860,000	370,000

Jätkame Posted Saturday 27th July, 2024 at 17:41(UTC+2) by maheaaatom

Eestlasi on mängus viis, neist telelauas kolm: Evgeny Vyal, Marius Morel ning Sergei Aleksejev. TV-ülekanne on 30-minutilise viivitusega, seega peaks seda saama näha alates kella 18:07-st.

Aleksei Vandyshev ning Kaspar Kaisel on teises lauas, kolmandas omasid pole. 

25. koht Igor Pihela noorem 5400 € Posted Saturday 27th July, 2024 at 17:17(UTC+2) by maheaaatom

Kahjuks on välja langenud ka Igor Pihela noorem. Viimased 17XBB läksid sisse -ga Sergei Aleksejevi vastu, turn äss. 

Jätkatakse kolmel laual, mis kõik kolitakse fuajeesse. Tõenäoliselt saame varsti siiski jätkata ka telelauas. 

15-minutiline tehniline paus.

Player		Chips	Progress
Sergei Aleksejev		4,300,000	800,000
Igor Pihela noorem		0	0

17:10 (UTC+2)

Start of Level 26
Blinds: 20,000/40,000     Ante: 40,000

VIDEO: Põhiturniiri teise päeva kõrghetked Posted Saturday 27th July, 2024 at 17:09(UTC+2) by maheaaatom

27. koht Mairo Tori 5400 € Posted Saturday 27th July, 2024 at 17:08(UTC+2) by maheaaatom

2023. aasta WSOP Circuit Tallinn põhiturniiril kõrge viienda koha saanud Mairo Tori lõpetab sel korral 27-ndana. Ka üldsegi mitte paha tulemus, tasuks 5400 eurot.

Mairo vaevles täna kehva kaardijooksu küüsis ning tema stäkk oli viimasel tunnil-kahel väga väike. Oleks läinud vaja kahte õnnetunud duublit, kuid paraku ei seda ei juhtunud.

Jätkab 25 parimat, eestlasi on sees kuus.

Player		Chips	Progress
Mairo Tori		0	0

Sergei elimineerib vastase ja teenib kõvasti lisa Posted Saturday 27th July, 2024 at 16:51(UTC+2) by maheaaatom

Lauas on ning pangas umbes 500K.

Sergei Aleksejev lükkab oma nupud keskele ning saab viimaks calli Eriks Kruminsilt.

Sergei:

Eriks:

Turn ega river midagi ei muuda. Konkurent väljas ning Sergei stäkk nüüd umbes 3,5M.

Player		Chips	Progress
Sergei Aleksejev		3,500,000	1,400,000

VIDEO: Kaheksanda päeva kokkuvõte Posted Saturday 27th July, 2024 at 16:39(UTC+2) by maheaaatom

Igor kaotas poole oma stäkist Posted Saturday 27th July, 2024 at 16:32(UTC+2) by maheaaatom

PFAI olid umbes 500K stäkiga norralane Gunnar Wedde ning meie Igor Pihela noorem.

Gunnar:

Igor:

Lauast abi ei tulnud, Igoril jäi umbes 500K alles.

Player		Chips	Progress
Igor Pihela noorem		500,000	850,000

Järgmine sõrmusejaht algab kell 17:00 Posted Saturday 27th July, 2024 at 16:19(UTC+2) by maheaaatom

Täna kell 17:00 algab kümnes sõrmuseturniir, 350 € NLH Deepstack, kus hiline registeerumine on lubatud kuni kella 23:00-ni. Tegemist on festivali mõttes suhteliselt "odava sisseostuga" turniiriga, lisaks on ka struktuur sügav ning võimalusi mängida küllaga. Seega peaks see sobima hästi ka paljudele hobimängijale ning mängima oodatakse väga palju inimesi.

NB! Tegemist on kahepäevase turniiriga, mis leiab oma lõpplahenduse homme.

Eestlaste stäkid suurest saalist Posted Saturday 27th July, 2024 at 16:15(UTC+2) by maheaaatom

Player		Chips	Progress
Aleksei Vandyshev		2,600,000	2,090,000
Sergei Aleksejev		2,600,000	500,000
Aleksei Vandyshev		1,400,000	890,000
Igor Pihela noorem		1,350,000	250,000
Kaspar Kaisel		1,300,000	600,000
Marius Morel		1,230,000	10,000
Mairo Tori		310,000	70,000

Jätkame Posted Saturday 27th July, 2024 at 16:02(UTC+2) by maheaaatom

Telelaua ülekanne on ajutiselt peatatud, seetõttu jätkavad neli lauda suures saalis ning viies fuajees. Põhjus on proosaline - telelaua kohal olev vahelagi laseb vett läbi ning äsja käis Tallinnast üle ka vihmahoog.

Millal TV-ülekanne jätkub, pole hetkel veel teada, kuid blogi kajastab endiselt kõike, mis puudutab Eesti mängijaid. 

Endiselt 33 mängijat ja 7 eestlast. Kõige hapumas seisus on Mairo Tori, kes kaebas pausi ajal kehva kaardijooksu üle. "Aga mul oleks vaja kaks duublit ja oleksin täiesti mängus tagasi," jäi Mairo optimistlikuks.

15:55 (UTC+2)

Start of Level 25
Blinds: 15,000/30,000     Ante: 30,000

Suure saali stäkid Posted Saturday 27th July, 2024 at 15:28(UTC+2) by maheaaatom

Algas tänane teine paus, kuhu läheb 33 mängijat. Eestlasi on sees seitse, neist viis "suures saalis" ja kaks telelauas.

Player		Chips	Progress
Sergei Aleksejev		2,100,000	900,000
Evgeny Vyal		1,700,000	400,000
Igor Pihela noorem		1,600,000	100,000
Marius Morel		1,240,000	10,000
Mairo Tori		240,000	230,000

Algas 150 € naisteturniir Posted Saturday 27th July, 2024 at 15:21(UTC+2) by maheaaatom

Äsja alanud 150 € Queens Mystery Bounty't alustas 17 mängijat, teiste seas tiitlikaitsja Ave Lepik.

Naisi tuleb aga kindlasti juurde, sest ainuüksi freerollil antakse välja veel viis kohta (hetkel sees 7 mängijat, kellest 5 Eestist). Hiline registeerumine kestab kuni 18:10-ni.

Kaspar duubeldas läbi Aleksei Posted Saturday 27th July, 2024 at 15:14(UTC+2) by maheaaatom

Veel üks vinge jaotus telelauast. Aleksei Vandyshev'i 250K kolmpanusega vaatasid nii tema kui Kaspar Kaisel floppi .

Aleksei panustas 125K ning sai Kasparilt calli.

Turnis avati , Alekseilt check, Kasparilt 160K ning Alekseilt call.

Riveri järel checkis Aleksei taas ning instacallis seejärel Kaspari 395K all-in panust.

Aleksei:

Kaspar:

Pank oli tubli 1,9M, Alekseil jäi 510K alles.

Player		Chips	Progress
Kaspar Kaisel		1,900,000	930,000
Aleksei Vandyshev		510,000	990,000

40. koht Paul Koppe 3850 € Posted Saturday 27th July, 2024 at 15:11(UTC+2) by maheaaatom

Telelauas avab Jarkko Juhani Suokas 50K tõstega ning Paul Koppe läheb all-in (335K). Soomlaselt call.

Jarkko:

Paul:

Lauast abi ei tule.

Kolmandat päeva liidrina alustanud Paulile sai eelkõige saatuslikuks ülimalt valus kaotus 2-outerile, mis jättis talle alles vaid 300 000 punkti. 

Player		Chips	Progress
Paul Koppe		0	0

Evgeny flippas leeduka välja Posted Saturday 27th July, 2024 at 14:55(UTC+2) by maheaaatom

Kasparas Klezys jammis buttonilt 530K ning Eesti mängija Evgeny Vyal mõtles SB-l pikalt, kas soovib enam kui poole oma stäkiga riskida või mitte. Aga call viimaks siiski ikkagi tuli.

Kasparas:
Evgeny:

Kasparas jäi ette kuni riverini, mis oli äss. Evgenyl nüüd umbes 1,3M. 

Player		Chips	Progress
Evgeny Vyal		1,300,000	200,000

Igor on sõiduvees Posted Saturday 27th July, 2024 at 14:45(UTC+2) by maheaaatom

Igor Pihela noorem hoiab oma lauas tugevat joont ega lase vastastel naljalt floppe vaadata. Kui vaja, teeb enne floppi tugeva kolmpanuse ja korjab nii vähehaaval nööpe. 

Igori stäkk hetkel juba 1,5M. 

Kahjuks pole häid uudiseid 1100 € Mystery Bounty'lt. Anti Reinthal langes välja 12. kohaga (1900 €) ning enam mängus ühtegi eestlast ei ole.

Player		Chips	Progress
Igor Pihela noorem		1,500,000	300,000

Kui kaua võiks täna minna? Posted Saturday 27th July, 2024 at 14:36(UTC+2) by maheaaatom

Meenutame, et eelmisel aastal käis kolmas päev tõelises turboformaadis - 60 mängija pealt jõuti üheksani kõigest kuue ja poole tunniga! Jah, te lugesite õieti.

Tänavu on mängijaid siiski natuke rohkem (kolmandat päeva alustas 68) ning struktuur aeglasem. Ja eelmine aasta mängiti tõesti ahvikiirusel. Hinnanguliselt jõuame seega finaallauni ikkagi pigem alles hilisõhtul.

Kaks naist Posted Saturday 27th July, 2024 at 14:31(UTC+2) by maheaaatom

Põhiturniiril on lisaks 39 mehele endiselt mängus ka kaks naist - Nohad Teliani Kanadast ning Vilde Bystol Fagerbakke Norrast. Mõlemal on täiesti korralik stäkk - Vildel umbes keskmine ja Nohadil umbes 75% keskmisest.

Mullu sai Eestis korduvalt hästi mänginud soomlanna Anna-Mari Hursti parima naisena 20. koha, kas sel korral suudetakse see tulemus ületada?

14:26 (UTC+2)

Start of Level 24
Blinds: 10,000/25,000     Ante: 25,000

Kõikide mängus olevate eestlaste stäkid Posted Saturday 27th July, 2024 at 14:25(UTC+2) by maheaaatom

Põhiturniiril on sees 8 Eesti mängijat, neist kolm telelauas ning viis suures saalis.

Keskmine stäkk on kerkinud juba üle miljoni (umbes 50XBB), kuid mänguruumi on veel kõigil.

Player		Chips	Progress
Aleksei Vandyshev		1,500,000	810,000
Marius Morel		1,250,000	0
Sergei Aleksejev		1,200,000	920,000
Igor Pihela noorem		1,200,000	0
Evgeny Vyal		1,100,000	400,000
Kaspar Kaisel		970,000	580,000
Paul Koppe		510,000	60,000
Mairo Tori		470,000	280,000

Igoril 1,2M, kuid võinuks olla rohkem... Posted Saturday 27th July, 2024 at 14:17(UTC+2) by maheaaatom

Igor Pihela on veel oma stäkki kasvatanud ning 1,2M punkti tundub nagu hea. 

Aga...äsja mängiti võimas pank, kus Igor avas 40K, SB tõstis 175K, BB läks all-in 850K ning ka Igor tegi sama (950K) stäkiga. SB foldis seejärel .

Igor avas , vastas . 

Meie mees sai veel lauast mastitõmbe, kuid tulemuseks siiski vaid panga poolitamine. Jah, Igoril võinuks ju kõikide loogika reeglite kohaselt olla juba 2,2 miljonit...

Endiselt 41 mängijat järgi.

Player		Chips	Progress
Igor Pihela noorem		1,200,000	700,000

46. koht Risto Pärnat, 42. koht Andre Villandberg - mõlemad 3850 Posted Saturday 27th July, 2024 at 14:03(UTC+2) by maheaaatom

Ristol oli üliväike stäkk ning see läks sisse -ga vastu. Flopis avati nii äss kui kuningas, kuid päästvat rida turn ega river Ristole ei toonud. Samuti on kahjuks väljas Andre Villandberg. 

Jätkab 41 parimat.

Player		Chips	Progress
Andre Villandberg		0	0
Risto Pärnat		0	0

Anti võitleb Mystery Bounty'l Posted Saturday 27th July, 2024 at 13:52(UTC+2) by maheaaatom

Blogivälistest ülekannetest on 1100 € NLH Mystery Bountyl mängus 17 parimat, ainsa eestlasena Anti Reinthal. Kuigi suur Anti stäkk just ei ole, kuid Anti on teada-tuntud vana võitleja. 

Suurim bounty on sel turniiril koguni 20 000 eurot, seega läheb varsti põnevaks sikutamiseks.

Käimas on ka naiste freeroll kell 15:00 algavale 150 € naistekale (38 osalejat) ning alanud on 250 € NLH Bounty (hetkel 91 sisseostu). 

Mairole väike skalp Posted Saturday 27th July, 2024 at 13:41(UTC+2) by maheaaatom

Mairo Tori avas CO-lt 45K, Christoffer Berggren aga jammis oma 5XBB stäki keskele ning see oli mõistagi Mairolt kindel call. 

Christopher:
Mairo:

Laud tõi Mairole rea. Tema stäkk nüüd 750K.

Player		Chips	Progress
Mairo Tori		750,000	50,000

Igor hävitas vastase ässad Posted Saturday 27th July, 2024 at 13:36(UTC+2) by maheaaatom

Igor Pihelal on kena miljon koos ning stäkk sellega üle keskmise. Kuidas tal õnnestus see saada?

"Kaitsesid blindi -ga, flopis . Läksime sisse, vastas ässad. Turn õnneks ruutu," kõlab Igori lühikirjeldus.

Väga heas seisus on ka Eesti pokkerimängijad Evgeny Vyal ja Sergei Aleksejev, mõlemal tublisti üle miljoni punkti.

Player		Chips	Progress
Evgeny Vyal		1,500,000	0
Sergei Aleksejev		1,300,000	1,020,000
Igor Pihela noorem		1,000,000	500,000

Alustab telelaud Posted Saturday 27th July, 2024 at 13:26(UTC+2) by maheaaatom

Paul Koppe ja Co viidi telelauda, mis alustab väikse hilinemise järel. Seega saab TV-ülekannet vaadata umbes alates kella 13:55-st ning nähtav on see ikka siit.

Põhiturniir läheb edasi, algas 23. tase. Alles 49 parimat.

13:24 (UTC+2)

Start of Level 23
Blinds: 10,000/20,000     Ante: 20,000

Täna on hea päev võitmiseks! Posted Saturday 27th July, 2024 at 13:04(UTC+2) by maheaaatom

Nii arvab Igor Pihela noorem, kes just duubli sai ning täpselt poole miljoni peale tõusis.

Ka Paul Koppe on paar blufiga lisa saanud ning hetkel on mehe stäkk 580K. Väga hästi on edenenud nii Kaspar Kaisel kui Marius Morel. 

Algas tänane esimene paus 20 minutit.

Player		Chips	Progress
Kaspar Kaisel		1,550,000	85,000
Marius Morel		1,250,000	145,000
Mairo Tori		700,000	200,000
Paul Koppe		570,000	270,000
Igor Pihela noorem		500,000	255,000
Andre Villandberg		450,000	130,000
Risto Pärnat		150,000	175,000

51. koht Ermo Kosk 3850 € Posted Saturday 27th July, 2024 at 12:56(UTC+2) by maheaaatom

Üldises möllus oleme kaotanud ka seitsmekordse Eesti meistri Ermo Kose, kes alustas tänast päeva mängitava, kuid siiski selgelt alla keskmise stäkiga (umbes 30xBB).

Viimaseks käeks jäi Jarkko Suokase pocket ässade vastu.

Player		Chips	Progress
Ermo Kosk		0	0

Paul saab ülivalusa kaotuse Posted Saturday 27th July, 2024 at 12:51(UTC+2) by maheaaatom

Yurii Zabrodotskyi (B) ja Paul Koppe (SB) vaatavad viimase 150K kolmpanuse peale floppi .

Paul paneb 225K ning ukrainlane teeb calli (hiljem väidab, et misclick).

Turn on , Paulilt jätkupanus ning lõpuks on mõlemad mehed all-in.

Paul:

Yurii: ja eestlane drawing dead.

Paulil jääb umbes 300K järgi. Suht karm algus Eesti mängijatele...

Player		Chips	Progress
Paul Koppe		300,000	1,360,000

58. koht Andre Grigorijev, 56. koht Mauri Dorbek - mõlemad 3550 € Posted Saturday 27th July, 2024 at 12:39(UTC+2) by maheaaatom

Mauri käsi käis kohe erakordselt kehvast - nupud läksid sisse pärast 3-betitud floppi Sohrab Malkari vastu. 

Sohrab:

Mauri:

Turn ... No mis sa hing oskad teha...

Väljas ka eile väga heas seisus olnud, kuid oma suurest stäkist samuti ässade paariga ilma jäänud Andre Grigorijev. Tema viimaseks käeks jäi flip -ga Jarkko Suokase vastu. Soomlasele flopist maja.

Player		Chips	Progress
Mauri Dorbek		0	0
Andre Grigorjev		0	0

60. koht Artur Külanurk, 63. koht Markku Koplimaa, 64. koht Steven Tool - kõik 3550 € Posted Saturday 27th July, 2024 at 12:27(UTC+2) by maheaaatom

Päeva algus on kiire, lühikese ajaga kaotasime veel kolm lühikese stäkiga eestlast, neist Steven Tool oli lausa ekstra-short. 

Aga out on ka Markku Koplimaa ning mullu sel turniiril kolmandaks tulnud Artur Külanurk.

Jätkab 58 parimat, blindid 10000/15000/15000 (tase 22).

Player		Chips	Progress
Steven Tool		0	0
Markku Koplimaa		0	0
Artur Külanurk		0	0

68. koht Martin Piik Posted Saturday 27th July, 2024 at 12:15(UTC+2) by maheaaatom

Martin näitas ülihead mängu avapäeval, kuid teisel jäi umbes samale tasemele ning kuigi heaks oma stäkki just ei saanud. Tema on kahjuks ka tänane esimene langeja.

Mängijad on taas laudades Posted Saturday 27th July, 2024 at 12:13(UTC+2) by maheaaatom

Action on alanud ning täna ootab meid ees pikk mängupäev kuni finaallauni. Kõik 68 mängijat paistavad ka laudades istuvat.

Alanud on ka high-roller, millest valmib samuti live-blogi Mariliisi tegemisel. Hoidke sellelgi silma peal!

12:11 (UTC+2)

Day 3 of Olympic Park Casino Started
Level: 22     Blinds: 10,000/15,000     Ante: 15,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