0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

0.0008 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/2023_estonian_championship_main_event/3/updates', 1, '2024-12-26')

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

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

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

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

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

0.0003 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.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

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

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

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

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

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

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

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

0.0060 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.0008 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` = '2023_estonian_championship_main_event'

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '17'

0.0293 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '64'
AND `published` = 1

0.0281 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0063 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '65'
AND `published` = 1

0.0277 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0058 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '67'
AND `published` = 1

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

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

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

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` = '3246'
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` = '3234'
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` = '3233'
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` = '3231'
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` = '3229'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0072 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3227'
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` = '3225'
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` = '3223'
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` = '3221'
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` = '3220'
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` = '3217'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0080 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3213'
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` = '3212'
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` = '3211'
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` = '3209'
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` = '3206'
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` = '3204'
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` = '3201'
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` = '3200'
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` = '3199'
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` = '3197'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

0.0079 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3185'
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` = '3184'
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` = '3181'
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` = '3180'
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` = '3178'
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` = '3176'
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` = '3175'
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` = '3174'
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` = '3173'
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` = '3172'
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` = '3170'
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` = '3168'
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` = '3165'
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` = '3163'
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` = '3162'
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` = '3159'
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` = '3156'
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` = '3155'
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` = '3153'
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` = '3152'
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` = '3150'
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` = '3149'
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` = '3147'
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` = '3145'
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` = '3144'
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` = '3143'
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` = '3142'
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` = '3138'
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` = '3137'
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` = '3136'
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` = '3134'
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` = '3131'
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` = '3129'
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` = '3127'
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` = '3125'
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` = '3124'
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` = '3123'
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` = '3120'
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` = '3119'
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` = '3116'
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` = '3115'
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` = '3114'
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` = '3112'
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` = '3110'
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` = '3109'
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` = '3108'
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` = '3107'
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` = '3104'
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` = '3102'
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` = '3101'
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` = '3100'
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` = '3097'
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` = '3096'
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` = '3095'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

0.0069 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3246'
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` = '3234'
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` = '3233'
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` = '3231'
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` = '3229'
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` = '3228'
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` = '3227'
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` = '3225'
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` = '3223'
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` = '3221'
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` = '3220'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0085 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3197'
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` = '3193'
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` = '3192'
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` = '3190'
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` = '3188'
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` = '3186'
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` = '3185'
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` = '3184'
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` = '3181'
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` = '3180'
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` = '3178'
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` = '3176'
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` = '3175'
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` = '3174'
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` = '3173'
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` = '3172'
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` = '3170'
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` = '3168'
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` = '3165'
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` = '3163'
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` = '3162'
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` = '3159'
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` = '3156'
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` = '3155'
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` = '3153'
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` = '3152'
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` = '3150'
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` = '3149'
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` = '3147'
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` = '3145'
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` = '3144'
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` = '3143'
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` = '3142'
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` = '3138'
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` = '3137'
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` = '3136'
ORDER BY `chip_change` DESC, `busted` ASC

