0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0081 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event8' ORDER BY `views` DESC

0.0112 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-09' AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event8'

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

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

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

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

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

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

0.0003 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0004 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0003 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0003 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.0059 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` = 'wsopctallinn_2023_event8'

0.0003 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '35'

0.0286 SECONDS:
SELECT `content` FROM `tour_stop_blog_day_posts` WHERE `content` LIKE "%
0.0058 SECONDS:
SELECT COUNT(*) AS `numrows` FROM `tour_stop_blog_day_posts` WHERE `tour_stop_blog_day_id` = '127' AND `published` = 1

0.0001 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `id` = '127'

0.0004 SECONDS:
SELECT * FROM `tour_stop_blog_days` WHERE `tour_stop_blog_id` = '35' AND `name` = '1'

0.0061 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '127' ORDER BY `busted` ASC, `current_chips` DESC

0.0064 SECONDS:
SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name` FROM `tour_stop_blog_day_posts` LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id` WHERE `tour_stop_blog_day_posts`.`published` = 1 AND `tour_stop_blog_day_id` = '127' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '5594' 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` = '5490' 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` = '5489' 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` = '5488' 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` = '5487' 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` = '5486' 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` = '5485' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5482' 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` = '5484' 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` = '5481' 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` = '5478' 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` = '5480' 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` = '5479' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5477' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5475' 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` = '5476' 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` = '5474' 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` = '5469' 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` = '5473' 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` = '5472' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5470' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5471' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5468' 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` = '5467' 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` = '5466' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5465' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5464' 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` = '5462' 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` = '5461' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5460' 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` = '5459' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5458' ORDER BY `chip_change` DESC, `busted` ASC

0.0113 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5456' ORDER BY `chip_change` DESC, `busted` ASC

0.0113 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5455' ORDER BY `chip_change` DESC, `busted` ASC

0.0110 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5454' 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` = '5453' ORDER BY `chip_change` DESC, `busted` ASC

0.0083 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5451' 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` = '5449' 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` = '5447' 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` = '5450' 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` = '5445' 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` = '5439' 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` = '5438' 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` = '5435' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5431' 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` = '5422' 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` = '5421' 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` = '5410' 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` = '5403' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5401' 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` = '5400' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5399' 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` = '5389' 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` = '5386' 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` = '5382' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '127' ORDER BY `busted` ASC, `current_chips` DESC

0.0057 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` = '127' ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC

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` = '5594' 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` = '5490' 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` = '5489' 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` = '5488' 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` = '5487' 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` = '5486' 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` = '5485' ORDER BY `chip_change` DESC, `busted` ASC

0.0071 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5482' 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` = '5484' ORDER BY `chip_change` DESC, `busted` ASC

0.0089 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5481' 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` = '5478' 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` = '5480' 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` = '5479' 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` = '5477' 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` = '5475' 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` = '5476' 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` = '5474' 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` = '5469' 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` = '5473' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5472' 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` = '5470' 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` = '5471' 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` = '5468' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5467' 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` = '5466' 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` = '5465' 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` = '5464' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5463' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5462' 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` = '5461' 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` = '5460' 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` = '5459' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5458' 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` = '5456' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5455' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5454' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5453' 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` = '5451' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5449' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5447' 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` = '5450' 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` = '5445' 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` = '5439' 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` = '5438' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5435' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5431' 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` = '5422' 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` = '5421' 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` = '5410' 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` = '5403' 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` = '5401' 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` = '5400' 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` = '5399' ORDER BY `chip_change` DESC, `busted` ASC

0.0059 SECONDS:
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code` FROM `tour_stop_blog_day_post_progress` LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id` WHERE `tour_stop_blog_day_post_id` = '5389' 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` = '5386' 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` = '5382' ORDER BY `chip_change` DESC, `busted` ASC

0.0057 SECONDS:
SELECT `tour_stop_blog_day_players`.* FROM `tour_stop_blog_day_players` WHERE `tour_stop_blog_day_id` = '127' ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS:
SELECT * FROM `tour_stop_blogs` WHERE `active` = 1 AND `tour_stop_id` = 2143

English
WSOPC Tallinn Event #8: €1,100 PLO / PLO5 Live Reporting - Day 1
1 New Update - Click to refresh
Live Updates - Day 1
Norwegian Jon Kyte Wins Event #8: €1,100 PLO/PLO5 (€34,780) Posted Thursday 21st September, 2023 at 17:41(UTC+0) by Lina Olofsson

