0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0067 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-11-25'
AND `url` = 'https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/2/updates'
ORDER BY `views` DESC

0.0007 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/live-reporting/summer_showdown_main_2023/2/updates', 1, '2024-11-25')

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

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

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

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

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

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

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

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

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

0.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.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

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

0.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.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0064 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0007 SECONDS: 
SELECT tour_stop_blogs.*, tours.page_background as page_background, tours.page_header as page_header, currencies.name as currency_name, currencies.symbol as currency_symbol, currencies.ISO_4217_code as currency_code, tour_stops.logo as tour_stop_logo, tour_stops.name as tour_stop_name, tour_stop_blog_days.name as current_day_name, tours.id as tour_id, CASE
						WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
						THEN tours.logo
						ELSE tour_stops.logo
					END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stop_blogs`
LEFT JOIN `currencies` ON `currencies`.`id` = `tour_stop_blogs`.`currency_id`
LEFT JOIN `tour_stops` ON `tour_stops`.`id` = `tour_stop_blogs`.`tour_stop_id`
LEFT JOIN `tour_stop_blog_days` ON `tour_stop_blog_days`.`id` = `tour_stop_blogs`.`current_day_id`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE `friendly_url` = 'summer_showdown_main_2023'

0.0005 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'

0.0391 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0094 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '75'
AND `published` = 1

0.0309 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0060 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '83'
AND `published` = 1

0.0279 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.0277 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` = '86'
AND `published` = 1

0.0271 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '90'
AND `published` = 1

0.0272 SECONDS: 
SELECT `content`
FROM `tour_stop_blog_day_posts`
WHERE `content` LIKE "%
0.0057 SECONDS: 
SELECT COUNT(*) AS `numrows`
FROM `tour_stop_blog_day_posts`
WHERE `tour_stop_blog_day_id` = '92'
AND `published` = 1

0.0003 SECONDS: 
SELECT *
FROM `tour_stop_blog_days`
WHERE `tour_stop_blog_id` = '25'
AND `name` = '2'

0.0061 SECONDS: 
SELECT `tour_stop_blog_day_players`.*
FROM `tour_stop_blog_day_players`
WHERE `tour_stop_blog_day_id` = '86'
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_posts`.`published` = 1
AND `tour_stop_blog_day_id` = '86'
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` = '4030'
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` = '4012'
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` = '4007'
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` = '4004'
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` = '4002'
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` = '4001'
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` = '3998'
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` = '3995'
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` = '3991'
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` = '3983'
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` = '3980'
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` = '3971'
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` = '3962'
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` = '3956'
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` = '3951'
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` = '3945'
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` = '3944'
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` = '3937'
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` = '3924'
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` = '3926'
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` = '3910'
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` = '3917'
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` = '3903'
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` = '3901'
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` = '3899'
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` = '3892'
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` = '3894'
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` = '3879'
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` = '3878'
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` = '3876'
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` = '3875'
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` = '86'
ORDER BY `busted` ASC, `current_chips` DESC

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

0.0065 SECONDS: 
SELECT `tour_stop_blog_day_post_progress`.*, `tour_stop_blog_day_players`.`country_code` AS `player_country_code`
FROM `tour_stop_blog_day_post_progress`
LEFT JOIN `tour_stop_blog_day_players` ON `tour_stop_blog_day_post_progress`.`tour_stop_blog_day_player_id` = `tour_stop_blog_day_players`.`id`
WHERE `tour_stop_blog_day_post_id` = '4030'
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` = '4012'
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` = '4007'
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` = '4004'
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` = '4002'
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` = '4001'
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` = '3998'
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` = '3995'
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` = '3991'
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` = '3983'
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` = '3980'
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` = '3971'
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` = '3962'
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` = '3956'
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` = '3951'
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` = '3945'
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` = '3944'
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` = '3937'
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` = '3924'
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` = '3926'
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` = '3910'
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` = '3917'
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` = '3903'
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` = '3901'
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` = '3899'
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` = '3892'
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` = '3894'
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` = '3879'
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` = '3878'
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` = '3876'
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` = '3875'
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` = '92'
ORDER BY `busted` ASC, `current_chips` DESC