0.0089 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3134'
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` = '3131'
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` = '3129'
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` = '3130'
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` = '3127'
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` = '3125'
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` = '3124'
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` = '3123'
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` = '3120'
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` = '3119'
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` = '3116'
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` = '3115'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0079 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '3112'
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` = '3110'
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` = '3109'
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` = '3108'
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` = '3107'
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` = '3104'
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` = '3102'
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` = '3101'
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` = '3100'
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` = '3097'
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` = '3096'
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` = '3095'
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` = '67'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2020

    

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(1)
  • Asian Poker Tour(5)
  • Aspers Casino Westfield Stratford City(9)
  • Battle Of Malta(1)
  • Borgata Poker(1)
  • Bratislava Poker Festival(0)
  • British Poker Series(11)
  • BSOP(0)
  • Costa Rica Poker Festival(1)
  • Dusk Till Dawn(5)
  • EAPT(1)
  • 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(0)
  • Irish Poker Open(1)
  • Irish Poker Tour(11)
  • Kings of Tallinn(1)
  • 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(5)
  • 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)
  • Unibet DeepStack Open(2)
  • Venetian Deepstack Extravaganza(1)
  • Women's Winter Festival(0)
  • WPT(1)
  • WPT Prime(1)
  • WPT Special Events(0)
  • WSOP(1)
  • 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

Estonian Poker Championship Põhiturniir (Main Event) Live Reporting - Day 3

Estonian Poker Championship - Live Reporting

Põhiturniir (Main Event) See other events

OlyBet Bounty King – EMV 2023 Opening Event Team Event 2023 Põhiturniir (Main Event)

Estonian Poker Championship - Live Reporting OlyBet Bounty King – EMV 2023 Opening Event Team Event 2023 Põhiturniir (Main Event)

---

Current Level 25 Current Day 3

---

Blinds 30,000/60,000 Ante 60000

Entries 164 Remaining 1

---

Prize Pool (EUR) €78,199 First Prize (EUR) €14,699

Chip Leaders Day 3

1

Kaidar Viikman

4,920,000

Day 1 Day 2 Day 3

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 3

00:00 (UTC+2)

Day 3 of Estonian Poker Championship Ended
Level: 25     Blinds: 30,000/60,000     Ante: 60,000

EMV põhiturniiri võitja on Kaidar Viikman - 14699 € Posted Saturday 15th April, 2023 at 21:56(UTC+2) by maheaaatom

Finaali kuuenda punktisummaga alustanud Kaidar Viikman sai EMV põhiturniiril teenitud võidu. Jah, täna jooksid tal tõepoolest ka kaardid kõige paremini (ainuüksi kolm ässade paari), kuid turniiripokkeris ei põhine võit ometi ainult kaardiõnnel.

Kaidari algus oli luurav, kuid mäng edenedes muutus ta järjest agresiivsemaks ning lõpuks suutis ka oma nimekad konkurendid üle kavaldada. Ässadega Taago Tamme bluffima meelitamine oli puhas klassika.  Sellega haaras Kaidar ohjad kindlalt ette kätte ega loovutanud neid enam kellelegi.

See on Kaidar kolmas Eesti meistritiitel. Tõsise töömehe, ETPF-i hinge ning suure pokkerisõbrana on Kaidar tähtsaima Eestisisese pokkeriturniiri võidu igati välja teeninud ning väärt ainult kiidusõnu!

Nende positiivsete nootidega me tänaseks lõpetame ning täname kõiki, kes jälgisid EMV 2023 live-blogi. Aga seda lehte ei tasuks veel kinni panna, sest Olympic Casinos jätkub paaride turniir ning ETPF-i aastagala. Viimase päevakokkuvõte leiate juba pühapäeva hommikul siitsamast OlyBetEvents.com lehelt.

2. koht - Taago Tamm 14400 € Posted Saturday 15th April, 2023 at 21:49(UTC+2) by maheaaatom

Kaidar tõstab 200K, Taago lükkab all-in ning Kaidar callib. Kaardid lauale!

Taago:

Kaidar:

Flopis avatakse

Kõik pole veel lõppenud, sest turn annab Taagole pea hea portsu oute. Aga kohele neist siiski ükski ei jõua, sest river on blank . Turniir on lõppenud, Taagole ägeda mängu eest tasuks 14400 eurot.

Player		Chips	Progress
Kaidar Viikman		4,920,000	1,820,000
Taago Tamm		0	0

21:43 (UTC+2)

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

Mehed teevad diili Posted Saturday 15th April, 2023 at 21:39(UTC+2) by maheaaatom

Järjekordne all-in - Taagol ning Kaidaril on vastu panna . Laud toob Taagole veel ühe üheksa juurde ning duubli 1,8M peale.

Kuulsime ka diilist, millega mõlemad teenivad vähemalt 14 400 eurot ning võitjale jääb 299 eurot ekstrat.

Player		Chips	Progress
Kaidar Viikman		3,100,000	700,000
Taago Tamm		1,800,000	600,000

Taago Tamm jääb ellu Posted Saturday 15th April, 2023 at 21:35(UTC+2) by maheaaatom

Juba paistis, et mäng on läbi, mis läbi, sest Taago on keskel -ga Kaidar Viikmani vastu. 

Aga show läheb siiski edasi, sest Taago tõmbab lauast rea kokku!

Pidu läheb aina hoogsamaks, laval on bänd.

Taago kaotus kasvab Posted Saturday 15th April, 2023 at 21:33(UTC+2) by maheaaatom

Taago üritab veelkord bluffida, kuid Kaidar callib ta tuimalt maha. Nüüd on Taagol järgi veel vaid 430K ning ta on juba enam kui 1:10 taga.

Player		Chips	Progress
Kaidar Viikman		3,100,000	700,000
Taago Tamm		1,800,000	600,000

Algas ETPF-i auhinnagala Posted Saturday 15th April, 2023 at 21:27(UTC+2) by maheaaatom

Õhtujuht Andres Puusepp on laval ning juhatamas sisse ETPF-i aastagalat. Samuti on sõna võtmas Olympic Casino pokkerimänedžer Meelis Ahman. 

Paaride turniiril on sees 14 parimat. Vaikselt läheb edasi ka põhiturniiri heads-up. Mäng on üsna luurav, Kaidar on veel pisut lisa saanud ning juhib hetkel juba umbes 6:1. 

3. koht - Andrey Koks 9300 € Posted Saturday 15th April, 2023 at 21:17(UTC+2) by maheaaatom

Andrey Koks lükkab oma shortstäki sisse -ga ning saab calli Kaidar Viikmani -lt. 

Taaskord on kaardijumalad Kaidari poolel. Turn on !

Turniiri mõnda aega lausa ülivõimsa ülekaaluga juhtiv Andrey saab tasuks kolmanda koha eest 9300 eurot auhinnaraha, mis on mehe senise live-karjääri suurim.

Head-up algab Kaidari 3:1 eduseisus (Kaidar 3,8M, Taago 1,2M). Väike tehniline paus. 

Player		Chips	Progress
Kaidar Viikman		3,800,000	800,000
Taago Tamm		1,200,000	100,000
Andrey Koks		0	0

Kaidar seab Taagole lõksu ja läheb liidriks Posted Saturday 15th April, 2023 at 21:11(UTC+2) by maheaaatom

Taago Tamm ründab -ga ning pocket ässad saanud Kaidar lihtsalt callib. Flopis on . Taago paneb 150K ja saab jällegi vaid calli. 

Turni järel paneb Taago juba 300K ning call järgneb ka nüüd.

River on ning Taago lähebki oodatult all-in. Loomulikult Kaidar callib ning võtab hiiglasliku 3M panga maha.

Tema nüüd ka selgelt uus chipliider. See võis vabalt olla selle turniiri võtmekäsi.

Player		Chips	Progress
Kaidar Viikman		3,000,000	1,800,000
Taago Tamm		1,100,000	1,100,000
Andrey Koks		790,000	25,000

4. koht - Kaido Koorits 7000 € Posted Saturday 15th April, 2023 at 21:03(UTC+2) by maheaaatom

Finaali liidrina alustanud pokkeristaar Kaido Koorits on kahjuks mängust väljas. 

Viimaseks käeks jääb flip pocket neljadega Kaidar Viikmani vastu. Turn on äss. 

Player		Chips	Progress
Kaido Koorits		0	0

Laksakas Kaidole Posted Saturday 15th April, 2023 at 20:55(UTC+2) by maheaaatom

Kaido () üritab taas panka jõuga maha võtta. Vastas Taago Tamme . 

Flopis on ning Taago avab 125K-ga, kuid Kaido vastab 360K ülestõstega. 

Taago ei jää passima ning läheb all-in. Selle järel foldib Kaido koheselt. 

Taago ja Kaido pushivad kordamööda Posted Saturday 15th April, 2023 at 20:48(UTC+2) by maheaaatom

Kui ei pushi Kaido, siis pushib Taago. Ja kui Taago ei pushi, on Kaido nupud keskel. Kaido stäkk on taas tõusnud üle miljoni.

Enim kannatab selles möllus kõige rahulikumalt mängiv Andrey. Kaidar on justkui kaval rebane, kes ootab rahulikult oma kohti. Ja lehed on Kaidaril täna väga hästi jooksnud.

Kaido saab Valerilt noomida Posted Saturday 15th April, 2023 at 20:44(UTC+2) by maheaaatom

Turniiridirektor Valeri käib vahepeal Kaidot noomimas ja palub tal nupud korralikult tornidesse laduda ja stäkki mitte varjata. Karistust siiski ei järgne, piirdutakse hoiatusega.

Kaido ja Taago on endiselt kõige aktiivsemad mängijad, kuid meeste stäkkides on oluline vahe. Taago on chipliider, Kaidol aga väikseim stäkk. 

Player		Chips	Progress
Taago Tamm		2,200,000	500,000
Kaidar Viikman		1,200,000	100,000
Andrey Koks		765,000	15,000
Kaido Koorits		735,000	565,000

Ave ja Kristo ei pidanud suurele pingele vastu Posted Saturday 15th April, 2023 at 20:37(UTC+2) by maheaaatom

Paaristurniiri favoriidid Kristo Erala ja Ave Lepik on mängust väljas. Viimased nupud kaotas Kristo ja need võttis ära Teele Viira.

Teelel on muide hirmuäratavalt suur stäkk ning ajaloost on teada, et temagi on just nimelt selle turniiri ühel korral varem võitnud. Täna mängib Teele koos Mairold Millertiga. 

20:35 (UTC+2)

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

KÜSIMUS: Kui kaugel on paaride turniir? Posted Saturday 15th April, 2023 at 20:33(UTC+2) by maheaaatom

Ja VASTUS: 20 parimat paari on konkurentsis. 

Põhiturniiri finaal läks samuti edasi ning kasiinosse on juba omajagu rahvast kogunenud. Näiteks vastne viiekordne Eesti meister Marko Kolk tuli kohale just selleks, et oma meistrisõrmus kätte saada. Paaristurniiril ta ei osale.

Kaido mängus tagasi Posted Saturday 15th April, 2023 at 20:15(UTC+2) by maheaaatom

Kaido Koorits on mängus tagasi!

Duubel tuleb läbi Kaidar Viikmani - Kaidol on ja Kaidaril . Kicker peab kuni lõpuni, Kaidol nüüd taas 1,3 miljonit.

Chipliider endiselt Taago Tamm 1,7M. Seisud muutuvad kogu aeg ja pidevalt. Algas järjekordne paus, tõenäoliselt mitte viimane tänasel turniiril.

Player		Chips	Progress
Taago Tamm		1,700,000	746,000
Kaido Koorits		1,300,000	300,000
Kaidar Viikman		1,100,000	600,000
Andrey Koks		780,000	68,000

Kaido duubeldab läbi Kaidari Posted Saturday 15th April, 2023 at 20:06(UTC+2) by maheaaatom

Kaido lükkab enne floppi sisse ja saab Kaidarilt callib.

Kaido:

Kaidar:

Flop ja turn on Kaidarile ohutud, riverisse avatakse aga ! Oh neid emotsioone!

Player		Chips	Progress
Kaido Koorits		520,000	480,000

Kaidar loputab Kaidoga põrandat Posted Saturday 15th April, 2023 at 19:59(UTC+2) by maheaaatom

Kaidar on vahepeal vist lõvikonservi söönud, sest tal on piisavalt julgust Kaido bluff pärast lauas avatud kaarte kuningas-kõrgega ära callida. Õige otsus, Kaidol on vaid . Hea kättemaks finaali alguses saadud "laksude eest" ning 450K pank Kaidarile.

Kaido on juba väga raskes seisus, tal vaid 9xBB. Aga senine mäng on näidanud, et kuni sul on chippe ja tool, kus istuda, on kõik alles ees.

5. koht - Erik Põlluveer 4800 € Posted Saturday 15th April, 2023 at 19:52(UTC+2) by maheaaatom

Erik peab suruma ning on selleks väga hea käsi. 

Vastas Taago Tamme , kes saab kohe flopist ühe ässa juurde. Midagi ei muuda ka turn ega river. Ja vahepeal lausa lootusetus seisus olnud Taago Tamm on sisuliselt chipliider.

Tubli töö Erik, kuigi üks koht jäi olulise edetabeli võitmiseks kahjuks puudu. EMV 2023 Aasta Mängija on seega Ermo Kosk. Palju õnne!

Player		Chips	Progress
Erik Põlluveer		0	0

Stäkkide seis Posted Saturday 15th April, 2023 at 19:44(UTC+2) by maheaaatom

Player		Chips	Progress
Kaidar Viikman		1,700,000	500,000
Kaido Koorits		1,000,000	372,000
Taago Tamm		954,000	379,000
Andrey Koks		848,000	127,000
Erik Põlluveer		355,000	427,000

Andrey duubeldab läbi Kaido Posted Saturday 15th April, 2023 at 19:39(UTC+2) by maheaaatom

Andrey lükkab oma 10XBB stäki sisse ja saab Kaido Kooritsalt calli.

Andrey:

Kaido:

Flop sobib suurepäraselt Andreyle, kuid turn viib hoopis Kaido ette. Kas kõik? Ei. River toob Andreyle masti.

Taago võtab duubli läbi Eeriku Posted Saturday 15th April, 2023 at 19:30(UTC+2) by maheaaatom

Taago Tamm ja Erik Põlluveer on enne floppi sees:

Taago:

Erik:

Erikul on stäkk kaks korda suurem, ta on tugevalt ees ning kaalul ei vähem ega rohkem kui "Aasta Mängija" tiitel. 

Paraku on flopis ja üheksa eluga Taago jätkab mängu.

Paaride turniiril sai hiline regamine läbi Posted Saturday 15th April, 2023 at 19:25(UTC+2) by maheaaatom

Paaride turniiril käib mäng 10 400 eurole ning sisseoste oli 52. Erinevaid paare peaks olema 40-45 vahel. 

Äsja oli paaride turniiril ka paus ning lõppes hiline registeerumine. Melu on hea ning lauad lõbusaid inimesi täis.

Chipliidrist chiplooseriks? Posted Saturday 15th April, 2023 at 19:15(UTC+2) by maheaaatom

Andrey on veelgi langenud, nüüd juba umbes 500K peale.

Ja ega ta väga julge all-in ka minna, just foldis Andrey Taago Tamme all-in'i peale võrdlemisi korraliku . Tuletame meelde, et mingis faasis oli Andreyl umbes sama palju chippe kui teistel kokku. Paraku muutus sellega aga ka Andrey enda mäng liiga passiivseks ning konkurendid kasutasid seda ära.

Suurturniiride kogemus on Andreyl hea, kuid päris nii tugeva live-turniiri finaallauas ta varem veel mänginud ei ole. 

Kui kaua täna läheb? Posted Saturday 15th April, 2023 at 19:12(UTC+2) by maheaaatom

Mullu vältas finaal üheksa ja pool tundi. See tähendaks, et täna käiks mäng sel juhul kella 22:30-ni. 

9-11 tundi oleks ka finaali prognoositav kestvus. Tõsi, kell 21:00 algab gala ning lavale tuleb ka bänd, kuid põhiturniir läheb ikka edasi ning küllap jõutakse võitjale ka gala ajal auhind üle anda.

Kõik sõltub muidugi ka sellest, kes lõppmängu jäävad. Hetkel paistab, et meil on kaks aktiivset, kaks passiivset ning üks keskmine mängija. Agressoriks on endiselt Kaido, kes on kahel eelmisel käel vastaseid kiusanud.

19:03 (UTC+2)

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

Stäkkide seis Posted Saturday 15th April, 2023 at 19:01(UTC+2) by maheaaatom

Player		Chips	Progress
Kaidar Viikman		2,200,000	700,000
Erik Põlluveer		782,000	295,000
Andrey Koks		721,000	479,000
Kaido Koorits		628,000	20,000
Taago Tamm		575,000	625,000

Kaidar survestab...lõpuks! Posted Saturday 15th April, 2023 at 18:57(UTC+2) by maheaaatom

Andrey ( ) tuleb blinde sööma, Kaidar Viikman () vastab all-in'iga. Küllap ka selleks, et tema järel istuva üsna ettearvamatu ning agressiivse Taago Tamme analoogset panust ennustada. 

Kõik foldivad. Tubli Kaidar, julge mäng! Finaali alguses suure chipliidi saavutanud Andrey on langenud juba alla 800K. 

46 paari Posted Saturday 15th April, 2023 at 18:52(UTC+2) by maheaaatom

Paaride turniirile on lisandunud mõned uued paarid ning nüüd on tehtud juba 46 sisseostu. Tõsi, mõned neist on ka väljalangenud paaride re-entryd. 

Kristol ja Avel polegi just kuigi suur stäkk. Aga turniir on siiski ka selgelt algfaasis. 

Vaikselt hakatakse valmistuma ka aastagalaks, vahuveini pokaalid (kuigi tühjad) on igatahes valmis pandud.

Kaido võtab natuke tagasi Posted Saturday 15th April, 2023 at 18:45(UTC+2) by maheaaatom

Kaido ja Taago on mõlemad actioni-mehed ja seekord on Kaido see, kes Taago ületõstele all-in'iga vastab.

Kuna Taago ilmselgelt bluffis, siis ta all-in'i vaatama ei lähe. 

Järgmises jaotuses on all-in Erik Põlluveer, taaskord calle saamata. Jälle kaotab natuke raha Andrey Koks.

Ja ülejärgmine jaotus - Kaido saab ässad ning soodsa olukorra, Taago tuleb tema blindi kallele. Paraku piisab vaid pisikesest ületõstest, et Taago loobuks.

Kaidar taas liidriks, Taagol 1,2M Posted Saturday 15th April, 2023 at 18:41(UTC+2) by maheaaatom

Taago ja Andrey vaatavad floppi . Andrey on küll selgelt ees ( vs. ), kuid Andrey õnnetuseks on turn . See checkitakse küll läbi ja pärast riverit teeb Taago pisikese panuse, mis meelitab Andrey callima. 

Korralik pank Taagole ja Andrey langeb 1,2M peale. 

Järgmises jaotuses on taas superkaart Kaidaril - . Kaido üritab seda panka blufiga maha võtta ning kaotab pea poole oma stäkist. Liidriks tõuseb taas Kaidar.

Player		Chips	Progress
Kaidar Viikman		1,500,000	300,000
Taago Tamm		1,200,000	877,000
Andrey Koks		1,200,000	500,000
Kaido Koorits		608,000	492,000
Erik Põlluveer		487,000	90,000

Erik jääb ellu Posted Saturday 15th April, 2023 at 18:33(UTC+2) by maheaaatom

Erik on keskel -ga, kuid tema õnnetuseks on Kaidar Viikman TAAS (!!!) kaardi leinud ning mõistagi ei kavatse oma -st loobuda.

Flop midagi head ei tõota. Hoopis parem on turn , mis toob Erikule portsu oute. Ja üks neist - - jõuab ka kohale. Pank pooleks!

Kaido läheb taas Kaidarist mööda Posted Saturday 15th April, 2023 at 18:31(UTC+2) by maheaaatom

Kaidar teeb bluffari kuulsusega Kaido vastu järjekordse hero-calli, kuid seekord Kaido ei bluffinudki. Ebaõnnestunud käik läks maksma ligi 300K. 

Juba järgmises käes üritab Kaidar () meelitada algset tõstjat Kaidot () vähemalt callima. Ei - panus oli liiga suur (200K) ning Kaido ei soovinud gämblema minna.  

Kas Erik kangutab end "Aasta Mängijaks"? Posted Saturday 15th April, 2023 at 18:25(UTC+2) by maheaaatom

Kui Erik Põlluveeril õnnestuks veel üks väljalangemine üle elada, oleks tee "Aasta Mängija" tiitlile vaba.

Lihtne see aga olema ei saa, sest Erik on chiplooser. Äsja preflopist 4-bet all-in'i teinud Taago Tamm (, calle ei tulnud) korjas oma stäkile 50% lisa ning ronis taas Erikust mööda.

Stäkkide seis Posted Saturday 15th April, 2023 at 18:21(UTC+2) by maheaaatom

Player		Chips	Progress
Andrey Koks		1,700,000	100,000
Kaidar Viikman		1,200,000	100,000
Kaido Koorits		1,100,000	100,000
Erik Põlluveer		577,000	232,000
Taago Tamm		323,000	0

18:19 (UTC+2)

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

Kaidar püüdis Taago blufi Posted Saturday 15th April, 2023 at 18:08(UTC+2) by maheaaatom

Viimane käsi enne teist pausi pakkus taas korraliku intriigi. Riveriks on lauas 

ning Kaidari () pisikesele panusele vastab Taago Tamm () 225K re-raise'iga. 

Kaidar mõtleb küll pikalt, kuid alla ei anna. Õnnestunud call tõstab ta 1,1M peale, blufiga armetult vahele jäänud Taago potsatab 323K-le.

Oleme niisiis pausil.

Player		Chips	Progress
Kaidar Viikman		1,100,000	228,000
Taago Tamm		323,000	246,000

6. koht - Mario Jürgens 3900 € Posted Saturday 15th April, 2023 at 17:59(UTC+2) by maheaaatom

Mario ( ) alustab 51K tõstega, Kaido Koorits () vastab all-in'iga. Ja Mario - võrdlemisi üllatuslikult - callib! Tõsi, tema stäkk oli ka suhteliselt väike, mängu jäi panna vaid umbes 9XBB jagu.

Flop toob küll seitsme, kuid ei enamat. Jätkab viis parimat.

Player		Chips	Progress
Kaido Koorits		1,200,000	100,000
Mario Jürgens		0	0

Kaidar tõuseb Posted Saturday 15th April, 2023 at 17:51(UTC+2) by maheaaatom

Kaidar saab Mario Jürgensi käest suure panga. Mõlemad mehed said flopist reatõmbe ning kuigi Kaidar oma oli väiksem, jõudis just see pärale. 

River tõi Kaidarile lisaks ka masti, mis küll midagi ei muutnud. Ta lükkas ka all-in, kuid Mariol ilmselgelt millegagi callida ei olnud. Pank oli siiski suur ja Mario langes 11xxBB peale.

Järgmies jaotuses parandab oma positsiooni pisut Erik Põlluveer, kelle saab jagu Taago Tamme pocket kümnetest. Kuigi palju raha keskele küll paraku ei lähe ning emand-high flopile pihta saanud Erik mängib taas võib-olla liigagi rahulikult.

Andrey on väga rahulikuks jäänud Posted Saturday 15th April, 2023 at 17:43(UTC+2) by maheaaatom

Andrey Koks on küll endiselt chipliider, kuid mängib ülirahulikult. Initsiatiivi hoiab pigem Kaido Koorits, kuigi Andreyl on 800K suurem stäkk. 

Kõik ülejäänud pigem ootavad õigeid kohti. Üsna hästi on edenenud aga Taago Tamm, kes on vaikselt tõusnud samasse kohta, kus ta päeva alguses oli. 

Player		Chips	Progress
Andrey Koks		1,800,000	200,000
Kaido Koorits		1,100,000	387,000
Taago Tamm		745,000	176,000

Erik jätab ilmse võidukäe callimata Posted Saturday 15th April, 2023 at 17:35(UTC+2) by maheaaatom

Erik ( ) ja Taago () vaatavad floppi , ka turn ei too üllataval kombel actionit.

Riveri järel lükkab Taago oma 215K stäki keskele. 

Kuigi Erikul on kaks paari ning juba pangas olevat raha arvestades peaks see olema instacall, foldib ta oma käe pika mõtlemise järel. Nii läheb raskeks EMV "Aasta Mängijaks" saada.

Player		Chips	Progress
Taago Tamm		569,000	171,000
Erik Põlluveer		345,000	159,000

Mängijate stäkid Posted Saturday 15th April, 2023 at 17:25(UTC+2) by maheaaatom

Player		Chips	Progress
Andrey Koks		2,000,000	100,000
Kaidar Viikman		872,000	90,000
Kaido Koorits		713,000	262,000
Erik Põlluveer		504,000	249,000
Mario Jürgens		415,000	68,000
Taago Tamm		398,000	164,000

37 paari Posted Saturday 15th April, 2023 at 17:17(UTC+2) by maheaaatom

Just niipalju pokkeripaare on paaride turniiril mängus. Selgituseks - mängitakse ühe stäkiga kuniks nuppe jätkub. Võib ka ühe re-entry teha.

Baarileti ääres õnnestus näha ka Marko "Naxer" Keskelit, kes jäi eile ülinapilt ilma Flip & Go turniiri tiitli kaitsmisest. "Tal oli viimases jaotuses vist üks blind rohkem. Mul mast, tal kaks paari, riveriga sai maja kätte," meenutab endiselt VIIEKORDNE Eesti meister Naxer oma öiseid üleelamusi.

7. koht - Rivo Tamm 3200 € Posted Saturday 15th April, 2023 at 17:09(UTC+2) by maheaaatom

Päeva suuruselt teise stäkiga alustanud Rivo on jäänud niivõrd lühikeseks, et -ga pole tal enam midagi oodata või mõelda. 

Call tuleb seekord Kaidar Viikmanilt (). Juba flopis on kaks ruutut ning turn toob Kaidarile ka masti kohale.

Player		Chips	Progress
Kaidar Viikman		807,000	25,000
Rivo Tamm		0	0

Kaido viga jätab Taago mängu Posted Saturday 15th April, 2023 at 17:02(UTC+2) by maheaaatom

Floppi vaatab kolm mängijat - Andrey, Kaido ja Taago.

Taago ( ) lükkab oma 124K stäkinatukese keskele ja saab kiirelt calli Andreylt (). Seejuures viskab Kaido oma käe () maha. 

Saatuslik viga, sest Andrey laua abiga midagi kokku ei saa, Kaido oleks aga kõrgema kickeriga Taago välja võtnud.

Paaristurniiri favoriit saabus Posted Saturday 15th April, 2023 at 16:55(UTC+2) by maheaaatom

Kui põhiturniiri võib võita kes iganes, siis paaristurniiril on selge favoriit juba ammu paigas. 

Mõistagi on selleks Ave Lepik, kes viimasel viiel-kuuel aastal vist ainult ühel korral esikolmikust välja jäänud.

Tiitli on ta võitnud koos Gert Laanemetsaga. Mullu tuli Ave teiseks, toona mängiti aga koos 2017. aasta EMV põhiturniiri meistri Kristo Eralaga. Sama pokkeriduo asub heitlusesse ka täna.

Kaidar kaotab "Chuck Norrisele" Posted Saturday 15th April, 2023 at 16:46(UTC+2) by maheaaatom

Kaidar ( ) tõstab panused 50K-le ning Kaido Koorits () kolmpanustab 140K. Kaidar callib.

Flop on Kaidarile mööda mis mööda. Ta checkib ette ja Kaidol piisab teha väike bluff, et pank maha korjata. 

16:41 (UTC+2)

Start of Level 21
Blinds: 12,000/24,000     Ante: 24,000

Blind blindi vastu Posted Saturday 15th April, 2023 at 16:35(UTC+2) by maheaaatom

300K stäkiga Erik ründab SB-lt ja BB-l -ga istuv Kaido Koorits peab pika mõttepausi.

Erikul pole just ülearu tight mängija reputatsiooniga, lisaks on Kaidol ka suht hea tõmbekaart.

Ei, vara veel. Lõpuks Kaido siiski foldib.

Paarimängijad kogunevad Posted Saturday 15th April, 2023 at 16:31(UTC+2) by maheaaatom

Olympic Park kasiinos on juba näha erinevaid Eesti pokkerimängijaid, kelle eesmärgiks kell 17:00 algav paaristurniir. 

Kohal on juba näiteks Kristo Erala, Maili Tannbaum, Mati Pirn, Kert Raud jt. Mõned neist vaatavad ka TV ekraanilt põhiturniiri live-ülekannet.

Kaido võtab Andreylt tagasi Posted Saturday 15th April, 2023 at 16:29(UTC+2) by maheaaatom

Kaido () ja Andrey () vaatavad floppi . Andrey checkib ette ja Kaido teeb 83K panuse. 

Turn on , mis checkitakse läbi. Riveri järel läheb Andrey 80K-ga proovima, kuid see panus on selgelt liiga väike, et Kaidot eemale peletada. 

Call tuleb ning Kaido kraabib 476K panga endale.

Player		Chips	Progress
Andrey Koks		2,100,000	100,000
Kaido Koorits		975,000	253,000

Kaido ründab shortstäkke Posted Saturday 15th April, 2023 at 16:22(UTC+2) by maheaaatom

Kaido istub nii Mario kui Taago suhtes positsioonil ning ei anna neile  hõlpu. Kui talle jagatakse, lükkab mees kohe nuppe. Blindidel olevatel shortidel midagi head käes ei ole ja tulevad kiired foldid. Aga mänguruumi neil jälle märksa vähem...

Suured poisid omavahel Posted Saturday 15th April, 2023 at 16:15(UTC+2) by maheaaatom

Kaido Koorits tuleb -ga blinde sööma ja saab kaasa chipliider Andrey Koksi ( ). 

Flop sobib mõlemale. 

Andrey checkib, Kaido paneb 56K ja saab calli.

Turn ei muuda midagi. Kaido poolt läheb seekord sisse 126K ja Andrey ei jäta siingi callimata.

River . Andrey checkib ette ja Kaido proovib 266K blufiga panka kätte saada. 

Andrey mõtleb päris pikalt, lausudes viimaks "Doesn't make any sense". Ja callib ära. 

Nüüd on Andrey juba ülivõimas chipliider ja Kaido langeb lihtsurelike sekka. 

Player		Chips	Progress
Andrey Koks		2,200,000	500,000
Kaido Koorits		722,000	478,000

15:51 (UTC+2)

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

8. koht - Kaur Ajamaa 2500 € Posted Saturday 15th April, 2023 at 15:50(UTC+2) by maheaaatom

Kaur Ajamaa avab 33K tõstega, Kaidar callib BB-lt.

Flopis avatakse ja mehed on all-in.

Kaur:

Kaidar: ! Turn ega river Kauri ei päästa ning tal jääb napp 14K alles. Järgmises jaotuses võtab Kaidar sellegi ära. Kaurilt siiski väga korralik saavutus, kaks aastat järjest EMV finaallauda pääseda on kõva sõna!

Pärast jaotuse lõppu algas finaali esimene paus, oleme tagasi 15 minuti pärast.

Player		Chips	Progress
Andrey Koks		1,700,000	100,000
Kaido Koorits		1,200,000	0
Kaidar Viikman		782,000	286,000
Rivo Tamm		382,000	97,000
Mario Jürgens		347,000	67,000
Erik Põlluveer		255,000	180,000
Taago Tamm		234,000	32,000
Kaur Ajamaa		0	0

Erik ei julge Posted Saturday 15th April, 2023 at 15:43(UTC+2) by maheaaatom

Erik Põlluveer läheb küll , kuid Rivo Tammel on niivõrd hea reputatsioon, et tema all-in käigule Erik ei vasta.

Oli õige otsus ka, sest Rivol tõepoolest parem kaart ().

9. koht - Kristjan Maasalu 1700 € Posted Saturday 15th April, 2023 at 15:36(UTC+2) by maheaaatom

Andrey avab 35K tõstega ning Kristjan Maasalu vastab 177K all-in'iga. Andrey callib.

Andrey:

Kristjan:

Flopis avatakse kaheksa ning pärast turni on Kristjan drawing dead.

Player		Chips	Progress
Andrey Koks		1,800,000	280,000
Kristjan Maasalu		0	0

Andrey võtab veel juurde Posted Saturday 15th April, 2023 at 15:27(UTC+2) by maheaaatom

Kaks panka järjest võitnud Andrey on tõusnud juba üle 1,5M ning hoiab konkurentidel survet. Tõsi, tal on kaarte ka olnud. 

Kõrgeim agressioonifaktor ning iseäranis table-talki eestvedamine on aga selgelt Kaido käes. Kõige passiivsem on siiani olnud Rivo.

Player		Chips	Progress
Andrey Koks		1,520,000	320,000

Mariole duubel Posted Saturday 15th April, 2023 at 15:19(UTC+2) by maheaaatom

Mario lükkab -ga ja saab vastu all-in panuse Taago Tamme -lt. 

Flopis on poiss ning Mario jääb mängu. Nüüd on Taago seis juba õige hapuks läinud, tal vaid 266K järgi.

Player		Chips	Progress
Mario Jürgens		414,000	199,000
Taago Tamm		266,000	47,000

Ka Kaido käib all-in Posted Saturday 15th April, 2023 at 15:13(UTC+2) by maheaaatom

Suurima stäkiga Kaido Koorits näitab, et ka tema oskab all-in lükata. See on vastuseks Kristjan Maasalu tõstele -ga. Vastuseks kiired foldid (Kaidol on pocket poiste paar). 

Väheke sai juurde Taago Tamm, kes nägi ära, et flop läks kõigile mööda ning oskas õiges kohas bluffida.

Taagol julgust jätkub Posted Saturday 15th April, 2023 at 15:04(UTC+2) by maheaaatom

Taago Tamm käib oma 313K stäkiga all-in'is ning sunnib foldima ka Kaur Ajamaa . Taagol polnud muide enamat -st. 

Suur pank Kaurile Posted Saturday 15th April, 2023 at 15:01(UTC+2) by maheaaatom

Kaur Ajamaa parandab oluliselt oma seisu, tõmmates juurde 165K punkti. Lõviosa sellest tuleb Rivo Tammelt. 

Kauril olid pocket soldatid, Rivol suur hulk tõmbeid, mis küll ükski kohale ei jõudnud.

Turniiri selged liidrid on aga endiselt Kaido ja Andrey, kõik ülejäänud on alla keskmise stäkkidega. Varsti läheb paugutamiseks, pange tähele!

Mängijate punktiseisud Posted Saturday 15th April, 2023 at 14:58(UTC+2) by maheaaatom

Player		Chips	Progress
Andrey Koks		1,200,000	100,000
Kaido Koorits		1,200,000	100,000
Kaidar Viikman		496,000	48,000
Rivo Tamm		479,000	402,000
Erik Põlluveer		435,000	48,000
Taago Tamm		313,000	38,000
Kristjan Maasalu		268,000	40,000
Kaur Ajamaa		250,000	89,000
Mario Jürgens		215,000	8,000

Kristjan duubeldab, Mario uus shortstäkk Posted Saturday 15th April, 2023 at 14:53(UTC+2) by maheaaatom

Kristjan lükkab emandatega ja saab vastu teise väikese stäki Mario Jürgensi  . Lauda numbripuru ja Kristjanile taas duubel. Chippide üldarvult läheb ta nüüd napilt Mariost mööda.

Player		Chips	Progress
Kristjan Maasalu		228,000	94,000
Mario Jürgens		223,000	129,000

Mario käib all-in'is Posted Saturday 15th April, 2023 at 14:43(UTC+2) by maheaaatom

Mario läheb -ga röövima, kuid Taago Tamm 3-panustab (75K) kaartidega . Mario ei anna alla.

Kuningas-high flopi järel ei soovi Mario midagi juhuse hooleks jätta ning lükkab kiirelt all-in. Loomulikult pole Taagol enam millegagi callida.

Ei ole see päev Taagole hästi alanud...

Player		Chips	Progress
Taago Tamm		390,000	115,000
Mario Jürgens		341,000	11,000

14:40 (UTC+2)

Start of Level 19
Blinds: 8,000/16,000     Ante: 16,000

Kristjan Maasalu saab duubli Posted Saturday 15th April, 2023 at 14:34(UTC+2) by maheaaatom

Kristjan Maasalu läheb proovima ja saab vastu Taago Tamme (). Flopis nii poiss kui üheksa.

Finaalis endiselt üheksa alles, Kristjan on tagasi samas seisus, mis päeva alguses.

Player		Chips	Progress
Kristjan Maasalu		134,000	46,000

Andrey võtab Kaurilt tagasi ning saab samuti miljonäriks Posted Saturday 15th April, 2023 at 14:32(UTC+2) by maheaaatom

Järgmies jaotuses jagatakse Andreyle täna juba teist korda pocket ässad ning õnnetul kombel saab Kaur Ajamaa () õnnetul kombel top-paarile pihta.

Andrey korjab valuet kõikidel tänavatel ning saab korraliku panga. "Valus," tõdeb Kaur.

Player		Chips	Progress
Andrey Koks		1,100,000	316,000
Kaur Ajamaa		339,000	212,000

Kaido võtab Andreylt valuet Posted Saturday 15th April, 2023 at 14:27(UTC+2) by maheaaatom

Ässaga mastitõmbe saanud Kaido meelistab Andrey bluffima ja korjab check-raise'iga umbes 130K panga maha. 

Järmises jaotuses saab Andrey ( ) küll emand-high flopis kenasti pihta, kuid ei panusta. Checkid sobivad Kaidole ( ), kes saab turnist ässa ning omakorda ise kõrgeima paari. 

Kaido on kaval ning võtab valuet nii turnil kui riveril. Saab makstud ka.

Player		Chips	Progress
Kaido Koorits		1,300,000	300,000
Andrey Koks		784,000	168,000

Kaido liidriks Posted Saturday 15th April, 2023 at 14:14(UTC+2) by maheaaatom

Veel ühe väikese panga võitnud Kaido tõusis miljoni chipini ning võttis liidripositsiooni Andreylt üle.

Player		Chips	Progress
Kaido Koorits		1,000,000	8,000

Kaido näksab Kaurilt Posted Saturday 15th April, 2023 at 14:12(UTC+2) by maheaaatom

Neli mängijat vaatab floppi . Kaur avab 35K-ga ja saab calli vaid positsioonilt istuvalt Kaidolt. 

Turn on ning nüüd Kaur checkib. Kaido paneb nüüd 45K ja Kaur muckib.

(Meeste kaardid: Kaur ja Kaido )

Kaidol on nüüd peaaaegu sama palju kui Andreyl.

Kristjanil selg vastu seina Posted Saturday 15th April, 2023 at 14:06(UTC+2) by maheaaatom

Kristjan Maasalu stäkk on langenud 88K peale, mis on vaid 7XBB. 

Esimese pooltunni selgelt agressiivseimaid mängijad on Andrey, Kaido ja Taago. Neist viimasele on lahtine mäng küll üsna kalliks maksma läinud...

Eriku, Mairo, Kaidari ja Mario pole veel agressiooni näidanud.

Player		Chips	Progress
Kristjan Maasalu		88,000	42,000

Andrey tõuseb uueks liidriks Posted Saturday 15th April, 2023 at 14:00(UTC+2) by maheaaatom

Andrey, Kaido ja Taago vaatavad esimese eestvõtmisel 110K-ga emand-high floppi. 

Andrey tulistab 75K ja korjab panga maha. Tal nüüd 952 000, mis viib ta mängu liidriks.

(Kõigil meestel olid käes paarid - Andreyl soldatid, Kaidol kaheksad ja Taagol kolmed).

Player		Chips	Progress
Andrey Koks		952,000	174,000

Erik korjab kõvasti juurde Posted Saturday 15th April, 2023 at 13:55(UTC+2) by maheaaatom

Erik ja Taago vaatavad floppi . Erik panustab 32K ja saab Taagolt calli.

Turn on ning Erik avab taas 105K panusega. Taago callib jälle

River on ning see chekitakse läbi. 

Erik avab , Taagol on untsu läinud mastitõmme -.  

Meeste stäkid nüüd suhteliselt võrdsed: Taagol 505K ja Erikul 483K

Player		Chips	Progress
Taago Tamm		505,000	213,000
Erik Põlluveer		483,000	201,000

Mis on täna veel kavas? Posted Saturday 15th April, 2023 at 13:32(UTC+2) by maheaaatom

Kell 17:00 algab paaristurniir ning kell 21:00 aastagala. DJ Alvar Orula käis ka just oma varustust paika sättimas, tema hakkab meist lõbustama õhtupoole. 

Kommentaator Kristjan Laas on samuti kohal ning köhib just oma häält puhtaks. 

Veel veerand tundi ülekande alguseni!

Kellest saab EMV 2023 Aasta Mängija? Posted Saturday 15th April, 2023 at 13:27(UTC+2) by maheaaatom

Hetkeseis Aasta Mängija arvestuses on järgmine: 

1. Ermo Kosk 59 punkti
2. Markku Koplimaa 48 punkti
3. Marko Kolk 42 punkti
4. Erik Põlluveer 38 punkti

Ermo, Markku ja Marko enam punkte juurde teenida ei saa. Erik Põlluveer võidab juhul kui saavutab põhiturniiril vähemalt neljanda koha. Esikolmikusse võib tõusta ka Kristjan Maasalu (parimal juhul teiseks), kuid selleks on vaja ideaalset asjade kokkulangemist.

Põhiturniiri finaal on alanud! Posted Saturday 15th April, 2023 at 13:15(UTC+2) by maheaaatom

Turniiridirektor Meelis Ahman juhatas mängijad pidulikult laudadesse ning tehti ära ka finaallauda pildid. 

Täpselt kell 13:14 läks mäng käima. Kuna nii meie ülekanne kui live-stream on 30-minutilise viivitusega, siis põhiturniiri uuendustega läheb veel natuke aega.

Põhiturniiri finalistide tutvustus Posted Friday 14th April, 2023 at 10:46(UTC+2) by maheaaatom

Kaido Koorits 

Punkte: 992 000

Eesti meistritiitleid: 4

Koht Hendoni Eesti rahalistis: 35

Kaido on elukutseline pokkerimängija ning avalikkusele ka selgelt tuntuim finalist. Oma esimese meistritiitli võitis ta juba 2011. aastal ning viimase alles mullu paarismängus. Kaido tugevuseks on nii agressiivne mängustiil kui table-talk, lisaks on tal ka suurim stäkk. Seega hoiab tõenäoliselt just Kaido finaallauas tempot.  

--

Rivo Tamm 

Punkte: 881 000

Eesti meistritiitleid: 0

Koht Hendoni Eesti rahalistis: 526

Rivo teekond finaallaua suuruselt teiseks stäkiks kulges otsekui märkamatult. Teda polnud küll ülearu näha, kuid targad otsused ning õiged käigud tagasid kokkuvõttes edu. Rivol on kaks EMV põhiturniiri cashi ning 10 aastat tagasi jõudis ta ka finaallauda, saavutades toona kuuenda koha. 

--

Andrey Koks 

Punkte: 778 000

Eesti meistritiitleid: 0

Koht Hendoni Eesti rahalistis: 259

Sarnaselt Rivole polnud ka IT-taustaga Andrey mäng põhiturniiri esimesel ja teisel päeval ülearu silmatorkav, küll aga tulemuslik. Alati sõbralik Andrey on mänginud pokkerit üle 10 aastat ning korjanud erinevatelt Eestis toimuvatelt turniiridelt ka ridamisi neljakohalisi cashe. Eriti aktiivseks on ta muutunud aga just viimasel aastal. 

---

Taago Tamm 

Punkte: 718 000

Eesti meistritiitleid: 0

Koht Hendoni Eesti rahalistis: 69

Erinevalt kahest eelmisest mehest paistis Taago turniiri esimestel päevadel vägagi silma. Ta jõudis olla korduvalt ka turniiri chipliider ning mängis üldse väga aktiivselt. Deep-stack turniirid Taagole sobivad, ta on olnud selles formaadis võidukas nii Kings of Tallinnal kui Tallinn Summer Showdownil.  Mullusel Battle of Maltal jõudis ta koguni kahel päeval järjest poodiumile. Kindlasti alustab Taago ka EMV põhiturniiri finaali vaid võidumõtetega.  

---

Kaur Ajamaa 

Punkte: 551 000

Eesti meistritiitleid: 0

Koht Hendoni Eesti rahalistis: 232

Kaur on ambitsioonikas ja kirglik mängija, kellel on samuti üsna korralik live-mängude kogemus. Ta on ainus põhiturniiri finalist, kes jõudis sinna ka eelmisel aastal (toona viies koht). Tõenäoliselt üsna ebamugav vastane kõigile.

---

Kaidar Viikman 

Punkte: 448 000

Eesti meistritiitleid: 2

Koht Hendoni Eesti rahalistis: 347

ETPF-i tööhobusena tuntud Kaidar Viikman jäi teel finaali väga tagasihoidlikuks, tuues esile hoopis vastaste head taset. See võis aga olla vaid sõjakavalus. Kaidaril on kaks EMV tiitlit, tohutu mängukogemus ning ta oli muuseas ka see mees, kes sai teise koha 12 aastat tagasi toimunud tollasel maailma läbi aegade suurimal online-turniiril (200 000 osalejat).

---

Mario Jürgens 

Punkte: 330 000

Eesti meistritiitleid: 0

Koht Hendoni Eesti rahalistis: 930

Mario alustas EMV põhiturniiri turbopäevast (muide koos Taago Tammega), mille ta ka võitis. Teisel päeval pidas mehe stäkk samuti ilusti vastu. Live-pokkeris on Mario finalistidest võib-olla isegi kõige tundmatum, kuid cashe on ta noppinud näiteks nii tänavusel kui ka mullusel Kings of Tallinnal. 

---

Erik Põlluveer 

Punkte: 282 000

Eesti meistritiitleid: 2

Koht Hendoni Eesti rahalistis: 218

Erik on Kaido ja Taago kõrval kolmas raskekaallane, kelle ainsaks nõrkuseks on suhteliselt väike stäkk. Kogemusi on mehel kõvasti ning ka tänavustel tiitlivõistlustel on Erik kulgenud soodsas pärituules. High-rolleril teine, 8-Game'is kolmas, Pot Limit Omaha Hi-Lo's kuues... Vähemalt neljas koht põhiturniiril tagaks talle suure tõenäosusega ka EMV "Aasta Mängija" tiitli.

---

Kristjan Maasalu 

Punkte: 130 000

Eesti meistritiitleid: 0

Koht Hendoni Eesti rahalistis: 158

Kristjan on hästi tuntud kõikidele Eesti hobimängijatele. Ta on mänginud üle 10 aasta peamiselt väikese sisseostuga turniire ning olnud paljudel neist ka edukas. 2019. aastal oli ta EMV põhiturniiril kümnes, nüüd on seegi saavutus ületatud. Ainus häda on selles, et Kristjani stäkk on paganama väike. Aga üks duubel, siis teinegi...ja ega tea midagi!

EMV põhiturniiri finaal algab kell 13:00 Posted Friday 14th April, 2023 at 09:52(UTC+2) by maheaaatom

Laupäeval selgub Olympic Park kasiinos EMV tähtsaima, 555-eurose sisseostuga põhiturniiri tšempion. Samuti toimub paaristurniir ning pidulik auhinnagala.

Meie blogi toimub telelauaga sünkroonis ning põhiturniiril toimuvast kirjutame seega 30-minutilise nihkega (seega alustame umbes kell 13:30-13:45). Paaristurniirist ja muust põnevast kirjutame aga reaalajas. Ülekanne toimub kuni põhiturniiri võitja selgumiseni. Eelkõige sobib blogi neile pokkerifännidele, kes ei soovi kogu aeg telepilti vaadata, kuid olla siiski kursis kõige olulisemate sündmuste ning finaali kulgemisega.

09:44 (UTC+2)

Day 3 of Estonian Poker Championship Started
Level: 18     Blinds: 6,000/12,000     Ante: 12,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