As one of two Norwegians in the field when the 2023 WSOPC Tallinn Event #8 €1,100 PLO 4&5 started in a field dominated by Finnish players Jon Kyte might have been outnumbered but experience-wise, he surely wasn't. With over one million euros in tournament winnings and €226,505 so far this year he already had proven himself to be one of the names to keep an eye out on. And taking advantage of having one of the biggest stacks on the bubble as we reached the last 18 players left off the field he never looked back and didn't give away that lead until they were heads-up for the circuit ring even if it was just for one hand before he took it back and then eliminated his last opponent taking home the first prize of €34,780 the glorious golden WSOPC ring along with it. 

The Land of the Mumin Trolls Dominated the Field 

As the tournament started at noon the field wasn't even up to 20 players but after the first break, we had almost 100 entries in the field and landed on 143 in total. We described it as "High Chaparral" for the first ten levels of the tournament as players were tossing their chips around all the time and plenty of them fired a second or a third bullet in this €1,100 PLO/PLO5. But Jon Kyte wasn't one of them as he took his seat in a satellite the night before and only paid €60 to enter the tournament. During the satellite, he took a massage and as it was finished he asked the masseuse if she wanted to have 5% in him in the tournament instead of him paying for it and she said yes. 

During the final table yesterday we saw her rooting for him all the way and as he won she was probably the loudest voice of them all cheering for his win as she ended up getting €1,739 for her percent in the Norwegian and probably could take the rest of the week off. 

Outnumbered Maybe But This Was Kyte's Day

To say Kyte was outnumbered is not an understatement with 85 players in total from the land of the Mumin trolls and luxurious designs - Finland giving us a prize pool of €137,280 to play for. 

Down to the last three tables, the players started to smell the scent of the money with 17 getting paid at least €2,250 for their efforts, and the very last player to bust before the money was Mohammed Halafi who was eliminated by Kyte in a round of five cards Omaha getting his money in on the flop with top pair which was in huge favour for Kyte who both had an open-ended straight flush draw and two pair. The turn gave Kyte the straight and sent his opponent to the rail as he started his journey toward that golden ring and after that, he never looked back. 

Huge Lead Going Into the Final Table 

After eliminating Kai Lehto in 12th Kyte was the first player with over a million in chips and when they reached the final table he had one million more than Janne Peltoniemi in second place. When the final started we had six out of the eight from Finland but the Kyle machinery continued his strike eliminating the first player as we reached the final as he busted Matias Knaapinen in eighth place (€4,700).

The final table started well for our Estonian Igor Pihela Jr. as he first sent the well-renowned Juha Helppi to the rail for a seventh-place finish worth €5,850. The odds got even worse having a Finnish victory when he took out Olli Kokko in sixth place (€7,200). But down to the final five players, it started to go downhill for Pihela and after losing several big hands he was eliminated by Janne Peltoinemi for a €9,000 payday. 

The play would go on for more than an hour with the four remaining players and by now Finland actually were three against the one Norwegian so could it finally be a victory for the Finns who's been so, so close in several events but always fell on the target string. In event #4 Deuce to Seven Triple Draw they had five out of the seven at the final table but had to see themselves beaten as Martin Rafael Lategui Lourido from Cyprus walked away with the golden ring. 

This was really the day of Jon Kyte from start to finish at the final table even if it would take a little over 16 hours from start to finish and three hours on the final table only. After eliminating Janne Peltoniemi in fourth place (€11,800), and Jari Petteri Kalenius in third (€15,950) he was in the lead as we reached heads-up between Kyte and Olli Rummukainen. This was the first time at the final table that Kyte actually would give away his lead but that only lasted one hand before he took it back and the hand after that it was all over and he had eliminated yet another Finn earning himself that WSOP Circuit golden ring here in event #8 here in Tallinn. 

A huge congratulations to the Norwegian for a fantastic performance and thank you for the show you gave us all! 

Event #8: €1,100 PLO/PLO5 Final Table Results

Place

Name

Country

Prize

1

Jon Kyte

Norway

€34,780

2

Olli Rummukainen

Finland

€23,250

3

Jari Petteri Kalenius

Finland

€15,950

4

Janne Peltoniemi

Finland

€11,800

5

Igor Pihela (Jr)

Estonia

€9,000

6

Olli Kokko

Finland

€7,200

7

Juha Helppi

Finland

€5,850

8

Matias Knaapinen

Finland

€4,700

Article author: Lina Olofsson
Photo credits: Elena Kask