0.0004 SECONDS: 
SELECT *
FROM `tour_stop_blogs`
WHERE `active` = 1
AND `tour_stop_id` = 2084
English
Kings of Tallinn Summer Showdown 2023 2023 Tallinn Summer Showdown €1,100 Main Event Live Reporting - Day 4
Kings of Tallinn Summer Showdown 2023 - Live Reporting 2023 Tallinn Summer Showdown €150 Celebrity Special (Estonian) 2023 Tallinn Summer Showdown €1,100 Main Event (Estonian) 2023 Tallinn Summer Showdown €5,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €3,000 High Roller (Estonian) 2023 Tallinn Summer Showdown €555 Championship 2023 Tallinn Summer Showdown €1,100 Main Event
Current Level 33 Current Day 4
Blinds 100,000/200,000 Ante 200000
Entries 564 Remaining 1
Prize Pool (EUR) €530,160 First Prize (EUR) €108,260
Day 1A Day 1B Day 1C Day 2 Day 3 Day 4
Live Updates Chip Counts Structure Gallery Payouts
1 New Update - Click to refresh
Live Updates - Day 2
End-of-Day 2 Chip Counts Posted Saturday 29th July, 2023 at 08:24(UTC+0) by Jason Glatzer
Player  Chips  Big Blinds
Juan Carlos Vecino Duenas        709,000 118
Vlads Dolgilevics        674,000 112
Nils Linden        558,000 93
Mikael Haapaniemi        536,000 89
Tapio Aaltonen        492,000 82
Ville-Matti Keranen        478,000 80
Mauri Kristjan Dorbek        470,000 78
Yanis Sahli        457,000 76
Juho Heiska        440,000 73
Tomi Arponen        422,000 70
Phil Gross        406,000 68
Hendrik Diegenant        405,000 68
Kai Lehto        405,000 68
Siim Suviste        388,000 65
James Noonan        382,000 64
Kasper Mellanen        379,000 63
Guillermo Cifuentes        352,000 59
Dmitrijs Kornevs        352,000 59
Karolis Kutkauskas        326,000 54
Magnus Pukk        321,000 54
Konstantin Arber        320,000 53
Nick Penning        314,000 52
Keito Kaljulaid        307,000 51
Harri Seppa        295,000 49
Matias Arosuo        287,000 48
Feras Abid        285,000 48
Kristian Larsson        266,000 44
Ilya Nikiforov        258,000 43
Urmo Velvelt        251,000 42
Touko Berndtson        238,000 40
Jari Saviaho        238,000 40
Christian Steinbo        233,000 39
Herli Olop        221,000 37
Anna-Mari Hursti        220,000 37
Anatoly Filatov        213,000 36
Kristaps Deksnis        211,000 35
Lukas Rutkauskas        192,000 32
Daniel Jullumstro        191,000 32
Kaspar Laursoo        189,000 32
Henri Schalin        183,000 31
Aleksi Naski        182,000 30
Espen Sandvik        180,000 30
Anders Auset        172,000 29
Jordi Baixas        172,000 29
Igor Pihela Jr.        170,000 28
Tarmo Tammel        170,000 28
Kasparas Klezys        168,000 28
Vygerdas Jonikas        164,000 27
Hein Haraldsen        155,000 26
Tero Kilkanen        144,000 24
Jargo Alavali        139,000 23
Samuli Hietala        137,000 23
Stefan Bittger        136,000 23
Matias Kesanen         136,000 23
Edgars Beizaks        134,000 22
Jaana Kindsigo        132,000 22
Kaido Mikk        126,000 21
Luis Cruz        114,000 19
Ranno Sootla        112,000 19
Patrick Schratz          94,000 16
Andrei Mjagkov          89,000 15
Joonas Helin          84,000 14
Roberts Rumba          78,000 13
Sebastian Van Wonterghem          61,000 10
Hyunsil Park          58,000 10
Kalle Parkkinen          53,000 9
Ramunas Mika          51,000 9
Maksim Rusinov          39,000 7
Grantas Naujokas          33,000 6
Julian Herold          28,000 5
Martin Piik          12,000 2

No hand-by-hand Posted Friday 28th July, 2023 at 19:13(UTC+0) by Gia Carnestorm

Two players shared the unfortune to lose their all-in at the same time which means we are now down to 71 players. The updates regarding Main Event ends for today and Jason will be back tomorrow. 
Overheard at a table Posted Friday 28th July, 2023 at 18:45(UTC+0) by Gia Carnestorm

