0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0064 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-05-17'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_KOT_555_Champ_Fin/2/updates'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.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.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.0076 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0004 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_KOT_555_Champ_Fin'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '100'
0.0209 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0041 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '233'
AND `published` = 1
0.0211 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0043 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '234'
AND `published` = 1
0.0209 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0038 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '244'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '100'
AND `name` = '2'
0.0049 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '233'
ORDER BY `busted` ASC, `current_chips` DESC
0.0043 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` = '233'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10466'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10463'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10455'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10449'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10447'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10440'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10438'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10437'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10436'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10429'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10427'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10426'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10409'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10405'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10392'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10388'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10381'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10379'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10367'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10363'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10360'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10355'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10353'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10350'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10337'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10336'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10321'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10319'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10311'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10307'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10305'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10304'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10298'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10294'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10290'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10288'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10282'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10281'
ORDER BY `chip_change` DESC, `busted` ASC
0.0154 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10276'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10275'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10271'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10267'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10266'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10261'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10257'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10255'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10254'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10251'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10245'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10232'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0094 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10226'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10210'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10208'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10205'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10200'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10197'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10195'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10192'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10188'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10184'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10179'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10174'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10170'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10164'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10161'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10150'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10148'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10121'
ORDER BY `chip_change` DESC, `busted` ASC
0.0049 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '233'
ORDER BY `busted` ASC, `current_chips` DESC
0.0047 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` = '233'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10466'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10463'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10455'
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` = '10449'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10447'
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` = '10440'
ORDER BY `chip_change` DESC, `busted` ASC
0.0192 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10438'
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` = '10437'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10436'
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` = '10429'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10427'
ORDER BY `chip_change` DESC, `busted` ASC
0.0051 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10426'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10411'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10409'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10405'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10402'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10397'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10392'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10391'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10388'
ORDER BY `chip_change` DESC, `busted` ASC
0.0252 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10381'
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` = '10379'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10367'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10363'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10360'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10357'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10355'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10353'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10350'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10337'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10336'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10321'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10319'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10311'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10307'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10305'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10304'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10298'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10294'
ORDER BY `chip_change` DESC, `busted` ASC
0.0047 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10290'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10288'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10282'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10281'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10276'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10275'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10271'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10267'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10266'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10261'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10257'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10255'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10254'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10251'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10246'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10245'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10243'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10242'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10236'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10234'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10233'
ORDER BY `chip_change` DESC, `busted` ASC
0.0148 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10232'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10228'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10227'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10226'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10223'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10212'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10211'
ORDER BY `chip_change` DESC, `busted` ASC
0.0050 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10210'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10208'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10207'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10205'
ORDER BY `chip_change` DESC, `busted` ASC
0.0082 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10204'
ORDER BY `chip_change` DESC, `busted` ASC
0.0083 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10200'
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` = '10197'
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` = '10195'
ORDER BY `chip_change` DESC, `busted` ASC
0.0088 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10192'
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` = '10188'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10186'
ORDER BY `chip_change` DESC, `busted` ASC
0.0074 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10184'
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` = '10179'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10178'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10174'
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` = '10170'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10168'
ORDER BY `chip_change` DESC, `busted` ASC
0.0045 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10164'
ORDER BY `chip_change` DESC, `busted` ASC
0.0042 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10161'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10155'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10150'
ORDER BY `chip_change` DESC, `busted` ASC
0.0052 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10148'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0044 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0041 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10138'
ORDER BY `chip_change` DESC, `busted` ASC
0.0145 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0046 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10133'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10129'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10123'
ORDER BY `chip_change` DESC, `busted` ASC
0.0043 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '10121'
ORDER BY `chip_change` DESC, `busted` ASC
0.0048 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '244'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2351
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.
Jarmolle pytty, nyt hyvää yötä! Posted Wednesday 28th February, 2024 at 02:36(UTC+2) by Juhani Tyriseva
Tänään klo 15.00 alkaneen 250€ NLH-turnauksen voitto tuli Suomeen, Jarmo Salonen kuittasi pytyn ja mukavat 7.020€ voittorahat.
Koetan taas loppuviikosta postata kaikkien meikäläisten voittokuvat ketjuun.
Nyt oikein hyvää yötä!!
555€ Championshipin päivä pulkassa Posted Wednesday 28th February, 2024 at 02:32(UTC+2) by Juhani Tyriseva
Pelattiin sovitusti taso loppuun ja pistettiin merkit pussiin.
13 pelaajaa jatkaa huomenna klo 12.30.
Suomalaiset:
Jan-Mikael Kesänen 665K
Joonas Helin 655K
Konsta Heikkilä 925K
Touko Berndtson 1540K
Matte Karjalainen 1220K
Mikko Ylämäki 2540K
Peliä jatketaan sitten TV-pöydästä, postaan linkin streamiin huomenna.
Jan-Mikael nousi kolmossijalta voittoon Posted Wednesday 28th February, 2024 at 02:13(UTC+2) by Juhani Tyriseva
Andrius Bielskis avasi, Jan-Mikael Kesänen ja Adrians Imsa maksoivat takaa.
Floppi Bielskis sökötti, Jan-Mikael meni all in 275K, Imsa maksoi. Bielskis miettimään, päätyi kippaamaan auki
Jan-Mikael
Adrians
Turn
River ja Jan-Mikael nousi kuilun partaalta voittoon, hänellä nyt noin 950K.
Ryssgaard nukkui ohi onnensa Posted Wednesday 28th February, 2024 at 02:03(UTC+2) by Juhani Tyriseva
Tanskalais-liettualainen Christian Ryssgaard on seuraava turnauksesta pudonnut. Christian meni illallistauolla käymään hotellissaan, ja nukahti. Kesti yli kaksi tuntia, ennen kuin häneen saatiin yhteys ja hän palasi pöytään.
Christianin pelityyli oli varsin vauhdikas, ja hän kuului selkeästi "high risk, high reward"-kategoriaan.
Christianin peli päättyi tällä kertaa ikävästi, kun kunkkupari ei kestänyt vihun kättä vastaan.
Tällä kertaa erikoismuuvit tuottivat hänelle 2.850€.
13 pelaajaa.
Viktorija oli turnauksen paras naispelaaja Posted Wednesday 28th February, 2024 at 01:58(UTC+2) by Juhani Tyriseva
Pudonneita:
Viktorija Ignataviciene
Viktorija oli ylivoimaisesti turnauksen parasnaispelaaja. Hän sinnitteli jo bubblessa pienellä pinolla, ja sai hyvin kunnioitusta puskuilleen.
Viktorija tienasi 2.850€.
14 pelaajaa.
Suomalaispitoisuus nousussa Posted Wednesday 28th February, 2024 at 01:49(UTC+2) by Juhani Tyriseva
Tässä on nyt pudonnut aika monta ulkomaan elävää peräkkäin, meikäläisillä hyvä vaihe kisassa.
Suomalaiset:
Jan-Mikael Kesänen 520K
Joonas Helin 900K
Konsta Heikkilä 1300K
Touko Berndtson 1500K
Matte Karjalainen 750K
Mikko Ylämäki 2200K
15 pelaajaa, keskistakki 1400K.
01:47 (UTC+2)
Start of Level 27 Blinds: 30,000/60,000 Ante: 60,000
Moya ulos, 15 pelaajaa jäljellä Posted Wednesday 28th February, 2024 at 01:47(UTC+2) by Juhani Tyriseva
Pudonneita:
Javier Guinot Moya.
"Avasin käden, Javier puski pienen pinonsa blindistä kädellään, eikä ohi minusta päässyt", kertoi Mikko Ylämäki.
15 pelaajaa jäljellä.
Touko Norjan poikaa vahvempi Posted Wednesday 28th February, 2024 at 01:36(UTC+2) by Juhani Tyriseva
Touko Berndtsonin oli Thor William Morstolin kättä vahvempi, kun ässä tuli pöytään.
16 pelaajaa, tehdään redraw.
Rivit harvenevat Posted Wednesday 28th February, 2024 at 01:31(UTC+2) by Juhani Tyriseva
Pudonneita:
Matteo Capelletti
Serhii Leonov
Sultans Ertinhajens
17 pelaajaa. Kun yksi putoaa, mennään kahteen pöytään.
Konstalle napsahti Posted Wednesday 28th February, 2024 at 01:30(UTC+2) by Juhani Tyriseva
Konsta Heikkilä avasi UTG, Christian Ryssgaard ja Matte Karjalainen maksoivat blindeistä.
Floppi sököteltiin.
Turn Christian löi 85K, Matte maksoi, Konsta reissasi 285K total, Christian kippasi, Matte maksoi.
River Konsta meni all in 665K, Matte miettimään, maksu.
Konsta näytti täyskäden.
Matte näytti kolme ässää.
Konstalla nyt noin 2200K.
00:47 (UTC+2)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Pikku tauko Posted Wednesday 28th February, 2024 at 00:46(UTC+2) by Juhani Tyriseva
Pidetään illan viimeinen tauko. Jos mitään yllättävää ei satu, pelataan tauon jälkeen vielä kaksi tasoa, ja sitten lyödään merkit pussiin.
20 pelaajaa palaa tauolta pöytiin. Seuraava taso bb ante 40K, blindit 20K/40K.
Suomalaisten tilanne Posted Wednesday 28th February, 2024 at 00:29(UTC+2) by Juhani Tyriseva
Suomalaiset:
Mikko Ylämäki 920K
Konsta Heikkilä 1200K
Matte Karjalainen 1500K
Touko Berndtson 1200K
Jan-Mikael Kesänen 720K
Joonas Helin 760K
20 pelaajaa, keskistakki 1050K.
Bluffi vai ei? Posted Wednesday 28th February, 2024 at 00:27(UTC+2) by Juhani Tyriseva
Riverissä pöydässä oli:
Aleksandrs Krumins löi 75K, kun potissa oli noin 200K. Touko Berndtson miettimään, all in 850K. Krumins mietti hetken, tarkisti korttinsa ja kippasi.
Toukolla nyt 1200K.
Konsta onnistui Posted Wednesday 28th February, 2024 at 00:19(UTC+2) by Juhani Tyriseva
Peder Behr avasi, Konsta Heikkilä 3-bet, Jan-Mikael Kesänen all in, Peder all in, Konsta all in pienimmällä, 400K pinolla.
Peder
Konsta
Jan-Mikael
Floppi
Turn
River ja Konstan pino kolminkertaistui, hänellä nyt noin 1300K.
Jan-Mikael sai tuplat Pederiltä, hänellä nyt 900K.
Pederille jäi 70K.
Suomalaisten chip count Posted Wednesday 28th February, 2024 at 00:05(UTC+2) by Juhani Tyriseva
Suomalaiset:
Mikko Ylämäki 1050K
Konsta Heikkilä 500K
Matte Karjalainen 1670K
Touko Berndtson 1220K
Matias Kesänen 620K
Joonas Helin 750K
22 pelaajaa, keskistakki 954K.
23:57 (UTC+2)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Välillä tulee väri Posted Tuesday 27th February, 2024 at 23:57(UTC+2) by Juhani Tyriseva
Joel Ylismäki avasi, vihu maksoi.
Floppi Joel ja vihu menivät all in.
Joel
Vihu
Turn
River ja vihun väri lähetti Joelin kassan suuntaan.
Joel tienasi 1.800€.
24 pelaajaa, tehdään redraw Posted Tuesday 27th February, 2024 at 23:49(UTC+2) by Juhani Tyriseva
Päästiin 24 pelaajaan, kun Ukrainan Mykhalo Mikhalov ja Latvian Dmitrijs Arsuns putosivat.
Kuten aina Teresan vetämissä turnauksissa, tärkeissä tehdään redraw kun päästään 24, 16 ja 9 pelaajaan, niin nytkin.
Suomalaisten pinot Posted Tuesday 27th February, 2024 at 23:30(UTC+2) by Juhani Tyriseva
Suomalaiset:
Mikko Ylämäki 1150K
Konsta Heikkilä 350K
Matte Karjalainen 1750K
Joel Ylismäki 400K
Touko Berndtson 1490K
Jan-Mikael Kesänen 660K
Joonas Helin 950K
Keskistakki 840K.
23:28 (UTC+2)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Kevin, Jonatan ja Jani poistuivat Posted Tuesday 27th February, 2024 at 23:18(UTC+2) by Juhani Tyriseva
Pudonneita:
Jonatan Fors 1.600€
Jani Vilmunen 1.800€
Kevin Karenius 1.800€
28 pelaajaa.
Ässilläkin voi hävitä Posted Tuesday 27th February, 2024 at 22:59(UTC+2) by Juhani Tyriseva
Uutinen:
Ässät eivät aina voita jakoa.
"Aleksandrs Krumins avasi väärällä vuorolla buttonista. Maksoin isosta kädellä.
Floppi tuli Krumins joka oli jo kohtuullisen humalassa, löi jatkolyönnin, menin all in 200K, hän maksoi kädellään, josta en ohi päässyt", kertoi Roope Tarmi jaosta johon hänen pelinsä päättyivät. "Oli ihannepöytä; yksi ollut nyt tunnin sitoutissa, yksi heiluu humalassa ja kolme nittiä kippailee", harmitteli Roope hyvän tilanteen valumista hukkaan.
Roope tienasi 1.600€.
Kuutoset lähettivät Juuson kassalle Posted Tuesday 27th February, 2024 at 22:45(UTC+2) by Juhani Tyriseva
"Valuin pieniin ja minulla oli vain 110K. Touko Berndtson avasi 40K, puskin kaikki sisään kädelläni, Touko maksoi kädellään. Floppi ratkaisi voittajan, kun kumpikaan ei enää tuon jälkeen osunut", kertoi Juuso Oksanen.
Juuso tienasi 1.600€.
35 pelaajaa.
22:33 (UTC+2)
Start of Level 22 Blinds: 10,000/20,000 Ante: 20,000
Ravut olivat lujat Posted Tuesday 27th February, 2024 at 22:28(UTC+2) by Juhani Tyriseva
"Luka Soraisen ei pärjännyt vihun kädelle", kertoi vierestä seurannut Roope Tarmi.
Luka tienasi 1.600€.
37 pelaajaa.
Villen pelit päättyivät ohivetoon Posted Tuesday 27th February, 2024 at 22:24(UTC+2) by Juhani Tyriseva
"Menin all in kädellä, vieruskaveri päätti maksaa kädellään ja osui jätkään", kertoi Ville Turja.
Ville tienasi 1400€.
40 pelaajaa.
Akselin pelit päättyivät Posted Tuesday 27th February, 2024 at 22:22(UTC+2) by Juhani Tyriseva
Pudonneita:
Akseli Paalanen 1400€
41 pelaajaa.
Joonas vei norjalaisen viimeiset Posted Tuesday 27th February, 2024 at 22:14(UTC+2) by Juhani Tyriseva
Norjan Niklas Gjersvold oli ajautunut pieniin merkkeihin ja meni all in Joonas Heliniä vastaan, maksu.
Niklas
Joonas
Floppi
Turn
River ja Niklas lähti kassalle. Joonaksella nyt noin 450K.
42 pelaajaa.
21:54 (UTC+2)
Start of Level 21 Blinds: 10,000/15,000 Ante: 16,000
Illallinen check, jatketaan Posted Tuesday 27th February, 2024 at 21:54(UTC+2) by Juhani Tyriseva
Illallistauko on pidetty, jatketaan peliä.
Jatkossakin on varmasti vauhtia ja vaarallisia tilanteita.
Nyt illallistauko Posted Tuesday 27th February, 2024 at 21:06(UTC+2) by Juhani Tyriseva
555€ Championshipissä lähdettiin 45 pelaajan voimin illallistauolle.
Suomalaiset:
Ville Turja 400K
Jonatan Fors 445K
Matte Karjalainen 760K
Mikko Ylämäki 1140K
Konsta Heikkilä 650K
Jani Vilmunen 260K
Kevin Karenius 90K
Juuso Oksanen 190K
Joel Ylismäki 1030K
Akseli Paalanen 140K
Touko Berndtson 680K
Jan-Mikael Kesänen 1140K
Joonas Helin 360K
Roope Tarmi 290K
Luka Sorainen 185K
Keskistakki 466K
Ja taas meikäläisiä lauluun Posted Tuesday 27th February, 2024 at 21:02(UTC+2) by Juhani Tyriseva
Pudonneita suomalaisia:
Tomi Arponen 1400€
Arto Loikkanen 1400€
Kasper Mellanen 1400€
Touko kärkijoukkoon Posted Tuesday 27th February, 2024 at 20:42(UTC+2) by Juhani Tyriseva
Touko Berndtson on noussut miljoonakerhoon, Toukon pinossa nyt noin 1100K.
"Pistä sinne nettiin, että Touko lupasi voittaa tämän turnauksen", virnuili Toukon vieressä istuva Akseli Paalanen. Toimitus teki työtä käskettyä.
Pokeri-celebrity Celebrityyn Posted Tuesday 27th February, 2024 at 20:36(UTC+2) by Juhani Tyriseva
Pudonneita:
Ilari Sahamies 1200€
Celebrity-turnaukseen on nyt siis mahdollista saada todellinen pokeri-celebrity pelaamaan, katsotaan liittyykö Ilari iloiseen joukkoon.
20:33 (UTC+2)
Start of Level 20 Blinds: 6,000/12,000 Ante: 12,000
Mikko vei Bengtin merkit Posted Tuesday 27th February, 2024 at 20:32(UTC+2) by Juhani Tyriseva
Bengt Johnsson meni all in 23K UTG, Gundars Zelcs ja Mikko Ylämäki maksoivat blindeistä.
Floppi sököteltiin.
Turn sököteltiin.
River sököteltiin.
Bengt näytti
Gundars kippasi, Mikko näytti nelosparin ja vei potin.
Mikolla nyt noin 900K.
Toni Celebrityyn? Posted Tuesday 27th February, 2024 at 20:16(UTC+2) by Juhani Tyriseva
Viimeinen suomalaispoistuja:
Toni Sarkama 1200€
Toni ehtii kyllä halutessaan mukaan Celebrity Eventiin, joka saatiin käyntiin hetki sitten.
Touko vei Magnusin merkit Posted Tuesday 27th February, 2024 at 20:13(UTC+2) by Juhani Tyriseva
Touko Berndtson avasi, Magnus Pukk meni all in 50K, maksu.
Touko
Magnus
Floppi
Turn
River ja Touko vei potin suorallaan.
Toukon pinossa nyt noin 500K.
Miltei täystuho Posted Tuesday 27th February, 2024 at 20:02(UTC+2) by Juhani Tyriseva
Viimeiset 15 minuuttia eivät sujuneet hyvin suomalaisilta.
Pudonneita:
Markus Ylänne 1100€
Ville Jantunen 1200€
Henri Tanskanen 1200€
Juho Suutari 1200€
Pyry Kekäläinen 1200€
64 pelaajaa.
Oliko Artolla timanttia? Posted Tuesday 27th February, 2024 at 19:59(UTC+2) by Juhani Tyriseva
Arto Loikkanen avasi, Ilari Sahamies reissasi 60K total isosta, maksu.
Floppi Ilari löi 60K, Arto miettimään, all in 200K, kippi.
"Oliko hyvät", kysyi Ilari Artolta. "Timanttia oli", sanoi Arto ja hymyili, näyttämättä korttejaan.
Artolla nyt noin 350K.
Jani kassalle Posted Tuesday 27th February, 2024 at 19:44(UTC+2) by Juhani Tyriseva
Pudonneita:
Jani Tuovinen.
Jani tienasi 1.100€.
Kasper Lukan pinolla Posted Tuesday 27th February, 2024 at 19:42(UTC+2) by Juhani Tyriseva
Kasper Mellanen meni all in keskeltä, Luka Sorainen maksoi isosta.
Kasper
Luka
Floppi
Turn
River ja Kasper tuplasi värillään, hänellä nyt noin 220K.
Vielä kaksi tasoa ennen ruokailua Posted Tuesday 27th February, 2024 at 19:19(UTC+2) by Juhani Tyriseva
Pelaajat lähtivät 20 minuutin pituiselle tauolle. Tauon jälkeen pelataan kaksi tasoa ennen tunnin illallistaukoa, joka pitäisi olla noin klo 20.40.
Kasperin komboveto toimi Posted Tuesday 27th February, 2024 at 19:16(UTC+2) by Juhani Tyriseva
Kasper Mellanen ja Matte Karjalainen blindien välisessä.
Floppi Kasper meni all in, maksu.
Kasper
Matte
Turn
River ja Kasper tuplasi pinonsa suorallaan, hänellä nyt noin 90K.
Jussi Kivekäs on turnauksen bubble boy Posted Tuesday 27th February, 2024 at 19:10(UTC+2) by Juhani Tyriseva
Bubble ei kauaa kestänyt.
Jussi Kivekäs ja Angel Alonso menivät all in ennen floppia.
Jussi
Angel
Floppi
Turn
River ja Angelin kunkkupari määritti Jussin kohtalon.
Tasan bubblessa ollaan Posted Tuesday 27th February, 2024 at 19:03(UTC+2) by Juhani Tyriseva
Pelaajia on jäljellä nyt 88 kappaletta, ollaan tasan bubblessa. Pelataan siis hand for hand kunnes bubble boy löytyy.
Suomalaisittain viime hetket ovat menneet mukavasti, kukaan meikäläinen ei ole pudonnut.
Rouvat toivat Tomille apua Posted Tuesday 27th February, 2024 at 19:00(UTC+2) by Juhani Tyriseva
Tomi Arponen meni all in UTG, Aleksandrs Krumins maksoi pienestä.
Tomi
Aleksandrs
Floppi
Turn
River ja Tomi tuplasi, hänellä nyt noin 200K.
Ei ihan saletit Posted Tuesday 27th February, 2024 at 18:43(UTC+2) by Juhani Tyriseva
Riverissä pöydässä oli:
Toni Sarkama löi 45K, Dominik Ostrowski miettimään, maksu.
Toni näytti melkein saletit, vihu kippasi.
Tonilla nyt noin 300K.
Vielä muutama suomalainen Posted Tuesday 27th February, 2024 at 18:38(UTC+2) by Juhani Tyriseva
Täydennetään vähän meikäläisten chip countia:
Henri Tanskanen 160K
Matte Karjalainen 180K
Joel Ylismäki 145K
91 pelaajaa, nyt ollaan jo todella lähellä bubblea.
18:30 (UTC+2)
Start of Level 19 Blinds: 5,000/10,000 Ante: 10,000
Celebrity Eventin alku siirtyy Posted Tuesday 27th February, 2024 at 18:30(UTC+2) by Juhani Tyriseva
Kuhina on täällä ensimmäisen kerroksen konferenssitilassa kova. Nyt kun 555€ ja 1100€ PLO menevät kovaa vauhtia eteenpäin, on pelipöydistä pientä pulaa. Näin ollen 150€ Celebrity Eventin alkua joudutaan siirtymään, se alkaa vasta klo 20.00.
Suomalaisten chip count Posted Tuesday 27th February, 2024 at 18:22(UTC+2) by Juhani Tyriseva
Suomalaiset:
Juho Suutari 205K
Tomi Arponen 50K
Roope Tarmi 300K
Kevin Karenius 210K
Markus Ylänne 230K
Ville Turja 205K
Konsta Heikkilä 190K
Luka Sorainen 310K
Kasper Mellanen 90K
Mikko Ylämäki 320K
Jani Vilmunen 225K
Jussi Kivekäs 290K
Jani Tuovinen 200K
Jan-Mikael Kesänen 70K
Joonas Helin 165K
Toni Sarkama 240K
Ville Jantunen 155K
Juuso Oksanen 80K
Akseli Paalanen 125K
Pyry Kekäläinen 110K
Jonatan Fors 120K Ilari Sahamies 170K
Arto Loikkanen 75K
Touko Berdtson 270K
Ei päivitystä ilman meikäläisten vähenemistä Posted Tuesday 27th February, 2024 at 18:10(UTC+2) by Juhani Tyriseva
Pudonneita:
Ngo Minh Thang
Juhana Konttinen
Max Rotko
Mathias Siljander
Elias Suhonen
Jarkko kohti uusia seikkailuita Posted Tuesday 27th February, 2024 at 18:08(UTC+2) by Juhani Tyriseva
Jarkko Suokas ja Presiyan Tsvetanov menivät all in ennen floppia.
Presian
Jarkko
Floppi
Turn
River ja Jarkon pelit päättyivät.
Klassikko päättyi Villen tappioon Posted Tuesday 27th February, 2024 at 18:04(UTC+2) by Juhani Tyriseva
Ville Jantunen ja Audrius Skucas menivät all in ennen floppia.
Audrius
Ville
Floppi
Turn
River ja klassikkomatsi päättyi Liettuan pojan voittoon.
Villelle jäi 155K.
18:00 (UTC+2)
Start of Level 18 Blinds: 4,000/8,000 Ante: 8,000
Vielä jäädään ilman rahaa Posted Tuesday 27th February, 2024 at 17:44(UTC+2) by Juhani Tyriseva
Pudonneita suomalaisia:
Sebastian Wahl
Riku Hänninen
Aleksi Naski
113 pelaajaa, todella kovaa vauhtia kohti bubblea mennään. Toisaalta päivän loppuun on erittäin paljon matkaa.
17:41 (UTC+2)
Start of Level 17 Blinds: 3,000/6,000 Ante: 6,000
Nuorempi vei turkulaisten matsin Posted Tuesday 27th February, 2024 at 17:40(UTC+2) by Juhani Tyriseva
Reissattu potti, riverissä pöydässä oli:
Kasper Mellanen löi noin potillisen 45K, Luka Sorainen miettimään, Luka all in isommalla pinolla, Kasper miettimään, kippi.
Luka näytti värin, ja vei potin.
Joni Liimatta tekee kivaa sisältöä Posted Tuesday 27th February, 2024 at 17:37(UTC+2) by Juhani Tyriseva
Kohti bubblea Posted Tuesday 27th February, 2024 at 17:26(UTC+2) by Juhani Tyriseva
126 pelaajaa.
Pudonneita suomalaisia:
Jimi Koponen
Johan Alen
Matias Arosuo
Veikka Keto-Tokoi
Jyrkin KQ, ei hyvä Posted Tuesday 27th February, 2024 at 17:24(UTC+2) by Juhani Tyriseva
Jyrki Lampisen pelit päättyivät tässä kisassa.
Jyrki ja Sultans Ertinhajevs menivät all in ennen floppia.
Jyrki
Sultans
Floppi
Turn
River ja Jyrki siirtyi pohtimaan Celebrity Eventiin osallistumista.
Ja taas meikäläisiä katsomoon Posted Tuesday 27th February, 2024 at 17:15(UTC+2) by Juhani Tyriseva
Sitten viimeisen päivityksen meikäläisistä ovat pudonneet:
Tommi Lankinen
Juho Härkönen
Heikki Piira
Ville Lönngren
Anna-Mari Hursti
Ville Lönngren
135 pelaajaa.
17:11 (UTC+2)
Start of Level 16 Blinds: 2,000/5,000 Ante: 5,000
Kohta enää150 pelaajaa Posted Tuesday 27th February, 2024 at 16:27(UTC+2) by Juhani Tyriseva
Pelaajat vähenevät vauhdilla.
Pudonneita suomalaisia:
Mikael Haapaniemi
Jose Koistinen
Tuomas Jalonen
Rattailla ei aina pärjää Posted Tuesday 27th February, 2024 at 16:22(UTC+2) by Juhani Tyriseva
Jari Saviahon pelit päättyivät, kun flopatut rattaat eivät riittäneet paikallista vihua vastaan. Taitava vihu veteli käteensä takaovesta värin.
Teron pelit päättyivät Posted Tuesday 27th February, 2024 at 16:21(UTC+2) by Juhani Tyriseva
"Mun ei pärjännyt vihun kädelle", raportoi Tero Kilkanen.
Ehkäpä Tero ottaa seuraavaksi kohteekseen klo 17.00 alkavan PLO-turnauksen.
Ilarille komeat tuplat Posted Tuesday 27th February, 2024 at 16:18(UTC+2) by Juhani Tyriseva
Ilari Sahamies ja Hendry Kullamäe menivät all in ennen floppia.
Ilari
Hendry
Floppi
Turn
River ja Ilari tuplasi, hänellä nyt noin 130K.
Putoilee kuin kärpäsiä Posted Tuesday 27th February, 2024 at 16:13(UTC+2) by Juhani Tyriseva
Viime hetket ovat olleet meikäläisille tuskallisia.
Pudonneita:
Jari Lahtinen
Ari Soini
Kalle Parkkinen
Rasmus Lundström
16:10 (UTC+2)
Start of Level 15 Blinds: 2,000/4,000 Ante: 4,000
Ensin oli hyvä tarina, sitten huonoa onnea Posted Tuesday 27th February, 2024 at 16:10(UTC+2) by Juhani Tyriseva
"Pikku pinon pusku kädellä ei toiminut, kun vihu maksoi kädellään ja osui jätkään, joten ulkona ollaan. Sitä ennen minulla oli omasta mielestäni hyvä tarina, ja painoin kaikki ilmalla sisään, mutta vihu ei ostanut mun tarinaa ja maksoi", virnuili Jari Hurri.
"Illan Celebrity Event on sitten seuraavana vuorossa, siellä on rento meininki", suunnitteli Jari jatkoa.
Ville jäi kiinni Posted Tuesday 27th February, 2024 at 16:00(UTC+2) by Juhani Tyriseva
Turnissa pöydässä oli:
Ville Jantunen löi 9K, Mauri Dorbek maksoi.
River Ville löi 20K, Mauri miettimään, maksu.
Ville näytti
Mauri käänsi näkyviin ja vei potin.
Selkeästi alle 200 pelaajaa Posted Tuesday 27th February, 2024 at 15:50(UTC+2) by Juhani Tyriseva
Turnauksessa on nyt mukana 184/701 pelaajaa.
Pudonneita:
Juuso Kauppi
Juha Kaitanen
Kaikkia flippejä ei voita Posted Tuesday 27th February, 2024 at 15:42(UTC+2) by Juhani Tyriseva
"Juuso Oksanen avasi kädellään, minä puskin kädelläni, Juuso maksoi ja voitti flipin", raportoi Petteri Kalenius putoamisestaan.
Pekka, Matias ja Karri OUT Posted Tuesday 27th February, 2024 at 15:33(UTC+2) by Juhani Tyriseva
Pudonneita:
Pekka Ikonen
Matias Knaapinen
Karri Uusi-Äijö
199/701 pelaajaa.
15:29 (UTC+2)
Start of Level 14 Blinds: 1,500/3,000 Ante: 3,000
Matias ja Henri PLO-turnaukseen? Posted Tuesday 27th February, 2024 at 15:22(UTC+2) by Juhani Tyriseva
Pudonneita:
Matias Kesänen
Henri Antikainen
213/701 pelaajaa turnauksessa.
Pillittääkö tää kaveri, taas? Posted Tuesday 27th February, 2024 at 15:20(UTC+2) by Juhani Tyriseva
Pöydässä 28 suomalaiset ovat huomanneet tanskalaisliettualaisen Christian Rysgaardin pelaavan reipasta pokeria.
Hetki sitten kolmen pelaajan potissa floppi oli:
Luka Sorainen löi takaa 14K, Ville Jantunen ja Rysgaard maksoivat.
Turn Rysgaard löi 25K, Luka kippasi, Ville maksoi.
River sököteltiin.
Rysgaard näytti värin.
Ville näytti pienemmän värin.
Meikäläisten joukotkin harvenevat Posted Tuesday 27th February, 2024 at 15:09(UTC+2) by Juhani Tyriseva
Kuten aina re-entryajan päätyttyä, nyt mennään vauhdilla.
Pudonneita meikäläisiä:
Teemu Kailasvuo
Joel Haapio
Jethro Rostedt
Santtu Leinonen
PLO-turnaus alkaa klo 17.00, joten sieltä sitten uuteen nousuun.
Tarmi ei antanut armoa Posted Tuesday 27th February, 2024 at 15:06(UTC+2) by Juhani Tyriseva
Roope Tarmin pöytään oli tauon jälkeen tullut uusi vihu 20K pinon kanssa.
Roope ja vihu menivät all in ennen floppia.
Roope
Vihu
Floppi
Turn
River ja vihu suuntasi kohti seuraavia turnauksia.
Player
Chips
Progress
Roope Tarmi
90,000
0
Juhan ohiveto onnistui Posted Tuesday 27th February, 2024 at 14:56(UTC+2) by Juhani Tyriseva
Martin Pikk avasi, Juha Kaitanen meni vierestä all in 29K, maksu.
Martin
Juha
Floppi
Turn
River ja Juhan täyskäsi oli myrkkyä Martinille.
Juhan pinossa nyt noin 65K.
14:49 (UTC+2)
Start of Level 13 Blinds: 1,000/2,500 Ante: 2,500
Mutta päästiinpä sittenkin! Posted Tuesday 27th February, 2024 at 14:47(UTC+2) by Juhani Tyriseva
Taukoa on nyt jäljellä 3 minuuttia, ja kassalla on ollut kuhinaa. Turnauksessa on nyt tehty 701 sisäänostoa! Aika huikeaa.
Pelaajia tauon jälkeen pöytiin tulee 248 kappaletta. Pitkä päivä on siis edessä, kun pidetään alkuperäisestä suunnitelmasta kiinni, pelataan kunnes yhdeksän finalistia on jäljellä.
Ihan ei seuraavalle sataluvulle päästä Posted Tuesday 27th February, 2024 at 14:44(UTC+2) by Juhani Tyriseva
Turnauksessa on nyt tehty 680 sisäänostoa. Vielä on reilu minuuttia tasoa 12 jäljellä, joten lisäostoja tulee, kun viimeiset jaot pelataan. Tason jälkeisellä tauollakin pääsee mukaan, joten vasta sitten tiedetään saadaanko kisaan 700 sisäänostoa.
Setälän ässät oli blokattu Posted Tuesday 27th February, 2024 at 14:09(UTC+2) by Juhani Tyriseva
"Kolmen pelaajan all inissä mun ei pärjännyt kun vastassa oli ja
Pöytään tuli ja nelosparin kaverilla oli suora, muilla ei", raportoi Sakari.
Tero sai oikeutta - vai isän kädestä? Posted Tuesday 27th February, 2024 at 13:55(UTC+2) by Juhani Tyriseva
"Olisit tullut aiemmin kurkkaamaan, kun minulla oli vielä paljon enemmän merkkejä. Hetki sitten mun törmäsi Jon Martinezin käteen. Avasin, Jon meni all in, maksoin ja Jon osui kymppiin, minä en mihinkään", harmitteli Tero.
"Jon tarkkana kaverina oli varmaan huomannut, että oli pari kertaa avannut ja kipannut sitten 3-betiin. Nyt en ollut aikeissa kipata, ja sain oikeutta, vai sittenkin isän kädestä", virnuili Tero.
13:41 (UTC+2)
Start of Level 12 Blinds: 1,000/2,000 Ante: 2,000
Joonas oli Tommia vahvempi Posted Tuesday 27th February, 2024 at 13:39(UTC+2) by Juhani Tyriseva
Tommi Lankinen avasi, Joonas Helin pisti vauhtia vierestä, maksu.
Floppi Joonas löi 5K, maksu.
Turn sököteltiin.
River Tommi löi 10K, Joonas meni all in 45K, kippi.
Joonaksen pinossa nyt noin 75K.
Roope törmäsi settiin Posted Tuesday 27th February, 2024 at 13:31(UTC+2) by Juhani Tyriseva
Roope Holma joutui toteamaan, että vihun oli Roopen kättä vahvempi, kun pöydässä oli:
Isommalla pinolla operoinut vihu kasasi itselleen kaikki Roopen merkit ja Roope lähti miettimään, kannattaa re-entryn teko.
Muutakin pelattavaa on jos 555€ Championship ei nappaa Posted Tuesday 27th February, 2024 at 13:24(UTC+2) by Juhani Tyriseva
Vaikka toimitus askartelee tänään lähinnä 555€ Championshipin kanssa, on pelaajille kovasti vaihtoehtoja, jos tämä ei nappaa tai lähtö (kuten monelle käy) tästä 555€ kisasta tulee.
Keskeiset:
Klo 13.00 NLH Satellite illan Celebrityyn. Buy in 0€, rebuys/add on 10€
Klo 14.00 Flip & Go Satellite Mystery Bountyyn 130€+20€
Klo 15.00 NLH 250€, 100€ Progressive Bounties.
Klo 17.00 1100€ PLO4/5 Championship, Day 1
Klo 18.00 Welcome Drinks @OlympicCasino
Klo 19.30 150€ NLH Celebrity Special
Klo 22.00 MegaSatellite to KoT Main Event, 150€ Buy in
12:58 (UTC+2)
Start of Level 11 Blinds: 1,000/1,500 Ante: 1,600
Hyvä pilli, jos oli pilli? Posted Tuesday 27th February, 2024 at 12:58(UTC+2) by Juhani Tyriseva
Blindien välisessä Johan Palokangas ja Jari Lahtinen.
Riveriin tultiin, pöytä oli:
Johan löi 5700, Jari mietti hetken ja meni all in 28K.
Johan miettimään, kippi. "Hyvä pilli oli, jos oli pilli", pohti Johan.
"Ei ollut pilli, oli minulla suora", ilmoitti Jari. Johan ei kyllä oikein tuntunut Jaria tällä kertaa uskovan.
Ville osoitti luonnetta Posted Tuesday 27th February, 2024 at 12:50(UTC+2) by Juhani Tyriseva
Ville Turja avasi buttonista, Lucas Cravero 3-bettasi pienestä, maksu.
Floppi Lucas löi 6K, maksu.
Turn Lucas löi 13K, Ville mietti hetken ja meni all in. Lucas ei aikaillut, vaan kippasi nopeasti.
Ville näytti
Ja nyt mennään - ennätystahtiin! Posted Tuesday 27th February, 2024 at 12:29(UTC+2) by Juhani Tyriseva
Kings of Tallinn Championship (555€) turnauksen päivä 2 on saatu käyntiin, ja heti alkuun voidaan iloita uudesta ennätyksestä. Tällä hetkellä turnauksessa on tehty 581 sisäänostoa, mikä on enemmän kuin tässä turnauksessa koskaan.
300 pelaajaa istuu pöydissä, joten tunnelma on tiivis.
Suomalaiset siis minulla erityisvartioinnissa, koetan meikäläisten tilanteita postata ketjuun mahdollisimman paljon.
Mielenkiintoista päivää!!
12:25 (UTC+2)
Day 2 of Kings of Tallinn 2024 Started Level: 10 Blinds: 600/1,200 Ante: 1,200
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.
Bielskis sökötti, Jan-Mikael meni all in 275K, Imsa maksoi. Bielskis miettimään, päätyi kippaamaan auki 
ja Jan-Mikael nousi kuilun partaalta voittoon, hänellä nyt noin 950K. 
kättä vastaan. 
kädellään, eikä ohi minusta päässyt", kertoi Mikko Ylämäki. 
oli Thor William Morstolin 
sököteltiin.
Konsta meni all in 665K, Matte miettimään, maksu.
täyskäden. 
ja Konstan pino kolminkertaistui, hänellä nyt noin 1300K. 
ja vihun väri lähetti Joelin kassan suuntaan. 
Krumins joka oli jo kohtuullisen humalassa, löi jatkolyönnin, menin all in 200K, hän maksoi 
kädelläni, Touko maksoi 
kädelle", kertoi vierestä seurannut Roope Tarmi. 
sököteltiin.
sököteltiin.
nelosparin ja vei potin. 
"Kolmen pelaajan all inissä mun 
£ GBP
$ USD
€ EUR