Jon Kyte Won the 2023 WSOPC Tallinn Event #8 for €34,780 Posted Thursday 21st September, 2023 at 02:42(UTC+0) by Lina Olofsson

With almost 80 percent Finns in this tournament the odds surely was in the blue and white nations favor but as we were down to the final eight players it was domination nation for Norway all the way through the end as Jon Kyte took home the eight WSOPC golden ring here at Olympic Casino and Hilton Park after more than 16 hours of play. 

A huge congratulations to Kyte who walks away with €34,780 for his efforts.

Olli Rummukainen Eliminated in Second Place (€23,250) Posted Thursday 21st September, 2023 at 02:37(UTC+0) by Lina Olofsson

Level 24: 25,000/50,000 (50,000)
Entries: 1/143

Just before the last break of the tournament Jon Kyte would loose the chip lead for the very first time since he sat down on the final table here but it wouldn't last for more than a hand as he doubled up against Olli Rummukainen and a few hands later they went all-in before the flop with five cards each on their hand. 

Kyte:
Rummukainen:

As the board ran out Kyte got a straight sending his opponent in second. For his silver medal the Finn Olli Rummukainen cashed €23,250. 

Player Chips Progress
Olli Rummukainen 0 0
Jari Petteri Kalenius Eliminated in Third Place (€15,950) Posted Thursday 21st September, 2023 at 02:29(UTC+0) by Lina Olofsson

Level 24: 25,000/50,000 (50,000)
Entries: 2/143

With three players left Jari Petteri Kalenius had a rough path in particular against our Norwegian in the field and after doubling up his fellow countrymen Olli Rummukainen he was the player at risk when he got his last chips in against the Norwegian Kyte before the flop. 

Kalenius:
Kyte:

The board ran out giving Kyte the straight and sending our second-last Finn out from the tournament in third place for €15,950.

Player Chips Progress
Jari Petteri Kalenius 0 0
Janne Peltoniemi Eliminated in 4th place (€11,800) Posted Thursday 21st September, 2023 at 01:54(UTC+0) by Lina Olofsson

Level 24: 25,000/50,000 (50,000)
Entries: 3/143

After a raise from our chip leader Jon Kyte from the button Finnish Janne Peltoniemi pushed his last 250K chips over the line and was called. 

Peltoniemi:
Kyte:

The flop of put Kyte in favour and on the turn it was all over and as the dealer put the on the river Peltoniemi was already on his way up from the chair leaving the final table in fourth position with €11,800 on the pay check. 

Player Chips Progress
Janne Peltoniemi 0 0
01:52 (UTC+0)
Start of Level 22
Blinds: 15,000/30,000     Ante: 30,000
Igor Pihela (Jr) Eliminated in 5th Place (€9,000) Posted Thursday 21st September, 2023 at 00:44(UTC+0) by Lina Olofsson

Level 21: 10,000/25,000 (25,000)
Entries: 4/143

After eliminating Olli Kokko Igor Pihela (Jr) lost a few hands in a row and was suddenly the short stack on the final table as he looked down on and got all-in against Peltoinemi before the flop with 345K in his stack. He was a slight favorite before the flop against the Finn's

The board ran out and Pihela (Jr) was our fifth-place finisher with a €9,000 paycheck. 

Player Chips Progress
Igor Pihela (Jr) 0 0
00:29 (UTC+0)
Start of Level 21
Blinds: 10,000/25,000     Ante: 25,000
Olli Kokko Eliminated in 6th Place (€7,200) Posted Thursday 21st September, 2023 at 00:27(UTC+0) by Alaxandar Georgiev

Level 20: 10,000/20,000 (20,000)
Entries: 5/143

Olli Kokko picked up a hand on the cut-off and raised to 70,000, but only had that much left behind. Igor Pihela (Jr.) three-bet again from the button and Kokko called.

Olli Kokko:
Igor Pihela (Jr.):

Crazy flop as the dealer revealed which gave Kokko trip-Tens and a flush draw + open-ended straight draw for Pihela. 

Kokko was ahead till the turn which completed the flush for Pihela. The river didn't get Kokko a full house and he lost the hand.

Olli Kokko was eliminated in 6th Place and collected €7,200.

Player Chips Progress
Igor Pihela (Jr) 845,000 220,000
Olli Kokko 0 0
First Blow To Jon Kyte Posted Thursday 21st September, 2023 at 00:15(UTC+0) by Alaxandar Georgiev

Jon Kyte had almost two million chips going into this pot where he found himself calling an all-in from Janne Peltoniemi for 350,00 after some action on the flop.

