0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0067 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-09-01'
AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event7'
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.0001 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.0004 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.0063 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_event7'
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '143'
0.0247 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0052 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '346'
AND `published` = 1
0.0051 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` = '346'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '143'
AND `name` = '2'
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '346'
ORDER BY `busted` ASC, `current_chips` DESC
0.0048 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` = '346'
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` = '15160'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15159'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15158'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15147'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0058 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15143'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15153'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15128'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15109'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15107'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15105'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15102'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15099'
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` = '15097'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15094'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15092'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15087'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15086'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15059'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15053'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '346'
ORDER BY `busted` ASC, `current_chips` DESC
0.0047 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '346'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15160'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15159'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15158'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15149'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15147'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15146'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15145'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15143'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15142'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15137'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15153'
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` = '15131'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15130'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15127'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15128'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15124'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15122'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15120'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15118'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15116'
ORDER BY `chip_change` DESC, `busted` ASC
0.0056 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15114'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15113'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15110'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15109'
ORDER BY `chip_change` DESC, `busted` ASC
0.0057 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15107'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15106'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15105'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15102'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15099'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15097'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15094'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15092'
ORDER BY `chip_change` DESC, `busted` ASC
0.0055 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15087'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15086'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15059'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15053'
ORDER BY `chip_change` DESC, `busted` ASC
0.0053 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '15054'
ORDER BY `chip_change` DESC, `busted` ASC
0.0054 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '346'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 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.
Day 2 of Olympic Park Casino Ended Level: 28 Blinds: 50,000/100,000 Ante: 100,000
Riku Koivurinne Wins Event #7: €1,100 PLO 4&5 (€41,200) Posted Thursday 25th July, 2024 at 22:32(UTC+3) by Jason Glatzer
Finland's Riku Koivurinne navigated through a record-breaking field of 198 entries in the two-day Event #7: €1,100 PLO 4&5 Cards at Olympic Park Casino.
While Koivurinne didn't start the day with many chips, he quickly moved up the ranks before eventually capturing the chip lead from runner-up Jan Holte. He displayed aggression at the correct times for a commanding performance en route to winning the WSOP Circuit Gold Ring and the free ticket to the $1 million guaranteed WSOP Tournament of Champions next summer, where he will play for a matching WSOP gold bracelet to go along with his newly earned ring.
Koivurinne had a 4:1 chip advantage to start heads-up play against Holte. Holte battled back before nearly evening the stacks before the duo agreed to a deal guaranteeing Koivurinne €33,700 and Holte at least €32,500 with still €7,500 to play for. Koivurinne went on a tear to quickly close things out from there to win his first taste at WSOP gold.
€1,100 PLO 4&5 Final Table Results
The €1,100 PLO 4&5 broke Estonian poker records for the largest international PLO tournament prize pool, with 198 runners generating a huge €190,800 prize pool. The top 23 players earned at least a min-cash valued at €2,200 for exactly double the €1,100 buy-in. The event was live-streamed at OlyBet.tv with WSOP Circuit Tallinn commentator George Sandford leading the way.
Place
Name
Country
Prize
1
Riku Koivurinne
Finland
€41,200
2
Jan Holte
Norway
€32,500
3
Lars Romundstad
Norway
€20,800
4
Jussi Mattila
Finland
€15,400
5
Stanislovas Vinicenka
Lithuania
€11,900
6
Sami Paananen
Finland
€9,280
7
Renars Stepins
Latvia
€7,350
8
Gisle Olsen
Denmark
€6,000
Final Table Action
Holte began the final table with the chip lead with more than double the stack of his nearest opponent in fellow Norwegian Lars Romundstad. Eventual winner Koivurinne was near the bottom of the pack with 12.5 big blinds to start the day.
The action was hot and heavy from the start, with several of the short-stacked players making moves. The first six times a short stack committed their stack resulted in a double-up, with the seventh time resulting in a triple-up.
However, everything settled down after that, and the momentum went to the big stacks. Romunstad lost several big pots and was low on chips when he chipped up by eliminating Denmark's Gisle Olsen (pictured above) in eighth place for €6,000.
From there, it was all the Koivurinne story as he eliminated the rest of the field in what turned out to be a commanding performance.
Koivurinne ousted the popular Finn Jussi Mattila (fourth - €15,400), Lithuanian cash-game guru Stanislovas Vinicenka (fifth - €11,900), Finland's Sami Paananen (sixth - €9,280), and Latvia's Renars Stepins (seventh - €7,350) all before the first break leaving just three players remaining.
After the break, Koivurinne served a small bad beat to Romundstad, which resulted in him collecting a €20,800 prize and having a commanding 4:1 chip advantage to start the heads-up action.
Koivurinne's momentum, which was on display from the start, temporarily died down as Holte won a few smaller pots before doubling through the chip leader to nearly even the stacks.
The duo asked for a short break to discuss a deal, which was agreed on quickly. After that, it was back to the Koivurinne show, with the Finn relentlessly applying pressure before sealing the deal by allowing his opponent to bluff into his full house.
Congrats to Riku Koivurinne for an epic win in the 2024 WSOP Circuit Tallinn Event #7: €1,100 PLO 4&5 for €41,200. Stay tuned at OlyBet as tomorrow we hop into the Main Event and the two-day €1,100 Mystery Bounty ring event.
*Photos courtesy of Elena Kask / OlyBet Poker.
Final Table Payouts Posted Thursday 25th July, 2024 at 22:09(UTC+3) by Jason Glatzer
Place
Name
Country
Prize
1
Riku Koivurinne
Finland
€41,200
2
Jan Holte
Norway
€32,500
3
Lars Romundstad
Norway
€20,800
4
Jussi Mattila
Finland
€15,400
5
Stanislovas Vinicenka
Lithuania
€11,900
6
Sami Paananen
Finland
€9,280
7
Renars Stepins
Latvia
€7,350
8
Gisle Olsen
Denmark
€6,000
Jan Holte Eliminated in 2nd Place (€32,500) Posted Thursday 25th July, 2024 at 19:06(UTC+3) by Jason Glatzer
Level 28: 50,000/100,000 (100,000) Entries: 1/198
The tournament ended in a flash as Holte's stack vanished the very next hand to exit in second place for €32,500.
Riku Koivurinne opened for 300,000. After posting the big blind, Holte had only 400,000 in his stack and jammed in for the extra chip. Koivurinne called, and Holte needed some help.
Jan Holte: Riku Koivurinne:
It wasn't the aces or kings that got the job done. Instead, it was a full house beating a flush for Holte to exit just one spot shy of the ring after the ran out on the double-paired board.
Congratulations to Riku Koivurinne for winning the 2024 WSOP Circuit Tallinn Event #7: €1,100 PLO 4&5 at Olympic Park Casino and the Hilton Tallinn Park. Stay tuned for a recap of the day.
Player
Chips
Progress
Riku Koivurinne
6,000,000
500,000
Jan Holte
0
0
Koivurinne Extends the Lead to Leave Holte on Crumbs Posted Thursday 25th July, 2024 at 19:02(UTC+3) by Jason Glatzer
Level 28: 50,000/100,000 (100,000) Entries: 2/198
Jan Holte limped the button with . Instead of checking back his option with in his hand, Riku Koivurinne opted to raise to 300,000. Holte called in position before bricking the flop.
Koivurinne checked his full house before calling a bet of 400,000 by Holte, who was already drawing dead.
Holte bet 800,000 with just another 500,000 behind on the turn. Koivurinne jammed, and Holte will need to get something going for a chance at the ring after folding.
Player
Chips
Progress
Riku Koivurinne
5,500,000
2,400,000
Jan Holte
500,000
2,400,000
Deal Agreed! Posted Thursday 25th July, 2024 at 18:57(UTC+3) by Jason Glatzer
Level 28: 50,000/100,000 (100,000) Entries: 2/198
The two players agreed upon an ICM deal, guaranteeing Finland's Riku Koivurinne €33,700 and Jan Holte at least €32,500 to flatten the payout.
There is still plenty to play for, with an additional €7,500 going to the winner, who will also be awarded a precious WSOP Circuit gold ring and a chance for more hardware in the form of a WSOP bracelet with an invitation to the WSOP Tournament of Champions $1 million guaranteed freeroll next summer.
Holte Nearly Evens it Up Posted Thursday 25th July, 2024 at 18:54(UTC+3) by Jason Glatzer
Level 28: 50,000/100,000 (100,000) Entries: 2/198
Jan Holte opened the button for 275,000 with and was called by Riku Koivurinne with from the big blind.
Holte continued with his overpair for 350,000 on the flop. Koivurinne folded, and Holte moved within two big blinds of his heads-up opponent.
The duo stopped the clock for a five-minute break while discussing a potential deal.
Player
Chips
Progress
Riku Koivurinne
3,100,000
700,000
Jan Holte
2,900,000
700,000
Momentum Changing Early Posted Thursday 25th July, 2024 at 18:47(UTC+3) by Jason Glatzer
Level 28: 50,000/100,000 (100,000) Entries: 2/198
Jan Holte won a few smaller pots just to be one double up away from the chip lead. He nearly effectively doubled without committing his stack over the course of several hands.
Player
Chips
Progress
Riku Koivurinne
3,800,000
1,000,000
Jan Holte
2,200,000
1,000,000
Lars Romundstad Eliminated in 3rd Place (€20,800) Posted Thursday 25th July, 2024 at 18:36(UTC+3) by Jason Glatzer
Level 28: 50,000/100,000 (100,000) Entries: 2/198
Lars Romundstad opened for 350,000 from the button with 225,000 left in his stack and was called by chip-leader Riku Koivurinne from the big blind.
Koivurinne bet more than the 225,000 his opponent had in his stack after the flop and Romundstad called as a 3:1 favorite with his jacks.
Lars Romundstad: Riku Koivurinne:
The , on the turn, flipped the tables with Koivurinne holding a better two-pair, and Romundstad was eliminated in 3rd place for €20,800 after the river completed the board.
Koivurinne will start the heads-up battle in the driver's seat with quadruple the stack of the start-of-the-day chip leader Jan Holte.
Player
Chips
Progress
Riku Koivurinne
4,800,000
925,000
Jan Holte
1,200,000
50,000
Lars Romundstad
0
0
18:27 (UTC+3)
Start of Level 28 Blinds: 50,000/100,000 Ante: 100,000
#FinalTableFreeroll Posted Thursday 25th July, 2024 at 18:21(UTC+3) by Matthew Summers
First Break Posted Thursday 25th July, 2024 at 17:45(UTC+3) by Jason Glatzer
The final three players are on their first break of the day. Blinds will increase to 50,000/100,000 (100,000) when the action resumes in 20 minutes.
Player
Chips
Progress
Riku Koivurinne
3,875,000
775,000
Jan Holte
1,250,000
350,000
Lars Romundstad
835,000
365,000
Koivurinne Extends Lead With Nut Flush Blocker Posted Thursday 25th July, 2024 at 17:42(UTC+3) by Jason Glatzer
Level 27: 40,000/80,000 (80,000) Entries: 3/198
Riku Koivurinne opened for 210,000 with from the button. Jan Holte with defended his big blind.
Holte improved to set on the flop with Koivruinne having a pretty nut-flush draw and an inconsequential top pair. Both players checked before Holte bet 175,000 on the turn before the river brought a third diamond onto the board.
Holte checked. Koivurinne bet 600,000 and got Holte to fold the best hand.
Player
Chips
Progress
Riku Koivurinne
3,100,000
500,000
Jan Holte
1,600,000
500,000
Lars Romundstad
1,200,000
215,000
Jussi Mattila Eliminated in 4th Place (€15,400) Posted Thursday 25th July, 2024 at 17:33(UTC+3) by Jason Glatzer
Level 27: 40,000/80,000 (80,000) Entries: 3/198
The tournament tells its own story. The first seven all-in and call situations led to short-stack players doubling or tripling their stacks. This was followed by the reverse situation, where the last five times this occurred, a player walked to the cashier for their payout.
Popular Finnish player Jussi "Potti-Jussi" Mattila has appeared at many final tables at Olympic Park Casino and had many supporters hoping he would earn his first WSOP Circuit gold ring. Mattila showed his heart, but in the end, he ran out of chips just one place shy of the podium after the following hand against Riku Koivurinne.
Koivurinne opened for 210,000 from the button before Mattila defended his big blind. Mattila checked the flop. Koivurinne fired out for a pot-sized bet of 540,000. Mattila jammed for 695,000, and the cards were tabled after Koivruinne called for a few more chips.
Jussi Mattila: Riku Koivurinne:
Mattila had a decent draw but bricked the turn and river to exit in fourth place for €15,400. The final three podium players each locked up a minimum of €20,800.
Meanwhile, the tournament witnessed the first lead change at the final table, with Koivruinne having a final table high of 2.6 million.
Player
Chips
Progress
Riku Koivurinne
2,600,000
700,000
Jussi Mattila
0
0
17:32 (UTC+3)
Start of Level 27 Blinds: 40,000/80,000 Ante: 80,000
Updated Chip Counts Posted Thursday 25th July, 2024 at 17:19(UTC+3) by Jason Glatzer
Player
Chips
Progress
Jan Holte
2,100,000
100,000
Riku Koivurinne
1,900,000
0
Lars Romundstad
985,000
150,000
Jussi Mattila
985,000
115,000
Stanislovas Vinicenka Eliminated in 5th Place (€11,900) Posted Thursday 25th July, 2024 at 17:18(UTC+3) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 5/198
The eliminations are coming at a fast and furious pace with Stanislovas Vinicenka the next to go in fifth place for €11,900. Vinicenka committed 210,000 of his 250,000 stack from the cutoff before Riku Koivurinne put him in for the rest from the big blind.
Stanislovas Vinicenka: Riku Koivurinne:
Koivurinne improved to two pair on the runout. Vinicenka was unable to come up with anything better and headed out of the tournament arena. Despite not getting a ring, Vinicenka came into play with crumbs in his stack and managed to ladder up a few spots for a bigger payout.
Player
Chips
Progress
Riku Koivurinne
1,900,000
400,000
Stanislovas Vinicenka
0
0
Sami Paananen Eliminated in 6th Place (€9,280) Posted Thursday 25th July, 2024 at 17:13(UTC+3) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 6/198
It was a total of seven times the short stack survived to start. However, it has been disastrous for the short stacks since then, as for the third time in a row, a committed stack led to elimination.
Jan Holte opened for 200,000 from under the gun before Sami Paananen jammed his stack of 275,000 from the big blind. Holte called for the additional crumbs and Paananen was flipping for his tournament life.
Sami Paananen: Jan Holte:
Holte won the hand with two pair after the runout to eliminate Paananen in sixth place for €9,280. The final five players each locked up at least a €11,900 payout.
Player
Chips
Progress
Jan Holte
2,200,000
300,000
Sami Paananen
0
0
Renars Stepins Eliminated in 7th Place (€7,350) Posted Thursday 25th July, 2024 at 17:08(UTC+3) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 6/198
Momentum has turned the other way for the short stacks as they have started to lose their stacks instead of doubling (or tripling) their stacks as was the case earlier.
Renars Stepins bet 210,000 out of his 380,000 stack from under the gun. Riku Koivurinne effectively three-bet jammed from the big blind and Stepins called off the rest of his stack.
Renars Stepins: Riku Koivurinne:
Stepins wasn't able to get any love to push him ahead of his opponent's aces on the runout and headed to the cashier to collect his seventh-place prize of €7,350.
The final six players now each secured a minimum of €9,280.
Player
Chips
Progress
Riku Koivurinne
1,500,000
400,000
Renars Stepins
0
0
Gisle Olsen Eliminated in 8th Place (€6,000) Posted Thursday 25th July, 2024 at 16:54(UTC+3) by Jason Glatzer
Level 26: 30,000/60,000 (60,000) Entries: 7/198
After six doubles and one triple, a player finally ran out of gas in Denmark's Gisle Olsen.
Olsen fired out a pot-sized bet from early position for 210,000 with just 60,000 behind. Lars Romundstad three-bet shoved for 415,000 from one seat over and Olsen called off the rest of his stack after the rest of the table folded.
Gisle Olsen: Lars Romundstad:
Olsen had a decent holding but fell to Romundstad's trip deuces after the ran out on the board.
Olsen earned the eighth-place prize of €6,000, while the final seven each earned a payout ladder and will take home at least a €7,350 prize.
Player
Chips
Progress
Jan Holte
1,900,000
0
Jussi Mattila
1,100,000
400,000
Riku Koivurinne
1,100,000
0
Lars Romundstad
835,000
420,000
Renars Stepins
380,000
130,000
Sami Paananen
335,000
150,000
Stanislovas Vinicenka
250,000
335,000
Gisle Olsen
0
0
16:47 (UTC+3)
Start of Level 26 Blinds: 30,000/60,000 Ante: 60,000
Updated Chip Counts Posted Thursday 25th July, 2024 at 16:46(UTC+3) by Jason Glatzer
Player
Chips
Progress
Jan Holte
1,900,000
0
Riku Koivurinne
1,100,000
280,000
Jussi Mattila
700,000
125,000
Stanislovas Vinicenka
585,000
105,000
Renars Stepins
510,000
170,000
Sami Paananen
485,000
25,000
Lars Romundstad
415,000
125,000
Gisle Olsen
270,000
125,000
Olsen Triples Up Posted Thursday 25th July, 2024 at 16:41(UTC+3) by Jason Glatzer
Level 25: 25,000/50,000 (50,000) Entries: 8/198
The final table has witnessed six double-ups and one triple-up. So far, no eliminations as the short stacks keep getting some love.
Gisle Olsen jammed his stack of 115,000 from under the gun with and was called by Riku Koivurinne from the small blind with and Jan Halte with from the big blind.
Holte improved to Broadway on the flop and got Koivurinne to fold his flush draw after betting 395,000.
The flush would have came for the side pot on the turn but the main pot was destined to go to Olsen from the start with the river improving him to a full house to triple his stack.
Player
Chips
Progress
Jan Holte
1,900,000
100,000
Riku Koivurinne
820,000
165,000
Gisle Olsen
395,000
280,000
Updated Chip Counts Posted Thursday 25th July, 2024 at 16:37(UTC+3) by Jason Glatzer
Player
Chips
Progress
Jan Holte
1,800,000
200,000
Riku Koivurinne
985,000
215,000
Stanislovas Vinicenka
690,000
0
Renars Stepins
680,000
100,000
Jussi Mattila
575,000
100,000
Lars Romundstad
540,000
0
Sami Paananen
510,000
0
Gisle Olsen
115,000
20,000
Paananen Doubles Through Vinicenka Posted Thursday 25th July, 2024 at 16:33(UTC+3) by Jason Glatzer
Level 25: 25,000/50,000 (50,000) Entries: 8/198
The double-up theme continued as now the shorter stacks are six-for-six after Sami Paananen doubled through Stanislovas Vinicenka as follows:
Vinicenka opened for 150,000 from the small blind. Paananen three-bet shoved for 230,000, and Vinicenka called.
Sami Paananen: Stanislovas Vinicenka:
It wasn't the cleanest board for a set, but a set of snowmen kept Paananen alive and doubled his stack after the rolled out on the board.
Player
Chips
Progress
Stanislovas Vinicenka
690,000
230,000
Sami Paananen
510,000
230,000
16:28 (UTC+3)
Start of Level 25 Blinds: 25,000/50,000 Ante: 50,000
Vinicenka Doubles Again Posted Thursday 25th July, 2024 at 16:27(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
It's been an unbelievable run for the short stacks with five doubles and no eliminations taking place during the first blind level of the final table. Stanislovas Vinicenka was the first to double twice.
Lars Romundstad opened for 125,000 from the cutoff before Vinicenka defended his big blind.
Vinicenka checked before he called off his stack of 305,000 after facing an effective jam by Romundstad.
Stanislovas Vinicenka: Lars Romundstad:
Both players had trips with the same nut-kicker. However, Romundstad had better equity with the flush draw. The turn changed the outcome instantly as Vinicenka improved to a full house and only a two outer for an ace on the river would lead to a chop.
The river did push Romundstad to a flush. However, this wasn't enough, and Vinicenka, after starting the day with crumbs, was in the middle of the pack.
Player
Chips
Progress
Stanislovas Vinicenka
920,000
550,000
Lars Romundstad
540,000
530,000
Koivurinne Makes it Four for Four on First Blind Level Doubles Posted Thursday 25th July, 2024 at 16:19(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
Jan Holte opened for 125,000 from the hijack. Riku Koivurinne three-bet jammed for 335,000 from the cutoff and was called by Holte after the action folded back around.
Riku Koivurinne: Jan Holte:
Koirvurinne doubled his stack after his queens were good on the low runout to make it the fourth double-up during the first blind level of the final table.
Player
Chips
Progress
Jan Holte
2,000,000
395,000
Riku Koivurinne
770,000
415,000
Vinicenka's Turn to Double Posted Thursday 25th July, 2024 at 16:09(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
There have been three players thus far that have committed their stacks, and so far, it has been three for three for the shorter stacks.
Lithuania's Stanislovas Vinicenka bet 140,000 of his 155,000 stack from the hijack and was called by Denmark's Gisle Olsen from the big blind.
The fest of the chips went in on the flop.
Stanislovas Vinicenka: Gisle Olsen:
Vinicenka flopped trips, and that was all it took to double his stack after the turn and river completed the board.
Meanwhile, Gisle Olsen finds himself short on chips after previously doubling Renars Stepins before now doubling Vinicenka.
Player
Chips
Progress
Stanislovas Vinicenka
370,000
215,000
Gisle Olsen
135,000
195,000
Paananen Doubles Through Koivurinne Posted Thursday 25th July, 2024 at 16:02(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
Sami Paananen was down to under three big blinds when he jammed for 110,000 from the button. Riku Koivurinne didn't have a great hand but the price felt right for him to call.
Sami Paananen: Riku Koivurinne:
Koivurinne was ahead after the rainbow flop and Paananen needed an ace, king, ten, or nine on the river after the turn in order to survive.
The timely river saved the day for Paananen who doubled his stack through Koivurinne instead of becoming the first player to his the rail.
Player
Chips
Progress
Riku Koivurinne
355,000
150,000
Sami Paananen
280,000
150,000
Stepins Doubles Through Olsen Posted Thursday 25th July, 2024 at 15:49(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
Gisle Olsen min-raised from early position with . Renars Stepins three-bet nearly all of his stack with a pot-sized bet of 300,000 with from the hijack. Olsen called off nearly half his stack.
Olsen put Stepins in for his final 40,000 on the flop with Renars kings still holding strong.
Stepins had Olsen drawing dead to his full house on the turn and officially doubled his stack after the river completed the board.
Player
Chips
Progress
Renars Stepins
780,000
440,000
Gisle Olsen
330,000
340,000
Short Stacks Get Shorter Posted Thursday 25th July, 2024 at 15:46(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
There haven't been any flops as of yet, but the short stacks are now shorter, and the chip leader has grown his stack during the first few hands.
Player
Chips
Progress
Jan Holte
2,395,000
100,000
Lars Romundstad
1,070,000
0
Jussi Mattila
675,000
20,000
Gisle Olsen
670,000
0
Riku Koivurinne
505,000
0
Renars Stepins
340,000
100,000
Stanislovas Vinicenka
155,000
100,000
Sami Paananen
130,000
80,000
Cards in the Air Posted Thursday 25th July, 2024 at 15:32(UTC+3) by Jason Glatzer
Level 24: 20,000/40,000 (40,000) Entries: 8/198
Cards are in the air for the final table of the €1,100 PLO 4&5 ring event at Olympic Park Casino and the Hilton Tallinn Park. As a reminder, you can watch the stream with George Sandford and guests commentating on the action on a 30-minute delay. We promise to recap the biggest hands and bad beats throughout the day. So the choice is yours!
15:27 (UTC+3)
Day 2 of Olympic Park Casino Started Level: 24 Blinds: 20,000/40,000 Ante: 40,000
The Trip Leader! Posted Thursday 25th July, 2024 at 13:39(UTC+3) by Matthew Summers
Book Tournament Travel with The Trip Leader!
- Mobile-Friendly Website
- Competitive Prices
- Pay Now or Pay When You Stay
- ATOL Protected Flights
- Geo-Locate Hotels & Airports
- Packages & Buy-Ins
- Exclusive Promotions & Offers
- Select Display Language
- Multiple Currencies & Payment Options
- Easily View and Amend Trips
Jan Holte Kicks Off Event #7: €1,100 PLO 4&5 With Substantial Lead Posted Thursday 25th July, 2024 at 12:57(UTC+3) by Jason Glatzer
The €1,100 PLO 4&5 broke records in Tallinn for a €1,100 buy-in Omaha event. On its opening day, 198 entries generated a €190,800 prize pool.
The start time of Day 2 was pushed back to 2 p.m. as the action went late into the night until 2019 WSOP Europe 8-Game bracelet winner Espen Sandvik hit the rail on the official final table bubble in ninth place for €5,100.
The final eight players locked up at least €6,000, with much more to come as the payout ladders count at this game stage.
Norway's Jan Holte (pictured above) holds a substantial lead on the field, more than double his nearest opponent with 2,295,000. This is good for 57 big blinds to start, with the action kicking off with 28 minutes remaining on Level 24 with blinds at 20,000/40,000 with a 40,000 big blind ante. Blinds will be 30 minutes long after Level 24 is completed until a winner is crowned.
Norway is favored to win this event based on opening chip counts. The only other chip millionaire to kick things off was Norway's Lars Romundstad, who catapulted his 30,000 opening stack into 1,070,000.
Three Finns are in the mix, but none with huge stacks. Long-time Olympic Park Casino player Jussi "Potti-Jussi" Mattila tops the Finnish charts with 695,000, with Riku Koivurinne (505,000) and Sami Paananen (210,000) coming in a bit shorter.
Also in the mix are Denmark's Gisle Olsen (670,000), Lithuania's Stanislovas Vinicenka (255,000), and Latvia's Renars Stepins (240,000).
Anything can happen in PLO, especially during the five-card rounds. So no lead is safe in what promises to be an exciting day with the players vying for the €44,500 and the coveted WSOP Circuit gold ring. Additionally, the winner will be invited for a chance at a WSOP bracelet for free in the $1 million guaranteed Tournament of Champions Freeroll next summer.
George Sandford will be commenting on the action with various guests throughout the day at OlyBet.tv. You will also get updates on all the biggest hands at the final table on the OlyBet blog.
Best of luck to all the players, and stay tuned with reporting starting at around 2:30 p.m. local time when the action kicks off on the stream.
Final Table Seat Draw Posted Thursday 25th July, 2024 at 12:56(UTC+3) by Jason Glatzer
Seat
Name
Country
Chips
Big Blinds
1
Renars Stepins
Latvia
240,000
6
2
Jussi Mattila
Finland
695,000
17
3
Stanislovas Vinicenka
Lithuania
255,000
6
4
Sami Paananen
Finland
210,000
5
5
Jan Holte
Norway
2,295,000
57
6
Riku Koivurinne
Finland
505,000
13
7
Gisle Olsen
Denmark
670,000
17
8
Lars Romundstad
Norway
1,070,000
27
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.