Mauri Kristjan Dorbek says he knows he had been drinking to much wine today. Declares he can´t play sober, because he then is to intense. 
LOL!
Last level for today just started Posted Friday 28th July, 2023 at 18:29(UTC+0) by Gia Carnestorm

Still more than 50 minutes left of todays last level. 75 players still in. If we go down to pay-outs before this level ends, then day 2 ends, but if there is still more than 71 players left when this level is over, the game will continue.
18:26 (UTC+0)
Start of Level 16
Blinds: 2,000/5,000     Ante: 5,000
Big hands Posted Friday 28th July, 2023 at 18:23(UTC+0) by Gia Carnestorm

Kasparas Klezys just lost a huge pot with KK. He races to 10k and Juho H. S. Heiska reraces to 25k, Kasparas races to 60k  and Juho goes all-in, gets an insta call and shows AA. No helping cards for Kasparas with 125k left. Juho has around 520k.
Dealers have to announce every all-in. Posted Friday 28th July, 2023 at 18:12(UTC+0) by Gia Carnestorm

Henri Pietari Wagner and Teemu Aukusti Toikkanen goes all-in heads up.  Henri shows AdAh. Then what? Teemu shows AcAs. No flush possible on the flop, split pot. 
When four more players are out, the pay-outs starts. 
Hein Haraldsen wins comfortable Posted Friday 28th July, 2023 at 17:58(UTC+0) by Gia Carnestorm

Jari A. J. Saviaho races to 8k utg. Cut off+1 calls, so do the button and BB. Flop shows 8 6 2, rainbow. Jari bets 4k, Hein races to 10k, button and bb folds, Jari calls. 
Turn is Kh which makes a flush draw. Jari bets 40k and Hein goes all-in for 160k approx. Jari thinks for a while, says "did you hit the set", gets no answer and folds. 
New TV-table Posted Friday 28th July, 2023 at 17:40(UTC+0) by Gia Carnestorm

After the break they changed players at the TV-table. It is the table with highest average ; 221.500. There is one player really short he has 70k with the blinds 2000/4000 BBA 4000. If there is a chip then there is a chair. 
Biggest stack on the table has Yanis Mehdi Sahli from France with 400k. 
17:12 (UTC+0)
Start of Level 15
Blinds: 2,000/4,000     Ante: 4,000
Third break for the day Posted Friday 28th July, 2023 at 17:12(UTC+0) by Gia Carnestorm

With 84 players left the average stack is 201.429.  There are like five players really short stacked with stacks between 30 and 70k. A number of players have around 100k and are as well in the zone of danger since 13 more players must be eliminated before reaching the prize money. 

In my opinion there is no difference in male and female players opportunities of winning.  So few women play poker on a high level, moneywise. Still three ladies in, but I compare with Sweden were it almost always are at least 15% female players, and often two or more at the finale table. Is the reason the height of the buy-in? This I have been asking myself since I started playing poker 30 years ago. Will I ever get an answer?
Went down to check the TV-table Posted Friday 28th July, 2023 at 16:22(UTC+0) by Gia Carnestorm

There is one short stack at the TV-table and that is Kalle Elmeri Parkkinen with 70k. He still has 23 BB.
7 players have between 140k and 180 k. Chip leader at the table is Keito Kaljulaid. 

We are now down to less than 100 players, to be exact 94 for the moment. 
15:55 (UTC+0)
Start of Level 14
Blinds: 1,500/3,000     Ante: 3,000
Concentration and focus are the keys in players room Posted Friday 28th July, 2023 at 15:34(UTC+0) by Gia Carnestorm

The only spot in the room where you can here a laughter is in the media area. That is because 35 more players have to be eliminated before the rest is in the money. 
We have a new chip leader with 530k; Juan Carlos Vecino Duenas. 
Here are the prizes in € Posted Friday 28th July, 2023 at 15:12(UTC+0) by Gia Carnestorm

1st 108260
2nd  72700
3rd  49300
4th  34900
5th  25600
6th  19300
7th 13400
8th 10100
9th   7700
10th 6300
11-12 5300
13-16 4500
17-24 3900
25-32 3300
33-40 3000
41-48 2700
49-56 2400
57-64 2200
65-71 2000
14:44 (UTC+0)
Start of Level 13
Blinds: 1,000/2,500     Ante: 2,500
15 minutes break Posted Friday 28th July, 2023 at 14:44(UTC+0) by Gia Carnestorm