Jon Kyte:
Janne Peltoniemi:

Top set for Peltoniemi against an open-ended straight draw for Kyte.

The turn and the river bricked for Kyte as the dealer put and .

Big scoop for Peltoniemi to make him second in chips.

Player Chips Progress
Jon Kyte 1,500,000 100,000
Janne Peltoniemi 880,000 255,000
23:59 (UTC+0)
Start of Level 20
Blinds: 10,000/20,000     Ante: 20,000
Juha Helppi Eliminated in 7th Place (€5,850) Posted Wednesday 20th September, 2023 at 23:59(UTC+0) by Alaxandar Georgiev

Level 19: 10,000/20,000 (20,000)
Entries: 6/143

Short-stacked Juha Helppi raised to 70,000 leaving himself 150,000 behind. Igor Pihela (Jr.) three-bet from the button to 240,000 and Helppi made the call.

Juha Helppi:
Igor Pihela  (Jr.):

Both were with similar odds of winning the pot until the dealer revealed the  flop. Pihela flopped a straight and Helppi was drawing thin. The turn gave the Finn some outs for a full house, but none of those came on the river.

Juha Helppi eliminated in 7th place (€5,850).

Player Chips Progress
Igor Pihela (Jr) 625,000 315,000
Juha Helppi 0 0
Matias Knaapinen Eliminated in 8th Place (€4,700) Posted Wednesday 20th September, 2023 at 23:43(UTC+0) by Lina Olofsson

Level 19: 10,000/15,000 (15,000)
Entries: 7/143

Our chip leader Jon Kyte raises to 35K and Matias Knaapinen with 255K behind makes the call. 

Flop comes and the players get all their chips in the middle and we have a showdown: 
Knaapinen:
Kyte:

So we have two pairs for our Finn at risk and the nut flush draw for Kyte. Turn doesn't change anything but the river gives the Norwegian the flush and Knaapinen is eliminated from the final table in eight for €4,700.  

Player Chips Progress
Matias Knaapinen 0 0
Final Table Chip Counts Posted Wednesday 20th September, 2023 at 23:34(UTC+0) by Alaxandar Georgiev

Check out the Final Table chip count update below.

Jon Kyte continued his domination and increased his chip lead to a whopping 1,600,000 chips stack having almost a million chips more than Janne Peltoniemi in second (625,000).

Olli Kokko lost 630,000 pot against Jari Kalenius on the first hand of the final table and was left with 330,000 to play with.


Player Chips Progress
Jon Kyte 1,600,000 300,000
Janne Peltoniemi 625,000 355,000
Jari Petteri Kalenius 530,000 253,000
Olli Kokko 330,000 315,000
Igor Pihela (Jr) 310,000 99,000
Matias Knaapinen 285,000 7,000
Juha Helppi 200,000 74,000
Olli Rummukainen 116,000 205,000
Okada Gets a Beat on The Final Table Bubble Posted Wednesday 20th September, 2023 at 23:20(UTC+0) by Lina Olofsson

Level 19: 10,000/15,000 (15,000)
Entries: 8/143

It looked like a possible chop pot when the money went in between Olli Kokko and Ken Okada before the flop.

Kokko:
Okada:

After the flop it was a bit of favour to our player at risk Okada but then hit turn and came on the river he was eliminated in ninth place for €3,750 and we have our final eight finalists in this event.

Player Chips Progress
Ken Okada 0 0
23:15 (UTC+0)
Start of Level 19
Blinds: 10,000/15,000     Ante: 15,000
Huge Overlay in the Midnight Satellite Posted Wednesday 20th September, 2023 at 23:00(UTC+0) by Lina Olofsson

We have another Mega-Satellite to the Main Event for tomorrow with 15 seats guaranteed. The buy-in is €150 and as we speak there are only 74 players bought in which leaves it with a huge overlay so if you're around pop by and take a shot! 

Rummukainen Doubles Up Posted Wednesday 20th September, 2023 at 22:57(UTC+0) by Alaxandar Georgiev

Level 18: 6,000/12,000 (12,000)
Entries: 10/143

Igor Pihela(Jr) raised 30,000 from under the gun and got re-raised from Olli Rummukainen to 102,000 from the small blind, leaving himself 56,000 behind. Igor announced all in and Rummukainen called.

Igor Pihela (Jr.):
Olli Rummukainen:

The flop gave Pihela a flush draw, but the turn locked up the pot for Rammukainen completing his full-house.

