0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0068 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-10-28'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_fin/2/updates'
ORDER BY `views` DESC
0.0371 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-10-28'
AND `url` = 'https://www.maineventtravel.com/live-reporting/kings_of_tallinn_autumn_2024_main_fin/2/updates'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.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.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.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.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0403 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.0109 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` = 'kings_of_tallinn_autumn_2024_main_fin'
0.0138 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '217'
0.1922 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0190 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '454'
AND `published` = 1
0.1343 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0331 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '456'
AND `published` = 1
0.1129 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0189 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '458'
AND `published` = 1
0.1370 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0567 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '463'
AND `published` = 1
0.0135 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '217'
AND `name` = '2'
0.0128 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '456'
ORDER BY `busted` ASC, `current_chips` DESC
0.0485 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` = '456'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0325 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19274'
ORDER BY `chip_change` DESC, `busted` ASC
0.0208 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19273'
ORDER BY `chip_change` DESC, `busted` ASC
0.0463 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19264'
ORDER BY `chip_change` DESC, `busted` ASC
0.0264 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19262'
ORDER BY `chip_change` DESC, `busted` ASC
0.0189 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19259'
ORDER BY `chip_change` DESC, `busted` ASC
0.0255 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19258'
ORDER BY `chip_change` DESC, `busted` ASC
0.0412 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19254'
ORDER BY `chip_change` DESC, `busted` ASC
0.0206 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19253'
ORDER BY `chip_change` DESC, `busted` ASC
0.0315 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19249'
ORDER BY `chip_change` DESC, `busted` ASC
0.0476 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19247'
ORDER BY `chip_change` DESC, `busted` ASC
0.0260 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19245'
ORDER BY `chip_change` DESC, `busted` ASC
0.0258 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0459 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19240'
ORDER BY `chip_change` DESC, `busted` ASC
0.0311 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19238'
ORDER BY `chip_change` DESC, `busted` ASC
0.1721 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19236'
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` = '19233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0239 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19231'
ORDER BY `chip_change` DESC, `busted` ASC
0.1683 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19230'
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` = '19229'
ORDER BY `chip_change` DESC, `busted` ASC
0.0255 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0247 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19221'
ORDER BY `chip_change` DESC, `busted` ASC
0.0460 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0304 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19219'
ORDER BY `chip_change` DESC, `busted` ASC
0.0248 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19216'
ORDER BY `chip_change` DESC, `busted` ASC
0.0481 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19214'
ORDER BY `chip_change` DESC, `busted` ASC
0.0197 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19213'
ORDER BY `chip_change` DESC, `busted` ASC
0.0199 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0478 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19210'
ORDER BY `chip_change` DESC, `busted` ASC
0.0260 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0197 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19205'
ORDER BY `chip_change` DESC, `busted` ASC
0.1140 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19202'
ORDER BY `chip_change` DESC, `busted` ASC
0.0466 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0311 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0195 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19196'
ORDER BY `chip_change` DESC, `busted` ASC
0.0781 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19192'
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` = '19191'
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` = '19189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0444 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19188'
ORDER BY `chip_change` DESC, `busted` ASC
0.0271 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0299 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19183'
ORDER BY `chip_change` DESC, `busted` ASC
0.0494 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19181'
ORDER BY `chip_change` DESC, `busted` ASC
0.0142 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0340 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19177'
ORDER BY `chip_change` DESC, `busted` ASC
0.0466 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19176'
ORDER BY `chip_change` DESC, `busted` ASC
0.0413 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19175'
ORDER BY `chip_change` DESC, `busted` ASC
0.0272 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19174'
ORDER BY `chip_change` DESC, `busted` ASC
0.0382 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19169'
ORDER BY `chip_change` DESC, `busted` ASC
0.0257 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19168'
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` = '19165'
ORDER BY `chip_change` DESC, `busted` ASC
0.0592 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19164'
ORDER BY `chip_change` DESC, `busted` ASC
0.0199 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19159'
ORDER BY `chip_change` DESC, `busted` ASC
0.0260 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19158'
ORDER BY `chip_change` DESC, `busted` ASC
0.0526 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19157'
ORDER BY `chip_change` DESC, `busted` ASC
0.0241 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19152'
ORDER BY `chip_change` DESC, `busted` ASC
0.0356 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19151'
ORDER BY `chip_change` DESC, `busted` ASC
0.1472 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19147'
ORDER BY `chip_change` DESC, `busted` ASC
0.0408 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19144'
ORDER BY `chip_change` DESC, `busted` ASC
0.0200 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19143'
ORDER BY `chip_change` DESC, `busted` ASC
0.0938 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19141'
ORDER BY `chip_change` DESC, `busted` ASC
0.0528 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19139'
ORDER BY `chip_change` DESC, `busted` ASC
0.0161 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0271 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19136'
ORDER BY `chip_change` DESC, `busted` ASC
0.0421 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19134'
ORDER BY `chip_change` DESC, `busted` ASC
0.0208 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19132'
ORDER BY `chip_change` DESC, `busted` ASC
0.0251 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19129'
ORDER BY `chip_change` DESC, `busted` ASC
0.2583 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19128'
ORDER BY `chip_change` DESC, `busted` ASC
0.0243 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19126'
ORDER BY `chip_change` DESC, `busted` ASC
0.0248 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19123'
ORDER BY `chip_change` DESC, `busted` ASC
0.1453 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0245 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0190 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19117'
ORDER BY `chip_change` DESC, `busted` ASC
0.0562 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0198 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0262 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '456'
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_id` = '456'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0752 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19274'
ORDER BY `chip_change` DESC, `busted` ASC
0.0174 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19273'
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` = '19264'
ORDER BY `chip_change` DESC, `busted` ASC
0.0286 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19262'
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` = '19259'
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` = '19258'
ORDER BY `chip_change` DESC, `busted` ASC
0.0173 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19254'
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` = '19253'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19249'
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` = '19247'
ORDER BY `chip_change` DESC, `busted` ASC
0.0499 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19245'
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` = '19241'
ORDER BY `chip_change` DESC, `busted` ASC
0.0221 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19240'
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` = '19238'
ORDER BY `chip_change` DESC, `busted` ASC
0.0175 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0994 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19233'
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` = '19231'
ORDER BY `chip_change` DESC, `busted` ASC
0.0304 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19230'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19229'
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` = '19227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0189 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19221'
ORDER BY `chip_change` DESC, `busted` ASC
0.0276 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19220'
ORDER BY `chip_change` DESC, `busted` ASC
0.0391 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19219'
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` = '19216'
ORDER BY `chip_change` DESC, `busted` ASC
0.0174 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19214'
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` = '19213'
ORDER BY `chip_change` DESC, `busted` ASC
0.0270 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0410 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19210'
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` = '19206'
ORDER BY `chip_change` DESC, `busted` ASC
0.0164 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19205'
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` = '19202'
ORDER BY `chip_change` DESC, `busted` ASC
0.0285 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19199'
ORDER BY `chip_change` DESC, `busted` ASC
0.0418 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19197'
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` = '19196'
ORDER BY `chip_change` DESC, `busted` ASC
0.0093 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19192'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19191'
ORDER BY `chip_change` DESC, `busted` ASC
0.0185 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19189'
ORDER BY `chip_change` DESC, `busted` ASC
0.0591 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19188'
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` = '19186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0170 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19183'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19181'
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` = '19178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0369 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19177'
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` = '19176'
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` = '19175'
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` = '19174'
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` = '19169'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0168 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19165'
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` = '19164'
ORDER BY `chip_change` DESC, `busted` ASC
0.0328 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19159'
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` = '19158'
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` = '19157'
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` = '19152'
ORDER BY `chip_change` DESC, `busted` ASC
0.0170 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19151'
ORDER BY `chip_change` DESC, `busted` ASC
0.0111 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19147'
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` = '19144'
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` = '19143'
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` = '19141'
ORDER BY `chip_change` DESC, `busted` ASC
0.0273 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19139'
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` = '19138'
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` = '19136'
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` = '19134'
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` = '19132'
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` = '19129'
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` = '19128'
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` = '19126'
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` = '19123'
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` = '19120'
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` = '19119'
ORDER BY `chip_change` DESC, `busted` ASC
0.0457 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19118'
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` = '19117'
ORDER BY `chip_change` DESC, `busted` ASC
0.0128 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19115'
ORDER BY `chip_change` DESC, `busted` ASC
0.0129 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '19114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '458'
ORDER BY `busted` ASC, `current_chips` DESC
0.0066 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2596
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.
TOP5 ja suomalaiset Posted Friday 25th October, 2024 at 23:42(UTC+0) by Juhani Tyriseva
Top-5 ja suomalaiset:
Serhii Leonov 1052K Elias Suhonen 896K Enea Subashi 712K Angel Alonso Rodriguez 665K Tommy Piiroinen 653K Luka Sorainen 573K Vu Vuong 550K Julius Kettunen 481K Kalle Parkkinen 481K Eero Abbey 379K Kasper Mellanen 317K Jarkko Suokas 252K Sebastian Wahl 238K Aku Uotila 160K Samuli Segerman 150K Jussi Hietalahti 85K Mikael Haapaniemi 81K Jari Mähönen 80K Mathias Siljander 79K Roope Tarmi 79K Joonas Helin 74K Johan Alen 56K Henri Ojala 53K Hai Hoang 12K
Nyt kiitos seurasta ja hyvää yötä!!
Rolandas on turnauksen bubble boy Posted Friday 25th October, 2024 at 23:14(UTC+0) by Juhani Tyriseva
Rolandas Aglinskas.
Rolandas meni all in keskeltä, Samuli Segerman maksoi isosta.
Rolandas
Samuli
Floppi
Turn
87 pelaajaa, lopetetaan tältä päivältä. Suomalaisten countit hetken kuluttua.
River ja Samuli vei Rolandasin merkit värillään.
88 pelaajaa, tasan bubblessa ollaan Posted Friday 25th October, 2024 at 22:12(UTC+0) by Juhani Tyriseva
Yksi pelaaja putosi, kun ei pärjännyt vihun kädelle, kymppi tuli turniin.
88 pelaajaa, tasan bubblessa siis ollaan.
Yhä 89 pelaajaa Posted Friday 25th October, 2024 at 22:02(UTC+0) by Juhani Tyriseva
Edelleen 89 pelaajaa. Pienimmät pinot ovat kyllä kuivuneet, nyt on kolme alle 30K pinoa pöydissä.
Suomalaisista huonoimmassa tilanteessa on Hai Hoang, jolla on 25K, mutta button seuraavassa jaossa, joten jonkin verran hengitystilaa on.
Aloitetaan pelaamaan hand for hand Posted Friday 25th October, 2024 at 21:51(UTC+0) by Juhani Tyriseva
89 pelaajaa, turnausjohto p äätti että aletaan pelaamaan hand for hand jo nyt, niin stallauksesta ei ole kenellekään enää hyötyä. Tämä päätös on harvinainen, mutta jos näyttää siltä että stallausta selkeästi on, on päätös ihan ymmärrettävä.
Tavoitteena on siis pelata niin kauan, että kaksi pelaajaa putoaa, sitten pussitetaan merkit.
Kunkut voittavat jätkät Posted Friday 25th October, 2024 at 21:44(UTC+0) by Juhani Tyriseva
Jarkko Suokas avasi, Bahadir Hatipoglu maksoio takaa, ja Elias Suhonen isosta.
Floppi Bahadir löi 20K, Elias kippasi, Jarkko maksoi.
Turn sököteltiin.
River Jarkko löi 35K, maksu.
Jarkko näytti kolme kunkkua.
Pettynyt Bahadir käänsi näkyviin jätkäparin.
21:17 (UTC+0)
Start of Level 18 Blinds: 3,000/6,000 Ante: 6,000
Yksi taso vielä pelataan - Puhkeaako bubble? Posted Friday 25th October, 2024 at 21:17(UTC+0) by Juhani Tyriseva
Ollaan päästy 91 pelaajaan.
Nyt alkaa illan viimeinen taso, bb ante 6K, blindit 3K/6K.
Turnausjohto ilmoitti juuri, että tällä kertaa pelataan lisää, jos bubble ei puhkea. Toivon ja uskon kyllä, että bubble tunnin pelin aikana puhkeaa, ilman jatkoaikaakin.
Tärkeät tuplat Sebastianille Posted Friday 25th October, 2024 at 21:04(UTC+0) by Juhani Tyriseva
"Juu, tuplat tuli Taago Tammia vastaan. Avasin kädellä, Taago painoi all in isommalla pinollaan, maksoin. Taagolla oli
Floppiin tuli kolme herttaa, joten 12-outtista Taago veti, mutta ei onneksi osunut", iloitsi Sebastian Wahl.
Sebastianilla nyt noin 280K.
Suomalaisten pinot Posted Friday 25th October, 2024 at 20:56(UTC+0) by Juhani Tyriseva
Suomalaiset:
Mikael Haapaniemi 160K
Sebastian Wahl 80K
Jussi Hietalahti 140K
Pekka Ikonen 290K
Mathias Siljander 140K
Jarkko Suokas 70K
Aku Uotila 330K
Tommy Piiroinen 530K
Julius Kettunen 390K
Henri Ojala 210K
Hai Hoang 40K
Elias Suhonen 560K
Eero Abbey 460K
Kalle Parkkinen 515K
Joonas Helin 160K
Roope Tarmi 130K
Luka Sorainen 560K
Jari Mähönen 150K
Kasper Mellanen 330K
Samuli Segerman 160K
Joelin pelit päättyivät Posted Friday 25th October, 2024 at 20:53(UTC+0) by Juhani Tyriseva
Pudonneita:
Joel Salmirinne.
96 pelaajaa.
Lisää suomalaisilmeitä Posted Friday 25th October, 2024 at 20:26(UTC+0) by Juhani Tyriseva
Seppo Parkkinen.
Olli Muukkonen.
Muutama suomalaiskasvo Posted Friday 25th October, 2024 at 20:24(UTC+0) by Juhani Tyriseva
Mainio kuvaajamme Elena Kask on ottanut taas lisää kuvia meikäläisistä.
Jarmo Solja.
Zahid Bhuiyan.
Mikko Ylämäki.
20:12 (UTC+0)
Start of Level 17 Blinds: 2,000/5,000 Ante: 5,000
Zhun pelit päättyivät Posted Friday 25th October, 2024 at 20:01(UTC+0) by Juhani Tyriseva
Pudonneita:
Hengtao Zhu.
"Pikku pinon työnsin kädellä, vihu maksoi kädellään josta en ohi päässyt", kertoi Zhu
Suomalaispinoja Posted Friday 25th October, 2024 at 19:46(UTC+0) by Juhani Tyriseva
Suomalaisia:
Mikael Haapaniemi 70K
Sebastian Wahl 160K
Pekka Ikonen 300K
Mathias Siljander 90K
Vu Vuong 400K
Jarkko Suokas 190K
Aku Uotila 310K
Tommy Piiroinen 315K
Julius Kettunen 270K
Henri Ojala 200K
Hai Hoang 85K
Elias Suhonen 430K
Eero Abbey 430K
Kalle Parkkinen 230K
Joonas Helin 190K
Roope Tarmi 165K
Luka Sorainen 430k
Kasper Mellanen 250K
Jari Mähönen 160K
Hengtao Zhu 54K
Samuli Segerman 200K
Keskistakki 202K.
Ollin ja Saulin pelit päättyivät Posted Friday 25th October, 2024 at 19:42(UTC+0) by Juhani Tyriseva
Pudonneita:
Olli Muukkonen
Sauli Haapaniemi
105 pelaajaa.
Bubble lähestyy, rivit harvenee Posted Friday 25th October, 2024 at 19:34(UTC+0) by Juhani Tyriseva
Pudonneita:
Mikko Ylämäki
Ismo Bärlund
Aleksi Naski
Jarmo Salonen
108 pelaajaa.
Kärki vastaan setti Posted Friday 25th October, 2024 at 19:32(UTC+0) by Juhani Tyriseva
Pudonneita:
Jonatan Fors.
"Vihu avasi buttonista, puolustin isoa. Minä osuin kärkeen ja flopilta mentiin sisään. Vihu olikin osunut settiin, joten siihen päättyi mun turnaus", raportoi Jonatan.
Eero on pelannut tutkan alapuolella Posted Friday 25th October, 2024 at 19:17(UTC+0) by Juhani Tyriseva
Eero Abbey.
Eero on jotenkin onnistunut pysymään toimitukselta piilossa, mutta nyt mies bongattiin.
Eeron pinossa on mukavasti 480K.
18:56 (UTC+0)
Start of Level 16 Blinds: 2,000/4,000 Ante: 4,000
Harvennusta riveissä Posted Friday 25th October, 2024 at 18:55(UTC+0) by Juhani Tyriseva
Pudonneita:
Jarmo Solja
Mikael Koistinen
Jari Saviaho
129 pelaajaa, vauhdilla kohti bubblea mennään.
Helpin merkit Ikosen pinoon Posted Friday 25th October, 2024 at 18:53(UTC+0) by Juhani Tyriseva
Pudonneita:
Juha Helppi.
"Ei päässyt Juhan ohi mun kädestä", raportoi Pekka Ikonen Juhan putoamista.
Jarmo vei Miskan merkit Posted Friday 25th October, 2024 at 18:34(UTC+0) by Juhani Tyriseva
Pudonneita:
Miska Vääräniemi.
Miska ja Jarmo Salonen menivät all in ennen floppia.
Miska
Jarmo
Floppi
Turn
River ja Miskan pelit päättyivät. Jarmolla nyt noin 100K.
Joonaksen pelit päättyivät Posted Friday 25th October, 2024 at 18:32(UTC+0) by Juhani Tyriseva
Pudonneita:
Joonas Lyytinen.
139 pelaajaa.
Suomalaispinoja Posted Friday 25th October, 2024 at 18:29(UTC+0) by Juhani Tyriseva
Suomalaisten pinoja:
Mikael Haapaniemi 190K
Sebastian Wahl 135K
Ismo Bärlund 25K
Pekka Ikonen 170K
Jarmo Salonen 75K
Miska Vääräniemi 30K
Joel Salmirinne 90K
Jarkko Suokas 230K
Aku Uotila 165K
Jari Saviaho 95K
Jonatan Fors 180K
Johan Alen 85K
Zahid Bhuiyan 120K
Tommy Piiroinen 320K
Juha Helppi 90K
Joonas Lyytinen 50K
Henri Ojala 230K
Hai Hoang 70K
Elias Suhonen 270K
Kalle Parkkinen 165K
Joonas Helin 165K
Aleksi Naski 180K
Roope Tarmi 180K
Luka Sorainen 520K
Jari Mähönen 160K
Kasper Mellanen 250K
Mikael Koistinen 85K
Sauli Haapaniemi 175K
Jarmo Solja 35K
Hengtao Zhu 75K
Olli Muukkonen 100K
Mikko Ylämäki 45K
Samuli Segerman 155K
Mähönen vei suomalaisten ottelun Posted Friday 25th October, 2024 at 18:19(UTC+0) by Juhani Tyriseva
Luka Sorainen avasi buttonista, Juha Helppi ja Jari Mähönen puolustivat blindejään.
Floppi sököteltiin.
Turn sököteltiin.
River Juha löi 10K, Jari reissasi 26500 total, Luka kippasi, Juha miettimään.
"Mä tiedän, että sulla on aina se, mutta mä en usko sua yhtään", sanoi Juha ja maksoi.
Jari näytti täyskäden, ja Juha kippasi.
18:16 (UTC+0)
Start of Level 15 Blinds: 1,500/3,000 Ante: 3,000
Nyt illallistauko Posted Friday 25th October, 2024 at 17:04(UTC+0) by Juhani Tyriseva
Aleksi Naski yhä tiukasti mukana. Peli jatkuu noin klo 19.55.
148/701 pelaajaa, bubbleen on vielä aika reilusti matkaa.
Casperin pelit päättyivät Posted Friday 25th October, 2024 at 16:59(UTC+0) by Juhani Tyriseva
Casper von Schantzin all in kädellä sattui hieman huonoon hetkeen, sillä vastaan tuli kaksi vihua, joista toisella oli ja toisella pöytään tuli ässä, joten voittaja oli viimeksimainittu vihu, joka pudotti Casperin ja sai tuplat kurkoparin mieheltä.
Samulille kivasti lisää merkkejä Posted Friday 25th October, 2024 at 16:54(UTC+0) by Juhani Tyriseva
Henrik Juncker avasi keskeltä, Samuli Segerman reissasi 13K total, maksu.
Floppi Samuli löi 8K, Henrik checkreissasi 40K all in, maksu.
Henrik
Samuli
Turn
River ja Samulin suora lähetti Henrikin muiden harrastusten pariin.
Joona ja Jani poistuivat Posted Friday 25th October, 2024 at 16:43(UTC+0) by Juhani Tyriseva
Pudonneita:
Joona Tuomi
Jani Tuovinen
161 pelaajaa.
Prize pool selvillä Posted Friday 25th October, 2024 at 16:12(UTC+0) by Juhani Tyriseva
Turnauksesssa tehtiin 701 sisäänostoa. Näin palkintopottiin saatiin 658.940€.
Voittaja kuittaa komeat 130.300€, ja rahaa on tarjolla 87 parhaalle. Min cash on 2.200€.
Harvennusta riveissä Posted Friday 25th October, 2024 at 16:11(UTC+0) by Juhani Tyriseva
Pudonneita:
Onni Huttunen
Iikka Väisänen
Tommi Lankinen
Joonas Holm
170 pelaajaa.
15:56 (UTC+0)
Start of Level 14 Blinds: 1,000/2,500 Ante: 2,500
Hassan hävisi klassikko-ottelun Posted Friday 25th October, 2024 at 15:56(UTC+0) by Juhani Tyriseva
"200K flippi, vastaan ja tappiohan siinä tuli. Nyt sitten siihen 1000€+100€ Progressive Knockoutiin", suunnitteli Hassan Sey.
Juhon pelit päättyivät Posted Friday 25th October, 2024 at 15:53(UTC+0) by Juhani Tyriseva
Miska Vihervuori avasi, Juho Härkönen reissasi 12K total, Edikas Jurgutis reissasi 28K total, Miska kippasi, Juho all in 85K, maksu.
Juho
Edikas
Floppi
Turn
River ja Juhon pelit päättyivät.
Chip count Posted Friday 25th October, 2024 at 15:44(UTC+0) by Juhani Tyriseva
Suomalaisten pinoja:
Mikael Haapaniemi 140K
Sebastian Wahl 180K
Jussi Hietalahti 70K
Ismo Bärlund 40K
Pekka Ikonen 180K
Mathias Siljander 55K
Hassan Sey 100K
Jarmo Salonen 45K
Juho Härkönen 110K
Onni Huttunen 25K
Vu Vuong 190K
Joel Salmirinne 75K
Tommi Lankinen 40K
Jarkko Suokas 250K
Aku Uotila 105K
Jari Saviaho 75K
Jonatan Fors 200K
Johan Alen 65K
Zahid Bhuiyan 110K
Casper von Schantz 55K
Tommy Piiroinen 155K
Juha Helppi 100K
Jani Tuovinen 45K
Joonas Lyytinen 55K
Henri Ojala 230K
Hai Hoang 35K
Elias Suhonen 210K
Kalle Parkkinen 25K
Joonas Helin 210K
Aleksi Naski 200K
Roope Tarmi 85K
Luka Sorainen 375K
Jari Mähönen 140K
Kasper Mellanen 170K
Mikael Koistinen 150K
Sauli Haapaniemi 55K
Jarmo Solja 58K
Hengtao Zhu 65K
Olli Muukkonen 110K
Mikko Ylämäki 48K
Samuli Segerman 75K
Iikka Väisänen 50K
Rivit harvenevat Posted Friday 25th October, 2024 at 15:36(UTC+0) by Juhani Tyriseva
Pudonneita:
Juho Suutari
Veikka Keto-Tokoi
Miska Vihervuori
Miika Töyräs
Kyösti Isberg
186 pelaajaa.
Antti-Jussi ja Rasmus muiden harrastusten pariin Posted Friday 25th October, 2024 at 15:14(UTC+0) by Juhani Tyriseva
Pudonneita:
Antti-Jussi Noronen
Rasmus Lundström
Herroille löytyy kyllä tälle illalle runsaasti vaihtoehtoja, monta mielenkiintoista turnausta on ohjelmassa.
203/701 pelaajaa.
700 meni rikki Posted Friday 25th October, 2024 at 15:08(UTC+0) by Juhani Tyriseva
Alustavan laskelman mukaan turnaukseen tuli 701 pelaajaa. Kestää jonkin aikaa, ennen kuin numerot saadaan varmistettua ja prize pool vahvistettua.
Mutta nyt ei enää siis lisää ostoja tehdä, aletaan oikeasti selvittää, kuka tämän kisan voittaa.
Ja vielä meikäläisiä Posted Friday 25th October, 2024 at 14:35(UTC+0) by Juhani Tyriseva
Aleksi Naski.
Pekka Ikonen.
14:33 (UTC+0)
Start of Level 13 Blinds: 1,000/2,000 Ante: 2,000
Ja vielä muutama suomalaiskuva Posted Friday 25th October, 2024 at 14:32(UTC+0) by Juhani Tyriseva
Juho Härkönen.
Niko Linnamo.
Juha Helppi.
Zahid Bhuiyan.
Lisää kuvia salista Posted Friday 25th October, 2024 at 14:30(UTC+0) by Juhani Tyriseva
Sillä aikaa kun toimitus on kyylännyt erilaisia tapahtumia salissa, on kuvaajamme Elena Kask ahkeroinut. Pistetäänpä taas muutama kuva päivän pelaajista.
Sauli Haapaniemi.
Samuli Segerman.
Anne Koskinen.
Viimeisille ostoksille Posted Friday 25th October, 2024 at 14:27(UTC+0) by Juhani Tyriseva
Teresa valvoo, homma toimii.
Nyt pelataan vielä kolme viimeistä re-entrykättä. Taululla on komea lukema, 689 sisäänostoa on koossa.
Tauolla voi siis vielä ostaa sisään, joten todella lähelle 700 sisäänostoa päädytään.
Tarkennusta päivän pelilsuunnitelmaan Posted Friday 25th October, 2024 at 14:02(UTC+0) by Juhani Tyriseva
Toisin kuin virheellisesti aamulla kerroin, tänään pelataan 10 tasoa. Koska päivästä tulee pitkähkö, pidetään tunnin illallistauko tason 14 jälkeen, noin klo 18.40.
Näin päivä päättyy suurin piirtein keskiyöllä, tankatkaa tämän aikataulun mukaan.
Vihu osui settiin Posted Friday 25th October, 2024 at 14:00(UTC+0) by Juhani Tyriseva
"Button avasi, maksoin pienestä kädellä.
Floppi oli vihu teki jatkolyönnin, checkreissasin 12K total, vihu meni all in, maksoin. Vihulla oli kädellään, enkä ohi päässyt vaikka oli värinvedon lisäksi takaovisuoran vedot sekä ylös että alas", raportoi Osku Karttunen. "Taidan nyt siirtyä pelaamaan Sviteniä"; suunnitteli Osku.
Vu osui floppiin Posted Friday 25th October, 2024 at 13:31(UTC+0) by Juhani Tyriseva
Reissatussa potissa floppi oli:
Kristiana Stauere löi 3K, Vu Vuong maksoi takaa.
Turn Vu löi 5500, maksu.
River Vu löi 11500, maksu.
Vu näytti täyskäden, Kristiana kippasi. Vun pinossa nyt noin 145K.
13:28 (UTC+0)
Start of Level 12 Blinds: 1,000/1,500 Ante: 1,500
Värilläkin voi hävitä Posted Friday 25th October, 2024 at 13:02(UTC+0) by Juhani Tyriseva
Riverissä pöydässä oli:
Toivo Rinne ja Tarjei Forus menivät all in.
Toivo {as2s] väri
Tarjei täyskäsi, ja Toivo lähti pohtimaan re-entryn tekoa.
Ilarin ysisetti ei riittänyt Posted Friday 25th October, 2024 at 12:59(UTC+0) by Juhani Tyriseva
Turnissa pöydässä oli:
Ilari Sahamies meni all in 20K, vihu maksoi.
Ilari
Vihu
River ja vihun isompi setti lähetti Ilarin miettimään re-entryn tekoa.
Suomalaispinoja Posted Friday 25th October, 2024 at 12:54(UTC+0) by Juhani Tyriseva
Suomalaisia:
Mikael Haapaniemi 185K
Sebastian Wahl 190K
Jussi Hietalahti 135K
Johan Martinsen 40K
Pekka Ikonen 90K
Tommi Hakala 50K
Mathias Siljander 45K
Hassan Sey 65K
Tapio Aaltonen 20K
Jarmo Salonen 60K
Juho Härkönen 70K
Osku Karttunen 75K
Vu Vuong 120K
Teemu Toikkanen 55K
Joel Salmirinne 33K
Rasmus Lundström 39K
Tommi Lankinen 28K
Jarkko Suokas 90K
Jari Saviaho 20K
Jonatan Fors 120K
Johan Alen 70K
Zahid Bhuiyan 150K
Joona Koivisto 25K
Casper von Schantz 15K
Tommy Piiroinen 225K
Joonas Lyytinen 85K
Henri Ojala 140K
Hai Hoang 80K
Elias Suhonen 135K
Juho Suutari 80K
Pasi Laihinen 47K
Seppo Parkkinen 75K
Joonas Helin 45K
Heini Puuska 20K
Roope Tarmi 125K
Luka Sorainen 300K
Jari Mähönen 95K
Kasper Mellanen 160K
Mikael Koistinen 200K
Ville Mesiranta 110K
Tero Kilkanen 25K
Sauli Haapaniemi 110K
Kyösti Isberg 140K
Jarmo Solja 60K
JP Juhola 75K
Hengtao Zhu 50K
Olli Muukkonen 55K
Mikko Ylämäki 22K
Samuli Segerman 37K
Iikka Väisänen 30K
12:22 (UTC+0)
Start of Level 11 Blinds: 600/1,200 Ante: 1,200
Mathias sai tuplat Posted Friday 25th October, 2024 at 12:21(UTC+0) by Juhani Tyriseva
Turnissa pöydässä oli:
Mathias Siljander ja Ruslan Stserbjuk menivät all in.
Mathias
Ruslan
River ja Mathias tuplasi, hänellä nyt noin 60K.
Ei niin iloista tunnelmaa Posted Friday 25th October, 2024 at 11:58(UTC+0) by Juhani Tyriseva
Hassan Sey avasi buttonista, Aleksandr Januskevic reissasi 11200 total pienestä, Hassan meni all in 55K. Aleksandr alkoi tuijottaa vieressä istuvaa Hassania, ja haki jonkinlaista telliä. Hassan puolestaan pisti isot kuulokkeensa korville ja alkoi kuunnella musiikkia ja tuijotti ilmeettömänä eteenpäin.
Viitisen minuuttia siinä meni, ennen kuin muut pelaajat hermostuivat tuijotteluun, ja pyysivät Aleksandrille kellon. Kello meni nollaan, ja Aleksandrin käsi julistettiin kuolleeksi, joten kortteja ei nähty.
Toivottavasti tästä ei jäänyt isompia haavoja kummankaan pelaajan sieluun.
Hertta on nyt valttia Posted Friday 25th October, 2024 at 11:40(UTC+0) by Juhani Tyriseva
Riverissä pöydässä oli:
Kyösti Isberg löi 15K, Raimo Reimann maksoi.
Kyösti käänsi näkyviin Raimo kippasi.
Hertta on nyt selkeästi valttia.
Vu veti värin Posted Friday 25th October, 2024 at 11:33(UTC+0) by Juhani Tyriseva
Kolmen pelaajan all in ennen floppia.
Osku Karttunen
Henri Wagner
Vu Vuong
Floppi
Turn
River ja Vu pudotti Henrin ja sai tuplat Oskulta. Vun pinossa nyt noin 120K.
Osku ei antanut armoa Posted Friday 25th October, 2024 at 11:29(UTC+0) by Juhani Tyriseva
"Iikka Väisänen meni all in buttonista, minä heräsin pienestä kädellä, ja. menin myös all in. Iikalla oli
Aluksi keskityin naulan väistelyyn, sitten rakentelin värin ja suoran vedot itselleni, ja varmuuden vuoksi vedin sen suoran", raportoi Osku Karttunen.
Iikka lähti kassan suuntaan pohtimaan lisäoston mielekkyyttä. Oskulla nyt noin 125K.
Roopella hyvä startti Posted Friday 25th October, 2024 at 11:17(UTC+0) by Juhani Tyriseva
Roope Tarmi ja Johan Creutz menivät all in ennen floppia.
Roope
Johan
Floppi
Turn
River ja Roopen kunkkupari oli luja. Roopella nyt noin 140K.
"Hyvä alku päivään, ensin flipistä tuplat ja sen jälkeenkin edettiin, ja nyt tämä", iloitsi Roope.
11:10 (UTC+0)
Start of Level 10 Blinds: 600/1,200 Ante: 1,200
Tommi meni miinaan Posted Friday 25th October, 2024 at 11:10(UTC+0) by Juhani Tyriseva
Riverissä pöydässä oli:
Tommi Hakala löi 10200, Ruslan Stserbjuk checkreissasi 25K total, Tommi miettimään, maksu.
Ruslan näytti täyskäden. Tommi huokasi ja kippasi. Tommille jäi noin 70K.
Sauli reppasi AK:ta Posted Friday 25th October, 2024 at 11:02(UTC+0) by Juhani Tyriseva
Sauli Haapaniemi ja Hanno Kerem menivät melko vauhdikkaasti all in ennen floppia.
Sauli
Hanno
Floppi
Turn
River ja Sauli oli voitokas, pinossa nyt noin 105K. "Koetin vielä reppaa AK:ta, että saisin jätkillä ja rouvilta maksun", analysoi Sauli. "Hyvin repattu, maksu tuli", kuittasi toimitus.
Seppo teki kepposen Posted Friday 25th October, 2024 at 10:51(UTC+0) by Juhani Tyriseva
"En päässyt pienellä pinollani kovin pitkälle", harmitteli Jyri Merivirta.
"Tuli avaus, Seppo reissasi ja minä menin kädelläni all in 30K, avaaja kippasi, Seppo maksoi kädellään, josta en ohi päässyt. Yhden laukauksen vielä ammun, toivottavasti sillä sitten jo lähtee sujumaan", suunnitteli Jyri.
600 puhki Posted Friday 25th October, 2024 at 10:38(UTC+0) by Juhani Tyriseva
Turnauksessa on nyt 250/602 pelaajaa.
Toimitus ja Jason Glatzer eivät ole vielä lyöneet kuuluisaa sivuvetoaan pelaajien kokonaismäärästä. Toimituksen näkemys on, että oikea luku on melko tasan 700 sisäänostoa, kalibroin tätä sitten tilanteen mukaan.
"Ei huono", analysoisi eräs tanssituomari.
Ei väriä, ei pottia Posted Friday 25th October, 2024 at 10:35(UTC+0) by Juhani Tyriseva
Reissattu potti, turnissa pöydässä oli:
Heikki Rahikka löi 4500, Marco Dittman checkreissasi all in 18K, maksu.
Marco
Heikki
River ja Marco tuplasi kasiparillaan.
Erän 1D jatkoonpäässeet suomalaiset Posted Friday 25th October, 2024 at 10:24(UTC+0) by Juhani Tyriseva
Viime yönä päättyneen erän 1D osallistujamäärä oli 183 pelaajaa. 67 pelaajaa lunasti jatkopaikan.
Suomalaiset jatkoon:
Tommi Hakala 163.100 Juha Helppi 147.700 Joonas Lyytinen 119.000 Aku Uotila 105.800 Elias Suhonen 96.700 Mikko Ylämäki 84.500 Hai Hoang 82.500 Rasmus Lundström 77.800 Kim Pihl 77.400 Kari Mäkinen 68.900 Joonas Helin 68.600 Tapio Aaltonen 67.700 Anne Koskinen 67.600 Thanh Doan 66.000
Jari Hurri 56.900 (tiedot Jarin 569K pinosta ovat liioittelua, dealerille on tullut typo pinoja kirjattaessa) Tommi Lankinen 55.200 Joel Salmirinne 51.000 Visa Kiviharju 50.200 Hengtao Zhu 44.100 Iikka Väisänen 38.700 Roope Tarmi 32.100 Juho Suutari 30.000 Samuli Segerman 28.000 Johan Martinsen 27.400 Mathias Siljander 17.200
Peli käynnissä, ei jonoa Posted Friday 25th October, 2024 at 10:12(UTC+0) by Juhani Tyriseva
Hämmästyttävän hyvin lähti päivä käyntiin. Jono rekisteröintitiskillä loppui melko tasan klo 12.00 ja 12.05 päästiin aloittamaan.
"Olen todella pettynyt, kun ei tarvinnut yhtään ulkona jonottaa", pohdiskeli Osku Karttunen.
Kohta mennään Posted Friday 25th October, 2024 at 09:51(UTC+0) by Juhani Tyriseva
Vähän on nyt jonoa kasino rekisteröintitiskillä, toivotaan että jono purkautuu pian. Veikkaanpa, että noin klo 12.15 päästään aloittamaan.
Ja vielä muutama suomalaiskuva Posted Friday 25th October, 2024 at 09:49(UTC+0) by Juhani Tyriseva
Martin "Franke" von Zweigbergk.
Heikki Rahikka.
Pekka Ikonen.
Lisää kuvasatoa Posted Friday 25th October, 2024 at 09:43(UTC+0) by Juhani Tyriseva
Henri Wagner.
Heini Puuska.
Jaakko Hotti.
Eilisen kuvasatoa Posted Friday 25th October, 2024 at 09:41(UTC+0) by Juhani Tyriseva
Sillä aikaa kun toimitus seurata 555€ Championshipin menoa, oli turnauksen virallinen valokuvaaja Elena Kask ahkerana erän 1C parissa, ja aika paljon suomalaisiakin osui kuviin. Seuraavana pieni kuvakavalkadi.
Vu Vuong.
Niko Linnama.
Osku Karttunen.
Päivän pelisuunnitelma Posted Friday 25th October, 2024 at 09:32(UTC+0) by Juhani Tyriseva
Tänään pelataan kahdeksan tunnin mittaista tasoa. Ensimmäinen taso ontaso 9, bb ante 1000, blindit 500/1000. Taso 12, bb ante 1500, blindit 1000/1500 on viimeinen late rer/re-entrytaso. Näin ollen lisäostojen tekomahdollisuus loppuu noin klo 16.40.
Taukoja pidetään aina kahden pelatun tason jälkeen, ja mitään varsinaista illallistaukoa ei tänään ole.
Ei voi ihan varmaksi sanoa, päästäänkö tänään bubble toiselle puolelle, sen aika näyttää.
Huomenta! Posted Friday 25th October, 2024 at 09:19(UTC+0) by Juhani Tyriseva
Kings of Tallinn Autumn Editionin pääturnauksen 1000€+100€ päivä 2 käynnistyy klo 12.00 ja toimitus on valmiina. Päivän 2 alku on usein sikäli hieman ongelmallinen, että kasinon rekisteröintitiskille muodostuu jonoa. Jos siis luet tätä juuri nyt ja olet hotellissa, mene saman tien hakemaan rannekkeesi kasinon respasta. Säästyt jonotukselta ja nopeutat pelin käyntiin lähtemistä.
09:17 (UTC+0)
Day 2 of Kings of Tallinn Autumn Edition 2024 Started Level: 9 Blinds: 500/1,000 Ante: 1,000
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
ja Samuli vei Rolandasin merkit värillään. 
ei pärjännyt vihun 
kädelle, kymppi tuli turniin.
Bahadir löi 20K, Elias kippasi, Jarkko maksoi.
Jarkko löi 35K, maksu.
kolme kunkkua.
jätkäparin. 
kädellä, Taago painoi all in isommalla pinollaan, maksoin. Taagolla oli 
ja Miskan pelit päättyivät. Jarmolla nyt noin 100K. 
sököteltiin.
täyskäden, ja Juha kippasi. 
ja Samulin suora lähetti Henrikin muiden harrastusten pariin. 
ja Juhon pelit päättyivät. 
ja Mathias tuplasi, hänellä nyt noin 60K. 
ja Sauli oli voitokas, pinossa nyt noin 105K. "Koetin vielä reppaa AK:ta, että saisin jätkillä ja rouvilta maksun", analysoi Sauli. "Hyvin repattu, maksu tuli", kuittasi toimitus. 
ja Marco tuplasi kasiparillaan. 
£ GBP
$ USD
€ EUR