During this two ours session since last break almost 60 players have left the Main Event. Dreams and hopes down the drain, but there is always a tomorrow, always new games to play and a lot of open tables. 
Siim Suviste takes down a 350k pot Posted Friday 28th July, 2023 at 14:31(UTC+0) by Gia Carnestorm

Siim who has BB versus Paul Koppe on the Button. I didn´t see the hand from start, but it is around 100k in the pot with the flop K T 7 rainbow. Slim bets 12.5k and Paul reraise to 25k.  Slim calls. Turn Q makes a possible straight and a flush draw, both checks. River shows a 3, no flush. 
Slim thinks for a while and bets 55k. Paul quite quick says all-in for 110k, leaving Slim thinking for a long time. Paul makes a joke, putting on his hoodie saying - No tells from me, next time I will bring my sunglasses as well. 
Finally Slim calls and Paul says you win, showing A high. 
Slim shows TT and Paul is out. 
Is maybe TT the hand of the day?
8 biggest stacks Posted Friday 28th July, 2023 at 13:54(UTC+0) by Gia Carnestorm

Level 12 1000/2000 BBA 2000
160/564

Tapio Ilmari Aaltonen                  450k
Jargo Alaväli                                     350k
Kristap Deksnis                              325k
Juan Carlos Vecino Duennas  300k
Artjoms Hromovs                          270k
Karolis Kutkauskas                       250k
Vadims Milovs                                 250k
Anna Mari Hursti                           250k
13:52 (UTC+0)
Start of Level 12
Blinds: 1,000/2,000     Ante: 2,000
Alive and kicking! Posted Friday 28th July, 2023 at 13:52(UTC+0) by Gia Carnestorm

This is my first Live Report for more than ten years. Please don´t expect miracles, but hopefully you at least find the information expected.
 The first break for today is just over and it is the normal razzle and dazzle of chips in the room. The sound that make us love poker so much. Or maybe it is annoying for you?
184/564 players still in the game. Approx. 55 have starting stack (30000) or less.
Chip leader with 264.500 is Vlad Dolgevics and all together have ten players more than 200k. 
Hudge Chip Leader Posted Friday 28th July, 2023 at 13:27(UTC+0) by Gia Carnestorm

Tapio Ilmari Aaltonen is Chip Leader with approx. 450k. He raised pre flop UTG+1 and BB reraises. Flop comes A T 7 rainbow. BB bets and Tapio calls after thinking for a while. Turn shows J and gives an flush draw. BB is all-in and Tapio calls quick as a King Cobra. BB shows AK
and Tapio has TT. Over and out for Kevin Victor Karenius. 
Late Registration Closed; €530,160 Prize Pool Posted Friday 28th July, 2023 at 12:46(UTC+0) by Jason Glatzer

Level 11: 1,000/1,500 (1,500)
Entries: 196/564

The action has resumed from the break which means late registration has closed. The record-breaking Kings of Tallinn Summer Showdown €1,100 Main Event attracted 564 entries for a €530,160 prize pool. Full payouts will be announced in the near future.

Best of luck to the 196 remaining players in their hunt for Kings of Tallinn Summer Showdown glory.

Gia Carnestrom will be handling the reporting for the day while your usual reporter Jason Glatzer will commentate both the second half of Day 2 of the Main Event before hopping into the High Roller.
12:39 (UTC+0)
Start of Level 11
Blinds: 1,000/1,500     Ante: 1,500
Break Time! Posted Friday 28th July, 2023 at 12:06(UTC+0) by Jason Glatzer

Players are playing their final few hands before heading on a 15-minute break. We will know the total number of entrants and the prize pool after the action resumes. The prize pool has already soared past €500,000! Amazing, especially considering there was no guarantee.

Gia Carnestrom will be handling the blog for Day 2 with Jason Glatzer moving over to the commentating booth to announce the second half of the Main Event and the €5,000 High Roller shortly after before coming back to report Day 3 and Day 4 of the Main Event.
Main Event Continues to Grow Posted Friday 28th July, 2023 at 11:32(UTC+0) by Jason Glatzer

Level 10: 700/1,400 (1,400)
Entries: 199/528