Player Chips Progress
Olli Rummukainen 321,000 269,000
Igor Pihela (Jr) 149,000 158,000
Kurko Busts In The Battle Of The Draws Posted Wednesday 20th September, 2023 at 22:53(UTC+0) by Alaxandar Georgiev

Level 18: 6,000/12,000 (12,000)
Entries: 10/143

Kimmo Kurko opened to 30,000 from the cut-off and once again Olli Kokko called from the button. 

The flop was bound to have some action and it did. A check-raise all-in from Kurko after a quick bet from Kokko for 50,000 chips.

Kimmo Kurko:
Olli Kokko:

Kurko had the better flush draw, but his opponent had already made a two-pair and was blocking his spades.

The turn was , Kurko was looking for some big cards or a spade on the last card but got none on the river.

Kimmo Kurko is eliminated in 11th place and will collect €3 050.

Player Chips Progress
Olli Kokko 645,000 213,000
Kimmo Kurko 0 0
Lehto busts against Kyte Posted Wednesday 20th September, 2023 at 22:29(UTC+0) by Lina Olofsson

Level 18: 6,000/12,000 (12,000)
Entries: 11/143

Over at the feature table, we just saw another player eliminated from the tournament by our chip leader Jon Kyte. 

It was before the flop all the money went in for Kai Lehto with against Kyte's

The board ran out and our Norwegian player added another couple of hundreds to his lead.

Jon Kyte

Player Chips Progress
Jon Kyte 1,026,000 180,000
Kai Lehto 0 0
Swede Gronvik Bites the Dust Posted Wednesday 20th September, 2023 at 22:11(UTC+0) by Lina Olofsson

Level 18: 6,000/12,000 (12,000)
Entries: 12/143

Kimmo Kurko raised to 35K under the gun and the only Swede in the tournament - Mikael "Greenbay" Gronvik pushed all-in for his last 68K. Action was folded around to Kurko who made the call. And we had our Swede at risk as the players turned over their hands. 

Gronvik:
Kurko:

The board ran out and Mr Greenbay exited the tournament in for a 13th place finish and a €2,600 payday. 

Player Chips Progress
Mikael Gronvik 0 0
22:01 (UTC+0)
Start of Level 18
Blinds: 6,000/12,000     Ante: 12,000
Antikainen Finishes The Tournament Posted Wednesday 20th September, 2023 at 21:41(UTC+0) by Alaxandar Georgiev

Level 17: 5,000/10,000 (10,000)
Entries: 13/143

Jari Petteri Kalenius raised from the button to 25,000 and Henri Antikainen defended from the big blind. 

The flop was quickly checked by Antikainen, followed by a 30,000 bet from Kalenius - Antikainen didn't hesitate and pushed his remaining 169,000 chips in the middle. Kalenius had some time to decide, but in the end, called the all-in.

Henri Antikainen:
Jari Petteri Kalenius:

Antikainen had a King-high flush draw and a pair and his opponent had top two pair with the ace and the jack.

The turn didn't give Antikainen the needed spade, nor the river.

Henri Antikainen finishes the tournament in 14th and claims the prize of €2,600.

Player Chips Progress
Jari Petteri Kalenius 783,000 174,000
Henri Antikainen 0 0
21:20 (UTC+0)
Start of Level 17
Blinds: 5,000/10,000     Ante: 10,000
Chip Count Update Final 16 Posted Wednesday 20th September, 2023 at 21:16(UTC+0) by Alaxandar Georgiev

Jon Kyte and Olli Kokko are both leading the battle for the PLO 4&5 ring. There are also  four people with under ten big blind, who will be looking to double their way up.

Player Chips Progress
Jon Kyte 846,000 16,000
Olli Kokko 772,000 562,000
Jari Petteri Kalenius 461,000 218,000
Jari Petteri Kalenius 391,000 148,000
Igor Pihela (Sr) 307,000 48,000
Matias Knaapinen 292,000 142,000
Ken Okada 279,000 121,000
Juha Helppi 234,000 97,000
Henri Antikainen 169,000 38,000
Mikael Gronvik 128,000 23,000
Kai Lehto 117,000 17,000
Vladislavs Petrovs 109,000 12,000
Jose Koistinen 63,000 34,000
Olli Rummukainen 52,000 8,000
Kimmo Kurko 45,000 71,000
Seppo Paavo Parkkinen 27,000 160,000
Final Two-Tables Re-Draw Posted Wednesday 20th September, 2023 at 20:48(UTC+0) by Alaxandar Georgiev

