0.0003 SECONDS: SHOW TABLES FROM `maineven_met-base`
0.0084 SECONDS: SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023'
ORDER BY `views` DESC
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'USD'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'GBP'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'GBP'
0.0002 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'USD'
AND `currency_iso_to` = 'EUR'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'GBP'
0.0001 SECONDS: SELECT `rate`
FROM `exchange_rates`
WHERE `currency_iso_from` = 'EUR'
AND `currency_iso_to` = 'USD'
0.0003 SECONDS: SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
0.0002 SECONDS: SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0
0.0004 SECONDS: SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0002 SECONDS: SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'
0.0001 SECONDS: SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`
0.0004 SECONDS: SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'
0.0003 SECONDS: SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'
0.0065 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` = 'summer_showdown_main_2023'
0.0003 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
0.0297 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0067 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1
0.0411 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0068 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '83'
AND `published` = 1
0.0307 SECONDS: SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "% 0.0063 SECONDS: SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '85'
AND `published` = 1
0.0531 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` = '86'
AND `published` = 1
0.0298 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` = '90'
AND `published` = 1
0.0490 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` = '92'
AND `published` = 1
0.0002 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `id` = '92'
0.0004 SECONDS: SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '4'
0.0067 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '92'
ORDER BY `busted` ASC, `current_chips` DESC
0.0068 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` = '92'
ORDER BY `tour_stop_blog_day_posts`.`datetime` DESC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4377'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4376'
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` = '4373'
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` = '4369'
ORDER BY `chip_change` DESC, `busted` ASC
0.0075 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4367'
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` = '4366'
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` = '4362'
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` = '4360'
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` = '4358'
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` = '4356'
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` = '4353'
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` = '4352'
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` = '4348'
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` = '4347'
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` = '4345'
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` = '4343'
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` = '4342'
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` = '4339'
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` = '4335'
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` = '4330'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4327'
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` = '4321'
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` = '4317'
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` = '4315'
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` = '4310'
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` = '4308'
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` = '4307'
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` = '4306'
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` = '4304'
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` = '4302'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4298'
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` = '4296'
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` = '4293'
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` = '4291'
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` = '4289'
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` = '4284'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4282'
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` = '4270'
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` = '4269'
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` = '4266'
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` = '4262'
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` = '4261'
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` = '4260'
ORDER BY `chip_change` DESC, `busted` ASC
0.0059 SECONDS: SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '92'
ORDER BY `busted` ASC, `current_chips` DESC
0.0059 SECONDS: SELECT `tour_stop_blog_day_posts`.*, `users`.`full_name` as `full_name`
FROM `tour_stop_blog_day_posts`
LEFT JOIN `users` ON `users`.`id` = `tour_stop_blog_day_posts`.`user_id`
WHERE `tour_stop_blog_day_id` = '92'
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` = '4377'
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` = '4376'
ORDER BY `chip_change` DESC, `busted` ASC
0.0067 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4373'
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` = '4369'
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` = '4367'
ORDER BY `chip_change` DESC, `busted` ASC
0.0072 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4366'
ORDER BY `chip_change` DESC, `busted` ASC
0.0121 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4362'
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` = '4360'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4358'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4356'
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` = '4353'
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` = '4352'
ORDER BY `chip_change` DESC, `busted` ASC
0.0103 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4348'
ORDER BY `chip_change` DESC, `busted` ASC
0.0122 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4347'
ORDER BY `chip_change` DESC, `busted` ASC
0.0124 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4345'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4343'
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` = '4342'
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` = '4339'
ORDER BY `chip_change` DESC, `busted` ASC
0.0087 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4335'
ORDER BY `chip_change` DESC, `busted` ASC
0.0084 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4330'
ORDER BY `chip_change` DESC, `busted` ASC
0.0116 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4327'
ORDER BY `chip_change` DESC, `busted` ASC
0.0078 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4321'
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` = '4317'
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` = '4315'
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` = '4310'
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` = '4308'
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` = '4307'
ORDER BY `chip_change` DESC, `busted` ASC
0.0108 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4306'
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` = '4304'
ORDER BY `chip_change` DESC, `busted` ASC
0.0068 SECONDS: SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4302'
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` = '4298'
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` = '4296'
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` = '4293'
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` = '4291'
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` = '4289'
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` = '4284'
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` = '4282'
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` = '4270'
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` = '4269'
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` = '4266'
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` = '4262'
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` = '4261'
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` = '4260'
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` = '92'
ORDER BY `busted` ASC, `current_chips` DESC
0.0004 SECONDS: SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
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.
Kai Lehto Wins 2023 Kings of Tallinn Summer Showdown Posted Sunday 30th July, 2023 at 18:08(UTC+0) by Jason Glatzer
After four long days, Finland's Kai Lehto defeated Phil Gross heads-up to win the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event for €108,260.
A recap will be published on the OlyBetEvents.com news section early on Monday. Here is a look at all of the final table payouts:
Place
Player
Country
Prize
1
Kai Lehto
Finland
€108,260
2
Phil Gross
Germany
€72,700
3
Urmo Velvelt
Estonia
€49,300
4
Ville Keranen
Finland
€34,900
5
Tarmo Tammel
Estonia
€25,600
6
Mikael Haapaniemi
Finland
€19,300
7
Tomi Arponen
Finland
€13,400
8
Magnus Pukk
Estonia
€10,100
9
Jakob Linden
Sweden
€7,700
Phil Gross Eliminated in 2nd Place (€72,700) Posted Sunday 30th July, 2023 at 18:06(UTC+0) by Jason Glatzer
Phil Gross (pictured above) opened the button with for 400,000. Kai Lehto defended his big blind with to see the flop. Lehto checked and Gross continued with 300,000 with his top pair.
The turn didn't help or hurt either player. Gross bet 500,000 and Lehto check-called. Fireworks erupted after the pair the board on the river to push Lehto ahead with trip sixes.
Lehto checked one last time. Gross bet 1,300,000. Lehto went into the tank before he jammed. Gross called off for 5.1 million only to get the bad news.
Congrats to Kai Lehto for winning the 2023 Kings of Tallinn €1,100 Main Event for €108,260 and well played to Phil Gross who banked €72,700 for his efforts.
The recap of this event will be published at OlyBetEvents.com.
Player
Chips
Progress
Kai Lehto
17,000,000
8,400,000
Phil Gross
0
0
Gross Doubles With Ace-Nine Suited Posted Sunday 30th July, 2023 at 17:46(UTC+0) by Jason Glatzer
Kai Lehto limped from the small blind. Phil Gross quickly jammed for 4.1 million. Lehto asked for a count before calling a minute later.
Phil Gross: Kai Lehto:
Gross was ahead, but Lehto had two live cards. Both players bricked the . Gross doubled up with ace-high and the stacks were fairly even after the hand.
Player
Chips
Progress
Kai Lehto
8,600,000
2,300,000
Phil Gross
8,400,000
2,400,000
KoT Summer Showdown €3,000 High Roller Winner Juan Duenas Interview Posted Sunday 30th July, 2023 at 17:33(UTC+0) by Jason Glatzer
17:23 (UTC+0)
Start of Level 33 Blinds: 100,000/200,000 Ante: 200,000
Better Pair for Gross Posted Sunday 30th July, 2023 at 17:23(UTC+0) by Jason Glatzer
Level 32: 75,000/150,000 (150,000) Entries: 2/564
Kai Lehto opened for a min-raise with from the button. Phil Gross defended his big blind with before improving to top pair on the flop.
Gross check-called a bet of 200,000 by Lehto. The river improved Lehto to an inferior pair. Gross checked and Lehto bet 575,000. Gross called and won the pot just before the blind level increased.
Player
Chips
Progress
Kai Lehto
10,900,000
900,000
Phil Gross
6,000,000
900,000
Gross Doubles With Snowmen Posted Sunday 30th July, 2023 at 16:53(UTC+0) by Jason Glatzer
Level 32: 75,000/150,000 (150,000) Entries: 2/564
Phil Gross (pictured below) opened the button with a min-raise and was called by Kai Lehto from the big blind.
Gross continued for 300,000 on the flop. Lehto jammed and Gross called off for his stack of 2,200,000.
Phil Gross: Kai Lehto:
It was a coin flip with Lehto holding top pair and Gross with tons of draws. The spiked the turn to improve Gross to a set and doubled his stack after the river completed the board.
Player
Chips
Progress
Kai Lehto
11,800,000
2,000,000
Phil Gross
5,100,000
2,000,000
Lehto Takes the Lead Posted Sunday 30th July, 2023 at 16:44(UTC+0) by Jason Glatzer
Level 32: 75,000/150,000 (150,000) Entries: 2/564
Phil Gross opened for 375,000 from the button. Kai Lehto three-bet to 1,125,000 and Gross called.
Pandemonium took place after the came on the flop. Lehto continued for 600,000. Gross jammed and Lehto called off for 5,700,000.
Kai Lehto: Phil Gross:
Lehto was ahead after pairing up his king but had to fade the flush draw and back door outs held by Gross.
Gross bricked the turn and river for Lehto to take a massive heads-up chip lead.
Player
Chips
Progress
Kai Lehto
13,800,000
6,600,000
Phil Gross
3,100,000
6,600,000
Lehto on the Comeback Trail Posted Sunday 30th July, 2023 at 16:33(UTC+0) by Jason Glatzer
Level 32: 75,000/150,000 (150,000) Entries: 2/564
Phil Gross opened the button with a min-raise with before Kai Lehto defended his big blind with
Lehto improved to two pair on the flop and check-called a bet of 300,000 by Gross. Another check-call came by Lehto. This time it was for 500,000 after the turn, which improved Gross to an inferior two pair.
The river was checked down and Lehto narrowed the gap on Gross's chip lead.
Player
Chips
Progress
Phil Gross
9,700,000
2,900,000
Kai Lehto
7,200,000
2,875,000
16:24 (UTC+0)
Start of Level 32 Blinds: 75,000/150,000 Ante: 150,000
Urmo Velvelt Eliminated in 3rd Place (€49,300) Posted Sunday 30th July, 2023 at 16:00(UTC+0) by Jason Glatzer
Level 31: 50,000/125,000 (125,000) Entries: 2/564
Phil Gross won a handful of smaller pots against Urmo Velvelt to extend his lead before he open-jammed the button. Velvet called off his stack of 1.9 million and it was a coin flip for Velvelt's tournament life.
Urmo Velvelt: Phil Gross:
Velvelt was ahead after the flop and pulled even further ahead after the . Fortunes changed on the river as Gross improved to a better pair to eliminate Velvelt in third place for €49,300.
Meanwhile, Gross entered the heads-up action with triple the stack of Kai Lehto. Both players locked up €72,700 and unless a deal is made will be playing for the €108,260 top prize and, of course, the coveted Kings of Tallinn Summer Showdown Main Event trophy.
Players went on a short break after the hand.
Player
Chips
Progress
Phil Gross
12,600,000
6,500,000
Kai Lehto
4,325,000
775,000
Urmo Velvelt
0
0
Gross Takes the Lead Posted Sunday 30th July, 2023 at 15:48(UTC+0) by Jason Glatzer
Level 31: 50,000/125,000 (125,000) Entries: 3/564
Phil Gross (pictured below) just took the chip lead for the first time on the final day of the Main Event.
It was a limped pot with Lehto leading out with for 150,000 on the flop. Gross with called with bottom pair. Lehto continued his aggression with a bet of 400,000 on the turn. Gross opted to call again and improved to a flush on the river.
Kai bet nearly the pot with a bet of 1,300,000. Gross asked for the pot to be spread and stared at his opponent for a couple of minutes. Gross eventually jammed and won a big pot after Lehto folded.
Player
Chips
Progress
Phil Gross
6,100,000
1,300,000
Urmo Velvelt
5,100,000
200,000
Kai Lehto
5,100,000
2,100,000
Interview With Fifth Place Finisher Tarmo Tammel Posted Sunday 30th July, 2023 at 15:34(UTC+0) by Jason Glatzer
Earlier this week, Kings of Tallinn Summer Showdown presenter Evely Pihela interviewed the local legend and fifth-place finisher in the 2023 KoT Summer Showdown Main Event Tarmo Tammel. Check out the interview below:
Final Table Payouts Posted Sunday 30th July, 2023 at 15:32(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€108,260
2
€72,700
3
€49,300
4
Ville Keranen
Finland
€34,900
5
Tarmo Tammel
Estonia
€25,600
6
Mikael Haapaniemi
Finland
€19,300
7
Tomi Arponen
Finland
€13,400
8
Magnus Pukk
Estonia
€10,100
9
Jakob Linden
Sweden
€7,700
Ville Keranen Eliminated in 4th Place (€34,900) Posted Sunday 30th July, 2023 at 15:30(UTC+0) by Jason Glatzer
Level 31: 50,000/125,000 (125,000) Entries: 3/564
Ville Keranen (pictured below) won several flips but he was unable to win the following hand to hit the rail while he was ahead.
Kai Lehto opened for 250,000 from under the gun. Keranen three-bet shoved for 2,300,000 from the small blind. Lehto went into the tank before he found a call.
Ville Keranen: Kai Lehto:
Keranen had Lehto dominated but sometimes the underdog wins. That is exactly what happened with Lehto winning a big pot while also eliminating Keranen after the .
Congrats to Keranen for an amazing run. Despite missing out on the podium he has plenty of reasons to celebrate with fourth place awarding €34,900.
Player
Chips
Progress
Kai Lehto
7,200,000
2,300,000
Urmo Velvelt
4,900,000
300,000
Phil Gross
4,800,000
1,200,000
Ville Keranen
0
0
15:22 (UTC+0)
Start of Level 31 Blinds: 50,000/125,000 Ante: 125,000
Another Double for Keranen Posted Sunday 30th July, 2023 at 15:12(UTC+0) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 4/564
Urmo Velvelt opened for 200,000 from under the gun. Phil Gross called with from the small blind before Ville Keranen three-bet shoved for 1,800,000 from the big blind. Velvelt went into the tank for a couple of minutes before eventually calling. Gross wasted no time in tossing away his suited rags and we were off to the races with Keranen at risk.
Ville Keranen: Urmo Velvelt:
The flop pushed Keranen ahead. The turn further improved Keranen to trips and he earned a double-up after the river completed the board.
Meanwhile, Kai Lehto was pushed back into the chip lead by default and all four players are just a dozen big blinds apart in what is now a tightly-grouped final four.
Player
Chips
Progress
Kai Lehto
4,900,000
600,000
Urmo Velvelt
4,600,000
900,000
Ville Keranen
3,800,000
1,100,000
Phil Gross
3,600,000
600,000
Kicker Issues for Velvelt Posted Sunday 30th July, 2023 at 14:59(UTC+0) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 4/564
Urmo Velvelt opened for a min-raise from under the gun with and was called by Kai Lehto called from the button with .
Both players improved to top pair on the flop with Velvelt having some kicker issues. Velvelt led out for 300,000 and Lehto called.
Velvelt checked the turn. Lehto bet 825,000 and got a call. Both players checked the river and Lehto won a big pot to close the gap to under a big blind between him and Velvelt for the chip lead.
Player
Chips
Progress
Kai Lehto
5,500,000
1,100,000
Urmo Velvelt
5,500,000
300,000
Tarmo Tammel Eliminated in 5th Place (€25,600) Posted Sunday 30th July, 2023 at 14:26(UTC+0) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 4/564
Kai Lehto opened from the cutoff for 200,000. Phil Gross three-bet the button to 500,000. Tarmo Tammel (pictured below) four-bet shoved for 1,200,000 from the small blind. Lehto folded and Gross called.
Phil Gross: Tarmo Tammel:
Tammel was in amazing shape. At least so we thought. Tarmo remained ahead after the flop and was still ahead after the turn. However, the turn did provide more outs to Gross with a seven completing a straight. The straight draw was completed after the river completed the board for Tammel to hit the rail on a bad beat in fifth place for €25,600.
Player
Chips
Progress
Kai Lehto
4,400,000
600,000
Phil Gross
4,200,000
1,300,000
Tarmo Tammel
0
0
Lehto Chips Up With Two Pair Posted Sunday 30th July, 2023 at 14:05(UTC+0) by Jason Glatzer
Level 30: 50,000/100,000 (100,000) Entries: 5/564
Phil Gross min-raised from under the gun with and was called by both Urmo Velvelt with and Kai Lehto with from the blinds.
Velvelt checked with his overpair on the flop before Lehto fired in a bet of 225,000 with his bottom pair. Gross called with his overcards and gutshot straight draw and Velvelt opted to call as well.
The turn would have completed a flush draw if either of the three players had three clubs. This card also improved Lehto with two pair. Velvelt checked again before Lehto bet 450,000. Gross snap-folded and Velvelt went into the tank before he opted to give up on his hand.
Player
Chips
Progress
Urmo Velvelt
5,800,000
700,000
Kai Lehto
3,800,000
700,000
Phil Gross
2,900,000
400,000
13:58 (UTC+0)
Start of Level 30 Blinds: 50,000/100,000 Ante: 100,000
Tammel Doubles Through Gross Before Break Posted Sunday 30th July, 2023 at 13:38(UTC+0) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 5/564
Phil Gross opened for a min-raise from the button before Tarmo Tammel jammed for 620,000 from the small blind. Gross called and the cards were turned over.
Tarmo Tammel: Phil Gross:
Tammel was behind and at risk of hitting the rail in fifth place. But he nailed his three on the flop and doubled his stack with two pair after the ran out on the board.
The final five players are on their first break at the final table. Blinds will increase to 50,000/100,000 with a 100,000 big blind ante when the action resumes.
Player
Chips
Progress
Urmo Velvelt
6,500,000
1,000,000
Phil Gross
3,300,000
300,000
Kai Lehto
3,100,000
0
Ville Keranen
2,700,000
1,300,000
Tarmo Tammel
1,400,000
420,000
Updated Final Table Payouts Posted Sunday 30th July, 2023 at 13:29(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€108,260
2
€72,700
3
€49,300
4
€34,900
5
€25,600
6
Mikael Haapaniemi
Finland
€19,300
7
Tomi Arponen
Finland
€13,400
8
Magnus Pukk
Estonia
€10,100
9
Jakob Linden
Sweden
€7,700
Mikael Haapaniemi Eliminated in 6th Place (€19,300) Posted Sunday 30th July, 2023 at 13:25(UTC+0) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 5/564
Urmo Velvelt opened for 175,000 with from under the gun. Phil Gross called from the cutoff before Mikael Haapaniemi three-bet jammed for 1,400,000. Velvelt snap-folded and Gross went into the tank for a few minutes before he found a call.
Mikael Haapaniemi: Phil Gross:
Gross got rewarded for the gutsy call after his jack paired on the runout to win the hand and effectively double.
Haapaniemi proved yesterday that he knows how to play a big stack but we will unfortunately not get the chance to see that on display at the final table after losing the flip for his tournament life. Congrats to Haapaniemi for his sixth-place finish for €19,300 and his solid poker throughout the event. Happaniemi had a series to be proud of and will have a trophy to bring home after previously winning Event #25: €250 NLH/PLO/PLO5 for €6,110.
Player
Chips
Progress
Urmo Velvelt
5,500,000
100,000
Phil Gross
3,600,000
1,500,000
Mikael Haapaniemi
0
0
Tammel Runs Big Slick Into Velvelt's Rockets Posted Sunday 30th July, 2023 at 13:08(UTC+0) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 6/564
Phil Gross opened for 175,000 from the hijack with . Tarmo Tammel three-bet to 555,000 with . Online poker superstar Urmo Velvelt (pictured below) woke up with from the big blind and jammed for 2,600,000.
Gross snap-folded and Tammel went into the tank before he called in a sick cooler of a hand.
The flop would have improved Gross to two pair if he stuck around. Of course, it was an easy fold. Meanwhile, Tammel had thin hope with a back door flush draw. The back door opened to a front door on the turn to give both Velvelt and Tammel a sweat.
However, the blank completed the board to double Velvelt into the chip lead after winning the biggest pot thus far in the Main Event and kill Tammel's early momentum. While Tammel took the cooler in stride, it was the charismatic Gross appeared to be upset he couldn't find a way to realize his equity in this hand.
Player
Chips
Progress
Urmo Velvelt
5,400,000
2,900,000
Phil Gross
2,100,000
300,000
Tarmo Tammel
980,000
2,620,000
Updated Final Table Payouts Posted Sunday 30th July, 2023 at 12:59(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€108,260
2
€72,700
3
€49,300
4
€34,900
5
€25,600
6
€19,300
7
Tomi Arponen
Finland
€13,400
8
Magnus Pukk
Estonia
€10,100
9
Jakob Linden
Sweden
€7,700
Tomi Arponen Eliminated in 7th Place (€13,400) Posted Sunday 30th July, 2023 at 12:57(UTC+0) by Jason Glatzer
Level 29: 40,000/80,000 (80,000) Entries: 6/564
Tomi Arponen (pictured below) jammed his short stack of 965,000 from under the gun. A bunch of players quickly folded before the action paused on Tarmo Tammel. A minute later Tammel folded and it was a heads-up showdown with Arponen at risk after Ville Keranen folded from the big blind.
Tomi Arponen: Tarmo Tammel:
Arponen was in for a world of hurt and was drawing to a chop after the flop. Arponen's fate was sealed after he was drawing dead on the turn and was officially eliminated by Tammel in seventh place for €13,400 after the river completed the board.
Player
Chips
Progress
Tarmo Tammel
3,600,000
1,000,000
Tomi Arponen
0
0
12:52 (UTC+0)
Start of Level 29 Blinds: 40,000/80,000 Ante: 80,000
Updated Final Table Payouts Posted Sunday 30th July, 2023 at 12:50(UTC+0) by Jason Glatzer
Place
Player
Country
Prize
1
€108,260
2
€72,700
3
€49,300
4
€34,900
5
€25,600
6
€19,300
7
€13,400
8
Magnus Pukk
Estonia
€10,100
9
Jakob Linden
Sweden
€7,700
Magnus Pukk Eliminated in 8th Place (€10,100) Posted Sunday 30th July, 2023 at 12:49(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 7/564
Magnus Pukk (pictured below) opened with a min-raise with from early position and was called by Ville Keranen with from one seat over.
The flop hit both players hard. Pukk improved to top two pair but was far behind the bottom set held by Keranen. Pukk checked. Keranen jammed for 1,400,000 and Pukk quickly called.
The turn and the river completed the board and Pukk was eliminated in eighth place for €10,100.
Meanwhile, Keranen continues his hot final table run and went from the second shortest stack to the chip lead during the opening blind level.
Player
Chips
Progress
Ville Keranen
4,000,000
1,800,000
Kai Lehto
3,100,000
100,000
Tarmo Tammel
2,600,000
0
Urmo Velvelt
2,500,000
0
Mikael Haapaniemi
2,000,000
0
Phil Gross
1,800,000
100,000
Tomi Arponen
965,000
30,000
Magnus Pukk
0
0
Keranen Chips Up With Queens Posted Sunday 30th July, 2023 at 12:41(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 8/564
Tarmo Tammel opened for 120,000 with from early position before Magnus Pukk jacked it up to 280,000 from the hijack with . Ville Keranen four-bet to 430,000 with . Urmo Velvelt then woke up with from the big blind and opted to make a tight fold with all the action in front of him. Tammel folded as well and Pukk called.
Keranen improved to the top set on the flop. Pukk check-called a bet of 140,000. This was enough to get Pukk to fold. Despite not doubling up, Keranen has had a great early start to the final table where he came in with the second shortest stack and was in the middle of the pack after doubling up earlier and this hand.
Player
Chips
Progress
Tarmo Tammel
2,600,000
300,000
Urmo Velvelt
2,500,000
100,000
Ville Keranen
2,200,000
800,000
Magnus Pukk
1,600,000
1,200,000
Cowboys for Gross Posted Sunday 30th July, 2023 at 12:30(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 8/564
Mikael Haapaniemi opened for 120,000 from early position with . Kai Lehto three-bet to 320,000 from the hijack before Phil Gross jammed for 730,000 from the cutoff. Haapaniemi folded and Lehto called.
Phil Gross: Kai Lehto:
Gross was in amazing shape with his cowboys and doubled his stack after no magic happened for Lehto on the runout.
Player
Chips
Progress
Kai Lehto
3,200,000
205,000
Mikael Haapaniemi
2,000,000
310,000
Phil Gross
1,700,000
700,000
Final Table Payouts Posted Sunday 30th July, 2023 at 12:25(UTC+0) by Jason Glatzer
Here is an updated look at the final table payouts:
Place
Player
Country
Prize
1
€108,260
2
€72,700
3
€49,300
4
€34,900
5
€25,600
6
€19,300
7
€13,400
8
€10,100
9
Jakob Linden
Sweden
€7,700
Jakob Linden Eliminated in 9th Place (€7,700) Posted Sunday 30th July, 2023 at 12:22(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 8/564
Jakob Linden jammed his short stack of 690,000 from middle position and was called by Magnus Pukk from the big blind.
Jakob Linden: Magnus Pukk:
The flop kept Linden's cards live while also adding an eight to a straight along with a backdoor flush draw. The turn paired up Pukk to eliminate jacks and tens as outs for Linden but his backdoor flush draw became a real flush draw with one more card to come.
However, the paired up the board and Linden was the first player to hit the rail at the final table in ninth place for €7,700.
Player
Chips
Progress
Magnus Pukk
2,800,000
1,375,000
Jakob Linden
0
0
Big Slick for Tammel Posted Sunday 30th July, 2023 at 12:17(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 9/564
We've already had a lead change after two high-profile Estonians battled it out in the following hand.
Tarmo Tammel opened for 120,000 from early position with and was called by Urmo Velvelt with from the small blind. Both players improved to top pair on the flop with Tammel ahead with the better kicker. Velvelt check-called a bet of 105,000 before the blank came on the turn.
Both players checked and the river completed the board. Velvelt led out for 100,000. Tammel called to take down the pot.
Player
Chips
Progress
Tarmo Tammel
2,900,000
100,000
Urmo Velvelt
2,600,000
40,000
Keranen Off to Broadway Posted Sunday 30th July, 2023 at 12:08(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 9/564
Fireworks already erupted on the second hand of the final table. Tarmo Tammel opened for 120,000 from the cutoff with . Ville Keranen (pictured below) jammed his short stack of 610,000. Tomi Arponen rejammed for 2,050,000. Tammel folded and it was a heads-up showdown with Keranen at risk.
Ville Keranen: Tomi Arponen:
Keranen was at risk of becoming the first player out at the final table and things went from bad to worse after Arponen nailed the top pair on the flop. The didn't change a thing. However, the spiked the river to improve Keranen to Broadway to stay alive and double his stack.
Player
Chips
Progress
Tarmo Tammel
2,800,000
100,000
Ville Keranen
1,400,000
670,000
Tomi Arponen
995,000
670,000
Final Table Stream Begins Posted Sunday 30th July, 2023 at 12:01(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 9/564
The action began 30 minutes ago at the final table with the stream beginning moments ago. Sit, back, relax, and watch the stream while also catching up on the action you missed in the blog.
Final Table Seat Draw Posted Sunday 30th July, 2023 at 11:09(UTC+0) by Jason Glatzer
Photos are being taken of the prestigious final nine players of the Kings of Tallinn Summer Showdown Main Event. The action will likely resume in 15 minutes with the entire final table live-streamed at OlyBet.tv, Facebook, and Delfi from the beginning until a winner is crowned.
There will be no spoilers in the blog today as we will report on a delay. This reporter will be in an out of the commentating booth with Andreas "Wiseguy" Hoglund hosting the action.
Seat
Player
Chips
Big Blinds
1
Ville Keranen
730,000
12
2
Tomi Arponen
1,665,000
28
3
Mikael Haapaniemi
2,310,000
39
4
Jakob Linden
840,000
14
5
Urmo Velvelt
2,640,000
44
6
Kai Lehto
3,405,000
57
7
Phil Gross
1,000,000
17
8
Tarmo Tammel
2,900,000
48
9
Magnus Pukk
1,425,000
24
Player
Chips
Progress
Kai Lehto
3,405,000
385,000
Tarmo Tammel
2,900,000
560,000
Urmo Velvelt
2,640,000
25,000
Mikael Haapaniemi
2,310,000
180,000
Tomi Arponen
1,665,000
130,000
Magnus Pukk
1,425,000
180,000
Phil Gross
1,000,000
360,000
Jakob Linden
840,000
150,000
Ville Keranen
730,000
0
Tapio Altonen Eliminated in 10th Place (€6,300) Posted Sunday 30th July, 2023 at 10:57(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 9/564
Tapio Altonen came into today with just six big blinds and a plan to do something within the next orbit and a half. The action came around to him in the big blind and he thought for a few minutes after Tarmo Tammel min-raised the button. Aaltonen eventually jammed for 285,000 and Tammel snap-called.
Tapio Altonen: Tarmo Tammel:
Aaltonen's cards were live but his odds decreased after Tammel improved to top pair on the flop.
"Jack," Aaltonen was rooting for as this would have completed a gutshot to Broadway. However, Aaltonen was unable to improve on the turn and river and bubbled the final table. He didn't walk away empty-handed as he did collect the 10th place prize of €6,300.
Despite his dreams being crushed, Aaltonen showed tons of sportsmanship with hugs and handshakes to his opponents and rail after an impressive 3+ days of poker.
Player
Chips
Progress
Tarmo Tammel
2,900,000
560,000
Tapio Aaltonen
0
0
Cards in the Air Posted Sunday 30th July, 2023 at 10:35(UTC+0) by Jason Glatzer
Level 28: 30,000/60,000 (60,000) Entries: 10/564
Cards are in the air to start the final day of the Main Event. Best of luck to the final 10 players.
Who Will Win the Record Breaking Kings of Tallinn Summer Showdown Main Event? Posted Sunday 30th July, 2023 at 09:40(UTC+0) by Jason Glatzer
It has been a fantastic week at Olympic Park Casino and the Hilton Tallinn Park with the Kings of Tallinn Summer Showdown bringing record numbers to every event including the €1,100 Main Event which attracted 564 entries to create a €530,160 prize pool.
Today will be the day that we will learn who will earn the right to be crowned the Kings of Tallinn Summer Showdown Main Event champion.
Finland's Kai Lehto (pictured above) will be the clear chip leader to kick off the action with a 50 big blind stack of 3,020,000. Lehto's claim to the title is far from a certainty with many other formidable players in the mix including Urmo Velvelt (2,665,000) and Tarmo Tammel (2,340,000) also in the top three to start the day. Velvelt has had some decent results in Tallinn and online while Tammel (pictured below) came into the Kings of Tallinn Summer showdown with a record of 68 recorded cashes at Olympic Park Casino according to The Hendon Mob.
Meanwhile, Mikael Haapaniemi, Magnus Pukk, Tomi Arponen, the entertaining Phil Gross, Jakub Linden, Ville-Matte Keranen, and popular Finnish hero Tapio Altonen all are still in contention for the coveted trophy.
Time will tell which one of these players will join the Kings of Tallinn Summer Showdown royalty. The final 10 players already locked up €6,300 with payout jumps taking place every time a player hits the rail. It won't be a bad day's "work" for any of the remaining players but this is especially true for tonight's trophy winner will take home €108,260. Check out all of the final day payouts below:
Place
Prize
1
€108,260
2
€72,700
3
€49,300
4
€34,900
5
€25,600
6
€19,300
7
€13,400
8
€10,100
9
€7,700
10
€6,300
As Day 3 ended late, the organizers added an extra 30 minutes to the start time with cards in the air at 12:30 p.m. on Sunday with blinds increasing every hour.
There will be a break as soon as one player hits the rail for the TV table to be set up which will be broadcasted across a variety of channels including OlyBet.tv, Facebook, and Delfi.
Final Day Seat Draw Posted Sunday 30th July, 2023 at 09:11(UTC+0) by Jason Glatzer
Table
Seat
Player
Chips
Big Blinds
11
2
Tapio Aaltonen
345,000
6
11
3
Phil Gross
1,360,000
23
11
4
Urmo Velvelt
2,665,000
44
11
5
Tarmo Tammel
2,340,000
39
11
6
Mikael Haapaniemi
2,130,000
36
12
2
Tomi Arponen
1,535,000
26
12
3
Ville-Matti Keranen
730,000
12
12
6
Nils Linden
990,000
17
12
7
Kai Lehto
3,020,000
50
12
8
Magnus Pukk
1,605,000
27
09:08 (UTC+0)
Day 4 of Kings of Tallinn Summer Showdown 2023 Started Level: 28 Blinds: 30,000/60,000 Ante: 60,000
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.
for 400,000. Kai Lehto defended his big blind with 
to see the 
flop. Lehto checked and Gross continued with 300,000 with his top pair. 
turn didn't help or hurt either player. Gross bet 500,000 and Lehto check-called. Fireworks erupted after the 
pair the board on the river to push Lehto ahead with trip sixes. 
. Gross doubled up with ace-high and the stacks were fairly even after the hand. 
from the button. Phil Gross defended his big blind with 
before improving to top pair on the 
flop.
river improved Lehto to an inferior pair. Gross checked and Lehto bet 575,000. Gross called and won the pot just before the blind level increased.
river completed the board.
came on the flop. Lehto continued for 600,000. Gross jammed and Lehto called off for 5,700,000.
river for Lehto to take a massive heads-up chip lead.
before Kai Lehto defended his big blind with 
flop and check-called a bet of 300,000 by Gross. Another check-call came by Lehto. This time it was for 500,000 after the 
flop. Gross with 
.
from the small blind before Ville Keranen three-bet shoved for 1,800,000 from the big blind. Velvelt went into the tank for a couple of minutes before eventually calling. Gross wasted no time in tossing away his suited rags and we were off to the races with Keranen at risk.
and was called by Kai Lehto called from the button with 
flop before Lehto fired in a bet of 225,000 with his bottom pair. Gross called with his overcards and gutshot straight draw and Velvelt opted to call as well.
£ GBP
$ USD
€ EUR
