0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0125 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Est/1A/updates'
ORDER BY `views` DESC

0.0190 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_1100_Main_Event_Est/1A/updates'

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

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

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

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

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

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

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

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

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

0.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.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

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

0.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.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0036 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` = '2024_KOT_1100_Main_Event_Est'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '97'

0.0298 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '242'
AND `published` = 1

0.0276 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` = '247'
AND `published` = 1

0.0273 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0093 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '249'
AND `published` = 1

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

0.0278 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` = '257'
AND `published` = 1

0.0274 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` = '262'
AND `published` = 1

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '97'
AND `name` = '1A'

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

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

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` = '10742'
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` = '10730'
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` = '10728'
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` = '10725'
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` = '10722'
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` = '10715'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

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

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

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

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

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

0.0096 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10635'
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` = '10633'
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` = '10632'
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` = '10629'
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` = '10621'
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` = '10617'
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` = '10614'
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` = '10612'
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` = '10611'
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` = '10603'
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` = '10598'
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` = '10587'
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` = '10583'
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` = '10577'
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` = '10574'
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` = '10572'
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` = '10569'
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` = '10568'
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` = '10562'
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` = '10560'
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` = '10559'
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` = '10557'
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` = '10553'
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` = '10552'
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` = '10549'
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` = '10543'
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` = '10538'
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` = '10537'
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` = '10535'
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` = '10534'
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` = '10529'
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` = '10528'
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` = '10527'
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` = '10523'
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` = '10521'
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` = '10518'
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` = '10516'
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` = '10514'
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` = '10512'
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` = '10508'
ORDER BY `chip_change` DESC, `busted` ASC

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

0.0056 SECONDS: 
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '242'
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` = '10742'
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` = '10730'
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` = '10728'
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` = '10725'
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` = '10722'
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` = '10715'
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` = '10709'
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` = '10703'
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` = '10701'
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` = '10696'
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` = '10692'
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` = '10689'
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` = '10679'
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` = '10677'
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` = '10668'
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` = '10661'
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` = '10659'
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` = '10656'
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` = '10654'
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` = '10649'
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` = '10644'
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` = '10639'
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` = '10635'
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` = '10633'
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` = '10632'
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` = '10629'
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` = '10621'
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` = '10617'
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` = '10614'
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` = '10612'
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` = '10611'
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` = '10603'
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` = '10598'
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` = '10587'
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` = '10583'
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` = '10577'
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` = '10574'
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` = '10572'
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` = '10569'
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` = '10568'
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` = '10562'
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` = '10560'
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` = '10559'
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` = '10557'
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` = '10553'
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` = '10552'
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` = '10549'
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` = '10543'
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` = '10538'
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` = '10537'
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` = '10535'
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` = '10534'
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` = '10529'
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` = '10528'
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` = '10527'
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` = '10523'
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` = '10521'
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` = '10518'
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` = '10516'
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` = '10514'
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` = '10512'
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` = '10508'
ORDER BY `chip_change` DESC, `busted` ASC

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

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

    

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(2)
  • Women's Winter Festival(0)
  • WPT(2)
  • 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

Kings of Tallinn 2024 Event #29: €1,100 Main Event (Estonian) Live Reporting - Day 4

Kings of Tallinn 2024 - Live Reporting

Event #29: €1,100 Main Event (Estonian) See other events

Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

Kings of Tallinn 2024 - Live Reporting Event #12: €555 Championship (English) Event #29: €1,100 Main Event (English) Event #42: €5,000 High Roller (English) Event #49: €3,000 NLH (English) Event #3: €350 Kings of Tallinn Cup (Estonian) Event #12: €555 Championship (Estonian) Event #27: €150 Celebrity Event (Estonian) Event #29: €1,100 Main Event (Estonian) Event #42: €5,000 High Roller (Estonian) Event #49: €3,000 NLH (Estonian) Event #12: €555 Championship (Finnish) Event #29: €1,100 Main Event (Finnish) High Roller Events (Finnish)

---

Current Level 34 Current Day 4

---

Blinds 200,000/400,000 Ante 400000

Entries 914 Remaining 1

---

Prize Pool (EUR) €859,160 First Prize (EUR) €120,910

Chip Leaders Day 4

1

Edgaras Kausinis

27,420,000

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

Live Updates Chip Counts Structure Gallery Payouts

SHARE

1 New Update - Click to refresh

Live Updates - Day 1A

Eestlaste stäkid päeva 1A järel Posted Wednesday 28th February, 2024 at 22:07(UTC+2) by maheaaatom

Avapäeva 1A elas üle 87 mängijat, neist 16 eestlast. Päeva liidriks on Christian Rysgaard, parimad meie mängijad (Kaido Mikk ja Aleksei Smirnov) asuvad üldises pingereas vastavalt viiendal ja kuuendal kohal.

Päev 1B algab neljapäeval kell 12:00 ning liituda võivad nii uued mängijad kui need, kes täna välja langesid. Peatse kohtumiseni!

Player		Chips	Progress
Kaido Mikk		171,700	141,700
Aleksei Smirnov		170,000	140,000
Kris Tikka		141,600	111,600
Herli Olop		131,500	24,500
Aleksander Sebastian Lattikas		113,600	83,600
Maksim Petrov		110,400	80,400
Tarmo Tammel		104,000	24,000
Henri Käsper		101,600	71,600
Neeme Org		69,600	39,600
Silver Simulask		65,200	35,200
Siim Suviste		56,900	26,900
Artur Külanurk		36,900	6,900
Martin Zobel		34,500	4,500
Eedi Kirves		32,700	2,700
Ragnar Toompere		32,200	2,200
Rauno Tahvonen		24,800	5,200

Danielsson püüab auku-rea, Pihela kahjuks väljas Posted Wednesday 28th February, 2024 at 20:49(UTC+2) by maheaaatom

Päeva ühes viimases käes saab Igor Pihela üsna valusa kaotuse osaliseks.

Flopi järel panustab Malca Eli Danielsson 7500, Igor teeb vastu tavapärase min-tõste 15 000 ja saab calli.

Turni järel on nupud keskel, Igoril ning Danielssonil . Igoril vähemalt pool stäkki läinud ning päris päeva lõpus läks kahjuks ka see.

Ühtlasi on mäng tänaseks läbi, peagi avaldame kõikide allesjäänud eestlaste täpse punktiseisu.

Player		Chips	Progress
Kaido Mikk		171,700	141,700
Aleksei Smirnov		170,000	140,000
Kris Tikka		141,600	111,600
Herli Olop		131,500	24,500
Aleksander Sebastian Lattikas		113,600	83,600
Maksim Petrov		110,400	80,400
Tarmo Tammel		104,000	24,000
Henri Käsper		101,600	71,600
Neeme Org		69,600	39,600
Silver Simulask		65,200	35,200
Siim Suviste		56,900	26,900
Artur Külanurk		36,900	6,900
Martin Zobel		34,500	4,500
Eedi Kirves		32,700	2,700
Ragnar Toompere		32,200	2,200
Rauno Tahvonen		24,800	5,200
Igor Pihela vanem		0	0

Algab viimaste käte jagamine Posted Wednesday 28th February, 2024 at 20:38(UTC+2) by maheaaatom

Alustatakse viie viimase käe jagamist, seega on päev peagi läbi. 

Neile, kes veel soovivad täna mängima tulla, infoks, et kell 21:30 algab 555 € NLH shorthand ning kell 23:00 150-eurone põhiturniiri satelliit. 

Kaidol ja Maksimil 100K Posted Wednesday 28th February, 2024 at 20:28(UTC+2) by maheaaatom

Üsna korralike stäkkidega on turniiril veel Kaido Mikk ja Maksim Petrov, mõlemal on umbes 100K.

Kahjuks väljas Ralf Hamburg ja Margus Tuvikene.

Veel pool tundi lõpuni Posted Wednesday 28th February, 2024 at 20:20(UTC+2) by maheaaatom

Saalis on märksa vaiksemaks jäänud, sest laudades juba alla 100 mängija. Ja eks igaüks üritab nüüd maksimumi anda, et võimalikult hea stäkiga teise päeva jõuda.

Kahjuks on out Ranno Sootla, kuid kindlasti võtab see mees juba homme ette uue katse. Ka Hendrik Uibo ja Allan Arjut ei istu enam omal kohal.

Player		Chips	Progress
Tanel Merida		0	0
Hendrik Uibo		0	0

Championshipi võitis soomlane Posted Wednesday 28th February, 2024 at 20:12(UTC+2) by maheaaatom

Eestlastele väga hapult kulgenud 700 sisseostuga 555 € Championship sai ka läbi ning selle võitis Mikko Tapani Ylämäki. Kaks parimat tegid diili, seega sai Mikko 57 860 ning teiseks tulnud leedulane Andrius Bielskis 49 000 eurot.

Eestlaste parimaks jäi mäletatavasti Dmitri Zatsiki 35. (!) koht. See häbi tuleb nüüd põhiturniiril kindlasti maha pesta.

Mathias Siljander on tänagi lauas Posted Wednesday 28th February, 2024 at 19:58(UTC+2) by maheaaatom

Aastaid tagasi Tallinnas imetegusid teinud Mathias Siljander (muuhulgas ka 2019. aasta Summer Showdown põhiturniiri võitja) istub samas lauas Herli Olopiga, kuid on sel korral vähem agressiivne kui tavaliselt. "Varem ikka 3-betid pea iga käega ja iga kaardiga, täna on ta rahulikum," iseloomustab Herli. 

Tõsi, Mathiasel pole täna kõrval ka tavapärast õllekannu. Ja stäkki ka mitte kuigivõrd, vast ainult nii 70K, mis on täiesti keskmine. 

Herli ise on pidevalt actionis olnud, alles sai ta ühe shordi kätte -ga vs. , siis andis jälle teisele ära (blindide sõda vs. ), mõlemal korral kõrgem pocket pidas. Ja korra bluffis ta 6-kõrgega ka Siljanderi enda välja.

Herlil igati tubli 135K stäkk ehk kahekordne keskmine.

19:48 (UTC+2)

Start of Level 8
Blinds: 500/1,000     Ante: 1,000

Tammelile duubel, Pihela võtab ka juurde Posted Wednesday 28th February, 2024 at 19:48(UTC+2) by maheaaatom

Tammeli-Pihela lauast kaks head uudist.

1. Flopi järel on Tammel sees pocket kuningatega mastitõmbe vastu. Kunnid peavad. 

2. Kohe selle järel mängivad action-panga Mindaugas Kriauciunas ja Igor Pihela vanem.

Kolmpanustatud flopi järel avab leedulane 6200-ga, Igor teeb min-tõste 12400. Leedulaselt call.

Turni järel checkib vastane ette ja Igor panustab 7500. Calli ei tule.

Tarmol umbes 80K, Igoril 150K. 

Player		Chips	Progress
Igor Pihela vanem		150,000	20,000
Tarmo Tammel		80,000	50,000

Kairit mängust väljas Posted Wednesday 28th February, 2024 at 19:36(UTC+2) by maheaaatom

Kairit on natuke pahane, sest suur osa tema stäkist oli läinud ühele vastasele, kes tema - enda sõnul ülitight mängija imagoga - blufi - boardiga pocket neljadega ära callis.

Päris viimaseks käeks jäi vs. ning lauast abi ei tulnud. 

Player		Chips	Progress
Kairit Leibold		0	0

Herli püüab veel ühe blufi Posted Wednesday 28th February, 2024 at 19:23(UTC+2) by maheaaatom

Herli () avab UTG-lt ning saab kaasa BB-l istuva hispaanlase. 

Flopis on , Herli teeb väikese panuse ja saab calli.

Turni järel panustab juba vastane terve panga ulatuses ning Herli callib.

River on , hispaanlane paneb nüüd juba 17K ning Herli mõtleb pikalt. Viimaks tuleb call, vastas on puhas bluff (). Herlil nüüd 107K.

Player		Chips	Progress
Herli Olop		107,000	32,000

Georgi kaotab hiigelpanga Posted Wednesday 28th February, 2024 at 19:18(UTC+2) by maheaaatom

Georgi Abuladze ja Maximilian Johnnie Sanders kütavad juba enne floppi sisse 14K. 

Avatakse . Inglane avab 6K panusega ja saab calli.

Turn on , Sanders paneb nüüd juba 25K ning Georgi mõtleb pikalt, kuniks teatab, et on all-in (ca. 75K) Sanders callib koheselt.

Georgi:

Sanders:

River ei muuda midagi, punktid loetakse kokku ning Georgile jääb 1,5xBB järgi. Pank oli ligi 200K, seega väga valus kaotus.

Mängu jätkab 130 pokkerisportlast Posted Wednesday 28th February, 2024 at 18:59(UTC+2) by maheaaatom

130 mängijat on laudades tagasi. Eestlastest on üks suuremaid stäkke Joosep Toolil (125 000), kelle oleme siiani kahetsusväärselt tähelepanuta jätnud. 

Kohe on algamas 150-eurone turboturniir.

18:56 (UTC+2)

Start of Level 7
Blinds: 400/800     Ante: 800

Viimane paus Posted Wednesday 28th February, 2024 at 18:39(UTC+2) by maheaaatom

Mängijad läksid viimasele pausile. Hea uudis on see, et Herli callis meisterlikult ära ühe vastase bluffi ja Allan jäi ise bluffides vahele. Aga mõlemad on kenasti mängus, Herli koguni 85K stäkiga.

Player		Chips	Progress
Herli Olop		75,000	45,000

Kris saab neliku Posted Wednesday 28th February, 2024 at 18:28(UTC+2) by maheaaatom

Eesti värve kaitsev Kris Tikka on tõusnud juba 120K peale, saades äsja duubli Soome highrollerilt Roope Tarmilt. 

PFAI jaotuses oli Krisil , Roopel seevastu. 

Laud andis veel kaks kuningat - võimas käsi!

Allan duubeldab Posted Wednesday 28th February, 2024 at 18:24(UTC+2) by maheaaatom

Allanil õnnestub oma 25K stäkk duublisse saada. 

Nupud läksid sisse pärast floppi ja turni . Õigemine oli Allanil selleks hetkeks juba nii palju raha keskel, et foldida polnud enam kuidagi võimalik.

Tema õnneks ilmnes, et ka vastane panustas õhuga (). 

-ga mänginud Allani õnneks tõi river open-enderi kohale. 

Lätlane kukutab Erki Posted Wednesday 28th February, 2024 at 18:17(UTC+2) by maheaaatom

Riveriks oli lauas ning niigi suure stäkiga Läti pokkerimängija Yaniv Peretz lükkas oma nupud meie Erki Andressoo vastu keskele.

Erki mõtles mitu minutit, otsustades viimaks oma allesjäänud 16 000 punktiga ikkagi calli. Ei olnud õige otsus:

Yaniv:

Erki:

See oli Erkile juba teine bullet ning hetkeseisuga ta turniirile naasnud ei ole. 

Murdepunkt? Posted Wednesday 28th February, 2024 at 18:07(UTC+2) by maheaaatom

Oleme jõudnud päevaga 1A faasi, mil aktiivsete mängijate arv hakkab pigem vähenema. Uusi liitujaid enam väga peale ei tule ja väljalangejatel on küll võimalik end 60XBB tagasi osta, kuid paljud eelistavad ikkagi algusest alustada. Selleks on veel kaks võimalust - homme kell 12:00 algav 1B ja 21:00 turbo-versioonis mängitav 1C.

Lauas ka Henri Käsper Posted Wednesday 28th February, 2024 at 17:56(UTC+2) by maheaaatom

Eesti pokkerilegend ning live-turniiridel üle miljoni euro teeninud Henri Käsper on samuti kohal ning istub samas lauas Tarmo Tammeli ning Herli Olopiga. 

Henril oli iseäranis edukas 2023. aasta ning tõenäoliselt valitakse aasta live-mängijaks just kas tema või Tarmo Tammel. Loodame, et mehed annavad teineteisele väärika lahingu ka Kings of Tallinn 2024 põhiturniiril.

Ülimenukas 250 € Bounty Posted Wednesday 28th February, 2024 at 17:49(UTC+2) by maheaaatom

250-eurosel bounty-turniiril on juba tehtud 265 sisseostu ning re-entry periood pole veel kaugeltki lõppenud. 

Kuna tegemist on tänase odavaima (mitte-turbo) turniiriga, on kohal ka hulk hobimängijaid.

Lauas ka tõeline küürvaal Posted Wednesday 28th February, 2024 at 17:40(UTC+2) by maheaaatom

Multimiljonärist ettevõtja ning pokkerisõber Paul Newey on samuti kohal. Tegemist mehega, kes muuhulgas cashinud ka kuulsal WSOP miljonidollarilise sisseostuga turniiril. Et sellised mehed Tallinnas mängivad, annab tunnistust sellele, et oleme Euroopas ikka väga kõrgelthinnatud sihtkoht!

Igor on veelgi juurde saanud Posted Wednesday 28th February, 2024 at 17:35(UTC+2) by maheaaatom

Igor Pihela stäkk on juba 130K, mis on eestlastest suurim. Hendrik Uibo on ka pisut juurde saanud ning hetkel 80K peal. Georgil on umbes 60K. 

Suurem osa eestlastest istub aga endiselt algstäkil. Muidugi mäng on veel noor, ainuüksi esimest päeva on veel jäänud 3 taset.

Player		Chips	Progress
Igor Pihela vanem		130,000	40,000
Hendrik Uibo		80,000	50,000
Georgi Abuladze		60,000	30,000

17:32 (UTC+2)

Start of Level 6
Blinds: 300/600     Ante: 600

Võõrad suled Posted Wednesday 28th February, 2024 at 17:32(UTC+2) by maheaaatom

Aleksei Smirnov on üks kuuest Eesti mängijast, kel sõrmes ka WSOP Circuit meistrisõrmus. Ja seda kannab Aleksei uhkusega.

Paraku ilmneb, et sõrmusekandjaid on teisigi, üks neist istub koguni tema vastas ning sel mehel on sõrmes kaks WSOP Circuit kuldsõrmust. Ja temagi ei häbene neid näitada. Mis aga kõige veidram, Hendoni andmetel pole see mees ühtegi sõrmust tegelikult võitnud.

"Ebay's, igal pool ju müüakse kõike," naerab Aleksei ise.

Profid omavahel Posted Wednesday 28th February, 2024 at 17:28(UTC+2) by maheaaatom

Kolmandas lauas võitlevad Eesti pokkeriproff Urmo Velvelt (CO) ning Eestis elab Hispaania pokkeripro I Roura Adria Comas (BB). Enne floppi läheb panka juba 8000 punkti.

Flopis avatakse , Urmo panustab 4K ette ja saab calli.

Turn on , Urmo proovib nüüd 10K-ga, kuid hispaanlane callib järjekindlalt. 

Riverisse avatakse , nüüd Urmo checkib ja vastane läheb all-in. Urmo foldib, jättes umbes 25K alles. 

Algas tänane esimene põhiturniiri megasatelliit Posted Wednesday 28th February, 2024 at 17:15(UTC+2) by maheaaatom

Fuajees läks käima põhiturniiri megasatelliit, mille sisseost on 80 eurot. Garanteeritud on vähemalt 5 x 1100 € piletit. Turniiri alustas 49 mängijat ning mõistagi tuleb neid juurde. Overlayd oodata pigem ei tasu, küll on tegemist aga soodsaima allesjäänud võimalusega pileti hankimiseks.

Omaha-turniiri esikoht läks Saksamaale Posted Wednesday 28th February, 2024 at 17:10(UTC+2) by maheaaatom

1100 € PLO leidis just oma lõpplahenduse, võitjaks tuli sakslane Per-Thorben Kasten, kes teenis 21 150 €. Heads-up'is sõlmiti diil ning nii sai finaalivastane Jacob Plickert Reinholdt Taanist isegi 100 eurot rohkem. Kolmandaks tuli eestlastele juba märksa rohkem tuttav lätlane Davis Modans.

Mängiti 101 520 eurole ning sisseoste tehti 108. Nagu varem juba mainitud, ei õnnestunud ühelgi eestlasel auhinnarahadesse jõuda.

5. päeva videokokkuvõte Posted Wednesday 28th February, 2024 at 17:01(UTC+2) by maheaaatom

200 sisseostu täis Posted Wednesday 28th February, 2024 at 16:56(UTC+2) by maheaaatom

Teise täissaja plaan on täidetud, kohalikest staaridest on viimasena liitunud Allan Arjut. 

Pudeneb ka. Stanislav Smeljovi stäkk sulas nagu tänavune lumi ning mees on mängust väljas. Ka Tarmo Tammel pidi korra kassas käima.

Aleksandr kaitseb edukalt blindi Posted Wednesday 28th February, 2024 at 16:52(UTC+2) by maheaaatom

Ranno Sootla ründab CO-lt blinde 1100-ga ning saab calli BB-ll istuvalt Aleksandr Kupermanil.

Flop on , Aleksandr checkib, Ranno panustab 2000 ja saab calli.

Turni järel kordub sama.

River järel checkib Aleksandr taas ette ja Ranno koputab samuti lauale. 

Aleksandr avab ning korjab panga maha.

Kuidas mängida pokkerit ilma käteta? Posted Wednesday 28th February, 2024 at 16:43(UTC+2) by maheaaatom

Erivajadustega inimesi on suurtel turniiridel ennegi nähtud - kohe meenub näiteks pime pokkerimängija Steven Iglesias - ning me näeme ka Kings of Tallinnal. 

Tugiisikut pole vaja. Mängija istub lihtsalt diileri vasakul käel, kes näitab talle kaardid ette ning mängija ütleb seejärel oma otsuse. Žetoone liigutab seejärel juba diiler. 

Meeldiv, et ka erivajadustega inimesed saavad pokkerit mängides lõbusalt aega veeta ning et nendega arvestatakse. Muide - seesama mees  kasutab aktiivselt ka varvastega täiesti tavaliselt nutitelefoni. Proovige, kas saate samaga hakkama :)

16:38 (UTC+2)

Start of Level 5
Blinds: 200/500     Ante: 500

Puhkama Posted Wednesday 28th February, 2024 at 16:20(UTC+2) by maheaaatom

Mängijad lubatakse puhkama, pool tänasest päevast on mängitud. 

Hendrik Uibo palub öelda, et tema stäkk on umbes 60K. "Alles oli ka 80K. Aga mul oli flush-draw, mis ei tulnud kokku. Vastane callis ässadega ära."

Pausi ajal saab osaleda nii flipamentidel kui ka minna sööma. Täna pakub Olybet Bar & Grill näiteks kanavardaid riisiga. 

Läheneme 200 sisseostule Posted Wednesday 28th February, 2024 at 16:13(UTC+2) by maheaaatom

Hetkel on tehtud 193 sisseostu ning aega mänguga liitumiseks on veel küllaga. Tuntud tegijatest on lauda istunud veel Tõnis Viik, Kaido Mikk ja Rauno Tahvonen. 

Georgi ja Ralf katsuvad pilkudega jõudu Posted Wednesday 28th February, 2024 at 15:56(UTC+2) by maheaaatom

Ralf Hamburg ja Georgi Abuladze peavad maha korraliku psühholoogilise lahingu. Paugutamine käib enne floppi ning ületõsteid on tehtud korduvalt, lõpuks lükkab Ralf 8000 ning Georgi vastab sellele 19K panusega.

"Palju sul on?" uurib Ralf ning Georgi vastab, et 47K. Seejärel jõllitavad veel mõlemad teineteist, Georgi varjab seejuures veel eriti hoolikalt oma pead ja nägu, Ralf seevastu on väga vaba hoiakuga. Lõpuks ta siiski foldib ja Georgi korjab nupud kokku.

Herli haukab tükikese Stanislavi stäkist Posted Wednesday 28th February, 2024 at 15:45(UTC+2) by maheaaatom

Herli Olop on lauas tagasi ning peab just maha väikese heitluse Stanislav Smeljoviga. 

Riveriks on pangas 10 100 punkti ning lauas  ning Stanislav avab 5100-ga. Herli vastab 15K ületõstega ning Stanislav foldib.

Herlil umbes keskmine stäkk, Stanislavil oluliselt alla selle. 

Six-six-six Posted Wednesday 28th February, 2024 at 15:39(UTC+2) by maheaaatom

Eedi Kirves tõstab buttonilt 800, Roman Jezov callib ning Maikel Homin lükkab BB-lt 3300 juurde. Kõik callivad.

Lauas avatakse saatanlik flop

Roman checkib, Maikel paneb 3500 ning saab calli vaid Eedilt. 

Turni avatakse ning seekord ründab Maikel veelgi tõsisemalt 6500-ga. Sellele Eedi enam vastama ei hakka.

15:28 (UTC+2)

Start of Level 4
Blinds: 200/400     Ante: 400

Eestlaste laud Posted Wednesday 28th February, 2024 at 15:28(UTC+2) by maheaaatom

Neljandasse lauda on sattunud koguni neli Eesti mängijat - Maikel Homin, Rene Krause, Eedi Kirves ja Roman Jezov. Viimane neist oli meie parim eilsel 250 € NLH turniiril, saavutades seal kuuenda koha. Neile on pakkumas konkurentsi muuhulgas nimekas Soome pokkeriproff ning tõeline kivinägu Roope Tarmi, kes võitis muuhulgas mulluse WSOP Circuit Tallinn highroller turniiri.

Laua selgelt aktiivseim mängija on Maikel, kuid erilist edu ta veel saavutanud pole, sest mehel on natuke alla algstäki.

Igor ruulib Posted Wednesday 28th February, 2024 at 15:09(UTC+2) by maheaaatom

Kiire ülevaade näitab, et ühelgi eestlasel peale Igor Pihela vanema keskmisest märksa suuremat stäkki veel ei ole.

Igoril on kuskil 90K ning see on tulnud kõik esimese bulletiga. Tarvo Mäesepp ja Andres Reisenbuk on aga paraku mängust väljas ning pole näha, et nad oleksid turniiriga taasliitunud.

Player		Chips	Progress
Igor Pihela vanem		90,000	60,000

Algab tänane esimene kõrvalturniir Posted Wednesday 28th February, 2024 at 15:00(UTC+2) by maheaaatom

Kohe on algamas tänane esimene kõrvalturniir, 250 € sisseostuga NLH Progressive Bounty. Hetkel on kirjas juba 57 võistlejat ning võib eeldada, et see turniir kujuneb võrdlemisi rahvarohkeks.

800-900K auhinnafond on reaalne Posted Wednesday 28th February, 2024 at 14:58(UTC+2) by maheaaatom

Mängijad usuvad, et tänavusel põhiturniiril lüüakse kindlasti eelmiste aastate rekord üle ning auhinnafond võib ulatuda isegi 800-900 tuhande euroni. Miljonit veel esialgu ei usuta. 

Tuletame meelde, et mullune auhinnafond oli  673 050 eurot ning sisseoste kogunes 716. Mis veelgi tähtsam - turniiri esikoht jäeti Eestisse ning selle ei saanud juhuslik mängijad, vaid hinnatud pokkeriproff, eelkõige cashgame-eksperina tuntud Priit Parmasto. 

164 sisseostu Posted Wednesday 28th February, 2024 at 14:48(UTC+2) by maheaaatom

Mängijaid aina lisandub, lauas on juba Maikel Homin, Mart Rinken ja Ranno Sootla. 

Herli Olopi esimene katse läks aia taha, ka Lauri Raag ja Ivar Rühka peavad kasutama järgmist õlekõrt.

Tiimide võistlusel eestlased endiselt kolmandad Posted Wednesday 28th February, 2024 at 14:32(UTC+2) by maheaaatom

Tiimide arvestuses on hetkeseisuga liidrid "KIIRED JA VIHASED", kuid sellest nimest ei tasu veel euroofiasse sattuda, sest tegemist on soomlastega. 

Parim Eesti tiim "TIME" (Tammel, Arjut, Uibo ja Morel) on kolmandad. Neist ainsana on hetkel võistlustules Hendrik Uibo. 

Kohal on ETV Posted Wednesday 28th February, 2024 at 14:26(UTC+2) by maheaaatom

Turniirile on saabunud ETV kaamerad ning Aet Süvari isiklikult. Väga tore, et pokker saab taaskord meedias head tähelepanu ning nagu me teame, sisaldub peagi ilmuvas loos ka intervjuu ühe tuntud Eesti superässaga.

Põhiturniir jätkub ning ka 555 € Championship on jõudnud viimaks finaallauani, mis mängitakse telekaamerate all.

14:23 (UTC+2)

Start of Level 3
Blinds: 100/300     Ante: 300

Esimene paus Posted Wednesday 28th February, 2024 at 14:04(UTC+2) by maheaaatom

Põhiturniiril osalejad lubati esimest korda puhkama.  Esimese kahe taseme jooksul tehti 143 sisseostu ning hetkel on laudades 134 mängijat. Et midagi väga märgilist veel juhtunud pole, tuleneb eelkõige sellest, et keskmine stäkk on 150xBB ning niisama tõmblemiseks puudub igasugune vajadus.

Tuletame meelde, et me mängime täna kaheksa taset, igaüks vältab täpselt tunni . Pausid toimuvad iga kahe tunni järel ning kokku on neid kavas kolm.

Championshipil veeretatakse nuppe Posted Wednesday 28th February, 2024 at 13:52(UTC+2) by maheaaatom

Kui suures saalis toimub PLO edeneb kiirelt (päeva alustas 14 parimat, nüüd on neist pooled juba välja langenud), siis Championship'il käib paras passimine - alustas 13 mängijat, nad on juba umbes tunni mänginud ning välja pole kukkunud keegi. 

Suuremat tähelepanu ma kummalegi turniirile selles blogis pöörama ei hakka, sest eestlasi mängus pole. 

Tanelil korralik algus Posted Wednesday 28th February, 2024 at 13:50(UTC+2) by maheaaatom

Tanel Merida on suutnud oma stäki juba enam kui kahekordistada ja istub hetkel 64K peal.

"Õnnestus alguses kaks suuremat panka võita," on Tanel enda algusega rahul. 

Kairit lauas on nüüd ka rohkem rahvast, ka äsjased SPA-mehed on puhanud ja värskete nägudega seal istet võtnud.

Player		Chips	Progress
Tanel Merida		64,000	34,000

Veel uusi tulijaid Posted Wednesday 28th February, 2024 at 13:40(UTC+2) by maheaaatom

Oleme jõudnud 128 sisseostuni, viis mängijat on pidanud ka re-entry tegema.

Meie ässadest on lisandunud Mark Metsla ja Igor Pihela vanem. Viimane on avapäevadel tuntud väga lahtise ja agressiivse mängu poolest. Eks põhjus ikka selles, et Igorit huvitavad ainult tipmised kohad ning oma stäki kindlustamiseks tuleb alguses ka riske võtta. 

Põrgusse see pokker, SPA on lahedam Posted Wednesday 28th February, 2024 at 13:38(UTC+2) by maheaaatom

Kairiti-lauas on endiselt vaid neli "elus" mängijat, kaks stäkki tiksuvad tühja. Põhjus olevat selles, et nende omanikud panid oma stäkid küll jooksma, kuid pokkerit mängida ei viitsi. SPA-s olevat lahedam.

Teistele lauakaaslastele see olukord muidugi meeldib. Tasuta raha on laual, loomulikult võetakse see hea meelega vastu.

13:09 (UTC+2)

Start of Level 2
Blinds: 100/200     Ante: 200

100 mängija piir ületatud Posted Wednesday 28th February, 2024 at 13:08(UTC+2) by maheaaatom

Mängijaid tuleb iga minutiga juurde ning saja mängija piir sai sellega ületatud. Teiste seas on lisandunud näiteks Herli Olop ja Stanislav Smeljov.

Magnus haarab re-entry järele Posted Wednesday 28th February, 2024 at 13:05(UTC+2) by maheaaatom

2022. aasta EMV põhiturniiri võitja Magnus Puki esimene bullet läks "piima järele" ning mees on pidanud võtma ette teise katse. "Midagi hullu pole, võitsin selle pileti nagunii online-satelliidilt," tõdeb mees ise. 

Suur action olla toimunud enne floppi - UTG avas, CO kolmpanustas, Magnus tegi buttonilt nelipanuse ja UTG vastas veel 5-betiga. Magnuselt call.

Flopis avati ning pank suurenes kahe panuste arvelt veel umbes 40% võrra.

Turn checkiti läbi, riveri järel läks vastane all-in ning Magnus callis -ga. Vastas paraku .

Tänased turniirid Posted Wednesday 28th February, 2024 at 12:44(UTC+2) by maheaaatom

Lisaks põhiturniirile ja kahele täna lõppevale kahepäevasele turniirile viiakse täna läbi veel kolm turniiri:

- Kell 15:00 250 € NLH Progressive Bounty

- Kell 19:00 150 € NLH Turbo

- Kell 21:30 555 € NLH Shorthand

Lisaks ka pauside ajal toimuvad 150-eurosed flipid ning kaks põhiturniiri satelliiti, mis algavad vastavalt kell 17:00 ja 23:00. Neist esimesel osalemine maksab 80 eurot (5 piletit GTD) ja teisel 150 eurot (10 piletit GTD). 

Teisipäevane kiire kokkuvõte Posted Wednesday 28th February, 2024 at 12:38(UTC+2) by maheaaatom

Eestlastest kuulub eilse suurima kangelase au kindlasti kossuässale Merike Andersonile, kes saavutas 500 sisseostuga (!) kuulsuste eriturniiril kõrge viienda koha ning teenis 3320 eurot. "Kuulsustest" jõudsid rahadesse ka Ott Kiivikas ja Silver Laas, parima Eesti mängijana oli Viktor Blinov kolmas. Võitis Küprose pokkerimängija Sinnos Eleftherio. 

555 € Championshipi teine päev läks eestlastel totaalselt aia taha, parimana saavutas Dmitri Zatsik 35. koha. Kohe hakatakse ka selgitama turniiri võitjat ning finaal mängitakse telelauas. Päris finaalini läheb veel aega, hetkel on alles 13 parimat. 

Kahepäevasel 1100 € PLO 4/5 Championshipil tehti 108 sisseostu ning kohe on algamas ka finaalpäev. Eestlasi kahjuks mängus enam ei ole. 

 165 sisseostuga 250 € NLH 8-handed lõppes soomlase Jarmo Saloneni võiduga. Ning mõistagi tekitas omajagu melu ka Olympic Casinos toimunud vastuvõtt naismängijatele koos tasuta turniiriga, mille viis parimat teenisid pileti laupäevasele naisteturniirile.

Urmo on lauas tavapärasest varem Posted Wednesday 28th February, 2024 at 12:26(UTC+2) by maheaaatom

Maailmaklassi superässadest on juba lauas Urmo Velvelt, kes tunnistab isegi, et see on tema jaoks üsna ebatavaliselt vara.

Aga kohal on ka Magnus Pukk, Tanel Merida, Hendrik Uibo, Silver Simulask jt. 

"Aga mulle meeldibki shorthand!" Posted Wednesday 28th February, 2024 at 12:23(UTC+2) by maheaaatom

Kui enamikes laudades on viis-kuus mängijat, siis selles, kuhu sattus Kairit Leibold (ning peagi ka Aleksandr Kuperman) on mängijaid vaid kolm. 

"Aga mulle meeldibki shorthand," ei lase Kairit tujul langeda. Naerab ka diiler.

 

Mäng on alanud Posted Wednesday 28th February, 2024 at 12:17(UTC+2) by maheaaatom

Esimesed 68 julget on laudades istet võtnud, umbes kümmekond eestlast nende seas. Täna mängitakse 8x60 minutit ehk umbes kella üheksani.

12:16 (UTC+2)

Day 1A of Kings of Tallinn 2024 Started
Level: 1     Blinds: 100/100     Ante: 100

Põhiturniir algab kell 12:00 Posted Wednesday 28th February, 2024 at 11:33(UTC+2) by maheaaatom

Head pokkerisõbrad! Täna algab Kings of Tallinn 2024 põhiturniir. Avapäev mängitakse kolmes voorus ning kolmapäeval on kavas neist esimene - 1A.

 

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