Niki Nurmisto was just eliminated in 17th place and we are down to the last 16 players and two final tables. The remaining players will be seated at the main and feature table after a short break.

Player Chips Progress
Niki Nurmisto 0 0
The Bubble Burst Posted Wednesday 20th September, 2023 at 20:45(UTC+0) by Alaxandar Georgiev

Another three-way pot involving Jon Kyte and two other players, one of them being Mohammed Halafi who defended Kyte's raise to 30,000 from the big blind. With only 90,000 chips left behind Halafi announced he was all-in on the flop, followed by a snap call from Kyte.

Mohammed Halafi: 
Jon Kyte:

Svenberg had a top pair and the queen-high flush draw, while Kyte had an open-ended straight flush draw.

The turn was which completed Kyte's straight and the river meant that Halafi was eliminated in 18th place.

All of the remaining 17 players are guaranteed at least €2,150.

Player Chips Progress
Jon Kyte 830,000 162,000
Mohammed Halafi 0 0
Good Hand For Antikainen Posted Wednesday 20th September, 2023 at 20:17(UTC+0) by Alaxandar Georgiev

Level 16: 4,000/8,000 (8,000)
Entries: 19/143

Henri Antikainen put all of his 53,000 remaining chips in the middle from under the gun and got a call from Mikael Gronvik.

Mikael Gronvik:
Henri Antikainen:

To the flop which was more than Antikainen could've hoped for as he was dominated pre-flop. Open-ended and with the nut flush-draw he had a lot of outs to win the hand.

The turn locked the hand for him, with the river being which completed his flush as well.

Player Chips Progress
Henri Antikainen 126,000 121,000
Mikael Gronvik 105,000 95,000
20:12 (UTC+0)
Start of Level 16
Blinds: 4,000/8,000     Ante: 8,000
Ken Okada Doubles Up Twice Posted Wednesday 20th September, 2023 at 19:59(UTC+0) by Alaxandar Georgiev

Level 15: 3,000/6,000 (6,000)
Entries: 22/143

Two action hands in a row for Ken Okada. On the first hand he managed to double up with against Jon Kyte's his Aces won over the hand and he doubled to Almost 200,000 chips.

Next hand Okada raised 15,000 from an early position, followed by a call from Markku Koplimaa and Jose Koistinen.

We had a three-way flop, Okada bet 30,000 and Koplimaa jammed it all in. Okada snap called and we went to showdown.

Ken Okada:
Markku Koplimaa:

Okada flopped the nut straight and was ahead against Koplimaa's two-pair. The turn and the river didn't give Koplimaa the full house, nor the split, and he was left with only one chip worth 1,000.

Shortly after Koplima busted in 22th place.

Player Chips Progress
Ken Okada 400,000 310,000
Markku Koplimaa 0 0
Sahamies and Zarans Has Left the Building Posted Wednesday 20th September, 2023 at 19:53(UTC+0) by Lina Olofsson

Level 15: 3,000/6,000 (6,000)
Entries: 22/143

We just lost Ilari Sahamies and Kristaps Zarans from the tournament and are down to the final 22 players. Yet another five to go before we reach the money in this event. 

Player Chips Progress
Kristaps Zarans 0 0
Ilari Sahamies 0 0
19:48 (UTC+0)
Start of Level 15
Blinds: 3,000/6,000     Ante: 6,000
Norwegian Kyte Takes the Lead with Three Tables Left Posted Wednesday 20th September, 2023 at 19:20(UTC+0) by Lina Olofsson

Level 14: 2,000/5,000 (5,000)
Entries: 26/143

They are down the final three tables and just did a re-draw of the remaining 24 players. We think we just spotted the chip leader in the tournament as the players bagged their chips to move out to the tables right next to the feature table streamed HERE. 

Our new sheriff in town is Jon Kyte with 668,000 in his stack. 

Player Chips Progress
Jon Kyte 668,000 638,000
Markus Svanberg 350,000 320,000
25 players left Posted Wednesday 20th September, 2023 at 19:13(UTC+0) by Lina Olofsson

25 players remain in the tournament as we've reached the 14th level of today's circuit event. As soon as another player gets eliminated we are doing a re-draw on the remaining three tables. 

Don't forget to tune into our LIVE STREAM where you can follow the action from our featured table in the tournament.

25 Seats Guaranteed in the Mega-Satellite Starting Now! Posted Wednesday 20th September, 2023 at 19:09(UTC+0) by Lina Olofsson