More players and re-entries continue to file in and the prize pool is now inches away from €500,000. This was the guarantee during the winter-edition of the Kings of Tallinn and it appears this figure will be smashed even without a guarantee.
11:14 (UTC+0)
Start of Level 10
Blinds: 700/1,400     Ante: 1,400
Cards in the Air Posted Friday 28th July, 2023 at 10:09(UTC+0) by Jason Glatzer

Level 9: 600/1,200 (1,200)
Entries: 221/490

Cards are in the air to start Day 2 of the Main Event. The field will continue to grow and grow but already 25 new players got into the mix before the start of the day.
Welcome to Day 2 of the €1,100 Main Event Posted Friday 28th July, 2023 at 09:58(UTC+0) by Jason Glatzer

Welcome to Day 2 of the 2023 Kings of Tallinn Summer Showdown €1,100 Main Event at Olympic Park Casino and the Hilton Tallinn Park.

The three opening flights attracted 465 entries with 196 players finding a bag. They will be joined by others with late registration open for the first two blind levels of the second day. After late registration, we will know the prize pool which currently stands at more than €437,000 and shortly after that the full payouts of the Main Event.

Day 1b chip leader Vlads Dolgilevics (pictured below) leads the way to start the day after advancing with 264,500. He is closely followed by Day 1c chip leader Phil Gross (261,500), Guillermo Cifuentes (253,000), Day 1a chip leader Feras Abid (221,000), and Kalle Parkkinen (218,100)

The plan for the day is to play eight more blind levels of one hour each. Your usual reporter Jason Glatzer will put down the pen and pick up the microphone as today is also the day of the inaugural Kings of Tallinn Summer Showdown €5,000 High Roller. However, the amazing Gia Carnestrom will take over with reporting starting after the first break when late registration is closed. Glatzer will be back on the floor for Day 3 and Day 4 of the Main Event until a winner is crowned.

