0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0077 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-18'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event5/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.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.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.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0041 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.0006 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_wsop_tallinn_event5'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '140'
0.0885 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0136 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '328'
AND `published` = 1
0.1019 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0342 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '336'
AND `published` = 1
0.0073 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '140'
AND `name` = '2'
0.0291 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '336'
ORDER BY `busted` ASC, `current_chips` DESC
0.0279 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` = '336'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0493 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0368 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14674'
ORDER BY `chip_change` DESC, `busted` ASC
0.0478 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14673'
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` = '14672'
ORDER BY `chip_change` DESC, `busted` ASC
0.0129 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14668'
ORDER BY `chip_change` DESC, `busted` ASC
0.0131 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14667'
ORDER BY `chip_change` DESC, `busted` ASC
0.0128 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14666'
ORDER BY `chip_change` DESC, `busted` ASC
0.0135 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14665'
ORDER BY `chip_change` DESC, `busted` ASC
0.0597 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14662'
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` = '14660'
ORDER BY `chip_change` DESC, `busted` ASC
0.0130 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14651'
ORDER BY `chip_change` DESC, `busted` ASC
0.0129 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0134 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14654'
ORDER BY `chip_change` DESC, `busted` ASC
0.0354 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14652'
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` = '14650'
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` = '14649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0137 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0128 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14641'
ORDER BY `chip_change` DESC, `busted` ASC
0.0153 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14640'
ORDER BY `chip_change` DESC, `busted` ASC
0.0551 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14636'
ORDER BY `chip_change` DESC, `busted` ASC
0.0135 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0129 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14631'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14625'
ORDER BY `chip_change` DESC, `busted` ASC
0.0360 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14626'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14619'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14614'
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` = '14612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14610'
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` = '14608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14606'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14603'
ORDER BY `chip_change` DESC, `busted` ASC
0.0283 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14602'
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` = '14599'
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` = '14598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0073 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14596'
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` = '14597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14595'
ORDER BY `chip_change` DESC, `busted` ASC
0.0069 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14592'
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` = '14589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14588'
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` = '14587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0064 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0280 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0156 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0205 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0561 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14569'
ORDER BY `chip_change` DESC, `busted` ASC
0.0128 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14568'
ORDER BY `chip_change` DESC, `busted` ASC
0.0128 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0417 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0137 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0151 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14561'
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` = '14560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0715 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0062 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '336'
ORDER BY `busted` ASC, `current_chips` DESC
0.0128 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` = '336'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0131 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14729'
ORDER BY `chip_change` DESC, `busted` ASC
0.0133 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14674'
ORDER BY `chip_change` DESC, `busted` ASC
0.0797 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14673'
ORDER BY `chip_change` DESC, `busted` ASC
0.0246 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14672'
ORDER BY `chip_change` DESC, `busted` ASC
0.0430 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14668'
ORDER BY `chip_change` DESC, `busted` ASC
0.0135 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14667'
ORDER BY `chip_change` DESC, `busted` ASC
0.0132 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14666'
ORDER BY `chip_change` DESC, `busted` ASC
0.0129 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14665'
ORDER BY `chip_change` DESC, `busted` ASC
0.0128 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14662'
ORDER BY `chip_change` DESC, `busted` ASC
0.0981 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14660'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14651'
ORDER BY `chip_change` DESC, `busted` ASC
0.0408 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14657'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14654'
ORDER BY `chip_change` DESC, `busted` ASC
0.0178 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14652'
ORDER BY `chip_change` DESC, `busted` ASC
0.0180 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14650'
ORDER BY `chip_change` DESC, `busted` ASC
0.0138 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14649'
ORDER BY `chip_change` DESC, `busted` ASC
0.0375 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14645'
ORDER BY `chip_change` DESC, `busted` ASC
0.0202 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14643'
ORDER BY `chip_change` DESC, `busted` ASC
0.0131 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14641'
ORDER BY `chip_change` DESC, `busted` ASC
0.0173 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14640'
ORDER BY `chip_change` DESC, `busted` ASC
0.0202 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14636'
ORDER BY `chip_change` DESC, `busted` ASC
0.0600 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14635'
ORDER BY `chip_change` DESC, `busted` ASC
0.0063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14631'
ORDER BY `chip_change` DESC, `busted` ASC
0.0169 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14625'
ORDER BY `chip_change` DESC, `busted` ASC
0.0100 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14629'
ORDER BY `chip_change` DESC, `busted` ASC
0.0539 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14626'
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` = '14619'
ORDER BY `chip_change` DESC, `busted` ASC
0.0201 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14618'
ORDER BY `chip_change` DESC, `busted` ASC
0.0065 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14617'
ORDER BY `chip_change` DESC, `busted` ASC
0.0516 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14614'
ORDER BY `chip_change` DESC, `busted` ASC
0.0202 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14612'
ORDER BY `chip_change` DESC, `busted` ASC
0.0126 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14610'
ORDER BY `chip_change` DESC, `busted` ASC
0.0285 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14608'
ORDER BY `chip_change` DESC, `busted` ASC
0.0400 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14606'
ORDER BY `chip_change` DESC, `busted` ASC
0.0177 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14604'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14603'
ORDER BY `chip_change` DESC, `busted` ASC
0.0178 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14602'
ORDER BY `chip_change` DESC, `busted` ASC
0.0185 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14599'
ORDER BY `chip_change` DESC, `busted` ASC
0.0371 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14598'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14596'
ORDER BY `chip_change` DESC, `busted` ASC
0.0175 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14597'
ORDER BY `chip_change` DESC, `busted` ASC
0.0190 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14595'
ORDER BY `chip_change` DESC, `busted` ASC
0.1063 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14593'
ORDER BY `chip_change` DESC, `busted` ASC
0.0455 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14592'
ORDER BY `chip_change` DESC, `busted` ASC
0.0236 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14589'
ORDER BY `chip_change` DESC, `busted` ASC
0.0126 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14588'
ORDER BY `chip_change` DESC, `busted` ASC
0.0194 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14587'
ORDER BY `chip_change` DESC, `busted` ASC
0.0409 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14586'
ORDER BY `chip_change` DESC, `busted` ASC
0.0240 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14585'
ORDER BY `chip_change` DESC, `busted` ASC
0.0145 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14584'
ORDER BY `chip_change` DESC, `busted` ASC
0.0125 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14583'
ORDER BY `chip_change` DESC, `busted` ASC
0.0797 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14580'
ORDER BY `chip_change` DESC, `busted` ASC
0.0236 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14579'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14577'
ORDER BY `chip_change` DESC, `busted` ASC
0.0368 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14575'
ORDER BY `chip_change` DESC, `busted` ASC
0.0117 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14572'
ORDER BY `chip_change` DESC, `busted` ASC
0.0177 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14570'
ORDER BY `chip_change` DESC, `busted` ASC
0.0207 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14569'
ORDER BY `chip_change` DESC, `busted` ASC
0.1002 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14568'
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` = '14566'
ORDER BY `chip_change` DESC, `busted` ASC
0.0571 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14565'
ORDER BY `chip_change` DESC, `busted` ASC
0.0060 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14563'
ORDER BY `chip_change` DESC, `busted` ASC
0.0133 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14561'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14560'
ORDER BY `chip_change` DESC, `busted` ASC
0.0123 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '14558'
ORDER BY `chip_change` DESC, `busted` ASC
0.0573 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '336'
ORDER BY `busted` ASC, `current_chips` DESC
0.0005 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.
Linda Nguyen Multi-Tables the Queen Final and Wins Posted Wednesday 24th July, 2024 at 02:14(UTC+2) by Lina Olofsson
We started the final table of the WSOPC €250 Queens event here in Tallinn this afternoon as every tournament should be started. With a glass of champagne for each player served with fresh fruit on the side. After a presentation of our nine final table queens the ladies sat down to continue their way to lay their hands on that glorious golden ring everyone in this field wants to lay their hands on but only 12 lucky players will be fortunate enough to call their own.
This event, the queens only, had 90 entries in total combining a prize pool of €19,008 to play for and a first prize of €5,570 but all nine players were guaranteed at least €580 for their efforts making it into the final.
Going into the final table the only Swede in the field - Jenny Westerlund - was in the lead with more than double the amount of Lithuanian Marta Porter in second. Marta is the player who wrote herself into the history books as she won the first-ever Queens of Tallinn here last November.
But it wasn't the Swede nor the Lithuanian who would be crowned the champion after all. Both players fell short with four players left. First Marta was eliminated after not being able to catch any hands during the final. Later on, Jenny was out in third after losing a massive pot against Norwegian Linda Nguyen and then seeing the rest of her chips go to Finn Linda Lahdenpaa. But before we come to the Linda versus Linda heads-up let's have a look and see what happened from the beginning.
Starting the final with 18 minutes left on the clock in level 17 there were a few players who really needed some good cards before the blinds would eat the majority of their stack. One of these was Israeli Ruth Guber in the very first hand on the final table. She looked down on and pushed her stack over the line. Behind her, Linda Lahdenpaa woke up with and called while the rest of the queens got out of the way. A very dry board ran out where no players hit and ace high was good enough and sent Guper to the rail in ninth for a €580 payday.
Mirjam Jalak was in the same state as Guber with six big blinds to start the final with and a few hands later she tried her luck with the same queen jack which was called by our chip leader Jenny with which hit the turn on and Jalak was out in eighth place for €690.
With seven players remaining Jenny still held down the fort and had increased her lead even further and now had almost three times as much as her closest opponent which now was Linda Lahdenpaa. Anu Lilja who was on the other side of the leaderboard however needed to catch some cards with way less and only a few big blinds in her stack. She hung on for a few more hands but eventually, the always cheerful and smiling Anu decided her suited connectors were the ones who would terminate her fate. Anu's fellow countryman Linda Lahdenpaa was the one who called and showed which was bad news for Lilja who had been really lucky to find magic in the community cards before but this time they didn't help her and she was sent to the cashier to pick up €830 for seventh.
As six they would go on for quite a while and we would be able to experience a lot of action to unfold before we saw the next elimination. Jenny Westerlund would both lose and regain the chip lead during this period while other players would hang on to a thread to survive before the blinds would take all their chips.
Cristina Jugastru was down to only 15,000 on 10,000/20,000 and was all-in from the big blind. Marta Porter was the initial raiser and Cristina needed help with her to stay alive against . The board didn't do it and one of the two Cristinas was eliminated from the final. Jugastru cashed €1,020 for her sixth-place finish.
Kristiina Sultangarejev-Tuder was a few orbits later also put to the test when she pushed the remains of her stack into the middle with which was called by Westerlund with . The board ran out and just like that they were down to only four as Sultangarejev-Tuder walked to the rail. Her fifth-place finish paid €1,350.
With four players left the Queens of Tallinn Champion Marta Porter found herself being the short stack and needing some double up. She jammed her last 300,000 and was called by Linda Lahdenpaa and Porters needed help against . Two live cards didn't help as the board ran out and Porter was eliminated in fourth for €1,820.
With three players left Jenny Westerlund continued her aggressive way of playing poker and it paid off once again. Westerlund was the first player to reach a million in chips but the happiness didn't stay for that long as Linda Nguyen managed to double up through her and she'd later find herself the one at risk against Linda Lahdenpaa with against where the board ran out . For a very well played final table, Swedish Westerlund was rewarded €2,510.
The match heads-up would go on for a few levels and give plenty of action as the players were pretty deep and with a bit of advantage to Lahdenpaa. But that would change a few times before we got to the final hand of the tournament where Nguyen had taken on the lead and never looked back. The very last hand came when Linda Nguyen pushed all-in with and Linda Lahdenpaa called with . The flop looked like it would give Lahdenpaa a double up but the on the turn was brutal and the on the river didn't give her any of the outs she needed and we had a winner in the WSOPC Queens Event #5 and her name was Linda...Nguyen.
A huge congratulations to Norway for taking down another title here in Tallinn and to Linda Nguyen who started the final table with also playing day two in the €555 Event and ran between the live-streamed final and the grand ballroom to play her stack there. As soon as she was eliminated in the €555 she gave the others a hard match and it surely paid off! Apart from the coveted WSOPC golden ring Nguyen also picked up €5,580 in first prize alongside the crowd cheering her on in true Norwegian spirit.
WSOPC Event #5 - NLH Queens - Final table results:
1
Linda Nguyen
Norway
€5,570
2
Linda Lahpendaa
Finland
€3,630
3
Jenny Westerlund
Sweden
€2,510
4
Marta Porter
Lithuania
€1,820
5
Kristiina Sultangarejev-Tuder
Estonia
€1,350
6
Cristina Jugastru
Romania
€1,020
7
Anu Lilja
Finland
€830
8
Mirjam Jalak
Estonia
€690
9
Ruth Guper
Israel
€580
Linda Lahpendaa Eliminated in 2nd Place (€3,630) Posted Tuesday 23rd July, 2024 at 23:09(UTC+2) by Jason Glatzer
Level 27: 40,000/80,000 (80,000) Entries: 1/90
The heads-up battle of the Lindas is over in the two-day Event #5: €250 NLH Queens ladies-only ring event. Linda Nguyen came out on top to win the €5,570 top prize, the coveted WSOP Circuit Tallinn gold ring, and an invite to win a bracelet and riches for free in the 2025 WSOP Tournament of Champions $1 million guaranteed freeroll.
Both Lindas had the chip lead several times, and this heads-up battle could have gone either way. Congrats to both Lindas for a valiant run, and Lahpendaa still has reason to celebrate despite coming one player shy of winning the two-day Event #5: €250 Queens and instead collected the runner-up prize of €3,630.
Nguyen jammed the button and Lahpendaa lost a few smaller pots before calling off her stack of 370,000.
Linda Lahpendaa: Linda Nguyen:
Both players had clubs with Lahpendaa ahead, looking for a double. Lahpendaa increased her chances to double after her opponent didn't improve on the flop. However, Nguyen connected with her jack on the turn, leaving Lahpendaa with just three outs to survive.
The blank river paired the board for Nguyen to ship the bacon.
A massive congrats to Linda Nguyen on her epic win at the first-ever ladies ring event held in Tallinn.
This author will be putting down his pen. We hope you enjoyed the coverage, and stay tuned for the fantastic Lina Olofsson for the recap of the two-day Event #5: €250 NLH Queens at Olympic Park Casino.
Player
Chips
Progress
Linda Nguyen
2,300,000
700,000
Linda Lahdenpaa
0
0
23:04 (UTC+2)
Start of Level 27 Blinds: 40,000/80,000 Ante: 80,000
Two Short-Stack Doubles for Lahdenpaa Posted Tuesday 23rd July, 2024 at 23:04(UTC+2) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 2/90
Nguyen had won several pots in a row and had her opponent down to just two big blinds when she jammed the small blind. Lahpendaa was left with little choice but to call and was in amazing shape to double.
Linda Lahdenpaa: Linda Nguyen:
Lahdenpaa managed to hold here to double back to five big blinds after the ran out on the board.
The chips were back in the middle again the next hand with Lahdenpaa jamming for 300,000 from the button and Nguyen calling from the big blind.
Linda Lahdenpaa: Linda Nguyen:
Lahdenpaa appeared to be back in business after the allowed her to double again to 11 big blinds with ace-high.
Player
Chips
Progress
Linda Nguyen
1,600,000
100,000
Linda Lahdenpaa
660,000
150,000
Nguyen Back on Top With a Straight Posted Tuesday 23rd July, 2024 at 22:57(UTC+2) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 2/90
The lead changes continued during the Linda vs. Linda heads-up battle, with Linda Nguyen regaining the table captain status after the following hand:
Nguyen min-raised the button with before Lahdenpaa with defended her big blind.
It wasn't the worst flop for Nguyen who immediately improved to a straight on the flop. Lahdenpaa checked her middle-pair before she called a small bet of 75,000 by Nguyen.
Lahdenpaa checked the turn before Nguyen value-bet 170,000. Lahdenpaa called before doing the same facing a bet of 275,000 by Nguyen on the river. Nguyen was awarded the pot to regain the chip lead.
Player
Chips
Progress
Linda Nguyen
1,700,000
600,000
Linda Lahdenpaa
510,000
690,000
22:51 (UTC+2)
Start of Level 26 Blinds: 30,000/60,000 Ante: 60,000
Rockets for Lahdenpaa to Regain the Chip Lead Posted Tuesday 23rd July, 2024 at 22:50(UTC+2) by Jason Glatzer
Level 25: 25,000/50,000 (50,000) Entries: 2/90
Linda Nguyen jammed for more than the 550,000 Linda Lahpendaa had left in her stack. Lahdenpaa couldn't call quick enough with the best starting hand preflop in hold'em.
Linda Lahdenpaa: Linda Nguyen:
Aces were good for Lahdenpaa to regain the chip lead after the ran out on the board.
Player
Chips
Progress
Linda Lahdenpaa
1,200,000
250,000
Linda Nguyen
1,100,000
200,000
Rollercoaster Ride for the Lindas Posted Tuesday 23rd July, 2024 at 22:46(UTC+2) by Jason Glatzer
Level 25: 25,000/50,000 (50,000) Entries: 2/90
Linda Nguyen gained the heads-up chip lead for a second time in what is turning out to be a rollercoaster ride for both players.
Nguyen min-raised the button with and Linda Lahdenpaa with defended her big blind.
Nguyen bet her flush draw and gut-shot straight draw for 75,000 on the flop and Lahdenpaa called with her bottom pair.
Lahdenpaa checked, and Nguyen bet 125,000. Lahdenpaa folded the best hand and Nguyen regained the lead.
Player
Chips
Progress
Linda Nguyen
1,300,000
300,000
Linda Lahdenpaa
950,000
350,000
Lahdenpaa Back on Top Posted Tuesday 23rd July, 2024 at 22:43(UTC+2) by Jason Glatzer
Level 25: 25,000/50,000 (50,000) Entries: 2/90
Linda Lahdenpaa just got the lead back. She min-raised the button with , and Nguyen with defended her big blind.
Both players snagged a piece of the flop. Nguyen check-called a bet of 100,000 with an inferior pair.
The blank turn followed, and once again, Nguyen check-called a bet of 200,000. The barrel was unloaded with another bullet by Lahdenpaa after Nguyen checked the river with a 400,000 chip jam. Nguyen went into the tank before she got away from her hand to cut off the damage.
Player
Chips
Progress
Linda Lahdenpaa
1,300,000
400,000
Linda Nguyen
1,000,000
400,000
Nguyen takes the Lead Posted Tuesday 23rd July, 2024 at 22:37(UTC+2) by Jason Glatzer
Level 25: 25,000/50,000 (50,000) Entries: 2/90
Linda Lahdenpaa opened for 100,000 from the button with before Linda Nguyen with called from the big blind.
Neither player hit a piece of the flop. Nguyen checked. Lahdenpaa bet 75,000 and Nguyen called with her king-high.
The turn improved Nguyen to the top pair. She checked before Lahdenpaa, who now had a flush draw, fired out for 225,000.
Nguyen jammed for 725,000 and denied her opponent's equity in the hand while taking the chip lead after Lahdenpaa folded.
Player
Chips
Progress
Linda Nguyen
1,400,000
550,000
Linda Lahdenpaa
900,000
500,000
Whats Your Name? Posted Tuesday 23rd July, 2024 at 22:33(UTC+2) by Lina Olofsson
You have a hard time keeping up with who was eliminated and not? Well as a reporter where you often refer to players by their first name when talking about them in the media room it can lead to a fatal error if you accidentally eliminate someone from the tournament who's still playing thinking it was another one with the same name. Most reporters have "been there, done that" as far as it comes to mixing up players in larger fields but normally as the tournament progresses you realize these errors instantly and find a way to separate the players by using their surnames or nicknames.
When we were down to the last ten players in the field we've had some problems with misunderstandings. When they were playing for the final table bubble late yesterday we had four Kristinas in the field and two Lindas.
Luckily for us reporters one of the Kristina's didn't use her first name but her second which is Anu and that made it a bit easier. After Kristina number two was eliminated on the final table bubble we were down to "only" two when it was time for today's final. But the name Kristina wasn't the only common amongst the final players. So was Linda and down to the last two in the field of 90 both players listened to that name which caused a lot of confusion when referring to hands that just happened. "So Linda raised? No Linda was the one who called."
One thing we knew for sure with these two queens competing for the victory and that luxurious WSOPC ring was that the inscription would be Linda no matter what.
22:30 (UTC+2)
Start of Level 25 Blinds: 25,000/50,000 Ante: 50,000
Jenny Westerlund Eliminated in 3rd Place (€2,510) Posted Tuesday 23rd July, 2024 at 22:26(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 2/90
Linda Lahpendaa opened for a min-raise from the button. Jenny Westerlund three-bet jammed for 355,000 from the small blind and Lahdenpaa called.
Jenny Westerlund: Linda Lahdenpaa:
Westerlund held the chip lead a good portion of the final table and also held it recently. But she ran out of gas and had to settle for a third-place podium prize of €2,510 after she was unable to get ahead of ace-queen on the runout.
Meanwhile, get ready for a Linda vs. Linda heads-up battle with Finland's Linda Lahdenpaa holding a nearly 2:1 chip advantage over Norwegian Linda Nguyen.
Players went on a 15-minute break after the hand. Nguyen turned down any deal talk as she said she is playing for the ring and the chance to head to the $1 million guaranteed WSOP Tournament of Champions freeroll bracelet event next summer in Las Vegas.
Player
Chips
Progress
Linda Lahdenpaa
1,400,000
525,000
Linda Nguyen
850,000
90,000
Jenny Westerlund
0
0
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 22:21(UTC+2) by Jason Glatzer
Player
Chips
Progress
Linda Nguyen
940,000
50,000
Linda Lahdenpaa
875,000
170,000
Jenny Westerlund
435,000
220,000
Lahdenpaa Narrows the Gap With Fours Posted Tuesday 23rd July, 2024 at 22:19(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 3/90
Linda Nguyen opened for 95,000 from the small blind with and was called by Linda Lahdenpaa with from her big blind.
Nguyen led out for 80,000 on the flop and Nguyen called. The followed on the turn and Nguyen checked. Nguyen checked. Lahdenpaa jammed for 315,000 and chipped up after Nguyen folded.
Player
Chips
Progress
Linda Nguyen
890,000
210,000
Linda Lahdenpaa
705,000
175,000
Nguyen Takes the Lead Posted Tuesday 23rd July, 2024 at 22:15(UTC+2) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 3/90
Jenny Westerlund opened with to 100,000 from the small blind and was called by Linda Nguyen with from the big blind.
Both players checked the flop before Nguyen paired up her queen on the turn. Westerlund checked. Nguyen bet 80,000 and Westerlund called with her ace-high.
The river completed the board. Westerlund checked and Nguyen bet 175,000. Westerlund covered her cards with her card protector and went into the tank. Eventually, Westerlund made the hero-call only to find out the bad news.
Meanwhile, Nguyen took the chip lead as the latest chip millionaire in the €250 Queens.
Player
Chips
Progress
Linda Nguyen
1,100,000
210,000
Jenny Westerlund
655,000
345,000
22:03 (UTC+2)
Start of Level 24 Blinds: 20,000/40,000 Ante: 40,000
Lahdenpaa Doubles Her Short Stack Posted Tuesday 23rd July, 2024 at 22:02(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
Linda Lahdenpaa witnessed her stack dwindle down to six big blinds. She seemingly found a good spot to get them to get back into the thick of things, even if it meant delivering a bad beat to Jenny Westerlund.
Lahdenpaa jammed for 245,000 from the small blind and Westerlund was left with little choice than to call.
Linda Lahdenpaa: Jenny Westerlund:
It was looking like Lahdenpaa would head to the showers in third place. Especially after she got nowhere on the flop. However, the spiked the turn to push Lahdenpaa ahead with a pair, and she doubled through Westerlund after the blank river had completed the board.
Player
Chips
Progress
Jenny Westerlund
1,000,000
80,000
Linda Lahdenpaa
530,000
15,000
Westerlund Regains Lead Posted Tuesday 23rd July, 2024 at 21:53(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
Linda Lahdenpaa min-raised the button with . Jenny Westerlund three-bet to 165,000. Lahdenpaa folded, and this was good enough to take the chip lead.
Player
Chips
Progress
Jenny Westerlund
920,000
135,000
Linda Lahdenpaa
515,000
60,000
Nguyen Heads to Broadway to Snag Chip Lead Posted Tuesday 23rd July, 2024 at 21:48(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
Linda Nguyen is no longer multi-tabling as she was eliminated in Event #5: €555 NLH ring event in 71st place for €1,100. However, she is alive and well for a ring in the ladies-only affair as she just took the chip lead as follows:
Nguyen opened for 70,000 from the button with and was called by Linda Lahdenpaa from the small blind with and Jenny Westerlund with from the big blind.
The flop was checked around and the same was the case on the turn.
The river improved Nguyen to Broadway. Both Lahdenpaa and Westerlund checked before Nguyen bet 150,000. Lahdenpaa called, but Nguyen managed to get some value from Westerlund, who called after pairing up with her queen on the river.
Player
Chips
Progress
Linda Nguyen
890,000
470,000
Jenny Westerlund
785,000
315,000
Linda Lahdenpaa
575,000
130,000
Westerlund Regains the Chip Lead Posted Tuesday 23rd July, 2024 at 21:37(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
Linda Lahdenpaa with opened for 65,000 from the button. Jenny Westerlund with three-bet to 180,000 from the big blind. Lahdenpaa called before the rolled out on the flop.
Lahdenpaa check-raised her middle pair from 100,000 to 250,000. Westerlund jammed for 500,000 with her better pair in her pocket. Despite getting decent odds on the call, Lahdenpaa opted to save her chips for a better spot and folded.
Meanwhile, Westerlund was back on top with the chip lead and was a chip millionaire for the first time in the €250 Queens.
Player
Chips
Progress
Jenny Westerlund
1,100,000
390,000
Linda Lahdenpaa
705,000
395,000
Lahdenpaa Becomes First Chip Millionaire Posted Tuesday 23rd July, 2024 at 21:30(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
Jenny Westerlund opened with for 65,000 from the button. Linda Lahdenpaa three-bet with to 180,000, and Westerlund called.
Neither player got any love from the flop. Lahdenpaa led out for 125,000 and was the event's first chip millionaire after Westerlund folded.
Player
Chips
Progress
Linda Lahdenpaa
1,100,000
145,000
Jenny Westerlund
710,000
180,000
Westerlund Making Moves Again Posted Tuesday 23rd July, 2024 at 21:26(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
Jenny Westerlund opened with for 65,000 from the small blind. Linda Nguyen defended her big blind with and had an open-ended straight draw on the flop.
Westerlund check-called a bet of 70,000 before check-calling again after the paired the board on the turn for 110,000.
The river put trips on the board. Westerlund unleashed her stack of 370,000, and Nguyen could only fold.
Player
Chips
Progress
Jenny Westerlund
890,000
290,000
Linda Nguyen
420,000
215,000
"They Are All Worthy Winners" Posted Tuesday 23rd July, 2024 at 21:15(UTC+2) by Lina Olofsson
Last November the very same people behind the WSOPC success here in Tallinn threw the first-ever women's only poker festival, Queens of Tallinn. Lithuanian player Marta Porter was the one winning the main event for €6,167.
When the final table in the €250 WSOPC Queens event Marta was still in and was second in chips after a fantastic run yesterday. Several of her opponents from the first day of the event described her as a really hard nut to crack and someone who kept the pressure on the table all the time.
Marta looked like she'd be able to defend her position as the queen of the throne for a long while here at the final table today but in the end, the cards didn't come her way and she finished in fourth place after more than five hours of play.
"I'm really happy with my finish. The three players still in are really good and all of them are worthy winners in this event. That was a nice start!", Marta smiled as we met her on the way down the stairs as she just received her paycheck of €1,820.
This is not the only event we will see Marta in this week as she plans to stay the entire festival here during the WSOPC in Tallinn.
Marta Porter Eliminated in 4th Place (€1,820) Posted Tuesday 23rd July, 2024 at 21:13(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 3/90
It was a heck of a ride for the 2023 Queens of Tallinn Main Event champion from Lithuania Marta Porter. Unfortunately, she fell short of adding a WSOP Circuit Tallinn ring to her resume, but will still go home with the fourth-place prize of €1,820 after the following hand:
Porter jammed for 310,000 from the button and was called by Linda Lahdenpaa from the big blind.
Marta Porter: Linda Lahdenpaa:
Porter had two live cards but didn't connect with the runout to end her amazing run.
Meanwhile, Lahdenpaa has regained the chip lead at the final table for a third time.
Player
Chips
Progress
Linda Lahdenpaa
955,000
325,000
Marta Porter
0
0
Kristiina Sultangarejev-Tuder Eliminated in 5th Place (€1,350) Posted Tuesday 23rd July, 2024 at 21:05(UTC+2) by Jason Glatzer
Level 23: 15,000/30,000 (30,000) Entries: 4/90
Kristiina Sultangarejev-Tuder jammed her three-big blind stack of 90,000 from the cutoff and was called Jenny Westerlund from the button.
Kristiina Sultangarejev-Tuder: Jenny Westerlund:
Westerlund's hand held on the board to eliminate Sultangarejev-Tuder in fifth place for €1,350.
Player
Chips
Progress
Jenny Westerlund
600,000
195,000
Kristiina Sultangarejev-Tuder
0
0
Small Chip Lead for Nguyen Posted Tuesday 23rd July, 2024 at 20:53(UTC+2) by Jason Glatzer
No big pots occured, but the blinds went through Linda Lahdenpaa to give the multi-tabling other Linda in Linda Nguyen the chip lead.
Player
Chips
Progress
Linda Nguyen
635,000
15,000
Linda Lahdenpaa
630,000
75,000
Marta Porter
475,000
0
Jenny Westerlund
405,000
30,000
Kristiina Sultangarejev-Tuder
105,000
120,000
20:48 (UTC+2)
Start of Level 23 Blinds: 15,000/30,000 Ante: 30,000
Nguyen Chips Up Posted Tuesday 23rd July, 2024 at 20:48(UTC+2) by Jason Glatzer
Level 22: 10,000/25,000 (25,000) Entries: 5/90
Linda Lahdenpaa opened for 50,000 from under the gun with and was called by Jenny Westerlund from the button with and Linda Nguyen with from the big blind.
Nguyen checked after improving to two pair on the flop. Lahdenpaa bet her dominated top pair for 80,000. Westerlund quickly folded, and Nguyen called.
The action slowed with both players checking after the paired the board on the turn, but that all changed after the river. Nguyen jammed for 305,000, and Lahdenpaa went into the tank with a difficult decision to make.
Lahdenpaa eventually made the hard but correct decision to fold and save a bit of her stack. Meanwhile, Nguyen seems to win every hand she plays in, as was the case here to catapult her stack despite missing out on a double.
Player
Chips
Progress
Linda Lahdenpaa
705,000
180,000
Linda Nguyen
650,000
360,000
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 20:33(UTC+2) by Jason Glatzer
Player
Chips
Progress
Linda Lahdenpaa
885,000
60,000
Marta Porter
475,000
0
Jenny Westerlund
375,000
0
Linda Nguyen
290,000
60,000
Kristiina Sultangarejev-Tuder
225,000
0
Cristina Jugastru Eliminated in 6th Place (€1,020) Posted Tuesday 23rd July, 2024 at 20:32(UTC+2) by Jason Glatzer
Level 22: 10,000/25,000 (25,000) Entries: 5/90
Marta Porter opened for 50,000 from under the gun. Cristina Jugastru called off for one more chip from her stack of 15,000 from the small blind and had two live cards for some hope to potentially start a Cinderella story.
Cristina Jugastru: Marta Porter:
It was looking grim for Jugastru as just her queen was live after Porter paired her seven on the flop. Neither the turn nor the river assisted Jugastru and she ended her impressive run in sixth place for €1,020.
Player
Chips
Progress
Marta Porter
475,000
65,000
Cristina Jugastru
0
0
Kristiina Vs. Cristina Posted Tuesday 23rd July, 2024 at 20:25(UTC+2) by Jason Glatzer
Level 22: 10,000/25,000 (25,000) Entries: 6/90
Kristiina Sultangarejev-Tuder jammed for 100,000 from the small blind. Cristina Jugastru called off most of her stack, and this hand would likely determine the tournament life of both players.
Kristiina Sultangarejev-Tuder: Cristina Jugastru:
Sultangarejev-Tuder just had her stack crushed by Porter after losing a coin flip with jacks. But she had some breathing room while leaving Jugastru with less than one big blind after the board kept her ahead the entire way.
Player
Chips
Progress
Kristiina Sultangarejev-Tuder
225,000
135,000
Cristina Jugastru
15,000
125,000
Porter Doubles With Big Slick to Decimate Sultangarejev-Tuder's Stack Posted Tuesday 23rd July, 2024 at 20:20(UTC+2) by Jason Glatzer
Level 22: 10,000/25,000 (25,000) Entries: 6/90
Kristiina Sultangarejev-Tuder jammed for 260,000 from the hijack. Marta Porter called off her stack of 170,000 from the small blind and was flipping for her tournament life.
Marta Porter: Kristiina Sultangarejev-Tuder:
It wasn't looking great for the 2023 Queens of Tallinn Main Event champion Porter after getting no love on the flop. The was a golden card for Porter pushing her ahead of Sultangarejev-Tuder and just needed to fade two outs on the river.
No drama bomb came on the river and Porter doubled her stack instead of heading to the cashier.
Player
Chips
Progress
Marta Porter
410,000
180,000
Kristiina Sultangarejev-Tuder
100,000
110,000
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 20:14(UTC+2) by Jason Glatzer
Player
Chips
Progress
Linda Lahdenpaa
945,000
3,000
Jenny Westerlund
375,000
55,000
Linda Nguyen
350,000
43,000
Marta Porter
230,000
74,000
Kristiina Sultangarejev-Tuder
210,000
98,000
Cristina Jugastru
140,000
20,000
20:11 (UTC+2)
Start of Level 22 Blinds: 10,000/25,000 Ante: 25,000
Party Break Posted Tuesday 23rd July, 2024 at 20:08(UTC+2) by Jason Glatzer
Players are on a 35-minute break so they can go downstairs to the casino floor and enjoy the Meet & Greet party along with the house band Good Beat Jackpot.
Meanwhile, Linda Nguyen is still multi-tabling the €555 No-Limit Hold'em and can get back to playing a blind level over in the other room.
Lahdenpaa Doubles Through Westerlund Into the Chip Lead Posted Tuesday 23rd July, 2024 at 20:05(UTC+2) by Jason Glatzer
Level 21: 10,000/20,000 (20,000) Entries: 6/90
Jenny Westerlund opened with for 45,000 from the cutoff. Linda Lahdenpaa three-bet to 150,000 with from the big blind, and Westerlund called.
Both players were likely pleased to see the flop, with Westerlund holding a flush draw and Lahdenpaa nailing the goods with the top set.
Lahdenpaa bet 100,000. Westerlund jammed more than covering the 306,000 Lahdenpaa had in her stack, and Lahdenpaa called.
Lahdenpaa could have hit the rail but instead doubled into the chip lead for a second time after Westerlund bricked the turn and river.
Player
Chips
Progress
Linda Lahdenpaa
942,000
416,000
Jenny Westerlund
320,000
456,000
Porter Doubles Short Stack With Deuces Posted Tuesday 23rd July, 2024 at 19:54(UTC+2) by Jason Glatzer
Level 21: 10,000/20,000 (20,000) Entries: 6/90
Jenny Westerlund opened the button for 45,000 before Marta Porter jammed her short stack of 58,000 from the small blind. Westerlund called the rest of the crumbs and Porter was flipping for her tournament life just before the break for the Meet and Greet party hosting by the house band Good Beat Jackpot.
Marta Porter: Jenny Westerlund:
Deuces held on the clean runout for Porter to survive and gain some breathing room.
Player
Chips
Progress
Jenny Westerlund
776,000
58,000
Marta Porter
156,000
98,000
Westerlund Regains Lead After Doubling Through Porter Posted Tuesday 23rd July, 2024 at 19:48(UTC+2) by Jason Glatzer
Level 21: 10,000/20,000 (20,000) Entries: 6/90
Jenny Westerlund opened for 45,000 from the small blind with and was called by Marta Porter with from the big blind.
Westerlund pulled ahead on the flip after improving to the top pair on the flop. Porter jammed for 380,000, and Westerlund needed to fade just two outs to double into the chip lead, or she'd otherwise fade into the stardust in sixth place.
The blank river completed the board for Westerlund to double through Porter back into the commanding chip lead she began the final table with.
Meanwhile, Porter was down to just three big blinds after her mistimed aggression.
Player
Chips
Progress
Jenny Westerlund
834,000
396,000
Marta Porter
58,000
477,000
Sultangarejev-Tuder Doubles With Tens Posted Tuesday 23rd July, 2024 at 19:41(UTC+2) by Jason Glatzer
Level 21: 10,000/20,000 (20,000) Entries: 6/90
Kristiina Sultangarejev-Tuder jammed for 139,000 from under the gun and was called by Linda Lahdenpaa from the big blind.
Kristiina Sultangarejev-Tuder: Linda Lahdenpaa:
Ace-trey got nowhere on the board for Sultangarejev-Tuder to double her stack.
Player
Chips
Progress
Linda Lahdenpaa
526,000
14,000
Kristiina Sultangarejev-Tuder
308,000
129,000
19:40 (UTC+2)
Start of Level 21 Blinds: 10,000/20,000 Ante: 20,000
Big Blind Flush for Porter; Lahdenpaa Takes Lead by Default Posted Tuesday 23rd July, 2024 at 19:38(UTC+2) by Jason Glatzer
Level 20: 10,000/15,000 (15,000) Entries: 6/90
Jenny Westerlund opened for 35,000 from the small blind with . Marta Porter looked down at her from the big blind before calling to see the flop.
Westerlund flopped a straight and continued for 17,000. But Porter was going nowhere with her gutshot straight draw and flush draw, and called.
Porter nailed her flush on the turn. Westerlund bet 56,000 and Porter called. Westerlund jammed her flush. Porter wasted no time in calling with her flush to double her stack.
Meanwhile, this was the first chip lead at the final table with Linda Lahdenpaa taking the lead by default with Porter not too far behind.
Player
Chips
Progress
Marta Porter
535,000
220,000
Jenny Westerlund
438,000
305,000
Nguyen Can Head Back to Multi-Tabling After Doubling Through Westerlund Posted Tuesday 23rd July, 2024 at 19:30(UTC+2) by Jason Glatzer
Level 20: 10,000/15,000 (15,000) Entries: 6/90
Cristina Jugastru limped with from under the gun before Jenny Westerlund three-bet to 40,000 with .
Linda Nguyen, still alive in the €555 NLH ring event deep on Day 2, was back in her seat at the feature table when she four-bet jammed for 169,000 with from the button.
With her big stack, Jugastru got away cheaply, while Westerlund found a call with Nguyen at risk on a coin flip.
It wasn't looking great for Nguyen on the flop but that all changed after she paired up her jack on the turn. The river completed the board for Nguyen to double into a healthy stack and can head back safely for an orbit or two in the €555 NLH if she so chooses.
Player
Chips
Progress
Jenny Westerlund
743,000
124,000
Linda Nguyen
393,000
184,000
Cristina Jugastru
160,000
20,000
Jacks Good for Sultangarejev-Tuder Posted Tuesday 23rd July, 2024 at 19:25(UTC+2) by Jason Glatzer
Level 20: 10,000/15,000 (15,000) Entries: 6/90
Kristiina Sultangarejev-Tuder jammed her short stack of 77,000 from under the gun and was called by Linda Lahdenpaa from the big blind.
Kristiina Sultangarejev-Tuder: Linda Lahdenpaa:
Sultangarejev-Tuder pipped her opponent's pair preflop and held onto double her stack after Lahdenpaa was unable to pull ahead on the board.
Player
Chips
Progress
Linda Lahdenpaa
540,000
52,000
Kristiina Sultangarejev-Tuder
179,000
92,000
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 19:20(UTC+2) by Jason Glatzer
Player
Chips
Progress
Jenny Westerlund
867,000
62,000
Linda Lahdenpaa
592,000
10,000
Marta Porter
315,000
0
Linda Nguyen
209,000
34,000
Cristina Jugastru
180,000
15,000
Kristiina Sultangarejev-Tuder
87,000
60,000
Thin Value for Lahdenpaa Posted Tuesday 23rd July, 2024 at 19:18(UTC+2) by Jason Glatzer
Level 20: 10,000/15,000 (15,000) Entries: 6/90
Marta Porter min-raised the button with and was called by Linda Lahdenpaa with from the big blind.
Lahdenpaa check-called a min-bet by Porter after both players flopped middle pair with Lahdenpaa holding the better kicker on the flop. The kicker issues for Porter temporarily didn't matter after the paired the board on the turn.
Both players checked, and Lahdenpaa was again back ahead after the river double-paired the board. Lahdenpaa fired 70,000, and Porter went into the tank before she called, only to get the bad news that her hand wasn't strong enough.
Player
Chips
Progress
Linda Lahdenpaa
602,000
125,000
Marta Porter
315,000
28,000
19:13 (UTC+2)
Start of Level 20 Blinds: 10,000/15,000 Ante: 15,000
Well-Timed Four-Bet for Porter Posted Tuesday 23rd July, 2024 at 19:08(UTC+2) by Jason Glatzer
Level 19: 6,000/12,000 (12,000) Entries: 6/90
Cristina Jugastru opened for a min-raise from the cutoff with . Jenny Westerlund three-bet to 62,000 from the button for before Marta Porter with from the small blind came in for a four-bet for nearly half her stack to 156,000.
Jugastru and Westerlund both folded slightly better hands, and Porter added some free chips to her stack.
Westerlund Near 1 Million Posted Tuesday 23rd July, 2024 at 19:07(UTC+2) by Jason Glatzer
Level 19: 6,000/12,000 (12,000) Entries: 6/90
Cristina Jugastru opened for 25,000 from the button with . Jenny Westerlund three-bet to 67,000 with from the small blind and Jugastru called.
Westerlund improved to top pair on the flop and she continued for 47,000. Jugastru called in position and the paired the board on the turn. Westerlund jammed for more than the 165,000 Jugastru had in her stack and was near 1 million in chips after Jugastru folded.
Player
Chips
Progress
Jenny Westerlund
929,000
95,000
Cristina Jugastru
165,000
77,000
Two Pair for Porter Posted Tuesday 23rd July, 2024 at 19:06(UTC+2) by Jason Glatzer
Level 19: 6,000/12,000 (12,000) Entries: 6/90
Marta Porter opened for a min-raise from the cutoff with and was called by Cristina Jugastru with from the big blind.
Both players found some love on the flop with neither player with clubs in their hand. Jugastru checked her strong ace. Porter fired out for 12,000 with her two pair and Jugastru raised to 48,000. Porter opted to call and the followed on the turn to add potential straight possibilities neither player had to the non-existing flush draw for both players.
Both players checked before Jugastru bet small for 16,000 on the river. Porter opted to call with her two pair on the scary board to scoop up the pot.
Player
Chips
Progress
Marta Porter
343,000
118,000
Cristina Jugastru
242,000
82,000
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 19:05(UTC+2) by Jason Glatzer
Player
Chips
Progress
Jenny Westerlund
834,000
0
Linda Lahdenpaa
477,000
5,000
Cristina Jugastru
324,000
0
Linda Nguyen
243,000
20,000
Marta Porter
225,000
0
Kristiina Sultangarejev-Tuder
147,000
50,000
Westerlund More Aggressive Than Porter Posted Tuesday 23rd July, 2024 at 19:03(UTC+2) by Jason Glatzer
Level 19: 6,000/12,000 (12,000) Entries: 6/90
Jenny Westerlund opened for 30,000 from the small blind with , and Marta Porter with defended her big blind.
Both players bricked the flop. Westerlund was still ahead and also had some backdoors and bet 16,000. Porter raised to 42,000 with air. Westerlund was undeterred and three-bet to 135,000 and won the pot after Porter folded.
Player
Chips
Progress
Jenny Westerlund
834,000
89,000
Marta Porter
225,000
59,000
19:01 (UTC+2)
Start of Level 19 Blinds: 6,000/12,000 Ante: 12,000
#FinalTableFreeroll Posted Tuesday 23rd July, 2024 at 19:00(UTC+2) by Matthew Summers
Trips for Lahdenpaa; Great Fold by Porter Posted Tuesday 23rd July, 2024 at 18:31(UTC+2) by Jason Glatzer
Level 18: 5,000/10,000 (10,000) Entries: 6/90
Jenny Westerlund opened for 26,000 with from the cutoff and was called by Marta Porter from the button with and Linda Lahdenpaa (pictured below) with from the big blind.
Lahdenpaa checked her top pair on the flop before Westerlund continued with middle pair for 26,000. Porter and Lahdenpaa called before the paired the board on the turn.
The action checked around, and Lahdenpaa fired out for 118,000 on the river. Westerlund paused for a few moments before she folded, leaving Porter with a very tough decision regarding nearly half her stack. Porter tanked for a few minutes before saving herself some chips with a fold.
Player
Chips
Progress
Jenny Westerlund
745,000
83,000
Linda Lahdenpaa
482,000
98,000
Marta Porter
284,000
10,000
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 17:35(UTC+2) by Jason Glatzer
Player
Chips
Progress
Jenny Westerlund
828,000
0
Linda Lahdenpaa
384,000
5,000
Cristina Jugastru
324,000
80,000
Marta Porter
294,000
0
Linda Nguyen
223,000
0
Kristiina Sultangarejev-Tuder
197,000
106,000
Rockets for Nguyen Posted Tuesday 23rd July, 2024 at 17:33(UTC+2) by Jason Glatzer
Level 18: 5,000/10,000 (10,000) Entries: 6/90
Linda Nguyen (pictured below) still has a stack with the money bubble coming closer and closer in the three-day Event #3: €555 No-Limit Hold'em. She will still have to multi-table for a bit but at least gained some breathing room on the €250 Queens final table after the following hand.
Table captain Jenny Westerlund opened for 22,000 from early position with . Porter flatted with from the hijack before Nguyen woke up with and squeezed for her stack of 88,000. Westerlund folded, but Porter was unable to get out of the way with such a premium hand.
The rabbit didn't come out of the hat for Porter on the dry board for Nguyen to double through Porter.
Player
Chips
Progress
Jenny Westerlund
828,000
4,000
Marta Porter
294,000
92,000
Linda Nguyen
223,000
115,000
Anu Lilja Eliminated in 7th Place (€830) Posted Tuesday 23rd July, 2024 at 17:25(UTC+2) by Jason Glatzer
Level 18: 5,000/10,000 (10,000) Entries: 6/90
Anu Lilja found herself down to just three big blinds when she jammed for 29,000 from the small blind. Fellow Finn Linda Lahdenpaa called from the big blind, and Lilja needed a bit of help after the cards were tabled.
Anu Lilja: Linda Lahdenpaa:
Lilja stood up as the rolled out on the board before heading to the cashier to collect her €830 seventh-place prize.
"Good luck, ladies," Lilja said with a smile.
Player
Chips
Progress
Linda Lahdenpaa
389,000
29,000
Anu Lilja
0
0
17:19 (UTC+2)
Start of Level 18 Blinds: 5,000/10,000 Ante: 10,000
Porter Bluffs With Jack-Four Posted Tuesday 23rd July, 2024 at 17:18(UTC+2) by Jason Glatzer
Level 17: 4,000/8,000 (8,000) Entries: 7/90
Cristina Jugastru opened the button with . 2023 Queens of Tallinn winner Marta Porter (pictured below) looked down at . With her opponent covered, she fired out a three-bet to 68,000, forcing Jugastru to fold the best hand.
Player
Chips
Progress
Marta Porter
386,000
69,000
Cristina Jugastru
244,000
37,000
Updated Chip Counts Posted Tuesday 23rd July, 2024 at 17:13(UTC+2) by Jason Glatzer
Player
Chips
Progress
Jenny Westerlund
832,000
0
Linda Lahdenpaa
360,000
16,000
Marta Porter
317,000
4,000
Kristiina Sultangarejev-Tuder
303,000
0
Cristina Jugastru
281,000
0
Linda Nguyen
108,000
21,000
Anu Lilja
49,000
16,000
Mirjam Jalak Eliminated in 8th Place (€690) Posted Tuesday 23rd July, 2024 at 17:10(UTC+2) by Jason Glatzer
Level 17: 4,000/8,000 (8,000) Entries: 7/90
In the first two hands, two players hit the rail. During the second hand, Jenny Westerlund extended her already impressive chip lead by earning the stack of Estonia's Mirjam Jalak.
Westerlund opened the cutoff for 17,000. Jalak, who came in with the shortest stack of the day, jammed for 34,000 from the big blind. Westerlund snap-called and once again the short-stack tabled queen-jack for a second straight hand.
Mirjam Jalak: Jenny Westerlund:
The outcome was the same for Jalak as it was for Ruth Guper during the previous hand with queen-jack after bricking the board to exit in eighth place for €690.
Player
Chips
Progress
Jenny Westerlund
832,000
46,000
Mirjam Jalak
0
0
Ruth Guber Eliminated in 9th Place (€580) Posted Tuesday 23rd July, 2024 at 16:59(UTC+2) by Jason Glatzer
Level 17: 4,000/8,000 (8,000) Entries: 8/90
Ruth Guper jammed on the very first hand at the final table for 58,000. Finland's Linda Lahdenpaa three-bet nearly half her stack to 120,000 from one seat over and the rest of the table folded.
Ruth Guper: Linda Lahdenpaa:
Guper had two live cards, but could not connect on the runout to exit in ninth place for €580.
Player
Chips
Progress
Linda Lahdenpaa
344,000
78,000
Ruth Guper
0
0
Final Day Begins Posted Tuesday 23rd July, 2024 at 16:44(UTC+2) by Jason Glatzer
Welcome to the second and final day of the two-day Event #2: €250 NLH Queens Ladies Only ring event.
Players will battle the final 18 minutes of 4,000/8,000 (8,000) before blinds increase every 30 minutes until a winner is crowned. The nine players have each locked up €580 with tonight's winner going home with a €5,570 top prize, a coveted WSOP Circuit gold ring, and an invite for a chance to win a bracelet and tons more cash in the 2025 WSOP Tournament of Champions $1 million freeroll in Las Vegas.
Sweden's Jenny Westerlund leads the way with 786,000 in chips for a massive chip lead on the field. Lithuania's 2023 Queens of Tallinn Main Event champion Marta Porter (321,000), Estonia's Kristiina Sultangarejev-Tuder (303,000), Romania's Cristina Jugastru (281,000), and Finland's Linda Lahdenpaa (266,000) are all tightly packed together.
Meanwhile, Norway's Linda Nguyen (129,000) has a short stack but is also multi-tabling Day 2 before the bubble in the three-day Event #3: €555 No-Limit Hold'em, which you can also follow the coverage of by navigating to that event within our blog.
Finland's Anu Lilja (65,000) and Israel's Ruth Guper (58,000) bring in the short stacks and will be hoping to catapult their stacks while watching others head to the rail.
While you can follow along all the big action in the blog, you will also be able to witness the action unfold directly on your screens with George Sandford hosting the kickoff of the live stream at OlyBet.tv along side guests Daiva Byrne and Maureen Bloechlinger.
Best of luck to all of the ladies in their quest to become the first-ever Queens ring winner at Olympic Park Casino.
16:16 (UTC+2)
Day 2 of Olympic Park Casino Started Level: 17 Blinds: 4,000/8,000 Ante: 8,000
Your search results are valid for .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.