0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0077 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event8'
ORDER BY `views` DESC
0.0111 SECONDS: UPDATE `page_views` SET views = views + 1
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/live-reporting/wsopctallinn_2023_event8'
0.0003 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.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.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.0040 SECONDS: SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
LIMIT 30
0.0005 SECONDS: SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
THEN tours.logo
ELSE tour_stops.logo
END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'wsopctallinn_2023_event8'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '35'
0.0281 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0064 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.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '35'
AND `name` = '1'
0.0062 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.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_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '127'
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` = '5594'
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` = '5490'
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` = '5489'
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` = '5488'
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` = '5487'
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` = '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.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` = '5482'
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` = '5484'
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` = '5481'
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` = '5478'
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` = '5480'
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` = '5479'
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` = '5477'
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` = '5475'
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` = '5476'
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` = '5474'
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` = '5469'
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` = '5473'
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` = '5472'
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` = '5470'
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` = '5471'
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` = '5468'
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` = '5467'
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` = '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.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` = '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.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` = '5461'
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` = '5460'
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` = '5459'
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` = '5458'
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` = '5456'
ORDER BY `chip_change` DESC, `busted` ASC
0.0085 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5454'
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` = '5453'
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` = '5451'
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` = '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.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` = '5450'
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` = '5445'
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` = '5439'
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` = '5438'
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` = '5435'
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` = '5431'
ORDER BY `chip_change` DESC, `busted` ASC
0.0077 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5422'
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` = '5421'
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` = '5410'
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` = '5403'
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` = '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.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` = '5399'
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` = '5389'
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` = '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.0058 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.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` = '5594'
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` = '5490'
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` = '5489'
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` = '5488'
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` = '5487'
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` = '5486'
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` = '5485'
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` = '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.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` = '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.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` = '5480'
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` = '5479'
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` = '5477'
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` = '5475'
ORDER BY `chip_change` DESC, `busted` ASC
0.0092 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5474'
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` = '5469'
ORDER BY `chip_change` DESC, `busted` ASC
0.0079 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0127 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.0170 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_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.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` = '5471'
ORDER BY `chip_change` DESC, `busted` ASC
0.0126 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5468'
ORDER BY `chip_change` DESC, `busted` ASC
0.0126 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '5467'
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` = '5466'
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` = '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.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` = '5463'
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` = '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.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` = '5460'
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` = '5459'
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` = '5458'
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` = '5456'
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` = '5455'
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` = '5454'
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` = '5453'
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` = '5451'
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` = '5449'
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` = '5447'
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` = '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.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` = '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.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` = '5435'
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` = '5431'
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` = '5422'
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` = '5421'
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` = '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.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` = '5401'
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` = '5400'
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` = '5399'
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` = '5389'
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` = '5386'
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` = '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
Hi,
We'd like to send you push notifications so you never miss out on:
Exclusive Offers
Upcoming Events
Exciting Promotions
Poker Travel News
Don’t worry; we won’t bombard you with messages, and you can-opt out
anytime by logging into your account and changing your settings.
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 .
Go to checkoutMore Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.
Kyte got a straight sending his opponent in second. For his silver medal the Finn Olli Rummukainen cashed €23,250. 
giving Kyte the straight and sending our second-last Finn out from the tournament in third place for €15,950.
put Kyte in favour and on the turn 
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. 
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 
. 
flop.
and 
.
flop. Pihela flopped a straight and Helppi was drawing thin. The
river.
£ GBP
$ USD
€ EUR
