0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0107 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-18'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event8/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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.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.0036 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = '2024_wsop_tallinn_event8'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '144'
0.0283 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0062 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '361'
AND `published` = 1
0.0282 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '367'
AND `published` = 1
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '144'
AND `name` = '2'
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '367'
ORDER BY `busted` ASC, `current_chips` DESC
0.0064 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` = '367'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '15911'
ORDER BY `chip_change` DESC, `busted` ASC
0.0297 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15881'
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` = '15850'
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` = '15845'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15832'
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` = '15821'
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` = '15820'
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` = '15818'
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` = '15813'
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` = '15803'
ORDER BY `chip_change` DESC, `busted` ASC
0.0076 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15800'
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` = '15792'
ORDER BY `chip_change` DESC, `busted` ASC
0.0287 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15791'
ORDER BY `chip_change` DESC, `busted` ASC
0.0070 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15787'
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` = '15785'
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` = '15782'
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` = '15778'
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` = '15775'
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` = '15769'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15767'
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` = '15760'
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` = '15748'
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` = '15749'
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` = '15747'
ORDER BY `chip_change` DESC, `busted` ASC
0.0277 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15743'
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` = '15741'
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` = '15738'
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` = '15734'
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` = '15733'
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` = '15724'
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` = '15722'
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` = '15709'
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` = '15706'
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` = '15701'
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` = '15696'
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` = '15694'
ORDER BY `chip_change` DESC, `busted` ASC
0.0271 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15685'
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` = '15677'
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` = '15676'
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` = '15669'
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` = '15667'
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` = '15665'
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` = '15637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '367'
ORDER BY `busted` ASC, `current_chips` DESC
0.0061 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` = '367'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
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` = '15911'
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` = '15881'
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` = '15850'
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` = '15845'
ORDER BY `chip_change` DESC, `busted` ASC
0.0318 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15832'
ORDER BY `chip_change` DESC, `busted` ASC
0.0269 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15821'
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` = '15820'
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` = '15818'
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` = '15813'
ORDER BY `chip_change` DESC, `busted` ASC
0.0515 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15803'
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` = '15800'
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` = '15792'
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` = '15791'
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` = '15787'
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` = '15785'
ORDER BY `chip_change` DESC, `busted` ASC
0.0120 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15782'
ORDER BY `chip_change` DESC, `busted` ASC
0.0176 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15778'
ORDER BY `chip_change` DESC, `busted` ASC
0.0706 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15775'
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` = '15769'
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` = '15767'
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` = '15760'
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` = '15748'
ORDER BY `chip_change` DESC, `busted` ASC
0.0086 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15749'
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` = '15747'
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` = '15743'
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` = '15741'
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` = '15738'
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` = '15734'
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` = '15733'
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` = '15732'
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` = '15724'
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` = '15722'
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` = '15709'
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` = '15706'
ORDER BY `chip_change` DESC, `busted` ASC
0.0383 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15701'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15696'
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` = '15694'
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` = '15685'
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` = '15677'
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` = '15676'
ORDER BY `chip_change` DESC, `busted` ASC
0.0093 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15669'
ORDER BY `chip_change` DESC, `busted` ASC
0.0071 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15667'
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` = '15665'
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` = '15637'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '367'
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.
Rasmus Lundstrum Wins The €1,100 NLH Mystery Bounty Ring Event #8 Posted Saturday 27th July, 2024 at 21:44(UTC+2) by Alaxandar Georgiev
This is the story of Rasmus Lundstrum and how you should never give up and fight till the end. He was left with only 3 blinds after he took a bad beat right before the final table and managed to get a little double, then another and another, he even started playing from his short stack and eventually won the heads-up against Akseli Paalanen who was chip-leading the final table until the heads-up.
Even though Rasmus couldn't win a lot of big bounties and two players even won bigger prizes than his €25,850 for first place, but he won the thing that was most important to him - the WSOPC Golden Ring, he played brilliantly throughout the final table and deserved every bit of that gold.
The biggest bounty €20,000 was pulled right from the first envelope by Steinn Karlsson who finished 15th but cashed the event for €21,650 which is even near how much Lundstrum won. At the end of the day, this is how this format is played, everyone went wild in the hunt for the bounties, and some pots were won in a very strange way. The only other big bounty that was pulled by a player who did not join the final table was €8,000 by Josep Ramon who bubbled the final table in 10th place.
Akseli Paalanen also did a great job at the final table, at one point with four players left he had about 70% of the chips in play, but couldn't close it out. At least he got some pretty big bounties and even pulled the last big one €10,00 0out of Lundstrum's "hands".
Down below you can see how players finished on the final table.
Place
Player
Country
Prize + Bounties
1
Rasmus Lundstrum
Finland
€25,850
2
Akseli Paalanen
Finland
€40,880
3
Claudio Cecchi
Italy
€14,250
4
Arduini Lorenzo
Italy
€35,300
5
Ritvars Cekalins
Latvia
€15,950
6
Albert Ostrovskij
Lithuania
€4,550
7
Oleksii Natoptanyi
Ukraine
€8,650
8
Klaudijus Bajoras
Lithuania
€3,050
9
Egidijus Digrys
Lithuania
€2,500
Akseli The Terminator Posted Saturday 27th July, 2024 at 19:50(UTC+2) by Lina Olofsson
The Mystery Bounty is over and even when the very last hand of the tournament had played out the excitement wasn't over. Neither for the two players - Rasmus and Akseli - nor the (mostly Finnish) rail which had stood there for quite some time to see it all come to an end. There was still plenty of money, alongside the prize money they agreed on making a deal on, to play for in the golden box, and even if Akseli already had picked up some of his bounties already from it he still had three of those bounty chips to collect.
Before the final table started Akseli drew four black envelopes in front of the cameras here in the grand ballroom. First, he picked up €2,000, in the next one he got €1,000, and in the third one he took one of the remaining €10K, and in the last one he received €500 making it a good payday no matter what happened.
The very cheerful crowd, Akseli and our winner Rasmus headed over to the box which still had seven more envelopes to open in one of them there was €10,000 and the rest of the envelopes surely weren't empty with the amount of €500 up to €3,000. Akseli who was a machine here today had another three when the heads-up was over and even if he didn't win that WSOP Circuit ring he was probably really happy anyway as it was going to be a big payday with or without the title to it.
Rasmus had four of those bounty chips (one chip=one envelope) and Akseli had three. Obviously it was the big one with the 10K both of the players wanted to lay their hand on and they used different strategies to do it. They even let some of their friends draw it for them which made the whole thing even more cheerful and exciting.
As Rasmus was the winner he got to pick the first envelope which had €1,000 in it. When it was time for Rasmus he sent one of his friends to the box to pick up his one which was €500. Something that made the excitement even bigger as the €10K was still in the game.
They continued drawing as the excitement rose in the tournament room. As there were three left so was the big check. Rasmus who had two left of those knew that he'd at least catch one of the big numbers as both 10K and 3K was still in. He put his hand down the box and nervously picked one of the envelopes up. Very gently he opened it as the others leaned over to see and when the number finally revealed the check "only" had four and not five digits on it and he secured the 3K as Akseli reached down to pick up one of the last two. One had €500 in it and the other one was the big one.
After seconds that felt like minutes, Akseli opened the envelope and revealed the check. There it was. The €10,000. Akseli and his friends screamed out of joy and Rasmus received the very last envelope in the box.
Rasmus Lundstrum Is The WSOPC RIng Event #8 €1,100 Mystery Bounty Champion (€25,850) Posted Saturday 27th July, 2024 at 18:30(UTC+2) by Alaxandar Georgiev
Rasmus Lundstrum made it to the victory after he took a bad beat right before the final table and started on it with just three blinds. He managed to beat his opponent Akseli Paalanen in the heads-up and is now crowned champion of the €1,100 Mystery Bounty.
Finland's Lundstrum will take home €25,850 which includes €6,000 in bounties and the golden WSOPC Ring. He mentioned that the ring means a lot to him and he will have a memory for life.
Congratulations to the winner, he is now hungry for more as he told our team that he will be joining some more of the side events.
Akseli Paalanen is Eliminated In 2nd Place (€40,880) Posted Saturday 27th July, 2024 at 18:21(UTC+2) by Alaxandar Georgiev
Akseli Paalanen called the 205,000 raise from the big blind and the flop was - Rasmus Lundstrum bet 300,000 and Paalanen shoved his remaining 1,300,000 chips which Lundstrum snap-called.
Akseli Paalanen: Rasmus Lundstrum:
Paalanen had the straight draw and a top pair for his opponent. The turn wasn't what Paalanen needed, neither was the on the river. His run is over just 1 away from the WSOPC Ring and the glory.
Akseli Paalanen finishes in 2nd place and wins €40,880 since he drew the last 10,000 bounty too. This amount is €15,000 more than what Rasmus Lundstrum got for 1st place.
Akseli Paalanen in the heads-up (red hat)
Player
Chips
Progress
Rasmus Lundstrom
6,540,000
3,635,000
Akseli Paalanen
0
0
Just A Four Million Pot On The Turn Posted Saturday 27th July, 2024 at 17:52(UTC+2) by Alaxandar Georgiev
Level 27: 30,000/60,000 (60,000) Entries 2/218
A raise to 120,000 from Rasmus who had just lost almost 1,500,000 in a few hands before and a call from Paalonen led to flop on which Rasmus Lundstrum bet 100,000 and got a call.
The turn is where things got scary for both when the dealer turned the - Lundstrum bet 280,000 and got raised to 850,000 by his opponent, Lundstrum took his time and re-raised once again to 1,500,000 which was followed by a call from Paalonen.
They both checked on the river and Paalonen turned for a missed double gutshot and a flush draw. Lundstrum had and won the big pot.
Player
Chips
Progress
Rasmus Lundstrom
4,200,000
505,000
Rasmus Lundstrom
2,400,000
1,295,000
Queens In The Mystery Bounty Posted Saturday 27th July, 2024 at 17:34(UTC+2) by Lina Olofsson
The format of the Mystery Bounty is thrilling as it doesn't matter if you have seven eliminations or one as long as you collect the right envelope in the raffle. The €1,100 Mystery Bounty surely is proof of that with its 218 entries. As the final table began in this tournament the Queens Mystery Bounty kicked off which has 38 entries so far when we're six levels in. There might be even more since the players may re-enter or buy in until the end of the break after level eight.
Among the runners in this Queens event, there are plenty of familiar faces from the Queens event earlier this week but so far we haven't spotted the ring winner Linda Nguyen but both her runner-up Linda Lahdenpaa and third place finisher Jenny Westerlund. Other familiar faces are Nina Ottesen, Anne Bedeck, Indre Martoviciute, Daiva Byrne, and Sirkka-Liisa Seppala.
Heads Up For The Golden Ring Posted Saturday 27th July, 2024 at 17:34(UTC+2) by Alaxandar Georgiev
Level 27: 30,000/60,000 (60,000) Entries 2/218
Rasmus Lundstrum's amazing comeback after a bad beat got him up all the way to the heads-up, he lost a million chips pot before the final table and started on it with just 3 blinds. Now he is the chip leader in the heads-up against Aleksi Paalonen who has been chip leading the final table till the heads-up.
Both Finns made a deal already and are playing for €3,500, the bounties and the golden jewelry.
Rasmus Lundstrum - 3.695,000
Aleksi Paalonen - 2,845,000
17:30 (UTC+2)
Start of Level 27 Blinds: 30,000/60,000 Ante: 60,000
Claudio Cecchi Is Eliminated In 3rd Place (€14,250) Posted Saturday 27th July, 2024 at 17:30(UTC+2) by Alaxandar Georgiev
Level 26: 25,000/50,000 (50,000) Entries 3/218
Rasmus Lundstrum shoved from the small blind and Claudio Cecchi called off his remaining 12 blinds. There was a €4,000 pay jump if Lundstrum won the pot.
Claudio Cecchi: Rasmus Lundstrum:
A safe flop for Cecchi, then another card peeled and it was indeed the on the turn. The river bricked for the Italian and his hopes of taking the golden ring were over.
Claudio Cecchi finished in 3rd place and collected the sum of (€14,250) which includes around €4,000 in bounties.
Player
Chips
Progress
Rasmus Lundstrom
3,695,000
1,295,000
Akseli Paalanen
2,845,000
255,000
Claudio Cecchi
0
0
Arduini Lorenzo is Eliminated in 4th (€35,300) Posted Saturday 27th July, 2024 at 17:07(UTC+2) by Alaxandar Georgiev
Level 26: 25,000/50,000 (50,000) Entries 4/218
Rasmus Lundstrum opened the pot to 100,000 from the button against the two shortest stacks and Arduini Lorenzo put all of his 440,000 chips in the middle and Lundstrum made the call.
Arduini Lorenzo: Rasmus Lundstrum:
Lorenzo was slightly ahead and at risk, the flop turned and Lundstrum was now in the lead with his pair of sevens. Another came on the turn and the river was .
Arduini Lorenzo finished in 4th place, but he gets a massive pay out of €35,300 after pulling €15,000, €7,000, a €5,000 plus a €500 bounty.
Player
Chips
Progress
Rasmus Lundstrom
2,400,000
500,000
Arduini Lorenzo
0
0
Lundstrum Fights Back Posted Saturday 27th July, 2024 at 16:59(UTC+2) by Alaxandar Georgiev
Level 26: 25,000/50,000 (50,000) Entries 4/218
Another blind versus blind action between Akseli Paalanen and Rasmus Lundstrum. This time Paalanen made it 175,000 from the small blind and Lundstrum called.
We saw a flop of on which the Finn continued with a 100,000 bet, Lundstrum called and the turn was . Same thing happened on the turn, but the price was 175,000.
The river was and Paalanen checked, after a while Lundstrum bet 415,000 which Paalanen called.
Lundstrum turned - he hit his gutshot straight on the river and wins a massive pot worth almost 2,000,000
Player
Chips
Progress
Akseli Paalanen
3,100,000
1,200,000
Rasmus Lundstrom
1,900,000
1,200,000
16:46 (UTC+2)
Start of Level 26 Blinds: 25,000/50,000 Ante: 50,000
Tough Spot For The Three Short Stacks Posted Saturday 27th July, 2024 at 16:45(UTC+2) by Alaxandar Georgiev
Level 25: 20,000/40,000 (40,000) Entries 4/218
Akseli Paalanen is sitting with a stack of about 4,700,000 and all three of the other players are hanging around the 600-700,000 chips mark. With the pay jumps and the bounties in play, Paalanen is putting up the pressure on the other players.
Monster Hand For Paalanen Posted Saturday 27th July, 2024 at 16:25(UTC+2) by Alaxandar Georgiev
Level 25: 20,000/40,000 (40,000) Entries 4/218
There was already more than 700,000 in the middle on board and Arduini Lorenzo was heads up against Akseli Paalanen, he checked and Paalanen bet another 550,000. After some thinking Lorenzo made the call and his opponent showed down a set of fours.
Lorenzo mucked his cards and Paalanen scooped a pot that was almost 2,000,000.
Akseli Paalanen - Chip leading the final table.
Player
Chips
Progress
Akseli Paalanen
4,300,000
1,300,000
Arduini Lorenzo
450,000
1,300,000
16:19 (UTC+2)
Start of Level 25 Blinds: 20,000/40,000 Ante: 40,000
Ritvars Cekalins is Eliminated in 5th place (€15,950) Posted Saturday 27th July, 2024 at 16:19(UTC+2) by Alaxandar Georgiev
Level 24: 15,000/30,000 (30,000) Entries 5/218
Hand after hand Akseli Paalanen opens and busts players out, this time it was Ritvars Cekalins that jammed his last 10 blinds against the raise, Paalanen called and they showed down.
Ritvars Cekalins: Akseli Paalanen:
Paalanen was against the hand he just had, the flop came and Cekalins was still doing good, the turn was not very good for him since the gave the Finn a little bit more outs. The river was , which Cekalins definitely didn't need because it completed Paalanen's 1-card flush.
Ritvars Cekalins finished in 5th place and gets a nice payout of €15,950 because he took down one of the €10,000 bounties earlier.
Player
Chips
Progress
Akseli Paalanen
3,000,000
500,000
Ritvars Cekalins
0
0
Albert Ostrovskij is eliminated in 6th place (€4,550) Posted Saturday 27th July, 2024 at 16:11(UTC+2) by Alaxandar Georgiev
Level 24: 15,000/30,000 (30,000) Entries 6/218
The last Lithuanian on the final table Albert Ostrovskij shoved from cutoff for 470,000 and once again it was the chip leader Akseli Paalanen who also went all-in from the button.
Albert Ostrovskij: Akseli Paalanen:
The board ran-out in favor of the bigger stack and Ostrovskij got eliminated.
Albert Ostrovskij finished in 6th place and will get a payout of €4,550.
Two Double Ups For Lundstrum Posted Saturday 27th July, 2024 at 16:04(UTC+2) by Alaxandar Georgiev
Level 24: 15,000/30,000 (30,000) Entries 6/218
Finland's Rasmus Lundstrum managed to double up twice against the chip leader Akseli Paalanen first one was with his vs and then Paalanen open-shoved from cutoff with and Lundstrum pocket aces . In just a few hands he got his stack up from 135,000 to 700,000.
Player
Chips
Progress
Akseli Paalanen
2,500,000
400,000
Rasmus Lundstrom
700,000
455,000
15:58 (UTC+2)
Start of Level 24 Blinds: 15,000/30,000 Ante: 30,000
Double Elimination On The Final Table Posted Saturday 27th July, 2024 at 15:55(UTC+2) by Alaxandar Georgiev
Level 23: 10,000/25,000 (25,000) Entries 9/218
Klaudijus Bajoras went all-in under the gun for his last 175,000 chips, he got a call from Arduini Lorenzo, then Oleksii Natoptanyi jammed from the button for 625,000 and it was followed by another re-shove by chip leader Akseli Paalanen, everyone else folded and it was a 3-way all-in.
Two players at risk and they were both drawing very thin after the flop. There was almost no hope for Bajoras already and Natoptanyi needed to hit a two-outer. The next two cards were and and it was over for the shorter stacks. Double Elimination for Paalanen.
7th place and €8,650 for Oleksii Natoptanyi after he drew a €5,000 bounty. 8th place and € 3,050 for Klaudijus Bajoras, unlucky for him he took no bounties.
Player
Chips
Progress
Akseli Paalanen
2,900,000
865,000
Oleksii Natoptanyi
0
0
Klaudijus Bajoras
0
0
Egidijus Digrys is Eliminated in 9th (€2,500) Posted Saturday 27th July, 2024 at 15:35(UTC+2) by Alaxandar Georgiev
Level 23: 10,000/25,000 (25,000) Entries 9/218
Egidijus Digrys raised 75,000 off from his 400,000 stack and got effectively jammed by Arduini Lorenzo who was on the button. Digrys called and they revealed their cards.
Egidijus Digrys: Arduini Lorenzo:
Digrys was ahead and needed to fade some aces after the flop. The turn was another diamond, which gave Lorenzo too many additional outs for a flush and a gutshot straight. The river was the which meant it was the end for Digrys in the golden ring race.
Egidijus Digrys finished in 9th place and he won 0 bounties, he will collect a payout of €2,500.
Player
Chips
Progress
Arduini Lorenzo
1,750,000
155,000
Egidijus Digrys
0
0
Can The Shortest Stack Double Up? Posted Saturday 27th July, 2024 at 15:29(UTC+2) by Alaxandar Georgiev
Level 23: 10,000/25,000 (25,000) Entries 9/218
Rasmus Lundstrum was all-in for his last 70,000 chips and got two calls, one of them from Albert Ostrovskij on the big blind who bet the .
Rasmus Lundstrum: Albert Ostrovskij:
Lundstrum needed only a queen to stay alive after his opponent had already paired his eight. The turn was and with only one card to go Lundstrum hit the on the river and tripled up.
Player
Chips
Progress
Albert Ostrovskij
600,000
80,000
Rasmus Lundstrom
245,000
175,000
15:21 (UTC+2)
Start of Level 23 Blinds: 10,000/25,000 Ante: 25,000
Final Table Seat Draw And Chip Counts Posted Saturday 27th July, 2024 at 15:17(UTC+2) by Alaxandar Georgiev
Check out the players who made it to the final table of the Ring Event #8 WSOPC €1,100 NLH Mystery Bounty.
The big chip leader is Finland's Akseli Paalanen with just a bit over two million chips, right behind is Arduini Lorenzo and everyone else is short compared to these two. Rasmus Lundstrum and Klaudijus Bajoras are left with just a few blinds and they need to spin it up.
Name
Country
Chip count
Seat
Arduini Lorenzo
Italy
1,595,000
18-5
Egidijus Digrys
Lithuania
350,000
18-9
Rasmus Lundström
Finland
70,000
18-1
Akseli Paalanen
Finland
2,035,000
18-8
Klaudijus Bajoras
Lithuania
110,000
18-2
Albert Ostrovskij
Lithuania
680,000
18-6
Oleksii Natoptanyi
Ukraine
570,000
18-7
Ritvars Cekalins
Latvia
425,000
18-4
Claudio Cecchi
Italy
705,000
18-3
Players Who Busted Right Before FT Posted Saturday 27th July, 2024 at 15:04(UTC+2) by Alaxandar Georgiev
Here is the list of players who fell short of making it into the final table.
Phil Gross got an ugly setup against one of the players where he had two pairs on the flop and his opponent had a made straight. He falls short of making it into another WSOPC Final table after winning his first golden ring just 2 days ago.
Place
Name
Country
Prize + Bounties
10
Josep Ramon
Spain
€10,150
11
Phil Gross
Germany
€3,100
12
Anti Reinthal
Estonia
€1,900
13
Mikael Haapaniemi
Finland
€2,900
14
Pavels Kazakovs
Latvia
€2,650
Player
Chips
Progress
Josep Pastor De Ramon
0
0
Phil Gross
0
0
Anti Reinthal
0
0
Mikael Haapaniemi
0
0
Pavels Kazakovs
0
0
Josep Ramon Bubbles The Final Table Posted Saturday 27th July, 2024 at 14:56(UTC+2) by Alaxandar Georgiev
Level 20: 10,000/20,000 (20,000) Entries 10/218
Josep Ramon was left with a few blinds after he lost his last hand and decided to go for it with from the big blind after a raise by Arduini Lorenzo. No luck for Ramon till the river, he finished in 10th place just one away from the final table.
Ramon will take home €2,500 and his €8,000 bounty he drew earlier.
Player
Chips
Progress
Arduini Lorenzo
1,700,000
1,270,000
Josep Pastor De Ramon
0
0
Karlsson And Cekalins Picks Up The Big Ones In The Raffle! Posted Saturday 27th July, 2024 at 14:51(UTC+2) by Lina Olofsson
And just like that we are down to the last ten players and already had the first break of the day which also meant raffle time. Several players got to join the raffle action.
All players from now on get a bounty chip for each player they eliminate and get to stick their hand into the big box of envelopes which contains some huge numbers. The minimum amount they will say €500 and then it's all the way up to the €20,000 one lucky winner will receive. And it's already out there!
Steinn Thanh Du Karlsson was the first one to reach into those envelopes and he did a very good job picking up the highest amount of them all. He only had one bounty chip and managed to pick just the right one. As soon as the game resumed he was eliminated but still picked up more than the first price in the tournament cashing in €21 650 in total for his efforts here.
Just after Steinn had plucked his 20,000 win it was time for Ritvars Cekalins and he did a really good job too cashing in €10,000 which there are three of in total amongst all these 27 envelopes.
Double On The FT Bubble Posted Saturday 27th July, 2024 at 14:50(UTC+2) by Alaxandar Georgiev
Level 20: 10,000/20,000 (20,000) Entries 10/218
Ritvars Cekalins shoved his over a raise on the final table bubble, he had 234,000 chips and got called behind by another all-in player Josep Ramon, who had 345,000.
Ramon didn't manage to make a pair till the river and is down to 110,000 chips.
Player
Chips
Progress
Ritvars Cekalins
640,000
455,000
Josep Pastor De Ramon
110,000
151,000
14:35 (UTC+2)
Start of Level 21 Blinds: 10,000/20,000 Ante: 20,000
The Most Disgusting Hand In Day 2 Posted Saturday 27th July, 2024 at 14:32(UTC+2) by Alaxandar Georgiev
Level 20: 10,000/15,000 (15,000) Entries 12/218
Raise from Albert Ostrovskij and a call from Rasmus Lundstrum on the big blind saw them both go on the flop where Lundstrum check-raised his opponent's 40,000 bet to 115,000 and Ostrovskij re-shoved for 488,000 which was snap-called by Lundstrum.
Rasmus Lundstrum: - Set of threes Albert Ostrowskij: - top pair, top kicker
Ostrowskij seemed surprised when he saw his opponent's hand, he got some hopes when the dealer put the on the turn which meant he was now drawing for a full house.
BANG... the river was another ace and Lundstrum couldn't believe it... he said "I want to cry .. " as he started counting the chips for the massive payout he had to give to Ostrovskij, Lundstrum was left with about 130,000 after the sick hand.
Rasmus Lundstrum
Player
Chips
Progress
Albert Ostrovskij
1,020,000
450,000
Rasmus Lundstrom
130,000
60,000
Last Two Tables Posted Saturday 27th July, 2024 at 14:10(UTC+2) by Alaxandar Georgiev
Level 20: 10,000/15,000 (15,000) Entries 14/218
There was a re-draw for the last two tables after another few players busted, we will soon be on the final table if players continue going crazy for bounties. But a lot of the big bounties have already been taken, let's see how players adjust to this situation.
Here is a list of the people who busted in the money.
Player
Chips
Progress
Steinn Thanh Du Karlsson
0
0
Nidal Dawoud
0
0
Vidar Assersen
0
0
Massimo Casabona
0
0
Mikko Salmij?rvi
0
0
Ryhor Karapanau
0
0
Frederic Delval
0
0
Sven Stok
0
0
Morten Bremseth
0
0
Jaakko Ranua
0
0
Ricardas Lukauskas
0
0
Ekrem Esker Atush
0
0
Elvijs Kuceruks
0
0
Gross Gives People A Ride With His Q7 Posted Saturday 27th July, 2024 at 14:03(UTC+2) by Alaxandar Georgiev
Level 20: 10,000/15,000 (15,000) Entries 17/218
Arduini Lorenzo opened up the pot from an early position and got a call from Rasmus Lundstrom for 30,000 chips. Then we had the main aggro player Phil Gross who recently won a WSOPC Ring shove for 332,000 and only Lorenzo called after some thinking.
Phil Gross: Arduini Lorenzo:
Phil was feeling great when he saw his opponent's hand and even better on the flop. He managed to hit a pair and held it through the next two cards. Huge pot worth about 700,000 chips goes Phil's way.
Phil got another huge one against blind on blind a few hands later when he won against . Phil drilled a Jack on the flop and got his first Mystery Bounty.
Player
Chips
Progress
Phil Gross
710,000
210,000
Arduini Lorenzo
430,000
312,000
Ricardas Lukauskas
0
0
Huge Hand On Table 18 Posted Saturday 27th July, 2024 at 13:53(UTC+2) by Alaxandar Georgiev
Level 20: 10,000/15,000 (15,000) Entries 18/218
Pavels Kazakovs raised under the gun, Arduini Lorenzo, and Phil Gross called the 30,000 raise and Albert Ostrovskij shoved it from the big blind for 175,000. Kazakovs re-shoved and Lorenzo called for a big pot.
Albert Ostrovskij: Arduini Lorenzo: Pavels Kazakovs:
Ostrovskij was favorite to triple-up and the flop was clean for him. The turn and river didn't change anything for the pocket pairs.
Ostrovskij wins a massive pot worth over 550,000 and Lorenzo had 371,000 behind for the side pot, so even though he lost the main pot he is still up in chips.
Player
Chips
Progress
Arduini Lorenzo
742,000
145,000
Albert Ostrovskij
570,000
328,000
Pavels Kazakovs
90,000
302,000
13:45 (UTC+2)
Start of Level 20 Blinds: 10,000/15,000 Ante: 15,000
Oleksii Natoptanyi Is Short Of Luck Posted Saturday 27th July, 2024 at 13:42(UTC+2) by Alaxandar Georgiev
Level 19: 6,000/12,000 (10,000) Entries 19/218
Oleksii Natoptanyi shoved his last 90,000 in the middle and Ekrem Atush re-jammed from the small blind.
Oleksii Natoptanyi: Ekrem Atush:
The flop was safe for the Ukrainian, the dealer then put the on the turn and Atush was now a card away from a mystery bounty envelope. The river was a brick and it ended Natoptanyi's run in the tournament in 19th place and €1,350.
Another One Bites The Dust Posted Saturday 27th July, 2024 at 13:27(UTC+2) by Alaxandar Georgiev
Level 19: 6,000/12,000 (10,000) Entries 22/218
Egidijus Digrys opened under the gun and Ryhor Karapanau only had 2 blinds left he called the raise and was all in. 3 more calls were followed behind by Mikael Haapaniemi in the middle, Rasmus Lundström, and Josep Ramon completed from the blinds.
The flop was two checks and action was on Digrys who bet 36,000 - only Lundstrom called and they both checked the turn. The river was and Lundstrom checked once again, which led to Digrys betting 60,000 and Lundstrom snap-calling.
Lundstrom wins a sweet pot and his first Mystery Bounty, Karapanau finished the tournament in 21st place and will take home €1,250.
Player
Chips
Progress
Rasmus Lundstrom
540,000
146,000
Egidijus Digrys
200,000
163,000
Ryhor Karapanau
0
0
13:14 (UTC+2)
Start of Level 19 Blinds: 6,000/12,000 Ante: 12,000
Big River For Assersen Posted Saturday 27th July, 2024 at 13:14(UTC+2) by Alaxandar Georgiev
Level 18: 5,000/10,000 (10,000) Entries 25/218
Vidar Assersen shoved for his remaining 50,000 chips and Iceland's Steinn Karlsson had him covered right on his left with his 72,000 chips, on the big blind Egidijus Digrys was sitting with a big stack of more than 400,000 and also flicked in the call to play for the bounties.
Vidar Assersen: Steinn Karlsson: Egidijus Digrys:
Assersen had the best hand and was very likely to triple up on the flop. Digrys could now hit a six for the win as well, the turn changed nothing, but it was very bad news on the river for Assersen's pocket queens.
Steinn Karlsson wins the bounty and a good pot at start of Day 2.
Player
Chips
Progress
Egidijus Digrys
363,000
72,000
Steinn Thanh Du Karlsson
195,000
170,000
Vidar Assersen
0
0
13:01 (UTC+2)
Day 2 of Olympic Park Casino Started Level: 18 Blinds: 5,000/10,000 Ante: 10,000
Shuffle Up And Deal !! Posted Saturday 27th July, 2024 at 13:01(UTC+2) by Alaxandar Georgiev
Level 18: 5,000/10,000 (10,000) Entries 27/218
Players just took their seats, opened their bags and the chips were on the table. The top bounty prize is the whopping amount of €20,000 and its almost as much as the first place prize which is €21,430, so one lucky guy could potentially win more than the player who wins the tournament.
Follow this live blog for more updates through the final day of the WSOPC €1,100 NLH Mystery Bounty Ring Event.
Historical Mystery Bounty In Tallinn About To Start Posted Saturday 27th July, 2024 at 12:54(UTC+2) by Lina Olofsson
Records after records are broken here as the prestigious WSOP Circuit visits Tallinn for the second time. As the registration closed in the €1,100 Mystery Bounty after ten levels there had been 218 entries made in total creating a prize pool of €209,280 with a first prize of €21,430.
As the tournament clock stopped here pretty late last night on the 18th level the remaining players were down to the last 27 which means that when we come back we are not only in the money. So is the mystery bounty where one lucky player will receive an astonishing €20,000, one will receive €15,000 and in three of these envelopes there will be €10,000.
In each break, there will be a mystery bounty raffle for the players who managed to pick up some bounties which the blog obviously will stick around to see and report back to you.
Chip leader going into today is Arduini Lorenzo from Italy with 597,000. Second in chips, we have the Finn Mikael Haapaniemi with 563,000 and the third is the event three winner Phil Gross with 500,000.
Play resumes at 1 pm. Shuffle up and deal!
The Event #3 winner Phil Gross is excited to start!
Day 2 Seat Draw Posted Saturday 27th July, 2024 at 11:36(UTC+2) by Jason Glatzer
Table
Seat
Name
Country
Chips
Big Blinds
16
1
Jaakko Ranua
Finland
45,000
5
16
3
Massimo Casabona
Italy
69,000
7
16
4
Josep Pastor De Ramon
Spain
261,000
26
16
5
Klaudijus Bajoras
Lithuania
266,000
27
16
6
Ekrem Esker Atush
Finland
97,000
10
16
7
Phil Gross
Germany
500,000
50
16
8
Mikael Haapaniemi
Finland
563,000
56
17
1
Akseli Paalanen
Finland
338,000
34
17
2
Oleksii Natoptanyi
Ukraine
241,000
24
17
3
Mikko Salmijärvi
Finland
192,000
19
17
4
Nidal Dawoud
Denmark
61,000
6
17
5
Anti Reinthal
Estonia
255,000
26
17
7
Sven Stok
Netherlands
458,000
46
17
8
Ritvars Cekalins
Latvia
185,000
19
18
1
Elvijs Kuceruks
Latvia
72,000
7
18
3
Morten Bremseth
Norway
163,000
16
18
4
Ricardas Lukauskas
Lithuania
156,000
16
18
5
Albert Ostrovskij
Lithuania
242,000
24
18
6
Pavels Kazakovs
Latvia
392,000
39
18
7
Arduini Lorenzo
Italy
597,000
60
18
8
Frederic Delval
France
92,000
9
23
1
Egidijus Digrys
Lithuania
435,000
44
23
2
Ryhor Karapanau
Latvia
190,000
19
23
3
Claudio Cecchi
Italy
168,000
17
23
4
Vidar Assersen
Norway
72,000
7
23
6
Steinn Thanh Du Karlsson
Iceland
25,000
3
23
7
Rasmus Lundström
Finland
394,000
39
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.
- Rasmus Lundstrum bet 300,000 and Paalanen shoved his remaining 1,300,000 chips which Lundstrum snap-called.
wasn't what Paalanen needed, neither was the 
on the river. His run is over just 1 away from the WSOPC Ring and the glory.
flop on which Rasmus Lundstrum bet 100,000 and got a call.
- Lundstrum bet 280,000 and got raised to 850,000 by his opponent, Lundstrum took his time and re-raised once again to 1,500,000 which was followed by a call from Paalonen.
river and Paalonen turned 
flop for Cecchi, then another card peeled and it was indeed the 
on the turn. The river bricked for the Italian and his hopes of taking the golden ring were over.
and Lundstrum was now in the lead with his pair of sevens. Another 
on which the Finn continued with a 100,000 bet, Lundstrum called and the turn was 
. Same thing happened on the turn, but the price was 175,000.
and Paalanen checked, after a while Lundstrum bet 415,000 which Paalanen called.
board and Arduini Lorenzo was heads up against Akseli Paalanen, he checked and Paalanen bet another 550,000. After some thinking Lorenzo made the call and his opponent showed down 
a set of fours. 
and Cekalins was still doing good, the turn was not very good for him since the 
gave the Finn a little bit more outs. The river was 
vs 
. In just a few hands he got his stack up from 135,000 to 700,000.
flop. The turn was 
hand and decided to go for it with 
flop. He managed to hit a pair and held it through the next two cards. Huge pot worth about 700,000 chips goes Phil's way.
didn't change anything for the pocket pairs.
brick and it ended Natoptanyi's run in the tournament in 19th place and €1,350.
£ GBP
$ USD
€ EUR