For those of you looking at the schedule, you likely noticed a €150 Mega Satellite guaranteeing 10 seats to the WSOPC Tallinn €1,500 Main Event at 9 p.m. which just started with only 72 players in the field which gives you a great value if you are here in Tallinn and want to take the chance of making it into the Main Event. 

What you wouldn't have seen is a new satellite that popped up with some tremendous value for late-night players as at Midnight there will be an added €150 mega satellite with another 15 seats guaranteed!

Of course, Omaha lovers will still be able to enjoy Event #36: €150 PLO 4, 5, & 6 card event at 11 p.m.. This is a six-max affair, which makes perfect sense once incorporating the six-card Omaha.

Helppi on The Feature Table Posted Wednesday 20th September, 2023 at 19:05(UTC+0) by Lina Olofsson

Level 14: 2,000/5,000 (5,000)
Entries: 26/143

The action is live on our feature table where you can see the following players: 

Seat

Name

Country

Chips

1

Juha Helppi

Finland

149,000

2

Empty

3

Mohammed Halafi

Finland

233,000

4

Olli Rummukainen 

Finland

33,000

5

Jose Koistinen

Finland

143,000

6

Janne Peltoniemi

Finland

98,000

7

Markku Koplimaa

Estonia

198,000

8

Matias Knaapinen

Finland

83,000

Player Chips Progress
Mohammed Halafi 233,000 203,000
Markku Koplimaa 198,000 168,000
Juha Helppi 149,000 119,000
Jose Koistinen 143,000 113,000
Janne Peltoniemi 98,000 68,000
Matias Knaapinen 83,000 53,000
Olli Rummukainen  33,000 3,000
18:39 (UTC+0)
Start of Level 14
Blinds: 2,000/5,000     Ante: 5,000
Good Odds for a Finnish Victory Posted Wednesday 20th September, 2023 at 18:20(UTC+0) by Lina Olofsson

As we've previously mentioned it's been a pretty crazy day until the registration closed where it's been hard to keep track of all the action. And to be honest a chip leader could easily be heading out the door a few hands later. 

This could almost be called the Finnish Championship with the majority of Finns in the field. If the former EPT media coordinator Mad Harper had been here we would have been giving you a pretty fun pie chart of it all but 95 of the entries had a Finnish flag of the total 143 so you could do the math yourselves. But the chances of a blue and white player finally taking it down (after being very close in several events) look good since 22 out the 32 remaining players are from Finland. But let's not take anything in advance since they had five out of the finalists in yesterday's 8-game final and didn't get all the way there but let's hope they'll do better this time. 

A few of the most familiar faces in the field are Juha Helppi, Ilari Sahamies, Mikael Gronvik, Kimmo Kurko, Igor Pihela Sr, and Ken Okada. 

Break and Time for the Live Stream Posted Wednesday 20th September, 2023 at 18:04(UTC+0) by Lina Olofsson

Our last 33 players in the field are now on a 20-minute break and in the meanwhile one of the remaining tables is being moved to the feature table which you'll be able to follow on our LIVE STREAM together with our commentators Andreas and George with a 30-minute delay. So approximately 20.30 you can tune in there and follow the action until we have a winner in today's circuit event. 

17:59 (UTC+0)
Start of Level 13
Blinds: 2,000/4,000     Ante: 4,000
€137,280 Prize Pool! Posted Wednesday 20th September, 2023 at 17:48(UTC+0) by Lina Olofsson

There's been a huge shift when it comes to the action around the tables since the registration closed. The former "High Chaparral" we had earlier has turned into a more careful way of play. The total prize pool is now announced with €137,280 but we haven't got our hands on the payouts yet but will get back to you as soon as they are announced. 

Apart from the first prize the winner in this circuit event will also lay his hands on one of these beautiful WSOP Circuit rings. 

17:38 (UTC+0)
Start of Level 12
Blinds: 1,500/3,000     Ante: 3,000
Smile! You're on Camera! Posted Wednesday 20th September, 2023 at 17:38(UTC+0) by Lina Olofsson

Here are a few pictures from today's field in the €1,100 PLO/PLO8 which attracted 143 players in total. All the pictures captured by our amazing photographer you'll find in the gallery above. 

Ilari Sahamies

Antti Karkkainen

Mikael Gronvik and Jon Kyte

Cho Min Ho

Juha Helppi

Change of Plans Posted Wednesday 20th September, 2023 at 17:22(UTC+0) by Lina Olofsson

We are back from the dinner break!

