0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0062 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsopc_tallinn_me_EST/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.0002 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.0003 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.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0002 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0061 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_wsopc_tallinn_me_EST'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '141'
0.0248 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '347'
AND `published` = 1
0.0247 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0046 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '369'
AND `published` = 1
0.0246 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0045 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '375'
AND `published` = 1
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '141'
AND `name` = '2'
0.0055 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '347'
ORDER BY `busted` ASC, `current_chips` DESC
0.0049 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` = '347'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '15543'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15534'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15529'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15525'
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` = '15523'
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` = '15522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15516'
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` = '15512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15506'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15504'
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` = '15502'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15490'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15486'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15484'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15480'
ORDER BY `chip_change` DESC, `busted` ASC
0.0091 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15479'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15477'
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` = '15475'
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` = '15471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0097 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15469'
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` = '15462'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15461'
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` = '15458'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15455'
ORDER BY `chip_change` DESC, `busted` ASC
0.0384 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15441'
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` = '15437'
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` = '15435'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15433'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15431'
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` = '15430'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15429'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15427'
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` = '15420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15414'
ORDER BY `chip_change` DESC, `busted` ASC
0.0457 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15412'
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` = '15409'
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` = '15408'
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` = '15404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15394'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15392'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15390'
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` = '15386'
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` = '15382'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15377'
ORDER BY `chip_change` DESC, `busted` ASC
0.0467 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15366'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15362'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15354'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15352'
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` = '15350'
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` = '15346'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15340'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15332'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15325'
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` = '15324'
ORDER BY `chip_change` DESC, `busted` ASC
0.0466 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15316'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15312'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15309'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15305'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15304'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15301'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15300'
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` = '15051'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '347'
ORDER BY `busted` ASC, `current_chips` DESC
0.0050 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` = '347'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0459 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15543'
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` = '15534'
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` = '15529'
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` = '15525'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15523'
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` = '15522'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15518'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15516'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15512'
ORDER BY `chip_change` DESC, `busted` ASC
0.0066 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15510'
ORDER BY `chip_change` DESC, `busted` ASC
0.0482 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15506'
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` = '15504'
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` = '15502'
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` = '15498'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15496'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15493'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15490'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15486'
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` = '15484'
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` = '15480'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15479'
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` = '15477'
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` = '15475'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15469'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15462'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15461'
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` = '15458'
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` = '15455'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15441'
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` = '15437'
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` = '15435'
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` = '15433'
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` = '15431'
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` = '15430'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15429'
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` = '15427'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15420'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15414'
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` = '15412'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15409'
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` = '15408'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15404'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15396'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15394'
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` = '15392'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15390'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15386'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15382'
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` = '15377'
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` = '15374'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15366'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15362'
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` = '15354'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15352'
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` = '15350'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15346'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15340'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15332'
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` = '15325'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15324'
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` = '15316'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15312'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15309'
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` = '15305'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15304'
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` = '15301'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15300'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15051'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '375'
ORDER BY `busted` ASC, `current_chips` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2553
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.
Turniiri jätkab 17 Eesti mängijat Posted Saturday 27th July, 2024 at 01:37(UTC+2) by maheaaatom
Põhiturniiri teise päeva järel püsib mängus 68 parimat, kelle seas 17 Eesti mängijat. Paul Koppe on turniiri chipliider, üle miljoni stäkid on ka Kaspar Kaiselil ja Marius Morelil.
Action jätkub laupäeval kell 12:00, mil mängitakse kuni finaallauani. Head ööd!
Player
Chips
Progress
Paul Koppe
1,660,000
240,000
Kaspar Kaisel
1,465,000
235,000
Marius Morel
1,105,000
105,000
Evgeny Vyal
790,000
513,500
Aleksei Vandyshev
690,000
0
Andre Villandberg
585,000
265,000
Mairo Tori
500,000
200,000
Mauri Dorbek
475,000
55,000
Ermo Kosk
445,000
155,000
Risto Pärnat
325,000
55,000
Sergei Aleksejev
280,000
51,500
Markku Koplimaa
265,000
5,000
Igor Pihela noorem
245,000
55,000
Andre Grigorjev
230,000
99,000
Martin Piik
220,000
40,000
Artur Külanurk
60,000
170,000
Steven Tool
50,000
170,000
Andre kaotab ässadega megapanga Posted Saturday 27th July, 2024 at 00:51(UTC+2) by maheaaatom
Floppi vaatab kolm mängijat.
Checkitakse kuni Andre Grigorijevini, kes panustab 100K ning saab mõlemalt vastaselt calli.
Turn on , checkitakse taas kuni Andreni, kes lükkab nüüd keskele juba 200K. Vastu tuleb aga all-in (550K) kreeklaselt Enea Subashilt. Andre mõtleb pisut, leides viimaks siiski calli.
"Kas sul on nuts?" pärib Andre ning kreeklane avabki . Andrel .
Kahju, tegemist oli tõenäoliselt suurima pangaga, kus ükski eestlane täna osalenud. Andre jääb ellu, kuid kahjuks mitte kuigi suure stäkiga.
Ühtlasi hakkab päev lõppema ning mängijad pakivad chippe. Poole tunni jooksul katsume avaldada ka eestlaste täpse puntkiseisu.
Andre näitab Pauli vastu jõulist mängu Posted Saturday 27th July, 2024 at 00:40(UTC+2) by maheaaatom
Eestlane Andre Grigorjev avab 30K tõstega ning Paul Koppe vastab traditsioonilise 3-panusega 75K. Andrelt call.
Flopis avatakse ning Andre avab 50K-ga. Paul vastab 125K-ga ning Andre taas callib.
Turn on ning taas jätkab Andre panustamist, seekord 100K-ga. Paul hakkab naerma ja viskab kiirelt maha.
Ega jõumängu vastu muud moodi saagi kui peab ka ise jõudu näitama. Käib viie viimase käe jagamine. Vahepeal on langenud kolm soomlast, 69 parimat mängus.
73. koht Martin Keskküla, 79. koht Sergei Krementsukov - mõlemad 3250 € Posted Saturday 27th July, 2024 at 00:31(UTC+2) by maheaaatom
Sisuja mängu teinud Martin Keskküla, kes alustas päeva korralikku 160 000 punktiga, lõppkohaks jääb 73. Sergei jääb temast kuus kohta tahapoole.
Mängus 72 parimat.
Player
Chips
Progress
Sergei Krementsukov
0
0
Martin Keskküla
0
0
Lõppes €250 NLH & PLO 4 & 5 Mix Posted Saturday 27th July, 2024 at 00:27(UTC+2) by maheaaatom
Turniiri võitis Hollandi mängija, kellele järgnes kolm soomlast. Eestlasi kahjuks finaallauda ei jõudnud.
Kahjuks tuleb tõdeda, et Eesti pokkerimängijatel pole siiani just kõige paremini läinud, võidetud on vaid üks kõrvalturniir. Samas on tähtsaimad turniirid alles käimas või ees ning põhiturniiril on meie meeste seis päris hea. Loodame, et me ilma sõrmuseta ei jää, kuigi eelmise aasta õnnestumist (4 sõrmust) ületada on juba sisuliselt võimatu.
Paul hoiab survet Posted Saturday 27th July, 2024 at 00:24(UTC+2) by maheaaatom
Paul Koppe hoiab omas lauas (kus istuvad ka Igor Pihela ja Andre Villandberg) survet ning ründab järjest panku. Eks seda peabki tegema, lisaks on Paulil selgelt ka kõige suurem stäkk.
Paljude mängijate mõtted tunduvad olevat juba homses päevas. Täna on mängida veel umbes pool tundi ning laudades 74 parimat.
Kuidas Arturil läheb? Posted Saturday 27th July, 2024 at 00:12(UTC+2) by maheaaatom
Mullu selsamal turniiril kolmanda koha saavutanud ning oma elu tulemuse teinud Artur Külanurk on selgi aastal rahades ning istub hetkel lauas umbes 240K stäkiga, mis on 20XBB. Otseselt veel kiiret pole.
Steven Toolil on umbes samapalju, mõni aeg tagasi kaotas mees enam kui miljonilise panga -ga -le.
Martin Piigil on ligikaudu 260K. Mairo Tori on oluliselt juurde saanud ning hetkel 700K stäkiga. Kaspar Kaisel istub endiselt miljoni peal.
Player
Chips
Progress
Mairo Tori
700,000
250,000
Martin Piik
260,000
105,000
Artur Külanurk
230,000
20,000
Steven Tool
220,000
80,000
Maja neliku vastu, Paul ligineb kahele miljonile Posted Saturday 27th July, 2024 at 00:02(UTC+2) by maheaaatom
Igor Pihela ja Paul Koppe mängisid omavahel 800K panga, kus sattusid vastamisi Igori ja Pauli i.
Tähelepanu väärib aga board - !
Niisiis - maja neliku vastu. Igoril on umbes 300K järgi, kuid Paulil peaks olema hetke suurim stäkk - umbes 1,9M.
Player
Chips
Progress
Paul Koppe
1,900,000
800,000
Igor Pihela noorem
300,000
300,000
84. koht Sten Liivand 3250 € Posted Friday 26th July, 2024 at 23:51(UTC+2) by maheaaatom
Sten Liivandile jääb WSOP Circuit põhiturniiri lõppkohaks 84. ning auhinnaraha kaasneb sellega 3250 eurot.
Jätkab 81 parimat ning äsja alanud tänase viimase mängutaseme pimepanused on 6000/12000/12000.
Vabandame veelkord lugejate ees, kuna programmis esineb ajutusi tehnilisi tõrkeid, mis võivad muuta keskkonna kohati väga aeglaseks nii lugejate kui blogijate jaoks. Katsume anda endast parima ning loodame, et probleem kiiremas korras laheneb.
Player
Chips
Progress
Sten Liivand
0
0
Eestlaste stäkke Posted Friday 26th July, 2024 at 23:41(UTC+2) by maheaaatom
Player
Chips
Progress
Paul Koppe
1,100,000
150,000
Igor Pihela noorem
600,000
150,000
Mairo Tori
450,000
70,000
Mauri Dorbek
420,000
40,000
Martin Piik
365,000
5,000
Andre Villandberg
320,000
280,000
Steven Tool
300,000
200,000
Risto Pärnat
270,000
50,000
86. koht Jaanus Kippel 3250 € Posted Friday 26th July, 2024 at 23:34(UTC+2) by maheaaatom
Jaanus Kippel on omamoodi online-pokkeri Eesti meistrivõistluste fenomen. 2022. aastal tuli ta OPEM põhiturniiril teiseks, järgmine aasta aga juba võitjaks.
Live-pokkeris on Jaanus mänginud pigem väikseid turniire ning seetõttu on täna saavutatud 86. koht koos 3250-eurose auhinnarahaga mehe karjääri teadaolevalt suurim live-turniirivõit.
Player
Chips
Progress
Jaanus Kippel
0
0
Ermo kaotas miljonipanga Posted Friday 26th July, 2024 at 23:30(UTC+2) by maheaaatom
Kahjuks üks halb uudis lauast nr. 12.
Ermo Kosk callis Ignotas Tamasauskase all-in panust pärast lauas avatud kaarte
Ermo:
Ignotas:
River midagi ei muutnud, kõrgemad kaks paari pidasid. Ermo õnneks oli leedulasel kaks korda väiksem stäkk, kuid hiigelpank (1,1M) läks viimasele ning nüüd osad vahetusid. Ermol umbes 600K järgi.
Player
Chips
Progress
Ermo Kosk
600,000
550,000
Mariusele pisike stäkilisa Posted Friday 26th July, 2024 at 23:22(UTC+2) by maheaaatom
Marius Morel kugistas just alla ühe väikese stäki, kes kaitses oma blindi -ga. Mariuse tegi oodatult puhta töö.
97. koht Urmo Velvelt 3000 € Posted Friday 26th July, 2024 at 23:13(UTC+2) by maheaaatom
Maailmakuulsal netiässal Urmol oli alles ainult 5XBB ning sellega pidi ta loomulikult pressima. Kahjuks sattus Urmo 3-way panka, kus temale jäi vaid statisti osa.
Tasuks 3000 € eurot, tema kohta tavaline buyin online-turniiridel. Aga küllap näeme Urmot juba homsel highrolleril.
Player
Chips
Progress
Urmo Velvelt
0
0
Miljonärid Posted Friday 26th July, 2024 at 23:07(UTC+2) by maheaaatom
Kaspar Kaisel ja Ermo Kosk on veel tõusnud ning hetkel tõenäoliselt eestlastest rikkaimad vastavalt 1,23M ja 1,15M stäkkidega. Mariusel on endiselt umbes miljoni kanti.
Player
Chips
Progress
Kaspar Kaisel
1,230,000
350,000
Ermo Kosk
1,150,000
500,000
Marius Morel
1,000,000
10,000
Igor lõhkab mulli Posted Friday 26th July, 2024 at 22:57(UTC+2) by maheaaatom
Lauas on ning all-in nii Igor Pihela noorem kui Nemo T. O. A. Israel.
Nemo:
Igor:
Seega - poisid ja potid. Ja poiss riverisse ka tuleb! Igoril nüüd 750K stäkk, tema lauas on aga Paul Koppel veel enam - 950K.
Palju õnne allesjäänud mängijatele - kõik on teeninud vähemalt 3000 eurot!
Player
Chips
Progress
Paul Koppe
950,000
770,000
Igor Pihela noorem
750,000
410,000
Mäng jätkub, täna veel kaks taset Posted Friday 26th July, 2024 at 22:47(UTC+2) by maheaaatom
Mullimäng läheb edasi, blindid on 5000/10000/10000.
Täna mängitakse veel kaks taset (2x60 min) või kuni mulli lõhkemiseni. Oleks muidugi täielik ime, kui mull varem ei lõhkeks, tõenäoliselt juhtub see õige pea.
Algas tänane viimane paus Posted Friday 26th July, 2024 at 22:25(UTC+2) by maheaaatom
Mängijad lubati 15 minutiks puhkama. Mull pole veel lõhkenud ning bubble-play jätkub pärast pausi.
Algas mullimäng Posted Friday 26th July, 2024 at 21:56(UTC+2) by maheaaatom
Mäng jätkub hand-by-hand, laudades on 104 mängijat. Kahjuks kaotasime enne mõned eestlased, nende seas päeva keskel ülihead stäkki omanud Kristjan Maasalu, ainsa konkurentsis püsinud Eesti naismängija Katariina Ingerma ning WSOP Circuit sõrmusekandja Aleksei Smirnovi.
On vähemalt üks 30K ja üks 50K stäkk. Nemad on ka esimesena sihikul.
P.S. Ülekandes võib esineda tõrkeid, kuna meil on tehnilisi probleeme.
Player
Chips
Progress
Kristjan Maasalu
0
0
Andre Mägi
0
0
Aleksei Smirnov
0
0
Katariina Ingerma
0
0
Eestisse kaks cashi €250 NLH & PLO 4 & 5 Mix'ilt Posted Friday 26th July, 2024 at 21:52(UTC+2) by maheaaatom
Sellel kõrvalturniiril on selgunud 10 parimat ning eestlasi kahjuks nende seas pole.
12. koha sai Egon Kaljulaid ja 11. Erik Põlluveer (vastavalt 570 ja 650 eurot). Väike "Hendoni-cash" ikka :)
Viis kohta mullini Posted Friday 26th July, 2024 at 21:43(UTC+2) by maheaaatom
Mullimäng on suhteliselt lähedal ning pole kahtlust, et see täna ka lõhkeb. Veel viis mängijat ning kõikidele allesjäänutele on tagatud vähemalt 3000 eurot.
Lühike tehniline paus Posted Friday 26th July, 2024 at 21:27(UTC+2) by maheaaatom
Toimub telelaua vahetus ning turniirikell pandi korraks kinni.
Mariusel miljon koos Posted Friday 26th July, 2024 at 21:21(UTC+2) by maheaaatom
Marius Morel on tõusnud taas liidriks stäkiga, mis on tema väitel "üle miljoni". Noh, kui siis õige natuke.
Kaspar Kaisel on samuti miljonile lähenemas, tal ca. 880K. Kes on aga ära andnud, on Urmo Velvelt, kes peab saama hetkel hakkama vaid pisut enama kui 10XBB stäkiga.
112 mängijat järgi, blindid 4000/8000/8000.
Player
Chips
Progress
Marius Morel
1,010,000
330,000
Kaspar Kaisel
880,000
250,000
Steven Tool
630,000
130,000
Andre Villandberg
600,000
70,000
Mauri Dorbek
460,000
80,000
Mairo Tori
380,000
60,000
Markku Koplimaa
260,000
80,000
Urmo Velvelt
100,000
260,000
Pavel Solodovnikov
0
0
Steven Seller
0
0
Algas 250 € NLH turbo Posted Friday 26th July, 2024 at 21:08(UTC+2) by maheaaatom
Alanud on ka 250 € NLH ning laudades 43 mängijat. Eestlastest on võistlemas näiteks Priit Vanem ja tuntud naismängija Annemar Neiland.
Ermole kõva lisa Posted Friday 26th July, 2024 at 21:05(UTC+2) by maheaaatom
Ermo võitis oma lauas suure panga, callides pika mõtlemise järel ära Pasi Sormuneni 200K all-in panust kui lauas oli avatud
Vastas polnud õnneks midagi enamat -st, Ermo võttis panga ilusti maha.
"Eks ma masti kartsin küll," tunnistab seitsmekordne Eesti pokkerimeister ka ise, kuid lisab, et panus ei vastanud tema hinnangul siiski mastile. Kogemused...
Ermol nüüd 650K. Üks eestlane kahjuks ka vähem - Steven Selleril ei õnnestunud oma shortstäkiga vajalikku duublit saada.
Player
Chips
Progress
Ermo Kosk
650,000
250,000
Andre annab valusa, kui õnneks väikse duubli Posted Friday 26th July, 2024 at 20:48(UTC+2) by maheaaatom
15. lauas on Andres Villandberg callimas Ali Kabiri Fari (80K) all-in'i.
Andre:
Ali:
Lauda brutaalne
Õnneks on Andrel niivõrd suur stäkk, et tema jaoks jätkub mäng endises taktis.
Tempo on all Posted Friday 26th July, 2024 at 20:36(UTC+2) by maheaaatom
Mullini on 20 kohta ning kuna keskmine stäkk on 55XBB, on tempo suhteliselt all - mängitakse väikseid panku ning midagi olulist juhtunud pole. Kõik eelnevalt mainitud eestlased on endiselt kenasti sees.
Kõrvalactionit Posted Friday 26th July, 2024 at 20:24(UTC+2) by maheaaatom
1 100 € NLH Mystery Bounty'l on tehtud juba 179 sisseostu, kuid action veel võrdlemisi noor.
SVITEN on juba üle tunni kestnud ning tehtud on 63 sisseostu. Mängijaid on kõikjalt, ka viis-kuus eestlast.
250 € NLH & PLO 4 & 5 Mix turniiri lõplikuks sisseostude arvuks jääb 119 ning hetkel on mängus 23 parimat, nende seas ka kaks eestlast.
Kes tahavad mängida "tavalist" ja võrdlemisi odavat pokkerit, on oodatud kell 21:00 algavale 250 € NLH Turbo, 8-handed turniirile, mis on ka tänane viimane kõrvalturniir.
Stäkkide seis Posted Friday 26th July, 2024 at 20:18(UTC+2) by maheaaatom
Tuntud ässadest on väljas Norra pokkerimiljonär Jon Kristian Kyte, eestlasi õnneks vahepeal langenud ei ole. Suurima stäkiga peaks meie omadest olema Kaspar Kaisel umbes 850K-ga.
Jätkab 127 parimat, seega on mullini veel 24 kohta. Hetkel 18. tase ja blindid 3000/6000/6000
Player
Chips
Progress
Kaspar Kaisel
850,000
220,000
Marius Morel
680,000
120,000
Andre Villandberg
530,000
40,000
Steven Tool
500,000
250,000
Mairo Tori
440,000
50,000
Jaanus Kippel
400,000
90,000
Ermo Kosk
400,000
80,000
Mauri Dorbek
380,000
90,000
Martin Piik
370,000
10,000
Urmo Velvelt
360,000
40,000
Igor Pihela noorem
340,000
120,000
Markku Koplimaa
340,000
10,000
Risto Pärnat
320,000
20,000
Ermo kaotab väikese panga, Igor võtab duubli Posted Friday 26th July, 2024 at 19:05(UTC+2) by maheaaatom
Edoardo Mancinelli avab 10K tõstega, Ermo Kosk tõstab positsioonilt üle 32K ning saab calli.
Flop: .
Itaallane checkib ning callib Ermo 11K panust.
Turn on ning Edoardo check-callib taas meie mehe 16K panust.
River checkitakse läbi, itaallane abav ning Ermo muckib koheselt.
Paar lauda eemal õnnestub Igor Pihela nooremal oma stäkk -ga vastu duublisse saada. Seda hitti oli kindlasti vaja.
Ühtlasi on käes aeg õhtusöögipausiks ning me oleme tagasi kell 20:00.
Player
Chips
Progress
Tauno Pajula
0
0
Mairo ja Andre sõdivad blindidel Posted Friday 26th July, 2024 at 18:52(UTC+2) by maheaaatom
Mairo Tori ja Andre Villandberg vaatavad blindidel floppi .
Mairo checkib ette, Andre paneb 30K ning saab Mairolt 80K ületõste. Andrelt call.
Turn ning river checkitakse läbi.
Piisab Andrel oma avada, kui Mairol lehed lendavad kiirelt mucki.
Mairol 390K järgi, kuid Andrel juba 570K.
Player
Chips
Progress
Andre Villandberg
570,000
477,000
Mairo Tori
390,000
236,000
Naxeri stäkk sulas kokku Posted Friday 26th July, 2024 at 18:39(UTC+2) by maheaaatom
Marko Keskel ei suutnud oma stäkiga siiski imesid teha ning on paraku mängust väljast. Aga 22 euro eest oli mängurõõmu kindlasti piisavalt. Muidugi - mulli oleks ju võinud ka ikkagi üle elada...
Jätkab 143 parimat, keskmine stäkk on kerkinud 57XBB peale. Paarkümmend eestlast on veel mängus ning õnneks on nii mõnelgi neist üsna pirakad stäkid.
Player
Chips
Progress
Marko Keskel
0
0
Sergei Kuznetsov
0
0
Martin Zobel
0
0
Veel eestlaste stäkke Posted Friday 26th July, 2024 at 18:26(UTC+2) by maheaaatom
Väga korraliku stäki on ajanud kokku Kaspar Kaisel, kes ka alustas tänast päeva heast seisust.
Jätkab 151 parimat, mullini on 48 kohta. Täna see kindlasti ka lõhkeb, kuid aega veel on.
Player
Chips
Progress
Kaspar Kaisel
630,000
362,500
Risto Pärnat
340,000
169,000
Jaanus Kippel
310,000
79,500
Aleksei Smirnov
260,000
10,000
Steven Tool
250,000
0
Igor Pihela noorem
220,000
20,000
Artur Külanurk
210,000
93,000
Paul Koppe
180,000
88,500
Martin Keskküla
160,000
83,500
Katariina Ingerma
130,000
49,000
Alari Arnover
0
0
Rene Peterkopf
0
0
Marius juhib turniiri Posted Friday 26th July, 2024 at 18:12(UTC+2) by maheaaatom
Suurima stäkiga mängija peaks praeguse seisuga olema meie oma Marius Morel, kel umbes 800K punkti.
Mairo Tori on suuruselt neljas (626K), Kristjan Maasalu kuues (610K) ning Mauri Dorbek kümnes (470K).
Player
Chips
Progress
Marius Morel
800,000
0
Mairo Tori
626,000
14,000
Kristjan Maasalu
610,000
10,000
Mauri Dorbek
470,000
50,000
VIDEO: Kuidas mängida Svitenit? Posted Friday 26th July, 2024 at 18:09(UTC+2) by maheaaatom
Kell 19:00 algab järgmine kõrvalturniir, 250 € sisseostuga SVITEN (Five Card PLO & Draw). Tegemist on (nagu nimigi ütleb) rootslaste mänguga ning kes sobiks seda mängu veel paremini selgitama kui Rootsi meister Peter La Terra.
Tarmo Tammelil on olnud paremaid päevi Posted Friday 26th July, 2024 at 18:06(UTC+2) by maheaaatom
Eesti GPI edetabeli liider, tuntud turniirihai Tarmo Tammel on kahjuks mängust väljas.
Tarmol (alustas päeva 89 500 punktiga) ei olnud väga stäkki ega ka erilisi võimalusi selle suurendamiseks.
Player
Chips
Progress
Tarmo Tammel
0
0
Kaardid taas õhus Posted Friday 26th July, 2024 at 18:03(UTC+2) by maheaaatom
Paus venis tehnilistel põhjustel natuke pikemaks, kuid nüüd mäng jätkub ning laudades on 166 pokkerisportlast. Välja on langenud Anton Markachev ja Timmo Kaha.
17. tase vältab juba tunni ning selle järel algab tund aega kestev õhtusöögipaus.
Blindid 2000/5000/5000, kesmine stäkk ligi 50XBB.
Player
Chips
Progress
Timmo Kaha
0
0
Anton Markachev
0
0
Urmo edeneb, "Naxer" paraku mitte Posted Friday 26th July, 2024 at 17:38(UTC+2) by maheaaatom
Urmo Velvelt on tõusnud 400K peale, Mairo Tori natuke ära andnud (640K).
Marko "Naxer" Keskel, kes lubas, et alla 30XBB ta ei lange, on hetkel mängus umbes 15XBB stäkiga. Ju siis pole mees kogenud sobivat kaardijooksu või siis leidnud ühtegi head kohta, kust lükkama minna.
Kahjuks on väljas nii Marita Mägi kui Eesti rahalisti nr. 1 Ilya Nikiforov.
Põhiturniir saadeti järjekordsele pausile, mis on seekord 15 minutit.
Player
Chips
Progress
Mairo Tori
640,000
60,000
Urmo Velvelt
400,000
100,000
Martin Piik
380,000
20,000
Markku Koplimaa
330,000
10,000
Marita Mägi
0
0
Ilya Nikiforov
0
0
Marita ja Tarmo üritavad ellu jääda Posted Friday 26th July, 2024 at 17:20(UTC+2) by maheaaatom
Kiita pole ei Marita Mägi ega Tarmo Tammeli stäkk. Marita on siiski püsinud üsna pikalt 100K peal, mis on 25XBB ja annab siiski teatavat mänguruumi. "Kaarte pole aga üldse, tavaline on ," naeratab Marita mõrumagusalt.
Tarmo Tammelil on umbes 60K alles ning sellega pole samuti pikka pidu. Aga Tarmo on väga kannatlik ja ootab õiget kohta, lugedes tähelepanelikult igat jaotust.
400K pank Mariusele Posted Friday 26th July, 2024 at 17:07(UTC+2) by maheaaatom
12. lauas oli pärast lauas avatud all-in Soome lipu all võistlev Mihn Thang Ngo.
Pangas oli juba tubli 170K ning Ngo all-in panus pisut üle saja tuhande. Mariuselt call.
Ngo:
Marius:
Umbes 400K pank meie mehele, kel nüüd ca. 800K. See on juba kõva väljakutse.
Eestlastest väljas noor kahur Hendrik Uibo, kelle tähelend algaski suuresti just mullusel WSOP Circuit põhiturniiril.
Player
Chips
Progress
Marius Morel
800,000
450,000
Hendrik Uibo
0
0
Kohe algab 1100-eurone sõrmuseturniir Posted Friday 26th July, 2024 at 16:57(UTC+2) by maheaaatom
Loetud minutite pärast läheb käima 1 100 € NLH Mystery Bounty, mis on arvult kaheksas sõrmuseturniir. See turniir on kahepäevane ning täna mängitakse kuni rahakohtadeni.
Kristjanil käis jõuluvana külas Posted Friday 26th July, 2024 at 16:53(UTC+2) by maheaaatom
Vahetult enne pausi oli üks 300K stäkk Kristan Maasalu lauas lammutama kukkunud ning kõik meie mehele maha mänginud. Kristjanil on ka hetkel alles 600K stäkk, mis on kolmekordne keskmine ning väga kõva sõna.
Eriti hästi edeneb mulluse põhiturniiri viies mees Mairo Tori, kel lausa 700 000 punkti. Aga kurta pole ka Martin Piigi ka Mauri Dorbeku stäkid.
Player
Chips
Progress
Mairo Tori
700,000
421,500
Kristjan Maasalu
600,000
440,500
Mauri Dorbek
420,000
34,000
Martin Piik
400,000
127,000
Ermo Kosk
320,000
143,500
Aleksei Smirnov
250,000
120,000
Herli üheksatega väljas Posted Friday 26th July, 2024 at 16:43(UTC+2) by maheaaatom
Herli Olopi tänane kaardijooks oli kõike muud kui kiita, oma väikese 30K stäkiga oli ka raske tühjalt kohalt duubleid otsida. Viimaks õnnestus see siiski saada.
Kohe järgmises käes jagati Herlile üheksad ja neile tuli call -lt.
Flopis numbripuru ja Herli juba mõtles, et siit hakkab võib-olla uus tähelend. Riveris paraku äss.
"Tase on ikka üsna tugev. Tõsi-satelliitidel käib täiesti suvaline lammutamine," muljetas Herli.
Väljas ka Richard Koppel ja Hanna Heinlo. Alles 200 parimat.
Player
Chips
Progress
Hanna Heinlo
0
0
Richard Koppel
0
0
Herli Olop
0
0
Turniiri võitja teenib 193 750 eurot Posted Friday 26th July, 2024 at 16:19(UTC+2) by maheaaatom
Lõplik auhinnafond on 1 052 352 eurot, sisseoste kogunes 812. Tegemist on seega suurima turniiriga, mis toimunud Olympic Park Casinos, kuigi mitte päris suurima auhinnafondiga turniiriga Eestis.
Turniiri võitjat premeeritakse 193 750 euroga, kuigi ei saa välistada, et parimad sõlmivad omavahel diili nagu ka juhtus möödunud aastal. Min-cash on täna 3000 eurot ehk kahte bulletit kasutanud mängijad saavad täpselt oma raha tagasi.
Veel kolm eestlast out, nende seas ka high-roller Igor Pihela vanem.
Player
Chips
Progress
Riho Sagor
0
0
Egon Norden
0
0
Igor Pihela vanem
0
0
VIDEO: 7. päeva kokkuvõte Posted Friday 26th July, 2024 at 16:09(UTC+2) by maheaaatom
Algas tänane esimene kõrvalturniir Posted Friday 26th July, 2024 at 16:08(UTC+2) by maheaaatom
Just läks käima €250 NLH & PLO 4 & 5 Mix, esialgu 31 mängijaga. Liituda saab kuni kella 18:30-ni.
NB! Kohe saab hakata jälgima ka põhiturniiri TV-ülekannet. Telelauas Eesti rahalisti esinumber Ilya Nikiforov ning meie naismängija Kateriina Ingerma.
Ermo ampsas ühe väiksema stäki Posted Friday 26th July, 2024 at 16:03(UTC+2) by maheaaatom
Vilius Maniusis avas UTG-lt tõstega, misjärel läks väikese stäkiga Ritvars Cekalins keskelt all-in ning sama tegi ka tema järel istuv Ermo Kosk, kelle stäkk polnud samuti kuigi suur. Kõik teised mängijad foldisid.
Ritvars:
Ermo:
Laud pidas ning Ermole vajalik lisa.
Eestlastest kahjuks väljas kaks väga nimekat ässa: Ranno Sootla ja Taago Tamm.
Player
Chips
Progress
Ranno Sootla
0
0
Taago Tamm
0
0
Lõplikult langenud eestlased Posted Friday 26th July, 2024 at 15:48(UTC+2) by maheaaatom
Player
Chips
Progress
Priit Oja
0
0
Meelis Ahman
0
0
Priit Parmasto
0
0
Aleksandr Geller
0
0
Ranel Käsi
0
0
Rasmus Sepping
0
0
Madis Ormisson
0
0
Nadezda Guk
0
0
Vadim Guk
0
0
Stanislav Smeljov
0
0
Kaido Mikk
0
0
Dmitri Damaskin
0
0
Kris Tikka
0
0
Hanno Kerem
0
0
Jako Kuusik
0
0
Jargo Alaväli
0
0
Tanel Evert
0
0
Tanel Merida
0
0
Georgi Abuladze
0
0
Magnus Pukk
0
0
Anton Konnov
0
0
Andrei Mjagkov
0
0
Eestlaste jutunurgast Posted Friday 26th July, 2024 at 15:39(UTC+2) by maheaaatom
Steven Seller on tõusnud 230K peale, Mauri Dorbekul korralik 386K. Alles täna mänguga liitunud Urmo Velvelt on leidnud kiire hiiteri ning temal ka juba 300K.
Väike tänukõne OlyBeti ja Olympic Casino pokkerimänedžerilt ning turniir jätkub. Esialgse info põhjal on auhinnafondis 1049760 eurot ning tehti 810 sisseostu. Alles on 249 parimat, jätkame blindidega 1500/3000/3000.
Player
Chips
Progress
Mauri Dorbek
386,000
334,000
Urmo Velvelt
300,000
0
Steven Seller
230,000
196,500
"Naxer" ei kavatse tiksuma hakata Posted Friday 26th July, 2024 at 15:09(UTC+2) by maheaaatom
Marko Keskel on omajagu ära andnud ning tal kuskil 120K alles, mis on 40XBB.
"Ma ei kavatse alla 30XBB kukkuda, nii pole mängida mõtet," avaldab "Naxer" ning kurdab seejärel, et premium käsi pole täna üldse olnud. Aga loodetavasti toob edu julge ning kartmatu mäng, mis on "Naxeril" varemgi tulu toonud.
Mängijad hakkavad pausile minema, oleme tagasi 20 minuti pärast.
Viimase kolm re-entry kätt Posted Friday 26th July, 2024 at 15:03(UTC+2) by maheaaatom
Kuulutati välja viimased kolm re-entry kätt, mille jooksul on veel lubatud "paugutada). Siis on "pidu" läbi ning pärast pausi algab tõsine mäng.
Rahabosse pidavat kuuldavasti päris palju mängima, seega võime veel oodata auhinnafondi olulist paisumist.
Ilyal 130K Posted Friday 26th July, 2024 at 14:43(UTC+2) by maheaaatom
Põhiturniirist võtab osa ka Eesti rahalisti liider, nimekas high-roller Ilya Nikiforov.
Mees alustas päeva vaid 47K stäkiga, kuid on oluliselt juurde saanud ning hetkel on tal 130K.
Käimas on viimane re-entry eelne mängutase (20 minutit pausini), blindid 1500/3000/3000. Kui peaks nihu minema, on veel võimalus end 1500 euroga mängu osta ning saada selle eest 50 000 punkti.
Player
Chips
Progress
Ilya Nikiforov
130,000
83,000
Marita mustad kuningad Posted Friday 26th July, 2024 at 14:32(UTC+2) by maheaaatom
Marita sai väga lubava pocket käe ning tema 15K tõstega läks kaasa laua chipliider.
Lauas avati punased numbrid ning Marita panuse peale läks vastane all-in, mida Marita callima ei hakanud. Sinna läks omajagu stäkk, Marital nüüd umbes 100K järgi.
Samas lauas ka Paul Koppe umbes 180K punktiga.
Player
Chips
Progress
Marita Mägi
100,000
38,500
Auhinnagarantii on ületatud! Posted Friday 26th July, 2024 at 14:20(UTC+2) by maheaaatom
Hea sõnum kõikidele allesjäänud mängijatele: turniiri auhinnagarantii miljon eurot on ületatud! Prognoositakse, et see võib tõusta kuni 1,05 miljonini.
Täna mängitakse 11 taset Posted Friday 26th July, 2024 at 14:16(UTC+2) by maheaaatom
Täna on plaanis mängida 11 taset, mille vahele mahub ka tunnine õhtusöögipaus. Seega peaks mäng kestma umbes kella 23:30-ni.
Marius Morel tõusulainel Posted Friday 26th July, 2024 at 14:15(UTC+2) by maheaaatom
Mariuse käsi on käinud täna väga kenasti, tal hetkel juba ca. 350K. Ja Marius näitab aktiivset ning agressiivset pokkerit.
Markku Koplimaa on samuti lisa saanud, tal umbes 320K. Rahul on ka põhiturniirile vaid 22-eurosele satelliidilt kvalifitseerunud Marko "Naxer" Keskel, kellel umbes 230K. Selgetes raskustes on Tarmo Tammel, kes langenud vaid 40K peale.
Eesti naistest ka. Martinast me juba rääkisime. Hanno Heinlol on umbes 100K (on seega juurde saanud), Katariina Ingermal on 40K, Ave Lepik on kahjuks väljas.
Player
Chips
Progress
Marius Morel
350,000
207,500
Markku Koplimaa
320,000
70,000
Marko Keskel
230,000
50,000
Aleksei Smirnov
130,000
3,000
Hanna Heinlo
100,000
32,000
Tarmo Tammel
40,000
49,500
Ave Lepik
0
0
Käimas ka 1100 € NLH satelliit Posted Friday 26th July, 2024 at 14:00(UTC+2) by maheaaatom
Fuajees on juba tund aega käinud 80-eurose sisseostuga 1100 € sõrmuseturniiri satelliit (algab kell 17:00). Auhinnagarantiiks on 3 piletit, kuid tõenäoliselt see selgelt ületatakse, sest hetkel on tehtud juba 126 sisseostu.
Osalejate seas on ka rida eestlasi eesotsas Priit Ojaga, kes kohe mängu alguses põhiturniirilt bad beadiga välja langes.
Ermo: Eile oli väga mängitav, täna nats raskem Posted Friday 26th July, 2024 at 13:48(UTC+2) by maheaaatom
Seitsmekordne Eesti meister Ermo Kosk kiitis avapäeva, mille tase oli olnud vägagi "mängitav", kuid täna olevat juba raskem. Nuppe on siiski piisavalt järgi.
Päeva vaid 26K pealt alustanud Meelis Ahman on "ohutsoonist" väljas, tal hetkel 104K.
Algas 13. tase (1000/2500/2500) ning meil on veel mängida tund ja 20 minutit kuni re-entry perioodi lõpuni.
Player
Chips
Progress
Meelis Ahman
104,000
78,000
Uudiseid rindelt Posted Friday 26th July, 2024 at 13:24(UTC+2) by maheaaatom
Päeva suuruselt kolmanda stäkiga alustanud Martin Piik on natuke ära andnud, tal 273K järgi.
Mõlemal Igor Pihelal on ca. 200K (seega on noorem Igor päris korralikult juurde saanud). Marko "Naxer" Keskelil on pisut vähem.
Mairo Tori alustas päeva seitsmendalt kohalt (278 500) ning umbes sama palju on tal ka praegu.
Kehvasti on läinud Herlil, kes on langenud 121K pealt vaid 30K peale, mis on 12XBB. "Kaart lihtsalt ei jookse. Muidu makstakse siin lauas küll kõik asjad välja," mainib Herli.
Algas ka tänane esimene paus 20 minutit.
Player
Chips
Progress
Martin Piik
273,000
43,500
Igor Pihela vanem
210,000
22,500
Igor Pihela noorem
200,000
66,000
Marko Keskel
180,000
9,000
Herli Olop
30,000
91,000
Kas garantii ületatakse? Posted Friday 26th July, 2024 at 13:10(UTC+2) by maheaaatom
On igati reaalne, et tänavu ületatakse 1M eurone auhinnagarantii (mullu tekkis väike overlay).
Avapäevade osaleje arv oli järgmine: 1A (132 mängijat), 1B (25 mängijat), 1C (155 mängijat), 1D (30 mängijat), 1E (274 mängijat) ja 1F (77 mängijat). Mida see näitab? Mängu võetakse ikka päris tõsiselt ning valdav enamus mängijaid eelistab päevaseid "normaalpäevi" õhtustele turbodele.
Markku ja Marita Posted Friday 26th July, 2024 at 13:06(UTC+2) by maheaaatom
Fuajeelauas istuvad kõrvuti Markku Koplimaa ning Marita Mägi.
Markku on 195K pealt 250K peale tõusnud, kohe alguses õnnestus tal saada üks pank kätte just Marita vastu.
Aga Marita seis pole ka kurta. Ta alustas päeva 183 500 punktiga ning kuigi alguses läks sellest pea neljandik Markkule, on Marita vaikselt nuppe tagasi korjanud ning hetkel samas seisus, mis päeva alguses.
Player
Chips
Progress
Markku Koplimaa
250,000
54,500
Infoks flipisõpradele Posted Friday 26th July, 2024 at 12:53(UTC+2) by maheaaatom
Turniiride pauside ajal käivad fuajees tavapärased flipid, millega on võimalik hea õnne korral erinevaid turniiripileteid (näiteks põhiturniiri omi) saada.
See on juba õnnestunud 15 mängijal ning kõik need on võitnud koha ka laupäeval kell 11:30 toimuvale tasuta megaflipile, kus üks õnnelik mängija saab auhinnaks oktoobris toimuva Kings of Tallinn 2024 Autumn Edition põhiturniiri paketi.
Tanel bad beadiga väljas Posted Friday 26th July, 2024 at 12:41(UTC+2) by maheaaatom
Viiendast lauast tõusis just püsti Tanel Evert, kes alustas päeva 48 500 punktiga (suht võrdväärne algstäkiga), kuid langes juba esimesel tasemel pocket ässadega pocket kaheksate vastu. Kaheksa lauas, mis muud...
Tanel ei plaani mängu naaseda.
Mänguruumi nagu on? Posted Friday 26th July, 2024 at 12:37(UTC+2) by maheaaatom
Hetkel on keskmine stäkk 115 313 punkti, mis on pea 60XBB ning liiga palju tormamist seetõttu veel ei ole.
Laudades on 320 mängijat ning nii suur saal kui fuajee on mängijaid paksult täis. Tõenäoliselt ei muuta väga midagi enne re-entry perioodi lõppu, sest kes juba mängima tulnud on, teeb seda hingega.
Ja mis on täna tulemas? Posted Friday 26th July, 2024 at 12:29(UTC+2) by maheaaatom
Põhifookus on mõistagi põhiturniiri teisel päeval, kuid lisaks saab reedel kell 17:00 alguse ka 1100 € NLH Mystery Bounty (Ring Event #8), mille avapäev mängitakse kuni rahadeni.
Lisaks on kavas kolm kõrvalturniiri
– 250 € NLH & PLO4&5 Mix (kell 16:00),
- 250 € PL Sviten (kell 19:00) ja
- 250 € NLH Turbo 8-max (kell 21:00).
Päeva lõpetab kell 23:00 algav 150-eurose sisseostuga high-rolleri satelliit, mille auhinnagarantiiks on kolm 3000-eurost piletit.
Eilse päeva kokkuvõte Posted Friday 26th July, 2024 at 12:27(UTC+2) by maheaaatom
Neljapäeval leidis oma lõpplahenduse WSOP Circuit Tallinn 1100-eurose sisseostuga PLO 4&5 turniir, mille võitis soomlane Riku Matias Koivurinne. Järjekorras seitsmendale sõrmuseturniirile tehti 198 sisseostu ning selle auhinnafond oli tubli 190 800 eurot.
Finaali kindla liidrina alustanud norralane Jan Roger Holte jäi teiseks ning Lars Myklegard Romundstad (mõlemad mehed siis Norrast). Eestlased kahjuks keegi ei cashinud.
Neljast kõrvalturniirist oli suurima auhinnafondiga 555 € NLH Deepstack (172 sisseostu), mille võitis leedulane Andrius Bielskis. 226 sisseostuga 150 € NLH DeepStacki võitis Soomet esindav Xuan Truc Tran, 148 sisseostuga 250 € PLO4&5 Hi-Lo rootslane Björn Stefan Lindberg ning 194 sisseostuga PLO 4&5 Norra pokkerimängija Tarjei Forus. Viimasel saavutas Marius Morel kolmanda koha, mis oli kahjuks ka eilne ainuke pjedestaalikoht eestlastele.
Mäng on alanud Posted Friday 26th July, 2024 at 12:18(UTC+2) by maheaaatom
Kaardid ja mängijad on laudades ning teine päev alanud.
Kohal 328 pokkerisportlast, kokku on sisseoste kogunenud juba 720. On ka täna "nullist" alustajaid, nende seas näiteks mulluse Kings of Tallinn põhiturniiri tšempion Priit Parmasto.
Player
Chips
Progress
Priit Parmasto
50,000
0
12:13 (UTC+2)
Day 2 of Olympic Park Casino Started Level:Blinds: 0/0 Ante: 0
WSOP Circuit Tallinn põhiturniiri live-blogi alustab kell 12:00 Posted Thursday 25th July, 2024 at 11:51(UTC+2) by maheaaatom
Reedel kell 12:00 algab käimasoleva pokkerifestivali tähtsaima, 1M auhinnagarantiiga WSOP Circuit põhiturniiri teine päev. Meie live-blogi kestab kuni finaallauani (eeldusel, et konkurentsis on vähemalt üks eestlane). Hetkel on neid mängus 66, kokku on mängijaid 305.
Hiline registeerumine kestab kuni umbes 15:20-ni.
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.