0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0104 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-12-19' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event7' ORDER BY `views` DESC

0.0168 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-12-19' AND `url` = 'https://www.maineventtravel.com/live-reporting/2024_wsop_tallinn_event7'

0.0004 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'USD'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'GBP' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'USD' AND `currency_iso_to` = 'EUR'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'GBP'

0.0002 SECONDS:
SELECT `rate` FROM `exchange_rates` WHERE `currency_iso_from` = 'EUR' AND `currency_iso_to` = 'USD'

0.0004 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.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0006 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.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 `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0006 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.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` = 'page'

0.0043 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.0007 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.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '143'

0.0292 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0066 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '346' AND `published` = 1

0.0066 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.0005 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '143' AND `name` = '2'

0.0061 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.0069 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.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` = '15160' 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` = '15159' 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` = '15158' 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` = '15149' 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` = '15147' 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` = '15146' 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` = '15145' ORDER BY `chip_change` DESC, `busted` ASC

0.0112 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0119 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0115 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0112 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0081 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0074 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '15130' ORDER BY `chip_change` DESC, `busted` ASC

0.0080 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '15128' 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` = '15124' 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` = '15122' 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` = '15120' 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` = '15118' 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` = '15116' 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` = '15114' 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` = '15113' 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` = '15110' 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` = '15109' 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` = '15107' 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` = '15106' 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` = '15105' 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` = '15102' 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` = '15099' 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` = '15097' 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` = '15094' 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` = '15092' 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` = '15087' 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` = '15086' 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` = '15059' 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` = '15053' 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` = '15054' 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` = '346' ORDER BY `busted` ASC, `current_chips` DESC

0.0059 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.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` = '15160' 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` = '15159' 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` = '15158' 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` = '15149' 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` = '15147' 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` = '15146' 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` = '15145' 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` = '15143' 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` = '15142' 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` = '15137' 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` = '15153' 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` = '15131' 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` = '15130' 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` = '15127' 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` = '15128' 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` = '15124' 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` = '15122' 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` = '15120' 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` = '15118' 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` = '15116' 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` = '15114' 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` = '15113' 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` = '15110' 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` = '15109' 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` = '15107' 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` = '15106' 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` = '15105' 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` = '15102' 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` = '15099' 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` = '15097' 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` = '15094' 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` = '15092' 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` = '15087' 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` = '15086' 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` = '15059' 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` = '15053' 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` = '15054' ORDER BY `chip_change` DESC, `busted` ASC

0.0058 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.0005 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2553

English
Olympic Park Casino Event #7: €1,100 PLO4&5 Live Reporting - Day 2

Current Level 28 Current Day 2
Blinds 50,000/100,000 Ante 100000
Entries 198 Remaining 1
Prize Pool (EUR) €190,800 First Prize (EUR) €41,200
1 New Update - Click to refresh
Live Updates - Day 2
22:32 (UTC+3)
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

#FinalTableFreeroll

 

MainEventTravel.com's Exclusive Added Value Promotion!

 

Win back up to 100% of Tournament Travel booked with MET in Eligible Events!

 

Head to MainEventTravel.com > Promotions for full details.

 

#FinalTableFreeroll

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 . More 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.