As the PLO/PLO5 attracted even more entries than we could have assumed the management team has changed the plans of the live stream and pushed it another hour before we air on OlyBet.tv.

17:08 (UTC+0)
Start of Level 11
Blinds: 1,000/2,500     Ante: 2,500
At Least 25 Seats to the Main Event Guaranteed Tonight! Posted Wednesday 20th September, 2023 at 16:41(UTC+0) by Jason Glatzer

For those of you looking at the schedule, you likely noticed a €150 Mega Satellite guaranteeing 10 seats to the WSOPC Tallinn €1,500 Main Event at 9 p.m.

What you wouldn't have seen is a new satellite that popped up with some tremendous value for late-night players as at Midnight there will be an added €150 mega satellite with another 15 seats guaranteed! 

Of course, Omaha lovers will still be able to enjoy Event #36: €150 PLO 4, 5, & 6 card event at 11 p.m.. This is a six-max affair, which makes perfect sense once incorporating the six-card Omaha.

Video Recap From Day 6 Posted Wednesday 20th September, 2023 at 16:39(UTC+0) by Jason Glatzer

Dinner Break! Posted Wednesday 20th September, 2023 at 15:57(UTC+0) by Lina Olofsson

The players have now gone on their 60-minute dinner break of the day and you can still buy in until the play resumes. 

When they come back not only will we have one of the tables streamed from the tournament, but we will also know how much will be up for grabs in this tournament. 

You'll find the live stream and all of our other coverages from here in Tallinn if you turn over to OlyBet.tv

Last Chance to Gamble Posted Wednesday 20th September, 2023 at 15:33(UTC+0) by Lina Olofsson

Level 9: 1,000/2,000 (2,000)
Entries: 52/128

As we're now on today's last level with the possibility of buying into the PLO/PLO5 the game seems to have loosened up quite a bit and the number of entries in the field will most likely become even higher than what we'd possibly could dream of. But like our fellow Finnish reporter Juhani said "The Finns love to gamble" and they surely seem to. 

Sami Paananen

15:26 (UTC+0)
Start of Level 10
Blinds: 1,000/2,000     Ante: 2,000
One More Time? Posted Wednesday 20th September, 2023 at 15:26(UTC+0) by Lina Olofsson

Level 9: 1,000/1,500 (1,500)
Entries: 57/122

As we're almost at the end of level nine it's only one more level to make your way into today's field in the PLO/PLO5. Or make your way BACK in if you've lost your first bullet. 

The latter one is what seems to be the case for many of the Finns in the field as they not only dominate the list of players bought into the event. They also dominate the list of eliminations and second (maybe even third) bullets. 

15:12 (UTC+0)
Start of Level 9
Blinds: 1,000/1,500     Ante: 1,500
Finland Dominates The Field Posted Wednesday 20th September, 2023 at 14:36(UTC+0) by Lina Olofsson

As this is a single-day event with the possibility to re-enter if you're up for it there's already been a lot of players eliminated from the field. Who's willing to put up another €1,100 to take a second bullet is for the future to decide but as we've earlier mentioned they have until the end of the dinner break to decide if they wanna join or not in this fantastic form of the game of poker. 

It's safe to say that four and five-card PLO is a favorite for our Finnish players since more than half the field comes from Finland. Aki Pyysing, Ilari Sahamies, and Juha Helppi we'd say are the most notable players among those.

Welcome To Our Coverage of Event #8: €1,100 Pot Limit Omaha 4&5 Cards Posted Wednesday 20th September, 2023 at 14:20(UTC+0) by Lina Olofsson

After mostly No-Limit Hold'em tournaments in our coverage we're mixing it up today with some four and five cards Pot Limit Omaha in event #8 of the 2023 WCOPC Tallinn. The players can still buy in until the end of level ten which always makes the fields small in the beginning as poker players love to sleep in as we're all aware of. 

When the cards were in the air right after noon today the field surely looked a bit sparse but before the first level started we were up to 44 players (of which 27 of them were Finns). Another hour or so players kept dropping in and during the first break of the day, we were up to almost 80 players. 

As we start the coverage from the tournament now the field is already up to 105 players and probably go even further before the registration closes. At 6.40 pm the players will go on dinner break and after they're done eating we're starting the live stream here from Tallinn from this event and you can follow it all the way through until we have a lucky winner of yet another golden WSOPC ring. 

14:14 (UTC+0)
Day 1 of WSOPC Tallinn Started
Level: 8     Blinds: 600/1,200     Ante: 1,200

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.