Cards are scheduled to be in the air at noon with blinds at 600/1,200 along with a 1,200 big blind ante. Best of luck to all of the Main Event players! 
Day 2 Seat Draw Posted Friday 28th July, 2023 at 09:53(UTC+0) by Jason Glatzer
Table Seat Player  Chips  Big Blinds
1 1 Ignacio Gonzales Garrido     66,500 55
1 2 Timo Tapio Koistinen     25,000 21
1 3 Casimir Lucas M. Seire     73,900 62
1 4 Jorgen Jakobsen     29,700 25
1 5 Sami M. O. Säämänen     65,300 54
1 6 Tapio Ilmari Aaltonen   212,600 177
1 8 Aleksejs Gusevs     31,500 26
1 9 Tomas Pinkevicius     22,900 19
2 1 Vlads Dolgilevics   264,500 220
2 2 Timo Petteri Laiho     24,200 20
2 3 Anders Auset   131,400 110
2 4 Henri Mikael Schalin   103,600 86
2 5 Ingus Arajs     83,900 70
2 7 Ville Heikki Juhana Konttinen   111,400 93
2 8 Andrei Mjagkov     53,400 45
2 9 Jani Alexanteri Tuovinen     87,500 73
3 1 Feras Michael Badir Abid   221,000 184
3 2 Ramunas Mika     42,600 36
3 3 Akseli Timonpoika Paalanen     67,000 56
3 4 Kent Ove Roed     80,100 67
3 5 Kaspars Butans     37,500 31
3 7 Johannes Hermann Többe   120,100 100
3 8 Mikael Johannes Haapaniemi     19,200 16
3 9 Joonas E. P. Helin     38,000 32
4 1 Anna-Mari Hursti   151,700 126
4 2 Jari-Pekka Juhola     64,400 54
4 3 Olli Juhani Muukkonen     84,500 70
4 4 Henri Pietari Wagner     93,500 78
4 5 Sebastian Ricken Van Wonterghem   168,800 141
4 6 Roope O. O. Tarmi     40,000 33
4 7 Julius Jesperi Tiihonen     27,500 23
4 8 Claudio Cecchi     76,300 64
5 1 Julius Kasperi Kettunen     38,100 32
5 2 Ivar Rühka     94,800 79
5 3 Alberto Martinez Gonzalez     24,000 20
5 4 Phil Gross   261,500 218
5 5 Thomas Haverstad     14,500 12
5 6 Michailas Miserkejevas   157,100 131
5 8 Jaana Kindsigo     75,900 63
5 9 Vaclav Hlasek     45,100 38
6 1 Jari Tapio Kärkkäinen     89,000 74
6 2 Sergei Oganesjan     22,300 19
6 3 Karolis Kutkauskas   191,100 159
6 5 Nick Martijn Penning   157,400 131
6 6 Victor Iglesias Descalzo   144,900 121
6 7 Patrick Johann Schratz     30,000 25
6 8 Anders Christiansen     58,900 49
6 9 Tarieli Ustiashvili     79,500 66
7 1 Niko Petro     80,100 67
7 2 Jordi Conejos Baixas     37,900 32
7 3 Peter Bumba     49,300 41
7 4 Pasi Tapani Sormunen     77,400 65
7 5 Kalle Tapani Lindholm     21,000 18
7 6 Harri Antero Juvonen     44,000 37
7 7 Pasi Pertti Aatos Laihinen     21,700 18
7 9 Sten Talviste     87,900 73
8 1 Yanis Mehdi Sahli   118,300 99
8 2 Vladislav Senkevic     64,200 54
8 3 Elias Oskari Vääräniemi     45,700 38
8 5 Daniel Jullumstro   105,700 88
8 6 Roope N.A Holma     96,300 80
8 7 Tarmo Tammel     20,200 17
8 8 Elias L. B. Suhonen     20,000 17
8 9 Christian Kay Steinbo     81,000 68
9 1 Tomas Ramanauskas     62,700 52
9 2 Fatih Gulgonul     55,200 46
9 3 Tomi Tapani Arponen   117,100 98
9 4 Kaido Mikk     36,800 31
9 6 Jari M.J. Mähönen     84,000 70
9 7 Guillermo Gordo Cifuentes   253,000 211
9 8 Touko Teivonpoika Berndtson     40,100 33
9 9 Markus L. Isosalo     50,900 42
10 1 James Noonan     24,500 20
10 2 Priit Vanem     30,000 25
10 3 Roni Robert Berg     49,500 41
10 4 Maksim Rusinov     90,100 75
10 5 Aleksandr Kuperman     51,700 43
10 6 Petteri Miettinen     42,500 35
10 7 Vu Hoang Vuong     38,400 32
10 8 Kevin Viktor Karenius     48,100 40
11 1 Maksim Petrov     32,500 27
11 2 Artjoms Hromovs     16,400 14
11 3 Georgi Abuladze     92,700 77
11 4 Janne Johannes Järvinen     66,500 55
11 5 Juan Carlos Vecino Duenas   163,800 137
11 6 Jussi P. K. Mattila   110,500 92
11 7 Steponas Venckus     36,900 31
11 9 Kai E. J. Lehto   101,300 84
12 1 Enea Subashi     82,400 69
12 3 Jargo Alaväli   213,000 178
12 4 Mario Antonio Colavita De La Grana     37,800 32
12 5 Kristaps Deksnis   130,400 109
12 6 Kasparas Klezys     88,100 73
12 8 Stefan Bittger     38,700 32
12 9 Jan Arthur Svendsen     62,000 52
13 2 Andres Aro     43,500 36
13 3 Viacheslav Sultanov     23,700 20
13 4 Andrey Koks     21,200 18
13 5 Anatoly Filatov     51,000 43
13 6 Eeti Tapani Löyttyniemi       8,300 7
13 8 Julian Herold     34,300 29
13 9 Espen Smorholm Sandvik     92,000 77
14 2 Konstantin Ärber     40,000 33
14 3 Erik Skjerven Borkvik     61,200 51
14 5 Jose M. H. Koistinen     18,200 15
14 6 Jan-Mikael Juhani Kesänen   106,700 89
14 7 Rafael Granados Gancedo     44,400 37
14 8 Hendrik Paul L. Diegenant     73,000 61
14 9 Ermo Kosk   105,200 88
15 1 Kaidar Viikman     46,700 39
15 2 Magnus Pukk   171,400 143
15 4 Markku Koplimaa   160,500 134
15 5 Urmo Velvelt     75,300 63
15 6 Vegard Aafedt Bukve     14,700 12
15 7 Tõnis Viik     34,600 29
15 8 Kasparas Drazdauskas     36,000 30
15 9 Kaius Kiidli     18,800 16
16 2 Ivar Vendelin     58,100 48
16 3 Aleksandr Jelpidiforov     32,200 27
16 5 Hein Haraldsen     53,800 45
16 6 Tuomas Mikael Jalonen     32,400 27
16 7 Sebastian Wahl     78,000 65
16 8 Luigi Tasca     20,800 17
16 9 Liutauras Armanavicius     57,400 48
17 1 Niki Juhani Nurmisto     55,900 47
17 2 Thor William Holm Morstol     45,300 38
17 4 Sergei Aleksejev     11,300 9
17 5 Luis Rodriguez Cruz     59,200 49
17 6 Kristaps Renga   134,400 112
17 7 Kalle Elmeri Parkkinen   218,100 182
17 9 Janne M. T. Nevalainen     67,400 56
18 1 Adria Comas I Roura   103,300 86
18 2 Henrik Veldhoen     28,900 24
18 3 Kaido Koorits     64,400 54
18 4 Oskar Ojaveer     29,300 24
18 6 Max August Avela     47,100 39
18 7 Vygerdas Jonikas     71,800 60
18 9 Aleksi Mikael Naski     67,400 56
19 1 Georgina James     85,900 72
19 2 Edgars Beizaks     45,500 38
19 4 Ville-Matti Keränen     74,300 62
19 5 Teemu Kalevi Leppälahti     67,300 56
19 7 Amid Zulkowitz     47,500 40
19 8 Raffael Wadl     37,900 32
19 9 Massimo Casabona     47,000 39
20 1 Aki Taisto Olavi Pyysing     49,800 42
20 2 Herli Olop     49,300 41
20 4 Matias Juhani Kesänen      41,100 34
20 5 Eetu Mikael Porkka     32,000 27
20 6 Mart Tammoja     28,400 24
20 8 Mauri Kristjan Dorbek   207,400 173
20 9 Henning Gunnar Andre      79,000 66
21 1 Mark Metsla   105,500 88
21 2 Paul Koppe     41,000 34
21 4 Siim Suviste     74,000 62
21 5 Jari Juhani Porkka     68,500 57
21 6 Dmitrijs Kornevs     58,900 49
21 7 Teemu Aukusti Toikkanen     42,500 35
21 8 Silver Simulask     25,200 21
21 9 Karlo Kivi     56,800 47
22 1 Martin Piik     65,300 54
22 3 Stephane Pascal Cordeille     75,600 63
22 4 Kristaps Sipols     30,900 26
22 5 Igor Pihela     79,200 66
22 6 Jorn Martinsen     27,400 23
22 7 Ville J. S. Pohjalainen     81,900 68
22 8 Harri Robert Seppä     80,900 67
22 9 Grantas Naujokas     70,400 59
25 1 Roberto Raffaele Caprio     69,800 58
25 2 Lars Emil Nydegger     27,500 23
25 4 Benjamin Arthur Victor Gros     67,500 56
25 5 Nils Jakob Elias Linden   134,900 112
25 6 Patrick Pfeiffer     21,000 18
25 8 Vadims Milovs     50,200 42
25 9 Sami Aleksi Pulliainen     82,000 68
26 1 Kasper J. O. Mellanen     28,800 24
26 3 Totti Matias Arosuo     60,800 51
26 4 Kristian Peder Larsson     62,100 52
26 6 Kaspar Laursoo   208,700 174
26 7 Juho H. S. Heiska     55,700 46
26 8 Christian Arstad     42,200 35
26 9 Jarmo Juhani Salonen     45,600 38
27 1 Tero Tapio Laurila     91,500 76
27 2 Ilya Nikiforov     96,900 81
27 3 Kaspars Kalnozols   127,900 107
27 5 Hengtao Zhu      49,600 41
27 6 Inigo Serrano Robles     49,300 41
27 8 Stanislav Smeljov     28,900 24
27 9 Tero Petteri Kilkanen     41,000 34
28 1 Hendrik Uibo     33,200 28
28 4 Jyrki Olavi Lampinen     59,200 49
28 5 Tarjei Forus     58,200 49
28 6 Tomi Petri Bondarew     22,900 19
28 7 Igor Pihela Jun.   149,100 124
28 8 Samuli Tero Hietala     45,700 38
28 9 Keito Kaljulaid   125,400 105
09:52 (UTC+0)
Day 2 of Kings of Tallinn Summer Showdown 2023 Started
Level: 9     Blinds: 600/1,200     Ante: 1,200

UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.